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 eventid IN (40110, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40166, 40171, 40177, 40186, 40191, 40200, 40206, 40215, 40220, 40229, 40241, 40246, 40255, 40260, 40268, 40273, 40280, 40293, 40317, 40321, 40404, 40414, 40429, 40434, 40482, 48991, 49005, 49010, 49019, 49024, 49029, 49049, 49059, 49070, 49078, 49093, 49106, 49108, 49115, 49118, 49121, 49124) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

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

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

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: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Song: In III: an additional song, as17790311

Performances

Mainpiece Title: La Buona Figliuola

Dance: End I: Les Oiseleurs, as17790123; End Opera: New Ballet, as17790227

Ballet: End II: Annette et Lubin. As17781124

Performances

Mainpiece Title: La Buona Figliuola

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: La Buona Figliuola

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Modesta Actor: Sga Jermoli
Role: Lazzarina Actor: Sga Pozzi
Role: Zerbinetta Actor: Sga Sestini.

Dance: End I: Les Oiseleurs, as17790123; End II: Ballet by Fairies, as17790302End Opera: New Ballet, as17790227

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: Semiramide; O, La Vendetta Di Nino

Dance: End of Act I New Divertisement, as17940311End of Act II Les Ruses de l'Amour, as17940401, but omitted: Mlle Guirdele

Performances

Mainpiece Title: Semiramide

Dance: As17940426 throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940426 throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940426 throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940426 throughout

Performances

Mainpiece Title: A Grand Selec Tion Of Music From The Most Eminent Masters

Afterpiece Title: THE GRAND TE DEUM, composed by Paisiello, upon the return of his Majesty the King of the Two Sicilies, from Vienna to Naples, in the summer of 1791

Performances

Mainpiece Title: Semiramide

Dance: As17940426 throughout

Performances

Mainpiece Title: Semiramide

Afterpiece Title: LA SERVA PADRONA

Dance: End of Act I of afterpiece us Ruus dt I' A11WMr (performers not listed, but see17940401 No other ballet performed this evening.]

Performances

Mainpiece Title: Semiramide

Afterpiece Title: LA SERVA PADRONA

Music: Between the two Operas a concerto on the violin by Giornovichi

Dance: End of Act I of afterpiece New Divertisement, as17940311athi

Performances

Mainpiece Title: Semiramide

Dance: As17940531 throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940531 throughout

Performances

Mainpiece Title: La Serva Padrona

Dance: End of opera concerto, as17940603 after which La Vittoria (a Grand Cantata, composed by Paisiello, and performed by Mme Banti at Naples, adapted [by Da Ponte] to the glorious occasion of the triumph of the British flag [on 1 June 1794]), The Goddess of Victory-Mme Banti, accompanied by Chorusses, and a grand Allegorical Ballet, composed by Noverre; to conclude with Rule Britannia by Mme Banti

Performances

Mainpiece Title: La Serva Padrona

Dance: End of opera New Divertisement, as17940311after which: La Vittoria, Ballet, Rule Britannia, all as17940623

Performances

Mainpiece Title: La Serva Padrona

Dance: As17940623throughout

Performances

Mainpiece Title: La Serva Padrona

Dance: As17940623throughout

Performances

Mainpiece Title: La Serva Padrona

Dance: As17940623throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940531 throughout