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 (270, 450, 501, 619, 904, 946, 964, 975, 1159, 1235, 1237, 1430, 1475, 1507, 1728, 1777, 2177, 2606, 2607, 4526, 4582, 4619, 5223, 5425, 5657, 6509, 6511, 6515, 6964, 7045, 7568, 7665, 7853, 8196, 8442, 8444, 8446, 8449, 8451, 8488, 8542, 8676, 9565, 9648, 9841, 10376, 10378, 10379, 10854, 11337, 12477, 12480, 12485, 12562, 12762, 12883, 13132, 13135, 13139, 13142, 13146, 13150, 13154, 13158, 13162, 13165, 13169, 13173, 13754, 14258, 14267, 14431, 14486, 14649, 14889, 15519, 15527, 15915, 15919, 15923, 15927, 15931, 15938, 15990, 16012, 16025, 16129, 16461, 16550, 16635, 17005, 17081, 17495, 18163, 18503, 18515, 18519, 18673, 18686, 18723, 19364, 19370, 19372, 19827, 19830, 19842, 20079, 20276, 20684, 20704, 21846, 22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22759, 22875, 22878, 22881, 22883, 22886, 22887, 22889, 22966, 22969, 23100, 23103, 23110, 23113, 23142, 23302, 23599, 23605, 23608, 23660, 23707, 24005, 24008, 24010, 24177, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24819, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 25053, 25055, 25061, 25063, 25088, 25131, 25275, 26592, 27913, 27932, 27945, 27981, 28120, 28122, 28123, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28662, 28664, 28669, 28675, 28683, 28688, 28693, 28696, 28698, 28702, 28704, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28794, 28796, 28799, 28802, 28841, 28885, 28956, 29014, 29195, 29244, 29315, 29431, 29496, 29934, 29936, 29938, 29941, 29943, 29945, 29947, 29949, 29952, 29954, 29962, 30381, 30410, 30484, 30566, 30660, 31109, 31179, 31395, 31411, 31673, 31725, 31907, 31953, 32704, 32925, 32929, 32934, 32938, 32943, 32995, 33000, 33004, 33009, 33013, 33020, 33100, 33129, 33166, 33193, 33617, 33664, 34197, 34688, 34696, 34772, 34779, 34840, 34841, 34843, 34844, 34846, 34848, 34851, 34855, 34857, 34858, 34913, 34989, 35062, 35274, 35357, 35595, 35607, 35610, 35612, 35617, 35619, 35624, 35629, 35633, 35638, 35683, 35889, 35989, 36219, 36257, 36419, 36434, 36546, 37076, 37566, 37941, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38083, 38088, 38091, 38143, 38197, 38219, 38371, 38408, 38411, 38413, 38418, 38421, 38423, 38426, 38427, 38428, 38432, 38435, 38437, 38440, 38442, 38446, 38449, 38451, 38454, 38456, 38460, 38463, 38468, 38469, 38470, 38474, 38491, 38493, 38494, 38495, 38499, 38501, 38503, 38506, 38508, 38512, 38517, 38522, 38526, 38529, 38531, 38537, 38541, 38544, 38548, 38552, 38557, 38562, 38566, 38570, 38571, 38574, 38575, 38576, 38578, 38580, 38583, 38584, 38585, 38586, 38588, 38594, 38596, 38598, 38603, 38604, 38609, 38611, 38613, 38620, 38624, 38625, 38628, 38630, 38635, 38639, 38644, 38650, 38659, 38664, 38668, 38674, 38681, 38683, 38684, 38693, 38694, 38695, 38707, 38712, 38727, 38742, 38756, 38760, 38772, 38775, 38779, 38786, 38791, 38866, 38873, 38883, 38888, 38891, 38935, 38943, 38949, 38951, 38954, 38956, 38957, 38966, 38971, 38974, 38991, 39004, 39008, 39015, 39018, 39025, 39027, 39029, 39031, 39038, 39039, 39041, 39048, 39049, 39054, 39055, 39057, 39065, 39070, 39074, 39077, 39078, 39084, 39088, 39095, 39096, 39108, 39115, 39123, 39124, 39149, 39177, 39210, 39211, 39223, 39229, 39234, 39237, 39262, 39277, 39280, 39291, 39313, 39316, 39330, 39337, 39426, 39432, 39445, 39490, 39503, 39514, 39520, 39523, 39527, 39600, 39610, 39621, 39622, 39629, 39635, 39638, 39647, 39664, 39674, 39688, 39700, 39712, 39732, 39744, 39760, 39782, 39813, 39829, 39837, 39875, 39876, 39891, 39899, 39937, 39947, 39953, 39957, 39986, 39995, 40041, 40044, 40055, 40065, 40070, 40087, 40092, 40093, 40099, 40115, 40132, 40151, 40176, 40214, 40238, 40250, 40276, 40289, 40374, 40420, 40421, 40433, 40439, 40442, 40454, 40456, 40464, 40470, 40477, 40485, 40541, 40566, 40572, 40578, 40596, 40606, 40610, 40622, 40624, 40627, 40628, 40632, 40635, 40636, 40653, 40677, 40681, 40708, 40718, 40723, 40735, 40827, 40858, 40873, 40907, 40914, 40935, 40960, 40979, 41117, 41121, 41125, 41152, 41166, 41176, 41207, 41245, 41251, 41283, 41294, 41402, 41489, 41491, 41527, 41528, 41652, 41659, 41661, 41697, 41709, 41729, 41738, 41763, 41767, 41774, 41816, 41828, 41841, 41871, 41931, 41949, 41976, 42042, 42046, 42098, 42105, 42132, 42300, 42310, 42334, 42339, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42408, 42412, 42420, 42425, 42435, 42442, 42452, 42455, 42463, 42470, 42472, 42481, 42486, 42501, 42510, 42516, 42541, 42551, 42556, 42561, 42607, 42620, 42668, 42689, 42712, 42727, 42739, 42743, 42810, 42811, 42812, 42814, 42817, 42818, 42820, 42822, 42823, 42826, 42828, 42832, 42839, 42842, 42844, 42846, 42848, 42850, 42853, 42893, 42896, 42897, 42902, 42906, 42907, 42920, 42924, 42926, 42928, 42934, 42940, 42942, 42946, 42952, 42954, 42962, 42965, 42968, 43003, 43016, 43024, 43062, 43069, 43089, 43095, 43110, 43343, 43349, 43356, 43361, 43366, 43378, 43387, 43393, 43422, 43431, 43457, 43492, 43501, 43518, 43612, 43628, 43648, 43652, 43677, 43764, 43770, 43781, 43789, 43818, 43829, 43830, 43837, 43878, 43888, 43969, 44027, 44053, 44083, 44090, 44114, 44153, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44298, 44299, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44399, 44412, 44429, 44437, 44469, 44529, 44569, 44608, 44632, 44664, 44674, 44676, 44677, 44684, 44716, 44742, 44871, 44887, 44931, 44941, 44978, 44980, 45024, 45025, 45055, 45060, 45077, 45083, 45090, 45094, 45103, 45109, 45218, 45280, 45302, 45316, 45324, 45335, 45369, 45407, 45413, 45417, 45421, 45434, 45436, 45438, 45442, 45447, 45449, 45451, 45452, 45464, 45469, 45482, 45485, 45507, 45511, 45517, 45526, 45534, 45539, 45542, 45554, 45557, 45559, 45567, 45582, 45589, 45591, 45628, 45640, 45660, 45709, 45744, 45788, 45794, 45796, 45798, 45800, 45802, 45806, 45808, 45812, 45820, 45832, 45841, 45853, 45864, 45865, 45873, 45889, 45893, 45910, 45917, 45931, 45950, 45983, 45988, 46019, 46020, 46062, 46099, 46145, 46163, 46195, 46203, 46243, 46273, 46293, 46298, 46299, 46302, 46312, 46319, 46322, 46335, 46348, 46349, 46406, 46418, 46425, 46440, 46454, 46457, 46468, 46486, 46499, 46508, 46521, 46534, 46539, 46547, 46548, 46553, 46562, 46575, 46576, 46581, 46591, 46597, 46604, 46611, 46631, 46633, 46712, 46851, 46854, 46857, 46872, 46873, 46878, 46880, 46890, 46894, 46900, 46908, 46918, 46920, 46924, 46932, 46970, 47004, 47054, 47061, 47065, 47066, 47071, 47076, 47080, 47083, 47097, 47104, 47113, 47127, 47132, 47167, 47178, 47197, 47206, 47223, 47225, 47226, 47258, 47279, 47288, 47290, 47296, 47320, 47339, 47398, 47400, 47443, 47445, 47451, 47460, 47467, 47471, 47481, 47483, 47491, 47492, 47494, 47498, 47504, 47532, 47544, 47565, 47567, 47571, 47576, 47577, 47588, 47591, 47594, 47622, 47646, 47677, 47682, 47692, 47703, 47713, 47718, 47743, 47763, 47766, 47778, 47788, 47799, 47817, 47844, 47859, 47865, 47877, 47912, 47927, 47933, 47952, 47957, 47965, 47969, 47970, 47972, 47976, 47977, 47980, 47982, 47985, 47986, 47988, 47990, 47991, 47997, 48020, 48059, 48120, 48129, 48131, 48151, 48164, 48224, 48270, 48274, 48279, 48284, 48321, 48333, 48351, 48370, 48376, 48390, 48394, 48408, 48411, 48432, 48440, 48454, 48543, 48615, 48635, 48637, 48639, 48660, 48673, 48675, 48705, 48755, 48760, 48771, 48782, 48793, 48860, 48999, 49025, 49088, 49203, 49220, 49224, 49238, 49242, 49246, 49248, 49250, 49254, 49260, 49306, 49362, 49392, 49408, 49489, 49552, 49574, 49606, 49646, 49659, 49732, 49737, 49764, 49820, 49894, 49899, 49918, 49946, 50022, 50112, 50158, 50184, 50214, 50290, 50307, 50327, 50371, 50401, 50443, 50456, 50511, 50604, 50611, 50615, 50646, 50727, 50753, 50756, 50777, 50792, 50797, 50806, 50823, 50824, 50825, 50827, 50830, 50835, 50845, 50848, 50849, 50853, 50858, 50862, 50864, 50867, 50869, 50870, 50876, 50877, 50879, 50885, 50890, 50893, 50895, 50896, 50901, 50902, 50903, 50910, 51032, 51060, 51159, 51161, 51164, 51166, 51168, 51170, 51181, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51237, 51241, 51257, 51266, 51268, 51273, 51304, 51308, 51312, 51316, 51338, 51341, 51345, 51351, 51356, 51364, 51380, 51388, 51423, 51438, 51465, 51470, 51557, 51561, 51564, 51565, 51569, 51572, 51577, 51581, 51591, 51624, 51629, 51634, 51643, 51648, 51653, 51655, 51664, 51667, 51676, 51701, 51759, 51794, 51797, 51811, 51833, 51836, 51841, 51843, 51860, 51871, 51882, 51900, 51907, 52034, 52133, 52157, 52370, 52371, 52446, 52513, 52583) 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 Fatal Secret

