SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sga Costanza"/1) | (@(roleclean,performerclean) "Sga Costanza")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 904 matches on Performance Comments, 676 matches on Performance Title, 217 matches on Event Comments, 0 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: La Buona Figliuola

Performance Comment: Sga Guglielmi, 1st time.

Dance: I: Grand Turkish Dance, as17720509; II: Pastoral Dance, as17720516; III: Le Triomphe de la Magie, as17720512

Event Comment: Sga Banti's indisposition continuing so severely as to prevent her performance, SEMIRAMIDE, intended for this Evening, is unavoidably deferred

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: [but not listed in playbill, i

Dance: As17940426 throughout

Opera: As17940401

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Miss Lucy in Town

Dance: II: La Mascarada-Brunoro, Mlle Bonneval; IV: Turkish Seraglio-Brunoro,Signora Costanza

Music: III: Concerto-Piantinada

Performances

Mainpiece Title: The Old Batchelor

Dance: Checo [Torinese], Chiaretta [Aquilanti], Brunoro, Costanza, Boromeo, Mlle Bonneval

Performances

Mainpiece Title: La Costanza Di Rosinella

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: 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

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

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: Divertisement, as17780207; End II: Les Bohemiens, as17771216; End Opera: Masquerade Dance, as17780303Minuet de la Cour=, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
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: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
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: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17821212 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17830116 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17830128 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17830128 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17830215 throughout

Cast
Role: Slaves Actor: Sga Crespi, Mlle Theodore

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17830204 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
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: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
Role: Giannina Actor: Sga Allegranti.

Dance: As17830322hroughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi
Role: Lisetta Actor: Sga Pollone
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: L'arcifanfano

Performance Comment: Principal Characters by Trebbi, Manzoletto, Gherardi, Micheli, Mrs Barthelemon, Sga Prudom, Sga Sestini. Cast from Larpent MS 538: Arcifanfano-Trebbi; Tagliacantoni-Manzoletto; Dottore Matteo-Gherardi; Malgoverno-Micheli; Gloriosa-Mrs Barthelemon; Garbata-Sga Prudom; Semplicina-Sga Sestini.
Cast
Role: Garbata Actor: Sga Prudom
Role: Semplicina Actor: Sga Sestini.

Dance: End I: New Ballet-Sg and Sga Zuchelli, Sga Crespi; End II: new ballet, composed by Simonet, The Fortunate Escape-Slingsby, Sga Tantini, Sga Crespi, Mme Simonet; End Opera: new ballet, composed by Simonet, The Country Gallant-, in which Mme Simonet, will dance in Men's Cloaths with Sga Tantini, Sga Crespi, Sg and Sga Zuchelli