SELECT * FROM london_stages WHERE eventid IN (28128, 28134, 28136, 48999, 49003, 49025, 49030, 49045, 49060, 49080, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49117, 49119, 49120, 49122, 49190, 49194, 49198, 49200, 49202, 49205, 49210, 49212, 49213, 49218, 49225, 49227, 49230, 49239, 49241, 49243, 49245, 49247, 49249, 49251, 49253, 49255, 49257, 49263, 49265, 49267, 49269, 49277, 49279, 49281, 49283, 49289, 49291, 49293, 49299, 49301, 49304, 49306, 49311, 49318, 49320, 49323, 49325, 49327, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49358, 49361, 49363, 49365, 49367, 49370, 49372, 49375, 49377, 49379, 49381, 49389, 49393, 49395, 49398, 49403, 49407, 49410, 49412, 49415, 49419, 49451, 49453, 49457, 49461, 49464, 49471, 49474, 49477, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49512, 49516, 49519, 49524, 49526, 49528, 49533, 49535, 49540, 49544, 49549, 49552, 49559, 49564, 49572, 49574, 49577, 49579, 49582, 49584, 49586, 49588, 49591, 49593, 49596, 49598, 49601, 49603, 49608, 49613, 49615, 49619, 49624, 49626, 49634, 49636, 49639, 49643, 49648, 49758, 49760, 49763, 49765, 49769, 49771, 49773, 49774, 49776, 49778, 49781, 49782, 49784, 49786, 49789, 49790, 49793, 49795, 49798, 49800, 49802, 49804, 49806, 49808, 49810, 49812, 49816, 49820, 49822, 49824, 49826, 49828, 49830, 49832, 49834, 49838, 49840, 49842, 49844, 49846, 49848, 49850, 49852, 49856, 49858, 49860, 49862, 49864, 49866, 49868, 49870, 49872, 49874, 49876, 49878, 49880, 49882, 49885, 49887, 49890, 49892, 49894, 49896, 49899, 49901, 49904, 49906, 49909, 49911, 49914, 49916, 49918, 49923, 49925, 49930, 49934, 49937, 49939, 49942, 49944, 49946, 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, 50034, 50037, 50047, 50051, 50060, 50063, 50066, 50069, 50076, 50078, 50083, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50110, 50115, 50117, 50120, 50122, 50127, 50130, 50133, 50135, 50137, 50140, 50147, 50150, 50152, 50155, 50157, 50160, 50162, 50165, 50169, 50171, 50174, 50176, 50178, 50180, 50183, 50188, 50190, 50192, 50194, 50197, 50199, 50202, 50204, 50209, 50212, 50214, 50217, 50218, 50219, 50220, 50221, 50223, 50224, 50226, 50228, 50229, 50230, 50231, 50232, 50234, 50235, 50237, 50238, 50239, 50240, 50242, 50243, 50245, 50246, 50247, 50248, 50250, 50251, 50253, 50254, 50256, 50257, 50259, 50260, 50262, 50263, 50264, 50265, 50267, 50268, 50270, 50271, 50272, 50273, 50275, 50276, 50277, 50278, 50279, 50280, 50282, 50283, 50284, 50285, 50286, 50287, 50288, 50289, 50291, 50292, 50293, 50294, 50295, 50296, 50297, 50298, 50299, 50300, 50301, 50302, 50303, 50304, 50305, 50306, 50307, 50308, 50309, 50310, 50311, 50312, 50313, 50314, 50315, 50316, 50317, 50318, 50319, 50320, 50321, 50322, 50323, 50335, 50337, 50339, 50341, 50344, 50347, 50349, 50351, 50354, 50355, 50357, 50359, 50362, 50363, 50365, 50367, 50369, 50372, 50373, 50375, 50377, 50379, 50381, 50382, 50384, 50386, 50390, 50393, 50395, 50397, 50399, 50401, 50403, 50405, 50407, 50409, 50413, 50415, 50417, 50419, 50421, 50425, 50427, 50429, 50432, 50434, 50439, 50443, 50446, 50448, 50455, 50462, 50465, 50467, 50469, 50471, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50519, 50523, 50525, 50528, 50530, 50533, 50535, 50537, 50539, 50542, 50550, 50553, 50555, 50558, 50561, 50563, 50565, 50567, 50570, 50572, 50575, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50608, 50610, 50613, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50670, 50673, 50675, 50679, 50683, 50687, 50689, 50692, 50694, 50701, 50703, 50706, 50713, 50716, 50718, 50721, 50727, 50730, 50732, 50735, 50738, 50741, 50743, 50746, 50748, 50751, 50753, 50761, 50766, 50768, 50773, 50776, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50801, 50807, 50809, 50811, 50813, 50814, 50816, 50817, 50818, 50820, 50821, 50824, 50825, 50826, 50827, 50829, 50830, 50832, 50833, 50834, 50835, 50838, 50840, 50841, 50842, 50843, 50845, 50848, 50849, 50850, 50851, 50853, 50854, 50856, 50857, 50858, 50859, 50861, 50862, 50864, 50865, 50866, 50867, 50869, 50870, 50871, 50872, 50873, 50874, 50875, 50877, 50878, 50879, 50881, 50882, 50885, 50887, 50888, 50890, 50891, 50893, 50894, 50895, 50896, 50897, 50899, 50900, 50901, 50902, 50903, 50905, 50907, 50908, 50909, 50910, 50914, 50916, 50918, 50922, 50926, 50928, 50930, 50931, 50933, 50935, 50939, 50941, 50945, 50947, 50949, 50952, 50954, 50956, 50958, 50960, 50962, 50964, 50966, 50968, 50972, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51000, 51002, 51004, 51006, 51011, 51013, 51015, 51017, 51020, 51023, 51030, 51035, 51037, 51040, 51042, 51044, 51046, 51049, 51051, 51053, 51056, 51058, 51060, 51063, 51066, 51068, 51070, 51072, 51075, 51077, 51080, 51082, 51084, 51086, 51089, 51091, 51094, 51096, 51100, 51103, 51106, 51109, 51111, 51113, 51115, 51118, 51120, 51123, 51125, 51127, 51129, 51132, 51134, 51137, 51139, 51141, 51144, 51146, 51149, 51151, 51153, 51155, 51158, 51160, 51163, 51165, 51167, 51169, 51172, 51174, 51178, 51181, 51184, 51186, 51190, 51193, 51196, 51198, 51202, 51205, 51208, 51210, 51214, 51217, 51220, 51222, 51226, 51230, 51233, 51236, 51240, 51243, 51246, 51248, 51251, 51253, 51255, 51257, 51260, 51262, 51265, 51267, 51270, 51272, 51279, 51282, 51284, 51287, 51292, 51294, 51297, 51299, 51301, 51306, 51308, 51311, 51313, 51316, 51318, 51321, 51323, 51326, 51328, 51330, 51332, 51335, 51337, 51340, 51342, 51344, 51348, 51350, 51353, 51355, 51357, 51359, 51362, 51364, 51367, 51369, 51371, 51373, 51375, 51377, 51378, 51380, 51381, 51382, 51386, 51387, 51388, 51390, 51391, 51392, 51394, 51395, 51396, 51397, 51399, 51400, 51402, 51404, 51405, 51407, 51408, 51410, 51411, 51412, 51413, 51415, 51418, 51419, 51420, 51421, 51423, 51424, 51426, 51428, 51430, 51431, 51432, 51433, 51434, 51435, 51437, 51439, 51441, 51444, 51445, 51446, 51447, 51448, 51449, 51450, 51451, 51452, 51453, 51454, 51456, 51457, 51458, 51461, 51462, 51463, 51464, 51465, 51466, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51475, 51476, 51477, 51478, 51480, 51483, 51485, 51487, 51489, 51491, 51493, 51497, 51499, 51500, 51502, 51504, 51507, 51508, 51510, 51512, 51515, 51516, 51518, 51520, 51523, 51524, 51526, 51528, 51530, 51534, 51536, 51538, 51542, 51546, 51548, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51570, 51572, 51576, 51578, 51580, 51582, 51584, 51586, 51590, 51595, 51597, 51602, 51604, 51606, 51609, 51612, 51614, 51616, 51620, 51623, 51626, 51628, 51633, 51635, 51638, 51640, 51642, 51644, 51647, 51649, 51654, 51656, 51658, 51661, 51663, 51666, 51668, 51670, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51705, 51709, 51712, 51715, 51717, 51721, 51727, 51733, 51736, 51746, 51749, 51752, 51754, 51761, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51793, 51798, 51800, 51807, 51810, 51812, 51814, 51816, 51819, 51821, 51824, 51827, 51830, 51832, 51837, 51840, 51842, 51844, 51846, 51848, 51850, 51855, 51858, 51863, 51865, 51868, 51870, 51872, 51876, 51878, 51881, 51884, 51886, 51889, 51892, 51894, 51897, 51901, 51903, 51906, 51908, 51911, 51913, 51916, 51918, 51921, 51923, 51926, 51928, 51930, 51932, 51935, 51937, 51939, 51941, 51942, 51943, 51944, 51946, 51947, 51949, 51950, 51952, 51953, 51954, 51956, 51957, 51958, 51961, 51962, 51963, 51966, 51967, 51968, 51969, 51970, 51971, 51972, 51975, 51976, 51977, 51980, 51981, 51982, 51983, 51984, 51985, 51986, 51988, 51989, 51991, 51992, 51993, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52009, 52010, 52012, 52013, 52016, 52017, 52020, 52021, 52022, 52023, 52024, 52025, 52026, 52027, 52028, 52030, 52031, 52032, 52033, 52034, 52035, 52036, 52037, 52038, 52039, 52040, 52041, 52043, 52044, 52045, 52046, 52047, 52048, 52049, 52050, 52051, 52052, 52053, 52054, 52055, 52059, 52061, 52063, 52065, 52067, 52069, 52071, 52073, 52075, 52076, 52078, 52080, 52083, 52084, 52086, 52088, 52091, 52092, 52095, 52096, 52101, 52103, 52105, 52107, 52109, 52111, 52113, 52115, 52117, 52119, 52121, 52123, 52125, 52127, 52129, 52131, 52135, 52139, 52143, 52145, 52147, 52149, 52151, 52153, 52157, 52159, 52161, 52163, 52165, 52167, 52171, 52173, 52175, 52179, 52183, 52185, 52187, 52191, 52195, 52197, 52199, 52201, 52203, 52205, 52209, 52217, 52220, 52222, 52228, 52233, 52235, 52240, 52242, 52247, 52252, 52254, 52256, 52263, 52268, 52270, 52276, 52279, 52281, 52283, 52288, 52290, 52293, 52297, 52299, 52302, 52304, 52309, 52311, 52313, 52316, 52318, 52322, 52325, 52328, 52334, 52340, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52366, 52370, 52373, 52376, 52385, 52393, 52395, 52397, 52399, 52402, 52404, 52409, 52412, 52414, 52419, 52422, 52424, 52433, 52443, 52446, 52455, 52457, 52460, 52462, 52465, 52470, 52475, 52477, 52482, 52489, 52494, 52496, 52500, 52505, 52508, 52510, 52515, 52520, 52521, 52526, 52528, 52529, 52535, 52536, 52537, 52539, 52540, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52551, 52552, 52553, 52555, 52556, 52558, 52559, 52560, 52561, 52563, 52564, 52566, 52567, 52568, 52569, 52571, 52572, 52574, 52575, 52576, 52577, 52579, 52580, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52588, 52593, 52594, 52595, 52596, 52597, 52598, 52599, 52600, 52601, 52602, 52603, 52604, 52605, 52606, 52607, 52608, 52609, 52610, 52615) 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: King Richard The Third

