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, 45691, 45697, 45703, 45705, 45707, 45712, 45721, 45725, 45741, 45747, 45749, 45753, 45757, 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, 45845, 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, 48466, 48467, 48469, 48470, 48471, 48472, 48473, 48474, 48475, 48476, 48477, 48478, 48480, 48482, 48483, 48484, 48486, 48487, 48488, 48489, 48492, 48493, 48494, 48495, 48496, 48497, 48506, 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: At Kings The Pirates

Cast
Role: Sailor Actor: Alfred

Afterpiece Title: The Mariners

Dance: As17930408

Song: End II: a New Song composed by Percy-Master Welsh

Performances

Mainpiece Title: At Kings All In The Wrong

Cast
Role: Servants Actor: Alfred, Lyons

Afterpiece Title: The Citizen

Entertainment: In the course of the Evening: [at end of mainpiece (Thespian Magazine, July 1793, p. 50)] Fencing-La Chevaliere D'Eon, Mrs Bateman, an English Officer

Performances

Mainpiece Title: At Kings The Pirates

Cast
Role: Sailor Actor: Alfred

Afterpiece Title: The Humourist

Dance: As17930408

Performances

Mainpiece Title: At Hay The School For Scandal

Afterpiece Title: The Apprentice

Cast
Role: Watchman Actor: Alfred

Dance: End: Minuet de la Cour and Gavot-Master and Miss D'Egville

Song: As17921030

Performances

Mainpiece Title: The Battle Of Hexham Or Days Of Old

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Deaf Lover

Cast
Role: William Actor: Alfred

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Ledger, Alfred

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Surrender of Calais

Cast
Role: Crier Actor: Alfred

Song: In 2nd piece: Singing-Cooke, Kenrick, Willoughby, Linton, Dorion, Aylmer, Little, Brown, Lyons, Miss DeCamp, Miss Dall, Miss Fontenelle, Mrs Powell, Mrs Masters, Mrs Bramwell, Mrs Hatton

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Ledger, Alfred

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: A Mogul Tale or The Descent of the Balloon

Performances

Mainpiece Title: The Pad

Cast
Role: Gentlemen Actor: _Bland, Alfred.

Afterpiece Title: The Surrender of Calais

Cast
Role: Crier Actor: Alfred

Song: As17930617

Performances

Mainpiece Title: The Surrender Of Calais

Cast
Role: Gentlemen Actor: _Bland, Alfred.

Afterpiece Title: The Son in Law

Song: In: As17930617

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The London Hermit or Rambles in Dorsetshire

Cast
Role: John Grum Actor: Alfred

Afterpiece Title: The Deaf Lover

Cast
Role: William Actor: Alfred

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Pad

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: The Son in Law

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Afterpiece Title: Katharine and Petruchio

Cast
Role: Cook Actor: Alfred

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred
Role: William Actor: Alfred

Afterpiece Title: The Son in Law

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Performances

Mainpiece Title: The Surrender Of Calais

Cast
Role: Gentlemen Actor: _Bland, Alfred.

Afterpiece Title: A Mogul Tale

Song: As17930628

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: The Flitch of Bacon

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Afterpiece Title: The Son in Law

Cast
Role: John Grum Actor: Alfred
Role: William Actor: Alfred

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred
Role: William Actor: Alfred

Afterpiece Title: The Citizen

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: The London Hermit

Cast
Role: John Grum Actor: Usher in place of Alfred
Role: William Actor: Alfred

Afterpiece Title: The Flitch of Bacon

Cast
Role: John Grum Actor: Usher in place of Alfred.
Role: William Actor: Alfred

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: A Mogul Tale