SELECT * FROM london_stages WHERE eventid IN (287, 1136, 3808, 3839, 10132, 14711, 14734, 15479, 15480, 15482, 15487, 15762, 17910, 17917, 18163, 22073, 22541, 22699, 23551, 23555, 23595, 23626, 23667, 23670, 24295, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24824, 24827, 24828, 24829, 24830, 24831, 24832, 24833, 24834, 24835, 24836, 24837, 24838, 24839, 24840, 24841, 24842, 24843, 24844, 24845, 24846, 24847, 24848, 24849, 25142, 25153, 25185, 25310, 25313, 25316, 25322, 25326, 25724, 25735, 26475, 28788, 28790, 28810, 28813, 28820, 28822, 28839, 29061, 29327, 29419, 29449, 29551, 29564, 29580, 29604, 31822, 32269, 32273, 32274, 32275, 32276, 32277, 32278, 32279, 32281, 32282, 32283, 32285, 32287, 32290, 32292, 32294, 32295, 32297, 32298, 32299, 32303, 32304, 32309, 33684, 33745, 33748, 33752, 33757, 33759, 33765, 33770, 33789, 34251, 34297, 34304, 34308, 34309, 34322, 34333, 34338, 34688, 34696, 34719, 34866, 34870, 35212, 35245, 35347, 35364, 35380, 35384, 35387, 35443, 35454, 35484, 35501, 35515, 35557, 35591, 36182, 36185, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36283, 36285, 36288, 36290, 36292, 36299, 36306, 36311, 36316, 36325, 36327, 36363, 36553, 36687, 36707, 36729, 36732, 36734, 36737, 36739, 36741, 36743, 36746, 36748, 36751, 36757, 36760, 36765, 36767, 36771, 36779, 36783, 36826, 36831, 36835, 36842, 36856, 36859, 36869, 36874, 36884, 36898, 36912, 36915, 36924, 36926, 36931, 36937, 36940, 36942, 36948, 36953, 37003, 37017, 37022, 37040, 37050, 37056, 37081, 37192, 37194, 37198, 37228, 37230, 37236, 37252, 37254, 37258, 37269, 37300, 37308, 37320, 37332, 37334, 37336, 37341, 37346, 37353, 37360, 37362, 37367, 37372, 37383, 37385, 37387, 37389, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37440, 37442, 37444, 37458, 37461, 37463, 37466, 37468, 37471, 37473, 37476, 37480, 37486, 37491, 37496, 37504, 37511, 37515, 37518, 37520, 37529, 37541, 37567, 37573, 37607, 37609, 37617, 37647, 37649, 37660, 37668, 37674, 37676, 37678, 37782, 37784, 37788, 37792, 37794, 37798, 37800, 37804, 37806, 37808, 37812, 37814, 37816, 37818, 37820, 37822, 37824, 37826, 37830, 37834, 37836, 37838, 37840, 37842, 37844, 37846, 37850, 37857, 37859, 37865, 37867, 37871, 37873, 37876, 37879, 37881, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37922, 37926, 37929, 37931, 37934, 37938, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38004, 38027, 38029, 38046, 38048, 38063, 38071, 38079, 38094, 38108, 38113, 38119, 38124, 38129, 38139, 38144, 38173, 38184, 38189, 38191, 38193, 38198, 38201, 38211, 38222, 38234, 38237, 38240, 38251, 38310, 38312, 38314, 38316, 38319, 38322, 38324, 38331, 38333, 38335, 38338, 38340, 38344, 38346, 38348, 38350, 38352, 38354, 38360, 38362, 38365, 38368, 38370, 38372, 38377, 38379, 38382, 38384, 38388, 38408, 38411, 38413, 38416, 38418, 38421, 38423, 38426, 38428, 38430, 38432, 38435, 38437, 38440, 38442, 38444, 38446, 38449, 38451, 38454, 38456, 38769, 38859, 38865, 38871, 38874, 38882, 38886, 38909, 38922, 38931, 38935, 38940, 38943, 38945, 38947, 38949, 38952, 38954, 38957, 38959, 38963, 38966, 38968, 38971, 38980, 38983, 38985, 38987, 38991, 38995, 39000, 39004, 39009, 39012, 39017, 39018, 39024, 39025, 39027, 39029, 39031, 39032, 39034, 39036, 39037, 39038, 39039, 39041, 39042, 39043, 39044, 39046, 39047, 39048, 39049, 39051, 39052, 39054, 39055, 39056, 39057, 39058, 39060, 39063, 39065, 39066, 39067, 39068, 39070, 39072, 39073, 39074, 39076, 39077, 39082, 39084, 39086, 39087, 39089, 39094, 39096, 39098, 39101, 39103, 39108, 39114, 39115, 39124, 39129, 39136, 39137, 39138, 39147, 39152, 39157, 39161, 39163, 39166, 39178, 39182, 39185, 39191, 39199, 39200, 39206, 39211, 39220, 39223, 39226, 39229, 39231, 39237, 39242, 39246, 39251, 39262, 39270, 39271, 39277, 39281, 39286, 39313, 39316, 39321, 39323, 39325, 39330, 39446, 39450, 39452, 39456, 39464, 39469, 39473, 39475, 39479, 39483, 39485, 39490, 39492, 39494, 39496, 39498, 39503, 39507, 39509, 39512, 39514, 39517, 39523, 39528, 39531, 39533, 39535, 39537, 39540, 39545, 39549, 39551, 39556, 39561, 39565, 39568, 39573, 39575, 39577, 39579, 39582, 39584, 39587, 39589, 39598, 39604, 39610, 39622, 39633, 39635, 39638, 39642, 39647, 39652, 39656, 39658, 39664, 39667, 39669, 39674, 39679, 39681, 39685, 39688, 39691, 39694, 39696, 39698, 39700, 39703, 39705, 39708, 39710, 39712, 39714, 39717, 39724, 39727, 39732, 39736, 39744, 39755, 39760, 39765, 39770, 39773, 39782, 39792, 39798, 39806, 39808, 39813, 39819, 39824, 39829, 39833, 39838, 39855, 39858, 39862, 39867, 39869, 39874, 39878, 39884, 39887, 39889, 39895, 39899, 39916, 40017, 40018, 40020, 40022, 40024, 40026, 40027, 40028, 40030, 40032, 40034, 40036, 40038, 40046, 40051, 40055, 40057, 40061, 40063, 40065, 40067, 40069, 40071, 40077, 40079, 40081, 40087, 40089, 40091, 40093, 40095, 40099, 40107, 40112, 40114, 40116, 40118, 40121, 40123, 40126, 40128, 40130, 40132, 40135, 40140, 40144, 40146, 40151, 40154, 40156, 40158, 40160, 40163, 40165, 40167, 40176, 40179, 40181, 40183, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40231, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40263, 40270, 40276, 40279, 40282, 40285, 40289, 40292, 40295, 40297, 40302, 40305, 40308, 40311, 40316, 40323, 40324, 40326, 40331, 40335, 40338, 40340, 40345, 40350, 40353, 40355, 40358, 40360, 40362, 40364, 40367, 40369, 40372, 40374, 40377, 40379, 40382, 40384, 40387, 40389, 40391, 40396, 40401, 40403, 40408, 40413, 40416, 40418, 40420, 40422, 40425, 40428, 40433, 40436, 40438, 40441, 40444, 40446, 40448, 40450, 40454, 40566, 40568, 40572, 40574, 40576, 40578, 40580, 40582, 40584, 40587, 40589, 40590, 40593, 40594, 40596, 40598, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40622, 40624, 40628, 40632, 40634, 40636, 40638, 40640, 40649, 40651, 40653, 40655, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40695, 40697, 40700, 40706, 40708, 40711, 40712, 40714, 40717, 40719, 40721, 40723, 40726, 40727, 40729, 40732, 40734, 40736, 40748, 40750, 40752, 40765, 40767, 40772, 40775, 40777, 40784, 40787, 40789, 40792, 40795, 40797, 40801, 40804, 40809, 40813, 40816, 40819, 40842, 40848, 40852, 40856, 40866, 40870, 40873, 40880, 40884, 40886, 40889, 40891, 40898, 40900, 40902, 40905, 40907, 40910, 40912, 40917, 40922, 40925, 40928, 40933, 40951, 40956, 40960, 40962, 40965, 40970, 40980, 40983, 40989, 40999, 41010, 41123, 41197, 41459, 41487, 42992, 43099, 43156, 43830, 43833, 44031, 44078, 44227, 44230, 44233, 44237, 44242, 44244, 44247, 44249, 44253, 44256, 44261, 44263, 44286, 44293, 44311, 44315, 44319, 44328, 44337, 44374, 44377, 44414, 44427, 44432, 44437, 44459, 44589, 44591, 44593, 44595, 44597, 44599, 44601, 44605, 44616, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44634, 44636, 44641, 44643, 44645, 44647, 44648, 44650, 44652, 44654, 44656, 44658, 44660, 44662, 44666, 44668, 44670, 44672, 44674, 44678, 44680, 44682, 44684, 44686, 44688, 44690, 44692, 44694, 44696, 44698, 44705, 44710, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44778, 44780, 44783, 44785, 44787, 44789, 44791, 44794, 44796, 44799, 44805, 44808, 44815, 44817, 44818, 44819, 44822, 44828, 44834, 44836, 44840, 44847, 44853, 44857, 44860, 44863, 44867, 44874, 44876, 44880, 44884, 44887, 44897, 44907, 44909, 44911, 44915, 44920, 44922, 44925, 44927, 44929, 44931, 44934, 44936, 44941, 44944, 44946, 44952, 44957, 44964, 44969, 44971, 44975, 44980, 44983, 44986, 44989, 44990, 44992, 44995, 44996, 44998, 45001, 45004, 45007, 45008, 45013, 45016, 45020, 45022, 45025, 45027, 45030, 45032, 45035, 45037, 45040, 45041, 45043, 45044, 45047, 45051, 45053, 45055, 45056, 45057, 45059, 45063, 45065, 45068, 45073, 45074, 45075, 45076, 45077, 45078, 45081, 45083, 45084, 45086, 45087, 45088, 45089, 45091, 45092, 45096, 45101, 45107, 45108, 45110, 45113, 45114, 45115, 45116, 45117, 45118, 45121, 45122, 45123, 45124, 45127, 45129, 45130, 45131, 45137, 45141, 45143, 45147, 45159, 45164, 45166, 45169, 45174, 45176, 45178, 45180, 45182, 45184, 45188, 45192, 45196, 45204, 45208, 45214, 45216, 45222, 45224, 45228, 45232, 45236, 45238, 45240, 45244, 45248, 45252, 45255, 45257, 45262, 45264, 45274, 45278, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45302, 45305, 45307, 45310, 45314, 45316, 45319, 45321, 45324, 45326, 45328, 45330, 45333, 45335, 45344, 45347, 45352, 45354, 45356, 45378, 45384, 45394, 45397, 45399, 45407, 45410, 45420, 45425, 45433, 45436, 45438, 45442, 45444, 45449, 45451, 45459, 45461, 45464, 45466, 45469, 45475, 45477, 45480, 45482, 45485, 45492, 45495, 45500, 45509, 45511, 45517, 45519, 45521, 45524, 45526, 45529, 45531, 45534, 45539, 45542, 45544, 45547, 45554, 45557, 45559, 45562, 45567, 45569, 45574, 45577, 45582, 45587, 45589, 45591, 46148, 47102, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47416, 47419, 47424, 47468, 47476, 47876, 47907, 47919, 47946, 47947, 47957, 48018, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48110, 48112, 48116, 48120, 48122, 48130, 48132, 48138, 48177, 48235, 48263, 48270, 48274, 48277, 48279, 48284, 48291, 48310, 48319, 48340, 48401, 48415, 48429, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48566, 48568, 48570, 48574, 48939, 49030, 49045, 49060, 49133, 49135, 49137, 49167, 49172, 49231, 49239, 49255, 49279, 49304, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49370, 49375, 49379, 49424, 49444, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49808, 49828, 49932, 49937, 49958, 50137, 50306, 50308, 50310, 50974, 51004, 51051, 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, 51372, 51377, 51380, 51405, 51415, 51420, 51428, 51430, 51453, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51550, 51552, 51554, 51556, 51570, 51572, 51582, 51595, 51602, 51623, 51626, 51633, 51638, 51640, 51642, 51647, 51649, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51807, 51819, 51821, 51824, 51830, 51832, 51837, 51844, 51848, 51850, 51855, 51863, 51872, 51876, 51878, 51888, 51913, 51989, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52034, 52044, 52046, 52049, 52050, 52051, 52053) 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: First Love

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Blue-Beard

