SELECT * FROM london_stages WHERE eventid IN (933, 979, 1329, 1335, 1765, 1960, 2641, 3594, 3745, 3926, 3947, 3963, 4013, 4052, 4166, 4192, 4256, 4267, 4286, 4312, 4316, 4317, 4350, 4510, 4564, 4622, 4629, 4739, 4888, 4927, 4952, 5113, 5306, 5328, 5408, 5651, 5839, 5898, 5942, 6093, 6094, 6109, 6430, 6525, 6582, 7097, 7100, 7227, 7310, 7341, 7423, 7426, 7429, 7469, 7586, 7762, 7867, 7932, 7961, 7989, 8067, 8224, 8338, 8430, 8565, 8732, 8782, 8838, 8922, 8940, 8952, 8994, 9019, 9067, 9174, 9253, 9321, 9372, 9487, 9598, 9702, 9804, 9861, 9883, 9970, 10072, 10258, 10294, 10389, 10393, 10429, 10493, 10658, 10745, 10826, 10873, 10883, 10919, 10967, 11118, 11283, 11391, 11442, 11538, 11607, 11703, 11729, 11816, 11924, 11945, 12063, 12207, 12282, 12311, 12416, 12608, 12721, 12754, 12764, 12837, 12898, 12934, 12986, 13000, 13027, 13123, 13134, 13137, 13141, 13144, 13148, 13152, 13156, 13160, 13164, 13178, 13185, 13228, 13315, 13341, 13384, 13410, 13431, 13476, 13529, 13596, 13611, 13734, 13802, 13966, 14024, 14065, 14121, 14129, 14152, 14176, 14270, 14306, 14352, 14428, 14494, 14525, 14615, 14618, 14625, 14628, 14771, 14773, 14929, 15092, 15097, 15103, 15106, 15111, 15176, 15180, 15335, 15577, 15587, 15616, 15649, 15756, 15761, 15766, 15801, 15805, 15811, 15817, 15913, 15965, 15967, 15971, 15977, 15982, 15984, 15991, 16013, 16022, 16038, 16074, 16080, 16081, 16084, 16108, 16112, 16138, 16150, 16211, 16254, 16390, 16391, 16412, 16429, 16440, 16452, 16455, 16456, 16464, 16476, 16559, 16606, 16654, 16827, 16857, 16948, 16982, 17025, 17065, 17109, 17117, 17301, 17315, 17396, 17404, 17406, 17521, 17550, 17559, 17583, 17633, 17762, 17794, 17821, 17879, 17913, 17939, 17943, 18004, 18016, 18040, 18042, 18062, 18073, 18088, 18123, 18199, 18202, 18216, 18229, 18240, 18297, 18337, 18603, 18641, 18691, 18737, 18742, 18751, 18780, 18790, 18800, 18810, 18826, 18830, 18858, 18907, 18920, 19060, 19106, 19118, 19122, 19162, 19171, 19180, 19181, 19195, 19234, 19243, 19274, 19288, 19289, 19334, 19386, 19392, 19396, 19434, 19435, 19446, 19486, 19495, 19540, 19566, 19580, 19594, 19623, 19642, 19717, 19763, 19860, 19892, 19944, 19984, 20030, 20079, 20095, 20128, 20195, 20230, 20259, 20276, 20293, 20298, 20314, 20323, 20398, 20401, 20405, 20409, 20412, 20415, 20418, 20421, 20447, 20453, 20459, 20586, 20624, 20646, 20681, 20694, 20709, 20717, 20719, 20792, 20820, 20966, 21192, 21234, 21277, 21318, 21334, 21341, 21354, 21407, 21482, 21531, 21644, 21646, 21757, 21761, 21821, 21852, 21908, 21974, 22243, 22300, 22479, 22524, 22580, 22631, 22800, 22858, 22942, 22950, 22953, 22964, 22973, 22978, 23017, 23029, 23065, 23108, 23136, 23142, 23147, 23244, 23251, 23252, 23271, 23380, 23383, 23393, 23409, 23414, 23488, 23863, 24023, 24024, 24033, 24088, 24178, 24181, 24244, 24251, 24320, 24366, 24389, 24515, 24521, 24586, 24866, 24925, 24963, 25086, 25092, 25387, 25510, 25518, 25730, 25732, 25746, 25755, 25784, 25802, 25808, 25982, 26024, 26229, 26233, 26237, 26272, 26294, 26311, 26326, 26406, 26464, 26548, 26605, 26618, 26860, 26864, 26869, 26878, 26921, 27086, 27087, 27386, 27440, 27453, 27578, 27619, 27681, 27760, 27770, 27832, 27948, 28070, 28107, 28171, 28222, 28337, 28353, 28362, 28364, 28366, 28368, 28371, 28535, 28649, 28657, 28710, 28783, 29049, 29053, 29180, 29258, 29429, 29588, 29867, 29904, 29953, 30059, 30078, 30099, 30128, 30312, 30401, 30572, 30615, 30618, 30659, 30850, 30866, 30877, 31005, 31229, 31273, 31365, 31369, 31417, 31496, 31502, 31506, 31515, 31519, 31556, 31569, 31737, 31753, 31837, 31841, 31861, 31877, 31887, 31901, 32007, 32028, 32075, 32079, 32328, 32350, 32408, 32473, 32524, 32738, 32885, 32891, 33016, 33113, 33393, 33564, 35057, 35108, 35182, 35335, 35382, 35587, 36186, 36234, 36241, 36251, 36255, 36264, 36273, 36282, 36296, 36336, 36355, 36381, 36477, 36492, 36555, 36816, 36897, 36996, 37002, 37008, 37064, 37082, 37571, 37636, 38198, 38678, 38717, 38860, 38947, 38974, 38982, 38986, 38993, 39056, 39081, 39100, 39196, 39208, 39303, 39346, 39474, 39615, 39735, 39775, 39805, 40039, 40080, 40084, 40104, 40184, 40192, 40310, 40583, 40731, 40861, 40931, 40951, 40956, 40960, 40970, 41104, 41242, 41312, 41754, 41907, 42203, 42204, 42205, 42209, 42215, 42218, 42282, 42387, 42517, 42696, 42717, 42957, 43179, 43219, 43307, 43773, 44227, 44645, 44687, 44699, 44707, 44719, 44735, 44795, 44802, 44812, 44856, 44891, 44933, 44936, 44946, 44957, 44965, 44968, 44980, 44986, 45004, 45013, 45020, 45025, 45030, 45037, 45041, 45047, 45106, 45161, 45166, 45186, 45190, 45198, 45200, 45209, 45210, 45212, 45220, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45333, 45342, 45349, 45354, 45365, 45386, 45390, 45403, 45410, 45416, 45429, 45461, 45472, 45487, 45517, 45526, 45554, 45574, 45589, 45702, 45714, 45720, 45731, 45742, 45746, 45767, 45791, 45810, 45813, 45817, 45822, 45831, 45909, 45923, 45942, 45950, 45978, 46011, 46030, 46074, 46075, 46095, 46118, 46133, 46262, 46279, 46282, 46301, 46325, 46328, 46363, 46399, 46449, 46459, 46474, 46483, 46519, 46523, 46524, 46564, 46631, 46632, 46697, 46717, 46731, 46853, 46884, 46892, 46935, 46939, 46943, 46959, 46992, 47006, 47011, 47043, 47045, 47059, 47073, 47185, 47192, 47220, 47224, 47235, 47241, 47253, 47266, 47294, 47322, 47431, 47456, 47459, 47466, 47467, 47480, 47487, 47491, 47496, 47525, 47529, 47551, 47561, 47574, 47692, 47707, 47804, 47808, 47829, 47863, 47879, 47891, 48000, 48047, 48127, 48199, 48353, 48380, 48425, 48545, 48577, 48643, 48645, 48868, 49066, 49074, 49095, 49164, 49219, 49251, 49262, 49263, 49275, 49287, 49363, 49430, 49552, 49555, 49631, 49632, 49754, 49818, 49842, 49863, 49930, 49939, 50043, 50088, 50101, 50112, 50151, 50160, 50170, 50200, 50203, 50336, 50351, 50354, 50362, 50377, 50392, 50407, 50419, 50673, 50704, 50709, 50712, 50717, 50722, 50726, 50751, 50766, 50808, 50917, 50981, 51001, 51008, 51035, 51044, 51047, 51057, 51147, 51160, 51220, 51300, 51331, 51375, 51376, 51444, 51484, 51508, 51543, 51620, 51666, 51736, 51805, 51821, 51893, 52064, 52095, 52114, 52361, 52382, 52492, 52521) 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 Merchant Of Venice

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Smugglers

