SELECT * FROM london_stages WHERE eventid IN (39174, 39192, 39382, 39733, 39747, 39761, 39783, 39794, 39809, 39825, 40110, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40171, 40186, 40200, 40215, 40229, 40241, 40255, 40260, 40268, 40273, 40280, 40286, 40293, 40298, 40306, 40312, 40317, 40321, 40327, 40336, 40346, 40351, 40356, 40365, 40370, 40375, 40380, 40385, 40394, 40399, 40409, 40423, 40434, 40439, 40442, 40451, 40456, 40464, 40470, 40477, 40485, 40490, 40689, 40704, 40709, 40715, 40724, 40744, 40768, 40773, 40782, 40785, 40793, 40798, 40805, 40810, 40817, 40822, 40829, 40835, 40843, 40849, 40857, 40863, 40871, 40903, 40918, 41046, 48195, 48212, 48221, 48226, 48234, 48239, 48253, 48262, 48267, 48276, 48281, 48290, 48295, 48304, 48318, 48323, 48332, 48337, 48345, 48350, 48359, 48364, 48373, 48378, 48387, 48392, 48399, 48405, 48414, 48419, 48428, 48433, 48441, 48446, 48452, 48455, 48460, 48463, 48468, 48795, 48800, 48809, 48814, 48823, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48889, 48894, 48901, 48906, 48915, 48920, 48929, 48935, 48944, 48949, 48958, 48963, 48972, 48991, 49005, 49010, 49019, 49024, 49029, 49034, 49039, 49049, 49054, 49059, 49064, 49070, 49075, 49078, 49084, 49093, 49098, 49104, 49106, 49108, 49113, 49115, 49118, 49121, 49124, 49303, 49308, 49317, 49322, 49331, 49336, 49341, 49346, 49355, 49360, 49402, 49409, 49423, 49437, 49447, 49450, 49455, 49460, 49463, 49468, 49476, 49481, 49488, 49491, 49496, 49505, 49510, 49514, 49518, 49523, 49532, 49537, 49546, 49551, 49561, 49566, 49571, 49576, 49581, 49590, 49595, 49600, 49605, 49610, 49617, 49623, 49628, 49633, 49638, 49647, 49652, 49661, 49673, 49676, 49681, 49684, 49689, 49692, 49697, 49884, 49889, 49898, 49903, 49908, 49913, 49927, 49936, 49941, 49950, 49955, 49964, 49969, 49976, 49981, 49990, 49995, 50007, 50014, 50020, 50027, 50039, 50049, 50071, 50090, 50109, 50114, 50119, 50149, 50154, 50227, 50233, 50244, 50249, 50258, 50274, 50281, 50431, 50436, 50445, 50450, 50459, 50464, 50473, 50478, 50485, 50490, 50499, 50504, 50513, 50518, 50527, 50532, 50541, 50547, 50557, 50560, 50569, 50589, 50598, 50612, 50617, 50624, 50629, 50636, 50672, 50677, 50710, 50720, 50729, 50798, 50803, 50810, 50822, 50852, 50855, 50860, 50863, 50868, 51010, 51019, 51025, 51034, 51039, 51055, 51062, 51079, 51122, 51131, 51157, 51176, 51183, 51188, 51195, 51200, 51219, 51228, 51232, 51238, 51245, 51250, 51259, 51264, 51269, 51275, 51281, 51286, 51296, 51305, 51315, 51320, 51325, 51334, 51339, 51346, 51352, 51361, 51389, 51409, 51414, 51417, 51422, 51429, 51594, 51599, 51622, 51625, 51632, 51637, 51646, 51651, 51660, 51665, 51674, 51679, 51689, 51695, 51719, 51726, 51731, 51738, 51744, 51751, 51756, 51763, 51768, 51775, 51795, 51809, 51818, 51829, 51834, 51839, 51852, 51857, 51862, 51880, 51891, 51896, 51905, 51910, 51915, 51945, 51979, 51995, 52006, 52014, 52232, 52237, 52246, 52251, 52260, 52265, 52272, 52278, 52287, 52292, 52301, 52306, 52315, 52320, 52327, 52332, 52339, 52344, 52351, 52356, 52363, 52368, 52375, 52380, 52387, 52392, 52406, 52411, 52416, 52421, 52430, 52435, 52440, 52445, 52450, 52459, 52464, 52469, 52474, 52487, 52493, 52502, 52507, 52517, 52523, 52530, 52533, 52538, 52541, 52546, 52549, 52554, 52557, 52562, 52565, 52570, 52573, 52578) 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: Demofoonte

Cast
Role: Matusio Actor: Rovedino

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17781128

Performances

Mainpiece Title: Artaserse

Cast
Role: Megabise Actor: Rovedino

Dance: As17790209

Performances

Mainpiece Title: Demofoonte

Cast
Role: Matusio Actor: Rovedino

Dance: As17790209

Performances

Mainpiece Title: Artaserse

Cast
Role: Megabise Actor: Rovedino

Dance: As17790209

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: II: Ballet connected with the Opera, by Genii of the various Arts- (See17790302 Pedal Harp-Hochbrucher; End II: new Ballet by Fairies of the Court of Azore,-Banti, Sga Tinti, LeDet, Henry, young Miss Simonet, Mlle Baccelli (1st appearance this season); End Opera: new serious Ballet, Le Couronnement de Zemire-Mons and Mme Simonet, Banti, Sg and Sga Zuchelli, Sga Tinti, Slingsby

Performances

Mainpiece Title: Demofoonte

Cast
Role: Matusio Actor: Rovedino

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17791128, but Mlle Baccelli

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: II: Ballet by Genii as17790223-Sg Zuchelli, Sga Zuchelli, young Miss Simonet; also Pedal Harp, as17790223; End II: Ballet by Fairies, as17790223, but _LeDet, _Henry, young Miss _Simonet, Slingsby; End Opera: +Le Couronnement de Zemire, as17790223

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Demofoonte

Cast
Role: Matusio Actor: Rovedino

Dance: End of new song: Les Oiseleurs, as17790123; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17790227

Song: End I: a new song-Pacchierotti; with violin obligato composed by Bertoni-Cramer; In III: an additional song composed by Handel-Pacchierotti

Performances

Mainpiece Title: Demofoonte

Cast
Role: Matusio Actor: Rovedino

Dance: As17790311

Song: In III: an additional song, as17790311

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: End I: a new Ballet, Hippomene et Atalante. Hippomene-Simonet, Atalante- Mlle Baccelli, Sg and Sga Zuchelli, Mlle Vidini, Slingsby; End II: a new Ballet, connected with the Opera, +Les Forges de Vulcain. Venus-Mme Simonet, the 3 Graces- Sga Zuchelli, Sga Tinti, Miss Rose, +Cupid- young Miss Simonet, +the 3 Cyclopes- Banti, Zuchelli, LeDet, +Vulcain- Slingsby; With a grand Chorus of the Cyclopes by $Sacchini-

Ballet: End Opera: a new Serious Ballet, La Fete du Ciel. Apollo-Mme Simonet; Flora-Sga Tinti; Zephir-Banti; Iris-Mlle Baccelli; To conclude with a grand Chaconne, in which-Mme Simonet will dance in a Man's Dress

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: II: Ballet by Genii, as17790302 but Pedal Harp-_; End II: Ballet by Fairies, as17790302End Opera: a new grand Military Pantomime Ballet, La Bravoure des Femmes, in which-Mme Simonet,in the character of Leading Officer, will fight a Duel at Small Sword; The other Principal Parts Mlle Baccelli, Simonet, Sg and Sga Zuchelli, Slingsby; Minuet-Mme Simonet, Mlle Baccelli

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Sandro Actor: Rovedino

Dance: As17790302

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: As17790325

Ballet: La Fete du Ciel. As17790325

Performances

Mainpiece Title: Enea E Lavinia

Cast
Role: Ilioneo Actor: Rovedino

Dance: As17790325

Ballet: La Fete du Ciel. As17790325