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

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Dance: End I: As17810612 End III: Tambourine Dance, as17810601

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Performances

Mainpiece Title: The Nabob

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Dance: As17810620

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: The Dead Alive

Cast
Role: Edward Sandford Actor: Wood
Role: Caroline Sandford Actor: Miss Harper

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: THE DEAD ALIVE

Cast
Role: Caroline Sandford Actor: Miss Leak

Song: In mainpiece, as17940717 but omitted: Mrs Harlowe

Performances

Mainpiece Title: The Deaf Lover

Afterpiece Title: THE VILLAGE LAWYER

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: AULD ROBIN GRAY

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: AULD ROBIN GRAY

Cast
Role: Caroline Sandford Actor: Miss Leak

Performances

Mainpiece Title: All The World's A Stage

Afterpiece Title: PEEPING TOM

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE SON-IN-LAW

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: THE SPANISH BARBER

Afterpiece Title: AULD ROBIN GRAY

Cast
Role: Caroline Sandford Actor: Miss Leak

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: AULD ROBIN GRAY

Cast
Role: Caroline Sandford Actor: Miss Leak

Performances

Mainpiece Title: Thomas And Sally; Or, The Sailor's Return

Afterpiece Title: THE LONDON HERMIT

Afterpiece Title: THE DEAD ALIVE

Cast
Role: Caroline Sandford Actor: Miss Leak

Performances

Mainpiece Title: I'll Tell You What

Afterpiece Title: AULD ROBIN GRAY

Cast
Role: Caroline Sandford Actor: Miss Leak

Dance: Afterpiece: To conclude with a Highland Reel by the Characters

Performances

Mainpiece Title: Rosina

Afterpiece Title: HEIGHO FOR A HUSBAND

Afterpiece Title: AULD ROBIN GRAY

Cast
Role: Caroline Sandford Actor: Miss Leak

Dance: 3rd piece: To conclude as17940805

Performances

Mainpiece Title: Tit For Tat

Afterpiece Title: THE DEAD ALIVE

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE PRISONER AT LARGE

Performances

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

Afterpiece Title: THE DEAD ALIVE

Cast
Role: Caroline Sandford Actor: Miss Leak

Performances

Mainpiece Title: Tit For Tat

Afterpiece Title: AULD ROBIN GRAY

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE AGREEABLE S URPRISE

Dance: 2nd piece: To conclude as17940805

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: THE MOUNTAINEERS

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE MAYOR OF GARRATT

Performances

Mainpiece Title: Rule Britannia

Afterpiece Title: PEEPING TOM

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Mainpiece Title: Auld Robin Gray

Afterpiece Title: THE SON-IN-LAW

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE VILLAGE LAWYER

Cast
Role: Caroline Sandford Actor: Miss Leak

Dance: 1st piece to conclude as17940805

Performances

Mainpiece Title: Britain's Glory

Afterpiece Title: THE MOUNTAINEERS

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE IRISHMAN IN LONDON

Performances

Mainpiece Title: Rule Britannia

Afterpiece Title: THE VILLAGE LAWYER

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE APPARITION

Performances

Mainpiece Title: Auld Robin Gray

Afterpiece Title: THE SON-IN-LAW

Cast
Role: Caroline Sandford Actor: Miss Leak

Afterpiece Title: THE CHILDREN IN THE WOOD

Dance: As17940826