SELECT * FROM london_stages WHERE eventid IN (1136, 1304, 1412, 1542, 1582, 1691, 1711, 1728, 1732, 1736, 1737, 1765, 1770, 1777, 1780, 1791, 1863, 1882, 1883, 1886, 1919, 1922, 1935, 1937, 1945, 1959, 1982, 1983, 1984, 1988, 1990, 1991, 2004, 2005, 2006, 2012, 2018, 2026, 2050, 2104, 2153, 2163, 2165, 2193, 2285, 2306, 2362, 2371, 2435, 2519, 2550, 2555, 2593, 2727, 2790, 2853, 2986, 3791, 3797, 3799, 3809, 3843, 3854, 3861, 3872, 3877, 3897, 3899, 3944, 3953, 3955, 3982, 3985, 3986, 3988, 3989, 3994, 4004, 4011, 4042, 4043, 4045, 4046, 4047, 4049, 4050, 4059, 4060, 4061, 4063, 4064, 4066, 4075, 4077, 4078, 4082, 4085, 4086, 4091, 4092, 4095, 4096, 4097, 4104, 4106, 4110, 4111, 4112, 4117, 4124, 4128, 4134, 4135, 4138, 4140, 4143, 4151, 4155, 4156, 4159, 4160, 4163, 4175, 4176, 4182, 4193, 4202, 4206, 4208, 4210, 4216, 4218, 4226, 4227, 4228, 4231, 4238, 4241, 4299, 4301, 4303, 4316, 4317, 4322, 4328, 4331, 4338, 4340, 4342, 4359, 4361, 4370, 4380, 4386, 4406, 4426, 4433, 4440, 4461, 4472, 4481, 4510, 4512, 4514, 4535, 4553, 4564, 4634, 4637, 4638, 4639, 4641, 4642, 4643, 4645, 4646, 4649, 4657, 4659, 4663, 4664, 4667, 4669, 4674, 4705, 4710, 4718, 4726, 4728, 4732, 4734, 4741, 4742, 4745, 4748, 4753, 4759, 4769, 4781, 4794, 4800, 4812, 4817, 4820, 4823, 4838, 4839, 4841, 4843, 4844, 4853, 4869, 4891, 4894, 4895, 4904, 4906, 4908, 4912, 4913, 4914, 4915, 4918, 4921, 4924, 4939, 4940, 4953, 4969, 4973, 4976, 4979, 4981, 4988, 5058, 5109, 5113, 5115, 5126, 5129, 5132, 5141, 5161, 5164, 5169, 5170, 5172, 5174, 5175, 5179, 5183, 5184, 5190, 5192, 5194, 5196, 5239, 5247, 5256, 5262, 5267, 5270, 5289, 5299, 5301, 5303, 5310, 5312, 5324, 5333, 5335, 5338, 5342, 5344, 5403, 5406, 5409, 5414, 5415, 5440, 5469, 5472, 5480, 5481, 5484, 5511, 5573, 5587, 5635, 5664, 5706, 5738, 5746, 5748, 5789, 5794, 5799, 5839, 5841, 5845, 5865, 5922, 5934, 5972, 6086, 6090, 6115, 6125, 6181, 6233, 6371, 6411, 6539, 6547, 6579, 6583, 6605, 6636, 6684, 6689, 6716, 6738, 6741, 6759, 6790, 6803, 6816, 6828, 6831, 6852, 6855, 6894, 6897, 6927, 6933, 6948, 6963, 7044, 7074, 7080, 7090, 7122, 7132, 7160, 7164, 7191, 7230, 7258, 7334, 7450, 7454, 7456, 7476, 7478, 7496, 7500, 7517, 7535, 7537, 7560, 7593, 7595, 7605, 7677, 7697, 7742, 7744, 7748, 9890, 9891, 9903, 9929, 9952, 9964, 9973, 10023, 10051, 10232, 10242, 10274, 10277, 10279, 10284, 10321, 10330, 10342, 10351, 24764, 24771, 24775, 24779, 24789, 24796, 24799, 24812, 24813, 25127, 25133, 25142, 25153, 25164, 25170, 25182, 25185, 25195, 49239, 49255, 49279, 49304, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49370, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49432, 49439, 49452, 49465, 49766, 49770, 49775, 49780, 49787, 49788, 49791, 49809, 49825, 49827, 49841, 49847, 49851, 49853, 49859, 49867, 49873, 49875, 49877, 49881, 49886, 49891, 49895, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49937, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49958, 49959, 49961, 49966, 49968, 49971, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50064, 50067, 50070, 50073, 50077, 50079, 50082, 50089, 50099, 50104, 50108, 50111, 50113, 50116, 50121, 50123, 50126, 50128, 50131, 50134, 50138, 50141, 50146, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50179, 50181, 50186, 50189, 50193, 50195, 50198, 50203, 50208, 50213, 50215, 50324, 50330, 50332, 50336, 50342, 50345, 50348, 50358, 50368, 50370, 50374, 50376, 50389, 50396, 50412, 50418, 50420, 50422, 50424, 50426, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50454, 50456, 50461, 50463, 50466, 50468, 50472, 50484, 50492, 50501, 50531, 50534, 50538, 50540, 50543, 50546, 50556, 50559, 50562, 50586, 50597, 50600, 50605, 50607, 50611, 50614, 50616, 50628, 50632, 50638, 50640, 50684, 50693, 50702, 50704, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50731, 50733, 50736, 50742, 50744, 50749, 50752, 50757, 50762, 50764, 50767, 50769, 50779, 50784, 50795, 50800, 50802, 50805, 50812, 50911, 50912, 50917, 50919, 50921, 50923, 50927, 50929, 50934, 50942, 50944, 50948, 50950, 50951, 50953, 50957, 50961, 50963, 50967, 50969, 50973, 50977, 50987, 50991, 50999, 51001, 51003, 51005, 51007, 51009, 51014, 51016, 51018, 51021, 51027, 51029, 51033, 51036, 51038, 51041, 51045, 51047, 51052, 51054, 51057, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51135, 51138, 51140, 51142, 51147, 51150, 51156, 51191, 51203, 51211, 51215, 51218, 51223, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51263, 51266, 51271, 51280, 51285, 51288, 51293, 51295, 51298, 51300, 51302, 51304, 51309, 51312, 51317, 51319, 51322, 51324, 51329, 51331, 51336, 51338, 51341, 51343, 51345, 51351, 51354, 51356, 51360, 51363, 51365, 51368, 51376, 51449, 51450, 51452, 51454, 51462, 51465, 51481, 51484, 51492, 51496, 51498, 51503, 51505, 51506, 51509, 51511, 51513, 51514, 51517, 51519, 51521, 51522, 51525, 51527, 51529, 51531, 51532, 51535, 51537, 51539, 51541, 51543, 51545, 51557, 51561, 51565, 51567, 51569, 51571, 51573, 51575, 51577, 51579, 51581, 51583, 51585, 51587, 51589, 51591, 51593, 51596, 51603, 51613, 51617, 51624, 51629, 51634, 51639, 51643, 51648, 51650, 51653, 51655, 51657, 51664, 51667, 51671, 51676, 51683, 51686, 51694, 51701, 51704, 51722, 51728, 51750, 51759, 51762, 51771, 51789, 51794, 51797, 51803, 51806, 51808, 51811, 51813, 51815, 51822, 51828, 51833, 51836, 51841, 51843, 51845, 51851, 51859, 51861, 51866, 51869, 51871, 51873, 51877, 51882, 51885, 51887, 51900, 51904, 51907, 51912, 51914, 51917, 51922, 51927, 51929, 51931, 52060, 52062, 52072, 52074, 52081, 52087, 52099, 52100, 52102, 52108, 52112, 52120, 52126, 52128, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52162, 52164, 52166, 52168, 52170, 52172, 52174, 52178, 52180, 52182, 52184, 52186, 52188, 52190, 52192, 52194, 52204, 52206, 52208, 52214, 52221, 52225, 52231, 52239, 52241, 52243, 52274, 52280, 52282, 52286, 52289, 52291, 52294, 52296, 52298, 52300, 52303, 52305, 52308, 52310, 52312, 52314, 52317, 52319, 52323, 52326, 52329, 52331, 52335, 52338, 52341, 52343, 52350, 52355, 52359, 52362, 52365, 52367, 52374, 52383, 52389, 52391, 52394, 52396, 52398, 52400, 52403, 52405, 52410, 52413, 52415, 52418, 52423, 52429, 52432, 52434, 52437, 52439, 52442, 52444, 52449, 52458, 52461, 52463, 52466, 52468, 52471, 52473, 52476, 52478, 52483, 52495, 52497, 52504, 52506, 52509, 52511, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52551, 52552, 52553, 52555, 52558, 52559, 52560, 52561, 52564, 52566, 52567, 52569, 52571, 52572, 52574, 52575, 52576, 52579, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52594, 52595, 52597, 52600, 52601, 52602, 52605, 52610, 52615) 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 Country Girl

