SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mrs Green"/1) | (@(roleclean,performerclean) "Mrs 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 23357 matches on Performance Comments, 4469 matches on Event Comments, 4297 matches on Performance Title, 2111 matches on Roles/Actors, and 17 matches on Author.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: A Duke and no Duke

Dance: As17591015; End I: The Dutch Skipper-Poitier Jr

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: Catherine and Petruchio

Cast
Role: Catherine Actor: Mrs Green.

Dance: As17591017

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Dance: As17591017

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Cheats of Scapin

Dance: Country Dance, as17591017; Hornpipe, as17591017; The Dutch Skipper, as17591017; The Threshers, as17591005

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: A Duke and no Duke

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Knights

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: Catherine and Petruchio

Cast
Role: Catherine Actor: Mrs Green.

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The School Boy

Cast
Role: Lady Manlove Actor: Mrs Copin

Dance: AAs 23 Oct

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: Miss in Her Teens

Cast
Role: Tagg Actor: Mrs Vincent
Role: Biddy Actor: Mrs Green.

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Lying Valet

Cast
Role: Kitty Pry Actor: Mrs Green

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: A Duke and no Duke

Dance: CCountry Dance, as17591023; Hornpipe, as17591023; The Dutch Skipper, as17591023; Fingalian Dance-Miss Hilliard,

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: Catherine and Petruchio

Cast
Role: Catherine Actor: Mrs Green.

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Cheats of Scapin

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Knights

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: A Duke and no Duke

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Lying Valet

Cast
Role: Kitty Pry Actor: Mrs Green

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Dance: As17591102

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: Miss in Her Teens

Cast
Role: Tagg Actor: Mrs Vincent
Role: Biddy Actor: Mrs Green.

Dance: As17591012 End II: a New Comic Dance-Granier, Miss Hillard; Hornpipe-Miss Dawson

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The School Boy

Cast
Role: Lady Manlove Actor: Mrs Copin

Dance: As17591113

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: Catherine and Petruchio

Cast
Role: Catherine Actor: Mrs Green.

Dance: As17591113

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Knights

Dance: As17591113

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: A Duke and no Duke

Dance: As17591113

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mrs Peachum Actor: Mrs Stephens
Role: Mrs Coaxer Actor: Mrs Ferguson
Role: Mrs Vixen Actor: Miss Allen
Role: Jenny Actor: Mrs Baker
Role: Mrs Slammekin Actor: Mrs Green
Role: Diana Trapes Actor: Mrs Copin
Role: Mrs Midnight Actor: Mrs Copin
Role: Mrs Clearaccount Actor: Mrs Ferguson
Role: Constance Actor: Mrs Vincent
Role: Aurelia Actor: Mrs Hamilton.

Afterpiece Title: The Englishman Returned from Paris

Cast
Role: Lucinda Actor: Mrs Baker.

Dance: As17591113