SELECT * FROM london_stages WHERE eventid IN (19723, 19725, 19727, 19729, 19731, 19733, 19735, 19739, 19743, 19747, 19759, 19803, 19808, 19858, 19860, 19861, 19863, 19865, 19867, 19868, 19871, 19888, 19890, 19895, 19897, 19899, 19902, 19903, 19906, 19908, 19911, 19913, 19916, 19918, 19921, 20051, 20065, 20084, 20097, 20106, 20190, 20193, 20196, 20199, 21882, 21887, 21896, 21898, 21901, 21903, 21904, 21906, 21913, 21939, 21943, 21948, 21980, 22029, 22048, 22095, 22163, 22190, 22202, 22321, 22344, 22439, 22461, 22489, 22561, 22635, 22638, 22643, 22646, 22649, 22653, 22656, 22659, 22664, 22672, 22733, 22757, 22797, 22926, 22935, 22938, 22947, 22956, 22958, 22961, 22967, 22970, 22986, 23002, 23007, 23011, 23022, 23026, 23029, 23032, 23035, 23037, 23040, 23044, 23046, 23049, 23055, 23058, 23067, 23087, 23090, 23106, 23116, 23118, 23127, 23153, 23156, 23162, 23181, 23186, 23191, 23195, 23216, 23223, 23225, 23230, 23242, 23244, 23247, 23251, 23253, 23256, 23258, 23261, 23264, 23268, 23274, 23277, 23280, 23283, 23292, 23294, 23295, 23297, 23300, 23302, 23315, 23317, 23345, 23349, 23351, 23353, 23356, 23363, 23369, 23373, 23377, 23380, 23382, 23383, 23387, 23389, 23393, 23396, 23400, 23405, 23409, 23416, 23419, 23422, 23425, 23433, 23445, 23451, 23457, 23480, 23501, 23509, 23542, 23545, 23557, 23560, 23565, 23568, 23576, 23581, 23584, 23587, 23590, 23593, 23597, 23600, 23603, 23606, 23613, 23616, 23618, 23629, 23636, 23639, 23655, 23661, 23668, 23671, 23674, 23689, 23692, 23698, 23702, 23705, 23716, 23720, 23724, 23727, 23730, 23739, 23743, 23755, 23758, 23767, 23771, 23783, 23791, 23804, 23825, 23829, 23832, 23836, 23839, 23841, 23846, 23850, 23852, 23861, 23865, 23875, 23896, 23897, 23915, 23917, 23920, 23926, 23929, 23931, 23933, 23936, 23943, 23947, 23962, 23966, 23970, 23973, 23977, 23980, 23982, 23983, 23985, 23993, 23994, 23996, 24000, 24014, 24023, 24024, 24041, 24044, 24045, 24049, 24051, 24061, 24076, 24083, 24118, 24126, 24133, 24150, 24156, 24161, 24165, 24177, 24179, 24194, 24197, 24204, 24207, 24225, 24231, 24239, 24265, 24267, 24292, 24298, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24314, 24315, 24316, 24319, 24322, 24325, 24328, 24330, 24332, 24340, 24349, 24363, 24365, 24378, 24381, 24383, 24389, 24395, 24403, 24420, 24422, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24468, 24471, 24477, 24485, 24488, 24493, 24499, 24503, 24505, 24517, 24521, 24526, 24534, 24536, 24567, 24577, 24580, 24590, 24641, 24644, 24649, 24660, 24667, 24679, 24685, 24692, 24698, 24704, 24721, 24754, 24758, 24761, 24769, 24777, 24787, 24790, 24862, 24865, 24875, 24881, 24885, 24888, 24892, 24894, 24896, 24898, 24909, 24918, 24920, 24923, 24925, 24933, 24935, 24937, 24939, 24944, 24949, 24960, 24966, 24968, 24973, 24978, 24993, 24996, 25029, 25033, 25035, 25038, 25040, 25042, 25044, 25047, 25049, 25057, 25059, 25061, 25063, 25072, 25092, 25094, 25096, 25098, 25104, 25108, 25110, 25112, 25114, 25117, 25123, 25125, 25128, 25134, 25146, 25148, 25157, 25197, 25213, 25224, 25227, 25237, 25249, 25252, 25259, 25271, 25282, 25305, 25386, 25388, 25398, 25400, 25404, 25406, 25408, 25410, 25417, 25419, 25421, 25423, 25436, 25438, 25440, 25442, 25444, 25448, 25450, 25466, 25468, 25470, 25482, 25493, 25519, 25525, 25531, 25533, 25536, 25540, 25551, 25553, 25569, 25579, 25588, 25590, 25615, 25619, 25623, 25638, 25640, 25646, 25653, 25663, 25668, 25683, 25689, 25707, 25758, 25765, 25771, 25781, 25785, 25789, 25791, 25799, 25803, 25805, 25807, 25813, 25819, 25837, 25890, 25894, 25906, 25910, 25915, 25936, 25951, 25957, 25964, 25983, 25985, 26033, 26037, 26047, 26050, 26052, 26062, 26068, 26095, 26100, 26105, 26113, 26116, 26126, 26140, 26145, 26147, 26157, 26160, 26161, 26176, 26190, 26199, 26206, 26208, 26216, 26222, 26230, 26240, 26242, 26244, 26250, 26254, 26259, 26264, 26266, 26275, 26278, 26285, 26301, 26303, 26309, 26312, 26315, 26318, 26321, 26324, 26327, 26330, 26353, 26359, 26362, 26374, 26377, 26379, 26382, 26384, 26394, 26404, 26407, 26414, 26417, 26419, 26422, 26424, 26432, 26435, 26440, 26442, 26445, 26460, 26465, 26470, 26473, 26476, 26479, 26482, 26485, 26488, 26491, 26494, 26497, 26500, 26502, 26505, 26512, 26518, 26524, 26526, 26529, 26533, 26538, 26546, 26549, 26559, 26564, 26568, 26581, 26593, 26598, 26602, 26607, 26609, 26611, 26615, 26617, 26619, 26623, 26625, 26630, 26632, 26646, 26650, 26655, 26659, 26673, 26678, 26680, 26682, 26684, 26686, 26688, 26690, 26692, 26700, 26704, 26706, 26712, 26720, 26722, 26724, 26726, 26750, 26757, 26759, 26767, 26771, 26776, 26787, 26792, 26795, 26797, 26799, 26806, 26813, 26830, 26835, 26839, 26872, 26875, 26877, 26879, 26886, 26889, 26893, 26897, 26899, 26934, 26956, 26964, 26971, 26979, 26983, 26992, 26995, 27004, 27016, 27020, 27027, 27033, 27035, 27040, 27052, 27057, 27059, 27064, 27078, 27082, 27088, 27096, 27106, 27170, 27214, 27230, 27238, 27240, 27249, 27254, 27259, 27264, 27269, 27278, 27283, 27297, 27318, 27324, 27327, 27330, 27332, 27334, 27337, 27345, 27423, 27429, 27445, 27452, 27488, 27516, 27533, 27555, 27558, 27561, 27575, 27581, 27591, 27621, 27633, 27676, 27679, 27680, 27682, 27687, 27690, 27692, 27694, 27700, 27722, 27728, 27732, 27735, 27763, 27765, 27777, 27779, 27784, 27786, 27798, 27806, 27815, 27827, 27916, 27920, 27942, 28009, 28016, 28041, 28054, 28099, 28102, 28131, 28140, 28142, 28146, 28150, 28152, 28154, 28156, 28160, 28162, 28164, 28168, 28172, 28178, 28182, 28187, 28193, 28199, 28201, 28205, 28211, 28213, 28215, 28217, 28219, 28223, 28229, 28231, 28233, 28235, 28241, 28243, 28249, 28253, 28255, 28258, 28263, 28268, 28271, 28273, 28280, 28283, 28285, 28293, 28301, 28303, 28306, 28308, 28312, 28320, 28324, 28326, 28340, 28343, 28345, 28348, 28350, 28357, 28361, 28363, 28367, 28370, 28376, 28381, 28384, 28386, 28391, 28393, 28395, 28398, 28400, 28403, 28406, 28419, 28428, 28434, 28437, 28454, 28462, 28464, 28468, 28484, 28486, 28496, 28498, 28504, 28509, 28511, 28513, 28521, 28526, 28534, 28536, 28541, 28556, 28565, 28609, 28616, 28619, 28628, 28633, 28635, 28638, 28651, 28655, 28659, 28660, 28667, 28677, 28705, 28709, 28714, 28719, 28721, 28733, 28735, 28742, 28749, 28751, 28754, 28756, 28759, 28763, 28768, 28770, 28773, 28775, 28779, 28784, 28786, 28797, 28807, 28815, 28820, 28828, 28834, 28839, 28847, 28849, 28852, 28864, 28869, 28879, 28939, 28950, 28958, 28962, 28964, 28967, 28971, 28973, 28978, 28988, 28991, 28993, 28997, 29002, 29005, 29009, 29019, 29031, 29036, 29043, 29046, 29050, 29062, 29068, 29070, 29071, 36499, 37807, 37829, 37831, 37841, 37849, 37880, 37882, 37887, 37889, 37925, 37933, 37943, 37954, 37958, 37964, 37967, 37969, 37980, 37987, 38011, 38021, 38032, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38076, 38083, 38088, 38091, 38093, 38102, 38105, 38112, 38128, 38143, 38148, 38151, 38158, 38165, 38188, 38190, 38192, 38197, 38216, 38221, 38313, 38317, 38330, 38336, 38345, 38347, 38349, 38361, 38364, 38371, 38376, 38381, 38385, 38396, 38401, 38410, 38420, 38422, 38425, 38427, 38429, 38436, 38441, 38443, 38445, 38464, 38467, 38469, 38473, 38479, 38488, 38494, 38500, 38505, 38523, 38565, 38568, 38570, 38573, 38608, 38644, 38653, 38673, 38689, 38703, 38716, 38726, 38736, 38741, 38750, 38785, 39937, 39947, 39953, 39957, 39973, 39975, 39977, 39979, 39982, 39984, 39986, 39987, 39988, 39989, 39995, 40000, 40005, 40009, 40012, 40018, 40462, 40467, 40474, 40488, 40508, 40509, 40510, 40512, 40513, 40516, 40517, 40519, 40521, 40522, 40523, 40524, 40527, 40528, 40531, 40533, 40534, 40535, 40537, 40541, 40545, 40554, 40557, 40558, 41006, 41015, 41019, 41020, 41025, 41026, 41031, 41035, 41055, 41060, 41065, 41066, 41067, 41073, 41075, 41077, 41081, 41094, 41096, 41097, 41102, 41103, 41104, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41579, 41580, 41582, 41585, 41586, 41588, 41590, 41594, 41595, 41598, 41601, 41603, 41604, 41607, 41609, 41610, 41612, 41613, 41615, 41617, 41618, 41620, 41621, 41624, 41626, 41628, 41631, 41632, 41633, 41635, 41637, 41638, 41639, 41640, 41642, 41644, 41645, 41646, 41649, 41650, 41652, 41661, 41668, 41670, 41673, 41674, 41675, 41676, 41678, 41680, 41681, 41682, 41685, 42168, 42170, 42171, 42173, 42175, 42176, 42179, 42181, 42183, 42184, 42186, 42187, 42191, 42194, 42195, 42198, 42203, 42205, 42206, 42207, 42211, 42214, 42215, 42216, 42217, 42218, 42221, 42222, 42223, 42224, 42225, 42226, 42227, 42229, 42232, 42236, 42237, 42238, 42239, 42240, 42241, 42243, 42245, 42247, 42248, 42254, 42255, 42259, 42261, 42262, 42265, 42268, 42271, 42456, 42750, 42753, 42755, 42758, 42760, 42762, 42764, 42765, 42766, 42767, 42768, 42770, 42772, 42773, 42774, 42775, 42778, 42780, 42782, 42783, 42787, 42788, 42790, 42791, 42792, 42795, 42797, 42798, 42799, 42800, 42801, 42802, 42804, 42805, 42807, 42808, 42815, 42817, 42818, 42819, 42821, 42825, 42827, 42829, 42830, 42831, 42833, 42834, 42835, 42837, 42841, 42843, 42847, 42849, 43323, 43326, 43329, 43330, 43332, 43333, 43337, 43339, 43340, 43346, 43350, 43352, 43355, 43357, 43380, 43381, 43387, 43390, 43398, 43399, 43401, 43402, 43406, 43407, 43410, 43411, 43415, 43417, 43420, 43423, 43426, 43432, 43437, 43909, 43916, 43927, 43932, 43936, 43946, 43953, 43957, 43960, 43963, 43968, 43969, 43971, 43972, 43983, 43984, 43987, 43994, 43999, 44001, 44003, 44005, 44011, 44012, 44015, 44016, 44017, 44019, 44021, 44023, 44024, 44025, 44481, 44492, 44493, 44501, 44506, 44515, 44519, 44525, 44526, 44527, 44532, 44533, 44538, 44542, 44566, 44569, 44570, 44572, 44579, 44580, 44582, 44583, 44585, 44984, 44990, 44996, 45002, 45008, 45040, 45045, 45051, 45062, 45067, 45071, 45074, 45082, 45084, 45089, 45091, 45093, 45098, 45099, 45101, 45104, 45105, 45107, 45109, 45110, 45111, 45114, 45115, 45117, 45118, 45121, 45122, 45123, 45124, 45128, 45129, 45130, 45131, 45132, 45133, 45134, 45597, 45600, 45604, 45605, 45611, 45616, 45619, 45625, 45627, 45629, 45632, 45633, 45635, 45636, 45637, 45638, 45639, 45641, 45642, 45643, 45646, 45647, 45648, 45652, 45653, 45654, 45655, 45656, 45657, 45658, 45659, 45660, 45664, 45666, 45668, 45673, 45676, 45677, 45678, 45679, 45680, 45682, 45684, 45686, 45687, 45688, 45689, 45690, 46104, 46116, 46128, 46138, 46149, 46179, 46180, 46181, 46183, 46185, 46187, 46190, 46191, 46193, 46194, 46196, 46199, 46200, 46201, 46202, 46204, 46205, 46207, 46208, 46209, 46210, 46211, 46212, 46213, 46215, 46216, 46217, 46218, 46219, 46223, 46224, 46225, 46226, 46227, 46228, 46229, 46230, 46235, 46236, 46237, 46240, 46241, 46244, 46245, 46246, 46247, 46248, 46249, 46251, 46254, 46255, 46256, 46257, 46258, 46259, 46735, 46736, 46739, 46741, 46742, 46744, 46745, 46748, 46749, 46752, 46753, 46755, 46756, 46759, 46760, 46762, 46763, 46764, 46765, 46768, 46770, 46773, 46775, 46776, 46777, 46778, 46779, 46780, 46782, 46783, 46784, 46785, 46786, 46787, 46789, 46791, 46792, 46793, 46794, 46795, 46797, 46798, 46799, 46801, 46802, 46805, 46807, 46809, 46810, 46812, 46813, 46814, 46815, 46816, 46817, 46818, 46819, 46820, 46821, 46822, 46824, 46826, 47316, 47321, 47331, 47334, 47335, 47338, 47341, 47345, 47349, 47352, 47356, 47357, 47360, 47362, 47363, 47366, 47368, 47371, 47373, 47376, 47378, 47380, 47381, 47382, 47383, 47384, 47386, 47387, 47388, 47389, 47390, 47391, 47392, 47393, 47394, 47395, 47396, 47397, 47398, 47399, 47400, 47404, 47405, 47406, 47407, 47408, 47409, 47410, 47411, 47413, 47414, 47419, 47420, 47421, 47424, 47425, 47426, 47427, 47428, 47915, 47916, 47917, 47919, 47920, 47921, 47922, 47924, 47927, 47929, 47930, 47931, 47932, 47934, 47936, 47938, 47939, 47940, 47941, 47942, 47943, 47944, 47945, 47947, 47948, 47950, 47951, 47953, 47954, 47955, 47956, 47958, 47959, 47960, 47962, 47963, 47967, 47968, 47970, 47972, 47974, 47977, 47979, 47982, 47985, 47986, 47987, 47988, 47991, 48449, 48450, 48453, 48456, 48457, 48461, 48464, 48467, 48469, 48470, 48471, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48481, 48482, 48484, 48485, 48486, 48487, 48488, 48489, 48490, 48492, 48493, 48494, 48495, 48496, 48497, 48498, 48499, 48500, 48501, 48502, 48503, 48504, 48505, 48506, 48507, 48508, 48511, 48513, 48515, 48516, 48518, 48519, 48521, 48522, 48524, 48525, 48526, 48528, 48529, 48530, 48531, 48532, 48533, 48534, 48538, 48540, 48542, 48544, 48546, 48548, 48552, 48554, 48556, 48560, 48562, 48564, 48566, 48568, 48572, 48576, 48584, 48587, 48589, 48597, 48599, 48604, 48606, 48612, 48622, 48624, 48632, 48638, 48644, 48646, 48648, 48658, 48660, 48676, 48678, 48680, 48686, 48690, 48718, 48736, 48756, 48760, 48762, 48770, 48782, 48784, 48790, 48799, 48816, 48845, 48861, 48864, 48869, 48948, 49123, 49125, 49126, 49127, 49128, 49130, 49131, 49132, 49133, 49135, 49136, 49137, 49138, 49139, 49140, 49141, 49142, 49143, 49144, 49145, 49146, 49147, 49148, 49149, 49150, 49151, 49152, 49153, 49154, 49155, 49156, 49157, 49158, 49160, 49161, 49162, 49163, 49164, 49165, 49166, 49168, 49169, 49170, 49171, 49172, 49173, 49174, 49175, 49176, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49187, 49651, 49654, 49656, 49658, 49660, 49663, 49669, 49670, 49677, 49678, 49680, 49682, 49683, 49685, 49686, 49688, 49691, 49695, 49696, 49698, 49700, 49701, 49702, 49703, 49704, 49705, 49706, 49707, 49708, 49709, 49711, 49712, 49713, 49714, 49715, 49717, 49718, 49719, 49721, 49722, 49723, 49724, 49725, 49726, 49727, 49729, 49730, 49731, 49733, 49734, 49735, 49736, 49738, 49740, 49745, 49746, 49747, 49748, 49750, 49752, 49753, 49762, 50226, 50230, 50235, 50237, 50238, 50239, 50240, 50243, 50245, 50246, 50247, 50248, 50253, 50254, 50257, 50259, 50262, 50264, 50265, 50267, 50270, 50271, 50272, 50275, 50276, 50279, 50280, 50282, 50283, 50285, 50286, 50287, 50289, 50290, 50291, 50294, 50295, 50296, 50297, 50299, 50302, 50303, 50304, 50310, 50311, 50312, 50313, 50314, 50316, 50317, 50321, 50322, 50806, 50809, 50814, 50817, 50821, 50824, 50825, 50826, 50827, 50830, 50832, 50833, 50835, 50837, 50838, 50845, 50848, 50849, 50853, 50856, 50858, 50864, 50865, 50867, 50869, 50870, 50873, 50877, 50878, 50879, 50882, 50885, 50890, 50893, 50896, 50898, 50899, 50901, 50902, 50903, 50905, 50908, 50909, 50910, 51388, 51391, 51392, 51394, 51397, 51404, 51405, 51407, 51408, 51415, 51418, 51420, 51421, 51424, 51426, 51431, 51439, 51441, 51442, 51446, 51453, 51457, 51458, 51463, 51468, 51475, 51944, 51947, 51950, 51953, 51955, 51957, 51964, 51967, 51971, 51973, 51976, 51978, 51981, 51983, 51988, 51989, 51991, 51999, 52004, 52008, 52013, 52021, 52024, 52026, 52033, 52035, 52037, 52041, 52045, 52049, 52052) 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: Women Pleased

