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 Castle-spectre

Cast
Role: Kenrick Actor: Holland

Afterpiece Title: The Shipwreck

Song: End: the Fishing Duet from Don Juan-Miss Arne, Miss Wentworth

Performances

Mainpiece Title: The Castle Of Montval

Cast
Role: Count of Montval Actor: Holland

Afterpiece Title: The Adopted Child

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: My Grandmother

Song: Vocal Parts-Kelly, Sedgwick, Dignum, Trueman, Danby, Brown, Cook, Tett, Caulfield Jun., Sawyer, Danby Jun., Aylmer, Willoughby, Bardoleau, Clark, Mead, Elliot, Ms Crouch, Ms DeCamp, Ms Stephens, Ms Leak, Ms Dufour, Ms Arne, Ms Menage, Ms Roffey, Ms Menage Jun., Ms Jackson, Ms Wentworth, Ms Chippendale, Ms Jacobs, Ms Butler, Ms Bowyer, Ms Williams, Ms Saunders, Ms Gaudry, Ms Benson, Mrs Illingworth, Mrs Coates

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Deaf Lover

Song: As17990524

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Virgin Unmask'd

Song: As17990524

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Apprentice

Song: As17990524

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Humourist

Song: Vocal Parts, as17990524, but Mrs _Illingworth, Mrs _Coates

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Purse; or, Benevolent Tar

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Sylvester Daggerwood

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Shipwreck

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Virgin Unmask'd

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Wedding Day

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Apprentice

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Humourist

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Prize

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The First Floor

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Shipwreck

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: Katharine and Petruchio

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Adopted Child

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Purse

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: High Life below Stairs

Dance: As17980920

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Irish Widow

Cast
Role: Nephew Actor: Holland

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Apprentice

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Centinel Actor: Holland

Afterpiece Title: The Adopted Child

Song: As17990529