SELECT * FROM london_stages WHERE eventid IN (44937, 44942, 44947, 44962, 44967, 44976, 44981, 44987, 44999, 45005, 45014, 45033, 45042, 45046, 45052, 45058, 45061, 45066, 45072, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45322, 45331, 45336, 45345, 45350, 45357, 45362, 45366, 45370, 45375, 45382, 45387, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 45545, 45570, 45585, 45598, 45973, 46000, 46013, 46026, 46048, 46086, 46091, 46096, 46101, 46119, 46164, 46360, 46362, 46364, 46368, 46372, 46376, 46378, 46380, 46384, 46388, 46390, 46392, 46396, 46398, 46400, 46404, 46408, 46416, 46420, 46424, 46428, 46432, 46437, 46442, 46447, 46451, 46456, 46461, 46465, 46470, 46475, 46477, 46480, 46482, 46487, 46491, 46496, 46501, 46505, 46510, 46516, 46518, 46526, 46528, 46530, 46534, 46539, 46540, 46542, 46544, 46548, 46553, 46554, 46556, 46558, 46562, 46563, 46568, 46570, 46576, 46581, 46582, 46584, 46587, 46591, 46599, 46608, 46613, 46616, 46621, 46628, 46638, 46643, 46651, 46658, 46665, 46672, 46680, 46694, 46719, 46730, 46827, 46842, 46843, 46845, 46850, 46853, 46859, 46862, 46866, 46872, 46876, 46878, 46882, 46886, 46890, 46894, 46898, 46902, 46904, 46910, 46914, 46916, 46926, 46928, 46934, 46938, 46940, 46946, 46948, 46950, 46952, 46956, 46960, 46962, 46964, 46968, 46972, 46982, 46984, 46986, 46988, 46992, 46994, 46996, 46998, 47000, 47002, 47004, 47006, 47010, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47040, 47042, 47044, 47046, 47050, 47054, 47058, 47065, 47067, 47070, 47072, 47078, 47082, 47085, 47087, 47095, 47097, 47103, 47107, 47113, 47118, 47138, 47149, 47166, 47182, 47185, 47213, 47219, 47230, 47243, 47252, 47254, 47269, 47272, 47296, 47303, 47443, 47445, 47448, 47450, 47457, 47460, 47463, 47465, 47468, 47471, 47476, 47481, 47483, 47490, 47492, 47494, 47518, 47524, 47567, 47571, 47594, 47596, 47620, 47622, 47642, 47646, 47677, 47679, 47682, 47692, 47703, 47718, 47743, 47763, 47778, 47807, 47817, 47859, 47864, 47871, 47893, 47899, 47907, 47995, 47996, 47998, 48001, 48009, 48011, 48013, 48014, 48016, 48018, 48022, 48025, 48040, 48044, 48052, 48056, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48112, 48122, 48165, 48179, 48181, 48185, 48195, 48208, 48210, 48219, 48222, 48224, 48237, 48242, 48253, 48262, 48267, 48276, 48277, 48281, 48290, 48293, 48298, 48302, 48305, 48307, 48312, 48316, 48319, 48323, 48326, 48328, 48335, 48340, 48343, 48350, 48355, 48357, 48364, 48367, 48369, 48371, 48374, 48378, 48381, 48385, 48392, 48395, 48399, 48401, 48405, 48414, 48415, 48419, 48420, 48424, 48428, 48429, 48436, 48441, 48455, 48460, 48463, 48468, 48521, 48548, 48554, 48564, 48572, 48578, 48591, 48597, 48612, 48624, 48638, 48658, 48670, 48676, 48678, 48686, 48688, 48690, 48700, 48706, 48710, 48728, 48730, 48738, 48740, 48746, 48750, 48758, 48768, 48772, 48780, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48820, 48825, 48827, 48831, 48833, 48836, 48843, 48845, 48850, 48852, 48855, 48857, 48859, 48864, 48866, 48869, 48871, 48873, 48880, 48883, 48888, 48891, 48893, 48900, 48903, 48910, 48917, 48919, 48924, 48928, 48931, 48934, 48946, 48953, 48957, 48960, 48962, 48989, 49001, 49015, 49020, 49022, 49027, 49030, 49035, 49040, 49042, 49045, 49050, 49055, 49057, 49060, 49068, 49071, 49073, 49076, 49082, 49112, 49116, 49117, 49119, 49120, 49122, 49221, 49223, 49231, 49233, 49235, 49243, 49259, 49267, 49271, 49275, 49281, 49287, 49291, 49295, 49299, 49309, 49318, 49323, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49372, 49375, 49379, 49384, 49398, 49400, 49405, 49410, 49417, 49421, 49424, 49426, 49435, 49444, 49542, 49544, 49547, 49564, 49569, 49582, 49584, 49586, 49591, 49596, 49598, 49601, 49606, 49608, 49615, 49621, 49624, 49634, 49636, 49641, 49645, 49648, 49758, 49760, 49763, 49769, 49776, 49792, 49793, 49800, 49808, 49810, 49814, 49816, 49828, 49836, 49840, 49842, 49848, 49852, 49856, 49880, 49890, 49906, 49914, 49916, 49928, 49932, 49934, 49939, 49944, 50012, 50040, 50047, 50051, 50054, 50063, 50066, 50069, 50072, 50078, 50086, 50088, 50091, 50101, 50103, 50105, 50107, 50112, 50115, 50117, 50120, 50122, 50130, 50133, 50137, 50145, 50152, 50155, 50157, 50171, 50176, 50183, 50185, 50188, 50190, 50194, 50197, 50199, 50202, 50204, 50207, 50209, 50212, 50218, 50219, 50220, 50223, 50228, 50641, 50648, 50653, 50681, 50691, 50707, 50761, 50812, 50823) 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 Re Teodoro In Venezia

