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 (2272, 2417, 3694, 3719, 3792, 4168, 4231, 4274, 4446, 4704, 5185, 5264, 5289, 5971, 6476, 6540, 6688, 6930, 6967, 7113, 7217, 7329, 7462, 7570, 7870, 7964, 8042, 8354, 8535, 8584, 8645, 8750, 8849, 8959, 9070, 9212, 9271, 9588, 9750, 10495, 10537, 10609, 10652, 10701, 10903, 10994, 11113, 11177, 11373, 11472, 11690, 11806, 11907, 12099, 12344, 12636, 12981, 13032, 13035, 13040, 13043, 13047, 13052, 13056, 13060, 13063, 13066, 13167, 13176, 13245, 13326, 13416, 13489, 13507, 13533, 13554, 13599, 13642, 13752, 13847, 14006, 14059, 14087, 14110, 14154, 14177, 14181, 14217, 14288, 14353, 14366, 14445, 14533, 14780, 14847, 14857, 14957, 15089, 15100, 15123, 15235, 15315, 15401, 15495, 15548, 15620, 15740, 15826, 15837, 15869, 16370, 16567, 16733, 16926, 16998, 17133, 17173, 17208, 17210, 17253, 17411, 17570, 17591, 17773, 17791, 18029, 18208, 18266, 18609, 18767, 18811, 18969, 19080, 19179, 19259, 19365, 19476, 19525, 19546, 19670, 19748, 19761, 19879, 20005, 20206, 20238, 20258, 20261, 20265, 20268, 20271, 20274, 20277, 20280, 20284, 20287, 20305, 20337, 20351, 20382, 20426, 20577, 20715, 20823, 20977, 20980, 20986, 21007, 21017, 21027, 21058, 21145, 21364, 21430, 21503, 21702, 21706, 21714, 21724, 21874, 21892, 21917, 21960, 22000, 22058, 22249, 22302, 22380, 22436, 22548, 22658, 22784, 22823, 22885, 22888, 22973, 23014, 23168, 23261, 23268, 23271, 23277, 23353, 23512, 23652, 23683, 23700, 23763, 23916, 23960, 24063, 24184, 24645, 24689, 24736, 24755, 24788, 24971, 24974, 25017, 25020, 25052, 25056, 25286, 25296, 25365, 25428, 25527, 25545, 25679, 26078, 26577, 26715, 27105, 27229, 27253, 27304, 27403, 27509, 27630, 27689, 27751, 27764, 27883, 27928, 27979, 28048, 28110, 28173, 28244, 28323, 28465, 29471, 29575, 29727, 31172, 31200, 31251, 31384, 31448, 31690, 31758, 31853, 32102, 33012, 35829, 35854, 36418, 36475, 38739, 40376, 41891, 42419, 42421, 42431, 42505, 43767, 44035, 44165, 44178, 44434, 45448, 45518, 45546, 45578, 45603, 45697, 45721, 45741, 45790, 45830, 45873, 45931, 45964, 46004, 46072, 46108, 46132, 46219, 46222, 46247, 46256, 46279, 46288, 46317, 46354, 46503, 46565, 46843, 46948, 47909, 48616, 48776, 48857, 49629, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51845, 52331, 52335, 52338, 52343, 52350, 52413, 52497) 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 Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Standard Actor: Powel

Performances

Mainpiece Title: Sir Harry Wildair

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Afterpiece Title: The Stage Coach

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Afterpiece Title: The School Boy

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Performances

Mainpiece Title: The Humours Of The Army

Cast
Role: Ensign Standard Actor: Ryans

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Afterpiece Title: Hob

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Song: As17151028

Dance: Prince, Mrs Santlow, Mrs Bicknell, Miss Younger

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Song: As17170102

Dance: As17161103

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Song:

Dance:

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Dance: As17180318

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Dance: As at Hampton Court yesterday Shaw, Mrs Santlow, Mrs Bicknell, Miss Lindar

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Dance: Mrs Booth