SELECT * FROM london_stages WHERE eventid IN (9645, 12916, 12928, 12948, 13026, 13037, 13044, 13048, 13057, 13080, 13084, 13120, 13124, 13145, 13153, 13168, 13194, 13207, 13212, 13217, 13234, 13247, 13251, 13269, 13278, 13285, 13293, 13300, 13303, 13323, 13336, 13340, 13348, 13504, 13523, 13569, 13575, 38015, 41582, 41588, 41595, 41613, 41628, 41644, 41650, 41668, 41670, 41673, 41676, 41677, 41679, 41681, 41683, 41684, 41685, 41686, 41696, 41708, 41740, 41742, 41744, 41746, 41748, 41750, 41752, 41754, 41756, 41758, 41760, 41769, 41773, 41775, 41783, 41787, 41792, 41796, 41801, 41806, 41811, 41817, 41825, 41855, 41908, 41913, 41917, 41930, 41935, 41944, 41970, 41975, 41989, 41997, 42002, 42041, 42046, 42060, 42080, 42095, 42097, 42100, 42108, 42113, 42116, 42123, 42133, 42165, 42166, 42168, 42170, 42171, 42173, 42175, 42176, 42179, 42183, 42184, 42186, 42191, 42192, 42195, 42199, 42200, 42203, 42205, 42207, 42208, 42210, 42211, 42212, 42214, 42217, 42220, 42221, 42224, 42225, 42228, 42229, 42231, 42234, 42238, 42242, 42247, 42248, 42249, 42255, 42258, 42261, 42262, 42264, 42265, 42267, 42268, 42277, 42298, 42309, 42315, 42331, 42333, 42335, 42368, 42376, 42395, 42407, 42411, 42439, 42464, 42478, 42480, 42493, 42517, 42589, 42602, 42671, 42681, 42686, 42698, 42701, 42706, 42734, 42738, 42750, 42753, 42755, 42758, 42760, 42762, 42764, 42765, 42767, 42768, 42769, 42770, 42773, 42774, 42775, 42777, 42778, 42780, 42782, 42783, 42785, 42789, 42790, 42792, 42797, 42802, 42803, 42805, 42806, 42808, 42810, 42814, 42815, 42816, 42819, 42821, 42822, 42823, 42825, 42827, 42830, 42831, 42835, 42837, 42839, 42841, 42843, 42845, 42849, 42851, 42859, 42863, 42865, 42888, 42892, 42900, 42902, 42907, 42910, 42915, 42941, 42943, 42945, 42967, 42983, 42996, 43002, 43014, 43035, 43103, 43107, 43109, 43112, 43114, 43119, 43121, 43126, 43133, 43140, 43147, 43162, 43166, 43169, 43199, 43216, 43218, 43241, 43254, 43256, 43292, 43299, 43302, 43304, 43312, 43314, 43317, 43323, 43326, 43327, 43329, 43330, 43332, 43333, 43337, 43339, 43340, 43346, 43350, 43352, 43353, 43355, 43357, 43366, 43368, 43369, 43370, 43372, 43375, 43378, 43381, 43382, 43384, 43388, 43391, 43394, 43395, 43399, 43402, 43404, 43406, 43409, 43415, 43417, 43425, 43426, 43427, 43428, 43429, 43430, 43431, 43432, 43434, 43440, 43454, 43467, 43483, 43485, 43520, 43524, 43554, 43558, 43579, 43593, 43605, 43607, 43621, 43630, 43643, 43780, 43805, 43867, 43887, 43897, 43899, 43902, 43905, 43906, 43908, 43912, 43913, 43914, 43917, 43919, 43920, 43922, 43923, 43925, 43926, 43927, 43929, 43931, 43932, 43934, 43935, 43936, 43938, 43940, 43942, 43944, 43945, 43948, 43951, 43956, 43957, 43959, 43962, 43964, 43965, 43968, 43971, 43982, 43983, 43987, 43988, 43991, 43997, 44001, 44005, 44008, 44014, 44017, 44020, 44021, 44022, 44023, 44025, 44149, 44151, 44153, 44157, 44174, 44180, 44188, 44230, 44237, 44242, 44244, 44267, 44284, 44293, 44322, 44324, 44369, 44382, 44402, 44419, 44427, 44439, 44442, 44449, 44464, 44480, 44483, 44484, 44486, 44489, 44490, 44492, 44493, 44495, 44496, 44498, 44499, 44501, 44504, 44510, 44514, 44515, 44517, 44523, 44525, 44526, 44527, 44528, 44532, 44538, 44542, 44549, 44550, 44553, 44555, 44556, 44559, 44560, 44562, 44564, 44565, 44566, 44567, 44568, 44570, 44573, 44574, 44575, 44578, 44580, 44582, 44583, 44584, 44586, 44587, 44589, 44593, 44595, 44628, 44634, 44650, 44652, 44654, 44656, 44658, 44662, 44666, 44670, 44674, 44678, 44680, 44682, 44686, 44690, 44694, 44698, 44726, 44731, 44743, 44746, 44750, 44757, 44764, 44776, 44787, 44796, 44863, 44884, 44903, 44909, 44917, 44925, 44927, 44929, 44939, 44946, 44952, 44955, 44959, 44969, 44971, 44973, 44975, 44998, 45004, 45007, 45013, 45018, 45020, 45025, 45030, 45039, 45041, 45043, 45047, 45135, 45139, 45143, 45150, 45154, 45156, 45158, 45166, 45169, 45174, 45176, 45180, 45184, 45188, 45192, 45196, 45204, 45208, 45216, 45222, 45228, 45232, 45234, 45236, 45238, 45240, 45244, 45248, 45252, 45257, 45262, 45274, 45280, 45295, 45297, 45307, 45330, 45338, 45344, 45349, 45356, 45361, 45386, 45399, 45403, 45412, 45420, 45433, 45438, 45442, 45454, 45466, 45472, 45475, 45477, 45482, 45487, 45497, 45502, 45504, 45511, 45517, 45521, 45524, 45526, 45534, 45539, 45547, 45554, 45559, 45567, 45577, 45579, 45589, 45591, 45595, 45693, 45698, 45704, 45716, 45724, 45726, 45733, 45735, 45740, 45748, 45756, 45771, 45775, 45789, 45793, 45795, 45803, 45807, 45809, 45811, 45813, 45815, 45817, 45819, 45825, 45827, 45838, 45854, 45856, 45860, 45871, 45874, 45880, 45890, 45894, 45899, 45902, 45904, 45909, 45911, 45920, 45923, 45951, 45958, 45978, 45980, 46011, 46028, 46031, 46036, 46038, 46040, 46042, 46045, 46047, 46050, 46052, 46055, 46058, 46068, 46078, 46080, 46085, 46093, 46098, 46100, 46103, 46112, 46115, 46118, 46121, 46127, 46133, 46140, 46143, 46146, 46148, 46157, 46160, 46163, 46166, 46174, 46176, 46186, 46189, 46198, 46287, 46295, 46303, 46305, 46309, 46313, 46315, 46325, 46331, 46338, 46345, 46351, 46363, 46367, 46375, 46377, 46387, 46397, 46399, 46401, 46405, 46411, 46421, 46423, 46433, 46436, 46438, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46474, 46483, 46490, 46492, 46497, 46500, 46506, 46511, 46519, 46524, 46529, 46533, 46538, 46543, 46547, 46552, 46564, 46575, 46580, 46585, 46593, 46602, 46607, 46609, 46614, 46619, 46627, 46632, 46642, 46644, 46654, 46686, 46688, 46700, 46708, 46711, 46718, 46726, 46729, 46731, 46732, 46736, 46737, 46739, 46743, 46744, 46749, 46757, 46759, 46760, 46761, 46762, 46764, 46765, 46768, 46770, 46773, 46776, 46778, 46780, 46785, 46786, 46787, 46789, 46792, 46801, 46802, 46805, 46810, 46812, 46813, 46816, 46841, 46849, 46863, 46885, 46897, 46915, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46945, 46947, 46951, 46953, 46955, 46963, 46973, 47001, 47005, 47013, 47025, 47027, 47031, 47037, 47041, 47043, 47047, 47049, 47051, 47057, 47059, 47061, 47063, 47066, 47068, 47071, 47073, 47076, 47079, 47083, 47088, 47091, 47104, 47167, 47198, 47202, 47207, 47212, 47214, 47218, 47224, 47235, 47238, 47244, 47247, 47253, 47261, 47264, 47266, 47277, 47279, 47283, 47289, 47297, 47301, 47306, 47309, 47312, 47315, 47320, 47321, 47326, 47329, 47331, 47338, 47341, 47356, 47362, 47363, 47366, 47368, 47431, 47437, 47442, 47444, 47449, 47464, 47472, 47482, 47495, 47499, 47501, 47503, 47507, 47509, 47513, 47515, 47517, 47519, 47521, 47523, 47525, 47527, 47529, 47531, 47533, 47537, 47539, 47541, 47543, 47553, 47561, 47564, 47566, 47568, 47570, 47575, 47577, 47603, 47605, 47614, 47621, 47625, 47631, 47633, 47643, 47645, 47647, 47655, 47672, 47676, 47678, 47683, 47685, 47823, 47825, 47838, 47867, 47877, 47894, 48006, 48023, 48026, 48029, 48039, 48047, 48057, 48070, 48074, 48078, 48088, 48093, 48099, 48107, 48135, 48139, 48144, 48724, 48734, 48744, 48890, 49231, 49267, 49281, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49384, 49417, 49424, 49444, 49502, 49808, 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, 50060, 50081, 50096, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50346, 50347, 50349, 50351, 50357, 50359, 50365, 50367, 50369, 50372, 50375, 50377, 50379, 50381, 50382, 50384, 50390, 50397, 50399, 50403, 50405, 50407, 50409, 50417, 50423, 50432, 50437, 50439, 50453, 50460, 50474, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50533, 50537, 50542, 50558, 50570, 50613, 50643, 51106, 51109, 51111, 51113, 51115, 51120, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51230, 51233, 51236, 51240, 51243, 51248, 51251, 51253, 51257, 51260, 51262, 51267, 51270, 51276, 51279, 51284, 51287, 51289, 51294, 51299, 51301, 51303, 51308, 51311, 51318, 51321, 51323, 51326, 51328, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51377, 51380, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51582, 51588, 51592, 51597, 51600, 51609, 51611, 51612, 51618, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51705, 51709, 51712, 51715, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51793, 51840, 51842, 51846, 51884, 51926, 51970, 51972, 52084, 52086, 52088, 52091, 52117, 52119, 52163, 52201, 52203, 52334, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52370, 52376, 52482) 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 London Merchant

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Siege Of Belgrade

