SELECT * FROM london_stages WHERE eventid IN (1442, 1447, 1581, 2026, 2114, 2211, 3583, 3618, 3754, 3766, 3773, 4015, 4025, 4035, 4115, 4171, 4183, 4203, 4563, 5157, 5159, 5162, 5667, 6181, 6996, 8976, 8982, 9011, 9056, 9207, 9281, 9426, 9444, 9488, 9540, 9647, 9882, 9926, 9990, 10157, 10276, 10342, 10415, 10480, 10750, 10803, 10946, 11047, 11208, 11262, 11609, 11698, 11812, 11871, 12504, 12550, 12882, 12905, 12908, 13094, 13098, 13176, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13733, 13737, 13741, 13763, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13866, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13910, 13920, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14058, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14213, 14229, 14268, 14299, 14340, 14373, 14384, 14392, 14395, 14407, 14430, 14432, 14443, 14452, 14519, 14544, 14550, 14877, 14935, 14967, 15153, 15254, 15259, 15280, 15284, 15288, 15291, 15300, 15303, 15325, 15329, 15332, 15366, 15517, 15518, 15645, 15828, 15871, 15876, 15880, 15884, 15891, 15899, 15906, 15907, 15910, 15964, 16004, 16008, 16009, 16012, 16016, 16021, 16049, 16054, 16058, 16070, 16097, 16101, 16107, 16114, 16118, 16129, 16135, 16394, 16406, 16461, 16487, 16642, 16651, 16661, 16665, 16668, 16673, 16678, 16697, 16725, 16899, 16913, 16960, 17122, 17195, 17235, 17284, 17341, 17473, 17491, 17567, 17647, 17671, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17827, 17831, 17833, 17837, 17841, 17845, 17850, 17855, 17860, 17873, 17878, 17883, 17890, 17981, 18021, 18166, 18168, 18171, 18226, 18239, 18300, 18351, 18379, 18412, 18475, 18629, 18678, 18688, 18904, 18913, 18921, 18923, 18929, 18938, 18966, 18983, 19005, 19055, 19090, 19163, 19255, 19283, 19347, 19380, 19401, 19444, 19446, 19451, 19510, 19516, 19520, 19527, 19534, 19536, 19538, 19556, 19562, 19576, 19590, 19591, 19595, 19611, 19633, 19643, 19646, 19648, 19650, 19653, 19656, 19658, 19659, 19663, 19683, 19685, 19713, 19715, 19722, 19728, 19741, 19793, 19795, 19798, 19843, 19845, 19847, 19862, 19878, 19881, 19883, 19975, 19983, 20002, 20012, 20027, 20053, 20067, 20081, 20102, 20120, 20135, 20182, 20197, 20245, 20248, 20249, 20254, 20257, 20264, 20267, 20273, 20359, 20360, 20529, 20587, 20589, 20660, 20716, 20718, 20800, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20915, 20917, 20928, 20937, 20948, 20951, 20960, 20971, 20981, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21103, 21119, 21120, 21158, 21172, 21184, 21209, 21261, 21314, 21339, 21351, 21379, 21393, 21455, 21490, 21500, 21518, 21591, 21720, 21788, 21789, 21830, 21883, 21890, 21912, 21916, 21955, 21981, 22028, 22162, 22216, 22264, 22315, 22325, 22328, 22331, 22355, 22359, 22397, 22409, 22418, 22494, 22496, 22587, 22595, 22747, 22776, 22777, 22798, 22853, 22877, 22896, 22959, 23012, 23066, 23100, 23103, 23110, 23113, 23142, 23200, 23222, 23245, 23286, 23290, 23358, 23364, 23381, 23390, 23410, 23431, 23439, 23529, 23697, 23711, 23735, 23751, 23777, 23794, 23819, 23857, 23934, 23974, 24012, 24058, 24187, 24243, 24338, 24370, 24371, 24372, 24426, 24508, 24695, 24732, 24765, 24924, 24926, 24927, 24931, 24987, 25001, 25026, 25119, 25262, 25281, 25337, 25382, 25391, 25392, 25418, 25425, 25458, 25555, 25648, 25669, 25685, 25715, 25752, 25753, 25772, 25794, 25795, 25831, 25914, 25942, 25953, 25986, 26036, 26042, 26079, 26099, 26115, 26131, 26133, 26134, 26165, 26200, 26232, 26248, 26252, 26258, 26288, 26297, 26352, 26409, 26578, 26614, 26681, 26730, 26742, 26812, 26850, 26998, 27022, 27067, 27068, 27186, 27376, 27521, 27555, 27561, 27570, 27573, 27596, 27667, 27731, 27780, 27795, 27859, 27923, 28067, 28204, 28207, 28317, 28529, 28548, 28641, 28703, 28713, 28737, 28776, 28863, 29017, 29022, 29168, 29224, 29245, 29307, 29343, 29363, 29394, 29474, 29547, 29550, 29732, 29739, 29792, 29849, 29892, 29893, 30028, 30040, 30085, 30095, 30109, 30124, 30153, 30155, 30358, 30415, 30505, 30603, 30633, 30657, 30682, 30787, 30838, 30863, 30998, 31237, 31241, 31343, 31358, 31436, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31523, 31526, 31535, 31569, 31605, 31617, 31626, 31642, 31657, 31673, 31689, 31700, 31731, 31740, 31771, 31840, 31852, 31963, 31995, 32072, 32161, 32178, 32329, 32357, 32416, 32507, 32546, 32593, 32683, 32707, 32858, 32881, 32883, 33114, 33137, 33151, 33198, 33250, 33253, 33360, 33398, 33592, 33681, 33696, 33711, 33767, 33905, 33964, 34389, 34550, 34709, 34723, 34966, 35055, 35135, 35526, 36090, 36155, 36385, 36392, 36455, 36888, 37085, 37099, 37104, 37191, 37197, 37286, 37288, 37290, 37299, 37305, 37312, 37326, 37335, 37343, 37354, 37399, 37548, 37572, 37594, 37607, 37626, 37637, 37649, 37665, 37674, 37678, 37798, 37816, 37826, 37867, 38151, 38200, 38203, 38233, 38347, 38361, 38383, 38387, 38390, 38394, 38399, 38420, 38497, 38500, 38710, 38908, 38925, 38929, 39008, 39026, 39182, 39461, 39500, 39751, 40144, 40570, 41300, 41470, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42056, 42060, 42061, 42116, 42277, 42322, 42436, 42560, 42717, 42875, 42877, 43033, 43079, 43081, 43084, 43093, 43098, 43104, 43115, 43127, 43143, 43155, 43229, 43232, 43263, 43321, 43451, 43493, 43673, 43677, 43685, 43692, 43714, 43721, 43731, 43742, 43766, 43791, 44306, 44525, 44891, 44968, 45359, 45372, 45388, 45416, 45662, 45670, 45671, 45676, 45681, 45750, 45954, 45978, 45999, 46013, 46026, 46269, 46499, 46531, 46541, 46554, 46573, 46583, 46601, 46626, 46869, 46884, 46913, 47026, 47060, 47080, 47137, 47158, 47190, 47255, 47285, 47474, 47496, 47582, 47692, 47711, 47717, 47726, 47732, 47747, 47829, 47869, 47891, 48020, 48082, 48230, 48269, 48273, 48282, 48283, 48286, 48297, 48301, 48383, 48393, 48397, 48410, 48412, 48415, 48426, 48557, 48643, 48645, 48696, 48716, 48748, 48780, 48838, 48914, 49066, 49152, 49238, 49242, 49246, 49248, 49250, 49254, 49260, 49263, 49278, 49290, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49425, 49432, 49439, 49452, 49465, 49469, 49511, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49552, 49556, 49560, 49568, 49570, 49575, 49578, 49580, 49589, 49592, 49602, 49604, 49607, 49612, 49631, 49635, 49640, 49650, 49655, 49659, 49662, 49667, 49837, 49842, 49849, 49939, 50021, 50033, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50166, 50170, 50177, 50184, 50186, 50189, 50195, 50203, 50215, 50374, 50380, 50385, 50387, 50476, 50502, 50521, 50633, 50655, 50682, 50716, 50751, 50942, 50944, 50948, 50950, 50953, 50957, 50961, 50963, 50969, 50977, 50993, 51095, 51140, 51152, 51160, 51213, 51247, 51249, 51254, 51256, 51261, 51285, 51293, 51298, 51302, 51317, 51342, 51349, 51354, 51356, 51358, 51363, 51457, 51504, 51509, 51513, 51517, 51547, 51676, 51700, 51723, 51736, 51748, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51799, 51801, 51806, 51811, 51813, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51849, 51856, 51864, 51869, 51871, 51885, 51890, 51900, 51907, 51914, 51931, 51933, 51936, 51982, 52044, 52050, 52051, 52053, 52176, 52300, 52348, 52468) 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: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: England's Glory; or, The Defeat of the Dutch Fleet by the Gallant Admiral Duncan on the Memorable Eleventh of October

