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

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Hob in the Well

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Miller of Mansfield

Dance: IV: The Sailors Revels, as17711008

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: Polly Honeycomb

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Thomasand Sally

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Afterpiece Title: The Witches; or, A Trip to Naples

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Othello

Afterpiece Title: The Witches

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: Wit's Last Stake

Dance: V: The Sailors Revels, as17711008

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Absent Man

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Lottery

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Chaplet

Dance: V: A Comic Dance-Daigville, Sga Vidini

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplish'd Fools

Afterpiece Title: Marplot in Lisbon

Dance: End: The Amusements of Strasburgh, as17711118

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Tobacconist

Entertainment: Interlude. All up at Stockwell; or, The Ghost no Conjuror, a New Interlude-Characters-Weston, Bannister

Dance: After Interlude: The Sailors Revels, as17711008

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Humours of the Turf

Dance: End: The Sailors Revels, as17711008

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Deuce Is in Him

Dance: III: The Sailors Revels, as17711008

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Absent Man

Dance: V: The Drunken Peasant-Philips, the original

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Miss in Her Teens

Dance: End: Hornpipe-Walker

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Lyar

Dance: III: The Sailors Revels-Atkins

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Institution of the Garter

Performances

Mainpiece Title: Alexander The Great; Or, The Rival Queens

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Irish Widow

Dance: End Act I of the Farce: A New Dance call'd The Irish Fair-Atkins, Mrs Sutton, being her first appearance that stage