SELECT * FROM london_stages WHERE eventid IN (1288, 1430, 1531, 1772, 2194, 2285, 2290, 3518, 3832, 4171, 4183, 4553, 4595, 4607, 4830, 4846, 5671, 5950, 6562, 6612, 7168, 7350, 7424, 7448, 7875, 7916, 8077, 8525, 8557, 9648, 9976, 10048, 10236, 10282, 10325, 10334, 10398, 10456, 10578, 10604, 10795, 10859, 10891, 11272, 11296, 11417, 11449, 11508, 11604, 11626, 11631, 11663, 11755, 11848, 12122, 12239, 12314, 12652, 12736, 12836, 12861, 12862, 12904, 12940, 12961, 12966, 13018, 13051, 13105, 13328, 13453, 13459, 13497, 13525, 13532, 13537, 13538, 13539, 13543, 13545, 13547, 13549, 13552, 13563, 13569, 13573, 13575, 13645, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13712, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13836, 13837, 13841, 13845, 13850, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14113, 14123, 14135, 14161, 14174, 14181, 14187, 14215, 14219, 14222, 14228, 14229, 14236, 14238, 14242, 14247, 14248, 14250, 14256, 14259, 14264, 14266, 14269, 14350, 14359, 14399, 14403, 14583, 14640, 14644, 14663, 14813, 14835, 14846, 14866, 14878, 14920, 14929, 15045, 15047, 15071, 15090, 15367, 15389, 15537, 15729, 15730, 15754, 15785, 15790, 15870, 15905, 15932, 15959, 16094, 16098, 16374, 16428, 16468, 16521, 16578, 16599, 16625, 16849, 16986, 17129, 17142, 17166, 17229, 17237, 17302, 17408, 17424, 17533, 18286, 18289, 18329, 18332, 18336, 18339, 18342, 18346, 18349, 18353, 18356, 18358, 18362, 18366, 18369, 18373, 18386, 18414, 18471, 18475, 18479, 18482, 18488, 18492, 18493, 18495, 18503, 18515, 18519, 18526, 18530, 18538, 18541, 18551, 18559, 18602, 18614, 18625, 18635, 18646, 18657, 18682, 18687, 18723, 18765, 18794, 18807, 18816, 18839, 18872, 18975, 18989, 18993, 18996, 19003, 19022, 19036, 19047, 19051, 19053, 19056, 19058, 19068, 19078, 19082, 19084, 19094, 19101, 19106, 19122, 19165, 19203, 19227, 19266, 19313, 19341, 19345, 19368, 19375, 19406, 19408, 19415, 19418, 19423, 19425, 19444, 19459, 19502, 19506, 19518, 19521, 19543, 19545, 19547, 19549, 19568, 19584, 19668, 19757, 19764, 19958, 20040, 20157, 20278, 20376, 20413, 20429, 20433, 20506, 20583, 20751, 20989, 21117, 21250, 21385, 21487, 21553, 21579, 21586, 21592, 21626, 21631, 21691, 21848, 21956, 22269, 22329, 22535, 22907, 22910, 22960, 22963, 22972, 23053, 23295, 23316, 23384, 23391, 23394, 23403, 23424, 23489, 23496, 23499, 23502, 23513, 23515, 23564, 23593, 23597, 23600, 23603, 23669, 23715, 23772, 23952, 23954, 23956, 23958, 23965, 23977, 23980, 23982, 23983, 23985, 24000, 24011, 24041, 24076, 24082, 24119, 24133, 24197, 24208, 24215, 24239, 24267, 24294, 24328, 24352, 24363, 24422, 24445, 24499, 24531, 24577, 24633, 24660, 24722, 24754, 24915, 24917, 24920, 24921, 24942, 24945, 24966, 24994, 25013, 25058, 25077, 25085, 25120, 25128, 25205, 25213, 25270, 25305, 25368, 25397, 25413, 25417, 25419, 25421, 25423, 25519, 25569, 25590, 25619, 25647, 25665, 25700, 25708, 25761, 25822, 25843, 25874, 25952, 25984, 26049, 26050, 26104, 26158, 26181, 26183, 26214, 26257, 26272, 26295, 26298, 26342, 26387, 26401, 26427, 26524, 26537, 26600, 26644, 26683, 26744, 26790, 26831, 26937, 26960, 26988, 27032, 27111, 27185, 27270, 27370, 27433, 27544, 27549, 27597, 27626, 27686, 27725, 27771, 27776, 27837, 28042, 28077, 28082, 28149, 28208, 28230, 28304, 28346, 28502, 28639, 28695, 28720, 28722, 28734, 28741, 28787, 28821, 28994, 29060, 29156, 29170, 29192, 29263, 29335, 29530, 29581, 29831, 29900, 29963, 30060, 30098, 30138, 30306, 30370, 30398, 30449, 30576, 30792, 30981, 31191, 31223, 31232, 31336, 31337, 31346, 31832, 31897, 31909, 32046, 32322, 32344, 32358, 32414, 32475, 32568, 32676, 32720, 32743, 32860, 32907, 32974, 33189, 33376, 33418, 33589, 33631, 33658, 33725, 33837, 33972, 34222, 34252, 34317, 34367, 34422, 34457, 34520, 34562, 34565, 34567, 34570, 34572, 34574, 34579, 34581, 34596, 34598, 34612, 34622, 34654, 34791, 34809, 34937, 35022, 35067, 35085, 35179, 35591, 35605, 35704, 35884, 36206, 36227, 36393, 36422, 36430, 36478, 36522, 36675, 36740, 36769, 36798, 36828, 36848, 36868, 36900, 36904, 37053, 37067, 37107, 37108, 37251, 37422, 37534, 37578, 37613, 37624, 37638, 37790, 37815, 37824, 37846, 37888, 37916, 37917, 37992, 37997, 38012, 38106, 38123, 38124, 38134, 38178, 38191, 38207, 38208, 38217, 38224, 38228, 38310, 38315, 38334, 38341, 38362, 38464, 38478, 38479, 38555, 38645, 38669, 38682, 38737, 38743, 38744, 38771, 38790, 38856, 38987, 39023, 39111, 39242, 39266, 39366, 39398, 39400, 39403, 39405, 39413, 39419, 39439, 39472, 39476, 39502, 39511, 39532, 39572, 39607, 39651, 39769, 40021, 40022, 40066, 40172, 40225, 40256, 40258, 40264, 40266, 40269, 40271, 40278, 40281, 40284, 40363, 40378, 40386, 40393, 40397, 40418, 40424, 40428, 40436, 40441, 40445, 40598, 40605, 40607, 40609, 40610, 40612, 40614, 40617, 40618, 40621, 40623, 40625, 40627, 40631, 40641, 40643, 40645, 40648, 40649, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40699, 40701, 40703, 40722, 40725, 40742, 40749, 40757, 40766, 40771, 40778, 40788, 40800, 40803, 40808, 40824, 40830, 40838, 40844, 40865, 40872, 40885, 40897, 40904, 40905, 40909, 40919, 40920, 40926, 40930, 40950, 40951, 40956, 40960, 40971, 40977, 40984, 40985, 40993, 41003, 41129, 41130, 41134, 41135, 41149, 41159, 41180, 41198, 41210, 41216, 41249, 41254, 41258, 41270, 41284, 41285, 41297, 41305, 41312, 41334, 41341, 41347, 41420, 41474, 41476, 41480, 41485, 41490, 41491, 41494, 41496, 41500, 41503, 41505, 41508, 41510, 41513, 41518, 41519, 41527, 41529, 41532, 41534, 41542, 41544, 41547, 41559, 41561, 41562, 41564, 41569, 41712, 41731, 41734, 41823, 41862, 41923, 42013, 42039, 42101, 42113, 42126, 42147, 42148, 42153, 42392, 42398, 42458, 42464, 42467, 42493, 42745, 42891, 42892, 42915, 42938, 43035, 43043, 43299, 43310, 43449, 43484, 43657, 43698, 43728, 43735, 43755, 43778, 43833, 43904, 44028, 44033, 44040, 44045, 44061, 44073, 44085, 44119, 44144, 44283, 44408, 44458, 44533, 44594, 44604, 44656, 44702, 45001, 45089, 45194, 45282, 45291, 45295, 45471, 45491, 45501, 45510, 45715, 45717, 45719, 45770, 45788, 45796, 45800, 45808, 45820, 45828, 45832, 45841, 45853, 45865, 45869, 45893, 45910, 45936, 46062, 46079, 46097, 46280, 46283, 46291, 46300, 46310, 46320, 46321, 46332, 46346, 46358, 46414, 46421, 46438, 46474, 46490, 46522, 46607, 46642, 46647, 46726, 46737, 46743, 46761, 46836, 46848, 46874, 46902, 46914, 46926, 46938, 46950, 46962, 46969, 46985, 47060, 47103, 47123, 47155, 47172, 47263, 47312, 47334, 47349, 47371, 47376, 47380, 47383, 47386, 47387, 47388, 47437, 47453, 47500, 47531, 47548, 47587, 47783, 47894, 47956, 48006, 48053, 48055, 48057, 48061, 48062, 48066, 48070, 48072, 48074, 48078, 48082, 48084, 48093, 48095, 48097, 48099, 48111, 48113, 48115, 48117, 48119, 48123, 48176, 48202, 48204, 48216, 48303, 48306, 48308, 48311, 48322, 48325, 48329, 48331, 48336, 48344, 48347, 48356, 48358, 48361, 48363, 48366, 48372, 48375, 48377, 48380, 48382, 48404, 48409, 48411, 48430, 48437, 48444, 48535, 48539, 48585, 48588, 48613, 48618, 48620, 48621, 48628, 48654, 48677, 48689, 48708, 48734, 48744, 48757, 48840, 48858, 48884, 48942, 49038, 49041, 49046, 49051, 49058, 49069, 49097, 49184, 49194, 49201, 49205, 49232, 49313, 49327, 49384, 49427, 49449, 49452, 49454, 49458, 49462, 49465, 49556, 49609, 49637, 49772, 49779, 49809, 49844, 49861, 49877, 49886, 49891, 49938, 49952, 50073, 50077, 50101, 50105, 50107, 50111, 50115, 50117, 50120, 50122, 50130, 50151, 50156, 50170, 50181, 50186, 50203, 50254, 50265, 50275, 50283, 50290, 50296, 50297, 50303, 50310, 50312, 50313, 50316, 50322, 50338, 50370, 50412, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50456, 50463, 50468, 50472, 50480, 50484, 50501, 50572, 50601, 50627, 50631, 50634, 50639, 50643, 50649, 50655, 50661, 50687, 50692, 50706, 50724, 50730, 50735, 50741, 50751, 50761, 50773, 50783, 50785, 50794, 50799, 50811, 50881, 50897, 50898, 50901, 50905, 50908, 50909, 50910, 50912, 50917, 50963, 50979, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 51004, 51060, 51073, 51080, 51145, 51152, 51154, 51172, 51243, 51246, 51287, 51292, 51300, 51316, 51317, 51323, 51330, 51342, 51357, 51364, 51367, 51369, 51371, 51372, 51373, 51376, 51377, 51380, 51444, 51597, 51611, 51827, 51870, 51882, 51918, 51924, 52062, 52164, 52208, 52225, 52347, 52423, 52463, 52468) 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 Second Part Of King Henry The Fourth

