SELECT * FROM london_stages WHERE eventid IN (44589, 44591, 44593, 44597, 44599, 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, 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, 45208, 45212, 45214, 45216, 45218, 45220, 45222, 45226, 45228, 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, 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, 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, 46580, 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, 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, 48430, 48432, 48437, 48439, 48440, 48443, 48444, 48447, 48535, 48536, 48537, 48541, 48543, 48547, 48549, 48555, 48559, 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, 48677, 48679, 48685, 48687, 48689, 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, 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, 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, 49943, 49945, 49947, 49952, 49957, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 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, 51611) 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: A Cure For The Heart Ache

Afterpiece Title: The Honest Thieves

Cast
Role: Patrick Actor: Macready
Role: Colonel Careless Actor: Macready

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: Two Strings to Your Bow

Cast
Role: Ferdinand Actor: Macready

Song: End: The Little Farthing Rushlight-Young Standen

Performances

Mainpiece Title: The Mask'd Friend

Cast
Role: Sir Harry Portland Actor: Macready

Afterpiece Title: The Folly of Age; or, The Accomplished Lady

Afterpiece Title: Barataria

Afterpiece Title: Harlequin's Medley

Dance: In 2nd piece: A la Parisot, Le Pas Russe-Delpini

Song: In 2nd piece: La Verginella, My dear Molly@oh! what Folly (composed by Carter)-Delpini

Entertainment: Vaudeville. In 4th piece: The Farm Yard- (from The Rape of Proserpine), with the Birth of Harlequin, and his Emancipation from the Egg Shell; The favorite Scene from Aladin of Pantaloon's Death-, and the Whimsical Lamentation of Pierrot; A Jump through a Hogshead of Fire-; and the celebrated Dying and Skeleton Scenes-

Performances

Mainpiece Title: The Belle's Stratagem

Cast
Role: Villars Actor: Macready

Afterpiece Title: The Waterman

Afterpiece Title: The Honest Thieves

Cast
Role: Patrick Actor: Macready
Role: Colonel Careless Actor: Macready

Song: In 2nd piece: The Heaving of the Lead, The Storm-Incledon

Performances

Mainpiece Title: The Rivals

Cast
Role: Fag Actor: Macready

Afterpiece Title: The Waterman

Afterpiece Title: Harlequin and Oberon

Song: 2nd piece: with additional songs-

Performances

Mainpiece Title: Love For Love

Cast
Role: Tattle Actor: Macready

Afterpiece Title: The Devil to Pay

Song: End II piece: The Storm-Incledon; End: The Beggar-Townsend

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Charles Actor: Macready

Afterpiece Title: Between II and III of the above,Sylvester Daggerwood

Afterpiece Title: High Life below Stairs

Dance: In II 3rd piece: A Mock Minuet-R. Palmer, Miss Pope

Song: End I 1st piece: Little Taffline-Mrs Bland

Entertainment: MonologuePrevious 1st piece: Occasional Address-Lacy