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: Notoriety

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 Farmer

Afterpiece Title: Modern Antiques

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: Wild Oats

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 Woodman

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: In afterpiece: Byrne, Mlle St.Amand

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

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

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Dance: As17920111

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

Performances

Mainpiece Title: Love In A Village

Cast
Role: Carter Actor: Rees

Afterpiece Title: Love a-la-Mode

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: The Magician No Conjurer

Cast
Role: Countrymen Actor: Thompson, Cross, Rees

Afterpiece Title: The Deaf Lover

Performances

Mainpiece Title: The Magician No Conjurer

Cast
Role: Countrymen Actor: Thompson, Cross, Rees

Afterpiece Title: Lovers' Quarrels

Performances

Mainpiece Title: The Magician No Conjurer

Cast
Role: Countrymen Actor: Thompson, Cross, Rees

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Blue Beard

Cast
Role: Sailor Actor: Rees

Performances

Mainpiece Title: The Magician No Conjurer

Cast
Role: Countrymen Actor: Thompson, Cross, Rees

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: Love In A Village

Cast
Role: Carter Actor: Rees

Afterpiece Title: The Miser

Cast
Role: James Actor: Rees