SELECT * FROM london_stages WHERE eventid IN (38380, 38389, 38403, 38419, 38433, 38447, 38461, 38487, 38513, 38527, 38542, 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, 40346, 40351, 40365, 40380, 40394, 40404, 40409, 40414, 40423, 40429, 40434, 40451, 40482, 40490) 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: Enea E Lavinia

Cast
Role: Amata Actor: Sga Pozzi
Role: Lavinia Actor: Sga Bernasconi.

Dance: End I: Hippomene et Atalante, as17790325End II: Ballet by Fairies, as17790302

Ballet: End Opera: La Fete du Ciel. As17790325but Apollo-_; Chaconne-_

Cast
Role: Flora Actor: Sga Tinti

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

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

Dance: End I: Hippomene et Atalante, as17790325but Mlle _Vidini; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17781128, but Mme _Simonet, Mlle Bacelli

Song: In III: an additional song, as17790311