SELECT * FROM london_stages WHERE eventid IN (38335, 38338, 38346, 38350, 38352, 38354, 38362, 38365, 38368, 38370, 38377, 38379, 38416, 38430, 38444, 38458, 38465, 38478, 38480, 38482, 38484, 38486, 38489, 38497, 38510, 38517, 38522, 38524, 38526, 38529, 38531, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38562, 38569, 38579, 38584, 38612, 38730, 38735, 38740, 38749, 38751, 38754, 38762, 38772, 38779, 38786, 38791, 38923, 38927, 38936, 38941, 38950, 38955, 38964, 38969, 38978, 38992, 38997, 39005, 39010, 39019, 39040, 39053, 39064, 39071, 39080, 39085, 39092, 39097, 39106, 39112, 39120, 39125, 39134, 39139, 39148, 39153, 39162, 39168, 39174, 39180, 39186, 39192, 39198, 39204, 39215, 39221, 39227, 39233, 39238, 39244, 39249, 39256, 39267, 39272, 39279, 39284, 39290, 39295, 39300, 39311, 39319, 39328, 39332, 39340, 39344, 39350, 39352, 39356, 39358, 39364, 39367, 39373, 39382, 39794, 39804, 39809, 39825, 39851, 39856, 39865, 39879, 39897, 39911, 39918, 39929, 39939, 40070, 40110, 40115, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40166, 40167, 40171, 40177, 40186, 40191, 40200, 40206, 40215, 40220, 40229, 40241, 40246, 40255, 40260, 40268, 40273, 40280, 40293, 40317, 40321, 40339, 40346, 40351, 40365, 40380, 40394, 40404, 40409, 40414, 40415, 40423, 40429, 40434, 40451, 40482, 40490, 40934, 40949, 40963, 40975, 40990, 41004, 41013, 41021, 41029, 41037, 41046, 41262, 41267, 41276, 41288, 41293, 41302, 41307, 41316, 41321, 41330, 41336, 41345, 41348, 41357, 41362, 41367, 41372, 41377, 41386, 41391, 41395, 41400, 41405, 41409, 41413, 41418, 41422, 41426, 41431, 41437, 41443, 41448, 41456, 41463, 41467, 41472, 41477, 41482, 41486, 41492, 41501, 41506, 41507, 41509, 41511, 41514, 41516, 41521, 41522, 41530, 41531, 41535, 41538, 41540, 41545, 41548, 41550, 41560, 41565, 41568, 41574, 41578, 41581, 41593, 41596, 41605, 41608, 41611, 41614, 41619, 41622) 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: As17790325

Ballet: La Fete du Ciel. As17790325

Cast
Role: Flora Actor: Sga Tinti

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: Enea E Lavinia

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

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Cast
Role: Flora Actor: Sga Tinti

Performances

Mainpiece Title: La Buona Figliuola

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Comus

Dance: In: Grand Dance, as17781102, but _Henry, Grimaldi, Master +Mills, Miss +Grimaldi

Song: As17790413

Performances

Mainpiece Title: Enea E Lavinia

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

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Cast
Role: Flora Actor: Sga Tinti

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

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: Three new Ballets composed by Favre Guiardele. End I: The Rural Sports-Sg and Sga Zuchelli, Henry, Miss Andreas, Miss Simonet, Sga Crespi; End II: La Fete Pastorale-Favre Guiardele, Mme Simonet, Sga Tantini; with a Pas Seul-Mlle Baccelli; accompanied on the guitar-Noferi; End Opera: Serious Ballet, as17800122, but Mme Simonet, Sga +Tantini; +Grand Chaconne by Floquet-

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800422, but Miss _Andreas; End II: Il Filosofo, as17800509; End Opera: Grand Serious Ballet, as17791127, but _Slingsby, Mme Simonet; with a +Grand Chaconne, as17800422

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800512; End II: La Fete Pastorale, as17800422, but Slingsby; Pas Seul, as17800422; accompanied on the guitar-Noferi; End Opera: +Serious Ballet, as17800422, but Slingsby; +Grand Chaconne, as17800422

Performances

Mainpiece Title: Rinaldo

Dance: End I: The Rural Sports, as17800512, but Miss _Simonet; End II: La Fete Pastorale, as17800520; End Opera: Serious Ballet-; connected with the Opera, in which a Grand Chaconne ([the music] composed by Floquet)-Favre Guiardele, Mme Simonet, Slingsby, Sga Tantini, Mlle Baccelli

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800527; End II: La Fete Pastorale, as17800520; End Opera: Serious Ballet, as17800527; Grand Chaconne, as17800527; To conclude with: New Allemande-

Performances

Mainpiece Title: Quinto Fabio

Cast
Role: Fausta Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800527; End II: Il Filosofo, as17800509; To conclude with: New Allemande-; End Opera: New Serious Ballet, as17800516

Song: As 22 Jan

Performances

Mainpiece Title: Ricimero

Dance: End I: The Fortunate Escape, as17801125, but Mme _Simonet, Henry; End II: +Grand Serious Ballet (composed by Simonet)-Sg and Sga Zuchelli, Henry, Sga Crespi, Mlle Baccelli; to conclude with: Grand Chaconne-Vestris? Jun.; End III new ballet, Les Amans Surpris (composed by Simonet)-Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

Performances

Mainpiece Title: Le Serve Rivali

Cast
Role: Palmetta Actor: Sga Prudom
Role: Giacinta Actor: Sga Sestini.

Dance: End I: The Fortunate Escape, as17801216; End II: Grand Serious Ballet, as17801216; Grand Chaconne, as17801216; End Opera: Les Amans Surpris, as17801216, but Mme Simonet

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Lorenzini

Dance: As17801219

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.