SELECT * FROM london_stages WHERE eventid IN (39463, 39467, 41988, 42015, 42053, 42295, 42309, 42337, 42405, 42449, 42469, 42476, 42517, 42558, 42565, 42580, 42589, 42602, 42671, 42696, 42711, 42746, 42759, 42913, 42917, 42921, 42927, 42943, 42949, 42964, 42973, 42981, 42983, 42985, 43007, 43039, 43073, 43088, 43203, 43228, 43238, 43243, 43259, 43262, 43271, 43273, 43276, 43287, 43302, 43307, 43309, 43459, 43461, 43501, 43518, 43524, 43526, 43530, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43586, 43598, 43609, 43612, 43617, 43628, 43632, 43635, 43637, 43640, 43646, 43650, 43655, 43658, 43663, 43667, 43701, 43706, 43717, 43764, 43794, 43800, 43835, 43837, 43840, 43843, 43846, 43848, 43851, 43853, 43857, 43860, 43870, 43872, 43875, 43877, 43880, 43882, 43890, 44030, 44034, 44038, 44044, 44047, 44053, 44055, 44057, 44060, 44062, 44064, 44065, 44069, 44071, 44075, 44077, 44079, 44082, 44084, 44088, 44090, 44092, 44096, 44102, 44106, 44114, 44126, 44142, 44150, 44154, 44166, 44169, 44171, 44185, 44189, 44246, 44260, 44292, 44298, 44302, 44371, 44378, 44411, 44431, 44443, 44453, 44471, 44473, 44590, 44606, 44607, 44691, 44751, 44754, 44756, 44759, 44763, 44768, 44770, 44773, 44775, 44777, 44782, 44784, 44786, 44793, 44800, 44816, 44827, 44833, 44848, 44856, 44866, 44875, 44896, 44912, 44916, 44928, 44938, 44956, 44970, 44972, 44974, 44979, 44985, 44991, 44994, 45000, 45003, 45012, 45017, 45021, 45024, 45036, 45136, 45138, 45140, 45144, 45149, 45161, 45165, 45170, 45172, 45177, 45181, 45183, 45185, 45189, 45193, 45199, 45201, 45203, 45205, 45207, 45209, 45211, 45215, 45217, 45221, 45223, 45225, 45229, 45231, 45233, 45237, 45241, 45249, 45256, 45261, 45263, 45265, 45273, 45275, 45277, 45282, 45284, 45286, 45288, 45290, 45292, 45294, 45296, 45299, 45301, 45304, 45306, 45309, 45311, 45313, 45315, 45318, 45320, 45323, 45325, 45327, 45329, 45332, 45334, 45339, 45341, 45343, 45351, 45353, 45360, 45364, 45371, 45377, 45380, 45383, 45389, 45393, 45398, 45402, 45409, 45411, 45419, 45424, 45435, 45437, 45439, 45448, 45455, 45460, 45476, 45479, 45481, 45486, 45489, 45499, 45508, 45514, 45518, 45533, 45546, 45556, 45561, 45566, 45568, 45571, 45578, 45581, 45583, 45586, 45590, 45596, 45599, 45601, 45603, 45697, 45703, 45705, 45707, 45712, 45721, 45725, 45741, 45749, 45753, 45762, 45768, 45770, 45774, 45776, 45782, 45788, 45790, 45794, 45796, 45798, 45800, 45802, 45806, 45808, 45812, 45816, 45818, 45824, 45826, 45830, 45832, 45834, 45837, 45839, 45843, 45847, 45849, 45851, 45855, 45857, 45861, 45868, 45870, 45873, 45875, 45877, 45882, 45884, 45887, 45889, 45896, 45898, 45908, 45917, 45922, 45924, 45931, 45938, 45941, 45943, 45950, 45957, 45964, 45977, 45983, 45990, 45992, 46001, 46004, 46006, 46014, 46019, 46027, 46039, 46041, 46046, 46051, 46057, 46062, 46064, 46067, 46069, 46072, 46074, 46077, 46084, 46087, 46089, 46094, 46099, 46105, 46108, 46114, 46117, 46126, 46129, 46132, 46136, 46139, 46142, 46147, 46150, 46153, 46156, 46159, 46168, 46260, 46274, 46278, 46280, 46283, 46288, 46291, 46293, 46300, 46306, 46310, 46312, 46318, 46320, 46326, 46332, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46362, 46366, 46376, 46378, 46400, 46408, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46451, 46456, 46461, 46463, 46465, 46468, 46470, 46473, 46475, 46477, 46482, 46485, 46487, 46489, 46491, 46494, 46496, 46499, 46503, 46508, 46510, 46518, 46521, 46523, 46528, 46532, 46535, 46537, 46546, 46549, 46551, 46556, 46560, 46565, 46574, 46577, 46589, 46597, 46601, 46603, 46606, 46611, 46613, 46616, 46618, 46621, 46623, 46631, 46633, 46638, 46641, 46648, 46651, 46658, 46660, 46665, 46677, 46680, 46687, 46690, 46694, 46704, 46707, 46715, 46720, 46843, 46848, 46853, 46857, 46859, 46860, 46864, 46866, 46870, 46872, 46874, 46876, 46878, 46880, 46884, 46886, 46890, 46892, 46894, 46898, 46900, 46902, 46904, 46908, 46910, 46914, 46916, 46918, 46922, 46924, 46926, 46928, 46932, 46934, 46938, 46940, 46942, 46946, 46948, 46950, 46952, 46954, 46956, 46958, 46960, 46962, 46964, 46966, 46970, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46988, 46990, 46992, 46994, 46996, 47000, 47004, 47006, 47008, 47010, 47012, 47014, 47016, 47018, 47020, 47024, 47026, 47032, 47042, 47044, 47046, 47052, 47054, 47060, 47062, 47065, 47070, 47072, 47075, 47078, 47080, 47085, 47087, 47090, 47097, 47103, 47107, 47113, 47116, 47123, 47127, 47130, 47132, 47143, 47147, 47149, 47155, 47172, 47178, 47182, 47185, 47191, 47197, 47203, 47206, 47208, 47211, 47223, 47228, 47237, 47241, 47243, 47246, 47252, 47254, 47258, 47260, 47272, 47278, 47294, 47296, 47303, 47448, 47453, 47457, 47463, 47468, 47476, 47488, 47492, 47498, 47500, 47504, 47506, 47508, 47516, 47526, 47528, 47532, 47534, 47538, 47540, 47542, 47544, 47546, 47548, 47550, 47554, 47556, 47560, 47565, 47567, 47569, 47574, 47576, 47579, 47583, 47585, 47588, 47592, 47602, 47610, 47615, 47624, 47627, 47634, 47636, 47638, 47642, 47648, 47650, 47654, 47658, 47662, 47673, 47682, 47684, 47699, 47728, 47738, 47748, 47751, 47758, 47763, 47766, 47768, 47773, 47778, 47781, 47783, 47786, 47788, 47791, 47793, 47799, 47802, 47804, 47807, 47809, 47814, 47822, 47824, 47829, 47839, 47847, 47864, 47866, 47868, 47871, 47876, 47884, 47889, 47893, 47895, 47899, 47901, 47905, 47907, 47913, 47998, 48001, 48003, 48007, 48011, 48013, 48018, 48021, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48044, 48046, 48048, 48050, 48054, 48058, 48060, 48065, 48067, 48073, 48075, 48077, 48079, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48120, 48122, 48124, 48126, 48128, 48130, 48132, 48136, 48138, 48141, 48143, 48145, 48147, 48149, 48151, 48153, 48155, 48157, 48159, 48161, 48165, 48169, 48171, 48173, 48175, 48177, 48179, 48181, 48185, 48203, 48208, 48210, 48213, 48215, 48217, 48219, 48222, 48224, 48235, 48237, 48251, 48256, 48263, 48265, 48274, 48277, 48279, 48288, 48291, 48298, 48310, 48312, 48314, 48319, 48326, 48328, 48333, 48338, 48340, 48343, 48346, 48351, 48353, 48365, 48367, 48371, 48376, 48381, 48390, 48397, 48401, 48415, 48422, 48429, 48431, 48448, 48449, 48453, 48457, 48459, 48461, 48467, 48469, 48470, 48471, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48482, 48483, 48484, 48487, 48488, 48489, 48492, 48494, 48495, 48496, 48497, 48512, 48515, 48519, 48526, 48528, 48530, 48532, 48533, 48713, 48733, 48753, 48763, 48765, 48773) 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: Twelfth Night

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Dance: As17851103

