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) "Cranfield"/1) | (@(roleclean,performerclean) "Cranfield")') 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 1126 matches on Roles/Actors, 89 matches on Performance Comments, 12 matches on Performance Title, 4 matches on Event Comments, and 0 matches on Author.

Performances

Mainpiece Title: Wild Oats; Or, The Strolling Gentlemen

Performances

Mainpiece Title: The Beaux Stratagem

Performances

Mainpiece Title: He's Much To Blame

Performances

Mainpiece Title: A Cure For The Heart Ache

Performances

Mainpiece Title: The Ghost

Afterpiece Title: He's Much to Blame

Performances

Mainpiece Title: False Impressions

Performances

Mainpiece Title: The Raft

Afterpiece Title: Harlequin's Return

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Comedy of Errors

Song: In III 2nd piece: song in character-Mrs Clendining

Performances

Mainpiece Title: The Raft

Afterpiece Title: Rule a Wife and Have a Wife

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Lie of the Day; or, A Party at Hampton Court

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Road To Ruin

Performances

Mainpiece Title: Hooly And Fairly

Dance: 1st piece to conclude with: a Highland Reel, as17980428

Song: In 1st piece: Highland Laddy-; Hooly and Fairly-; Katharine Ogie-; Andrew and his Cutty Gun-; Todlen Hame-; Tulloch Goram-; End II 2nd piece: Old Towler-Incledon; End 2nd piece: Admiral Benbow-Incledon

Music: In 3rd piece: The Union Pipes-Murphy

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: Lock and Key

Dance: In 2nd piece: Highland Reel, as17980428

Song: End III 1st piece: Black Ey'd Susan-Incledon

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Reformed in Time

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Ghost

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: The Votary Of Wealth

Music: Afterpiece: The Overture-; accompanied on the Union Pipes-Murphy; accompanied on the Pedal Harp-Weippert

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Guardian

Music: In 3rd piece: As17990131

Performances

Mainpiece Title: The Votary Of Wealth

Music: Afterpiece: The overture Accompanied on the Pedal Harp-Weippert