SELECT * FROM london_stages WHERE eventid IN (35350, 42438, 42443, 42446, 42453, 42459, 42468, 42487, 42497, 42511, 42523, 42537, 42547, 42572, 42595, 42604, 42617, 42626, 42710, 43225, 43230, 43266, 44342, 44744, 44753, 44758, 44767, 44772, 44781, 44792, 44837, 44864, 44936, 44980, 44986, 45004, 45013, 45020, 45025, 45030, 45037, 45041, 45047, 45462, 45473, 45478, 45483, 45493, 45498, 45513, 45522, 45580, 45623, 46534, 46539, 46548, 46553, 46562, 46576, 46581, 46591, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48106, 48110, 48116, 48120, 48130, 48132, 48138, 48177, 48235, 48263, 48291, 48310, 48687, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48894, 48906, 48915, 48958, 48963, 48972, 50007, 50014, 50020, 50027, 50344, 50349, 50357, 50386, 50434, 50478, 50485, 50490, 50499, 50504, 50710, 50720, 50729, 50771, 50798, 50822, 50860, 51034, 51250, 51259, 51296, 51325, 51339, 51355, 51417, 51865, 52411, 52421, 52430) 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: Il Disertore

Cast
Role: Tonina Actor: Sga Mengis Boschetti

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I New Divertisement, as17821102, but Sga Crespi in place of Sga Sala; added: Pas de Deux, as17821210 End of Act II Apelles and Campaspe, as17821102

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I Apelles and Campaspe, as17821102; End of Opera New Divertisement, as17821102, with Passacaille, as17821109

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I New Divertisement, as17821102, but Sga Crespi in place of Sga Sala; End of Opera Il Ratio delle Sabine, as17821212

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17821212 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830111 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830116 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I New Divertisement, as17821130, but omitted: Mlle Theodore; End of Act II Le Tuteur Trompe, as17830111, but omitted: Mlle Theodore, Pas de Basque

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830128 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830128 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I Le Tuteur Trompe, as17830111, with two Pas de Deux, in a stile entirely new, called Pas de Lapons; or, Laplanders' Dance, by Slingsby and Mlle Theodore; End of Act II a new Pastoral Ballet by the principal Dancers, with a variety of Pas Seuls and a Pas de Deux by Slingsby and Mlle Theodore, and to conclude with a Grand Allemande by Lepicq, Mme Rossi, Slingsby, Mlle Theodore

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830215 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830204 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I an entirely new Divertissement, composed by Lepicq, li Riposo del Campo; or, The Recreations of the Camp, in which a Pas de Deux, La Recrue par Force; or, The Kidnappers, by Lepicq and Mme Rossi, and the other characters by Slingsby, Henry, Zuchelli, Sga Crespi, Mlle Theodore; End of Opera a new Ballet (1st time), founded on the Fairy Tale by Voltaire, La Begueule; or, She Wou'd and She Wou'd Not, in which a Minuet by Lepicq and Mme Rossi, and the other characters by Slingsby, Henry, Degville Jun., Sga Crespi, Mlle Theodore, Mme Simonet

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I Il Riposo del Campo, as17830313End of Act II La Bigueule, as17830313but omitted: Mlle Theodore, Mme Simonet

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: As17830322hroughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giannina Actor: Sga Allegranti.

Dance: End of Act I Il Riposo del Campo, as17830424; End of Act II La Bigueule, as17830313but omitted: Slingsby, Mme Simonet

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: Giannina Actor: Sga Rachele Dorta.

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: Giannina Actor: Sga Rachele Dorta.

Dance: As17840415 throughout

Performances

Mainpiece Title: Le Gelosie Villane

Cast
Role: Giannina Actor: Sga Rachele Dorta.

Dance: As17840424 throughout

Performances

Mainpiece Title: Giulio Sabino

Dance: As17860311hroughout

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Giannina Actor: Sga Benini.

Dance: As17870106

Performances

Mainpiece Title: Giannina E Bernardone

Cast
Role: Giannina Actor: Sga Benini.

Dance: As17870106