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 (47709, 47724, 47876, 47907, 48541, 48551, 48553, 48567, 48687, 48719, 48837, 49030, 49045, 49060, 49231, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49384, 49417, 49558, 49787, 49900, 49902, 49924, 49937, 49958, 50137, 50344, 50349, 50352, 50357, 50367, 50369, 50375, 50379, 50381, 50386, 50390, 50397, 50407, 50421, 50434, 50448, 50475, 50477, 50480, 50482, 50484, 50511, 50525, 50530, 50555, 50597, 50600, 50605, 50607, 50611, 50616, 50628, 50632, 50638, 50640, 50663, 50694, 50703, 50714, 50724, 50753, 50764, 50940, 50959, 50965, 50971, 50974, 51004, 51051, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51106, 51107, 51109, 51110, 51111, 51112, 51113, 51114, 51115, 51116, 51119, 51120, 51121, 51124, 51126, 51128, 51133, 51140, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51233, 51236, 51240, 51247, 51249, 51254, 51256, 51258, 51260, 51262, 51267, 51270, 51279, 51284, 51285, 51287, 51294, 51298, 51299, 51301, 51304, 51311, 51321, 51323, 51326, 51328, 51337, 51338, 51344, 51348, 51353, 51356, 51362, 51364, 51369, 51377, 51380, 51499, 51502, 51504, 51507, 51509, 51513, 51516, 51517, 51520, 51526, 51534, 51542, 51546, 51547, 51549, 51550, 51551, 51552, 51553, 51554, 51555, 51556, 51559, 51563, 51567, 51570, 51571, 51572, 51575, 51579, 51582, 51583, 51585, 51589, 51595, 51598, 51601, 51602, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51623, 51624, 51626, 51627, 51629, 51631, 51633, 51634, 51636, 51638, 51639, 51640, 51641, 51642, 51643, 51647, 51648, 51649, 51655, 51662, 51672, 51675, 51676, 51677, 51690, 51693, 51694, 51696, 51698, 51700, 51716, 51718, 51722, 51725, 51728, 51730, 51737, 51747, 51749, 51752, 51754, 51759, 51764, 51766, 51770, 51773, 51776, 51778, 51779, 51781, 51783, 51791, 51792, 51794, 51797, 51801, 51807, 51808, 51819, 51820, 51821, 51824, 51830, 51832, 51836, 51837, 51838, 51840, 51842, 51844, 51846, 51848, 51850, 51855, 51861, 51863, 51869, 51871, 51872, 51876, 51878, 51884, 51885, 51890, 51907, 51913, 51914, 51926, 51936, 52077, 52084, 52086, 52088, 52091, 52092, 52095, 52099, 52103, 52105, 52108, 52111, 52115, 52117, 52125, 52127, 52143, 52149, 52153, 52163, 52171, 52175, 52200, 52201, 52202, 52203, 52204, 52206, 52208, 52210, 52211, 52212, 52213, 52214, 52215, 52216, 52218, 52220, 52221, 52223, 52224, 52225, 52226, 52227, 52229, 52231, 52233, 52234, 52236, 52238, 52239, 52240, 52244, 52248, 52250, 52253, 52254, 52255, 52257, 52259, 52261, 52262, 52264, 52266, 52269, 52271, 52277, 52281, 52334, 52340, 52341, 52342, 52346, 52347, 52349, 52352, 52354, 52358, 52364, 52370, 52376, 52388, 52390, 52395, 52397, 52448, 52455, 52467, 52473, 52480, 52482) 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: A Trip To Scarborough

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Blue-Beard

Song: Chorus of Witches and Spirits, as17971107, but Miss Wentworth, Miss _Menage, _Kelly, Mrs _Bland

Performances

Mainpiece Title: First Love

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Raft

Afterpiece Title: Harlequin's Return

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Comedy of Errors

Song: In III 2nd piece: song in character-Mrs Clendining

Performances

Mainpiece Title: The Raft

Afterpiece Title: Rule a Wife and Have a Wife

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Lie of the Day; or, A Party at Hampton Court

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Blue-Beard