SELECT * FROM london_stages WHERE eventid IN (12035, 12472, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12500, 12502, 12506, 12512, 12521, 12525, 12527, 12546, 12599, 12617, 12632, 12717, 12812, 12819, 12826, 13247, 13267, 13280, 13521, 13618, 13620, 13671, 13764, 13932, 13936, 13940, 14023, 14103, 14434, 14461, 14704, 14746, 14753, 14908, 14915, 14999, 15001, 15005, 15011, 15021, 15237, 15241, 15246, 15250, 15252, 15255, 15260, 15266, 15270, 15274, 15277, 15281, 15285, 15289, 15292, 15295, 15298, 15301, 15304, 15344, 15347, 15350, 15357, 15360, 15393, 15485, 15514, 15585, 15744, 15779, 15788, 15793, 15799, 15810, 15849, 15879, 15882, 15885, 15888, 15893, 15896, 15901, 15904, 15908, 15912, 15917, 15962, 15966, 15995, 16004, 16006, 16031, 16051, 16103, 16125, 16162, 16346, 16417, 16485, 16499, 16500, 16503, 16515, 16539, 16540, 16584, 16866, 16891, 17056, 17058, 17081, 17157, 17211, 17289, 17300, 17306, 17386, 17399, 17428, 17440, 17785, 17788, 17804, 17842, 17934, 18142, 18158, 18235, 18248, 18275, 18278, 18283, 18292, 18329, 18332, 18336, 18339, 18342, 18346, 18349, 18353, 18355, 18356, 18358, 18362, 18366, 18368, 18369, 18373, 18386, 18387, 18390, 18397, 18401, 18407, 18411, 18427, 18445, 18446, 18452, 18469, 18504, 18608, 18620, 18692, 18803, 18853, 18905, 18906, 18910, 18912, 18932, 19001, 19019, 19137, 19150, 19200, 19276, 19322, 19370, 19405, 19543, 19562, 19573, 19620, 19631, 19644, 19741, 19878, 20012, 20047, 20087, 20166, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20242, 20248, 20264, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20434, 20450, 20630, 20650, 20668, 20670, 20693, 20729, 20732, 20735, 20739, 20742, 20799, 20886, 20913, 20916, 20960, 21000, 21033, 21295, 21323, 21394, 21473, 21561, 21637, 21638, 21640, 21649, 21653, 21712, 21736, 21792, 21819, 21831, 21900, 21902, 21905, 21907, 21923, 21942, 21979, 22051, 22066, 22078, 22086, 22092, 22117, 22151, 22219, 22267, 22309, 22312, 22381, 22430, 22431, 22465, 22492, 22559, 22593, 22621, 22730, 22789, 22802, 22819, 22833, 22834, 22848, 22940, 22954, 22956, 22958, 22961, 22990, 22992, 22995, 23002, 23011, 23055, 23064, 23081, 23090, 23106, 23115, 23125, 23127, 23156, 23173, 23184, 23207, 23215, 23238, 23247, 23254, 23313, 23347, 23351, 23369, 23389, 23433, 23494, 23500, 23501, 23510, 23518, 23539, 23551, 23555, 23595, 23606, 23626, 23659, 23667, 23670, 23709, 23731, 23776, 23815, 23861, 23875, 23894, 23925, 23928, 23932, 23935, 23944, 23949, 23987, 23988, 23990, 24001, 24002, 24017, 24059, 24064, 24159, 24185, 24211, 24235, 24326, 24351, 24355, 24410, 24413, 24428, 24500, 24511, 24527, 24568, 24570, 24630, 24680, 24687, 24712, 24750, 24794, 24802, 24873, 24886, 24912, 24956, 24990, 25044, 25126, 25144, 25158, 25188, 25254, 25263, 25288, 25295, 25319, 25363, 25372, 25490, 25491, 25524, 25548, 25550, 25581, 25655, 25702, 25705, 25721, 25733, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25787, 25793, 25797, 25801, 25815, 25841, 25858, 25900, 25938, 25975, 26154, 26167, 26203, 26210, 26246, 26290, 26348, 26514, 26552, 26585, 26639, 26642, 26696, 26732, 26819, 26907, 26989, 27098, 27100, 27145, 27196, 27198, 27206, 27247, 27290, 27342, 27365, 27398, 27665, 27691, 27747, 27933, 28078, 28105, 28133, 28194, 28294, 28476, 28481, 28547, 28567, 28607, 28652, 28685, 28690, 28795, 28844, 28963, 29052, 29085, 29175, 29177, 29188, 29368, 29370, 29380, 29389, 29458, 29542, 29598, 29628, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29773, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29829, 29839, 29897, 29902, 29910, 29920, 29937, 29948, 29961, 29968, 29988, 30043, 30062, 30126, 30148, 30152, 30286, 30287, 30288, 30290, 30291, 30295, 30299, 30308, 30315, 30324, 30338, 30374, 30389, 30420, 30435, 30468, 30561, 30574, 30598, 30600, 30670, 30677, 30699, 30779, 30783, 30809, 30839, 30875, 30987, 31050, 31117, 31187, 31198, 31215, 31252, 31279, 31333, 31335, 31344, 31349, 31372, 31394, 31432, 31491, 31695, 31705, 31729, 31767, 31825, 31839, 31847, 31891, 31920, 31933, 31954, 31990, 32088, 32153, 32201, 32247, 32312, 32327, 32347, 32375, 32495, 32563, 32636, 32679, 32688, 32696, 32715, 32742, 32805, 32845, 32879, 32996, 33104, 33120, 33134, 33178, 33262, 33269, 33283, 33295, 33421, 33495, 33520, 33598, 33623, 33653, 33691, 33713, 33763, 33764, 33765, 33768, 33796, 33831, 33834, 33838, 33933, 34013, 34068, 34212, 34215, 34250, 34303, 34306, 34311, 34327, 34339, 34370, 34523, 34553, 34773, 34801, 34852, 34853, 34861, 34873, 34917, 34973, 34983, 34990, 35061, 35083, 35090, 35284, 35294, 35331, 35657, 35663, 35697, 35757, 35772, 35826, 35855, 35892, 35900, 35931, 36109, 36154, 36230, 36235, 36261, 36267, 36294, 36346, 36533, 36639, 36641, 36645, 36658, 36662, 36687, 36720, 36728, 36733, 36847, 36883, 36910, 36963, 37052, 37124, 37209, 37265, 37273, 37281, 37355, 37381, 37399, 37568, 37589, 37607, 37649, 37674, 37677, 37678, 37763, 37796, 37804, 37832, 37869, 37974, 38068, 38159, 38161, 38214, 38299, 38311, 38365, 38656, 38732, 38734, 38762, 38855, 38858, 38868, 38871, 38886, 38896, 38994, 39037, 39042, 39082, 39099, 39178, 39297, 39321, 39323, 39442, 39459, 39473, 39475, 39479, 39483, 39485, 39494, 39498, 39508, 39513, 39517, 39525, 39541, 39551, 39561, 39568, 39582, 39603, 39604, 39642, 39658, 39818, 39848, 39850, 39866, 39874, 39898, 39920, 39922, 39930, 39948, 39993, 40046, 40077, 40146, 40239, 40354, 40401, 40544, 40577, 40609, 40629, 40696, 40797, 40804, 40816, 40958, 41014, 41017, 41022, 41028, 41034, 41078, 41079, 41118, 41119, 41120, 41122, 41127, 41145, 41160, 41306, 41404, 41505, 41509, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41662, 41663, 41666, 41669, 41671, 41672, 41674, 41678, 41680, 41682, 41685, 41686, 41715, 41717, 41718, 41720, 41723, 41785, 41865, 42006, 42052, 42070, 42080, 42108, 42168, 42171, 42175, 42183, 42186, 42191, 42195, 42199, 42205, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 42270, 42397, 42670, 42682, 42694, 42714, 42777, 42886, 43226, 43260, 43289, 43415, 43445, 43475, 43562, 43603, 43635, 43657, 43663, 43747, 43784, 43805, 43887, 44025, 44037, 44049, 44154, 44272, 44286, 44446, 44515, 44519, 44532, 44712, 44718, 44827, 44988, 45311, 45334, 45446, 45600, 45861, 45875, 45903, 45929, 45967, 45970, 45975, 46063, 46103, 46161, 46171, 46274, 46309, 46609, 46616, 46750, 46786, 47007, 47009, 47017, 47023, 47035, 47314, 47406, 47441, 47511, 47555, 47597, 47848, 47896, 47964, 47999, 48384, 48569, 48581, 49419, 49799, 49803, 49869, 50143, 50489, 50774, 50951, 50959, 50997, 51277, 51381, 51392, 51402, 51407, 51576, 51580, 51597, 51606, 51984, 52025, 52060, 52091, 52101, 52129, 52189, 52203, 52506, 52616) 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 Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Devil to Pay

