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 (12887, 12892, 12895, 12898, 12901, 12904, 12907, 12910, 12913, 12919, 12923, 12927, 12931, 12934, 12937, 12940, 12944, 12947, 12951, 12954, 12961, 12964, 12967, 12972, 12976, 12980, 12983, 12986, 12992, 12998, 13002, 13005, 13008, 13012, 13016, 13018, 13022, 13025, 13029, 13032, 13035, 13040, 13043, 13047, 13052, 13056, 13060, 13063, 13066, 13070, 13073, 13079, 13083, 13087, 13091, 13094, 13098, 13105, 13109, 13113, 13116, 13119, 13123, 13127, 13134, 13137, 13141, 13144, 13148, 13152, 13156, 13160, 13164, 13167, 13171, 13175, 13181, 13185, 13189, 13192, 13198, 13202, 13225, 13233, 13238, 13242, 13245, 13256, 13260, 13263, 13268, 13272, 13277, 13281, 13286, 13289, 13292, 13296, 13301, 13304, 13309, 13312, 13315, 13318, 13322, 13326, 13330, 13339, 13343, 13351, 13355, 13360, 13363, 13367, 13372, 13377, 13412, 13416, 13421, 13426, 13431, 13443, 13446, 13460, 13462, 13466, 13468, 13474, 13476, 13480, 13482, 13484, 13486, 13489, 13492, 13493, 13495, 13498, 13501, 13503, 13507, 13509, 13514, 13515, 13517, 13519, 13522, 13524, 13528, 13529, 13530, 13532, 13533, 13537, 13544, 13550, 13553, 13554, 13556, 13559, 13562, 13566, 13568, 13579, 13582, 13586, 13589, 13592, 13596, 13599, 13603, 13606, 13608, 13610, 13625, 13627, 13632, 13635, 13638, 13642, 13645, 13647, 13651, 13655, 13658, 13661, 13664, 13668, 13681, 13684, 13692, 13696, 13715, 13719, 13723, 13726, 13734, 13745, 13748, 13752, 13756, 13760, 13768, 13771, 13779, 13783, 13787, 13791, 13794, 13798, 13802, 13806, 13810, 13813, 13817, 13820, 13824, 13828, 13832, 13835, 13839, 13843, 13847, 13853, 13857, 13861, 13864, 13871, 13875, 13879, 13882, 13895, 13907, 13911, 13915, 13921, 13925, 13929, 13959, 13962, 13966, 13969, 13973, 13977, 13999, 14003, 14006, 14010, 14013, 14017, 14028, 14032, 14035, 14039, 14045, 14053, 14059, 14065, 14069, 14084, 14088, 14103, 14110, 14114, 14121, 14131, 14137, 14142, 14146, 14154, 14158, 14170, 14189, 14201, 14208, 14210, 14214, 14218, 14221, 14223, 14235, 14255, 14258, 14263, 14270, 14304, 14305, 14307, 14308, 14309, 14312, 14314, 14315, 14317, 14318, 14320, 14321, 14323, 14324, 14363, 14366, 14369, 14375, 14379, 14383, 14386, 14394, 14399, 14403, 14415, 14418, 14422, 14428, 14431, 14441, 14445, 14451, 14454, 14458, 14485, 14498, 14505, 14524, 14530, 14533, 14549, 14552, 14615, 14618, 14625, 14628, 14634, 14637, 14640, 14644, 14654, 14668, 14679, 14683, 14718, 14726, 14738, 14773, 14813, 14828, 14835, 14841, 14857, 14873, 14883, 14889, 14894, 14921, 14934, 14942, 14957, 15045, 15047, 15053, 15059, 15072, 15085, 15087, 15089, 15094, 15104, 15106, 15123, 15126, 15133, 15137, 15158, 15163, 15189, 15197, 15200, 15235, 15242, 15247, 15267, 15312, 15315, 15332, 15335, 15344, 15347, 15350, 15353, 15357, 15360, 15366, 15373, 15392, 15396, 15401, 15415, 15421, 15424, 15448, 15457, 15497, 15516, 15548, 15553, 15565, 15588, 15603, 15616, 15620, 15636, 15735, 15737, 15740, 15743, 15754, 15758, 15760, 15772, 15784, 15799, 15811, 15816, 15869, 15968, 16006, 24067, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33489, 33491, 33494, 33496, 33501, 33510, 33517, 33524, 33529, 33572, 33626, 33630, 33652, 33676, 33794, 33796, 33798, 33804, 33806, 33814, 33819, 33821, 33823, 33825, 33829, 33831, 33833, 33839, 33841, 33843, 33849, 33875, 33882, 33889, 33896, 33903, 33905, 33907, 33917, 33919, 33921, 33924, 33929, 33933, 34000, 34069, 34072, 34146, 34175, 34182, 34199, 34224, 34237, 34317, 34350, 34355, 34376, 34395, 34404, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34557, 34714, 34905, 34975, 34998, 35042, 35066, 35068, 35106, 35113, 35120, 35132, 35138, 35240, 35250, 35281, 35286, 35302, 35332, 35340, 35354, 35375, 35535, 35602, 35617, 35626, 35818, 35860, 35966, 35969, 35975, 35979, 35986, 35988, 35993, 35996, 36001, 36006, 36008, 36012, 36014, 36019, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36047, 36049, 36051, 36053, 36055, 36059, 36062, 36066, 36068, 36072, 36075, 36078, 36081, 36088, 36091, 36093, 36097, 36099, 36100, 36102, 36103, 36104, 36107, 36108, 36131, 36359, 36429, 36440, 36671, 36710, 36714, 36750, 36756, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 37044, 37071, 37216, 37253, 37531, 38873, 38883, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38951, 38953, 38956, 38960, 38970, 38974, 38982, 38986, 38988, 38990, 38993, 38995, 38998, 39000, 39006, 39011, 39017, 39020, 39022, 39024, 39026, 39028, 39030, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39062, 39065, 39067, 39069, 39072, 39074, 39076, 39078, 39081, 39083, 39086, 39088, 39095, 39098, 39100, 39102, 39104, 39109, 39114, 39118, 39121, 39123, 39132, 39137, 39142, 39149, 39156, 39163, 39177, 39181, 39190, 39196, 39199, 39202, 39208, 39210, 39219, 39225, 39228, 39230, 39234, 39242, 39250, 39262, 39268, 39270, 39273, 39296, 39308, 39322, 39333, 39335, 39343, 39445, 39455, 39480, 39486, 39511, 39513, 39518, 39520, 39539, 39546, 39560, 39564, 39567, 39574, 39578, 39581, 39583, 39586, 39590, 39595, 39597, 39600, 39605, 39609, 39611, 39621, 39623, 39643, 39646, 39648, 39653, 39655, 39660, 39666, 39670, 39675, 39678, 39680, 39682, 39687, 39690, 39699, 39704, 39707, 39718, 39721, 39726, 39735, 39740, 39743, 39750, 39754, 39781, 39805, 39807, 39812, 39818, 39828, 39832, 39840, 39843, 39849, 39863, 39866, 39871, 39877, 39894, 40015, 40021, 40023, 40025, 40027, 40035, 40037, 40039, 40047, 40056, 40070, 40072, 40078, 40098, 40115, 40125, 40131, 40150, 40153, 40157, 40167, 40180, 40182, 40187, 40196, 40198, 40201, 40204, 40207, 40211, 40213, 40216, 40218, 40223, 40225, 40227, 40230, 40232, 40239, 40275, 40284, 40319, 40322, 40330, 40334, 40339, 40349, 40354, 40366, 40368, 40371, 40388, 40407, 40410, 40415, 40427, 40430, 40460, 40463, 40563, 40565, 40567, 40571, 40573, 40575, 40577, 40579, 40588, 40592, 40594, 40595, 40597, 40599, 40601, 40603, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40629, 40631, 40633, 40635, 40637, 40639, 40641, 40643, 40645, 40648, 40650, 40652, 40654, 40657, 40659, 40662, 40664, 40666, 40668, 40671, 40673, 40676, 40678, 40680, 40687, 40692, 40694, 40699, 40702, 40705, 40710, 40716, 40718, 40722, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40745, 40747, 40749, 40751, 40754, 40760, 40762, 40764, 40769, 40776, 40780, 40783, 40786, 40794, 40796, 40806, 40812, 40815, 40818, 40820, 40827, 40830, 40832, 40838, 40841, 40847, 40851, 40858, 40861, 40869, 40875, 40879, 40881, 40883, 40885, 40890, 40899, 40901, 40906, 40940, 40957, 40959, 40964, 40966, 40969, 40973, 40982, 40993, 41008, 41114, 41116, 41118, 41121, 41124, 41128, 41129, 41131, 41136, 41138, 41140, 41142, 41144, 41146, 41147, 41155, 41159, 41161, 41165, 41168, 41175, 41178, 41189, 41195, 41208, 41214, 41218, 41223, 41230, 41232, 41237, 41242, 41244, 41246, 41256, 41260, 41263, 41274, 41280, 41282, 41286, 41296, 41300, 41303, 41308, 41322, 41331, 41337, 41346, 41349, 41351, 41353, 41355, 41358, 41360, 41363, 41365, 41368, 41370, 41373, 41375, 41378, 41380, 41382, 41396, 41398, 41401, 41403, 41407, 41411, 41414, 41416, 41427, 41429, 41440, 41446, 41450, 41454, 41460, 41465, 41473, 41479, 41484, 41488, 41495, 41497, 41499, 41524, 41526, 41533, 41541, 41543, 41546, 41551, 41556, 41561, 41563, 41568, 41570, 41575, 41577, 41687, 41692, 41694, 41700, 41702, 41704, 41710, 41712, 41713, 41715, 41717, 41720, 41722, 41724, 41726, 41728, 41730, 41732, 41734, 41736, 41738, 41740, 41742, 41758, 41762, 41764, 41773, 41780, 41785, 41789, 41799, 41803, 41808, 41820, 41822, 41843, 41850, 41852, 41860, 41862, 41865, 41879, 41917, 41922, 41930, 41938, 41940, 41949, 41960, 41962, 41973, 41986, 42000, 42002, 42006, 42013, 42034, 42039, 42041, 42055, 42057, 42060, 42070, 42072, 42080, 42085, 42087, 42092, 42102, 42105, 42107, 42110, 42126, 42128, 42131, 42133, 42141, 42148, 42153, 42162, 42164, 42273, 42275, 42277, 42288, 42292, 42296, 42309, 42315, 42327, 42331, 42333, 42335, 42344, 42347, 42349, 42353, 42358, 42366, 42368, 42371, 42373, 42376, 42378, 42380, 42382, 42388, 42393, 42395, 42397, 42407, 42409, 42416, 42424, 42436, 42441, 42444, 42447, 42449, 42451, 42454, 42457, 42460, 42462, 42464, 42471, 42474, 42478, 42483, 42485, 42488, 42493, 42495, 42498, 42500, 42503, 42507, 42512, 42517, 42519, 42521, 42524, 42526, 42529, 42531, 42533, 42540, 42543, 42548, 42560, 42563, 42565, 42568, 42570, 42573, 42575, 42580, 42583, 42589, 42596, 42598, 42602, 42609, 42615, 42619, 42622, 42628, 42635, 42637, 42645, 42669, 42671, 42693, 42708, 42713, 42725, 42732, 42740, 44827, 44928, 44935, 44938, 44970, 44972, 44979, 44988, 44997, 45000, 45019, 45024, 45144, 45151, 45155, 45157, 45163, 45168, 45173, 45185, 45189, 45221, 45239, 45243, 45247, 45254, 45259, 45263, 45268, 45270, 45273, 45279, 45292, 45311, 45318, 45332, 45334, 45337, 45346, 45348, 45355, 45358, 45360, 45364, 45368, 45373, 45380, 45385, 45389, 45396, 45398, 45402, 45406, 45409, 45415, 45419, 45424, 45439, 45443, 45448, 45453, 45471, 45499, 45508, 45518, 45536, 45543, 45556, 45581, 45592, 45594, 45600, 45616, 45626, 45628, 45631, 45635, 45636, 45638, 45639, 45640, 45647, 45648, 45653, 45654, 45655, 45656, 45657, 45658, 45660, 45661, 45662, 45664, 45666, 45668, 45670, 45671, 45672, 45673, 45674, 45675, 45676, 45677, 45678, 45681, 45682, 45685, 45686, 45687, 45718, 45723, 45730, 45736, 45760, 45774, 45776, 45804, 45822, 45845, 45859, 45870, 45898, 45927, 45938, 46087) 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 Fate Of Sparta

