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: The Distrest Mother

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Funeral

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Rover

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Lady's Last Stake

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Double Gallant; Or, The Sick Lady's Cure

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Eurydice

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Eurydice

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Eurydice

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Eurydice

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Music: V: Concerto on the Violin-Charke

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: Cephalus and Procris

Cast
Role: Pierot Actor: Roger

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: The Pilgrim

Dance: new Hornpipe in the Character of a Sailor and his Wife-Jones, Mrs Ogden; Two Pierrots-Poitier, Pelling

Performances

Mainpiece Title: The Fond Husband

Afterpiece Title: The Tragedy of Tragedies

Dance: TTwo Pierrots-Poitier, Pelling; Hornpipe-Jones, Mrs Ogden