Dance: As17970104

Performances

Mainpiece Title: Isabella

Ballet: The Scotch Ghost. As17961221

Song: As17960924

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Prize

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: Theodosius; Or, The Force Of Love

Song: Mainpiece: Vocal Parts-Dignum, Sedgwick, Cooke, Wentworth, Maddocks, Welsh, Grimaldi, Evans, J. Fisher, Gregson, Tett, Mrs Butler, Mrs Maddocks, Mrs Granger, Mrs Roffey, Mrs Gawdry, Mrs Benson, Mrs Menage

Performances

Mainpiece Title: Theodosius

Ballet: The Scotch Ghost. As17961221

Song: As17970120

Performances

Mainpiece Title: The London Merchant

Performances

Mainpiece Title: Tamerlane

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Coriolanus

Cast
Role: Young Marcius Actor: Master Wells

Afterpiece Title: The Shipwreck

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Blue-Beard; or, Female Curiosity

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Isabella

Afterpiece Title: Blue-Beard

Song: As17971030

Performances

Mainpiece Title: The Will

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Blue-Beard

Song: Mainpiece: Vocal Parts, as17971209, but _Brown, _Fisher, _Evans, _Phillimore, Ms _Butler, Ms _Jackson, Ms _Benson, Ms _Menage, Ms _Gaudry

Monologue: The Masque of Neptune and Amphitrite. As 9 Dec. 1797

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Blue-Beard

Song: Chorus of Witches and Spirits, as17971107, but Miss Wentworth, Miss _Menage, _Kelly, Mrs _Bland

Performances

Mainpiece Title: First Love

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Blue-Beard