SELECT * FROM london_stages WHERE eventid IN (43571, 43576, 43600, 43764, 43783, 43788, 43794, 43811, 43823, 43848, 43855, 43882, 43899, 44047, 44057, 44071, 44104, 44112, 44116, 44128, 44132, 44136, 44138, 44140, 44142, 44144, 44146, 44148, 44150, 44152, 44156, 44158, 44160, 44162, 44164, 44177, 44185, 44187, 44189, 44197, 44238, 44255, 44271, 44318, 44321, 44381, 44393, 44423, 44428, 44473, 44594, 44671, 44714, 44716, 44718, 44722, 44725, 44734, 44742, 44747, 44777, 44786, 44793, 44798, 44800, 44804, 44807, 44814, 44818, 44821, 44829, 44830, 44838, 44839, 44842, 44851, 44855, 44865, 44869, 44875, 44878, 44879, 44882, 44883, 44890, 44894, 44902, 44906, 44910, 44914, 44926, 44933, 44935, 44943, 44948, 44985, 44988, 44997, 45003, 45010, 45019, 45026, 45034, 45142, 45144, 45148, 45151, 45155, 45157, 45161, 45163, 45168, 45170, 45173, 45175, 45181, 45185, 45187, 45189, 45191, 45193, 45197, 45199, 45201, 45205, 45209, 45215, 45217, 45221, 45223, 45225, 45227, 45233, 45235, 45237, 45239, 45241, 45243, 45245, 45247, 45249, 45254, 45259, 45263, 45311, 45318, 45323, 45327, 45329, 45334, 45337, 45343, 45355, 45367, 45368, 45376, 45379, 45388, 45389, 45392, 45396, 45398, 45401, 45402, 45405, 45409, 45414, 45415, 45418, 45424, 45427, 45431, 45435, 45437, 45439, 45441, 45443, 45450, 45453, 45455, 45458, 45463, 45468, 45471, 45476, 45481, 45484, 45486, 45489, 45491, 45496, 45508, 45516, 45518, 45525, 45530, 45533, 45536, 45538, 45543, 45548, 45563, 45571, 45576, 45592, 45594, 45601, 45603, 45691, 45697, 45701, 45713, 45720, 45721, 45728, 45736, 45737, 45760, 45762, 45768, 45774, 45776, 45778, 45780, 45810, 45814, 45822, 45845, 45851, 45859, 45870, 45877, 45891, 45919, 45927, 45941, 45957, 45959, 45964, 45966, 45969, 45972, 45977, 45982, 45985, 45990, 45995, 45996, 45999, 46009, 46010, 46012, 46025, 46030, 46032, 46037, 46039, 46046, 46049, 46054, 46057, 46072, 46074, 46087, 46094, 46102, 46105, 46108, 46114, 46120, 46126, 46129, 46132, 46142, 46147, 46153, 46264, 46270, 46274, 46276, 46280, 46282, 46283, 46288, 46291, 46300, 46304, 46306, 46308, 46310, 46312, 46320, 46324, 46328, 46332, 46340, 46346, 46358, 46360, 46362, 46364, 46368, 46372, 46376, 46378, 46380, 46384, 46388, 46390, 46392, 46394, 46396, 46398, 46400, 46404, 46408, 46410, 46412, 46414, 46416, 46418, 46420, 46424, 46426, 46428, 46432, 46437, 46440, 46442, 46447, 46451, 46456, 46461, 46465, 46470, 46473, 46475, 46477, 46480, 46482, 46487, 46491, 46494, 46496, 46501, 46505, 46510, 46514, 46516, 46518, 46526, 46528, 46530, 46535, 46537, 46540, 46542, 46544, 46551, 46554, 46556, 46558, 46560, 46563, 46568, 46570, 46579, 46582, 46584, 46587, 46592, 46594, 46597, 46599, 46601, 46608, 46613, 46616, 46621, 46623, 46628, 46631, 46638, 46643, 46648, 46651, 46653, 46656, 46658, 46665, 46667, 46672, 46675, 46677, 46680, 46682, 46685, 46687, 46690, 46694, 46696, 46701, 46704, 46710, 46712, 46717, 46722, 46827, 46840, 46842, 46843, 46845, 46848, 46850, 46853, 46859, 46862, 46864, 46866, 46868, 46872, 46874, 46876, 46878, 46880, 46882, 46886, 46890, 46894, 46898, 46902, 46904, 46908, 46910, 46914, 46916, 46924, 46926, 46928, 46932, 46934, 46938, 46940, 46944, 46946, 46948, 46950, 46952, 46956, 46958, 46960, 46962, 46964, 46968, 46970, 46972, 46982, 46984, 46986, 46988, 46992, 46994, 46996, 46998, 47000, 47002, 47004, 47006, 47010, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47040, 47042, 47044, 47046, 47048, 47050, 47054, 47058, 47062, 47065, 47067, 47070, 47072, 47078, 47082, 47085, 47087, 47090, 47095, 47097, 47103, 47107, 47111, 47113, 47118, 47123, 47127, 47136, 47138, 47141, 47143, 47149, 47153, 47158, 47166, 47176, 47182, 47185, 47189, 47195, 47197, 47203, 47206, 47208, 47211, 47213, 47219, 47228, 47230, 47243, 47252, 47254, 47258, 47260, 47269, 47272, 47278, 47284, 47294, 47296, 47303, 47443, 47445, 47448, 47450, 47452, 47453, 47455, 47457, 47460, 47461, 47463, 47465, 47468, 47471, 47476, 47477, 47481, 47483, 47486, 47488, 47490, 47492, 47494, 47498, 47504, 47506, 47510, 47512, 47514, 47516, 47518, 47522, 47524, 47526, 47528, 47530, 47532, 47534, 47536, 47538, 47540, 47542, 47544, 47546, 47550, 47552, 47554, 47556, 47558, 47563, 47567, 47569, 47571, 47574, 47576, 47579, 47581, 47583, 47585, 47588, 47592, 47594, 47596, 47599, 47602, 47604, 47606, 47608, 47610, 47613, 47615, 47618, 47620, 47622, 47624, 47627, 47630, 47634, 47636, 47638, 47640, 47642, 47644, 47646, 47648, 47652, 47656, 47660, 47664, 47667, 47669, 47671, 47673, 47675, 47677, 47679, 47682, 47684, 47687, 47689, 47692, 47695, 47701, 47703, 47708, 47711, 47713, 47718, 47721, 47723, 47726, 47733, 47736, 47741, 47743, 47746, 47748, 47751, 47756, 47758, 47761, 47763, 47768, 47771, 47776, 47778, 47781, 47783, 47791, 47796, 47799, 47804, 47807, 47812, 47817, 47827, 47832, 47834, 47839, 47849, 47852, 47859, 47864, 47868, 47871, 47873, 47876, 47881, 47884, 47886, 47889, 47891, 47893, 47895, 47899, 47901, 47902, 47905, 47907, 47909, 47910, 47995, 47996, 47998, 48001, 48003, 48005, 48007, 48009, 48011, 48013, 48014, 48016, 48022, 48027, 48030, 48031, 48034, 48035, 48037, 48040, 48042, 48044, 48046, 48048, 48050, 48052, 48054, 48056, 48058, 48060, 48063, 48065, 48067, 48069, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48108, 48110, 48112, 48114, 48116, 48118, 48120, 48122, 48124, 48126, 48128, 48130, 48132, 48136, 48138, 48141, 48145, 48147, 48149, 48151, 48153, 48157, 48159, 48161, 48165, 48169, 48171, 48173, 48175, 48177, 48179, 48181, 48183, 48185, 48201, 48203, 48205, 48208, 48210, 48213, 48217, 48219, 48222, 48224, 48230, 48232, 48235, 48237, 48240, 48242, 48244, 48260, 48263, 48265, 48268, 48270, 48272, 48274, 48277, 48279, 48282, 48284, 48286, 48291, 48296, 48305, 48310, 48319, 48338, 48340, 48346, 48353, 48360, 48369, 48376, 48381, 48383, 48390, 48393, 48395, 48397, 48401, 48403, 48408, 48410, 48412, 48415, 48420, 48424, 48426, 48429, 48434, 48436, 48442, 48538, 48542, 48544, 48548, 48550, 48552, 48554, 48556, 48558, 48560, 48562, 48564, 48566, 48568, 48572, 48574, 48576, 48578, 48580, 48582, 48587, 48589, 48593, 48595, 48597, 48599, 48604, 48610, 48612, 48614, 48616, 48622, 48626, 48632, 48636, 48638, 48644, 48646, 48648, 48652, 48666, 48668, 48670, 48676, 48678, 48686, 48688, 48690, 48696, 48698, 48700, 48706, 48710, 48716, 48718, 48720, 48723, 48726, 48728, 48736, 48738, 48746, 48748, 48750, 48756, 48758, 48760, 48762, 48768, 48770, 48772, 48776, 48778, 48780, 48782, 48784, 48786, 48788, 48790, 48792, 48794, 48797, 48799, 48802, 48804, 48806, 48808, 48811, 48813, 48816, 48818, 48820, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48878, 48880, 48883, 48885, 48888, 48891, 48893, 48897, 48900, 48903, 48910, 48914, 48917, 48919, 48924, 48928, 48931, 48934, 48939, 48943, 48946, 48948, 48953, 48957, 48960, 48962, 48979, 48981, 48983, 48985, 48987, 48989, 48992, 48994, 48997, 48999, 49001, 49003, 49008, 49011, 49013, 49015, 49017, 49025, 49030, 49037, 49040, 49045, 49047, 49052, 49055, 49060, 49062, 49065, 49076, 49080, 49082, 49085, 49087, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49117, 49119, 49187, 49194, 49196, 49198, 49200, 49202, 49205, 49207, 49210, 49212, 49213, 49218, 49221, 49223, 49225, 49227, 49230, 49231, 49235, 49239, 49243, 49249, 49255, 49257, 49259, 49261, 49265, 49267, 49271, 49273, 49279, 49281, 49285, 49291, 49295, 49297, 49301, 49304, 49306, 49309, 49311, 49318, 49320, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49358, 49361, 49363, 49365, 49367, 49370, 49372, 49375, 49377, 49379, 49381, 49384, 49389, 49391, 49395, 49398, 49400, 49410, 49417, 49421, 49424, 49426, 49440, 49444, 49451, 49457, 49474, 49479, 49489, 49494, 49521, 49540, 49544, 49549, 49559, 49564, 49574, 49577, 49582, 49584, 49586, 49588, 49591, 49596, 49601, 49606, 49608, 49613, 49615, 49624, 49626, 49629, 49631, 49636, 49639, 49645, 49758, 49767, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49784, 49786, 49789, 49790, 49795, 49798, 49800, 49802, 49806, 49808, 49812, 49814, 49816, 49818, 49820, 49824, 49828, 49830, 49832, 49838, 49844, 49846, 49850, 49854, 49856, 49858, 49860, 49862, 49864, 49866, 49868, 49870, 49872, 49874, 49876, 49880, 49885, 49887, 49890, 49892, 49894, 49901, 49904, 49906, 49911, 49914, 49918, 49920, 49925, 49928, 49932, 49937, 49944, 49946, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50034, 50040, 50043, 50047, 50051, 50054, 50063, 50066, 50069, 50072, 50074, 50078, 50081, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50112, 50115, 50117, 50120, 50122, 50125, 50130, 50133, 50137, 50140, 50142, 50145, 50147, 50150, 50152, 50155, 50157, 50160, 50165, 50171, 50176, 50180, 50183, 50188, 50190, 50192, 50194, 50199, 50202, 50207, 50209, 50212, 50214, 50217, 50218, 50219, 50220, 50228, 50341, 50344, 50347, 50349, 50357, 50372, 50373, 50384, 50386, 50393, 50395, 50401, 50411, 50423, 50427, 50429, 50434, 50437, 50441, 50453, 50457, 50460, 50462, 50465, 50469, 50471, 50474, 50476, 50479, 50481, 50483, 50505, 50511, 50516, 50519, 50521, 50523, 50535, 50539, 50545, 50548, 50550, 50563, 50567, 50572, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50606, 50608, 50610, 50613, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50687, 50689, 50692, 50703, 50706, 50713, 50723, 50727, 50730, 50735, 50741, 50743, 50746, 50748, 50751, 50756, 50761, 50763, 50771, 50773, 50776, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50801, 50811, 50823, 50914, 50920, 50924, 50928, 50930, 50938, 50939, 50943, 50947, 50949, 50960, 50962, 50964, 50970, 50972, 50974, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51002, 51004, 51006, 51011, 51013, 51015, 51017, 51020, 51023, 51026, 51030, 51035, 51037, 51040, 51042, 51049, 51051, 51053, 51060, 51063, 51066, 51070, 51080, 51086, 51089, 51103, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51132, 51134, 51137, 51139, 51141, 51146, 51149, 51151, 51153, 51155, 51158, 51160, 51163, 51165, 51167, 51169, 51172, 51174, 51178, 51181, 51186, 51190, 51193, 51196, 51198, 51202, 51205, 51210, 51217, 51222, 51226, 51233, 51236, 51240, 51243, 51246, 51248, 51251, 51253, 51260, 51262, 51267, 51270, 51272, 51276, 51282, 51287, 51289, 51292, 51297, 51303, 51306, 51313, 51316, 51323, 51330, 51332, 51335, 51340, 51342, 51355, 51357, 51362, 51364, 51367, 51369, 51371, 51373, 51377, 51380, 51382, 51385, 51390, 51491, 51493, 51495, 51504, 51510, 51512, 51518, 51523, 51524, 51528, 51530, 51533, 51538, 51544, 51548, 51570, 51572, 51582, 51588, 51595, 51606, 51612, 51618, 51628, 51630, 51638, 51640, 51642, 51644, 51647, 51649, 51652, 51654, 51661, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51785, 51793, 51796, 51798, 51812, 51819, 51835, 51840, 51842, 51846, 51853, 51868, 51884, 51886, 51894, 51916, 51921, 51923, 51926, 51939, 51943, 51961, 51963, 52061, 52067, 52071, 52073, 52075, 52076, 52078, 52080, 52083, 52084, 52086, 52088, 52098, 52107, 52117, 52121, 52135, 52145, 52159, 52165, 52167, 52177, 52181, 52191, 52193, 52316, 52324, 52333, 52340, 52342, 52346, 52348, 52349, 52352, 52354, 52357, 52358, 52360, 52364, 52370, 52376, 52378, 52381, 52384, 52388, 52390, 52393, 52395, 52397, 52402, 52412, 52414, 52422, 52443, 52448, 52455, 52460, 52467, 52470, 52477, 52480, 52482, 52485, 52489, 52491, 52494, 52498, 52500, 52505, 52508, 52510, 52515, 52518) 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

