The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (1497, 15597, 18193, 18196, 18377, 18380, 18383, 18503, 18515, 18519, 18673, 18686, 18723, 18920, 18922, 18928, 18930, 18975, 19064, 19067, 19069, 19072, 19074, 19079, 19092, 19100, 19102, 19105, 19164, 19462, 19775, 19777, 19779, 19781, 19784, 19786, 19789, 19791, 19799, 19801, 19850, 20002, 20053, 20166, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20242, 20248, 20307, 20311, 20317, 20324, 20326, 20327, 20441, 20468, 20488, 20495, 20499, 20502, 20521, 20613, 20778, 20781, 20920, 20964, 20973, 21010, 21057, 21079, 21196, 21202, 21273, 21298, 21532, 21610, 21671, 21744, 21847, 21900, 21902, 21905, 21907, 21923, 21942, 21979, 22005, 22008, 22010, 22013, 22019, 22022, 22027, 22032, 22034, 22046, 22051, 22053, 22066, 22118, 22192, 22219, 22320, 22335, 22400, 22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22759, 22833, 22834, 22848, 22863, 22874, 22883, 22903, 22920, 22927, 22951, 22954, 22966, 22969, 22990, 22992, 22994, 22995, 22997, 23001, 23003, 23059, 23062, 23071, 23080, 23100, 23103, 23110, 23113, 23119, 23125, 23139, 23142, 23143, 23168, 23171, 23175, 23178, 23186, 23206, 23207, 23214, 23215, 23216, 23219, 23225, 23238, 23254, 23413, 23417, 23528, 23588, 23599, 23605, 23608, 23618, 23660, 23707, 23768, 23837, 24145, 24169, 24222, 24262, 24455, 24458, 24461, 24467, 24469, 24896, 24897, 24909, 25023, 25096, 25193, 25219, 25237, 25238, 25250, 25260, 25686, 26052, 26257, 26259, 26261, 26264, 26266, 26268, 26271, 26273, 26275, 26278, 26281, 26283, 26285, 26288, 26290, 26293, 26295, 26297, 26368, 26371, 26373, 26376, 26378, 26381, 26383, 26386, 26388, 26396, 26398, 26401, 26403, 26406, 26408, 26413, 26416, 26418, 26421, 26423, 26426, 26429, 26431, 26434, 26599, 26624, 26626, 26744, 26763, 26768, 27349, 27351, 27354, 27385, 27446, 27473, 27553, 27571, 27770, 27775, 27779, 27784, 27788, 27789, 27795, 27813, 27817, 27819, 27822, 27829, 27905, 27934, 27940, 27954, 27965, 28083, 28092, 28766, 28927, 29032, 29503, 29823, 29826, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29922, 29925, 29928, 29930, 29933, 29935, 29939, 29942, 29944, 29950, 29953, 29955, 29957, 29959, 29963, 29966, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30049, 30053, 30069, 30076, 30126, 30144, 30148, 30152, 30297, 30383, 30385, 30388, 30390, 30395, 30413, 30415, 30429, 30432, 30444, 30452, 30475, 30479, 30567, 30602, 30603, 30608, 30615, 30627, 30648, 30681, 30684, 30692, 30833, 30897, 31152, 31163, 31221, 31406, 31408, 31410, 31412, 31416, 31425, 31429, 31436, 31438, 31452, 31456, 31460, 31463, 31501, 31503, 31516, 31520, 31524, 31530, 31532, 31534, 31536, 31541, 31547, 31570, 31575, 31584, 31588, 31592, 31600, 31606, 31630, 31643, 31661, 31668, 31697, 31704, 31746, 31774, 31868, 31876, 31884, 31936, 31940, 31947, 31956, 31961, 31970, 31975, 31986, 31988, 31989, 31990, 31991, 31993, 31995, 31998, 32000, 32003, 32005, 32007, 32009, 32012, 32014, 32017, 32019, 32021, 32023, 32026, 32028, 32030, 32032, 32034, 32036, 32039, 32041, 32045, 32047, 32049, 32051, 32054, 32057, 32059, 32061, 32063, 32066, 32068, 32078, 32083, 32090, 32095, 32097, 32099, 32102, 32106, 32114, 32131, 32205, 32224, 32253, 32381, 32543, 32545, 32547, 32550, 32552, 32555, 32557, 32559, 32561, 32564, 32566, 32569, 32571, 32576, 32581, 32585, 32589, 32594, 32598, 32601, 32604, 32606, 32610, 32617, 32624, 32627, 32649, 32666, 32667, 32689, 32711, 32713, 32722, 32725, 32744, 32882, 32884, 32892, 32935, 32944, 32949, 32956, 32958, 32960, 32962, 33108, 33136, 33173, 33362, 33363, 33364, 33365, 33368, 33369, 33370, 33372, 33373, 33374, 33375, 33377, 33379, 33381, 33384, 33386, 33389, 33390, 33393, 33396, 33398, 33401, 33403, 33407, 33419, 33436, 33440, 33442, 33444, 33447, 33449, 33452, 33454, 33475, 33477, 33482, 33484, 33490, 33492, 33498, 33525, 33526, 33530, 33531, 33538, 33539, 33551, 33553, 33558, 33560, 33563, 33571, 33573, 33581, 33586, 33589, 33593, 33602, 33614, 33617, 33626, 33658, 33664, 33672, 33674, 33684, 33711, 33792, 33800, 33837, 33962, 33972, 34014, 34063, 34078, 34161, 34224, 34317, 34344, 34346, 34681, 34732, 34751, 34761, 34779, 34965, 34979, 34993, 35007, 35021, 35067, 35069, 35071, 35073, 35076, 35077, 35095, 35098, 35100, 35229, 35273, 35337, 35379, 35498, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35543, 35551, 35558, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35629, 35635, 35642, 35667, 35676, 35683, 35716, 35756, 35768, 35773, 35780, 35818, 35823, 35826, 35865, 35868, 35918, 35986, 35992, 36182, 36185, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36219, 36220, 36222, 36224, 36226, 36228, 36233, 36257, 36283, 36285, 36288, 36290, 36292, 36299, 36306, 36311, 36316, 36325, 36327, 36363, 36546, 36553, 36693, 37253, 37257, 37264, 37276, 37307, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37440, 37442, 37444, 37458, 37461, 37463, 37466, 37468, 37471, 37473, 37476, 37496, 37504, 37511, 37515, 37518, 37520, 37529, 37541, 37566, 37567, 37573, 37602, 37609, 37617, 37618, 37647, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38097, 38338, 38346, 38350, 38352, 38354, 38362, 38365, 38368, 38370, 38377, 38379, 38416, 38430, 38434, 38439, 38444, 38457, 38458, 38465, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38561, 38562, 38569, 38579, 38584, 38612, 38658, 38675, 38700, 38760, 50255, 50261) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Prometheus

