SELECT * FROM london_stages WHERE eventid IN (287, 2034, 4615, 5852, 5854, 5856, 5863, 5882, 5889, 6131, 6157, 6338, 6380, 6557, 6597, 6599, 6665, 6724, 6735, 7076, 7102, 15870, 17793, 18001, 18364, 18367, 18371, 18374, 18375, 18378, 18381, 18426, 18430, 18435, 18574, 18673, 18686, 19438, 19448, 19491, 19520, 19522, 19527, 19534, 19583, 28830, 31236, 31253, 31809, 31822, 31823, 34808, 34814, 34819, 34821, 34824, 34826, 34836, 34851, 34852, 34853, 34856, 34858, 34861, 34868, 34871, 34872, 34873, 34874, 34877, 34879, 34880, 34881, 34882, 34883, 34884, 35342, 35347, 35364, 35380, 35387, 35397, 35400, 35403, 35440, 35443, 35446, 35454, 35505, 39108, 40309, 40560, 40769, 40771, 41006, 41015, 41019, 41020, 41026, 41031, 41035, 41065, 41073, 41075, 41081, 41677, 41891, 41907, 43771, 44092, 44589, 44591, 44593, 44597, 44599, 44600, 44612, 44618, 44620, 44621, 44623, 44625, 44628, 44630, 44634, 44636, 44641, 44647, 44650, 44652, 44656, 44668, 44672, 44684, 44688, 44692, 44698, 44703, 44705, 44708, 44710, 44712, 44717, 44723, 44737, 44755, 44762, 44778, 44783, 44785, 44791, 44796, 44799, 44801, 44805, 44808, 44810, 44813, 44815, 44817, 44820, 44822, 44828, 44831, 44836, 44840, 44844, 44847, 44857, 44860, 44874, 44880, 44887, 44891, 44897, 44903, 44907, 44911, 44915, 44917, 44920, 44922, 44927, 44936, 44939, 44941, 44944, 44946, 44949, 44952, 44955, 44957, 44964, 44966, 44971, 44973, 44978, 44980, 44986, 45004, 45011, 45013, 45016, 45020, 45022, 45025, 45030, 45032, 45035, 45037, 45041, 45047, 45135, 45141, 45145, 45147, 45152, 45156, 45158, 45159, 45162, 45164, 45166, 45167, 45169, 45171, 45174, 45176, 45178, 45180, 45182, 45184, 45188, 45192, 45194, 45196, 45198, 45204, 45206, 45207, 45208, 45211, 45212, 45214, 45215, 45216, 45217, 45218, 45220, 45221, 45222, 45225, 45226, 45228, 45229, 45232, 45234, 45240, 45244, 45248, 45252, 45255, 45257, 45262, 45264, 45266, 45269, 45271, 45274, 45280, 45285, 45291, 45297, 45302, 45305, 45307, 45321, 45330, 45333, 45338, 45342, 45344, 45356, 45361, 45369, 45384, 45394, 45397, 45399, 45407, 45412, 45420, 45423, 45425, 45433, 45436, 45438, 45442, 45449, 45454, 45461, 45464, 45469, 45480, 45482, 45490, 45495, 45497, 45500, 45502, 45504, 45506, 45511, 45517, 45519, 45526, 45529, 45534, 45537, 45539, 45542, 45544, 45549, 45552, 45554, 45559, 45562, 45567, 45569, 45574, 45589, 45591, 45700, 45706, 45711, 45714, 45717, 45722, 45731, 45745, 45752, 45758, 45759, 45767, 45795, 45797, 45799, 45801, 45805, 45821, 45835, 45840, 45842, 45848, 45862, 45866, 45869, 45878, 45885, 45888, 45892, 45899, 45928, 45948, 45971, 45984, 45988, 45997, 46020, 46033, 46040, 46042, 46045, 46050, 46060, 46065, 46067, 46073, 46075, 46090, 46095, 46098, 46103, 46112, 46118, 46124, 46130, 46133, 46151, 46169, 46171, 46174, 46176, 46262, 46271, 46275, 46277, 46279, 46281, 46284, 46286, 46287, 46289, 46292, 46294, 46295, 46297, 46301, 46305, 46307, 46311, 46313, 46315, 46317, 46321, 46325, 46327, 46333, 46338, 46341, 46343, 46347, 46351, 46355, 46359, 46363, 46365, 46367, 46373, 46377, 46381, 46383, 46385, 46387, 46391, 46395, 46399, 46411, 46413, 46415, 46423, 46427, 46431, 46436, 46441, 46443, 46448, 46450, 46455, 46462, 46464, 46469, 46471, 46476, 46478, 46481, 46483, 46488, 46490, 46492, 46495, 46500, 46502, 46504, 46506, 46509, 46511, 46519, 46522, 46524, 46533, 46536, 46543, 46550, 46552, 46564, 46574, 46580, 46589, 46590, 46593, 46595, 46598, 46600, 46602, 46604, 46612, 46614, 46617, 46622, 46627, 46632, 46634, 46637, 46639, 46644, 46647, 46649, 46652, 46654, 46657, 46663, 46668, 46671, 46678, 46681, 46683, 46688, 46691, 46695, 46697, 46702, 46705, 46716, 46721, 46723, 46725, 46728, 46734, 46746, 46751, 46758, 46774, 46829, 46838, 46844, 46846, 46847, 46852, 46855, 46861, 46865, 46867, 46871, 46879, 46885, 46887, 46891, 46893, 46895, 46897, 46899, 46905, 46909, 46917, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46935, 46937, 46939, 46941, 46943, 46945, 46947, 46949, 46953, 46955, 46959, 46963, 46967, 46971, 46977, 46981, 46983, 46985, 46991, 46995, 46997, 47001, 47003, 47005, 47011, 47013, 47021, 47025, 47033, 47037, 47039, 47045, 47047, 47049, 47061, 47063, 47066, 47071, 47076, 47079, 47081, 47083, 47088, 47091, 47104, 47114, 47167, 47183, 47198, 47202, 47207, 47209, 47212, 47218, 47220, 47224, 47229, 47235, 47238, 47242, 47244, 47247, 47249, 47253, 47259, 47261, 47266, 47277, 47279, 47283, 47285, 47289, 47291, 47295, 47301, 47309, 47312, 47315, 47320, 47322, 47326, 47413, 47414, 47419, 47424, 47431, 47439, 47442, 47444, 47446, 47449, 47454, 47458, 47459, 47462, 47464, 47470, 47472, 47475, 47478, 47482, 47489, 47495, 47497, 47499, 47507, 47519, 47531, 47533, 47541, 47543, 47547, 47549, 47551, 47557, 47564, 47566, 47568, 47570, 47575, 47580, 47586, 47589, 47595, 47600, 47607, 47616, 47623, 47628, 47637, 47641, 47649, 47651, 47655, 47657, 47659, 47665, 47670, 47678, 47683, 47685, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47767, 47769, 47774, 47779, 47782, 47784, 47787, 47789, 47792, 47794, 47797, 47800, 47803, 47805, 47808, 47810, 47813, 47815, 47820, 47825, 47828, 47833, 47835, 47840, 47843, 47845, 47848, 47850, 47853, 47855, 47858, 47863, 47865, 47867, 47872, 47879, 47882, 47885, 47887, 47890, 47892, 47994, 47997, 48002, 48004, 48008, 48012, 48015, 48017, 48019, 48020, 48023, 48026, 48028, 48032, 48038, 48039, 48043, 48045, 48047, 48049, 48051, 48053, 48055, 48057, 48059, 48061, 48062, 48066, 48070, 48072, 48074, 48076, 48078, 48082, 48084, 48086, 48088, 48090, 48093, 48095, 48097, 48099, 48101, 48103, 48105, 48107, 48109, 48111, 48113, 48115, 48117, 48119, 48121, 48123, 48125, 48127, 48129, 48131, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48186, 48190, 48194, 48197, 48202, 48204, 48216, 48223, 48225, 48229, 48233, 48236, 48238, 48243, 48247, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48278, 48280, 48285, 48289, 48292, 48294, 48299, 48303, 48306, 48308, 48311, 48317, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48344, 48347, 48352, 48354, 48356, 48358, 48361, 48363, 48366, 48368, 48370, 48372, 48375, 48377, 48380, 48382, 48394, 48396, 48404, 48409, 48411, 48416, 48418, 48423, 48425, 48426, 48430, 48432, 48437, 48439, 48440, 48443, 48444, 48447, 48526, 48535, 48536, 48537, 48541, 48543, 48547, 48549, 48555, 48559, 48562, 48563, 48565, 48571, 48573, 48575, 48577, 48579, 48583, 48585, 48588, 48596, 48598, 48603, 48605, 48609, 48613, 48615, 48618, 48620, 48621, 48623, 48625, 48628, 48634, 48635, 48640, 48642, 48643, 48645, 48647, 48654, 48656, 48657, 48664, 48667, 48669, 48672, 48674, 48675, 48676, 48677, 48678, 48679, 48685, 48686, 48687, 48689, 48690, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48712, 48714, 48717, 48719, 48722, 48727, 48729, 48732, 48734, 48735, 48737, 48744, 48745, 48747, 48749, 48752, 48754, 48755, 48761, 48769, 48774, 48777, 48780, 48783, 48789, 48791, 48798, 48801, 48805, 48810, 48815, 48817, 48819, 48826, 48830, 48832, 48835, 48837, 48840, 48849, 48856, 48858, 48863, 48868, 48872, 48874, 48884, 48887, 48896, 48899, 48904, 48909, 48913, 48916, 48927, 48930, 48938, 48942, 48956, 48971, 48980, 48984, 48988, 48998, 49000, 49004, 49018, 49023, 49031, 49036, 49041, 49043, 49046, 49051, 49056, 49058, 49066, 49069, 49086, 49088, 49090, 49097, 49188, 49193, 49199, 49201, 49208, 49209, 49211, 49213, 49214, 49217, 49222, 49224, 49226, 49232, 49238, 49242, 49246, 49248, 49250, 49254, 49256, 49260, 49274, 49340, 49343, 49350, 49357, 49359, 49371, 49385, 49396, 49399, 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, 49495, 49507, 49513, 49517, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49558, 49560, 49563, 49568, 49570, 49573, 49575, 49578, 49580, 49583, 49587, 49589, 49592, 49597, 49599, 49602, 49604, 49607, 49609, 49612, 49614, 49616, 49620, 49625, 49632, 49635, 49637, 49640, 49642, 49644, 49646, 49649, 49650, 49653, 49655, 49657, 49659, 49662, 49667, 49754, 49757, 49759, 49761, 49764, 49766, 49768, 49770, 49772, 49775, 49779, 49783, 49787, 49788, 49791, 49796, 49797, 49799, 49801, 49803, 49807, 49809, 49811, 49813, 49817, 49819, 49823, 49833, 49839, 49841, 49847, 49849, 49851, 49853, 49855, 49857, 49859, 49861, 49865, 49867, 49869, 49873, 49875, 49877, 49881, 49886, 49888, 49891, 49895, 49900, 49910, 49915, 49919, 49921, 49924, 49929, 49933, 49938, 49939, 49943, 49945, 49947, 49952, 49957, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 49999, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50061, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50084, 50087, 50089, 50092, 50094, 50099, 50104, 50106, 50108, 50111, 50113, 50116, 50118, 50121, 50123, 50126, 50128, 50131, 50134, 50136, 50138, 50141, 50143, 50146, 50148, 50151, 50153, 50156, 50161, 50163, 50166, 50170, 50172, 50175, 50177, 50179, 50181, 50186, 50189, 50191, 50193, 50195, 50198, 50200, 50203, 50205, 50210, 50213, 50324, 50327, 50330, 50332, 50334, 50338, 50340, 50345, 50350, 50352, 50353, 50356, 50360, 50361, 50364, 50366, 50368, 50370, 50371, 50374, 50380, 50383, 50385, 50387, 50389, 50391, 50392, 50394, 50396, 50398, 50400, 50402, 50404, 50406, 50408, 50410, 50412, 50414, 50416, 50418, 50422, 50424, 50430, 50433, 50442, 50447, 50449, 50454, 50456, 50458, 50461, 50463, 50466, 50468, 50470, 50475, 50480, 50482, 50492, 50494, 50496, 50506, 50508, 50517, 50549, 50562, 50586, 50600, 50605, 50607, 50611, 50614, 50616, 50628, 50632, 50640, 50684, 50693, 50707, 50714, 50719, 50724, 50728, 50733, 50736, 50739, 50742, 50744, 50749, 50752, 50757, 50759, 50762, 50764, 50772, 50777, 50779, 50782, 50784, 50786, 50790, 50792, 50795, 50797, 50800, 50802, 50805, 50808, 50869, 50871, 50873, 50874, 50875, 51309, 51329, 51336, 51354, 51365, 51590, 51595, 51611, 51625, 51637, 51651, 51665, 51719, 51731, 51769) 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: Venice Preserved

