SELECT * FROM london_stages WHERE eventid IN (34801, 38223, 38229, 38235, 38250, 38253, 38254, 38260, 38261, 38267, 38270, 38276, 38278, 38284, 38292, 38293, 38301, 38304, 38819, 38820, 38822, 38824, 38826, 38827, 38832, 38840, 39310, 39334, 39338, 39342, 39348, 39353, 39354, 39357, 39359, 39361, 39362, 39365, 39368, 39370, 39371, 39374, 39377, 39379, 39381, 39383, 39384, 39385, 39386, 39387, 39388, 39389, 39390, 39392, 39393, 39395, 39396, 39398, 39399, 39400, 39403, 39404, 39405, 39406, 39407, 39408, 39409, 39410, 39411, 39412, 39413, 39414, 39415, 39416, 39419, 39420, 39422, 39424, 39426, 39427, 39428, 39429, 39431, 39432, 39433, 39434, 39435, 39436, 39437, 39438, 39439, 39912, 39917, 39927, 39928, 39932, 39934, 39935, 39937, 39943, 39945, 39947, 39950, 39951, 39953, 39954, 39955, 39957, 39960, 39961, 39962, 39963, 39964, 39965, 39966, 39967, 39968, 39969, 39970, 39971, 39972, 39973, 39975, 39976, 39977, 39978, 39979, 39981, 39982, 39983, 39984, 39985, 39986, 39987, 39988, 39989, 39990, 39994, 39995, 39997, 39998, 40000, 40001, 40002, 40003, 40004, 40005, 40006, 40007, 40008, 40009, 40010, 40011, 40012, 40013, 40014, 40051, 40075, 40077, 40079, 40081, 40083, 40085, 40087, 40095, 40097, 40101, 40103, 40105, 40109, 40112, 40114, 40116, 40118, 40130, 40132, 40154, 40158, 40160, 40165, 40170, 40183, 40202, 40217, 40226, 40236, 40243, 40254, 40259, 40263, 40279, 40391, 40393, 40396, 40406, 40408, 40413, 40446, 40450, 40462, 40465, 40467, 40472, 40473, 40474, 40476, 40478, 40479, 40480, 40481, 40483, 40486, 40487, 40488, 40489, 40492, 40494, 40499, 40500, 40502, 40504, 40506, 40507, 40508, 40509, 40510, 40512, 40513, 40516, 40517, 40518, 40519, 40520, 40521, 40522, 40523, 40524, 40525, 40526, 40527, 40528, 40529, 40531, 40532, 40533, 40534, 40535, 40536, 40537, 40538, 40541, 40543, 40545, 40547, 40551, 40553, 40554, 40557, 40558, 40561, 40564, 40580, 40615, 40634, 40646, 40658, 40703, 40755, 40770, 40931, 40938, 40941, 40943, 40951, 40953, 40956, 40958, 40960, 40967, 40970, 40972, 40974, 40978, 40992, 40997, 41005, 41006, 41011, 41012, 41014, 41015, 41017, 41019, 41020, 41022, 41025, 41026, 41028, 41030, 41031, 41034, 41035, 41036, 41039, 41041, 41045, 41050, 41054, 41055, 41056, 41059, 41060, 41061, 41063, 41065, 41066, 41067, 41068, 41070, 41071, 41073, 41074, 41075, 41077, 41080, 41081, 41083, 41085, 41087, 41088, 41092, 41094, 41096, 41099, 41102, 41103, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41115, 41130, 41150, 41152, 41154, 41156, 41158, 41160, 41162, 41166, 41169, 41176, 41184, 41187, 41201, 41213, 41227, 41241, 41271, 41273, 41278, 41281, 41399, 41421, 41425, 41458, 41474, 41503, 41518, 41529, 41552, 41564, 41569, 41573, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41601, 41603, 41607, 41609, 41612, 41617, 41620, 41621, 41624, 41627, 41632, 41635, 41637, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41649, 41652, 41661, 41665, 41667, 41671, 41673, 41675, 41676, 41683, 41759, 41772, 41790, 41793, 41795, 41800, 41802, 41804, 41809, 41812, 41814, 41818, 41823, 41826, 41831, 41838, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41980, 41984, 41987, 41994, 41998, 42001, 42003, 42011, 42021, 42026, 42040, 42045, 42047, 42050, 42058, 42063, 42066, 42073, 42081, 42101, 42106, 42134, 42142, 42157, 42163, 42170, 42173, 42176, 42178, 42179, 42181, 42182, 42184, 42187, 42190, 42191, 42192, 42198, 42199, 42200, 42205, 42207, 42208, 42210, 42212, 42215, 42216, 42218, 42220, 42221, 42223, 42224, 42226, 42228, 42229, 42231, 42232, 42234, 42237, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42251, 42252, 42253, 42255, 42256, 42257, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42302, 42306, 42310, 42312, 42318, 42324, 42328, 42330, 42338, 42354, 42357, 42372, 42415, 42420, 42458, 42461, 42467, 42470, 42477, 42486, 42489, 42491, 42494, 42496, 42549, 42561, 42566, 42633, 42678, 42728, 42731, 42750, 42753, 42754, 42755, 42760, 42762, 42764, 42765, 42766, 42767, 42768, 42769, 42770, 42772, 42773, 42774, 42775, 42777, 42778, 42780, 42782, 42783, 42785, 42787, 42788, 42789, 42790, 42791, 42795, 42797, 42798, 42799, 42800, 42801, 42802, 42803, 42804, 42805, 42806, 42807, 42808, 42810, 42814, 42815, 42816, 42817, 42818, 42819, 42822, 42823, 42825, 42827, 42829, 42830, 42831, 42833, 42834, 42835, 42836, 42837, 42838, 42839, 42840, 42841, 42842, 42843, 42844, 42845, 42846, 42847, 42848, 42849, 42850, 42851, 42852, 42853, 43317, 43319, 43322, 43323, 43326, 43327, 43330, 43333, 43335, 43337, 43339, 43343, 43344, 43347, 43350, 43352, 43355, 43356, 43364, 43366, 43368, 43372, 43374, 43375, 43376, 43377, 43379, 43380, 43383, 43388, 43389, 43390, 43391, 43395, 43396, 43398, 43400, 43402, 43403, 43405, 43406, 43407, 43412, 43415, 43417, 43419, 43420, 43422, 43423, 43425, 43428, 43432, 43433, 43441, 43442, 43460, 43462, 43463, 43472, 43473, 43482, 43494, 43506, 43512, 43514, 43517, 43519, 43523, 43525, 43527, 43531, 43533, 43535, 43539, 43541, 43543, 43547, 43549, 43551, 43553, 43555, 43568, 43577, 43590, 43606, 43618, 43627, 43636, 43641, 43647, 43649, 43651, 43659, 43696, 43836, 43896, 46275, 46277, 46284, 46292, 46301, 46307, 46321, 46329, 46336, 46343, 46347, 46385, 46395, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46478, 46492, 46495, 46511, 46522, 46536, 46550, 46557, 46561, 46566, 46578, 46593, 46595, 46602, 46612, 46634, 46644, 46647, 46649, 46652, 46673, 46688, 46700, 46708, 46711, 46716, 46725, 46729, 46732, 46738, 46751, 46758, 46774) 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 Man Of The World

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Performances

