SELECT * FROM london_stages WHERE eventid IN (37918, 37932, 37939, 38010, 38020, 38039, 38055, 38069, 38080, 38095, 38104, 38109, 38125, 38130, 38140, 38145, 38155, 38169, 38185, 38199, 38204, 38238, 38252, 38255, 38264, 38366, 38375, 38380, 38389, 38398, 38403, 38409, 38419, 38424, 38433, 38438, 38447, 38452, 38461, 38466, 38475, 38487, 38504, 38513, 38518, 38527, 38532, 38542, 38631, 38641, 38646, 38660, 38665, 38677, 38691, 38702, 38708, 38718, 38733, 38738, 38747, 38782, 38797, 38808, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39332, 39344, 39352, 39356, 39358, 39367, 39373, 40110, 40124, 40138, 40152, 40166, 40177, 40191, 40206, 40220, 40246, 40404, 40414, 40429, 40434, 40439, 40442, 40456, 40464, 40470, 40477, 40485, 41220, 41225, 41267, 41307, 41362, 41377, 41391, 41395, 41400, 41405, 41409, 41418, 41426, 41431, 41443, 41448, 41456, 41463, 41472, 41482, 41521, 41530, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 42054, 42180, 42188, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42412, 42420, 42425, 42435, 42442, 42452, 42463, 42472, 42481, 42486, 42501, 42506, 42510, 42530, 42541, 42549, 42551, 42554, 42561, 42607, 42620, 42668, 42689, 42712, 42801, 42804, 42807, 42813, 42838, 42840, 42842, 42844, 42846, 42847, 42848, 42850, 42852, 42853, 42870, 42880, 42889, 42898, 42906, 42920, 42928, 42942, 42952, 42968, 43003, 43069, 43095, 43124, 43167, 43277, 43322, 43330, 43333, 43337, 43347, 43350, 43352, 43355, 43395, 43399, 43400, 43405, 43415, 43929, 43938, 43942, 43944, 43948, 43951, 43967, 43970, 43975, 43977, 43979, 43981, 43985, 43986, 43988, 43991, 43992, 44007, 44009, 44013, 44015, 44021, 44219, 44228, 44231, 44240, 44245, 44254, 44307, 44312, 44316, 44320, 44329, 44333, 44338, 44351, 44375, 44385, 44390, 44400, 44415, 44430, 44440, 44455, 44460, 44472, 44476, 44478, 44480, 44481, 44482, 44483, 44491, 44500, 44503, 44504, 44508, 44511, 44517, 44521, 44526, 44527, 44532, 44533, 44535, 44539, 44547, 44556, 44557, 44558, 44559, 44560, 44561, 44563, 44564, 44565, 44567, 44573, 44576, 44579, 44580, 44581, 44582, 44585, 44586, 44744, 44753, 44758, 44767, 44772, 44781, 44792, 44820, 44825, 44837, 44858, 44864, 44937, 44942, 44947, 44953, 44962, 44967, 44976, 44981, 44984, 44987, 44990, 44993, 44996, 44999, 45005, 45008, 45014, 45033, 45040, 45042, 45046, 45051, 45052, 45058, 45059, 45061, 45066, 45067, 45070, 45072, 45074, 45075, 45079, 45080, 45081, 45082, 45092, 45094, 45095, 45097, 45099, 45102, 45116, 45125, 45126, 45132, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45357, 45362, 45366, 45370, 45382, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 45655, 45656, 45657, 45658, 45660, 45677, 46008, 46021, 46071, 46076, 46086, 46091, 46096, 46101, 46119, 46131, 46434, 46439, 46444, 46453, 46458, 46467, 46472, 46479, 46484, 46493, 46498, 46507, 46512, 46520, 46525, 46567, 46689, 46703, 47205, 47215, 47221, 47245, 47262, 47271, 47274, 47280, 47286, 47292, 47298, 47305, 47308, 47310, 47317, 47324, 47332, 47336, 47343, 47347, 47354, 47358, 47364) 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: Lisola Damore

Dance: After the Overture: A New Ballet Incident to the Opera call'd Le Retour des Matelotes-Helm, Mlle Sophie, Sga Tinti; End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: Lisola Damore

Dance: End Overture: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: Alcina

Dance: I: Les Deux Soeurs, as17760203; II: Ballet Pastoral-S. Vallouy, Mme Vallouy, Helm, Mlle Sophie; Pigmalion, as17760307

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: Ballet Pastoral, as17760328

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: La Fete du Village, as17760224

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: Caio Mario

Cast
Role: Aquilio Actor: Sestini

Dance: I: Grand Ballet, with Chaconne-Fierville, Mlle Baccelli; II: Ballet Pastoral, as17760328 End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: La Serva Padrona

Afterpiece Title: LIsola DAmore

Dance: After the Intermezzo: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: Caio Mario

Cast
Role: Aquilio Actor: Sestini

Dance: I: Diane et Endymion, as17760312 II: La Fete du Village, as17760224

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: Caio Mario

Cast
Role: Aquilio Actor: Sestini

Dance: I: La Fete du Village, as17760224; II: Diane et Endymion, as17760312 End Opera: Ballet-; with a Chaconne-; and a Minuet de la Cour-the two Vallouys

Performances

Mainpiece Title: Il Bacio

Cast
Role: Parts Actor: Signora _Sestini.

Dance: I: Diane et Endymion, as17760312 End II: Minuet a la Cour-the two Vallouys

Ballet: End Opera: Astolphe. As17760312[dancers only.

Performances

Mainpiece Title: Caio Mario

Cast
Role: Aquilio Actor: Sestini

Dance: La Fete du Village, as17760504; Diane et Endymion, as17760504; Minuet de la Cour, as17760504

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17760516

Ballet: Astolphe. As17760312

Performances

Mainpiece Title: Lisola Damore

Dance: After Overture: Le Minuet a la Cour-the two Vallouys; End I: Diane et Endymion, as17760312 End Opera: La Fete du Village, as17760224

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: Diane et Endymion, as17760312

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17761102

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amusemens Champetres, as17761102; End II: Grand Serious Ballet, as17761102; End Opera: a new Ballet, Demi-caractere, Les Chasseurs-Mons Vallouy, Mme Vallouy, Sg and Sga Zuchelli, Simonin Vallouy?@le@cadet

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17761116

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17761116

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Heureux, as17761102 End II: Grand Serious Ballet, as17761102, but Mons _Simonet; in which a Passacaile-Mme Simonet; Chaconne-Mme Simonet; End Opera: Les Chasseurs, as17761112

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Heureux, as17761102; End II: Grand Serious Ballet, as17761130; End Opera: a new Comic Dance, composed by Zuchelli, La Force de l'Amour-Sg and Sga Zuchelli

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Heureux, as17761102, but Mme _Vallouy; End II: Serious Ballet, as17761130; End Opera: La Force de l'Amour, as17761207

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: La Force de l'Amour, as17761214; End II: Grand Serious Ballet, as17761130; End Opera: Les Amans Heureux, as17761217, but Sga Zuchelli

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: La Force de l'Amour, as17761214; End II: Grand Serious Ballet, as17761217, Passacaile-_, Chaconne-_; End Opera: Les Amans Heureux, as17770104

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: La Force de l'Amour, as17761214; End II: Grand Serious Ballet, as17761102, but Mons _Simonet, Vallouy@le@cadet; End Opera: +Les Amans Heureux, as17770104

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17770117