The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sga Colombati"/1) | (@(roleclean,performerclean) "Sga Colombati")') 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 903 matches on Performance Comments, 647 matches on Performance Title, 217 matches on Event Comments, 111 matches on Roles/Actors, and 0 matches on Author.

Performances

Mainpiece Title: La Serva Padrona

Dance: As17940623throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940531 throughout

Performances

Mainpiece Title: L'amore Contrastato

Dance: As17941206

Performances

Mainpiece Title: L'amore Contrastato

Dance: As17941206

Performances

Mainpiece Title: L'amore Contrastato

Dance: As17941206

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: As17950110

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: End I: Divertisement, as17941220; End II: a new Ballet by Onorati L'Amant Retrouve-Gentili, Lahante, Aumer, Mlle Rosine, Mme DelCaro, Mme Hilligsberg

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950127

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: Dances- see17950124

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: As17950124

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950127

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950124

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: End I: Divertisement, as17941220; End II: New Divertisement by Onorati-

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: End I: New Divertisement, as17950228; End II: L'Amant Retrouve, as17950124

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: As17950228

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: As17950228

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: As17950228

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950303

Performances

Mainpiece Title: Aci E Galatea

Cast
Role: Dorinda Actor: Sga Colombati.

Dance: End I: New Divertisement, as17950228; End II: L'Espiegle Soubrette, as17950124

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: End I: New Divertisement, in which the Pas Russe-Mme Hilligsberg, Mme Hilligsberg's sister in men's clothes; End II: a new Grand Dramatic Pantomime Ballet, in 3 parts, composed by Onorati, Paul et Virginie-Gentili, Aumer, Lahante, Simpson, Mme DelCaro, Miss J. Hilligsberg, Mme Rossi, Mme Hilligsberg who will perform in men's clothes and dance a Scotch Reel in that character