SELECT * FROM london_stages WHERE eventid IN (38881, 41114, 41121, 41131, 41134, 41140, 41144, 41146, 41151, 41155, 41157, 41175, 41178, 41180, 41186, 41189, 41195, 41200, 41212, 41214, 41216, 41218, 41221, 41230, 41232, 41235, 41237, 41244, 41249, 41251, 41254, 41260, 41263, 41265, 41270, 41274, 41280, 41282, 41284, 41286, 41289, 41291, 41294, 41296, 41298, 41303, 41305, 41308, 41310, 41314, 41317, 41319, 41324, 41328, 41339, 41351, 41363, 41368, 41373, 41378, 41393, 41396, 41420, 41434, 41444, 41460, 41470, 41488, 41490, 41502, 41504, 41517, 41519, 41531, 41541, 41548, 41556, 41558, 41566, 41570, 41572, 41690, 41692, 41696, 41708, 41712, 41717, 41722, 41728, 41730, 41734, 41736, 41744, 41748, 41750, 41760, 41762, 41764, 41767, 41771, 41775, 41778, 41780, 41785, 41794, 41827, 41835, 41837, 41840, 41842, 41845, 41847, 41857, 41862, 41865, 41869, 41895, 41897, 41908, 41913, 41925, 41949, 41957, 41983, 42013, 42016, 42036, 42039, 42046, 42049, 42051, 42067, 42075, 42080, 42085, 42087, 42092, 42100, 42102, 42105, 42113, 42118, 42121, 42126, 42128, 42140, 42141, 42143, 42146, 42148, 42149, 42151, 42153, 42164, 42166, 42273, 42284, 42288, 42292, 42295, 42307, 42311, 42313, 42321, 42331, 42333, 42337, 42342, 42344, 42351, 42356, 42361, 42368, 42371, 42373, 42376, 42382, 42391, 42402, 42419, 42421, 42426, 42434, 42439, 42441, 42462, 42464, 42466, 42469, 42474, 42476, 42478, 42480, 42483, 42490, 42493, 42505, 42509, 42514, 42517, 42521, 42524, 42526, 42531, 42535, 42540, 42543, 42545, 42548, 42553, 42555, 42558, 42565, 42568, 42570, 42575, 42580, 42585, 42589, 42593, 42596, 42598, 42602, 42611, 42622, 42624, 42628, 42632, 42637, 42650, 42658, 42671, 42676, 42686, 42691, 42693, 42696, 42703, 42706, 42708, 42711, 42713, 42716, 42720, 42725, 42740, 42746, 42753, 42861, 42865, 42867, 42869, 42872, 42873, 42881, 42883, 42885, 42890, 42892, 42893, 42897, 42900, 42902, 42903, 42905, 42907, 42915, 42919, 42923, 42925, 42929, 42931, 42933, 42935, 42937, 42939, 42941, 42943, 42947, 42949, 42951, 42953, 42955, 42957, 42959, 42962, 42964, 42967, 42969, 42971, 42973, 42976, 42978, 42981, 42983, 42985, 42987, 42990, 42993, 42998, 43000, 43002, 43005, 43007, 43009, 43011, 43016, 43019, 43021, 43023, 43025, 43030, 43035, 43039, 43042, 43049, 43056, 43066, 43073, 43078, 43080, 43083, 43088, 43092, 43100, 43103, 43107, 43123, 43137, 43151, 43154, 43194, 43199, 43203, 43207, 43218, 43223, 43228, 43231, 43238, 43243, 43246, 43248, 43254, 43259, 43262, 43264, 43269, 43271, 43273, 43276, 43284, 43287, 43299, 43302, 43307, 43309, 43314, 43438, 43440, 43450, 43454, 43456, 43458, 43459, 43461, 43466, 43469, 43474, 43477, 43479, 43487, 43491, 43495, 43497, 43501, 43503, 43505, 43509, 43516, 43518, 43520, 43522, 43524, 43526, 43528, 43530, 43534, 43538, 43542, 43544, 43546, 43550, 43552, 43554, 43556, 43558, 43560, 43563, 43565, 43567, 43569, 43571, 43586, 43598, 43600, 43605, 43607, 43609, 43612, 43614, 43617, 43621, 43630, 43632, 43635, 43637, 43640, 43643, 43646, 43650, 43655, 43663, 43667, 43688, 43698, 43701, 43706, 43717, 43721, 43728, 43735, 43739, 43751, 43755, 43764, 43769, 43771, 43773, 43775, 43778, 43783, 43785, 43791, 43794, 43797, 43800, 43811, 43817, 43823, 43825, 43831, 43835, 43837, 43843, 43851, 43853, 43855, 43857, 43860, 43865, 43875, 43877, 43880, 43882, 43897, 43904, 44025, 44028, 44030, 44032, 44034, 44036, 44040, 44042, 44044, 44045, 44047, 44052, 44053, 44055, 44057, 44062, 44064, 44067, 44071, 44073, 44075, 44084, 44086, 44088, 44090, 44094, 44096, 44098, 44100, 44102, 44104, 44108, 44112, 44114, 44116, 44118, 44122, 44124, 44126, 44128, 44130, 44132, 44136, 44138, 44140, 44142, 44144, 44146, 44148, 44150, 44152, 44156, 44158, 44160, 44162, 44164, 44166, 44169, 44171, 44177, 44179, 44197, 44205, 44217, 44220, 44226, 44236, 44238, 44241, 44246, 44250, 44252, 44255, 44257, 44266, 44269, 44271, 44274, 44280, 44283, 44285, 44289, 44298, 44318, 44331, 44334, 44336, 44344, 44347, 44349, 44353, 44357, 44371, 44373, 44376, 44383, 44386, 44391, 44393, 44398, 44403, 44408, 44416, 44423, 44426, 44428, 44431, 44433, 44438, 44443, 44448, 44453, 44458, 44466, 44471, 44473, 44588, 44590, 44594, 44602, 44604, 44606, 44609, 44614, 44615, 44619, 44622, 44624, 44626, 44627, 44629, 44631, 44633, 44635, 44637, 44640, 44642, 44644, 44646, 44651, 44657, 44663, 44665, 44669, 44671, 44675, 44677, 44685, 44687, 44689, 44691, 44693, 44695, 44699, 44702, 44704, 44714, 44716, 44718, 44720, 44722, 44725, 44727, 44730, 44732, 44734, 44736, 44742, 44745, 44747, 44749, 44756, 44761, 44763, 44765, 44779, 44782, 44786, 44788, 44793, 44795, 44798, 44800, 44802, 44804, 44807, 44809, 44812, 44814, 44816, 44821, 44823, 44833, 44835, 44839, 44843, 44852, 44862, 44866, 44870, 44873, 44875, 44886, 44890, 44906, 44908, 44910, 44914, 44921, 44930, 44935, 44938, 44940, 44943, 44945, 44948, 44951, 44954, 44963, 44968, 44970, 44974, 44977, 44982, 44991, 44994, 44997, 45000, 45003, 45006, 45012, 45019, 45024, 45026, 45031, 45034, 45036, 45136, 45138, 45146, 45148, 45149, 45151, 45153, 45155, 45157, 45160, 45161, 45163, 45165, 45170, 45172, 45173, 45177, 45181, 45183, 45185, 45187, 45189, 45191, 45193, 45195, 45199, 45201, 45203, 45205, 45207, 45209, 45211, 45213, 45215, 45217, 45219, 45221, 45223, 45225, 45227, 45229, 45231, 45233, 45235, 45241, 45243, 45249, 45254, 45268, 45282, 45284, 45286, 45288, 45290, 45292, 45294, 45296, 45299, 45301, 45304, 45306, 45309, 45311, 45313, 45315, 45318, 45320, 45323, 45325, 45327, 45329, 45332, 45334, 45339, 45341, 45343, 45346, 45348, 45351, 45353, 45355, 45360, 45364, 45368, 45371, 45373, 45377, 45380, 45383, 45385, 45389, 45393, 45396, 45406, 45409, 45411, 45419, 45422, 45428, 45432, 45435, 45437, 45439, 45441, 45445, 45450, 45453, 45455, 45458, 45465, 45468, 45474, 45479, 45481, 45486, 45489, 45496, 45499, 45503, 45505, 45508, 45510, 45516, 45518, 45520, 45523, 45525, 45538, 45541, 45543, 45548, 45551, 45553, 45556, 45558, 45561, 45563, 45566, 45568, 45573, 45581, 45583, 45586, 45588, 45590, 45592, 45594, 45596, 45597, 45600, 45603, 45607, 45610, 45613, 45617, 45618, 45622, 45624, 45626, 45628, 45631, 45632, 45633, 45634, 45635, 45637, 45638, 45639, 45640, 45641, 45642, 45643, 45644, 45645, 45647, 45648, 45649, 45651, 45653, 45655, 45656, 45657, 45658, 45659, 45660, 45661, 45663, 45667, 45668, 45669, 45670, 45671, 45672, 45673, 45674, 45675, 45676, 45677, 45678, 45679, 45681, 45682, 45683, 45685, 45686, 45687, 45689, 45691, 45703, 45705, 45707, 45710, 45712, 45715, 45718, 45723, 45728, 45734, 45737, 45743, 45747, 45749, 45753, 45755, 45757, 45762, 45768, 45770, 45774, 45776, 45782, 45794, 45796, 45798, 45800, 45802, 45804, 45806, 45808, 45812, 45816, 45818, 45824, 45826, 45828, 45830, 45832, 45834, 45837, 45839, 45843, 45845, 45847, 45849, 45855, 45857, 45859, 45861, 45865, 45868, 45870, 45873, 45875, 45879, 45882, 45884, 45887, 45889, 45893, 45896, 45898, 45908, 45910, 45917, 45919, 45922, 45924, 45931, 45936, 45938, 45941, 45943, 45945, 45947, 45950, 45953, 45957, 45961, 45966, 45974, 45977, 45979, 45983, 45987, 45990, 45992, 45996, 46001, 46004, 46006, 46014, 46017, 46019, 46023, 46027, 46032, 46039, 46041, 46044, 46046, 46051, 46057, 46059, 46062, 46064, 46067, 46069, 46072, 46074, 46077, 46079, 46084, 46087, 46089, 46092, 46094, 46097, 46099, 46111, 46114, 46117, 46126, 46129, 46132, 46136, 46139, 46142, 46150, 46153, 46156, 46162, 46260, 46264, 46268, 46270, 46272, 46274, 46278, 46280, 46282, 46283, 46288, 46291, 46293, 46296, 46298, 46300, 46302, 46310, 46312, 46314, 46316, 46318, 46320, 46322, 46324, 46326, 46328, 46330, 46332, 46335, 46337, 46340, 46342, 46344, 46346, 46348, 46352, 46354, 46356, 46358, 46366, 46370, 46374, 46394, 46400, 46406, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46451, 46454, 46461, 46463, 46468, 46473, 46477, 46482, 46485, 46487, 46489, 46494, 46499, 46508, 46521, 46523, 46532, 46535, 46537, 46546, 46549, 46551, 46560, 46574, 46577, 46589, 46597, 46601, 46603, 46611, 46616, 46618, 46621, 46623, 46626, 46631, 46633, 46638, 46641, 46646, 46648, 46651, 46653, 46660, 46665, 46667, 46670, 46675, 46677, 46680, 46682, 46685, 46687, 46690, 46694, 46696, 46701, 46704, 46707, 46710, 46717, 46720, 46722, 46848, 46851, 46857, 46860, 46862, 46864, 46866, 46868, 46870, 46872, 46874, 46876, 46878, 46880, 46884, 46886, 46890, 46892, 46894, 46896, 46900, 46902, 46904, 46908, 46910, 46914, 46916, 46918, 46920, 46922, 46924, 46926, 46928, 46930, 46932, 46934, 46938, 46940, 46942, 46950, 46954, 46958, 46960, 46962, 46964, 46966, 46970, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46990, 46992, 46994, 46996, 46998, 47004, 47006, 47008, 47012, 47014, 47016, 47018, 47020, 47024, 47026, 47032, 47044, 47046, 47048, 47052, 47054, 47060, 47062, 47065, 47070, 47075, 47080, 47085, 47087, 47090, 47092, 47097, 47100, 47103, 47107, 47113, 47116, 47123, 47127, 47130, 47132, 47143, 47147, 47155, 47164, 47166, 47172, 47178, 47182, 47191, 47197, 47203, 47206, 47208, 47211, 47213, 47223, 47225, 47228, 47237, 47241, 47248, 47258, 47263, 47269, 47272, 47278, 47284, 47288, 47294, 47296, 47307, 47313, 47321, 47323, 47327, 47329, 47334, 47341, 47363, 47371, 47376, 47383, 47386, 47388, 47389, 47393, 47401, 47402, 47404, 47408, 47416, 47418, 47419, 47420, 47421, 47423, 47425, 47426, 47427, 47429, 47430, 47443, 47445, 47448, 47450, 47452, 47453, 47457, 47460, 47463, 47465, 47468, 47471, 47473, 47476, 47480, 47481, 47483, 47488, 47490, 47492, 47494, 47496, 47498, 47502, 47504, 47508, 47512, 47514, 47516, 47518, 47522, 47524, 47528, 47532, 47534, 47538, 47540, 47542, 47544, 47546, 47550, 47554, 47556, 47560, 47563, 47565, 47567, 47569, 47571, 47574, 47576, 47579, 47583, 47585, 47588, 47592, 47594, 47596, 47608, 47610, 47618, 47620, 47624, 47630, 47638, 47642, 47646, 47650, 47652, 47654, 47658, 47662, 47667, 47671, 47675, 47679, 47682, 47689, 47692, 47695, 47699, 47703, 47706, 47713, 47721, 47723, 47728, 47736, 47738, 47743, 47748, 47751, 47753, 47758, 47763, 47766, 47768, 47773, 47778, 47781, 47783, 47786, 47788, 47791, 47793, 47799, 47804, 47807, 47812, 47814, 47817, 47819, 47822, 47829, 47832, 47837, 47842, 47844, 47847, 47852, 47854, 47857, 47859, 47862, 47864, 47866, 47871, 47876, 47878, 47884, 47886, 47889, 47891, 47893, 47899, 47902, 47905, 47907, 47908, 47911, 47992, 47995, 48001, 48003, 48007, 48011, 48013, 48014, 48018, 48021, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48044, 48046, 48048, 48050, 48054, 48058, 48060, 48063, 48065, 48067, 48071, 48075, 48077, 48079, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48118, 48120, 48122, 48124, 48126, 48128, 48130, 48132, 48134, 48136, 48138, 48141, 48143, 48145, 48147, 48149, 48151, 48153, 48155, 48157, 48159, 48161, 48163, 48165, 48169, 48171, 48173, 48175, 48177, 48181, 48185, 48193, 48198, 48205, 48208, 48210, 48213, 48215, 48219, 48222, 48224, 48232, 48235, 48237, 48246, 48251, 48256, 48260, 48263, 48270, 48274, 48277, 48279, 48284, 48288, 48291, 48293, 48298, 48302, 48307, 48310, 48316, 48319, 48324, 48330, 48340, 48357, 48360, 48371, 48376, 48379, 48381, 48385, 48388, 48390, 48393, 48397, 48401, 48410, 48412, 48415, 48429, 48431, 48438, 48607, 48627, 48649, 48671, 48691, 48693, 48711, 48713, 48733, 48751, 48753, 48763, 48765, 48773, 48979, 48981, 48983, 48985, 48987, 48992, 48994, 48997, 48999, 49001, 49003, 49006, 49008, 49011, 49020, 49025, 49030, 49037, 49042, 49045, 49052, 49057, 49060, 49071, 49076, 49080, 49085, 49087, 49094, 49099, 49102, 49111, 49190, 49194, 49198, 49200, 49202, 49204, 49205, 49212, 49223, 49231, 49233, 49239, 49241, 49245, 49247, 49251, 49253, 49255, 49259, 49263, 49265, 49267, 49269, 49271, 49275, 49281, 49283, 49287, 49289, 49293, 49295, 49299, 49304, 49306, 49313, 49320, 49323, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49351, 49356, 49358, 49361, 49363, 49365, 49370, 49372, 49375, 49379, 49384, 49386, 49391, 49395, 49398, 49403, 49405, 49407, 49410, 49417, 49419, 49424, 49426, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49508, 49512, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49535, 49538, 49540, 49544, 49549, 49552, 49555, 49557, 49564, 49567, 49572, 49574, 49579, 49582, 49584, 49586, 49588, 49591, 49593, 49596, 49598, 49601, 49603, 49611, 49615, 49619, 49621, 49626, 49631, 49634, 49639, 49643, 49648, 49771, 49773, 49774, 49778, 49782, 49784, 49786, 49790, 49792, 49793, 49795, 49800, 49802, 49804, 49806, 49808, 49812, 49820, 49822, 49824, 49826, 49828, 49830, 49836, 49838, 49840, 49842, 49844, 49846, 49850, 49854, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49880, 49887, 49892, 49894, 49899, 49901, 49904, 49906, 49909, 49911, 49918, 49920, 49925, 49930, 49932, 49937, 49939, 49946, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50034, 50037, 50040, 50047, 50051, 50054, 50060, 50063, 50066, 50069, 50072, 50074, 50076, 50078, 50081, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50110, 50112, 50115, 50117, 50120, 50122, 50125, 50127, 50130, 50133, 50135, 50137, 50142, 50150, 50152, 50155, 50160, 50162, 50165, 50171, 50176, 50178, 50180, 50185, 50188, 50190, 50192, 50194, 50197, 50199, 50202, 50204, 50207, 50209, 50212, 50214, 50217, 50218, 50219, 50220, 50223, 50225, 50228, 50337, 50339, 50344, 50349, 50357, 50359, 50362, 50367, 50386, 50388, 50390, 50393, 50397, 50399, 50401, 50403, 50405, 50407, 50409, 50413, 50415, 50417, 50421, 50423, 50427, 50429, 50432, 50434, 50439, 50441, 50443, 50446, 50448, 50451, 50453, 50455, 50457, 50460, 50462, 50465, 50467, 50471, 50474, 50476, 50479, 50481, 50483, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50516, 50519, 50521, 50523, 50528, 50537, 50539, 50542, 50545, 50548, 50550, 50558, 50570, 50572, 50613, 50622, 50634, 50649, 50655, 50661, 50663, 50667, 50673, 50675, 50679, 50689, 50694, 50701, 50703, 50706, 50718, 50721, 50727, 50732, 50746, 50748, 50751, 50753, 50758, 50763, 50766, 50768, 50778, 50781, 50789, 50794, 50796, 50804, 50813, 50816, 50974, 51004, 51051, 51106, 51109, 51111, 51113, 51115, 51120, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51248, 51251, 51253, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51550, 51552, 51554, 51556, 51582, 51609, 51672, 51675, 51677, 51703, 51709, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51807, 51824) 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 Wheel Of Fortune

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: The Captive of Spilburg

Dance: In afterpiece: a Dance-Roffey, Whitmell, Wells, Male, Garman, W. Banks, Goodman, Gauron, Ms Brooker, Ms Daniels, Ms Brigg, Ms Byrne, Ms Vining, Ms Luciet, Ms Drake, Ms Riches; New Hornpipe-Sga Bossi DelCaro

Performances

Mainpiece Title: The Stranger

Afterpiece Title: The Captive of Spilburg

Music: As17980915

Dance: In: As17980915; In afterpiece: a Dance, as17981114; New Hornpipe, as17981114

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Captive of Spilburg

Dance: As17981114

Performances

Mainpiece Title: Isabella; Or, The Fatal Marriage

Afterpiece Title: Blue-Beard

Song: In III: Epithalamium. Vocal Parts-Mrs Bland, Miss Leak

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Feudal Times; or, The Banquet Gallery

Performances

Mainpiece Title: Love Makes A Man

Performances

Mainpiece Title: The Wheel Of Fortune

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Performances

Mainpiece Title: The School For Scandal

Song: As17990108

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Douglas

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Isabella

Afterpiece Title: Feudal Times

Song: In III: Epithalamium. Vocal Parts-Miss Leak, Miss Menage

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Feudal Times