SELECT * FROM london_stages WHERE eventid IN (429, 500, 1304, 4687, 4733, 8408, 8447, 8454, 8460, 8477, 8564, 8708, 8779, 8974, 9051, 9152, 9580, 9658, 10446, 10507, 11074, 11176, 11277, 11853, 12825, 12977, 13211, 13297, 13947, 14126, 14602, 16237, 17163, 17254, 17726, 18293, 18413, 18514, 18681, 18820, 19054, 19128, 19417, 19542, 19807, 19933, 19986, 20262, 20388, 20531, 22074, 22102, 22116, 22371, 22520, 22728, 22754, 23135, 24388, 26865, 26870, 26881, 26902, 26911, 26917, 26922, 26927, 26932, 26953, 27263, 27272, 37780, 38308, 38311, 38366, 38375, 38380, 38389, 38398, 38403, 38409, 38419, 38424, 38433, 38438, 38447, 38452, 38461, 38466, 38475, 38487, 38513, 38527, 38542, 38558, 38567, 38582, 38595, 38610, 38626, 38655, 38670, 38677, 38686, 38691, 38723, 38782, 38808, 39510, 39524, 39538, 39552, 39566, 39580, 39594, 39617, 39631, 39645, 39659, 39672, 39686, 39701, 39715, 39728, 39737, 39742, 39756, 39766, 39771, 39778, 39788, 39804, 39820, 39834, 39851, 39865, 39879, 39897, 39929, 39939, 41336, 41345, 41348, 41357, 41372, 41386, 41413, 41422, 41437, 41467, 41477, 41486, 41492, 41501, 41506, 41511, 41516, 41535) 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 Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village, as17760312

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village, as17760224

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: Ballet Pastoral, as17760328

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: Le Fete du Village, as17760224

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: La Fete du Village, as17760224

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Vestale

Dance: Apollon e Daphne, as17751031; Minuet de la Cour-the two Vallouys; End II: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17760516

Ballet: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: Diane et Endymion, as17760312

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: Creso

Dance: End I: New Ballet, as17771104; End II: Le Devin du Village, as17771104; End Opera: La Polonaise Favourite, as17771104

Performances

Mainpiece Title: Creso

Dance: End I: Le Devin du Village, as17771104; End II: New Ballet, as17771104; End Opera: a Ballet Demi-caractere, La Clochette-Mons and Mme Simonet, Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet

Performances

Mainpiece Title: Creso

Dance: As17771108

Performances

Mainpiece Title: Creso

Dance: End I: New Ballet, as17771104; End II: Le Devin du Village, as17771104; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: Creso

Dance: As17771118

Performances

Mainpiece Title: Creso

Dance: End I: Le Devin du Village, as17771209; End II: Serious Ballet, as17771209; End Opera: La Clochette, as17771209

Performances

Mainpiece Title: Creso

Dance: End I: Le Devin du Village, as17771104; End II: Les Bohemiens, as17771216; End Opera: Serious Ballet, as17771209

Performances

Mainpiece Title: Creso

Dance: End I: La Polonaise Favourite, as17771104; End II: Le Devin du Village, as17771104; End Opera: Serious Ballet, as17771209

Performances

Mainpiece Title: Creso

Dance: As17771108

Performances

Mainpiece Title: Creso

Dance: End I: Les Bohemiens, as17771216; End II: Serious Ballet, as17771209; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: Creso

Dance: End I: Serious Ballet, as17780120; End II: Les Bohemiens, as17771216; End Opera: La Polonaise Favourite, as17771104

Performances

Mainpiece Title: Creso

Dance: End I: Serious Ballet, as17780120; End II: Les Bohemiens, as17771216; End Opera: La Polonaise Favourite, as17771104, but Mme _Simonet

Performances

Mainpiece Title: Erifile

Dance: End I: La Polonaise Favourite, as17780131; End II: Les Bohemiens, as17771216; End Opera: Divertisement-Mons and Mlle Banti, Vallouy@le@cadet, Mlle Baccelli

Song: In II: Air-Sga Danzi; accompanied on the Hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: Erifile

Dance: As17780207

Performances

Mainpiece Title: Erifile

Dance: As17780207

Performances

Mainpiece Title: Erifile

Dance: As17780207

Performances

Mainpiece Title: Creso

Dance: As17780203 throughout

Song: II: a new song by Sacchini-Roncaglia; accompanied on the violin-Cramer