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, 29745, 29749, 29756, 29758, 29760, 29768, 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, 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, 33810, 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, 34224, 34229, 34232, 34234, 34239, 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: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: Phaedra And Hippolitus

Cast
Role: Hippolitus Actor: Holland, 1st time

Afterpiece Title: Harlequin Ranger

Dance: TThe Market, as17571126

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Harlequin Ranger

Dance: I: The Market, as17571126

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Merope

Cast
Role: Dorilas Actor: Holland

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Amphitryon; Or, The Two Sosias

Cast
Role: Jupiter Actor: Holland, 1st time

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Roman Father

Cast
Role: Valerius Actor: Holland

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: The Roman Father

Cast
Role: Valerius Actor: Holland

Ballet: By Desire, The Prussian Camp. As17580120, but Officer-Blakes

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Cast
Role: Torrismond Actor: Holland, 1st time

Afterpiece Title: The Author

Performances

Mainpiece Title: The Roman Father

Cast
Role: Valerius Actor: Holland

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Roman Father

Cast
Role: Valerius Actor: Holland

Afterpiece Title: The Englishman in Paris

Performances

Mainpiece Title: The Tempest

Cast
Role: Ferdinand Actor: Holland

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Agis

Cast
Role: Rhesus Actor: Holland

Performances

Mainpiece Title: Agis

Cast
Role: Rhesus Actor: Holland

Performances

Mainpiece Title: Agis

Cast
Role: Rhesus Actor: Holland

Performances

Mainpiece Title: Agis

Cast
Role: Rhesus Actor: Holland

Performances

Mainpiece Title: Agis

Cast
Role: Rhesus Actor: Holland

Performances

Mainpiece Title: Agis

Cast
Role: Rhesus Actor: Holland

Performances

Mainpiece Title: The Winter's Tale

Cast
Role: Florizel Actor: Holland

Afterpiece Title: The Frenchified Lady never in Paris

Song: (BBy Desire,)Cymon and Iphigenia-Beard