SELECT * FROM london_stages WHERE eventid IN (194, 197, 234, 274, 282, 287, 303, 321, 359, 365, 394, 403, 415, 420, 432, 450, 679, 876, 886, 898, 935, 937, 942, 946, 964, 992, 996, 1022, 1030, 1136, 1155, 1160, 1183, 1203, 1213, 1259, 1262, 1278, 1288, 1291, 1296, 1318, 1337, 1338, 1341, 1344, 1402, 1457, 1507, 1522, 1533, 1549, 1581, 1582, 1601, 1618, 1622, 1662, 1670, 1683, 1691, 1732, 1735, 1746, 1765, 1769, 1770, 1772, 1779, 1794, 1814, 1820, 1839, 1843, 1852, 1857, 1863, 1877, 1882, 1899, 1960, 2064, 2131, 2146, 2605, 2888, 3105, 3170, 3245, 3440, 4568, 4578, 4583, 4586, 4592, 4594, 4595, 4599, 4600, 4605, 4606, 4607, 4611, 4613, 4615, 4616, 4617, 5289, 7912, 8235, 8636, 10330, 10388, 12644, 12693, 12697, 12701, 12704, 12713, 12723, 12726, 12734, 12737, 12738, 12741, 12743, 12746, 12749, 12751, 13289, 13292, 13296, 13318, 13322, 13343, 13351, 13355, 13360, 13480, 13484, 13486, 13492, 13501, 13503, 13519, 16496, 17806, 18184, 18186, 18188, 18194, 18335, 18338, 18379, 18382, 18424, 18427, 18440, 18791, 20219, 20222, 20225, 20229, 20232, 20235, 20238, 20241, 20244, 20247, 20250, 20253, 20256, 20259, 20281, 20285, 20288, 20316, 20322, 20325, 20328, 20331, 20334, 20338, 20341, 20345, 20349, 20352, 20355, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20434, 20443, 20450, 20488, 20495, 20499, 20502, 20518, 20530, 20534, 20544, 20551, 20556, 20560, 20566, 20569, 20572, 20702, 21791, 21911, 22086, 22089, 22092, 22108, 22113, 22118, 22126, 22138, 22142, 22151, 22153, 22161, 22163, 22179, 22188, 22190, 22192, 22195, 22204, 22207, 22224, 22237, 22245, 22272, 22275, 22277, 22341, 22537, 22542, 22567, 23168, 23171, 23175, 23178, 23186, 23206, 23214, 23216, 23219, 23225, 23266, 23618, 23820, 23943, 24292, 24298, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24351, 24366, 24372, 24376, 24443, 24450, 24459, 24465, 24470, 24476, 24484, 24487, 24498, 24510, 24524, 24528, 24542, 24566, 24570, 24621, 24625, 24629, 24632, 24635, 24641, 24644, 24647, 24679, 24682, 24712, 24787, 24802, 24873, 24946, 24949, 24950, 24953, 24955, 24958, 24963, 24966, 24968, 24970, 24976, 24984, 24987, 24990, 24998, 25001, 25003, 25006, 25008, 25010, 25012, 25015, 25017, 25020, 25022, 25024, 25026, 25029, 25031, 25035, 25040, 25044, 25047, 25049, 25053, 25055, 25057, 25059, 25061, 25072, 25086, 25088, 25094, 25114, 25123, 25128, 25131, 25134, 25148, 25192, 25206, 25213, 25227, 25237, 25249, 25275, 25286, 25288, 25295, 25418, 25425, 25443, 25445, 25449, 25451, 25893, 25896, 25899, 25902, 25905, 25907, 25909, 25959, 25961, 25982, 26067, 26361, 26363, 26366, 26368, 26371, 26373, 26376, 26378, 26381, 26383, 26386, 26388, 26761, 26768, 26808, 26826, 26928, 27051, 27643, 27647, 27728, 27737, 28766, 28865, 28870, 28872, 28875, 28880, 28886, 28892, 28897, 28903, 28909, 28916, 28923, 28965, 29020, 29032, 29238, 29240, 29245, 29247, 29249, 29263, 29279, 29283, 29288, 29307, 29313, 29323, 29328, 29347, 29458, 29509, 29731, 29738, 29744, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29918, 29922, 29925, 29928, 29930, 29933, 29935, 29939, 29942, 29944, 29950, 29953, 29955, 29957, 29959, 29963, 29966, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30049, 30053, 30056, 30064, 30069, 30076, 30126, 30131, 30144, 30146, 30148, 30150, 30152, 30154, 30322, 30326, 30328, 30330, 30375, 30384, 30394, 30409, 30411, 30414, 30421, 30428, 30433, 30442, 30449, 30456, 30464, 30466, 30471, 30503, 30508, 30521, 30536, 30543, 30550, 30554, 30565, 30576, 30586, 30590, 30609, 30645, 30649, 30659, 30681, 30683, 30685, 30689, 30794, 30802, 30807, 30813, 30815, 30817, 30823, 30827, 30831, 30833, 30897, 31056, 31062, 31152, 31163, 31221, 31248, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31523, 31526, 31535, 31560, 31562, 31569, 31605, 31608, 31617, 31626, 31642, 31657, 31673, 31689, 31700, 31704, 31715, 31731, 31740, 31771, 31850, 31856, 31864, 31874, 31876, 31877, 31878, 31881, 31885, 31887, 31896, 31900, 31908, 31910, 31912, 31914, 31916, 31921, 31924, 31927, 31930, 31932, 31946, 31947, 31956, 31961, 31967, 31970, 31972, 31974, 31975, 31979, 31982, 31986, 31988, 31990, 32001, 32004, 32008, 32020, 32024, 32027, 32029, 32031, 32033, 32035, 32037, 32040, 32042, 32046, 32048, 32050, 32052, 32055, 32058, 32060, 32062, 32064, 32067, 32069, 32072, 32074, 32075, 32076, 32077, 32079, 32081, 32082, 32084, 32086, 32087, 32089, 32091, 32093, 32107, 32118, 32121, 32122, 32125, 32126, 32127, 32129, 32132, 32137, 32141, 32147, 32156, 32161, 32164, 32178, 32182, 32188, 32205, 32207, 32209, 32221, 32226, 32235, 32236, 32240, 32241, 32244, 32245, 32250, 32256, 32258, 32261, 32264, 32319, 32321, 32323, 32325, 32329, 32332, 32333, 32336, 32339, 32341, 32342, 32344, 32346, 32347, 32348, 32349, 32351, 32353, 32357, 32359, 32361, 32362, 32366, 32367, 32377, 32379, 32381, 32383, 32385, 32389, 32391, 32393, 32396, 32402, 32404, 32408, 32420, 32422, 32424, 32429, 32431, 32443, 32463, 32465, 32467, 32469, 32471, 32472, 32473, 32475, 32476, 32477, 32479, 32480, 32481, 32482, 32486, 32487, 32488, 32491, 32493, 32495, 32496, 32500, 32502, 32505, 32507, 32510, 32514, 32515, 32516, 32517, 32522, 32524, 32527, 32533, 32537, 32540, 32542, 32543, 32545, 32547, 32550, 32552, 32554, 32555, 32556, 32557, 32558, 32559, 32561, 32563, 32564, 32566, 32568, 32569, 32571, 32573, 32575, 32576, 32580, 32581, 32585, 32589, 32593, 32594, 32598, 32601, 32604, 32606, 32610, 32617, 32619, 32624, 32627, 32635, 32643, 32648, 32649, 32656, 32658, 32666, 32667, 32671, 32674, 32676, 32686, 32689, 32692, 32696, 32699, 32709, 32711, 32721, 32724, 32730, 32738, 32744, 32748, 32749, 32813, 32815, 32817, 32818, 32822, 32831, 32835, 32837, 32838, 32839, 32841, 32843, 32847, 32849, 32851, 32855, 32857, 32859, 32861, 32863, 32865, 32881, 32883, 32889, 32895, 32897, 32902, 32911, 32923, 32939, 32947, 32952, 32954, 32957, 32967, 32970, 32973, 32975, 32977, 32979, 32982, 32984, 32986, 32988, 32990, 32992, 32997, 33002, 33006, 33011, 33016, 33021, 33027, 33030, 33032, 33036, 33037, 33046, 33047, 33048, 33051, 33058, 33060, 33083, 33085, 33093, 33101, 33103, 33106, 33109, 33117, 33122, 33124, 33127, 33131, 33137, 33140, 33149, 33151, 33158, 33162, 33171, 33173, 33175, 33184, 33192, 33193, 33194, 33201, 33202, 33263, 33278, 33282, 33284, 33296, 33298, 33301, 33305, 33310, 33312, 33315, 33317, 33320, 33322, 33325, 33327, 33330, 33332, 33339, 33340, 33341, 33344, 33351, 33356, 33359, 33361, 33363, 33365, 33368, 33370, 33373, 33375, 33377, 33379, 33383, 33396, 33397, 33398, 33400, 33402, 33426, 33428, 33429, 33430, 33434, 33435, 33439, 33440, 33441, 33443, 33446, 33447, 33448, 33451, 33453, 33455, 33457, 33458, 33460, 33461, 33462, 33463, 33465, 33467, 33468, 33471, 33472, 33474, 33476, 33477, 33479, 33481, 33483, 33489, 33491, 33494, 33496, 33497, 33499, 33501, 33502, 33504, 33506, 33507, 33509, 33510, 33511, 33513, 33515, 33516, 33517, 33518, 33520, 33524, 33527, 33529, 33530, 33535, 33536, 33537, 33539, 33541, 33544, 33546, 33549, 33572, 33573, 33586, 33602, 33608, 33626, 33631, 33634, 33639, 33649, 33654, 33658, 33665, 33674, 33679, 33686, 33689, 33694, 33696, 33699, 33700, 33701, 33705, 33711, 33714, 33793, 33795, 33809, 33844, 33880, 33925, 33951, 33970, 33979, 33995, 33997, 33999, 34001, 34004, 34006, 34009, 34011, 34013, 34015, 34018, 34025, 34029, 34034, 34068, 34089, 34156, 34169, 34174, 34181, 34198, 34230, 34250, 34253, 34255, 34259, 34262, 34267, 34340, 34343, 34345, 34356, 34368, 34375, 34377, 34380, 34384, 34390, 34392, 34394, 34415, 34424, 34453, 34485, 34521, 34598, 34668, 34694, 34697, 34713, 34723, 34725, 34730, 34733, 34735, 34739, 34748, 34752, 34754, 34757, 34759, 34766, 34776, 34782, 34785, 34794, 34805, 34823, 34832, 34837, 34850, 34854, 34863, 34881, 34906, 34948, 35065, 35121, 35236, 35282, 35336, 35743, 35884, 35925, 35946, 35958, 35990, 36478, 36483, 36512, 36524, 36536, 36556, 36644, 36650, 36693, 36739, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36842, 36845, 36847, 36849, 36851, 36854, 36859, 36861, 36867, 36872, 36874, 36876, 36882, 36889, 36896, 36898, 36903, 36905, 36910, 36940, 36956, 36970, 36989, 37006, 37029, 37037, 37045, 37056, 37061, 37064, 37067, 37077, 37079, 37083, 37086, 37092, 37108, 37120, 37219, 37222, 37224, 37226, 37240, 37242, 37287, 37289, 37302, 37308, 37320, 37332, 37334, 37339, 37346, 37367, 37389, 37401, 37415, 37423, 37440, 37546, 37549, 37575, 37580, 37583, 37585, 37590, 37595, 37600, 37603, 37607, 37612, 37614, 37617, 37619, 37631, 37636, 37641, 37644, 37647, 37649, 37652, 37666, 37672, 37674, 37676, 37678, 37796, 37802, 37804, 37818, 37822, 37832, 37834, 37836, 37848, 37869, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 37974, 38068, 38071, 38152, 38154, 38159, 38161, 38214, 38237, 38408, 38411, 38413, 38418, 38421, 38423, 38426, 38428, 38432, 38435, 38437, 38440, 38442, 38446, 38449, 38451, 38454, 38456, 38458, 38460, 38463, 38468, 38470, 38474, 38489, 38491, 38493, 38495, 38499, 38501, 38503, 38506, 38508, 38512, 38517, 38522, 38526, 38529, 38531, 38537, 38541, 38544, 38548, 38552, 38557, 38562, 38566, 38571, 38574, 38576, 38584, 38586, 38594, 38604, 38609, 38620, 38625, 38628, 38630, 38635, 38650, 38659, 38664, 38674, 38681, 38683, 38693, 38695, 38707, 38712, 38727, 38732, 38742, 38756, 38762, 38772, 38779, 38786, 38791, 38863, 38866, 38869, 38872, 38875, 38878, 38882, 38887, 38890, 38893, 38897, 38900, 38938, 39111, 39278, 39389, 39390, 39398, 39400, 39403, 39405, 39407, 39413, 39419, 39422, 39424, 39436, 39438, 39439, 39443, 39845, 39850, 39867, 39876, 39878, 39887, 40057, 40063, 40069, 40075, 40101, 40103, 40109, 40128, 40144, 40156, 40168, 40185, 40195, 40202, 40210, 40228, 40233, 40248, 40265, 40297, 40302, 40311, 40323, 40324, 40338, 40355, 40360, 40369, 40377, 40384, 40422, 40877, 41011, 41012, 41017, 41022, 41025, 41028, 41034, 41038, 41044, 41052, 41057, 41059, 41061, 41067, 41077, 41079, 41083, 41085, 41122, 41123, 41125, 41130, 41134, 41137, 41140, 41145, 41146, 41151, 41161, 41170, 41178, 41180, 41191, 41195, 41200, 41221, 41224, 41226, 41233, 41235, 41240, 41246, 41249, 41250, 41258, 41263, 41264, 41269, 41270, 41277, 41291, 41296, 41300, 41305, 41339, 41355, 41370, 41373, 41384, 41387, 41389, 41393, 41398, 41403, 41440, 41444, 41446, 41460, 41462, 41465, 41469, 41474, 41481, 41487, 41493, 41497, 41503, 41520, 41552, 41557, 41558, 41559, 41564, 41569, 41718, 41723, 41727, 42035, 42111, 42124, 42142, 42440, 42670, 42735, 42896, 42932, 42936, 42944, 42948, 42956, 42960, 42963, 42970, 42984, 43022, 43026, 43033, 43035, 43036, 43037, 43039, 43040, 43042, 43045, 43052, 43062, 43063, 43065, 43074, 43081, 43089, 43091, 43110, 43120, 43127, 43134, 43141, 43148, 43152, 43155, 43156, 43163, 43170, 43180, 43239, 43313, 43437, 43443, 43445, 43447, 43448, 43459, 43475, 43480, 43489, 43499, 43507, 43518, 43537, 43540, 43548, 43561, 43574, 43582, 43584, 43591, 43595, 43612, 43631, 43641, 43651, 43682, 43693, 43722, 43746, 43747, 43767, 43774, 43798, 43801, 43812, 43818, 43821, 43836, 43838, 43847, 43849, 43852, 43861, 43866, 43873, 43881, 43883, 43896, 43928, 43941, 43947, 43949, 43952, 43955, 43958, 43966, 43973, 43976, 44011, 44012, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44048, 44113, 44173, 44175, 44177, 44179, 44191, 44193, 44195, 44197, 44199, 44209, 44211, 44215, 44222, 44224, 44229, 44232, 44234, 44248, 44264, 44276, 44306, 44308, 44327, 44432, 44436, 44451, 44453, 44475, 44515, 44519, 44529, 44532, 44544, 44546, 44598, 44606, 44619, 44626, 44627, 44629, 44631, 44633, 44635, 44637, 44642, 44644, 44646, 44651, 44655, 44663, 44665, 44669, 44673, 44675, 44687, 44689, 44693, 44699, 44704, 44720, 44730, 44736, 44745, 44749, 44761, 44765, 44779, 44795, 44802, 44803, 44809, 44812, 44823, 44835, 44843, 44859, 44862, 44873, 44886, 45054, 45086, 45127, 45199, 45215, 45221, 45223, 45233, 45235, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45327, 45329, 45334, 45341, 45343, 45371, 45383, 45389, 45409, 45435, 45437, 45439, 45441, 45450, 45455, 45458, 45468, 45486, 45489, 45518, 45537, 45543, 45547, 45592, 45594, 45600, 45602, 45603, 45605, 45614, 45633, 45635, 45637, 45639, 45641, 45643, 45644, 45647, 45649, 45650, 45651, 45653, 45654, 45655, 45656, 45657, 45658, 45660, 45662, 45669, 45670, 45671, 45675, 45676, 45677, 45678, 45679, 45681, 45682, 45683, 45687, 45689, 45730, 45762, 45768, 45804, 45944, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46040, 46104, 46116, 46122, 46128, 46134, 46138, 46156, 46167, 46171, 46172, 46177, 46179, 46181, 46182, 46184, 46193, 46194, 46199, 46209, 46210, 46213, 46216, 46225, 46227, 46229, 46231, 46232, 46233, 46234, 46235, 46238, 46239, 46245, 46259, 46271, 46273, 46284, 46292, 46299, 46311, 46323, 46334, 46336, 46339, 46353, 46357, 46361, 46369, 46373, 46383, 46389, 46393, 46397, 46401, 46403, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46506, 46509, 46511, 46515, 46522, 46524, 46529, 46536, 46543, 46552, 46564, 46566, 46580, 46585, 46590, 46593, 46607, 46612, 46614, 46622, 46634, 46637, 46639, 46657, 46676, 46688, 46695, 46697, 46700, 46708, 46711, 46716, 46718, 46729, 46732, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46891, 46893, 46895, 46897, 46905, 46907, 46909, 46917, 46941, 46949, 46965, 46967, 47063, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47186, 47198, 47204, 47220, 47235, 47253, 47270, 47289, 47306, 47309, 47312, 47315, 47320, 47326, 47559, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47665, 47688, 47690, 48015, 48023, 48024, 48029, 48032, 48091, 48278, 48285, 48289, 48294, 48299, 48320, 48322, 48349, 48358, 48366, 48368, 48467, 48469, 48470, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48484, 48487, 48488, 48489, 48492, 48494, 48495, 48496, 48497, 48498, 48499, 48501, 48502, 48503, 48504, 48515, 48519, 48526, 48530, 48532, 48533, 48551, 48553, 48566, 48568, 48570, 48574, 48620, 48628, 48650, 48654, 48672, 48677, 48712, 48722, 48734, 48737, 48744, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48760, 48761, 48762, 48766, 48767, 48768, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48806, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48829, 48830, 48835, 48837, 48851, 48856, 48858, 48861, 48865, 48870, 48871, 48875, 48877, 48878, 48883, 48885, 48891, 48897, 48902, 48905, 48914, 48916, 48917, 48923, 48924, 48930, 48931, 48939, 48945, 48948, 48952, 48953, 48959, 48960, 48961, 48962, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49058, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49825, 49827, 49831, 50017, 50068, 50158, 50208, 50948, 50953, 51012, 51067, 51085, 51221, 51940) 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 Travellers In Switzerland