Dance: Dutch Skipper by d'Vallois and Mrs Bullock

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Lovers Opera

Dance: Tambourine by Miss Wherrit. Dutch Skipper by d'Vallois and Mrs Bullock

Song: The Milk Pail Song by Miss Gerrard

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: Flora

Dance: Tambourine by Miss Wherrit. Scot's Dance by Mrs Bullock. Dutch Skipper by Vallois and Mrs Bullock. Milk Pail Song and Dance by Delagarde, Sandham, Mrs Evans, Woodward, Miss Gerrard, Miss Wherrit, Miss Sandham, Mrs Vallois, Mrs Dove

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: Damon and Phillida

Dance: Coquette by Mrs Bullock. Scot's Dance by Miss Wherrit. Wooden Shoe Dance by Vallois. Dutch Skipper by Vallois and Mrs Bullock

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Stoppelaer

Afterpiece Title: The Harlot's Progress

Dance: Hornpipe by Le Brun

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Tavern Bilkers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Stoppelaer

Afterpiece Title: Love Is the Doctor

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Salway

Dance: Tambourine by Miss Rogers. The Kilkenny by Glover and Mrs Laguerre. Scot's Dance by Glover and Mrs Laguerre

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Berry

Afterpiece Title: The School Boy

Dance: Irish Trot by Master Oates. A comic Peasant Dance by Master Oates and Miss Oates Jr. Pierrot by Topham and Mrs Davenport. Scotch Dance by Mr and Mrs Davenport

