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 Wheel Of Fortune

Cast
Role: Mr Woodville Actor: Caulfield.

Afterpiece Title: Who's the Dupe

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: The Citizen

Song: As18000430

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: Vocal Parts, as18000429, but _Sawyer, _Aylmer, _Willoughby, _Bardoleau, _Clark, _Mead, _Elliot, Ms _Bristow, Ms _Butler, Ms _Gawdry

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As18000503

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As18000503

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Freeman Actor: Caulfield

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: De Montfort

Cast
Role: Grimbald Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As18000503

Performances

Mainpiece Title: The Inconstant; Or, The Way To Win Him

Afterpiece Title: The Pannel

Cast
Role: Don Pedro Actor: Caulfield

Song: In afterpiece: The Blue Bell of Scotland-Mrs Jordan; accompanied on the Lute-Mrs Jordan

Performances

Mainpiece Title: Indiscretion

Performances

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

Afterpiece Title: The Humourist

Cast
Role: Beaumont Actor: Caulfield

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Snake Actor: Caulfield

Song: In III: song-Dignum

Performances

Mainpiece Title: Pizarro

Cast
Role: Almagro Actor: Caulfield

Afterpiece Title: The Apprentice

Song: Vocal Parts, as17991228, but Mrs Coates, Mrs _Chippendale

Performances

Mainpiece Title: Pizarro

Cast
Role: Almagro Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: As17991228

Performances

Mainpiece Title: Indiscretion

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Muley Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Ballet: End: The Scotch Ghost. As17991202

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Snake Actor: Caulfield

Afterpiece Title: No Song No Supper

Song: As18000516

Performances

Mainpiece Title: Indiscretion

Performances

Afterpiece Title: The Strangers at Home

Cast
Role: Regnalto Actor: Caulfield

Dance: In: a favorite Pas Seul-Sga Bossi DelCaro

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Song: In: The Blue Bell of Scotland, as18000512; accompanied on the Lute, as18000512; In course Evening: Crazy Jane-Mrs Bland; In 3rd piece: a new ballad, The Fisherman and the River Queen (Written and Composed by M. G. Lewis, Esq, M. P., Author of Crazy Jane.)-Mrs Bland

Performances

Mainpiece Title: The Castle-spectre

Cast
Role: Muley Actor: Caulfield

Afterpiece Title: No Song No Supper

Cast
Role: William Actor: Caulfield

Dance: End II: New Divertisement Ballet-Sga Bossi DelCaro, Mme D'Egville, Gheri; a Pas Seul-Sga Bossi DelCaro; accompanied on the tamborine-Sga Bossi DelCaro; End: The Lucky Escape Principal Performers-St.Pierre, Grimaldi, Gheri, Miss B. Denis, Mrs Grimaldi, Miss E. Denis, Miss Lupini, Miss Cranfield, Mme D'Egville, Sga Bossi DelCaro, the whole Corps de Ballet

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Traverse Actor: Caulfield

Afterpiece Title: The Prize

Song: End: Strike the Harp-Master Suett, Master Heather, Danby; with an accompaniment of Piano Forte-; [a New Loyal Song Secure within her sea@girt Reign [(Dramatic Censor, II, 243)] (written by Dutton and composed by Moorehead,)-Trueman; End IV: Crazy Jane-Mrs Bland

Performances

Mainpiece Title: The Siege Of Belgrade

Cast
Role: Ismael Actor: Caulfield

Afterpiece Title: Of Age To-morrow

Song: III: a new song (composed by Kelly)-Mme Bolla

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Snake Actor: Caulfield

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Apewell Actor: Caulfield
Role: Shark Actor: Caulfield

Afterpiece Title: The Shipwreck

Cast
Role: Shark Actor: Caulfield

Song: In III: song-Dignum; End 2nd piece: Soft Musick let my humble lay (composed by Suett)-Master Suett; In 3rd piece: Crazy Jane-Mrs Bland

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Kilmallock Actor: Caulfield

Afterpiece Title: The Citizen