SELECT * FROM london_stages WHERE eventid IN (1996, 27268, 27310, 27313, 27315, 27319, 27328, 27335, 27412, 27524, 27609, 28245, 28247, 28249, 28251, 28255, 28258, 28260, 28265, 28271, 28283, 28329, 28331, 28334, 28338, 28352, 28683, 29488, 29508, 29587, 29590, 29637, 32549, 32551, 32856, 32866, 32898, 32924, 32947, 32951, 32960, 32978, 32989, 32994, 33003, 33012, 33024, 33036, 33039, 33092, 33110, 33116, 33124, 33143, 33150, 33163, 33174, 33179, 33218, 33219, 33224, 33225, 33226, 33230, 33231, 33232, 33235, 33236, 33237, 33238, 33239, 33240, 33241, 33242, 33243, 33244, 33245, 33247, 33248, 33249, 33250, 33251, 33252, 33253, 33254, 33255, 33256, 33257, 33291, 33293, 33302, 33315, 33327, 33336, 33341, 33350, 33353, 33355, 33364, 33374, 33383, 33386, 33388, 33392, 33397, 33414, 33435, 33437, 33483, 33512, 33526, 33538, 33595, 33622, 33633, 33640, 33642, 33659, 33673, 33676, 33681, 33698, 33788, 33791, 33792, 33804, 33810, 33829, 33833, 33843, 33847, 33849, 33853, 33855, 33857, 33860, 33862, 33864, 33866, 33873, 33875, 33884, 33887, 33893, 33898, 33912, 33919, 33924, 33935, 33950, 33969, 33974, 33976, 33978, 33980, 33982, 33984, 33986, 33989, 33991, 33994, 33998, 34000, 34003, 34005, 34010, 34017, 34040, 34043, 34050, 34055, 34058, 34067, 34097, 34102, 34107, 34112, 34117, 34122, 34132, 34141, 34144, 34151, 34155, 34158, 34166, 34168, 34173, 34175, 34178, 34182, 34194, 34197, 34199, 34202, 34204, 34207, 34209, 34212, 34214, 34222, 34224, 34232, 34246, 34249, 34252, 34258, 34261, 34328, 34339, 34346, 34348, 34353, 34369, 34374, 34376, 34379, 34381, 34383, 34391, 34393, 34395, 34397, 34400, 34404, 34406, 34410, 34412, 34414, 34418, 34421, 34423, 34426, 34440, 34461, 34465, 34479, 34484, 34496, 34498, 34505, 34507, 34510, 34513, 34516, 34518, 34520, 34527, 34529, 34531, 34533, 34538, 34543, 34547, 34555, 34561, 34571, 34573, 34575, 34578, 34585, 34587, 34589, 34592, 34600, 34611, 34641, 34681, 34688, 34696, 34706, 34714, 34722, 34734, 34736, 34753, 34770, 34772, 34775, 34779, 34781, 34784, 34795, 34812, 34887, 34893, 34897, 34911, 34913, 34919, 34921, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34963, 34966, 34968, 34970, 34972, 34975, 34977, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35008, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35036, 35038, 35040, 35042, 35045, 35048, 35051, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35085, 35088, 35092, 35094, 35097, 35104, 35106, 35108, 35111, 35118, 35120, 35122, 35125, 35127, 35129, 35132, 35135, 35143, 35149, 35160, 35164, 35169, 35172, 35174, 35177, 35179, 35182, 35184, 35187, 35202, 35207, 35210, 35213, 35218, 35223, 35227, 35230, 35235, 35243, 35255, 35264, 35272, 35274, 35277, 35289, 35292, 35296, 35299, 35305, 35316, 35324, 35330, 35337, 35340, 35343, 35345, 35351, 35357, 35360, 35365, 35368, 35372, 35375, 35379, 35381, 35382, 35495, 35506, 35508, 35513, 35518, 35520, 35522, 35524, 35547, 35549, 35560, 35566, 35568, 35573, 35577, 35579, 35581, 35583, 35587, 35589, 35592, 35595, 35603, 35615, 35621, 35629, 35635, 35642, 35656, 35659, 35683, 35691, 35693, 35699, 35714, 35756, 35810, 35818, 35823, 35826, 35844, 35856, 35865, 35868, 35876, 35879, 35889, 35907, 35910, 35918, 35922, 35924, 35932, 35943, 35947, 35967, 35981, 35989, 35997, 36113, 36115, 36118, 36129, 36135, 36145, 36147, 36153, 36166, 36168, 36174, 36184, 36193, 36195, 36199, 36203, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36246, 36248, 36253, 36257, 36266, 36275, 36289, 36291, 36303, 36308, 36333, 36343, 36370, 36372, 36374, 36376, 36379, 36384, 36388, 36391, 36398, 36403, 36406, 36429, 36434, 36440, 36460, 36465, 36490, 36499, 36504, 36506, 36518, 36523, 36529, 36532, 36546, 36552, 36558, 36564, 36568, 36636, 36655, 36657, 36663, 36665, 36667, 36671, 36678, 36680, 36686, 36690, 36694, 36696, 36702, 36704, 36717, 36719, 36724, 36738, 36745, 36752, 36761, 36766, 36768, 36778, 36793, 36795, 36802, 36830, 36832, 36837, 36839, 36841, 36862, 36868, 36878, 36881, 36900, 36902, 36904, 36969, 36988, 36990, 37002, 37005, 37018, 37021, 37033, 37036, 37041, 37046, 37049, 37058, 37071, 37073, 37076, 37080, 37091, 37098, 37107, 37119, 37212, 37223, 37225, 37227, 37231, 37249, 37253, 37255, 37260, 37264, 37266, 37268, 37274, 37276, 37278, 37280, 37282, 37284, 37292, 37294, 37303, 37307, 37310, 37315, 37317, 37324, 37333, 37338, 37340, 37345, 37352, 37357, 37361, 37366, 37368, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37436, 37439, 37443, 37451, 37455, 37460, 37465, 37467, 37470, 37479, 37517, 37528, 37531, 37533, 37540, 37545, 37570, 37584, 37597, 37606, 37611, 37618, 37621, 37630, 37632, 37637, 37646, 37651, 37659, 37662, 37671, 37680, 37774, 37778, 37781, 37783, 37785, 37787, 37790, 37793, 37797, 37803, 37805, 37809, 37813, 37815, 37817, 37819, 37821, 37825, 37827, 37829, 37831, 37833, 37835, 37837, 37839, 37841, 37843, 37852, 37856, 37860, 37864, 37870, 37874, 37880, 37882, 37887, 37889, 37893, 37902, 37905, 37911, 37916, 37925, 37928, 37930, 37935, 37937, 37941, 37943, 37947, 37949, 37951, 37962, 37969, 37982, 37996, 38030, 38032, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38078, 38083, 38088, 38091, 38093, 38097, 38105, 38107, 38112, 38118, 38123, 38143, 38151, 38153, 38158, 38160, 38167, 38172, 38175, 38177, 38180, 38183, 38190, 38192, 38197, 38202, 38210, 38216, 38224, 38227, 38233, 38315, 38323, 38325, 38329, 38330, 38332, 38334, 38341, 38345, 38353, 38371, 38373, 38376, 38378, 38381, 38383, 38385, 38387, 38390, 38394, 38396, 38399, 38404, 38407, 38410, 38420, 38427, 38429, 38436, 38441, 38450, 38455, 38459, 38462, 38467, 38469, 38473, 38477, 38485, 38488, 38494, 38496, 38500, 38502, 38523, 38551, 38563, 38568, 38570, 38573, 38593, 38619, 38644, 38663, 38678, 38682, 38689, 38709, 38711, 38714, 38719, 38724, 38726, 38736, 38741, 38743, 38745, 38748, 38758, 38760, 38766, 38768, 38778, 38794, 38796, 38798, 38864, 38879, 38885, 38888, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38918, 38920, 38924, 38926, 38928, 38934, 38937, 38939, 38944, 38946, 38948, 38953, 38960, 38965, 38970, 38976, 38979, 38982, 38984, 38988, 39003, 39006, 39008, 39015, 39022, 39024, 39026, 39028, 39032, 39036, 39038, 39041, 39043, 39045, 39049, 39051, 39054, 39058, 39065, 39067, 39072, 39074, 39078, 39083, 39088, 39090, 39093, 39095, 39098, 39104, 39107, 39121, 39123, 39142, 39149, 39171, 39177, 39181, 39202, 39210, 39213, 39225, 39234, 39236, 39245, 39253, 39257, 39260, 39262, 39265, 39268, 39270, 39280, 39285, 39291, 39308, 39312, 39324, 39337, 39341, 39347, 39449, 39451, 39453, 39457, 39460, 39465, 39472, 39476, 39480, 39493, 39497, 39499, 39502, 39511, 39527, 39532, 39539, 39546, 39550, 39555, 39558, 39564, 39567, 39572, 39578, 39581, 39583, 39588, 39590, 39592, 39595, 39605, 39607, 39609, 39611, 39613, 39618, 39632, 39651, 39657, 39660, 39663, 39668, 39670, 39673, 39675, 39678, 39680, 39684, 39687, 39690, 39693, 39695, 39704, 39709, 39713, 39716, 39729, 39759, 39769, 39789, 39791, 39843, 39847, 39852, 39854, 39857, 39861, 39871, 39873, 39888, 39902, 40023, 40025, 40027, 40041, 40043, 40050, 40056, 40058, 40062, 40066, 40074, 40082, 40086, 40090, 40094, 40096, 40098, 40106, 40113, 40143, 40148, 40150, 40157, 40159, 40162, 40164, 40169, 40172, 40175, 40178, 40187, 40189, 40196, 40198, 40201, 40204, 40211, 40213, 40216, 40225, 40230, 40235, 40244, 40253, 40256, 40258, 40264, 40266, 40269, 40271, 40278, 40281, 40284, 40304, 40334, 40337, 40339, 40344, 40352, 40357, 40371, 40376, 40381, 40386, 40390, 40412, 40415, 40419, 40427, 40440, 40443, 40445, 40449, 40459, 40460, 40463, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40633, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40682, 40699, 40713, 40718, 40722, 40742, 40745, 40749, 40757, 40760, 40766, 40778, 40800, 40803, 40858, 40869, 40879, 40881, 40883, 40890, 40899, 40904, 40909, 40919, 40921, 40930, 40935, 40940, 40945, 40952, 40955, 40973, 40984, 40991, 40993, 40996, 40998, 41003, 41459, 41719, 47051, 47111, 47121, 47125, 47136, 47141, 47153, 47158, 47170, 47176, 47189, 47195, 47198, 47214, 47244, 47259, 47283, 47289, 47301, 47309, 47326, 47441, 47444, 47474, 47475, 47478, 47482, 47559, 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, 47665, 47678, 47688, 47690, 47709, 47724, 47800, 47805, 47820, 47835, 47867, 47997, 47999, 48002, 48006, 48010, 48012, 48015, 48023, 48026, 48028, 48029, 48032, 48038, 48043, 48049, 48080, 48090, 48093, 48095, 48097, 48103, 48105, 48109, 48129, 48133, 48135, 48148, 48150, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48170, 48172, 48174, 48178, 48180, 48182, 48192, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48280, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48341, 48347, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48380, 48382, 48396, 48404, 48409, 48430, 48437, 48439, 48440, 48444, 48447) 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: Hamlet

