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) "Sparkling"/1) | (@(roleclean,performerclean) "Sparkling")') 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 128 matches on Roles/Actors, 48 matches on Performance Comments, 3 matches on Event Comments, 0 matches on Performance Title, and 0 matches on Author.

Performances

Mainpiece Title: The Miser

Afterpiece Title: Flora

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Rites of Hecate

Dance: III: The Italian Gardiners, as17631119

Performances

Mainpiece Title: The Miser

Afterpiece Title: Love in a Camp

Dance: As17870131

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Dumb Cake

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Miser

Dance: As17881107

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Miser

Dance: As17890101

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: As It Should Be

Dance: End II: As17890525; End I: Statute Dance-the Characters

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: A Mogul Tale; or, The Descent of the Balloon

Afterpiece Title: Ut Pictura Poesis

Afterpiece Title: As It Should Be

Dance: As17890525

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: As It Should Be

Dance: End: As17890525; III: Hornpipe-Menage

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: The Romp

Afterpiece Title: Half an Hour after Supper

Afterpiece Title: Ut Pictura Poesis

Dance: As17890525

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: Tit for Tat

Afterpiece Title: Ut Pictura Poesis

Afterpiece Title: Half an Hour after Supper

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Vimonda

Afterpiece Title: As It Should Be

Entertainment: Monologue. End 2nd piece: British Loyalty or A Squeeze for St. Paul's-Bannister Jun.; conclude with: God save the King-Chapman, Chambers, Mathews

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Half an Hour after Supper

Dance: End: As17890525

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: As It Should Be

Dance: As17890624

Performances

Mainpiece Title: Summer Amusement; Or, An Adventure At Margate

Afterpiece Title: Half an Hour after Supper

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: A Mogul Tale

Performances

Mainpiece Title: The Married Man

Afterpiece Title: The Romp

Dance: As17890708

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Family Party

Performances

Mainpiece Title: The Married Man

Afterpiece Title: Seeing is Believing

Afterpiece Title: The Flitch of Bacon

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Married Man

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Ut Pictura Poesis

Afterpiece Title: The Married Man

Afterpiece Title: The Village Lawyer

Dance: End 2nd piece: as17890727

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Married Man

Afterpiece Title: Polly Honeycomb

Dance: As17890728