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, 38787, 38797, 38802, 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: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: La Paysane Distraite, as17770524, but Sga _Zuchelli; End II: Serious Ballet, as17770225, but Sga _Zuchelli; End Opera: La Clochette, as17770315but Sga _Zuchelli

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Paysane Distraite, as17770617 End II: Serious Ballet, as17770617 End Opera: La Clochette, as17770315but Sga _Zuchelli, Mlle DeCamp

Performances

Mainpiece Title: I Capricci Del Sesso

Dance: End I: La Paysane Distraite, as17770617 End II: La Clochette, as17770624 End Opera: Serious Ballet, as17770621

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Zerbinetta Actor: Sga Sestini.

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: Zerbinetta Actor: Sga Sestini.

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Zerbinetta Actor: Sga Sestini.

Dance: As17781124

Ballet: Annette et Lubin. As17781124

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Zerbinetta Actor: Sga Sestini.

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

Performances

Mainpiece Title: La Fraschetana

Dance: As17790105

Performances

Mainpiece Title: La Fraschetana

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

Performances

Mainpiece Title: La Buona Figliuola

Dance: End I: Les Oiseleurs, as17790123; End Opera: New Ballet, as17790227

Ballet: End II: Annette et Lubin. As17781124

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17790429

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17790429

Ballet: Annette et Lubin. As17790429

Performances

Mainpiece Title: L'avaro Deluso

Cast
Role: Zerbinetta Actor: Sga Sestini.

Dance: End I: Les Oiseleurs, as17790123; End II: Ballet by Fairies, as17790302End Opera: New Ballet, as17790227

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: new Ballet, Les Paysans Voles-Banti, Sga Tinti, Sg and Sga Zuchelli; End II: Ballet by Fairies, as17790302End Opera: new Ballet Espagnol, La Serenade Interrompuee-Simonet, Mlle Baccelli, Sg and Sga Zuchelli, LeDet; with a Pas de Deux du Masque-Simonet, Mlle Baccelli; accompanied on the Guittar-Noferi

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17790515

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: Les Paysans Voles, as17790515; End II: Les Moissonneurs, as17781229; End III: La Serenade Interrompuee, as17790515; Pas de Deux du Masque, as17790515

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17790525

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17790515

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: Les Paysans Voles, as17790515; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, in which the Quadrilles danced at the Pantheon last night (composed by Simonet)-Slingsby, Mme Simonet, Banti, Sga Tinti, Sg and Sga Zuchelli, Simonet, Mlle Baccelli

Performances

Mainpiece Title: La Governante

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17790615

Performances

Mainpiece Title: L'arcifanfano

Cast
Role: Semplicina Actor: Sga Sestini.

Dance: End I: New Ballet-Sg and Sga Zuchelli, Sga Crespi; End II: new ballet, composed by Simonet, The Fortunate Escape-Slingsby, Sga Tantini, Sga Crespi, Mme Simonet; End Opera: new ballet, composed by Simonet, The Country Gallant-, in which Mme Simonet, will dance in Men's Cloaths with Sga Tantini, Sga Crespi, Sg and Sga Zuchelli