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: La Frascatana

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: 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: 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: La Scola Dei Maritati

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

Dance: End I: New Divertisement, as17950228; End II: L'Amant Retrouve, as17950124

Performances

Mainpiece Title: La Scola Dei Maritati

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

Dance: As17950303

Performances

Mainpiece Title: La Scola Dei Maritati

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

Dance: End I: New Divertisement, as17950228; End II: Paul et Virginie- see17950326Mme Hilligsberg will perform in men's Clothes

Performances

Mainpiece Title: Il Conte Ridicolo

Cast
Role: Belisa Actor: Sga Pastorelli.

Dance: As17950411

Performances

Mainpiece Title: Il Conte Ridicolo

Cast
Role: Belisa Actor: Sga Pastorelli.

Dance: As17950411

Performances

Mainpiece Title: La Scola Dei Maritati

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

Dance: As17950411

Performances

Mainpiece Title: La Scola Dei Maritati

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

Dance: As17950411

Performances

Mainpiece Title: Alceste; Or, Il Tronfo Dell' Amor Conjugale

Cast
Role: Ismene Actor: Sga Pastorelli.

Dance: End Opera: Paul et Virginie, as17950411o other ballet listed]

Performances

Mainpiece Title: Alceste

Cast
Role: Ismene Actor: Sga Pastorelli.

Dance: As17950430

Performances

Mainpiece Title: Alceste

Cast
Role: Ismene Actor: Sga Pastorelli.

Dance: As17950430