SELECT * FROM london_stages WHERE eventid IN (1863, 1877, 1886, 1922, 1945, 1959, 1982, 1983, 1984, 1988, 1990, 1991, 1999, 2005, 2006, 2012, 2018, 2022, 2040, 2050, 2059, 2097, 2104, 2118, 2211, 2217, 2239, 2249, 2272, 2285, 2304, 2306, 2348, 2395, 2401, 2417, 2428, 2435, 2458, 2459, 2463, 2467, 2468, 2511, 2520, 2526, 2536, 2578, 2593, 2672, 2727, 2853, 3061, 3145, 3170, 3245, 3440, 3790, 3793, 3798, 3808, 3816, 3817, 3822, 3830, 3834, 3839, 3852, 3853, 3855, 3862, 3876, 3878, 3880, 3881, 3883, 3884, 3886, 3890, 3896, 3917, 3921, 3926, 3927, 3938, 3947, 3953, 3955, 3959, 3961, 3963, 3981, 3985, 3986, 3988, 3994, 3995, 3996, 4013, 4035, 4039, 4041, 4042, 4044, 4046, 4047, 4048, 4049, 4052, 4055, 4058, 4059, 4060, 4066, 4080, 4085, 4086, 4093, 4095, 4096, 4097, 4104, 4106, 4120, 4121, 4123, 4124, 4128, 4135, 4140, 4150, 4151, 4152, 4160, 4162, 4166, 4168, 4173, 4175, 4176, 4185, 4196, 4208, 4215, 4218, 4220, 4226, 4228, 4231, 4232, 4235, 4240, 4242, 4375, 4387, 4391, 4397, 4413, 4432, 4436, 4446, 4448, 4452, 4456, 4460, 4480, 4503, 4509, 4536, 4544, 4545, 4551, 4555, 4566, 4589, 4621, 4622, 4626, 4629, 4632, 4633, 4638, 4643, 4645, 4648, 4657, 4662, 4663, 4667, 4670, 4674, 4693, 4694, 4719, 4728, 4731, 4737, 4784, 4792, 4794, 4795, 4802, 4809, 4812, 4823, 4835, 4843, 4844, 4869, 4887, 4888, 4891, 4892, 4894, 4908, 4909, 4917, 4923, 4927, 4939, 4940, 4945, 4949, 4950, 4952, 4953, 4963, 4972, 4979, 4990, 5099, 5103, 5106, 5113, 5115, 5134, 5141, 5144, 5150, 5152, 5153, 5161, 5168, 5171, 5172, 5175, 5184, 5190, 5194, 5269, 5270, 5306, 5310, 5328, 5331, 5342, 5344, 5395, 5403, 5408, 5440, 5465, 5611, 5706, 5715, 5735, 5781, 5785, 5805, 5841, 5845, 5906, 5908, 5922, 5929, 5947, 5970, 5972, 5984, 5996, 5998, 6006, 6010, 6028, 6085, 6086, 6093, 6094, 6095, 6097, 6109, 6115, 6153, 6179, 6199, 6241, 6315, 6411, 6424, 6492, 6539, 6547, 6569, 6571, 6573, 6577, 6589, 6605, 6615, 6619, 6658, 6684, 6713, 6716, 6724, 6730, 6747, 6759, 6790, 6803, 6816, 6828, 6831, 6852, 6855, 6865, 6897, 6927, 6933, 6963, 7031, 7034, 7037, 7044, 7048, 7066, 7074, 7080, 7084, 7088, 7090, 7092, 7096, 7100, 7112, 7120, 7124, 7230, 7233, 7258, 7444, 7446, 7454, 7456, 7459, 7470, 7476, 7478, 10830, 10914, 10919, 11124, 11126, 11129, 11131, 11134, 11136, 11138, 11140, 11143, 11145, 11148, 11151, 11154, 11157, 11163, 11168, 11174, 11179, 11185, 11190, 11197, 11203, 11212, 11216, 11219, 11223, 11226, 11324, 11382, 11384, 11389, 11404, 11410, 11416, 11418, 11424, 11432, 11439, 11448, 11455, 11459, 11461, 11467, 11474, 11487, 11494, 11499, 11506, 11515, 11517, 11524, 11526, 11529, 11531, 11533, 11536, 11538, 11542, 11544, 11547, 11549, 11552, 11554, 11557, 11560, 11562, 11568, 11571, 11579, 11598, 11599, 11604, 11612, 11614, 11634, 11636, 11639, 11642, 11645, 11647, 11654, 11659, 11667, 11672, 11679, 11683, 11685, 11688, 11700, 11705, 11722, 11751, 11763, 11766, 11774, 11786, 11789, 11827, 11833, 11837, 11842, 11846, 11856, 11858, 11867, 11895, 11997, 12035, 12130, 12169, 12181, 12190, 12221, 12233, 12238, 12246, 12252, 12255, 12346, 12365, 12369, 12397, 12399, 12401, 12402, 12405, 12408, 12411, 12413, 12416, 12418, 12419, 12421, 12424, 12426, 12429, 12430, 12432, 12433, 12435, 12436, 12439, 12441, 12446, 12448, 12449, 12451, 12453, 12455, 12457, 12459, 12464, 12466, 12468, 12470, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12497, 12500, 12501, 12502, 12506, 12507, 12512, 12521, 12522, 12527, 12529, 12539, 12545, 12546, 12564, 12566, 12572, 12605, 12619, 12621, 12629, 12647, 12678, 12724, 12732, 12754, 12764, 12979, 12982, 12985, 12991, 12995, 12997, 13000, 13001, 13004, 13007, 13011, 13024, 13034, 13038, 13121, 13125, 13294, 13324, 13358, 13424, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13732, 13746, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14229, 14785, 14796, 14826, 14852, 14903, 14907, 14911, 15001, 15003, 15005, 15011, 15015, 15597, 15698, 15701, 15704, 15705, 15708, 15710, 15711, 15712, 15714, 15715, 15716, 15717, 15718, 15719, 15720, 15723, 15791, 15796, 15808, 15813, 15818, 15825, 15828, 15842, 15846, 15850, 15864, 15887, 15911, 15920, 15928, 15935, 15954, 15975, 15985, 16000, 16005, 16009, 16026, 16030, 16041, 16050, 16111, 16115, 16119, 16126, 16130, 16136, 16139, 16142, 16148, 16152, 16157, 16161, 16165, 16169, 16173, 16177, 16195, 16205, 16223, 16233, 16239, 16245, 16252, 16282, 16286, 16307, 16316, 16328, 16333, 16337, 16344, 16351, 16366, 16388, 16395, 16403, 16481, 16549, 16594, 16600, 16624, 16631, 16633, 16643, 16651, 16669, 16674, 16679, 16706, 16782, 16823, 16837, 16841, 16850, 16854, 16858, 16862, 16866, 16870, 16874, 16878, 16886, 16890, 16910, 16922, 16926, 16933, 16937, 16941, 16945, 16949, 16956, 16960, 16985, 16989, 16993, 17002, 17006, 17011, 17015, 17019, 17060, 17072, 17076, 17081, 17098, 17134, 17156, 17311, 17328, 17333, 17342, 17347, 17352, 17430, 17440, 17448, 17452, 17455, 17458, 17464, 17467, 17469, 17473, 17478, 17491, 17496, 17499, 17502, 17505, 17509, 17512, 17515, 17518, 17526, 17537, 17540, 17604, 17634, 17647, 17651, 17655, 17658, 17668, 17671, 17674, 17677, 17683, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17851, 17856, 17861, 17940, 18123, 18427, 18446, 18460, 18468, 18504, 18516, 18608, 18737, 19036, 19041, 19043, 19065, 19075, 19101, 19123, 19149, 19243, 19281, 19283, 19285, 19291, 19293, 19295, 19302, 19310, 19314, 19349, 19382, 19384, 19662, 19665, 19668, 19672, 19678, 19680, 19682, 19684, 19686, 19688, 19718, 19722, 19730, 19734, 19746, 19754, 19756, 19764, 19773, 19778, 19787, 19790, 19794, 19799, 19801, 19821, 19828, 19831, 19833, 19835, 19851, 19856, 19866, 19869, 19872, 19875, 19879, 19882, 19889, 19900, 20123, 20736, 22964, 22973, 22978, 22994, 22997, 23029, 23062, 23136, 23139, 23142, 23168, 23171, 23175, 23178, 23186, 23206, 23214, 23216, 23219, 23225, 23271, 23618, 24351, 24570, 24712, 24802, 25418, 25425, 25443, 25445, 25449, 25451, 25893, 25896, 25899, 25902, 25905, 25907, 25909, 25959, 25961, 25982, 26067, 28529, 28823, 28825, 28828, 28831, 28837, 28841, 28844, 28847, 28871, 28876, 28885, 28891, 28893, 28896, 28956, 28958, 28983, 28997, 29070, 29537, 29547, 29549, 29593, 29610, 29722, 29766, 29846, 29853, 29864, 29877, 29881, 29958, 30039, 30055, 30106, 30116, 30147, 30157, 30301, 30304, 30309, 30337, 30341, 30481, 30484, 30486, 30489, 30493, 30496, 30498, 30542, 30549, 30585, 30624, 30694, 30712, 30749, 30750, 30751, 30753, 30754, 30756, 30758, 30760, 30762, 30763, 30764, 30765, 30766, 30767, 30768, 30791, 30812, 30856, 30956, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31061, 31069, 31094, 31097, 31100, 31102, 31109, 31112, 31116, 31136, 31154, 31158, 31179, 31182, 31189, 31220, 31223, 31236, 31274, 31350, 31401, 31405, 31409, 31411, 31413, 31415, 31417, 31419, 31422, 31426, 31428, 31432, 31437, 31439, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31488, 31491, 31494, 31496, 31498, 31500, 31502, 31504, 31506, 31510, 31519, 31523, 31526, 31529, 31531, 31533, 31535, 31560, 31562, 31569, 31605, 31608, 31617, 31626, 31629, 31632, 31642, 31648, 31654, 31657, 31673, 31686, 31689, 31700, 31709, 31715, 31731, 31734, 31740, 31767, 31768, 31771, 31839, 31841, 31847, 31849, 31853, 31869, 31877, 31881, 31885, 31887, 31913, 31921, 31927, 31930, 31932, 31946, 31967, 31972, 31974, 31979, 31982, 32003, 32030, 32035, 32036, 32037, 32040, 32042, 32046, 32048, 32050, 32052, 32055, 32058, 32060, 32062, 32063, 32064, 32067, 32069, 32072, 32074, 32075, 32076, 32077, 32079, 32081, 32082, 32083, 32084, 32086, 32087, 32089, 32090, 32091, 32095, 32111, 32121, 32126, 32164, 32181, 32211, 32218, 32220, 32221, 32226, 32227, 32231, 32235, 32240, 32245, 32256, 32258, 32264, 32317, 32319, 32321, 32323, 32325, 32329, 32332, 32336, 32339, 32341, 32342, 32344, 32346, 32348, 32354, 32362, 32366, 32380, 32384, 32390, 32393, 32395, 32403, 32407, 32411, 32414, 32416, 32437, 32442, 32450, 32454, 32459, 32464, 32466, 32471, 32473, 32475, 32477, 32479, 32481, 32486, 32488, 32493, 32495, 32500, 32502, 32507, 32514, 32516, 32533, 32542, 32554, 32556, 32558, 32563, 32568, 32572, 32575, 32578, 32580, 32584, 32591, 32593, 32597, 32603, 32609, 32613, 32616, 32619, 32623, 32629, 32635, 32639, 32642, 32648, 32656, 32658, 32666, 32671, 32674, 32676, 32683, 32698, 32710, 32718, 32724, 32748, 32811, 32813, 32815, 32817, 32822, 32832, 32834, 32838, 32840, 32842, 32846, 32848, 32850, 32852, 32854, 32856, 32858, 32860, 32862, 32864, 32866, 32868, 32870, 32872, 32874, 32876, 32878, 32882, 32884, 32892, 32933, 32939, 32947, 32953, 33003, 33022, 33031, 33036, 33039, 33045, 33047, 33092, 33100, 33103, 33106, 33116, 33124, 33129, 33131, 33134, 33145, 33158, 33177, 33193, 33201, 33260, 33265, 33267, 33287, 33291, 33312, 33315, 33317, 33320, 33322, 33325, 33327, 33330, 33332, 33339, 33341, 33344, 33348, 33362, 33383, 33388, 33397, 33400, 33402, 33428, 33430, 33435, 33439, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33481, 33483, 33489, 33491, 33494, 33496, 33501, 33506, 33510, 33512, 33515, 33517, 33520, 33524, 33529, 33536, 33538, 33570, 33572, 33585, 33597, 33604, 33617, 33622, 33626, 33630, 33649, 33652, 33654, 33659, 33671, 33673, 33676, 33700, 33702, 33725, 33792, 33794, 33796, 33798, 33800, 33804, 33806, 33837, 33841, 33889, 33896, 33907, 33962, 33972, 34010, 34014, 34050, 34058, 34069, 34072, 34146, 34161, 34175, 34182, 34199, 34202, 34224, 34237, 34350, 34355, 34376, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34531, 34536, 34541, 34547, 34552, 34557, 34559, 34566, 34569, 34571, 34585, 34589, 34681, 34720, 34772, 34777, 34798, 34895, 34905, 34911, 34913, 34917, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35068, 35070, 35074, 35076, 35078, 35088, 35092, 35094, 35104, 35106, 35108, 35111, 35113, 35118, 35120, 35125, 35127, 35129, 35132, 35135, 35138, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35240, 35250, 35264, 35277, 35281, 35286, 35289, 35302, 35305, 35308, 35319, 35327, 35332, 35340, 35354, 35365, 35372, 35382, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35543, 35549, 35551, 35553, 35566, 35573, 35577, 35581, 35583, 35587, 35595, 35597, 35603, 35617, 35626, 35629, 35635, 35647, 35650, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35683, 35686, 35688, 35696, 35702, 35707, 35718, 35747, 35751, 35756, 35788, 35792, 35802, 35813, 35818, 35823, 35826, 35829, 35854, 35860, 35865, 35876, 35889, 35907, 35943, 35947, 35970, 35983, 35989, 35994, 36111, 36118, 36120, 36125, 36139, 36141, 36145, 36147, 36153, 36161, 36163, 36179, 36190, 36206, 36214, 36217, 36219, 36223, 36227, 36229, 36232, 36237, 36239, 36243, 36248, 36253, 36257, 36266, 36275, 36279, 36287, 36291, 36293, 36298, 36303, 36305, 36308, 36324, 36326, 36343, 36345, 36365, 36388, 36398, 36406, 36418, 36424, 36445, 36449, 36460, 36468, 36475, 36485, 36494, 36504, 36506, 36513, 36523, 36537, 36546, 36558, 36561, 36564, 36568, 36575, 39363) 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: Macbeth

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Committee

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Love's Last Shift

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Cato

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Don John

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Albion Queens; Or, The Death Of Mary, Queen Of Scotland

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Othello, Moor Of Venice

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: King Henry The Ivth, Part Ii

Afterpiece Title: Perseus and Andromeda

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Elizabeth Rogers
Role: Lucy Actor: Susanna Rogers

Performances

Mainpiece Title: The Chances

Afterpiece Title: Harlequin Happy

Cast
Role: Pierot Actor: Roger.