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

Mainpiece Title: The Constant Couple

Afterpiece Title: The Beggar's Pantomime

Dance: III: Dutchman and Frow-Vallois, Mrs Bullock; V: Richmond Maggot-LeSac, Mrs Woodward

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Afterpiece Title: The Beggar's Pantomime

Performances

Mainpiece Title: The Committee

Afterpiece Title: The Beggar's Pantomime

Performances

Mainpiece Title: All Alive And Merry

Afterpiece Title: Harlequin Shipwreck'd

Cast
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: All Alive And Merry

Afterpiece Title: Harlequin Shipwreck'd

Cast
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: Sir Harry Wildair

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: Sir Harry Wildair

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: Tunbridge Walks

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: The Independent Patriot

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: A Tutor For The Beaus

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: A Tutor For The Beaus

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: The Wonder

Cast
Role: Donna Isabella Actor: Mrs Hamilton

Afterpiece Title: The Honest Yorkshireman

Dance: I: A new Serious Dance in Boy's Cloaths-Mlle Roland, others; IV: Scot's Dance-Haughton, Mlle Roland; V: French Peasant-Haughton, Mlle Roland

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: Hymen's Triumph

Cast
Role: Cupid Actor: Master Hamilton
Role: Colombine Actor: Mrs Hamilton

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: The Honest Yorkshireman

Performances

Mainpiece Title: King Charles The First

Afterpiece Title: The Honest Yorkshireman