SELECT * FROM london_stages WHERE eventid IN (4371, 37963, 37965, 37968, 37970, 37972, 37974, 37976, 37978, 37981, 37986, 37988, 37990, 37999, 38004, 38022, 38031, 38038, 38048, 38051, 38057, 38061, 38066, 38068, 38092, 38098, 38106, 38129, 38144, 38152, 38159, 38161, 39501, 39515, 39529, 39543, 39557, 39571, 39585, 39599, 39636, 39650, 39665, 39677, 39692, 39706, 39720, 39733, 39747, 39761, 39783, 39794, 39799, 39809, 39815, 39825, 39839, 39846, 39856, 39870, 39885, 39903, 39908, 39914, 39924, 39933, 39944, 40110, 40124, 40138, 40152, 40166, 40177, 40191, 40206, 40220, 40246, 40286, 40298, 40306, 40312, 40327, 40336, 40356, 40370, 40375, 40385, 40399, 40404, 40414, 40429, 40434, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41662, 41663, 41666, 41669, 41671, 41672, 41674, 41678, 41680, 41682, 41685, 41686, 42168, 42171, 42175, 42183, 42186, 42191, 42195, 42199, 42205, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 42423, 42428, 42468, 42473, 42552, 42557, 42567, 42572, 42577, 42582, 42587, 42760, 42762, 42765, 42769, 42775, 42777, 42783, 42785, 42797, 42803, 42808, 42810, 42814, 42816, 42819, 42823, 42851, 43153, 43177, 43187, 43196, 43209, 43235, 43240, 43251, 43261, 43286, 43291, 43301, 43311, 43334, 43338, 43616, 43654, 43687, 43737, 48038, 48043, 48049, 48080, 48090, 48109, 48133, 48135, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48264, 48278, 48285, 48289, 48294, 48299, 48349, 48384, 48409, 48411, 48416, 48418, 48430, 48437, 48443, 48579, 48585, 48659, 48665, 48685, 48697, 48704, 48714, 48747, 48749, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48842, 48844, 48846, 48849, 48851, 48854, 48856, 48860, 48863, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49051, 49053, 49056, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49193, 49199, 49206, 49214, 49216, 49222, 49226, 49244, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49432, 49439, 49445, 49449, 49452, 49454, 49462, 49465, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49563, 49570, 49575, 49578, 49580, 49589, 49592, 49594, 49597, 49599, 49602, 49604, 49607, 49612, 49620, 49635, 49640, 49642, 49650, 49655, 49657, 49662, 49664, 49667, 50092) 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: Il Marchese Villano

Dance: As17780203

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Bernardo Actor: Rossi

Dance: End II: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: La Serenade Interrompuee, as17780224

Ballet: End I: new Ballet Pastoral (composed by Simonet; the introduction by Banti), La Surprize de Daphnis et Cephise. Pas de Deux-Sg and Sga Zuchelli; Daphnis Banti; Cephise-Mlle Banti

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17780203 throughout

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Bernardo Actor: Rossi

Dance: As17780331

Ballet: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Villotto Actor: Antonio Rossi

Dance: As17780203

Song: II: new song (composed by Sacchini)-Pozzi; accompanied on the flute-Florio; III: Che dirnen so-Jermoli

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Bernardo Actor: Rossi

Dance: As17780331

Ballet: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Villotto Actor: Antonio Rossi

Dance: End I: Divertisement, as17780207; End II: Les Bohemiens, as17771216; End Opera: Masquerade Dance, as17780303Minuet de la Cour=, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303

Performances

Mainpiece Title: La Buona Figliuola

Dance: End I: Serious Ballet, as17780120; End II: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Don Anselmo Actor: Rossi

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: Don Anselmo Actor: Rossi

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: Don Anselmo Actor: Rossi

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: Don Anselmo Actor: Rossi

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: La Buona Figliuola

Dance: End I: L'Amour dans la Vendange, as17780519; End II: The Masquerade Ballet-; in which a Minuet-Mme Simonet en homme, or in man's dress,, Mlle Baccelli; End Opera: La Serenade Interrompuee, as17780224; in which the Minuet Dauphin-Mme Simonet in man's dress, Mlle Banti

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Don Anselmo Actor: Rossi

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: Don Anselmo Actor: Rossi

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: Don Anselmo Actor: Rossi

Dance: As17780609

Performances

Mainpiece Title: L'amore Soldato

Cast
Role: Don Anselmo Actor: Rossi

Dance: As17780609

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Calandrano Actor: Antonio Rossi

Dance: With new Dances composed by Simonet. End II: La Noche Hollandoise-Banti, Zuchelli, Slingsby, Sga Zuchelli, Sga Tinti; End Opera: a new grand Serious Ballet, Les Nymphes de Diane; ou, L'Amour Faune-Mons Simonet, Mme Simonet, Banti, Sga Tinti

Ballet: End I: new Pantomime Ballet Annette et Lubin. Bailly-LeDet; Sig. du Village-Simonet; Lubin-Slingsby; Annette-Mme Simonet; unassigned-Sg Zuchelli, Sga Zuchelli

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Calandrano Actor: Antonio Rossi

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Calandrano Actor: Antonio Rossi

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Calandrano Actor: Antonio Rossi

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: La Fraschetana [recte Frascatana]

Dance: End I: La Noche Hollandoise, as17781124; End II: new ballet, Les Moissonneurs (the music by the celebrated Paisiello) with a Pas de Deux Anacreontique,-Mme Simonet, Slingsby, Banti, Sga Tinti, Sg and Sga Zuchelli, LeDet; End: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124, but _Banti, LeDet; End II: +Les Moissonneurs, as17781222, but Sg and Sga _Zuchelli; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: As17790105