SELECT * FROM london_stages WHERE eventid IN (1007, 1124, 1129, 1159, 1172, 1174, 1207, 1282, 1287, 1294, 1329, 1545, 1716, 1777, 1828, 2005, 2006, 2020, 2022, 2040, 2047, 2071, 2217, 2326, 3357, 3815, 5147, 6888, 7120, 7344, 9870, 12067, 13247, 13308, 13311, 13356, 13555, 13559, 14732, 14733, 14743, 14803, 14862, 14884, 16455, 16551, 17192, 17274, 17312, 17716, 17806, 17910, 18224, 18229, 18233, 18237, 18242, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18278, 18281, 18283, 18286, 18289, 18292, 18295, 18300, 18303, 18307, 18310, 18314, 18318, 18432, 18437, 18444, 18447, 18450, 18605, 18610, 18617, 18628, 18685, 18718, 18894, 18897, 18904, 19101, 19212, 19217, 19223, 19245, 19251, 19255, 19261, 19263, 19271, 19300, 19351, 19391, 19548, 19591, 19596, 19612, 19633, 20120, 21738, 21742, 21745, 21749, 21867, 21869, 21873, 21875, 21877, 21879, 21885, 21890, 21891, 21894, 21899, 21909, 21920, 21953, 21956, 21961, 22014, 22114, 22129, 22133, 22139, 22143, 22164, 22169, 22183, 22190, 22225, 22230, 22238, 22246, 22250, 22254, 22268, 22276, 22304, 22323, 22329, 22358, 22367, 22373, 22377, 22384, 22395, 22415, 22427, 22440, 22443, 22446, 22478, 22484, 22535, 22568, 22578, 22581, 22606, 22679, 22688, 22691, 22706, 22738, 22742, 22747, 22758, 22773, 22779, 22783, 22790, 22811, 22820, 22824, 22827, 22842, 22844, 22855, 22900, 22911, 22920, 22945, 23023, 23053, 23077, 23114, 23115, 23133, 23154, 23157, 23182, 23192, 23203, 23210, 23217, 23226, 23229, 23236, 23243, 23257, 23269, 23281, 23293, 23318, 23350, 23352, 23357, 23379, 23406, 23423, 23496, 23499, 23502, 23513, 23515, 23532, 31373, 31385, 31388, 31390, 31392, 31400, 31404, 31414, 31420, 31431, 31446, 31458, 31532, 31559, 31572, 31590, 31646, 31685, 31709, 31732, 31734, 31737, 31768, 31769, 31783, 31784, 31785, 31786, 31788, 31789, 31790, 31791, 31792, 31793, 31794, 31795, 31796, 31797, 31798, 31799, 31800, 31801, 31802, 31803, 31804, 31805, 31806, 31807, 31808, 31809, 31810, 31811, 31812, 31813, 31814, 31815, 31816, 31817, 31818, 31819, 31820, 31821, 31823, 31830, 31846, 31856, 31872, 31874, 31878, 31886, 31894, 31896, 31902, 31912, 31914, 31922, 31938, 31954, 31956, 31964, 31970, 31980, 31992, 32004, 32006, 32015, 32037, 32050, 32062, 32089, 32091, 32096, 32153, 32156, 32159, 32174, 32182, 32196, 32207, 32209, 32214, 32218, 32222, 32230, 32234, 32239, 32244, 32255, 32257, 32269, 32273, 32274, 32275, 32276, 32277, 32278, 32279, 32281, 32284, 32285, 32286, 32291, 32293, 32295, 32298, 32301, 32302, 32306, 32307, 32310, 32320, 32331, 32333, 32337, 32371, 32373, 32398, 32404, 32406, 32415, 32436, 32445, 32465, 32485, 32491, 32505, 32529, 32531, 32592, 32620, 32624, 32636, 32659, 32665, 32675, 32686, 32694, 32696, 32714, 32730, 32749, 32751, 35460, 35464, 35471, 35473, 35553, 35647, 35650, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35686, 35688, 35696, 35702, 35707, 35718, 35788, 35802, 35813, 35849, 35865, 35907, 35934, 35986, 35992, 36153, 36166, 36168, 36374, 36434, 36877, 38015, 40591, 40877, 41459, 42831, 43272, 43293, 43316, 44508, 44585, 46270, 46274, 46280, 46283, 46290, 46291, 46296, 46300, 46302, 46310, 46316, 46320, 46322, 46326, 46332, 46335, 46342, 46344, 46346, 46352, 46356, 46358, 46364, 46388, 46390, 46394, 46400, 46404, 46408, 46412, 46414, 46416, 46418, 46420, 46424, 46426, 46428, 46432, 46437, 46440, 46442, 46445, 46447, 46449, 46451, 46456, 46459, 46461, 46463, 46465, 46473, 46475, 46477, 46480, 46482, 46485, 46487, 46491, 46494, 46496, 46505, 46510, 46518, 46528, 46535, 46549, 46556, 46577, 46613, 46631, 46646, 46658, 46660, 46670, 46675, 46677, 46682, 46685, 46687, 46704, 46707, 46717, 46720, 46722, 46848, 46856, 46857, 46859, 46866, 46872, 46876, 46878, 46880, 46884, 46886, 46888, 46890, 46892, 46894, 46908, 46924, 46932, 46944, 46946, 46954, 46966, 46970, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46988, 46990, 46992, 46996, 47000, 47006, 47008, 47010, 47012, 47014, 47018, 47020, 47024, 47026, 47032, 47034, 47040, 47042, 47044, 47046, 47050, 47052, 47054, 47058, 47065, 47067, 47070, 47072, 47075, 47082, 47087, 47097, 47113, 47116, 47118, 47127, 47130, 47132, 47143, 47147, 47160, 47178, 47182, 47197, 47201, 47206, 47208, 47211, 47217, 47219, 47234, 47237, 47246, 47248, 47254, 47260, 47265, 47278, 47282, 47300, 48617, 48733, 48753, 48763, 48765, 48773, 49352, 49376, 49449, 49452, 49454, 49458, 49462, 49465, 49493, 49517, 49525, 49553, 49556, 49565, 49568, 49585, 49599, 49604, 49614, 49639, 49657, 49659, 49664, 49761, 49764, 49768, 49783, 49785, 49788, 49791, 49796, 49801, 49807, 49813, 49817, 49819, 49821, 49823, 49829, 49843, 49849, 49853, 49857, 49873, 49877, 49883, 49886, 49891, 49893, 49895, 49900, 49902, 49905, 49924, 49938, 49952, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50097, 50111, 50113, 50123, 50126, 50131, 50136, 50138, 50141, 50143, 50146, 50151, 50153, 50156, 50158, 50161, 50170, 50172, 50175, 50177, 50184, 50186, 50189, 50195, 50203, 50205, 50208, 50215, 50324, 50327, 50332, 50334, 50338, 50340, 50345, 50350, 50352, 50353, 50356, 50358, 50360, 50361, 50364, 50366, 50370, 50371, 50374, 50376, 50378, 50380, 50385, 50387, 50391, 50394, 50422, 50440, 50458, 50468, 50477, 50489, 50501, 50512, 50517, 50597, 50600, 50605, 50607, 50611, 50614, 50616, 50623, 50628, 50632, 50638, 50640, 50693, 50707, 50714, 50719, 50724, 50728, 50744, 50749, 50752, 50754, 50757, 50759, 50762, 50764, 50769, 50774, 50777, 50786, 50792, 50795, 50797, 50800, 50802, 50808, 50812, 50823, 51883, 52332, 52344, 52351, 52356, 52451, 52562) 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 Mysteries Of The Castle

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: The Wives Revenged

