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, 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, 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, 51233, 51236, 51240, 51260, 51262, 51267, 51270, 51279, 51284, 51287, 51294, 51299, 51301, 51311, 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 Grecian Daughter

Afterpiece Title: My Grandmother

Ballet: End: The Scotch Ghost. As17961108, but Glaude-Grimaldi

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Richard Coeur de Lion

Dance: In III afterpiece: Dance, as17961019

Ballet: End: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The Conspiracy

Afterpiece Title: Harlequin Captive

Cast
Role: Furies Actor: Roffey, Wells, Master Gregson

Performances

Mainpiece Title: Isabella

Afterpiece Title: Harlequin Captive

Cast
Role: Furies Actor: Roffey, Wells, Master Gregson

Song: III: Epithalamium-; Vocal Parts-Mrs Bland, Master Welsh

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Devil to Pay

Ballet: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The London Merchant; Or, George Barnwell

Afterpiece Title: The Adopted Child

Ballet: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Devil to Pay

Ballet: The Scotch Ghost. As17961112

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: The Child of Nature

Afterpiece Title: The Apprentice

Dance: III 1st piece: Dance, as17961019

Ballet: End 2nd piece: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: The Devil to Pay

Ballet: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Shipwreck

Ballet: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Shipwreck

Ballet: End: The Scotch Ghost. As17961112, but Hornpipe-_

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Robinson Crusoe; or, Harlequin Friday

Performances

Mainpiece Title: A Bold Stroke For A Wife

Performances

Mainpiece Title: Know Your Own Mind

Performances

Mainpiece Title: Romeo And Juliet

Performances

Mainpiece Title: The Rivals

Performances

Mainpiece Title: Mary Queen Of Scots

Performances

Mainpiece Title: The Conscious Lovers

Song: As17961220

Performances

Mainpiece Title: The Siege Of Belgrade

Ballet: End I: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: Who's the Dupe

Ballet: End: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Douglas

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Honey Moon

Performances

Mainpiece Title: The London Merchant

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Siege Of Belgrade

Dance: As17970104