SELECT * FROM london_stages WHERE eventid IN (5131, 5136, 5140, 6030, 7647, 8458, 9570, 9947, 10137, 10679, 10682, 10685, 10689, 10692, 10695, 10698, 10704, 10710, 10717, 10723, 10730, 10734, 10737, 10742, 10747, 10752, 10762, 10788, 11301, 11324, 11382, 11384, 11389, 11404, 11410, 11459, 11461, 11467, 11474, 11499, 11506, 11515, 11517, 11571, 11579, 11598, 11599, 11602, 11763, 11786, 11789, 11798, 11814, 11826, 11827, 11833, 11837, 11842, 11846, 11856, 11858, 11927, 11955, 11957, 11960, 11962, 11965, 11967, 11969, 11971, 11973, 11975, 11989, 11992, 11997, 12084, 12130, 12167, 12190, 12210, 12233, 12238, 12252, 12255, 12319, 12346, 12365, 12369, 12391, 12397, 12399, 12401, 12402, 12405, 12408, 12411, 12413, 12416, 12418, 12419, 12421, 12424, 12426, 12429, 12430, 12432, 12433, 12435, 12436, 12439, 12441, 12446, 12448, 12449, 12451, 12453, 12455, 12457, 12459, 12463, 12464, 12466, 12468, 12470, 12486, 12550, 12564, 12566, 12572, 12597, 12601, 12606, 12610, 12623, 12644, 12678, 12693, 12697, 12701, 12704, 12713, 12718, 12723, 12724, 12726, 12734, 12737, 12738, 12741, 12743, 12744, 12746, 12749, 12751, 12754, 12759, 12764, 12808, 12814, 12822, 12823, 12826, 12827, 12831, 12845, 12873, 12876, 12884, 12886, 12889, 12912, 12918, 12922, 12971, 12979, 12982, 12985, 12991, 12995, 12997, 13001, 13004, 13007, 13011, 13015, 13024, 13034, 13042, 13046, 13051, 13062, 13065, 13069, 13072, 13075, 13078, 13082, 13086, 13090, 13093, 13097, 13100, 13104, 13108, 13112, 13115, 13118, 13126, 13133, 13155, 13159, 13163, 13166, 13170, 13174, 13177, 13180, 13184, 13188, 13191, 13197, 13201, 13205, 13209, 13215, 13220, 13224, 13227, 13232, 13237, 13244, 13249, 13255, 13276, 13284, 13288, 13291, 13295, 13299, 13302, 13310, 13317, 13321, 13325, 13334, 13342, 13346, 13350, 13362, 13371, 13375, 13379, 13382, 13389, 13394, 13397, 13402, 13411, 13425, 13430, 13435, 13438, 13445, 13452, 13470, 13479, 13488, 13567, 13568, 13570, 13591, 13605, 13613, 13617, 13626, 13641, 13650, 13667, 13691, 13695, 13699, 13702, 13733, 13737, 13741, 13763, 13770, 13774, 13778, 13805, 13816, 13819, 13823, 13827, 13860, 13866, 13870, 13910, 13920, 13979, 13982, 13987, 13990, 13994, 13998, 14002, 14005, 14009, 14012, 14016, 14019, 14022, 14038, 14044, 14048, 14058, 14072, 14083, 14087, 14118, 14124, 14136, 14141, 14145, 14162, 14169, 14173, 14177, 14193, 14213, 14217, 14254, 14340, 14346, 14353, 14365, 14374, 14402, 14405, 14417, 14430, 14433, 14440, 14444, 14447, 14450, 14453, 14457, 14460, 14464, 14490, 14507, 14512, 14516, 14519, 14529, 14532, 14536, 14560, 14563, 14566, 14573, 14579, 14583, 14611, 14617, 14624, 14631, 14650, 14670, 14675, 14678, 14713, 14717, 14730, 14772, 14774, 14777, 14792, 14847, 14877, 14907, 14920, 14924, 14936, 14939, 14952, 14972, 15095, 15100, 15136, 15153, 15174, 15177, 15181, 15185, 15188, 15199, 15205, 15260, 15337, 15346, 15488, 15492, 15499, 15506, 15591, 15597, 15602, 15623, 15632, 15668, 15698, 15701, 15749, 15757, 15786, 15822, 15825, 15834, 15837, 15868, 15887, 15920, 16026, 16034, 16038, 16115, 16119, 16126, 16130, 16136, 16139, 16142, 16148, 16152, 16157, 16161, 16165, 16169, 16173, 16177, 16183, 16195, 16205, 16215, 16223, 16233, 16239, 16245, 16252, 16282, 16295, 16323, 16328, 16344, 16366, 16388, 16395, 16442, 16458, 16462, 16481, 16572, 16580, 16582, 16585, 16589, 16592, 16595, 16598, 16601, 16603, 16605, 16611, 16615, 16648, 16655, 16659, 16663, 16670, 16675, 16680, 16685, 16687, 16695, 16699, 16703, 16707, 16710, 16714, 16790, 16827, 16833, 16982, 17025, 17045, 17067, 17073, 17082, 17095, 17103, 17119, 17129, 17143, 17157, 17162, 17179, 17182, 17186, 17195, 17221, 17225, 17229, 17262, 17380, 17513, 17516, 17521, 17524, 17546, 17549, 17561, 17565, 17568, 17571, 17575, 17578, 17582, 17587, 17595, 17597, 17601, 17609, 17612, 17617, 17759, 17762, 17766, 17770, 17777, 17843, 17847, 17852, 17857, 17862, 17867, 17875, 17897, 17906, 17944, 17948, 17970, 18144, 18147, 18150, 18152, 18163, 18205, 18208, 18212, 18216, 18220, 18503, 18515, 18519, 18592, 18673, 18686, 18712, 18723, 18860, 18868, 18870, 18872, 18874, 18889, 18893, 18898, 18899, 18903, 18917, 18936, 18975, 18977, 18996, 19003, 19010, 19033, 19042, 19050, 19052, 19055, 19057, 19077, 19117, 19120, 19156, 19162, 19178, 19186, 19187, 19196, 19217, 19227, 19229, 19268, 19270, 19272, 19276, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19301, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19354, 19356, 19358, 19360, 19362, 19368, 19370, 19374, 19376, 19377, 19379, 19383, 19403, 19405, 19434, 19438, 19448, 19455, 19457, 19464, 19486, 19491, 19499, 19506, 19514, 19522, 19525, 19543, 19553, 19562, 19568, 19570, 19572, 19590, 19597, 19601, 19605, 19607, 19614, 19617, 19620, 19623, 19641, 19644, 19646, 19679, 19689, 19695, 19699, 19701, 19707, 19733, 19735, 19741, 19757, 19759, 19770, 19798, 19800, 19820, 19825, 19827, 19830, 19834, 19839, 19840, 19842, 19852, 19855, 19857, 19861, 19867, 19871, 19878, 19897, 19906, 19908, 19911, 19916, 19921, 19944, 19951, 19954, 19957, 19960, 19974, 19981, 19993, 19999, 20007, 20009, 20012, 20015, 20020, 20024, 20030, 20032, 20040, 20043, 20051, 20076, 20079, 20087, 20095, 20099, 20108, 20127, 20128, 20129, 20132, 20137, 20143, 20157, 20159, 20160, 20163, 20166, 20169, 20172, 20175, 20178, 20184, 20187, 20205, 20208, 20211, 20214, 20217, 20227, 20233, 20242, 20248, 20251, 20254, 20257, 20264, 20267, 20270, 20273, 20276, 20289, 20298, 20314, 20329, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20401, 20429, 20432, 20435, 20438, 20457, 20472, 20532, 20558, 20564, 20583, 20607, 20610, 20621, 20627, 20630, 20637, 20641, 20646, 20665, 20671, 20676, 20684, 20690, 20694, 20695, 20709, 20711, 20720, 20722, 20729, 20732, 20735, 20739, 20742, 20745, 20749, 20751, 20753, 20755, 20757, 20760, 20763, 20766, 20769, 20771, 20774, 20780, 20786, 20796, 20799, 20802, 20805, 20814, 20817, 20825, 20829, 20832, 20835, 20838, 20841, 20845, 20852, 20854, 20857, 20860, 20864, 20867, 20872, 20875, 20878, 20882, 20892, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20924, 20928, 20937, 20941, 20948, 20951, 20955, 20960, 20964, 20967, 20970, 20973, 20977, 20980, 20984, 20986, 20990, 20993, 20997, 21000, 21004, 21007, 21010, 21013, 21017, 21020, 21027, 21033, 21037, 21041, 21045, 21056, 21059, 21066, 21072, 21076, 21079, 21083, 21086, 21092, 21096, 21099, 21103, 21109, 21112, 21116, 21119, 21123, 21126, 21136, 21139, 21143, 21146, 21153, 21157, 21161, 21165, 21168, 21172, 21184, 21188, 21198, 21202, 21217, 21226, 21234, 21242, 21250, 21257, 21260, 21262, 21266, 21275, 21278, 21281, 21284, 21290, 21295, 21298, 21304, 21308, 21310, 21316, 21318, 21321, 21326, 21338, 21341, 21347, 21352, 21354, 21359, 21360, 21366, 21368, 21370, 21374, 21376, 21378, 21382, 21386, 21388, 21390, 21392, 21394, 21398, 21401, 21403, 21405, 21407, 21413, 21418, 21420, 21427, 21432, 21436, 21442, 21448, 21451, 21454, 21457, 21460, 21462, 21465, 21473, 21476, 21482, 21484, 21492, 21495, 21498, 21506, 21509, 21517, 21526, 21531, 21534, 21540, 21544, 21546, 21551, 21559, 21561, 21567, 21573, 21578, 21581, 21584, 21593, 21596, 21598, 21605, 21609, 21614, 21626, 21635, 21638, 21667, 21677, 21680, 21693, 21712, 21733, 21736, 21740, 21767, 21771, 21785, 21792, 21801, 21803, 21805, 21811, 21819, 21821, 21823, 21824, 21825, 21831, 21832, 21834, 21836, 21852, 21855, 21857, 21861, 21866, 21870, 21874, 21876, 21882, 21884, 21887, 21889, 21892, 21896, 21898, 21906, 21908, 21910, 21913, 21915, 21917, 21922, 21931, 21939, 21950, 21957, 21960, 21962, 21966, 21974, 21978, 21980, 21986, 21992, 21997, 22000, 22005, 22008, 22010, 22013, 22017, 22019, 22022, 22027, 22029, 22032, 22034, 22038, 22043, 22046, 22048, 22053, 22056, 22058, 22075, 22081, 22089, 22118, 22121, 22126, 22138, 22153, 22159, 22163, 22179, 22182, 22185, 22188, 22190, 22192, 22204, 22207, 22213, 22226, 22237, 22240, 22243, 22245, 22247, 22249, 22253, 22258, 22260, 22269, 22272, 22275, 22277, 22300, 22302, 22321, 22330, 22344, 22348, 22353, 22360, 22369, 22372, 22380, 22383, 22385, 22388, 22396, 22399, 22405, 22411, 22417, 22420, 22423, 22433, 22436, 22439, 22445, 22449, 22453, 22461, 22467, 22474, 22477, 22480, 22489, 22505, 22508, 22514, 22517, 22524, 22531, 22534, 22548, 22552, 22558, 22561, 22564, 22570, 22577, 22580, 22586, 22591, 22598, 22616, 22631, 22635, 22638, 22643, 22646, 22649, 22653, 22656, 22659, 22664, 22669, 22672, 22746, 22757, 22772, 22792, 22794, 22800, 22821, 22823, 22826, 22845, 22858, 22860, 22862, 22885, 22888, 22902, 22919, 22935, 22938, 22944, 22947, 22953, 22967, 22970, 22973, 22975, 22986, 23000, 23007, 23014, 23017, 23022, 23026, 23029, 23032, 23035, 23037, 23040, 23044, 23046, 23049, 23052, 23058, 23065, 23067, 23082, 23116, 23118, 23121, 23124, 23147, 23168, 23175, 23209, 23228, 23235, 23237, 23258, 23261, 23268, 23271, 23274, 23277, 23283, 23285, 23292, 23295, 23300, 23301, 23315, 23345, 23353, 23383, 23393, 23396, 23405, 23409, 23428, 23451, 23480, 23488, 23509, 23512, 23542, 23553, 23557, 23562, 23590, 23593, 23597, 23600, 23603, 23609, 23632, 23655, 23658, 23683, 23705, 23708, 23743, 23746, 23771, 23783, 23804, 23839, 23848, 23859, 23863, 23865, 23867, 23891, 23896, 23915, 23916, 23918, 23920, 23933, 23947, 23960, 23962, 23973, 23993, 23994, 23996, 24005, 24008, 24010, 24014, 24016, 24049, 24061, 24063, 24073, 24118, 24145, 24169, 24177, 24179, 24184, 24194, 24222, 24231, 24243, 24257, 24262, 24314, 24319, 24320, 24330, 24348, 24353, 24366, 24368, 24370, 24376, 24379, 24398, 24400, 24403, 24406, 24407, 24409, 24411, 24414, 24420, 24427, 24430, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24468, 24474, 24477, 24482, 24485, 24503, 24515, 24526, 24530, 24536, 24544, 24552, 24567, 24580, 24582, 24584, 24635, 24641, 24644, 24647, 24662, 24688, 24692, 24704, 24707, 24715, 24723, 24761, 24769, 24805, 24865, 24866, 24867, 24875, 24881, 24885, 24905, 24911, 24918, 24923, 24935, 24953, 24960, 24963, 24968, 24993, 25017, 25020, 25051, 25053, 25055, 25057, 25059, 25061, 25072, 25086, 25088, 25104, 25106, 25123, 25131, 25136, 25146, 25154, 25157, 25197, 25224, 25259, 25267, 25275, 25282, 25286, 25288, 25290, 25333, 25335, 25387, 25401, 25407, 25409, 25418, 25425, 25447, 25494, 25520, 25541, 25545, 25582, 25641, 25667, 25671, 25678, 25694, 25710, 25725, 25728, 25730, 25732, 25734, 25743, 25744, 25749, 25755, 25764, 25780, 25800, 25842, 25844, 25896, 25905, 25921, 25945, 26085, 26144, 26200, 26203, 26215, 26219, 26221, 26231, 26265, 26270, 26274, 26280, 26282, 26284, 26287, 26300, 26599, 32027, 32029, 32031, 32033, 32035, 32037, 32040, 32042, 32046, 32048, 32050, 32052, 32055, 32058, 32060, 32062, 32064, 32067, 32069, 32072, 32075, 32077, 32079, 32082, 32084, 32087, 32089, 32091, 32122, 32125, 32127, 32129, 32132, 32137, 32141, 32250, 33356, 33359, 33361, 33363, 33365, 33368, 33370, 33373, 33375, 33377, 33379, 33384, 33389, 33393, 33396, 33398, 33401, 33403, 33407, 33419, 33436, 33440, 33442, 33444, 33447, 33449, 33452, 33454, 33475, 33477, 33482, 33484, 33490, 33492, 33525, 33530, 33539, 33551, 33553, 33558, 33560, 33571, 33573, 33581, 33586, 33593, 33602, 33614, 33658, 33672, 33674, 33711, 35673, 35675, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 38497, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 40040, 40042, 40044, 40046, 40048, 40053, 40059, 40061, 40071, 40073, 40093, 40099, 40121, 40135, 40140, 40149, 40173, 40179, 40181, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40279, 40311, 40316, 40323, 40326, 40331, 40358, 40367, 40379, 40382, 40413, 40425, 40431, 40454, 43079, 43081, 43084, 43093, 43098, 43104, 43115, 43127, 43143, 43229, 43232, 43263, 43321, 43439, 43446, 43453, 43460, 43494, 46105, 46142, 46478, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46909, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47063, 47081, 47198, 47202, 47289, 47309, 47326, 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, 48032, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49801, 49811, 49837, 49849, 49980, 49983, 49985, 49987, 49989, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50070, 50079, 50089, 50104, 50128, 50134, 50148, 50166, 50205, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50688, 50690, 50695, 50697, 50699, 50702, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50736, 50742, 50744, 50747, 50764, 50772, 50784, 50790, 50802, 50805, 50812, 51509, 51513, 51517, 51914) 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: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Macbeth

