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 MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Andrews"/1) | (@(roleclean,performerclean) "Andrews")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 495 matches on Roles/Actors, 205 matches on Author, 99 matches on Performance Comments, 96 matches on Event Comments, and 9 matches on Performance Title.

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Music: As17911122

Performances

Mainpiece Title: Notoriety

Afterpiece Title: The Miser

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The Dramatist

Afterpiece Title: Oscar and Malvina

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: The Jovial Crew

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

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Notoriety

Afterpiece Title: Love and War

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

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

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Music: In afterpiece: As17911219

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Three Weeks after Marriage

Dance: As17910912

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Oscar and Malvina

Music: As17920125

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Pannel

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Robin Hood

Entertainment: Monologues Preceding: [a New Address, She Couldn't Help It-[by Harley]; End: Collins's Ode on the Passions-Mrs Esten; [Imitations End II: Dramatic Imitations [Comic, Vocal and Tragic,-Mrs Wells

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: Richard Coeur de Lion

Song: for this Night only a new Song by Suett-Mrs Jordan In Character of Viola; accompaniments for the Oboe and Grand Piano Forte-; End: a favourite Song by Dibdin-Suett

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Doctor and the Apothecary

Song: End II: a favourite Duett(composed by Florio Jun.)-Miss Hagley, Mrs Bland