Dance: In Scene V 3rd piece: a Triple Hornpipe-Blurton, Mrs Watts, Mlle St.Amand

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Maid of the Mill

Afterpiece Title: England's Glory

Dance: As17971018

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Maid of the Mill

Afterpiece Title: England's Glory

Dance: As17971018

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: England's Glory

Dance: End II : Les Delassemens Militaires, as17971021; End 2nd piece: Peggy's Love, as17971021

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Maid of the Mill

Afterpiece Title: England's Glory

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: A Divertisement

Afterpiece Title: England's Glory

Dance: In 2nd piece: Ballet, as17971013

Performances

Mainpiece Title: Abroad And At Home

Afterpiece Title: The Irishman in London

Afterpiece Title: England's Glory

Performances

Mainpiece Title: King Henry The Fourth, First Part

Afterpiece Title: The Highland Reel

Afterpiece Title: England's Glory

Performances

Mainpiece Title: Wives As They Were, And Maids As They Are

Afterpiece Title: England's Glory

Dance: End II: Les Delassemens Militaires, as17971021; End: Cupid and Psyche (composed by Noverre)-Mrs Wild, Mme Rose, Mme Hilligsberg, Didelot, Fialon, The Graces by Mlle St.Amand, Mme D'Egville, Mlle Philips

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: A Divertisement