Afterpiece Title: Miss in her Teens

Cast
Role: Loveit Actor: Knight

Entertainment: Monologue. End: Occasional Address-the Widow (see below); After which: Collins's Ode on the Passions-Mrs G. Aickin

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Francis Actor: Knight

Afterpiece Title: The Farm House

Cast
Role: Modely Actor: Knight
Role: Aura Actor: Mrs Knight.

Performances

Mainpiece Title: The Suspicious Husband

Cast
Role: Jack Meggot Actor: Knight

Afterpiece Title: The Farmer

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Lock and Key

Cast
Role: Captain Vain Actor: Knight

Song: In V: Dirge set to Music by Shield-; Vocal Parts-Mrs Martyr, Mrs Clendining, Mrs Henley, Mrs Watts, Mrs Follett, Miss Leserve, Mrs Castelle, Mrs Norton, Mrs Gilbert, Mrs Masters, Mrs Lloyd, Mrs Blurton, Miss Walcup, Miss Gray, Miss Burnett, Linton, Street, Gray

Performances

Mainpiece Title: The Merry Wives Of Windsor

Cast
Role: Slender Actor: Knight

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Honest Thieves

Cast
Role: Colonel Careless Actor: Knight
Role: Ruth Actor: Mrs Knight

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Diamond Cut Diamond; or, The Venetian Revels

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Diamond Cut Diamond

