SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Hamilton"/1) | (@(roleclean,performerclean) "Hamilton")') 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 1989 matches on Roles/Actors, 550 matches on Performance Comments, 47 matches on Event Comments, 11 matches on Performance Title, and 10 matches on Author.

Performances

Afterpiece Title: The Apprentice

Cast
Role: Scotchman Actor: Hamilton

Dance: End: The Italian Peasants-

Performances

Afterpiece Title: Miss in Her Teens

Cast
Role: Fribble Actor: Hamilton

Dance: As17730723

Performances

Afterpiece Title: The Register Office

Cast
Role: Scotchman Actor: Hamilton

Dance: As17730804

Performances

Afterpiece Title: The Virgin Unmask'd

Cast
Role: Coupee Actor: Hamilton.

Dance: As17730804

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Nabob

Afterpiece Title: The Author

Cast
Role: Poet Actor: Hamilton

Dance: As17730804

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: The Author

Cast
Role: Poet Actor: Hamilton

Dance: End of Play: Tambourine Dance-Giorgi's Scholars

Performances

Mainpiece Title: The Bankrupt

Afterpiece Title: A Trip to Portsmouth

Cast
Role: Laird Actor: Hamilton

Performances

Mainpiece Title: The Macaroni

Afterpiece Title: The Apprentice

Cast
Role: Scotchman Actor: Hamilton

Song: III: O What a Charming Thing's a Battle-Bannister

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Mock Doctor

Cast
Role: Helebore Actor: Hamilton

Monologue: 1773 9 20 Interlude. Piety in Pattens. As 23 Aug

Performances

Mainpiece Title: The Busy Body

Cast
Role: Whisper Actor: Hamilton

Afterpiece Title: Comus

Performances

Mainpiece Title: The Busy Body

Cast
Role: Whisper Actor: Hamilton

Afterpiece Title: The Padlock

Dance: II: The Merry Sailors, as17731007

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Richard Actor: Hamilton

Afterpiece Title: The Sylphs

Performances

Mainpiece Title: The Man Of Business

Cast
Role: Cash Actor: Hamilton

Afterpiece Title: Thomasand Sally

Performances

Mainpiece Title: The Man Of Business

Cast
Role: Cash Actor: Hamilton

Afterpiece Title: The Upholsterer

Dance: End: The Highland Reel, as17731112

Performances

Mainpiece Title: The Man Of Business

Cast
Role: Cash Actor: Hamilton

Afterpiece Title: Midas

Performances

Mainpiece Title: The Man Of Business

Cast
Role: Cash Actor: Hamilton

Afterpiece Title: Achilles in Petticoats