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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: His mighty arm Actor: Kelly

Afterpiece Title: Grand Selection 3

Music: End Part II: a trio for violin viola and violoncello-G. and R. and C. Ashley

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: Sixth concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: As17930319

Ballet: Venus and Adonis. As17930319

Performances

Mainpiece Title: At King's The Siege Of Belgrade

Cast
Role: The Seraskier Actor: Kelly

Afterpiece Title: The Sultan

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prisoner

Cast
Role: Marcos Actor: Kelly

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: End I: an entire new Divertisement (composed by Noverre) Le Faune Infidele-Nivelon, Mlle Hilligsberg, D'Egville, Mlle Millerd

Ballet: End Opera: Venus and Adonis. As17930226

Performances

Mainpiece Title: At King's The Pirates

Cast
Role: Don Altador Actor: Kelly

Afterpiece Title: The Agreeable Surprise

Dance: As17921121, but The Dances-Miss _Prevot

Song: In the course of the Evening The Little Farthing Rushlight-Bannister Jun

Performances

Mainpiece Title: Le Nozze Di Dorina

Cast
Role: Masotto Actor: Kelly

Dance: End I: Le Faune Infidele, as17930406, but Gentili

Ballet: End Opera: Venus and Adonis. As17930226

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: As17930409

Ballet: Venus and Adonis. As17930409

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: As17930409

Ballet: Venus and Adonis. As17930409

Performances

Mainpiece Title: At King's The Pirates

Cast
Role: Don Altador Actor: Kelly

Afterpiece Title: The Mayor of Garratt

Dance: As17930408

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: End I: Le Faune Infidele- [See17930409]; End Opera: Venus and Adonis- [See17930226]

Performances

Mainpiece Title: Le Nozze Di Dorina

Cast
Role: Masotto Actor: Kelly

Dance: End I: Les Epoux du Tempe- [See17930205]

Ballet: End Opera: the Grand Historical Ballet in 4 Parts, which has been so long in preparation, Iphiginia in Aulide; or, The Sacrifice of Iphiginia composed by Noverre. Iphiginia-Mlle Hilligsberg; Clytemnestra-Mlle Millerd; Agamemnon-D'Egville; Achilles-Nivelon; Egisthus-Favre Gardel; Young Orestes-Mlle Menage; Lesbian-Gentili; Warriors, Lesbian Slaves, High Priests, Priests, Priestesses-the Corps de Ballet

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: As17930423

Ballet: Iphigenia in Aulide. As17930423

Performances

Mainpiece Title: Le Nozze Di Dorina

Cast
Role: Masotto Actor: Kelly

Dance: End I: Le Faune Infidele, as17930420

Ballet: End Opera: Iphiginia in Aulide. As17930423

Performances

Mainpiece Title: I Giuochi D'agrigento

Cast
Role: Eraclide Actor: Kelly

Dance: As17930423

Ballet: Iphigenia in Aulide. As17930423

Performances

Mainpiece Title: Le Nozze Di Dorina

Cast
Role: Masotto Actor: Kelly

Dance: End I: Divertisement- [See17930126]

Ballet: End Opera: Iphiginia in Aulide. As17930423

Performances

Mainpiece Title: At King's All In The Wrong

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: Teodolinda

Cast
Role: Minolfi Actor: Kelly

Dance: As17930507

Ballet: Iphiginia in Aulide. As17930507

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Perillo Actor: Kelly

Dance: As17930423

Ballet: Iphiginia in Aulide. As17930423

Performances

Mainpiece Title: At King's The Siege Of Belgrade

Cast
Role: The Seraskier Actor: Kelly

Afterpiece Title: The Irish Widow

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Perillo Actor: Kelly

Dance: As17930430

Ballet: Iphigenia in Aulide. As17930430

Performances

Mainpiece Title: At King's The Pirates

Cast
Role: Don Altador Actor: Kelly

Afterpiece Title: The Sultan

Dance: As17930408

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Perillo Actor: Kelly

Dance: As17930430

Ballet: Iphigenia in Aulide. As17930430

Performances

Mainpiece Title: At King's Artaxerxes

Cast
Role: Artabanes Actor: Kelly

Afterpiece Title: The Pannel

Song: the favourite Harp Song-Mme Mara [Ah che nel petto io sento]; accompanied-Meyer Jun