SELECT * FROM london_stages WHERE eventid IN (771, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14229, 14300, 14301, 14313, 14316, 15001, 15005, 15011, 15014, 15505, 15566, 15570, 15584, 15604, 16163, 16221, 16485, 16504, 16510, 16531, 16534, 16548, 17372, 17375, 17376, 17380, 17385, 17386, 17392, 17412, 17414, 17495, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17730, 17734, 17738, 17741, 17745, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17807, 17811, 17814, 18054, 18058, 18323, 18326, 18387, 18390, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18620, 18803, 19050, 19052, 19055, 19057, 19244, 19247, 19249, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19301, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19356, 19358, 19368, 19374, 19376, 19377, 19379, 19383, 19411, 19415, 19418, 19420, 19455, 19534, 19536, 19538, 19543, 19545, 19547, 19549, 19556, 19562, 19568, 19576, 19590, 19595, 19611, 19620, 19673, 19675, 19679, 19689, 19697, 19751, 19757, 19763, 19766, 19768, 19770, 19772, 19789, 19800, 19805, 19815, 19818, 19820, 19827, 19832, 19834, 19836, 19839, 19842, 19845, 19847, 19855, 19858, 19861, 19878, 19881, 19883, 19978, 20002, 20012, 20053, 20067, 20090, 20102, 20292, 20295, 20311, 20326, 20347, 20359, 20398, 20415, 20421, 20438, 20461, 20679, 20697, 20706, 20805, 20814, 20817, 20832, 20835, 20838, 20841, 20845, 20875, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20955, 20960, 20967, 20980, 20990, 21000, 21013, 21020, 21041, 21059, 21066, 21086, 21092, 21096, 21099, 21103, 21112, 21116, 21119, 21126, 21172, 21184, 21195, 21198, 21230, 21260, 21326, 21332, 21347, 21354, 21359, 21360, 21366, 21370, 21378, 21382, 21390, 21398, 21405, 21418, 21451, 21482, 21506, 21517, 21534, 21551, 21573, 21635, 21761, 21771, 21805, 21821, 21884, 21887, 21908, 21943, 21948, 21950, 21986, 22024, 22027, 22032, 22034, 22038, 22043, 22132, 22138, 22166, 22182, 22188, 22213, 22253, 22275, 22333, 22366, 22442, 22483, 22524, 22545, 22620, 22687, 22836, 22923, 22981, 23011, 23055, 23090, 23106, 23127, 23156, 23247, 23315, 23351, 23369, 23380, 23383, 23389, 23393, 23409, 23433, 23501, 23600, 23603, 23606, 23861, 23875, 23910, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24580, 24641, 24692, 25059, 25136, 25288, 25295, 26305, 26308, 26314, 27690, 27692, 27722, 27728, 27737, 27763, 28059, 28219, 28633, 28667, 29237, 29593, 29776, 30297, 30383, 30684, 43657, 44031, 44078, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46566, 46593, 46700, 46711, 46729, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47186, 47204, 47214, 47270, 47320, 47454, 47458, 47462, 47470, 47474, 47475, 47478, 47482, 47489, 47503, 47517, 47523, 47535, 47559, 47562, 47564, 47572, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47651, 47665, 47674, 47688, 47690, 47709, 47714, 47724, 47729, 47754, 47759, 47769, 47779, 47787, 47815, 47825, 47830, 47850, 47869, 47885, 48015, 48023, 48029, 48032, 48038, 48043, 48049, 48080, 48090, 48091, 48109, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48280, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48320, 48322, 48325, 48329, 48331, 48336, 48347, 48358, 48361, 48363, 48366, 48368, 48370, 48375, 48377, 48380, 48382, 48384, 48394, 48404, 48409, 48411, 48430, 48432, 48437, 48447, 48539, 48541, 48551, 48553, 48567, 48615, 48645, 48659, 48665, 48685, 48697, 48704, 48707, 48714, 48719, 48727, 48837, 48860, 48947, 49028, 49053, 49072, 49081, 49083, 49100, 49208, 49211, 49256, 49266, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49439, 49452, 49465, 49493, 49517, 49543, 49553, 49565, 49568, 49585, 49604, 49614, 49657, 49799, 49803, 49817, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50070, 50079, 50089, 50092, 50099, 50104, 50113, 50116, 50128, 50134, 50138, 50143, 50148, 50163, 50166, 50193, 50195, 50200, 50203, 50330, 50340, 50352, 50361, 50364, 50368, 50374, 50376, 50380, 50385, 50387, 50389, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50454, 50456, 50461, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50684, 50688, 50690, 50695, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50736, 50742, 50744, 50754, 50757, 50759, 50762, 50764, 50772, 50777, 50784, 50790, 50795, 50800, 50802, 50805, 50812, 50919, 50925, 50937, 50940, 50942, 50944, 50948, 50950, 50953, 50957, 50959, 50961, 50963, 50965, 50969, 50971, 50977, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51140, 51154, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51179, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51263, 51266, 51268, 51273, 51285, 51290, 51298, 51302, 51304, 51309, 51312, 51317, 51319, 51322, 51329, 51336, 51338, 51341, 51343, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51376, 51481, 51488, 51501, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51664, 51676, 51694, 51697, 51699, 51701, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51806, 51811, 51813, 51815, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51845, 51849, 51856, 51864, 51869, 51871, 51885, 51887, 51890, 51900, 51907, 51914, 51933, 51936) 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: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Miser

Afterpiece Title: Harlequin's Chaplet

Dance: As 31 Dec. 1789

Performances

Mainpiece Title: The Poor Soldier

Afterpiece Title: The Child of Nature

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: Eudora

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: Additional Dances (1st time)-Byrne, Mrs Goodwin, the two Miss Simonets

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Highland Reel

Dance: As17891125

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Song: As17891012, but Vocal Parts-_Cubitt, C. _Powell

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Highland Reel

Dance: As17891125

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Harlequin's Chaplet

Dance: As17900129

Performances

Mainpiece Title: The Czar

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: The Death Of Captain Cook

Afterpiece Title: The Highland Reel

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: The Lying Valet

Afterpiece Title: The Poor Soldier

Afterpiece Title: Harlequin's Chaplet

Dance: Preceding: As17891113

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Harlequin's Chaplet

Song: End: As17900407

Performances

Mainpiece Title: Nootka Sound

Afterpiece Title: The Comedy of Errors

Afterpiece Title: Harlequin's Chaplet