Cast
Role: Ferdinand Actor: Ryan
Role: Cardinal of Arragon Actor: Walker

Performances

Mainpiece Title: The Fatal Secret

Cast
Role: Ferdinand Actor: Ryan
Role: Cardinal of Arragon Actor: Walker

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: Harlot's Process

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: Cephalus and Procris

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Marshal

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: Cephalus and Procris

Performances

Mainpiece Title: Fair Rosamond

Cast
Role: Cardinal Aquinas Actor: Winstone
Role: Cardinal Columbus Actor: Ridout

Afterpiece Title: The Impostor; or, The Biter Bit: With the Comical Humours of Vizard the Biter, Mixum the Vintner, and his Drawer Balderdash

Dance: I: Two Punches by Tench and Janno. II: The Constant Lovers. End of Droll: Le Badinage Cbampetre. Tumbling by Mynheer Vanderhoff, Mons de Voltore, Mons de Broc, Mons Janno

Performances

Mainpiece Title: The Tempest; Or, The Inchanted Island

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: The Devil to Pay

Dance: By Nivelon, Essex, Lalauze, Le Brun, Mrs Walter, Pelling, Davenport, Mrs Pelling, Miss Mann: I: Dutchman and his Frow. III: Pierots. V: Revellers

Performances

Mainpiece Title: Abra Mule