Performances

Mainpiece Title: The Beggar's Opera, Tragedized

Cast
Role: Macheath Actor: Mrs Charke

Afterpiece Title: The Humours of Sir John Falstaff, Justice Shallow, and Ancient Pistol

Performances

Mainpiece Title: The Beggar's Opera, Tragedized

Cast
Role: Macheath Actor: Mrs Charke

Afterpiece Title: The Humours of Sir John Falstaff

Performances

Mainpiece Title: The Humours Of Sir John Falstaff

Cast
Role: Macheath Actor: Mrs Charke

Afterpiece Title: The Devil to Pay

Afterpiece Title: The Mock Doctor

Dance: The Black and White Joke by Tench and Miss Brett. Harlequin by Miss Brett

Song: Was ever Nymph like Rosamond by Mrs Jones

Performances

Mainpiece Title: The Beggar's Opera, Tragediz'd

Cast
Role: Macheath Actor: Mrs Charke

Afterpiece Title: The Lovers Opera

Dance: Pierrot by Davenport. End of Afterpiece: a new Country Dance

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Roberts

Afterpiece Title: The Devil to Pay

Dance: The Black and White Joak by Davenport and Miss Brett. Harlequin by Miss Brett

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Roberts

Afterpiece Title: The Devil to Pay

Dance: As17340807

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: Scot's Dance, as17340920

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Stoppelaer

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Chymical Counterfeits

Dance: As17341231

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: Jupiter and Io

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Boscawen

Afterpiece Title: Flora

Performances

Mainpiece Title: Abra Mule

Afterpiece Title: Macheath 1n the Shades; or, Bayes at Parnassus

Cast
Role: Macheath Actor: Stoppelaer

Dance: Tambourine by Miss Rogers. Scot's Dance by Glover, Miss Rogers, Le Sac, Miss Baston, Delagarde, Mrs De L'Orme

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: Jupiter and Io

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Stoppelaer

Afterpiece Title: The Country House

Dance: A new Tambourine by Glover and Miss Rogers

Song: Leveridge's Song In Praise of English Roast Beef

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Devil to Pay

Music: A Piece of Hunting-Musick on the French Horn by Mr Charles

Dance: Scot's Dance by Mrs Woodward. Black Joak by Woodward and Mrs Woodward

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Master Norsa

Afterpiece Title: The Lottery