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: The Country Girl

Cast
Role: William Actor: Alfred

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The West Indian

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Deserter

Cast
Role: Soldiers Actor: Chaplin, Wilson, Alfred

Performances

Mainpiece Title: The Beggar's Opera

Dance: In III: Hornpipe-Keen. [This was danced, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: King Richard Iii

Performances

Mainpiece Title: All In The Wrong

Cast
Role: Servant Actor: Alfred

Afterpiece Title: Comus

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Constable Actor: Alfred

Afterpiece Title: The Pannel

Cast
Role: Alguaziles Actor: Wilson, Jones, Alfred, Cox

Performances

Mainpiece Title: The Beggar's Opera

Performances

Mainpiece Title: The Country Girl

Cast
Role: William Actor: Alfred

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The West Indian

Performances

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

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Pannel

Cast
Role: Alguaziles Actor: Wilson, Jones, Alfred, Cox

Performances

Mainpiece Title: The Impostors

Performances

Mainpiece Title: All In The Wrong

Cast
Role: Servant Actor: Alfred

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: The Impostors

Afterpiece Title: The Pannel

Cast
Role: Alguaziles Actor: Wilson, Jones, Alfred, Cox

Performances

Mainpiece Title: The Impostors

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred

Performances

Mainpiece Title: Coriolanus

Afterpiece Title: The Deserter

Cast
Role: Soldiers Actor: Chaplin, Wilson, Alfred

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Constable Actor: Alfred

Afterpiece Title: The Pannel

Cast
Role: Alguaziles Actor: Wilson, Jones, Alfred, Cox

Performances

Mainpiece Title: All In The Wrong

Cast
Role: Servant Actor: Alfred

Afterpiece Title: Arthur and Emmeline

Performances

Mainpiece Title: The Maid Of The Mill

Dance: End I: As17890107

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Tom Actor: Alfred

Afterpiece Title: The First Floor

Cast
Role: Postboy Actor: Alfred

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Pannel

Cast
Role: Alguaziles Actor: Wilson, Jones, Alfred, Cox

Performances

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

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred