SELECT * FROM london_stages WHERE eventid IN (20166, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20242, 20248, 20292, 20295, 20311, 20326, 20347, 20359, 20398, 20415, 20421, 20438, 20461, 20805, 20814, 20817, 20832, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21099, 21103, 21119, 21172, 21184, 21525, 21532, 21538, 21545, 21588, 21599, 21615, 21683, 21793, 22020, 22025, 22028, 22033, 22035, 22039, 22057, 22076, 22193, 22216, 22316, 22446, 22459, 22468, 22478, 22484, 22494, 22497, 22543, 22559, 22621, 22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22759, 22764, 22795, 22966, 22969, 24292, 24298, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24764, 24771, 24775, 24779, 24789, 24796, 24799, 25127, 25133, 25142, 25153, 25164, 25170, 25182, 25185, 25195, 29856, 31368, 31380, 31403, 31437, 31698, 31745, 31783, 31792, 31793, 31804, 31806, 31809, 31814, 31823, 31857, 31881, 31889, 31897, 31909, 31925, 31932, 31935, 31937, 31941, 31946, 31951, 31972, 31982, 32003, 32030, 32036, 32041, 32066, 32076, 32083, 32086, 32090, 32095, 32111, 32114, 32148, 32152, 32158, 32171, 32181, 32184, 32198, 32204, 32206, 32211, 32221, 32233, 32235, 32252, 32256, 32319, 32334, 32344, 32354, 32356, 32364, 32376, 32380, 32393, 32411, 32416, 32452, 32471, 32484, 32490, 32493, 32498, 32504, 32509, 32512, 32518, 32521, 32558, 32588, 32593, 32600, 32613, 32635, 32639, 32642, 32653, 32683, 32701, 32708, 32710, 32734, 32743, 32748, 34259, 34260, 34265, 34268, 34271, 34273, 34274, 34276, 34278, 34279, 34281, 34284, 34285, 34286, 34288, 34290, 34292, 34293, 34294, 34295, 34296, 34298, 34300, 34301, 34302, 34303, 34305, 34306, 34307, 34310, 34311, 34312, 34316, 34318, 34320, 34321, 34323, 34325, 34326, 34327, 34329, 34331, 34332, 34333, 34334, 34512, 35557, 38272, 38273, 38308, 38314, 38322, 38328, 38338, 38348, 38374, 38377, 38379, 38384, 38391, 38393, 38395, 38400, 38405, 38406, 38480, 38497, 38597, 38614, 38710, 38725, 38735, 38737, 38762, 38770, 38780, 38807, 38813, 38814, 38818, 38819, 38820, 38821, 38822, 38823, 38824, 38825, 38827, 38829, 38830, 38832, 38833, 38836, 38837, 38843, 38848, 38849, 38854, 38855, 38857, 38859, 38880, 38881, 38884, 38892, 38898, 38902, 38913, 38917, 38919, 38921, 38933, 38938, 38959, 38963, 38985, 39009, 39021, 39044, 39046, 39063, 39066, 39068, 39073, 39091, 39094, 39101, 39105, 39122, 39129, 39133, 39136, 39138, 39143, 39147, 39152, 39157, 39161, 39166, 39172, 39178, 39185, 39191, 39203, 39206, 39209, 39220, 39226, 39231, 39261, 39274, 39281, 39283, 39292, 39294, 39304, 39309, 39310, 39334, 39336, 39338, 39342, 39348, 39351, 39355, 39376, 39383, 39388, 39392, 39398, 39399, 39400, 39401, 39402, 39403, 39404, 39405, 39410, 39413, 39417, 39419, 39421, 39422, 39424, 39425, 39426, 39427, 39428, 39429, 39430, 39431, 39432, 39434, 39435, 39436, 39437, 39438, 39439, 39441, 39442, 39443, 39444, 39448, 39452, 39463, 39464, 39467, 39477, 39492, 39496, 39507, 39512, 39542, 39573, 39575, 39577, 39579, 39584, 39587, 39589, 39593, 39596, 39598, 39601, 39606, 39608, 39612, 39614, 39619, 39624, 39630, 39644, 39652, 39654, 39656, 39661, 39676, 39679, 39681, 39685, 39698, 39705, 39714, 39717, 39722, 39746, 39755, 39773, 39787, 39798, 39827, 39841, 39848, 39850, 39855, 39858, 39860, 39864, 39867, 39876, 39878, 39884, 39887, 39890, 39895, 39905, 39920, 39922, 39927, 39928, 39932, 39934, 39943, 39945, 39946, 39950, 39952, 39955, 39956, 39958, 39959, 39965, 39967, 39969, 39971, 39976, 39980, 39983, 39991, 39994, 39997, 40002, 40003, 40004, 40007, 40010, 40024, 40032, 40038, 40040, 40051, 40057, 40059, 40075, 40079, 40083, 40085, 40105, 40156, 40170, 40173, 40188, 40195, 40197, 40208, 40212, 40217, 40226, 40236, 40243, 40254, 40259, 40279, 40285, 40292, 40305, 40316, 40326, 40331, 40338, 40369, 40396, 40406, 40424, 40448, 40450, 40465, 40467, 40469, 40471, 40472, 40473, 40479, 40480, 40481, 40483, 40486, 40487, 40489, 40492, 40494, 40495, 40496, 40498, 40499, 40500, 40501, 40502, 40503, 40504, 40506, 40507, 40508, 40509, 40510, 40511, 40512, 40513, 40514, 40516, 40517, 40518, 40519, 40520, 40523, 40524, 40525, 40526, 40527, 40529, 40531, 40532, 40533, 40534, 40536, 40538, 40539, 40540, 40542, 40543, 40544, 40545, 40546, 40547, 40548, 40549, 40550, 40551, 40552, 40553, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40562, 40584, 40587, 40593, 40602, 40604, 40608, 40611, 40617, 40619, 40634, 40638, 40644, 40651, 40658, 40672, 40688, 40711, 40712, 40714, 40719, 40734, 40741, 40772, 40813, 40819, 40856, 40866, 40880, 40891, 40895, 40898, 40900, 40902, 40907, 40912, 40917, 40920, 40933, 40938, 40951, 40980, 40985, 40999, 41010, 41197, 41459, 41520, 41552, 41557, 41559, 41988, 42735, 43437, 43679, 44861, 45537, 45547, 45836, 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, 46492, 46511, 46536, 46566, 46593, 46700, 46711, 46729, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46909, 47063, 47198, 47289, 47309, 47320, 47326, 47582, 47584, 47586, 47587, 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, 48278, 48285, 48289, 48294, 48299, 48349, 48416, 48418, 48443, 48747, 48749, 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, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49051, 49053, 49056, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49445, 49449, 49454, 49462, 49642, 49797, 49801, 49811, 49819, 49837, 49849, 49937, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49980, 49982, 49983, 49984, 49985, 49986, 49987, 49988, 49989, 49991, 49993, 49994, 49997, 49998, 50000, 50001, 50003, 50004, 50005, 50006, 50009, 50010, 50012, 50013, 50015, 50016, 50018, 50019, 50022, 50023, 50025, 50026, 50028, 50029, 50030, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50070, 50079, 50089, 50092, 50101, 50104, 50105, 50107, 50115, 50117, 50120, 50122, 50128, 50130, 50134, 50137, 50148, 50166, 50205, 50208, 50367, 50369, 50375, 50379, 50381, 50390, 50397, 50399, 50403, 50409, 50417, 50511, 50592, 50596, 50601, 50610, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50687, 50689, 50692, 50706, 50713, 50730, 50735, 50743, 50746, 50748, 50751, 50761, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50960, 50964, 50974, 51004, 51015, 51035, 51044, 51051, 51089, 51103, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51132, 51134, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51174, 51178, 51181, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51220, 51222, 51233, 51236, 51240, 51248, 51251, 51253, 51260, 51262, 51267, 51270, 51272, 51279, 51284, 51287, 51294, 51297, 51299, 51301, 51311, 51321, 51323, 51326, 51328, 51335, 51337, 51344, 51348, 51353, 51362, 51364, 51369, 51371, 51375, 51377, 51380, 51387, 51499, 51502, 51504, 51507, 51509, 51513, 51516, 51517, 51520, 51526, 51534, 51542, 51546, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51570, 51572, 51582, 51586, 51590, 51595, 51602, 51604, 51614, 51616, 51623, 51626, 51633, 51638, 51640, 51642, 51647, 51649, 51749, 51750, 51752, 51754, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51787, 51791, 51807, 51817, 51819, 51820, 51821, 51824, 51825, 51828, 51830, 51832, 51833, 51836, 51837, 51841, 51844, 51848, 51850, 51855, 51863, 51868, 51872, 51876, 51878, 51913, 51914, 52084, 52086, 52088, 52091, 52092, 52095, 52103, 52105, 52111, 52115, 52117, 52125, 52127, 52143, 52149, 52153, 52163, 52171, 52175, 52201, 52203, 52334, 52340, 52519) 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 Rehearsal

