SELECT * FROM london_stages WHERE eventid IN (47468, 47476, 47477, 47488, 47496, 47498, 47500, 47504, 47516, 47518, 47522, 47524, 47526, 47528, 47532, 47534, 47538, 47542, 47544, 47546, 47548, 47550, 47554, 47556, 47569, 47574, 47576, 47579, 47583, 47585, 47588, 47592, 47622, 47632, 47638, 47650, 47652, 47654, 47671, 47675, 47692, 47699, 47706, 47713, 47723, 47728, 47748, 47751, 47758, 47763, 47773, 47778, 47781, 47786, 47788, 47791, 47793, 47796, 47799, 47804, 47809, 47814, 47829, 47854, 47859, 47868, 47871, 47889, 47891, 47901, 47905, 47908, 47911, 48003, 48011, 48013, 48018, 48021, 48022, 48025, 48035, 48040, 48042, 48046, 48048, 48050, 48052, 48054, 48056, 48058, 48060, 48063, 48065, 48067, 48069, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48108, 48112, 48114, 48118, 48120, 48122, 48124, 48128, 48136, 48141, 48143, 48145, 48147, 48149, 48153, 48155, 48157, 48159, 48161, 48165, 48169, 48173, 48175, 48181, 48183, 48185, 48205, 48208, 48210, 48215, 48219, 48222, 48224, 48232, 48237, 48246, 48251, 48256, 48270, 48274, 48277, 48288, 48291, 48293, 48298, 48302, 48305, 48307, 48316, 48319, 48321, 48324, 48330, 48333, 48335, 48340, 48343, 48346, 48348, 48351, 48353, 48357, 48371, 48374, 48376, 48383, 48390, 48393, 48395, 48397, 48401, 48403, 48406, 48408, 48410, 48412, 48415, 48417, 48420, 48426, 48429, 48436, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48538, 48540, 48542, 48544, 48546, 48548, 48550, 48552, 48554, 48556, 48558, 48560, 48562, 48564, 48566, 48568, 48570, 48572, 48574, 48576, 48578, 48580, 48582, 48584, 48587, 48589, 48591, 48593, 48595, 48597, 48599, 48604, 48610, 48612, 48614, 48622, 48624, 48626, 48632, 48636, 48638, 48644, 48646, 48648, 48652, 48658, 48660, 48666, 48668, 48670, 48676, 48678, 48680, 48686, 48688, 48690, 48696, 48698, 48700, 48706, 48710, 48716, 48718, 48720, 48726, 48728, 48730, 48736, 48738, 48740, 48746, 48748, 48750, 48756, 48758, 48760, 48762, 48768, 48770, 48772, 48776, 48778, 48780, 48784, 48786, 48788, 48790, 48792, 48794, 48797, 48799, 48802, 48804, 48806, 48808, 48811, 48813, 48816, 48818, 48820, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48878, 48880, 48883, 48885, 48888, 48891, 48893, 48897, 48900, 48903, 48905, 48910, 48914, 48917, 48919, 48924, 48928, 48931, 48934, 48939, 48946, 48948, 48953, 48957, 48960, 48962, 48979, 48981, 48983, 48985, 48987, 48992, 48994, 48997, 48999, 49001, 49003, 49006, 49008, 49011, 49020, 49025, 49030, 49037, 49045, 49047, 49052, 49060, 49062, 49076, 49080, 49085, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49117, 49119, 49187, 49194, 49196, 49198, 49200, 49202, 49204, 49205, 49207, 49210, 49212, 49213, 49215, 49218, 49225, 49227, 49230, 49231, 49233, 49239, 49241, 49243, 49245, 49249, 49255, 49257, 49261, 49263, 49267, 49269, 49273, 49279, 49281, 49285, 49289, 49291, 49297, 49301, 49304, 49306, 49311, 49313, 49315, 49318, 49320, 49325, 49327, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49361, 49363, 49365, 49367, 49370, 49372, 49375, 49377, 49379, 49381, 49384, 49386, 49389, 49395, 49398, 49405, 49407, 49410, 49412, 49415, 49417, 49424, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49470, 49471, 49474, 49477, 49479, 49483, 49484, 49487, 49489, 49492, 49494, 49498, 49499, 49502, 49503, 49506, 49508, 49512, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49535, 49538, 49540, 49544, 49552, 49555, 49559, 49562, 49567, 49574, 49608, 49611, 49615, 49621, 49626, 49629, 49631, 49634, 49636, 49639, 49645, 49651, 49654, 49656, 49658, 49660, 49665, 49668, 49669, 49670, 49672, 49675, 49677, 49678, 49679, 49680, 49682, 49683, 49685, 49686, 49687, 49688, 49690, 49691, 49693, 49694, 49695, 49696, 49698, 49699, 49700, 49701, 49702, 49703, 49704, 49705, 49706, 49707, 49708, 49709, 49710, 49711, 49712, 49713, 49714, 49715, 49716, 49717, 49718, 49719, 49720, 49721, 49722, 49723, 49724, 49725, 49726, 49727, 49728, 49729, 49730, 49731, 49733, 49734, 49735, 49736, 49737, 49738, 49739, 49740, 49741, 49742, 49743, 49744, 49745, 49746, 49747, 49748, 49749, 49750, 49751, 49752, 49753, 49760, 49767, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49784, 49786, 49789, 49790, 49793, 49795, 49798, 49800, 49802, 49806, 49808, 49812, 49816, 49818, 49820, 49822, 49824, 49828, 49830, 49832, 49836, 49838, 49840, 49842, 49844, 49846, 49848, 49850, 49852, 49854, 49856, 49858, 49860, 49862, 49866, 49868, 49870, 49872, 49874, 49876, 49878, 49880, 49885, 49887, 49890, 49892, 49894, 49896, 49899, 49901, 49904, 49909, 49911, 49918, 49920, 49928, 49932, 49937, 49939, 49942, 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, 50040, 50047, 50054, 50060, 50072, 50078, 50081, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50110, 50112, 50115, 50117, 50120, 50122, 50125, 50130, 50133, 50135, 50137, 50140, 50145, 50150, 50152, 50155, 50157, 50162, 50165, 50169, 50171, 50176, 50178, 50180, 50183, 50188, 50190, 50192, 50194, 50197, 50199, 50202, 50204, 50207, 50209, 50212, 50214, 50217, 50218, 50219, 50220, 50221, 50223, 50226, 50228, 50229, 50230, 50231, 50234, 50235, 50237, 50240, 50242, 50243, 50245, 50247, 50248, 50250, 50251, 50254, 50256, 50257, 50260, 50262, 50263, 50264, 50265, 50270, 50271, 50272, 50273, 50275, 50276, 50278, 50279, 50280, 50283, 50284, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50293, 50295, 50296, 50297, 50299, 50300, 50301, 50302, 50303, 50304, 50305, 50306, 50307, 50308, 50309, 50310, 50311, 50312, 50313, 50314, 50315, 50316, 50317, 50318, 50320, 50322, 50323, 50339, 50341, 50344, 50347, 50349, 50351, 50355, 50357, 50363, 50367, 50369, 50372, 50373, 50375, 50379, 50381, 50382, 50384, 50386, 50388, 50390, 50393, 50395, 50397, 50399, 50401, 50403, 50405, 50407, 50409, 50411, 50413, 50415, 50417, 50419, 50421, 50423, 50427, 50429, 50434, 50439, 50443, 50446, 50448, 50451, 50455, 50457, 50460, 50462, 50465, 50471, 50474, 50476, 50479, 50481, 50483, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50516, 50519, 50521, 50523, 50525, 50528, 50530, 50535, 50537, 50539, 50542, 50545, 50550, 50555, 50558, 50563, 50565, 50570, 50572, 50575, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50606, 50608, 50610, 50613, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50667, 50670, 50675, 50679, 50683, 50687, 50689, 50692, 50694, 50696, 50703, 50706, 50711, 50713, 50721, 50723, 50725, 50727, 50730, 50732, 50735, 50738, 50741, 50743, 50746, 50748, 50751, 50753, 50756, 50761, 50763, 50768, 50771, 50773, 50776, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50801, 50804, 50806, 50811, 50813, 50814, 50817, 50818, 50820, 50821, 50825, 50826, 50829, 50830, 50832, 50834, 50835, 50837, 50838, 50840, 50841, 50842, 50843, 50845, 50846, 50848, 50849, 50850, 50851, 50853, 50854, 50857, 50858, 50859, 50861, 50862, 50864, 50865, 50866, 50867, 50869, 50870, 50871, 50872, 50873, 50874, 50875, 50877, 50881, 50882, 50885, 50887, 50888, 50890, 50891, 50892, 50893, 50894, 50895, 50896, 50897, 50898, 50899, 50900, 50901, 50902, 50905, 50906, 50907, 50908, 50909, 50910, 50922, 50924, 50926, 50928, 50930, 50931, 50933, 50939, 50941, 50943, 50945, 50947, 50956, 50958, 50960, 50964, 50966, 50968, 50970, 50972, 50974, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51000, 51002, 51004, 51006, 51011, 51013, 51015, 51020, 51023, 51028, 51030, 51035, 51037, 51046, 51049, 51051, 51060, 51066, 51072, 51080, 51084, 51086, 51089, 51091, 51098, 51103, 51109, 51113, 51118, 51123, 51132, 51151, 51153, 51160, 51165, 51167, 51172, 51178, 51190, 51193, 51198, 51205, 51210, 51217, 51222, 51243, 51246, 51255, 51257, 51265, 51272, 51279, 51282, 51287, 51292, 51297, 51308, 51313, 51316, 51321, 51323, 51330, 51335, 51340, 51342, 51348, 51350, 51353, 51355, 51357, 51359, 51362, 51364, 51367, 51369, 51371, 51373, 51375, 51377, 51378, 51380, 51381, 51383, 51386, 51390, 51391, 51392, 51394, 51395, 51396, 51397, 51399, 51400, 51402, 51404, 51405, 51407, 51408, 51411, 51412, 51413, 51415, 51416, 51419, 51420, 51421, 51424, 51428, 51430, 51431, 51433, 51434, 51435, 51437, 51440, 51441, 51442, 51445, 51446, 51447, 51448, 51449, 51450, 51451, 51453, 51454, 51456, 51457, 51461, 51462, 51464, 51465, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51474, 51475, 51476, 51477, 51483, 51485, 51487, 51489, 51491, 51493, 51497, 51499, 51500, 51502, 51504, 51507, 51508, 51510, 51512, 51515, 51516, 51518, 51520, 51523, 51524, 51526, 51528, 51530, 51533, 51534, 51536, 51538, 51542, 51546, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51570, 51572, 51576, 51578, 51582, 51584, 51586, 51588, 51590, 51595, 51600, 51602, 51604, 51609, 51611, 51612, 51614, 51616, 51620, 51623, 51626, 51628, 51633, 51638, 51640, 51642, 51644, 51647, 51649, 51654, 51656, 51658, 51661, 51663, 51666, 51668, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51705, 51709, 51712, 51715, 51717, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51785, 51791, 51793, 51798, 51807, 51810, 51812, 51819, 51821, 51824, 51827, 51830, 51832, 51837, 51840, 51842, 51844, 51846, 51848, 51850, 51853, 51855, 51860, 51863, 51865, 51868, 51870, 51872, 51876, 51878, 51884, 51886, 51892, 51894, 51897, 51901, 51903, 51906, 51908, 51911, 51913, 51916, 51918, 51921, 51923, 51926, 51928, 51930, 51932, 51935, 51937, 51939, 51941, 51942, 51943, 51946, 51949, 51950, 51952, 51953, 51954, 51956, 51957, 51958, 51959, 51961, 51963, 51964, 51966, 51968, 51969, 51970, 51972, 51977, 51978, 51980, 51982, 51985, 51986, 51988, 51989, 51991, 51992, 51993, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52010, 52012, 52013, 52016, 52017, 52021, 52022, 52023, 52026, 52027, 52028, 52029, 52030, 52031, 52032, 52033, 52034, 52035, 52037, 52038, 52039, 52040, 52041, 52043, 52044, 52045, 52046, 52048, 52049, 52050, 52051, 52052, 52053, 52055, 52076, 52078, 52080, 52083, 52084, 52086, 52088, 52091, 52092, 52095, 52096, 52098, 52101, 52103, 52105, 52107, 52109, 52111, 52115, 52117, 52121, 52123, 52125, 52127, 52129, 52133, 52135, 52139, 52143, 52145, 52147, 52149, 52151, 52153, 52157, 52159, 52161, 52163, 52165, 52167, 52169, 52171, 52175, 52179, 52181, 52183, 52187, 52191, 52193, 52195, 52197, 52199, 52201, 52203, 52205, 52209, 52211, 52213, 52215, 52217, 52220, 52222, 52224, 52226, 52228, 52233, 52235, 52238, 52240, 52242, 52244, 52247, 52249, 52252, 52254, 52256, 52258, 52261, 52263, 52266, 52268, 52270, 52276, 52279, 52281, 52283, 52285, 52288, 52290, 52293, 52297, 52302, 52304, 52309, 52311, 52313, 52316, 52318, 52322, 52325, 52328, 52334, 52340, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52366, 52370, 52373, 52376, 52382, 52385, 52388, 52390, 52393, 52395, 52397, 52399, 52404, 52409, 52412, 52414, 52419, 52422, 52424, 52426, 52428, 52431, 52433, 52436, 52438, 52441, 52446, 52448, 52453, 52455, 52457, 52462, 52467, 52475, 52477, 52480, 52482, 52485, 52489, 52496, 52498, 52505, 52508, 52518, 52522, 52524, 52526, 52532, 52535, 52536, 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, 52579, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52588, 52589, 52590, 52591, 52592, 52593, 52594, 52595, 52596, 52597, 52598, 52599, 52600, 52601, 52602, 52603, 52604, 52605, 52606, 52607, 52608, 52610, 52612, 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: The Conscious Lovers

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Song: As17961220

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: Ismael Actor: Caulfield

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: End I: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Richard Coeur De Lion

Cast
Role: Snake Actor: Caulfield

Afterpiece Title: Who's the Dupe

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: End: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Douglas

Cast
Role: Officer Actor: Caulfield

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Performances

Mainpiece Title: Measure For Measure

Cast
Role: Provost Actor: Caulfield

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Much Ado About Nothing

Cast
Role: Conrade Actor: Caulfield

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Dance: In II: Masquerade-; Dance-Gentili, Mrs Wild

Song: In Masquerade: Stevens's Glee, Sigh no more Ladies-Dignum, Sedgwick Cooke, Master Welsh, Mrs Bland, Miss DeCamp

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: Ismael Actor: Caulfield

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Dance: As17970104

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: Isabella

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Song: As17960924

Performances

Mainpiece Title: The Chances

Cast
Role: Gentlemen Actor: Caulfield, Cooke, Fisher, Trueman

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Snake Actor: Caulfield

Afterpiece Title: No Song No Supper

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Theodosius; Or, The Force Of Love

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

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

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Song: As17970120

Performances

Mainpiece Title: Theodosius

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Song: As17970120

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Performances

Mainpiece Title: Theodosius

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Song: As17970120

Performances

Mainpiece Title: Theodosius

Afterpiece Title: Richard Coeur de Lion

Song: As17970120

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: Ismael Actor: Caulfield

Afterpiece Title: The Follies of a Day

Ballet: End I: The Scotch Ghost. As17961116, but Hornpipe-_

Performances

Mainpiece Title: Tamerlane

Cast
Role: Omar Actor: Caulfield

Afterpiece Title: The Prize

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Tamerlane

Cast
Role: Omar Actor: Caulfield

Afterpiece Title: Robinson Crusoe

Cast
Role: the Lover Actor: Caulfield

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield