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 Mountaineers

Song: Mainpiece: Vocal Parts, as17930803, but _Little, _Brown, _Hobler, _Horsfall, _Saunders, _Dibble, _Lyons

Performances

Mainpiece Title: The Mountaineers

Song: As17930816

Performances

Mainpiece Title: The Mountaineers

Song: As17930816

Performances

Mainpiece Title: The Flitch Of Bacon

Afterpiece Title: Tit for Tat

Performances

Mainpiece Title: The Mountaineers

Song: As17930823

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Royal Clemency; or, The Deserter of Naples

Performances

Mainpiece Title: The Humourist

Afterpiece Title: The Children in the Wood

Afterpiece Title: Royal Clemency

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Royal Clemency

Performances

Mainpiece Title: She Stoops To Conquer; Or, The Mistakes Of A Night

Afterpiece Title: The Humourist

Performances

Mainpiece Title: The Box-lobby Challenge

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Afterpiece Title: THE ENGLISHMAN IN PARIS

Dance: In mainpiece Dances (composed by D'Egville) by Hamoir, G. D'Egville, Master D'Egville, Miss Menage, Miss Phillips, the Miss D'Egvilles, &c.; In Act II of afterpiece a Minuet by Hamoir and Miss De Camp

Performances

Mainpiece Title: All The World's A Stage

Afterpiece Title: THE BATTLE OF HEXHAM; or, Days of Old

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: THE MOUNTAINEERS

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: THE MOUNTAINEERS

Performances

Mainpiece Title: The Life And Death Of King Richard Iii

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: THE BATTLE OF HEXHAM

Afterpiece Title: MY GRANDMOTHER

Performances

Afterpiece Title: The Sultan

Dance: In: Dances (composed by D'Egville)-G. D'Egville, Master D'Egville, Miss Menage, Miss Phillips, the Miss D'Egvilles

Performances

Afterpiece Title: No Song No Supper

Dance: End II: a New Dance by J. D'Egville, in which-Fialon, Aumer will make their 1st appearance on this stage