SELECT * FROM london_stages WHERE eventid IN (2641, 3529, 3534, 3611, 3961, 3996, 4121, 4185, 4375, 4387, 4662, 4719, 4731, 4737, 4784, 4792, 4835, 4923, 4945, 4990, 5395, 5738, 5875, 5934, 6162, 6296, 6726, 6929, 7032, 7112, 7229, 7572, 7661, 7876, 8117, 8215, 8541, 8702, 8727, 8788, 8873, 8942, 9000, 9097, 9198, 9249, 9399, 9411, 9507, 9522, 9524, 9673, 9784, 9930, 9955, 9993, 10004, 10059, 10107, 10292, 10331, 10455, 10484, 10612, 10623, 10755, 10823, 10909, 10937, 11024, 11100, 11141, 11144, 11146, 11229, 11295, 11371, 11393, 11489, 11522, 11747, 11749, 11849, 11904, 12087, 12096, 12188, 12224, 12353, 12568, 12663, 12732, 12864, 13010, 13061, 13278, 13285, 13293, 13300, 13303, 13313, 13323, 13336, 13337, 13340, 13348, 13740, 13743, 13829, 13858, 13868, 13872, 13909, 14119, 14172, 14463, 14553, 14760, 14791, 14859, 14864, 15135, 15152, 15307, 15339, 15399, 15551, 15584, 15601, 15604, 15727, 15730, 15794, 15797, 15815, 15821, 15824, 15827, 15829, 15831, 15835, 15838, 15862, 15884, 15922, 15930, 15941, 16070, 16091, 16097, 16311, 16368, 16369, 16464, 16482, 16496, 16497, 16541, 16608, 16736, 16749, 16853, 16984, 16990, 17188, 17224, 17444, 17528, 17561, 17565, 17568, 17571, 17575, 17578, 17582, 17615, 17655, 17658, 17661, 17680, 17741, 17759, 17800, 17892, 17897, 17912, 17966, 17970, 17987, 18012, 18038, 18115, 18191, 18320, 18593, 18627, 18637, 18734, 18752, 18868, 18879, 18939, 19033, 19089, 19117, 19143, 19178, 19287, 19301, 19376, 19448, 19453, 19457, 19464, 19474, 19498, 19499, 19568, 19569, 19579, 19617, 19653, 19729, 19736, 19744, 19746, 19754, 19793, 19837, 19851, 19869, 20022, 20032, 20052, 20422, 20548, 20580, 20634, 20659, 20683, 20720, 20825, 20918, 20925, 20953, 20970, 20974, 21011, 21056, 21077, 21104, 21150, 21212, 21262, 21282, 21306, 21308, 21319, 21322, 21347, 21411, 21451, 21517, 21735, 21766, 21822, 21866, 21879, 21914, 21947, 21991, 22043, 22059, 22199, 22209, 22247, 22252, 22254, 22424, 22468, 22506, 22571, 22680, 22803, 22908, 22930, 22945, 23000, 23052, 23092, 23095, 23117, 23124, 23133, 23134, 23166, 23172, 23175, 23301, 23366, 23466, 23553, 23614, 23622, 23729, 23746, 23758, 23859, 24066, 24073, 24160, 24564, 24621, 24686, 24689, 24746, 24797, 24852, 24916, 24970, 25003, 25151, 25155, 25280, 25289, 25334, 25379, 25394, 25443, 25506, 25520, 25541, 25703, 25728, 25760, 25896, 26017, 26076, 26124, 26199, 26303, 26388, 26422, 26466, 26538, 26640, 26641, 26646, 26650, 26655, 26667, 26688, 26755, 26757, 26761, 26768, 26785, 26808, 26809, 26813, 26826, 26899, 26928, 27051, 27095, 27096, 27144, 27183, 27185, 27194, 27217, 27221, 27292, 27300, 27325, 27333, 27401, 27402, 27424, 27559, 27579, 27673, 27675, 27714, 27742, 27809, 27871, 28075, 28084, 28096, 28137, 28139, 28198, 28274, 28340, 28343, 28345, 28348, 28350, 28357, 28363, 28398, 28504, 28509, 28526, 28555, 28557, 28631, 28732, 28769, 28780, 28906, 28962, 28967, 28973, 28978, 28991, 28993, 29002, 29005, 29010, 29019, 29043, 29047, 29050, 29061, 29071, 29164, 29190, 29249, 29301, 29341, 29357, 29376, 29381, 29384, 29386, 29388, 29390, 29400, 29402, 29405, 29410, 29414, 29421, 29437, 29439, 29503, 29515, 29520, 29606, 29721, 29833, 29841, 29992, 30013, 30016, 30019, 30059, 30061, 30063, 30084, 30109, 30146, 30223, 30322, 30403, 30460, 30473, 30476, 30480, 30482, 30485, 30487, 30490, 30494, 30497, 30499, 30599, 30671, 30711, 30788, 30862, 30874, 30884, 30896, 30919, 30955, 30979, 31031, 31043, 31098, 31136, 31149, 31151, 31159, 31169, 31194, 31207, 31226, 31234, 31257, 31356, 31361, 31410, 31412, 31465, 31660, 31686, 31723, 31771, 31777, 31844, 31849, 31874, 31878, 31886, 31896, 31902, 31903, 31912, 31914, 31915, 31927, 31938, 31964, 31974, 31991, 31992, 32004, 32015, 32017, 32035, 32058, 32061, 32092, 32096, 32106, 32156, 32160, 32174, 32196, 32207, 32214, 32218, 32234, 32249, 32320, 32333, 32373, 32415, 32422, 32436, 32445, 32485, 32516, 32592, 32624, 32631, 32636, 32675, 32686, 32696, 32713, 32730, 32749, 32809, 32828, 32836, 32893, 32911, 32945, 32987, 32990, 33013, 33060, 33093, 33101, 33135, 33149, 33152, 33178, 33199, 33273, 33288, 33298, 33347, 33381, 33440, 33456, 33458, 33461, 33463, 33468, 33472, 33481, 33521, 33522, 33531, 33535, 33539, 33592, 33597, 33598, 33610, 33639, 33653, 33657, 33674, 33691, 33695, 33799, 33802, 33823, 33867, 33906, 33968, 34015, 34026, 34039, 34049, 34051, 34076, 34082, 34102, 34103, 34142, 34161, 34180, 34202, 34220, 34234, 34235, 34250, 34260, 34265, 34268, 34271, 34273, 34274, 34276, 34278, 34279, 34281, 34284, 34286, 34288, 34290, 34292, 34293, 34294, 34296, 34298, 34300, 34302, 34305, 34307, 34310, 34312, 34316, 34323, 34325, 34326, 34329, 34331, 34332, 34334, 34351, 34380, 34415, 34453, 34485, 34521, 34526, 34544, 34598, 34603, 34606, 34608, 34616, 34619, 34621, 34627, 34631, 34634, 34636, 34668, 34694, 34703, 34713, 34715, 34720, 34723, 34739, 34749, 34754, 34758, 34777, 34785, 34805, 34807, 34895, 34902, 34923, 34957, 35017, 35063, 35094, 35214, 35246, 35287, 35295, 35300, 35314, 35316, 35327, 35502, 35513, 35570, 35668, 35719, 35767, 35784, 35788, 35849, 35856, 35863, 35879, 35880, 35895, 35905, 35907, 35934, 35964, 35973, 35975, 35992, 36081, 36130, 36134, 36153, 36158, 36175, 36179, 36182, 36189, 36235, 36237, 36242, 36263, 36287, 36320, 36373, 36418, 36498, 36503, 36516, 36547, 36556, 36575, 36602, 36637, 36654, 36672, 36734, 36796, 36861, 36872, 36953, 37034, 37059, 37222, 37271, 37334, 37374, 37387, 37439, 37441, 37452, 37468, 37551, 37609, 37612, 37660, 37662, 37788, 37820, 37875, 37876, 37890, 37975, 37992, 37995, 37997, 38001, 38009, 38012, 38014, 38017, 38019, 38024, 38043, 38054, 38074, 38089, 38118, 38124, 38148, 38168, 38173, 38191, 38201, 38222, 38225, 38240, 38247, 38312, 38324, 38333, 38335, 38340, 38348, 38372, 38397, 38421, 38460, 38468, 38503, 38508, 38540, 38575, 38578, 38580, 38583, 38585, 38588, 38596, 38598, 38603, 38609, 38611, 38613, 38620, 38624, 38639, 38659, 38668, 38676, 38684, 38694, 38706, 38714, 38725, 38728, 38744, 38749, 38767, 38775, 38857, 38873, 38883, 38891, 38907, 38935, 38951, 38956, 38974, 38980, 38983, 38987, 39083, 39086, 39171, 39182, 39185, 39236, 39257, 39348, 39447, 39454, 39469, 39477, 39479, 39481, 39485, 39494, 39526, 39528, 39531, 39533, 39535, 39537, 39540, 39545, 39549, 39556, 39565, 39575, 39591, 39629, 39667, 39736, 39774, 39837, 39845, 39862, 39864, 39877, 39887, 39891, 39946, 39997, 40092, 40126, 40142, 40227, 40231, 40267, 40282, 40285, 40289, 40292, 40294, 40295, 40297, 40302, 40305, 40308, 40340, 40353, 40355, 40358, 40360, 40362, 40367, 40372, 40392, 40398, 40403, 40406, 40408, 40413, 40422, 40431, 40433, 40438, 40444, 40446, 40448, 40450, 40532, 40574, 40579, 40601, 40635, 40695, 40697, 40733, 40735, 40758, 40784, 40827, 40831, 40914, 40956, 40979, 40987, 41001, 41109, 41119, 41131, 41144, 41169, 41184, 41217, 41275, 41381, 41424, 41427, 41429, 41434, 41450, 41454, 41455, 41479, 41495, 41512, 41524, 41528, 41539, 41546, 41577, 41607, 41738, 41762, 41764, 41767, 41771, 41775, 41778, 41780, 41787, 41835, 41837, 41840, 41842, 41845, 41847, 41857, 41871, 41925, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42016, 42036, 42060, 42065, 42067, 42086, 42097, 42102, 42105, 42106, 42118, 42128, 42143, 42215, 42216, 42218, 42221, 42224, 42226, 42229, 42232, 42237, 42242, 42243, 42283, 42284, 42321, 42339, 42361, 42374, 42379, 42381, 42481, 42490, 42514, 42516, 42551, 42575, 42615, 42620, 42622, 42624, 42628, 42635, 42637, 42645, 42686, 42708, 42713, 42716, 42719, 42727, 42728, 42732, 42740, 42879, 42880, 42882, 42884, 42886, 42887, 42896, 42901, 42904, 42912, 42920, 42952, 43003, 43057, 43059, 43062, 43067, 43069, 43095, 43109, 43110, 43112, 43113, 43114, 43118, 43119, 43121, 43122, 43124, 43126, 43130, 43133, 43140, 43141, 43147, 43148, 43162, 43166, 43169, 43170, 43172, 43180, 43183, 43186, 43198, 43200, 43208, 43217, 43219, 43222, 43224, 43227, 43234, 43239, 43241, 43242, 43249, 43255, 43257, 43265, 43267, 43268, 43270, 43274, 43305, 43308, 43313, 43336, 43374, 43376, 43392, 43423, 43425, 43427, 43430, 43433, 43447, 43541, 43580, 43661, 43670, 43673, 43683, 43858, 43866, 43912, 43919, 43944, 43945, 43951, 43956, 43967, 43986, 43987, 43993, 44007, 44011, 44015, 44034, 44051, 44189, 44190, 44350, 44372, 44439, 44451, 44481, 44495, 44508, 44538, 44541, 44566, 44570, 44580, 44585, 44600, 44635, 44650, 44652, 44654, 44658, 44662, 44666, 44670, 44674, 44678, 44682, 44686, 44690, 44694, 44737, 44741, 44743, 44750, 44757, 44759, 44764, 44776, 44787, 44796, 44824, 44859, 44862, 44870, 44871, 44873, 44879, 44883, 44909, 44911, 44912, 44913, 44929, 44931, 44949, 44951, 44960, 44964, 45007, 45029, 45039, 45040, 45051, 45057, 45063, 45086, 45098, 45108, 45133, 45139, 45143, 45152, 45236, 45249, 45313, 45333, 45384, 45455, 45461, 45470, 45500, 45524, 45562, 45564, 45583, 45608, 45617, 45633, 45635, 45637, 45639, 45641, 45643, 45647, 45651, 45653, 45657, 45676, 45678, 45682, 45683, 45687, 45689, 45703, 45709, 45761, 45770, 45829, 45842, 45943, 46036, 46065, 46139, 46145, 46146, 46278, 46319, 46570, 46574, 46584, 46599, 46607, 46608, 46626, 46657, 46710, 46712, 46741, 46748, 46756, 46764, 46777, 46780, 46784, 46792, 46793, 46794, 46798, 46799, 46800, 46802, 46807, 46809, 46813, 46815, 46842, 47037, 47067, 47238, 47261, 47290, 47321, 47331, 47338, 47341, 47356, 47361, 47362, 47363, 47366, 47368, 47442, 47449, 47669, 47824, 47839, 47928, 47932, 47937, 47959, 48157, 48163, 48173, 48198, 48246, 48279, 48310, 48312, 48314, 48326, 48328, 48333, 48351, 48352, 48365, 48366, 48367, 48368, 48396, 48397, 48450, 48456, 48464, 48469, 48470, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48484, 48485, 48487, 48488, 48489, 48490, 48492, 48494, 48495, 48496, 48497, 48515, 48516, 48519, 48524, 48526, 48529, 48530, 48532, 48533, 48562, 48592, 48676, 48678, 48686, 48690, 48748, 48959, 48984, 48988, 49009, 49038, 49041, 49056, 49066, 49077, 49081, 49083, 49100, 49126, 49148, 49161, 49171, 49172, 49177, 49181, 49183, 49310, 49553, 49658, 49713, 49718, 49731, 50254, 50265, 50275, 50283, 50290, 50296, 50303, 50310, 50312, 50313, 50316, 50322, 50428, 50435, 50444, 50466, 50544, 50731, 50904, 50907, 50981, 51054, 51377, 51441, 51446, 51462, 51611, 51704, 51742, 51824, 51959, 51964, 51969, 51985, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52029, 52030, 52035, 52044, 52046, 52049, 52050, 52051, 52053, 52274, 52506, 52545, 52589) 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: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: The Jew And The Doctor

