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 Alchemist

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Ballet: II: The Prussian Camp. As17580131

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: The Fair Quaker Of Deal

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Ballet: II: The Prussian Camp. As17580131, but Blakes_

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Ballet: II: The Prussian Camp. As17580328

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Ballet: II: The Prussian Camp. As17581214

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Dance: III: A New Grand Dance-the two Master Roters, Master Settree, Miss Twist, Miss Simson; IV: By Particualr Desire, a Minuet-Leviez, Miss Macklin

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: The Wonder

Afterpiece Title: Queen Mab

Cast
Role: Puck Actor: Master Rogers

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Mock Doctor

Performances

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Queen Mab

Song: III: A Cantata-Miss Young

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Wonder

Afterpiece Title: Queen Mab

Performances

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: Queen Mab

Performances

Afterpiece Title: High Life Below Stairs

Performances

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Duke of York Actor: Miss Rogers.

Afterpiece Title: The Englishman in Paris

Dance: V: The Cow Keepers, as17600313

Performances

Afterpiece Title: Catherine and Petruchio

Dance: V: The Cow Keepers, as17600313

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Duke of York Actor: Miss Rogers.

Afterpiece Title: High Life Below Stairs