Afterpiece Title: The Farm House

Dance: In: The Savoyard-Jackson, Mlle St.Amand; End II afterpiece: The Lamplighter [composed by Aldridge]-Jackson, Mrs Ratchford

Cast
Role: ] Actor: Jackson, Mrs Ratchford.

Performances

Mainpiece Title: Douglas

Cast
Role: Lady Randolph Actor: Mrs Crawford.

Afterpiece Title: The Maid of the Mill

Afterpiece Title: England's Glory

Dance: As17971018

Performances

Mainpiece Title: Douglas

Cast
Role: Lady Randolph Actor: Mrs Crawford.

Afterpiece Title: The Maid of the Mill

Afterpiece Title: England's Glory

Performances

Mainpiece Title: Merope

Cast
Role: Merope Actor: Mrs Crawford.

Afterpiece Title: The Round Tower

Performances

Mainpiece Title: Jane Shore

Cast
Role: Alicia Actor: Mrs Crawford.

Afterpiece Title: Harlequin and Quixotte

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Euphrasia Actor: Mrs Crawford.

Afterpiece Title: Harlequin and Quixotte

Performances

Mainpiece Title: Jane Shore

Cast
Role: Alicia Actor: Mrs Crawford.

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Song: In afterpiece: Come every jovial Fellow-Mrs Martyr, Gray, Mrs Mountain; O ever in my Bosom live-Mrs Martyr, Mrs Mountain

Performances

Mainpiece Title: Lover's Vows

Song: End II: Hope told a flattering tale-Mrs Ferguson; accompanied on the Pedal Harp-Weippert

Music: End I: Grand Sonata on the Piano Forte, as17990515; End IV: Lesson of Nicolai, as17990515

Entertainment: Monologues Before: [Collins' Ode on the Passions-Master Parker; End III: The Birth Day Ode [by Henry James Pye, 1st performed at St. James's Palace, 4 June, the birthday of George III]-Master Parker; End: Imitations-Mrs Sumbel (late $Mrs Wells)