Cast
Role: Harriet Actor: Miss Heard

Afterpiece Title: The Iron Chest

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: The Iron Chest

Cast
Role: Harriet Actor: Miss Heard

Afterpiece Title: The Shipwreck

Song: End: Jack and his Charming Fanny (composed by Suett)-Trueman

Performances

Mainpiece Title: Sighs

Afterpiece Title: Tars at Torbay; or, Sailors on Saturday Night

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Song: End 1st piece: Crazy Jane (composed by Miss Abrahams [recte Abrams])-Mrs Bland

Performances

Mainpiece Title: Blue Devils

Afterpiece Title: False and True

Cast
Role: Harriet Actor: Miss Heard

Afterpiece Title: The Jew and the Doctor

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Jew

Cast
Role: Harriet Actor: Miss Heard

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: Sighs

Afterpiece Title: Tars at Torbay

Cast
Role: Harriet Actor: Miss Heard

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Song: End 1st piece: Crazy Jane-Mrs Bland

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: Sighs

Afterpiece Title: Tars at Torbay

Cast
Role: Harriet Actor: Miss Heard

Afterpiece Title: The Castle of Sorrento

Cast
Role: Harriet Actor: Miss Heard

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: The Guardian

Cast
Role: Harriet Actor: Mrs Pope.

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Guardian

Cast
Role: Harriet Actor: Mrs Pope.

Dance: III: Hornpipe in Fetters-Blurton

Performances

Mainpiece Title: Ways And Means

Cast
Role: Harriet Actor: Miss Gaudry

Afterpiece Title: Obi

Performances

Mainpiece Title: What A Blunder

Afterpiece Title: The Guardian

Cast
Role: Miss Harriet Actor: A Young Lady