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 (2007, 2048, 2064, 2105, 2138, 2177, 2178, 2194, 2243, 2264, 2290, 2298, 2399, 2400, 2460, 2461, 2530, 35673, 35675, 35677, 35679, 35682, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35708, 35710, 35713, 35715, 35717, 35719, 35722, 35724, 35727, 35729, 35732, 35734, 35737, 35739, 35742, 35745, 35748, 35750, 35752, 35755, 35757, 35760, 35762, 35764, 35767, 35770, 35772, 35775, 35779, 35782, 35784, 35789, 35827, 35850, 35857, 35882, 35890, 35917, 35930, 35933, 35955, 35968, 35995, 41453, 46516, 46526, 46530, 46540, 46554, 46558, 46568, 46572, 46582, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47121, 47124, 47128, 47131, 47133, 47136, 47139, 47144, 47148, 47150, 47153, 47156, 47161, 47165, 47170, 47176, 47186, 47189, 47195, 47204, 47270, 47320, 47440, 47446, 47454, 47458, 47462, 47470, 47489, 47503, 47517, 47521, 47537, 47541, 47543, 47549, 47555, 47557, 47559, 47561, 47568, 47575, 47580, 47582, 47584, 47709, 47722, 47724, 47800, 47805, 47820, 47835, 47850, 47853, 47863, 47869, 47885, 47890, 48015, 48023, 48029, 48032, 48230, 48240, 48244, 48254, 48258, 48268, 49203, 49352, 49362, 49376, 49408, 49411, 49504, 49630, 49646, 49653, 49659, 51684) 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 Prussian Festival

Afterpiece Title: Oscar and Malvina

Song: As17910926

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Notoriety

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Music: As17911122

Performances

Mainpiece Title: A Day In Turkey

Music: As17911024

Performances

Mainpiece Title: The Beggar's Opera

Dance: As17911112

Music: As17911024

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Dramatist

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Jovial Crew

Dance: In II 3rd piece: the original Crutch Dance-

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Oscar and Malvina

Music: In 3rd piece: The Harp and Pipes-Weippert, Courtney

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: Blue Beard; or, The Flight of Harlequin

Dance: see17920111

Performances

Mainpiece Title: The Conscious Lovers

Song: As17911020

Performances

Mainpiece Title: Inkle And Yarico

Dance: As17911102

Performances

Afterpiece Title: Rosina

Song: Sweet Bird(by Handel)-Mrs Billington; accompanied on the violin-Weichsel

Performances

Mainpiece Title: The Road To Ruin

Performances

Afterpiece Title: The Deaf Lover

Dance: In: Dance incidental to the piece,-Byrne, Mlle St.Amand

Entertainment: Monologue End: (by way of Epilogue) Poetical Sketch, Jemmy Jumps in the Dumps; or, A Sunday Lounge in Hyde Park-Munden