SELECT * FROM london_stages WHERE eventid IN (9743, 23570, 23574, 23578, 23592, 23631, 23745, 24634, 33337, 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, 33820, 33828, 33832, 33834, 33838, 33842, 33844, 33846, 33852, 33878, 33904, 33927, 33975, 33981, 33990, 33995, 33997, 33999, 34001, 34004, 34006, 34009, 34011, 34013, 34015, 34018, 34025, 34029, 34034, 34068, 34073, 34086, 34089, 34094, 34131, 34174, 34181, 34198, 34220, 34230, 34240, 34253, 34255, 34259, 34264, 34267, 34340, 34345, 34347, 34349, 34356, 34362, 34368, 34373, 34375, 34377, 34380, 34384, 34390, 34394, 34401, 34415, 34429, 34432, 34436, 34441, 34450, 34453, 34455, 34485, 34521, 34593, 34598, 34601, 34604, 34607, 34612, 34620, 34622, 34635, 34637, 34648, 34665, 34668, 34670, 34694, 34697, 34713, 34721, 34723, 34725, 34728, 34739, 34744, 34750, 34754, 34759, 34768, 34778, 34782, 34785, 34792, 34794, 34805, 34807, 34810, 34813, 34818, 34938, 34946, 34950, 34958, 34960, 34962, 34964, 34967, 34969, 34971, 34973, 34976, 34978, 34981, 34983, 34985, 34987, 34990, 34995, 34997, 34999, 35001, 35004, 35006, 35009, 35011, 35013, 35046, 35054, 35061, 35063, 35065, 35067, 35069, 35071, 35073, 35077, 35095, 35098, 35100, 35273, 35336, 35352, 35582, 35588, 35593, 35596, 35601, 35616, 35625, 35627, 35632, 35648, 35657, 35663, 35666, 35668, 35673, 35675, 35684, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35811, 35866, 35875, 35877, 35880, 35893, 35895, 35898, 35900, 35906, 35911, 35914, 35923, 35935, 35941, 35953, 35958, 35971, 35982, 35987, 36132, 36136, 36332, 36334, 36337, 36339, 36342, 36344, 36346, 36348, 36351, 36353, 36356, 36358, 36360, 36368, 36371, 36478, 36512, 36524, 36536, 36664, 36672, 36676, 36681, 36693, 36746, 36748, 36755, 37037, 37045, 37056, 37108, 37228, 37230, 37236, 37267, 37269, 37273, 37275, 37277, 37318, 37325, 37327, 37330, 37339, 37348, 37355, 37358, 37379, 37381, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37583, 37590, 37593, 37619, 37631, 37641, 37649, 37663, 37672, 37674, 37782, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38129, 38144, 38335, 38338, 38346, 38350, 38352, 38354, 38362, 38365, 38368, 38370, 38377, 38379, 38416, 38430, 38444, 38458, 38465, 45760, 45762, 45768, 45772, 45774, 45776, 45808, 45822, 45834, 45837, 45843, 45845, 45849, 45855, 45859, 45861, 45868, 45870, 45875, 45882, 45884, 45896, 45908, 45927, 45936, 45941, 46087, 46114, 46267, 46276, 46280, 46283, 46291, 46300, 46302, 46304, 46310, 46318, 46320, 46322, 46332, 46334, 46335, 46339, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46364, 46366, 46390, 46400, 46404, 46408, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46451, 46461, 46463, 46468, 46470, 46473, 46477, 46480, 46482, 46487, 46489, 46494, 46496, 46510, 46521, 46528, 46532, 46535, 46546, 46556, 46577, 46592, 46613, 46633, 46641, 46653, 46675, 46677, 46687, 46701, 46704, 46720, 46848, 46851, 46859, 46872, 46878, 46880, 46884, 46890, 46892, 46894, 46908, 46912, 46920, 46924, 46932, 46936, 46970, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46988, 46990, 46992, 46996, 47006, 47008, 47010, 47012, 47014, 47018, 47020, 47024, 47026, 47032, 47038, 47044, 47054, 47065, 47070, 47072, 47075, 47087, 47097, 47113, 47116, 47127, 47130, 47182, 47197, 47206, 47211, 47225, 47237, 47246, 47254, 47263, 47276, 47278, 47288, 47486, 47488, 47490, 47498, 47500, 47504, 47506, 47516, 47528, 47532, 47534, 47536, 47538, 47540, 47542, 47544, 47546, 47548, 47550, 47554, 47556, 47560, 47565, 47569, 47574, 47576, 47579, 47583, 47585, 47588, 47592, 47602, 47608, 47615, 47627, 47632, 47634, 47642, 47648, 47650, 47652, 47654, 47658, 47660, 47671, 47673, 47679, 47689, 47728, 47736, 47753, 47758, 47766, 47773, 47781, 47786, 47788, 47791, 47799, 47804, 47807, 47812, 47814, 47819, 47822, 47824, 47829, 47832, 47837, 47842, 47847, 47852, 47854, 47857, 47862, 47864, 47866, 47868, 47871, 47884, 47889, 47899, 47901, 47904, 47905, 47908, 47911, 47913, 48003, 48005, 48011, 48013, 48018, 48021, 48031, 48035, 48037, 48040, 48042, 48054, 48060, 48063, 48065, 48073, 48075, 48077, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48108, 48110, 48112, 48114, 48122, 48128, 48136, 48138, 48143, 48145, 48149, 48153, 48157, 48161, 48169, 48171, 48173, 48175, 48181, 48185, 48203, 48208, 48213, 48215, 48217, 48222, 48256, 48265, 48274, 48277, 48288, 48298, 48310, 48312, 48314, 48319, 48326, 48328, 48333, 48335, 48338, 48340, 48343, 48351, 48365, 48367, 48369, 48379, 48390, 48401, 48406, 48415, 48420, 48422, 48424, 48426, 48429, 48431, 48436, 48763, 48765, 48773, 48979, 48981, 48983, 48985, 48987, 48992, 48994, 48997, 48999, 49001, 49003, 49006, 49008, 49011, 49013, 49015, 49017, 49020, 49022, 49025, 49027, 49030, 49032, 49037, 49040, 49045, 49047, 49052, 49055, 49060, 49062, 49068, 49073, 49080, 49085, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49117, 49119, 49194, 49198, 49200, 49202, 49205, 49207, 49210, 49213, 49218, 49223, 49225, 49227, 49230, 49231, 49249, 49253, 49255, 49257, 49261, 49267, 49269, 49271, 49273, 49279, 49281, 49285, 49297, 49299, 49301, 49304, 49306, 49311, 49320, 49323, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49358, 49361, 49363, 49365, 49367, 49370, 49375, 49377, 49379, 49381, 49384, 49389, 49391, 49395, 49403, 49407, 49412, 49415, 49417, 49419, 49424, 49426, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49508, 49512, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49538, 49555, 49559, 49564, 49577, 49611, 49624, 49769, 49771, 49773, 49774, 49778, 49782, 49784, 49790, 49795, 49802, 49808, 49812, 49820, 49824, 49828, 49830, 49838, 49840, 49844, 49846, 49850, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49882, 49887, 49896, 49901, 49904, 49911, 49918, 49928, 49932, 49937, 49946, 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, 50034, 50047, 50051, 50054, 50060, 50063, 50066, 50069, 50078, 50081, 50086, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50110, 50115, 50117, 50120, 50122, 50125, 50130, 50133, 50137, 50145, 50152, 50155, 50157, 50171, 50176, 50178, 50185, 50188, 50190, 50194, 50202, 50209, 50212, 50219, 50220, 50223, 50225, 50228, 50341, 50346, 50347, 50349, 50351, 50355, 50357, 50359, 50365, 50367, 50369, 50372, 50375, 50377, 50379, 50381, 50382, 50384, 50390, 50397, 50399, 50403, 50405, 50407, 50409, 50417, 50421, 50423, 50432, 50437, 50439, 50448, 50453, 50460, 50462, 50465, 50467, 50469, 50471, 50474, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50525, 50528, 50530, 50533, 50535, 50537, 50542, 50545, 50555, 50558, 50570, 50572, 50577, 50580, 50582, 50585, 50587, 50590, 50594, 50599, 50608, 50610, 50634, 50639, 50643, 50651, 50663, 50670, 50683, 50694, 50701, 50703, 50706, 50718, 50746, 50791, 50799, 50801, 50811, 51106, 51109, 51111, 51113, 51115, 51120, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51233, 51236, 51240, 51260, 51262, 51267, 51270, 51279, 51284, 51287, 51294, 51299, 51301, 51311, 51321, 51323, 51326, 51328, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51377, 51380, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51542, 51546, 51582, 51609, 51982, 51984, 52117, 52303, 52317, 52329, 52359, 52418, 52425, 52429, 52432, 52439, 52442, 52447, 52452, 52456, 52461, 52466, 52476, 52504, 52511) 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 Tempest

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Song: As17891117

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Tempest

Song: As17891117, but the Masque of Neptune and Amphitrite-_Sedgwick, Neptune- +Shaw

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Cast
Role: Quildrive Actor: Banks

Dance: As17891204

Song: In Opera: a new song-Sga Storace

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Cast
Role: Quildrive Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Cast
Role: Quildrive Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Cast
Role: Quildrive Actor: Banks

Dance: As17891204

Performances

Mainpiece Title: As You Like It

Cast
Role: sic] Actor: Banks

Afterpiece Title: Polly Honeycombe

Dance: As17900210

Song: As17890922

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Harlequin Actor: Banks

Performances

Mainpiece Title: As You Like It

Cast
Role: sic] Actor: Banks

Afterpiece Title: Polly Honeycombe

Dance: As17900210

Song: As17890922

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Cast
Role: Quildrive Actor: Banks

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Silvertongue Actor: Banks

Afterpiece Title: The Spoil'd Child