SELECT * FROM london_stages WHERE eventid IN (38080, 38095, 38104, 38125, 38130, 38140, 38155, 38169, 38185, 38199, 38238, 38252, 38264, 38504, 38518, 38532, 38631, 38641, 38646, 38660, 38665, 38708, 38797, 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, 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, 44987, 44993, 44999, 45005, 45014, 45033, 45042, 45046, 45052, 45058, 45059, 45061, 45066, 45067, 45070, 45072, 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, 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: Donna Stella Actor: Sga Lorenzini
Role: Lisetta Actor: Sga Prudom
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

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

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

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini
Role: Lisetta Actor: Sga Prudom
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Surpris, as17801216

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini
Role: Lisetta Actor: Sga Prudom
Role: Violante Actor: Sga Sestini.

Dance: End I: Les Amans Surpris, as17801216

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

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

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Serpina Actor: Sga Prudom
Role: Lucinda Actor: Sga Sestini.

Dance: End I: The Rural Sports, as17810123

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Serpina Actor: Sga Prudom
Role: Lucinda Actor: Sga Sestini.

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

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

Ballet: End Opera: Ninette a la Cour. As17810505

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini
Role: Lisetta Actor: Sga Prudom
Role: Violante Actor: Sga Sestini.

Dance: As17810324throughout.

Ballet: Ninette a la Cour. As17810324

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Serpina Actor: Sga Prudom
Role: Lucinda Actor: Sga Sestini.

Dance: End I: Les Caprices de Galatee, as17810329

Ballet: End Opera: Ninette a la Cour. As17810327

Performances

Mainpiece Title: Il Barone Di Torre Forte

Cast
Role: Serpina Actor: Sga Prudom
Role: Lucinda Actor: Sga Sestini.

Dance: As17810526 throughout

Ballet: Ninette a la Cour. As17810526

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini
Role: Lisetta Actor: Sga Prudom
Role: Violante Actor: Sga Sestini.

Dance: As17810501 throughout

Cast
Role: Les Amans Surpris Actor: Sg and Sga Zuchelli, Henry, Mlle Baccelli, Vestris? Jun.

Performances

Dance: Incident to the piece: Ballets by Vestris Sen.-Vestris Sen., Vestris Jun., Simonet, Slingsby, Traffieri, Zuchelli, Henry, Mme Simonet, Mlle Baccelli, Sga Crespi, Sga Zuchelli, Miss Stageldoir, Miss Armstrong

Performances

Dance: As17810605

Music: End Part I: a concerto on the hautboy-LeBrun; End Part II: a concerto on the violin-Cramer

Performances

Dance: As17810605

Music: End Part II: a concerto on the hautboy-LeBrun

Performances

Mainpiece Title: Il Bacio

Cast
Role: Clarice Actor: Sga Lorenzini
Role: Scaltrina Actor: Sga Salpietro
Role: Zuccherina Actor: Sga Sestini.

Dance: As17820402 throughout

Performances

Mainpiece Title: Il Bacio

Cast
Role: Clarice Actor: Sga Lorenzini
Role: Scaltrina Actor: Sga Salpietro
Role: Zuccherina Actor: Sga Sestini.

Dance: As17820605throughout

Performances

Mainpiece Title: Il Bacio

Cast
Role: Clarice Actor: Sga Lorenzini
Role: Scaltrina Actor: Sga Salpietro
Role: Zuccherina Actor: Sga Sestini.

Dance: End of Act I New Dance, as17820603 End of Opera Apelles and Campaspe, as17820605

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: All the World's a Stage

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Country Mad-cap