Afterpiece Title: A New Symphony

Performances

Mainpiece Title: Acis And Galatea; Redemption 0

Afterpiece Title: A New Symphony

Performances

Mainpiece Title: The Messiah; Redemption 0

Performances

Mainpiece Title: The Messiah; Redemption 0

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Romp

Dance: End II: As17870113

Performances

Mainpiece Title: The Resurrection; Redemption 0

Music: End I: concerto violin-Shaw [, as17870307 End II: concerto on violoncello-Mara

Performances

Mainpiece Title: Seduction

Afterpiece Title: The Sultan

Cast
Role: Osmyn Actor: Dignum

Performances

Mainpiece Title: Redemption 0

Performances

Mainpiece Title: Seduction

Afterpiece Title: The Sultan

Cast
Role: Osmyn Actor: Dignum

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Sultan

Cast
Role: Osmyn Actor: Dignum

Performances

Mainpiece Title: Judas Maccabaeus; Redemption 0

Song: End II: an Italian Air-Mme Mara

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Sultan

Cast
Role: Osmyn Actor: Dignum

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Sons of Anacreon

Afterpiece Title: The Quaker

Cast
Role: Lubin Actor: Dignum

Performances

Mainpiece Title: The Heiress

Afterpiece Title: Harlequin's Invasion

Cast
Role: Mercury Actor: Dignum

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Sultan

Cast
Role: Osmyn Actor: Dignum

Dance: End: As17870113; End I: The Minuet de la Cour, as17861125

Song: V: song-Miss Romanzini

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Sultan

Cast
Role: Osmyn Actor: Dignum

Song: Singing, as17861202, but Mrs _Wrighten

Performances

Mainpiece Title: Love For Love

Afterpiece Title: (End of Act II mainpiece) Jewish Courtship

Performances

Mainpiece Title: A School For Fathers

Afterpiece Title: Harlequin's Invasion

Cast
Role: Mercury Actor: Dignum

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Sons of Anacreon

Cast
Role: Lubin Actor: Dignum

Afterpiece Title: The Padlock

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: Harlequin's Invasion

Cast
Role: Mercury Actor: Dignum

Dance: As17870115

Song: As17861226

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Lord Aimworth Actor: Dignum

Afterpiece Title: The Distress'd Baronet

Dance: As17870126

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Captain Macheath Actor: Dignum

Afterpiece Title: Bon Ton

Dance: III: a Hornpipe-Johnston

Song: End I: Primroses deck the Banks' green side (composed by Linley? Sen)-Dignum; End I afterpiece: Bright Phoebus has mounted the Chariot of Day (composed by Hook)-Dignum

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Sons of Anacreon

Cast
Role: Lubin Actor: Dignum

Afterpiece Title: The Deserter

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Bon Ton

Dance: End III: As17870113

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Double Disguise

Song: End III: song-Miss Barnes; End IV: O! Nanny wilt thou go with me (composed by Carter)-Dignum; End: Bright Phoebus has mounted the Chariot of Day-Miss Barnes