Afterpiece Title: HARLEQUIN AND FAUSTUS

Song: As17931227, but Mrs Follett in place of Mrs Clendining

Performances

Mainpiece Title: Love's Frailties

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: THE SAILOR'S FESTIVAL; or, All Alive at Portsmouth

Afterpiece Title: MARIAN

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Everyone Has His Fault

Afterpiece Title: THE SAILOR'S FESTIVAL

Afterpiece Title: THE TWO MISERS

Music: End of Act II of mainpiece concerto on the Piano Forte, composed by Krumpholtz, accompanied by the Full Band, by Miss Poole

Song: End of Act IV of mainpiece Mad Bm, in character, by Miss Poole

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: THE SAILOR'S FESTIVAL

Afterpiece Title: THE POOR SOLDIER

Song: In Act II of mainpiece the Grand Triumphal Entry of Alexander into Babylon. Vocal Parts by Johnstone, Incledon, Cubitt, Rock//Mrs Mountain, Miss Stuart, Miss Leserve, Miss Barnett, Mrs Lloyd, Mrs Martyr. In the course of the Evening Black-Eyed Susan by Incledon

Performances

Mainpiece Title: Robin Hood

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: British Fortitude And Hibernian Friendship

Afterpiece Title: KING LEAR

Afterpiece Title: NETLEY ABBEY

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: THE PACKET-BOAT; or, A Peep behind the Veil

Afterpiece Title: BRITISH FORTITUDE AND HIBERNIAN FRIENDSHIP

Monologue: 1794 05 13 End of Act I of 1st piece A Plague on both your Houses; or, A Peep into New Drury and Covent-Garden Theatres, to conclude with a Comic Song, in the Character of an Old Woman of Eighty, by Munden

Performances

Mainpiece Title: British Fortitude And Hibernian Friendship

Afterpiece Title: THE COMEDY OF ERRORS

Afterpiece Title: THE PACKET-BOAT

Song: In Act III of 2nd piece, as17931008

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: THE SAILOR'S FESTIVAL

Afterpiece Title: MODERN ANTIQUES

Song: End of Act IV of 1st piece Mad Bess, as17940425; In the course of the Evening Black-Eyed Susan, as17940502