SELECT * FROM london_stages WHERE eventid IN (1425, 2047, 2071, 2526, 2637, 3518, 3885, 4062, 4071, 4204, 4413, 4648, 4653, 4795, 4925, 5186, 5265, 5623, 5749, 5759, 5784, 6178, 6392, 6643, 6677, 7257, 7443, 7528, 7941, 8026, 8173, 8334, 8355, 8387, 8408, 8414, 8447, 8454, 8460, 8485, 8545, 8614, 8660, 8700, 8703, 8768, 8846, 8859, 8953, 9022, 9065, 9267, 9333, 9379, 9438, 9533, 9546, 9797, 9826, 9897, 10062, 10236, 10286, 10325, 10398, 10578, 10795, 10859, 10891, 10983, 10985, 10988, 10990, 11000, 11019, 11029, 11082, 11238, 11296, 11449, 11492, 11508, 11543, 11805, 11808, 11848, 12314, 12495, 12836, 13051, 13453, 13459, 13497, 13525, 13578, 13614, 13680, 13750, 13783, 14064, 14069, 14084, 14103, 14359, 14663, 15077, 15090, 15474, 15571, 15575, 15592, 15751, 15755, 15865, 15877, 16071, 16237, 16453, 16758, 17012, 17163, 17169, 17372, 17375, 17376, 17392, 17433, 17553, 17663, 17667, 17670, 17673, 17677, 17679, 17696, 17745, 17749, 17815, 17942, 18096, 18259, 18272, 18414, 18493, 18663, 18784, 18877, 18961, 18963, 18965, 18968, 19129, 19265, 19271, 19297, 19315, 19362, 19372, 19403, 19491, 19502, 19508, 19590, 19609, 19661, 19679, 19823, 19855, 19877, 20061, 20189, 20236, 20376, 20413, 20570, 20657, 20777, 20931, 21159, 21163, 21174, 21179, 21193, 21200, 21219, 21222, 21264, 21271, 21292, 21299, 21309, 21324, 21386, 21413, 21445, 21489, 21496, 21499, 21553, 21564, 21568, 21586, 21592, 21596, 21602, 21620, 21690, 21798, 21836, 21882, 21884, 21887, 21922, 21951, 21957, 21984, 21992, 22029, 22057, 22081, 22093, 22126, 22207, 22272, 22353, 22445, 22459, 22462, 22487, 22514, 22564, 22695, 22804, 22909, 23030, 23033, 23058, 23187, 23299, 23316, 23384, 23409, 23447, 23489, 23633, 23651, 23715, 23868, 23922, 23945, 24003, 24050, 24110, 24115, 24210, 24334, 24337, 24340, 24365, 24505, 24790, 24898, 24944, 25098, 25397, 25802, 25939, 26024, 26083, 26138, 26206, 26208, 26237, 26267, 26407, 26450, 26716, 26740, 26754, 26926, 27362, 27419, 27484, 27496, 27631, 27777, 27786, 27916, 27946, 27950, 27955, 27963, 27968, 27976, 28001, 28099, 28161, 28182, 28187, 28377, 28387, 28392, 28412, 28448, 28530, 28569, 28654, 28705, 28706, 28709, 28719, 28755, 28762, 28816, 28894, 28982, 29185, 29189, 29197, 29231, 29446, 29737, 29741, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29773, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29797, 29798, 29800, 29802, 29805, 29806, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29829, 29830, 29839, 29880, 29896, 29897, 29902, 29910, 29920, 29937, 29948, 29961, 29968, 29988, 30043, 30062, 30077, 30126, 30148, 30152, 30692, 30981, 31191, 31430, 31508, 31730, 31745, 32225, 32365, 32417, 32429, 32480, 32484, 32490, 32494, 32498, 32504, 32544, 32632, 32642, 32650, 32674, 32707, 32748, 32812, 32856, 32898, 32950, 32978, 33073, 33116, 33153, 33163, 33242, 33244, 33315, 33359, 33368, 33475, 33571, 33640, 33682, 33698, 33754, 33847, 33853, 34083, 34116, 34168, 34210, 34448, 34514, 34556, 34576, 34733, 34771, 34911, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35013, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35077, 35078, 35088, 35092, 35094, 35097, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35133, 35135, 35143, 35149, 35160, 35164, 35169, 35172, 35174, 35177, 35179, 35182, 35184, 35187, 35202, 35207, 35210, 35213, 35218, 35223, 35264, 35277, 35289, 35305, 35349, 35365, 35372, 35382, 35393, 35480, 35525, 35556, 35560, 35713, 35868, 36203, 36270, 36536, 36854, 36868, 36900, 36904, 37069, 37107, 37528, 37611, 37659, 37881, 37885, 38589, 38654, 38748, 38766, 38798, 38923, 38936, 38950, 38964, 39148, 39162, 39458, 39466, 39512, 39606, 39681, 39686, 39701, 39715, 39728, 39742, 39756, 39771, 39788, 40016, 40026, 40048, 40051, 40083, 40159, 40337, 40371, 40412, 40634, 40640, 40726, 40819, 41281, 41332, 41458, 41745, 41770, 42461, 42569, 42894, 43029, 44104, 44112, 44116, 44128, 44132, 44136, 44148, 44152, 44156, 44158, 44160, 44162, 44296, 45332, 45339, 45348, 45406, 45419, 45543, 46359, 46427, 46441, 46455, 46481, 46509, 46622, 46709, 46727, 46852, 46917, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47081, 47202, 47497, 47723, 48212, 48221, 48226, 48232, 48234, 48239, 48373, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 48995, 49000, 49004, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49061, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49385, 49441, 49620, 49657, 49664, 49759, 49768, 49844, 50084, 50113, 50126, 50356, 50733, 50736, 50742, 50744, 50757, 50795, 50802, 50995, 51263, 51755, 51765, 51767, 51771, 51845, 52106) 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: Cato

