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 (41777, 41782, 41791, 41798, 41805, 41810, 41819, 41824, 41829, 41834, 41844, 41849, 41854, 41859, 41864, 41873, 41878, 41883, 41888, 41894, 41899, 41904, 41910, 41919, 41924, 41927, 41932, 41937, 41942, 41946, 41951, 41955, 41959, 41964, 41968, 41972, 41977, 41981, 41985, 41991, 41995, 41999, 42004, 42008, 42012, 42018, 42023, 42027, 42038, 42043, 42048, 42054, 42064, 42069, 42074, 42079, 42084, 42089, 42094, 42109, 42130, 42155, 42158, 42167, 42185, 42196) 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: L'eroe Cinese

Dance: End of Act II le Triomphe de l'Amour Conjugal, as17820110; End of Opera Rinaldo and Armida, as17820223

Performances

Mainpiece Title: Il Bacio

Dance: As17820402 throughout

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I Divertisement Dance, as17820307End of Act II La Rosiere de Salency, as17820319End of Opera Rinaldo and Armida, as17820223

Performances

Mainpiece Title: La Contadina In Corte

Dance: End of Act I La Rosiere de Salency, as17820319End of Opera Adela of Pontbieu, as17820411

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: As17820219 throughout

Song: In Act II two new songs by Sga Allegranti, one of which composed by Giardini

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I Pastoral Dance, as17820129; End of Act II Divertisement Dance, as17820307End of Opera Adela of Pontbieu, as II Apr

Performances

Mainpiece Title: La Contadina In Corte

Dance: As17820402 throughout

Performances

Mainpiece Title: I Vlaggiatori Felici

Dance: End of Act I Le Triomphe de l'Amour Conjugal, as17820110; End of Opera Medea and Jason, as17820411

Performances

Mainpiece Title: La Contadina In Corte

Dance: End of Act I Le Triomphe de l'Amour Conjugal, as17820110; End of Opera Adela of Pontbieu, as17820411

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I Pastoral Dance, as17811128; End of Act II Apollon et les Muses, as17820502; End of Opera New Dance, as17820502

Performances

Mainpiece Title: L'eroe Cinese

Dance: End of Act I New Divertisement Dance, as17820216; End of Act II Apollon et les Muses, as17820509; End of Act III New Dance, as17820507

Performances

Mainpiece Title: Ifigenia In Aulide

Dance: End of Act I Divertisement Dana, as17811117, but omitted: Gardel, Mlle Baccelli; End of Opera Mirsa, as17820516

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I Le Triompbe de l'Amour Conjugal, as17820312End of Act II Rinaldo and Armida, as17820223

Performances

Mainpiece Title: La Contadina In Corte

Dance: End of Act I Divertisement Dance, as17820525; End of Opera Apollon et les Muses, as17820502, but omitted: Mme Simonet, Mlle Baccelli

Performances

Mainpiece Title: Ezio

Dance: End of Act I New Divertisement Dance, as17820216, but omitted: Nivelon; End of Act II Apelles and Campaspe, as17820605 End of Opera Adela of Pontbieu, as17820411

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I Apollon et les Muses, as17820601 End of Opera Medea and Jason, as17820411