SELECT * FROM london_stages WHERE eventid IN (1567, 9979, 9981, 13371, 15479, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18620, 18803, 18950, 18954, 18956, 18959, 18961, 18963, 18965, 18968, 18970, 18973, 19019, 19024, 19027, 19031, 19045, 19322, 20114, 20434, 20450, 20719, 20799, 20886, 20960, 20966, 21000, 21033, 21277, 21295, 21712, 21736, 21792, 21819, 21831, 22267, 22759, 22833, 22834, 22956, 22958, 22961, 23002, 23011, 23020, 23055, 23090, 23106, 23127, 23156, 23247, 23351, 23369, 23389, 23433, 23501, 23551, 23555, 23595, 23606, 23626, 23667, 23670, 23861, 23875, 23894, 23925, 23928, 23932, 23935, 23944, 23987, 23988, 23990, 24001, 24002, 24017, 24059, 24064, 24159, 24182, 24185, 24201, 24214, 24235, 24292, 24298, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24326, 24351, 24355, 24410, 24428, 24500, 24527, 24568, 24570, 24630, 24680, 24712, 24750, 24771, 24775, 24779, 24789, 24794, 24796, 24799, 24802, 24812, 24813, 24873, 24912, 24956, 24990, 25044, 25126, 25144, 25158, 25188, 25263, 25288, 25295, 25319, 25372, 25490, 25524, 25548, 25550, 25554, 25655, 25675, 25688, 25702, 25705, 25721, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25787, 25793, 25797, 25801, 25815, 25841, 25858, 25900, 25938, 25975, 26088, 26134, 26154, 26203, 26331, 26334, 26337, 26340, 26343, 26346, 26349, 26354, 26357, 26360, 26375, 26380, 26385, 26390, 26395, 26400, 26405, 26410, 26415, 26420, 26425, 26428, 26433, 26438, 26443, 26448, 26453, 26458, 26463, 26468, 26471, 26474, 26477, 26480, 26483, 26486, 26489, 26492, 26498, 26503, 26506, 26510, 26636, 26639, 26819, 26907, 27100, 27145, 27196, 27198, 27206, 27247, 27290, 27342, 27365, 27398, 27453, 27528, 27530, 27539, 27547, 27640, 27647, 27665, 28078, 28119, 28133, 28194, 28274, 28294, 28476, 28481, 28534, 28536, 28545, 28547, 28552, 28557, 28559, 28567, 28592, 28598, 28601, 28606, 28607, 28608, 28612, 28632, 28637, 28640, 28650, 28652, 28685, 28688, 28690, 28693, 28698, 28704, 28795, 28844, 29052, 29085, 29188, 29368, 29370, 29380, 29389, 29458, 29542, 29598, 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, 30089, 30099, 30101, 30107, 30112, 30117, 30126, 30128, 30148, 30152, 30275, 30277, 30278, 30280, 30281, 30284, 30285, 30286, 30288, 30291, 30295, 30299, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30337, 30374, 30408, 30410, 30420, 30450, 30561, 30566, 30575, 30670, 30686, 30690, 30695, 30699, 30779, 30783, 30787, 30793, 30800, 30801, 30803, 30808, 30809, 30814, 30839, 30852, 30875, 30878, 30900, 30916, 30928, 30947, 30983, 30987, 31050, 31117, 31187, 31198, 31203, 31215, 31247, 31252, 31279, 31333, 31335, 31344, 31349, 31372, 31394, 31432, 31491, 31523, 31526, 31535, 31569, 31605, 31617, 31626, 31642, 31657, 31673, 31677, 31689, 31695, 31700, 31705, 31725, 31729, 31731, 31740, 31749, 31758, 31767, 31771, 31825, 31839, 31847, 31877, 31881, 31885, 31887, 31891, 31920, 31933, 31954, 31990, 32088, 32153, 32201, 32235, 32247, 32258, 32264, 32312, 32327, 32342, 32346, 32347, 32348, 32366, 32375, 32495, 32563, 32636, 32666, 32671, 32676, 32679, 32685, 32688, 32696, 32699, 32715, 32719, 32723, 32724, 32742, 32748, 32785, 32786, 32789, 32800, 32801, 32802, 32803, 32804, 32805, 32813, 32815, 32817, 32822, 32838, 32845, 32879, 32996, 33104, 33106, 33120, 33134, 33159, 33178, 33201, 33262, 33269, 33283, 33295, 33421, 33495, 33520, 33598, 33623, 33648, 33653, 33665, 33670, 33679, 33689, 33691, 33694, 33699, 33701, 33703, 33708, 33711, 33713, 33714, 33716, 33830, 33834, 33836, 33838, 33848, 33850, 33880, 33899, 33941, 33954, 33956, 33968, 33973, 33983, 33987, 34006, 34013, 34020, 34068, 34073, 34079, 34185, 34190, 34200, 34205, 34208, 34215, 34220, 34228, 34230, 34235, 34238, 34250, 34266, 34351, 34370, 34382, 34417, 34434, 34490, 34499, 34519, 34553, 34718, 34725, 34730, 34733, 34735, 34737, 34748, 34752, 34757, 34764, 34766, 34773, 34776, 34790, 34801, 34896, 34916, 34917, 34942, 34956, 34973, 34983, 34990, 35020, 35056, 35061, 35083, 35090, 35114, 35203, 35282, 35284, 35290, 35294, 35297, 35317, 35331, 35333, 35349, 35358, 35363, 35514, 35515, 35643, 35663, 35697, 35757, 35772, 35793, 35826, 35855, 35861, 35884, 35887, 35892, 35900, 35906, 35928, 35941, 35944, 35946, 35950, 35964, 35984, 35990, 36085, 36109, 36154, 36230, 36235, 36261, 36267, 36294, 36346, 36533, 36639, 36640, 36641, 36645, 36658, 36662, 36687, 36720, 36728, 36733, 36847, 36883, 36910, 36956, 36963, 37036, 37037, 37045, 37050, 37052, 37056, 37058, 37068, 37073, 37096, 37108, 37124, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37190, 37193, 37199, 37201, 37204, 37207, 37209, 37219, 37222, 37226, 37240, 37242, 37258, 37265, 37273, 37281, 37289, 37302, 37308, 37320, 37332, 37334, 37339, 37355, 37374, 37381, 37399, 37401, 37415, 37423, 37449, 37546, 37549, 37568, 37575, 37580, 37589, 37593, 37595, 37600, 37603, 37607, 37612, 37614, 37617, 37619, 37636, 37644, 37647, 37649, 37652, 37663, 37666, 37674, 37676, 37677, 37678, 37763, 37796, 37804, 37832, 37869, 37974, 38068, 38159, 38161, 38214, 38311, 38365, 38406, 38656, 38732, 38734, 38762, 38858, 39850, 39867, 39876, 39878, 39887, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40619, 41520, 41552, 41557, 41559, 46484, 46493, 46498, 46507, 46512, 46520, 47885, 48384, 48409, 48411, 48430, 49597, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50215, 50374, 50380, 50382, 50384, 50385, 50386, 50387, 50397, 50405, 50407, 50411, 50415, 50423, 50427, 50432, 50437, 50439, 50451, 50453, 50460, 50465, 50474, 50479, 50481, 50505, 50507, 50509, 50514, 50519, 50528, 50533, 50535, 50542, 50548, 50550, 50553, 50561, 50563, 50565, 50570, 50585, 50590, 50592, 50594, 50599, 50619, 50643, 50649, 50655, 50661, 50667, 50673, 50687, 50692, 50696, 50701, 50706, 50711, 50721, 50723, 50725, 50741, 50771, 50778, 50789, 50799, 50804, 50811, 50816, 51550, 51554, 51556, 51558, 51560, 51564, 51568, 51586, 51590, 51604, 51614, 51616, 51879) 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: Hornpipe Actor: Yates.

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Yates.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: In III a Hornpipe Actor: Vaughan.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Performances

