SELECT * FROM london_stages WHERE eventid IN (31048, 31050, 31053, 31058, 31060, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31188, 47701, 47711, 47716, 47726, 47731, 47741, 47746, 47756, 47761, 47771, 47776, 47876, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48110, 48112, 48116, 48120, 48122, 48130, 48132, 48138, 48159, 48175, 48177, 48187, 48191, 48196, 48201, 48203, 48213, 48217, 48230, 48235, 48240, 48244, 48263, 48268, 48270, 48272, 48274, 48277, 48279, 48282, 48284, 48286, 48291, 48293, 48298, 48302, 48307, 48310, 48312, 48316, 48319, 48326, 48328, 48335, 48340, 48343, 48355, 48357, 48367, 48369, 48371, 48374, 48383, 48385, 48393, 48397, 48401, 48410, 48412, 48415, 48426, 48429, 48566, 48568, 48570, 48574, 48939, 49003, 49008, 49022, 49030, 49035, 49037, 49045, 49050, 49052, 49060, 49071, 49080, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49116, 49117, 49119, 49120, 49122, 49190, 49198, 49200, 49202, 49204, 49205, 49207, 49210, 49213, 49215, 49218, 49220, 49225, 49227, 49230, 49231, 49233, 49239, 49243, 49249, 49255, 49257, 49261, 49267, 49273, 49275, 49279, 49281, 49285, 49291, 49297, 49299, 49301, 49304, 49311, 49318, 49320, 49323, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49361, 49363, 49365, 49367, 49370, 49375, 49377, 49379, 49381, 49384, 49389, 49395, 49407, 49412, 49415, 49417, 49419, 49424, 49435, 49444, 49489, 49521, 49547, 49559, 49562, 49569, 49572, 49574, 49579, 49582, 49584, 49586, 49591, 49593, 49601, 49603, 49606, 49608, 49619, 49624, 49629, 49634, 49636, 49643, 49760, 49763, 49765, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49784, 49790, 49793, 49795, 49802, 49808, 49810, 49812, 49816, 49822, 49824, 49828, 49830, 49834, 49838, 49840, 49844, 49846, 49850, 49852, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49887, 49890, 49894, 49901, 49904, 49911, 49916, 49925, 49928, 49930, 49934, 49937, 49944, 49946, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50034, 50047, 50051, 50060, 50063, 50066, 50069, 50081, 50086, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50112, 50115, 50117, 50120, 50122, 50130, 50133, 50137, 50152, 50160, 50188, 50190, 50192, 50218, 50223, 50335, 50339, 50344, 50349, 50351, 50354, 50357, 50367, 50369, 50375, 50377, 50379, 50381, 50386, 50390, 50393, 50395, 50397, 50399, 50401, 50403, 50407, 50409, 50417, 50419, 50421, 50427, 50432, 50434, 50443, 50448, 50457, 50460, 50462, 50465, 50471, 50474, 50476, 50479, 50481, 50483, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50516, 50519, 50521, 50523, 50525, 50528, 50530, 50537, 50539, 50542, 50545, 50550, 50555, 50558, 50563, 50570, 50572, 50575, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50604, 50608, 50610, 50613, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50673, 50675, 50687, 50689, 50692, 50694, 50703, 50706, 50713, 50730, 50735, 50743, 50746, 50748, 50751, 50753, 50761, 50763, 50766, 50768, 50771, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799) 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: The Drummer Or The Haunted House

Afterpiece Title: Apollo and Daphne or The Burgomaster Trickd

Performances

Mainpiece Title: The Beggars Opera

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Apollo and Daphne With a New Occasional Scene of Action

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Funeral Or Grief A la mode

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Beggars Opera

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: Redemption 0 Selected From The Works Of handel By dr Arnold

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Cast
Role: Actor: Master Welsh

Music: End I: concerto on the bassoon-Parkinson; End II: concerto on the violin-Master Bridgetower

Performances

Mainpiece Title: Acis And Galatea 0 Redemption 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: A Miscellaneous Act

Music: End I: concerto on the hautboy-[J.] Parke

Performances

Mainpiece Title: The Messiah Redemption 0

Performances

Mainpiece Title: Acis And Galatea 0 Redemption 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17920229

Performances

Mainpiece Title: Judas Maccabaeus Redemption 0

Music: End Part I: concerto on the violoncello-Lindley

Performances

Mainpiece Title: A Grand Selection 0 Composed By g

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Fair Rosale Actor: Master Welsh

Performances

Mainpiece Title: Redemption 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17920229