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 Gamester

Cast
Role: Gamester Actor: Leigh

Dance: As17191005

Performances

Mainpiece Title: King Henry The Fourth, Part I

Cast
Role: Worcester Actor: Boheme

Dance:

Performances

Mainpiece Title: Le Joueur

Afterpiece Title: L'Esprit Follet

Performances

Mainpiece Title: King Henry The Fourth, Part I

Cast
Role: Worcester Actor: Boheme

Dance: As17201125

Performances

Mainpiece Title: Humphrey, Duke Of Gloucester

Performances

Mainpiece Title: The Pilgrim

Song: As17231116

Dance: Drunken Swiss-Nivelon Jr; Running Footman's Dance-Nivelon Sr

Ballet: The Humours of Bedlam. Mad Taylor-Nivelon Sr; Mad Dancing Master-Glover; Mad Gamester-Pelling; Mad Soldier-Nivelon Jr; Mad Astrologer-Lanyam; Mad Lady-Mrs Rogeir

Cast
Role: Mad Gamester Actor: Pelling

Performances

Mainpiece Title: The Pilgrim

Song: As17231116

Dance: As17231127

Ballet: The Humours of Bedlam. As17231127

Cast
Role: Mad Gamester Actor: Pelling

Performances

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

Cast
Role: Gloucester Actor: Quin

Dance: Dupre, Nivelons, Glover, Mrs Rogeir, Mrs Wall, Mrs Ogden; particularly Flag Dance (after a new manner)-Nivelon Sr

Song: Leveridge, Salway, Mrs Chambers

Performances

Mainpiece Title: The Pilgrim

Dance: French Peasant, Running Footman-Nivelon Sr, Mrs Rogeir; Myrtillo-

Ballet: The Humours of Bedlam. As17231127, but Mad Soldier-Dupre

Cast
Role: Mad Gamester Actor: Pelling

Performances

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

Cast
Role: Gloucester Actor: Quin

Dance: Glover, Newhouse, Lanyon, Mrs Rogier, Mrs Wall, Mrs Ogden; particularly Tollet's Ground-Newhouse, Mrs Rogier; Shepherd and Shepherdess-Glover, Mrs Wall; Peasant-Lanyom, Mrs Ogden

Performances

Mainpiece Title: King Henry The Ivth; Part I

Cast
Role: Worcester Actor: Ogden

Dance: End I: Louvre-Mrs Wall; II: French Peasant-Nivelon Sr, Mrs Rogier; III: Dutch Boor-Newhouse, Mrs Ogden; IV: Running Footman's Dance-Nivelon Sr, Mrs Rogier; V: Shepherd and Shepherdess-Glover, Mrs Wall

Performances

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

Cast
Role: Glocester Actor: Thurmond

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Performances

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

Cast
Role: Glocester Actor: Thurmond

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Performances

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

Cast
Role: Glocester Actor: Quin

Song: IIn Praise of Love and Wine-Leveridge, Laguerre

Dance: Dupre, Nivelon, Glover, Mrs Laguerre, Mrs Wall, Mrs Ogden; Flag Dance-Nivelon

Performances

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

Cast
Role: Glocester Actor: Quin

Dance: CChacone-Mrs Bullock; Dutch Burgomaster-Newhouse, Mrs Ogden

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: The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Dance: PPastoral-LeSac, Miss LaTour; Fingalian-Newhouse, Mrs Ogden; Scotish Dance-Mrs Bullock; Shepherd and Shepherdess-Salle, Mlle Salle

Performances

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

Cast
Role: Gloucester Actor: Quin

Song: TThe Play of Love-Leveridge

Dance: FFrench Sailor and Wife-Salle, Mlle Salle; French Peasant-Nivelon, Mrs Legare

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Humours of Bedlam

Cast
Role: Mad Gamester Actor: Pelling

Afterpiece Title: Pan and Syrinx

Dance: As17261024

Performances

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

Cast
Role: Glocester Actor: Quin

Performances

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

Cast
Role: Gloucester Actor: Thurmond

Performances

Mainpiece Title: Jane Shore

Cast
Role: Gloucester Actor: Cibber

Afterpiece Title: Apollo and Daphne; or, Harlequin's Metamorphoses

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth; With The Humours Of Sir John Falstaff And Justice Shallow

Cast
Role: Gloucester Actor: Oats