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: As You Like It

Song: V: a song-Mrs Bland

Performances

Mainpiece Title: The Country Girl

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: As You Like It

Song: As17990214

Performances

Mainpiece Title: Twelfth Night

Performances

Mainpiece Title: No Song No Supper

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Jealous Wife

Performances

Mainpiece Title: As You Like It

Song: As17990214

Performances

Mainpiece Title: Macbeth

Song: Chorus of Witches and Spirits, as17980918, but Miss _Arne, Mrs Crouch, Miss _Wentworth, Mrs +Bland, added: +Kelly

Performances

Mainpiece Title: Will And No Will; Or, Wit's Last Stake

Afterpiece Title: Trials of the Heart

Song: End 2nd piece: The Country Club-Bannister Jun.; In 3rd piece: In the dead of the Night-Mrs Jordan

Entertainment: Monologue End: Foote's Prologue to The Author-King; in which is introduced the well-known Fable of The Man the Boy and the Ass-King

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Deserter

Song: V: a song, as17990214

Entertainment: Monologue End: The Picture of a Play House; or, Bucks have at ye all-R. Palmer; Vaudeville II 3rd piece: Military Manoeuvres-; The Dead March-; the Ceremony Shooting a Deserter-

Performances

Mainpiece Title: The Inconstant

Entertainment: Vaudeville. In II afterpiece: Military Manoeuvres, as17990425; The Dead March, as17990425; Shooting a Deserter, as17990425

Performances

Mainpiece Title: The Castle-spectre

Entertainment: Monologues End: Collins's Ode on the Passions (1st time)-Miss Heard; Epilogue in the Character of Cupid-Master Chatterley

Performances

Mainpiece Title: Pizarro

Song: As17990529

Performances

Mainpiece Title: Pizarro

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-_

Cast
Role: Elpsa Actor: Mrs Brooker

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Lying Valet

Ballet: The Scotch Ghost. As17990628

Cast
Role: Elpsa Actor: Mrs Brooker

Song: As17990628

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Prize

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

Cast
Role: their Mother Actor: Mrs Brooker.

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Blue-Beard; or, Female Curiosity

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Blue-Beard

Song: As17991001

Performances

Mainpiece Title: The Wonder

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Blue-Beard

Dance: In III: Hornpipe-Garman

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Blue-Beard