SELECT * FROM london_stages WHERE eventid IN (38927, 38941, 38955, 38969, 38978, 38992, 38997, 39005, 39010, 39019, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39244, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39328, 39332, 39340, 39344, 39350, 39352, 39356, 39358, 39364, 39367, 39373, 39501, 39510, 39515, 39524, 39529, 39538, 39543, 39552, 39557, 39566, 39571, 39580, 39585, 39594, 39599, 39617, 39631, 39636, 39645, 39650, 39659, 39665, 39672, 39677, 39686, 39692, 39701, 39706, 39715, 39720, 39728, 39733, 39737, 39742, 39747, 39756, 39761, 39766, 39771, 39778, 39788, 39794, 39799, 39804, 39809, 39815, 39820, 39825, 39834, 39839, 39846, 39851, 39856, 39865, 39870, 39879, 39885, 39897, 39903, 39908, 39911, 39914, 39918, 39924, 39929, 39933, 39939, 39944, 40689, 40704, 40709, 40715, 40724, 40744, 40773, 40785, 40798, 40810, 40822, 40849, 40863, 40878, 40887, 40892, 40908, 40913, 40923, 40929, 40939, 40968, 40981, 40995, 41000, 41007, 41016, 41024, 41032, 41220, 41225, 41267, 41307, 41336, 41345, 41348, 41357, 41362, 41367, 41372, 41377, 41386, 41391, 41395, 41400, 41405, 41409, 41413, 41418, 41422, 41426, 41431, 41437, 41443, 41448, 41456, 41463, 41472, 41477, 41482, 41486, 41492, 41501, 41506, 41511, 41516, 41521, 41530, 41535, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 41608, 41611, 41614, 41619, 41622, 41777, 41782, 41791, 41798, 41805, 41810, 41819, 41834, 41849, 41873, 41904, 41919, 41951, 41959, 41981, 41995, 42008, 42012, 42027, 42038, 42048, 42064, 42079, 42109, 42120, 42130, 42155, 42185) 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: La Clemenza Di Scipione

Cast
Role: Idalba Actor: Sga Prudom
Role: Arsinda Actor: Sga Francesca Danzi.

Dance: As17780404

Ballet: La Surprize de Daphnis et Cephise. As17780404

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli
Role: Semplicina Actor: Sga Prudom
Role: Ottavina Actor: Sga Todi

Dance: End I: Les Bohemiens, as17771216; End II: Serious Ballet, as17780120; End Opera: new Ballet Demi-caractere (never performed), L'Amour dans la Vendange-Mons and Mlle Banti, Sg and Sga Zuchelli

Performances

Mainpiece Title: La Clemenza Di Scipione

Cast
Role: Idalba Actor: Sga Prudom
Role: Arsinda Actor: Sga Francesca Danzi.

Dance: As17780404

Ballet: La Surprize de Daphne et Cephise. As17780404

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli
Role: Semplicina Actor: Sga Prudom
Role: Ottavina Actor: Sga Todi

Dance: End I: Divertisement, as17780207; with a Minuet-Mons and Mme Simonet; End II: L'Amour dans la Vendange, as17780519; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: La Buona Figliuola

Dance: End I: L'Amour dans la Vendange, as17780519; End II: The Masquerade Ballet-; in which a Minuet-Mme Simonet en homme, or in man's dress,, Mlle Baccelli; End Opera: La Serenade Interrompuee, as17780224; in which the Minuet Dauphin-Mme Simonet in man's dress, Mlle Banti

Performances

Mainpiece Title: Il Re Pastore

Cast
Role: Tamiri Actor: Sga Prudom
Role: Elisa Actor: Sga F. Danzi.

Dance: End I: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: Les Amans unis par l'Hymen, as17780404

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli
Role: Semplicina Actor: Sga Prudom
Role: Ottavina Actor: Sga Todi

Dance: End I: Divertisement, as17780526; End II: L'Amour dans la Vendange, as17780519; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: Il Re Pastore

Cast
Role: Tamiri Actor: Sga Prudom
Role: Elisa Actor: Sga F. Danzi.

Dance: End II: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303but _Simonet, Mme Simonet; +Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: La Serenade Interrompuee, as17780224

Ballet: End I: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli
Role: Semplicina Actor: Sga Prudom
Role: Ottavina Actor: Sga Todi

Dance: End I: Divertisement, as17780207; End II: L'Amour dans la Vendange, as17780519; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

Dance: End I: La Polonaise Favourite, as17771104; End Opera: La Serenade Interrompuee, as17780224

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli
Role: Semplicina Actor: Sga Prudom
Role: Ottavina Actor: Sga Todi

Dance: As17780609

Performances

Mainpiece Title: La Clemenza Di Scipione

Cast
Role: Idalba Actor: Sga Prudom
Role: Arsinda Actor: Sga Francesca Danzi.

Dance: End II: La Clochette, as17771115; End Opera: Les Amans unis par l'Hymen, as17780404

Ballet: End I: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli
Role: Semplicina Actor: Sga Prudom
Role: Ottavina Actor: Sga Todi

Dance: As17780609

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: End I: new Pantomime Dance (composed by Zuchelli) Il Desertore-Sg and Sga Zuchelli, Henry, young Miss Andreas, Miss Simonet; End II: a grand Masquerade Dance-the other partsSg and Sga Zuchelli, Sga Tantini, Henry, Slingsby; in which a Chaconne(in character by the various Masks)-; and which will open with a Minuet-Favre Guiardele, Mme Simonet (1st appearance this season); End afterpiece: new Grand Balletconnected with the Opera-Favre Guiardele, Mme Simonet, Sga Tantini, Slingsby

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: End I: Il Desertore, as17791214; End II: Masquerade Dance, as17791214; Minuet, as17791214; End afterpiece: Grand Ballet, as17791214

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: As17791221 throughout

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: As17791221 throughout

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: As17791221 throughout

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: As17791221

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: As17791221

Performances

Mainpiece Title: La Contadina In Corte

Afterpiece Title: Il Soldano Generoso

Dance: As17791221 throughout

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Semplicina Actor: Sga Pozzi
Role: Lisandrina Actor: Sga Prudom
Role: Ottavina Actor: Sga Bernasconi.

Dance: End I: Il Desertore, as17791214; End II: Masquerade Dance, as17791221; Minuet, as17791221; End Opera: Grand Serious Ballet, as17791127, but _Slingsby, Mlle Baccelli

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Semplicina Actor: Sga Pozzi
Role: Lisandrina Actor: Sga Prudom
Role: Ottavina Actor: Sga Bernasconi.

Dance: End I: Il Desertore, as17791214; End II: New Pastoral Ballet-Favre Guiardele, Mme Simonet, Sg and Sga Zuchelli, Sga Tantini, Slingsby; End Opera: Grand Serious Ballet, as17800208

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Semplicina Actor: Sga Pozzi
Role: Lisandrina Actor: Sga Prudom
Role: Ottavina Actor: Sga Bernasconi.

Dance: As17800215

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Semplicina Actor: Sga Pozzi
Role: Lisandrina Actor: Sga Prudom
Role: Ottavina Actor: Sga Bernasconi.

Dance: As17800215 throughout