Afterpiece Title: Harlequin Shipwrecked

Dance: Mlle Auguste (who never appeared on the English stage before); The Swiss, as17410926

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Shipwrecked

Song: I: The Early Horn-Lowe; III: Happy Pair-Beard

Dance: II: A Dutch Dance, as17411114; IV: A New Dance The Italian Peasants-the Mechels

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: Harlequin Shipwrecked

Song: I: Early Horn-Lowe; III: Happy Pair-Beard

Dance: II: Sailor's Dance, as17411015; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: Cato

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: Was ever Nymph like Rosamund-Beard

Dance: II: a Tambourine-Mlle Mechel; IV: Les Matelotes, as17411110, but-the Mechels

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Harlequin Shipwrecked

Song: I: Was Ever Nymph Like Rosamund-Beard; III: The Early Horn-Lowe

Dance: II: a Tambourine-Mlle Mechel; IV: The Swiss, as17410926

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: Harlequin Shipwrecked

Song: I: A New Ballad-Beard; III: Noontide Air-Lowe; IV: Mad Tom by Henry Purcel-Beard in character

Dance: II: A Dutch Dance, as17411114; V: The Italian Peasants, as17411207

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: Harlequin Shipwrecked

Song: II: Noontide Air-Lowe; IV: Happy Pair-Beard

