SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sturgeon"/1) | (@(roleclean,performerclean) "Sturgeon")') 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 199 matches on Roles/Actors, 66 matches on Performance Comments, 10 matches on Event Comments, 0 matches on Performance Title, and 0 matches on Author.

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: III: The Provancalle, as17631014

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: I: Le Chasseur, as17650708 La Berge, as17650708 End: The Dutchman-Master Clinton, Miss Street

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650719

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: I: The Dutchman; End: The English Sailor at Marseilles-Miss Street; the New Hornpipe-Master Clinton

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650809

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650708

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: I: The Carpenter, as17650708 End: The Dutchman, as17650719

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650821

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650719

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650828

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650719 but New Hornpipe-Mas. Clinton

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650909

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650909

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Entertainment: Dancing-

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: II: New Tambourine Dance-; End: Hornpipe-Froment