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