SELECT * FROM london_stages WHERE eventid IN (1282, 1326, 1416, 1433, 1442, 1463, 1504, 1507, 1531, 1533, 1537, 1542, 1567, 1582, 1601, 1618, 1622, 1662, 1670, 3022, 3405, 5852, 5854, 5856, 5863, 5882, 5889, 5929, 5932, 6338, 6380, 6411, 6557, 6597, 6599, 6665, 6724, 6735, 7052, 7072, 7076, 7094, 7102, 7106, 7150, 7199, 7208, 7210, 7222, 7235, 7243, 7260, 7277, 7305, 7344, 7875, 8077, 8103, 8152, 8195, 8317, 8834, 10879, 10912, 11333, 11334, 11335, 11344, 11347, 11720, 11750, 11951, 12184, 12187, 12243, 12273, 12279, 12281, 12686, 13448, 14682, 14903, 14969, 15093, 15262, 15266, 15270, 15274, 15277, 15281, 15285, 15289, 15292, 15295, 15298, 15301, 15304, 15485, 15488, 15503, 15585, 15796, 15828, 15907, 15954, 16009, 16108, 16211, 16403, 16433, 16933, 17293, 17347, 17491, 17647, 18239, 18379, 18678, 18913, 18947, 19075, 19283, 19380, 19428, 19722, 19775, 19777, 19779, 19781, 19784, 19786, 19789, 19791, 19798, 19845, 19847, 19850, 19858, 19860, 19861, 19863, 19865, 19867, 19868, 19871, 19878, 19881, 19883, 19885, 19890, 19897, 19899, 19902, 19903, 19906, 19908, 19911, 19913, 19916, 19918, 19921, 20002, 20012, 20048, 20053, 20062, 20066, 20067, 20102, 23059, 23071, 23119, 23143, 24164, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25887, 25897, 25903, 25910, 25915, 25926, 25933, 25942, 25949, 25953, 26283, 26285, 26288, 26290, 26293, 26295, 26297, 31386, 31559, 31561, 31563, 31568, 31572, 31578, 31581, 31586, 31590, 31598, 31609, 31640, 31709, 31768, 43033, 43035, 43037, 43039, 43042, 43443, 43445, 43447, 43459, 43475, 43489, 43499, 43507, 43518, 43540, 43548, 43574, 43584, 43591, 43595, 43612, 46271, 46273, 46284, 46292, 46299, 46311, 46323, 46336, 46357, 46361, 46369, 46373, 46383, 46389, 46393, 46397, 46401, 46403, 46431, 46506, 46524, 46543, 46552, 46564, 46580, 46585, 46590, 46607, 46612, 46614, 46622, 46634, 46637, 46639, 46657, 46676, 46688, 46695, 46697, 46708, 46716, 46718, 46732, 47010, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47040, 47042, 47044, 47046, 47516, 47528, 47534, 47538, 47542, 47546, 47550, 47554, 47556, 47569, 47574, 47579, 47583, 47585, 47592, 47728, 47751, 47758, 47773, 47781, 47786, 47791, 47796, 47804, 47829, 47876, 47907, 48018, 48021, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48054, 48058, 48060, 48065, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48120, 48122, 48128, 48130, 48132, 48136, 48138, 48145, 48149, 48153, 48157, 48161, 48169, 48173, 48175, 48177, 48181, 48185, 48208, 48215, 48222, 48235, 48256, 48263, 48277, 48291, 48298, 48310, 48319, 48340, 48401, 48415, 48429, 48448, 48458, 48459, 48471, 48483, 48487, 48492, 48498, 48499, 48501, 48502, 48503, 48504, 48505, 48507, 48508, 48511, 48512, 48513, 48516, 48522, 48523, 48528, 48538, 48544, 48552, 48558, 48560, 48568, 48570, 48572, 48576, 48582, 48587, 48589, 48593, 48597, 48599, 48604, 48606, 48610, 48612, 48622, 48624, 48632, 48638, 48644, 48646, 48648, 48658, 48668, 48680, 48756, 48762, 48790, 48847, 48855, 48864, 48928, 48987, 48994, 48999, 49011, 49025, 49030, 49045, 49047, 49060, 49062, 49085, 49133, 49134, 49153, 49162, 49165, 49167, 49170, 49172, 49175, 49187, 49207, 49231, 49257, 49267, 49281, 49301, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49410, 49424, 49444, 49451, 49521, 49559, 49582, 49584, 49586, 49591, 49601, 49626, 49651, 49654, 49656, 49658, 49660, 49665, 49668, 49669, 49670, 49672, 49675, 49677, 49678, 49679, 49680, 49682, 49683, 49685, 49686, 49687, 49688, 49690, 49691, 49694, 49695, 49696, 49698, 49699, 49700, 49702, 49703, 49705, 49706, 49707, 49708, 49709, 49710, 49711, 49712, 49713, 49715, 49717, 49718, 49720, 49721, 49722, 49723, 49724, 49725, 49726, 49727, 49728, 49729, 49730, 49731, 49732, 49734, 49735, 49736, 49737, 49738, 49739, 49740, 49741, 49742, 49743, 49744, 49745, 49746, 49747, 49748, 49749, 49750, 49751, 49752, 49753, 49763, 49769, 49771, 49784, 49808, 49824, 49828, 49840, 49904, 49932, 49944, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50078, 50091, 50096, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50137, 50145, 50152, 50155, 50157, 50165, 50171, 50176, 50188, 50194, 50197, 50202, 50209, 50212, 50217, 50218, 50219, 50220, 50228, 50352, 50367, 50369, 50375, 50379, 50381, 50390, 50397, 50399, 50403, 50407, 50409, 50417, 50421, 50429, 50448, 50525, 50530, 50555, 50594, 50597, 50599, 50600, 50605, 50607, 50611, 50616, 50628, 50632, 50638, 50640, 50663, 50694, 50703, 50711, 50714, 50724, 50763, 50764, 50766, 50813, 51106, 51109, 51111, 51113, 51115, 51120, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51248, 51251, 51253, 51680, 51682, 51685, 51687, 51749, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51807, 51821, 51824, 51837, 51844, 51848, 51863, 52084, 52086, 52088, 52091, 52092, 52095, 52103, 52105, 52111, 52115, 52117, 52125, 52127, 52143, 52149, 52153, 52163, 52171, 52175, 52201, 52203, 52211, 52213, 52215, 52220, 52224, 52226, 52233, 52238, 52240, 52244, 52254, 52261, 52266, 52281, 52334, 52340, 52342, 52388, 52390, 52395, 52397, 52448, 52455, 52467, 52480) 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: Piety In Pattens

Afterpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Song: As17930803

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Song: As17930803

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Song: As17930803

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Song: As17930803

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: Caernarvon Castle; or, The Birth of the Prince of Wales

Cast
Role: unassigned Actor: Cooke.

Performances

Mainpiece Title: The Mountaineers

Song: Mainpiece: As17930803

Performances

Mainpiece Title: The Mountaineers

Song: Mainpiece: Vocal Parts, as17930803, but _Little, _Brown, _Hobler, _Horsfall, _Saunders, _Dibble, _Lyons

Performances

Mainpiece Title: The Mountaineers

Song: As17930816

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Mountaineers

Song: As17930816

Performances

Mainpiece Title: The Flitch Of Bacon

Afterpiece Title: Tit for Tat

Performances

Mainpiece Title: The Mountaineers

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Comus

Song: As17930823

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Robbers Actor: Bannister, Davies, Cooke, Alfred

Afterpiece Title: The Village Lawyer

Performances

Afterpiece Title: Who's the Dupe

Performances

Afterpiece Title: The Humourist

Cast
Role: Blunt Actor: Cooke

Performances

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Busy Body

Cast
Role: Servants Actor: Waldron Jun., Cooke, Lyons

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Afterpiece Title: The First Floor

Cast
Role: Bite Actor: Cooke
Role: Snap Actor: Cooke

Performances

Afterpiece Title: The Children in the Wood

Afterpiece Title: Royal Clemency

Cast
Role: Officers Actor: Cooke, Caulfield

Performances

Mainpiece Title: The Busy Body

Cast
Role: Servants Actor: Waldron Jun., Cooke, Lyons

Afterpiece Title: Royal Clemency

Cast
Role: Officers Actor: Cooke, Caulfield

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Afterpiece Title: The Prize

Performances

Mainpiece Title: The Mountaineers

Cast
Role: Moors Actor: Usher, Cooke

Afterpiece Title: Who's the Dupe

Cast
Role: Bite Actor: Cooke
Role: Snap Actor: Cooke

Performances

Mainpiece Title: The Busy Body

Cast
Role: Servants Actor: Waldron Jun., Cooke, Lyons

Afterpiece Title: The Children in the Wood

Performances

Afterpiece Title: The Children in the Wood