SELECT * FROM london_stages WHERE eventid IN (27268, 27310, 27313, 27315, 27319, 27328, 27335, 27412, 27524, 27609, 28245, 28247, 28249, 28251, 28255, 28258, 28260, 28265, 28271, 28283, 28329, 28331, 28334, 28338, 28352, 28683, 29488, 29508, 29587, 29590, 29637, 32549, 32551, 32856, 32866, 32898, 32924, 32947, 32951, 32960, 32978, 32989, 32994, 33003, 33012, 33024, 33036, 33039, 33092, 33110, 33116, 33124, 33143, 33150, 33163, 33174, 33179, 33218, 33219, 33224, 33225, 33226, 33230, 33231, 33232, 33235, 33236, 33237, 33238, 33239, 33240, 33241, 33242, 33243, 33244, 33245, 33247, 33248, 33249, 33250, 33251, 33252, 33253, 33254, 33255, 33256, 33257, 33291, 33293, 33302, 33315, 33327, 33336, 33341, 33350, 33353, 33355, 33364, 33374, 33383, 33386, 33388, 33392, 33397, 33414, 33435, 33437, 33483, 33512, 33526, 33538, 33595, 33622, 33633, 33640, 33642, 33659, 33673, 33676, 33681, 33698, 33788, 33791, 33792, 33804, 33810, 33829, 33833, 33843, 33847, 33849, 33853, 33855, 33857, 33860, 33862, 33864, 33866, 33873, 33875, 33884, 33887, 33893, 33898, 33912, 33919, 33924, 33935, 33950, 33969, 33974, 33976, 33978, 33980, 33982, 33984, 33986, 33989, 33991, 33994, 33998, 34000, 34003, 34005, 34010, 34017, 34040, 34043, 34050, 34055, 34058, 34067, 34097, 34102, 34107, 34112, 34117, 34122, 34132, 34141, 34144, 34151, 34155, 34158, 34166, 34168, 34173, 34175, 34178, 34182, 34194, 34197, 34199, 34202, 34204, 34207, 34209, 34212, 34214, 34222, 34224, 34232, 34246, 34249, 34252, 34258, 34261, 34328, 34339, 34346, 34348, 34353, 34369, 34374, 34376, 34379, 34381, 34383, 34391, 34393, 34395, 34397, 34400, 34404, 34406, 34410, 34412, 34414, 34418, 34421, 34423, 34426, 34440, 34461, 34465, 34479, 34484, 34496, 34498, 34505, 34507, 34510, 34513, 34516, 34518, 34520, 34527, 34529, 34531, 34533, 34538, 34543, 34547, 34555, 34561, 34571, 34573, 34575, 34578, 34585, 34587, 34589, 34592, 34600, 34611, 34641, 34681, 34688, 34696, 34706, 34714, 34722, 34734, 34736, 34753, 34770, 34772, 34775, 34779, 34781, 34784, 34795, 34812, 34887, 34893, 34897, 34911, 34913, 34919, 34921, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34963, 34966, 34968, 34970, 34972, 34975, 34977, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35008, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35036, 35038, 35040, 35042, 35045, 35048, 35051, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35085, 35088, 35092, 35094, 35097, 35104, 35106, 35108, 35111, 35118, 35120, 35122, 35125, 35127, 35129, 35132, 35135, 35143, 35149, 35160, 35164, 35169, 35172, 35174, 35177, 35179, 35182, 35184, 35187, 35202, 35207, 35210, 35213, 35218, 35223, 35227, 35230, 35235, 35243, 35255, 35264, 35272, 35274, 35277, 35289, 35292, 35296, 35299, 35305, 35316, 35324, 35330, 35337, 35340, 35343, 35345, 35351, 35357, 35360, 35365, 35368, 35372, 35375, 35379, 35381, 35382, 35495, 35506, 35508, 35513, 35518, 35520, 35522, 35524, 35547, 35549, 35560, 35566, 35568, 35573, 35577, 35579, 35581, 35583, 35587, 35589, 35592, 35595, 35603, 35615, 35621, 35629, 35635, 35642, 35656, 35659, 35683, 35691, 35693, 35699, 35714, 35756, 35810, 35818, 35823, 35826, 35844, 35856, 35865, 35868, 35876, 35879, 35889, 35907, 35910, 35918, 35922, 35924, 35932, 35943, 35947, 35967, 35981, 35989, 35997, 36113, 36115, 36118, 36129, 36135, 36145, 36147, 36153, 36166, 36168, 36174, 36184, 36193, 36195, 36199, 36203, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36246, 36248, 36253, 36257, 36266, 36275, 36289, 36291, 36303, 36308, 36333, 36343, 36370, 36372, 36374, 36376, 36379, 36384, 36388, 36391, 36398, 36403, 36406, 36429, 36434, 36440, 36460, 36465, 36490, 36499, 36504, 36506, 36518, 36523, 36529, 36532, 36546, 36552, 36558, 36564, 36568, 36636, 36655, 36657, 36663, 36665, 36667, 36671, 36678, 36680, 36686, 36690, 36694, 36696, 36702, 36704, 36717, 36719, 36724, 36738, 36745, 36752, 36761, 36766, 36768, 36778, 36793, 36795, 36802, 36830, 36832, 36837, 36839, 36841, 36862, 36868, 36878, 36881, 36900, 36902, 36904, 36969, 36988, 36990, 37002, 37005, 37018, 37021, 37033, 37036, 37041, 37046, 37049, 37058, 37071, 37073, 37076, 37080, 37091, 37098, 37107, 37119, 37212, 37223, 37225, 37227, 37231, 37249, 37253, 37255, 37260, 37264, 37266, 37268, 37274, 37276, 37278, 37280, 37282, 37284, 37292, 37294, 37303, 37307, 37310, 37315, 37317, 37324, 37333, 37338, 37340, 37345, 37352, 37357, 37361, 37366, 37368, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37436, 37439, 37443, 37451, 37455, 37460, 37465, 37467, 37470, 37479, 37517, 37528, 37531, 37533, 37540, 37545, 37570, 37584, 37597, 37606, 37611, 37618, 37621, 37630, 37632, 37637, 37646, 37651, 37659, 37662, 37671, 37680, 37774, 37778, 37781, 37783, 37785, 37787, 37790, 37793, 37797, 37803, 37805, 37809, 37813, 37815, 37817, 37819, 37821, 37825, 37827, 37829, 37831, 37833, 37835, 37837, 37839, 37841, 37843, 37852, 37856, 37860, 37864, 37870, 37874, 37880, 37882, 37887, 37889, 37893, 37902, 37905, 37911, 37916, 37925, 37928, 37930, 37935, 37937, 37941, 37943, 37947, 37949, 37951, 37962, 37969, 37982, 37996, 38030, 38032, 38045, 38047, 38050, 38053, 38056, 38060, 38062, 38065, 38070, 38073, 38078, 38083, 38088, 38091, 38093, 38097, 38105, 38107, 38112, 38118, 38123, 38143, 38151, 38153, 38158, 38160, 38167, 38172, 38175, 38177, 38180, 38183, 38190, 38192, 38197, 38202, 38210, 38216, 38224, 38227, 38233, 38315, 38323, 38325, 38329, 38330, 38332, 38334, 38341, 38345, 38353, 38371, 38373, 38376, 38378, 38381, 38383, 38385, 38387, 38390, 38394, 38396, 38399, 38404, 38407, 38410, 38420, 38427, 38429, 38436, 38441, 38450, 38455, 38459, 38462, 38467, 38469, 38473, 38477, 38485, 38488, 38494, 38496, 38500, 38502, 38523, 38551, 38563, 38568, 38570, 38573, 38593, 38619, 38644, 38663, 38678, 38682, 38689, 38709, 38711, 38714, 38719, 38724, 38726, 38736, 38741, 38743, 38745, 38748, 38758, 38760, 38766, 38768, 38778, 38794, 38796, 38798, 38864, 38879, 38885, 38888, 38891, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38918, 38920, 38924, 38926, 38928, 38934, 38937, 38939, 38944, 38946, 38948, 38953, 38960, 38965, 38970, 38976, 38979, 38982, 38984, 38988, 39003, 39006, 39008, 39015, 39022, 39024, 39026, 39028, 39032, 39036, 39038, 39041, 39043, 39045, 39049, 39051, 39054, 39058, 39065, 39067, 39072, 39074, 39078, 39083, 39088, 39090, 39093, 39095, 39098, 39104, 39107, 39121, 39123, 39142, 39149, 39171, 39177, 39181, 39202, 39210, 39213, 39225, 39234, 39236, 39245, 39253, 39257, 39260, 39262, 39265, 39268, 39270, 39280, 39285, 39291, 39308, 39312, 39324, 39337, 39341, 39347, 39449, 39451, 39453, 39457, 39460, 39465, 39472, 39476, 39480, 39493, 39497, 39499, 39502, 39511, 39527, 39532, 39539, 39546, 39550, 39555, 39558, 39564, 39567, 39572, 39578, 39581, 39583, 39588, 39590, 39592, 39595, 39605, 39607, 39609, 39611, 39613, 39618, 39632, 39651, 39657, 39660, 39663, 39668, 39670, 39673, 39675, 39678, 39680, 39684, 39687, 39690, 39693, 39695, 39704, 39709, 39713, 39716, 39729, 39759, 39769, 39789, 39791, 39843, 39847, 39852, 39854, 39857, 39861, 39871, 39873, 39888, 39902, 40023, 40025, 40027, 40041, 40043, 40050, 40056, 40058, 40062, 40066, 40074, 40082, 40086, 40090, 40094, 40096, 40098, 40106, 40113, 40143, 40148, 40150, 40157, 40159, 40162, 40164, 40169, 40172, 40175, 40178, 40187, 40189, 40196, 40198, 40201, 40204, 40211, 40213, 40216, 40225, 40230, 40235, 40244, 40253, 40256, 40258, 40264, 40266, 40269, 40271, 40278, 40281, 40284, 40304, 40334, 40337, 40339, 40344, 40352, 40357, 40371, 40376, 40381, 40386, 40390, 40412, 40415, 40419, 40427, 40440, 40443, 40445, 40449, 40459, 40460, 40463, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40633, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40682, 40699, 40713, 40718, 40722, 40742, 40745, 40749, 40757, 40760, 40766, 40778, 40800, 40803, 40858, 40869, 40879, 40881, 40883, 40890, 40899, 40904, 40909, 40919, 40921, 40930, 40935, 40940, 40945, 40952, 40955, 40973, 40984, 40991, 40993, 40996, 40998, 41003, 41459, 41719) 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 Clandestine Marriage

