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 (27436, 28059, 28199, 28201, 28205, 28211, 28213, 28223, 28231, 28235, 28243, 28253, 28308, 28312, 28324, 28340, 28343, 28345, 28348, 28350, 28357, 28361, 28363, 28393, 28398, 28462, 28484, 28496, 28504, 28509, 28526, 28565, 28651, 28721, 28770, 28849, 28950, 29007, 29068, 29174, 29225, 29331, 29354, 29407, 29419, 29468, 29551, 29610, 29649, 29735, 29776, 29813, 29815, 29819, 29821, 29864, 29917, 30045, 30061, 30223, 30295, 30297, 30299, 30383, 30393, 30400, 30405, 30502, 30504, 30507, 30509, 30513, 30517, 30520, 30526, 30532, 30535, 30537, 30546, 30553, 30557, 30564, 30569, 30580, 30585, 30597, 30651, 30665, 30678, 30684, 30697, 30706, 30707, 30709, 30710, 30714, 30716, 30741, 30761, 30791, 30795, 30806, 30816, 30820, 30830, 30845, 31154, 31162, 31281, 31350, 31354, 31356, 31360, 31368, 31370, 31372, 31374, 31378, 31389, 31391, 31395, 31397, 31399, 31413, 31504, 31542, 31556, 31749, 31761, 31829, 31831, 31835, 31837, 31869, 31877, 31881, 31885, 31887, 31925, 31939, 31965, 32211, 32219, 32235, 32252, 32258, 32264, 32321, 32325, 32329, 32339, 32342, 32346, 32348, 32350, 32352, 32356, 32358, 32364, 32366, 32382, 32384, 32473, 32475, 32477, 32479, 32481, 32486, 32488, 32493, 32495, 32500, 32507, 32514, 32516, 32554, 32556, 32558, 32563, 32568, 32575, 32580, 32593, 32619, 32648, 32656, 32658, 32666, 32671, 32676, 32678, 32680, 32704, 32720, 32724, 32729, 32748, 32813, 32815, 32817, 32822, 32827, 32830, 32836, 32838, 32886, 32888, 32890, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32966, 32969, 32972, 32974, 32976, 32978, 32981, 32983, 32985, 32987, 32989, 32991, 32994, 33106, 33110, 33121, 33150, 33166, 33183, 33195, 33243, 33244, 33245, 33250, 33252, 33253, 33254, 33256, 33257, 33265, 33269, 33271, 33273, 33275, 33315, 33317, 33322, 33325, 33327, 33330, 33332, 33339, 33341, 33344, 33383, 33388, 33397, 33400, 33402, 33404, 33428, 33430, 33435, 33439, 33481, 33483, 33506, 33515, 33520, 33536, 33654, 33761, 33767, 33794, 33796, 33798, 33800, 33802, 33804, 33808, 33810, 33814, 33819, 33821, 33823, 33845, 33851, 33853, 33855, 33857, 33862, 33864, 33866, 33873, 33874, 33877, 33884, 33891, 33893, 33896, 33898, 33905, 33907, 33912, 33931, 33943, 33945, 33948, 33953, 33964, 33969, 33986, 33989, 33996, 34048, 34052, 34058, 34093, 34112, 34115, 34132, 34137, 34144, 34146, 34155, 34158, 34170, 34173, 34175, 34178, 34180, 34182, 34187, 34197, 34199, 34209, 34212, 34214, 34217, 34232, 34258, 34261, 34336, 34348, 34353, 34355, 34357, 34359, 34365, 34369, 34376, 34387, 34389, 34393, 34400, 34402, 34408, 34416, 34428, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34454, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34487, 34489, 34491, 34493, 34498, 34503, 34505, 34507, 34510, 34512, 34523, 34525, 34527, 34529, 34531, 34536, 34541, 34545, 34547, 34550, 34552, 34557, 34559, 34566, 34569, 34571, 34573, 34580, 34583, 34585, 34587, 34589, 34595, 34597, 34600, 34603, 34606, 34611, 34616, 34636, 34647, 34678, 34683, 34693, 34703, 34709, 34714, 34717, 34720, 34724, 34727, 34729, 34732, 34747, 34751, 34756, 34758, 34761, 34763, 34767, 34770, 34777, 34779, 34793, 34798, 34804, 34812, 34889, 34895, 34901, 34911, 34917, 34927, 34949, 34955, 34966, 34970, 34972, 34975, 34982, 34994, 35028, 35036, 35045, 35055, 35080, 35102, 35111, 35116, 35135, 35140, 35154, 35184, 35235, 35243, 35281, 35283, 35299, 35308, 35313, 35316, 35319, 35327, 35332, 35340, 35345, 35365, 35368, 35375, 35495, 35500, 35508, 35526, 35533, 35535, 35537, 35541, 35555, 35562, 35564, 35631, 35653, 35662, 35681, 35688, 35714, 35721, 35733, 35738, 35741, 35759, 35769, 35797, 35807, 35818, 35854, 35860, 35897, 35913, 35916, 35940, 35963, 35970, 35983, 35994, 36115, 36127, 36131, 36139, 36149, 36153, 36155, 36176, 36217, 36221, 36223, 36260, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36287, 36289, 36291, 36296, 36301, 36305, 36324, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36398, 36406, 36409, 36424, 36445, 36455, 36465, 36482, 36497, 36529, 36540, 36546, 36564, 36647, 36649, 36653, 36655, 36659, 36663, 36667, 36671, 36678, 36680, 36688, 36696, 36704, 36710, 36717, 36726, 36742, 36752, 36764, 36768, 36773, 36775, 36780, 36782, 36784, 36787, 36790, 36793, 36820, 36827, 36837, 36862, 36886, 36888, 36892, 36900, 36941, 36969, 36980, 37033, 37063, 37073, 37078, 37082, 37104, 37110, 37119, 37223, 37241, 37294, 37315, 37324, 37349, 37359, 37378, 37380, 37382, 37384, 37386, 37388, 37393, 37398, 37402, 37407, 37412, 37414, 37419, 37424, 37428, 37439, 37451, 37455, 37460, 37462, 37465, 37467, 37470, 37475, 37479, 37505, 37517, 37531, 37540, 37555, 37608, 37618, 37626, 37630, 37635, 37640, 37646, 37653, 37680, 37763, 37781, 37793, 37795, 37799, 37801, 37817, 37823, 37833, 37839, 37849, 37852, 37856, 37880, 37882, 37887, 37895, 37902, 37914, 37943, 37958, 37964, 37967, 37980, 37985, 37989, 37994, 37998, 38011, 38021, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38083, 38088, 38091, 38105, 38128, 38143, 38156, 38165, 38175, 38180, 38188, 38192, 38197, 38200, 38205, 38207, 38210, 38224, 38236, 38311, 38323, 38336, 38347, 38355, 38378, 38383, 38387, 38390, 38394, 38399, 38401, 38407, 38417, 38420, 38427, 38436, 38445, 38448, 38450, 38469, 38485, 38494, 38500, 38505, 38507, 38521, 38536, 38565, 38570, 38608, 38642, 38644, 38653, 38663, 38680, 38729, 38734, 38750, 38768, 38778, 38794, 38796, 38798, 38888, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38930, 38934, 38939, 38944, 38948, 38953, 38960, 38970, 38976, 38982, 38988, 38995, 39000, 39008, 39013, 39015, 39017, 39022, 39024, 39026, 39032, 39078, 39083, 39093, 39095, 39104, 39121, 39142, 39149, 39181, 39190, 39202, 39213, 39225, 39260, 39268, 39273, 39285, 39315, 39326, 39333, 39345, 39449, 39451, 39453, 39457, 39460, 39465, 39480, 39497, 39508, 39513, 39518, 39520, 39525, 39527, 39532, 39541, 39550, 39555, 39558, 39564, 39603, 39609, 39611, 39613, 39615, 39618, 39621, 39625, 39629, 39632, 39637, 39641, 39646, 39675, 39678, 39687, 39707, 39735, 39750, 39759, 39789, 39818, 39828, 39840, 39852, 39854, 39861, 39866, 39871, 39894, 39898, 39902, 40019, 40031, 40041, 40043, 40049, 40054, 40058, 40060, 40094, 40106, 40143, 40150, 40192, 40194, 40198, 40204, 40209, 40213, 40253, 40256, 40315, 40319, 40330, 40334, 40337, 40344, 40361, 40363, 40366, 40376, 40378, 40383, 40386, 40388, 40390, 40395, 40397, 40417, 40424, 40432, 40435, 40437, 40443, 40447, 40453, 40457, 40458, 40460, 40466, 40597, 41128, 41131, 41136, 41140, 41142, 41144, 41155, 41170, 41189, 41200, 41221, 41244, 41246, 41256, 41286, 41296, 41300, 41420, 41460, 41490, 41519, 41548, 43063, 44470, 44474, 44502, 44505, 44513, 44516, 44520, 44531, 44537, 44540, 44551, 49777, 49817, 49819, 50092, 50911, 50948, 50953, 50965, 50971, 50983, 51012, 51052, 51076, 51083, 51090, 51119, 51133, 51209, 51263, 51290, 51304, 51307, 51319, 51322, 51329, 51336, 51354, 51365, 51368, 51397, 51399, 51400, 51403, 51410, 51416, 51423, 51425, 51428, 51430, 51437, 51440, 51447, 51453, 51455, 51456, 51467, 51468, 51474, 51475, 51476, 51478, 51481, 51488, 51505, 51506, 51511, 51513, 51514, 51517, 51519, 51521, 51522, 51525, 51527, 51529, 51531, 51532, 51535, 51537, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51557, 51559, 51561, 51563, 51565, 51567, 51569, 51571, 51573, 51575, 51577, 51579, 51581, 51583, 51585, 51587, 51588, 51589, 51591, 51592, 51597, 51598, 51600, 51601, 51603, 51605, 51607, 51610, 51612, 51613, 51615, 51617, 51618, 51619, 51621, 51627, 51631, 51636, 51639, 51641, 51650, 51657, 51659, 51662, 51667, 51669, 51671, 51672, 51673, 51675, 51677, 51678, 51680, 51681, 51682, 51683, 51685, 51686, 51687, 51690, 51691, 51693, 51694, 51696, 51697, 51698, 51700, 51703, 51705, 51706, 51709, 51710, 51712, 51713, 51715, 51718, 51721, 51722, 51724, 51725, 51727, 51728, 51729, 51733, 51734, 51736, 51739, 51742, 51743, 51746, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51793, 51794, 51797, 51799, 51801, 51806, 51811, 51813, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51838, 51840, 51841, 51842, 51843, 51845, 51846, 51847, 51849, 51851, 51854, 51856, 51864, 51869, 51871, 51877, 51882, 51884, 51885, 51890, 51893, 51895, 51900, 51907, 51926, 51933, 51936, 51944, 51947, 51950, 51953, 51957, 51962, 51967, 51970, 51971, 51972, 51976, 51981, 51988, 51991, 52004, 52013, 52021, 52024, 52026, 52033, 52035, 52037, 52041, 52045, 52047, 52052, 52054, 52066, 52079, 52081, 52082, 52084, 52086, 52088, 52090, 52091, 52093, 52097, 52102, 52117, 52134, 52144, 52162, 52163, 52164, 52166, 52168, 52170, 52172, 52174, 52178, 52182, 52186, 52192, 52194, 52201, 52203, 52204, 52206, 52214, 52218, 52223, 52227, 52236, 52239, 52241, 52243, 52245, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52280, 52282, 52284, 52286, 52289, 52291, 52294, 52296, 52298, 52300, 52303, 52305, 52308, 52310, 52312, 52314, 52317, 52319, 52323, 52326, 52329, 52331, 52334, 52335, 52338, 52342, 52343, 52346, 52349, 52350, 52352, 52353, 52354, 52355, 52358, 52359, 52362, 52364, 52365, 52367, 52370, 52374, 52376, 52383, 52389, 52394, 52396, 52398, 52400, 52403, 52405, 52413, 52415, 52418, 52420, 52425, 52429, 52432, 52434, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52461, 52466, 52471, 52476, 52478, 52482, 52490, 52495, 52497, 52499, 52504, 52511, 52514) 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: Joanna

