SELECT * FROM london_stages WHERE eventid IN (12035, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12500, 12502, 12506, 12512, 12521, 12527, 12546, 19878, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20242, 20248, 20264, 20434, 20450, 20630, 20729, 20732, 20735, 20739, 20742, 20799, 20886, 20913, 20916, 20960, 21000, 21033, 21295, 21352, 21394, 21473, 21561, 21638, 21712, 21736, 21792, 21819, 21831, 22789, 22819, 22940, 22954, 22956, 22958, 22961, 22990, 22992, 22995, 23002, 23011, 23055, 23064, 23081, 23090, 23106, 23115, 23125, 23127, 23156, 23207, 23215, 23238, 23247, 23254, 23351, 23369, 23389, 23433, 23501, 23510, 23518, 23551, 23555, 23595, 23606, 23626, 23659, 23667, 23670, 23709, 23731, 23815, 23861, 23875, 24017, 24059, 24064, 24185, 24351, 24570, 24712, 24802, 24873, 24990, 25044, 25288, 25295, 25319, 25372, 25490, 25524, 25548, 25550, 25655, 25702, 25721, 26203, 26639, 26819, 26907, 27100, 27196, 27198, 27206, 27342, 27665, 28078, 28476, 28481, 28547, 28567, 28607, 28844, 29052, 29085, 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, 33764, 33765, 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, 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, 37589, 37607, 37649, 37674, 37677, 37678, 37763, 37796, 37804, 37832, 37869, 37974, 38068, 38159, 38161, 38214, 38299, 38311, 38365, 38656, 38732, 38734, 38762, 38858, 39037, 39042, 39082, 39178, 39321, 39442, 39475, 39479, 39483, 39485, 39494, 39498, 39517, 39551, 39561, 39568, 39582, 39604, 39642, 39658, 39848, 39850, 39874, 39898, 40046, 40077, 40146, 40239, 40354, 40401, 40577, 40609, 40629, 40696, 40797, 40804, 40816, 40958, 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, 42320, 42397, 42670, 42682, 42694, 42714, 42777, 43260, 43415, 43445, 43475, 43562, 43603, 43635, 43663, 43747, 43805, 43887, 44037, 44049, 44154, 44286, 44446, 44515, 44519, 44532, 44712, 44718, 44827, 44988, 45446, 45861, 45875, 45903, 45929, 45970, 46161, 46274, 46616, 46750, 46786, 47406, 47964, 49419, 51576, 51580, 51597, 51606, 51984, 52091, 52101, 52129, 52189, 52203) 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: Diana Trapes Actor: Mrs Copen

Afterpiece Title: The Upholsterer

Dance: II: The Fingalian Dance-Miss Hilliard

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: Polly Honeycombe

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: The Hermit

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Dance: TThe Vintage, as17661011; II: The Italian Bakers, as17661011

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: The Hermit

Dance: II: The Vintage, as17661011

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Copin

Afterpiece Title: The Englishman in Paris

Dance: II: The Village Romps, as17661008

Entertainment: OOccasional Prologue-Ross; The London Cries-Shuter

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Copin

Afterpiece Title: Lethe

Dance: II: The Female Archer, as17661215

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Copin

Afterpiece Title: The Upholsterer

Dance: TThe Female Archer, as17661215

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Copin

Afterpiece Title: The Citizen

Dance: II: The Village Romps, as17661008; End Opera: The Female Archer, as17661215

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Copin

Afterpiece Title: The Upholsterer

Dance: II: The Female Archer, as17661215

Song: End: two favourite songs in the Italian Manner-Squibb

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Copin

Afterpiece Title: The Upholsterer

Song: I: A favourite song from Judith-Miss Brickler; accompanied on a new instrument call'd Piano Forte-Dibdin

Dance: II: A Comic Dance, Blind Man's Buff-Arnauld, Miss Valois. [See17641003.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Johnson

Afterpiece Title: The School Boy

Dance: FFingalian-; New Hornpipe, as17670805

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Jeffreys

Afterpiece Title: The Knights

Dance: FFingalian-; New Hornpipe, as17670805

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Dance: III: A Hornpipe-Mrs King; A Country Dance-

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Pitt

Afterpiece Title: Harlequin Dr Faustus

Dance: II: The Irish Lilt, as17670921

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Pitt

Afterpiece Title: Harlequin Dr Faustus

Dance: II: The Irish Lilt, as17671013

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: Harlequin's Invasion

Dance: I: The Lilliputian Camp, as17671202

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Pitt

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Pitt

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Bradshaw

Afterpiece Title: The Absent Man

Dance: II: The Wake, as17680220

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Pitt

Afterpiece Title: Lethe

Dance: II: The Irish Lilt, as17670921

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Pitt

Afterpiece Title: The Upholsterer

Ballet: End of Opera: The Wapping Landlady. As17680416