SELECT * FROM london_stages WHERE eventid IN (24634, 25251, 26305, 26308, 26314, 26610, 27690, 27692, 27722, 27728, 27737, 27763, 27791, 27793, 27804, 27846, 27913, 27922, 27932, 27945, 27981, 28031, 28067, 28083, 28092, 28166, 28187, 28205, 28207, 28219, 28253, 28275, 28393, 28484, 28491, 28506, 28633, 28641, 28651, 28667, 28681, 28691, 28694, 28696, 28699, 28702, 28707, 28709, 28712, 28721, 28723, 28726, 28728, 28731, 28737, 28740, 28770, 28777, 28782, 28794, 28800, 28849, 28939, 28967, 28973, 29009, 29022, 29036, 29085, 29154, 29167, 29171, 29174, 29176, 29189, 29191, 29193, 29195, 29197, 29199, 29207, 29213, 29215, 29219, 29225, 29227, 29230, 29237, 29244, 29248, 29254, 29257, 29264, 29266, 29271, 29273, 29280, 29282, 29285, 29287, 29291, 29293, 29295, 29300, 29306, 29308, 29312, 29315, 29317, 29322, 29325, 29331, 29336, 29338, 29342, 29344, 29349, 29354, 29357, 29361, 29363, 29367, 29372, 29393, 29395, 29398, 29412, 29431, 29442, 29449, 29452, 29484, 29496, 29499, 29532, 29537, 29547, 29549, 29583, 29593, 29604, 29610, 29735, 29739, 29742, 29749, 29752, 29756, 29760, 29762, 29764, 29770, 29772, 29774, 29776, 29813, 29815, 29819, 29821, 29826, 29846, 29853, 29864, 29877, 29881, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30086, 30093, 30114, 30145, 30151, 30160, 30295, 30297, 30299, 30301, 30305, 30313, 30327, 30357, 30360, 30362, 30365, 30379, 30383, 30561, 30617, 30653, 30678, 30684, 30697, 30703, 30791, 30795, 30806, 30816, 30820, 30845, 30858, 30860, 30872, 30880, 30882, 30884, 30891, 30905, 30912, 30924, 30942, 30954, 30958, 30966, 30973, 30976, 30979, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31061, 31069, 31094, 31097, 31100, 31102, 31109, 31116, 31136, 31168, 31179, 31182, 31189, 31200, 31220, 31223, 31247, 31274, 31350, 31354, 31356, 31360, 31368, 31370, 31372, 31374, 31378, 31389, 31391, 31395, 31397, 31399, 31405, 31409, 31411, 31413, 31417, 31419, 31426, 31428, 31432, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31517, 31519, 31523, 31526, 31531, 31533, 31535, 31542, 31556, 31569, 31605, 31617, 31626, 31629, 31632, 31642, 31648, 31657, 31673, 31686, 31689, 31700, 31718, 31731, 31740, 31761, 31767, 31771, 31773, 31829, 31831, 31835, 31837, 31839, 31841, 31847, 31849, 31853, 31869, 31877, 31881, 31885, 31887, 31965, 31985, 31987, 31989, 31991, 31993, 31995, 31998, 32000, 32003, 32005, 32007, 32009, 32012, 32014, 32017, 32019, 32021, 32023, 32026, 32028, 32030, 32032, 32034, 32036, 32039, 32041, 32045, 32047, 32049, 32051, 32054, 32057, 32059, 32061, 32063, 32066, 32068, 32076, 32078, 32083, 32090, 32095, 32097, 32102, 32106, 32114, 32131, 32211, 32219, 32224, 32231, 32235, 32238, 32258, 32264, 32321, 32325, 32329, 32339, 32342, 32346, 32348, 32350, 32352, 32356, 32358, 32364, 32366, 32382, 32384, 32390, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32454, 32459, 32464, 32466, 32471, 32473, 32475, 32477, 32479, 32481, 32486, 32488, 32493, 32495, 32500, 32502, 32507, 32514, 32516, 32523, 32526, 32546, 32554, 32556, 32558, 32563, 32568, 32575, 32580, 32593, 32619, 32648, 32656, 32658, 32666, 32671, 32676, 32722, 32724, 32748, 32813, 32815, 32817, 32822, 32827, 32830, 32836, 32838, 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, 33106, 33110, 33121, 33166, 33177, 33183, 33195, 33265, 33269, 33271, 33273, 33275, 33277, 33285, 33289, 33295, 33300, 33304, 33315, 33317, 33322, 33325, 33327, 33330, 33332, 33339, 33341, 33344, 33346, 33353, 33383, 33388, 33397, 33400, 33402, 33428, 33430, 33435, 33439, 33481, 33483, 33506, 33515, 33520, 33536, 33654, 33671, 33794, 33796, 33798, 33802, 33804, 33808, 33810, 33896, 33974, 33976, 33978, 33980, 33982, 33984, 33986, 33989, 33991, 33994, 33998, 34000, 34003, 34005, 34187, 34199, 34328, 34339, 34374, 34376, 34391, 34395, 34397, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34482, 34487, 34489, 34493, 34498, 34503, 34523, 34525, 34527, 34529, 34531, 34536, 34541, 34547, 34552, 34559, 34566, 34569, 34571, 34585, 34589, 34597, 34611, 34636, 34720, 34732, 34751, 34761, 34763, 34777, 34779, 34895, 34911, 34917, 35281, 35308, 35316, 35528, 35530, 35533, 35537, 35539, 35545, 35547, 35560, 35562, 35568, 35570, 35575, 35579, 35585, 35592, 35619, 35621, 35693, 35749, 35763, 35810, 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, 36429, 36440, 36482, 36523, 36529, 36540, 36649, 36653, 36671, 36688, 36696, 36704, 36717, 36722, 36731, 36736, 36742, 36752, 36764, 36773, 36780, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36834, 36837, 36839, 36844, 36846, 36850, 36853, 36855, 36860, 36878, 36883, 36890, 36897, 36902, 36906, 36914, 36955, 36957, 37036, 37058, 37068, 37094, 37096, 37212, 37214, 37216, 37218, 37229, 37241, 37251, 37253, 37257, 37264, 37268, 37276, 37303, 37307, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37430, 37436, 37443, 37445, 37455, 37477, 37524, 37531, 37566, 37579, 37602, 37618, 37623, 37643, 37787, 37793, 37797, 37803, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37852, 37856, 37870, 37874, 37887, 37893, 37902, 37905, 37949, 37962, 38050, 38123, 38153, 38158, 38167, 38183, 47498, 47504, 47532, 47544, 47576, 47588, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48112, 48122, 48136, 48145, 48149, 48153, 48157, 48169, 48173, 48181, 48185, 48208, 48222, 48277, 48319, 48340, 48401, 48415, 48429, 49030, 49045, 49060, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49384, 49417, 49424, 49431, 49433, 49444, 49582, 49584, 49586, 49591, 49601, 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, 50060, 50081, 50096, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50346, 50347, 50349, 50351, 50357, 50359, 50365, 50372, 50377, 50382, 50384, 50386, 50397, 50399, 50403, 50405, 50407, 50409, 50411, 50415, 50417, 50423, 50427, 50432, 50437, 50439, 50451, 50453, 50460, 50474, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50533, 50537, 50542, 50558, 50563, 50570, 50643, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51134, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51233, 51236, 51240, 51248, 51251, 51253, 51260, 51262, 51267, 51270, 51279, 51284, 51287, 51294, 51299, 51301, 51311, 51321, 51323, 51326, 51328, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51377, 51380, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51582, 51588, 51592, 51597, 51600, 51609, 51612, 51618, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51705, 51709, 51712, 51715, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51793, 51840, 51842, 51846, 51884, 51926, 51970, 51972, 51975, 52084, 52086, 52088, 52091, 52092, 52095, 52103, 52105, 52111, 52115, 52117, 52125, 52163, 52189, 52193, 52285, 52293, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52370, 52376, 52465, 52475, 52482, 52491, 52503, 52510, 52512) 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

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Isabella; Or, The Fatal Marriage

