SELECT * FROM london_stages WHERE eventid IN (134, 1925, 31468, 31471, 31473, 31475, 31478, 31481, 31483, 31485, 31487, 31489, 31492, 31495, 31499, 31505, 31507, 31511, 31514, 31518, 31522, 31527, 31538, 31543, 31549, 31551, 31557, 31565, 31570, 31575, 31584, 31588, 31592, 31600, 31606, 31630, 31643, 31661, 31668, 31697, 31746, 31774, 31888, 31904, 31916, 31926, 31945, 32008, 32135, 32144, 32147, 32199, 32246, 32263, 32355, 32369, 32387, 32400, 32415, 32440, 32478, 32485, 32499, 32513, 32592, 32614, 32640, 32657, 32681, 32730, 32826, 32853, 32875, 32885, 32904, 32916, 33018, 33040, 33071, 33113, 33142, 33294, 33316, 33323, 33345, 33349, 33361, 33405, 33480, 33521, 33584, 33627, 33705, 33801, 33852, 33892, 33918, 33927, 33981, 34006, 34073, 34147, 34190, 34225, 34230, 34253, 34347, 34362, 34450, 34497, 34548, 34635, 34712, 34753, 34766, 34786, 34888, 34926, 35011, 35069, 35103, 35105, 35117, 35141, 35178, 35244, 35297, 35344, 35492, 35507, 35512, 35517, 35521, 35531, 35536, 35565, 35586, 35598, 35636, 35715, 35737, 35748, 35764, 35779, 35840, 35850, 35928, 35954, 35964, 35977, 36104, 36124, 36133, 36162, 36360, 36489, 36519, 36526, 36635, 36646, 36648, 36654, 36674, 36707, 36755, 36851, 36905, 36989, 37040, 37207, 37219, 37222, 37230, 37240, 37277, 37327, 37401, 37403, 37536, 37593, 37652, 37686, 37786, 37814, 37863, 37936, 37999, 38015, 38061, 38092, 38108, 38119, 38162, 38176, 38183, 38227, 38320, 38338, 38363, 38415, 38763, 38867, 38886, 38889, 39033, 39412, 39418, 39450, 39455, 39792, 39806, 39832, 39849, 39893, 39896, 39905, 39909, 39915, 39925, 39940, 39954, 40267, 40272, 40295, 40308, 40320, 40469, 40471, 40599, 40717, 40732, 40775, 40915, 40972, 40999, 41012, 41124, 41128, 41165, 41201, 41213, 41260, 41582, 41588, 41644, 41668, 41687, 41757, 41789, 41848, 42107, 42249, 42258, 42268, 42289, 42292, 42296, 42393, 42519, 42589, 42753, 42758, 42764, 42767, 42770, 42774, 42778, 42782, 42790, 42805, 42843, 42855, 42863, 42878, 43253, 43304, 43305, 43370, 43442, 43464, 43471, 43584, 43623, 43890, 43917, 43922, 43931, 43947, 43962, 43988, 44139, 44256, 44261, 44315, 44489, 44528, 44643, 44648, 44680, 44698, 44731, 44741, 44746, 44760, 44863, 44884, 44946, 44952, 44972, 44975, 44979, 45087, 45144, 45150, 45154, 45259, 45318, 45361, 45389, 45420, 45497, 45693, 45716, 45871, 46011, 46149, 46303, 46331, 46401, 46452, 46585, 46718, 46951, 47027, 47031, 47264, 47515, 47539, 47603, 47643, 47680, 47810, 47838, 48192, 48249, 48427, 48611, 48631, 48667, 48724, 48735, 48787, 48813, 48824, 48827, 49775, 49780, 49881, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50099, 50113, 50116, 50163, 50193, 50195, 50198, 50332, 50704, 50709, 50712, 50717, 50722, 50726, 50767, 50987, 50991, 51047, 51329, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52170, 52172, 52180, 52184, 52186, 52190, 52194, 52280, 52291, 52355, 52468, 52509, 52603, 52604, 52606, 52607, 52608, 52610) 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: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Dutch Skippers, as17630101

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Dutch Skippers, as17630101

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Jealous Woodcutter, as17621023

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: I: The Dutch Skippers, as17630101

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17621125

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: I: The Sicilian Peasants, as17631005; II: The Cudgell'd Husband, as17631101

Music: II: Mr Handel's Water@Music, with a preamble on the Kettle Drums-Poitier

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17631005

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Knife Grinders, as17631012

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: TThe Cudgell'd Husband, as17631101

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Sicilian Peasants, as17631005

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: The Knife Grinders, as17631012

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: Venus Reveng'd, as17631222

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hawthorn Actor: Beard

Dance: II: Venus Reveng'd, as17631222