SELECT * FROM london_stages WHERE eventid IN (147, 343, 749, 3213, 3563, 3565, 3601, 3728, 3755, 3837, 3899, 4040, 4112, 4216, 4241, 4254, 4280, 4358, 4429, 4442, 4539, 4577, 4593, 4616, 4631, 4641, 4642, 4710, 4912, 4921, 5170, 5196, 5247, 5620, 5744, 5794, 5819, 5836, 5921, 6013, 6150, 6216, 6398, 6465, 6522, 6523, 6579, 6693, 6741, 6843, 6866, 6894, 6948, 7015, 7211, 7439, 7584, 7694, 7742, 7748, 7865, 7893, 7936, 8015, 8066, 8099, 8135, 8158, 8166, 8205, 8263, 8335, 8372, 8392, 8484, 8505, 8625, 8659, 8763, 8851, 8943, 8972, 9007, 9101, 9106, 9263, 9371, 9400, 9521, 9636, 9751, 9754, 9889, 9952, 10034, 10279, 10281, 10392, 10496, 10545, 10620, 10720, 10807, 10884, 10930, 11018, 11020, 11044, 11050, 11171, 11172, 11235, 11242, 11252, 11318, 11436, 11513, 11534, 11658, 11689, 11711, 11748, 11767, 11814, 11852, 11946, 12084, 12129, 12143, 12208, 12229, 12319, 12370, 12458, 12623, 12696, 12698, 12843, 12930, 13083, 13087, 13119, 13128, 13202, 13329, 13347, 13382, 13421, 13515, 13553, 13576, 13577, 13592, 13663, 13702, 13719, 13817, 13860, 13897, 14003, 14150, 14173, 14249, 14339, 14444, 14677, 14718, 14726, 14756, 14812, 14841, 14907, 14933, 15035, 15044, 15085, 15127, 15163, 15300, 15371, 15448, 15561, 15651, 15749, 15760, 15796, 15800, 15887, 15889, 15954, 15968, 16034, 16211, 16215, 16272, 16403, 16458, 16569, 16571, 16627, 16658, 16809, 16833, 17045, 17075, 17221, 17288, 17410, 17422, 17456, 17498, 17586, 17587, 17703, 17770, 17874, 17895, 17983, 18049, 18169, 18228, 18260, 18364, 18424, 18449, 18467, 18724, 18753, 18816, 18874, 18887, 18891, 18893, 18895, 18948, 18985, 18996, 19013, 19123, 19156, 19197, 19224, 19261, 19272, 19303, 19326, 19360, 19409, 19434, 19468, 19550, 19605, 19641, 19756, 19770, 19795, 19810, 19871, 20043, 20065, 20099, 20127, 20181, 20185, 20270, 20294, 20465, 20507, 20558, 20593, 20662, 20665, 20722, 20762, 20775, 20852, 20910, 20967, 21012, 21041, 21107, 21165, 21181, 21205, 21266, 21311, 21419, 21427, 21432, 21436, 21442, 21448, 21457, 21465, 21484, 21526, 21540, 21559, 21581, 21614, 21677, 21817, 21854, 21899, 21916, 21961, 21962, 21978, 22075, 22121, 22153, 22164, 22169, 22290, 22291, 22292, 22348, 22383, 22416, 22419, 22450, 22461, 22463, 22481, 22517, 22577, 22719, 22790, 22829, 22842, 22860, 22949, 22953, 22957, 23016, 23036, 23102, 23137, 23153, 23162, 23221, 23288, 23292, 23318, 23350, 23379, 23423, 23454, 23486, 23491, 23613, 23634, 23695, 23737, 23761, 23796, 23804, 23836, 23854, 23896, 23902, 23915, 23962, 23984, 24049, 24104, 24118, 24194, 24269, 24317, 24325, 24349, 24471, 24517, 24567, 24685, 24874, 24881, 24923, 24946, 24968, 25025, 25031, 25057, 25139, 25197, 25259, 25335, 25386, 25416, 25447, 25468, 25663, 25667, 25670, 25710, 25734, 25765, 25780, 25821, 25845, 25915, 25922, 26013, 26085, 26095, 26116, 26197, 26217, 26263, 26285, 26335, 26366, 26412, 26549, 26589, 26687, 26712, 26718, 26753, 26862, 26956, 27035, 27101, 27180, 27200, 27215, 27231, 27295, 27516, 27532, 27580, 27674, 27701, 27736, 27772, 27920, 27966, 28025, 28041, 28102, 28108, 28111, 28142, 28193, 28204, 28216, 28263, 28390, 28450, 28521, 28525, 28553, 28628, 28645, 28680, 28742, 28840, 28911, 28962, 28983, 29015, 29063, 29070, 29163, 29206, 29328, 29422, 29499, 29528, 29587, 29729, 29772, 29774, 29790, 29828, 29903, 29956, 29971, 30034, 30084, 30123, 30125, 30294, 30333, 30353, 30379, 30385, 30404, 30549, 30599, 30632, 30674, 30701, 30793, 30836, 30837, 30840, 30922, 30980, 31028, 31231, 31240, 31254, 31268, 31338, 31352, 31407, 31453, 31667, 31718, 31736, 31759, 31827, 31873, 31895, 32005, 32048, 32060, 32078, 32165, 32243, 32316, 32323, 32383, 32391, 32407, 32447, 32510, 32575, 32737, 32808, 32873, 32877, 32981, 33161, 33190, 33260, 33318, 33334, 33490, 33715, 33794, 33815, 33828, 33882, 33995, 34008, 34100, 34158, 34203, 34261, 34266, 34336, 34387, 34446, 34537, 34600, 34628, 34651, 34708, 34751, 34810, 34860, 34876, 34889, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35004, 35005, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35084, 35088, 35092, 35094, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35135, 35139, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35264, 35277, 35289, 35305, 35308, 35355, 35359, 35365, 35372, 35382, 35508, 35590, 35625, 35923, 35984, 35994, 36112, 36176, 36260, 36287, 36341, 36471, 36681, 36782, 36787, 36793, 36812, 36867, 36886, 37092, 37248, 37311, 37462, 37629, 37635, 37793, 37895, 37914, 37957, 38051, 38349, 38425, 38443, 38484, 38716, 38785, 38898, 38904, 38976, 39032, 39093, 39104, 39285, 39370, 39371, 39379, 39381, 39386, 39393, 39406, 39433, 39440, 39453, 39457, 39480, 39497, 39564, 39605, 39759, 39812, 40019, 40038, 40043, 40150, 40204, 40253, 40396, 40563, 40605, 40644, 40930, 40938, 41088, 41114, 41157, 41162, 41260, 41290, 41445, 41652, 41661, 41664, 41696, 41748, 41861, 41897, 41934, 42284, 42338, 42349, 42415, 42419, 42429, 42531, 42622, 42734, 42754, 42762, 42780, 42788, 42867, 42869, 42871, 42872, 42873, 42883, 42899, 42905, 42908, 42935, 42951, 43011, 43030, 43056, 43154, 43432, 43439, 43440, 43487, 43556, 43569, 43614, 43689, 43783, 43824, 43920, 43923, 43936, 43963, 44031, 44102, 44104, 44112, 44116, 44128, 44132, 44136, 44148, 44152, 44156, 44158, 44160, 44162, 44171, 44426, 44505, 44590, 44642, 44747, 44990, 44996, 45010, 45136, 45181, 45241, 45290, 45558, 45586, 45707, 45778, 45786, 45814, 45839, 45863, 45891, 45983, 46010, 46102, 46138, 46165, 46347, 46537, 46716, 46725, 46864, 46906, 46941, 46952, 46953, 47036, 47056, 47116, 47252, 47470, 47473, 47483, 47494, 47520, 47571, 47590, 47644, 47728, 48055, 48142, 48284, 48563, 48575, 48583, 48603, 48613, 48647, 48712, 48732, 48737, 48789, 48826, 48872, 49018, 49056, 49199, 49214, 49309, 49343, 49371, 49377, 49400, 49729, 49791, 49801, 49813, 49834, 49924, 49929, 50005, 50135, 50141, 50162, 50192, 50204, 50291, 50324, 50354, 50373, 50384, 50395, 50419, 50425, 50446, 50467, 50721, 50743, 50746, 50748, 50768, 50781, 50789, 50796, 50919, 50928, 50931, 50939, 50947, 50980, 50982, 51006, 51111, 51123, 51151, 51165, 51174, 51190, 51222, 51279, 51290, 51304, 51321, 51468, 51481, 51488, 51497, 51510, 51715, 51727, 51827, 52061, 52080, 52103, 52115, 52127, 52233) 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: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Wroughton

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Johnston

