SELECT * FROM london_stages WHERE eventid IN (1053, 1065, 1159, 1294, 1328, 1473, 1567, 1618, 1662, 1670, 1688, 1691, 1728, 1736, 1765, 1772, 1777, 1780, 1878, 1882, 1925, 1935, 1937, 1945, 1983, 1984, 1988, 1990, 1991, 2004, 2022, 2050, 2104, 2113, 2121, 2153, 2163, 2165, 2193, 2211, 2217, 2239, 2272, 2275, 2285, 2304, 2348, 2457, 2461, 2511, 2530, 2531, 2562, 2593, 2616, 3083, 3806, 4361, 4370, 4440, 4590, 5289, 5312, 20706, 33237, 33238, 33251, 33797, 33894, 39378, 39952, 39956, 46262, 46266, 46271, 46273, 46275, 46277, 46281, 46284, 46289, 46292, 46294, 46297, 46299, 46301, 46303, 46305, 46307, 46309, 46311, 46315, 46319, 46321, 46323, 46329, 46331, 46333, 46336, 46338, 46341, 46345, 46347, 46355, 46357, 46361, 46365, 46367, 46369, 46373, 46375, 46383, 46385, 46389, 46397, 46401, 46405, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46474, 46476, 46478, 46481, 46483, 46486, 46488, 46492, 46495, 46497, 46502, 46506, 46509, 46511, 46515, 46519, 46522, 46524, 46529, 46536, 46538, 46564, 46566, 46571, 46575, 46578, 46580, 46585, 46590, 46593, 46595, 46598, 46600, 46607, 46609, 46612, 46614, 46617, 46619, 46622, 46629, 46632, 46634, 46637, 46639, 46647, 46649, 46652, 46654, 46657, 46659, 46661, 46663, 46666, 46671, 46676, 46678, 46681, 46683, 46686, 46688, 46691, 46695, 46697, 46700, 46702, 46705, 46708, 46711, 46713, 46716, 46718, 46721, 46723, 46725, 46726, 46728, 46729, 46731, 46732, 46734, 46751, 46758, 46774, 46829, 46833, 46841, 46847, 46849, 46855, 46861, 46863, 46865, 46871, 46875, 46877, 46887, 46889, 46893, 46895, 46901, 46905, 46911, 46917, 46919, 46923, 46925, 46927, 46929, 46931, 46935, 46937, 46939, 46941, 46943, 46947, 46949, 46951, 46953, 46955, 46957, 46959, 46963, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47001, 47003, 47005, 47007, 47009, 47011, 47013, 47015, 47017, 47019, 47021, 47023, 47025, 47027, 47029, 47031, 47033, 47035, 47037, 47039, 47041, 47043, 47045, 47049, 47053, 47055, 47059, 47061, 47066, 47071, 47073, 47076, 47081, 47083, 47086, 47091, 47098, 47104, 47108, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47167, 47173, 47186, 47192, 47198, 47202, 47204, 47209, 47212, 47218, 47220, 47224, 47229, 47231, 47235, 47242, 47244, 47247, 47249, 47253, 47255, 47264, 47266, 47270, 47277, 47279, 47283, 47285, 47295, 47297, 47301, 47306, 47312, 47314, 47315, 47320, 47322, 47326, 47431, 47434, 47440, 47441, 47444, 47446, 47449, 47451, 47454, 47456, 47458, 47459, 47462, 47464, 47466, 47467, 47470, 47472, 47475, 47478, 47482, 47485, 47487, 47489, 47491, 47493, 47495, 47503, 47505, 47507, 47511, 47515, 47517, 47519, 47523, 47525, 47527, 47529, 47531, 47533, 47539, 47543, 47545, 47547, 47551, 47559, 47561, 47568, 47570, 47575, 47577, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47643, 47649, 47659, 47661, 47663, 47665, 47668, 47674, 47678, 47680, 47688, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47769, 47774, 47779, 47782, 47784, 47787, 47789, 47792, 47794, 47797, 47800, 47805, 47808, 47810, 47813, 47815, 47818, 47820, 47825, 47828, 47835, 47838, 47840, 47843, 47845, 47848, 47850, 47853, 47855, 47858, 47860, 47863, 47865, 47867, 47869, 47872, 47877, 47879, 47885, 47892, 47896, 47994, 47997, 48000, 48004, 48006, 48008, 48012, 48015, 48017, 48019, 48020, 48023, 48026, 48029, 48032, 48036, 48039, 48041, 48043, 48045, 48047, 48051, 48053, 48055, 48057, 48059, 48061, 48062, 48064, 48066, 48068, 48070, 48072, 48074, 48076, 48078, 48080, 48082, 48084, 48086, 48090, 48093, 48095, 48097, 48099, 48101, 48103, 48105, 48107, 48111, 48113, 48115, 48117, 48119, 48123, 48125, 48127, 48129, 48131, 48135, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48184, 48186, 48188, 48190, 48192, 48194, 48197, 48199, 48202, 48204, 48206, 48209, 48211, 48214, 48216, 48218, 48220, 48223, 48225, 48229, 48233, 48236, 48238, 48243, 48247, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48278, 48280, 48285, 48289, 48292, 48294, 48299, 48306, 48308, 48311, 48313, 48315, 48317, 48322, 48325, 48329, 48331, 48334, 48336, 48339, 48341, 48344, 48347, 48349, 48352, 48354, 48356, 48358, 48361, 48363, 48366, 48368, 48370, 48372, 48375, 48377, 48380, 48382, 48384, 48386, 48389, 48391, 48394, 48396, 48398, 48402, 48404, 48407, 48409, 48411, 48413, 48416, 48418, 48421, 48423, 48425, 48427, 48430, 48432, 48435, 48437, 48439, 48440, 48443, 48444, 48447, 48535, 48536, 48537, 48539, 48541, 48543, 48545, 48547, 48549, 48553, 48555, 48559, 48561, 48563, 48565, 48567, 48571, 48573, 48575, 48577, 48581, 48583, 48590, 48592, 48594, 48596, 48600, 48603, 48605, 48609, 48611, 48613, 48623, 48625, 48628, 48631, 48635, 48637, 48640, 48642, 48643, 48645, 48647, 48650, 48654, 48656, 48657, 48659, 48664, 48665, 48667, 48669, 48672, 48674, 48675, 48677, 48679, 48684, 48685, 48687, 48689, 48692, 48694, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48712, 48714, 48715, 48717, 48719, 48722, 48724, 48727, 48729, 48732, 48734, 48735, 48737, 48739, 48742, 48744, 48745, 48752, 48754, 48755, 48757, 48759, 48761, 48764, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48824, 48826, 48828, 48830, 48832, 48835, 48837, 48849, 48851, 48856, 48858, 48860, 48865, 48868, 48870, 48872, 48877, 48879, 48890, 48892, 48896, 48899, 48902, 48904, 48909, 48916, 48923, 48930, 48933, 48938, 48942, 48945, 48947, 48952, 48956, 48959, 48961, 48967, 48971, 48980, 48982, 48986, 48988, 48990, 48993, 48995, 48998, 49000, 49002, 49004, 49009, 49012, 49014, 49016, 49018, 49021, 49023, 49026, 49028, 49031, 49033, 49036, 49038, 49041, 49043, 49046, 49053, 49056, 49058, 49061, 49066, 49069, 49072, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49092, 49095, 49100, 49184, 49188, 49191, 49193, 49195, 49197, 49199, 49201, 49203, 49206, 49208, 49209, 49211, 49214, 49219, 49232, 49234, 49236, 49238, 49242, 49246, 49248, 49250, 49254, 49256, 49260, 49262, 49264, 49266, 49270, 49302, 49305, 49307, 49310, 49326, 49328, 49333, 49340, 49343, 49345, 49350, 49354, 49362, 49366, 49371, 49373, 49380, 49387, 49401, 49404, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49441, 49445, 49449, 49452, 49454, 49458, 49462, 49465, 49467, 49472, 49475, 49478, 49480, 49490, 49493, 49495, 49507, 49509, 49513, 49517, 49525, 49543, 49553, 49556, 49558, 49563, 49568, 49570, 49573, 49583, 49585, 49587, 49597, 49599, 49604, 49607, 49609, 49614, 49620, 49625, 49630, 49632, 49635, 49637, 49640, 49642, 49644, 49646, 49650, 49653, 49655, 49657, 49659, 49667, 49754, 49757, 49759, 49761, 49764, 49770, 49775, 49777, 49779, 49780, 49783, 49785, 49787, 49788, 49791, 49797, 49799, 49801, 49803, 49811, 49813, 49817, 49819, 49820, 49821, 49825, 49827, 49829, 49831, 49839, 49843, 49849, 49853, 49857, 49861, 49863, 49869, 49871, 49873, 49877, 49879, 49881, 49883, 49886, 49891, 49893, 49895, 49912, 49915, 49917, 49924, 49929, 49931, 49933, 49938, 49952, 49961, 49975, 49980, 49983, 49985, 49987, 49989, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50106, 50108, 50111, 50113, 50116, 50121, 50128, 50131, 50134, 50136, 50141, 50143, 50146, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50172, 50175, 50177, 50179, 50184, 50186, 50189, 50191, 50193, 50195, 50198, 50200, 50203, 50205, 50210, 50215, 50324, 50327, 50332, 50334, 50336, 50340, 50342, 50345, 50348, 50352, 50353, 50358, 50361, 50364, 50370, 50371, 50374, 50380, 50391, 50392, 50394, 50396, 50408, 50412, 50418, 50422, 50424, 50440, 50447, 50456, 50461, 50463, 50487, 50492, 50498, 50512, 50586, 50597, 50600, 50605, 50607, 50611, 50616, 50628, 50632, 50638, 50640, 50684, 50693, 50714, 50719, 50724, 50728, 50733, 50736, 50742, 50744, 50752, 50754, 50757, 50762, 50764, 50767, 50769, 50774, 50779, 50782, 50786, 50790, 50792, 50795, 50797, 50800, 50802, 50805, 50808, 50823, 50915, 50917, 50919, 50921, 50923, 50925, 50927, 50929, 50932, 50934, 50937, 50942, 50944, 50946, 50948, 50950, 50951, 50953, 50957, 50961, 50963, 50965, 50967, 50969, 50971, 50973, 50975, 50977, 50979, 50981, 50983, 50985, 50987, 50991, 50995, 50999, 51001, 51024, 51043, 51050, 51052, 51057, 51061, 51064, 51069, 51076, 51085, 51090, 51119, 51126, 51133, 51135, 51145, 51147, 51150, 51154, 51156, 51159, 51161, 51164, 51166, 51168, 51170, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51223, 51227, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51266, 51268, 51271, 51283, 51285, 51288, 51290, 51295, 51298, 51300, 51302, 51304, 51307, 51309, 51312, 51317, 51319, 51322, 51327, 51329, 51331, 51336, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51360, 51363, 51365, 51368, 51481, 51484, 51488, 51490, 51494, 51496, 51501, 51503, 51505, 51506, 51509, 51511, 51513, 51514, 51517, 51519, 51521, 51522, 51525, 51527, 51529, 51531, 51532, 51535, 51537, 51541, 51543, 51545, 51557, 51561, 51565, 51569, 51573, 51577, 51581, 51587, 51591, 51613, 51639, 51650, 51657, 51683, 51694, 51710, 51722, 51728, 51750, 51762, 51789, 51866) 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 School For Wives

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: The World In A Village

