SELECT * FROM london_stages WHERE eventid IN (1294, 1566, 1780, 1945, 1988, 2050, 3986, 4002, 5181, 5841, 6117, 6618, 6945, 7090, 7404, 7406, 7416, 7422, 8103, 8152, 8302, 8303, 10788, 12035, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12500, 12502, 12506, 12512, 12521, 12527, 12546, 13247, 13278, 13285, 13293, 13300, 13303, 13323, 13336, 13340, 13517, 13562, 13566, 13568, 13748, 14131, 14199, 14456, 14517, 14559, 14642, 14669, 14671, 14674, 14677, 14716, 14736, 14745, 14765, 14776, 14805, 14913, 14917, 14925, 14963, 15001, 15005, 15011, 15041, 15050, 15062, 15121, 15182, 15330, 15341, 15518, 15577, 15588, 15711, 15782, 15909, 15953, 16048, 16135, 16272, 16380, 16411, 16422, 16437, 16495, 16504, 16510, 16514, 16531, 16563, 16574, 16588, 16602, 16650, 16766, 16770, 16774, 16777, 16778, 16783, 16795, 16865, 17097, 17103, 17173, 17186, 17216, 17241, 17243, 17267, 17300, 17372, 17373, 17374, 17375, 17376, 17378, 17382, 17384, 17392, 17393, 17398, 17413, 17434, 17525, 17535, 17538, 17541, 17580, 17904, 17938, 18009, 18140, 18215, 18303, 18387, 18390, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18620, 18795, 18803, 18905, 18906, 18910, 18912, 18932, 18942, 18944, 18946, 19029, 19057, 19299, 19420, 19432, 19553, 19620, 19644, 19646, 19661, 19711, 19737, 19741, 19792, 19804, 19823, 19824, 19836, 19877, 19878, 19916, 20061, 20090, 20129, 20166, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20242, 20248, 20264, 20434, 20450, 20571, 20630, 20743, 20784, 20827, 20830, 20834, 20837, 20840, 20843, 20847, 20850, 20853, 20856, 20859, 20862, 20869, 20877, 20897, 20923, 20936, 20943, 21035, 21060, 21101, 21131, 21198, 21290, 21423, 21492, 21637, 21640, 21649, 21653, 21803, 21861, 21926, 21936, 21938, 21940, 21947, 21951, 21956, 21963, 21965, 21970, 22135, 22183, 22196, 22205, 22238, 22241, 22321, 22329, 22332, 22338, 22342, 22367, 22384, 22415, 22418, 22421, 22453, 22487, 22489, 22561, 22635, 22714, 22757, 22852, 22936, 22956, 22958, 22961, 22968, 22982, 22991, 23000, 23002, 23004, 23011, 23014, 23029, 23030, 23032, 23033, 23035, 23037, 23040, 23055, 23067, 23090, 23106, 23118, 23127, 23156, 23187, 23247, 23283, 23351, 23369, 23389, 23396, 23433, 23447, 23480, 23494, 23500, 23501, 23507, 23522, 23533, 23534, 23540, 23542, 23551, 23555, 23590, 23595, 23606, 23626, 23633, 23651, 23655, 23667, 23669, 23670, 23861, 23865, 23868, 23875, 23920, 23952, 23954, 23956, 23958, 23963, 23965, 23967, 23968, 23971, 23976, 23977, 23978, 23980, 23981, 23982, 23983, 23985, 24000, 24011, 24041, 24042, 24076, 24082, 24119, 24133, 24160, 24197, 24201, 24239, 24267, 24307, 24319, 24328, 24330, 24339, 24343, 24344, 24361, 24363, 24376, 24401, 24422, 24451, 24499, 24511, 24577, 24583, 24650, 24657, 24660, 24683, 24754, 24772, 24823, 24920, 24935, 24936, 24966, 24993, 25128, 25152, 25213, 25305, 25685, 25691, 25701, 25761, 25764, 25778, 25782, 25784, 25786, 25788, 25791, 25796, 25804, 25805, 25807, 25819, 25820, 25822, 25827, 25830, 25840, 25843, 25868, 25871, 25874, 25899, 25930, 25952, 25984, 26049, 26088, 26099, 26104, 26134, 26158, 26191, 26235, 26393, 26539, 26547, 26579, 26596, 26631, 26677, 26683, 26693, 26704, 26709, 26712, 26720, 26743, 26744, 26747, 26748, 26759, 26776, 26803, 26814, 26831, 26931, 26937, 26988, 27016, 27032, 27057, 27081, 27088, 27111, 27151, 27177, 27194, 27553, 27599, 27666, 27669, 27678, 27684, 27685, 27686, 27688, 27695, 27698, 27703, 27750, 27757, 27822, 27831, 27922, 28009, 28042, 28064, 28120, 28122, 28123, 28209, 28211, 28238, 28246, 28252, 28261, 28409, 28549, 28611, 28656, 28689, 28736, 28853, 28887, 28960, 29156, 29162, 29191, 29206, 29207, 29208, 29212, 29233, 29235, 29236, 29241, 29250, 29262, 29267, 29276, 29290, 29352, 29355, 29461, 29508, 29521, 29545, 29581, 29724, 29736, 29815, 29822, 29884, 29905, 29908, 30021, 30081, 30160, 30317, 30318, 30335, 30344, 30347, 30354, 30503, 30579, 30593, 30594, 30663, 30789, 30807, 30846, 30855, 30914, 31006, 31019, 31133, 31177, 31189, 31242, 32045, 32054, 32086, 32114, 32358, 32414, 32475, 32568, 32676, 32720, 32860, 33157, 33189, 33376, 33418, 33537, 33589, 33631, 33648, 33650, 33658, 33660, 33663, 33665, 33668, 33670, 33677, 33679, 33682, 33686, 33694, 33696, 33699, 33701, 33703, 33708, 33711, 33716, 33725, 33746, 33747, 33749, 33751, 33753, 33755, 33760, 33763, 33764, 33765, 33768, 33837, 33972, 34185, 34190, 34200, 34205, 34208, 34220, 34222, 34228, 34230, 34235, 34238, 34250, 34252, 34303, 34306, 34311, 34317, 34327, 34852, 34853, 34861, 34873, 35013, 35022, 35077, 35133, 35282, 35290, 35297, 35320, 35333, 35349, 35363, 35397, 35400, 35403, 35405, 35409, 35411, 35414, 35418, 35424, 35432, 35440, 35450, 35458, 35470, 35475, 35482, 35525, 35884, 35894, 35906, 35928, 35941, 35944, 35946, 35963, 35964, 35990, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36049, 36051, 36053, 36055, 36062, 36066, 36072, 36075, 36081, 36091, 36097, 36100, 36103, 36119, 36142, 36206, 36227, 36256, 36290, 36393, 36478, 36479, 36497, 36502, 36512, 36524, 36532, 36536, 36538, 36740, 36750, 36769, 36828, 36848, 37037, 37045, 37056, 37108, 37251, 37422, 37593, 37649, 37663, 37868, 37884, 37923, 37928, 37930, 37933, 37935, 37937, 37949, 37973, 37977, 37982, 37989, 38003, 38026, 38037, 38040, 38106, 38123, 38151, 38191, 38207, 38233, 38294, 38298, 38310, 38417, 38425, 38525, 38619, 38624, 38639, 38669, 38680, 38684, 38689, 38731, 38748, 38771, 38790, 38855, 38875, 38987, 39266, 39308, 39334, 39342, 39366, 39404, 39410, 39864, 39890, 39920, 39922, 40022, 40197, 40316, 40424, 40467, 40506, 40512, 40518, 40547, 40548, 40549, 40550, 40552, 40553, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40617, 40693, 40711, 40885, 40897, 40914, 40916, 40920, 40926, 40927, 40937, 40942, 40955, 40985, 41072, 41135, 41285, 41553, 41559, 41586, 41600, 41609, 41616, 41630, 41635, 41637, 41638, 41639, 41641, 41643, 41647, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41662, 41663, 41666, 41669, 41671, 41672, 41674, 41677, 41678, 41680, 41682, 41685, 41686, 41731, 41740, 41764, 42002, 42113, 42147, 42168, 42171, 42175, 42183, 42186, 42191, 42195, 42199, 42205, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 42320, 42392, 42464, 42493, 42609, 42670, 42682, 42694, 42714, 42886, 42892, 42915, 42987, 43021, 43035, 43260, 43299, 43415, 43579, 43581, 43589, 43591, 43593, 43595, 43610, 43613, 43650, 43692, 43714, 43735, 43784, 43817, 43833, 43891, 43958, 44007, 44037, 44040, 44085, 44089, 44119, 44131, 44169, 44286, 44459, 44551, 44773, 45001, 45006, 45074, 45075, 45076, 45078, 45081, 45113, 45295, 45436, 45451, 45587, 45626, 45628, 45631, 45635, 45638, 45640, 45648, 45686, 45719, 45758, 45759, 45761, 45763, 45765, 45769, 45773, 45777, 45781, 45785, 45789, 45799, 45803, 45828, 45932, 46065, 46074, 46075, 46083, 46085, 46088, 46095, 46100, 46121, 46133, 46140, 46142, 46148, 46174, 46202, 46205, 46208, 46212, 46223, 46224, 46228, 46235, 46240, 46242, 46248, 46254, 46258, 46274, 46277, 46286, 46295, 46309, 46313, 46318, 46333, 46351, 46395, 46421, 46438, 46474, 46476, 46490, 46550, 46557, 46561, 46566, 46607, 46609, 46616, 46642, 46675, 46681, 46687, 46704, 46721, 46723, 46725, 46726, 46728, 46734, 46737, 46743, 46761, 46836, 46846, 46969, 47263, 47312, 47437, 47501, 47693, 47724, 47794, 47890, 47894, 48006, 48012, 48039, 48045, 48051, 48076, 48086, 48091, 48103, 48352, 48366, 48368, 48396, 48409, 48439, 48539, 48565, 48575, 48667, 48675, 48677, 48679, 48685, 48687, 48689, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48709, 48714, 48727, 48729, 48732, 48734, 48735, 48744, 48754, 48757, 48777, 48791, 48805, 48817, 48858, 48875, 48878, 48883, 48885, 48891, 48897, 48905, 48914, 48917, 48924, 48939, 48947, 48953, 49016, 49038, 49048, 49072, 49081, 49082, 49083, 49088, 49089, 49097, 49100, 49103, 49109, 49114, 49117, 49119, 49147, 49150, 49152, 49158, 49184, 49232, 49258, 49329, 49332, 49334, 49337, 49338, 49339, 49340, 49342, 49343, 49345, 49348, 49350, 49351, 49352, 49354, 49356, 49357, 49359, 49361, 49362, 49365, 49371, 49373, 49375, 49376, 49378, 49379, 49384, 49385, 49387, 49390, 49392, 49399, 49401, 49413, 49417, 49419, 49424, 49425, 49431, 49432, 49439, 49444, 49452, 49465, 49504, 49582, 49584, 49586, 49591, 49597, 49601, 49609, 49637, 49642, 49667, 49688, 49728, 49772, 49796, 49799, 49801, 49803, 49808, 49811, 49823, 49825, 49827, 49829, 49831, 49833, 49835, 49837, 49839, 49841, 49843, 49845, 49847, 49851, 49855, 49859, 49863, 49867, 49869, 49871, 49875, 49879, 49883, 49893, 49897, 49926, 49935, 49940, 49949, 49954, 49959, 49980, 49983, 49985, 49987, 49989, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50057, 50067, 50070, 50079, 50082, 50089, 50104, 50108, 50128, 50131, 50134, 50136, 50143, 50148, 50166, 50191, 50205, 50221, 50224, 50226, 50229, 50230, 50231, 50232, 50234, 50235, 50238, 50239, 50242, 50243, 50245, 50247, 50250, 50257, 50262, 50263, 50265, 50267, 50268, 50270, 50276, 50277, 50278, 50280, 50283, 50285, 50289, 50293, 50294, 50295, 50298, 50302, 50303, 50309, 50317, 50319, 50322, 50332, 50334, 50396, 50422, 50480, 50492, 50572, 50577, 50580, 50582, 50585, 50586, 50587, 50590, 50594, 50599, 50608, 50616, 50719, 50739, 50759, 50766, 50792, 50811, 50817, 50826, 50838, 50840, 50850, 50870, 50900, 50917, 50921, 50963, 50977, 51001, 51003, 51005, 51007, 51009, 51014, 51016, 51018, 51021, 51027, 51029, 51033, 51036, 51041, 51045, 51073, 51078, 51087, 51150, 51241, 51247, 51249, 51254, 51256, 51271, 51285, 51298, 51300, 51309, 51329, 51336, 51349, 51354, 51356, 51358, 51365, 51376, 51383, 51432, 51445, 51469, 51472, 51481, 51521, 51525, 51527, 51531, 51576, 51580, 51597, 51606, 51749, 51752, 51754, 51758, 51761, 51764, 51766, 51770, 51776, 51781, 51783, 51785, 51791, 51796, 51800, 51803, 51806, 51811, 51814, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51851, 51859, 51869, 51871, 51873, 51877, 51879, 51885, 51888, 51898, 51900, 51907, 51913, 51927, 51929, 51936, 51953, 51975, 51984, 51988, 52004, 52013, 52021, 52026, 52035, 52041, 52045, 52052, 52060, 52062, 52091, 52093, 52097, 52101, 52126, 52128, 52129, 52137, 52141, 52144, 52153, 52203, 52218, 52224, 52225, 52227, 52236, 52245, 52253, 52282, 52295, 52342, 52346, 52349, 52352, 52353, 52354, 52358, 52364, 52370, 52376, 52391, 52396, 52444, 52454, 52458, 52471, 52473, 52482, 52499, 52506, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52551, 52552, 52553, 52555, 52558, 52559, 52560, 52561, 52563, 52564, 52566, 52567, 52569, 52571, 52572, 52574, 52575, 52576, 52579, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52593, 52594, 52595, 52597, 52600, 52601, 52602, 52604, 52605, 52610, 52615) 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 Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Beggars Opera

Performances

Mainpiece Title: The Metamorphosis Of The Beggars Opera

Cast
Role: Crookfinger'd Jack Actor: Miss Wood

Afterpiece Title: Damon and Phillida

Performances

Mainpiece Title: The Authors Farce With The Pleasures Of The Town

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Afterpiece Title: The Cheats of Scapin

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: The Authors Farce

Cast
Role: Jack Actor: Achurch
Role: Jack Pudding Actor: Reynolds

Performances

Mainpiece Title: Oroonoko

Cast
Role: Jack Stanmore Actor: Pearce

Afterpiece Title: Flora

Song: A Youth of Thirteen Years of Age

Performances

Mainpiece Title: Wat Tyler And Jack Straw Being The Representation Of That Celebrated And Heroick Action Of Sir William Walworth A lord Mayor Of London Performd In The Reign Of king Richard The Second Shewing How He Stabd The Insolent Rebel wat Tyler At The Head Of His Rout In smithfield For Which Reason The Dagger Which He So Loyally Employd Was Added To The Citys Arms And Loyalty

Cast
Role: Jack Straw Actor: Collet