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('(@(perftitleclean,performancetitle) "Le Speranze Della Terra"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Erifile

Dance: End I: La Polonaise Favourite, as17780131; End II: Les Bohemiens, as17771216; End Opera: Divertisement-Mons and Mlle Banti, Vallouy@le@cadet, Mlle Baccelli

Song: In II: Air-Sga Danzi; accompanied on the Hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: End I: Divertisement, as17780207; End Opera: new grand Serious Ballet, Les Amans unis par l'Hymen-Simonet, Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet

Song: II: an air-Sga Danzi; [accompanied on the violin-Cramer; violoncello-Cervetto; German flute-Florio; hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331