The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (31935, 31937, 31939, 31941, 31944, 31949, 31951, 31953, 32773, 32775, 32777, 32783, 32786, 32788, 32790, 32792, 32793, 32795, 32796, 32801, 32804, 33227, 33228, 33229, 33230, 33232, 33233, 33234, 33250, 33730, 33738, 33739, 33742, 33756, 33762, 33774, 33780, 33785, 33786, 33788, 34170, 34285, 34301, 34823, 34832, 34837, 34850, 34854, 34876, 35370, 35380, 35387, 35458, 35475, 35484, 35860, 35874, 35886, 35932, 35954, 35969, 36008, 36078, 36088, 36102, 36113, 36124, 36271, 36315, 36329, 36384, 36440, 36477, 36494, 36511, 36539, 36557, 36612, 36628, 36663, 36671, 36724, 37109, 37125, 37135, 37149, 37195, 37225, 37243, 37296, 37368, 37485, 37689, 37705, 37759, 37843, 37858, 37878, 38016, 38162, 38241, 38257, 38265, 38277, 38280, 38289, 38304, 38789, 38810, 38828, 38834, 38853, 38859, 38870, 38876, 38932, 39293, 39347, 39363, 39402, 39442, 39443, 39444, 39640, 39642, 39906, 39980, 40443, 40472, 40473, 40499, 40500, 40504, 40517, 40523, 40525, 40547, 40720, 41043, 41048, 41070, 41126, 41589, 41629, 41673, 43156, 43960, 43972, 43994, 44003, 44297, 44474, 45516, 45600, 45619, 45625, 45629, 45646, 45659, 45664, 45673, 45680, 45744, 45773, 46047, 46187, 46215, 46745, 46783, 47166, 47394, 47404, 47410, 47421, 47427, 47451, 47456, 47459, 47467, 47491, 47706, 47721, 47837, 48112, 48340, 48622, 49153, 49162, 49419, 49651, 49703, 50440, 51082, 51094, 51208, 51235, 51561) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: IV: The Provancalle, as17631014

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: TThe Italian Gardiners, as17631119

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: TThe Italian Gardiners, as17631119

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: III: The Provancalle, as17631014

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650708

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: I: Le Chasseur, as17650708 La Berge, as17650708 End: The Dutchman-Master Clinton, Miss Street

Performances

Mainpiece Title: The Lyar

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650719

Performances

Mainpiece Title: The Orators

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: I: The Dutchman; End: The English Sailor at Marseilles-Miss Street; the New Hornpipe-Master Clinton

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650809

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650708

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: I: The Carpenter, as17650708 End: The Dutchman, as17650719

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650821

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650719

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650828

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650719 but New Hornpipe-Mas. Clinton

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650909

Performances

Mainpiece Title: The Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17650909

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Entertainment: Dancing-

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715

Performances

Mainpiece Title: Commissary

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Foote

Dance: As17660715