Cast
Role: Belisa Actor: Sga Sestini
Role: Lisetta Actor: Sga Storace.

Dance: As17880103

Performances

Mainpiece Title: Il Re Teodoro In Venezia

Cast
Role: Belisa Actor: Sga Sestini
Role: Lisetta Actor: Sga Storace.

Dance: As17880103

Performances

Mainpiece Title: Il Re Teodoro In Venezia

Cast
Role: Belisa Actor: Sga Sestini
Role: Lisetta Actor: Sga Storace.

Dance: End I: a new ballet, The Military Dance (composed by Chevalier)-Didelot, Chevalier, Coulon, Vestris, Mlle Coulon, the two Miss Simonets, Sga Bedini, Mlle Hilligsberg; End Opera: Les Offrandes a l'Amour, as17871208

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: End I: The Military Dance, as17880112, but Henry; a +Pas de Deux (composed by Noverre)-Didelot, Mlle Coulon; Pas de Deux (composed by Vestris)-Vestris, Mlle Hilligsberg; End Opera: Les Offrandes a l'Amour, as17871208

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: As17880115

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: As17880115

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: As17880115

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: End I: Divertissement, as17871208

Ballet: End Opera: a new ballet (1st time), composed by Noverre, L'Amour et Psiche. By Mlle Hilligsberg, Didelot, Mlle Coulon, Chevalier, Vestris, Sga Bedini, the two Miss Simonets, Mlle Vedie, Henry, Jacolet, Saulnier, Sala, Coulon. Cast from synopsis (H. Reynell, 1788): Psyche-Mlle Hilligsberg; Adonis-Didelot; Venus-Mlle Coulon; Hymen-Chevalier; Love, or Cupid-Vestris; Graces Furies and Fates-Sga Bedini, the two Miss Simonets, Mlle Vedie, Henry, Jacolet, Saulnier, Sala; Mercury-Coulon. The music composed by Mazzinghi; with all new Scenery (by Marinari), Dresses (by Lupino)

Performances

Mainpiece Title: Il Re Teodoro In Venezia

Cast
Role: Belisa Actor: Sga Sestini
Role: Lisetta Actor: Sga Storace.

Dance: As17880115

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: End I: Les Offrandes a l'Amour, as17871208

Ballet: End Opera: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Ballet: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: End I: The Military Dance, as17880115

Ballet: End Opera: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Il Re Teodoro In Venezia

Cast
Role: Belisa Actor: Sga Sestini
Role: Lisetta Actor: Sga Storace.

Dance: As17880212

Ballet: L'Amour et Psiche. As17880212

Performances

Mainpiece Title: La Locandiera