Dance: II: Masquerade Dance- incident to the Play

Entertainment: Monologue.Preceding: a new Occasional Address-Murray

Performances

Mainpiece Title: The Rival Soldiers

Afterpiece Title: Rule a Wife and Have a Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Knight

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Knight

Afterpiece Title: England's Glory; or, The Defeat of the Dutch Fleet by the Gallant Admiral Duncan on the Memorable Eleventh of October

Dance: In Scene V 3rd piece: a Triple Hornpipe-Blurton, Mrs Watts, Mlle St.Amand

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Maid of the Mill

Cast
Role: Ralph Actor: Knight

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight

Dance: As17971018

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Maid of the Mill

Cast
Role: Ralph Actor: Knight
Role: Sir Charles Racket Actor: Knight

Afterpiece Title: England's Glory

Cast
Role: Ralph Actor: Knight
Role: Sir Charles Racket Actor: Knight

Dance: As17971018

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Knight

Afterpiece Title: England's Glory

Cast
Role: Ralph Actor: Knight
Role: Sir Charles Racket Actor: Knight

Dance: End II : Les Delassemens Militaires, as17971021; End 2nd piece: Peggy's Love, as17971021

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Honest Thieves

Cast
Role: Colonel Careless Actor: Knight
Role: Ruth Actor: Mrs Knight

Dance: III: a Hornpipe in Fetters-Blurton

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Maid of the Mill

Cast
Role: Ralph Actor: Knight
Role: Sir Charles Racket Actor: Knight

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight
Role: Ralph Actor: Knight

Performances

Mainpiece Title: The Way Of The World

Cast
Role: Petulant Actor: Knight

Afterpiece Title: A Divertisement

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight
Role: Ralph Actor: Knight

Dance: In 2nd piece: Ballet, as17971013

Performances

Mainpiece Title: Abroad And At Home

Cast
Role: Young Testy Actor: Knight
Role: Lady Flourish Actor: Mrs Knight

Afterpiece Title: The Irishman in London

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight
Role: Ralph Actor: Knight

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Francis Actor: Knight

Afterpiece Title: The Highland Reel

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight
Role: Ralph Actor: Knight

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Gratiano Actor: Knight

Afterpiece Title: The Citizen

Cast
Role: Young Philpot Actor: Knight
Role: Maria Actor: Mrs Knight.

Performances

Mainpiece Title: Wives As They Were, And Maids As They Are

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight
Role: Ralph Actor: Knight

Dance: End II: Les Delassemens Militaires, as17971021; End: Cupid and Psyche (composed by Noverre)-Mrs Wild, Mme Rose, Mme Hilligsberg, Didelot, Fialon, The Graces by Mlle St.Amand, Mme D'Egville, Mlle Philips

Performances

Mainpiece Title: The Way Of The World

Cast
Role: Petulant Actor: Knight

Afterpiece Title: The Ghost

Cast
Role: Farmer Harrow Actor: Knight

Dance: End II: Les Delassemens Militaires, as17971021; End: Cupid and Psyche, as17971104

Performances

Mainpiece Title: The Merry Wives Of Windsor

Cast
Role: Slender Actor: Knight

Afterpiece Title: A Divertisement

Afterpiece Title: England's Glory

Cast
Role: Sir Charles Racket Actor: Knight
Role: Ralph Actor: Knight

Dance: In 2nd piece: Ballet, as17971013; In V 3rd piece: a Triple Hornpipe, as17971018

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Knight

Afterpiece Title: Catherine and Petruchio

Dance: End I: The Statute Dance- [performers not listed]

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Knight

Afterpiece Title: The Honest Thieves

Cast
Role: Colonel Careless Actor: Knight
Role: Ruth Actor: Mrs Knight

Dance: As17971115

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: The Irish Mimick; or, Blunders at Brighton

Cast
Role: Julia Actor: Mrs Knight.