Afterpiece Title: Hooly and Fairly; or, The Highland Lad and Lowland Lass

Afterpiece Title: A Divertisement

Dance: 2nd piece to conclude with: Highland Reel-; In 3rd piece: Ballet, as17971013

Song: In V 1st piece: a Dirge, as17970925; In 2nd piece: Highland Laddy-; Hooly and Fairly-; Katharine Ogie- [recte Oggy]; Andrew and his Cutty Gun-; Todlen Hame-; Tulloch Goram-; The Little Farthing Rushlight-Graham

Performances

Mainpiece Title: Hooly And Fairly

Cast
Role: Hamlet Actor: Johnston

Afterpiece Title: The Beaux Stratagem

Afterpiece Title: Oscar and Malvina

Dance: 1st piece to conclude with: a Highland Reel, as17980428

Song: In 1st piece: Highland Laddy-; Hooly and Fairly-; Katharine Ogie-; Andrew and his Cutty Gun-; Todlen Hame-; Tulloch Goram-; End II 2nd piece: Old Towler-Incledon; End 2nd piece: Admiral Benbow-Incledon

Music: In 3rd piece: The Union Pipes-Murphy

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Wroughton

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Purse

Afterpiece Title: Hamlet; Prince of Denmark

Cast
Role: Hamlet Actor: Johnston

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Holman

Afterpiece Title: Botheration; or, A Ten Years Blunder

Song: In V: a Dirge, set to music by Shield. Vocal Parts-Mrs Martyr, Mrs Iliff, Miss Sims, Mrs Whitmore, Mrs Watts, Mrs Follett, Miss Leserve, Mrs Castelle, Mrs Norton, Mrs Gilbert, Mrs Masters, Mrs Lloyd, Mrs Blurton, Miss Walcup, Miss Gray, Miss Burnett, Miss Wheatley, Linton, Street, Gray, Lee, Platt, Dyke, Curties; Incidental to afterpiece: Mr O'Blarney's Description of London (Including his Remarks on St. James's, The Monument, St. Paul's, Wigs and Crops, Debating Clubs, Boarding Schools, Squares, Inns, Gardens, Fields, Soldiers, Sailors, and Volunteers)-Johnstone

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Holman

Afterpiece Title: The Miser

Song: In V: a Dirge, as17980917

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: The Outlaws

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: The Embarkation

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Hamlet

Cast
Role: Hamlet Actor: Kemble
Role: Ghost of Hamlet's Father Actor: Barrymore

Afterpiece Title: Lodoiska