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: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Dance: As17891204

Song: In Opera: a new song-Sga Storace

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deaf Lover

Dance: As17900123

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deuce is in Him

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Irish Widow

Dance: In II: As17891204; End I afterpiece: The Irish Bird Catchers, as17900123

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Dance: As17891204

Performances

Mainpiece Title: The Messiah, Preceded By god Save The King(coronation Anthems)

Music: End II: concerto on the violin-Master Bridgtower, Son to the African Prince

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deaf Lover

Dance: As17900123

Performances

Mainpiece Title: A Grand Selection 0[from The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Dance: As17891204

Performances

Mainpiece Title: Redemption, A Sacred Oratorio Selected From The Great And Favourite Works Of handel That Were Performed At His Commemoration, In westminster-abbey And At The pantheon On 26 And 27 May 1784 0; Messiah

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Cast
Role: Lord remember David Actor: Kelly

Afterpiece Title: Redemption 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection From The Works Of handel 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deuce is in Him

Dance: As17891204

Performances

Mainpiece Title: Acis And Galatea; Messiah

Afterpiece Title: A Grand Selection

Music: End II oratorio: concerto on the violoncello-Mason

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Performances

Mainpiece Title: A Grand Selection From The Works Of handel 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Sound an alarm Actor: Kelly

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deuce is in Him

Dance: As17891204

Performances

Mainpiece Title: A Grand Selection From The Works Of handel 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Adventurers

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Adventurers

Dance: As17891204