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: La Cameriera Astuta

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

Dance: End Opera: Euthyme et Eucharis, as17880313End I: New Dance, as17880308Pas de Bernois, as17880308_Didelot, Coulon; +Pas de Trois, as17880308a Pas Seul-Chevalier; Pas de Deux, as17880308Pas Seul, as17880308Pas de Russe, as17880308Hornpipe, as17880308Pas de Cinq, as17880308Pas de Sept, as17880308General Dance, as17880308

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: As17880315but Euthyme et Eucharis-_

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

Performances

Mainpiece Title: La Cameriera Astuta

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

Ballet: L'Amour et Psiche. As17880329

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: As17880403

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 Ballet, as17880403, but _Gardel

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: As17880426

Ballet: L'Amour et Psiche. As17880426

Performances

Dance: End I: New Ballet, as17880426; with a Pas de Deux-Miss Harvey, Henry

Song: In opera: the Grand Quintetto (never performed in this Country)-; several beautiful parts of music as performed in the original Opera-

Ballet: End Opera: L'Amour et Psiche. As17880129, but Hymen-Henry in place of Chevalier; Graces Furies and Fates-Mlle _Vedie, Miss Harvey, _Jacolet, _Saulnier, _Sala; Didelot_; Coulon_

Performances

Dance: As17880503

Song: As17880515

Performances

Dance: End I: New Ballet, as17880426; End Opera: Adela de Ponthieu, as17880419

Song: Grand Quintetto, as17880515

Performances

Dance: End I: New Ballet, as17880426

Song: As17880515

Ballet: End Opera: The Deserter. As17880529

Performances

Mainpiece Title: A Grand Selection 0 [of Sacred Music From The Works Of handel, Chiefly Performed At westminster-abbey At The handel Commemoration, 26 May 1784]; Messiah

Afterpiece Title: The Coronation Anthem, God save the King

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violin-Mme Gautherot

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17890227; End Part I: Concerto by Handel on organ-Greatorex

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A gala Sponsored By brooks's Club, Celebration Of king's Recovery [and See 15, 24 Apr

Performances

Mainpiece Title: La Vendemmia

Cast
Role: Artemisia Actor: Sga Sestini
Role: Lauretta Actor: Sga Borselli
Role: Agatina Actor: Sga Storace.

Dance: As17890404

Performances

Mainpiece Title: La Vendemmia

Cast
Role: Artemisia Actor: Sga Sestini
Role: Lauretta Actor: Sga Borselli
Role: Agatina Actor: Sga Storace.

Dance: End I: Admete-, as17890428; End Opera: Les Caprices de Galatee, as17890507

Performances

Mainpiece Title: La Vendemmia

Cast
Role: Artemisia Actor: Sga Sestini
Role: Lauretta Actor: Sga Borselli
Role: Agatina Actor: Sga Storace.

Dance: End I: Admete, as17890402; End Opera: a new Ballet, composed in Paris by Gardel Sen. for Mlle Guimard, Ninette a la Cour , Ninette -Mlle Guimard

Performances

Mainpiece Title: La Vendemmia

Cast
Role: Artemisia Actor: Sga Sestini
Role: Lauretta Actor: Sga Borselli
Role: Agatina Actor: Sga Storace.

Dance: As17890404

Performances

Mainpiece Title: La Vendemmia

Cast
Role: Artemisia Actor: Sga Sestini
Role: Lauretta Actor: Sga Borselli
Role: Agatina Actor: Sga Storace.

Dance: End I: La Nymphe et le Chasseur, as17890319End Opera: Les Caprices de Galatee-. Galatee-Mlle Guimard

Performances

Mainpiece Title: Il Barbiere Di Siviglia; Or, The Spanish Barber

Dance: End II: New Divertissement-[See17890110]; End Opera: La Nymphe et le Chasseur, as17890606

Music: End I: a Trio for Piano Forte Violin and Violoncello-Clementi, Cramer, Cervetto

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Adela Actor: Sga Storace

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Adela Actor: Sga Storace

Afterpiece Title: The Humourist

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Adela Actor: Sga Storace

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Haunted Tower

Cast
Role: Adela Actor: Sga Storace

Afterpiece Title: Who's the Dupe