SELECT * FROM london_stages WHERE eventid IN (1772, 15408, 15415, 15421, 15427, 15727, 15730, 18662, 25898, 25904, 25911, 25920, 25934, 25947, 25966, 25973, 26044, 28579, 28580, 28581, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28597, 28606, 28612, 28632, 30551, 30895, 30909, 30921, 30939, 30949, 34028, 34031, 34033, 34036, 34038, 34043, 34045, 34048, 34052, 34060, 34063, 34065, 34075, 34082, 34088, 34127, 34192, 34239, 34372, 34503, 34683, 34761, 34929, 35088, 35197, 35851, 37016, 38366, 38375, 38398, 38409, 38424, 38438, 38475, 39585, 39599, 39650, 39665, 39677, 39692, 39706, 39720, 39815, 39839, 40758, 40761, 40763, 41797, 42305, 43225, 43230, 43266, 43573, 43578, 43583, 43588, 43597, 44219, 44228, 44231, 44240, 44245, 44254, 44375, 44491, 44511, 45795, 45797, 45801, 45805, 45973, 45995, 46000, 46008, 46013, 46021, 46024, 46025, 46076, 46286, 46526, 46530, 46531, 46540, 46558, 46568, 46569, 46573, 46582, 46587, 46588, 46634, 46639, 46796, 46993, 47136, 47137, 47142, 47153, 47176, 47190, 47195, 47573, 47701, 47717, 47742, 47746, 47747, 47776, 47803, 48231, 48244, 48245, 48255, 48283, 48297, 48301, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48894, 48906, 48915, 48958, 48963, 48972, 49238, 49446, 49469, 49473, 49490, 49511, 49515, 49540, 49577, 49608, 49613, 49624, 49636, 49671, 49838, 50021, 50033, 50059, 50335, 50365, 50425, 50439, 50533, 50565, 50633, 50669, 50679, 50682, 50738, 50768, 50798, 50807, 50816, 50822, 50882, 51204, 51229, 51242, 51353, 51371, 51376, 51405, 51415, 51420, 51449, 51450, 51452, 51454, 51462, 51465, 51696, 51711, 51729, 51732, 51748, 51757, 51772, 51842, 51846, 51851, 51855, 51989, 51997, 51999, 52004, 52007, 52008, 52026, 52049, 52324, 52357, 52360, 52471, 52510, 52524) 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 Vera Costanza

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

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

Performances

Mainpiece Title: La Vera Costanza

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

Performances

Mainpiece Title: La Vera Costanza

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

Dance: As17780210

Performances

Mainpiece Title: La Vera Costanza

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

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

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: The Shepherdess Of The Alps

Cast
Role: Marchioness Actor: Mrs Pitt

Afterpiece Title: The Upholsterer

Dance: As17791022

Performances

Mainpiece Title: The Shepherdess Of The Alps

Cast
Role: Marchioness Actor: Mrs Pitt

Afterpiece Title: Catherine and Petruchio

Dance: As17791013

Performances

Mainpiece Title: The Shepherdess Of The Alps

Cast
Role: Marchioness Actor: Mrs Pitt

Afterpiece Title: The Apprentice

Dance: As17791022

Performances

Mainpiece Title: The Banditti; Or, Love's Labyrinth

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: False Delicacy

Cast
Role: Miss Marchmont Actor: Mrs Brereton

Afterpiece Title: Robinson Crusoe

Dance: As17820921

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: : Marchese Roberto Actor: Franchi

Dance: End of Act I Le Reveil du Bonheur, as17840203; End of Opera Divertissement, in which a Pas de Deux, as17831216, and to conclude with the favourite Caledonian Pas de Trois, as17831129

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: : Marchese Roberto Actor: Franchi

Dance: As17840415 throughout

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: : Marchese Roberto Actor: Franchi

Dance: As17840424 throughout

Performances

Mainpiece Title: Il Curioso Indiscreto

Dance: End of Act I an entirely new Divertissement (composed by Lepicq) by Nivelon, Mlle Dorival (from the Opera-House in Paris; their 1st appearance), Frederic, Mme Julien, Mlle Fusi, Mme Bithmer (their 1st appearance), Henry, Zuchelli, Sg and Sga Pitrot Angiolini (from the King's Theatre at Naples; their 1st appearance); End of Opera a new Grand Ballet (composed by Lepicq) Le Parti de Chasse d'Henry IV-King Henry rv-Angiolini; the other Characters by Lepicq, Mme Rossi, Frederic, Mlle Dorival, Zuchelli, Nivelon, Sga Pitrot Angiolini

Performances

Mainpiece Title: Il Curioso Indiscreto

Dance: As17841218 throughout

Performances

Mainpiece Title: Il Curioso Indiscreto

Dance: As17841218 throughout

Performances

Mainpiece Title: Il Curioso Indiscreto

Dance: As17841218 throughout

Performances

Mainpiece Title: Il Curioso Indiscreto

Dance: End of Act I Divertissement, as17841218; End of Opera Le Tuteur Trompe, with the Fandango, by Lepicq, Mme Rossi, Frederic, Zuchelli, Mme Bithmer, Henry, Nivelon, Mlle Dorival

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Marchese Tulipano Actor: Morigi

Dance: End of Act I a new Divertissement Serieux (composed by Giroux) by Vestris, Sga Carolina, the two Mlles Simonet, Duquesney Jun., Mlle Mozon, &c, and to conclude with a Grand Chaconne, [the music] composed by Sacchini; End of Opera a new Divertissement Villageois (composed by D'Egville) by Vestris, Sga Carolina, Mme Crespi, the two Mlles Simonet, Duquesney Jun., Spozzi, Mlle Mozon, &c

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Marchese Tulipano Actor: Morigi

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Marchese Tulipano Actor: Morigi

Dance: As17860124 throughout

Performances

Mainpiece Title: Il Marchese Tulipano

Cast
Role: Il Marchese Tulipano Actor: Morigi

Dance: As17860124 throughout