SELECT * FROM london_stages WHERE eventid IN (1814, 2096, 2105, 2113, 2116, 2117, 2690, 5151, 5652, 6014, 10308, 11452, 11692, 11728, 12676, 14876, 14924, 15429, 15597, 15668, 16033, 16323, 16462, 18190, 18193, 18196, 18377, 18380, 18383, 20749, 20778, 20781, 20882, 21057, 21196, 21226, 21239, 21259, 21273, 21361, 21395, 21532, 21610, 21671, 21744, 21940, 21989, 22072, 22191, 22232, 22320, 22335, 22400, 22920, 23003, 23059, 23080, 23413, 23417, 23528, 23588, 24398, 24400, 24403, 24406, 24407, 24409, 24411, 24414, 24430, 24453, 24468, 24552, 24584, 24635, 24688, 24761, 24805, 24897, 25023, 25193, 25250, 25410, 25525, 25856, 25893, 25896, 25899, 25902, 25904, 25905, 25907, 25909, 25911, 25912, 25914, 25916, 25918, 25921, 25923, 25930, 25932, 25935, 25937, 25941, 25943, 25967, 25971, 25986, 26028, 26052, 26112, 26153, 26230, 26241, 26243, 26245, 26247, 26249, 26251, 26253, 26256, 26260, 26320, 26323, 26577, 26772, 26775, 26777, 26780, 26782, 26784, 26786, 26789, 26794, 26796, 27260, 27324, 27327, 27330, 27332, 27334, 27337, 27349, 27351, 27354, 27361, 27414, 27423, 27429, 27445, 27446, 27452, 27473, 27553, 27571, 27589, 27600, 27633, 27870, 27874, 27876, 27879, 27882, 27884, 27887, 27889, 27896, 27899, 27938, 27975, 28027, 28057, 28119, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28597, 28598, 28601, 28606, 28608, 28612, 28632, 28637, 28640, 28650, 28809, 29562, 30076, 30392, 30598, 32314, 32689, 32807, 32844, 32937, 33114, 33163, 34242, 34244, 34599, 34643, 34743, 34812, 34899, 34903, 34909, 34919, 34963, 35017, 35099, 35227, 35504, 35509, 35512, 35517, 35519, 35673, 35675, 35677, 35679, 35682, 35684, 35686, 35687, 35689, 35692, 35694, 35697, 35700, 35703, 35705, 35708, 35710, 35713, 35715, 35717, 35719, 35722, 35724, 35727, 35729, 35732, 35734, 35737, 35739, 35742, 35745, 35748, 35750, 35752, 35755, 35757, 35760, 35762, 35764, 35767, 35770, 35772, 35775, 35779, 35782, 35784, 35789, 35827, 35850, 35857, 35882, 35890, 35896, 35917, 35930, 35933, 35955, 35968, 35995, 35996, 36010, 36223, 36459, 36862, 36900, 36996, 37068, 37072, 37213, 37235, 37289, 37386, 37388, 37419, 37599, 37656, 37695, 37712, 37724, 37738, 38018, 38047, 38118, 38219, 38275, 38422, 38434, 38439, 38457, 38470, 38474, 38479, 38481, 38483, 38485, 38488, 38490, 38492, 38493, 38494, 38496, 38498, 38500, 38502, 38505, 38507, 38509, 38511, 38514, 38516, 38519, 38521, 38523, 38530, 38536, 38540, 38561, 38566, 38570, 38571, 38581, 38593, 38608, 38613, 38635, 38654, 38658, 38668, 38673, 38675, 38694, 38699, 38700, 38775, 38786, 38860, 38864, 38867, 38870, 38873, 38883, 38885, 38888, 38889, 38906, 38918, 38920, 38962, 39181, 39245, 39282, 39288, 39531, 39540, 39910, 40123, 40272, 40630, 40761, 40946, 41170, 41200, 41259, 41389, 41475, 41558, 41822, 42082, 42151, 42275, 42325, 42881, 42996, 43342, 43444, 43448, 43449, 43451, 43455, 43474, 43476, 43622, 43662, 43664, 43784, 43854, 43856, 43901, 44046, 44054, 44085, 44119, 44353, 44466, 44505, 44602, 44677, 44950, 45100, 45106, 45112, 45428, 45494, 45514, 45523, 45691, 45747, 45785, 45823, 45865, 45914, 45916, 45925, 45930, 45973, 46000, 46007, 46009, 46013, 46015, 46017, 46048, 46059, 46063, 46488, 46531, 46561, 46569, 46573, 46588, 46595, 46673, 46797, 46804, 46809, 46820, 46913, 47093, 47101, 47145, 47151, 47157, 47162, 47168, 47174, 47180, 47184, 47187, 47193, 47199, 47227, 47232, 47239, 47250, 47256, 47264, 47267, 47271, 47307, 47323, 47417, 47428, 47430, 47540, 47654, 47759, 47800, 47805, 47814, 47820, 47835, 47847, 47884, 47905, 47966, 47981, 47995, 48028, 48038, 48043, 48049, 48071, 48080, 48081, 48090, 48100, 48109, 48185, 48230, 48264, 48384, 48409, 48411, 48430, 48437, 48473, 48551, 48553, 48555, 48557, 48561, 48565, 48567, 48569, 48588, 48596, 48613, 48621, 48635, 48637, 48647, 48651, 48662, 48665, 48685, 48697, 48704, 48714, 48824, 48860, 48882, 49028, 49053, 49060, 49126, 49216, 49222, 49226, 49244, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49525, 49563, 49599, 49646, 49657, 49783, 49794, 49805, 49815, 49837, 49849, 49886, 49891, 49897, 49999, 50008, 50108, 50116, 50118, 50166, 50170, 50193, 50203, 50223, 50245, 50270, 50276, 50352, 50452, 50669, 50684, 50701, 50718, 50800, 50809, 50821, 50825, 50830, 50835, 50845, 50848, 50849, 50853, 50858, 50864, 50867, 50869, 50870, 50877, 50879, 50885, 50890, 50893, 50896, 50901, 50902, 50903, 50910, 50987, 51056, 51204, 51229, 51239, 51247, 51249, 51254, 51256, 51273, 51285, 51298, 51356, 51459, 51547, 51676, 51732, 51769, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51799, 51801, 51806, 51811, 51813, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51849, 51856, 51858, 51864, 51869, 51871, 51885, 51890, 51892, 51900, 51907, 51933, 51936, 51941, 51956, 52068, 52119, 52348, 52357) 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

