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: Walker

Music: Handel's Water Musick, in which will be performed a Preamble on the Kettle Drums by Job Baker

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Salway

Dance:

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mullart

Afterpiece Title: The Tragedy of Tragedies

Dance: Hornpipe by Taylor

Song: A New Ballad (never sung before) In Praise of English Plumb Pudding by Mullart

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Sandham

Afterpiece Title: The Art of Management; or, Tragedy Expell'd

Entertainment:

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Afterpiece Title: The Necromancer

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: I: A new Comic Ballet by Nivelon and Mlle De L'Isle. II: French Peasants by Lalauze, Mlle D'Hervigni, &c. V: Glover's Scot's Dance

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Charke

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Charke. hathi.

Afterpiece Title: The Deposing and Death of Queen Gin

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Salway

Dance: CClown-Nivelon; Hornpipe-Ferguson; Scot's Dance-Glover, Mrs Laguerre, Desse, Mrs Ogden, Tench, Mlle Delorme

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Afterpiece Title: Apollo and Daphne; or, The Burgomaster Trick'd

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Roberts.

Afterpiece Title: Harlequin Shipwreck'd

Dance: II: A new Serious Dance-Delamayne, Miss Oates

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Roberts.

Afterpiece Title: Harlequin Shipwreck'd

Dance: As17361116

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Roberts.

Afterpiece Title: Harlequin Shipwreck'd

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Roberts.

Afterpiece Title: Harlequin Shipwreck'd

Dance: II: Harlequin-Delamayne

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Afterpiece Title: Britannia; or, The Royal Lovers

Afterpiece Title: The Beggar's Pantomime; or, The Contending Colombines; Intermix'd with Ballad Songs in the Characters of Polly and Lucy

Cast
Role: Harlequin Macheath Actor: Lun Jr

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Britannia

Cast
Role: Harlequin Macheath Actor: Lun Jr

Afterpiece Title: The Beggar's Pantomime

Cast
Role: Harlequin Macheath Actor: Lun Jr

Performances

Mainpiece Title: Ignoramus

Afterpiece Title: Britannia

Cast
Role: Harlequin Macheath Actor: Lun Jr

Afterpiece Title: The Beggar's Pantomime

Cast
Role: Harlequin Macheath Actor: Lun Jr

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Britannia

Cast
Role: Harlequin Macheath Actor: Lun Jr

Afterpiece Title: The Beggar's Pantomime

Cast
Role: Harlequin Macheath Actor: Lun Jr

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: Britannia

Cast
Role: Harlequin Macheath Actor: Lun Jr

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Afterpiece Title: Britannia

Cast
Role: Harlequin Macheath Actor: Lun Jr

Afterpiece Title: The Beggar's Pantomime

Cast
Role: Harlequin Macheath Actor: Lun Jr

Performances

Mainpiece Title: The Country Lasses; Or, The Custom Of The Manor

Afterpiece Title: Britannia

Cast
Role: Harlequin Macheath Actor: Lun Jr

Afterpiece Title: The Beggar's Pantomime

Cast
Role: Harlequin Macheath Actor: Lun Jr