SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Philosofo De Campagna"/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 King's The Inconstant

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: At King's The Belle's Stratagem

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: At King's The Heiress

Afterpiece Title: Richard Coeur de Lion

Song: Probably as17921016

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Harlequin's Museum [and see17921220]

Dance: In afterpiece: the Burlesque Pas de Russe-Byrn, Miss Smith; Hornpipe-Holland; rest of the Dances-Byrn, Ratchford, Cranfield, Rayner, Platt, Jackson, Wilde, Mrs Watts, Miss Francis, Mrs Ratchford, Mrs Lloyd, Mrs Crowe, Mrs Bayzand, Mme Rossi

Performances

Mainpiece Title: At King's The Chances

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: End I: a new Divertisement (composed by Noverre)-Mlle Millerd (from the Grand Opera in Paris; 1st appearance in this country), Mlle Hilligsberg, Favre Gardel, Nivelon; End Opera: Les Caractres de la Danse-; a new divertisement (composed by Noverre), Les Epoux du Tempe-Mlle Hilligsberg, Mlle Millerd, Nivelon, Favre Gardel

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: As17930126

Performances

Mainpiece Title: At King's The Haunted Tower

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: As17930216

Performances

Mainpiece Title: At King's The Country Girl

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: L'allegro Ed Il Penseroso [, Part I Only]; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

Mainpiece Title: L'allegro Ed Il Penseroso , Part I; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

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: Teodolinda

Dance: End I: Divertisement, as17930216, but _Nivelon; Pas de Trois-; a new Allegorical Scene-, in honour of his Majesty's Birth Day; End Opera: Le Jaloux Puni, as17930601 but Master Menage

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: MOTHER SHIPTON TRIUMPHANT; or, Harlequin's Museum

Dance: In afterpiece The Burlesque Pas de Russe by Byrn and Miss Smith; Hornpipe by Holland

Song: In afterpiece God save the King by Gray, Linton, Street, Kendrick, Little, Miss Barnett, Miss Stuart, &c

Monologue: 1793 11 19 End of mainpiece An Occasional Address, in the character of Goldfinch, by Lewis

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: End of Act I a new Divertisement, composed by Noverre [performers not listed]; End of Act II a new Pantomimic Ballet, composed by Noverre, Adelaide; ou, La Bergere des Alpes, by Aumer, Gentili, Mme Del Caro, Mlle Hilligsberg, Mme M. L. Hilligsberg Sen

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17940111 throughout

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: End of Act I Divertisement, as17940111; End of Act II Adelaide [performers not listed, but see17940111]

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17940118 throughout

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17940118 throughout

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: DON GIOVANNI

Dance: End of 1st piece a new Ballet, composed by Noverre, L' Union des Bergeres [performers not listed, but see17940304 In 2nd piece Dances connected with the opera, composed by Noverre, by Aumer, Lahante, Gentili, Favre Guiardele, Mlle Hilligsberg, Mme Del Caro, Mlle Guiardele, Mme Hilligsberg

Opera: [It was sung by Pasquariello.]

Performances

Mainpiece Title: I Contadini Bizzarri

Dance: End of Act I Divertisement, as17940111; End of Act II L'Union des Bergeres (performers as in Dances, 1 Mar.]

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: DON GIOVANNI

Dance: As17940301hroughout, but omitted: Lahante, Mlle Guiardele