Dance: I: Sailor's Dance, as17411015; III: The Swiss, as17410926

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Shipwrecked

Song: I: Was Ever Nymph like Rosamund-Beard; III: The Early Horn-Lowe

Dance: II: A Dutch Dance, as17411114; IV: The Swiss, as17410926

Performances

Mainpiece Title: The Spanish Friar

Afterpiece Title: Harlequin Shipwrecked

Song: I: Was ever Nymph like Rosamond-Lowe; III: a New Ballad-Lowe

Dance: II: Tambourine-Mlle Mechel; V: The Italian Peasants, as17411207

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin Shipwrecked

Song: I: New Ballad-Lowe; III: Happy Pair-Lowe

Dance: II: Dutch Dance-Philips, Miss Scott; V: The Swiss-M Mechell, Mlle Mechell

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Harlequin Shipwrecked

Song: I: See from the Silent Groves-Beard

Dance: III: A Dutch Dance, as17411114; II: Les Matelotes, as17411208; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; II: Early Horn-Lowe

Dance: III: The Drunken Peasant, as17411029; IV: A Dutch Dance, as17411114; V: The Swiss, as17410926

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Shipwrecked

Dance: I: A Dutch Dance, as17411114; II: The Swiss, as17410929

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Harlequin Shipwrecked

Song: I: A Ballad-Lowe

Dance: II: A Concerto, as17420105; III: A Dutch Dance, as17411114; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Shipwrecked

Dance: I: A Sailor's Dance, as17411015; II: The Italian Peasants, as17411205; Hornpipe-Philips

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Harlequin Shipwrecked

Dance: I: The French Peasants-the Mechels; III: A Dutch Dance, as17411114; IV: Les Matelotes, as17411208

Song: II: Happy Pair-Beard

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: A Ballad-Lowe

Dance: II: A Sailor's Dance, as17411015; IV: The Swiss-the Mechels

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: a Ballad-Lowe

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Shipwrecked

Song: I: a Ballad-Lowe; III: Happy Pair-Beard

Dance: II: The French Peasants, as17420116; IV: The Swiss, as17420119

Performances

Mainpiece Title: Volpone

Afterpiece Title: Harlequin Shipwrecked

Song: II: Was Ever Nymph like Rosamond-Beard; IV: a Ballad-Lowe

Dance: I: Les Matelotes, as17411208

Performances

Mainpiece Title: The Silent Woman

Afterpiece Title: Harlequin Shipwrecked

Song: I: Song-Beard

Dance: II: A Concerto, as17420105; III: A Dutch Dance, as17411114; IV: The Swiss, as17420119

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Harlequin Shipwrecked

Song: I: Sylvia don't Refuse your Bloom a new song of Mr Arne's-Lowe; III: Song-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: The Harlot's Progress

Song: I: Sylvia wilt thou was e thy Prime, a new song of Mr Arne's,-Lowe; III: Was ever nymph like Rosamond-Lowe

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: Harlequin Shipwrecked

Song: I: Sylvia wilt thou was e thy Prime-Lowe; III: a Song with French Horns-Beard

Dance: II: The Italian Peasants, as17411205; IV: a New Dance call'd Les Pelerins Voyageur-the Mechels

Performances

Mainpiece Title: All's Well That Ends Well

Afterpiece Title: Harlequin Shipwrecked

Song: I: Celia has ten thousand charms-Beard; III: Song with French Horns-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205