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: 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

Dance: LLe Boufon, as17411030; Les Masons et Les Sabotiers, as17411218

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fortune Tellers

Cast
Role: Gipsies Actor: Bride, Green, Rayner, Gray

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

Dance: II: A Dutch Dance, as17411114; IV: Matelote Polonnes-Mechel

Performances

Dance: I: The Drunken Peasant, as17411029; II: A Dutch Dance, as17411014;

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Harlequin Shipwrecked (from Rylands MS

Cast
Role: Gipsies Actor: Bride, Green, Rayner, Gray

Song: I: Bright Author of My Present Flame-Lowe; III: The Early Horn-Lowe

Dance: II: A Concerto-Mlle Mechel; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Committee

Dance: LLes Matelotes, as17411110

Ballet: New Dance (never perform'd before) call'd% Les Satires Puny. Peasants-Sg and Sga Fausan; Satyrs-Delamain, Dumont, Leviez, Baudoin; Shepherds-LeCroix, Desse, Constantini, Rayner; Shepherdesses-Mrs Walter, Mrs Thompson, Miss Story, Mrs Rayner

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Fortune Tellers

Dance: LLes Matelotes, as17411110

Ballet: lso% Les Satires Puny. As17420106

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 Committee

Dance: LLes Masons et Les Sabotiers, as17411218

Ballet: LLes Satires Puny. As17420106

Performances

Mainpiece Title: The Merchant Of Venice

Song: I: See from the Silent Groves-Beard

Dance: II: Les Matelotes, as17411110

Ballet: V: Les Satires Puny. As17420106

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: The Constant Couple

Song: I: The Early Horn-Lowe; III: A Ballad-Beard

Dance: II: Les Matelotes, as17411110

Ballet: V: Les Satires Puny. As17420106

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: The Constant Couple

Song: I: A Ballad-Beard; III: Bright Author of my Present Flame-Lowe

Dance: II: Les Matelotes, as17411110

Ballet: V: Les Satires Puny. As17420106

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: The Constant Couple

Dance: LLes Jardiniers Suedois, as17411128

Ballet: LLes Satires Puny. As17420106

Performances

Mainpiece Title: The Rehearsal

Dance: LLa Foullies-the Fausans

Ballet: LLes Satires Puny. As17420106

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 Busy Body

Song: I: A Ballad-Lowe; IV: The Early Horn-Lowe

Dance: II: La Foullies, as17420125

Ballet: V: Les Satires Puny. As17420106

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: The Rehearsal

Dance: I: A Concerto, as17420105; II: The Drunken Peasant-Phillips; III: A Dutch Dance, as17411114; IV: Les Matelotes, as17411208

Ballet: V: Les Satires Puny. As17420106