SELECT * FROM london_stages WHERE eventid IN (1746, 4329, 6337, 9110, 9113, 9116, 9119, 9123, 9127, 9130, 9187, 9190, 9226, 9252, 9313, 9390, 9474, 9537, 9641, 9905, 10361, 10850, 13113, 13116, 13198, 14028, 14142, 14306, 14485, 14654, 15104, 16583, 16777, 16965, 17434, 19244, 19247, 19249, 19411, 19415, 19418, 19420, 19455, 19697, 19978, 20201, 20790, 20961, 21034, 21038, 21218, 21294, 21329, 21548, 21553, 21625, 21631, 21676, 22565, 22937, 22941, 23641, 24296, 24300, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24333, 25045, 25124, 25166, 25293, 25446, 25817, 25987, 26011, 26306, 27216, 27220, 27234, 27243, 27291, 27301, 27340, 27361, 27379, 27612, 27652, 27672, 27729, 27753, 27796, 27807, 27832, 28049, 28202, 28222, 28325, 28516, 28535, 28722, 28764, 28785, 28871, 28888, 28989, 29778, 29780, 29782, 29784, 29786, 29788, 29790, 29792, 29794, 29799, 29801, 29804, 29808, 29810, 29817, 29828, 29840, 29844, 29848, 29870, 29883, 31048, 31049, 31052, 31053, 31061, 31064, 31188, 31749, 32039, 32756, 32757, 32758, 32760, 32761, 32762, 32764, 32765, 32766, 32767, 32768, 32769, 32770, 32771, 32772, 32774, 32776, 32778, 32781, 32786, 32788, 32790, 32792, 32793, 32796, 32798, 32801, 32803, 32804, 32959, 33726, 33732, 33739, 33742, 33756, 33762, 33777, 33785, 34297, 34309, 34322, 34333, 34348, 34357, 34359, 34369, 34389, 34393, 34400, 34412, 34416, 34428, 34683, 34703, 34717, 34724, 34758, 34767, 34791, 34793, 34798, 34814, 34819, 34836, 34851, 34858, 34868, 34879, 34883, 35347, 35364, 35380, 35387, 35403, 35443, 35454, 35484, 35894, 35963, 35993, 36012, 36027, 36068, 36170, 36193, 36197, 36313, 36331, 36455, 36535, 36572, 36580, 36603, 36631, 36800, 37150, 37599, 37656, 37699, 37713, 37723, 37733, 37756, 37774, 37825, 37923, 37983, 37986, 37989, 38006, 38009, 38014, 38015, 38019, 38024, 38027, 38031, 38036, 38041, 38046, 38057, 38066, 38151, 38187, 38196, 38233, 38256, 38269, 38286, 38303, 38309, 38368, 38383, 38387, 38390, 38394, 38399, 38402, 38417, 38420, 38425, 38500, 38525, 38722, 38731, 38789, 38803, 38834, 38897, 38922, 38972, 38977, 38991, 39016, 39026, 39030, 39034, 39047, 39060, 39062, 39069, 39076, 39091, 39102, 39118, 39132, 39163, 39165, 39216, 39222, 39247, 39276, 39378, 39750, 39868, 39883, 39916, 39936, 40102, 40368, 40509, 40510, 40512, 40513, 40516, 40517, 40519, 40524, 40527, 40531, 40545, 40820, 40932, 40982, 41179, 41601, 41603, 41604, 41607, 41610, 41615, 41618, 41621, 41626, 41631, 41633, 41642, 41646, 41649, 42140, 42141, 42143, 42146, 42148, 42151, 42153, 42206, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 42248, 42268, 42810, 42811, 42812, 42814, 42815, 42817, 42818, 42820, 42821, 42822, 42823, 42825, 42826, 42827, 42828, 42830, 42831, 42832, 42837, 42839, 42842, 42844, 42846, 42848, 42850, 42853, 42987, 43280, 43343, 43349, 43356, 43361, 43366, 43378, 43387, 43393, 43409, 43422, 43431, 43830, 43870, 43969, 44005, 44123, 44382, 44394, 44444, 44582, 44840, 45037, 45140, 45172, 45203, 45261, 45339, 45364, 45398, 45444, 45459, 45475, 45481, 45519, 45521, 45561, 45596, 45712, 45725, 45824, 45826, 45830, 45839, 45847, 45887, 45922, 45945, 45957, 45977, 45990, 46033, 46039, 46057, 46072, 46094, 46132, 46153, 46168, 46537, 46551, 46601, 46611, 46638, 46648, 46651, 46665, 46680, 46690, 46694, 46817, 46819, 46821, 46822, 46824, 46864, 46880, 46892, 46904, 46916, 46928, 46940, 46958, 46964, 46994, 47016, 47032, 47046, 47062, 47085, 47090, 47107, 47143, 47183, 47203, 47208, 47228, 47272, 47294, 47339, 47400, 47452, 47464, 47472, 47473, 47482, 47495, 47507, 47519, 47526, 47636, 47662, 47682, 47684, 47786, 47822, 47833, 47844, 47866, 47878, 47895, 47912, 47927, 47952, 47953, 47957, 47965, 47969, 47976, 47980, 47990, 48001, 48016, 48034, 48059, 48320, 48322, 48346, 48353, 48358, 48366, 48368, 48388, 48390, 48425, 48454, 48462, 48465, 48467, 48469, 48470, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48484, 48487, 48488, 48489, 48492, 48494, 48495, 48496, 48497, 48515, 48519, 48526, 48530, 48532, 48533, 48607, 48627, 48649, 48671, 48691, 48711, 48751, 48760, 48762, 48768, 48770, 48772, 48931, 48948, 49123, 49128, 49130, 49136, 49138, 49140, 49141, 49142, 49143, 49144, 49145, 49148, 49149, 49150, 49151, 49155, 49156, 49157, 49158, 49162, 49165, 49166, 49168, 49169, 49171, 49172, 49174, 49175, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49247, 49283, 49315, 49393, 49407, 49438, 49500, 49504, 49507, 49509, 49513, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49545, 49548, 49550, 49557, 49626, 49656, 49663, 49669, 49687, 49700, 49701, 49712, 49737, 49763, 49771, 49784, 49795, 49809, 49825, 49827, 49831, 49840, 49850, 49857, 49944, 49991, 50055, 50091, 50142, 50185, 50189, 50210, 50225, 50250, 50264, 50290, 50305, 50344, 50397, 50403, 50453, 50497, 50533, 50545, 50580, 50596, 50614, 50689, 50733, 50736, 50742, 50744, 50757, 50778, 50795, 50802, 50805, 50808, 50818, 50830, 50832, 50849, 50853, 50858, 50865, 50867, 50870, 50874, 50875, 50877, 50885, 50890, 50902, 50924, 50928, 50974, 50988, 51002, 51013, 51028, 51097, 51098, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51121, 51124, 51128, 51130, 51138, 51142, 51156, 51167, 51203, 51243, 51276, 51288, 51303, 51326, 51356, 51385, 51395, 51399, 51405, 51411, 51413, 51424, 51431, 51441, 51442, 51446, 51451, 51453, 51468, 51470, 51474, 51485, 51502, 51520, 51539, 51544, 51546, 51560, 51564, 51572, 51602, 51652, 51677, 51698, 51717, 51761, 51814, 51889, 51904, 51946, 51950, 51980, 51983, 52038, 52055, 52065, 52075, 52111, 52121, 52161, 52226, 52254, 52299, 52334, 52353, 52410, 52424, 52463, 52510) 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 Rivals

Cast
Role: Coachman Actor: Thompson

Afterpiece Title: Hartford Bridge

Song: End II: A New Hunting Song- (never [previously] performed, composed by Davy); End III: Sally in our Alley-Incledon; End: The Red Cross Knight, as18000426; End I afterpiece: The Sailor's Journal-Incledon

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: High Life below Stairs

Cast
Role: Coachman Actor: Webb

Afterpiece Title: Rosina

Ballet: In 2nd piece: The Scotch Ghost. As17991202, but Glaude-Fisher