Cast
Role: Renault Actor: Powel
Role: Sir Henry Check Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: Marian

Cast
Role: Capulet Actor: Powel
Role: Cymbeline Actor: Powel

Afterpiece Title: THE SIEGE OF BERWICK

Cast
Role: Ghost Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Boniface Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: Love In A Village

Cast
Role: Sir William Meadows Actor: Powel

Afterpiece Title: THE MAID OF THE OAKS

Dance: In Act I of afterpiece, Dance, as17931112

Performances

Mainpiece Title: Hamlet

Cast
Role: King Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Song: As17940109

Performances

Mainpiece Title: Douglas

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: Venice Preserved

Cast
Role: Renault Actor: Powel

Afterpiece Title: ROSINA

Performances

Mainpiece Title: Macbeth

Cast
Role: Doctor Actor: Powel
Role: Angelo Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Song: As17931227, but Mrs Follett in place of Mrs Clendining

Performances

Mainpiece Title: Venice Preserved

Cast
Role: Renault Actor: Powel

Afterpiece Title: THE MIDNIGHT WANDERERS

Cast
Role: Don Pedraza Actor: Powel
Role: Serjeant Actor: W. Powel
Role: Recruit Actor: C. Powell

Performances

Mainpiece Title: The Belles Stratagem

Cast
Role: Porter Actor: Powel

