SELECT * FROM london_stages WHERE eventid IN (12463, 12826, 20359, 20755, 20757, 20760, 20802, 20814, 20817, 20832, 20835, 20838, 20841, 20845, 20854, 20875, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20964, 20967, 20973, 20980, 20984, 20986, 20990, 20993, 20997, 21000, 21007, 21010, 21013, 21017, 21020, 21027, 21037, 21041, 21045, 21059, 21072, 21079, 21083, 21086, 21092, 21096, 21099, 21103, 21109, 21112, 21116, 21119, 21126, 21136, 21143, 21146, 21157, 21172, 21184, 21202, 21298, 23333, 26200, 26203, 26215, 26219, 26221, 26231, 26265, 26270, 26274, 26280, 26282, 26284, 26287, 26300, 26599, 32027, 32029, 32031, 32033, 32035, 32037, 32040, 32042, 32046, 32048, 32050, 32052, 32055, 32058, 32060, 32062, 32064, 32067, 32069, 32072, 32075, 32077, 32079, 32082, 32084, 32087, 32089, 32091, 32122, 32125, 32127, 32129, 32132, 32137, 32141, 32250, 32867, 32869, 32871, 32873, 32877, 32881, 32883, 32889, 32891, 32897, 32899, 32902, 32907, 32909, 32918, 32921, 32923, 32927, 32931, 32936, 32940, 32948, 32959, 32961, 32963, 33155, 33190, 33307, 33313, 33318, 33328, 33337, 33356, 33359, 33361, 33363, 33365, 33368, 33370, 33373, 33375, 33377, 33379, 33384, 33389, 33393, 33396, 33398, 33401, 33403, 33407, 33419, 33436, 33440, 33442, 33444, 33447, 33449, 33452, 33454, 33475, 33477, 33482, 33484, 33490, 33492, 33525, 33530, 33539, 33551, 33553, 33558, 33560, 33571, 33573, 33581, 33586, 33593, 33602, 33614, 33658, 33672, 33674, 33711, 33842, 33844, 33846, 33852, 33854, 33856, 33863, 33865, 33904, 33927, 33975, 33981, 33990, 34073, 34086, 34131, 34174, 34220, 34240, 34255, 34264, 35663, 35673, 35675, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 36132, 36136, 36351, 36353, 36356, 36358, 36360, 36368, 36371, 36664, 36672, 36676, 36681, 36693, 37583, 37590, 37619, 37631, 37641, 37672, 37674, 38416, 38430, 38444, 38458, 38497, 39456, 39458, 39461, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39876, 39881, 39889, 40040, 40042, 40044, 40046, 40048, 40053, 40059, 40061, 40071, 40073, 40093, 40099, 40121, 40135, 40140, 40149, 40173, 40179, 40181, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40279, 40311, 40316, 40323, 40326, 40331, 40358, 40367, 40379, 40382, 40413, 40425, 40431, 40454, 42670, 43079, 43081, 43084, 43093, 43098, 43104, 43115, 43127, 43143, 43229, 43232, 43263, 43321, 43439, 43446, 43453, 43460, 43494, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46566, 46593, 46700, 46711, 46729, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46905, 46909, 46917, 46941, 46949, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47063, 47081, 47198, 47202, 47289, 47306, 47309, 47312, 47315, 47320, 47326, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47649, 47665, 47688, 47690, 48015, 48023, 48032, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48170, 48172, 48174, 48178, 48180, 48182, 48278, 48285, 48289, 48294, 48299, 48349, 48650, 48672, 48712, 48722, 48737, 48747, 48749, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48837, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49594, 49612, 49635, 49640, 49650, 49655, 49662, 49667, 49801, 49811, 49837, 49849, 49980, 49983, 49985, 49987, 49989, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50104, 50111, 50128, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50161, 50166, 50170, 50177, 50184, 50186, 50189, 50203, 50205, 50215, 50374, 50380, 50385, 50387, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50688, 50690, 50695, 50702, 50707, 50714, 50724, 50736, 50742, 50744, 50764, 50772, 50790, 50802, 50805, 50812, 51509, 51513, 51517, 51877, 51914, 51927, 51929) 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: A Day In Turkey

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Blue Beard

Dance: As17920111

Song: Juliet's Funeral Procession, as17910926; Solemn Dirge, as17910926; Vocal Parts, as17920926, but _Lee, Rowson, Mrs _Davenett

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Dance: As17920111

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Blue Beard

Dance: As17920111

Song: Vocal Parts, as17911010, but Gray, _Williamson, +Rowson, _Lee

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Blue Beard

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Blue Beard; or, The Flight of Harlequin

Dance: In afterpiece: Dancing-Byrn, Platt, Ratchford

Song: End IV: Juliet's Funeral Procession-; with the Solemn Dirge Vocal Parts-Johnstone, Incledon, Darley, Gray, Rock, Lee, Letteney, Mrs Blanchard, Mrs Harlowe, Miss Stuart, Miss Barnett, Mrs Arnold, Mrs Cross, Miss Leserve, Mrs Davenett, Mrs Watts, Mrs Gray, Miss Francis, Mrs Masters, Miss Broadhurst

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Blue Beard

Dance: Dancing, as17921008, but _Ratchford, Holland

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Blue Beard

Dance: As17921015

Song: Juliet's Funeral Procession-; the Solemn Dirge, as17921008, but Mrs Martyr

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Punch Actor: Rayner

Dance: As17921226