SELECT * FROM london_stages WHERE eventid IN (13292, 13296, 13318, 13322, 13343, 13351, 13355, 13360, 17805, 17809, 17813, 17816, 17820, 17823, 17826, 17829, 17832, 17835, 17839, 17843, 17847, 17852, 17857, 17862, 17867, 17875, 17906, 17944, 17954, 18224, 18229, 18233, 18237, 18242, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18278, 18281, 18283, 18286, 18289, 18292, 18295, 18300, 18303, 18307, 18310, 18314, 18318, 18432, 18437, 18444, 18447, 18450, 19510, 19516, 19520, 19527, 19534, 19536, 19538, 19556, 19562, 19576, 19590, 19595, 19611, 19646, 19648, 19650, 19653, 19656, 19658, 19659, 19663, 19683, 19685, 19713, 19715, 19741, 19791, 19793, 19795, 19798, 19845, 19847, 19878, 19881, 19883, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20002, 20003, 20008, 20010, 20012, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20053, 20054, 20058, 20063, 20067, 20068, 20072, 20082, 20088, 20098, 20102, 20103, 20107, 20111, 20113, 20116, 20122, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20359, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21103, 21119, 21138, 21141, 21145, 21148, 21152, 21155, 21159, 21163, 21170, 21172, 21179, 21184, 21186, 22082, 22087, 22090, 22093, 22096, 22099, 22104, 22107, 22114, 22130, 22143, 22154, 22385, 22388, 22390, 22392, 22442, 22445, 22449, 22506, 22509, 22515, 22518, 22522, 22532, 22553, 22556, 22565, 22609, 22617, 22619, 22660, 22670, 22702, 22750, 22770, 22773, 22831, 22939, 22942, 22945, 22948, 22957, 22959, 22971, 22974, 22979, 23003, 23005, 23015, 23036, 23041, 23066, 23098, 23101, 23104, 23128, 23140, 23151, 23179, 23207, 23210, 23215, 23226, 23267, 23298, 23558, 23561, 23594, 23662, 23706, 23711, 23721, 23728, 23744, 23747, 23812, 23826, 23842, 26178, 28823, 28825, 28828, 28831, 28837, 28841, 28844, 28847, 28871, 28876, 28885, 28891, 28893, 28896, 28956, 28958, 28983, 28997, 29070, 29173, 29180, 29190, 29196, 29415, 29537, 29547, 29549, 29593, 29610, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29935, 29942, 29953, 29957, 29959, 29963, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30053, 30126, 30133, 30144, 30148, 30152, 30745, 30746, 30748, 30752, 30757, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 31398, 31402, 31404, 31406, 31408, 31410, 31412, 31416, 31425, 31429, 31436, 31438, 31452, 31456, 31460, 31463, 31501, 31503, 31513, 31515, 31516, 31517, 31520, 31524, 31530, 31532, 31534, 31536, 31541, 31547, 31854, 31858, 31860, 31862, 31866, 31870, 31882, 31890, 31892, 31894, 31898, 31906, 31910, 31918, 31928, 31931, 31936, 31940, 31947, 31956, 31961, 31970, 31975, 31986, 31988, 31990, 32205, 32377, 32379, 32383, 32385, 32389, 32391, 32396, 32402, 32404, 32408, 32420, 32422, 32424, 32429, 32431, 32443, 32471, 32473, 32475, 32477, 32479, 32481, 32486, 32488, 32493, 32495, 32500, 32502, 32507, 32510, 32514, 32515, 32516, 32517, 32524, 32527, 32537, 32540, 32554, 32556, 32558, 32563, 32568, 32573, 32575, 32580, 32593, 32619, 32648, 32656, 32658, 32692, 32721, 32738, 32966, 32969, 32972, 32974, 32976, 32978, 32981, 32983, 32985, 32987, 32989, 32991, 32994, 32996, 32999, 33003, 33005, 33008, 33010, 33012, 33017, 33020, 33022, 33024, 33026, 33029, 33031, 33034, 33042, 33265, 33269, 33271, 33273, 33275, 33277, 33285, 33289, 33295, 33300, 33304, 33315, 33317, 33322, 33325, 33327, 33330, 33332, 33339, 33341, 33344, 33346, 33353, 33383, 33397, 33400, 33402, 33428, 33430, 33435, 33439, 33481, 33483, 33506, 33515, 33520, 33536, 33654, 33794, 33796, 33804, 33808, 33810, 33896, 33995, 33997, 33999, 34001, 34004, 34006, 34009, 34011, 34013, 34015, 34018, 34025, 34029, 34034, 34068, 34089, 34181, 34187, 34198, 34199, 34230, 34253, 34259, 34267, 34340, 34345, 34356, 34368, 34375, 34376, 34377, 34380, 34384, 34390, 34394, 34415, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34453, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34485, 34521, 34531, 34536, 34541, 34547, 34552, 34559, 34566, 34569, 34571, 34585, 34589, 34598, 34668, 34694, 34713, 34720, 34723, 34725, 34732, 34739, 34751, 34754, 34759, 34761, 34777, 34779, 34782, 34785, 34794, 34805, 34895, 34911, 34917, 35281, 35308, 35504, 35509, 35512, 35517, 35519, 35528, 35530, 35533, 35537, 35539, 35545, 35547, 35560, 35562, 35568, 35570, 35575, 35579, 35585, 35592, 35604, 35606, 35608, 35611, 35613, 35618, 35619, 35620, 35621, 35622, 35630, 35639, 35651, 35693, 35749, 35763, 35810, 35814, 35824, 35843, 35870, 35910, 35929, 35945, 36141, 36143, 36145, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36482, 36523, 36529, 36540, 36649, 36653, 36688, 36696, 36704, 36717, 36722, 36731, 36736, 36742, 36746, 36748, 36752, 36755, 36764, 36773, 36780, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36842, 36845, 36847, 36849, 36851, 36854, 36859, 36861, 36867, 36872, 36874, 36876, 36889, 36896, 36898, 36903, 36905, 36910, 36970, 36989, 37029, 37036, 37058, 37061, 37064, 37067, 37068, 37077, 37079, 37086, 37096, 37120, 37212, 37214, 37218, 37228, 37229, 37230, 37236, 37241, 37251, 37268, 37303, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37430, 37436, 37443, 37445, 37455, 37477, 37480, 37486, 37491, 37524, 37566, 37579, 37623, 37643, 37787, 37793, 37797, 37803, 37825, 37827, 37829, 37833, 37835, 37852, 37870, 37874, 37887, 37893, 37902, 37905, 37941, 37943, 37949, 37962, 38050, 38123, 38153, 38158, 38167, 38172, 38183, 38335, 38338, 38339, 38343, 38346, 38350, 38352, 38354, 38361, 38362, 38365, 38368, 38369, 38370, 38371, 38377, 38379, 38416, 38430, 38444, 38448, 38458, 38464, 38465, 38706, 38731, 38873, 38883, 38891, 38893, 38951, 38956, 38974, 39023, 39025, 39029, 39031, 39033, 39035, 39039, 39042, 39048, 39050, 39052, 39057, 39061, 39070, 39075, 39077, 39082, 39203, 39209, 39237, 39258, 39261, 39277, 39283, 39294, 39299, 39313, 39318, 39330, 39398, 39400, 39404, 39407, 39411, 39413, 39415, 39426, 39435, 39439, 39454, 39456, 39458, 39461, 39511, 39513, 39518, 39603, 39611, 39613, 39615, 39618, 39621, 39625, 39629, 39632, 39637, 39641, 39646, 39675, 39678, 39687, 39707, 39735, 39750, 39840, 39866, 39871, 39966, 39968, 39973, 40035, 40125, 40153, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40279, 40311, 40316, 40323, 40326, 40331, 40358, 40367, 40379, 40382, 40388, 40413, 40425, 40427, 40454, 40565, 40571, 40577, 40588, 40597, 40639, 40846, 40860, 40959, 40964, 40982, 41102, 41103, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41128, 41136, 41165, 41189, 41237, 41246, 41256, 41280, 41286, 41300, 41308, 41322, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 42187, 42194, 42198, 42222, 42226, 42227, 42293, 42294, 42447, 42449, 42451, 42454, 42457, 42460, 42464, 42471, 42474, 42478, 42483, 42488, 42493, 42495, 42500, 42503, 42507, 42512, 42519, 42524, 42529, 42531, 42533, 42540, 42543, 42548, 42560, 42565, 42570, 42583, 42596, 42609, 42670, 42726, 42764, 42766, 42767, 42770, 42772, 42780, 42831, 42833, 42834, 42835, 42837, 42847, 42849, 43271, 43380, 43390, 43398, 43402, 43407, 43420, 43423, 43966, 43976, 43980, 44001, 44011, 44012, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44508, 44512, 44519, 44520, 44528, 44545, 45537, 45547, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45951, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46093, 46100, 46103, 46121, 46133, 46148, 46154, 46166, 46174, 46220, 46407, 46409, 46411, 46412, 46413, 46414, 46415, 46416, 46417, 46418, 46419, 46420, 46421, 46423, 46424, 46425, 46426, 46427, 46428, 46429, 46431, 46432, 46433, 46436, 46437, 46438, 46440, 46441, 46442, 46443, 46446, 46447, 46448, 46451, 46452, 46455, 46457, 46460, 46461, 46462, 46464, 46466, 46469, 46470, 46471, 46473, 46476, 46477, 46478, 46481, 46482, 46486, 46487, 46492, 46494, 46495, 46509, 46511, 46515, 46522, 46529, 46535, 46536, 46566, 46593, 46700, 46711, 46729, 46905, 46917, 46941, 46949, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46990, 47008, 47012, 47014, 47018, 47020, 47024, 47026, 47032, 47044, 47052, 47070, 47075, 47087, 47116, 47130, 47182, 48551, 48553, 48569, 48588, 48613, 48618, 48620, 48621, 48628, 48650, 48654, 48672, 48677, 48712, 48722, 48734, 48737, 48744, 48760, 48762, 48763, 48765, 48768, 48770, 48772, 48773, 48782, 48784, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48827, 48831, 48837, 48845, 48850, 48852, 48858, 48859, 48864, 48866, 48880, 48883, 48884, 48891, 48903, 48919, 48928, 48931, 48948, 49046, 49051, 49058, 49069, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50210, 50215, 50374, 50380, 50385, 50387, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50537, 50542, 50558, 50570, 50800, 51360, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51853, 51877, 51927, 51929) 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: Better Late Than Never

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Burton

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Claremont

