SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "At Hay The Country Girl"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Parting Lovers

Dance: I: Peasants-the French Boy and Girl; II: Comic Ballet-Villeneuve, Miss Oates; III: Swiss Dance-French Boy and Girl; IV: Grecian Sailors-Glover; V: Hippisley's Drunken Man-

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Deuce is in Him

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: I: The Vintage, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: A Pamtomime Dance The Italian Bakers, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: The Vintage, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: The Italian Bakers, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: The Italian Bakers, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Daphne and Amintor

Dance: II: The Italian Bakers, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Cunning Man

Dance: II: The Italian Bakers, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: The Vintage, as17661011

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Music: II: A Concerto on the Harpsichord-Mr Burney Jr

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Edgar and Emmeline

Entertainment: End: Linco's Travels-King [, as17670406

Dance: HHearts of Oak, as17670212

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: A New Comic Dance-Grimaldi, Duquesney, Rollet, Mrs King

Performances

Mainpiece Title: The Messiah

Music: Instrumental parts-Hay, the most capital performers; with a solo on the violin-Hay

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: II: A New Dance called The Hunters-Hamoir, Miss Hamoir

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: III: The Wake, as17680929

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Fortunatus

Dance: III: New Comic Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Fortunatus

Dance: III: New Comic Dance, as17681210

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: III: A New Pierrot's Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Lyar

Dance: III: New Dance-(perform'd but once) [as17690509]; End: Hornpipe-Walker

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Padlock

Dance: III: The Wake, as17690518

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Ode

Dance: III: A Dance-Dagueville, Sga Vidini