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

Dance: I: new French Peasant-Poitier, Miss LaTour; II: Comic Dance, as17321209

Performances

Mainpiece Title: Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321216

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: I: French Peasant-Poitier, Miss LaTour; II: new Comic Dance-Nivelon, Mrs Laguerre, Pelling, Mrs Pelling, Newhouse, Miss LaTour, Lesac, Mrs Ogden, Delagarde Jr, Miss Baston

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321219

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321219

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321219

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: I: Tambourine-Miss Rogers; II: Fingalian-Newhouse, Mrs Ogden

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321226

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: I: Tambourine-Miss Rogers; II: Tollet's Ground-Newhouse, Mrs Ogden

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321228

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321228

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321228

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321228

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17321228

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: I: Tambourine-Miss Rogers; II: French Peasant-Poitier, Miss LaTour

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17330104

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17330104

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: As17330104

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance: I: Tambourine-Miss Rogers; II: Sicilian Dance-Glover, Mrs Pelling

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Dance: HHornpipe-Jones

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Dance: HHornpipe-Jones

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Tavern Bilkers

Dance: As17330129

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Mrs Sandham

Afterpiece Title: The Mock Doctor

Dance: HHornpipe-R. Jones , from gf