Entertainment: Afterpiece: [To conclude with Three Entire New Scenes, representing the Town and Harbour of Toulon; with a View of the Manoeuvring of the British, Spanish, and French Fleets, after the Surrender of the Town and Fortifications to the English] on the Twenty-ninth of August [1793]. In which, When in War on the Ocean-Davies; an Entire New Song [composed by Shield,-Incledon; The Music- [Selected by Shaw from Pepusch, Dr Arne, Arnold, Fisher, [Michael] Arne, Vincent, Dibdin, Reeve, Shield; The Dances-Byrn, Holland[; The Scenery-Hodgins, Walmsley, Phillips

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Claremont

Entertainment: As17931002

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Claremont

Dance: III: a Hornpipe in Character-Byrn

Entertainment: When in War on the Ocean, as17931002; New Song-Gray in place of Incledon; The Music, as17931002; The Dances, as17931002

Performances

Mainpiece Title: Lovers' Quarrels

Afterpiece Title: HARTFORD BRIDGE

Afterpiece Title: HARLEQUIN'S CHAPLET

Cast
Role: Pantaloon Actor: Claremont

Entertainment: As17931002

Performances

Mainpiece Title: Hamlet

Afterpiece Title: HARLEQUIN'S CHAPLET

Cast
Role: Pantaloon Actor: Claremont

Song: As17931030

Entertainment: As17931012

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Fugitive

Cast
Role: Pantaloon Actor: Claremont

Performances

Mainpiece Title: The Female Pursuit; Or, Stop Her Who Can

Afterpiece Title: The Fugitive

Cast
Role: Pantaloon Actor: Claremont

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: Lovers' Quarrels

Afterpiece Title: HARTFORD BRIDGE

Afterpiece Title: HARLEQUIN'S CHAPLET

Cast
Role: Pantaloon Actor: Claremont

Entertainment: As17931002

Performances

Mainpiece Title: Othello

Afterpiece Title: The Fugitive

Cast
Role: Pantaloon Actor: Claremont

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Ratchford

Dance: As17931020

Performances

Mainpiece Title: The German Hotel

Afterpiece Title: Annette and Lubin

Afterpiece Title: The Death of Captain Cook

Cast
Role: Pantaloon Actor: Claremont

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Ratchford

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: THE SPRIGS OF LAUREL

Cast
Role: Pantaloon Actor: Claremont

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Ratchford

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Pantaloon Actor: Ratchford

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: The German Hotel

Cast
Role: Pantaloon Actor: Claremont

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: Hamlet

Afterpiece Title: ROSE AND COLIN

Cast
Role: Pantaloon Actor: Ratchford

Dance: As17931022

Song: As17931030, but omitted: Gray

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Midnight Hour

Cast
Role: Pantaloon Actor: Claremont

Afterpiece Title: A Divertisement

Dance: As17931123