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

Performances

Mainpiece Title: L'usurpator Innocente

Performance Comment: Principal Characters-Marchesi (1st appearance this season), Mussini, Benigni, Costa, Torregiani, Sga Borselli, Mme Mara (1st appearance this season). Cast from libretto (Cane and Hammond, 1790): Timante-Luigi Marchesi; Demofoonte-Mussini; Cherinto-Giuseppe Benigni; Matusio-Costa; Adrato-Torregiani; Creusa-Sga Borselli; Dircea-Mme Mara.

Dance: End I: Les Mariages Flamands, as17900227; End Opera: Les Caprices-Labourie, Duquesney, Mlle de'Caro, Mlle Dorival, Mlle Hilligsberg

Performances

Mainpiece Title: La Generosita D'alessandro

Performance Comment: [Principal Characters by Marchesi, Benigni, Costa, Torregiani, Sga Borselli, Mme Mara. Cast from libretto (Hammond and Cane [1790]: Poro-Luigi Marchesi; Gandarte-Benigni; Alessandro-Costa; Timagene-Torregiani; Erissena-Sga Borselli; Cleofide-Mme Mara.

Dance: End I: La Jalousie sans Raison, as17900325End Opera: New Ballet, as17900422

Song: Two new songs of his own composition-Marchesi; one in Act I, one in Act II, accompanied by violin violoncello and tenor-Cramer, Cervetto, Shield

Performances

Mainpiece Title: Andromaca

Performance Comment: [Principal Characters by Marchesi, Benigni, Costa, Torregiani, Sga Borselli, Mme Mara. Cast from libretto (Hammond and Cane [1790]: Pirro-Luigi Marchesi; Pilade-Benigni; Oreste-Costa; Clearte-Torregiani; Ermione-Sga Borselli; Andromaca-Mme Mara.

Dance: End I: Divertisement, as17900515, but Mlle _Dorival, Mlle Ferrere; End Opera: +The Generous Slave, as17900527

Performances

Mainpiece Title: 'tis Well It's No Worse

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: A Trip to Scotland

Dance: II: A Dance, as17730506

Performances

Mainpiece Title: Matilda

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: All For Love

Afterpiece Title: The Absent Man

Dance: V: The Wake, as17680220

Performances

Mainpiece Title: Alonzo

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Tea

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The National Prejudice

Dance: Act I afterpiece: a French Dance call'd The Cotillion-Giorgi, Duquesney, Tassoni, Rolley, Mrs King, Sga Giorgi, Miss Tetley, Mrs Grimaldi; V: The Irish Hay@makers, as17670919

Performances

Mainpiece Title: The Hypocrite

Afterpiece Title: No Wit Like a Woman's

Dance: End: Pantomime Dance, The Lilliputian Camp, as17680922

Performances

Mainpiece Title: 'tis Well It's No Worse

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Rehearsal

Dance: End of mainpiece, as17811219

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Teague

Dance: In Act III of mainpiece a Hornpipe [performer not listed]; In afterpiece, as17820826

Song: In afterpiece The Tobacco Box by Brett and Miss Morris

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: THE GLORIOUS FIRST OF JUNE

Dance: In afterpiece the Ballets composed by James D'Egville; the Principal Dancers-D'Egville, Gentili, and also by permission of the Proprietor of the King's Theatre, Mme Del Caro, Mlle E. Hilligsberg, Mlle Hilligsberg

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak; or, Harlequin Woodcutter

Music: End I afterpiece: A Medley Overture on the Union Pipes and Pedal Harp-Murphy, Weippert

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: 'Tis All a Farce

Performances

Mainpiece Title: Sir Hercules Buffoon; Or, The Poetical Squire

Performances

Mainpiece Title: King Henry Iv, Part Ii

Afterpiece Title: The Capricious Lovers

Dance: End: A Minuet-Miss Giorgi, Miss Collett Scholars to Sg Giorgi; End I of the Farce: Hearts of Oak, as17670212, but-Grimaldi, Mrs King

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The London Merchant; Or, The History Of George Barnwell

Afterpiece Title: A Peep behind the Curtain; or, The New Rehearsal

Performances

Mainpiece Title: The Widow'd Wife

Afterpiece Title: The Old Maid

Performances

Mainpiece Title: The Widow'd Wife

Afterpiece Title: Flora; or, Hob in the Well

Performances

Mainpiece Title: the Widow'd Wife

Afterpiece Title: [The Lyar