SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Lampe"/1) | (@(roleclean,performerclean) "Mr Lampe")') 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 4270 matches on Event Comments, 1340 matches on Performance Comments, 555 matches on Performance Title, 18 matches on Author, and 6 matches on Roles/Actors.

Performances

Mainpiece Title: The Fair Penitent

Dance: DDutch Skipper, as17421025; Characters of Dancing, as17421025; Grand Ballet, as17421108

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Afterpiece Title: The Lying Valet

Dance: I: a Serious Dance-Mlle Roland; III: Sailor's Dance-Delamayne, Mlle Roland; V: (by Desire) a Minuet, Louvre-Delamayne, Mlle Roland. [Dances not in Daily Advertiser.

Performances

Mainpiece Title: Sir Courtly Nice; Or, It Cannot Be

Afterpiece Title: Bickerstaff's Unburied Dead

Song: Mrs Dunstall

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Lying Valet

Song: End of Farce:By Particular Desire, Bumper Squire Jones-Beard

Performances

Mainpiece Title: The Siege Of Damascus

Afterpiece Title: Perseus and Andromeda

Dance: TTambourine-Cooke; Characters of Dancing, as17421025; La Provencale, as17421105

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Scotch Dance-Delamain, Anne Auretti; II: Tambourine-Anne Auretti; III: Characters of Dancing, as17421025; IV: Un Pas de Deux-Anne and Janneton Auretti; V: L'Aimable Vainqueur, Minuet-Picq, Anne Auretti

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Lying Valet

Music: II: Concerto on German Flute-Burk Thumoth

Song: IV: Stella and Flavia-Beard

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Lying Valet

Song: As17430413

Music: As17430416

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Toyshop

Dance: I: Dutch Skipper, as17421025; III: Peasants, as17421230; V: Le Rendezvous Gallant, as17421217

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Lying Valet

Dance: I: A French Peasant-Froment, Mlle Gondeau; III: A New Serious Dance-Desse, Mrs Walter; V: La Florana, as17430408

Song: II: Stella and Flavia-Beard; IV: Bumper Squire Jones-Beard, Lowe

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lying Valet

Song: III: Song-Lowe

Dance: II: Tyrolean Dance, as17421129; IV: Sicilian Peasant, as17430310

Performances

Mainpiece Title: Cato

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: Cato

Dance: II, V: As17431003

Performances

Mainpiece Title: Roxana; Or, Alexander In India

Performances

Mainpiece Title: Roxana

Performances

Mainpiece Title: The Assignation; Or, Love In A Nunnery

Dance: LLes Paisans Moisonneurs, as17431026

Performances

Mainpiece Title: The Rehearsal

Performances

Mainpiece Title: The Rehearsal

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Lawyer's Feast

Song: II: Song-Morland

Dance: V: New Dance, as17431123

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Old Man Taught Wisdom

Performances

Mainpiece Title: None

Performances

Mainpiece Title: Othello, Moor Of Venice

Performances

Mainpiece Title: Acis And Galatea

Music: Concerto on German Flute-Burk Thumoth

Song: An English and an Italian Song-the sister of the above lady, a child of nine years; the whole to conclude with: the Coronation Anthem God Save the King-; Trumpet-Valentine Snow

Performances

Mainpiece Title: Samson