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

Afterpiece Title: The Country House

Dance: SScots Dance-Sga Barberina; Les Savoyardes, as17420501; La Provencale, as17420212

Ballet: RRural Assembly. As17420508

Performances

Mainpiece Title: Hamlet

Dance: SScots Dance-Sga Barbarina; Les Savoyardes, as17420501; La Provencale, as17420212

Ballet: RRural Assembly. As17420508

Performances

Mainpiece Title: The Miser

Dance: SScots Dance-Sga Barbarina; Les Savoyardes, as17420501; La Provencale, as17420212

Ballet: RRural Assembly. As17420508

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Perseus and Andromeda

Dance: SScots Dance-Sga Barberina; Les Savoyardes, as17420501; La Provencale, as17420212

Ballet: RRural Assembly. As17420508

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplish'd Fools

Afterpiece Title: The Virgin Unmask'd

Song: III: The Early Horn-Lowe

Dance: II: Tyrolean Dance-Borromeo, Signora Constanza, Desse, Baudouin, LaPierre, Mrs Thomson, Mlle Gendon, Mlle Fabres; IV: A Peasant Dance-Borromeo, Sga Constanza; being the 1st time of their appearing on that stage

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Mock Doctor

Dance: II: Les Matelotes, as17421009; Turkish Seraglio-Brunoro, Boromeo, Mlle Bonneval, Sga Constanza

Song: III: Song-Beard

Performances

Mainpiece Title: The Provoked Husband; Or, A Journey To London

Dance: Checo Torinese, Sga Charetta Aquilanti, their 1st appearance, Boromeo, Mlle Bonneval

Music: Concerto-Veracini

Song: Beard

Performances

Mainpiece Title: The Careless Husband

Song: I: Beard

Music: III: A Concerto on the Violincello-Cervette

Dance: II: Grand Comic Dance, as17421117; IV: A New Comic Ballet, call'd Les Moisoneurs de la Styrie-Checo Torinese, Sga Chiaretta Aquilanti, Boromeo

Performances

Mainpiece Title: The Old Batchelor

Dance: DDutch Skipper, as17421025; Characters of Dancing, as17421025; Musette-Picq, Sga Domitilla; Grand Ballet, as17421108

Performances

Mainpiece Title: The Distrest Mother

Dance: TTambourine-Cooke; Characters of Dancing, as17421025; Les Savoyards-Villeneuve, Sga Domitilla; La Provencale, as17421105

Performances

Mainpiece Title: The Stratagem

Dance: II: a New Comic Dance call'd Neopolitan Punch-Checo Torinese, Sga Chiaretta Aquilanti, Boromeo, Mlle Bonneval; IV: A New Comic Dance call'd Italian Gardeners-Checo, Chiaretta

Performances

Mainpiece Title: The Beggar's Opera

Dance: I: Neopolitan Punch-Chico, Sga Chiaretta, Mlle Bonneval; II: Italian Gardeners, as17421231

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Italian Gardeners, as17421231; III: a New Serious Dance-Sga Aquilanti; V: A New Sicilian Peasant-Checo, Chiaretta

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Virgin Unmask'd

Dance: Entertainments-Cooke, Lalauze, Sga Campioni (being her 1st appearance on that stage)

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Anatomist

Song: I, III: Lowe

Dance: II: A Grand Comic Dance-Leonardi, Sga Bettini; IV: Grand Dance-Muilment

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Devil to Pay

Dance: III: Leonardi, Sga Bettini; IV: Grand Dance, as17441217

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Mock Doctor

Song: I, IV: Lowe

Dance: V: Grand Dance-Sga Bettini

Performances

Mainpiece Title: Richard Iii

Afterpiece Title: The Devil to Pay

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Distressed Mother

Afterpiece Title: The Mock Doctor

Dance: III: Grand Dance, as17441217; V: Sga Bettini

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Temple of Dulness

Cast
Role: Sga Dorinna Actor: Mrs Arne

Dance: II: Muilment; IV: Sga Bettini

Performances

Mainpiece Title: The Committee

Afterpiece Title: Temple of Dulness

Cast
Role: Sga Dorinna Actor: Mrs Arne

Dance: II: Serious Dance-Sga Bettini; IV: Grand Dance, as17441217

Performances

Mainpiece Title: Volpone; Or, The Fox

Afterpiece Title: Pyramus and Thisbe

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: Rosamond

Dance: II: Sga Bettini; III: Shepherd's Dance-Muilment

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Mock Doctor

Song: II: Lowe

Dance: III: Grand Dance-Muilment; V: Comic Dance-Sga Bettini

Performances

Mainpiece Title: Mariamne

Dance: Cooke, Sga Campioni