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) "Mr Farquhar"/1) | (@(roleclean,performerclean) "Mr Farquhar")') 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 4241 matches on Event Comments, 1145 matches on Performance Comments, 1076 matches on Author, 528 matches on Performance Title, and 2 matches on Roles/Actors.

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lying Valet

Dance: II: New Dutch Dance, as17531117; V: Gipsey Tambourine, as17531012

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: Fortunatus

Song: I: Beard

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Chaplet

Dance: III: A Hornpipe-Granier

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Philoclea

Performances

Mainpiece Title: Lo Studente A La Moda

Dance: As17540118

Performances

Mainpiece Title: Philoclea

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Knights

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Knights

Performances

Mainpiece Title: Constantine

Performances

Mainpiece Title: Admeto

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Sorcerer

Dance: LLes Taileurs, as17531210

Performances

Mainpiece Title: Love's Last Shift

Afterpiece Title: The London Prentice

Dance: Devisse, Mlle Auretti

Performances

Mainpiece Title: Ara

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Old Woman's Oratory

Performances

Mainpiece Title: Virginia

Afterpiece Title: Lethe

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Shepherd's Lottery

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Shepherd's Lottery

Performances

Mainpiece Title: Creusa, Queen Of Athens

Performances

Mainpiece Title: L'allegro Il Penseroso Ed Il Moderato

Performances

Mainpiece Title: The Man Of Mode

Afterpiece Title: The Chaplet

Dance: I: The Gipsey Tambourine- see17531012; II: The Country Amusements, as17540416 III: A Hornpipe-Granier, Harrison, Morris; IV: A Serious Dance-Devisse