SELECT * FROM london_stages WHERE eventid IN (21334, 35812, 35904, 38015, 38115, 41459, 42916, 42918, 42922, 42924, 42930, 42932, 42934, 42936, 42940, 42944, 42946, 42948, 42956, 42958, 42960, 42965, 42970, 42977, 42979, 42982, 42986, 42988, 42997, 42999, 43001, 43006, 43072, 43077, 43101, 43120, 43141, 43158, 43172, 43180, 43191, 43204, 43217, 43255, 43325, 43460, 43618, 43627, 43963, 43970, 43975, 43977, 43979, 43981, 43984, 43985, 43986, 43988, 43991, 43992, 44006, 44007, 44009, 44010, 44013, 44029, 44109, 44127, 44133, 44135, 44141, 44151, 44200, 44210, 44223, 44249, 44290, 44389, 44424, 44439, 44577, 44579, 44583, 44585, 44591, 44658, 45446, 45475, 45521, 45524, 45562, 45572, 45584, 45711, 45742, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45914, 45916, 45918, 45925, 45930, 45934, 45937, 45944, 45951, 45958, 45965, 46024, 46028, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46070, 46080, 46093, 46100, 46103, 46106, 46121, 46127, 46133, 46148, 46154, 46166, 46174, 46275, 46277, 46284, 46297, 46307, 46359, 46385, 46464, 46500, 46536, 46595, 46642, 46751, 46758, 46774, 46861, 46875, 46889, 46905, 46917, 46941, 46945, 46947, 46949, 47047, 47198, 47202, 47212, 47224, 47235, 47244, 47247, 47253, 47266, 47277, 47283, 47437, 47464, 47472, 47478, 47482, 47495, 47507, 47519, 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, 47649, 47665, 47688, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47769, 47774, 47779, 47782, 47787, 47792, 47797, 47800, 47805, 47808, 47813, 47815, 47820, 47825, 47828, 47835, 47843, 47855, 47858, 47872, 47892, 48015, 48023, 48032, 48036, 48041, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48341, 48344, 48347, 48349, 48356, 48358, 48361, 48363, 48372, 48375, 48377, 48382, 48386, 48389, 48391, 48398, 48402, 48407, 48413, 48416, 48418, 48421, 48443, 48547, 48571, 48596, 48650, 48672, 48712, 48717, 48722, 48737, 48747, 48749, 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, 48826, 48828, 48830, 48835, 48837, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49051, 49053, 49056, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49193, 49199, 49206, 49214, 49228, 49229, 49234, 49236, 49240, 49244, 49248, 49250, 49252, 49258, 49262, 49264, 49266, 49280, 49282, 49284, 49286, 49288, 49292, 49294, 49296, 49298, 49300, 49302, 49305, 49307, 49312, 49314, 49316, 49319, 49321, 49324, 49326, 49328, 49330, 49333, 49335, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49380, 49382, 49385, 49387, 49390, 49392, 49399, 49401, 49404, 49425, 49432, 49439, 49445, 49452, 49465, 49478, 49485, 49500, 49504, 49507, 49509, 49513, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49578, 49580, 49589, 49592, 49594, 49599, 49602, 49607, 49612, 49620, 49635, 49640, 49646, 49650, 49653, 49655, 49657, 49662, 49664, 49667, 49754, 49777, 49779, 49787, 49797, 49801, 49811, 49815, 49819, 49825, 49827, 49831, 49837, 49849, 49861, 49873, 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, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50113, 50116, 50118, 50128, 50131, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50177, 50179, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50215, 50330, 50332, 50334, 50338, 50340, 50352, 50353, 50356, 50358, 50360, 50361, 50374, 50376, 50378, 50380, 50383, 50385, 50387, 50389, 50391, 50392, 50394, 50396, 50398, 50400, 50402, 50404, 50406, 50408, 50410, 50412, 50414, 50416, 50418, 50420, 50422, 50424, 50428, 50430, 50433, 50435, 50438, 50440, 50442, 50444, 50447, 50449, 50452, 50454, 50456, 50463, 50466, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50517, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50586, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 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, 50724, 50726, 50731, 50736, 50742, 50744, 50747, 50754, 50757, 50764, 50767, 50769, 50772, 50774, 50782, 50784, 50790, 50795, 50800, 50802, 50805, 50808, 50812, 50917, 50921, 50923, 50925, 50927, 50929, 50932, 50936, 50937, 50940, 50951, 50957, 50959, 50961, 50965, 50969, 50971, 50973, 50975, 50977, 50979, 50981, 50983, 50985, 50987, 50989, 50991, 50993, 50995, 50997, 51001, 51003, 51005, 51007, 51009, 51014, 51016, 51018, 51021, 51027, 51029, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51052, 51054, 51057, 51061, 51073, 51076, 51078, 51087, 51090, 51095, 51119, 51133, 51140, 51145, 51147, 51150, 51152, 51156, 51175, 51191, 51203, 51209, 51211, 51215, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51252, 51254, 51256, 51258, 51261, 51266, 51268, 51271, 51273, 51277, 51280, 51283, 51285, 51290, 51293, 51295, 51298, 51300, 51304, 51307, 51309, 51312, 51314, 51317, 51319, 51322, 51324, 51329, 51331, 51336, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51360, 51363, 51365, 51376, 51481, 51484, 51501, 51509, 51513, 51517, 51527, 51529, 51531, 51535, 51537, 51539, 51541, 51543, 51545, 51561, 51593, 51596, 51598, 51601, 51605, 51607, 51610, 51613, 51615, 51619, 51621, 51627, 51631, 51636, 51639, 51641, 51645, 51653, 51662, 51669, 51673, 51686, 51688, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51755, 51765, 51767, 51771, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51803, 51806, 51811, 51813, 51815, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51841, 51843, 51845, 51849, 51851, 51856, 51859, 51861, 51864, 51866, 51869, 51871, 51873, 51877, 51879, 51885, 51887, 51890, 51893, 51895, 51898, 51900, 51902, 51904, 51907, 51909, 51914, 51922, 51924, 51927, 51929, 51931, 51933, 51936, 52057, 52060, 52062, 52064, 52068, 52077, 52093, 52097, 52100, 52102, 52104, 52106, 52110, 52112, 52114, 52116, 52118, 52120, 52122, 52124, 52126, 52128, 52130, 52132, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52162, 52164, 52166, 52168, 52170, 52172, 52174, 52176, 52178, 52180, 52182, 52184, 52186, 52190, 52192, 52194, 52196, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52267, 52269, 52271, 52274, 52277, 52280, 52282, 52289, 52291, 52294, 52296, 52300, 52303, 52308, 52310, 52312, 52314, 52317, 52319, 52329, 52347, 52353, 52355, 52359, 52365, 52367, 52371, 52374, 52377, 52379, 52383, 52386, 52389, 52394, 52396, 52398, 52403, 52405, 52418, 52423, 52425, 52429, 52432, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52461, 52463, 52466, 52468, 52471, 52473, 52476, 52478, 52481, 52483, 52486, 52490, 52492, 52499, 52504, 52506, 52509, 52511) 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: Artaxerxes

Afterpiece Title: Blue Beard

Cast
Role: Footboy Actor: Simmons

Dance: As17920111

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Blue Beard

Cast
Role: Footboy Actor: Simmons

Dance: As17920111

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

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Cast
Role: Footboy Actor: Simmons

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Blue Beard

Cast
Role: Footboy Actor: Simmons

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Cast
Role: Footboy Actor: Simmons

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Blue Beard

Cast
Role: Footboy Actor: Simmons

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Highland Reel

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Positive Man

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Romp

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Maid of the Oaks

Dance: In I afterpiece: a Dance-

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian