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) "Les Trois Freres Riveaux"/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: La Vestale

Dance: Les Deux Soeurs, as17760206; End II: Les Evenemens Imprevues-; A Divertissement, as17760206

Performances

Mainpiece Title: Astarto

Dance: End I: Les Amusemens Champetres, as17761102; End II: Les Amans Heureux, as17761102; End Opera: Grand Serious Ballet, as17761102

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amusemens Champetres, as17761102; End II: Grand Serious Ballet, as17761102; End Opera: a new Ballet, Demi-caractere, Les Chasseurs-Mons Vallouy, Mme Vallouy, Sg and Sga Zuchelli, Simonin Vallouy?@le@cadet

Performances

Mainpiece Title: Astarto

Dance: End I: Les Amans Heureux, as17761102 End II: Grand Serious Ballet, as17761102; End Opera: Les Chasseurs, as17761112

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amans Heureux, as17761102 End II: Grand Serious Ballet, as17761102, but Mons _Simonet; in which a Passacaile-Mme Simonet; Chaconne-Mme Simonet; End Opera: Les Chasseurs, as17761112

Performances

Mainpiece Title: Piramo E Tisbe

Dance: End Overture: Les Amusemens Champetres-Mme Simonet, Zuchelli, Vallouy@le@cadet; End I: Les Amans Heureux-Vallouy, Mme Simonet, Zuchelli, Vallouy@le@cadet; End Opera: Grand Serious Ballet, as17761130, but Sga _Zuchelli, Vallouy@le@cadet; Passacaile, as17761130;Chaconne, as17761130

Music: As17761214

Performances

Mainpiece Title: La Fraschetana [recte Frascatana]

Dance: End I: La Noche Hollandoise, as17781124; End II: new ballet, Les Moissonneurs (the music by the celebrated Paisiello) with a Pas de Deux Anacreontique,-Mme Simonet, Slingsby, Banti, Sga Tinti, Sg and Sga Zuchelli, LeDet; End: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124, but _Banti, LeDet; End II: +Les Moissonneurs, as17781222, but Sg and Sga _Zuchelli; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise-, as17781229, but Sga _Zuchelli; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Artaserse

Dance: End I: Les Oiseleurs, as17790129; End Opera: Les Nymphes de Diane, as17781124

Ballet: End II: Annette et Lubin. As17781124, but unassigned-Sga _Zuchelli

Performances

Mainpiece Title: Demofoonte

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17781128

Performances

Mainpiece Title: Demofoonte

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17791128, but Mlle Baccelli

Performances

Mainpiece Title: Demofoonte

Dance: End of new song: Les Oiseleurs, as17790123; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17790227

Song: End I: a new song-Pacchierotti; with violin obligato composed by Bertoni-Cramer; In III: an additional song composed by Handel-Pacchierotti

Performances

Mainpiece Title: La Governante

Dance: End I: Les Paysans Voles, as17790515; End II: Les Moissonneurs, as17781229; End III: La Serenade Interrompuee, as17790515; Pas de Deux du Masque, as17790515

Performances

Mainpiece Title: L'olimpiade

Dance: End I: Les Paysans Voles, as17790515, but _Banti, LeDet; End II: +Les Moissonneurs, as17781229; End Opera: a New Divertisement-Simonet, Banti, Mlle Baccelli

Performances

Mainpiece Title: La Governante

Dance: End I: Les Paysans Voles, as17790515; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, in which the Quadrilles danced at the Pantheon last night (composed by Simonet)-Slingsby, Mme Simonet, Banti, Sga Tinti, Sg and Sga Zuchelli, Simonet, Mlle Baccelli

Performances

Mainpiece Title: L'olimpiade

Dance: End I: Les Paysans Voles-LeDet, Sg and Sga Zuchelli; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, with Quadrilles, as17790615

Performances

Mainpiece Title: Virginia

Dance: End of Act I Les Amans Surpris, as17860620 End of Opera Les Deux Solitaires, as17860523

Performances

Mainpiece Title: Gli Schiavi Per Amore

Song: As17880221

Dance: End Opera: Les Offrandes a l'Amour, as17871208; End I: New Dance, as17880221; Pas de Bernois, as17880221; Pas de Trois, as17880221; a Pas Seul, as17880221; Pas Seul, as17880221; Pas de Russe, as17880221; Pas de Cinq, as17880221; General Dance, as17880221; Pas de Sept, as17880221

Performances

Mainpiece Title: Il Re Teodoro In Venezia

Dance: End Opera: Les Offrandes a l'Amour, as17871208; End I: New Dance, as17880221; Pas de Bernois, as17880221; Pas de Trois, as17880221; Pas de Deux, as17880221; Pas Seul, as17880221; Pas de Russe, as17880221; Pas de Cinq, as17880221; Pas de Sept, as17880221; General Dance, as17880221; omitted: Pas Seul by Chevalier, Hornpipe

Performances

Mainpiece Title: Gli Schiavi Per Amore

Dance: End I: As17880226, but Les Offrandes a l'Amour-_; End Opera: Les Fetes de Tempe, as17880228, but _Henry

Performances

Mainpiece Title: La Cameriera Astuta

Dance: End Opera: Les Fetes de Tempe, as17880301End I: New Dance, as17880226; Pas de Bernois, as17880226; Pas de Trois, as17880226; Pas Seul, as17880226; Pas de Russe, as17880226; Pas de Cinq, as17880226; Pas de Sept, as17880226; General Dance, as17880226

Performances

Mainpiece Title: Giulio Sabino

Dance: End I: Les Offrandes a l'Amour, as17880417; End Opera: Les Fetes de Tempe, as17880228

Performances

Mainpiece Title: L'usurpator Innocente

Dance: End I: Les Mariages Flamands, as17900227; End Opera: Les Caprices-Labourie, Duquesney, Mlle de'Caro, Mlle Dorival, Mlle Hilligsberg