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

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Harlequin and Quixotte; or, The Magic Arm

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Elfrida

Dance: End I: Le Triomphe de Themis, as17971226; Pas Russe-Laborie, Mme Hilligsberg; End Opera: a new Pastoral Ballet in 4 acts, composed by S. Gallet, Elisa; ou, Le Triomphe de la Nature-Laborie, Mme Hilligsberg, Didelot, Mme Rose, Miss Hilligsberg, Mme Laborie, Gourlier, Master Laborie

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Don Juan; or, The Libertine Destroyed

Dance: In 3rd piece: Pas Seul, incidental to the piece-Sga Bossi DelCaro

Performances

Mainpiece Title: The Deaf Lover

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

Afterpiece Title: Blue Devils

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: Throw Physick to the Dogs

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Surrender of Calais

Afterpiece Title: Blue Devils

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Romp

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Apprentice

Song: Vocal Parts-Danby, Wentworth, Brown, Tett, Denman, Atkins, [J.] Fisher, Aylmer, Gallot, Peck, Walker, Willoughby, Phillimore, Evans, Fisher, Caulfield Jun., Ms Arne, Ms Roffey, Ms Wentworth, Ms Jackson, Ms Maddocks, Ms Menage, Ms Menage Jun., Ms Chippendale, Ms Gawdry, Ms Butler, Ms Benson, Ms Bowyer, Ms Jacobs, Ms Coates

Performances

Mainpiece Title: Ines De Castro

Dance: As17990101

Performances

Mainpiece Title: Ines De Castro

Dance: As17990330

Performances

Mainpiece Title: The East Indian

Afterpiece Title: The Romp

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: Vocal Parts-Kelly, Sedgwick, Dignum, Trueman, Danby, Brown, Cook, Tett, Caulfield Jun., Sawyer, Danby Jun., Aylmer, Willoughby, Bardoleau, Clark, Mead, Elliot, Ms Crouch, Ms DeCamp, Ms Stephens, Ms Leak, Ms Dufour, Ms Arne, Ms Menage, Ms Roffey, Ms Menage Jun., Ms Jackson, Ms Wentworth, Ms Chippendale, Ms Jacobs, Ms Butler, Ms Bowyer, Ms Williams, Ms Saunders, Ms Gaudry, Ms Benson, Mrs Illingworth, Mrs Coates

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Shipwreck

Song: As17990529

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: Fortune's Frolick

Performances

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

Afterpiece Title: The Castle of Sorrento