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: Love In The East

Afterpiece Title: Harlequin Junior

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Romp

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Le Matin, Midi, et le Soir

Afterpiece Title: Too Civil by Half

Dance: End 2nd piece: The Conjugal Frolick, as17880221

Performances

Mainpiece Title: A New Way To Pay Old Debts

Afterpiece Title: The Waterman

Dance: As17880607

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: Ways And Means; Or, A Trip To Dover

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: A Bold Stroke for a Wife

Dance: As17880924

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Ut Pictura Poesis

Dance: As17890525

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: As It Should Be

Dance: End II: As17890525; End I: Statute Dance-the Characters

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: As It Should Be

Dance: End: As17890525; III: Hornpipe-Menage

Performances

Mainpiece Title: The Married Man

Afterpiece Title: The Romp

Dance: As17890708

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Try Again

Dance: III: Hornpipe (in Character)-Byrn

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: New Spain; or, Love in Mexico

Dance: III 2nd piece: A Grand Indian War Dance-

Performances

Mainpiece Title: The German Hotel

Afterpiece Title: Love in a Camp; or, Patrick in Prussia

Performance Comment: Captain Patrick-Johnstone; Quiz-Quick; Darby (1st time)-Bernard; Marshall Ferbelin-Davies; Father Luke-Rock; Olmutz-Cubitt; Adjutant-Macready; Rupert-Lee; Mabel Flourish-Mrs Webb; Norah-Miss Francis; Flora-Mrs Martyr.
Cast
Role: Captain Patrick Actor: Johnstone

Performances

Mainpiece Title: The School For Arrogance

Performance Comment: Principal Characters by Lewis, Johnstone, Aickin, Farren, Wilson, Munden, Marshall, Thompson, Farley, Evatt, Cross, Mrs Wells, Miss Brunton, Mrs Mattocks. [Cast from text (G. G. J. and J. Robinson, 1791): Count Conolly Villars-Lewis; MacDermot-Johnstone; Mr Dorimont-Aickin; Edmund-Farren; Sir Paul Peckham-Wilson; Sir Samuel Sheepy-Munden; Picard-Marshall; Exempt-Thompson; Footmen-Farley, Evatt, Letteney, Blurton; Bailiffs-Cross, Lee; Lucy-Mrs Wells; Lydia-Miss Brunton; Lady Peckham-Mrs Mattocks; Prologue-Bernard [in the Character of a News-hawker]; Epilogue-Mrs Mattocks. [These were spoken, as here assigned, at all subsequent performances.]These were spoken, as here assigned, at all subsequent performances.]
Cast
Role: MacDermot Actor: Johnstone

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: Next Door Neighbours

Afterpiece Title: The Author

Performances

Mainpiece Title: A Day In Turkey; Or, The Russian Slaves

Afterpiece Title: Hob in the Well

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Virgin Unmask'd

Song: In: The original Music by Matthew Locke, with full Chorusses and additional Accompaniments-Bannister, Sedgwick, Dignum, Danby, Maddocks, Caulfield, Cooke, Alfred, Shaw, Lyons, Mrs Bland, Mrs Edwards, Miss Hagley, Miss DeCamp, Mrs Shaw, Mrs Edwin, Mrs Butler, Mrs Bramwell, Mrs Gawdry, Miss Kirton

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The German Hotel

Afterpiece Title: Love in a Camp; or, Patrick in Prussia

Performance Comment: Captain Patrick-Johnstone; Quiz-Quick; Darby (1st time)-Bernard; Marshall Ferbelin-Davies; Father Luke-Rock; Olmutz-Cubitt; Adjutant-Macready; Rupert-Lee; Mabel Flourish-Mrs Webb; Norah-Miss Francis; Flora-Mrs Martyr.
Cast
Role: Captain Patrick Actor: Johnstone