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

Dance: End I: New Ballet, as17801125, but Henry; End II: +The Fortunate Escape, as17801125; End Opera: The Country Gallant, as17801125

Performances

Mainpiece Title: Le Serve Rivali

Cast
Role: Giacinta Actor: Sga Sestini.

Dance: End I: The Fortunate Escape, as17801216; End II: Grand Serious Ballet, as17801216; Grand Chaconne, as17801216; End Opera: Les Amans Surpris, as17801216, but Mme Simonet

Performances

Mainpiece Title: Le Serve Rivali

Cast
Role: Giacinta Actor: Sga Sestini.

Dance: As17801219

Performances

Mainpiece Title: Le Serve Rivali

Cast
Role: Giacinta Actor: Sga Sestini.

Dance: As17810123

Performances

Mainpiece Title: Le Serve Rivali

Cast
Role: Giacinta Actor: Sga Sestini.

Dance: As17801216

Performances

Mainpiece Title: Le Serve Rivali

Cast
Role: Giacinta Actor: Sga Sestini.

Dance: As17810210

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: new Pastoral Ballet (composed by Simonet) The Country Diversions-Sg and Sga Zuchelli, Henry, Sga Crespi, Slingsby, Sga Tantini; and to finish with a grand Chaconne-Vestris? Jun

Ballet: End Opera: a new grand Pantomime Ballet in 3 acts (composed by Vestris Sen.) Ninette a la Cour. Sg Zuchelli, Sga Zuchelli, Henry, Sga Crespi, Mlle Baccelli, Vestris Jun., Mme Simonet, Vestris Sen. (1st appearance in England). Cast, with synopsis, from Public Advertiser, 26 Feb.: Nancy-Mlle Baccelli; Colas-Vestris Jun.; Prince-Vestris Sen.; Countess-Mme Simonet; Dancing@Master-Simonet; Mayor of the Town-Delpini; Peasants-Slingsby, Sga Tantini, Traffieri, 16 Figure Dancers; Lords-Zuchelli, Henry; Ladies-Sga Zuchelli, Sga Crespi; Huntsmen-; Captain of Life Guards-; Equerries-; Notaries-

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: The Nymphs of Diana, as17810210

Ballet: End Opera: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810222 throughout

Ballet: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: The Rural Sports, as17810123

Ballet: End: Ninette a la Cour. As17810222

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: The Rural Sports, as17810123

Ballet: End Opera: Ninette a la Cour. As17810222, but The Devonshire Minuet-Mme Simonet, Vestris Sen

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810329throughout.

Ballet: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: The Fortunate Escape, as17801216; End II: Grand Serious Ballet, as17810315Pas@Solo, as17810315Pas de Deux, as17810315Grand Chaconne, as17810315End Opera: Les Amans Surpris, as17801216

Song: Act II: the favourite song in Il Barone di Torre Forte-Sga Sestini

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Surpris, as17801216

Ballet: End II: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Surpris, as17801216

Ballet: End II: Ninette a la Cour (with Improvements). As17810327

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: The Rural Sports, as17810123

Ballet: End Opera: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17810510 throughout

Ballet: Medee et Jason. As17810510

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: End I: Grand Serious Ballet, as17801216, but Mlle _Baccelli; Grand Chaconne, as17801216

Ballet: End Opera: Ninette a la Cour. As17810505

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17810324throughout.

Ballet: Ninette a la Cour. As17810324