SELECT * FROM london_stages WHERE eventid IN (36223, 36232, 36234, 36237, 36239, 36241, 36243, 36251, 36253, 36255, 36264, 36266, 36273, 36275, 36282, 36291, 36296, 36308, 36336, 36343, 36355, 36381, 36434, 36473, 36477, 36492, 36555, 37150, 37152, 37155, 37157, 37159, 37160, 37162, 37167, 37168, 37175, 37177, 37178, 37179, 37180, 37181, 37183, 37186, 37188, 37190, 37191, 37193, 37197, 37199, 37201, 37204, 37205, 37207, 37208, 37210, 37586, 37692, 37695, 37699, 37702, 37707, 37708, 37712, 37713, 37723, 37724, 37733, 37738, 37750, 37756, 37761, 37763, 37768, 37775, 37777, 37780, 38311, 38363, 38873, 38883, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38951, 38953, 38956, 38960, 38970, 38974, 38982, 38995, 39000, 39017, 39022, 39024, 39026, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39078, 39083, 39086, 39088, 39095, 39098, 39104, 39114, 39123, 39137, 39142, 39146, 39149, 39151, 39163, 39165, 39177, 39181, 39199, 39202, 39210, 39225, 39234, 39242, 39250, 39262, 39268, 39270, 39273, 39296, 39308, 39322, 39333, 39335, 39343, 39793, 43683, 43833, 44741, 45054, 45470, 45512, 45708, 45836, 46114, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46905, 46909, 46917, 46941, 46949, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47063, 47081, 47198, 47202, 47218, 47220, 47235, 47253, 47289, 47291, 47306, 47309, 47312, 47315, 47320, 47326, 47474, 47475, 47478, 47482, 47484, 47485, 47493, 47495, 47497, 47507, 47513, 47519, 47527, 47531, 47537, 47543, 47549, 47555, 47561, 47566, 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, 47645, 47649, 47651, 47655, 47657, 47665, 47672, 47676, 47683, 47685, 47688, 47690, 47737, 47752, 47779, 47782, 47787, 47797, 47803, 47813, 47825, 47828, 47843, 47858, 47865, 47872, 47892, 48015, 48023, 48032, 48038, 48043, 48049, 48080, 48090, 48109, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48264, 48278, 48285, 48289, 48294, 48299, 48320, 48322, 48349, 48352, 48358, 48366, 48368, 48380, 48396, 48416, 48418, 48437, 48443, 48539, 48541, 48551, 48553, 48555, 48567, 48569, 48581, 48588, 48613, 48618, 48620, 48621, 48628, 48637, 48645, 48650, 48654, 48659, 48665, 48672, 48677, 48685, 48687, 48697, 48704, 48707, 48712, 48714, 48717, 48719, 48722, 48727, 48729, 48734, 48735, 48737, 48739, 48744, 48747, 48749, 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, 48813, 48815, 48817, 48819, 48821, 48826, 48827, 48828, 48830, 48835, 48837, 48842, 48844, 48846, 48849, 48851, 48854, 48856, 48858, 48860, 48863, 48865, 48870, 48877, 48879, 48884, 48902, 48916, 48923, 48930, 48945, 48947, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 48998, 49002, 49009, 49014, 49016, 49021, 49023, 49028, 49033, 49038, 49041, 49046, 49051, 49053, 49056, 49058, 49066, 49069, 49072, 49074, 49077, 49081, 49083, 49086, 49090, 49097, 49100, 49193, 49199, 49206, 49214, 49216, 49222, 49226, 49244, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49425, 49432, 49439, 49452, 49465, 49472, 49478, 49485, 49490, 49495, 49500, 49504, 49507, 49509, 49513, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49553, 49556, 49560, 49563, 49570, 49573, 49575, 49578, 49580, 49583, 49589, 49592, 49594, 49599, 49602, 49607, 49609, 49612, 49614, 49620, 49635, 49637, 49640, 49644, 49649, 49650, 49655, 49657, 49662, 49664, 49667, 49757, 49761, 49766, 49772, 49775, 49780, 49783, 49787, 49791, 49794, 49797, 49799, 49801, 49803, 49805, 49811, 49813, 49815, 49817, 49819, 49825, 49827, 49831, 49837, 49839, 49849, 49857, 49869, 49881, 49886, 49891, 49897, 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, 49966, 49968, 49971, 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, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50113, 50116, 50118, 50128, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50172, 50177, 50184, 50186, 50189, 50193, 50195, 50198, 50203, 50205, 50210, 50215, 50332, 50340, 50348, 50352, 50353, 50356, 50358, 50360, 50361, 50374, 50378, 50380, 50385, 50387, 50418, 50461, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50586, 50588, 50591, 50593, 50595, 50602, 50605, 50609, 50620, 50626, 50635, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50688, 50690, 50693, 50695, 50697, 50699, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50726, 50736, 50742, 50744, 50747, 50762, 50767, 50772, 50774, 50777, 50784, 50790, 50797, 50800, 50802, 50805, 50812, 50915, 50917, 50932, 50936, 50940, 50944, 50948, 50950, 50953, 50957, 50959, 50961, 50963, 50965, 50967, 50969, 50971, 50973, 50977, 50987, 50991, 50995, 51001, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 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, 51140, 51150, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51252, 51254, 51256, 51258, 51261, 51266, 51268, 51271, 51277, 51283, 51285, 51288, 51293, 51298, 51300, 51302, 51304, 51307, 51312, 51314, 51317, 51329, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51360, 51363, 51368, 51376, 51481, 51488, 51492, 51498, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51545, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51664, 51701, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51794, 51808, 51815, 51817, 51820, 51825, 51828, 51833, 51836, 51838, 51841, 51843, 51845, 51871, 51887, 51890, 51895, 51907, 51909, 51914, 51931, 52060, 52074, 52077, 52126, 52128, 52168, 52178, 52200, 52202, 52274, 52282, 52289, 52294, 52296, 52303, 52317, 52326, 52329, 52331, 52335, 52338, 52343, 52350, 52353, 52359, 52362, 52365, 52386, 52413, 52418, 52420, 52425, 52429, 52432, 52439, 52442, 52447, 52452, 52456, 52461, 52466, 52471, 52473, 52476, 52490, 52495, 52497, 52504, 52506, 52511, 52513) 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 Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Music: In 3rd piece: As17911024

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The First Part of King Henry the Fourth

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Romeo and Juliet

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Song: As17910926

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Music: As17911122

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Music: As17911024

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Dance: As17911112

Music: As17911024

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Dramatist

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Cast
Role: Carrol Actor: Follett

Afterpiece Title: The Jovial Crew

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

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Cast
Role: Carrol Actor: Follett

Afterpiece Title: Oscar and Malvina

Cast
Role: Carrol Actor: Follett

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: Clown Actor: Follett

Song: As17911020

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Dance: As17911102

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Dance: As17911112

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: The Farmer

Afterpiece Title: Modern Antiques

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Cast
Role: Clown Actor: Follett