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 Deaf Lover

Afterpiece Title: The Italian Monk

Cast
Role: Stiletto Actor: Caulfield

Song: 2nd piece: General Chorus [of Assassins and Nuns (text)]-Linton, Brown, Lyons, Aylmer, Little, Willoughby, Dibble, Kenrick, Caulfield Jun., Mrs Andrews, Miss Menage, Mrs Butler, Mrs Brown, Mrs Benson, Mrs Masters, Mrs Norton, Mrs Gaudry, Miss Leserve

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Agreeable Surprise

Cast
Role: Bite Actor: Caulfield
Role: Souffrance Actor: Caulfield

Song: As17970816

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Caulfield

Performances

Mainpiece Title: The Iron Chest

Cast
Role: Robbers Actor: Davies, Caulfield, Bannister

Afterpiece Title: Peeping Tom

Entertainment: Monologue.End: Collins's Ode on the Passions-Palmer; Imitations. Following monologue: a Variety of Imitations-Caulfield

Performances

Mainpiece Title: The Surrender Of Calais

Afterpiece Title: The Irish Tar; or, Which is the Girl

Afterpiece Title: The Agreeable Surprise

Cast
Role: Bite Actor: Caulfield
Role: Souffrance Actor: Caulfield

Song: 1st piece: Vocal Parts, as17970623 but _Caulfield Jun., _Walker, _Willoughby, Mrs _Butler, Mrs _Masters, Mrs _Norton, Miss _Menage, Mrs _Wall, Mrs _Benson, Miss _Leserve

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Caulfield

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Caulfield

Song: As17970816

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Salanio Actor: Caulfield

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Salanio Actor: Caulfield

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: A Mogul Tale

Cast
Role: Earl of Mercia Actor: Caulfield

Song: As17970816

Performances

Mainpiece Title: The Iron Chest

Cast
Role: Robbers Actor: Davies, Caulfield, Bannister

Afterpiece Title: The Agreeable Surprise

Song: Mainpiece: General Chorus, as17970814, but added: Lyons, Miss +Andrews, _Walker, _Dibble, _Caulfield Jun., Ms _Edward, Ms _Gaudry, Ms _Hale

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Afterpiece Title: The Poor Soldier

Cast
Role: Father Luke Actor: Caulfield

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Caulfield

Song: 1st piece: General Chorus, as17970816

Performances

Mainpiece Title: Othello

Cast
Role: Lodovico Actor: Caulfield

Afterpiece Title: No Song No Supper

Cast
Role: William Actor: Caulfield

Song: End: Sweet Echo, the song-Mrs Bland, the echoMrs Atkins

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Heir at Law

Cast
Role: Oliver Actor: Caulfield

Afterpiece Title: The Purse

Cast
Role: Count Fripon Actor: Caulfield
Role: Argus Actor: Caulfield

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Afterpiece Title: Peeping Tom

Song: 1st piece: General Chorus, as17970816

Performances

Mainpiece Title: The Purse

Afterpiece Title: The London Hermit

Cast
Role: Bite Actor: Caulfield
Role: Souffrance Actor: Caulfield

Afterpiece Title: The Children in the Wood

Cast
Role: Oliver Actor: Caulfield

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Rosina

Song: As17970816

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: The Guardian

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: The Village Lawyer

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Song: As17970816

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Afterpiece Title: The Village Lawyer

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Irishmen Actor: Caulfield, Abbot

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Lavinio Actor: Caulfield

Afterpiece Title: Peeping Tom

Song: End II: The Nightingale-Mrs Atkins; End: The Flowing can-Mrs Harlowe; End 2nd piece: Sweet Echo, as17970904

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Cast
Role: Don Lewis Actor: Caulfield

Afterpiece Title: The Humourist

Performances

Mainpiece Title: The Wheel Of Fortune

Cast
Role: Mr Woodville Actor: Caulfield

Afterpiece Title: The Children in the Wood