SELECT * FROM london_stages WHERE eventid IN (38335, 38338, 38346, 38350, 38352, 38354, 38362, 38365, 38368, 38370, 38377, 38379, 38416, 38430, 38444, 38458, 38465, 38478, 38480, 38482, 38484, 38486, 38489, 38497, 38510, 38517, 38522, 38524, 38526, 38529, 38531, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38562, 38569, 38579, 38584, 38612, 38730, 38735, 38740, 38749, 38751, 38754, 38762, 38772, 38779, 38786, 38791, 38923, 38927, 38936, 38941, 38950, 38955, 38964, 38969, 38978, 38992, 38997, 39005, 39010, 39019, 39040, 39053, 39064, 39071, 39080, 39085, 39092, 39097, 39106, 39112, 39120, 39125, 39134, 39139, 39148, 39153, 39162, 39168, 39174, 39180, 39186, 39192, 39198, 39204, 39215, 39221, 39227, 39233, 39238, 39244, 39249, 39256, 39267, 39272, 39279, 39284, 39290, 39295, 39300, 39311, 39319, 39328, 39332, 39340, 39344, 39350, 39352, 39356, 39358, 39364, 39367, 39373, 39382, 39794, 39804, 39809, 39825, 39851, 39856, 39865, 39879, 39897, 39911, 39918, 39929, 39939, 40070, 40110, 40115, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40166, 40167, 40171, 40177, 40186, 40191, 40200, 40206, 40215, 40220, 40229, 40241, 40246, 40255, 40260, 40268, 40273, 40280, 40293, 40317, 40321, 40339, 40346, 40351, 40365, 40380, 40394, 40404, 40409, 40414, 40415, 40423, 40429, 40434, 40451, 40482, 40490, 40934, 40949, 40963, 40975, 40990, 41004, 41013, 41021, 41029, 41037, 41046, 41262, 41267, 41276, 41288, 41293, 41302, 41307, 41316, 41321, 41330, 41336, 41345, 41348, 41357, 41362, 41367, 41372, 41377, 41386, 41391, 41395, 41400, 41405, 41409, 41413, 41418, 41422, 41426, 41431, 41437, 41443, 41448, 41456, 41463, 41467, 41472, 41477, 41482, 41486, 41492, 41501, 41506, 41507, 41509, 41511, 41514, 41516, 41521, 41522, 41530, 41531, 41535, 41538, 41540, 41545, 41548, 41550, 41560, 41565, 41568, 41574, 41578, 41581, 41593, 41596, 41605, 41608, 41611, 41614, 41619, 41622) 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: The Fair Penitent

Afterpiece Title: The Irish Widow

Performances

Mainpiece Title: The Funeral; Or, Grief A-la-mode

Afterpiece Title: The Country Mad-Cap

Performances

Mainpiece Title: The Wonder

Afterpiece Title: St Patrick's Day

Dance: II: The Humours of the New@Market Races, as17760503; End: The Merry Sailors, as17760314

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Cross Purposes

Dance: III: Minuets and Cotillions-Dumay, Miss Armstrong, Merrifield, Miss Ross, Harris, Miss Mathews, Mr and Mrs Holloway; End: The Humours of the New@Market Races, as17760503 [and for Minuets and Cotillions, see17750526]

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Catherine and Petruchio

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: Astarto

Cast
Role: Sidonia Actor: Sga Luiggia Farnese
Role: Elisa Actor: Sga Anna Pozzi.

Dance: New Dances composed by Simonet and Vallouy.End I: a Grand Serious Ballet-Mons Simonet, Mme Simonet (their 1st appearance in England), Sg Zuchelli, Sga Zuchelli; End II: a new Pastoral Ballet Les Amans Heureux; ou, L'Aimable Vieillesse-Mons Vallouy, Mme Vallouy, Sg and Sga Zuchelli, Vallouy@le@cadet; End Opera: a new Ballet Demi-caracteres Les Amusemens Champetres-Mons and Mme Simonet, Sg and Sga Zuchelli

Performances

Mainpiece Title: Astarto

Cast
Role: Sidonia Actor: Sga Luiggia Farnese
Role: Elisa Actor: Sga Anna Pozzi.

Dance: End I: Les Amusemens Champetres, as17761102; End II: Les Amans Heureux, as17761102; End Opera: Grand Serious Ballet, as17761102

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amusemens Champetres, as17761102; End II: Grand Serious Ballet, as17761102; End Opera: a new Ballet, Demi-caractere, Les Chasseurs-Mons Vallouy, Mme Vallouy, Sg and Sga Zuchelli, Simonin Vallouy?@le@cadet

Performances

Mainpiece Title: Astarto

Cast
Role: Sidonia Actor: Sga Luiggia Farnese
Role: Elisa Actor: Sga Anna Pozzi.

Dance: End I: Les Amans Heureux, as17761102 End II: Grand Serious Ballet, as17761102; End Opera: Les Chasseurs, as17761112

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amans Heureux, as17761102 End II: Grand Serious Ballet, as17761102, but Mons _Simonet; in which a Passacaile-Mme Simonet; Chaconne-Mme Simonet; End Opera: Les Chasseurs, as17761112

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amans Heureux, as17761102; End II: Grand Serious Ballet, as17761130; End Opera: a new Comic Dance, composed by Zuchelli, La Force de l'Amour-Sg and Sga Zuchelli

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amans Heureux, as17761102, but Mme _Vallouy; End II: Serious Ballet, as17761130; End Opera: La Force de l'Amour, as17761207

Performances

Mainpiece Title: Piramo E Tisbe

Cast
Role: Tisbe Actor: Sga Prudom.

Dance: End of Overture: Les Amans Heureux, as17761210; End I: La Force de l'Amour, as17761207, but Vallouy@le@cadet; End Opera: +Serious Ballet, as17761130

Music: Before first Dance: Overture to Astarto by Giardini-

Performances

Mainpiece Title: Piramo E Tisbe

Cast
Role: Tisbe Actor: Sga Prudom.

Dance: End Overture: Les Amusemens Champetres-Mme Simonet, Zuchelli, Vallouy@le@cadet; End I: Les Amans Heureux-Vallouy, Mme Simonet, Zuchelli, Vallouy@le@cadet; End Opera: Grand Serious Ballet, as17761130, but Sga _Zuchelli, Vallouy@le@cadet; Passacaile, as17761130;Chaconne, as17761130

Music: As17761214

Performances

Mainpiece Title: Piramo E Tisbe

Cast
Role: Tisbe Actor: Sga Prudom.

Dance: End Overture: Les Amans Heureux, as17761217; End I: La Force de l'Amour, as17761214; End Opera: Grand Serious Ballet, as17761217

Music: As17761214

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Force de l'Amour, as17761214; End II: Grand Serious Ballet, as17761130; End Opera: Les Amans Heureux, as17761217, but Sga Zuchelli

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Force de l'Amour, as17761214; End II: Grand Serious Ballet, as17761217, Passacaile-_, Chaconne-_; End Opera: Les Amans Heureux, as17770104