Cast
Role: Gloucester Actor: Oats

Performances

Mainpiece Title: Jane Shore

Cast
Role: Gloucester Actor: Cibber

Dance: As17260924

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Song: IV: De mi Cara-Mrs Warren

Dance: I: Two Pierrots-Nivelon, Poitier; II: Dutch Skipper-Pelling, Mrs Ogden; III: French Sailor-Salle, Mlle Salle; V: Two Punches and Harlequin-DuPre, Newhouse, Pelling

Performances

Mainpiece Title: The True And Ancient History Of King Lear And His Three Daughters

Cast
Role: Gloucester Actor: Quin

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: With The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Song: Miss Fenton

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Dance: End I: Fingalian-; II: French Peasants and their Lasses-; III: A new Ball Dance-Glover, Mrs Laguerre; V: Grand Dance of Moors-; Kettle Drums-Poitier

Performances

Mainpiece Title: The True And Ancient History Of King Lear And His Three Daughters

Cast
Role: Gloucester Actor: Quin

Performances

Mainpiece Title: The Pilgrim

Cast
Role: Mad Gamester Actor: Pelling

Afterpiece Title: Italian Jealousy; or, French Gallantry; With the Tavern Bilkers

Dance: HHighlander and Mistress-Salle, Mrs Legare; French Sailor-Salle, Mrs Legare

