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: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830215 throughout

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: As17830218 throughout

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17830218; End of Act II Le Tuteur Trompe, as17830128

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830204 throughout

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: End of Act II New Divertisement, as17821130; End of Act III Les Epouses Persanes, as17830215, but added: Degville Sen

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I an entirely new Divertissement, composed by Lepicq, li Riposo del Campo; or, The Recreations of the Camp, in which a Pas de Deux, La Recrue par Force; or, The Kidnappers, by Lepicq and Mme Rossi, and the other characters by Slingsby, Henry, Zuchelli, Sga Crespi, Mlle Theodore; End of Opera a new Ballet (1st time), founded on the Fairy Tale by Voltaire, La Begueule; or, She Wou'd and She Wou'd Not, in which a Minuet by Lepicq and Mme Rossi, and the other characters by Slingsby, Henry, Degville Jun., Sga Crespi, Mlle Theodore, Mme Simonet

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: As17830315hroughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I Il Riposo del Campo, as17830313End of Act II La Bigueule, as17830313but omitted: Mlle Theodore, Mme Simonet

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: End of Act I Il Riposo del Campo, as17830313but omitted: Slingsby; End of Act II La Bigueule, as17830320athi

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: As17830322hroughout

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821130, but omitted: Slingsby, Mlle Theodore; End of Act II Le Tuteur Trompe, as17830128

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: End of Act I La Begueule, as17830320End of Act II Il Riposo del Campo, as17830322athi

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: End of Act I Le Tuteur Trompe, as17830128; End of Act II Il Riposo del Campo, as17830322athi

Performances

Mainpiece Title: Zemira And Azor

Cast
Role: Fatima Actor: Sga Gherardi

Dance: End of Act II New Divertisement, as17821130; End of Act III Il Riposo del Campo, as17830322athi

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: As17830405 throughout

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17821130, but omitted: Slingsby; End of Act II 11 Riposo del Campo, as17830313but Degville Jun. in place of Slingsby

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: End of Act I Le Tuteur Trompe, as17830128; End of Act II Il Riposo del Campo, as17830412, but omitted: Sga Crespi

Performances

Mainpiece Title: Il Convito

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I New Divertisement, as17830327End of Act II Le Teteur Trompe, as17830128, with Sequedilla and Fandango, as17830410

Performances

Mainpiece Title: Creusa In Delfo

Cast
Role: Laodamia Actor: Sga Gherardi

Dance: End of Act I La Begucule, as17830320End of Act II Le Tuteur Trompe, as17830426

Performances

Mainpiece Title: Creusa In Delfo

Cast
Role: Laodamia Actor: Sga Gherardi

Dance: End of Act I Il Riposo del Campo, as17830424; End of Act II Le Tuteur Trompe, as17830426, but omitted: Slingsby

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: End of Act I Il Riposo del Campo, as17830424, but omitted: Mlle Theodore; End of Act II Le Tuteur Trompe, as17830503, but omitted: Mlle Theodore

Performances

Mainpiece Title: Il Trionfo Della Costanza

Cast
Role: Giacomina Actor: Sga Gherardi

Dance: End of Act I Il Riposo del Campo, as17830424; End of Act II La Bigueule, as17830313but omitted: Slingsby, Mme Simonet

Performances

Mainpiece Title: I Vecchi Burlati

Cast
Role: Droghetta Actor: Sga Gherardi

Dance: End of Act I Il Riposo del Campo, as17830506; End of Act II La Begueule, as17830510

Performances

Mainpiece Title: L'avaro

Cast
Role: Rosalinda Actor: Sga Gherardi

Dance: End of Act I La Begueule, as17830531; End of Act II Le Tuteur Trompe, as17830111, but omitted: Slingsby, Mlle Theodore

Performances

Mainpiece Title: Medonte

Cast
Role: Zelinda Actor: Sga Gherardi

Dance: End of Act I La Begueule, as17830531, but omitted Slingsby, and with a Minuet, as17830313End of Opera Le Tuteur Trompe, as17830614