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 Casentini"/1) | (@(roleclean,performerclean) "Sga Casentini")') 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, 218 matches on Event Comments, 96 matches on Roles/Actors, and 0 matches on Author.

Performances

Dance: As17910322

Ballet: Telemachus in the Island of Calypso. As17910322

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: End I: La Fille Mal Gardee, as17910430

Ballet: End Opera: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910510

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: End I: Divertisement, as17910217; End Opera: Telemachus in the Island of Calypso, as17910414

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910531

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910517

Ballet: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: End I: Le Triomphe de la Folie, as17910503; End Opera: The Deserter, as17910428

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910610

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910430

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: End I: La Fille Mal Gardee, as17910430; End Opera: Le Siege de Cythere, as17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910616

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910322

Ballet: Telemachus in the Island of Calypso. As17910322

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910623

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: La Locanda

Cast
Role: Guerina Actor: Sga Casentini
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti.

Dance: As17920214

Performances

Mainpiece Title: La Locanda

Cast
Role: Guerina Actor: Sga Casentini
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti.

Dance: As17920214

Performances

Mainpiece Title: La Locanda

Cast
Role: Guerina Actor: Sga Casentini
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti.

Dance: As17920214