SELECT * FROM london_stages WHERE eventid IN (19554, 19575, 19609, 22843, 22845, 22856, 22862, 22868, 22870, 22872, 22873, 22876, 22879, 22882, 22899, 22902, 22905, 22907, 22910, 22913, 22935, 22941, 22964, 22967, 22975, 22986, 23004, 23007, 23017, 23022, 23026, 23044, 23046, 23049, 23055, 23058, 23062, 23065, 23067, 23070, 23079, 23084, 23093, 23097, 23100, 23103, 23110, 23113, 23116, 23121, 23124, 23132, 23136, 23142, 23168, 23171, 23175, 23178, 23186, 23206, 23214, 23216, 23219, 23223, 23225, 23230, 23233, 23237, 23253, 23256, 23258, 23274, 23280, 23295, 23300, 23302, 23315, 23317, 23345, 23349, 23351, 23363, 23377, 23380, 23389, 23409, 23416, 23419, 23422, 23425, 23428, 23433, 23436, 23438, 23441, 23445, 23448, 23451, 23457, 23505, 23509, 23517, 23520, 23527, 23542, 23545, 23557, 23560, 23593, 23597, 23600, 23603, 23613, 23621, 23624, 23632, 23636, 23639, 23655, 23658, 23661, 23668, 23671, 23674, 23677, 23680, 23692, 23698, 23705, 23708, 23713, 23735, 23739, 23743, 23751, 23771, 23774, 23777, 23783, 23794, 23799, 23825, 23829, 23839, 23841, 23857, 23865, 23867, 23870, 23891, 23896, 23903, 23905, 23906, 23907, 23908, 23910, 23915, 23918, 23926, 23929, 23931, 23933, 23943, 23950, 23962, 23966, 23993, 23994, 23996, 24005, 24008, 24010, 24014, 24016, 24023, 24024, 24033, 24044, 24045, 24049, 24061, 24083, 24088, 24089, 24092, 24094, 24097, 24098, 24099, 24102, 24103, 24106, 24109, 24112, 24118, 24121, 24126, 24142, 24145, 24150, 24161, 24165, 24169, 24177, 24179, 24181, 24184, 24190, 24194, 24204, 24207, 24222, 24225, 24231, 24235, 24239, 24247, 24251, 24257, 24260, 24262, 24265, 24271, 24319, 24325, 24330, 24335, 24348, 24349, 24352, 24360, 24361, 24364, 24369, 24382, 24384, 24386, 24390, 24396, 24401, 24404, 24415, 24419, 24421, 24423, 24426, 24431, 24434, 24445, 24449, 24452, 24455, 24458, 24461, 24467, 24469, 24478, 24481, 24483, 24486, 24489, 24494, 24506, 24516, 24522, 24531, 24535, 24537, 24539, 24541, 24545, 24548, 24551, 24553, 24555, 24557, 24560, 24562, 24565, 24587, 24626, 24633, 24648, 24658, 24668, 24671, 24686, 24691, 24696, 24705, 24710, 24719, 24722, 24732, 24746, 24766, 24874, 24883, 24895, 24897, 24899, 24910, 24921, 24951, 24977, 24985, 24988, 25011, 25016, 25023, 25025, 25027, 25030, 25032, 25034, 25036, 25039, 25041, 25043, 25048, 25058, 25060, 25062, 25069, 25075, 25082, 25087, 25089, 25091, 25095, 25099, 25105, 25107, 25109, 25111, 25118, 25129, 25132, 25139, 25141, 25147, 25149, 25160, 25169, 25173, 25176, 25179, 25184, 25191, 25193, 25198, 25203, 25205, 25207, 25211, 25214, 25217, 25219, 25225, 25233, 25241, 25250, 25256, 25268, 25272, 25274, 25276, 25339, 25341, 25343, 25345, 25347, 25349, 25351, 25353, 25355, 25357, 25359, 25361, 25367, 25371, 25373, 25376, 25382, 25384, 25386, 25388, 25390, 25396, 25402, 25404, 25406, 25408, 25410, 25412, 25417, 25419, 25421, 25423, 25426, 25432, 25434, 25436, 25438, 25440, 25442, 25444, 25448, 25450, 25452, 25454, 25456, 25458, 25464, 25468, 25474, 25476, 25478, 25493, 25495, 25497, 25499, 25501, 25503, 25505, 25507, 25509, 25513, 25515, 25519, 25523, 25525, 25527, 25529, 25531, 25533, 25536, 25538, 25540, 25542, 25546, 25553, 25555, 25557, 25565, 25569, 25571, 25573, 25575, 25577, 25583, 25586, 25588, 25590, 25593, 25596, 25598, 25602, 25605, 25608, 25610, 25615, 25619, 25621, 25623, 25626, 25629, 25632, 25634, 25642, 25644, 25646, 25648, 25651, 25653, 25661, 25663, 25666, 25672, 25674, 25676, 25679, 25681, 25683, 25685, 25687, 25691, 25693, 25695, 25707, 25711, 25714, 25758, 25762, 25765, 25771, 25775, 25777, 25781, 25785, 25789, 25791, 25799, 25803, 25805, 25807, 25809, 25811, 25813, 25819, 25823, 25826, 25828, 25832, 25834, 25837, 25839, 25847, 25849, 25851, 25853, 25855, 25860, 25862, 25864, 25866, 25870, 25872, 25878, 25883, 25890, 25892, 25894, 25903, 25906, 25908, 25910, 25915, 25919, 25924, 25926, 25929, 25931, 25936, 25940, 25942, 25946, 25951, 25953, 25955, 25957, 25960, 25962, 25964, 25968, 25970, 25972, 25978, 25981, 25983, 25985, 25991, 25996, 26004, 26023, 26033, 26037, 26039, 26042, 26047, 26050, 26052, 26056, 26062, 26068, 26073, 26079, 26084, 26089, 26092, 26095, 26100, 26105, 26108, 26111, 26113, 26116, 26121, 26126, 26131, 26136, 26138, 26140, 26145, 26147, 26151, 26155, 26157, 26160, 26161, 26171, 26176, 26192, 26201, 26204, 26206, 26208, 26216, 26220, 26222, 26224, 26226, 26228, 26230, 26232, 26236, 26238, 26240, 26242, 26244, 26250, 26252, 26254, 26259, 26266, 26268, 26271, 26273, 26278, 26283, 26285, 26288, 26293, 26297, 26301, 26309, 26312, 26315, 26324, 26330, 26333, 26336, 26339, 26345, 26351, 26356, 26359, 26362, 26372, 26374, 26377, 26379, 26382, 26384, 26394, 26402, 26404, 26409, 26417, 26432, 26435, 26437, 26442, 26447, 26450, 26452, 26455, 26457, 26462, 26465, 26467, 26470, 26473, 26476, 26479, 26482, 26485, 26488, 26491, 26494, 26497, 26500, 26505, 26509, 26512, 26518, 26522, 26524, 26529, 26536, 26542, 26546, 26549, 26555, 26559, 26562, 26568, 26571, 26574, 26576, 26578, 26583, 26587, 26593, 26595, 26598, 26602, 26607, 26611, 26615, 26619, 26623, 26625, 26630, 26632, 26640, 26655, 26670, 26678, 26680, 26682, 26684, 26686, 26692, 26698, 26700, 26704, 26708, 26710, 26712, 26716, 26720, 26722, 26724, 26728, 26734, 26739, 26741, 26743, 26745, 26750, 26755, 26759, 26767, 26771, 26776, 26778, 26781, 26783, 26787, 26792, 26795, 26797, 26799, 26801, 26806, 26815, 26818, 26820, 26822, 26830, 26835, 26839, 26844, 26849, 26853, 26858, 26863, 26867, 26872, 26875, 26877, 26879, 26886, 26889, 26893, 26897, 26904, 26920, 26924, 26929, 26934, 26938, 26941, 26943, 26945, 26950, 26956, 26964, 26971, 26975, 26979, 26983, 26992, 26995, 26998, 27004, 27009, 27013, 27016, 27020, 27023, 27027, 27031, 27035, 27037, 27040, 27046, 27048, 27052, 27054, 27057, 27062, 27067, 27072, 27078, 27080, 27082, 27088, 27103, 27106, 27156, 27165, 27175, 27178, 27190, 27197, 27201, 27203, 27205, 27207, 27209, 27215, 27219, 27221, 27225, 27227, 27229, 27231, 27233, 27235, 27244, 27250, 27253, 27255, 27258, 27260, 27268, 27282, 27284, 27298, 27300, 27302, 27304, 27310, 27313, 27315, 27317, 27319, 27328, 27335, 27341, 27343, 27346, 27349, 27351, 27354, 27362, 27375, 27377, 27380, 27387, 27395, 27412, 27415, 27419, 27427, 27430, 27435, 27437, 27446, 27456, 27459, 27463, 27468, 27471, 27473, 27477, 27480, 27489, 27492, 27495, 27497, 27502, 27506, 27509, 27512, 27517, 27521, 27524, 27526, 27528, 27530, 27532, 27537, 27539, 27542, 27544, 27547, 27549, 27553, 27556, 27562, 27568, 27571, 27573, 27576, 27580, 27585, 27587, 27595, 27597, 27600, 27602, 27605, 27607, 27609, 27613, 27615, 27618, 27622, 27627, 27630, 27668, 27678, 27683, 27686, 27689, 27693, 27695, 27697, 27703, 27705, 27707, 27709, 27711, 27713, 27717, 27719, 27721, 27723, 27725, 27727, 27736, 27738, 27740, 27745, 27749, 27751, 27755, 27758, 27764, 27771, 27773, 27776, 27780, 27782, 27785, 27790, 27792, 27794, 27796, 27799, 27802, 27807, 27811, 27814, 27818, 27820, 27823, 27825, 27830, 27834, 27837, 27858, 27862, 27865, 27868, 27873, 27877, 27880, 27883, 27885, 27890, 27897, 27900, 27903, 27906, 27909, 27911, 27914, 27917, 27919, 27921, 27923, 27928, 27933, 27935, 27939, 27941, 27943, 27946, 27948, 27950, 27953, 27955, 27959, 27963, 27966, 27968, 27973, 27976, 27979, 27982, 27987, 27993, 27996, 28010, 28012, 28017, 28022, 28025, 28028, 28032, 28036, 28044, 28046, 28048, 28050, 28053, 28055, 28060, 28063, 28068, 28077, 28082, 28087, 28091, 28095, 28100, 28103, 28110, 28141, 28145, 28147, 28149, 28153, 28155, 28157, 28161, 28163, 28165, 28167, 28169, 28173, 28175, 28177, 28179, 28181, 28183, 28188, 28192, 28196, 28200, 28206, 28212, 28226, 28228, 28230, 28236, 28238, 28242, 28244, 28248, 28252, 28254, 28256, 28259, 28261, 28264, 28266, 28269, 28272, 28276, 28279, 28284, 28286, 28290, 28292, 28296, 28298, 28300, 28302, 28307, 28311, 28318, 28323, 28325, 28327, 28330, 28339, 28341, 28344, 28346, 28351, 28355, 28358, 28374, 28379, 28382, 28385, 28390, 28394, 28399, 28404, 28410, 28412, 28423, 28435, 28438, 28442, 28445, 28448, 28450, 28455, 28460, 28463, 28465, 28469, 28473, 28479, 28481, 28483, 28485, 28487, 28490, 28495, 28497, 28499, 28502, 28505, 28507, 28510, 28512, 28514, 28516, 28522, 28525, 28527, 28532, 28548, 28550, 28560, 28564, 28622, 28629, 28634, 28636, 28639, 28643, 28645, 28646, 28656, 28665, 28674, 28676, 28680, 28687, 28692, 28695, 28708, 28713, 28718, 28720, 28727, 28729, 28734, 28736, 28738, 28741, 28748, 28750, 28752, 28755, 28757, 28760, 28764, 28766, 28769, 28774, 28776, 28778, 28780, 28783, 28785, 28789, 28791, 28798, 28808, 28814, 28816, 28819, 28821, 28824, 28826, 28840, 28842, 28845, 28848, 28850, 28853, 28855, 28858, 28862, 28865, 28867, 28870, 28872, 28875, 28877, 28880, 28883, 28886, 28888, 28892, 28894, 28897, 28899, 28903, 28906, 28909, 28911, 28916, 28920, 28923, 28927, 28931, 28940, 28943, 28947, 28951, 28957, 28959, 28961, 28965, 28974, 28977, 28982, 28984, 28987, 28989, 28992, 28994, 28996, 29001, 29006, 29008, 29015, 29017, 29020, 29026, 29029, 29032, 29039, 29051, 29055, 29060, 29063, 29160, 29166, 29168, 29170, 29173, 29183, 29192, 29194, 29196, 29198, 29200, 29202, 29206, 29210, 29212, 29214, 29216, 29218, 29220, 29222, 29226, 29228, 29233, 29236, 29245, 29247, 29251, 29253, 29255, 29263, 29265, 29269, 29272, 29274, 29277, 29279, 29281, 29283, 29286, 29288, 29290, 29292, 29294, 29296, 29299, 29301, 29303, 29305, 29307, 29309, 29313, 29318, 29321, 29323, 29326, 29328, 29330, 29335, 29337, 29339, 29343, 29345, 29347, 29350, 29353, 29355, 29358, 29360, 29362, 29364, 29373, 29377, 29382, 29385, 29387, 29391, 29394, 29396, 29399, 29401, 29403, 29406, 29408, 29411, 29413, 29415, 29417, 29420, 29422, 29425, 29435, 29443, 29456, 29458, 29466, 29469, 29471, 29474, 29482, 29485, 29489, 29493, 29497, 29500, 29504, 29507, 29509, 29511, 29514, 29516, 29519, 29523, 29525, 29528, 29530, 29533, 29536, 29540, 29545, 29548, 29550, 29554, 29557, 29561, 29565, 29569, 29572, 29575, 29584, 29594, 29727, 29730, 29746, 29761, 29767, 29785, 29787, 29800, 29814, 29822, 29824, 29827, 29829, 29831, 29834, 29836, 29843, 29845, 29847, 29849, 29854, 29856, 29869, 29871, 29873, 29875, 29878, 29882, 29889, 29891, 29893, 29895, 29897, 29900, 29915, 29935, 29942, 29946, 29959, 29963, 29970, 29972, 29976, 29979, 29982, 29984, 29988, 29995, 30001, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30034, 30037, 30040, 30046, 30053, 30056, 30058, 30060, 30064, 30066, 30071, 30074, 30076, 30079, 30082, 30085, 30087, 30089, 30091, 30094, 30096, 30101, 30104, 30115, 30117, 30119, 30124, 30131, 30133, 30135, 30138, 30144, 30154, 30282, 30292, 30294, 30296, 30298, 30300, 30303, 30306, 30310, 30312, 30314, 30316, 30320, 30326, 30328, 30330, 30332, 30334, 30336, 30340, 30342, 30344, 30358, 30361, 30370, 30372, 30375, 30377, 30380, 30384, 30391, 30394, 30396, 30398, 30404, 30406, 30409, 30411, 30414, 30419, 30421, 30425, 30428, 30433, 30439, 30442, 30444, 30449, 30453, 30456, 30464, 30471, 30505, 30508, 30521, 30527, 30538, 30543, 30558, 30562, 30565, 30567, 30570, 30576, 30579, 30581, 30586, 30588, 30590, 30593, 30595, 30602, 30604, 30607, 30609, 30615, 30620, 30625, 30630, 30632, 30639, 30645, 30647, 30649, 30652, 30654, 30657, 30661, 30663, 30669, 30673, 30681, 30683, 30685, 30689, 30786, 30792, 30794, 30797, 30802, 30811, 30815, 30817, 30819, 30821, 30825, 30827, 30829, 30835, 30837, 30839, 30841, 30848, 30853, 30855, 30861, 30863, 30868, 30871, 30873, 30879, 30881, 30883, 30885, 30892, 30894, 30901, 30903, 30906, 30908, 30911, 30913, 30915, 30917, 30920, 30923, 30925, 30927, 30929, 30931, 30934, 30936, 30938, 30941, 30943, 30945, 30948, 30951, 30953, 30957, 30959, 30962, 30965, 30967, 30970, 30972, 30974, 30977, 30980, 30982, 30984, 30986, 30988, 30990, 30992, 30994, 30996, 30999, 31002, 31004, 31008, 31010, 31013, 31016, 31018, 31022, 31036, 31127, 31180, 31224, 31267, 31332, 31334, 31336, 31338, 31341, 31343, 31347, 31353, 31363, 31367, 31371, 31373, 31379, 31381, 31383, 31385, 31388, 31392, 31400, 31402, 31404, 31406, 31408, 31414, 31416, 31420, 31423, 31427, 31431, 31433, 31436, 31438, 31442, 31446, 31454, 31458, 31466, 31497, 31509, 31532, 31534, 31554, 31559, 31572, 31590, 31646, 31681, 31685, 31721, 31732, 31750, 31754, 31757, 31772, 31828, 31830, 31832, 31838, 31840, 31846, 31852, 31858, 31860, 31894, 31922, 31964, 31980, 31992, 32001, 32006, 32027, 32042, 32046, 32050, 32055, 32067, 32072, 32087, 32089, 32132, 32137, 32159, 32161, 32165, 32172, 32185, 32188, 32207, 32212, 32214, 32222, 32225, 32230, 32236, 32253, 32255, 32316, 32318, 32322, 32326, 32331, 32340, 32357, 32359, 32363, 32365, 32371, 32373, 32391, 32402, 32406, 32417, 32429, 32438, 32443, 32465, 32467, 32480, 32491, 32529, 32620, 32643, 32654, 32659, 32665, 32686, 32699, 32714, 32725, 34797, 34803, 34819, 34821, 34824, 34826, 34828, 34831, 34834, 34836, 34837, 34839, 34840, 34841, 34843, 34844, 34846, 34848, 34849, 34850, 34851, 34852, 34853, 34854, 34857, 34858, 34859, 34860, 34861, 34863, 34864, 34865, 34867, 34868, 34869, 34871, 34872, 34873, 34875, 34876, 34878, 34879, 34880, 34881, 34883, 34955, 34989, 35045, 35062, 35102, 35184, 35274, 35319, 35335, 35342, 35347, 35357, 35359, 35364, 35365, 35370, 35376, 35380, 35382, 35385, 35387, 35397, 35400, 35403, 35418, 35421, 35424, 35432, 35434, 35443, 35450, 35454, 35458, 35462, 35470, 35471, 35473, 35475, 35477, 35482, 35484, 35486, 35492, 35595, 35889, 35940, 38866, 38893, 40203, 40283, 40309, 40426, 42282, 42387, 45470, 50952, 50992, 51023, 51056, 51094, 51125, 51127, 51129, 51134, 51137, 51141, 51146, 51167, 51208, 51330, 51342, 51353, 51359, 51364, 51367, 51369, 51371, 51377, 51380, 51480, 51483, 51489, 51497, 51504, 51507, 51510, 51512, 51515, 51516, 51518, 51523, 51524, 51526, 51528, 51542, 51558, 51564, 51572, 51576, 51580, 51584, 51597, 51606, 51611, 51614, 51623, 51630, 51633, 51635, 51638, 51640, 51642, 51649, 51658, 51663, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51705, 51709, 51712, 51715, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51793, 51805, 51810, 51821, 51824, 51835, 51840, 51842, 51846, 51853, 51858, 51860, 51870, 51884, 51889, 51892, 51901, 51903, 51926, 51928, 51941, 51952, 51956, 51966, 51968, 51970, 51972, 51982, 51984, 52061, 52063, 52065, 52073, 52075, 52076, 52078, 52080, 52088, 52091, 52095, 52098, 52101, 52111, 52113, 52119, 52125, 52129, 52139, 52147, 52151, 52157, 52173, 52177, 52179, 52181, 52183, 52185, 52189, 52195, 52197, 52203, 52205, 52209, 52213, 52222, 52244, 52247, 52252, 52254, 52285, 52293, 52307, 52337, 52342, 52346, 52349, 52352, 52354, 52358, 52361, 52364, 52370, 52373, 52376, 52382, 52390, 52397, 52399, 52404, 52417, 52419, 52422, 52424, 52428, 52431, 52436, 52438, 52441, 52455, 52457, 52462, 52475, 52477, 52482, 52485, 52496, 52500, 52503, 52505, 52508, 52510, 52512, 52521, 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: Zara

Cast
Role: Lusignan Actor: Sparks

Afterpiece Title: The Devil to Pay

Dance: As17551101

Performances

Mainpiece Title: The Earl Of Essex

Cast
Role: Burleigh Actor: Sparks

Afterpiece Title: The Cheats of Scapin

Dance: As17551101

Performances

Mainpiece Title: Theodosius

Cast
Role: Marcian Actor: Sparks

Afterpiece Title: The Lying Valet

Dance: As17551217

Performances

Mainpiece Title: Macbeth

Cast
Role: Banquo Actor: Sparks

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Capulet Actor: Sparks

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Capulet Actor: Sparks

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Capulet Actor: Sparks

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Capulet Actor: Sparks

Performances

Mainpiece Title: The Earl Of Essex

Cast
Role: Burleigh Actor: Sparks

Afterpiece Title: The Miller of Mansfield

Dance: As17560102

Performances

Mainpiece Title: King Henry Iv, Part I

Cast
Role: King Actor: Sparks

Afterpiece Title: The Lying Valet

Dance: As17551101

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Contrivances

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Virgin Unmask'd

Dance: As17551101

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Contrivances

Dance: Guerin Jun, Mlle Capdeville

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Lover His Own Rival

Dance: As17560122

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: Damon and Phillida

Dance: Granier, Miss Hilliard

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Standard Actor: Sparks

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Double Disappointment

Dance: Granier, Miss Hilliard

Performances

Mainpiece Title: Lady Jane Gray

Cast
Role: Northumberland Actor: Sparks

Afterpiece Title: The Englishman Return'd from Paris

Performances

Mainpiece Title: All For Love

Cast
Role: Ventidius Actor: Sparks

Afterpiece Title: Orpheus and Eurydice

Dance: As17551114

Performances

Mainpiece Title: Phaedra And Hippolitus

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Clytus Actor: Sparks

Afterpiece Title: The Contrivances

Dance: As17551114

Performances

Mainpiece Title: Old Batchelor

Cast
Role: Heartwell Actor: Sparks

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101