Cast
Role: Valentine Actor: Trueman

Performances

Mainpiece Title: The Farmer

Cast
Role: Valentine Actor: Clarke

Afterpiece Title: The Child of Nature

Dance: End 1st piece: Peggy's Love- in which, by permission of the Proprietor of the Opera House, who has generously allowed Principal Dancers and Whole Corps de Ballet to appear, the following Ladies and Gentlemen will exert their well known Abilities:Laborie, Didelot, Mme Laborie, Mme Hilligsberg; End 2nd piece: La Vengeance d'Amour, in which the Pas de Quatre de Panurge-Laborie, Didelot, Mme Laborie, Mme Hilligsberg

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Smugglers

Cast
Role: Valentine Actor: Trueman

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Valentine Actor: Mansel

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Smugglers

Cast
Role: Valentine Actor: Trueman

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Smugglers

Cast
Role: Valentine Actor: Trueman

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Valentine Actor: Surmont

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: The Twins; or, Is It He, or his Brother

Song: By permission of Dibdin End I: Advice; or, Old Mary and John-Bannister Jun; End II: The Country Club-Bannister Jun; III: Tom Tough-Bannister Jun

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: What Is She

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Management

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: Of Age To-morrow

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: The First Floor

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Love For Love

Cast
Role: 000322but Valentine Actor: Powell
Role: Valentine Actor: Kemble

Afterpiece Title: The Follies of a Day

Song: In course evening: The Soldier tir'd of War's alarms-Miss Stephens; End I afterpiece: Crazy Jane-Mrs Bland