SELECT * FROM london_stages WHERE eventid IN (1996, 27268, 27310, 27313, 27315, 27319, 27328, 27335, 27412, 27524, 27609, 28245, 28247, 28249, 28251, 28255, 28258, 28260, 28265, 28271, 28283, 28329, 28331, 28334, 28338, 28352, 28683, 29488, 29508, 29587, 29590, 29637, 32549, 32551, 32856, 32866, 32898, 32924, 32947, 32951, 32960, 32978, 32989, 32994, 33003, 33012, 33024, 33036, 33039, 33092, 33110, 33116, 33124, 33143, 33150, 33163, 33174, 33179, 33218, 33219, 33224, 33225, 33226, 33230, 33231, 33232, 33235, 33236, 33237, 33238, 33239, 33240, 33241, 33242, 33243, 33244, 33245, 33247, 33248, 33249, 33250, 33251, 33252, 33253, 33254, 33255, 33256, 33257, 33291, 33293, 33302, 33315, 33327, 33336, 33341, 33350, 33353, 33355, 33364, 33374, 33383, 33386, 33388, 33392, 33397, 33414, 33435, 33437, 33483, 33512, 33526, 33538, 33595, 33622, 33633, 33640, 33642, 33659, 33673, 33676, 33681, 33698, 33788, 33791, 33792, 33804, 33810, 33829, 33833, 33843, 33847, 33849, 33853, 33855, 33857, 33860, 33862, 33864, 33866, 33873, 33875, 33884, 33887, 33893, 33898, 33912, 33919, 33924, 33935, 33950, 33969, 33974, 33976, 33978, 33980, 33982, 33984, 33986, 33989, 33991, 33994, 33998, 34000, 34003, 34005, 34010, 34017, 34040, 34043, 34050, 34055, 34058, 34067, 34097, 34102, 34107, 34112, 34117, 34122, 34132, 34141, 34144, 34151, 34155, 34158, 34166, 34168, 34173, 34175, 34178, 34182, 34194, 34197, 34199, 34202, 34204, 34207, 34209, 34212, 34214, 34222, 34224, 34232, 34246, 34249, 34252, 34258, 34261, 34328, 34339, 34346, 34348, 34353, 34369, 34374, 34376, 34379, 34381, 34383, 34391, 34393, 34395, 34397, 34400, 34404, 34406, 34410, 34412, 34414, 34418, 34421, 34423, 34426, 34440, 34461, 34465, 34479, 34484, 34496, 34498, 34505, 34507, 34510, 34513, 34516, 34518, 34520, 34527, 34529, 34531, 34533, 34538, 34543, 34547, 34555, 34561, 34571, 34573, 34575, 34578, 34585, 34587, 34589, 34592, 34600, 34611, 34641, 34681, 34688, 34696, 34706, 34714, 34722, 34734, 34736, 34753, 34770, 34772, 34775, 34779, 34781, 34784, 34795, 34812, 34887, 34893, 34897, 34911, 34913, 34919, 34921, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34963, 34966, 34968, 34970, 34972, 34975, 34977, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35008, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35036, 35038, 35040, 35042, 35045, 35048, 35051, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35085, 35088, 35092, 35094, 35097, 35104, 35106, 35108, 35111, 35118, 35120, 35122, 35125, 35127, 35129, 35132, 35135, 35143, 35149, 35160, 35164, 35169, 35172, 35174, 35177, 35179, 35182, 35184, 35187, 35202, 35207, 35210, 35213, 35218, 35223, 35227, 35230, 35235, 35243, 35255, 35264, 35272, 35274, 35277, 35289, 35292, 35296, 35299, 35305, 35316, 35324, 35330, 35337, 35340, 35343, 35345, 35351, 35357, 35360, 35365, 35368, 35372, 35375, 35379, 35381, 35382, 35495, 35506, 35508, 35513, 35518, 35520, 35522, 35524, 35547, 35549, 35560, 35566, 35568, 35573, 35577, 35579, 35581, 35583, 35587, 35589, 35592, 35595, 35603, 35615, 35621, 35629, 35635, 35642, 35656, 35659, 35683, 35691, 35693, 35699, 35714, 35756, 35810, 35818, 35823, 35826, 35844, 35856, 35865, 35868, 35876, 35879, 35889, 35907, 35910, 35918, 35922, 35924, 35932, 35943, 35947, 35967, 35981, 35989, 35997, 36113, 36115, 36118, 36129, 36135, 36145, 36147, 36153, 36166, 36168, 36174, 36184, 36193, 36195, 36199, 36203, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36246, 36248, 36253, 36257, 36266, 36275, 36289, 36291, 36303, 36308, 36333, 36343, 36370, 36372, 36374, 36376, 36379, 36384, 36388, 36391, 36398, 36403, 36406, 36429, 36434, 36440, 36460, 36465, 36490, 36499, 36504, 36506, 36518, 36523, 36529, 36532, 36546, 36552, 36558, 36564, 36568, 36636, 36655, 36657, 36663, 36665, 36667, 36671, 36678, 36680, 36686, 36690, 36694, 36696, 36702, 36704, 36717, 36719, 36724, 36738, 36745, 36752, 36761, 36766, 36768, 36778, 36793, 36795, 36802, 36830, 36832, 36837, 36839, 36841, 36862, 36868, 36878, 36881, 36900, 36902, 36904, 36969, 36988, 36990, 37002, 37005, 37018, 37021, 37033, 37036, 37041, 37046, 37049, 37058, 37071, 37073, 37076, 37080, 37091, 37098, 37107, 37119, 37212, 37223, 37225, 37227, 37231, 37249, 37253, 37255, 37260, 37264, 37266, 37268, 37274, 37276, 37278, 37280, 37282, 37284, 37292, 37294, 37303, 37307, 37310, 37315, 37317, 37324, 37333, 37338, 37340, 37345, 37352, 37357, 37361, 37366, 37368, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37436, 37439, 37443, 37451, 37455, 37460, 37465, 37467, 37470, 37479, 37517, 37528, 37531, 37533, 37540, 37545, 37570, 37584, 37597, 37606, 37611, 37618, 37621, 37630, 37632, 37637, 37646, 37651, 37659, 37662, 37671, 37680, 37774, 37778, 37781, 37783, 37785, 37787, 37790, 37793, 37797, 37803, 37805, 37809, 37813, 37815, 37817, 37819, 37821, 37825, 37827, 37829, 37831, 37833, 37835, 37837, 37839, 37841, 37843, 37852, 37856, 37860, 37864, 37870, 37874, 37880, 37882, 37887, 37889, 37893, 37902, 37905, 37911, 37916, 37925, 37928, 37930, 37935, 37937, 37941, 37943, 37947, 37949, 37951, 37962, 37969, 37982, 37996, 38030, 38032, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38078, 38083, 38088, 38091, 38093, 38097, 38105, 38107, 38112, 38118, 38123, 38143, 38151, 38153, 38158, 38160, 38167, 38172, 38175, 38177, 38180, 38183, 38190, 38192, 38197, 38202, 38210, 38216, 38224, 38227, 38233, 38315, 38323, 38325, 38329, 38330, 38332, 38334, 38341, 38345, 38353, 38371, 38373, 38376, 38378, 38381, 38383, 38385, 38387, 38390, 38394, 38396, 38399, 38404, 38407, 38410, 38420, 38427, 38429, 38436, 38441, 38450, 38455, 38459, 38462, 38467, 38469, 38473, 38477, 38485, 38488, 38494, 38496, 38500, 38502, 38523, 38551, 38563, 38568, 38570, 38573, 38593, 38619, 38644, 38663, 38678, 38682, 38689, 38709, 38711, 38714, 38719, 38724, 38726, 38736, 38741, 38743, 38745, 38748, 38758, 38760, 38766, 38768, 38778, 38794, 38796, 38798, 38864, 38879, 38885, 38888, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38918, 38920, 38924, 38926, 38928, 38934, 38937, 38939, 38944, 38946, 38948, 38953, 38960, 38965, 38970, 38976, 38979, 38982, 38984, 38988, 39003, 39006, 39008, 39015, 39022, 39024, 39026, 39028, 39032, 39036, 39038, 39041, 39043, 39045, 39049, 39051, 39054, 39058, 39065, 39067, 39072, 39074, 39078, 39083, 39088, 39090, 39093, 39095, 39098, 39104, 39107, 39121, 39123, 39142, 39149, 39171, 39177, 39181, 39202, 39210, 39213, 39225, 39234, 39236, 39245, 39253, 39257, 39260, 39262, 39265, 39268, 39270, 39280, 39285, 39291, 39308, 39312, 39324, 39337, 39341, 39347, 39449, 39451, 39453, 39457, 39460, 39465, 39472, 39476, 39480, 39493, 39497, 39499, 39502, 39511, 39527, 39532, 39539, 39546, 39550, 39555, 39558, 39564, 39567, 39572, 39578, 39581, 39583, 39588, 39590, 39592, 39595, 39605, 39607, 39609, 39611, 39613, 39618, 39632, 39651, 39657, 39660, 39663, 39668, 39670, 39673, 39675, 39678, 39680, 39684, 39687, 39690, 39693, 39695, 39704, 39709, 39713, 39716, 39729, 39759, 39769, 39789, 39791, 39843, 39847, 39852, 39854, 39857, 39861, 39871, 39873, 39888, 39902, 40023, 40025, 40027, 40041, 40043, 40050, 40056, 40058, 40062, 40066, 40074, 40082, 40086, 40090, 40094, 40096, 40098, 40106, 40113, 40143, 40148, 40150, 40157, 40159, 40162, 40164, 40169, 40172, 40175, 40178, 40187, 40189, 40196, 40198, 40201, 40204, 40211, 40213, 40216, 40225, 40230, 40235, 40244, 40253, 40256, 40258, 40264, 40266, 40269, 40271, 40278, 40281, 40284, 40304, 40334, 40337, 40339, 40344, 40352, 40357, 40371, 40376, 40381, 40386, 40390, 40412, 40415, 40419, 40427, 40440, 40443, 40445, 40449, 40459, 40460, 40463, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40633, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40682, 40699, 40713, 40718, 40722, 40742, 40745, 40749, 40757, 40760, 40766, 40778, 40800, 40803, 40858, 40869, 40879, 40881, 40883, 40890, 40899, 40904, 40909, 40919, 40921, 40930, 40935, 40940, 40945, 40952, 40955, 40973, 40984, 40991, 40993, 40996, 40998, 41003, 41459, 41719, 47051, 47111, 47121, 47125, 47136, 47141, 47153, 47158, 47170, 47176, 47189, 47195, 47198, 47214, 47244, 47259, 47283, 47289, 47301, 47309, 47326, 47441, 47444, 47474, 47475, 47478, 47482, 47559, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47665, 47678, 47688, 47690, 47709, 47724, 47800, 47805, 47820, 47835, 47867, 47997, 47999, 48002, 48006, 48010, 48012, 48015, 48023, 48026, 48028, 48029, 48032, 48038, 48043, 48049, 48080, 48090, 48093, 48095, 48097, 48103, 48105, 48109, 48129, 48133, 48135, 48148, 48150, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48170, 48172, 48174, 48178, 48180, 48182, 48192, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48280, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48341, 48347, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48380, 48382, 48396, 48404, 48409, 48430, 48437, 48439, 48440, 48444, 48447) 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: Love In A Village

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Farmer

Afterpiece Title: Modern Antiques

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Blue Beard

Dance: In afterpiece: Byrne, Mlle St.Amand

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Blue Beard

Dance: As17920111

Song: Juliet's Funeral Procession, as17910926; Solemn Dirge, as17910926; Vocal Parts, as17920926, but _Lee, Rowson, Mrs _Davenett

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Blue Beard

Dance: As17920111

Song: Vocal Parts, as17911010, but Gray, _Williamson, +Rowson, _Lee

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Little Hunchback

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Blue Beard

Performances

Afterpiece Title: Rosina

Song: Sweet Bird(by Handel)-Mrs Billington; accompanied on the violin-Weichsel