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

Performances

Mainpiece Title: Summer Amusement

Afterpiece Title: The Agreeable Surprise

Cast
Role: John Actor: Lyons
Related Works
Related Work: The Agreeable Surprise Author(s): John O'Keeffe

Dance: As17910617

Performances

Mainpiece Title: The Kentish Barons

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Ledger
Related Works
Related Work: The Son-in-Law Author(s): John O'Keeffe

Performances

Mainpiece Title: The Kentish Barons

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Ledger
Related Works
Related Work: The Son-in-Law Author(s): John O'Keeffe

Performances

Mainpiece Title: Half An Hour After Supper

Cast
Role: John Actor: Phillimore

Afterpiece Title: Next Door Neighbours

Cast
Role: Sir John Falstaff Actor: Palmer

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Ledger
Related Works
Related Work: The Son-in-Law Author(s): John O'Keeffe

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Ledger
Related Works
Related Work: The Son-in-Law Author(s): John O'Keeffe

Dance: As17910701

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Ledger
Related Works
Related Work: The Son-in-Law Author(s): John O'Keeffe

Afterpiece Title: Next Door Neighbours

Cast
Role: Sir John Falstaff Actor: Palmer
Role: John Actor: Ledger

Performances

Mainpiece Title: The Surrender Of Calais

Cast
Role: John Actor: Phillimore

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Ledger
Related Works
Related Work: The Son-in-Law Author(s): John O'Keeffe

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Performances

Mainpiece Title: Wild Oats

Cast
Role: John Dory Actor: Wilson
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: The Poor Soldier

Performance Comment: Patrick-Johnstone; Fitzroy-Davies; Dermot-Incledon; Father Luke-Rock; Bagatelle (with a song in character)-Marshall; Darby-Munden; Norah-Mrs Mountain; Kathlane-Mrs Martyr.
Cast
Role: Patrick Actor: Johnstone
Related Works
Related Work: The Poor Soldier Author(s): John O'Keeffe
Related Work: The Shamrock; or, The Anniversary of St. Patrick Author(s): John O'Keeffe

Performances

Mainpiece Title: The School For Scandal

Related Works
Related Work: The School for Scandal Scandaliz'd Author(s): John Philip Kemble

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Song: III: a song-Dignum

Performances

Mainpiece Title: Wild Oats

Cast
Role: John Dory Actor: Wilson
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: The Confederacy

Related Works
Related Work: The Confederacy Author(s): John Vanbrugh

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Performances

Mainpiece Title: Wild Oats

Cast
Role: John Dory Actor: Wilson
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: Wild Oats

Cast
Role: John Dory Actor: Wilson
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: Wild Oats

Cast
Role: John Dory Actor: Wilson
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Wild Oats

Cast
Role: Little John Actor: Quick
Role: Edwin Actor: Johnstone
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: Oscar and Malvina

Music: In 3rd piece: As17911024

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Wild Oats

Cast
Role: Little John Actor: Quick
Role: Edwin Actor: Johnstone
Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Music: As17911122

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Wild Oats

Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: The Jovial Crew

Performance Comment: Justice Clack-Quick; Oliver-Johnstone; Hilliard-Incledon; Vincent-Davies; Hearty-Darley; Springlove-Macready; Oldrents-Powel; Martin-Evatt; Patrico-Thompson; Meriel-Mrs Martyr; Amie-Miss Stuart; Rachel-Mrs Mountain.
Cast
Role: Oliver Actor: Johnstone

Dance: In II 3rd piece: the original Crutch Dance-

Performances

Mainpiece Title: The Confederacy

Related Works
Related Work: The Confederacy Author(s): John Vanbrugh

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Performances

Mainpiece Title: The Prussian Festival

Cast
Role: O'Whack Actor: Johnstone

Afterpiece Title: Wild Oats

Related Works
Related Work: Wild Oats; or, The Strolling Gentleman Author(s): John O'Keeffe

Afterpiece Title: Oscar and Malvina

Cast
Role: Captain Patrick Actor: Johnstone

Music: In 3rd piece: The Harp and Pipes-Weippert, Courtney

Performances

Mainpiece Title: The Heiress

Related Works
Related Work: The Heiress Author(s): John Burgoyne

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Performances

Mainpiece Title: The School For Scandal

Related Works
Related Work: The School for Scandal Scandaliz'd Author(s): John Philip Kemble

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Song: As17910927

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Dignum
Related Works
Related Work: The Devil to Pay; or, The Wives Metamorphos'd Author(s): John Mottley

Performances

Mainpiece Title: Mary Queen Of Scots

Related Works
Related Work: Mary Queen of Scots Author(s): John St. John

Afterpiece Title: Bon Ton

Cast
Role: Sir John Trotley Actor: King