Afterpiece Title: The Secret Tribunal

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Marian

Cast
Role: Thomas Actor: Haymes

Performances

Mainpiece Title: Speculation

Afterpiece Title: Rosina

Cast
Role: Rustic Actor: Haymes

Performances

Mainpiece Title: Speculation

Afterpiece Title: Marian

Cast
Role: Thomas Actor: Haymes

Performances

Mainpiece Title: Speculation

Afterpiece Title: Sprigs of Laurel

Cast
Role: Corporal Squib Actor: Haymes

Dance: As17951114

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Tibalt Actor: Haymes

Afterpiece Title: Lord Mayor's Day

Song: As17950921, but Vocal Parts-_

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Love in a Camp; or, Patrick in Prussia

Cast
Role: Mabel Flourish Actor: Mr Haymes

Dance: End: Highland Festivity-Byrn, Holland, Mlle St.Amand

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Comus

Performances

Mainpiece Title: The Battle Of Hexham; Or, Days Of Old

Afterpiece Title: The Poor Sailor

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Sheriff Actor: Haymes

Afterpiece Title: The Flitch of Bacon

Performances

Mainpiece Title: Speculation

Afterpiece Title: Marian

Cast
Role: Thomas Actor: Haymes

Dance: As17951125

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Sheriff Actor: Haymes

Afterpiece Title: Oscar and Malvina

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Sheriff Actor: Haymes

Afterpiece Title: Oscar and Malvina

Performances

Mainpiece Title: Speculation

Afterpiece Title: Sprigs of Laurel

Cast
Role: Corporal Squib Actor: Haymes

Dance: As17951125

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: Crotchet Lodge

Performances

Mainpiece Title: Oroonoko

Performances

Mainpiece Title: Erter

Afterpiece Title: Merry Sherwood

Performances

Mainpiece Title: The Ghost

Afterpiece Title: The Widow of Malabar

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Sheriff Actor: Haymes

Afterpiece Title: Merry Sherwood

Performances

Mainpiece Title: King Henry The Fourth, First Part

Cast
Role: Sheriff Actor: Haymes

Afterpiece Title: Merry Sherwood

Performances

Mainpiece Title: Speculation

Afterpiece Title: Harlequin's Treasure 0; or, Jewels New Set

Cast
Role: Vocal Sailor Actor: Haymes

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Cast
Role: Spofforth Actor: Haymes

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lie Of The Day; Or, A Party At Hampton Court

Afterpiece Title: Catharine and Petruchio

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2