SELECT * FROM london_stages WHERE eventid IN (1779, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39134, 39139, 39186, 39221, 39279, 39290, 39311, 39358, 40439, 40442, 40456, 40464, 40470, 40477, 40485, 41482, 41521, 41530, 41545, 41560, 41565, 41581, 41593, 41596, 41605, 43229, 43232, 43234, 43257, 43263, 43268, 43280, 43283, 43288, 43298, 43308, 43321, 43462, 43465, 43473, 43490, 43502, 43557, 43740, 43806, 44059, 44129, 44206, 44392, 44462, 44558, 44559, 44561, 44564, 44565, 44567, 44573, 44579, 44582, 44984, 44990, 44996, 45008, 45040, 45051, 45067, 45070, 45074, 45075, 45102, 45166, 45169, 45174, 45176, 45180, 45184, 45188, 45192, 45196, 45204, 45208, 45216, 45222, 45228, 45232, 45240, 45244, 45248, 45252, 45257, 45262, 45274, 45307, 45330, 45344, 45356, 45399, 45482, 45539, 45733, 45793, 45860, 45894, 46047, 46140, 46176, 46186, 46189, 46198, 46315, 46369, 46855, 46901, 46911, 46957, 47055, 47173, 47231, 47242, 47297, 47449, 47464, 47487, 47527, 47543, 47568, 47575, 47779, 47787, 47825, 48447, 48539, 48640, 48645, 48656, 48679, 48684, 48692, 48694, 48699, 48707, 48727, 48824, 48947, 49002, 49014, 49072, 49075, 49081, 49083, 49084, 49098, 49100, 49104, 49113, 49208, 49649, 50101, 50112, 50160, 50348, 50351, 50354, 50377, 50419, 50461, 50673, 50766, 50945, 50949, 50952, 50956, 50960, 50962, 50966, 51035, 51044, 51220, 51375, 51508, 51620, 51666) 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 Governante

Dance: End I: Les Paysans Voles, as17790515; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, in which the Quadrilles danced at the Pantheon last night (composed by Simonet)-Slingsby, Mme Simonet, Banti, Sga Tinti, Sg and Sga Zuchelli, Simonet, Mlle Baccelli

Performances

Mainpiece Title: La Governante

Dance: As17790615

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: End I: The Fortunate Escape, as17801216; End II: Grand Serious Ballet, as17810315Pas@Solo, as17810315Pas de Deux, as17810315Grand Chaconne, as17810315End Opera: Les Amans Surpris, as17801216

Song: Act II: the favourite song in Il Barone di Torre Forte-Sga Sestini

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: End I: Les Amans Surpris, as17801216

Ballet: End II: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: End I: Les Amans Surpris, as17801216

Ballet: End II: Ninette a la Cour (with Improvements). As17810327

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: As17810510 throughout

Ballet: Medee et Jason. As17810510

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: As17810324throughout.

Ballet: Ninette a la Cour. As17810324

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: As17810510 throughout

Ballet: Medee et Jason. As17810329

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: As17810501 throughout

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: As17810501

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Ballet: Medee et Jason. As17810329

Dance: As17810329throughout.

Performances

Mainpiece Title: La Fraschetana

Cast
Role: Donna Stella Actor: Sga Lorenzini

Dance: As17810501

Ballet: Medee et Jason. As17810501

Performances

Mainpiece Title: Robin Hood; Or, Sherwood Forest

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Harlequin Rambler

Dance: End of mainpiece a New Dance by Le Bccuf and Mlle Constance (from the King's Theatre in Paris; 1st appearance)

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Harlequin Rambler

Dance: As17840417

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Retaliation

Dance: As17840417

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: St

Dance: End of mainpiece The Rival Nymphs, as17840318athi

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Harlequin Rambler

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: The Commissary

Dance: End of mainpiece Rural Merriment by Jackson and Mrs Ratchford, to conclude with a Caledonian Reel by Eves and Mr and Mrs Ratchford

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Three Weeks after Marriage

Dance: End of mainpiece Adelaide de Brabant, as17840508

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Harlequin Rambler

Song: In afterpiece Old ThomasDay, as17840424

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: All the World's a Stage

Dance: As17840504

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Mrs Kemble

Afterpiece Title: Harlequin Rambler

Song: As17840514

Performances

Mainpiece Title: Robin Hood

Cast
Role: Stella Actor: Miss Wheeler

Afterpiece Title: St