SELECT * FROM london_stages WHERE eventid IN (46134, 46144, 46155, 46167, 46180, 46185, 46202, 46208, 46214, 46217, 46229, 46232, 46233, 46239, 46241, 46250, 46257, 46790, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46947, 46953, 46955, 46963, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47001, 47003, 47005, 47007, 47009, 47013, 47015, 47017, 47019, 47021, 47023, 47025, 47027, 47029, 47031, 47033, 47035, 47037, 47039, 47041, 47049, 47053, 47061, 47066, 47071, 47076, 47081, 47083, 47088, 47091, 47104, 47167, 47202, 47207, 47209, 47220, 47235, 47253, 47277, 47279, 47291, 47312, 47320, 47326, 47440, 47446, 47464, 47472, 47482, 47495, 47507, 47515, 47519, 47521, 47537, 47539, 47541, 47543, 47545, 47549, 47553, 47555, 47557, 47561, 47568, 47575, 47580, 47582, 47584, 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, 47643, 47649, 47659, 47661, 47663, 47665, 47668, 47680, 47688, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47769, 47774, 47779, 47782, 47787, 47792, 47797, 47800, 47803, 47805, 47808, 47810, 47813, 47815, 47820, 47825, 47828, 47835, 47838, 47843, 47858, 47865, 47869, 47872, 47892, 47994, 48008, 48015, 48019, 48023, 48026, 48032, 48036, 48039, 48041, 48045, 48051, 48053, 48055, 48057, 48061, 48062, 48066, 48070, 48072, 48074, 48076, 48078, 48082, 48084, 48086, 48093, 48095, 48097, 48099, 48111, 48113, 48115, 48117, 48119, 48121, 48123, 48133, 48135, 48137, 48142, 48176, 48192, 48202, 48204, 48216, 48292, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48320, 48322, 48325, 48329, 48331, 48336, 48341, 48344, 48347, 48349, 48352, 48356, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48380, 48382, 48384, 48386, 48389, 48391, 48396, 48398, 48402, 48404, 48407, 48409, 48411, 48413, 48418, 48421, 48423, 48427, 48430, 48432, 48437, 48439, 48444, 48535, 48551, 48553, 48563, 48565, 48569, 48575, 48583, 48588, 48603, 48605, 48609, 48611, 48613, 48618, 48620, 48621, 48628, 48631, 48647, 48654, 48667, 48674, 48677, 48707, 48719, 48734, 48735, 48737, 48744, 48752, 48754, 48755, 48757, 48759, 48761, 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, 48824, 48826, 48828, 48830, 48835, 48849, 48851, 48856, 48858, 48863, 48865, 48868, 48870, 48872, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48904, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48945, 48952, 48959, 48961, 48971, 48980, 48984, 48986, 48988, 48990, 48993, 49007, 49009, 49014, 49016, 49018, 49021, 49023, 49033, 49038, 49041, 49043, 49046, 49051, 49053, 49056, 49058, 49066, 49069, 49077, 49081, 49083, 49086, 49088, 49090, 49100, 49188, 49197, 49199, 49203, 49209, 49214, 49228, 49229, 49234, 49236, 49240, 49244, 49248, 49252, 49258, 49262, 49264, 49266, 49280, 49282, 49284, 49286, 49288, 49292, 49294, 49296, 49298, 49300, 49302, 49312, 49314, 49316, 49319, 49321, 49324, 49326, 49330, 49335, 49343, 49362, 49371, 49378, 49382, 49390, 49404, 49413, 49445, 49472, 49485, 49500, 49504, 49507, 49509, 49513, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49578, 49580, 49589, 49592, 49597, 49602, 49607, 49612, 49620, 49622, 49625, 49627, 49635, 49640, 49642, 49644, 49646, 49650, 49655, 49657, 49662, 49664, 49667, 49754, 49759, 49761, 49770, 49772, 49775, 49777, 49779, 49780, 49783, 49787, 49788, 49791, 49799, 49801, 49803, 49811, 49813, 49815, 49817, 49819, 49825, 49827, 49831, 49837, 49849, 49853, 49857, 49861, 49863, 49869, 49871, 49873, 49877, 49879, 49881, 49886, 49891, 49895, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50113, 50116, 50118, 50123, 50126, 50128, 50131, 50134, 50136, 50138, 50141, 50143, 50146, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50172, 50177, 50179, 50184, 50186, 50189, 50193, 50195, 50198, 50200, 50203, 50205, 50208, 50210, 50215, 50324, 50614, 50912, 50917, 50919, 50925, 50934, 50937, 50942, 50944, 50948, 50950, 50951, 50953, 50957, 50959, 50961, 50963, 50965, 50967, 50969, 50971, 50975, 50977, 50981, 50983, 50987, 50997, 51001, 51050, 51052, 51057, 51061, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51135, 51138, 51140, 51142, 51145, 51147, 51156, 51161, 51164, 51166, 51168, 51170, 51173, 51175, 51179, 51182, 51185, 51187, 51203, 51209, 51223, 51231, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51266, 51273, 51285, 51288, 51290, 51293, 51295, 51298, 51300, 51302, 51304, 51317, 51319, 51324, 51327, 51329, 51331, 51338, 51345, 51354, 51356, 51360, 51363, 51365, 51370, 51376, 51481, 51484, 51486, 51488, 51492, 51496, 51503, 51505, 51506, 51511, 51513, 51514, 51517, 51519, 51521, 51522, 51525, 51527, 51529, 51531, 51532, 51535, 51537, 51539, 51541, 51543, 51545, 51557, 51561, 51565, 51569, 51573, 51577, 51581, 51587, 51591, 51607, 51613, 51624, 51629, 51634, 51639, 51643, 51645, 51648, 51650, 51653, 51655, 51657, 51659, 51664, 51667, 51676, 51681, 51683, 51688, 51694, 51701, 51710, 51722, 51728, 51750, 51759, 51762, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51803, 51806, 51811, 51813, 51817, 51820, 51825, 51828, 51833, 51836, 51838, 51841, 51843, 51845, 51847, 51849, 51856, 51859, 51864, 51866, 51869, 51871, 51877, 51879, 51882, 51885, 51890, 51900, 51904, 51907, 51909, 51919, 51927, 51929, 51931, 51933, 51936, 52060, 52062, 52064, 52068, 52070, 52072, 52074, 52081, 52100, 52102, 52106, 52110, 52114, 52126, 52128, 52132, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52176, 52180, 52184, 52186, 52190, 52194, 52204, 52208, 52216, 52225, 52241, 52243, 52245, 52248, 52250, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52280, 52282, 52284, 52300, 52355, 52371, 52386, 52389, 52400, 52405, 52408, 52410, 52423, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52468, 52471, 52473, 52481, 52483, 52492, 52497, 52499, 52506, 52509) 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: Wild Oats

Cast
Role: Zachariah Actor: Rees

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: Notoriety

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Oscar and Malvina

Song: As17910926

Music: As17911122

Performances

Mainpiece Title: Love In A Village

Cast
Role: Carter Actor: Rees

Afterpiece Title: Lovers' Quarrels

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Notoriety

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Music: As17911122

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Miser

Cast
Role: James Actor: Rees

Dance: As17911109

Song: a favouriteAir from Idalide-Mrs Billington; accompanied on the harp-Meyer

Performances

Mainpiece Title: A Day In Turkey

Music: As17911024

Performances

Mainpiece Title: Notoriety

Afterpiece Title: The Miser

Cast
Role: James Actor: Rees

Performances

Mainpiece Title: The Beggar's Opera

Dance: As17911112

Music: As17911024

Performances

Mainpiece Title: A Day In Turkey

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Dramatist

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Jovial Crew

Dance: In II 3rd piece: the original Crutch Dance-

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Oscar and Malvina

Music: In 3rd piece: The Harp and Pipes-Weippert, Courtney

Performances

Mainpiece Title: Tancred And Sigismunda

Dance: see17920111

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Song: As17911020

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17911102

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17911112

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: Love In A Village

Cast
Role: Carter Actor: Rees

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees