SELECT * FROM london_stages WHERE eventid IN (147, 234, 270, 450, 975, 1136, 1235, 1236, 1237, 1239, 1259, 1262, 1263, 1284, 1291, 1292, 1296, 1302, 1318, 1319, 1337, 1356, 1373, 1401, 1419, 1447, 1451, 1522, 1523, 1777, 1779, 1780, 1786, 1794, 1814, 1825, 4616, 6014, 10012, 10833, 13026, 13044, 13048, 13057, 13120, 13124, 13153, 15815, 15821, 15824, 15827, 15871, 15876, 15880, 15884, 15891, 15910, 15953, 16008, 16016, 16070, 16091, 16097, 16135, 16147, 16327, 16336, 16368, 16387, 16497, 16530, 16550, 16703, 16707, 16710, 16714, 16718, 16722, 16727, 16731, 16734, 16741, 16745, 16749, 16754, 16758, 16793, 16797, 16813, 16816, 16820, 16824, 16838, 16842, 16846, 16851, 16867, 16907, 16911, 16939, 16942, 16946, 16950, 16953, 16957, 16961, 16966, 16970, 16974, 16978, 16982, 16986, 16990, 16994, 16998, 17003, 17007, 17012, 17016, 17020, 17025, 17031, 17035, 17039, 17045, 17056, 17061, 17099, 17124, 17253, 17269, 17273, 17393, 17413, 17446, 17449, 17456, 17485, 17488, 17492, 17494, 17497, 17506, 17510, 17512, 17515, 17518, 17526, 17530, 17532, 17535, 17537, 17538, 17540, 17541, 17546, 17552, 17555, 17561, 17565, 17568, 17571, 17575, 17578, 17582, 17587, 17595, 17597, 17601, 17609, 17612, 17617, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17651, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17709, 17711, 17712, 17715, 17719, 17721, 17722, 17724, 17725, 17728, 17729, 17731, 17732, 17735, 17736, 17739, 17742, 17746, 17748, 17754, 17759, 17761, 17765, 17770, 17776, 17782, 17783, 17786, 17791, 17795, 17796, 17851, 17856, 17861, 17862, 17867, 17875, 17880, 17885, 17892, 17897, 17922, 17927, 17940, 17948, 17955, 17966, 17970, 17999, 18009, 18012, 18026, 18030, 18051, 18123, 18171, 18190, 18193, 18196, 18199, 18202, 18203, 18206, 18210, 18214, 18216, 18226, 18228, 18231, 18233, 18239, 18241, 18244, 18248, 18250, 18251, 18253, 18257, 18259, 18273, 18275, 18277, 18278, 18280, 18281, 18283, 18286, 18288, 18289, 18292, 18295, 18299, 18303, 18306, 18309, 18317, 18320, 18324, 18329, 18332, 18335, 18336, 18338, 18339, 18342, 18346, 18348, 18349, 18353, 18355, 18356, 18358, 18361, 18362, 18365, 18366, 18368, 18369, 18373, 18376, 18377, 18380, 18382, 18383, 18385, 18386, 18388, 18389, 18391, 18392, 18398, 18399, 18403, 18405, 18409, 18412, 18444, 18446, 18460, 18468, 18477, 18481, 18484, 18490, 18493, 18494, 18497, 18504, 18505, 18516, 18517, 18521, 18525, 18535, 18540, 18543, 18547, 18559, 18590, 18594, 18604, 18609, 18616, 18622, 18631, 18648, 18652, 18659, 18679, 18688, 18701, 18705, 18725, 18763, 18774, 18800, 18842, 19036, 19041, 19043, 19065, 19075, 19123, 19149, 19245, 19251, 19255, 19261, 19263, 19271, 19281, 19283, 19285, 19291, 19293, 19295, 19300, 19302, 19310, 19314, 19316, 19319, 19321, 19323, 19325, 19327, 19329, 19331, 19333, 19335, 19337, 19339, 19341, 19343, 19349, 19351, 19378, 19380, 19382, 19384, 19387, 19389, 19391, 19395, 19408, 19410, 19412, 19421, 19426, 19465, 19474, 19479, 19481, 19483, 19485, 19487, 19500, 19537, 19591, 19596, 19612, 19662, 19665, 19668, 19672, 19678, 19680, 19682, 19684, 19686, 19688, 19746, 19754, 19787, 19790, 19794, 19799, 19801, 19821, 19833, 19835, 19851, 19856, 19866, 19869, 19872, 19875, 19879, 19882, 19889, 19900, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20154, 20156, 20158, 20161, 20164, 20167, 20170, 20173, 20176, 20179, 20197, 20198, 20200, 20207, 20212, 20215, 20234, 20240, 20259, 20290, 20299, 20302, 20330, 20344, 20348, 20351, 20360, 20370, 20373, 20382, 20402, 20416, 20419, 20420, 20422, 20426, 20430, 20442, 20446, 20449, 20458, 20462, 20466, 20469, 20483, 20487, 20498, 20501, 20506, 20511, 20517, 20521, 20543, 20555, 20559, 20568, 20571, 20577, 20581, 20608, 20611, 20651, 20706, 20733, 20740, 20743, 20747, 20754, 20758, 20761, 20770, 20772, 20775, 20778, 20787, 20790, 20797, 20798, 20800, 20801, 20803, 20804, 20806, 20807, 20813, 20815, 20818, 20819, 20821, 20823, 20824, 20826, 20827, 20830, 20834, 20837, 20840, 20842, 20843, 20846, 20847, 20849, 20850, 20853, 20855, 20856, 20858, 20859, 20861, 20862, 20865, 20866, 20868, 20869, 20873, 20874, 20876, 20877, 20879, 20880, 20884, 20887, 20893, 20896, 20897, 20899, 20900, 20903, 20904, 20906, 20912, 20918, 20923, 20933, 20935, 20936, 20938, 20939, 20942, 20945, 20949, 20952, 20956, 20961, 20965, 20968, 20971, 20974, 20991, 20994, 21001, 21005, 21008, 21011, 21021, 21022, 21025, 21028, 21031, 21034, 21038, 21039, 21042, 21043, 21052, 21060, 21070, 21073, 21077, 21080, 21084, 21087, 21093, 21104, 21110, 21111, 21113, 21117, 21127, 21128, 21131, 21133, 21140, 21141, 21144, 21151, 21154, 21158, 21162, 21169, 21178, 21185, 21189, 21197, 21206, 21210, 21213, 21221, 21243, 21244, 21251, 21258, 21282, 21294, 21299, 21311, 21312, 21319, 21329, 21373, 21393, 21522, 21525, 21532, 21538, 21545, 21549, 21552, 21555, 21558, 21560, 21562, 21565, 21571, 21577, 21582, 21588, 21599, 21603, 21612, 21615, 21618, 21620, 21624, 21627, 21630, 21633, 21639, 21648, 21652, 21660, 21665, 21668, 21671, 21675, 21678, 21683, 21688, 21707, 21756, 21793, 21800, 21828, 21840, 22316, 22319, 22322, 24294, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 25837, 26134, 28683, 36789, 38309, 40277, 40287, 40290, 40299, 40303, 40313, 40318, 40328, 40332, 40342, 40347, 40811, 40814, 40823, 40826, 40836, 40840, 40850, 40854, 40864, 40867, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483, 42056, 42061, 42387, 42627, 42792, 43680, 43691, 43694, 43704, 43710, 43724, 43738, 43749, 43754, 44700, 45960, 46343, 46381, 46389, 47479, 48278, 48285, 48637, 48669, 48687, 48695, 48699, 48715, 48717, 48727, 48729, 48739, 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, 48860, 48865, 48868, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48945, 48947, 48952, 48959, 48961, 48971, 48980, 48986, 48988, 48990, 48993, 49002, 49007, 49009, 49014, 49018, 49021, 49023, 49033, 49038, 49041, 49043, 49053, 49056, 49058, 49061, 49066, 49072, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49092, 49095, 49100, 49193, 49197, 49199, 49201, 49206, 49208, 49211, 49214, 49217, 49219, 49222, 49224, 49226, 49228, 49229, 49232, 49236, 49250, 49252, 49256, 49258, 49260, 49262, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49430, 49432, 49434, 49439, 49449, 49452, 49454, 49458, 49462, 49465, 49478, 49504, 49517, 49556, 49558, 49583, 49597, 49599, 49607, 49609, 49614, 49620, 49625, 49632, 49637, 49644, 49649, 49653, 49657, 49659, 49664, 49754, 49761, 49766, 49768, 49777, 49783, 49785, 49788, 49791, 49796, 49799, 49801, 49803, 49813, 49817, 49819, 49835, 49843, 49845, 49849, 49853, 49857, 49869, 49873, 49877, 49886, 49891, 49893, 49895, 49900, 49902, 49910, 49917, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50111, 50113, 50116, 50121, 50123, 50126, 50141, 50143, 50151, 50153, 50156, 50161, 50163, 50170, 50172, 50175, 50177, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50215, 51235) 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 Way Of The World

Dance: Entertainments-Picq, Desnoyer, Sga Barberina, Dubuisson, Villeneuve, Mlle Auguste, Mlle Bonneval, Sga Domitilla; Chacone, as17411230; La Provencale-Picq, Mlle Auguste, Villeneuve, Delagarde, Destrade, Dupre, Mrs Wright, Mrs LeBrun, Mrs Villeneuve, Mlle Maudet

Ballet: RRural Assembly. As17420121

Performances

Afterpiece Title: Lethe

Dance: As17420115

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Orpheus and Eurydice

Performances

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: Rule A Wife

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Dance: Entertainments-Picq, Denoyer, Sga Barberina, Duibuisson, Villeneuve, Mlle Auguste, Mlle Bonneval, Sga Domitilla; Tyrolean Dance between a Hungarian and two Tyrolese,-Denoyer, Picq, Sga Barbarina; Tambourine-Picq, Mlle Auguste

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Funeral

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Orpheus and Eurydice

Dance: TTambourine-Mlle Auguste; Tyrolean Dance, as17420206

Performances

Mainpiece Title: The Stratagem

Dance: Entertainments, as17420206, but _Duibuisson, _Villeneuve, Mlle _Bonneval, Sga _Domitilla; Tyrolean Dance, as17420206; Tambourine, as17420206; The Peasants-Picq, Mlle Auguste

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: As You Like It

Dance: Entertainments, as17420210, but Dubuisson, Mme +Bonneval; +Chacone, as17411230; Saraband-Sga Barbarina; La Provencale, as17420212

Ballet: After: Rural Assembly. As17420121

Performances

Mainpiece Title: The Miser

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Mistake

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Honest Yorkshireman

Dance: As17420210

Performances

Mainpiece Title: 2 Henry Iv

Dance: 2 As17420213, but Chacone-_; The Peasants, as17420210

Ballet: 2 RRural Assembly. As17420121

Performances

Mainpiece Title: The Gamester

Dance: Entertainments, as17420220; Peasants, as17420220; Grand Ballet call'd Mars and Venus-Mars-Desnoyer, +Venus- Sga Barbarina, +Their followers- Villeneuve, Richardson, Delegarde, Dupre, Destrade, Davenport, Mrs Wright, Mlle Fabrez, Mrs LeBrun, Mlle Rhenos, Mlle Maudet, Mrs LeFont

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Fair Quaker Of Deal; Or, The Humours Of The Navy

Afterpiece Title: Orpheus and Eurydice

Performances

Afterpiece Title: The School Boy

Dance: A new Scots Dance-Master Granier, Miss Granier

Performances

Mainpiece Title: Pamela

Afterpiece Title: The School Boy

Dance: As17420213

Performances

Mainpiece Title: She Wou'd If She Cou'd

Dance: TTyrolean Dance, as17420206; The Peasants, as17420210

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Unhappy Favourite

Dance: TTyrolean Dance, as17420206; The Peasants, as17420210

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Harlequin Englishman

Performances

Mainpiece Title: The Way Of The World

Dance: TTyrolean Dance, as17420206; A New Dance call'd Les Amants Heureux-Desnoyer, Sga Barberina

Ballet: RRural Assembly. As17420121