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 (1136, 7437, 14334, 19023, 19025, 19028, 19030, 19032, 19034, 19038, 19048, 19073, 19160, 33922, 41945, 42299, 42916, 42918, 42922, 42924, 42930, 42932, 42934, 42936, 42940, 42944, 42946, 42948, 42956, 42958, 42960, 42965, 42970, 42977, 42979, 42982, 42986, 42988, 42997, 42999, 43001, 43006, 43072, 43077, 43101, 43120, 43141, 43158, 43172, 43180, 43191, 43204, 43217, 43229, 43232, 43234, 43255, 43257, 43263, 43268, 43280, 43283, 43288, 43298, 43308, 43321, 43325, 43441, 43462, 43465, 43470, 43473, 43478, 43490, 43500, 43502, 43510, 43521, 43529, 43542, 43545, 43546, 43550, 43554, 43557, 43558, 43559, 43563, 43565, 43571, 43572, 43582, 43607, 43617, 43630, 43702, 43712, 43717, 43722, 43740, 43746, 43755, 43779, 43792, 43806, 43844, 43863, 43871, 43886, 43900, 43976, 44058, 44059, 44067, 44076, 44089, 44117, 44129, 44131, 44145, 44206, 44263, 44358, 44392, 44449, 44457, 44462, 44467, 44516, 44638, 44654, 44789, 44799, 44813, 44831, 44844, 44939, 44959, 45001, 45018, 45035, 45135, 45158, 45166, 45169, 45174, 45176, 45180, 45184, 45188, 45192, 45196, 45204, 45208, 45216, 45219, 45222, 45228, 45232, 45234, 45240, 45244, 45248, 45252, 45257, 45262, 45271, 45274, 45280, 45307, 45330, 45338, 45344, 45356, 45399, 45412, 45433, 45444, 45454, 45482, 45490, 45497, 45539, 45552, 45557, 45579, 45698, 45719, 45727, 45733, 45745, 45783, 45793, 45801, 45860, 45888, 45894, 45909, 45923, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46040, 46047, 46140, 46171, 46176, 46186, 46189, 46198, 46275, 46289, 46315, 46329, 46347, 46367, 46369, 46387, 46490, 46624, 46647, 46678, 46700, 46711, 46729, 46836, 46838, 46855, 46901, 46903, 46911, 46957, 46961, 47055, 47068, 47173, 47179, 47212, 47231, 47238, 47242, 47273, 47297, 47304, 47449, 47464, 47472, 47487, 47509, 47527, 47529, 47543, 47568, 47575, 47647, 47696, 47749, 47779, 47787, 47823, 47825, 47887, 48002, 48026, 48105, 48313, 48315, 48317, 48341, 48396, 48447, 48539, 48549, 48605, 48642, 48645, 48664, 48707, 48727, 48819, 48860, 48872, 48933, 48947, 48959, 48988, 49002, 49009, 49014, 49028, 49038, 49041, 49053, 49056, 49066, 49072, 49077, 49081, 49083, 49100, 49152, 49173, 49174, 49191, 49208, 49422, 49449, 49452, 49454, 49458, 49462, 49465, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49577, 49578, 49580, 49589, 49592, 49602, 49607, 49612, 49635, 49640, 49646, 49649, 49650, 49655, 49662, 49667, 49759, 49963, 50051, 50063, 50066, 50069, 50306, 50308, 50310, 50345, 50348, 50461, 50791, 50794, 50881, 50888, 50896, 50897, 50921, 50989, 51001, 51003, 51005, 51007, 51009, 51014, 51016, 51018, 51021, 51027, 51029, 51033, 51036, 51041, 51045, 51078, 51087, 51138, 51150, 51154, 51218, 51241, 51258, 51261, 51271, 51317, 51333, 51423, 51437, 51447, 51453, 51457, 51475, 51478, 51501, 51672, 51675, 51677, 51678, 51680, 51682, 51683, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51709, 51712, 51715, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51793, 51838, 51840, 51842, 51846, 51854, 51883, 51884, 51890, 51926, 52010, 52040, 52043, 52066, 52070, 52118, 52130, 52196, 52284, 52473, 52582, 52598) GROUP BY eventid ORDER BY eventdate ASC OPTION

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Song: As17831108, but omitted: Doyle

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Song: As17831121

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Song: As17831006, but Johnstone in place of Doyle

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Count Of Narbonne

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Shipwreck

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Dance: As17831119

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: Which Is The Man

Cast
Role: Fitzherbert Actor: Henderson

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Performances

Mainpiece Title: Isabella; Or, The Fatal Marriage

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Cast
Role: Fitzroy Actor: Bannister

Song: In Act III of mainpiece an Epithalamium by Mrs Kennedy and Mrs Martyr. The Music composed by Shield