Performances

Mainpiece Title: Douglas

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Prometheus

Dance: IV: The Italian Gardeners, as17751011

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Spanish Lady

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Waterman

Song: V: (By Desire) The Soldier Tir'd-Miss Abrams

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17751003

Performances

Mainpiece Title: Antigona

Dance: End I: a new Ballet in one act, Flore et Zephire-Didelot, Gentili, Fialon, Lahante, Hamoir, Giani, Roffey, Simpson, Master Menage, Mme Rose, Mme Hilligsberg, Mme Bossi, Mlle Parisot, Mme Vidi, Mlle Cabanel [Cast from Beaumont (see below): Cleonise-Mme Hilligsberg; +Flore-Mme Rose; +Bergeres-Mlle Parisot, Mme Bossi; +Zephire-Didelot; +L'Amour-Master Menage; +Un Petit Amour-Miss Hill.]; End Opera: [a new grand Dramatic Ballet in 3 acts, in the +Scotch style, L'Heureux Naufrage [; or, Les Sorcieres Ecossoises; Principal Performers in both dances-Didelot, Gentili, Fialon, Lahante, Hamoir, Giani, Roffey, Simpson, Master Menage, Mme Rose, Mme Hilligsberg, Mme Bossi, Mlle Parisot, Mme Vidi, Mlle Cabanel

Performances

Mainpiece Title: Antigona

Dance: Flore et Zephire, as17960707 but _Fialon, _Lahante, _Hamoir, _Giani, _Roffey, _Simpson, Master _Menage, Mme _Vidi, Mlle _Cabanel; L'Heureux Naufrage, as17960707 but _Fialon, _Lahante, _Hamoir, _Giani, _Roffey, _Simpson, Master _Menage, Mme _Vidi, Mlle _Cabanel