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 (28662, 28664, 28669, 28675, 28696, 28702, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28794, 28841, 28885, 28956, 29014, 29195, 29203, 29213, 29217, 29244, 29280, 29291, 29300, 29308, 29312, 29315, 29320, 29331, 29336, 29338, 29342, 29344, 29349, 29352, 29357, 29361, 29363, 29367, 29369, 29393, 29395, 29398, 29412, 29424, 29428, 29431, 29442, 29445, 29449, 29452, 29484, 29488, 29496, 29499, 29503, 29532, 29537, 29549, 29583, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30145, 30151, 30381, 30385, 30388, 30390, 30395, 30410, 30413, 30415, 30429, 30432, 30452, 30475, 30479, 30484, 30566, 30622, 30653, 30660, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30878, 30880, 30882, 30884, 30886, 30888, 30893, 30900, 30916, 30922, 30924, 30926, 30928, 30930, 30933, 30935, 30937, 30940, 30942, 30944, 30947, 30950, 30954, 30966, 30973, 30979, 30983, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31057, 31061, 31066, 31069, 31074, 31076, 31094, 31097, 31100, 31102, 31109, 31112, 31116, 31136, 31158, 31179, 31182, 31189, 31197, 31203, 31216, 31220, 31223, 31253, 31274, 31339, 31368, 31370, 31372, 31374, 31378, 31380, 31382, 31384, 31387, 31389, 31391, 31393, 31395, 31397, 31399, 31405, 31409, 31411, 31417, 31419, 31426, 31428, 31430, 31432, 31435, 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, 31513, 31515, 31517, 31519, 31523, 31526, 31531, 31533, 31535, 31537, 31542, 31556, 31569, 31605, 31611, 31614, 31617, 31620, 31626, 31629, 31632, 31636, 31642, 31648, 31657, 31671, 31673, 31686, 31689, 31700, 31703, 31715, 31718, 31725, 31731, 31740, 31747, 31753, 31761, 31767, 31771, 31773, 32319, 32321, 32325, 32329, 32334, 32339, 32342, 32346, 32348, 32350, 32352, 32356, 32358, 32364, 32366, 32382, 32384, 32390, 32393, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32452, 32454, 32459, 32464, 32466, 32493, 32523, 32526, 32546, 32558, 32653, 32666, 32671, 32676, 32678, 32680, 32704, 32708, 32720, 32722, 32724, 32729, 32734, 32748, 32807, 32813, 32815, 32817, 32822, 32827, 32830, 32832, 32834, 32836, 32838, 32840, 32842, 32846, 32848, 32850, 32852, 32854, 32856, 32858, 32860, 32862, 32864, 32866, 32868, 32870, 32872, 32874, 32876, 32878, 32882, 32884, 32886, 32888, 32890, 32892, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32933, 32935, 32944, 32949, 32953, 32956, 32958, 32960, 32962, 32966, 32969, 32972, 32974, 32976, 32978, 32981, 32983, 32985, 32987, 32989, 32991, 32994, 32996, 32999, 33003, 33005, 33008, 33010, 33012, 33017, 33020, 33022, 33024, 33026, 33029, 33031, 33034, 33039, 33042, 33045, 33092, 33103, 33106, 33108, 33110, 33116, 33121, 33134, 33136, 33145, 33150, 33158, 33166, 33172, 33179, 33183, 33193, 33195, 33260, 33265, 33267, 33269, 33271, 33273, 33275, 33277, 33285, 33287, 33289, 33291, 33295, 33297, 33300, 33304, 33344, 33346, 33348, 33353, 33362, 33364, 33369, 33372, 33374, 33378, 33381, 33383, 33386, 33390, 33402, 33428, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33486, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33570, 33572, 33585, 33589, 33604, 33617, 33620, 33622, 33626, 33647, 33659, 33673, 33693, 33700, 33710, 33719, 33725, 33792, 33798, 33800, 33802, 33804, 33806, 33808, 33810, 33814, 33819, 33821, 33823, 33825, 33829, 33831, 33833, 33837, 33839, 33841, 33843, 33849, 33875, 33882, 33889, 33898, 33903, 33905, 33907, 33917, 33919, 33921, 33924, 33929, 33933, 33962, 33969, 33972, 34014, 34017, 34040, 34063, 34069, 34072, 34078, 34146, 34161, 34173, 34182, 34187, 34204, 34237, 34258, 34374, 34397, 34400, 34406, 34410, 34418, 34578, 34681, 34688, 34696, 34722, 34770, 34772, 34779, 34893, 34984, 35033, 35064, 35104, 35210, 35337, 35379, 35495, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35617, 35621, 35626, 35629, 35635, 35642, 35645, 35647, 35650, 35653, 35656, 35659, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35683, 35686, 35688, 35693, 35696, 35702, 35707, 35718, 35723, 35756, 35761, 35788, 35802, 35810, 35813, 35818, 35823, 35826, 35865, 35918, 35989, 36113, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36253, 36257, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36308, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36482, 36504, 36540, 36546, 36636, 36649, 36651, 36653, 36673, 36688, 36696, 36704, 36710, 36714, 36717, 36738, 36750, 36752, 36756, 36764, 36773, 36784, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36834, 36837, 36839, 36844, 36846, 36850, 36853, 36855, 36860, 36878, 36881, 36883, 36890, 36897, 36902, 36904, 36906, 36914, 36925, 36955, 36957, 37028, 37044, 37080, 37094, 37119, 37124, 37212, 37216, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37253, 37257, 37264, 37272, 37276, 37307, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37436, 37439, 37443, 37445, 37455, 37460, 37467, 37477, 37479, 37517, 37524, 37570, 37579, 37584, 37602, 37618, 37637, 37643, 37646, 37671, 37795, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37852, 37856, 37870, 37874, 37887, 37893, 37897, 37902, 37905, 37907, 37941, 37943, 37949, 37962, 38050, 38123, 38153, 38156, 38158, 38167, 38172, 38183, 38219, 38422, 38434, 38439, 38457, 38561, 38658, 38675, 38700, 38760, 43645, 43660, 43675, 43690, 43733, 43748, 43864) 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 Tempest

Afterpiece Title: The Author

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Author

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Dance: I: The Market, as17571126

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Englishman in Paris

Dance: End: A new Grand Dance-the Children; End Farce: Minuet-Leviez, Miss Macklin

Performances

Mainpiece Title: The Tempest

Cast
Role: Actor: Giorgi, Sga Lucchi, others.

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: Comus

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Comus

Afterpiece Title: The Diversions of the Morning

Performances

Mainpiece Title: The Tempest

Cast
Role: Actor: Giorgi, Sga Lucchi, others.

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Queen Mab

Song: III: A Cantata-Miss Young

Ballet: II: The Prussian Camp (an Entertainment). Officer-Blakes; Prussian Soldiers-the comedians; Characters of the dance-Grimaldi, Giorgi, Sga Lucchi, Mrs Vernon