SELECT * FROM london_stages WHERE eventid IN (48889, 48901, 48920, 48929, 48935, 48944, 48949, 48991, 49005, 49010, 49019, 49024, 49034, 49039, 49049, 49054, 49059, 49064, 49070, 49078, 49093, 49106, 49108, 49115, 49118, 49121, 49124, 49303, 49308, 49317, 49322, 49331, 49336, 49341, 49346, 49355, 49360, 49369, 49374, 49383, 49388, 49397, 49402, 49409, 49423, 49437, 49442, 49450, 49455, 49463, 49468, 49476, 49481, 49491, 49496, 49505, 49510, 49514, 49518, 49523, 49532, 49551, 49561, 49566, 49600, 49617, 49623, 49628, 49638, 49652, 49676, 49884, 49889, 49898, 49903, 49908, 49913, 49927, 49936, 49941, 49950, 49995, 50039, 50049, 51034, 51079, 51122, 51131, 51157, 51200, 51207, 51224, 51228, 51232, 51250, 51259, 51275, 51281, 51296, 51325, 51339, 51417) 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 Serva Padrona

Dance: As17940623throughout

Performances

Mainpiece Title: Semiramide

Dance: As17940531 throughout

Performances

Mainpiece Title: L'amore Contrastato; Or, La Molinarella

Dance: End I: a Divertisement-Mme Hilligsberg, others; End II: [a grand Heroic Pantomime Ballet composed by Onorati Giustino I Imperatore dei Romani [; or, Il Trionfo dell' Amore e dell' Amicizia-D'Egville, Gentili, Aumer, Mme Ferlotti [Rinaldi], Mlle Rosine, Mme DelCaro, Mme Hilligsberg

Performances

Mainpiece Title: L'amore Contrastato

Dance: As17941206

Performances

Mainpiece Title: L'amore Contrastato

Dance: As17941206

Performances

Mainpiece Title: L'amore Contrastato

Dance: As17941206

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: End I: Divertisement-[See17941206]; End II: a new Petit Ballet by Onorati L'Espiegle Soubrette[; ou, Le Tableau Mouvant-Gentili, Lahante, Aumer, Mlle Rosine, Mme DelCaro, Mme Hilligsberg

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: Zenobia In Palmira

Cast
Role: Publia Actor: Sga Colombati.

Dance: As17941220

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: End I: Divertisement, as17941220; End II: L'Espiegle Soubrette, as17941220, but Mme Derlotti

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: As17950110

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: As17941220

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: End I: Divertisement, as17941220; End II: a new Ballet by Onorati L'Amant Retrouve-Gentili, Lahante, Aumer, Mlle Rosine, Mme DelCaro, Mme Hilligsberg

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: End I: L'Espiegle Soubrette- see17941220; End II: L'Amant Retrouve- see17950120

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: End I: Divertisement, as17941220; End II: L'Espiegle Soubrette, as17950124

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950127

Performances

Mainpiece Title: Semiramide; Or, La Vendetta Di Nino

Cast
Role: Azema Actor: Sga Colombati.

Dance: As17950124

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: Dances- see17950124

Performances

Mainpiece Title: I Zingari In Fiera

Cast
Role: Stellidaura Actor: Sga Colombati
Role: Cecca Actor: Sga Pastorelli.

Dance: As17950124

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950127

Performances

Mainpiece Title: La Scola Dei Maritati

Cast
Role: Isabella Actor: Sga Colombati
Role: Cilia Actor: Sga Pastorelli.

Dance: As17950124

Performances

Mainpiece Title: Semiramide

Cast
Role: Azema Actor: Sga Colombati.

Dance: End I: Divertisement, as17941220; End II: New Divertisement by Onorati-