Afterpiece Title: Macheath 1n the Shades; or, Bayes at Parnassus

Cast
Role: Cardinal Wolsey Actor: Houghton

Dance: Tambourine by Miss Rogers. Scot's Dance by Glover, Miss Rogers, Le Sac, Miss Baston, Delagarde, Mrs De L'Orme

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Cast
Role: Ferdinand Actor: W. Mills

Afterpiece Title: Harlequin Restor'd

Music: As17351018

Performances

Mainpiece Title: Fair Rosamond: Representing Her Amours With King Henry, And Her Being Poisoned By Queen Eleanor In Woodstock Bower

Cast
Role: Cardinal Aquinas Actor: Wallis
Role: Cardinal Columbus Actor: Bambridge

Afterpiece Title: The Modern Pimp; or, The Doctor Deceiv'd: With the Comical Humours of Crack the Pimp, Dr Grey-Goose, and Sir Nehemiah Nestle-Cock

Dance: I: Two Pierrots by Livier and Mlle Delorme. II: Wooden Shoe Dance by Livier and Janno. End of Afterpiece: Grand Peasant Dance by Livier, Janno, Mlle Delorme, Mrs Woodward

Performances

Mainpiece Title: The Tempest; Or, The Inchanted Island

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: Harlequin Restor'd

Dance: In II: Dance of Winds-Muilment, Thurmond; In IV: Comic Dance of Fantastical Spirits (in Grostesque Characters)-Thurmond, Villeneuve, Levier, Pelling; In V: Waterman's Dance-Harper; with a Grand ballet of Sailors-Mlle Roland

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: Harlequin Restor'd

Dance: As17370411

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Este

Afterpiece Title: The King and the Miller of Mansfield

Dance: As17370411