SELECT * FROM london_stages WHERE eventid IN (33371, 33385, 33399, 33408, 33413, 33427, 33432, 33445, 33450, 33464, 33478, 33493, 33505, 33519, 35836, 37542, 39856, 39870, 39885, 39903, 39914, 39924, 39933, 39944, 40798, 40810, 40822, 40849, 40863, 40878, 40887, 40892, 40908, 41985, 41991, 41999, 42018, 42043, 42069, 42084, 42094, 42099, 42115, 42125, 42145, 42167, 43225, 43230, 43266, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48894, 48906, 48915, 48958, 48963, 48972, 50798, 50822) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Dance: Ballet Master-Sodi; Dancers-Adriani, Slingsby, Signora Radicati, Signora Santoli, Hamoir, Mlle Hamoir

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Sandrina Actor: Signora Piatti

Performances

Mainpiece Title: La Contadina In Corte

Cast
Role: Sandrina Actor: Sga Ristorini

Performances

Mainpiece Title: La Buona Figluola

Cast
Role: Sandrina Actor: Gori

Song: II: A favourite Song-Taretti; III: A New Rondo-Mrs Barthelemon

Dance: I: Comic Dance-Sga Mazzoni, Bocchini; II: A Chaconne-Fierville; III: Persian Dance in Perseo- [Haram]

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: As17780331nd I: Masquerade Dance; End II: La Surprize de Daphnis et Cephise; End Opera: La Serenade Interrompuee.

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: End I: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End II: Les Bohemiens, as17771216; End Opera: Serious Ballet, as17780120

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: End I: Les Bohemiens, as17771216; End II: Serious Ballet, as17780120; End Opera: new Ballet Demi-caractere (never performed), L'Amour dans la Vendange-Mons and Mlle Banti, Sg and Sga Zuchelli

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: End I: Divertisement, as17780207; with a Minuet-Mons and Mme Simonet; End II: L'Amour dans la Vendange, as17780519; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: End I: Divertisement, as17780526; End II: L'Amour dans la Vendange, as17780519; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: End I: Divertisement, as17780207; End II: L'Amour dans la Vendange, as17780519; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: As17780609

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Jermoli

Dance: As17780609

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Lisandrina Actor: Sga Prudom

Dance: End I: Il Desertore, as17791214; End II: Masquerade Dance, as17791221; Minuet, as17791221; End Opera: Grand Serious Ballet, as17791127, but _Slingsby, Mlle Baccelli