SELECT * FROM london_stages WHERE eventid IN (37918, 37932, 37939, 38010, 38020, 38039, 38055, 38069, 38080, 38095, 38104, 38109, 38125, 38130, 38140, 38145, 38155, 38169, 38185, 38199, 38204, 38238, 38252, 38255, 38264, 38366, 38375, 38380, 38389, 38398, 38403, 38409, 38419, 38424, 38433, 38438, 38447, 38452, 38461, 38466, 38475, 38487, 38504, 38513, 38518, 38527, 38532, 38542, 38631, 38641, 38646, 38660, 38665, 38677, 38691, 38702, 38708, 38718, 38733, 38738, 38747, 38782, 38797, 38808, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39332, 39344, 39352, 39356, 39358, 39367, 39373, 40110, 40124, 40138, 40152, 40166, 40177, 40191, 40206, 40220, 40246, 40404, 40414, 40429, 40434, 40439, 40442, 40456, 40464, 40470, 40477, 40485, 41220, 41225, 41267, 41307, 41362, 41377, 41391, 41395, 41400, 41405, 41409, 41418, 41426, 41431, 41443, 41448, 41456, 41463, 41472, 41482, 41521, 41530, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 42054, 42180, 42188, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42412, 42420, 42425, 42435, 42442, 42452, 42463, 42472, 42481, 42486, 42501, 42506, 42510, 42530, 42541, 42549, 42551, 42554, 42561, 42607, 42620, 42668, 42689, 42712, 42801, 42804, 42807, 42813, 42838, 42840, 42842, 42844, 42846, 42847, 42848, 42850, 42852, 42853, 42870, 42880, 42889, 42898, 42906, 42920, 42928, 42942, 42952, 42968, 43003, 43069, 43095, 43124, 43167, 43277, 43322, 43330, 43333, 43337, 43347, 43350, 43352, 43355, 43395, 43399, 43400, 43405, 43415, 43929, 43938, 43942, 43944, 43948, 43951, 43967, 43970, 43975, 43977, 43979, 43981, 43985, 43986, 43988, 43991, 43992, 44007, 44009, 44013, 44015, 44021, 44219, 44228, 44231, 44240, 44245, 44254, 44307, 44312, 44316, 44320, 44329, 44333, 44338, 44351, 44375, 44385, 44390, 44400, 44415, 44430, 44440, 44455, 44460, 44472, 44476, 44478, 44480, 44481, 44482, 44483, 44491, 44500, 44503, 44504, 44508, 44511, 44517, 44521, 44526, 44527, 44532, 44533, 44535, 44539, 44547, 44556, 44557, 44558, 44559, 44560, 44561, 44563, 44564, 44565, 44567, 44573, 44576, 44579, 44580, 44581, 44582, 44585, 44586, 44744, 44753, 44758, 44767, 44772, 44781, 44792, 44820, 44825, 44837, 44858, 44864, 44937, 44942, 44947, 44953, 44962, 44967, 44976, 44981, 44984, 44987, 44990, 44993, 44996, 44999, 45005, 45008, 45014, 45033, 45040, 45042, 45046, 45051, 45052, 45058, 45059, 45061, 45066, 45067, 45070, 45072, 45074, 45075, 45079, 45080, 45081, 45082, 45092, 45094, 45095, 45097, 45099, 45102, 45116, 45125, 45126, 45132, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45357, 45362, 45366, 45370, 45382, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 45655, 45656, 45657, 45658, 45660, 45677, 46008, 46021, 46071, 46076, 46086, 46091, 46096, 46101, 46119, 46131, 46434, 46439, 46444, 46453, 46458, 46467, 46472, 46479, 46484, 46493, 46498, 46507, 46512, 46520, 46525, 46567, 46689, 46703, 47205, 47215, 47221, 47245, 47262, 47271, 47274, 47280, 47286, 47292, 47298, 47305, 47308, 47310, 47317, 47324, 47332, 47336, 47343, 47347, 47354, 47358, 47364) 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 Barone Di Torre Forte

Cast
Role: Lucinda Actor: Sga Sestini.

Dance: As17810526 throughout

Ballet: Ninette a la Cour. As17810526

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17810501 throughout

Ballet: Medee et Jason. As17810501

Performances

Dance: Incident to the piece: Ballets by Vestris Sen.-Vestris Sen., Vestris Jun., Simonet, Slingsby, Traffieri, Zuchelli, Henry, Mme Simonet, Mlle Baccelli, Sga Crespi, Sga Zuchelli, Miss Stageldoir, Miss Armstrong

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17810501

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Ballet: Medee et Jason. As17810329

Dance: As17810329throughout.

Performances

Dance: As17810605

Music: End Part I: a concerto on the hautboy-LeBrun; End Part II: a concerto on the violin-Cramer

Performances

Dance: As17810605

Music: End Part II: a concerto on the hautboy-LeBrun

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Violante Actor: Sga Sestini.

Dance: As17810501

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: Il Bacio

Cast
Role: Zuccherina Actor: Sga Sestini.

Dance: As17820402 throughout

Performances

Mainpiece Title: Il Bacio

Cast
Role: Zuccherina Actor: Sga Sestini.

Dance: As17820605throughout

Performances

Mainpiece Title: Il Bacio

Cast
Role: Zuccherina Actor: Sga Sestini.

Dance: End of Act I New Dance, as17820603 End of Opera Apelles and Campaspe, as17820605

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: All the Worlds a Stage

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Country Mad cap

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: Retaliation

Dance: As17821009

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Author

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Choice of Harlequin

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Choice of Harlequin

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Minor

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: St

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Deuce is in Him

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Country Mad Cap

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Sga Sestini.

Afterpiece Title: The Country Wife