SELECT * FROM london_stages WHERE eventid IN (1053, 1065, 1159, 1294, 1328, 1473, 1567, 1618, 1670, 1688, 1691, 1736, 1765, 1780, 1878, 1882, 1935, 1937, 1945, 1983, 1984, 1991, 2004, 2022, 2050, 2104, 2113, 2121, 2165, 2193, 2217, 2239, 2272, 2285, 2304, 2348, 2457, 2461, 2511, 2530, 2531, 2562, 2593, 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: 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

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