Cast
Role: Elliot Actor: Macready

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: As17901123

Performances

Mainpiece Title: The Toy; Or, Hampton Court Frolics

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: As17901123

Performances

Mainpiece Title: The German Hotel

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: As17901123

Performances

Mainpiece Title: The Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Farmer

Dance: End: The Wapping Landlady- [See17901204]

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beu Actor: Macready

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: End I in V: As17901020; In afterpiece: Dancing, as17901123

Performances

Mainpiece Title: The Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Farmer

Dance: End: The Wapping Landlady-Blurton, Mrs Watts

Performances

Mainpiece Title: Hamlet

Cast
Role: Rosencraus Actor: Macready

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: The Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Farmer

Dance: As17901204

Performances

Mainpiece Title: The Wives Revenged

Afterpiece Title: The Dramatist

Cast
Role: Willoughby Actor: Macready

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: The Orphan

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: As17901123

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Cast
Role: Don Manuel Actor: Macready

Afterpiece Title: Harlequin's Chaplet

Performances

Mainpiece Title: Hamlet

Cast
Role: Rosencraus Actor: Macready

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: As17901123

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: The German Hotel

Cast
Role: Adjutant Actor: Macready
Role: Willoughby Actor: Macready

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: The Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Farmer

Dance: As17901204

Performances

Mainpiece Title: The Farmer

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Midnight Hour

Cast
Role: Adjutant Actor: Macready
Role: Willoughby Actor: Macready

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Dance: As17901123

Performances

Mainpiece Title: The Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Don Manuel Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Don Manuel Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favourite

Cast
Role: Raleigh Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Busy Body

Cast
Role: Charles Gripe Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Blount Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Earl Of Essex

Cast
Role: Raleigh Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: As You Like It

Cast
Role: Le Beu Actor: Macready

Afterpiece Title: The Picture of Paris

Dance: As17901020

Performances

Mainpiece Title: King Lear

Cast
Role: Cornwall Actor: Macready

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Widow Of Malabar

Afterpiece Title: A Divertisement

Cast
Role: Willoughby Actor: Macready

Afterpiece Title: Hob in the Well

Dance: In 2nd piece: Byrn, Miss Blanchet (of dl)