SELECT * FROM london_stages WHERE eventid IN (9466, 9469, 9471, 9504, 9602, 9664, 10218, 10284, 10334, 10399, 10898, 10900, 10902, 10922, 10946, 10954, 10982, 11209, 11239, 11315, 12334, 12337, 12584, 12589, 12592, 12595, 12599, 12602, 12607, 12613, 12617, 12626, 12639, 12644, 12693, 12697, 12698, 12701, 12704, 12713, 12723, 12726, 12734, 12737, 12738, 12741, 12743, 12746, 12749, 12751, 12845, 12852, 12928, 12935, 12941, 16378, 16436, 16486, 16530, 17932, 17975, 18628, 18685, 20722, 20751, 20763, 20766, 20769, 20771, 20796, 20829, 20832, 20835, 20838, 20841, 20845, 20878, 20911, 20941, 21013, 21153, 21157, 21216, 21217, 21310, 23164, 24334, 24337, 24339, 24341, 24344, 24346, 24358, 24361, 24364, 24367, 24369, 24371, 24382, 24384, 24396, 24574, 24578, 24581, 24585, 24587, 24591, 24593, 24595, 24600, 24604, 24607, 24612, 24622, 24645, 24648, 24654, 24661, 24663, 24686, 24696, 24705, 24708, 24724, 24736, 24739, 24742, 24746, 24750, 24752, 24755, 24762, 24788, 24898, 24913, 24944, 24981, 25006, 25010, 25012, 25015, 25017, 25020, 25022, 25042, 25044, 25049, 25061, 25063, 25090, 25098, 25102, 25121, 25159, 25204, 25206, 25210, 25216, 25243, 25277, 25286, 25325, 25330, 25331, 25368, 25379, 25381, 25391, 25403, 25405, 25413, 25443, 25506, 25620, 25622, 25633, 25647, 25657, 25662, 25665, 25680, 25698, 25700, 25704, 25706, 25729, 25736, 25743, 25744, 25749, 25755, 25761, 25812, 25814, 25816, 25822, 25824, 25836, 25842, 25848, 25852, 25857, 25861, 25865, 25869, 25873, 25875, 25884, 25889, 25891, 25893, 25902, 25925, 25935, 25937, 25941, 25952, 25954, 25963, 25969, 25984, 25997, 25999, 26003, 26007, 26010, 26012, 26016, 26022, 26038, 26049, 26055, 26059, 26072, 26080, 26083, 26104, 26127, 26137, 26153, 26158, 29843, 29847, 29849, 29856, 29862, 29869, 29891, 29893, 29895, 29915, 29918, 29922, 29925, 29928, 29930, 29933, 29939, 29944, 29946, 29950, 29955, 29959, 29966, 30013, 30016, 30019, 30040, 30046, 30049, 30058, 30069, 30087, 30089, 30124, 30144, 30314, 30320, 30326, 30344, 30358, 30363, 30368, 30377, 30380, 30382, 30386, 30391, 30394, 30406, 30414, 30416, 30419, 30425, 30437, 30453, 30461, 30476, 30480, 30482, 30485, 30487, 30490, 30494, 30497, 30499, 30505, 30508, 30538, 30547, 30550, 30581, 30588, 30620, 30625, 30634, 30649, 30657, 30681, 30786, 30788, 30797, 30802, 30807, 30813, 30819, 30823, 30831, 30833, 30863, 30889, 30897, 30990, 30996, 31004, 31032, 31046, 31048, 31053, 31064, 31080, 31098, 31113, 31137, 31149, 31152, 31155, 31159, 31163, 31183, 31188, 31195, 31201, 31207, 31209, 31212, 31217, 31226, 31230, 31256, 31332, 31353, 31357, 31359, 31361, 31363, 31367, 31385, 31388, 31390, 31392, 31400, 31404, 31406, 31410, 31412, 31414, 31416, 31420, 31423, 31425, 31427, 31429, 31431, 31433, 31442, 31444, 31446, 31449, 31452, 31454, 31456, 31458, 31460, 31463, 31466, 31503, 31516, 31532, 31559, 31563, 31578, 31581, 31590, 31595, 31603, 31627, 31640, 31646, 31652, 31665, 31676, 31685, 31719, 31838, 31842, 31844, 31846, 31850, 31858, 31860, 31864, 31870, 31890, 31892, 31900, 31906, 31908, 31922, 31964, 31968, 31980, 31986, 31988, 31996, 32001, 32004, 32006, 32013, 32015, 32018, 32024, 32029, 32033, 32035, 32037, 32042, 32048, 32055, 32058, 32060, 32067, 32079, 32082, 32084, 32089, 32096, 32125, 32129, 32132, 32137, 32141, 32156, 32159, 32165, 32172, 32185, 32196, 32209, 32214, 32218, 32219, 32225, 32230, 32234, 32241, 32248, 32253, 32255, 32257, 32259, 32261, 32316, 32326, 32333, 32338, 32340, 32345, 32353, 32359, 32367, 32371, 32373, 32377, 32379, 32381, 32383, 32389, 32391, 32402, 32406, 32412, 32420, 32422, 32426, 32436, 32472, 32482, 32487, 32491, 32501, 32508, 32510, 32519, 32527, 32529, 32534, 32620, 32630, 32645, 32663, 32665, 32675, 32677, 32709, 32716, 32725, 32728, 32735, 32747, 32751, 32806, 32808, 32814, 32818, 32823, 32824, 32833, 32835, 32843, 32859, 32867, 32871, 32873, 32877, 32887, 32889, 32899, 32909, 32927, 32931, 32948, 32959, 32963, 32967, 33023, 33035, 33055, 33083, 33096, 33098, 33122, 33125, 33144, 33149, 33157, 33159, 33167, 33190, 33192, 33196, 33199, 33263, 33286, 33296, 33305, 33310, 33318, 33321, 33326, 33328, 33331, 33337, 33340, 33342, 33356, 33363, 33377, 33379, 33805, 33820, 33824, 33856, 33867, 33874, 33878, 33880, 33883, 33899, 33925, 33936, 33979, 33997, 34001, 34004, 34015, 34018, 34039, 34053, 34138, 34174, 34179, 34198, 34218, 34220, 34245, 34256, 34259, 34262, 34343, 34358, 34364, 34368, 34373, 34382, 34384, 34392, 34403, 34407, 34424, 34432, 34446, 34469, 34480, 34483, 34502, 34512, 34537, 34551, 34558, 34562, 34590, 34607, 34620, 34628, 34632, 34651, 34682, 34697, 34700, 34704, 34708, 34710, 34728, 34737, 34748, 34750, 34752, 34754, 34757, 34768, 34790, 34792, 34802, 34805, 34818, 34894, 34900, 34906, 34948, 34954, 34969, 34978, 35004, 35009, 35015, 35018, 35020, 35023, 35025, 35027, 35029, 35032, 35034, 35037, 35039, 35043, 35046, 35056, 35058, 35065, 35073, 35081, 35084, 35086, 35098, 35100, 35119, 35121, 35123, 35126, 35128, 35136, 35139, 35146, 35150, 35170, 35173, 35193, 35290, 35328, 35336, 35355, 35361, 35366, 35499, 35504, 35523, 35529, 35540, 35544, 35548, 35552, 35554, 35561, 35578, 35582, 35591, 35606, 35616, 35620, 35625, 35630, 35634, 35643, 35654, 35664, 35670, 35673, 35682, 35687, 35689, 35692, 35703, 35708, 35722, 35724, 35729, 35745, 35755, 35760, 35770, 35857, 35861, 35898, 35944, 35958, 35961, 35974, 35987, 36110, 36114, 36117, 36585, 36586, 36605, 36613, 36618, 37121, 37141, 37144, 37146, 37165, 37170, 37172, 37175, 37177, 37178, 37179, 37180, 37181, 37183, 37186, 37189, 37190, 37191, 37193, 37197, 37199, 37201, 37204, 37207, 37711, 37715, 37718, 37720, 37728, 37732, 37744, 37749, 37754, 37760, 37766, 37789, 38308, 38866, 38880, 38892, 38902, 38917, 38933, 38938, 38945, 38952, 38966, 38973, 38977, 38980, 38983, 38989, 38991, 38994, 38996, 38999, 39001, 39007, 39012, 39016, 39018, 39021, 39023, 39027, 39037, 39050, 39061, 39075, 39084, 39087, 39089, 39091, 39096, 39103, 39108, 39200, 39206, 39211, 39214, 39217, 39220, 39223, 39226, 39231, 39235, 39243, 39251, 39258, 39263, 39266, 39281, 39286, 39289, 39299, 39304, 39307, 39316, 41146, 41170, 41180, 41195, 41221, 41263, 42290, 42319, 42323, 42349, 42351, 42356, 42358, 42366, 42382, 42388, 42416, 42429, 42451, 42471, 42478, 42503, 42641, 42648, 42667, 42676, 42681, 42691, 42696, 42701, 42706, 42718, 42730, 42734, 42746, 42859, 42865, 42892, 42913, 42915, 42917, 42919, 42921, 42925, 42927, 42933, 42937, 42943, 42955, 42957, 42967, 42969, 42996, 43000, 43014, 43035, 43042, 43049, 43053, 43061, 43071, 43073, 43088, 43097, 43100, 43103, 43171, 43175, 43179, 43197, 43199, 43231, 43246, 43276, 43297, 43302, 43438, 43483, 43489, 43495, 43505, 43511, 43516, 43524, 43526, 43528, 43530, 43605, 43609, 43632, 43648, 43652, 43677, 43728, 43794, 43800, 43823, 43828, 43835, 43837, 43840, 43843, 43846, 43848, 43851, 43855, 43857, 43872, 43877, 43880, 43885, 44028, 44030, 44038, 44044, 44055, 44060, 44062, 44064, 44069, 44073, 44075, 44077, 44079, 44082, 44088, 44092, 44104, 44106, 44126, 44128, 44130, 44136, 44142, 44148, 44150, 44154, 44160, 44162, 44166, 44185, 44195, 44207, 44232, 44246, 44248, 44260, 44264, 44278, 44283, 44302, 44368, 44378, 44381, 44401, 44406, 44408, 44411, 44438, 44443, 44448, 44461, 44463, 44466, 44471, 44619, 44629, 44631, 44633, 44642, 44649, 44651, 44655, 44659, 44667, 44675, 44687, 44691, 44699, 44702, 44704, 44707, 44714, 44720, 44730, 44732, 44734, 44745, 44747, 44751, 44763, 44768, 44779, 44788, 44795, 44800, 44802, 44807, 44812, 44816, 44818, 44821, 44830, 44833, 44856, 44906, 44908, 44916, 44933, 44938, 44945, 44948, 44954, 44958, 44963, 44965, 44970, 44977, 44991, 44994, 45000, 45010, 45015, 45024, 45034, 45140, 45142, 45146, 45148, 45149, 45151, 45160, 45161, 45163, 45173, 45183, 45187, 45193, 45199, 45201, 45209, 45213, 45231, 45237, 45243, 45247, 45256, 45261, 45263, 45265, 45270, 45273, 45275, 45279, 45282, 45284, 45288, 45290, 45292, 45294, 45296, 45304, 45306, 45309, 45332, 45337, 45339, 45346, 45348, 45351, 45353, 45371, 45393, 45402, 45406, 45419, 45435, 45437, 45441, 45445, 45450, 45453, 45460, 45468, 45499, 45505, 45514, 45520, 45523, 45525, 45533, 45536, 45538, 45541, 45543, 45548, 45551, 45553, 45558, 45563, 45571, 45581, 45594, 45596, 45599, 45601, 45691, 45695, 45697, 45699, 45705, 45720, 45721, 45723, 45730, 45736, 45741, 45746, 45747, 45755, 45760, 45762, 45764, 45766, 45774, 45776, 45778, 45782, 45786, 45790, 45794, 45804, 45806, 45810, 45812, 45814, 45818, 45822, 45826, 45830, 45834, 45839, 45843, 45845, 45847, 45849, 45851, 45857, 45859, 45863, 45868, 45870, 45873, 45877, 45891, 45899, 45902, 45904, 45908, 45919, 45922, 45924, 45927, 45931, 45933, 45947, 45950, 45953, 45957, 45966, 45974, 45983, 45987, 45990, 45992, 46001, 46004, 46006, 46010, 46014, 46019, 46027, 46030, 46039, 46041, 46051, 46057, 46067, 46069, 46072, 46074, 46079, 46084, 46087, 46094, 46102, 46108, 46117, 46126, 46132, 46136, 46139, 46156, 46159, 46260, 46264, 46268, 46276, 46280, 46282, 46283, 46288, 46290, 46291, 46296, 46300, 46304, 46310, 46316, 46320, 46328, 46330, 46332, 46337, 46340, 46344, 46346, 46352, 46354, 46358, 46370, 46394, 46414, 46422, 46426, 46435, 46463, 46489, 46494, 46499, 46503, 46523, 46535, 46537, 46549, 46551, 46560, 46565, 46574, 46589, 46592, 46601, 46603, 46618, 46631, 46638, 46648, 46653, 46660, 46670, 46677, 46682, 46685, 46687, 46690, 46696, 46701, 46710, 46717, 46831, 46840, 46843, 46848, 46853, 46857, 46864, 46866, 46876, 46888, 46896, 46906, 46910, 46932, 46934, 46944, 46946, 46948, 46952, 46958, 46970, 46978, 46980, 46994, 47008, 47016, 47020, 47036, 47046, 47048, 47056, 47062, 47075, 47090, 47092, 47100, 47116, 47130, 47143, 47147, 47149, 47155, 47172, 47185, 47203, 47206, 47208, 47219, 47223, 47228, 47237, 47241, 47246, 47252, 47258, 47269, 47294, 47303, 47445, 47448, 47455, 47457, 47463, 47471, 47473, 47480, 47481, 47483, 47486, 47488, 47494, 47496, 47498, 47502, 47508, 47512, 47520, 47522, 47534, 47536, 47538, 47542, 47546, 47550, 47554, 47556, 47560, 47569, 47571, 47574, 47579, 47581, 47583, 47585, 47590, 47592, 47594, 47599, 47615, 47627, 47644, 47646, 47648, 47658, 47667, 47669, 47679, 47682, 47699, 47703, 47713, 47723, 47728, 47736, 47738, 47743, 47748, 47758, 47763, 47768, 47778, 47781, 47791, 47796, 47799, 47802, 47804, 47807, 47809, 47812, 47814, 47817, 47819, 47822, 47829, 47832, 47837, 47842, 47847, 47852, 47854, 47859, 47862, 47866, 47871, 47878, 47893, 47899, 47992, 47998, 48003, 48005, 48021, 48025, 48031, 48033, 48037, 48042, 48044, 48046, 48048, 48054, 48058, 48065, 48067, 48073, 48075, 48077, 48098, 48104, 48106, 48110, 48116, 48143, 48155, 48159, 48167, 48171, 48177, 48179, 48203, 48219, 48224, 48232, 48235, 48246, 48256, 48265, 48284, 48288, 48321, 48343, 48346, 48353, 48360, 48362, 48383, 48390, 48393, 48403, 48406, 48408, 48429, 48431, 48617, 51159, 51509, 51513, 51517, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51914) 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 Lunatick

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Mrs Ward.

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Lunatick

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Metamorphosis

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Mrs Ward.

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Rose Actor: Miss Ward

Afterpiece Title: The Humours of Harlequin

Cast
Role: Aurora Actor: Mrs Ward

Performances

Mainpiece Title: Hurlothrumbo; Or, News From Terra Australis Incognita: With The Whimsical Flights Of My Lord Flame

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Cobler's Opera

Cast
Role: Jenny Actor: Mrs Ward.

Dance: TTwo Pierrots-Salle, Pelling; Fingalian-Newhouse, Mrs Ogden; Scottish Dance-Mrs Bullock

Performances

Mainpiece Title: Hurlothrumbo

Dance: HHarlequin-a Gentleman that never appeared on the Stage before

Song: CCharming Warblers-Mrs Hill