Ballet: End II: the Grand Anacreontic Ballet, Bacchus et Ariadne. Bacchus-Laborie; Ariadne-Mme Lombard Laborie; Theseus-St. Pierre; Phedra-Miss D'Egville; Silenus-Blake; Cupid-Master Menage; Hymen-Miss Denys; Chief Persons of the Train of Bacchus representing Divinities of Olympus-Didelot, Mme Hilligsberg, Miss J. Hilligsberg; Deities of the Olympus, with a Grand Procession of Bacchanals, Bacchants, Nymphs, Satyrs, Fauns-The whole Corps de Ballet from the Opera House; the celebrated Pas de Quatre from Panurge-Didelot, Laborie, Mme Laborie, Mme Hilligsberg

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Blue-Beard

Dance: Two Pas Seulsincidental to the Ballet-Mlle Favre Guiardele (for that night only); In afterpiece: a new Pas Seul-Mlle Parisot

Ballet: End II: a New Ballet (for that night only), Kitty and Jemmy. Jemmy-Mlle Parisot; Kitty-Sga Bossi DelCaro; the Other Characters-Fialon (for that night only), Master Menage, Miss Menage, Roffey, Whitmell, Wells, Male, Garman, W. Banks, Ms Brooker, Ms Daniels, Ms Brigg, Ms Haskey, Ms Illingham, Ms Byrne, Ms Willis, Ms Vining

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard