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 (287, 1136, 3808, 3839, 10132, 14711, 14734, 15479, 15480, 15482, 15487, 15762, 17910, 17917, 18163, 22073, 22541, 22699, 23551, 23555, 23595, 23626, 23667, 23670, 24295, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24824, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 25142, 25153, 25185, 25310, 25313, 25316, 25322, 25326, 25724, 25735, 26475, 28788, 28790, 28810, 28813, 28820, 28822, 28839, 29061, 29327, 29419, 29449, 29551, 29564, 29580, 29604, 31822, 32269, 32273, 32274, 32275, 32276, 32277, 32278, 32279, 32281, 32282, 32283, 32285, 32287, 32290, 32292, 32294, 32295, 32297, 32298, 32299, 32303, 32304, 32309, 33684, 33745, 33748, 33752, 33757, 33759, 33765, 33770, 33789, 34251, 34297, 34304, 34308, 34309, 34322, 34333, 34338, 34688, 34696, 34719, 34866, 34870, 35212, 35245, 35347, 35364, 35380, 35384, 35387, 35443, 35454, 35484, 35501, 35515, 35557, 35591, 36182, 36185, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36283, 36285, 36288, 36290, 36292, 36299, 36306, 36311, 36316, 36325, 36327, 36363, 36553, 36687, 36707, 36729, 36732, 36734, 36737, 36739, 36741, 36743, 36746, 36748, 36751, 36757, 36760, 36765, 36767, 36771, 36779, 36783, 36826, 36831, 36835, 36842, 36856, 36859, 36869, 36874, 36884, 36898, 36912, 36915, 36924, 36926, 36931, 36937, 36940, 36942, 36948, 36953, 37003, 37017, 37022, 37040, 37050, 37056, 37081, 37192, 37194, 37198, 37228, 37230, 37236, 37252, 37254, 37258, 37269, 37300, 37308, 37320, 37332, 37334, 37336, 37341, 37346, 37353, 37360, 37362, 37367, 37372, 37383, 37385, 37387, 37389, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37440, 37442, 37444, 37458, 37461, 37463, 37466, 37468, 37471, 37473, 37476, 37480, 37486, 37491, 37496, 37504, 37511, 37515, 37518, 37520, 37529, 37541, 37567, 37573, 37607, 37609, 37617, 37647, 37649, 37660, 37668, 37674, 37676, 37678, 37782, 37784, 37788, 37792, 37794, 37798, 37800, 37804, 37806, 37808, 37812, 37814, 37816, 37818, 37820, 37822, 37824, 37826, 37830, 37834, 37836, 37838, 37840, 37842, 37844, 37846, 37850, 37857, 37859, 37865, 37867, 37871, 37873, 37876, 37879, 37881, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37922, 37926, 37929, 37931, 37934, 37938, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38004, 38027, 38029, 38046, 38048, 38063, 38071, 38079, 38094, 38108, 38113, 38119, 38124, 38129, 38139, 38144, 38173, 38184, 38189, 38191, 38193, 38198, 38201, 38211, 38222, 38234, 38237, 38240, 38251, 38310, 38312, 38314, 38316, 38319, 38322, 38324, 38331, 38333, 38335, 38338, 38340, 38344, 38346, 38348, 38350, 38352, 38354, 38360, 38362, 38365, 38368, 38370, 38372, 38377, 38379, 38382, 38384, 38388, 38408, 38411, 38413, 38416, 38418, 38421, 38423, 38426, 38428, 38430, 38432, 38435, 38437, 38440, 38442, 38444, 38446, 38449, 38451, 38454, 38456, 38769, 38859, 38865, 38871, 38874, 38882, 38886, 38909, 38922, 38931, 38935, 38940, 38943, 38945, 38947, 38949, 38952, 38954, 38957, 38959, 38963, 38966, 38968, 38971, 38980, 38983, 38985, 38987, 38991, 38995, 39000, 39004, 39009, 39012, 39017, 39018, 39024, 39025, 39027, 39029, 39031, 39032, 39034, 39036, 39037, 39038, 39039, 39041, 39042, 39043, 39044, 39046, 39047, 39048, 39049, 39051, 39052, 39054, 39055, 39056, 39057, 39058, 39060, 39063, 39065, 39066, 39067, 39068, 39070, 39072, 39073, 39074, 39076, 39077, 39082, 39084, 39086, 39087, 39089, 39094, 39096, 39098, 39101, 39103, 39108, 39114, 39115, 39124, 39129, 39136, 39137, 39138, 39147, 39152, 39157, 39161, 39163, 39166, 39178, 39182, 39185, 39191, 39199, 39200, 39206, 39211, 39220, 39223, 39226, 39229, 39231, 39237, 39242, 39246, 39251, 39262, 39270, 39271, 39277, 39281, 39286, 39313, 39316, 39321, 39323, 39325, 39330, 39446, 39450, 39452, 39456, 39464, 39469, 39473, 39475, 39479, 39483, 39485, 39490, 39492, 39494, 39496, 39498, 39503, 39507, 39509, 39512, 39514, 39517, 39523, 39528, 39531, 39533, 39535, 39537, 39540, 39545, 39549, 39551, 39556, 39561, 39565, 39568, 39573, 39575, 39577, 39579, 39582, 39584, 39587, 39589, 39598, 39604, 39610, 39622, 39633, 39635, 39638, 39642, 39647, 39652, 39656, 39658, 39664, 39667, 39669, 39674, 39679, 39681, 39685, 39688, 39691, 39694, 39696, 39698, 39700, 39703, 39705, 39708, 39710, 39712, 39714, 39717, 39724, 39727, 39732, 39736, 39744, 39755, 39760, 39765, 39770, 39773, 39782, 39792, 39798, 39806, 39808, 39813, 39819, 39824, 39829, 39833, 39838, 39855, 39858, 39862, 39867, 39869, 39874, 39878, 39884, 39887, 39889, 39895, 39899, 39916, 40017, 40018, 40020, 40022, 40024, 40026, 40027, 40028, 40030, 40032, 40034, 40036, 40038, 40046, 40051, 40055, 40057, 40061, 40063, 40065, 40067, 40069, 40071, 40077, 40079, 40081, 40087, 40089, 40091, 40093, 40095, 40099, 40107, 40112, 40114, 40116, 40118, 40121, 40123, 40126, 40128, 40130, 40132, 40135, 40140, 40144, 40146, 40151, 40154, 40156, 40158, 40160, 40163, 40165, 40167, 40176, 40179, 40181, 40183, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40231, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40263, 40270, 40276, 40279, 40282, 40285, 40289, 40292, 40295, 40297, 40302, 40305, 40308, 40311, 40316, 40323, 40324, 40326, 40331, 40335, 40338, 40340, 40345, 40350, 40353, 40355, 40358, 40360, 40362, 40364, 40367, 40369, 40372, 40374, 40377, 40379, 40382, 40384, 40387, 40389, 40391, 40396, 40401, 40403, 40408, 40413, 40416, 40418, 40420, 40422, 40425, 40428, 40433, 40436, 40438, 40441, 40444, 40446, 40448, 40450, 40454, 40566, 40568, 40572, 40574, 40576, 40578, 40580, 40582, 40584, 40587, 40589, 40590, 40593, 40594, 40596, 40598, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40622, 40624, 40628, 40632, 40634, 40636, 40638, 40640, 40649, 40651, 40653, 40655, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40695, 40697, 40700, 40706, 40708, 40711, 40712, 40714, 40717, 40719, 40721, 40723, 40726, 40727, 40729, 40732, 40734, 40736, 40748, 40750, 40752, 40765, 40767, 40772, 40775, 40777, 40784, 40787, 40789, 40792, 40795, 40797, 40801, 40804, 40809, 40813, 40816, 40819, 40842, 40848, 40852, 40856, 40866, 40870, 40873, 40880, 40884, 40886, 40889, 40891, 40898, 40900, 40902, 40905, 40907, 40910, 40912, 40917, 40922, 40925, 40928, 40933, 40951, 40956, 40960, 40962, 40965, 40970, 40980, 40983, 40989, 40999, 41010, 41123, 41197, 41459, 41487, 42992, 43099, 43156, 43830, 43833, 44031, 44078, 44227, 44230, 44233, 44237, 44242, 44244, 44247, 44249, 44253, 44256, 44261, 44263, 44286, 44293, 44311, 44315, 44319, 44328, 44337, 44374, 44377, 44414, 44427, 44432, 44437, 44459, 44589, 44591, 44593, 44595, 44597, 44599, 44601, 44605, 44616, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44634, 44636, 44641, 44643, 44645, 44647, 44648, 44650, 44652, 44654, 44656, 44658, 44660, 44662, 44666, 44668, 44670, 44672, 44674, 44678, 44680, 44682, 44684, 44686, 44688, 44690, 44692, 44694, 44696, 44698, 44705, 44710, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44778, 44780, 44783, 44785, 44787, 44789, 44791, 44794, 44796, 44799, 44805, 44808, 44815, 44817, 44818, 44819, 44822, 44828, 44834, 44836, 44840, 44847, 44853, 44857, 44860, 44863, 44867, 44874, 44876, 44880, 44884, 44887, 44897, 44907, 44909, 44911, 44915, 44920, 44922, 44925, 44927, 44929, 44931, 44934, 44936, 44941, 44944, 44946, 44952, 44957, 44964, 44969, 44971, 44975, 44980, 44983, 44986, 44989, 44990, 44992, 44995, 44996, 44998, 45001, 45004, 45007, 45008, 45013, 45016, 45020, 45022, 45025, 45027, 45030, 45032, 45035, 45037, 45040, 45041, 45043, 45044, 45047, 45051, 45053, 45055, 45056, 45057, 45059, 45063, 45065, 45068, 45073, 45074, 45075, 45076, 45077, 45078, 45081, 45083, 45084, 45086, 45087, 45088, 45089, 45091, 45092, 45096, 45101, 45107, 45108, 45110, 45113, 45114, 45115, 45116, 45117, 45118, 45121, 45122, 45123, 45124, 45127, 45129, 45130, 45131, 45137, 45141, 45143, 45147, 45159, 45164, 45166, 45169, 45174, 45176, 45178, 45180, 45182, 45184, 45188, 45192, 45196, 45204, 45208, 45214, 45216, 45222, 45224, 45228, 45232, 45236, 45238, 45240, 45244, 45248, 45252, 45255, 45257, 45262, 45264, 45274, 45278, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45302, 45305, 45307, 45310, 45314, 45316, 45319, 45321, 45324, 45326, 45328, 45330, 45333, 45335, 45344, 45347, 45352, 45354, 45356, 45378, 45384, 45394, 45397, 45399, 45407, 45410, 45420, 45425, 45433, 45436, 45438, 45442, 45444, 45449, 45451, 45459, 45461, 45464, 45466, 45469, 45475, 45477, 45480, 45482, 45485, 45492, 45495, 45500, 45509, 45511, 45517, 45519, 45521, 45524, 45526, 45529, 45531, 45534, 45539, 45542, 45544, 45547, 45554, 45557, 45559, 45562, 45567, 45569, 45574, 45577, 45582, 45587, 45589, 45591, 46148, 47102, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47416, 47419, 47424, 47468, 47476, 47876, 47907, 47919, 47946, 47947, 47957, 48018, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48110, 48112, 48116, 48120, 48122, 48130, 48132, 48138, 48177, 48235, 48263, 48270, 48274, 48277, 48279, 48284, 48291, 48310, 48319, 48340, 48401, 48415, 48429, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48566, 48568, 48570, 48574, 48939, 49030, 49045, 49060, 49133, 49135, 49137, 49167, 49172, 49231, 49239, 49255, 49279, 49304, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49370, 49375, 49379, 49424, 49444, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49808, 49828, 49932, 49937, 49958, 50137, 50306, 50308, 50310, 50974, 51004, 51051, 51106, 51109, 51111, 51113, 51115, 51120, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51233, 51236, 51240, 51260, 51262, 51267, 51270, 51279, 51284, 51287, 51294, 51299, 51301, 51311, 51321, 51323, 51326, 51328, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51372, 51377, 51380, 51405, 51415, 51420, 51428, 51430, 51453, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51550, 51552, 51554, 51556, 51570, 51572, 51582, 51595, 51602, 51623, 51626, 51633, 51638, 51640, 51642, 51647, 51649, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51807, 51819, 51821, 51824, 51830, 51832, 51837, 51844, 51848, 51850, 51855, 51863, 51872, 51876, 51878, 51888, 51913, 51989, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52034, 52044, 52046, 52049, 52050, 52051, 52053) 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 Purse

Afterpiece Title: The Jew

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: The Shipwreck

Afterpiece Title: Fortune's Frolick

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Cambro-britons

Afterpiece Title: The Castle of Sorrento

Performances

Afterpiece Title: The Heir at Law

Afterpiece Title: The Purse

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: False And True

Afterpiece Title: Blue Devils

Afterpiece Title: The Castle of Sorrento

Performances

Afterpiece Title: The Jew

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Purse

Performances

Mainpiece Title: Sighs

Afterpiece Title: Tars at Torbay; or, Sailors on Saturday Night

Afterpiece Title: The Castle of Sorrento

Song: End 1st piece: Crazy Jane (composed by Miss Abrahams [recte Abrams])-Mrs Bland

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: False and True

Afterpiece Title: The Jew and the Doctor

Performances

Afterpiece Title: The Jew

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: Sighs

Afterpiece Title: Tars at Torbay

Afterpiece Title: The Castle of Sorrento

Song: End 1st piece: Crazy Jane-Mrs Bland

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: Sighs

Afterpiece Title: Tars at Torbay

Afterpiece Title: The Castle of Sorrento