Afterpiece Title: OSCAR AND MALVINA

Music: As17940206

Song: In Act IV of mainpiece a Masquerade, in which Old Towler by Incledon

Performances

Mainpiece Title: Loves Frailties

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: The Road To Ruin

Cast
Role: Smith Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: The World In A Village

Cast
Role: Camillo Actor: Powel
Role: Renault Actor: Powel
Role: Sir Henry Check Actor: Powel

Afterpiece Title: THE SPRIGS OF LAUREL

Cast
Role: Cruizer Actor: Powel

Dance: As17931022

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Don Scipio Actor: Powel

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: Wild Oats

Cast
Role: Landlord Actor: Powel

Afterpiece Title: THE FARMER

Cast
Role: Farmer Stubble Actor: Powel

Dance: As17931022

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: Hamlet

Cast
Role: King Actor: Powel

Afterpiece Title: THE POOR SOLDIER

Song: As17940109

Performances

Mainpiece Title: The Tender Husband Or The Accomplished Fools

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Marquis Actor: W. Powel
Role: Lemonadier Actor: C. Powell

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: THE FOLLIES OF A DAY

Cast
Role: Bazil Actor: Powel
Role: Ghost Actor: Powel

Dance: Mainpiece: To conclude with The Savoyard by Byrn, Mlle St. Amand and Mme Rossi

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: THE MIDNIGHT HOUR

Cast
Role: Governor Actor: Powel

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: MODERN ANTIQUES

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HE WOUD BE A SOLDIER

Cast
Role: Sir Oliver Oldstock Actor: Powel

Dance: As17940225