SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Green"/1) | (@(roleclean,performerclean) "Mr Green")') 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 4507 matches on Event Comments, 1870 matches on Performance Comments, 629 matches on Performance Title, 26 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: Elfrida

Afterpiece Title: Harlequin Sorcerer

Monologue: Before the Play: (By desire) New Occasional Prelude. As 27 Oct. 1772

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Musical Lady

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Mayor of Garratt

Dance: V: The Mountaineers, as17730930

Performances

Mainpiece Title: Sethona

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Meeting of the Company

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The West Indian

Afterpiece Title: Harlequin's Jacket

Dance: II: Grand Provencalle Dance, as17750202

Performances

Mainpiece Title: Othello

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Othello

Afterpiece Title: The Elopement

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: Zara

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: May Day

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Roman Father (with Alterations)

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: La Cosa Rara

Dance: End I: New Divertissement, as17890110, but _Didelot; End Opera: Les Fetes Provencales, as17890207, but _Didelot, Mlle _Normand

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Song: Mainpiece: Vocal Parts-Incledon, Johnstone, Townsend, Hill, Linton, Blurton, Street, Gray, Little, Lee, Sawyer, Tett, Dyke, Mrs Chapman, Miss Mitchell, Miss Wheatley, Mrs Iliff, Miss Sims, Mrs Whitmore, Mrs Watts, Mrs Follett, Miss Leserve, Mrs Castelle, Mrs Norton, Mrs Gilbert, Mrs Masters, Mrs Lloyd, Mrs Blurton, Miss Walcup, Miss Gray, Miss Burnett, Mrs Martyr

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Lying Valet

Ballet: The Scotch Ghost. As17990628

Song: As17990628

Performances

Mainpiece Title: The Blind Beggar Of Bethnal Green

Cast
Role: Mustachio Actor: Green
Role: Mrs Constant Actor: Mrs Greenwood

Afterpiece Title: The Amours of Harlequin

Performances

Mainpiece Title: The Blind Beggar Of Bethnal Green

Cast
Role: Mustachio Actor: Green
Role: Mrs Constant Actor: Mrs Greenwood

Afterpiece Title: The Amours of Harlequin

Performances

Mainpiece Title: The Blind Beggar Of Bethnal Green

Cast
Role: Mustachio Actor: Green
Role: Mrs Constant Actor: Mrs Greenwood

Afterpiece Title: The Amours of Harlequin

Performances

Mainpiece Title: The Blind Beggar Of Bethnal Green

Cast
Role: Mustachio Actor: Green
Role: Mrs Constant Actor: Mrs Greenwood

Afterpiece Title: The Amours of Harlequin

Performances

Mainpiece Title: The Injur'd General; Or, The Blind Beggar Of Bednal-green; And The Woman Never Vext; With The Comical And Diverting Humours Of Squire Sousecrown And His Man Gudgeon

Performances

Mainpiece Title: The Blind Beggar Of Bednal Green; Or, The Woman Never Vex'd: With The Comical Humour Of Squire Souse Crown And His Man Gudgeon

Dance: Dutch Skipper-Monsieur De Long Dens, Monsieur De Long Dens'@Two@Children , just arrived from Paris

Performances

Mainpiece Title: The Blind Beggar Of Bednal Green

Afterpiece Title: Hob

Entertainment: Tumbling-

Performances

Mainpiece Title: The Amorous Widow

Afterpiece Title: Flora

Song: I: As Down in a Meadow-Miss Sukey Rogers; II: A song by Pepusch-Baker; IV: Polwart on the Green-Miss Sukey Rogers

Dance: III: Chacone-Miss Betty Rogers