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

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: The Elopement

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Elopement

Dance: III: Hornpipe-Mrs King; End: Country Dance-

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Othello

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Wit's Last Stake

Cast
Role: Mrs Watchly Actor: Mrs Johnston

Dance: End Act II: New Comic Dance, as17681210

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Queen Mab

Cast
Role: Cook Actor: Johnston

Performances

Mainpiece Title: The Hypocrite

Afterpiece Title: Wit's Last Stake

Cast
Role: Mrs Watchly Actor: Mrs Johnston

Dance: II: New Comic Dance, as17681210; End: The Wake, as17680929

Performances

Mainpiece Title: The School For Rakes

Afterpiece Title: The Lyar

Dance: I: New Comic Dance, as17681210

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Citizen

Dance: II: New Comic Dance, as17681210; End of Opera: The Wake, as17680929

Performances

Mainpiece Title: The School For Rakes

Afterpiece Title: Queen Mab

Cast
Role: Cook Actor: Johnston

Dance: I: Hearts of Oak, as17681013

Performances

Mainpiece Title: Hamlet

Cast
Role: Player Queen Actor: Mrs Johnston

Afterpiece Title: The Hermit

Cast
Role: French Lady Actor: Johnston

Dance: III: Hearts of Oak, as17681013

Performances

Mainpiece Title: The Widow'd Wife

Afterpiece Title: The Padlock

Dance: II: New Comic Dance, as17681210

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Devil to Pay

Cast
Role: Lady Loverule Actor: Mrs Johnston

Dance: IV: The Wake, as17680929, but Sga Giorgi, Mrs _King

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Deuce Is in Him

Dance: III: The Wake, as17690518

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Padlock

Dance: As17690926

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Ode

Dance: IV: The Wake-Giorgi, Mrs King

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Register Office

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Jubilee

Song: In Act IV: O! Gentle Sleep-Miss Young

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Othello

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: Amphitryon; Or, The Two Sosias

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Hob in the Well; or, Flora

Dance: I: A New Dance call'd the The English Gardeners-Atkins, Mrs King