Cast
Role: Councellor Actor: Usher

Afterpiece Title: The Lying Valet

Song: As17431029

Dance: As17431013

Performances

Mainpiece Title: The Relapse; Or, Virtue In Danger

Cast
Role: Bull Actor: Usher

Song: As17431022

Dance: II: A New Dance, as17431013; IV: Italian Masquerade, as17431110

Performances

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

Cast
Role: Meleager Actor: Usher

Afterpiece Title: The Lying Valet

Song: As17431029

Dance: III: A New Dance, as17431015

Performances

Mainpiece Title: The Relapse

Cast
Role: Bull Actor: Usher

Afterpiece Title: The Lying Valet

Music: I: a Piece of Scotch Music-Oswald

Dance: III: As17431123

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Meleager Actor: Usher

Afterpiece Title: The Anatomist

Dance: II: As17431013

Performances

Mainpiece Title: Aesop

Cast
Role: Priest Actor: Usher

Afterpiece Title: The Lying Valet

Dance: II: Italian Masquerade-Muilment; IV: New Serious Dance-Muilment, Desse, Liviez, Mrs Walter

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth; With The Humours Of Sir John Falstaff, Justice Shallow, Ancient Pistol

Cast
Role: Gower Actor: Usher

Afterpiece Title: Columbine Courtezan

