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 (33689, 34185, 34205, 34238, 34266, 34725, 34730, 34733, 34735, 34748, 34752, 34757, 34766, 34776, 35622, 35643, 35884, 35946, 36478, 36483, 36512, 36524, 36536, 36556, 36697, 36699, 36711, 36713, 36718, 36727, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36840, 36842, 36845, 36847, 36849, 36851, 36854, 36859, 36861, 36867, 36872, 36874, 36876, 36889, 36896, 36898, 36903, 36905, 36910, 36958, 36970, 36981, 36989, 37029, 37037, 37045, 37047, 37056, 37061, 37064, 37067, 37077, 37079, 37086, 37099, 37108, 37120, 37219, 37222, 37226, 37240, 37242, 37289, 37302, 37318, 37320, 37325, 37327, 37330, 37332, 37334, 37339, 37348, 37355, 37358, 37379, 37381, 37401, 37415, 37423, 37546, 37549, 37575, 37580, 37583, 37590, 37593, 37619, 37624, 37631, 37641, 37672, 37674, 37818, 37822, 37836, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38071, 38422, 38434, 38439, 38448, 38457, 38464, 38561, 38658, 38675, 38700, 38703, 38731, 39308, 41507, 41509, 41514, 41522, 41531, 41538, 41548, 41568, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44469, 44608, 44632, 44664, 44674, 44676, 44805, 44810, 44813, 44815, 44817, 44822, 44828, 44831, 44836, 44840, 44844, 44847, 44857, 44860, 44874, 44880, 44897, 44903, 44907, 44917, 44927, 44949, 44955, 44964, 44966, 45032, 45333, 45384, 45436, 45438, 45442, 45449, 45451, 45461, 45464, 45469, 45477, 45482, 45511, 45517, 45526, 45529, 45534, 45539, 45554, 45559, 45567, 45582, 45587, 45589, 45591, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46040, 46171, 46174, 46271, 46273, 46284, 46292, 46299, 46303, 46309, 46311, 46323, 46331, 46336, 46357, 46359, 46361, 46369, 46373, 46383, 46389, 46393, 46397, 46401, 46403, 46427, 46431, 46441, 46452, 46455, 46481, 46506, 46509, 46524, 46543, 46552, 46564, 46580, 46585, 46590, 46607, 46609, 46612, 46614, 46622, 46634, 46637, 46639, 46657, 46676, 46688, 46695, 46697, 46708, 46716, 46718, 46732, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46909, 46951, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47043, 47047, 47051, 47053, 47057, 47063, 47068, 47073, 47079, 47081, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47186, 47198, 47202, 47204, 47220, 47235, 47247, 47253, 47264, 47270, 47289, 47291, 47309, 47314, 47320, 47326, 47474, 47475, 47478, 47482, 47484, 47485, 47493, 47495, 47497, 47507, 47513, 47515, 47519, 47527, 47531, 47537, 47539, 47543, 47549, 47555, 47561, 47564, 47566, 47568, 47575, 47580, 47603, 47643, 47645, 47651, 47655, 47657, 47672, 47676, 47680, 47683, 47685, 47737, 47752, 47779, 47782, 47787, 47797, 47803, 47810, 47813, 47825, 47828, 47838, 47843, 47858, 47865, 47872, 47892, 48038, 48041, 48043, 48049, 48080, 48090, 48109, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48192, 48264, 48278, 48285, 48289, 48294, 48299, 48341, 48344, 48347, 48349, 48352, 48356, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48382, 48386, 48389, 48391, 48396, 48398, 48402, 48407, 48413, 48416, 48418, 48421, 48427, 48437, 48443, 48551, 48553, 48611, 48631, 48643, 48645, 48667, 48724, 48735, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48824, 48826, 48828, 48830, 48835, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 48995, 49000, 49004, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49051, 49053, 49056, 49061, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49193, 49199, 49206, 49214, 49216, 49222, 49226, 49244, 49270, 49343, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49472, 49478, 49485, 49490, 49495, 49500, 49504, 49507, 49509, 49513, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49563, 49599, 49620, 49646, 49657, 49664, 49766, 49775, 49779, 49780, 49783, 49791, 49794, 49799, 49801, 49803, 49805, 49809, 49813, 49815, 49817, 49821, 49823, 49825, 49827, 49829, 49831, 49833, 49835, 49837, 49839, 49841, 49843, 49845, 49847, 49849, 49851, 49855, 49859, 49863, 49867, 49869, 49871, 49875, 49877, 49879, 49881, 49883, 49886, 49891, 49893, 49897, 49919, 49926, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50113, 50116, 50118, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50177, 50179, 50184, 50186, 50189, 50193, 50195, 50198, 50203, 50215, 50330, 50332, 50352, 50353, 50356, 50358, 50360, 50361, 50366, 50368, 50374, 50378, 50380, 50385, 50387, 50389, 50398, 50400, 50402, 50404, 50406, 50410, 50414, 50416, 50418, 50420, 50422, 50424, 50428, 50430, 50433, 50435, 50438, 50440, 50442, 50444, 50447, 50449, 50452, 50454, 50456, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50517, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50623, 50626, 50628, 50632, 50635, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50688, 50690, 50693, 50695, 50697, 50699, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50731, 50736, 50742, 50744, 50747, 50762, 50764, 50767, 50769, 50772, 50777, 50784, 50790, 50795, 50802, 50805, 50812, 50932, 50936, 50940, 50959, 50965, 50971, 50975, 50987, 50991, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51130, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51175, 51179, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51247, 51249, 51254, 51256, 51266, 51268, 51273, 51277, 51283, 51285, 51293, 51298, 51304, 51312, 51314, 51329, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51370, 51481, 51488, 51496, 51503, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51603, 51617, 51624, 51629, 51634, 51643, 51648, 51655, 51659, 51662, 51664, 51667, 51669, 51671, 51673, 51676, 51678, 51681, 51686, 51691, 51694, 51697, 51699, 51701, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51767, 51794, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51841, 51866, 51895, 51907, 51909, 51914, 51933, 51936, 52060, 52066, 52072, 52077, 52093, 52097, 52099, 52106, 52108, 52110, 52122, 52128, 52200, 52202, 52216, 52274, 52277, 52289, 52294, 52296, 52303, 52317, 52329, 52331, 52335, 52338, 52341, 52343, 52347, 52350, 52353, 52359, 52365, 52367, 52374, 52377, 52379, 52383, 52386, 52389, 52394, 52396, 52398, 52403, 52405, 52408, 52413, 52418, 52420, 52425, 52429, 52432, 52437, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52461, 52466, 52473, 52476, 52481, 52483, 52490, 52497, 52499, 52504, 52506, 52509, 52511) 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

Afterpiece Title: Daphne and Amintor

Dance: III: A New Ballet-Mr Asselin, his first appearance in this kingdom, Miss Valois, Miss Twist

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: Daphne and Amintor

Dance: IV: The Merry Sailors, as17721012

Monologue: 1772 11 12 Before: (By particular desire) New Occasional Prelude. As 27 Oct

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: The Miser

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Sorcerer

Dance: II: The Merry Sailors, as17721012

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Rule A Wife

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: King Henry V

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: The Fox

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Elfrida

Afterpiece Title: Harlequin Sorcerer

Monologue: Before the Play: (By desire) New Occasional Prelude. As 27 Oct. 1772

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Love's Last Shift

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: Elfrida

Afterpiece Title: Harlequin Sorcerer

Monologue: Before: By particular desire, New Occasional Prelude. As 27 Oct. 1772, but Author-Hamilton

Performances

Mainpiece Title: The Fox

Afterpiece Title: Harlequin Sorcerer