Performances

Mainpiece Title: The Pilgrim; With The Humours Of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Dance: SScots Dance-Mrs Bullock; A new Comic Dance-Fisher Tench, Young Filch; Fingalian-Newhouse, Mrs Ogden; French Peasant-Moreau, Mrs Bullock

Performances

Mainpiece Title: The True And Antient History Of King Lear And His Three Daughters

Cast
Role: Glocester Actor: Quin

Performances

Mainpiece Title: King Henry The Ivth; With The Humours Of Sir John Falstaff

Cast
Role: Worcester Actor: Hulett

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: Jane Shore

Cast
Role: Glocester Actor: Cibber

Afterpiece Title: The Contrivances

Performances

Mainpiece Title: Jane Shore

Cast
Role: Gloucester Actor: W. Giffard

Dance:

Performances

Mainpiece Title: The Gamester

Cast
Role: Gamester Actor: Giffard

Dance: Mrs Haughton, others

Performances

Mainpiece Title: The Gamester

Cast
Role: Gamester Actor: Giffard

Dance: As17291125

Performances

Mainpiece Title: King Henry The Ivth, Part I

Cast
Role: Worcester Actor: Hulett

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: Jane Shore

Cast
Role: Gloucester Actor: W. Giffard

Dance: MMoorish Dance, as17291215; Pierrots-Burney Jr, Eaton

