SELECT * FROM london_stages WHERE eventid IN (37239, 37270, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37371, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37436, 37439, 37443, 37445, 37451, 37455, 37460, 37465, 37467, 37470, 37477, 37524, 37560, 37579, 37599, 37602, 37632, 37643, 37665, 37675, 37781, 37789, 37795, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37837, 37845, 37847, 37849, 37852, 37854, 37856, 37858, 37860, 37862, 37866, 37868, 37870, 37874, 37875, 37878, 37887, 37893, 37897, 37902, 37905, 37907, 37909, 37914, 37916, 37919, 37921, 37941, 37943, 37945, 37949, 37951, 37954, 37962, 37969, 37985, 37991, 38050, 38058, 38060, 38070, 38105, 38112, 38123, 38128, 38136, 38151, 38153, 38156, 38158, 38165, 38167, 38172, 38175, 38180, 38183, 38186, 38188, 38192, 38195, 38205, 38207, 38210, 38213, 38216, 38221, 38233, 38320, 38323, 38330, 38334, 38336, 38378, 38387, 38390, 38394, 38417, 38422, 38434, 38439, 38441, 38448, 38450, 38457, 38464, 38471, 38488, 38521, 38523, 38561, 38627, 38634, 38658, 38675, 38680, 38700, 38731, 38894, 39250, 39308, 40591, 45150, 45154, 45159, 45162, 45186, 45190, 45198, 45200, 45210, 45212, 45220, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45305, 45310, 45314, 45316, 45319, 45324, 45328, 45333, 45335, 45342, 45349, 45352, 45354, 45361, 45365, 45369, 45378, 45384, 45386, 45390, 45397, 45403, 45410, 45416, 45420, 45429, 45442, 45451, 45461, 45469, 45472, 45487, 45490, 45497, 45502, 45511, 45515, 45517, 45524, 45526, 45534, 45537, 45539, 45542, 45547, 45554, 45557, 45559, 45562, 45567, 45574, 45584, 45589, 45591, 45693, 45698, 45702, 45704, 45714, 45716, 45726, 45731, 45735, 45740, 45742, 45748, 45750, 45754, 45756, 45758, 45759, 45761, 45763, 45765, 45767, 45769, 45771, 45773, 45777, 45781, 45785, 45789, 45791, 45793, 45795, 45797, 45799, 45803, 45805, 45807, 45809, 45813, 45815, 45817, 45821, 45823, 45825, 45831, 45838, 45840, 45842, 45854, 45856, 45871, 45874, 45876, 45880, 45890, 45897, 45899, 45902, 45904, 45909, 45911, 45914, 45916, 45918, 45920, 45923, 45925, 45930, 45932, 45934, 45937, 45939, 45942, 45944, 45948, 45951, 45954, 45958, 45965, 45967, 45971, 45975, 45978, 45980, 45984, 45988, 46005, 46011, 46020, 46024, 46028, 46031, 46033, 46036, 46038, 46040, 46042, 46045, 46047, 46050, 46052, 46055, 46058, 46063, 46065, 46068, 46070, 46073, 46075, 46080, 46083, 46085, 46093, 46095, 46098, 46100, 46103, 46112, 46115, 46118, 46121, 46127, 46133, 46137, 46140, 46148, 46154, 46157, 46160, 46166, 46169, 46171, 46174, 46176, 46178, 46262, 46269, 46273, 46277, 46279, 46281, 46286, 46287, 46292, 46294, 46295, 46297, 46299, 46301, 46303, 46305, 46309, 46311, 46313, 46315, 46317, 46319, 46321, 46325, 46331, 46333, 46336, 46338, 46345, 46351, 46357, 46361, 46363, 46369, 46373, 46377, 46387, 46389, 46393, 46395, 46397, 46399, 46401, 46405, 46411, 46421, 46423, 46429, 46431, 46436, 46438, 46443, 46448, 46452, 46462, 46469, 46471, 46474, 46476, 46483, 46486, 46490, 46492, 46495, 46500, 46506, 46511, 46519, 46522, 46524, 46529, 46533, 46538, 46543, 46547, 46550, 46552, 46557, 46561, 46564, 46566, 46571, 46575, 46578, 46580, 46585, 46590, 46600, 46602, 46604, 46607, 46609, 46612, 46614, 46617, 46619, 46622, 46627, 46632, 46634, 46637, 46639, 46644, 46647, 46652, 46654, 46657, 46659, 46661, 46663, 46666, 46668, 46671, 46676, 46678, 46681, 46686, 46688, 46691, 46695, 46697, 46700, 46705, 46708, 46713, 46716, 46718, 46721, 46723, 46725, 46726, 46728, 46731, 46732, 46734, 46737, 46743, 46761, 46829, 46836, 46841, 46846, 46847, 46849, 46858, 46863, 46869, 46877, 46879, 46883, 46885, 46887, 46889, 46893, 46897, 46899, 46901, 46903, 46907, 46911, 46913, 46915, 46919, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46935, 46937, 46939, 46943, 46945, 46947, 46949, 46951, 46953, 46955, 46959, 46961, 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, 47047, 47049, 47051, 47053, 47057, 47059, 47061, 47066, 47071, 47073, 47076, 47081, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47167, 47183, 47186, 47192, 47198, 47202, 47204, 47207, 47209, 47212, 47214, 47220, 47224, 47226, 47229, 47235, 47238, 47244, 47247, 47253, 47255, 47259, 47264, 47266, 47270, 47273, 47277, 47279, 47283, 47285, 47289, 47291, 47295, 47297, 47301, 47304, 47306, 47309, 47312, 47314, 47315, 47320, 47322, 47326, 47431, 47434, 47437, 47440, 47441, 47442, 47444, 47446, 47451, 47454, 47456, 47458, 47459, 47462, 47464, 47466, 47467, 47470, 47472, 47474, 47482, 47484, 47487, 47489, 47491, 47495, 47501, 47503, 47505, 47507, 47511, 47515, 47517, 47519, 47521, 47523, 47525, 47529, 47531, 47537, 47539, 47541, 47543, 47547, 47549, 47551, 47555, 47557, 47559, 47561, 47564, 47568, 47575, 47577, 47582, 47593, 47597, 47603, 47619, 47635, 47641, 47643, 47651, 47659, 47661, 47663, 47668, 47674, 47678, 47680, 47693, 47700, 47704, 47707, 47709, 47714, 47719, 47722, 47729, 47734, 47739, 47744, 47754, 47764, 47769, 47774, 47789, 47792, 47794, 47808, 47810, 47815, 47818, 47833, 47838, 47840, 47845, 47848, 47850, 47853, 47855, 47863, 47867, 47869, 47874, 47877, 47879, 47882, 47885, 47890, 47894, 47896, 47994, 47997, 47999, 48000, 48004, 48006, 48008, 48010, 48012, 48019, 48020, 48029, 48038, 48041, 48043, 48045, 48047, 48049, 48051, 48053, 48055, 48057, 48059, 48061, 48062, 48064, 48066, 48068, 48070, 48072, 48074, 48076, 48078, 48080, 48082, 48084, 48086, 48088, 48090, 48093, 48095, 48097, 48099, 48103, 48107, 48109, 48111, 48113, 48115, 48117, 48119, 48121, 48123, 48125, 48127, 48129, 48144, 48148, 48150, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48192, 48199, 48202, 48204, 48216, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48280, 48292, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48339, 48341, 48344, 48347, 48349, 48352, 48354, 48356, 48358, 48361, 48363, 48366, 48368, 48372, 48375, 48377, 48380, 48382, 48384, 48386, 48389, 48391, 48394, 48396, 48398, 48402, 48404, 48407, 48409, 48413, 48418, 48421, 48425, 48427, 48430, 48432, 48435, 48437, 48439, 48444, 48535, 48536, 48539, 48541, 48543, 48545, 48547, 48551, 48557, 48565, 48567, 48569, 48573, 48577, 48579, 48581, 48585, 48588, 48590, 48592, 48596, 48600, 48602, 48603, 48605, 48611, 48613, 48618, 48620, 48621, 48623, 48628, 48631, 48634, 48637, 48640, 48642, 48645, 48651, 48654, 48656, 48657, 48664, 48665, 48667, 48669, 48674, 48677, 48679, 48684, 48687, 48689, 48692, 48694, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48714, 48715, 48717, 48719, 48722, 48724, 48727, 48729, 48732, 48734, 48735, 48742, 48744, 48752, 48754, 48755, 48757, 48759, 48761, 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, 48840, 48851, 48856, 48858, 48860, 48865, 48868, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48942, 48945, 48947, 48952, 48956, 48959, 48961, 48967, 48971, 48980, 48982, 48986, 48988, 48990, 48993, 49000, 49002, 49004, 49007, 49009, 49014, 49016, 49018, 49021, 49023, 49026, 49028, 49033, 49036, 49038, 49041, 49043, 49046, 49048, 49051, 49053, 49056, 49058, 49066, 49069, 49072, 49074, 49077, 49081, 49083, 49086, 49090, 49092, 49095, 49097, 49100) 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: Robin Hood