Afterpiece Title: Britannia

Afterpiece Title: The Beggar's Pantomime

Performances

Afterpiece Title: Britannia

Afterpiece Title: The Beggar's Pantomime

Performances

Afterpiece Title: Britannia

Afterpiece Title: The Beggar's Pantomime

Performances

Mainpiece Title: Macbeth

Cast
Role: With Music Actor:

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Rehearsal

Cast
Role: With the Music Actor:

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: The Rehearsal

Cast
Role: With the Music Actor:

Afterpiece Title: The Dragon of Wantley

Performances

Mainpiece Title: Macbeth

Cast
Role: With Music Actor:

Dance: LLes Matelotes, as17411110; Les Jardiniers Suedois, as17411128

Performances

Mainpiece Title: The Rehearsal

Cast
Role: With the Music Actor:

Afterpiece Title: The Rape of Proserpine

Dance: As17420125

Performances

Mainpiece Title: The Rehearsal

Cast
Role: With the Music Actor:

Afterpiece Title: Orpheus and Eurydice

Dance: A New Pierot Dance-Picq, Mlle Auguste

Performances

Mainpiece Title: Macbeth

Cast
Role: With Music Actor:

Dance: I: Les Enfans Jardiniers Suedois, as17420403 III: by Desire, a Minuet-Master Poiter, Miss Poiter; IV: A Serious Dance-Poiter, Mlle Roland; A Tambourine-Master Poitier; and a Serious Dance-Miss Poitier; Also Les Paisans Allemandes, as17420403

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The School Boy

Song: Concert Air from Alexander's Feast: War he sung is Toil and Trouble-Mrs Bishop; III: Can Love be controul'd by Advice-Miss Medina

Music: V: Preamble on the Kettle Drums-Jo. Woodbridge; who never perform'd on that Stage before ending with Handel's celebrated Water Musick-; And to conclude: the Concert, the Coronation Anthem Long Live the King (never perform'd there before) by Mr Handel-an Additional Band

Cast
Role: 's celebrated Water Musick Actor:

Dance: I: David apShenkin; II: Welsh Buffoon, as17420406 IV: Two Millers and Courtezan, as17420315 End I Afterpiece: New Scots Dance-Master and Miss Granier

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: The Lying Valet

Song: II: Can Love be controul'd by Advice-Miss Medina

Dance: I: Two Millers and Courtezan, as17420315 III: Welsh Buffoon, as17420406 IV: Drunken Peasant-David apShenkin

Music: V: Preamble on the Kettle Drums-Jo. Woodbridge; Handel's celebrated Water Musick-; To conclude with: the Coronation anthem-

Cast
Role: 's celebrated Water Musick Actor:

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Afterpiece Title: The King and Miller of Mansfield

Dance: CComic Dance-Richardson, Delagarde, Mrs LeBrun; Comic Dance, Pantaloon and Enamorata, as17420420

Entertainment: CCries of London-Salway

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Afterpiece Title: Old Man Taught Wisdom

Song: By Desire, Arrah my Judy-Stoppelaer

Dance: Villeneuve, Dumont, Richardson, Delagarde, Destrade, Dupre, DeVaul

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Dance: As17421026

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Afterpiece Title: The Necromancer

Dance: LLa Provencale, as17421105; Dutch Skipper, as17421025; Peasants, as17421230

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Macbeth

Cast
Role: With the Original Music Actor:

Afterpiece Title: The Rape of Proserpine

Dance: PPeasants, as17421230; New Grand Comic Ballet-Picq, Mlle Auguste

Performances

Mainpiece Title: Macbeth

Cast
Role: With the original Music Actor:

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Macbeth

Cast
Role: With the original Music Actor:

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Macbeth

Cast
Role: With the original Music Actor:

Afterpiece Title: The Necromancer

Dance: Cooke

Performances

Mainpiece Title: Macbeth

Cast
Role: With the original Music Actor:

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Macbeth

Cast
Role: With the original Music Actor:

Afterpiece Title: Flora; or, Hob in the Well

Dance: GGrand Ballet, as17440423