Cast
Role: King Actor: Hurst

Afterpiece Title: The Critic

Entertainment: Imitations. End II: contrasted vocal Imitations in the Italian and English stile-Bannister; End V: a variety of Imitations-Bannister Jun

Performances

Mainpiece Title: The Tempest

Cast
Role: Antonio Actor: Hurst

Afterpiece Title: The Jubilee

Dance: I: Dance of Spirits, as17791103; III: Dance of Fantastic Spirits, as17791103; IV: Dance, as17791103, but Delpini, Miss +Armstrong

Performances

Mainpiece Title: Macbeth

Cast
Role: Duncan Actor: Hurst

Afterpiece Title: Selima And Azor

Song: With the original Music composed by Matthew Locke, with full Chorusses and additional accompaniments,-Bannister, Gaudry, Chaplin, Fawcett, Holcroft, Philimore, Kenny, Miss Simson, Miss Abrams, Mrs Love, Mrs Davenett, Mrs Smith, Miss Kirby, Mrs Gaudry, Miss Collett; End I: song-Miss Wright

Performances

Mainpiece Title: Every Man In His Humour

Cast
Role: Downright Actor: Hurst

Afterpiece Title: Who's The Dupe

Dance: As17791215

Song: End IV: As17800411

Performances

Mainpiece Title: As You Like It