Performances

Mainpiece Title: The Maid Of The Mill

Dance: In afterpiece, as17851018

Performances

Mainpiece Title: Hamlet

Dance: In afterpiece, as17851018

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Song: As17851029

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Romp

Dance: As17851017

Performances

Mainpiece Title: Philaster

Cast
Role: Woodmen Actor: Alfred, Jones

Afterpiece Title: The Romp

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Dance: As17851103

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Dance: As17851103

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: he Humourist

Cast
Role: Blunt Actor: Alfred

Performances

Mainpiece Title: Zara

Afterpiece Title: Hurly-Burly; or, The Fairy of the Well

Dance: In afterpiece, by Hamoir, Williamson, Miss Stageldoir, Mrs Sutton, &c. [The dance was included, as here assigned, in all subsequent performances.]

Performances

Mainpiece Title: The Natural Son

Performances

Mainpiece Title: A New Way To Pay Old Debts

Afterpiece Title: Arthur and Emmeline

Dance: End of Act II of mainpiece a new Scotch Dance, The Lucky Return, by Williamson, Mrs Sutton, Miss J. Stageldoir, and others

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Performances

Mainpiece Title: The Distress'd Mother

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Virgin Unmask'd

Dance: As17851017

Performances

Mainpiece Title: The Captives

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Song: In Act II of mainpiece an Ode (composed by Dr Cooke). Vocal Parts by Dignum, Danby, Wilson, Phillimore, Alfred, Newbold; Mrs Love, Mrs Booth, Miss Burnett, Miss J. Stageldoir, Mrs Forster

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Song: As17860302athi

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Dance: End of Singing The Provencalle, as17850922

Song: End of mainpiece Stand to your Guns, my Hearts of Oak by Bannister

Performances

Mainpiece Title: The Provok'd Wife

Cast
Role: Porter Actor: Alfred

Afterpiece Title: The Virgin Unmask'd

Dance: End of Act IV of mainpiece The Lucky Return, as17860420

Performances

Mainpiece Title: The Lord Of The Manor

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Alfred

Dance: As17860522

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Arthur and Emmeline