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 Signora Spiletta"/1) | (@(roleclean,performerclean) "La Signora Spiletta")') 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 2474 matches on Performance Title, 686 matches on Performance Comments, 281 matches on Event Comments, 4 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Romp

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: A Gallimaufry

Afterpiece Title: Crotchet Lodge

Entertainment: Monologue.End: Monsieur Tonson (founded on fact, and recited at Freemason's Hall)-Fawcett

Performances

Mainpiece Title: The Mayor Of Garratt

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Battle of Hexham; or, Days of Old

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: New Hay at the Old Market

Song: 2nd piece: Vocal Parts-Cooke, Lyons, Aylmer, Boyce, Brown, Dibble, Dorion, Kenrick, Linton, Little, Walker, Miss Leak, Miss DeCamp, Mrs Gaudry, Mrs Hale, Mrs Butler, Mrs Norton, Miss Menage, Miss Granger

Performances

Mainpiece Title: Le Nozze Di Dorina

Afterpiece Title: Semiramide (Act II only)

Dance: As17950522

Music: As17950616

Performances

Mainpiece Title: Wild Oats; Or, The Strolling Gentlemen

Afterpiece Title: The Romp

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: The Romp

Song: As17951204

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: The Poor Sailor

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Adopted Child

Song: Mainpiece: Vocal Parts-Danby, Fisher, Maddocks, Trueman, Welsh, Master DeCamp, Master Gregson, Annereau, Atkins, Aylmer, Boyce, Bardoleau, Brown, Cook, Denman, Dixon, Dibble, Caulfield Jun., [J.] Fisher, Gallot, Tett, Walker, Willoughby, Miss Leak, Miss DeCamp, Miss Arne, Mrs Boimaison, Mrs Bramwell, Miss Chatterley, Miss Granger, Miss Jackson, Mrs Maddocks, Miss Menage, Miss Mellon, Mrs Butler, Miss Stuart

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Harlequin Captive

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Romp

Performances

Mainpiece Title: The Dead Alive

Afterpiece Title: The Battle of Hexham; or, Days of Old

Afterpiece Title: Bannian Day

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Devil to Pay; or, The Wives Metamorphosed

Song: Mainpiece: Vocal Parts-Aylmer, Boyce, Brown, Dibble, Kenrick, Linton, Little, Walker, Willoughby, Miss Leak, Miss DeCamp, Mrs Gaudry, Mrs Hale, Mrs Butler, Mrs Masters, Mrs Norton, Miss Menage, Miss Granger

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: A Cure For The Heart Ache

Afterpiece Title: Bantry Bay

Afterpiece Title: The Ghost

Performances

Mainpiece Title: Wives As They Were, And Maids As They Are

Afterpiece Title: Bantry Bay

Afterpiece Title: The Romp

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: Wives As They Were, And Maids As They Are

Afterpiece Title: Raymond and Agnes; or, The Castle of Lindenbergh

Song: Afterpiece: Vocal Parts-Gray, Linton, Street, Mrs Henley, Mrs Castelle, Miss Leserve. [Not listed on playbill, but in Songs (see below).

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Prisoner at Large

Song: Mainpiece: Vocal Parts-Aylmer, Brown, Dibble, Kenrick, Linton, Little, Caulfield Jun., Walker, Willoughby, Miss Andrews, Mrs Edward, Mrs Hale, Mrs Gaudry, Mrs Butler, Mrs Masters, Mrs Norton, Miss Menage, Mrs Wall, Mrs Benson, Miss Leserve

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: The Purse

Song: As17970705

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Irish Tar; or, Which is the Girl

Afterpiece Title: The Agreeable Surprise

Song: 1st piece: Vocal Parts, as17970623 but _Caulfield Jun., _Walker, _Willoughby, Mrs _Butler, Mrs _Masters, Mrs _Norton, Miss _Menage, Mrs _Wall, Mrs _Benson, Miss _Leserve