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: Jane Shore

Cast
Role: Catesby Actor: Caulfield

Afterpiece Title: The Glorious First of June

Song: In afterpiece: Choruses-Cooke, Danby, Lyons, Maddocks, Welsh, Mrs Bramwell, Miss Granger, Miss Chatterley

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Distress'd Mother

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Pirates

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

Mainpiece Title: Emilia Galotti

Cast
Role: Giuseppe Actor: Caulfield

Afterpiece Title: The Prize

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Ganem Actor: Caulfield

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

Performances

Mainpiece Title: Emilia Galotti

Cast
Role: Giuseppe Actor: Caulfield

Afterpiece Title: The Wedding Day

Song: In afterpiece: In the dead of the night-Mrs Jordan [not listed on playbill, but see BUC, 1061]

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: Ismael Actor: Caulfield

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: Emilia Galotti

Cast
Role: Giuseppe Actor: Caulfield

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Ganem Actor: Caulfield

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: Macbeth

Cast
Role: Serjeant Actor: Caulfield

Afterpiece Title: The Wedding Day

Song: As17941007

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Valentine Actor: Caulfield

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Pirates

Afterpiece Title: The Wedding Day

Dance: As17941027

Performances

Mainpiece Title: Othello

Cast
Role: Antonio Actor: Caulfield

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Ganem Actor: Caulfield

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Pirates

Afterpiece Title: The Wedding Day

Dance: As17941027

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield

Performances

Mainpiece Title: The Mourning Bride

Cast
Role: Selim Actor: Caulfield

Afterpiece Title: Nobody

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: Ismael Actor: Caulfield

Afterpiece Title: Nobody

Performances

Mainpiece Title: The Jew

Afterpiece Title: Lodoiska

Cast
Role: Adolphus Actor: Caulfield