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 (44589, 44591, 44593, 44597, 44599, 44612, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44634, 44636, 44641, 44647, 44650, 44652, 44656, 44668, 44672, 44684, 44688, 44692, 44698, 44703, 44705, 44708, 44710, 44712, 44717, 44723, 44737, 44755, 44762, 44778, 44783, 44785, 44791, 44796, 44799, 44801, 44805, 44808, 44810, 44813, 44815, 44817, 44822, 44828, 44831, 44836, 44840, 44844, 44847, 44857, 44860, 44874, 44880, 44887, 44891, 44897, 44903, 44907, 44911, 44915, 44917, 44920, 44922, 44927, 44936, 44939, 44941, 44944, 44946, 44949, 44952, 44955, 44957, 44964, 44966, 44971, 44973, 44978, 44980, 44986, 45004, 45011, 45013, 45016, 45020, 45022, 45025, 45030, 45032, 45035, 45037, 45041, 45047, 45135, 45141, 45145, 45147, 45152, 45156, 45158, 45159, 45162, 45164, 45166, 45167, 45169, 45171, 45174, 45176, 45178, 45180, 45182, 45184, 45188, 45192, 45194, 45196, 45198, 45204, 45206, 45208, 45212, 45214, 45216, 45218, 45220, 45222, 45226, 45228, 45232, 45234, 45240, 45244, 45248, 45252, 45255, 45257, 45262, 45264, 45266, 45269, 45271, 45274, 45280, 45285, 45291, 45297, 45302, 45305, 45307, 45321, 45330, 45333, 45338, 45342, 45344, 45356, 45361, 45369, 45384, 45394, 45399, 45407, 45412, 45420, 45423, 45425, 45433, 45436, 45438, 45442, 45449, 45454, 45461, 45464, 45469, 45480, 45482, 45490, 45495, 45497, 45500, 45502, 45504, 45506, 45511, 45517, 45519, 45526, 45529, 45534, 45537, 45539, 45542, 45544, 45549, 45552, 45554, 45559, 45562, 45567, 45569, 45574, 45589, 45591, 45700, 45706, 45711, 45714, 45717, 45722, 45731, 45745, 45752, 45758, 45759, 45767, 45795, 45797, 45799, 45801, 45805, 45821, 45835, 45840, 45842, 45848, 45862, 45866, 45869, 45878, 45885, 45888, 45892, 45899, 45928, 45948, 45971, 45984, 45988, 45997, 46020, 46033, 46040, 46042, 46045, 46050, 46060, 46065, 46073, 46075, 46090, 46095, 46098, 46103, 46112, 46118, 46124, 46130, 46133, 46151, 46169, 46171, 46174, 46176, 46262, 46271, 46275, 46277, 46279, 46281, 46284, 46286, 46287, 46289, 46292, 46294, 46295, 46297, 46301, 46305, 46307, 46311, 46313, 46315, 46317, 46321, 46325, 46327, 46333, 46338, 46341, 46343, 46347, 46351, 46355, 46359, 46363, 46365, 46367, 46373, 46377, 46381, 46383, 46385, 46387, 46391, 46395, 46399, 46411, 46413, 46415, 46423, 46427, 46431, 46436, 46441, 46443, 46448, 46450, 46455, 46462, 46464, 46469, 46471, 46476, 46478, 46481, 46483, 46488, 46490, 46492, 46495, 46500, 46502, 46504, 46506, 46509, 46511, 46519, 46522, 46524, 46533, 46536, 46543, 46550, 46552, 46564, 46580, 46590, 46593, 46595, 46598, 46600, 46602, 46604, 46612, 46614, 46617, 46622, 46627, 46632, 46634, 46637, 46639, 46644, 46647, 46649, 46652, 46654, 46657, 46663, 46668, 46671, 46678, 46681, 46683, 46688, 46691, 46695, 46697, 46702, 46705, 46716, 46721, 46723, 46725, 46728, 46734, 46746, 46751, 46758, 46774, 46829, 46838, 46844, 46846, 46847, 46852, 46855, 46861, 46865, 46867, 46871, 46879, 46885, 46887, 46891, 46893, 46895, 46897, 46899, 46905, 46909, 46917, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46935, 46937, 46939, 46941, 46943, 46945, 46947, 46949, 46953, 46955, 46959, 46963, 46967, 46971, 46977, 46981, 46983, 46985, 46991, 46995, 46997, 47001, 47003, 47005, 47011, 47013, 47021, 47025, 47033, 47037, 47039, 47045, 47047, 47049, 47061, 47063, 47066, 47071, 47076, 47079, 47081, 47083, 47088, 47091, 47104, 47114, 47167, 47183, 47198, 47202, 47207, 47209, 47212, 47218, 47220, 47224, 47229, 47235, 47238, 47242, 47244, 47247, 47249, 47253, 47259, 47261, 47266, 47277, 47279, 47283, 47285, 47289, 47291, 47295, 47301, 47309, 47312, 47315, 47320, 47322, 47326, 47431, 47439, 47442, 47444, 47446, 47449, 47454, 47458, 47459, 47462, 47464, 47470, 47472, 47475, 47478, 47482, 47489, 47495, 47497, 47499, 47507, 47519, 47531, 47533, 47541, 47543, 47547, 47549, 47551, 47557, 47564, 47566, 47568, 47570, 47575, 47580, 47586, 47589, 47595, 47600, 47607, 47616, 47623, 47628, 47637, 47641, 47649, 47651, 47655, 47657, 47659, 47665, 47670, 47678, 47683, 47685, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47767, 47769, 47774, 47779, 47782, 47784, 47787, 47789, 47792, 47794, 47797, 47800, 47803, 47805, 47808, 47810, 47813, 47815, 47820, 47825, 47828, 47833, 47835, 47840, 47843, 47845, 47848, 47850, 47853, 47855, 47858, 47863, 47865, 47867, 47872, 47879, 47882, 47885, 47887, 47890, 47892, 47994, 47997, 48002, 48004, 48008, 48012, 48015, 48017, 48019, 48020, 48023, 48026, 48028, 48032, 48038, 48039, 48043, 48045, 48047, 48049, 48051, 48053, 48055, 48057, 48059, 48061, 48062, 48066, 48070, 48072, 48074, 48076, 48078, 48082, 48084, 48086, 48088, 48090, 48093, 48095, 48097, 48099, 48101, 48103, 48105, 48107, 48109, 48111, 48113, 48115, 48117, 48119, 48121, 48123, 48125, 48127, 48129, 48131, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48186, 48190, 48194, 48197, 48202, 48204, 48216, 48223, 48225, 48229, 48233, 48236, 48238, 48243, 48247, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48278, 48280, 48285, 48289, 48292, 48294, 48299, 48303, 48306, 48308, 48311, 48317, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48344, 48347, 48352, 48354, 48356, 48358, 48361, 48363, 48366, 48368, 48370, 48372, 48375, 48377, 48380, 48382, 48394, 48396, 48404, 48409, 48411, 48416, 48418, 48423, 48425, 48430, 48432, 48437, 48439, 48440, 48443, 48444, 48447, 48535, 48536, 48537, 48541, 48543, 48547, 48549, 48555, 48559, 48563, 48565, 48571, 48573, 48575, 48577, 48579, 48583, 48585, 48588, 48596, 48598, 48603, 48605, 48609, 48613, 48615, 48618, 48620, 48621, 48623, 48625, 48628, 48634, 48635, 48640, 48642, 48643, 48645, 48647, 48654, 48656, 48657, 48664, 48667, 48669, 48672, 48674, 48675, 48677, 48679, 48685, 48687, 48689, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48712, 48714, 48717, 48719, 48722, 48727, 48729, 48732, 48734, 48735, 48737, 48744, 48745, 48747, 48749, 48752, 48754, 48755, 48761, 48769, 48774, 48777, 48783, 48789, 48791, 48798, 48801, 48805, 48810, 48815, 48817, 48819, 48826, 48830, 48832, 48835, 48837, 48840, 48849, 48856, 48858, 48863, 48868, 48872, 48874, 48884, 48887, 48896, 48899, 48904, 48909, 48913, 48916, 48927, 48930, 48938, 48942, 48956, 48971, 48980, 48984, 48988, 48998, 49000, 49004, 49018, 49023, 49031, 49036, 49041, 49043, 49046, 49051, 49056, 49058, 49066, 49069, 49086, 49088, 49090, 49097, 49188, 49193, 49199, 49201, 49208, 49209, 49211, 49214, 49217, 49222, 49224, 49226, 49232, 49238, 49242, 49246, 49248, 49250, 49254, 49256, 49260, 49274, 49340, 49343, 49350, 49357, 49359, 49371, 49385, 49396, 49399, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49441, 49445, 49449, 49452, 49454, 49458, 49462, 49465, 49467, 49472, 49475, 49478, 49480, 49490, 49495, 49507, 49513, 49517, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49558, 49560, 49563, 49568, 49570, 49573, 49575, 49578, 49580, 49583, 49587, 49589, 49592, 49597, 49599, 49602, 49604, 49607, 49609, 49612, 49614, 49616, 49620, 49625, 49632, 49635, 49637, 49640, 49642, 49644, 49646, 49649, 49650, 49653, 49655, 49657, 49659, 49662, 49667, 49754, 49757, 49759, 49761, 49764, 49766, 49768, 49770, 49772, 49775, 49779, 49783, 49787, 49788, 49791, 49796, 49797, 49799, 49801, 49803, 49807, 49809, 49811, 49813, 49817, 49819, 49823, 49833, 49839, 49841, 49847, 49849, 49851, 49853, 49855, 49857, 49859, 49861, 49865, 49867, 49869, 49873, 49875, 49877, 49881, 49886, 49888, 49891, 49895, 49900, 49910, 49915, 49919, 49921, 49924, 49929, 49933, 49938, 49943, 49945, 49947, 49952, 49957, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50061, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50084, 50087, 50089, 50092, 50094, 50099, 50104, 50106, 50108, 50111, 50113, 50116, 50118, 50121, 50123, 50126, 50128, 50131, 50134, 50136, 50138, 50141, 50143, 50146, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50172, 50175, 50177, 50179, 50181, 50186, 50189, 50191, 50193, 50195, 50198, 50200, 50203, 50205, 50210, 50213, 50324, 50327, 50330, 50332, 50334, 50338, 50340, 50345, 50350, 50352, 50353, 50356, 50360, 50361, 50364, 50366, 50368, 50370, 50371, 50374, 50380, 50383, 50385, 50387, 50389, 50391, 50392, 50394, 50396, 50398, 50400, 50402, 50404, 50406, 50408, 50410, 50412, 50414, 50416, 50418, 50422, 50424, 50430, 50433, 50442, 50447, 50449, 50454, 50456, 50458, 50461, 50463, 50466, 50468, 50470, 50475, 50480, 50482, 50492, 50494, 50496, 50506, 50508, 50517, 50549, 50562, 50586, 50600, 50605, 50607, 50611, 50614, 50616, 50628, 50632, 50640, 50684, 50693, 50707, 50714, 50719, 50724, 50728, 50733, 50736, 50739, 50742, 50744, 50749, 50752, 50757, 50759, 50762, 50764, 50772, 50777, 50779, 50782, 50784, 50786, 50790, 50792, 50795, 50797, 50800, 50802, 50805, 50808, 51611) 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 Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: Hercules and Omphale

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Phocion Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: Hamlet

Cast
Role: Rosencraus Actor: Macready

Afterpiece Title: Mago and Dago

Song: As17940929, but Vocal Parts-_

Performances

Mainpiece Title: Cymbeline

Cast
Role: Guiderius Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Tibalt Actor: Macready

Afterpiece Title: Mago and Dago

Song: As17941020, but Elegy-_; Vocal Parts-_

Performances

Mainpiece Title: Columbus

Cast
Role: Roldan Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: Hamlet

Cast
Role: Rosencraus Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: King Lear

Cast
Role: Cornwall Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Villers Actor: Macready

Afterpiece Title: Hercules and Omphale

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Tibalt Actor: Macready

Afterpiece Title: Mago and Dago

Song: As17950105

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Two Strings to Your Bow

Cast
Role: Ferdinand Actor: Macready

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: The Irishman in London

Cast
Role: Colloony Actor: Macready

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: The Prisoner at Large

Cast
Role: Jack Connor Actor: Macready

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: He Wou'd be a Soldier

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Modern Antiques

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: The School for Arrogance

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Hartford Bridge

Cast
Role: Forrester Actor: Macready

Dance: As17941001

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Midas

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Crotchet Lodge

Cast
Role: Dashley Actor: Macready

Performances

Mainpiece Title: The Mysteries Of The Castle

Cast
Role: Bernardo Actor: Macready

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: King Lear

Cast
Role: Cornwall Actor: Macready

Afterpiece Title: Crotchet Lodge

Cast
Role: Dashley Actor: Macready