SELECT * FROM london_stages WHERE eventid IN (4071, 4157, 4268, 4282, 4288, 4292, 4295, 4300, 4313, 4330, 4341, 4360, 4371, 4441, 4476, 4687, 4733, 4958, 5986, 5992, 5997, 6007, 6011, 6019, 6035, 6079, 6282, 6290, 6302, 6339, 6344, 6351, 6369, 6381, 6392, 6421, 6442, 6454, 6463, 6679, 6695, 6711, 6719, 6728, 6742, 6757, 6772, 6788, 6804, 6814, 6838, 6875, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20154, 20156, 20158, 20161, 20164, 20167, 20170, 20173, 20176, 20200, 20234, 20240, 20290, 20299, 20302, 20330, 20344, 20348, 20370, 20373, 20382, 20402, 20469, 20501, 20543, 20559, 20568, 20581, 20608, 20611, 20651, 20787, 20790, 20797, 20823, 20826, 20842, 20846, 20849, 20855, 20858, 20861, 20938, 20956, 20961, 20974, 21005, 21025, 21042, 21052, 21437, 21440, 21443, 21446, 21455, 21458, 21461, 21463, 21471, 26178, 28817, 29291, 29300, 29308, 29312, 29320, 29331, 29336, 29338, 29342, 29344, 29349, 29352, 29357, 29361, 29363, 29367, 29369, 29393, 29395, 29398, 29412, 29424, 29428, 29431, 29442, 29445, 29449, 29452, 29484, 29496, 29499, 29532, 29537, 29583, 29752, 29756, 29760, 29764, 29770, 29774, 29813, 29815, 29821, 29835, 29838, 29840, 29844, 29848, 29851, 29853, 29881, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30145, 30151, 30295, 30299, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30337, 30357, 30360, 30362, 30365, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30450, 30452, 30475, 30479, 30566, 30575, 30619, 30662, 30686, 30690, 30695, 30699, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30878, 30880, 30882, 30884, 30886, 30888, 30893, 30900, 30916, 30922, 30924, 30926, 30928, 30930, 30933, 30935, 30937, 30940, 30942, 30944, 30947, 30950, 30954, 30966, 30973, 30979, 30983, 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, 31045, 31047, 31049, 31052, 31055, 31057, 31059, 31061, 31063, 31066, 31069, 31074, 31076, 31094, 31097, 31100, 31102, 31109, 31112, 31116, 31136, 31151, 31158, 31165, 31179, 31182, 31189, 31197, 31203, 31216, 31220, 31223, 31274, 31368, 31370, 31372, 31374, 31378, 31389, 31391, 31395, 31397, 31399, 31405, 31409, 31411, 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, 31513, 31515, 31517, 31519, 31523, 31526, 31531, 31533, 31535, 31542, 31556, 31569, 31605, 31617, 31626, 31629, 31632, 31642, 31648, 31657, 31671, 31673, 31684, 31686, 31689, 31700, 31715, 31718, 31723, 31731, 31740, 31761, 31763, 31767, 31771, 31773, 31839, 31841, 31847, 31849, 31853, 31877, 31881, 31885, 31887, 31907, 31937, 31941, 31946, 31951, 31953, 31972, 31982, 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, 32078, 32083, 32090, 32095, 32097, 32102, 32104, 32106, 32109, 32114, 32117, 32119, 32124, 32128, 32131, 32134, 32140, 32146, 32158, 32171, 32177, 32195, 32206, 32224, 32233, 32235, 32258, 32264, 32321, 32325, 32329, 32334, 32339, 32342, 32346, 32348, 32366, 32390, 32393, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32452, 32454, 32459, 32464, 32466, 32471, 32473, 32475, 32477, 32479, 32481, 32486, 32488, 32493, 32495, 32500, 32502, 32507, 32514, 32516, 32554, 32556, 32558, 32563, 32568, 32575, 32580, 32593, 32619, 32648, 32653, 32656, 32658, 32666, 32671, 32676, 32678, 32680, 32704, 32708, 32720, 32722, 32724, 32748, 32813, 32815, 32817, 32822, 32838, 32866, 32886, 32888, 32890, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32935, 32944, 32949, 32951, 32956, 32958, 32960, 32962, 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, 33108, 33110, 33265, 33269, 33271, 33273, 33275, 33277, 33285, 33289, 33295, 33297, 33300, 33304, 33315, 33317, 33322, 33325, 33327, 33330, 33332, 33339, 33341, 33344, 33346, 33353, 33378, 33383, 33397, 33400, 33402, 33428, 33430, 33435, 33439, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33481, 33483, 33486, 33489, 33491, 33494, 33496, 33501, 33506, 33510, 33515, 33517, 33520, 33524, 33529, 33536, 33572, 33620, 33626, 33647, 33654, 33684, 33710, 33794, 33796, 33804, 33806, 33808, 33810, 33829, 33833, 33841, 33843, 33860, 33889, 33896, 33898, 33974, 33976, 33978, 33980, 33982, 33984, 33986, 33989, 33991, 33994, 33998, 34000, 34003, 34005, 34017, 34040, 34050, 34058, 34069, 34072, 34146, 34182, 34187, 34199, 34202, 34204, 34237, 34328, 34339, 34342, 34350, 34374, 34376, 34391, 34393, 34395, 34397, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34531, 34536, 34541, 34547, 34552, 34559, 34566, 34569, 34571, 34580, 34585, 34589, 34720, 34732, 34751, 34761, 34777, 34779, 34895, 34905, 34911, 34917, 34977, 35113, 35138, 35240, 35250, 35281, 35286, 35302, 35308, 35332, 35354, 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, 36482, 36523, 36529, 36540, 36649, 36653, 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, 37036, 37058, 37068, 37096, 37212, 37214, 37216, 37218, 37229, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37251, 37253, 37268, 37272, 37303, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37439, 37445, 37455, 37460, 37467, 37477, 37479, 37517, 37524, 37566, 37579, 37623, 37643, 37646, 37787, 37793, 37795, 37797, 37803, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37852, 37856, 37870, 37874, 37887, 37893, 37897, 37902, 37905, 37907, 37941, 37943, 37949, 37954, 37962, 38050, 38123, 38153, 38156, 38158, 38167, 38172, 38183, 38330, 38334, 38336, 38339, 38343, 38361, 38369, 38371, 38387, 38390, 38394, 38448, 38464, 38706, 38731, 38873, 38883, 38891, 38951, 38956, 38974, 39841, 40035, 40125, 40153, 40196, 40198, 40201, 40204, 40207, 40211, 40213, 40216, 40218, 40223, 40225, 40227, 40230, 40232, 40275, 40284, 40388, 40427, 40565, 40571, 40573, 40577, 40579, 40588, 40597, 40603, 40605, 40631, 40639, 40673, 40692, 40716, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40745, 40747, 40749, 40751, 40754, 40760, 40762, 40764, 40769, 40776, 40780, 40783, 40786, 40794, 40796, 40806, 40812, 40818, 40820, 40841, 40847, 40851, 40861, 40869, 40875, 40879, 40881, 40883, 40901, 40959, 40964, 40966, 40973, 40982, 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, 42923, 42925, 42929, 42931, 42933, 42937, 42951, 42957, 42962, 42967, 42969, 42976, 42990, 43000, 43009, 43011, 43021, 43033, 43035, 43037, 43039, 43042, 43271, 43443, 43445, 43447, 43459, 43475, 43489, 43499, 43507, 43518, 43540, 43548, 43574, 43584, 43591, 43595, 43612, 43632, 43635, 43637, 43640, 43646, 43650, 43655, 43663, 43667, 43706, 43717, 43853, 43877, 44034, 44047, 44055, 44062, 44084, 44088, 44096, 44102, 44166, 44169, 44171, 44173, 44175, 44177, 44508, 44512, 44519, 44528, 44545, 44577, 44579, 44583, 44585, 45762, 45768, 45919, 45924, 45933, 45947, 45966, 45974, 45987, 46549, 46551, 46560, 46574, 46589, 46603, 46618, 46677, 46857, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46990, 47008, 47012, 47014, 47018, 47020, 47024, 47026, 47032, 47044, 47052, 47070, 47075, 47087, 47116, 47130, 47182, 48763, 48765, 48773, 49415, 50367, 50375, 50399, 50403, 50405, 50407, 50409, 50411, 50415, 50417, 50423, 50425, 50427, 50429, 50432, 50437, 50439, 50451, 50453, 50460, 50465, 50467, 50474, 50479, 50481, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50519, 50523, 50528, 50533, 50535, 50537, 50542, 50548, 50550, 50553, 50558, 50561, 50563, 50565, 50567, 50570, 50585, 50590, 50592, 50594, 50596, 50599, 50601, 50610, 50615, 50619, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50667, 50673, 50687, 50689, 50692, 50696, 50701, 50706, 50711, 50713, 50721, 50723, 50725, 50730, 50735, 50741, 50743, 50746, 50748, 50751, 50756, 50761, 50768, 50771, 50773, 50778, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50804, 50811, 50918, 50935, 50968, 50974, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51004, 51011, 51042, 51051, 51056, 51060, 51063, 51066, 51080, 51082, 51084, 51094, 51100, 51106, 51109, 51111, 51113, 51115, 51118, 51120, 51149, 51155, 51169, 51172, 51174, 51178, 51181, 51196, 51208, 51222, 51233, 51236, 51240, 51243, 51246, 51260, 51262, 51267, 51270, 51279, 51284, 51287, 51292, 51294, 51299, 51301, 51311, 51316, 51321, 51323, 51326, 51328, 51330, 51332, 51337, 51344, 51348, 51353, 51357, 51362, 51364, 51367, 51369, 51373, 51377, 51380, 51497, 51499, 51534, 51550, 51584, 51588, 51592, 51597, 51600, 51604, 51612, 51618, 51658, 51670, 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, 51853, 51878, 51884, 51892, 51926, 51928, 51941, 51952, 51956, 51970, 51972, 52069, 52078, 52084, 52098, 52101, 52109, 52119, 52125, 52131, 52147, 52149, 52163, 52165, 52183, 52189, 52193, 52209, 52211, 52213, 52215, 52217, 52220, 52224, 52226, 52233, 52238, 52240, 52244, 52247, 52252, 52254, 52261, 52266, 52281, 52285, 52293, 52307, 52340, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52397, 52404, 52457, 52465, 52475, 52482, 52485, 52491, 52503, 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 Country Girl

Cast
Role: Countryman Actor: Grimaldi

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: Roffey, Ryder, Grimaldi

Afterpiece Title: The Liar

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: Roffey, Ryder, Grimaldi

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: Roffey, Ryder, Grimaldi

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: Roffey, Ryder, Grimaldi

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: Roffey, Ryder, Grimaldi

Afterpiece Title: The Apprentice

Cast
Role: Spouters Actor: Evans, Grimaldi, Chippendale

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: _Roffey, Ryder, Grimaldi

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: Roffey, Ryder, Grimaldi

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: A Trip To Scarborough

Cast
Role: Countryman Actor: Grimaldi

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Apprentice

Cast
Role: Spouters Actor: Evans, Grimaldi, Chippendale

Song: As17991228

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Apprentice

Cast
Role: Spouters Actor: Evans, Grimaldi, Chippendale

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

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Deserter

Ballet: End: The Scotch Ghost. As17991202, but Saundy-_; Donald-_

Cast
Role: Glaude Actor: Grimaldi

Entertainment: In which a Trial of Skill, in the exercise of the Austrian and Highland Broadsword-Nine of the First Swordsmen in this Kingdom

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: Of Age To-morrow

Ballet: End: The Scotch Ghost. As17991202

Cast
Role: Glaude Actor: Grimaldi

Performances

Mainpiece Title: The Egyptian Festival

Cast
Role: unassigned Actor: _Grimaldi

Afterpiece Title: The Strangers at Home

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

Performances

Mainpiece Title: The Country Girl

Cast
Role: Countryman Actor: Grimaldi

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Shipwreck

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: She Wou'd And She Wou'd Not

Afterpiece Title: Robin Hood

Song: End: a new song (composed by Dr Arnold,)-Miss Leak; accompanied on the Tamborine-Miss Leak

Ballet: After Singing: The Scotch Ghost. As17991202

Cast
Role: Glaude Actor: Grimaldi

Performances

Mainpiece Title: Indiscretion

Afterpiece Title: Of Age To-morrow

Song: End IV: Crazy Jane-Mrs Bland

Ballet: End: The Scotch Ghost. As17991202

Cast
Role: Glaude Actor: Grimaldi

Performances

Mainpiece Title: A Trip To Scarborough

Cast
Role: Countryman Actor: Grimaldi

Afterpiece Title: Of Age To-morrow

Ballet: End: The Scotch Ghost. As18000612