Afterpiece Title: Tom Thumb

Cast
Role: Cleara Actor: Stoppelaer

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Tom Thumb

Cast
Role: Cleara Actor: Stoppelaer

Song: As17310318

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Tom Thumb

Cast
Role: Cleara Actor: Stoppelaer

Performances

Mainpiece Title: King Lear And His Three Daughters

Cast
Role: Lear Actor: Quin

Performances

Mainpiece Title: King Lear And His Three Daughters

Cast
Role: Lear Actor: Quin

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: Aesop

Cast
Role: Learchus Actor: Hippisley

Afterpiece Title: Apollo and Daphne

Performances

Mainpiece Title: King Lear And His Three Daughters

Cast
Role: Lear Actor: Quin

Afterpiece Title: Apollo and Daphne

Performances

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

Cast
Role: Lear Actor: Delane

Afterpiece Title: The Devil to Pay

Song: LLove and Wine (by the author of Bacchus One Day Gayly Striding)-Excell

Ballet: The Difference of Nations. As17330312

Performances

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

Cast
Role: Lear Actor: Paget

Afterpiece Title: A Journey to Bristol

Dance: IV: Scottish Dance, as17330329 V: Tambourine-Miss Rogers; II of Farce: Tollet's Grounds-Newhouse, Mrs Ogden

Performances

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

Cast
Role: Lear Actor: Delane

Afterpiece Title: Flora

Song: Song of Mr Handel's-Cuttin; III: A Ballad called The Constant Maid-Mrs Roberts; IV: Cuttin

Dance: V: Grand Masquerade Dance, as17330410

Performances

Mainpiece Title: King Lear

Cast
Role: Lear Actor: Mills

Afterpiece Title: The Mock Countess

Dance: II: Dutchwoman-Miss Robinson; III: French Gardener and His Mistress-Haughton, Mrs Walter; IV: Saraband, Minuet-Lally Jr, Miss Mears; V: English Maggot-Haughton, Mrs Walter

Performances

Mainpiece Title: Aesop

Cast
Role: Learchus Actor: Aston

Afterpiece Title: The Devil to Pay; or, The Wives Metamorphos'd

Performances

Mainpiece Title: Aesop

Cast
Role: Learchus Actor: Aston

Afterpiece Title: The Devil to Pay

Music: Select Pieces between the Acts, Composed by Mr Lampe

Dance: Drunken Peasant by Le Brun. English Maggot by Lally Jr and Mrs Walter

Performances

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

Cast
Role: Lear Actor: Delane

Afterpiece Title: Damon and Phillida

Dance: Scot's Dance by Miss Wherrit

Performances

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

Cast
Role: Lear Actor: Quin

Dance: The Nassau, as17331112

Performances

Mainpiece Title: The True And Ant1ent History Of King Lear And H1s Three Daughters

Cast
Role: Lear Actor: Quin

Dance: Pygmalion (new) by Malter, Mlle Salle, Dupre, Pelling, Duke, LeSac, Newhouse, Delagarde

Performances

Mainpiece Title: Astartus

Performances

Mainpiece Title: King Lear

Cast
Role: Lear Actor: Delane

Afterpiece Title: Damon and Phillida

Entertainment:

Performances

Mainpiece Title: King Lear

Cast
Role: Lear Actor: Delane

Afterpiece Title: Britannia

Performances

Mainpiece Title: King Lear

Cast
Role: Lear Actor: Delane

Afterpiece Title: Jupiter and Io

Performances

Mainpiece Title: Issipile

Performances

Mainpiece Title: King Lear

Cast
Role: Lear Actor: Stephens

Afterpiece Title: The Toy Shop

Dance: By Lally and Mlle Salle. Scot's Dance by Glover and Miss Rogers

Performances

Mainpiece Title: The Twin Rivals

Cast
Role: Clear Actor: account-Wright

Afterpiece Title: The Honest Yorkshireman

Music: As17350715

Dance: French Peasant by Vallois and Mrs Woodward. Two Pierrots by Vallois and Davenport. Le Gout Anglois by Mr and Mrs Davenport

Song: As17350718

Performances

Mainpiece Title: The Twin Rivals

Cast
Role: Clear Actor: account-Wright

Afterpiece Title: The Honest Yorkshireman

Music: As17350715

Dance: As17350722

Song: As17350718

Performances

Mainpiece Title: The Twin Rivals

Cast
Role: Clear Actor: account-Wright

Afterpiece Title: The Honest Yorkshireman