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 Earl Of Essex

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Dance: After Singing: A Pastoral Dance-Byrne, Mlle St.Amand

Song: End: Black Eyed Susan-Incledon

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Valentine Actor: Caulfield

Afterpiece Title: The Doctor and the Apothecary

Song: End II: a favourite Duett(composed by Florio Jun.)-Miss Hagley, Mrs Bland

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Wild Oats; Or, The Strolling Gentlemen

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Columbus

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: At King's Love For Love

Cast
Role: Valentine Actor: Whitfield

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Dance: End: Hornpipe-Bayzand

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Dance: End: The Irish Lilt-

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Dance: As17931015

Performances

Mainpiece Title: The Siege Of Berwick

Cast
Role: : Valentine Actor: Holman

Afterpiece Title: ANNETTE AND LUBIN

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Performances

Mainpiece Title: The Siege Of Berwick

Cast
Role: : Valentine Actor: Holman

Afterpiece Title: ROBIN HOOD

Dance: As17931015

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: THE FARMER

Cast
Role: Valentine Actor: Johnstone

Dance: As17931022

Performances

Mainpiece Title: Annette And Lubin

Cast
Role: : Valentine Actor: Holman

Afterpiece Title: FONTAINVILLE FOREST

Afterpiece Title: THE SICILIAN ROMANCE

Performances

Mainpiece Title: The Widow Of Malabar

Afterpiece Title: THE FOLLIES OF A DAY

Afterpiece Title: THE FARMER

Cast
Role: Valentine Actor: Incledon

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: THE FARMER

Cast
Role: Valentine Actor: Johnstone

Dance: As17931022

Performances

Mainpiece Title: The Prisoner At Large

Afterpiece Title: THE AGREEABLE SURPRISE

Afterpiece Title: THE FARMER

Cast
Role: Valentine Actor: Johnstone

Song: In the course of the evening Dr Grigsby's Tippety Witchet by Fawcett [sec CG, 16 May]

Monologue: 1794 08 23 A new Occarimlal Address in the Character of Trudge [in INKLE AND YARICO] by Fawcett

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: The Rage

Afterpiece Title: The Farmer

Cast
Role: Valentine Actor: Johnstone

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Valentine Actor: Caulfield

Afterpiece Title: The Wedding Day

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: The Prize

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: Love For Love

Cast
Role: Valentine Actor: Kemble

Afterpiece Title: Lodoiska