Afterpiece Title: The Pavilion

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans

Performances

Mainpiece Title: As You Like It

Cast
Role: Sylvius Actor: Trueman

Afterpiece Title: The Deserter

Cast
Role: Serjeant Actor: Trueman

Song: As17991001

Performances

Mainpiece Title: Isabella; Or, The Fatal Marriage

Cast
Role: Pedro Actor: Trueman

Afterpiece Title: The Apprentice

Song: In III: Epithalamium Vocal Parts-Mrs Bland, Miss Leak

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Jaques Actor: Trueman

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans

Performances

Mainpiece Title: Jane Shore

Cast
Role: Ratcliffe Actor: Trueman

Afterpiece Title: The Mock Doctor

Cast
Role: James Actor: Trueman

Performances

Mainpiece Title: The Secret

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Mock Doctor

Cast
Role: James Actor: Trueman

Song: As17991114

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Gentlemen Actor: Surmont, Trueman

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Wheel Of Fortune

Cast
Role: Jenkins Actor: Trueman

Afterpiece Title: The Deserter

Cast
Role: Serjeant Actor: Trueman

Performances

Mainpiece Title: The Will

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans

Ballet: End: The Scotch Ghost; or, Little Fanny's Love. Jamie-Gheri (1st appearance); Glaude-Grimaldi; Saundy-Master Chatterley; Donald-Whitmell; Elpsa-Mrs Brooker; Fanny (with a Hornpipe)-Sga Bossi DelCaro

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Jaques Actor: Trueman

