SELECT * FROM london_stages WHERE eventid IN (12215, 27684, 27685, 27688, 27708, 27712, 27718, 27730, 27748, 27750, 27775, 27822, 27829, 27831, 27867, 27870, 27872, 27874, 27876, 27879, 27882, 27884, 27887, 27889, 27893, 27896, 27899, 27947, 27975, 27992, 28041, 28057, 28059, 28064, 28074, 28088, 28102, 28144, 28180, 28209, 28229, 28233, 28241, 28245, 28255, 28260, 28265, 28297, 28310, 28331, 28340, 28352, 28367, 28370, 28386, 28409, 28424, 28454, 28489, 28506, 28511, 28521, 28543, 28549, 28559, 28561, 28655, 28662, 28664, 28669, 28675, 28691, 28694, 28696, 28702, 28707, 28712, 28717, 28726, 28731, 28754, 28761, 28782, 28794, 28823, 28841, 28847, 28857, 28861, 28864, 28866, 28874, 28885, 28898, 28902, 28905, 28908, 28910, 28915, 28935, 28956, 28991, 28995, 28997, 29005, 29011, 29014, 29016, 29019, 29057, 29072, 29178, 29184, 29187, 29193, 29195, 29199, 29201, 29205, 29209, 29213, 29215, 29217, 29223, 29227, 29232, 29239, 29244, 29259, 29264, 29289, 29295, 29300, 29306, 29315, 29317, 29320, 29325, 29329, 29331, 29334, 29336, 29338, 29340, 29342, 29346, 29352, 29359, 29372, 29374, 29376, 29379, 29384, 29386, 29388, 29390, 29395, 29405, 29410, 29414, 29421, 29424, 29428, 29431, 29434, 29445, 29452, 29468, 29473, 29478, 29484, 29496, 29503, 29506, 29510, 29513, 29518, 29524, 29529, 29535, 29537, 29539, 29544, 29553, 29556, 29560, 29568, 29571, 29574, 29577, 29580, 29610, 29735, 29745, 29749, 29756, 29758, 29760, 29768, 29778, 29780, 29784, 29786, 29794, 29799, 29801, 29804, 29810, 29813, 29823, 29826, 29833, 29835, 29838, 29840, 29842, 29844, 29848, 29851, 29853, 29859, 29874, 29881, 29883, 29886, 29888, 29894, 29899, 29907, 29909, 29912, 29932, 29934, 29936, 29938, 29941, 29943, 29945, 29947, 29949, 29952, 29954, 29962, 29969, 29978, 29987, 29991, 29994, 29997, 30000, 30003, 30006, 30009, 30012, 30015, 30018, 30031, 30042, 30063, 30065, 30068, 30070, 30088, 30098, 30103, 30106, 30111, 30120, 30130, 30134, 30141, 30279, 30302, 30307, 30319, 30321, 30323, 30329, 30331, 30339, 30343, 30346, 30348, 30351, 30355, 30357, 30360, 30365, 30367, 30369, 30371, 30376, 30381, 30397, 30403, 30408, 30410, 30415, 30418, 30422, 30424, 30427, 30432, 30436, 30438, 30446, 30452, 30455, 30460, 30465, 30467, 30470, 30475, 30481, 30484, 30486, 30489, 30493, 30522, 30542, 30566, 30578, 30583, 30592, 30599, 30603, 30606, 30611, 30619, 30622, 30627, 30629, 30631, 30633, 30636, 30653, 30656, 30658, 30660, 30662, 30668, 30676, 30682, 30688, 30694, 30785, 30787, 30793, 30801, 30808, 30812, 30814, 30816, 30818, 30822, 30824, 30826, 30828, 30832, 30834, 30838, 30854, 30858, 30860, 30865, 30878, 30882, 30886, 30891, 30902, 30907, 30916, 30919, 30930, 30933, 30935, 30937, 30940, 30944, 30947, 30950, 30954, 30956, 30958, 30961, 30966, 30971, 30983, 30985, 30989, 30995, 30998, 31003, 31007, 31015, 31017, 31028, 31040, 31045, 31047, 31055, 31059, 31063, 31066, 31094, 31097, 31102, 31109, 31120, 31123, 31136, 31158, 31165, 31168, 31172, 31179, 31200, 31216, 31223, 31231, 31234, 31236, 31239, 31241, 31245, 31247, 31251, 31253, 31337, 31339, 31346, 31348, 31350, 31354, 31358, 31362, 31368, 31376, 31380, 31384, 31389, 31391, 31393, 31397, 31401, 31403, 31405, 31409, 31415, 31422, 31424, 31426, 31437, 31439, 31445, 31448, 31451, 31457, 31459, 31462, 31467, 31480, 31486, 31496, 31502, 31506, 31510, 31513, 31515, 31517, 31519, 31526, 31537, 31544, 31546, 31548, 31550, 31553, 31556, 31558, 31560, 31562, 31564, 31567, 31569, 31571, 31574, 31577, 31580, 31583, 31585, 31587, 31589, 31591, 31594, 31597, 31599, 31602, 31605, 31608, 31611, 31614, 31617, 31623, 31626, 31632, 31636, 31639, 31645, 31648, 31657, 31664, 31667, 31671, 31675, 31684, 31689, 31698, 31703, 31711, 31715, 31718, 31720, 31723, 31758, 31827, 31833, 31849, 31853, 31857, 31869, 31873, 31881, 31889, 31893, 31897, 31903, 31905, 31909, 31913, 31919, 31923, 31925, 31927, 31932, 31935, 31937, 31941, 31944, 31946, 31951, 31963, 31967, 31972, 31974, 31979, 31982, 31985, 31993, 31995, 32000, 32009, 32014, 32017, 32019, 32023, 32026, 32030, 32032, 32036, 32041, 32047, 32051, 32059, 32061, 32063, 32066, 32071, 32074, 32076, 32078, 32083, 32090, 32092, 32095, 32097, 32100, 32102, 32106, 32111, 32136, 32158, 32160, 32171, 32181, 32191, 32204, 32206, 32211, 32219, 32221, 32226, 32231, 32233, 32235, 32238, 32243, 32249, 32252, 32317, 32319, 32323, 32329, 32334, 32339, 32342, 32344, 32346, 32354, 32356, 32360, 32364, 32368, 32370, 32374, 32376, 32380, 32382, 32384, 32390, 32393, 32399, 32403, 32405, 32407, 32411, 32416, 32439, 32444, 32447, 32450, 32452, 32454, 32457, 32462, 32466, 32468, 32471, 32477, 32479, 32481, 32486, 32488, 32493, 32500, 32507, 32514, 32528, 32530, 32533, 32536, 32539, 32542, 32546, 32549, 32554, 32556, 32558, 32560, 32565, 32570, 32575, 32580, 32593, 32605, 32609, 32616, 32623, 32629, 32631, 32639, 32644, 32648, 32653, 32656, 32660, 32662, 32664, 32669, 32671, 32680, 32683, 32691, 32693, 32698, 32706, 32708, 32710, 32718, 32722, 32727, 32729, 32732, 32734, 32743, 32807, 32809, 32811, 32813, 32834, 32836, 32838, 32840, 32842, 32844, 32846, 32852, 32858, 32862, 32864, 32866, 32868, 32870, 32872, 32876, 32878, 32884, 32886, 32890, 32892, 32894, 32906, 32910, 32913, 32924, 32926, 32928, 32933, 32939, 32942, 32944, 32949, 32951, 32953, 32956, 32960, 32962, 32972, 32974, 32976, 32981, 32983, 32987, 32991, 32994, 32999, 33001, 33008, 33010, 33015, 33017, 33022, 33024, 33026, 33031, 33034, 33039, 33045, 33050, 33054, 33057, 33059, 33064, 33067, 33070, 33072, 33075, 33079, 33082, 33084, 33088, 33095, 33097, 33100, 33103, 33106, 33108, 33110, 33112, 33114, 33119, 33126, 33129, 33141, 33145, 33148, 33150, 33152, 33154, 33158, 33161, 33170, 33172, 33177, 33179, 33183, 33185, 33195, 33198, 33265, 33273, 33275, 33277, 33281, 33285, 33287, 33289, 33291, 33293, 33297, 33304, 33306, 33309, 33312, 33317, 33322, 33325, 33327, 33330, 33332, 33339, 33344, 33348, 33350, 33353, 33358, 33360, 33362, 33364, 33367, 33369, 33374, 33378, 33381, 33386, 33390, 33392, 33395, 33397, 33402, 33406, 33409, 33411, 33414, 33416, 33420, 33423, 33425, 33430, 33433, 33435, 33437, 33439, 33469, 33481, 33483, 33486, 33498, 33506, 33508, 33512, 33526, 33534, 33536, 33538, 33592, 33595, 33597, 33604, 33607, 33609, 33613, 33620, 33622, 33630, 33633, 33635, 33638, 33647, 33649, 33652, 33657, 33662, 33669, 33673, 33676, 33681, 33685, 33702, 33707, 33710, 33717, 33792, 33794, 33798, 33802, 33808, 33810, 33816, 33819, 33823, 33825, 33829, 33833, 33835, 33839, 33843, 33855, 33862, 33864, 33866, 33873, 33875, 33882, 33887, 33891, 33893, 33896, 33898, 33903, 33905, 33907, 33910, 33912, 33919, 33921, 33924, 33935, 33938, 33940, 33943, 33945, 33948, 33950, 33955, 33960, 33962, 33964, 33967, 33976, 33980, 33982, 33984, 33989, 33991, 34003, 34012, 34017, 34024, 34026, 34028, 34031, 34033, 34036, 34038, 34040, 34043, 34045, 34048, 34052, 34055, 34060, 34063, 34065, 34067, 34075, 34082, 34085, 34088, 34097, 34102, 34107, 34112, 34117, 34122, 34127, 34130, 34132, 34141, 34144, 34151, 34158, 34161, 34164, 34166, 34184, 34187, 34189, 34192, 34199, 34204, 34209, 34217, 34219, 34224, 34229, 34232, 34234, 34239, 34242, 34244, 34246, 34254, 34336, 34348, 34359, 34361, 34365, 34372, 34374, 34376, 34383, 34387, 34389, 34391, 34397, 34400, 34406, 34410, 34412, 34418, 34426, 34431, 34435, 34440, 34475, 34479, 34482, 34484, 34493, 34496, 34503, 34505, 34507, 34510, 34516, 34518, 34525, 34529, 34538, 34543, 34555, 34561, 34564, 34569, 34575, 34578, 34589, 34592, 34603, 34606, 34608, 34616, 34619, 34621, 34627, 34631, 34634, 34636, 34681, 34683, 34688, 34693, 34696, 34720, 34722, 34727, 34729, 34743, 34747, 34749, 34751, 34758, 34761, 34765, 34772, 34777, 34779, 34784, 34789, 34798, 34815, 34889, 34893, 34895, 34897, 34899, 34913, 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, 35070, 35074, 35076, 35078, 35088, 35092, 35094, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35135, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35264, 35277, 35289, 35305, 35316, 35365, 35372, 35382, 37650, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38730, 38735, 38740, 38749, 38751, 38754, 38762, 38772, 38779, 38786, 38791, 39366, 40411, 40435, 40965, 40970, 40974, 40980, 40985, 40987, 40997, 41557, 41988, 48278, 48285, 48289, 48294, 48299, 48349, 48384, 48409, 48411, 48416, 48418, 48430, 48443, 48551, 48553, 48555, 48557, 48561, 48565, 48567, 48569, 48579, 48585, 48588, 48596, 48613, 48621, 48635, 48647, 48651, 48747, 48749, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48842, 48844, 48846, 48849, 48851, 48854, 48856, 48863, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49051, 49053, 49056, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49193, 49199, 49206, 49214, 49216, 49222, 49226, 49244, 49445, 49449, 49454, 49462, 49472, 49478, 49485, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49578, 49580, 49589, 49592, 49594, 49597, 49602, 49607, 49612, 49620, 49635, 49640, 49642, 49650, 49655, 49657, 49662, 49664, 49667, 49797, 49801, 49811, 49819, 49857, 49877, 49886, 49891, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50111, 50113, 50116, 50118, 50128, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50177, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50210, 50215, 50384, 50395, 50399, 50419, 50432, 50437, 50441, 50446, 50451, 50455, 50460, 50474, 50486, 50500, 50514, 50537, 50539, 50542, 50550, 50555, 50558, 50565, 50570, 50575, 50594, 50608, 50619, 50625, 50627, 50631, 50634, 50639, 50658, 50687, 50721, 50732, 50741, 50751, 50768, 50804, 50928, 50930, 50931, 50935, 50938, 50939, 50941, 50943, 50945, 50947, 50952, 50968, 50970, 50972, 50976, 50982, 50988, 50996, 51000, 51002, 51004, 51006, 51011, 51013, 51017, 51020, 51026, 51028, 51030, 51035, 51040, 51049, 51066, 51072, 51123, 51149, 51151, 51153, 51160, 51165, 51184, 51190, 51198, 51210, 51217, 51222, 51279, 51282, 51306, 51316, 51321, 51342, 51362, 51367, 51382, 51390, 51480, 51483, 51485, 51489, 51493, 51497, 51500, 51504, 51508, 51510, 51512, 51516, 51518, 51523, 51524, 51528, 51530, 51533, 51538, 51540, 51548, 51552, 51554, 51556, 51558, 51562, 51566, 51568, 51570, 51574, 51600, 51609, 51616, 51620, 51626, 51628, 51644, 51647, 51654, 51658, 51661, 51672, 51680, 51690, 51700, 51703, 51705, 51715, 51717, 51721, 51727, 51733, 51736, 51746, 51773, 51788, 51793, 51798, 51802, 51812, 51816, 51819, 51827, 51832, 51837, 51842, 51844, 51848, 51863, 51865, 51870, 51872, 51876, 51878, 51881, 51884, 51886, 51892, 51894, 51897, 51901, 51903, 51906, 51908, 51911, 51916, 51918, 51921, 51923, 51926, 51928, 51930, 51932, 51935, 51937, 51939, 51941, 51942, 51943, 51946, 51949, 51952, 51954, 51956, 51958, 51961, 51963, 51966, 51968, 51970, 51972, 51975, 51980, 51982, 52059, 52061, 52063, 52067, 52069, 52071, 52073, 52075, 52076, 52078, 52080, 52083, 52084, 52086, 52092, 52096, 52103, 52105, 52107, 52109, 52115, 52117, 52123, 52127, 52131, 52133, 52135, 52139, 52143, 52145, 52149, 52151, 52155, 52157, 52165, 52167, 52169, 52179, 52183, 52187, 52191, 52195, 52197, 52199, 52201, 52205, 52207, 52209, 52211, 52215, 52217, 52220, 52222, 52228, 52230, 52233, 52235, 52240, 52242, 52244, 52247, 52249, 52256, 52263, 52268, 52270, 52273, 52276, 52281, 52283, 52290, 52297, 52302, 52304, 52307, 52311, 52313, 52316, 52318, 52322, 52325, 52328, 52330, 52337, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52370, 52373, 52376, 52378, 52385, 52388, 52393, 52395, 52397, 52399, 52402, 52404, 52409, 52412, 52414, 52417, 52419, 52422, 52424, 52428, 52431, 52436, 52441, 52443, 52448, 52453, 52457, 52460, 52462, 52465, 52467, 52470, 52472, 52475, 52480, 52482, 52489, 52491, 52494, 52503, 52512, 52515, 52518, 52519, 52524) 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: Hamlet