Cast
Role: Philip Actor: H. Johnston
Role: Eloisa Actor: Mrs H. Johnston

Afterpiece Title: The Poor Soldier

Cast
Role: Patrick Actor: Johnstone

Song: As18000124

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Rosina

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Raymond and Agnes; or, The Castle of Lindenbergh

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: The Turnpike Gate

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: The Jew and the Doctor

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: A Divertisement

Dance: As17991209

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: True Friends

Cast
Role: Father Dominico Actor: Johnstone
Role: Theodora Actor: Mrs H. Johnston.

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: True Friends

Cast
Role: Father Dominico Actor: Johnstone
Role: Theodora Actor: Mrs H. Johnston.

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: True Friends

Cast
Role: Father Dominico Actor: Johnstone
Role: Theodora Actor: Mrs H. Johnston.

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: True Friends

Cast
Role: Father Dominico Actor: Johnstone
Role: Theodora Actor: Mrs H. Johnston.

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: True Friends

Cast
Role: Father Dominico Actor: Johnstone
Role: Theodora Actor: Mrs H. Johnston.

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: The Irish Mimic

Cast
Role: Parrots Actor: Johnstone

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Netley Abbey

Cast
Role: M'Scrape Actor: Johnstone

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Raymond and Agnes

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Song: In afterpiece: I am a jolly gay Pedlar-Townsend; Come every jovial fellow-Miss Sims, Mrs Castelle, Miss Wheatley; O ever in my bosom live-Mrs Chapman, Mrs Atkins

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Oscar and Malvina

Song: As18000304

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Oscar and Malvina

Song: I am a jolly gay Pedlar, as18000304O ever in my bosom live, as18000304Come every jovial fellow-Simmons, Mrs Sydney, Miss Wheatley

Performances

Mainpiece Title: The Egyptian Festival

Afterpiece Title: The Liar

Performances

Mainpiece Title: Speed The Plough

Cast
Role: Henry Actor: H. Johnston
Role: Miss Blandford Actor: Mrs H. Johnston

Afterpiece Title: Oscar and Malvina

Song: As18000308