Performances

Mainpiece Title: King Lear And His Three Daughters

Cast
Role: Glocester Actor: Quin

Afterpiece Title: The Dutch and Scotch Contention

Performances

Mainpiece Title: The Gamester

Cast
Role: Gamester Actor: Giffard

Afterpiece Title: Jealousy Deceived

Performances

Mainpiece Title: Jane Shore

Cast
Role: Glocester Actor: Cibber

Afterpiece Title: The Lovers Opera

Dance: Mrs Booth, Roger, Lally, Essex, Thurmond; particularly Lads and Lasses, The Pieraite-

Performances

Mainpiece Title: The True And Antient History Of King Lear And His Three Daughters

Cast
Role: Gloucester Actor: W. Giffard

Dance: TThe White Joke-Eaton

Performances

Mainpiece Title: King Lear And His Three Daughters

Cast
Role: Glocester Actor: Quin

Song: As17300527

Dance: SScottish Dance-Mrs Bullock; Chacone-Delagarde, Miss Wherrit; Numidian-Glover, Miss LaTour

Performances

Mainpiece Title: The True And Antient History Of King Lear And His Three Daughters

Cast
Role: Gloucester Actor: W. Giffard

Song:

Dance:

Performances

Mainpiece Title: King Lear And His Three Daughters

Cast
Role: Gloucester Actor: W. Giffard

Song:

Dance:

Performances

Mainpiece Title: Jane Shore

Cast
Role: Gloucester Actor: W. Giffard

Afterpiece Title: The Cobler of Preston

Song: Mrs Mountfort