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: Hamlet, Prince Of Denmark

Cast
Role: King Actor: Sparks

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: The Scornful Lady

Cast
Role: Traveller Actor: I. Sparks

Afterpiece Title: The Double Disappointment

Dance: II: Dance-Cooke

Performances

Mainpiece Title: Hamlet

Cast
Role: King Actor: Sparks

Afterpiece Title: The Virgin Unmask'd

Dance: DDance-Cooke

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Morochius Actor: Sparks

Afterpiece Title: Miss in Her Teens

Dance: IV: Dance-Cooke

Performances

Mainpiece Title: As You Like It

Cast
Role: Charles Actor: I. Sparks

Dance: I: Les Caprices de la Dance-Sga Auretti; III: Grand Ballet-Cooke, Janeton Auretti; V: Polish Dance-Cooke, Sga Auretti, Leviez, Mathews, Shawford, Royer, Pelling, Mrs Addison, Mrs Shawford, Miss Cole, Miss Thompson

Performances

Mainpiece Title: Tamerlane

Cast
Role: Omar Actor: Sparks

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: Tamerlane

Cast
Role: Omar Actor: Sparks

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: King Richard Iii

Cast
Role: Buckingham Actor: I. L? Sparks

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: Comus

Cast
Role: 1st spirit Actor: Sparks

Afterpiece Title: The Anatomist

Performances

Dance: II: The Gardner's Revels-Cooke, Mathews, Mrs Addison

Song: fter the dance, an Entertainment of singing and dancing call'd The Sailors Rendezvous at Portsmouth-. [See17471116]

Performances

Mainpiece Title: Hamlet

Cast
Role: King Actor: Sparks

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: As You Like It

Cast
Role: Charles Actor: I. Sparks

Afterpiece Title: The Lying Valet

Dance: I: The Gardners Revels, as17471117; V: Polish Dance, as17471102

Performances

Mainpiece Title: King Henry V

Cast
Role: Constable Actor: Sparks
Role: Bardolph Actor: I. Sparks

Performances

Mainpiece Title: King Henry V

Cast
Role: Constable Actor: Sparks
Role: Bardolph Actor: I. Sparks

Performances

Mainpiece Title: King Henry V

Cast
Role: Constable Actor: Sparks
Role: Bardolph Actor: I. Sparks

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Cast
Role: Caliban Actor: I. Sparks

Performances

Mainpiece Title: The Tempest

Cast
Role: Caliban Actor: I. Sparks

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Tempest

Cast
Role: Caliban Actor: I. Sparks

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: King Henry V

Cast
Role: Constable Actor: Sparks
Role: Bardolph Actor: I. Sparks

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Morochius Actor: Sparks

Afterpiece Title: Miss in Her Teens

Dance: III: Tambourine-Anne Auretti; IV: Savoyards, as17471215; V: Dutch Dance, as17471128