SELECT * FROM london_stages WHERE eventid IN (24089, 24092, 24094, 24097, 24098, 24099, 24102, 24103, 24106, 24109, 24112, 24121, 24142, 24190, 24260, 24554, 24556, 24657, 25216, 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, 32187, 32199, 32246, 32263, 32355, 32369, 32387, 32400, 32415, 32440, 32478, 32485, 32499, 32513, 32592, 32614, 32640, 32657, 32681, 32730, 32822, 32826, 32827, 32853, 32875, 32885, 32904, 32916, 32947, 33018, 33040, 33071, 33113, 33142, 33294, 33316, 33323, 33345, 33349, 33361, 33405, 33480, 33521, 33584, 33627, 33705, 33801, 33852, 33877, 33892, 33918, 33927, 33978, 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, 35143, 35178, 35244, 35297, 35344, 35350, 35492, 35507, 35512, 35517, 35521, 35528, 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, 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, 40283, 40295, 40308, 40320, 40358, 40469, 40471, 40599, 40717, 40732, 40775, 40915, 40972, 40999, 41012, 41124, 41128, 41165, 41201, 41213, 41260, 41582, 41588, 41644, 41668, 41687, 41757, 41789, 41848, 42020, 42107, 42249, 42258, 42271, 42279, 42289, 42292, 42296, 42393, 42457, 42519, 42589, 42742, 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, 44358, 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, 48163, 48192, 48427, 48442, 48611, 48631, 48667, 48724, 48735, 48787, 48813, 48824, 48827, 49101, 49775, 49780, 49881, 50198, 50332, 50767, 50987, 50991, 51329) 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: Rosetta Actor: Miss Brent

Dance: II: The Sicilian Peasants, as17641001

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Upholsterer

Dance: II: The Sicilian Peasants, as17641001

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Cheats of Scapin

Dance: II: La Femme Maitresse, as17641004

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Knights

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Upholsterer

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: A Duke and no Duke

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Intriguing Chambermaid

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Upholsterer

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Intriguing Chambermaid

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: Cheats of Scapin

Dance: II: Blind Man's Buff, as17641003

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: A Duke and no Duke

Dance: II: A Tambourine, as17641015

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Intriguing Chambermaid

Dance: II: Rural Love, as17641212

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Upholsterer

Dance: II: Blind Man's Buff, as17641003

Performances

Mainpiece Title: The Foundling

Cast
Role: Rosetta Actor: Miss Pope

Afterpiece Title: The Witches

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The King and Miller of Mansfield

Dance: II: The Garland, as17651003

Performances

Mainpiece Title: The Foundling

Cast
Role: Rosetta Actor: Miss Pope

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: Polly Honeycombe

Dance: II: A New Grand Pantomime Ballet, call'd The Village Romps-Fichar, Arnauld, Sga Manesiere

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Intriguing Chambermaid

Dance: II: The Garland?-as17651003

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Intriguing Chambermaid

Dance: II: A Grand Ballet, call'd Rural Love-Fischar, Sga Manesiere, Miss Wilford, Arnauld, Leppie, Miss Twist, Miss Pitt

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: A Duke and no Duke

Dance: II: The Calabrian Peasants-Man Peasant Sga Manesiere, Woman Peasant Miss Wilford

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Citizen

Dance: II: Rural Love, as17651115

Performances

Mainpiece Title: The Foundling

Cast
Role: Rosetta Actor: Miss Pope

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: Polly Honeycombe

Dance: II: Rural Love, as17651115

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Englishman in Paris

Dance: II: Rural Love, as17651115

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: The Citizen

Dance: II: Rural Love, as17651115