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 (47064, 47069, 47074, 47084, 47089, 47094, 47099, 47105, 47110, 47115, 47120, 47129, 47135, 47140, 47146, 47152, 47163, 47169, 47181, 47188, 47194, 47200, 47287, 47299, 47302, 47318, 47344, 47375, 47379, 47681, 47686, 47691, 47697, 47705, 47770, 47775, 47780, 47785, 47795, 47811, 47826, 47841, 47856, 50450, 50459, 50464, 50473, 50478, 50485, 50490, 50499, 50504, 50513, 50629, 50691, 50710, 50720, 50729, 50798, 50822, 50860) 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: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Giannina Actor: Sga Fabrizzi
Role: Costanza Actor: Sga Salimbeni
Role: Rosina Actor: Sga Pastorelli.

Dance: As17961227

Ballet: L'Amour et Psiche. As17961227

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Giannina Actor: Sga Fabrizzi
Role: Costanza Actor: Sga Salimbeni
Role: Rosina Actor: Sga Pastorelli.

Dance: End: a new Divertissement- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

Performances

Mainpiece Title: La Modista Raggiratrice

Cast
Role: Madama Perlina Actor: Sga Fabrizzi
Role: Ninetta Actor: Sga Salimbeni?
Role: Chiarina Actor: Sga Pastorelli.

Dance: End I: Divertissement-, as17970103; End Opera: Flore et Zephire, as17961126

Performances

Mainpiece Title: La Modista Raggiratrice

Cast
Role: Madama Perlina Actor: Sga Fabrizzi
Role: Ninetta Actor: Sga Salimbeni?
Role: Chiarina Actor: Sga Pastorelli.

Dance: As17970221

Performances

Mainpiece Title: L'albero Di Diana

Cast
Role: Amore Actor: Sga Storace
Role: Diana Actor: Sga Fabrizzi
Role: Clizia Actor: Sga Salimbeni
Role: Britomarte Actor: Sga Pastorelli.

Dance: As17970131

Performances

Mainpiece Title: Nina

Cast
Role: Elisa Actor: Sga Salimbeni.

Dance: As17961220

Performances

Mainpiece Title: Nina

Cast
Role: Elisa Actor: Sga Salimbeni.

Dance: As17970221

Performances

Mainpiece Title: Nina

Cast
Role: Elisa Actor: Sga Salimbeni.

Dance: As17961220

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: Giannina Actor: Sga Fabrizzi
Role: Sandrina Actor: Sga Salimbeni
Role: Olivetta Actor: Sga Pastorelli.

Dance: As17970513

Song: End Opera: Pygmalion-Viganoni

Ballet: Sapho et Phaon. As17970513

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: Giannina Actor: Sga Fabrizzi
Role: Sandrina Actor: Sga Salimbeni
Role: Olivetta Actor: Sga Pastorelli.

Dance: End I: Apollon Berger, as17961227; End Opera: Acis et Galatie, as17970615

Performances

Mainpiece Title: Nina

Cast
Role: Elisa Actor: Sga Salimbeni.

Dance: End I: Les Delassements Militaires-, as17970124; End Opera: Acis et Galatie, as17970617