SELECT * FROM london_stages WHERE eventid IN (9348, 13700, 13703, 13707, 13711, 38728, 39083, 39086, 39093, 39104, 39260, 39276, 39280, 39282, 39285, 39298, 39301, 39317, 39329, 39333, 39335, 39341, 39445, 39447, 39451, 39453, 39497, 39508, 39511, 39513, 39518, 39522, 39539, 39546, 39581, 39603, 40585, 40591, 40712, 40727, 40895, 41015, 41019, 41020, 41022, 41023, 41026, 41027, 41028, 41030, 41031, 41033, 41034, 41035, 41041, 41043, 41044, 41048, 41049, 41050, 41053, 41054, 41055, 41056, 41057, 41058, 41059, 41060, 41061, 41062, 41063, 41064, 41065, 41066, 41067, 41068, 41069, 41070, 41071, 41072, 41073, 41076, 41077, 41079, 41080, 41081, 41083, 41084, 41085, 41086, 41087, 41088, 41089, 41091, 41092, 41094, 41095, 41096, 41097, 41099, 41100, 41101, 41104, 41106, 41107, 41109, 41110, 41197, 41333, 41589, 41592, 41597, 41600, 41606, 41607, 41616, 41623, 41627, 41629, 41630, 41634, 41636, 41639, 41646, 41647, 41648, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41661, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41671, 41672, 41673, 41674, 41678, 41680, 41682, 41685, 41891, 41907, 42053, 42168, 42170, 42171, 42175, 42178, 42182, 42183, 42186, 42190, 42195, 42225, 42232, 42235, 42237, 42238, 42239, 42240, 42241, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42251, 42252, 42253, 42254, 42255, 42256, 42257, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42282, 42760, 42765, 42777, 42787, 42788, 42791, 42794, 42795, 42797, 42798, 42799, 42800, 42805, 42807, 42810, 42811, 42812, 42814, 42817, 42818, 42819, 42820, 42822, 42823, 42825, 42826, 42827, 42828, 42829, 42830, 42831, 42832, 42837, 42839, 42841, 42842, 42843, 42844, 42846, 42848, 42850, 42853, 43319, 43322, 43323, 43326, 43327, 43330, 43333, 43337, 43339, 43343, 43347, 43349, 43350, 43352, 43353, 43355, 43356, 43357, 43358, 43360, 43361, 43363, 43364, 43366, 43371, 43372, 43373, 43377, 43378, 43379, 43382, 43383, 43384, 43386, 43387, 43389, 43391, 43392, 43393, 43394, 43397, 43398, 43399, 43400, 43401, 43402, 43403, 43404, 43407, 43412, 43414, 43415, 43421, 43422, 43423, 43424, 43431, 43433, 43434, 43437, 43515, 43902, 43909, 43916, 43920, 43923, 43926, 43927, 43929, 43931, 43932, 43934, 43935, 43936, 43938, 43942, 43944, 43946, 43953, 43960, 43963, 43964, 43969, 43970, 43972, 43975, 43977, 43979, 43981, 43983, 43984, 43985, 43986, 43988, 43989, 43991, 43992, 43993, 43994, 43997, 43999, 44001, 44003, 44004, 44005, 44006, 44007, 44009, 44010, 44011, 44012, 44013, 44015, 44016, 44017, 44018, 44019, 44021, 44023, 44024, 44025, 44476, 44480, 44483, 44484, 44486, 44496, 44501, 44503, 44510, 44514, 44517, 44521, 44523, 44525, 44526, 44527, 44529, 44532, 44533, 44535, 44539, 44542, 44547, 44548, 44549, 44550, 44552, 44555, 44557, 44560, 44561, 44562, 44563, 44565, 44567, 44568, 44573, 44574, 44575, 44576, 44578, 44580, 44581, 44582, 44583, 44584, 44585, 44586, 44587, 45002, 45008, 45044, 45045, 45048, 45073, 45100, 45104, 45105, 45109, 45113, 45114, 45116, 45597, 45600, 45604, 45607, 45608, 45613, 45617, 45618, 45619, 45621, 45624, 45625, 45628, 45629, 45630, 45633, 45634, 45635, 45636, 45637, 45639, 45640, 45641, 45643, 45644, 45646, 45647, 45649, 45653, 45655, 45656, 45657, 45658, 45659, 45660, 45661, 45662, 45664, 45665, 45668, 45670, 45671, 45673, 45674, 45675, 45676, 45677, 45678, 45680, 45681, 45682, 45685, 45687, 45689, 46122, 46128, 46138, 46144, 46149, 46155, 46161, 46167, 46172, 46177, 46179, 46180, 46181, 46182, 46183, 46184, 46185, 46187, 46190, 46191, 46193, 46196, 46197, 46199, 46201, 46204, 46206, 46207, 46208, 46209, 46210, 46211, 46214, 46215, 46216, 46217, 46219, 46221, 46225, 46227, 46228, 46229, 46230, 46231, 46232, 46233, 46234, 46236, 46237, 46238, 46239, 46240, 46241, 46243, 46245, 46246, 46247, 46248, 46249, 46250, 46251, 46253, 46254, 46255, 46256, 46257, 46258, 46259, 46735, 46736, 46739, 46740, 46741, 46742, 46744, 46745, 46747, 46748, 46749, 46750, 46752, 46753, 46754, 46755, 46756, 46757, 46759, 46760, 46762, 46763, 46764, 46765, 46767, 46768, 46769, 46770, 46772, 46773, 46775, 46777, 46778, 46779, 46780, 46782, 46783, 46784, 46785, 46786, 46787, 46788, 46789, 46790, 46791, 46792, 46793, 46794, 46795, 46797, 46798, 46799, 46801, 46802, 46803, 46804, 46805, 46807, 46809, 46810, 46811, 46812, 46813, 46814, 46815, 46816, 46817, 46818, 46819, 46820, 46821, 46822, 46824, 46825, 46826, 47307, 47313, 47323, 47329, 47331, 47334, 47338, 47339, 47341, 47342, 47345, 47346, 47349, 47350, 47353, 47356, 47357, 47361, 47362, 47363, 47366, 47368, 47370, 47371, 47373, 47374, 47376, 47380, 47381, 47382, 47383, 47384, 47385, 47386, 47387, 47388, 47389, 47390, 47391, 47392, 47393, 47394, 47395, 47396, 47397, 47398, 47399, 47400, 47403, 47404, 47405, 47407, 47409, 47410, 47411, 47412, 47413, 47414, 47415, 47416, 47417, 47419, 47421, 47422, 47423, 47424, 47427, 47428, 47430, 47498, 47504, 47532, 47544, 47576, 47588, 47912, 47914, 47915, 47916, 47917, 47919, 47920, 47921, 47922, 47924, 47927, 47929, 47930, 47931, 47934, 47936, 47937, 47938, 47941, 47942, 47944, 47945, 47947, 47948, 47950, 47951, 47952, 47954, 47955, 47956, 47957, 47958, 47959, 47960, 47961, 47962, 47963, 47965, 47966, 47967, 47968, 47969, 47970, 47972, 47974, 47976, 47977, 47979, 47980, 47981, 47982, 47985, 47986, 47987, 47988, 47990, 47991, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48112, 48122, 48136, 48145, 48149, 48153, 48157, 48169, 48173, 48181, 48185, 48208, 48222, 48277, 48319, 48340, 48401, 48415, 48429, 48445, 48448, 48450, 48453, 48454, 48456, 48458, 48459, 48461, 48464, 48466, 48467, 48469, 48470, 48471, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48481, 48482, 48483, 48484, 48485, 48487, 48488, 48489, 48490, 48491, 48492, 48494, 48495, 48496, 48497, 48498, 48499, 48501, 48502, 48503, 48504, 48505, 48507, 48508, 48511, 48512, 48513, 48515, 48516, 48518, 48519, 48521, 48522, 48524, 48526, 48528, 48529, 48530, 48531, 48532, 48533, 48538, 48540, 48542, 48544, 48546, 48552, 48554, 48560, 48564, 48568, 48572, 48576, 48587, 48589, 48597, 48604, 48612, 48622, 48632, 48638, 48646, 48648, 48660, 48680, 48756, 48790, 48864, 48869, 49030, 49045, 49060, 49123, 49125, 49126, 49127, 49128, 49129, 49130, 49132, 49133, 49134, 49135, 49136, 49137, 49138, 49139, 49140, 49141, 49142, 49143, 49144, 49145, 49146, 49147, 49148, 49149, 49150, 49151, 49152, 49153, 49155, 49156, 49157, 49158, 49162, 49163, 49164, 49165, 49166, 49168, 49169, 49170, 49171, 49172, 49174, 49175, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49187, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49384, 49417, 49424, 49444, 49951, 49953, 49956, 49958, 50030, 50060, 50346, 50347, 50349, 50351, 50357, 50359, 50365, 50372, 50377, 50382, 50384, 50397, 50405, 50407, 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, 50643, 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 London Merchant

Afterpiece Title: Robinson Crusoe; or, Harlequin Friday

Performances

Mainpiece Title: A Bold Stroke For A Wife

Performances

Mainpiece Title: Macbeth

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

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: Know Your Own Mind

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961219

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)