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, 38657, 38688, 38701, 38704, 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, 42121, 42423, 42428, 42468, 42473, 42552, 42557, 42567, 42572, 42577, 42582, 42587) 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: Demofoonte

Dance: As17781128

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: L'avaro Deluso

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: Demofoonte

Dance: As17781128

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana [recte Frascatana]

Dance: End I: La Noche Hollandoise, as17781124; End II: new ballet, Les Moissonneurs (the music by the celebrated Paisiello) with a Pas de Deux Anacreontique,-Mme Simonet, Slingsby, Banti, Sga Tinti, Sg and Sga Zuchelli, LeDet; End: Les Nymphes de Diane, as17781124

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

Dance: As17781128

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

Dance: As17781128

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

Dance: As17781128

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: As17790105

Performances

Mainpiece Title: Demofoonte

Dance: As17781128

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: As17790105

Performances

Mainpiece Title: Artaserse

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

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

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

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

Performances

Mainpiece Title: Artaserse

Dance: As17790209

Performances

Mainpiece Title: Demofoonte

Dance: As17790209

Performances

Mainpiece Title: Artaserse

Dance: As17790209

Performances

Mainpiece Title: Demofoonte

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

Performances

Mainpiece Title: Demofoonte

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

Dance: As17790311

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