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

Performances

Mainpiece Title: The Distrest Mother

Dance: As17921226

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: The Road To Ruin

Dance: As17921226

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Mago and Dago

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: The Lie Of The Day; Or, A Party At Hampton Court

Afterpiece Title: Catharine and Petruchio

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: Speculation

Afterpiece Title: Harlequin Captive

Song: As17960312

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: Live Lumber; Or, Unburied Dead

Afterpiece Title: The Lie of the Day

Afterpiece Title: The Way to Get Un-Married

Afterpiece Title: Hartford Bridge

Dance: End of 3rd piece: The Lucky Escape, as17951008

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Lock and Key

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Lock and Key

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: King Henry The Fourth, First Part

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Widow Of Malabar

Afterpiece Title: The Doldrum

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Catharine and Petruchio

Afterpiece Title: The Point at Herqui

Dance: III: Hornpipe-Byrn; 3rd piece: Dance, as17960415

Song: In: Old Towler-Incledon; 3rd piece: Tippy Bob, as17960415; The Waiter, as17960415; Irish Song, as17960415; New Loyal Song, as17960415; Ye Gentlemen of England, as17960415; Rule Britannia, as17960415; Admiral Benbow-Incledon; Rondo-Mrs Serres

Performances

Mainpiece Title: The Mask'd Friend

Afterpiece Title: The Way to Get Un-Married

Afterpiece Title: The Farmer

Song: In 2nd piece: The Sportman's snug little Cot-Incledon

Entertainment: Monologues, with Songs.End: The Barber's Petition-Fawcett (1st time); [with a song in character, Wigs [including His Own Wig, The Lover's Wig, Doctor's Wig, Coachman's Wig, Counsellor's Wig-Fawcett; End 2nd piece: A Ramble to Bath (1st time) [with a descriptive song in the character of Jacob Gawkey [in The Chapter of Accidents]-Knight

Performances

Mainpiece Title: Zorinski

Afterpiece Title: The Doldrum

Song: Mainpiece: As17960426

Performances

Mainpiece Title: King Henry The Fourth, First Part

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2