Afterpiece Title: Blue-Beard

Song: In III: Epithalamium. Vocal Parts-Mrs Bland, Miss Leak

Performances

Mainpiece Title: A Word For Nature

Afterpiece Title: The Shipwreck

Ballet: End: The Scotch Ghost; or, Little Fanny's Love. Jamie-Dubois; Glaude-Grimaldi; Saundy-Master Chatterley; Donald-Whitmell; The Lady of Dunblain-Mlle Parisot; Elpsa-Mrs Brooker; Fanny (with Hornpipe)-Sga Bossi DelCaro; Villagers-Roffey, Garman, Wells, Gauron, Goodman, Johnston, Bisan, Ms Brigg, Ms Byrne, Ms Daniels, Ms Vining, Ms Luciet, Ms Riches, Ms Drake

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: A Word For Nature

Afterpiece Title: My Grandmother

Ballet: End: The Scotch Ghost. As17981206

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Sylvester Daggerwood

Dance: In III: as17981129

Ballet: End afterpiece: The Scotch Ghost. As17981206

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: The Stranger

Afterpiece Title: The Humourist

Music: As17980915

Dance: In: As17980915

Ballet: End: The Scotch Ghost. As17981206

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Shipwreck

Song: As17981203

Ballet: End: The Scotch Ghost. As17981206

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Son-in-Law

Ballet: End: The Scotch Ghost. As17981206

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Feudal Times; or, The Banquet Gallery

Performances

Mainpiece Title: Love Makes A Man

Performances

Mainpiece Title: The Wheel Of Fortune

Performances

Mainpiece Title: The Stranger

Music: As17980915

Dance: As17980915

Performances

Mainpiece Title: The Jew

Performances

Mainpiece Title: The Wonder

Performances

Mainpiece Title: The Belle's Stratagem

Performances

Mainpiece Title: The Grecian Daughter

Performances

Mainpiece Title: A Bold Stroke For A Wife

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Rivals

Performances

Mainpiece Title: Much Ado About Nothing

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Apprentice

Ballet: End: Moggy and Jemmy. Jemmy-Garman; Bauldi-Grimaldi; Lady-Miss Daniels; Maude-Mrs Brooker; Moggy-Sga Bossi DelCaro; Peasants-Goodman, Whitmell, Wells, Bayzand, Johnston, Gauron, Masters J. and W. Chatterley, Ms Brigg, Ms Byrne, Ms Vining, Ms Riches, Ms Luciet, Ms Drake, Ms Connelly

Cast
Role: Maude Actor: Mrs Brooker

Performances

Mainpiece Title: The School For Scandal

Song: As17990108

Performances

Mainpiece Title: The Belle's Stratagem