SELECT * FROM london_stages WHERE eventid IN (933, 1828, 2095, 2565, 7426, 7429, 7981, 8052, 8974, 11277, 11947, 12201, 12996, 13101, 13130, 13457, 13651, 13918, 14178, 15556, 16256, 16327, 16383, 17977, 19023, 19025, 19028, 19030, 19032, 19034, 19038, 19048, 19073, 19160, 20891, 20894, 20919, 20957, 21015, 21032, 21088, 21118, 21134, 21228, 21317, 21580, 21684, 21719, 21774, 21911, 22005, 22008, 22010, 22013, 22019, 22022, 22027, 22032, 22034, 22046, 22053, 22118, 22192, 22317, 22345, 22360, 22361, 22449, 22570, 22601, 22687, 22749, 22797, 23559, 24068, 24070, 24075, 24078, 24145, 24150, 24169, 24218, 24222, 24262, 24341, 24346, 24359, 24368, 24418, 24474, 24544, 24561, 24632, 24647, 24648, 24690, 24707, 24905, 24913, 24953, 24981, 25006, 25051, 25106, 25207, 25210, 25267, 25418, 25425, 25445, 25533, 25535, 25536, 25540, 25553, 25673, 25707, 25812, 25814, 25816, 25824, 25836, 25891, 25959, 25961, 25982, 26052, 26067, 26126, 26160, 26198, 26205, 26229, 26230, 26243, 26265, 26296, 26426, 26580, 26601, 26669, 26713, 26719, 26735, 26771, 26836, 26855, 27003, 27057, 27071, 27170, 27230, 27236, 27324, 27327, 27330, 27332, 27334, 27337, 27423, 27429, 27445, 27452, 27488, 27591, 27617, 27633, 27680, 27815, 27827, 27849, 28021, 28162, 28227, 28399, 28403, 28404, 28410, 28455, 28486, 28499, 28638, 28779, 28992, 29036, 29205, 29442, 29747, 30339, 30357, 30367, 30371, 30397, 30422, 30578, 30641, 30876, 30898, 30916, 30919, 31009, 31017, 31123, 31462, 31513, 31540, 31645, 31648, 31675, 31684, 31723, 31763, 31905, 31932, 32111, 32399, 32405, 32416, 32593, 32609, 32648, 32683, 32706, 32844, 32846, 32852, 32866, 32951, 33110, 33289, 33335, 33347, 33350, 33384, 33395, 33592, 33648, 33649, 33681, 33850, 33854, 33906, 33939, 34010, 34050, 34058, 34202, 34342, 34380, 34580, 34693, 34747, 34753, 34778, 34786, 34912, 34914, 34916, 34918, 34920, 34922, 34924, 34932, 34936, 34942, 34952, 34972, 34992, 35076, 35080, 35283, 35416, 35421, 35426, 35438, 35471, 35541, 35553, 35563, 35567, 35571, 35580, 35584, 35585, 35588, 35593, 35596, 35608, 35622, 35660, 35717, 35743, 35762, 35866, 35902, 35916, 35955, 36128, 36164, 36181, 36198, 36226, 36261, 36294, 36297, 36304, 36309, 36318, 36377, 36404, 36410, 36419, 36453, 36479, 36559, 36573, 36651, 36687, 36707, 36751, 36813, 36856, 36884, 36924, 37003, 37022, 37040, 37050, 37056, 37058, 37071, 37081, 37254, 37262, 37501, 37506, 37515, 37525, 38033, 38038, 38112, 38359, 38386, 38441, 38488, 38516, 38523, 38720, 38740, 38869, 38876, 38965, 39022, 39028, 39253, 39360, 39593, 39618, 39632, 39703, 39791, 39843, 39912, 39917, 39935, 39951, 39985, 39987, 40023, 40113, 40175, 40245, 40263, 40355, 40357, 40465, 40519, 40576, 40940, 40955, 41148, 41240, 41277, 41292, 41428, 41462, 41752, 41863, 41907, 41935, 42131, 42287, 42395, 42400, 42409, 42444, 42456, 42466, 42485, 42498, 42538, 42554, 42563, 42578, 42619, 42645, 42688, 42732, 42774, 42778, 42782, 42790, 42801, 42804, 42895, 43026, 43040, 43129, 43272, 43293, 43316, 43513, 43561, 43582, 43661, 43665, 43670, 43681, 43688, 43695, 43701, 43711, 43725, 43745, 43771, 43798, 43814, 43847, 43862, 43980, 44038, 44071, 44106, 44184, 44260, 44289, 44378, 44603, 44607, 44610, 44638, 44649, 44664, 44673, 44721, 44734, 44895, 44926, 45021, 45145, 45191, 45422, 45544, 45573, 45725, 45732, 45764, 45784, 45837, 45905, 46017, 46033, 46042, 46050, 46059, 46073, 46169, 46281, 46286, 46292, 46294, 46295, 46301, 46313, 46315, 46333, 46351, 46395, 46476, 46495, 46543, 46552, 46564, 46600, 46637, 46652, 46681, 46721, 46723, 46725, 46728, 46734, 46847, 46925, 47005, 47088, 47462, 47641, 47654, 47689, 47753, 48043, 48053, 48062, 48138, 48335, 48348, 48379, 48547, 48590, 48592, 48594, 48596, 48717, 48761, 48835, 48865, 48870, 48979, 48981, 48983, 48985, 48987, 48992, 48994, 48997, 48999, 49001, 49003, 49006, 49008, 49011, 49020, 49023, 49025, 49033, 49035, 49037, 49050, 49052, 49053, 49065, 49080, 49085, 49099, 49102, 49111, 49193, 49207, 49250, 49254, 49257, 49268, 49301, 49338, 49466, 49478, 49521, 49559, 49607, 49653, 49754, 49769, 49821, 49824, 49861, 49904, 50007, 50014, 50020, 50027, 50094, 50096, 50097, 50102, 50123, 50353, 50355, 50356, 50358, 50360, 50361, 50378, 50408, 50423, 50458, 50462, 50491, 50599, 50623, 50639, 50972, 51035, 51083, 51198, 51362, 51483, 51793, 52134, 52415, 52427, 52434, 52490, 52497, 52605, 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: The Fair Penitent

Cast
Role: Rossano Actor: Blakes

Afterpiece Title: The Devil to Pay

Song: Master Mattocks

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: Macbeth

Cast
Role: Rosse Actor: King

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: Macbeth

Cast
Role: Rosse Actor: King

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Anderson

Afterpiece Title: The Stage Coach

Dance: As17500201

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes

Afterpiece Title: Miss in Her Teens

Dance: CComic Dance, as17500221; Venetian Gardeners-Grandchamps, Mlle Auretti

Performances

Mainpiece Title: Macbeth

Cast
Role: Rosse Actor: King

Afterpiece Title: Miss in Her Teens

Music: II: Concerto on Violincello-Cervetti

Dance: I: Black Joke, as17500420 II: Comic Dance-Grandchamps; III: L'Entree de Flore, as17491024; V: Venetian Gardeners-Grandchamps, Mlle Auretti

Performances

Mainpiece Title: Macbeth

Cast
Role: Ross Actor: Lee

Afterpiece Title: Lethe

Performances

Mainpiece Title: Macbeth

Cast
Role: Ross Actor: Lee

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: The Mock Doctor

Dance: II: Comic Dance, as17501117

Ballet: V: The Birdcatchers. As17501127

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Usher

Dance: As17510117

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Fair Penitent

Cast
Role: Rossano Actor: Usher

Dance: As17510117

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Usher

Afterpiece Title: Merlin's Cave

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Usher

Afterpiece Title: Damon and Phillida

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: Lethe

Dance: I: Hornpipe-the Little Swiss; II: The Savoyard-Mathews, Mad Camargo; III: Running Footman's Dance, as17501020; IV: A Harlequin Dance-the Little Swiss; V: The Scotch Dance-Mathews, Mad Auretti

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Usher

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: The Anatomist

Ballet: SSavoyard Travellers. As17511105

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: The Shepherd's Lottery

Performances

Mainpiece Title: The Fair Penitent

Cast
Role: Rossano Actor: Blakes.

Afterpiece Title: Lethe

Ballet: TThe Savoyard Travellers. As17511105

Performances

Mainpiece Title: Macbeth

Cast
Role: Ross Actor: Lee

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: Macbeth

Cast
Role: Ross Actor: Lee

Afterpiece Title: The Lying Valet