Afterpiece Title: The Shipwreck

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Saib Actor: Trueman

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: The Will

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans

Performances

Mainpiece Title: The East Indian

Afterpiece Title: The Prize

Cast
Role: Heartwell Actor: Trueman

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Lying Valet

Song: Mainpiece: Vocal Parts-Sedgwick, Dignum, Danby, Cook, Tett, Caulfield Jun., Sawyer, Danby Jun., Aylmer, Willoughby, Bardoleau, Clark, Mead, Elliot, Ms Crouch, Ms DeCamp, Ms Leak, Ms Arne, Ms Menage, Ms Roffey, Ms Menage Jun., Ms Wentworth, Ms Chippendale, Ms Jacobs, Ms Butler, Ms Saunders, Ms Gawdry, Ms Benson, Ms Coates

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Apprentice

Song: Vocal Parts, as17991211, but added: Miss Stephens

Performances

Mainpiece Title: The East Indian

Afterpiece Title: The Deserter

Cast
Role: Serjeant Actor: Trueman

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: My Grandmother

Song: As17991213

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Virgin Unmask'd

Song: As17991213

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Mock Doctor

Song: As17991213

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Lying Valet

Song: As17991213

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Humourist

Song: As17991213

Performances

Mainpiece Title: The London Merchant; Or, George Barnwell

Afterpiece Title: Blue-Beard

Cast
Role: Spahis Actor: Caulfield, Trueman, Maddocks, Evans