SELECT * FROM london_stages WHERE eventid IN (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, 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: Romeo And Juliet

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Song: As17891109

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: Harlequin's Chaplet

Dance: As17891221

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: Byrne, Miss Simonet

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Follies of a Day

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Midnight Hour

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Song: In III: song-Duffey

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin's Chaplet

Dance: In afterpiece: As17891231.; End II: Divertissement, as17891002

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Song: As17900113

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: Harlequin's Chaplet

Dance: As17891231

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