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 (25122, 25124, 25126, 25129, 25132, 25135, 25137, 25139, 25141, 25144, 25147, 25149, 25152, 25155, 25158, 25160, 25163, 25166, 25169, 25173, 25176, 25179, 25184, 25188, 26236, 26238, 26240, 26242, 26244, 26246, 26248, 26250, 26252, 26254, 26257, 26259, 26261, 26264, 26266, 26268, 26271, 26273, 26275, 26278, 26281, 26283, 26285, 26288, 26290, 26293, 26295, 26297, 27897, 27903, 27909, 27914, 27919, 27923, 27928, 27933, 27939, 27943, 27948, 27953, 27959, 27966, 27979, 28009, 28010, 28035, 28083, 28092, 28119, 28289, 28291, 28293, 28295, 28297, 28299, 28301, 28303, 28308, 28310, 28312, 28315, 28317, 28320, 28322, 28324, 28326, 28373, 28384, 28403, 28409, 28411, 28416, 28441, 28444, 28464, 28476, 28486, 28494, 28498, 28501, 28524, 28543, 28565, 28642, 28644, 28653, 28671, 28745, 28797, 29317, 29325, 29331, 29338, 29342, 29395, 29410, 30347, 30349, 30352, 30354, 30356, 30366, 30396, 30731, 30732, 30734, 30735, 30736, 30737, 30740, 30742, 30743, 30744, 30751, 30754, 30865, 30867, 30870, 30874, 30886, 30888, 30893, 30922, 30926, 31151, 31236, 31245, 31612, 31633, 31637, 31654, 31658, 31674, 31678, 31687, 31701, 31716, 31726, 31741, 31762, 32149, 32665, 32728, 33092, 33097, 34164, 34175, 34207, 34229, 34246, 34797, 34803, 34808, 34814, 34821, 34824, 34831, 34834, 34839, 34849, 34855, 34859, 34877, 34882, 34884, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35543, 35551, 35558, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35629, 35635, 35642, 35683, 35756, 35818, 35823, 35826, 35865, 36438, 36637, 36666, 36668, 36670, 36679, 36683, 36685, 36689, 36691, 36695, 36715, 36725, 36753, 36776, 36781, 36887, 36931, 37015, 37267, 37269, 37273, 37275, 37277, 37350, 37360, 37362, 37367, 37372, 37383, 37385, 37411, 37415, 37420, 37427, 37431, 37434, 37442, 37444, 37456, 37477, 37478, 37496, 37506, 37511, 37518, 37520, 37524, 37541, 37567, 37575, 37579, 37585, 37603, 37633, 37672, 37675, 38118, 38478, 38480, 38482, 38484, 38486, 38489, 38497, 38510, 38517, 38522, 38524, 38526, 38529, 38531, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38562, 38569, 38579, 38584, 38612, 38919, 38921, 38985, 39097, 39112, 39125, 39153, 39168, 39180, 39198, 39202, 39204, 39215, 39227, 39233, 39238, 39244, 39249, 39256, 39267, 39272, 39284, 39295, 39300, 39319, 39332, 39333, 39335, 39344, 39352, 39356, 39367, 39373, 39394, 39463, 39464, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39559, 39561, 39563, 39565, 39568, 39570, 39582, 39588, 39590, 39592, 39595, 39601, 39604, 39606, 39608, 39610, 39612, 39614, 39616, 39619, 39622, 39624, 39626, 39628, 39630, 39633, 39635, 39638, 39644, 39649, 39661, 39664, 39671, 39674, 39676, 39686, 39688, 39700, 39701, 39715, 39728, 39742, 39756, 39758, 39765, 39771, 39783, 39788, 39799, 39813, 39829, 39842, 39844, 39846, 39853, 39874, 39899, 39908, 39931, 40040, 40042, 40044, 40046, 40048, 40053, 40059, 40061, 40071, 40073, 40093, 40099, 40121, 40135, 40140, 40149, 40163, 40166, 40168, 40173, 40177, 40179, 40181, 40191, 40196, 40198, 40201, 40202, 40204, 40205, 40206, 40207, 40208, 40210, 40211, 40212, 40213, 40214, 40216, 40217, 40218, 40219, 40220, 40222, 40223, 40224, 40225, 40226, 40227, 40228, 40230, 40232, 40233, 40235, 40236, 40237, 40238, 40239, 40240, 40242, 40243, 40244, 40245, 40246, 40247, 40248, 40249, 40250, 40251, 40252, 40253, 40254, 40257, 40259, 40271, 40275, 40278, 40279, 40281, 40282, 40284, 40285, 40289, 40291, 40292, 40295, 40296, 40297, 40302, 40304, 40305, 40307, 40308, 40310, 40311, 40316, 40323, 40326, 40331, 40340, 40349, 40352, 40353, 40355, 40358, 40359, 40360, 40367, 40372, 40373, 40379, 40382, 40391, 40403, 40404, 40413, 40414, 40422, 40425, 40429, 40431, 40438, 40450, 40454, 40461, 40468, 40475, 40482, 40493, 40497, 40547, 40548, 40549, 40550, 40552, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40573, 40579, 40584, 40585, 40587, 40593, 40602, 40603, 40611, 40631, 40638, 40673, 40689, 40692, 40704, 40709, 40715, 40716, 40719, 40724, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40742, 40744, 40745, 40747, 40749, 40751, 40754, 40757, 40760, 40762, 40764, 40766, 40769, 40771, 40773, 40774, 40776, 40778, 40780, 40783, 40785, 40786, 40788, 40794, 40796, 40800, 40803, 40806, 40808, 40812, 40818, 40820, 40821, 40824, 40825, 40828, 40830, 40831, 40833, 40838, 40839, 40841, 40842, 40844, 40845, 40847, 40848, 40851, 40852, 40853, 40856, 40859, 40861, 40865, 40866, 40869, 40872, 40875, 40876, 40879, 40881, 40882, 40883, 40884, 40890, 40891, 40895, 40898, 40900, 40901, 40902, 40904, 40909, 40912, 40913, 40914, 40916, 40917, 40919, 40920, 40923, 40927, 40928, 40929, 40930, 40931, 40933, 40937, 40939, 40941, 40942, 40944, 40950, 40951, 40953, 40954, 40955, 40956, 40960, 40967, 40970, 40971, 40977, 40978, 40984, 40992, 41000, 41003, 41005, 41026, 41031, 41040, 41041, 41043, 41048, 41050, 41056, 41059, 41060, 41061, 41064, 41072, 41082, 41089, 41091, 41101, 41179, 41201, 41207, 41209, 41225, 41235, 41333, 41346, 41349, 41351, 41353, 41355, 41358, 41360, 41363, 41365, 41368, 41370, 41373, 41375, 41378, 41380, 41382, 41396, 41398, 41399, 41401, 41403, 41407, 41411, 41414, 41416, 41427, 41429, 41440, 41446, 41450, 41454, 41465, 41473, 41479, 41484, 41495, 41497, 41498, 41518, 41523, 41524, 41533, 41537, 41546, 41552, 41567, 41575, 41577, 41590, 41604, 41611, 41614, 41619, 41622, 41624, 41633, 41661, 41681, 41684, 44589, 44593, 44599, 44650, 44652, 44654, 44658, 44661, 44662, 44666, 44670, 44674, 44678, 44680, 44681, 44682, 44683, 44686, 44689, 44690, 44693, 44694, 44697, 44705, 44708, 44710, 44743, 44750, 44757, 44764, 44776, 44787, 44796, 44843, 44846, 44848, 44859, 44860, 44862, 44867, 44870, 44873, 44874, 44876, 44879, 44883, 44897, 44898, 44909, 44912, 44915, 44916, 44920, 44925, 44929, 44933, 44934, 44936, 44937, 44942, 44946, 44947, 44951, 44952, 44955, 44956, 44960, 44962, 44967, 44969, 44971, 44972, 44974, 44976, 44979, 44980, 44981, 44985, 44986, 44987, 44994, 44999, 45004, 45005, 45007, 45013, 45014, 45020, 45022, 45025, 45030, 45033, 45037, 45041, 45042, 45046, 45047, 45052, 45056, 45058, 45061, 45066, 45072, 45152, 45186, 45190, 45198, 45200, 45203, 45205, 45207, 45210, 45211, 45212, 45215, 45217, 45220, 45221, 45225, 45226, 45229, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45321, 45333, 45342, 45349, 45354, 45365, 45386, 45390, 45403, 45410, 45416, 45429, 45461, 45472, 45487, 45517, 45526, 45545, 45554, 45570, 45574, 45585, 45589, 45598, 45693, 45704, 45726, 45735, 45740, 45748, 45750, 45752, 45756, 45771, 45797, 45805, 45815, 45834, 45835, 45837, 45843, 45849, 45855, 45861, 45868, 45875, 45876, 45882, 45884, 45896, 45897, 45908, 45911, 45914, 45916, 45918, 45925, 45930, 45934, 45937, 45941, 45944, 45958, 45965, 46024, 46028, 46042, 46058, 46070, 46083, 46098, 46104, 46105, 46110, 46116, 46122, 46127, 46128, 46131, 46134, 46138, 46144, 46149, 46154, 46155, 46161, 46167, 46172, 46177, 46182, 46183, 46184, 46196, 46206, 46208, 46209, 46211, 46214, 46217, 46219, 46221, 46228, 46229, 46230, 46231, 46232, 46233, 46234, 46236, 46238, 46239, 46240, 46241, 46243, 46248, 46249, 46250, 46254, 46255, 46256, 46257, 46258, 46259, 46342, 46343, 46344, 46346, 46348, 46353, 46354, 46356, 46358, 46363, 46365, 46366, 46382, 46386, 46387, 46399, 46402, 46406, 46422, 46430, 46434, 46435, 46439, 46444, 46445, 46449, 46453, 46454, 46458, 46459, 46463, 46464, 46467, 46468, 46472, 46474, 46478, 46479, 46483, 46484, 46488, 46489, 46490, 46492, 46493, 46498, 46500, 46502, 46503, 46504, 46507, 46511, 46512, 46519, 46520, 46521, 46525, 46533, 46534, 46539, 46548, 46550, 46553, 46557, 46561, 46562, 46566, 46567, 46571, 46576, 46581, 46591, 46592, 46596, 46605, 46610, 46614, 46615, 46620, 46625, 46630, 46632, 46633, 46635, 46640, 46642, 46671, 46689, 46692, 46698, 46700, 46703, 46705, 46714, 46737, 46743, 46746, 46751, 46758, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46865, 46867, 46871, 46873, 46875, 46881, 46885, 46887, 46889, 46891, 46893, 46895, 46897, 46907, 46909, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46945, 46947, 46953, 46955, 46963, 47001, 47005, 47013, 47025, 47037, 47047, 47049, 47061, 47063, 47064, 47066, 47069, 47071, 47074, 47076, 47083, 47084, 47086, 47088, 47089, 47091, 47093, 47094, 47096, 47098, 47099, 47101, 47102, 47104, 47105, 47108, 47110, 47114, 47115, 47117, 47119, 47120, 47124, 47128, 47129, 47131, 47133, 47135, 47139, 47140, 47144, 47146, 47148, 47150, 47152, 47156, 47161, 47163, 47165, 47167, 47169, 47181, 47186, 47188, 47198, 47204, 47207, 47235, 47238, 47253, 47270, 47273, 47277, 47279, 47289, 47302, 47309, 47312, 47315, 47320, 47326, 47361, 47379, 47559, 47564, 47580, 47619, 47635, 47651, 47674, 47751, 47796, 48038, 48043, 48049, 48080, 48090, 48101, 48103, 48105, 48109, 48111, 48115, 48117, 48119, 48123, 48125, 48127, 48129, 48131, 48133, 48135, 48137, 48150, 48154, 48158, 48162, 48166, 48170, 48174, 48178, 48182, 48186, 48190, 48194, 48195, 48197, 48200, 48207, 48223, 48225, 48236, 48248, 48264, 48280, 48308, 48354, 48437, 48443, 48446, 48452, 48463, 48468, 48551, 48553, 48569, 48588, 48613, 48618, 48620, 48621, 48628, 48654, 48677, 48734, 48744, 48858, 48884, 49046, 49051, 49058, 49069, 49216, 49222, 49226, 49244, 49331, 49336, 49341, 49346, 49355, 49360, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49525, 49563, 49599, 49628, 49646, 49676, 49684, 49692, 49732, 49742, 49743, 49783, 49785, 49794, 49805, 49815, 49865, 49886, 49891, 49897, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49927, 49929, 49931, 49933, 49935, 49936, 49938, 49940, 49941, 49943, 49945, 49947, 49949, 49950, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50058, 50064, 50065, 50071, 50073, 50080, 50085, 50099, 50108, 50113, 50116, 50118, 50149, 50151, 50163, 50170, 50186, 50193, 50195, 50203, 50215, 50274, 50281, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50544, 50546, 50549, 50551, 50552, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50589, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50641, 50644, 50647, 50648, 50650, 50652, 50653, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50681, 50684, 50688, 50690, 50695, 50697, 50699, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50719, 50722, 50724, 50726, 50728, 50736, 50737, 50739, 50742, 50744, 50747, 50764, 50772, 50779, 50782, 50784, 50790, 50802, 50805, 50812, 50855, 50927, 50929, 50932, 50936, 50940, 50959, 50965, 50971, 51052, 51057, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51079, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51140, 51183, 51188, 51195, 51219, 51238, 51247, 51249, 51254, 51256, 51258, 51261, 51263, 51269, 51277, 51283, 51285, 51293, 51298, 51304, 51314, 51319, 51322, 51329, 51336, 51338, 51356, 51360, 51361, 51363, 51365, 51366, 51368, 51374, 51379, 51393, 51398, 51401, 51406, 51509, 51513, 51517, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51557, 51561, 51565, 51569, 51577, 51581, 51591, 51598, 51601, 51605, 51607, 51610, 51613, 51615, 51619, 51621, 51624, 51625, 51627, 51629, 51631, 51634, 51636, 51637, 51639, 51641, 51643, 51648, 51651, 51653, 51655, 51662, 51664, 51665, 51667, 51676, 51701, 51719, 51731, 51759, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51806, 51811, 51813, 51815, 51817, 51820, 51822, 51825, 51828, 51833, 51836, 51840, 51841, 51842, 51843, 51846, 51849, 51856, 51861, 51864, 51869, 51871, 51884, 51885, 51887, 51890, 51900, 51907, 51914, 51926, 51929, 51933, 51936, 51940, 52232, 52237, 52246, 52251, 52260, 52265, 52272, 52278, 52331, 52332, 52335, 52338, 52343, 52350, 52363, 52375, 52408, 52411, 52413, 52417, 52421, 52430, 52440, 52444, 52449, 52450, 52451, 52458, 52459, 52464, 52485, 52487, 52493, 52497, 52505, 52507, 52530, 52533, 52538, 52541, 52546, 52554, 52557, 52562, 52565, 52570, 52573, 52578) 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 Busy Body

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Twin Rivals

Afterpiece Title: The Fair

Performances

Mainpiece Title: Theodosius

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Fair

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fair

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Performances

Mainpiece Title: King Henry V

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Fair

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Funeral; Or, Grief A-la-mode

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Performances

Mainpiece Title: King Henry V

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Royal Merchant

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Fair

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Fair

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Fair

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Fair

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Fair

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Fair

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Fair

Performances

Mainpiece Title: Lady Jane Gray

Afterpiece Title: The Fair