SELECT * FROM london_stages WHERE eventid IN (38927, 38941, 38955, 38969, 38978, 38992, 38997, 39005, 39010, 39019, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39244, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39328, 39332, 39340, 39344, 39350, 39352, 39356, 39358, 39364, 39367, 39373, 39501, 39510, 39515, 39524, 39529, 39538, 39543, 39552, 39557, 39566, 39571, 39580, 39585, 39594, 39599, 39617, 39631, 39636, 39645, 39650, 39659, 39665, 39672, 39677, 39686, 39692, 39701, 39706, 39715, 39720, 39728, 39733, 39737, 39742, 39747, 39756, 39761, 39766, 39771, 39778, 39788, 39794, 39799, 39804, 39809, 39815, 39820, 39825, 39834, 39839, 39846, 39851, 39856, 39865, 39870, 39879, 39885, 39897, 39903, 39908, 39911, 39914, 39918, 39924, 39929, 39933, 39939, 39944, 40689, 40704, 40709, 40715, 40724, 40744, 40773, 40785, 40798, 40810, 40822, 40849, 40863, 40878, 40887, 40892, 40908, 40913, 40923, 40929, 40939, 40968, 40981, 40995, 41000, 41007, 41016, 41024, 41032, 41220, 41225, 41267, 41307, 41336, 41345, 41348, 41357, 41362, 41367, 41372, 41377, 41386, 41391, 41395, 41400, 41405, 41409, 41413, 41418, 41422, 41426, 41431, 41437, 41443, 41448, 41456, 41463, 41472, 41477, 41482, 41486, 41492, 41501, 41506, 41511, 41516, 41521, 41530, 41535, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 41608, 41611, 41614, 41619, 41622, 41777, 41782, 41791, 41798, 41805, 41810, 41819, 41834, 41849, 41873, 41904, 41919, 41951, 41959, 41981, 41995, 42008, 42012, 42027, 42038, 42048, 42064, 42079, 42109, 42120, 42130, 42155, 42185) 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: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

Dance: As17771108

Performances

Mainpiece Title: Le Due Contesse

Dance: As17771108

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: Le Due Contesse

Dance: As17771108

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

Dance: As17771118

Performances

Mainpiece Title: Le Due Contesse

Dance: End I: Le Devin du Village, as17771104; End II: La Clochette, as17771115; End Opera: a grand Serious Ballet-Mons Simonet, Mme Simonet, Mlle Baccelli, Zuchelli, Vallouy@le@cadet

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: Vittorina

Dance: End I: New Ballet, as17771104; End II: new ballet, Demicaractere, composed by Banti, Les Bohemiens-Sg and Sga Banti, Sg and Sga Zuchelli; End Opera: La Polonaise Favourite, as17771104

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: Vittorina

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

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

Dance: As17771108

Performances

Mainpiece Title: Le Due Contesse

Dance: As17771223

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli
Role: Baronessa Irere Actor: Sga Prudom
Role: Rosina Actor: Sga Pozzi.

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

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli
Role: Baronessa Irere Actor: Sga Prudom
Role: Rosina Actor: Sga Pozzi.

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

Performances

Mainpiece Title: Creso

Cast
Role: Cratina Actor: Sga Prudom
Role: Ariene Actor: Sga Francesca Danzi.

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli
Role: Baronessa Irere Actor: Sga Prudom
Role: Rosina Actor: Sga Pozzi.

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

Performances

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: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli
Role: Baronessa Irere Actor: Sga Prudom
Role: Rosina Actor: Sga Pozzi.

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli
Role: Baronessa Irere Actor: Sga Prudom
Role: Rosina Actor: Sga Pozzi.

Dance: As17780210

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli
Role: Baronessa Irere Actor: Sga Prudom
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Le Devin du Village, as17771104; End II: Divertisement, as17780207; End Opera: a new Grand Ballet Espagnol, La Serenade Interrompuee-Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet; in which a Pas de Deux du Masque-Simonet, Mlle Baccelli; accompanied on the Guitarre-Noferi