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: Redemption 0; Messiah

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End Part II: As17900219; End I: a new concerto on the Piano Forte-Attwood Jun., Musician to his Royal Highness the Prince of Wales

Performances

Mainpiece Title: Easter Pastimes

Afterpiece Title: The Heiress

Cast
Role: Bacchanals Actor: Kelly, Dignum, Sedgwick

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Adventurers

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Adventurers

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Dance: As17891204

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Captain Macheath Actor: Kelly

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Dance: III: Hornpipe-Bourk

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Invasion

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Who's the Dupe

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Devil to Pay

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Spoil'd Child

Dance: As17891204

Performances

Mainpiece Title: Tit For Tat

Afterpiece Title: Arthur and Emmeline

Cast
Role: Honor Actor: Kelly
Role: Rest of the Vocal Parts Actor: Kelly

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Rivals

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: The College Of Physicians; Or, Doctor Last's Examination

Afterpiece Title: The Heiress

Cast
Role: Bacchanals Actor: Kelly, Dignum, Sedgwick

Afterpiece Title: The Doctor and the Apothecary

Cast
Role: Carlos Actor: Kelly

Song: End II 2nd piece: The Greenwich Pensioner-Dignum

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Deaf Lover

Dance: As17891204

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Toy Shop

Afterpiece Title: The Deserter

Cast
Role: Henry Actor: Kelly

Song: As17900323

Performances

Mainpiece Title: The Rivals

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Romp

Dance: As17891204

Performances

Mainpiece Title: The Rivals

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: Taste; or, Frolicks of Fancy

Afterpiece Title: Arthur and Emmeline

Cast
Role: Honor Actor: Kelly
Role: Rest of the Vocal Parts Actor: Kelly

Entertainment: Monologue. Previous: British Loyalty, as17900423; to conclude with: God save the King-Dignum, Williames, Danby

Performances

Mainpiece Title: The Rivals

Afterpiece Title: No Song No Supper

Cast
Role: Frederick Actor: Kelly

Performances

Mainpiece Title: The Strangers At Home

Cast
Role: Montano Actor: Kelly

Afterpiece Title: Piety in Pattens

Afterpiece Title: The Adventurers

Song: In course Evening: Rosy Bowers (composed by Purcell)-Mrs Crouch

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Gentle Shepherd

Cast
Role: Patie Actor: Kelly

Dance: End: L'Amour au Rende'vous; or, The Conflict of Love, in which will be displayed the Customs of the American Indians, to conclude with the War Dance,-the young D'Egvilles, Miss Blanchet, Miss D'Egville, Miss DeCamp; End I afterpiece: A Highland Reel-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

Mainpiece Title: Il Barbiere Di Siviglia; Or, The Spanish Barber

Cast
Role: Count Almaviva Actor: Kelly

Dance: End I: La Bergere des Alpes, as17900525; End Opera: Divertisement, as17900529

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Cast
Role: Count Almaviva Actor: Kelly

Dance: As17900603

Song: In Opera: Occhiette Furbetti, from La Villanella Rapita-Borselli, Sga Storace