Mainpiece Title: Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Afterpiece Title: Tea

Performances

Mainpiece Title: Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Mathews
Role: In III a Hornpipe Actor: Vaughan.

Dance: I: Grand Ballet, as17471102; II: Dutch Dance, as17471128

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Mathews
Role: In III a Hornpipe Actor: Vaughan.

Afterpiece Title: The Anatomist

Dance: II: New Comic Dance call'd The Savoyards-Matthews

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Mathews
Role: In III a Hornpipe Actor: Vaughan.

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Afterpiece Title: Tea

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Afterpiece Title: Tea

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: as usual.

Afterpiece Title: Tea

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Mathews
Role: In III a Hornpipe Actor: Vaughan.

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Fair Quaker Of Deal; Or, The Humours Of The Navy

Cast
Role: Hornpipe Actor: Oates.

Afterpiece Title: Pyramus and Thisbe

Song: I: Duet-Mrs Lampe, Miss Young; IV: Myself I Shall adore by Handel-Mrs Lampe

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Oates.
Role: Hornpipe Actor: as usual.

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Perplex'd Husband

Cast
Role: Hornpipe Actor: Philips.

Song: I: Beard; III: Consider Fond Shepherd, Tis Liberty alone-Mrs Storer

Dance: II: Drunken Peasant-Philips; IV: The Amorous Swain, or Rival Nymphs-LaLauze, Mrs Delagarde, Miss Hillyard; V: a Ball Minuet (By Desire)-three scholars of LaLauze

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: The Lying Valet

Cast
Role: the Hornpipe Actor: Mathews.

Dance: III: Savoyards, as17471215; IV: Pastoral Dance-Cooke, Janneton Auretti[, as17480320

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Hornpipe Actor: Mathews
Role: In III a Hornpipe Actor: Vaughan.

Afterpiece Title: The King and Miller of Mansfield

Dance: I: Savoyards, as17471215

Performances

Mainpiece Title: The Northern Heros

Cast
Role: Count Piper Actor: Thomson

Afterpiece Title: The Volunteers; or, The Adventures of Roderick Random and his Friend Strap

Dance: Mr Shawford, Mrs Shawford, Master Cross, Mrs Vaughan

Performances

Mainpiece Title: He Northern Heroes; Or, The Bloody Contest Between Charles The Twelfth, King Of Sweden, And Peter The Great, Czar Of Muscovy

Cast
Role: Count Piper Actor: Thomson

Afterpiece Title: The Volunteers; or, The Adventures of Roderick Random and His Friend Strap

Dance: Particularly a Hornpipe-

Performances

Mainpiece Title: He Northern Heroes

Cast
Role: Count Piper Actor: Thomson

Afterpiece Title: The Volunteers