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

Afterpiece Title: The Irish Widow

Dance: I: a Dance of Cupids-; IV: [a Dance of Daemons-; V: Grand Dance [Grand Ballet [sic], as17781102; End I afterpiece: Minuet de la Cour, as17780919; [and Allemande, as17780919

Performances

Mainpiece Title: Demofoonte

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

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124, but _Banti, LeDet; End II: +Les Moissonneurs, as17781222, but Sg and Sga _Zuchelli; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Demofoonte

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

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Demofoonte

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

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: Demofoonte

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

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Dance: End I: new Ballet, Les Oiseleurs-Sg Zuchelli, Sga Zuchelli, Mlle Vidini, LeDet; End II: Les Moissonneurs, as17781229; End: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Dance: End I: Les Oiseleurs, as17790123, but Sga _Zuchelli, Sga Tinti; End II: +Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise-, as17781229, but Sga _Zuchelli; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Dance: End I: Les Oiseleurs, as17790129; End Opera: Les Nymphes de Diane, as17781124

Ballet: End II: Annette et Lubin. As17781124, but unassigned-Sga _Zuchelli

Cast
Role: unassigned Actor: Sga _Zuchelli.

Performances

Mainpiece Title: Demofoonte

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

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17781128

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Performances

Mainpiece Title: Demofoonte

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

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Performances

Mainpiece Title: Demofoonte

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

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17791128, but Mlle Baccelli

Performances

Mainpiece Title: Demofoonte

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

Dance: End of new song: Les Oiseleurs, as17790123; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17790227

Song: End I: a new song-Pacchierotti; with violin obligato composed by Bertoni-Cramer; In III: an additional song composed by Handel-Pacchierotti

Performances

Mainpiece Title: Demofoonte

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

Song: In III: an additional song, as17790311

Performances

Mainpiece Title: Cymon

Afterpiece Title: A Peep behind the Curtain

Dance: Dance of Cupids, as17781223; Dance of Daemons, as17781223

Performances

Mainpiece Title: Enea E Lavinia

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

Dance: End I: a new Ballet, Hippomene et Atalante. Hippomene-Simonet, Atalante- Mlle Baccelli, Sg and Sga Zuchelli, Mlle Vidini, Slingsby; End II: a new Ballet, connected with the Opera, +Les Forges de Vulcain. Venus-Mme Simonet, the 3 Graces- Sga Zuchelli, Sga Tinti, Miss Rose, +Cupid- young Miss Simonet, +the 3 Cyclopes- Banti, Zuchelli, LeDet, +Vulcain- Slingsby; With a grand Chorus of the Cyclopes by $Sacchini-

Ballet: End Opera: a new Serious Ballet, La Fete du Ciel. Apollo-Mme Simonet; Flora-Sga Tinti; Zephir-Banti; Iris-Mlle Baccelli; To conclude with a grand Chaconne, in which-Mme Simonet will dance in a Man's Dress

Cast
Role: Flora Actor: Sga Tinti

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