SELECT * FROM london_stages WHERE eventid IN (28128, 28134, 28136, 48999, 49003, 49025, 49030, 49045, 49060, 49080, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49117, 49119, 49120, 49122, 49190, 49194, 49198, 49200, 49202, 49205, 49210, 49212, 49213, 49218, 49225, 49227, 49230, 49239, 49241, 49243, 49245, 49247, 49249, 49251, 49253, 49255, 49257, 49263, 49265, 49267, 49269, 49277, 49279, 49281, 49283, 49289, 49291, 49293, 49299, 49301, 49304, 49306, 49311, 49318, 49320, 49323, 49325, 49327, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49358, 49361, 49363, 49365, 49367, 49370, 49372, 49375, 49377, 49379, 49381, 49389, 49393, 49395, 49398, 49403, 49407, 49410, 49412, 49415, 49419, 49451, 49453, 49457, 49461, 49464, 49471, 49474, 49477, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49512, 49516, 49519, 49524, 49526, 49528, 49533, 49535, 49540, 49544, 49549, 49552, 49559, 49564, 49572, 49574, 49577, 49579, 49582, 49584, 49586, 49588, 49591, 49593, 49596, 49598, 49601, 49603, 49608, 49613, 49615, 49619, 49624, 49626, 49634, 49636, 49639, 49643, 49648, 49758, 49760, 49763, 49765, 49769, 49771, 49773, 49774, 49776, 49778, 49781, 49782, 49784, 49786, 49789, 49790, 49793, 49795, 49798, 49800, 49802, 49804, 49806, 49808, 49810, 49812, 49816, 49820, 49822, 49824, 49826, 49828, 49830, 49832, 49834, 49838, 49840, 49842, 49844, 49846, 49848, 49850, 49852, 49856, 49858, 49860, 49862, 49864, 49866, 49868, 49870, 49872, 49874, 49876, 49878, 49880, 49882, 49885, 49887, 49890, 49892, 49894, 49896, 49899, 49901, 49904, 49906, 49909, 49911, 49914, 49916, 49918, 49923, 49925, 49930, 49934, 49937, 49939, 49942, 49944, 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, 50037, 50047, 50051, 50060, 50063, 50066, 50069, 50076, 50078, 50083, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50110, 50115, 50117, 50120, 50122, 50127, 50130, 50133, 50135, 50137, 50140, 50147, 50150, 50152, 50155, 50157, 50160, 50162, 50165, 50169, 50171, 50174, 50176, 50178, 50180, 50183, 50188, 50190, 50192, 50194, 50197, 50199, 50202, 50204, 50209, 50212, 50214, 50217, 50218, 50219, 50220, 50221, 50223, 50224, 50226, 50228, 50229, 50230, 50231, 50232, 50234, 50235, 50237, 50238, 50239, 50240, 50242, 50243, 50245, 50246, 50247, 50248, 50250, 50251, 50253, 50254, 50256, 50257, 50259, 50260, 50262, 50263, 50264, 50265, 50267, 50268, 50270, 50271, 50272, 50273, 50275, 50276, 50277, 50278, 50279, 50280, 50282, 50283, 50284, 50285, 50286, 50287, 50288, 50289, 50291, 50292, 50293, 50294, 50295, 50296, 50297, 50298, 50299, 50300, 50301, 50302, 50303, 50304, 50305, 50306, 50307, 50308, 50309, 50310, 50311, 50312, 50313, 50314, 50315, 50316, 50317, 50318, 50319, 50320, 50321, 50322, 50323, 50335, 50337, 50339, 50341, 50344, 50347, 50349, 50351, 50354, 50355, 50357, 50359, 50362, 50363, 50365, 50367, 50369, 50372, 50373, 50375, 50377, 50379, 50381, 50382, 50384, 50386, 50390, 50393, 50395, 50397, 50399, 50401, 50403, 50405, 50407, 50409, 50413, 50415, 50417, 50419, 50421, 50425, 50427, 50429, 50432, 50434, 50439, 50443, 50446, 50448, 50455, 50462, 50465, 50467, 50469, 50471, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50519, 50523, 50525, 50528, 50530, 50533, 50535, 50537, 50539, 50542, 50550, 50553, 50555, 50558, 50561, 50563, 50565, 50567, 50570, 50572, 50575, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50608, 50610, 50613, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50670, 50673, 50675, 50679, 50683, 50687, 50689, 50692, 50694, 50701, 50703, 50706, 50713, 50716, 50718, 50721, 50727, 50730, 50732, 50735, 50738, 50741, 50743, 50746, 50748, 50751, 50753, 50761, 50766, 50768, 50773, 50776, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50801, 50807, 50809, 50811, 50813, 50814, 50816, 50817, 50818, 50820, 50821, 50824, 50825, 50826, 50827, 50829, 50830, 50832, 50833, 50834, 50835, 50838, 50840, 50841, 50842, 50843, 50845, 50848, 50849, 50850, 50851, 50853, 50854, 50856, 50857, 50858, 50859, 50861, 50862, 50864, 50865, 50866, 50867, 50869, 50870, 50871, 50872, 50873, 50874, 50875, 50877, 50878, 50879, 50881, 50882, 50885, 50887, 50888, 50890, 50891, 50893, 50894, 50895, 50896, 50897, 50899, 50900, 50901, 50902, 50903, 50905, 50907, 50908, 50909, 50910, 50914, 50916, 50918, 50922, 50926, 50928, 50930, 50931, 50933, 50935, 50939, 50941, 50945, 50947, 50949, 50952, 50954, 50956, 50958, 50960, 50962, 50964, 50966, 50968, 50972, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51000, 51002, 51004, 51006, 51011, 51013, 51015, 51017, 51020, 51023, 51030, 51035, 51037, 51040, 51042, 51044, 51046, 51049, 51051, 51053, 51056, 51058, 51060, 51063, 51066, 51068, 51070, 51072, 51075, 51077, 51080, 51082, 51084, 51086, 51089, 51091, 51094, 51096, 51100, 51103, 51106, 51109, 51111, 51113, 51115, 51118, 51120, 51123, 51125, 51127, 51129, 51132, 51134, 51137, 51139, 51141, 51144, 51146, 51149, 51151, 51153, 51155, 51158, 51160, 51163, 51165, 51167, 51169, 51172, 51174, 51178, 51181, 51184, 51186, 51190, 51193, 51196, 51198, 51202, 51205, 51208, 51210, 51214, 51217, 51220, 51222, 51226, 51230, 51233, 51236, 51240, 51243, 51246, 51248, 51251, 51253, 51255, 51257, 51260, 51262, 51265, 51267, 51270, 51272, 51279, 51282, 51284, 51287, 51292, 51294, 51297, 51299, 51301, 51306, 51308, 51311, 51313, 51316, 51318, 51321, 51323, 51326, 51328, 51330, 51332, 51335, 51337, 51340, 51342, 51344, 51348, 51350, 51353, 51355, 51357, 51359, 51362, 51364, 51367, 51369, 51371, 51373, 51375, 51377, 51378, 51380, 51381, 51382, 51386, 51387, 51388, 51390, 51391, 51392, 51394, 51395, 51396, 51397, 51399, 51400, 51402, 51404, 51405, 51407, 51408, 51410, 51411, 51412, 51413, 51415, 51418, 51419, 51420, 51421, 51423, 51424, 51426, 51428, 51430, 51431, 51432, 51433, 51434, 51435, 51437, 51439, 51441, 51444, 51445, 51446, 51447, 51448, 51449, 51450, 51451, 51452, 51453, 51454, 51456, 51457, 51458, 51461, 51462, 51463, 51464, 51465, 51466, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51475, 51476, 51477, 51478, 51480, 51483, 51485, 51487, 51489, 51491, 51493, 51497, 51499, 51500, 51502, 51504, 51507, 51508, 51510, 51512, 51515, 51516, 51518, 51520, 51523, 51524, 51526, 51528, 51530, 51534, 51536, 51538, 51542, 51546, 51548, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51570, 51572, 51576, 51578, 51580, 51582, 51584, 51586, 51590, 51595, 51597, 51602, 51604, 51606, 51609, 51612, 51614, 51616, 51620, 51623, 51626, 51628, 51633, 51635, 51638, 51640, 51642, 51644, 51647, 51649, 51654, 51656, 51658, 51661, 51663, 51666, 51668, 51670, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51705, 51709, 51712, 51715, 51717, 51721, 51727, 51733, 51736, 51746, 51749, 51752, 51754, 51761, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51793, 51798, 51800, 51807, 51810, 51812, 51814, 51816, 51819, 51821, 51824, 51827, 51830, 51832, 51837, 51840, 51842, 51844, 51846, 51848, 51850, 51855, 51858, 51863, 51865, 51868, 51870, 51872, 51876, 51878, 51881, 51884, 51886, 51889, 51892, 51894, 51897, 51901, 51903, 51906, 51908, 51911, 51913, 51916, 51918, 51921, 51923, 51926, 51928, 51930, 51932, 51935, 51937, 51939, 51941, 51942, 51943, 51944, 51946, 51947, 51949, 51950, 51952, 51953, 51954, 51956, 51957, 51958, 51961, 51962, 51963, 51966, 51967, 51968, 51969, 51970, 51971, 51972, 51975, 51976, 51977, 51980, 51981, 51982, 51983, 51984, 51985, 51986, 51988, 51989, 51991, 51992, 51993, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52009, 52010, 52012, 52013, 52016, 52017, 52020, 52021, 52022, 52023, 52024, 52025, 52026, 52027, 52028, 52030, 52031, 52032, 52033, 52034, 52035, 52036, 52037, 52038, 52039, 52040, 52041, 52043, 52044, 52045, 52046, 52047, 52048, 52049, 52050, 52051, 52052, 52053, 52054, 52055, 52059, 52061, 52063, 52065, 52067, 52069, 52071, 52073, 52075, 52076, 52078, 52080, 52083, 52084, 52086, 52088, 52091, 52092, 52095, 52096, 52101, 52103, 52105, 52107, 52109, 52111, 52113, 52115, 52117, 52119, 52121, 52123, 52125, 52127, 52129, 52131, 52135, 52139, 52143, 52145, 52147, 52149, 52151, 52153, 52157, 52159, 52161, 52163, 52165, 52167, 52171, 52173, 52175, 52179, 52183, 52185, 52187, 52191, 52195, 52197, 52199, 52201, 52203, 52205, 52209, 52217, 52220, 52222, 52228, 52233, 52235, 52240, 52242, 52247, 52252, 52254, 52256, 52263, 52268, 52270, 52276, 52279, 52281, 52283, 52288, 52290, 52293, 52297, 52299, 52302, 52304, 52309, 52311, 52313, 52316, 52318, 52322, 52325, 52328, 52334, 52340, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52366, 52370, 52373, 52376, 52385, 52393, 52395, 52397, 52399, 52402, 52404, 52409, 52412, 52414, 52419, 52422, 52424, 52433, 52443, 52446, 52455, 52457, 52460, 52462, 52465, 52470, 52475, 52477, 52482, 52489, 52494, 52496, 52500, 52505, 52508, 52510, 52515, 52520, 52521, 52526, 52528, 52529, 52535, 52536, 52537, 52539, 52540, 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, 52577, 52579, 52580, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52588, 52593, 52594, 52595, 52596, 52597, 52598, 52599, 52600, 52601, 52602, 52603, 52604, 52605, 52606, 52607, 52608, 52609, 52610, 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: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: Katharine and Petruchio

Cast
Role: Hortensio Actor: Trueman

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Adopted Child

Cast
Role: Sir Bertrand Actor: Trueman

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Purse

Song: As17990529

Performances

Mainpiece Title: Peeping Tom

Afterpiece Title: Family Distress

Afterpiece Title: The Village Lawyer

Cast
Role: Charles Actor: Trueman

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: High Life below Stairs

Cast
Role: Freeman Actor: Trueman

Dance: As17980920

Song: As17990529

Performances

Mainpiece Title: A Mogul Tale

Afterpiece Title: Family Distress

Cast
Role: Charles Actor: Trueman

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Irish Widow

Song: As17990529

Performances

Mainpiece Title: The Dead Alive

Afterpiece Title: Family Distress

Cast
Role: Charles Actor: Trueman

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Apprentice

Cast
Role: President Actor: Trueman

Song: As17990529

Performances

Mainpiece Title: The Purse

Afterpiece Title: Family Distress

Cast
Role: Charles Actor: Trueman

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Adopted Child

Cast
Role: Sir Bertrand Actor: Trueman

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: Katharine and Petruchio

Cast
Role: Hortensio Actor: Trueman

Song: As17990529

Performances

Mainpiece Title: The London Hermit; Or, Rambles In Dorsetshire

Cast
Role: Peregrine Actor: Trueman

Afterpiece Title: The Village Lawyer

Cast
Role: Charles Actor: Trueman

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Humourist

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Purse

Cast
Role: Theodore Actor: Trueman

Song: As17990529

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Henry Moreland Actor: Trueman

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: No Song No Supper

Song: As17990529

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Peeping Tom

Cast
Role: Charles Actor: Trueman

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Purse

Song: As17990529

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: The Jew and the Doctor

Cast
Role: Charles Actor: Trueman

Entertainment: Monologue As17990622

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: Katharine and Petruchio

Song: Mainpiece: Vocal Parts-Kelly, Sedgwick, Dignum, Danby, Mrs Crouch, Miss DeCamp, Miss Stephens, Miss Leak, Miss Dufour

Ballet: End: The Scotch Ghost. As17981206, but Jamie-St.Pierre (1st appearance on this stage); Saundy-_; Donald-_; Villagers-_

Performances

Mainpiece Title: Rosina

Afterpiece Title: The London Hermit

Cast
Role: Charles Actor: Trueman

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: Pizarro

Cast
Role: Davilla Actor: Trueman

Afterpiece Title: The Lying Valet

Ballet: The Scotch Ghost. As17990628

Song: As17990628

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Prize

Cast
Role: Heartwell Actor: Trueman

Music: End: a new Grand Concerto on the violin (his composition)-Spagnoletti (1st appearance in public since his arrival from Italy)

Ballet: End II: a new Comic Ballet, The Happy Stratagem; or, The Deluded Mother. Jack-Bartolomici (1st public appearance); Fanny , Younger Sister-Sga Bossi DelCaro; Margaret , Elder Sister-Mlle Parisot; Susanna , their Mother-Mrs Brooker