Afterpiece Title: Animal Magnetism

Cast
Role: Jeff'ry Actor: Blanchard

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: A Bold Stroke for a Wife

Cast
Role: Simon Pure Actor: Blanchard

Dance: As17880924

Performances

Mainpiece Title: The Child Of Nature

Dance: As17881021

Performances

Mainpiece Title: The Highland Reel

Cast
Role: Charley Actor: Blanchard

Afterpiece Title: Duke and No Duke

Dance: As17881107

Performances

Mainpiece Title: The Highland Reel

Cast
Role: Charley Actor: Blanchard

Afterpiece Title: A Bold Stroke for a Wife

Cast
Role: Simon Pure Actor: Blanchard

Dance: As17881107

Performances

Mainpiece Title: The Child Of Nature

Dance: As17881112

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Animal Magnetism

Cast
Role: Jeff'ry Actor: Blanchard

Dance: As17881025

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Child of Nature

Cast
Role: Simon Pure Actor: Blanchard

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Farmer

Cast
Role: Rundy Actor: Blanchard

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: Love in a Village

Dance: End II 2nd piece: As17880915

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Farmer

Cast
Role: Rundy Actor: Blanchard

Afterpiece Title: The Midnight Hour

Performances

Mainpiece Title: The Prophet

Cast
Role: Lazarus Actor: Blanchard

