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: TTambourine-Miss Rogers

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Tavern Bilkers

Dance: FFrench Peasant-Mons and Mademoiselle Vallois

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

Dance:

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Walker

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: Harlequin Dr Faustus

Dance: I: A Grand Ballad called La Badine by Lally Sr, Mlle Grognet, from the Opera at Paris, being the first time of her performing on the Engl1sh Stage, Boval, S. Lally, Le Brun, Davenport, Mrs Walter, Miss Mears, Mrs D'Lorme, Mrs Davenport; With new Habits. II: Tambourine by Mlle Grognet. In III: Hornpipe by Le Brun

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Stoppelaer

Dance: I: La Badine, as17331012, but Olbeldiston added. II: Tambourine by Mlle Grognet. In III: Hornpipe by Le Brun

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Tavern Bilkers

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin Dr Faustus

Music: Solo on German Horn, composed by Signior Quantz and performed by Burk Thumoth

Dance: Hornpipe by Le Brun

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Harlot's Progress

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Mock Doctor

Dance: Drunken Peasant by Janno. Whim by F. Tench and Miss Mann. Punches by F. Tench and Janno. Watteau by Miss Robinson

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With The Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With The Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With the Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With The Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Mock Doctor

Dance: As17331026

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Dance: As17331026 Also The Mock Doctor. As17331105

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With The Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With The Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Happy Nuptials: With The Amorous Sportsman

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Devil to Pay

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

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Devil to Pay

Dance: Dutch Skipper by d'Vallois and Mrs Bullock. V: Amorous Sportsman: Sportsman-Thurmond; First Nymph-Mrs Bullock

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: The Devil to Pay

Dance: Dutch Skipper by d'Vallois and Mrs Bullock. Tambourine by Miss Wherrit. Two Pierrots by Vallois and J. Delagarde

Performances

Mainpiece Title: The Wonder

Cast
Role: Macheath Actor: Hulett

Afterpiece Title: Damon and Phillida

Dance: Dutch Skipper by d'Vallois and Mrs Bullock. Scot's Dance by Miss Wherrit. Friendly Lasses by Miss Wherrit and Miss Sandham

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Stoppelaer

Afterpiece Title: Cephalus and Procris