SELECT * FROM london_stages WHERE eventid IN (31205, 32535, 32650, 33371, 33385, 33399, 33408, 33413, 33427, 33432, 33445, 33450, 33464, 33478, 33493, 33505, 33519, 37309, 37314, 37323, 37328, 37337, 37351, 37390, 37395, 37404, 37418, 37432, 37438, 37542, 38923, 38927, 38936, 38941, 38950, 38955, 38964, 38969, 38978, 38992, 38997, 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, 39249, 39256, 39267, 39272, 39279, 39284, 39290, 39295, 39300, 39311, 39319, 39328, 39332, 39340, 39344, 39350, 39352, 39356, 39358, 39364, 39367, 39373, 39382, 39501, 39510, 39515, 39524, 39529, 39538, 39543, 39552, 39557, 39566, 39571, 39580, 39585, 39594, 39599, 39617, 39631, 39636, 39645, 39650, 39659, 39665, 39672, 39677, 39692, 39706, 39720, 39733, 39737, 39747, 39761, 39766, 39778, 39783, 39794, 39799, 39809, 39815, 39825, 39839, 39846, 39856, 39870, 39885, 39903, 39908, 39914, 39924, 39929, 39933, 39944, 40119, 40133, 40147, 40161, 40166, 40171, 40177, 40186, 40191, 40200, 40206, 40215, 40220, 40246, 40260, 40273, 40293, 40317, 40321, 40404, 40414, 40429, 40461, 40468, 40475, 40482, 40490, 40493, 40656, 40661, 40670, 40675, 40684, 40698, 40739, 40753, 40798, 40810, 40822, 40849, 40853, 40863, 40878, 40887, 40892, 40908, 40913, 40923, 40929, 40934, 40939, 40944, 40949, 40954, 40963, 40975, 40990, 41000, 41013, 41021, 41029, 41037, 41220, 41225, 41267, 41276, 41288, 41293, 41302, 41307, 41316, 41321, 41330, 41336, 41345, 41348, 41357, 41362, 41367, 41372, 41377, 41386, 41391, 41413, 41482, 41521, 41530, 41545, 41560, 41565, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 41611, 41614, 41619, 41622, 41777, 41782, 41791, 41798, 41805, 41810, 41819, 41824, 41829, 41834, 41844, 41849, 41854, 41859, 41864, 41873, 41878, 41888, 41899, 41904, 41910, 41919, 41927, 41932, 41937, 41946, 41951, 41959, 41964, 41968, 41972, 41977, 41981, 41995, 42004, 42008, 42023, 42054, 42059, 42074, 42089, 42104, 42135, 42138, 42155, 42158, 42169, 42180, 42185, 42188, 42193, 42196, 42201) 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 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: Adrasto Actor: Micheli

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

Cast
Role: Adrasto Actor: Micheli

Dance: As17781128

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: As17790105

Performances

Mainpiece Title: Demofoonte

Cast
Role: Adrasto Actor: Micheli

Dance: As17781128

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: As17790105

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

Cast
Role: Adrasto Actor: Micheli

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

Performances

Mainpiece Title: Demofoonte

Cast
Role: Adrasto Actor: Micheli

Dance: As17790209

Performances

Mainpiece Title: Demofoonte

Cast
Role: Adrasto Actor: Micheli

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: Adrasto Actor: Micheli

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: Adrasto Actor: Micheli

Dance: As17790311

Song: In III: an additional song, as17790311

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: La Buona Figliuola

Dance: As17790429

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17790429

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: L'olimpiade

Dance: End I: Les Paysans Voles, as17790515, but _Banti, LeDet; End II: +Les Moissonneurs, as17781229; End Opera: a New Divertisement-Simonet, Banti, Mlle Baccelli

Performances

Mainpiece Title: L'olimpiade

Dance: End I: Les Paysans Voles, as17790529; End II: Hippomene et Atalante, as17790325End Opera: New Divertisement, as17790529

Performances

Mainpiece Title: L'olimpiade

Dance: As17790605

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: Adrasto Actor: Micheli

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: L'olimpiade

Dance: End I: Ballet by Fairies, as17790302End II: Les Moissonneurs, as17781229; End Opera: La Serenade Interrompuee, as17790515; Pas de Deux du Masque, as17790515

Performances

Mainpiece Title: Alessandro Nelle Indie

Cast
Role: Timagene Actor: Micheli

Dance: End I: Indian Ballet (composed by Zuchelli), adapted to the Opera-Sg and Sga Zuchelli, Henry, young Miss Simonet; End II: new Pastoral Ballet (composed by Zuchelli and Slingsby)-Slingsby, Sg and Sga Zuchelli, Sga Tantini (1st appearance in England); End Opera: Grand Serious Ballet connected with the Opera (composed by Favre Guiardele, ballet master), in which the celebrated Chaconne of Jomelli's-Slingsby, Sga Tantini, Favre Guiardele (1st appearance in England)

Performances

Mainpiece Title: Alessandro Nelle Indie

Cast
Role: Timagene Actor: Micheli

Dance: As17791127

Performances

Mainpiece Title: Alessandro Nelle Indie

Cast
Role: Timagene Actor: Micheli

Dance: As17791127