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: At Hay The Rival Sisters

Performances

Mainpiece Title: At Hay Macbeth

Afterpiece Title: The Prize

Song: The Original Music, as17921226, but _Caulfield, _Maddocks, _Alfred, _Lyons

Performances

Mainpiece Title: At Hay Othello

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay The Fair Penitent

Afterpiece Title: The Cheats of Scapin

Performances

Mainpiece Title: At Hay The Grecian Daughter

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay Isabella

Afterpiece Title: The Prize

Song: As17921217

Performances

Mainpiece Title: At Hay The Tempest

Afterpiece Title: Fortune's Wheel

Song: In: Vocal Parts, as17921213, Sedgwick, _Kelly, Mrs +Crouch; Masque of Neptune and Amphitrite, as17930102 In course of Evening: +The Little Farthing Rushlight-Bannister Jun

Performances

Mainpiece Title: At Hay Jane Shore

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay King Henry The Eighth

Afterpiece Title: The Devil to Pay

Song: In IV: a song-Master Welsh

Performances

Mainpiece Title: At Hay The Jealous Wife

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At Hay Coriolanus

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: At Hay The Gamester

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At Hay The Mourning Bride

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: At Hay The Recruiting Officer

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At Hay The School For Scandal

Afterpiece Title: The Apprentice

Dance: End: Minuet de la Cour and Gavot-Master and Miss D'Egville

Song: As17921030

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Prize

Afterpiece Title: The Spoil'd Child

Song: End II: When on board our trim vessel (composed by Carter)-Bannister; End: The Waggoner (composed by Dibdin)-Wathen; End I 2nd piece: When Bibo went down-Bannister; End 2nd piece: The Cobler (composed by Reeve)-Wathen; End I 3rd piece: The Ship@wreck'd Sailors (composed by an Amateur for the Thespian Panorama [see hay, 4 Mar.])-Mrs Bland, Master Welsh, Dignum, Suett, Caulfield, Bannister

Performances

Mainpiece Title: The Follies Of A Day

Afterpiece Title: The Irish Widow

Afterpiece Title: A Masque, In Honor of the Nuptials of His Royal Highness [the Prince of Wales with Caroline Princess of Brunswick on 8 April 1795]

Afterpiece Title: The Poor Soldier

Dance: In 3rd piece: a Grand Dance-Byrn, Holland, Mlle St.Amand, Mme Rossi

Song: End I 2nd piece: The Richmond Primrose Girl (Music by Spofforth-Poetry by William Pearce, Esq.) sung in character-Mrs Clendining

Performances

Mainpiece Title: The Mayor Of Garratt

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Battle of Hexham; or, Days of Old

Performances

Mainpiece Title: The Agreeable Surprise

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The London Hermit; Or, Rambles In Dorsetshire

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: Ways And Means

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: New Hay at the Old Market

Song: 2nd piece: Vocal Parts-Cooke, Lyons, Aylmer, Boyce, Brown, Dibble, Dorion, Kenrick, Linton, Little, Walker, Miss Leak, Miss DeCamp, Mrs Gaudry, Mrs Hale, Mrs Butler, Mrs Norton, Miss Menage, Miss Granger

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: Peeping Tom

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: The Dead Alive

Afterpiece Title: Ways and Means

Afterpiece Title: New Hay at the Old Market

Performances

Mainpiece Title: The London Hermit

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Village Lawyer