Cast
Role: Duke Senior Actor: Hurst

Afterpiece Title: Fortunatus

Dance: End I: a new Comic Pantomime Dance, The Savoyards-Delpini, Sga Crespi, Henry, Miss Armstrong; End IV: Minuet, Allemande-Delpini, Sga Crespi

Performances

Mainpiece Title: Macbeth

Cast
Role: Duncan Actor: Hurst

Afterpiece Title: The Artifice

Song: As17800426

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Norfolk Actor: Hurst

Afterpiece Title: Fortunatus

Entertainment: Vaudeville. Jump through a Tub of Fire, as17800509, but _Wright, Spencer

Performances

Mainpiece Title: The Winter's Tale

Cast
Role: Cleomines Actor: Hurst

Afterpiece Title: The Critic

Dance: As17791126

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Traverse Actor: Hurst.

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The First Part Of King Henry Iv

Cast
Role: Blunt Actor: Hurst

Afterpiece Title: The Quaker

Performances

Mainpiece Title: The Winter's Tale

Cast
Role: Cleomines Actor: Hurst

Afterpiece Title: The Miniature Picture

Dance: II: New Dance, as17791126; End II afterpiece: The Coopers, as17800224

Performances

Mainpiece Title: Every Man In His Humour

Cast
Role: Downright Actor: Hurst

