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) "Opera House at Turin"/1) | (@(roleclean,performerclean) "Opera House at Turin")') 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 3079 matches on Event Comments, 2569 matches on Performance Title, 271 matches on Performance Comments, 0 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: L'isola D'amore

Dance: End Overture: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Apprentice

Dance: End Opera: The Frolick, as17760217

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks After Marriage

Dance: End of Opera: The Frolick, as17760217

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End Opera: The Frolick, as17760217

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End of Opera: Mirth and Jollity, as17760102

Performances

Mainpiece Title: The Duenna

Afterpiece Title: St Patrick's Day

Dance: End Opera: La Soiree A@la@mode, as17751207

Performances

Mainpiece Title: La Serva Padrona

Afterpiece Title: L'Isola D'Amore

Dance: After the Intermezzo: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End Opera: Rural Merriment, as17751220

Performances

Mainpiece Title: Il Bacio

Dance: I: La Fete du Village, as17760224; II: New Serious Ballet, with Chaconne and Minuet de la Cour-Vallouy, Mme Vallouy; End Opera: New Grand Comic Ballet, Les Maissoneurs Distresse-Helm, Mlle Sophie, Sga Tinti, Vallouy, Mrs Vallouy

Performances

Mainpiece Title: Caio Mario

Dance: I: Diane et Endymion, as17760312 II: La Fete du Village, as17760224

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Vestale

Dance: Apollon e Daphne, as17751031; Minuet de la Cour-the two Vallouys; End II: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End Opera: Rural Merriment, as17751220

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Man of Quality

Dance: I: A Minuet-Holloway, Miss Cranfield; II: A Minuet-Dagueville, Mrs Masters (Daughter of the late Mr Lalauze)

Performances

Mainpiece Title: Caio Mario

Dance: I: La Fete du Village, as17760224; II: Diane et Endymion, as17760312 End Opera: Ballet-; with a Chaconne-; and a Minuet de la Cour-the two Vallouys

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Bon Ton

Dance: End Opera: a Favourite Dance call'd The Gardeners, as17760116

Performances

Mainpiece Title: Il Bacio

Dance: I: Diane et Endymion, as17760312 End II: Minuet a la Cour-the two Vallouys

Ballet: End Opera: Astolphe. As17760312[dancers only.

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End Opera: Mirth and Jollity, as17760102

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End of Opera: The Frolick, as17760217

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Cross Purposes

Dance: I: The Humours of the New@Market Races, as17760503

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End Opera: The Humours of the New@Market Races, as17760503

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Catherine and Petruchio

Dance: End Opera: The Humours of the New@Market Races, as17760503

Performances

Mainpiece Title: Il Bacio

Dance: I: New Serious Ballet-Helm, Mlle Sophie; with an Adagio-Mlle Heinel; Grand Chaconne-Mlle Heinel; II: Diane et Endymion, as17760312 End Opera: Le Triomphe de la Magie (with several alterations and improvements)-Fierville, Helm, Sga Tinti, Mlle Sophie, Mlle Heinel

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Dance: End Opera: The Humours of the New@Market Races, as17760503

Performances

Mainpiece Title: L'isola D'amore

Dance: After Overture: Le Minuet a la Cour-the two Vallouys; End I: Diane et Endymion, as17760312 End Opera: La Fete du Village, as17760224

Performances

Mainpiece Title: Antigono

Dance: I: Minuet a la Cour-the two Vallouys; II: Pigmalion-Fierville, Helm, Mlle Sophie, Mlle Baccelli; End Opera: La Fete du Village, as17760224