Cast
Role: Traverse Actor: Hurst

Afterpiece Title: A ChristmasTale

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Sir Walter Blunt Actor: Hurst

Afterpiece Title: The Quaker

Dance: As17771111

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Cast
Role: Mowbray Actor: Hurst

Afterpiece Title: Comus

Performances

Mainpiece Title: The Roman Sacrifice

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: The Roman Sacrifice

Afterpiece Title: Comus

Performances

Mainpiece Title: The Roman Sacrifice

Afterpiece Title: The Waterman

Performances

Mainpiece Title: The Roman Sacrifice

Afterpiece Title: Comus

Performances

Mainpiece Title: Hamlet

Cast
Role: Player King Actor: Hurst

Afterpiece Title: Comus

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Sir Walter Blunt Actor: Hurst

Afterpiece Title: The Deserter

Dance: As17771111

Song: In afterpiece: by Desire, Oh what a charming thing's a battle-Bannister

Performances

Mainpiece Title: The Distress'd Mother

Cast
Role: Phoenix Actor: Hurst

Afterpiece Title: Comus

Performances

Mainpiece Title: King John

Cast
Role: Citizen Actor: Hurst

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Every Man In His Humour

Cast
Role: Downright Actor: Hurst

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Macbeth

Cast
Role: Seward Actor: Hurst

Afterpiece Title: Queen Mab

Song: In: the original Music by Matthew Locke, with full Chorusses and Additional Accompaniments,-Bannister, Gaudry, Legg, Edwards, Chaplin, Carpenter, Holcroft, Miss Abrams, Mrs Love, Mrs Pitt, Mrs Smith, Miss Collett

Performances

Mainpiece Title: Macbeth

Cast
Role: Seward Actor: Hurst

Afterpiece Title: Queen Mab

Song: As17780105

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Sir Walter Blunt Actor: Hurst

Afterpiece Title: The Quaker

Dance: As17771009

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: Comus

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: The Waterman

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: The Quaker

Dance: As17780128

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: Comus

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: The Note of Hand; or, Trip to Newmarket

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: Queen Mab

Dance: In: As17780128

Performances

Mainpiece Title: The Battle Of Hastings

Cast
Role: Raymond Actor: Hurst

Afterpiece Title: Queen Mab

Dance: As17780203