Afterpiece Title: The Deserter

Cast
Role: Jenny Actor: Miss Collett

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Afterpiece Title: Selima and Azor

Cast
Role: Lesbia Actor: Miss Collett

Performances

Mainpiece Title: The Fate Of Sparta

Afterpiece Title: Comus

Performances

Mainpiece Title: The Fate Of Sparta

Afterpiece Title: Selima and Azor

Cast
Role: Lesbia Actor: Miss Collett

Performances

Mainpiece Title: The Fate Of Sparta

Afterpiece Title: The Deserter

Cast
Role: Jenny Actor: Miss Collett

Performances

Mainpiece Title: The Fate Of Sparta

Afterpiece Title: Selima and Azor

Cast
Role: Lesbia Actor: Miss Collett

Performances

Mainpiece Title: Love In A Village

Cast
Role: Margery Actor: Miss Collett

Afterpiece Title: Harlequin Junior

Dance: End II: The Conjugal Frolick-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

Mainpiece Title: Love In The East; Or, Adventures Of Twelve Hours

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: All the World's a Stage

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: The Humourist

Performances

Mainpiece Title: King Lear

Afterpiece Title: Selima and Azor

Cast
Role: Lesbia Actor: Miss Collett

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: Harlequin Junior

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: The Irish Widow

Dance: End I afterpiece: The Irish Fair-Mills, Miss J. Stageldoir

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Deserter

Cast
Role: Jenny Actor: Miss Collett

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: The Minor

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: Harlequin Junior

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: Bon Ton

Performances

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

Afterpiece Title: Selima and Azor

Cast
Role: Lesbia Actor: Miss Collett

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: Comus

Performances

Mainpiece Title: Love In The East

Cast
Role: Lucy Actor: Miss Collett

Afterpiece Title: The Critic

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Deserter

Cast
Role: Jenny Actor: Miss Collett

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Comus

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Lauretta Actor: Miss Collett.

Performances

Mainpiece Title: The Heiress

Afterpiece Title: Comus

Dance: As17880313

Performances

Mainpiece Title: King Lear

Afterpiece Title: Richard Coeur de Lion

Cast
Role: Lauretta Actor: Miss Collett.