Afterpiece Title: Duke and No Duke

Dance: End: a New Dance, as17881107, but Mrs _Ratchford

Performances

Mainpiece Title: The Prophet

Cast
Role: Lazarus Actor: Blanchard

Afterpiece Title: Catherine and Petruchio

Song: End: God save the King-Bannister, Johnstone, Blanchard, Davies, Darley, Cubitt, Rock, Bonville, Janson, Lee

Performances

Mainpiece Title: The Prophet

Cast
Role: Lazarus Actor: Blanchard

Afterpiece Title: The Child of Nature

Cast
Role: Simon Pure Actor: Blanchard

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Farmer

Cast
Role: Rundy Actor: Blanchard

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: The Child of Nature

Cast
Role: Simon Pure Actor: Blanchard

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Aladin; or, The Wonderful Lamp

Dance: In Afterpiece: Byrne, King, Ratchford, Mrs Watts, Mrs Lloyd, Mrs Ratchford. [Included, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Aladin

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: The Child of Nature

Cast
Role: Simon Pure Actor: Blanchard

Afterpiece Title: Aladin

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Bernard, Blanchard

Afterpiece Title: Aladin

Entertainment: Vaudeville Sparring Match-Mendoza, another celebrated Pugilist

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Blanchard

Afterpiece Title: The Midnight Hour

Dance: End II: Mirth by Moonshine- [see17880915]

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Child of Nature

Cast
Role: Simon Pure Actor: Blanchard

Afterpiece Title: Aladin

Performances

Mainpiece Title: The Way To Keep Him

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Animal Magnetism

Cast
Role: Jeff'ry Actor: Blanchard

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Child of Nature

Cast
Role: Simon Pure Actor: Blanchard

Afterpiece Title: Aladin