SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Alfred"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Alfred

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Alfred

Afterpiece Title: A Trip to Scotland

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Deuce is in Him

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17730918

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Padlock

Dance: End: The Villagers-Aldridge, Langrish, Master Jackson, Miss Valois

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Minor

Dance: As17780121

Performances

Mainpiece Title: Alfred

Afterpiece Title: St

Dance: As17780121

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Catherine and Petruchio

Dance: II: a Dance of Spirits-Miss Stageldoir; III: a Dance of Fantastic Spirits-; IV: Dance-Hamoir, Miss Stageldoir

Song: The Music by Purcel and Dr Arne-; with the additional Airs and Chorusses by the late Linley Jun-; Vocal Parts-Williames, Danby, Fawcett, Alfred, Newbold, Mrs Love, Mrs Booth, Miss Barnes, Miss Cranford, Miss J. Stageldoir

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Afterpiece Title: The First Floor

Song: Mainpiece: Vocal Parts-Kelly, Dignum, Sedgwick, Danby, Fawcett, Wilson, Maddocks, Alfred, Lyons, Miss Romanzini, Mrs Edwards, Mrs Fox, Miss Barnes, Miss Stageldoir, Mrs Shaw, Mrs Butler, Mrs Crouch; III: Chorus of Furies-; V: the Masque of Neptune and Amphitrite. Neptune-Sedgwick, Amphitrite-Mrs Edwards

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: At King's Macbeth

Afterpiece Title: The Prisoner

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

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Island of St

Song: As17891017, but Vocal Parts-_Fawcett, _Wilson, _Maddocks, _Alfred, _Lyons, Mrs _Fox, Miss _Barnes, Miss _Stageldoir, Mrs _Shaw, Mrs _Butler

Performances

Mainpiece Title: At Hay Macbeth

Afterpiece Title: The Prize

Song: The Original Music, as17921226, but _Caulfield, _Maddocks, _Alfred, _Lyons