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 Travellers In Switzerland

Afterpiece Title: HE WOUD BE A SOLDIER

Cast
Role: Sir Oliver Oldstock Actor: Powel

Dance: As17940225

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

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

Dance: As17940225

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: THE SPRIGS OF LAUREL

Cast
Role: Cruizer Actor: Powel

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HE WOUD BE A SOLDIER

Cast
Role: Sir Oliver Oldstock Actor: Powel

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Areas Actor: Powel

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: HARLEQUIN AND FAUSTUS

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

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Areas Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

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

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: THE POOR SOLDIER

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: COMUS

Song: As17931029

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: HARTFORD BRIDGE

Dance: As17930916

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

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

Dance: As17940225

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: THE HIGHLAND REEL

Cast
Role: Fitzherbert Actor: Powel

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: HARLEQUIN AND FAUSTUS

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

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: THE IRISHMAN IN LONDON

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: THE SAILORS FESTIVAL or All Alive at Portsmouth

Afterpiece Title: MARIAN

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

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

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

Dance: As17940225

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: NETLEY ABBEY

Cast
Role: Mr Sterling Actor: Powel

Performances

Mainpiece Title: The Chances

Cast
Role: Surgeon Actor: Powel

Afterpiece Title: TRISTRAM SHANDY

Afterpiece Title: A DIVERTISEMENT

Cast
Role: Sir Fidget Fearful Actor: Powel

Dance: In 3rd piece a Ballet by Byrn, Mlle St. Amand, Mme Rossi

Song: In Act II of 1st piece a song by Mrs Mountain

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

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

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

Afterpiece Title: NETLEY ABBEY

Cast
Role: Mr Sterling Actor: Powel

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: NETLEY ABBEY

Cast
Role: Mr Sterling Actor: Powel

Dance: Mainpiece: To conclude with The Savoyard, as17940225; End of mainpiece Dermot and Kathlane, as17931022

Performances

Mainpiece Title: Everyone Has His Fault

Cast
Role: Hammond Actor: Powel

Afterpiece Title: THE SAILORS FESTIVAL

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

Afterpiece Title: THE TWO MISERS

Music: End of Act II of mainpiece concerto on the Piano Forte, composed by Krumpholtz, accompanied by the Full Band, by Miss Poole

Song: End of Act IV of mainpiece Mad Bm, in character, by Miss Poole

Performances

Mainpiece Title: Fontainville Forest

Cast
Role: Nemours Actor: Powel

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: HARLEQUIN AND FAUSTUS

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

Dance: As17940225

Performances

Mainpiece Title: British Fortitude And Hibernian Friendship Or An Escape From France

Afterpiece Title: THE LONDON HERMIT or Rambles in Dorsetshire

Cast
Role: Whimmy Actor: Powel

Afterpiece Title: THE SON IN LAW

Cast
Role: Cranky Actor: Powel