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

Afterpiece Title: The Intriguing Chambermaid

Dance: II: Rural Love, as17651115

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Miss Brent

Afterpiece Title: Lethe

Dance: II: Rural Love, as17651115

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Mattocks, 1st time

Afterpiece Title: The Apprentice

Dance: II: The Village Romps, as17661008

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Mattocks, 1st time

Afterpiece Title: The Intriguing Chambermaid

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Mattocks, 1st time

Afterpiece Title: Catherine and Petruchio

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Citizen

Dance: II: The Garland, as17661023

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: Miss in Her Teens

Dance: II: The Village Romps, as17661008

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: Harlequin Dr Faustus

Dance: II: Rural Love-Fishar, Sga Manesiere, Miss Wilford, Arnauld, Dumai, Miss Twist, Miss Pitt.[See17641212.

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: Catherine and Petruchio

Dance: II: Rural Love, as17661120

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Mattocks.

Afterpiece Title: Miss in Her Teens

Dance: II: Rural Love, as17661120

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto.

Afterpiece Title: The Upholsterer

Dance: II: The Female Archer, as17661215

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto.

Afterpiece Title: The Citizen

Dance: II: The Female Archer, as17661215

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto.

Afterpiece Title: The Englishman in Paris

Dance: II: The Female Archer, as17661215

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto.

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Citizen

Dance: II: Serious Dance, as17670916

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Royal Chace

Dance: II: A New Pantomime Dance, as17671016

Performances

Mainpiece Title: The Foundling

Cast
Role: Rosetta Actor: Miss Pope

Afterpiece Title: A Peep behind the Curtain

Dance: II: Hearts of Oak, as17671022

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Oxonian in Town

Dance: II: A New Pantomime Dance, as17671016

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Oxonian in Town

Dance: II: New Comic Dance-Arnauld, Miss Valois

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Royal Chace

Dance: II: A New Comic Dance, as17671024

Performances

Mainpiece Title: The Foundling

Cast
Role: Rosetta Actor: Miss Pope

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Royal Chace

Dance: II: The Merry Sailors, as17671009

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: Orpheus and Eurydice

Dance: II: A New Comic Dance, as17671021

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Royal Chace

Dance: II: A New Comic Dance, as17671021

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mrs Pinto

Afterpiece Title: The Apprentice

Dance: II: The Highland Reel, as17680307