SELECT * FROM london_stages WHERE eventid IN (3797, 3861, 4204, 5425, 6143, 6435, 6744, 7072, 7385, 10274, 11150, 13306, 13374, 13441, 13583, 14080, 14190, 14246, 14835, 15435, 15571, 15782, 15784, 15789, 15879, 16468, 16486, 16613, 17318, 17778, 18142, 18199, 18202, 18216, 18755, 18772, 19731, 20210, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20434, 21491, 21497, 22178, 22184, 22406, 22407, 22440, 22443, 22446, 22578, 22875, 22878, 22881, 22887, 22904, 22915, 22934, 22939, 22942, 22945, 22948, 22957, 22959, 22971, 22974, 22979, 23003, 23005, 23015, 23036, 23041, 23066, 23092, 23095, 23098, 23101, 23104, 23128, 23140, 23151, 23179, 23226, 23883, 24114, 24205, 24236, 24244, 24248, 24483, 24490, 24538, 24540, 24629, 24687, 25260, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25787, 25793, 25797, 25801, 25815, 26044, 26673, 26675, 26678, 26680, 26682, 26684, 26686, 26692, 26790, 26849, 26853, 26858, 26863, 26867, 26904, 26924, 26929, 27031, 27471, 27477, 27526, 27568, 27638, 27639, 27799, 27807, 27998, 28185, 28189, 28220, 28224, 28229, 28233, 28234, 28241, 28255, 28353, 28362, 28364, 28395, 28687, 28963, 29251, 29253, 29345, 29360, 29362, 29504, 29649, 29823, 29826, 29935, 29942, 30262, 30319, 30323, 30325, 30433, 30587, 30602, 30622, 30627, 30629, 30681, 30711, 30718, 30720, 30723, 30726, 30729, 30733, 30755, 30761, 30835, 30861, 30894, 30899, 30902, 30980, 31036, 31058, 31110, 31159, 31180, 31190, 31192, 31201, 31221, 31224, 31235, 31242, 31254, 31273, 31281, 31677, 31699, 31725, 31749, 31758, 31767, 31783, 31784, 31785, 31798, 32273, 32274, 32275, 32276, 32277, 32279, 32281, 32284, 32286, 32291, 32295, 32302, 32307, 32323, 32407, 32419, 32421, 32423, 32425, 32428, 32430, 32433, 32435, 32437, 32448, 32451, 32453, 32455, 32458, 32460, 32618, 32643, 33104, 33214, 33215, 33217, 33218, 33219, 33227, 33228, 33229, 33231, 33234, 33400, 33404, 33541, 33544, 33546, 33549, 33604, 33613, 33685, 33718, 33723, 33726, 33727, 33730, 33732, 33733, 33736, 33738, 33739, 33741, 33742, 33756, 33762, 33769, 33772, 33777, 33779, 33783, 33785, 34213, 34215, 34227, 34260, 34265, 34268, 34271, 34273, 34274, 34276, 34278, 34279, 34281, 34284, 34285, 34286, 34288, 34290, 34292, 34293, 34294, 34296, 34298, 34300, 34302, 34305, 34307, 34310, 34311, 34312, 34316, 34318, 34323, 34325, 34326, 34327, 34329, 34331, 34332, 34333, 34334, 34397, 34400, 34406, 34410, 34418, 34466, 34469, 34471, 34474, 34475, 34476, 34478, 34482, 34493, 34546, 34578, 34722, 34737, 34759, 34789, 34815, 34828, 34874, 34912, 34914, 34916, 34918, 34920, 34922, 34924, 34930, 34932, 34934, 34936, 34938, 34942, 34952, 34967, 34973, 34976, 34983, 34990, 34992, 35061, 35079, 35083, 35090, 35103, 35105, 35117, 35130, 35141, 35145, 35147, 35152, 35157, 35162, 35169, 35177, 35178, 35184, 35218, 35229, 35244, 35277, 35319, 35338, 35416, 35421, 35426, 35438, 35501, 35503, 35555, 35557, 35566, 35575, 35895, 35974, 36107, 36118, 36120, 36124, 36129, 36133, 36137, 36175, 36182, 36185, 36186, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36251, 36283, 36285, 36288, 36290, 36292, 36299, 36375, 36476, 36479, 36541, 36669, 36673, 36682, 36694, 36700, 36702, 36708, 36712, 36747, 36773, 36782, 36858, 36906, 36909, 36923, 37014, 37025, 37101, 37110, 37167, 37168, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37190, 37193, 37199, 37201, 37204, 37207, 37272, 37282, 37284, 37285, 37292, 37301, 37310, 37338, 37361, 37373, 37402, 37501, 37506, 37515, 37525, 37580, 37593, 37604, 37616, 37893, 37897, 37907, 37923, 38044, 38052, 38085, 38186, 38309, 38311, 38614, 38654, 38728, 38882, 39310, 39334, 39342, 39348, 39351, 39355, 39359, 39361, 39362, 39365, 39368, 39371, 39374, 39376, 39377, 39385, 39388, 39395, 39404, 39436, 39438, 39792, 39806, 39814, 39893, 39896, 39905, 39909, 39915, 40309, 40507, 40508, 40513, 40514, 40516, 40585, 40727, 41579, 41580, 41585, 41586, 41590, 41609, 41612, 41664, 42250, 42256, 42287, 44530, 44535, 44555, 44578, 45708, 45774, 45776, 46027, 46044, 46221, 46739, 48556, 48566, 48616, 48632, 48718, 48946, 49716, 50841, 51381, 51463) 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 Citizen

Cast
Role: Maria Actor: a young Gentlewoman

Afterpiece Title: The Mayor of Garratt

Dance: As17630704

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: Sicilian Peasants-Master Rogier, Miss Valois; End: A new comic Dance, The Carpenter and the Fruit Dealer-Gherardi Jr, Master Clinton, Miss Street

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: As17640626, but order reversed%

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: Sicilian Peasants, as17640626 End: The Venetian Gardeners-Master Clinton, Miss Street

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: As17640629, but order reversed%

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: A new Tambourine Dance-Rogier, Miss Valois; End: The Venetian Gardeners, as17640629

Performances

Mainpiece Title: The Patron

Afterpiece Title: The Mayor of Garratt

Dance: I: The Dutchman and Provincials-Gherardi, Master Clinton, Miss Street; End: Tambourine Dance, as17640705

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: The Mayor of Garratt

Dance: As17640710

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: The Mayor of Garratt

Dance: As17640710 but order reversed

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: The Mayor of Garratt

Dance: I: The Shepherdess and the Faux Aveugle, as17640801; End: The Calabrian Peasants-Rogier, Miss Valois

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: The Apprentice

Dance: TThe Dutchman and Provincials, as17640710 End: The Calabrian Peasants, as17640806

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: Tragedy a la Mode

Dance: As17640824, but order reversed

Performances

Mainpiece Title: The Patron

Cast
Role: Parts Actor: _Hayes, a young _Gentlewoman, Castle, Mrs +Granger.

Afterpiece Title: Tragedy a la Mode

Dance: As17640905

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fairy Tale

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Genii

Performances

Dance: Grimaldi, Aldridge, Giorgi, Berardi, Sga Giorgi, Miss Baker

Performances

Afterpiece Title: The Genii

Dance: As17641128