Cast
Role: Livia Actor: Sga Schinotti
Role: Madama Brillante Actor: Sga Storace.

Dance: As17880129

Ballet: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: End I: a New Dance-; in which will be introduced a Pas de Bernois-Didelot, Mlle Coulon; Pas de Trois-Coulon, the two Miss Simonets; Pas de Deux-Henry, Miss Harvey; a Pas Seul-Chevalier; Pas Seul-Mlle Coulon; the favorite Pas de Russe (composed by Gardel)-Vestris, Mlle Hilligsberg; Hornpipe-Chevalier; Pas de Cinq-the principal Dancers; Pas de Sept-the principal Dancers; conclude with: General Dance-all the Performers

Song: II: a favorite song, Gli affetti mici , composed by Paisiello,-Sga Sestini; violin obligato accompaniment-Cramer

Ballet: End Opera: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Song: As17880221

Dance: End Opera: Les Offrandes a l'Amour, as17871208; End I: New Dance, as17880221; Pas de Bernois, as17880221; Pas de Trois, as17880221; a Pas Seul, as17880221; Pas Seul, as17880221; Pas de Russe, as17880221; Pas de Cinq, as17880221; General Dance, as17880221; Pas de Sept, as17880221

Performances

Mainpiece Title: Il Re Teodoro In Venezia

Cast
Role: Belisa Actor: Sga Sestini
Role: Lisetta Actor: Sga Storace.

Dance: End Opera: Les Offrandes a l'Amour, as17871208; End I: New Dance, as17880221; Pas de Bernois, as17880221; Pas de Trois, as17880221; Pas de Deux, as17880221; Pas Seul, as17880221; Pas de Russe, as17880221; Pas de Cinq, as17880221; Pas de Sept, as17880221; General Dance, as17880221; omitted: Pas Seul by Chevalier, Hornpipe

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: End I: an entire new ballet, composed by Noverre, Les Fetes de Tempe. Principal Characters-Mlle Hilligsberg, Mlle Coulon, Didelot, Vestris, Henry, the two Miss Simonets, Coulon

Ballet: End Opera: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: End I: As17880226, but Les Offrandes a l'Amour-_; End Opera: Les Fetes de Tempe, as17880228, but _Henry

Performances

Mainpiece Title: La Cameriera Astuta

Cast
Role: Leonora Actor: Sga Sestini
Role: Dirindina Actor: Sga Schinotti
Role: Violetta Actor: Sga Storace.

Dance: End Opera: Les Fetes de Tempe, as17880301End I: New Dance, as17880226; Pas de Bernois, as17880226; Pas de Trois, as17880226; Pas Seul, as17880226; Pas de Russe, as17880226; Pas de Cinq, as17880226; Pas de Sept, as17880226; General Dance, as17880226

Performances

Mainpiece Title: La Cameriera Astuta

Cast
Role: Leonora Actor: Sga Sestini
Role: Dirindina Actor: Sga Schinotti
Role: Violetta Actor: Sga Storace.

Dance: As17880129

Performances

Mainpiece Title: La Cameriera Astuta

Cast
Role: Leonora Actor: Sga Sestini
Role: Dirindina Actor: Sga Schinotti
Role: Violetta Actor: Sga Storace.

Dance: End I: New Dance As17880221, but Hornpipe-_

Ballet: End Opera: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: As17880129

Ballet: L'Amour et Psiche. As17880129

Performances

Mainpiece Title: Gli Schiavi Per Amore

Cast
Role: Mlle Neri Actor: Sga Sestini
Role: Mlle Pate Actor: Sga Schinotti
Role: Gelinda Actor: Sga Anna Storace.

Dance: End I: Les Fetes de Tempe-[see17880228]; End Opera: a new grand Tragic Ballet, never performed, Euthyme et Eucharis[, composed by Noverre. Principal Characters-Mlle Hilligsberg, Didelot, Mlle Coulon, Vestris, Sga Bedini, the two Miss Simonets, Mme Vedie, Henry, Jacolet, Saulnier, Sala, Coulon. [Partial cast from Lynham, 170: Eucharis-Mlle Hilligsberg; +Mars-Didelot; +Euthyme-Vestris; +L'Ombre-Henry; +Bellone-Coulon.