SELECT * FROM london_stages WHERE eventid IN (14763, 14783, 14789, 15463, 15554, 15830, 15836, 15839, 15843, 15848, 15852, 15856, 15859, 15863, 15866, 15870, 15874, 15883, 15886, 15889, 15913, 15918, 15922, 15930, 15952, 15959, 15963, 15979, 15984, 15987, 16011, 16015, 16019, 16067, 16073, 16077, 16087, 16094, 16100, 16104, 16113, 16117, 16128, 16132, 16138, 16141, 16163, 16167, 16175, 16197, 16203, 16207, 16300, 16322, 16365, 16369, 16374, 16383, 16387, 16398, 16416, 16487, 17007, 17012, 17016, 17020, 17025, 17031, 17035, 17039, 17045, 17056, 17061, 17067, 17073, 17082, 17095, 17103, 17111, 17119, 17129, 17143, 17157, 17162, 17179, 17182, 17186, 17225, 17229, 17407, 17411, 17413, 17431, 17456, 17561, 17595, 17597, 17601, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17711, 17715, 17719, 17722, 17725, 17729, 17732, 17736, 17755, 17773, 17777, 17783, 17786, 17805, 17809, 17813, 17816, 17820, 17823, 17826, 17829, 17832, 17835, 17839, 17843, 17847, 17852, 17857, 17862, 17867, 17875, 17880, 17885, 17906, 17927, 17944, 17999, 18012, 18190, 18193, 18196, 18199, 18202, 18224, 18229, 18233, 18237, 18242, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18278, 18281, 18283, 18286, 18289, 18292, 18295, 18300, 18303, 18307, 18310, 18314, 18318, 18320, 18329, 18332, 18336, 18339, 18342, 18346, 18349, 18353, 18358, 18362, 18366, 18369, 18373, 18377, 18380, 18383, 18386, 18389, 18392, 18399, 18403, 18405, 18409, 18432, 18437, 18444, 18447, 18450, 18458, 18461, 18477, 18481, 18484, 18490, 18494, 18497, 18505, 18517, 18521, 18525, 18535, 18540, 18543, 18547, 18594, 18604, 18609, 18616, 18622, 18631, 18637, 18643, 18648, 18652, 18705, 18725, 18743, 18748, 18753, 18763, 18767, 18771, 19417, 21840, 24957, 44928, 44935, 44972, 44979, 45144, 45151, 45155, 45157, 45163, 45168, 45173, 45175, 45185, 45189, 45199, 45215, 45223, 45233, 45235, 45237, 45239, 45243, 45245, 45247, 45254, 45259, 45263, 45268, 45270, 45273, 45279, 45292, 45318, 45332, 45337, 45343, 45346, 45348, 45355, 45358, 45360, 45364, 45368, 45373, 45380, 45385, 45389, 45396, 45398, 45402, 45406, 45409, 45415, 45419, 45424, 45439, 45441, 45443, 45448, 45450, 45453, 45458, 45463, 45468, 45471, 45476, 45481, 45489, 45491, 45496, 45499, 45508, 45516, 45518, 45525, 45530, 45533, 45536, 45543, 45548, 45556, 45571, 45592, 45594, 45601, 45603, 45701, 45713, 45718, 45720, 45723, 45728, 45730, 45736, 45739, 45741, 45743, 45746, 45747, 45749, 45751, 45755, 45757, 45760, 45764, 45772, 45774, 45776, 45780, 45782, 45784, 45792, 45800, 45804, 45810, 45816, 45818, 45820, 45822, 45826, 45830, 45839, 45841, 45845, 45847, 45851, 45853, 45857, 45859, 45861, 45870, 45875, 45877, 45879, 45887, 45891, 45898, 45901, 45903, 45905, 45913, 45915, 45922, 45924, 45927, 45929, 45933, 45936, 45938, 45941, 45953, 45959, 45969, 45970, 45972, 45977, 45982, 45985, 45987, 45992, 45995, 45999, 46006, 46009, 46010, 46012, 46014, 46025, 46030, 46032, 46039, 46048, 46049, 46051, 46082, 46092, 46094, 46102, 46105, 46111, 46117, 46120, 46126, 46129, 46139, 46147, 46150, 46153, 46156, 46164, 46272, 46274, 46276, 46278, 46283, 46285, 46290, 46291, 46293, 46296, 46298, 46302, 46304, 46306, 46310, 46312, 46314, 46316, 46320, 46322, 46324, 46326, 46328, 46332, 46335, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46360, 46362, 46364, 46366, 46368, 46372, 46376, 46378, 46380, 46382, 46384, 46386, 46388, 46390, 46392, 46396, 46398, 46400, 46402, 46404, 46406, 46408, 46416, 46418, 46420, 46422, 46424, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46449, 46451, 46454, 46456, 46461, 46463, 46465, 46468, 46470, 46475, 46477, 46480, 46482, 46487, 46489, 46491, 46496, 46501, 46505, 46510, 46516, 46518, 46521, 46526, 46528, 46530, 46540, 46542, 46544, 46556, 46558, 46563, 46568, 46570, 46584, 46587, 46592, 46599, 46608, 46613, 46616, 46621, 46628, 46633, 46638, 46643, 46646, 46651, 46653, 46658, 46660, 46665, 46672, 46680, 46682, 46694, 46710, 46712, 46719, 46730, 46827, 46842, 46843, 46845, 46850, 46851, 46853, 46859, 46862, 46866, 46872, 46876, 46878, 46882, 46886, 46890, 46894, 46898, 46902, 46904, 46910, 46912, 46914, 46916, 46920, 46926, 46928, 46930, 46934, 46936, 46938, 46940, 46944, 46946, 46948, 46956, 46960, 46962, 46964, 46982, 46984, 46988, 46992, 46994, 46996, 46998, 47000, 47002, 47004, 47006, 47010, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47038, 47040, 47042, 47044, 47046, 47050, 47054, 47058, 47065, 47067, 47070, 47072, 47078, 47082, 47085, 47087, 47095, 47097, 47103, 47107, 47113, 47118, 47138, 47141, 47149, 47158, 47166, 47182, 47185, 47208, 47213, 47219, 47225, 47230, 47243, 47252, 47254, 47260, 47263, 47269, 47272, 47276, 47288, 47296, 47303, 47443, 47445, 47448, 47450, 47457, 47460, 47463, 47465, 47468, 47471, 47476, 47480, 47481, 47483, 47486, 47490, 47492, 47494, 47502, 47504, 47510, 47514, 47516, 47518, 47522, 47524, 47526, 47528, 47530, 47532, 47534, 47536, 47538, 47540, 47542, 47546, 47548, 47550, 47552, 47554, 47556, 47563, 47565, 47567, 47569, 47571, 47574, 47579, 47583, 47585, 47588, 47590, 47592, 47594, 47596, 47599, 47602, 47604, 47606, 47608, 47610, 47613, 47615, 47618, 47620, 47622, 47624, 47627, 47630, 47634, 47636, 47642, 47646, 47648, 47652, 47656, 47660, 47664, 47671, 47673, 47677, 47679, 47682, 47684, 47687, 47692, 47701, 47703, 47708, 47711, 47716, 47718, 47721, 47723, 47726, 47728, 47731, 47733, 47736, 47741, 47743, 47746, 47748, 47753, 47756, 47758, 47761, 47763, 47766, 47768, 47771, 47776, 47778, 47781, 47788, 47791, 47793, 47799, 47804, 47807, 47809, 47817, 47827, 47829, 47844, 47859, 47864, 47868, 47871, 47876, 47881, 47884, 47893, 47895, 47899, 47907, 47995, 47996, 47998, 48001, 48005, 48009, 48011, 48013, 48014, 48016, 48018, 48021, 48022, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48040, 48042, 48044, 48046, 48048, 48050, 48052, 48054, 48056, 48058, 48060, 48063, 48065, 48067, 48069, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48118, 48120, 48122, 48124, 48128, 48130, 48132, 48136, 48138, 48145, 48149, 48151, 48153, 48157, 48165, 48169, 48173, 48175, 48177, 48179, 48181, 48183, 48185, 48187, 48191, 48195, 48196, 48208, 48212, 48213, 48215, 48217, 48221, 48222, 48226, 48231, 48234, 48235, 48239, 48241, 48242, 48245, 48253, 48255, 48256, 48262, 48263, 48267, 48269, 48273, 48276, 48277, 48281, 48283, 48290, 48291, 48295, 48297, 48301, 48304, 48305, 48310, 48318, 48319, 48323, 48332, 48337, 48340, 48345, 48350, 48359, 48364, 48373, 48378, 48381, 48387, 48392, 48395, 48399, 48401, 48405, 48408, 48414, 48415, 48419, 48420, 48424, 48428, 48429, 48433, 48436, 48441, 48446, 48452, 48455, 48460, 48463, 48468, 48693, 48989, 49001, 49003, 49008, 49015, 49030, 49037, 49040, 49045, 49052, 49055, 49060, 49076, 49080, 49082, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49116, 49117, 49119, 49120, 49122, 49198, 49200, 49202, 49205, 49207, 49210, 49212, 49213, 49221, 49223, 49225, 49227, 49230, 49231, 49243, 49249, 49255, 49257, 49261, 49267, 49271, 49273, 49279, 49281, 49285, 49291, 49295, 49297, 49301, 49304, 49309, 49311, 49318, 49320, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49361, 49363, 49365, 49367, 49370, 49375, 49377, 49379, 49381, 49384, 49389, 49395, 49400, 49407, 49412, 49415, 49417, 49419, 49423, 49424, 49426, 49431, 49433, 49437, 49438, 49440, 49444, 49446, 49448, 49451, 49453, 49457, 49459, 49461, 49463, 49464, 49466, 49471, 49474, 49476, 49477, 49479, 49481, 49482, 49484, 49486, 49489, 49491, 49492, 49494, 49497, 49499, 49501, 49503, 49506, 49508, 49511, 49512, 49514, 49515, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49537, 49538, 49546, 49555, 49559, 49564, 49571, 49576, 49581, 49582, 49584, 49586, 49590, 49591, 49595, 49596, 49601, 49605, 49606, 49610, 49611, 49617, 49623, 49624, 49628, 49633, 49638, 49647, 49652, 49661, 49673, 49676, 49681, 49684, 49689, 49692, 49697, 49758, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49790, 49795, 49800, 49802, 49808, 49812, 49814, 49816, 49824, 49828, 49830, 49838, 49846, 49850, 49856, 49858, 49862, 49866, 49870, 49874, 49876, 49880, 49887, 49890, 49894, 49901, 49904, 49906, 49909, 49911, 49923, 49928, 49932, 49937, 49942, 49944, 49955, 49964, 49969, 49976, 49981, 49990, 49997, 49999, 50012, 50024, 50034, 50036, 50037, 50040, 50047, 50051, 50054, 50056, 50059, 50063, 50066, 50069, 50072, 50076, 50083, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50133, 50137, 50145, 50152, 50155, 50157, 50160, 50165, 50171, 50176, 50183, 50188, 50190, 50194, 50202, 50207, 50209, 50212, 50219, 50220, 50228, 50249, 50258, 50337, 50341, 50344, 50349, 50357, 50362, 50367, 50369, 50372, 50375, 50379, 50381, 50386, 50390, 50397, 50401, 50407, 50411, 50421, 50427, 50434, 50441, 50446, 50448, 50505, 50511, 50523, 50525, 50530, 50535, 50548, 50555, 50561, 50563, 50567, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50608, 50610, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50687, 50689, 50692, 50694, 50706, 50730, 50735, 50743, 50746, 50748, 50751, 50758, 50761, 50771, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50918, 50920, 50943, 50947, 50949, 50970, 50972, 50974, 50994, 51002, 51004, 51013, 51020, 51023, 51026, 51030, 51035, 51037, 51049, 51051, 51068, 51070, 51075, 51100, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51134, 51137, 51139, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51198, 51248, 51251, 51253, 51279, 51282, 51284, 51287, 51294, 51299, 51301, 51311, 51313, 51321, 51323, 51326, 51328, 51337, 51340, 51344, 51348, 51353, 51355, 51362, 51364, 51369, 51373, 51377, 51380, 51381, 51382, 51390, 51392, 51402, 51407, 51411, 51418, 51491, 51495, 51499, 51502, 51504, 51507, 51510, 51512, 51516, 51518, 51520, 51523, 51524, 51526, 51528, 51534, 51542, 51544, 51546, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51576, 51580, 51586, 51590, 51597, 51602, 51604, 51606, 51609, 51614, 51616, 51623, 51626, 51628, 51633, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51709, 51712, 51715, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51793, 51796, 51807, 51819, 51821, 51824, 51830, 51832, 51837, 51840, 51842, 51844, 51846, 51848, 51850, 51855, 51863, 51865, 51868, 51872, 51876, 51878, 51884, 51886, 51913, 51926, 51963, 52065, 52091, 52092, 52095, 52096, 52098, 52101, 52103, 52105, 52111, 52113, 52115, 52117, 52125, 52127, 52129, 52137, 52139, 52143, 52145, 52149, 52153, 52161, 52163, 52167, 52171, 52175, 52185, 52189, 52201, 52203, 52211, 52213, 52215, 52220, 52224, 52226, 52233, 52238, 52240, 52244, 52249, 52254, 52261, 52263, 52266, 52281, 52334, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52370, 52376, 52388, 52390, 52402, 52412, 52448, 52451, 52465, 52467, 52470, 52477, 52480, 52482, 52489, 52494, 52498, 52515) 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: A Grand Selection 0 Main Of Sacred Music, From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: The School For Lovers

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Cast
Role: Total eclipse Actor: Kelly

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Semiramide

Cast
Role: Arsace Actor: Kelly

Dance: End I: Divertisement, as17941220; End II: New Divertisement by Onorati-

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Semiramide

Cast
Role: Arsace Actor: Kelly

Dance: As17950228

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Semiramide

Cast
Role: Arsace Actor: Kelly

Dance: As17950228

Performances

Mainpiece Title: The Messiah

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Actor: Kelly

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Waft her angels Actor: Kelly

Music: 6th concerto of Giordani on the violin-C. Ashley

Performances

Mainpiece Title: King John

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Semiramide

Cast
Role: Arsace Actor: Kelly

Dance: As17950228

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Alexander the Great

Performances

Mainpiece Title: Acis And Galatea; Messiah

Afterpiece Title: A Grand Miscellaneous Act

Cast
Role: Softly rise Actor: Kelly

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Alexander the Great