SELECT * FROM london_stages WHERE eventid IN (48795, 48800, 48809, 48814, 48823, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48889, 48894, 48901, 48906, 48915, 48958, 48963, 48972, 49075, 49084, 49098, 49104, 49113, 49303, 49308, 49317, 49322, 49369, 49374, 49383, 49388, 49397, 49402, 49409, 49442, 49450, 49455, 49468, 49496, 49523, 49537, 49546, 49561, 49566, 49571, 49576, 49581, 49590, 49595, 49600, 49605, 49610, 49623, 49628, 49633, 49638, 49647, 49652, 49661, 49673, 49676, 49681, 49689, 49697, 49884, 49889, 49898, 49903, 49908, 49913, 49955, 49964, 49969, 49976, 49981, 49990, 50007, 50014, 50020, 50027, 50049, 50090, 50109, 50114, 50119, 50154, 50227, 50233, 50244, 50249, 50258, 50450, 50459, 50464, 50473, 50478, 50485, 50490, 50499, 50504, 50513, 50612, 50624, 50629, 50691, 50798, 50803, 50810, 50822, 50852, 50863, 50868, 51010, 51019, 51025, 51055, 51062, 51122, 51131, 51157, 51176, 51200, 51228, 51232, 51245, 51250, 51259, 51264, 51275, 51281, 51286, 51296, 51305, 51315, 51320, 51325, 51334, 51339, 51346, 51352, 51389, 51393, 51398, 51409, 51414, 51417, 51422, 51429, 51594, 51599, 51622, 51632, 51646, 51660, 51674, 51679, 51689, 51695, 51726, 51738, 51744, 51751, 51756, 51763, 51768, 51775, 51795, 51809, 51829, 51839, 51852, 51857, 51862, 51979, 51995, 52006, 52014, 52356, 52368, 52387) 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: An Act Of La Sposa In Equivoco

Cast
Role: Lesbina Actor: Sga Angelelli
Role: Ernesta Actor: Sga Colombati
Role: Lisetta Actor: Sga Pastorelli.

Afterpiece Title: Act II of Semiramide

Dance: End: Le Triomphe de Themis, as17971226; End 2nd piece: an entire new Anacreontic Ballet, composed by Gallet, La Vengeance de l'Amour-; Pas de Quatre of Panurge-Didelot, Laborie, Mme Hilligsberg, Mme Rose

Performances

Mainpiece Title: An Act Of La Sposa In Equivoco

Cast
Role: Lesbina Actor: Sga Angelelli
Role: Ernesta Actor: Sga Colombati
Role: Lisetta Actor: Sga Pastorelli.

Afterpiece Title: Act II of Semiramide

Dance: End 1st piece: Le Triomphe de Themis, as17980322End 2nd piece: La Vengeance de l'Amour, as17980322 Pas de Quatre of Panurge-_, and names of performers%

Performances

Mainpiece Title: Cinna

Cast
Role: Livia Actor: Sga Pastorelli.

Dance: End I: Le Triomphe de Themis, as17971226; End Opera: Ariadne et Bacchus, as17971216

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Giannina Actor: Sga Angelelli
Role: Costanza Actor: Sga Colombati
Role: Rosina Actor: Sga Pastorelli.

Dance: As17980331

Performances

Mainpiece Title: Il Consiglio Imprudente

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Giannina Actor: Sga Angelelli
Role: Costanza Actor: Sga Colombati
Role: Rosina Actor: Sga Pastorelli.

Dance: As17980313

Performances

Mainpiece Title: Cinna

Cast
Role: Livia Actor: Sga Pastorelli.

Dance: As17980306

Performances

Mainpiece Title: Il Matrimonio Segreto

Cast
Role: Carolina Actor: Sga Angelelli
Role: Elisetta Actor: Sga Pastorelli
Role: Fidalma Actor: Sga Colombati.

Dance: End I: A New Divertisement, as17980419; End Opera: La Vengeance de l'Amour-; Pas de Quatre de Panurge-

Performances

Mainpiece Title: Il Matrimonio Segreto

Cast
Role: Carolina Actor: Sga Angelelli
Role: Elisetta Actor: Sga Pastorelli
Role: Fidalma Actor: Sga Colombati.

Dance: As17980306

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: End I: Peggy's Love composed by Didelot [with music by Bossi]-; Pas de Trois-Laborie, Mme Laborie, Mme Hilligsberg; End Opera: La Vengeance de l'Amour, as17980421

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Giannina Actor: Sga Angelelli
Role: Costanza Actor: Sga Colombati
Role: Rosina Actor: Sga Pastorelli.

Dance: End 1st piece: Peggy's Love, as17980428; End 2nd piece: La Vengeance de l'Amour, as17980324

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: As17980306

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: End I: Le Triomphe de Themis, as17971226; Pas Russe-Laborie, Mme Hilligsberg; End Opera: a new Pastoral Ballet in 4 acts, composed by S. Gallet, Elisa; ou, Le Triomphe de la Nature-Laborie, Mme Hilligsberg, Didelot, Mme Rose, Miss Hilligsberg, Mme Laborie, Gourlier, Master Laborie

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: As17980501

Performances

Mainpiece Title: An Act Of Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Giannina Actor: Sga Angelelli
Role: Costanza Actor: Sga Colombati
Role: Rosina Actor: Sga Pastorelli.

Dance: End: Les Rivaux Genereux, as17980306End 2nd piece: Elisa- [see17980510]

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: End I: Peggy's Love, as17980428; End Opera: Elisa, as17980515

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Giannina Actor: Sga Angelelli
Role: Costanza Actor: Sga Colombati
Role: Rosina Actor: Sga Pastorelli.

Dance: As17980501

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: As17980519

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: As17980515

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: End I: Les Rivaux Genereux, as17980306

Ballet: End Opera: Le Deserteur. As17980614

Performances

Mainpiece Title: Antigona

Cast
Role: Ismene Actor: Sga Pastorelli.

Dance: As17980614

Ballet: Le Deserteur. As17980614

Performances

Mainpiece Title: Antigona

Cast
Role: Ismene Actor: Sga Pastorelli.

Dance: As17980616

Ballet: Le Deserteur. As17980616

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: End I: La Vengeance de l'Amour, as17980421

Ballet: End Opera: Le Deserteur. As17980614

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: As17980703

Ballet: Le Deserteur. As17980703

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Giannina Actor: Sga Angelelli
Role: Costanza Actor: Sga Colombati
Role: Rosina Actor: Sga Pastorelli.

Dance: End 1st piece: Peggy's Love, as17980428; End 2nd piece: Ariadne et Bacchus, as17971216

Performances

Mainpiece Title: Elfrida

Cast
Role: Evelina Actor: Sga Pastorelli.

Dance: As17980710