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, 28679, 28696, 28702, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28790, 28794, 28800, 28810, 28813, 28815, 28818, 28820, 28839, 28841, 28849, 28854, 28861, 28871, 28882, 28885, 28887, 28896, 28930, 28942, 28956, 28958, 28978, 28997, 29009, 29014, 29046, 29068, 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, 29722, 29766, 29810, 29823, 29826, 29877, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29958, 29960, 29981, 30006, 30009, 30028, 30039, 30055, 30057, 30081, 30114, 30116, 30145, 30151, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30337, 30381, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30450, 30452, 30475, 30479, 30484, 30566, 30575, 30622, 30653, 30660, 30686, 30690, 30695, 30699, 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, 32644, 32653, 32666, 32671, 32676, 32678, 32680, 32693, 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, 33664, 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, 34050, 34058, 34063, 34069, 34072, 34078, 34146, 34161, 34173, 34182, 34187, 34197, 34202, 34204, 34237, 34258, 34317, 34342, 34350, 34374, 34397, 34400, 34406, 34410, 34418, 34578, 34580, 34681, 34688, 34696, 34722, 34770, 34772, 34779, 34893, 34901, 34905, 34913, 34984, 34989, 35033, 35062, 35064, 35068, 35080, 35083, 35085, 35090, 35097, 35102, 35104, 35106, 35113, 35120, 35132, 35138, 35147, 35195, 35210, 35240, 35245, 35250, 35274, 35286, 35302, 35321, 35332, 35337, 35354, 35357, 35379, 35381, 35495, 35498, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35617, 35621, 35626, 35629, 35635, 35642, 35645, 35647, 35650, 35653, 35656, 35659, 35662, 35665, 35667, 35669, 35672, 35674, 35676, 35678, 35681, 35683, 35686, 35688, 35693, 35696, 35702, 35707, 35716, 35718, 35723, 35756, 35761, 35788, 35802, 35810, 35813, 35818, 35823, 35826, 35865, 35868, 35918, 35986, 35989, 35992, 36113, 36201, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36253, 36257, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36308, 36317, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36437, 36473, 36482, 36499, 36504, 36508, 36516, 36540, 36546, 36555, 36565, 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, 37270, 37272, 37276, 37307, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37371, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37436, 37439, 37443, 37445, 37455, 37460, 37467, 37477, 37479, 37517, 37524, 37566, 37570, 37579, 37584, 37602, 37618, 37637, 37643, 37646, 37665, 37667, 37671, 37675, 37785, 37790, 37795, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37837, 37852, 37856, 37870, 37874, 37887, 37893, 37897, 37902, 37905, 37907, 37916, 37925, 37941, 37943, 37949, 37962, 38050, 38060, 38123, 38153, 38156, 38158, 38167, 38172, 38177, 38183, 38216, 38219, 38224, 38315, 38320, 38330, 38334, 38336, 38341, 38367, 38422, 38434, 38439, 38448, 38450, 38453, 38455, 38457, 38464, 38467, 38469, 38471, 38561, 38573, 38583, 38598, 38611, 38658, 38675, 38682, 38700, 38719, 38731, 38743, 38760, 43645, 43660, 43675, 43690, 43733, 43748, 43864, 44329, 45100, 45105) 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 Busy Body

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 Gamesters

Ballet: New Comic Entertainment of Dancing, call'dThe Prussian Camp. Officer-Blakes; Prussian Soldiers-the Comedians; Characters of the Dance-Delatre, Giorgi, Lucchi, Mrs Vernon. New Habits and Decorations for the Dance

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Ranger

Ballet: II: The Prussian Camp. As17571223

Performances

Mainpiece Title: The Gamesters

Ballet: End: The Prussian Camp. As17571223

Performances

Mainpiece Title: The Gamesters

Dance: II: The Italian Peasants, as17571004

Ballet: End: The Prussian Camp. As17571223

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Author

Performances

Mainpiece Title: Zara

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Author

Ballet: TThe Prussian Camp. As17571223, but Officer-_

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Chaplet