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 (1408, 2113, 2194, 6992, 16548, 17686, 17689, 17693, 17697, 17700, 17702, 17706, 17710, 17713, 17718, 17720, 17723, 17730, 17734, 17738, 17741, 17745, 17753, 17757, 17764, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17794, 17798, 17800, 17807, 17811, 17814, 18054, 18058, 18198, 18201, 18204, 18209, 18211, 18213, 18232, 18234, 18238, 18252, 18255, 18260, 18364, 18367, 18371, 18374, 18375, 18378, 18381, 18426, 18430, 18435, 18673, 18686, 18761, 19253, 19256, 19260, 19330, 20292, 20295, 20311, 20326, 20347, 20398, 20415, 20421, 20438, 20461, 20518, 20530, 20534, 20544, 20551, 20560, 20566, 20569, 20572, 20832, 20835, 20838, 20841, 20845, 20875, 20967, 20980, 21112, 21116, 21126, 24298, 24301, 24304, 24308, 24311, 24313, 24315, 38102, 38121, 38138, 38148, 38177, 38190, 38197, 38242, 38885, 38918, 38937, 38946, 38976, 39093, 39107, 39123, 39213, 39245, 39257, 39265, 39291, 39416, 39493, 39502, 39525, 39546, 39648, 39693, 39699, 39818, 39852, 39875, 39902, 40184, 40511, 40834, 40924, 41151, 41161, 41173, 41202, 41208, 41324, 41457, 41507, 41509, 41514, 41517, 41522, 41531, 41538, 41548, 41568, 41671, 41706, 41832, 42049, 42290, 42311, 42363, 42391, 42426, 42555, 42580, 42641, 42673, 42683, 43477, 43501, 43516, 43532, 43603, 43652, 43745, 43785, 43828, 43862, 43955, 44611, 44640, 44685, 44899, 44963, 44988, 45003, 45195, 45229, 45422, 45443, 45952, 46355, 46391, 46502, 46504, 46649, 46663, 46671, 46705, 46882, 47028, 47118, 47230, 47416, 47461, 47576, 47738, 47849, 47902, 48022, 48094, 48201, 49032, 49111, 49424, 49629, 50017, 50212, 50363, 50994, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51140, 51247, 51249, 51254, 51256, 51258, 51285, 51298, 51304, 51338, 51356, 51367, 51489, 51788, 51860) 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: Hooly And Fairly

Afterpiece Title: Oscar and Malvina

Dance: 1st piece to conclude with: a Highland Reel, as17980428

Song: In 1st piece: Highland Laddy-; Hooly and Fairly-; Katharine Ogie-; Andrew and his Cutty Gun-; Todlen Hame-; Tulloch Goram-; End II 2nd piece: Old Towler-Incledon; End 2nd piece: Admiral Benbow-Incledon

Music: In 3rd piece: The Union Pipes-Murphy

Performances

Mainpiece Title: The Ugly Club

Cast
Role: Nell Trot Actor: Mrs Walcot

Afterpiece Title: The Castle-Spectre

Afterpiece Title: A Nosegay of Weeds; or, Old Servants in New Places

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Bon Ton

Cast
Role: Sir John Trotley Actor: King

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Bon Ton

Cast
Role: Sir John Trotley Actor: King

Music: As17980915

Dance: As17980915

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Afterpiece Title: Bon Ton

Cast
Role: Sir John Trotley Actor: King

Song: Mainpiece: Vocal Parts-Dignum, Danby, Brown, Mrs Bland, Miss Menage, Master Heather, Miss Jackson; End II: Jerry Sneak in his Glory-Roberts; End IV: The Town Crier-Suett; End: As burns the charger (from Robin Hood)-Sedgwick; End I afterpiece: At the peaceful Midnight Hour (from The Castle of Andalusia)-Sedgwick

Opera: V: Masque of Neptune and Amphitrite. Neptune-Caulfield; Amphitrite-Miss Wentworth