SELECT * FROM london_stages WHERE eventid IN (394, 403, 699, 1007, 1284, 1338, 1882, 1919, 1998, 2004, 2022, 2550, 2672, 3569, 3613, 3757, 3892, 3942, 3958, 3990, 3991, 4006, 4044, 4056, 4061, 4123, 4138, 4139, 4182, 4226, 4227, 4257, 4262, 4275, 4318, 4356, 4546, 4551, 4571, 4609, 4623, 4633, 4639, 4742, 4893, 4977, 5137, 5165, 5267, 5409, 5624, 5742, 5881, 6332, 6548, 6577, 6638, 6674, 6764, 6951, 6957, 7016, 7043, 7048, 7225, 7289, 7308, 7488, 7907, 8017, 8170, 8332, 8333, 8350, 8475, 8800, 8867, 9287, 9291, 9404, 9496, 9532, 9570, 9616, 9716, 9806, 9835, 9927, 10150, 10168, 10318, 10468, 10474, 10626, 10673, 10751, 10833, 10916, 10954, 10975, 11004, 11015, 11209, 11239, 11289, 11315, 11357, 11433, 11463, 11466, 11481, 11501, 11739, 11758, 11815, 11854, 11938, 12186, 12202, 12221, 12238, 12475, 12497, 12580, 12597, 12601, 12606, 12675, 12715, 12735, 12745, 12850, 12885, 12970, 13151, 13301, 13324, 13359, 13455, 13577, 13762, 13914, 14035, 14039, 14045, 14179, 14220, 14374, 14420, 14459, 14498, 14530, 14921, 14928, 15234, 15399, 15584, 15601, 15604, 15632, 15727, 15730, 15815, 15821, 15822, 15824, 15827, 15878, 15882, 15884, 15885, 15888, 15893, 15896, 15901, 15904, 15908, 15912, 15917, 15922, 15930, 15941, 15962, 15966, 15995, 16031, 16038, 16051, 16070, 16103, 16368, 16464, 16470, 16496, 16497, 16541, 16560, 16608, 16662, 16736, 16797, 16853, 16858, 16932, 16975, 16984, 17014, 17170, 17188, 17225, 17231, 17260, 17418, 17444, 17469, 17511, 17528, 17585, 17605, 17611, 17615, 17741, 17773, 17777, 17783, 17786, 17800, 17862, 17867, 17875, 17892, 17897, 17921, 17966, 18012, 18026, 18038, 18205, 18230, 18308, 18320, 18360, 18488, 18637, 18643, 18674, 18743, 18819, 18868, 18875, 19033, 19117, 19121, 19132, 19178, 19287, 19301, 19331, 19376, 19457, 19499, 19568, 19571, 19617, 19653, 19729, 19766, 19768, 19793, 19837, 20022, 20075, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20399, 20435, 20437, 20438, 20457, 20532, 20548, 20580, 20607, 20610, 20641, 20652, 20659, 20676, 20690, 20720, 20724, 20763, 20764, 20766, 20767, 20769, 20770, 20771, 20772, 20796, 20797, 20825, 20829, 20878, 20893, 20918, 20925, 20941, 20953, 20970, 20991, 21013, 21031, 21056, 21093, 21104, 21108, 21153, 21157, 21162, 21217, 21241, 21262, 21306, 21308, 21310, 21319, 21338, 21347, 21368, 21388, 21411, 21451, 21460, 21509, 21513, 21517, 21544, 21735, 21766, 21786, 21822, 21834, 21866, 21894, 21914, 21934, 21936, 21947, 21991, 22003, 22004, 22009, 22011, 22015, 22018, 22035, 22043, 22059, 22076, 22104, 22154, 22185, 22199, 22204, 22237, 22247, 22252, 22254, 22271, 22314, 22367, 22395, 22424, 22468, 22478, 22571, 22581, 22680, 22783, 22803, 22844, 22945, 22967, 23000, 23013, 23022, 23052, 23077, 23124, 23134, 23175, 23191, 23223, 23225, 23230, 23253, 23280, 23301, 23366, 23466, 23532, 23553, 23561, 23614, 23728, 23746, 23822, 23859, 23926, 23966, 24073, 24126, 24137, 24188, 24265, 24390, 24564, 24621, 24797, 24916, 25003, 25151, 25192, 25218, 25334, 25366, 25394, 25459, 25504, 25520, 25541, 25678, 25703, 25728, 25760, 25896, 26017, 26076, 26117, 26124, 26199, 26280, 26303, 26320, 26347, 26388, 26422, 26466, 26513, 26538, 26555, 26573, 26585, 26587, 26590, 26602, 26615, 26617, 26621, 26623, 26640, 26641, 26643, 26646, 26650, 26655, 26667, 26688, 26698, 26749, 26755, 26757, 26785, 26809, 26813, 26899, 27095, 27096, 27103, 27144, 27175, 27185, 27194, 27221, 27238, 27240, 27249, 27254, 27259, 27264, 27269, 27278, 27283, 27292, 27297, 27300, 27318, 27325, 27333, 27424, 27458, 27559, 27565, 27614, 27621, 27657, 27673, 27697, 27739, 27765, 27798, 27809, 27871, 27877, 27931, 28003, 28042, 28054, 28058, 28075, 28089, 28095, 28096, 28108, 28137, 28143, 28199, 28201, 28202, 28205, 28211, 28213, 28218, 28223, 28226, 28231, 28235, 28240, 28243, 28253, 28274, 28308, 28311, 28312, 28324, 28335, 28348, 28361, 28393, 28396, 28401, 28407, 28417, 28420, 28425, 28429, 28434, 28462, 28477, 28484, 28496, 28522, 28537, 28544, 28557, 28562, 28565, 28631, 28646, 28651, 28661, 28721, 28723, 28724, 28732, 28769, 28770, 28780, 28842, 28849, 28906, 28950, 28968, 28971, 28993, 29007, 29047, 29054, 29061, 29068, 29151, 29164, 29174, 29225, 29238, 29240, 29247, 29249, 29301, 29341, 29354, 29357, 29381, 29407, 29437, 29468, 29516, 29610, 29721, 29819, 29841, 29864, 29913, 29917, 29992, 29998, 30029, 30045, 30061, 30118, 30146, 30223, 30301, 30322, 30473, 30510, 30514, 30518, 30523, 30536, 30554, 30564, 30623, 30651, 30671, 30788, 30814, 30830, 30831, 30845, 30889, 30955, 31031, 31154, 31169, 31230, 31281, 31345, 31361, 31399, 31402, 31412, 31504, 31535, 31669, 31761, 31777, 31844, 31854, 31885, 31915, 31939, 31991, 32031, 32035, 32351, 32445, 32450, 32516, 32727, 32749, 32837, 32925, 32929, 32934, 32938, 32943, 32945, 32995, 33000, 33004, 33009, 33013, 33117, 33199, 33254, 33400, 33404, 33440, 33539, 33674, 33849, 33857, 33884, 33920, 33932, 33963, 34011, 34020, 34155, 34176, 34178, 34210, 34228, 34233, 34264, 34381, 34386, 34402, 34408, 34416, 34428, 34491, 34526, 34530, 34544, 34545, 34604, 34705, 34725, 34756, 34781, 34807, 34921, 34982, 35028, 35116, 35282, 35324, 35520, 35603, 35626, 35645, 35668, 35719, 35856, 35943, 36158, 36179, 36182, 36243, 36246, 36263, 36271, 36421, 36460, 36473, 36480, 36503, 36508, 36556, 36568, 36602, 36637, 36672, 36719, 36775, 36796, 37021, 37028, 37039, 37060, 37094, 37110, 37274, 37296, 37301, 37334, 37387, 37412, 37428, 37448, 37468, 37475, 37505, 37540, 37587, 37788, 37790, 37815, 37876, 37905, 37916, 37921, 37928, 37930, 37931, 37933, 37935, 37937, 37949, 37973, 37977, 37982, 37985, 37989, 37997, 37998, 38003, 38012, 38026, 38037, 38040, 38124, 38178, 38208, 38224, 38236, 38247, 38346, 38486, 38547, 38549, 38551, 38554, 38555, 38645, 38653, 38737, 38751, 38755, 38801, 38885, 38918, 38937, 38940, 38945, 38946, 38947, 38952, 38959, 38963, 38966, 38968, 38976, 39009, 39011, 39012, 39093, 39107, 39123, 39213, 39245, 39257, 39265, 39291, 39372, 39417, 39421, 39425, 39454, 39558, 39560, 39574, 39719, 39736, 39833, 39873, 39901, 39946, 40025, 40068, 40201, 40203, 40233, 40242, 40457, 40568, 40579, 40601, 40646, 40683, 40691, 40695, 40700, 40729, 40733, 40756, 40777, 40778, 40807, 40899, 40922, 40952, 41001, 41054, 41055, 41057, 41060, 41063, 41065, 41066, 41068, 41071, 41083, 41086, 41087, 41101, 41131, 41134, 41144, 41151, 41158, 41191, 41295, 41340, 41370, 41425, 41536, 41703, 41756, 41775, 41880, 41885, 41909, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42057, 42060, 42086, 42092, 42095, 42128, 42166, 42288, 42311, 42344, 42388, 42478, 42706, 42723, 42746, 42791, 42795, 42798, 42824, 42826, 42828, 42832, 42834, 42943, 42967, 43000, 43034, 43103, 43115, 43167, 43199, 43200, 43224, 43242, 43247, 43314, 43316, 43436, 43441, 43477, 43524, 43545, 43632, 43683, 43823, 43843, 43857, 43880, 43928, 44073, 44079, 44244, 44266, 44461, 44471, 44473, 44558, 44559, 44561, 44564, 44565, 44567, 44573, 44579, 44582, 44629, 44631, 44635, 44675, 44723, 44730, 44816, 44914, 44949, 44964, 45012, 45034, 45054, 45074, 45075, 45076, 45078, 45081, 45113, 45173, 45195, 45304, 45333, 45384, 45461, 45468, 45691, 45710, 45715, 45747, 45763, 45765, 45768, 45769, 45777, 45787, 45826, 45833, 45848, 45849, 45906, 45908, 45928, 45932, 45945, 45962, 45979, 46083, 46085, 46088, 46122, 46150, 46168, 46241, 46272, 46331, 46349, 46355, 46373, 46471, 46532, 46546, 46549, 46551, 46557, 46560, 46574, 46589, 46603, 46616, 46618, 46641, 46651, 46659, 46665, 46677, 46680, 46694, 46790, 46843, 46853, 46857, 46865, 46866, 46874, 46876, 46886, 46895, 46898, 46904, 46905, 46910, 46916, 46919, 46921, 46923, 46925, 46927, 46928, 46929, 46931, 46933, 46934, 46937, 46940, 46946, 46947, 46948, 46952, 46953, 46955, 46956, 46960, 46963, 46964, 46995, 47001, 47005, 47011, 47013, 47025, 47037, 47039, 47042, 47045, 47049, 47061, 47066, 47071, 47076, 47078, 47083, 47085, 47088, 47091, 47104, 47107, 47123, 47149, 47167, 47185, 47207, 47211, 47238, 47243, 47252, 47253, 47272, 47277, 47279, 47284, 47295, 47303, 47312, 47320, 47326, 47440, 47446, 47448, 47453, 47457, 47458, 47463, 47521, 47537, 47538, 47541, 47542, 47543, 47545, 47546, 47549, 47550, 47553, 47554, 47555, 47556, 47557, 47561, 47568, 47569, 47574, 47575, 47579, 47583, 47585, 47592, 47680, 47722, 47728, 47758, 47768, 47781, 47783, 47791, 47804, 47829, 47869, 47871, 47893, 47899, 47998, 48001, 48011, 48013, 48017, 48044, 48046, 48165, 48175, 48179, 48210, 48219, 48224, 48237, 48249, 48263, 48369, 48380, 48381, 48403, 48423, 48500, 48591, 48674, 48707, 48731, 48971, 48987, 48989, 49001, 49015, 49018, 49040, 49055, 49076, 49082, 49085, 49091, 49096, 49099, 49102, 49111, 49173, 49186, 49190, 49194, 49196, 49202, 49210, 49212, 49213, 49218, 49223, 49227, 49235, 49236, 49249, 49261, 49271, 49273, 49285, 49295, 49297, 49309, 49311, 49325, 49349, 49367, 49381, 49389, 49395, 49400, 49415, 49421, 49426, 49435, 49525, 49544, 49564, 49572, 49593, 49596, 49598, 49603, 49615, 49619, 49636, 49643, 49644, 49645, 49648, 49709, 49715, 49721, 49731, 49758, 49769, 49773, 49777, 49800, 49814, 49817, 49819, 49823, 49825, 49827, 49829, 49830, 49831, 49833, 49835, 49837, 49839, 49841, 49843, 49845, 49847, 49851, 49855, 49856, 49859, 49863, 49867, 49871, 49875, 49879, 49880, 49883, 49893, 49897, 49906, 49925, 49926, 49935, 49940, 49944, 49948, 49949, 49954, 49959, 49989, 50040, 50054, 50056, 50057, 50070, 50072, 50083, 50091, 50092, 50165, 50183, 50207, 50246, 50248, 50256, 50284, 50323, 50341, 50349, 50357, 50365, 50372, 50411, 50415, 50441, 50443, 50457, 50516, 50530, 50535, 50548, 50567, 50606, 50667, 50723, 50741, 50785, 50801, 50807, 50812, 50813, 50899, 50903, 50920, 50925, 50930, 50937, 50949, 50957, 50964, 50977, 50997, 51023, 51050, 51070, 51139, 51141, 51153, 51202, 51235, 51290, 51313, 51317, 51359, 51387, 51420, 51435, 51448, 51461, 51486, 51488, 51495, 51505, 51506, 51511, 51513, 51514, 51515, 51517, 51519, 51521, 51522, 51525, 51526, 51527, 51529, 51531, 51532, 51535, 51537, 51541, 51542, 51543, 51544, 51545, 51557, 51561, 51565, 51569, 51573, 51577, 51581, 51587, 51591, 51613, 51628, 51639, 51650, 51654, 51657, 51682, 51683, 51685, 51694, 51710, 51721, 51722, 51728, 51733, 51746, 51750, 51762, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51796, 51797, 51798, 51799, 51801, 51806, 51811, 51813, 51817, 51819, 51820, 51825, 51828, 51833, 51836, 51841, 51842, 51843, 51849, 51856, 51864, 51869, 51870, 51871, 51885, 51886, 51890, 51900, 51902, 51907, 51933, 51936, 51963, 51982, 51986, 52000, 52008, 52049, 52071, 52081, 52083, 52086, 52088, 52098, 52102, 52110, 52113, 52145, 52167, 52176, 52194, 52204, 52263, 52270, 52273, 52276, 52279, 52295, 52297, 52299, 52300, 52302, 52304, 52307, 52309, 52311, 52313, 52316, 52318, 52322, 52325, 52328, 52330, 52337, 52361, 52366, 52373, 52393, 52399, 52400, 52407, 52412, 52428, 52431, 52436, 52441, 52462, 52475, 52477, 52489, 52490, 52497, 52498, 52516, 52568, 52577, 52580, 52594, 52608, 52609, 52615) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: The Jew and the Doctor

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Rosina

Performances

Mainpiece Title: Douglas

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Caulfield

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Jew

Cast
Role: Frederick Bertram Actor: C. Kemble

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Robin Hood

Performances

Mainpiece Title: The Wonder

Cast
Role: Frederick Actor: Caulfield

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: The Magic Oak; or, Harlequin Woodcutter

Music: End I afterpiece: A Medley Overture on the Union Pipes and Pedal Harp-Murphy, Weippert

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: The Magic Oak

Music: As17990205

Performances

Mainpiece Title: As You Like It

Cast
Role: Frederick Actor: Maddocks

Afterpiece Title: Feudal Times

Song: V: a song-Mrs Bland

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: As You Like It

Cast
Role: Frederick Actor: Maddocks

Afterpiece Title: Feudal Times

Song: As17990214

Performances

Mainpiece Title: As You Like It

Cast
Role: Frederick Actor: Maddocks

Afterpiece Title: Feudal Times

Song: As17990214

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Song: In afterpiece: Come every jovial fellow-Mrs Chapman, Gray, Mrs Atkins; O ever in my bosom live-Mrs Chapman, Mrs Atkins

Performances

Mainpiece Title: Lover's Vows

Cast
Role: Frederick Actor: Pope

Afterpiece Title: Oscar and Malvina

Song: As17990304but O ever in my bosom live-Mrs Chapman, Mrs Iliff

Performances

Mainpiece Title: Five Thousand A Year

Cast
Role: Frederick Fervid Actor: Pope
Role: Servant to Frederick Actor: Curties

Afterpiece Title: A Divertisement

Cast
Role: Frederick Actor: Johnstone

Afterpiece Title: Catherine and Petruchio

Dance: In 2nd piece: Ballet-Blurton, Mrs Watts

Song: End 1st piece: Black Ey'd Susan-Incledon

Performances

Mainpiece Title: A Divertisement

Cast
Role: Frederick Fervid Actor: Pope
Role: Servant to Frederick Actor: Curties

Afterpiece Title: Five Thousand a Year

Cast
Role: Frederick Actor: Johnstone

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Ramah Droog

Afterpiece Title: The Magic Oak

Cast
Role: Frederick Actor: Johnstone

Performances

Mainpiece Title: A Divertisement

Cast
Role: Frederick Fervid Actor: Pope
Role: Servant to Frederick Actor: Curties

Afterpiece Title: Five Thousand a Year

Cast
Role: Frederick Actor: Johnstone

Afterpiece Title: The Magic Oak

Cast
Role: Frederick Actor: Johnstone

Dance: In 1st piece: As17990316

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: The Magic Oak

Cast
Role: Frederick Actor: Johnstone