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 Belle's Stratagem

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Ballet: End: The Scotch Ghost. As17961029, but Glaude-Grimaldi; The Lady of Dunblain-_; Villagers-Ms _Byrne, Ms _Thompson

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Richard Actor: Kelly

Dance: As17961019

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: The Seraskier Actor: Kelly

Afterpiece Title: The Apprentice

Ballet: The Scotch Ghost. As17961116

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Prisoner

Cast
Role: Marcos Actor: Kelly

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Doctor and the Apothecary

Cast
Role: Carlos Actor: Kelly

Performances

Mainpiece Title: The Force Of Ridicule

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Richard Actor: Kelly

Dance: As17961019

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: The Seraskier Actor: Kelly

Afterpiece Title: Robinson Crusoe

Ballet: End I: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Honey Moon

Cast
Role: Sir George Orbit Actor: Kelly

Afterpiece Title: Robinson Crusoe

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: The Seraskier Actor: Kelly

Afterpiece Title: Robinson Crusoe

Dance: As17970104

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Richard Actor: Kelly

Dance: As17961019

Performances

Mainpiece Title: The Chances

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Richard Actor: Kelly

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Theodosius

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Richard Actor: Kelly

Song: As17970120

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Deserter

Cast
Role: Henry Actor: Kelly

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: The Seraskier Actor: Kelly

Afterpiece Title: The Follies of a Day

Ballet: End I: The Scotch Ghost. As17961116, but Hornpipe-_

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: A Friend in Need

Cast
Role: Count Solano Actor: Kelly

Song: Afterpiece: Chorus-Welsh, Maddocks, Gregson, Wentworth, Atkins, Meyers, Annereau, Bardoleau, Walker, Willoughby, Ms Butler, Ms Roffey, Ms Granger, Ms Jackson, Ms Maddocks, Ms Menage, Ms Wentworth, Ms Benson

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: A Friend in Need

Cast
Role: Count Solano Actor: Kelly

Song: Chorus, as17970209, but _Annereau, _Bardoleau, _Walker, _Willoughby

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: A Friend in Need

Cast
Role: Count Solano Actor: Kelly

Song: In afterpiece: As17970210 In III: a new Duett (composed by Shaw) [In vows of everlasting truth (BUC 942)]-Dignum, Mrs Bland; In afterpiece: As17970210

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: A Friend in Need

Cast
Role: Count Solano Actor: Kelly

Ballet: The Scotch Ghost. As17961221

Song: As17970210

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: A Friend in Need

Cast
Role: Count Solano Actor: Kelly

Song: As17970210

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: A Friend in Need

Cast
Role: Count Solano Actor: Kelly

Ballet: The Scotch Ghost. As17961221

Song: As17970210

Performances

Mainpiece Title: The Purse; Or, Benevolent Tar

Afterpiece Title: The Children in the Wood

Afterpiece Title: Lodoiska

Cast
Role: Count Floreski Actor: Kelly

Ballet: The Scotch Ghost. As17970105