SELECT * FROM london_stages WHERE eventid IN (38325, 38330, 38334, 38336, 38339, 38343, 38351, 38355, 38357, 38359, 38361, 38364, 38367, 38369, 38371, 38373, 38376, 38378, 38381, 38383, 38385, 38387, 38390, 38392, 38394, 38399, 38401, 38404, 38407, 38420, 38422, 38427, 38434, 38439, 38441, 38445, 38448, 38457, 38462, 38464, 38488, 38500, 38523, 38528, 38545, 38547, 38549, 38551, 38554, 38559, 38561, 38565, 38575, 38578, 38580, 38583, 38585, 38588, 38596, 38598, 38603, 38611, 38613, 38624, 38629, 38634, 38639, 38658, 38668, 38675, 38684, 38692, 38694, 38698, 38700, 38703, 38706, 38716, 38719, 38734, 38745, 38768, 38775, 38796, 41515, 41518, 41532, 41537, 41547, 41562, 43439, 43441, 43446, 43449, 43453, 43457, 43460, 43462, 43465, 43468, 43473, 43476, 43478, 43480, 43484, 43488, 43490, 43492, 43494, 43496, 43498, 43500, 43502, 43508, 43510, 43512, 43514, 43521, 43525, 43531, 43533, 43537, 43547, 43549, 43551, 43557, 43559, 43564, 43570, 43575, 43590, 43610, 43613, 43618, 43627, 43631, 43636, 43641, 43647, 43649, 43651, 43656, 43682, 43689, 43693, 43715, 43718, 43726, 43736, 43740, 43743, 43752, 43765, 43767, 43770, 43772, 43786, 43789, 43801, 43806, 43812, 43818, 43821, 43824, 43826, 43829, 43836, 43838, 43844, 43847, 43849, 43852, 43856, 43858, 43861, 43866, 43868, 43873, 43876, 43878, 43881, 43883, 43888, 43891, 43893, 43896, 43898, 43901, 44027, 44029, 44031, 44033, 44035, 44039, 44056, 44059, 44061, 44068, 44076, 44078, 44080, 44089, 44093, 44097, 44103, 44107, 44109, 44111, 44117, 44123, 44129, 44131, 44133, 44165, 44170, 44178, 44190, 44206, 44208, 44218, 44235, 44244, 44247, 44249, 44251, 44253, 44263, 44265, 44270, 44275, 44277, 44281, 44284, 44286, 44293, 44296, 44303, 44311, 44315, 44319, 44328, 44332, 44337, 44341, 44345, 44369, 44372, 44374, 44379, 44382, 44387, 44389, 44392, 44394, 44404, 44407, 44409, 44414, 44419, 44424, 44427, 44432, 44434, 44437, 44439, 44442, 44444, 44452, 44457, 44459, 44462, 44464, 44467, 44589, 44591, 44593, 44595, 44597, 44599, 44601, 44605, 44616, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44634, 44636, 44641, 44643, 44647, 44648, 44650, 44652, 44656, 44658, 44660, 44662, 44668, 44670, 44672, 44678, 44680, 44684, 44686, 44688, 44698, 44710, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44783, 44787, 44791, 44794, 44796, 44805, 44808, 44810, 44813, 44815, 44817, 44819, 44822, 44824, 44828, 44831, 44834, 44836, 44840, 44844, 44847, 44853, 44857, 44860, 44863, 44867, 44871, 44874, 44876, 44880, 44884, 44887, 44897, 44903, 44907, 44909, 44911, 44913, 44915, 44917, 44920, 44925, 44927, 44929, 44934, 44936, 44939, 44944, 44949, 44952, 44955, 44957, 44961, 44964, 44966, 44969, 44971, 44973, 44975, 44978, 44989, 44992, 44995, 45007, 45011, 45016, 45022, 45027, 45032, 45035, 45039, 45135, 45137, 45139, 45141, 45147, 45152, 45156, 45159, 45164, 45166, 45167, 45169, 45174, 45176, 45178, 45180, 45182, 45184, 45188, 45192, 45194, 45196, 45198, 45204, 45206, 45208, 45216, 45218, 45222, 45228, 45232, 45238, 45240, 45244, 45248, 45252, 45255, 45257, 45262, 45264, 45274, 45278, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45302, 45305, 45307, 45310, 45314, 45316, 45319, 45324, 45326, 45328, 45330, 45333, 45335, 45342, 45344, 45347, 45352, 45356, 45359, 45361, 45365, 45372, 45378, 45384, 45394, 45397, 45399, 45407, 45412, 45420, 45423, 45436, 45438, 45440, 45446, 45449, 45451, 45459, 45461, 45469, 45475, 45480, 45482, 45485, 45492, 45500, 45502, 45504, 45511, 45517, 45519, 45521, 45524, 45526, 45531, 45534, 45539, 45542, 45544, 45547, 45549, 45554, 45559, 45562, 45564, 45567, 45569, 45572, 45577, 45579, 45584, 45587, 45589, 45591, 45700, 45702, 45706, 45711, 45714, 45717, 45722, 45724, 45727, 45731, 45733, 45752, 45754, 45758, 45763, 45765, 45767, 45769, 45777, 45781, 45787, 45791, 45793, 45799, 45821, 45833, 45835, 45838, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45885, 45888, 45890, 45892, 45894, 45899, 45902, 45904, 45906, 45911, 45928, 45932, 45937, 45951, 45962, 45967, 45971, 45975, 45984, 45988, 45993, 46015, 46024, 46028, 46031, 46033, 46036, 46038, 46040, 46042, 46047, 46050, 46052, 46055, 46058, 46060, 46063, 46065, 46068, 46070, 46073, 46075, 46080, 46083, 46085, 46088, 46090, 46093, 46095, 46098, 46100, 46103, 46106, 46112, 46121, 46124, 46127, 46130, 46133, 46137, 46140, 46143, 46146, 46148, 46151, 46157, 46166, 46169, 46171, 46174, 46176, 46178, 46186, 46189, 46198, 46262, 46266, 46271, 46273, 46275, 46277, 46279, 46281, 46284, 46286, 46287, 46289, 46294, 46295, 46297, 46299, 46305, 46307, 46309, 46313, 46315, 46317, 46327, 46329, 46333, 46341, 46345, 46347, 46351, 46353, 46355, 46359, 46365, 46369, 46373, 46375, 46383, 46385, 46395, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46476, 46486, 46488, 46492, 46495, 46500, 46502, 46511, 46515, 46524, 46529, 46533, 46536, 46543, 46552, 46564, 46575, 46590, 46593, 46595, 46600, 46607, 46609, 46612, 46617, 46622, 46624, 46627, 46629, 46634, 46637, 46639, 46642, 46649, 46652, 46657, 46659, 46661, 46663, 46666, 46671, 46676, 46678, 46681, 46686, 46688, 46691, 46695, 46697, 46700, 46702, 46705, 46708, 46711, 46716, 46721, 46723, 46725, 46726, 46728, 46729, 46732, 46734, 46736, 46739, 46741, 46742, 46744, 46745, 46748, 46749, 46750, 46751, 46756, 46757, 46758, 46764, 46765, 46770, 46772, 46773, 46774, 46775, 46777, 46779, 46780, 46783, 46784, 46786, 46787, 46788, 46789, 46792, 46793, 46794, 46795, 46797, 46798, 46799, 46802, 46807, 46809, 46810, 46813, 46815, 46817, 46818, 46819, 46821, 46822, 46824, 46829, 46833, 46838, 46841, 46844, 46846, 46847, 46849, 46852, 46854, 46855, 46861, 46863, 46865, 46867, 46869, 46871, 46877, 46879, 46887, 46893, 46895, 46899, 46901, 46905, 46907, 46909, 46911, 46913, 46917, 46919, 46923, 46925, 46927, 46929, 46933, 46937, 46941, 46945, 46949, 46953, 46955, 46957, 46963, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46987, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47011, 47015, 47017, 47019, 47021, 47023, 47025, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47045, 47047, 47049, 47053, 47055, 47063, 47066, 47079, 47081, 47091, 47093, 47098, 47101, 47173, 47183, 47198, 47202, 47209, 47212, 47214, 47218, 47220, 47224, 47226, 47229, 47231, 47235, 47242, 47244, 47247, 47253, 47261, 47266, 47277, 47279, 47283, 47285, 47289, 47291, 47295, 47297, 47306, 47309, 47312, 47314, 47315, 47320, 47326, 47341, 47349, 47352, 47356, 47361, 47362, 47363, 47366, 47368, 47373, 47374, 47384, 47389, 47390, 47392, 47393, 47394, 47395, 47396, 47397, 47398, 47399, 47403, 47404, 47405, 47406, 47407, 47409, 47410, 47411, 47412, 47413, 47414, 47417, 47418, 47419, 47420, 47421, 47422, 47423, 47424, 47425, 47426, 47427, 47429, 47437, 47439, 47440, 47441, 47442, 47444, 47446, 47449, 47451, 47454, 47456, 47458, 47459, 47462, 47464, 47467, 47470, 47472, 47474, 47475, 47478, 47482, 47484, 47485, 47487, 47489, 47491, 47493, 47495, 47497, 47499, 47501, 47503, 47507, 47511, 47513, 47517, 47519, 47521, 47527, 47531, 47533, 47537, 47541, 47543, 47547, 47549, 47551, 47555, 47557, 47561, 47566, 47568, 47570, 47575, 47595, 47597, 47600, 47607, 47616, 47623, 47628, 47637, 47641, 47645, 47649, 47651, 47655, 47657, 47659, 47672, 47676, 47678, 47683, 47685, 47693, 47722, 47734, 47737, 47752, 47779, 47782, 47784, 47787, 47789, 47794, 47797, 47813, 47825, 47828, 47833, 47843, 47848, 47850, 47855, 47858, 47867, 47869, 47872, 47874, 47877, 47882, 47890, 47892, 47896, 47912, 47914, 47915, 47916, 47917, 47918, 47919, 47920, 47921, 47922, 47923, 47924, 47925, 47929, 47930, 47931, 47933, 47934, 47935, 47936, 47938, 47940, 47942, 47945, 47946, 47947, 47948, 47950, 47951, 47954, 47956, 47957, 47958, 47959, 47960, 47961, 47962, 47963, 47964, 47965, 47966, 47967, 47968, 47969, 47970, 47971, 47972, 47973, 47974, 47975, 47976, 47977, 47978, 47979, 47980, 47981, 47982, 47983, 47984, 47985, 47986, 47987, 47988, 47989, 47991, 47999, 48008, 48010, 48012, 48015, 48017, 48020, 48023, 48028, 48032, 48036, 48043, 48047, 48055, 48059, 48061, 48062, 48070, 48072, 48074, 48078, 48084, 48090, 48097, 48099, 48101, 48103, 48105, 48109, 48111, 48115, 48117, 48119, 48121, 48123, 48125, 48127, 48129, 48131, 48133, 48135, 48137, 48139, 48142, 48144, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48174, 48178, 48180, 48182, 48186, 48190, 48194, 48197, 48223, 48225, 48229, 48233, 48236, 48238, 48243, 48247, 48250, 48252, 48257, 48261, 48266, 48271, 48275, 48280, 48285, 48292, 48303, 48308, 48311, 48313, 48315, 48317, 48322, 48325, 48327, 48329, 48331, 48334, 48336, 48339, 48341, 48344, 48347, 48349, 48352, 48356, 48358, 48361, 48363, 48370, 48372, 48375, 48377, 48380, 48382, 48384, 48386, 48389, 48391, 48394, 48398, 48402, 48404, 48407, 48409, 48411, 48413, 48418, 48421, 48423, 48427, 48430, 48432, 48435, 48437, 48440, 48443, 48447, 48535, 48536, 48537, 48539, 48541, 48543, 48545, 48547, 48553, 48555, 48557, 48559, 48561, 48567, 48569, 48571, 48573, 48575, 48579, 48581, 48590, 48594, 48596, 48598, 48600, 48603, 48605, 48609, 48615, 48625, 48628, 48630, 48634, 48635, 48637, 48640, 48642, 48643, 48645, 48647, 48650, 48651, 48654, 48656, 48659, 48662, 48664, 48665, 48667, 48669, 48672, 48674, 48675, 48677, 48679, 48684, 48685, 48687, 48689, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48712, 48714, 48715, 48717, 48719, 48722, 48727, 48729, 48732, 48734, 48735, 48737, 48742, 48744, 48745, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48761, 48764, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48832, 48835, 48837, 48851, 48856, 48858, 48860, 48863, 48865, 48868, 48870, 48872, 48877, 48879, 48892, 48896, 48899, 48902, 48904, 48909, 48916, 48923, 48930, 48933, 48938, 48945, 48947, 48952, 48959, 48961, 48967, 48971, 48980, 48982, 48986, 48988, 48990, 48993, 48995, 48998, 49000, 49002, 49004, 49009, 49012, 49014, 49016, 49021, 49023, 49028, 49031, 49033, 49036, 49038, 49041, 49043, 49053, 49056, 49058, 49066, 49069, 49072, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49095, 49100, 51324) 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: Hamlet

