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: The Cherokee

Afterpiece Title: The Citizen

Performances

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Pirates

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Deaf Lover

Performances

Mainpiece Title: The Purse

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: Sylvester Daggerwood

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: A Trip to the Nore

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