Performances

Mainpiece Title: Regulus

Cast
Role: 2nd Ambassador Actor: Usher

Performances

Mainpiece Title: The Relapse

Cast
Role: Bull Actor: Usher

Afterpiece Title: The Amorous Goddess

Performances

Mainpiece Title: The Relapse

Cast
Role: Bull Actor: Usher

Afterpiece Title: The Amorous Goddess

Dance: III: Last New Turkish Dance, as17440406

Performances

Mainpiece Title: Regulus

Cast
Role: 2nd Ambassador Actor: Usher

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Cast
Role: Soldier Actor: Usher

Afterpiece Title: The Anatomist

Song: The Favourite Cantata of Vertumnus and Pomona-Lowe

Dance: GGrand Turkish Dance-Muilment, Desse, Liviez, Miles, Baudouin, Mrs Story, Miss Thompson, Mrs Miles, Mrs Annesley

Performances

Afterpiece Title: The Amorous Goddess

Performances

Song: Lowe

Dance: Muilment

Performances

Mainpiece Title: Hamlet

Cast
Role: Marcellus Actor: Usher.

Afterpiece Title: The Anatomist

Song: Lowe

Dance: Muilment

Performances

Mainpiece Title: The Committee

Cast
Role: Soldier Actor: Usher

Afterpiece Title: Robin Goodfellow

Song: II: Rise Glory-Lowe; IV: Cantata-Lowe

Dance: III: Grand Dance, as17441217

Performances

Mainpiece Title: The Committee

Cast
Role: Soldier Actor: Usher

Afterpiece Title: Temple of Dulness

Dance: II: Serious Dance-Sga Bettini; IV: Grand Dance, as17441217

Performances

Mainpiece Title: The Committee

Cast
Role: Soldier Actor: Usher

Afterpiece Title: The Dragon of Wantley

Performances

Mainpiece Title: King John

Cast
Role: English Herald Actor: Usher

Performances

Mainpiece Title: King John

Cast
Role: English Herald Actor: Usher

Performances

Mainpiece Title: King John

Cast
Role: English Herald Actor: Usher

Performances

Mainpiece Title: King John

Cast
Role: English Herald Actor: Usher

Performances

Mainpiece Title: King John

Cast
Role: English Herald Actor: Usher