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 Constant Couple

Cast
Role: Constable Actor: Alfred

Afterpiece Title: The Sultan

Dance: As17881119

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred

Performances

Mainpiece Title: The Confederacy

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

Performances

Mainpiece Title: The Regent

Cast
Role: Banditti Actor: Phillimore, Chaplin, Alfred

Afterpiece Title: The Deserter

Cast
Role: Soldiers Actor: Chaplin, Wilson, Alfred

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Constable Actor: Alfred

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Deserter

Cast
Role: Soldiers Actor: Chaplin, Wilson, Alfred

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Pannel

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

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: Miss in her Teens

Performances

Mainpiece Title: The Strangers At Home

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred

Song: In afterpiece: a new Hunting Glee ['Tis health that gives birth] (1st time; composed by Callcott)-Kelly, Dignum, Sedgwick

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Minor

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Rosina

Cast
Role: Irishmen Actor: Phillimore, Alfred

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred

Performances

Mainpiece Title: King Henry The Eighth

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 Blade-Bone; or, Harlequin's Frolic

Cast
Role: Leaden Mercury Actor: Alfred

Afterpiece Title: The Virgin Unmask'd

Entertainment: Monologue Preceding: British Loyalty[; or, A Squeeze for St. Paul's by George Colman ynger]-Bannister Jun

Performances

Mainpiece Title: False Appearances

Afterpiece Title: The Farm House

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Farm House

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Constable Actor: Alfred

Afterpiece Title: The Devil to Pay

Cast
Role: Coachman Actor: Alfred

Performances

Mainpiece Title: Love For Love

Afterpiece Title: (End of Act II) Jewish Education

Afterpiece Title: A Lesson for Lawyers

Afterpiece Title: Rosina

Cast
Role: Irishmen Actor: Phillimore, Alfred

Entertainment: Monologue. As17890430

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Farm House

Performances

Mainpiece Title: Mary Queen Of Scots

Cast
Role: Nawe Actor: Alfred

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Romeo And Juliet

Song: As17881117, but Vocal Parts-Miss Hagley, Miss _Collett

Entertainment: Monologue. End afterpiece: An Ode on the Recovery of His Majesty-Mrs Siddons; in the Character of Britannia. Conclude with: God save the King!-