SELECT * FROM london_stages WHERE eventid IN (17065, 17406, 17550, 17583, 17633, 17821, 18016, 18088, 19180, 19566, 30345, 32419, 32421, 32423, 32425, 32428, 32430, 32433, 32435, 32437, 33662, 33671, 36866, 36868, 36871, 36873, 36875, 36881, 36930, 36936, 36947, 36972, 37011, 37060, 37107, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39134, 39139, 39186, 39221, 39279, 39290, 39311, 39358, 39650, 39665, 39677, 39692, 39706, 39720, 39815, 39839, 41482, 41521, 41530, 41545, 41560, 41565, 41581, 41593, 41596, 41605, 42085, 42102, 42295, 42438, 42443, 42446, 42453, 42459, 42468, 42487, 42497, 42511, 42523, 42537, 42547, 42572, 42595, 42604, 42617, 42626, 42710, 44536, 44539, 44541, 44544, 44545, 44546, 44550, 44552, 44553, 44571, 44581, 45056, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45357, 45382, 45400, 45527, 47089, 47094, 47099, 47105, 47110, 47115, 47120, 47129, 47135, 47140, 47146, 47152, 47163, 47169, 47188, 47302, 47379, 48795, 48800, 48809, 48814, 48823, 49075, 49084, 49098, 49104, 49113, 49537, 49546, 49595, 51228, 51232, 51275, 51281, 51809, 51829) 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

Cast
Role: Lisetta Actor: Sga Luiggia Farnese

Dance: End I: Les Amans Heureux, as17770104; End II: Divertisement-Simonet, Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet; End Opera: New Ballet (composed by Simonet)-Simonet, Mlle Baccelli, Mlle DeCamp, Sg and Sga Zuchelli; in which, particularly a grand Chaconne in two Parts, habille en homme-Mme Simonet

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Luiggia Farnese

Dance: End I: Les Amans Heureux, as17770104; End II: New Serious Ballet, as17770412; End Opera: La Clochette, as17770315

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Luiggia Farnese

Dance: End I: New Serious Ballet, as17770412; End II: Les Amans Heureux, as17770104; End Opera: Serious Ballet, as17770225Chaconne-_, Pas de deux-_

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Luiggia Farnese

Dance: End I: La Paysane Distraite, as17770524, but Sga _Zuchelli; End II: Serious Ballet, as17770225, but Sga _Zuchelli; End Opera: La Clochette, as17770315but Sga _Zuchelli

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

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

Dance: As17780210

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

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

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

Dance: As17780203

Song: II: new song (composed by Sacchini)-Pozzi; accompanied on the flute-Florio; III: Che dirnen so-Jermoli

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Lisetta Actor: Sga Jermoli

Dance: End I: Divertisement, as17780207; End II: Les Bohemiens, as17771216; End Opera: Masquerade Dance, as17780303Minuet de la Cour=, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: End I: The Fortunate Escape, as17801216; End II: Grand Serious Ballet, as17810315Pas@Solo, as17810315Pas de Deux, as17810315Grand Chaconne, as17810315End Opera: Les Amans Surpris, as17801216

Song: Act II: the favourite song in Il Barone di Torre Forte-Sga Sestini

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: End I: Les Amans Surpris, as17801216

Ballet: End II: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: End I: Les Amans Surpris, as17801216

Ballet: End II: Ninette a la Cour (with Improvements). As17810327

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: As17810510 throughout

Ballet: Medee et Jason. As17810510

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: As17810324throughout.

Ballet: Ninette a la Cour. As17810324

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: As17810510 throughout

Ballet: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: As17810501 throughout

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: As17810501

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Ballet: Medee et Jason. As17810329

Dance: As17810329throughout.

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Lisetta Actor: Sga Prudom

Dance: As17810501

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Henry and Emma

Afterpiece Title: The Capricious Lovers

Dance: End of Act I of afterpiece The Irish Fair, as17820406

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Divorce

Dance: Dance of Daemons as17820418

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Capricious Lovers

Cast
Role: Lisetta Actor: Mrs Wrighten

Dance: End of Act I of afterpiece The Irish Fair by Blurton, Miss M. Stageldoir