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: The Earl Of Warwick

Cast
Role: Earl of Warwick Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: Zara

Cast
Role: Osman Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: The Country Girl

Cast
Role: Moody Actor: Holland

Afterpiece Title: Queen Mab

Dance: II: A New Comic Dance-Grimaldi, Duquesney, Rollet, Mrs King

Performances

Mainpiece Title: Cymbeline

Cast
Role: Iachimo Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: The Orphan Of China

Cast
Role: Zamti Actor: Holland

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Young Bevil Actor: Holland

Afterpiece Title: Harlequin's Invasion

Dance: II: A New Comic Dance, call'd The Gardners Holiday-Mr Shuter (his 1st appearance), Sga Giorgi

Performances

Mainpiece Title: The Orphan

Cast
Role: Chamont Actor: Holland

Afterpiece Title: Harlequin's Invasion

Dance: I: Gardners Holiday, as17671120

Performances

Mainpiece Title: The School For Lovers

Cast
Role: Sir John Dorilant Actor: Holland

Afterpiece Title: Lethe

Dance: II: The Gardners Holiday, as17671120; End: Hearts of Oak, as17671022

Performances

Mainpiece Title: The Mourning Bride

Cast
Role: Osmyn Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Dance: End: The Gardners Holiday, as17671120

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Sir John Melvil Actor: Holland

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Plain Dealer

Cast
Role: Plain Dealer Actor: Holland

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Tamerlane

Cast
Role: Bajazet Actor: Holland

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland
Role: Prologue Actor: Holland

Afterpiece Title: The Old Maid

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: Flora; or, Hob in the Well

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: A Peep behind the Curtain

Performances

Mainpiece Title: the Widow'd Wife

Cast
Role: Sir John Melvil Actor: Holland

Afterpiece Title: [The Lyar

Performances

Mainpiece Title: Venice Preserved

Cast
Role: Pierre Actor: Holland

Afterpiece Title: The Lyar

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Young Bevil Actor: Holland

Afterpiece Title: The Deuce Is in Him

Dance: End: Hearts of Oak, as17671022

Performances

Mainpiece Title: The Widow'd Wife

Cast
Role: General Melmoth Actor: Holland

Afterpiece Title: High Life below Stairs

Dance: End: The Lilliputian Camp, as17671202

Performances

Mainpiece Title: The Earl Of Essex

Cast
Role: Essex Actor: Holland

Afterpiece Title: The Elopement