Mainpiece Title: Tamerlane

Cast
Role: Prince of Tanais Actor: Egan

Afterpiece Title: Harlequin Rambler

Song: In mainpiece To thee, O gentle sleep! by Brett

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Song: In Act III of mainpiece a sons by Brett

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Song: As17841112

Performances

Mainpiece Title: Fontainbleau; Or, Our Way In France

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: The Citizen

Dance: End of mainpiece The Belle of the Village, as17840917

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Aerostation

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Barnaby Brittle

Dance: As17841116

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Song: As17841112, but omitted: Mrs Sharpe

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Aerostation

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Retaliation

Dance: As17841001

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Song: As17841108, but added: Miss Francis

Performances

Mainpiece Title: Fontainebleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Tristram Shandy

Dance: AS 22 Oct

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: The Lying Valet

Dance: As17841022

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: The Upholsterer

Dance: End of mainpiece a new Ballet (composed by Harris) The Mountaineers; or, The Woodland Sports by Harris, Miss Matthews and Miss Besford

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Barnaby Brittle

Dance: As17841201

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: The Mock Doctor

Dance: As17841201

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Positive Man

Cast
Role: Maurice Actor: Egan

Song: As17841126

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: Retaliation

Dance: As17841201

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: St

Cast
Role: Lieutenant O'Connor Actor: Egan

Dance: As17841201

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Performances

Mainpiece Title: The Follies Of A Day

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Dance: As17841022

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Rosina

Cast
Role: Irishman Actor: Egan

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Montague Actor: Egan

Afterpiece Title: The Magic Cavern

Song: As17841126

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Drunken Butler Actor: Egan

Afterpiece Title: The Magic Cavern