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: Love In A Village

Afterpiece Title: Annette and Lubin

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Valentine Actor: Macready

Performances

Mainpiece Title: The Miser

Cast
Role: Clerimont Actor: Macready

Afterpiece Title: Rosina

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Bonds without Judgement; or, The Loves of Bengal

Dance: As17870217

Performances

Mainpiece Title: Such Things Are

Cast
Role: Mr Meanright Actor: Macready

Performances

Mainpiece Title: Annette And Lubin

Afterpiece Title: Artaxerxes

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Valentine Actor: Macready

Performances

Mainpiece Title: The Miser

Cast
Role: Clerimont Actor: Macready

Afterpiece Title: Love in a Camp

Dance: As17870131

Performances

Mainpiece Title: Such Things Are

Cast
Role: Mr Meanright Actor: Macready

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Castle Of Andalusia

Performances

Mainpiece Title: The Brothers

Cast
Role: Philip Actor: Macready

Afterpiece Title: The Maid of Bath

Dance: As17870425

Performances

Mainpiece Title: King Henry The Eighth

Cast
Role: Surrey Actor: Macready

Afterpiece Title: The Citizen

Song: As17870326

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Dance: End: The Piping Pedlar- [see17861002]

Song: Afterpiece: an additional song by Piccinni-

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Dance: As17870425

Song: As17870515

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Song: As17870515

Performances

Mainpiece Title: The Grecian Daughter

Cast
Role: Phocion Actor: Macready

Afterpiece Title: The Deserter

Dance: End: The Wapping Landlady, as17870131, but Miss _Cranfield, Miss Rowson

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Afterpiece Title: Bonds without Judgement

Cast
Role: Valentine Actor: Macready
Role: Captain Manly Actor: Macready

Song: As17870515

Performances

Mainpiece Title: The Mourning Bride

Cast
Role: Selim Actor: Macready

Afterpiece Title: Midas

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Afterpiece Title: Bonds without Judgement

Cast
Role: Valentine Actor: Macready
Role: Captain Manly Actor: Macready

Song: As17870515

Performances

Mainpiece Title: The Merry Wives Of Windsor

Cast
Role: Fenton Actor: Macready

Afterpiece Title: Love and War

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Bonds without Judgement

Cast
Role: Valentine Actor: Macready
Role: Captain Manly Actor: Macready

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Afterpiece Title: Bonds without Judgement

Cast
Role: Valentine Actor: Macready
Role: Captain Manly Actor: Macready

Song: As17870515

Performances

Mainpiece Title: Such Things Are

Cast
Role: Mr Meanright Actor: Macready

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: The Poor Soldier

Afterpiece Title: The Cheats of Scapin

Cast
Role: Octavian Actor: Macready

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Afterpiece Title: The Devil to Pay

Song: As17870515

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready

Afterpiece Title: Bonds without Judgement

Cast
Role: Valentine Actor: Macready
Role: Captain Manly Actor: Macready

Song: As17870515

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: Nina

Cast
Role: Valentine Actor: Macready
Role: Captain Manly Actor: Macready

Afterpiece Title: Love a-la-Mode