Afterpiece Title: High Life below Stairs

Dance: End: Dance, as17791122; II afterpiece: Mock Minuet, as17791208

Performances

Mainpiece Title: The Miniature Picture

Cast
Role: Cleomines Actor: Hurst

Afterpiece Title: The Critic

Dance: As17791220

Performances

Mainpiece Title: Love And A Bottle

Cast
Role: Leanthe Actor: Miss Hurst

Afterpiece Title: The Padlock

Dance: End: Minuet de la Cour, Allemande-Master Byrne, Miss Byrne

Song: End I, IV: a variety of select Catches and Glees-

Performances

Mainpiece Title: The Artifice

Cast
Role: Louisa Actor: Miss Hurst

Afterpiece Title: The Ghost

Song: End of mainpiece Auld Robin Gray by Miss Lyon

Performances

Mainpiece Title: The School For Arrogance

Afterpiece Title: The Padlock

Cast
Role: Leonora Actor: Miss Broadhurst

Performances

Mainpiece Title: A Grand Selection 0 From The Works Of Handel

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: Judas Maccabaeus; Grand Selection 0

Performances

Mainpiece Title: Redemption, Selected From The Great And Favourite Works Of handel That Were Performed In westminster-abbey And At The pantheon [on 26 And 27 May 1784] 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End: concerto on the hautboy-W. Parke; End II: concerto violin-Master Clement

Performances

Mainpiece Title: A Grand Selection 0 From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End I: concerto on the bassoon-Parkinson; End II: concerto violin-Master Clement

Performances

Mainpiece Title: Acis And Galatea 0; Grand Selection 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: PART III

Music: As17910323

Performances

Mainpiece Title: The Messiah

Song: End I: Da forte morir sapro-Miss Davies (Sarti)

Music: End II: concerto violin-Master Clement

Performances

Mainpiece Title: Redemption 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17910330