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) "La Lucchesina"/1) | (@(roleclean,performerclean) "La Lucchesina")') 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 2302 matches on Performance Title, 384 matches on Performance Comments, 156 matches on Event Comments, 4 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Orpheus and Eurydice

Dance: Sga Barbarina

Performances

Mainpiece Title: Miss In Her Teens

Afterpiece Title: Harlequin Fortune Teller

Entertainment: Italian Fireworks-as perform'd in the Opera House in the Haymarket

Performances

Mainpiece Title: Don Calascione

Dance: Between the Acts: Dancing-

Performances

Mainpiece Title: The Relapse

Afterpiece Title: The Anatomist

Dance: II: Wooden Shoe-Master Malter, two Miss Foulcades; III: Dutch Sailor-Mas. Maltere; IV: Les Fantasies de la Dance, as17500428 but-Miss Foulcade; V: Louvre & Minuet-Maltere, Miss Foulcade

Performances

Mainpiece Title: Entertainment Of Vocal And Instrumental Music

Song: Guadagni, Sga Cuzzoni, Sga Frasi

Performances

Mainpiece Title: Romeo And Juliet

Performances

Mainpiece Title: Romeo And Juliet

Dance: PPigmalion, as17510412, and others%

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Harlequin Skeleton

Dance: As17531030

Performances

Mainpiece Title: L'amour Costante

Dance: [Unspecified.]

Performances

Mainpiece Title: L'albergatrice

Performances

Mainpiece Title: Concert Of Vocal And Instrumental Music

Performances

Mainpiece Title: Othello

Afterpiece Title: Thomasand Sally

Performances

Mainpiece Title: Elvira

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Register Office

Dance: End: The Irish Lilt, as17630922; End I Farce: Hornpipe-Miss Baker

Performances

Mainpiece Title: Othello

Afterpiece Title: The Lying Valet

Dance: The Faggot Binders, as17640224

Performances

Mainpiece Title: Gli Stravaganti

Performances

Mainpiece Title: The Accomplish'd Maid

Dance: I: The Garland, as17661023; II: Rural Love, as17661120

Performances

Mainpiece Title: The Earl Of Warwick

Afterpiece Title: Polly Honeycombe

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Register Office

Dance: II: The Cow@Keepers (with alterations and additions)-Grimaldi's apprentices; III: Grand Dance The Lilliputian Camp, as17671202; V: By Particular Desire, The Cotillion, as17680406 but Miss Egan to list of dancers

Performances

Mainpiece Title: The Death Of Abel

Music: As17700307

Performances

Mainpiece Title: I Viaggiatori Ridicoli

Performances

Mainpiece Title: The Maid The Mistress

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Register Office

Entertainment: End: Bucks Have at Ye All-Richards

Monologue: II: Teague's Rambles to London. Capt. O'Brallaghan (with the favorite song in Love a La Mode)-Broderick; Terence O'Droghida-Youngs; the Knife Grinder (By Particular Desire)-Broderick