Afterpiece Title: HARLEQUIN AND FAUSTUS

Song: As17940109

Performances

Mainpiece Title: Douglas

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Venice Preserved

Cast
Role: Spinosa Actor: Cubitt

Afterpiece Title: ROSINA

Performances

Mainpiece Title: Macbeth

Cast
Role: Hecate Actor: Cubitt
Role: Dr Pinch Actor: Cubitt

Afterpiece Title: HARLEQUIN AND FAUSTUS

Song: As17931227, but Mrs Follett in place of Mrs Clendining

Performances

Mainpiece Title: Venice Preserved

Cast
Role: Spinosa Actor: Cubitt

Afterpiece Title: THE MIDNIGHT WANDERERS

Cast
Role: Gregory Actor: Cubitt
Role: Farmer Actor: Cubitt

Performances

Mainpiece Title: Love's Frailties

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Road To Ruin

Cast
Role: Sulky Actor: Cubitt

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The World In A Village

Cast
Role: Clown Actor: Cubitt
Role: Spinosa Actor: Cubitt
Role: Vansluisen Actor: Cubitt

Afterpiece Title: THE SPRIGS OF LAUREL

Dance: As17931022

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Don Juan Actor: Cubitt

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Performances

Mainpiece Title: A Day In Turkey

Cast
Role: Azim Actor: Cubitt

Afterpiece Title: OSCAR AND MALVINA

Music: As17940206

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Wild Oats

Cast
Role: Gammon Actor: Cubitt

Afterpiece Title: THE FARMER

Dance: As17931022

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Hamlet

Afterpiece Title: THE POOR SOLDIER

Cast
Role: Bagatelle Actor: Cubitt

Song: As17940109

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Cast
Role: Tipkin Actor: Cubitt

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: THE FOLLIES OF A DAY

Cast
Role: Noodle Actor: Cubitt

Dance: Mainpiece: To conclude with The Savoyard by Byrn, Mlle St. Amand and Mme Rossi

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: MODERN ANTIQUES

Cast
Role: Osman Actor: Cubitt

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HE WOU'D BE A SOLDIER

Cast
Role: Wilkins Actor: Cubitt

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HE WOU'D BE A SOLDIER

Cast
Role: Wilkins Actor: Cubitt

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: A Day In Turkey

Cast
Role: Azim Actor: Cubitt

Afterpiece Title: THE SPRIGS OF LAUREL

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HE WOU'D BE A SOLDIER

Cast
Role: Wilkins Actor: Cubitt

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225