SELECT * FROM london_stages WHERE eventid IN (47468, 47476, 47477, 47488, 47496, 47498, 47500, 47504, 47516, 47518, 47522, 47524, 47526, 47528, 47532, 47534, 47536, 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, 48499, 48501, 48503, 48504, 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, 51976, 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 Jew

Cast
Role: The Baron Actor: Caulfield

Afterpiece Title: My Grandmother

Cast
Role: Souffrance Actor: Caulfield

Afterpiece Title: Blue Devils

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Bulcazin Muley Actor: Caulfield

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: Blue Devils

Cast
Role: The Baron Actor: Caulfield

Afterpiece Title: Ways and Means

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: The Castle of Sorrento

Performances

Mainpiece Title: False And True

Afterpiece Title: Blue Devils

Cast
Role: Souffrance Actor: Caulfield

Afterpiece Title: The Castle of Sorrento

Performances

Afterpiece Title: All in Good Humour

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: The Purse

Cast
Role: The Baron Actor: Caulfield

Afterpiece Title: The Jew

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Afterpiece Title: Fortune's Frolick

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: Cambro-britons

Cast
Role: Mortimer Actor: Caulfield

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Afterpiece Title: The Heir at Law

Cast
Role: Fripon Actor: Caulfield
Role: Gabriel Actor: Caulfield

Afterpiece Title: The Purse

Cast
Role: the Baron Actor: Caulfield
Role: Gabriel Actor: Caulfield

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: False And True

Afterpiece Title: Blue Devils

Cast
Role: Souffrance Actor: Caulfield

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Afterpiece Title: The Jew

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: The Iron Chest

Cast
Role: Robbers Actor: Davies, Caulfield, Bannister

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: Sighs; or, The Daughter

Afterpiece Title: The Purse

Cast
Role: Fripon Actor: Caulfield
Role: Gabriel Actor: Caulfield
Role: the Baron Actor: Caulfield

Song: not listed in playbill; see17990824: In II 2nd piece: 'Twas in the solemn mid@night hour-Mrs Bland

Performances

Mainpiece Title: Sighs

Afterpiece Title: My Grandmother

Cast
Role: Souffrance Actor: Caulfield

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Afterpiece Title: Sighs

Cast
Role: Fripon Actor: Caulfield
Role: Gabriel Actor: Caulfield
Role: the Baron Actor: Caulfield

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: The Castle Of Sorrento

Afterpiece Title: The Heir at Law

Cast
Role: Fripon Actor: Caulfield
Role: Gabriel Actor: Caulfield

Performances

Mainpiece Title: Zorinski

Cast
Role: Rodomsko Actor: Caulfield

Afterpiece Title: The Follies of a Day

Song: End: My Mother bids me bind my Hair (by Haydn)-Master Suett (1st appearance in public)

Performances

Mainpiece Title: Sighs

Afterpiece Title: The Castle of Sorrento

Cast
Role: Souffrance Actor: Caulfield
Role: Chorus Actor: _Aylmer, _Brown, _Caulfield Jun.

Performances

Mainpiece Title: The Jew And The Doctor

Cast
Role: Paris Actor: Caulfield

Afterpiece Title: The Iron Chest