SELECT * FROM london_stages WHERE eventid IN (17801, 20204, 26545, 26643, 26652, 26657, 26668, 26672, 26679, 26701, 26707, 26711, 26715, 26717, 26723, 26733, 26740, 26761, 26770, 26800, 26808, 26860, 26885, 26901, 26935, 27019, 27032, 27051, 27079, 30345, 30392, 30431, 30462, 30495, 30640, 30655, 30667, 30679, 30693, 30698, 30842, 30864, 30890, 30895, 30904, 30909, 30918, 30921, 30932, 30939, 30946, 30949, 30960, 30963, 30975, 30978, 31000, 31042, 31186, 31249, 32256, 32258, 32390, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32454, 32459, 32464, 32466, 32523, 32526, 32546, 32644, 32693, 32722, 32724, 32734, 32748, 37386, 37391, 37396, 37400, 37405, 37410, 37451, 37455, 37460, 37462, 37465, 37467, 37470, 37475, 37488, 37495, 37500, 37514, 37517, 37519, 37555, 37574, 37604, 37611, 37616, 37646, 37651, 37658, 37683, 37685, 37692, 37695, 37702, 37703, 37705, 37707, 37708, 37712, 37713, 37716, 37721, 37723, 37724, 37727, 37733, 37738, 37753, 37755, 37756, 37757, 37761, 37763, 37764, 37767, 37768, 37769, 37771, 37772, 37773, 37789, 37815, 37909, 37914, 37916, 37919, 37921, 37928, 37930, 37933, 37935, 37937, 37945, 37949, 37951, 37954, 37969, 37973, 37977, 37982, 37985, 37991, 37994, 38003, 38026, 38037, 38040, 38047, 38112, 38118, 38151, 38195, 38207, 38212, 38213, 38218, 38219, 38221, 38223, 38224, 38229, 38233, 38235, 38241, 38246, 38250, 38253, 38254, 38256, 38257, 38260, 38261, 38263, 38267, 38268, 38269, 38270, 38271, 38272, 38274, 38278, 38279, 38280, 38283, 38285, 38286, 38287, 38288, 38290, 38292, 38295, 38296, 38297, 38298, 38300, 38303, 38304, 38305, 38306, 38307, 38308, 38309, 38311, 38315, 38330, 38334, 38336, 38341, 38351, 38369, 38371, 38383, 38387, 38390, 38392, 38394, 38399, 38420, 38427, 38441, 38469, 38488, 38494, 38500, 38523, 38540, 38549, 38556, 38570, 38575, 38578, 38580, 38583, 38585, 38588, 38596, 38598, 38603, 38611, 38613, 38619, 38624, 38639, 38644, 38653, 38668, 38680, 38684, 38689, 38694, 38706, 38731, 38736, 38745, 38748, 38768, 38771, 38775, 38790, 38860, 38885, 38894, 38918, 38937, 38946, 38976, 39030, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39083, 39086, 39093, 39098, 39107, 39114, 39123, 39135, 39137, 39163, 39190, 39196, 39199, 39208, 39213, 39216, 39219, 39228, 39230, 39239, 39242, 39245, 39247, 39250, 39257, 39260, 39262, 39265, 39270, 39276, 39280, 39282, 39285, 39291, 39298, 39301, 39303, 39308, 39317, 39329, 39346, 39774, 39845, 39916, 39921, 39923, 39926, 39931, 39936, 39938, 39941, 39946, 39974, 40018, 40283, 40309, 40878, 40887, 40892, 40908, 40913, 40923, 40929, 40939, 40968, 40981, 40995, 41000, 41007, 41016, 41024, 41032, 41220, 41225, 41267, 41307, 41362, 41377, 41391, 41395, 41400, 41405, 41409, 41418, 41422, 41426, 41431, 41437, 41443, 41448, 41456, 41463, 41472, 41482, 41521, 41530, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 42341, 42346, 42355, 42365, 42370, 42375, 42384, 42390, 42399, 42404, 42413, 42418, 42423, 42428, 42433, 42438, 42443, 42446, 42453, 42459, 42468, 42482, 42487, 42497, 42502, 42511, 42523, 42537, 42542, 42547, 42552, 42572, 42577, 42587, 42595, 42600, 42604, 42613, 42617, 42621, 42626, 42630, 42634, 42639, 42647, 42652, 42660, 42675, 42680, 42685, 42695, 42700, 42710, 42715, 42771, 42776, 42779, 47102, 49554) 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: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: As17821119 throughout

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17821109 throughout

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: End of Act I Apelles and Campaspe, as17821102; End of Opera New Divertisement, as17821102, but Sga Crespi in place of Sga Sala, and added: Pas de Deux by Lepicq and Mme Rossi (1st appearance in this country)

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17821130 throughout

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17821130 throughout

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I Apelles and Campaspe, as17821102; End of Act II New Divertisement, as17821130, and added: a second Pas de Deux by Master Laborie and Miss Simonet (their 1st appearance)

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821130; End of Opera a new grand Ballet, composed by Lepicq, Il Ratto delle Sabine; or, The Rape of the Sabines, by Lepicq, Henry, Zuchelli, Degville Sen., Slingsby, Mlle Theodore, Sga Crespi, Mme Rossi. [Partial cast from Public Advertiser, 14 Dec: Romolo-Lepicq; Acronte-Zuchelli; Erfilia-Mme Rossi.]

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: As17821212 throughout

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I New Divertisement, probably as17821119; End of Open Apelles and Campaspe, probably as17821102, but added: Henry

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821102, but Sga Crespi in place of Sga Sala; added: Pas de Deux, as17821210 End of Act II Apelles and Campaspe, as17821102

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I Apelles and Campaspe, as17821102; End of Opera New Divertisement, as17821102, with Passacaille, as17821109

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821102, but Sga Crespi in place of Sga Sala; End of Opera Il Ratio delle Sabine, as17821212

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17821212 throughout

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821130; End of Act II an entirely new Ballet (1st time; composed by Lepicq), he Tuteur Trompl; or, The Guardian Outwitted, by Lepicq, Slingsby, Henry, Zuchelli, Sga Crespi, Mlle Theodore, Mme Rossi, with two Pas de Basque by Mlle Theodore

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830111 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830116 throughout

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: As17830116 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821130, but omitted: Mlle Theodore; End of Act II Le Tuteur Trompe, as17830111, but omitted: Mlle Theodore, Pas de Basque

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830128 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830128 throughout

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: As17830116 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I Le Tuteur Trompe, as17830111, with two Pas de Deux, in a stile entirely new, called Pas de Lapons; or, Laplanders' Dance, by Slingsby and Mlle Theodore; End of Act II a new Pastoral Ballet by the principal Dancers, with a variety of Pas Seuls and a Pas de Deux by Slingsby and Mlle Theodore, and to conclude with a Grand Allemande by Lepicq, Mme Rossi, Slingsby, Mlle Theodore

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I Le Tuteur Trompe, as17830128; End of Act II an entirely new ballet of Serious, Comic, and Demi-characters, composed by Lepicq, Les spouses Persanes; or, The Persian Wives, by Lepicq, Mme Rossi, Slingsby, Henry, Zuchelli, Sga Crespi, Mlle Theodore, Mme Simonet. [Cast from Public Advertiser, 18 Feb.: Tamas-Lepicq; Hircana-Mme Rossi; Osman-Slingsby; Mahmoud-Henry; Boulganzar-Zuchelli; Slaves-Sga Crespi, Mlle Theodore; Fatima-Mme Simonet; Assan-Degville Sen.]