Afterpiece Title: England's Glory

Dance: In 2nd piece: Ballet, as17971013; In V 3rd piece: a Triple Hornpipe, as17971018

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Sealand Actor: Murray
Role: Mrs Sealand Actor: Mrs Davenport

Afterpiece Title: The Sultan

Song: In II: song-Mrs Clendining

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Sealand Actor: Murray
Role: Mrs Sealand Actor: Mrs Davenport

Afterpiece Title: Harlequin and Quixotte

Song: As17971118

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Sealand Actor: Murray
Role: Mrs Sealand Actor: Mrs Davenport

Afterpiece Title: Harlequin and Quixotte

Song: As17971118

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Sealand Actor: Murray
Role: Mrs Sealand Actor: Mrs Davenport

Afterpiece Title: Hartford Bridge

Song: As17971118

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Sea Captain Actor: Holland

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: concerto on the violoncello-C. Ashley; End II: concerto= on the Piano Forte-Dussek

Performances

Mainpiece Title: The Raft

Afterpiece Title: Douglas

Afterpiece Title: Robin Hood

Performances

Mainpiece Title: The Eccentric Lover

Cast
Role: John Seagrave Actor: Rees

Afterpiece Title: Raymond and Agnes

Dance: Afterpiece to conclude with: Dance of Savoyards-Platt, Miss Cranfield, Mlle St.Amand

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Maid of the Mill