Cast
Role: Horatio Actor: Holland

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Liar

Song: As17991228

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Kenrick Actor: Holland

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Humourist

Song: As17991228

Performances

Mainpiece Title: A Trip To Scarborough

Cast
Role: Townly Actor: Holland

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Apprentice

Song: As17991228

Performances

Mainpiece Title: The Stranger

Cast
Role: Count Wintersen Actor: Holland

Afterpiece Title: The Ring; or, Love Me for Myself

Music: As17991127

Dance: As17991127

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Shipwreck

Song: As17991228

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: No Song No Supper

Song: As17991228

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Follies of a Day

Song: As17991228

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Kenrick Actor: Holland

Afterpiece Title: Of Age To-morrow

Performances

Mainpiece Title: The Stranger

Cast
Role: Count Wintersen Actor: Holland

Afterpiece Title: Of Age To-morrow

Music: As17991127

Dance: As17991127

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Sanchio Actor: Holland

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Lying Valet

Song: As17991228

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: My Grandmother

Song: As17991228

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Kenrick Actor: Holland

Afterpiece Title: Of Age To-morrow

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: A Trip To Scarborough

Cast
Role: Townly Actor: Holland

Afterpiece Title: Of Age To-morrow

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Kenrick Actor: Holland

Afterpiece Title: Of Age To-morrow

Performances

Mainpiece Title: As You Like It

Cast
Role: Jaques de Boys Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991001

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Of Age To-morrow

Song: As17991228