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, 37604, 37632, 37643, 37656, 37665, 37671, 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: The Duenna

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: The Miser

Dance: End: Mirth by Moonshine, as17870928, but _Ratchford, Mrs _Invill

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: Much Ado About Nothing

Dance: As17871107

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Bernard, Blanchard

Dance: End: As17880124

Performances

Mainpiece Title: The Lady Of The Manor

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: The Man Of The World

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Blanchard

Afterpiece Title: Comus

Dance: As17880129

Song: In afterpiece: Sweet Echo-Mrs Ambrose (1st time); accompanied on the hautboy-W. Parke; II: the celebrated Laughing Song from L'Allegro il Penseroso-Bowden

Performances

Mainpiece Title: The Beaux Stratagem

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Positive Man

Cast
Role: Grogg Actor: Blanchard

Dance: As17880129

Performances

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

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Bernard, Blanchard

Dance: As17880121

Performances

Mainpiece Title: The Careless Husband

Performances

Mainpiece Title: The Capricious Lady

Afterpiece Title: The Dumb Cake

Cast
Role: Clown Actor: Blanchard

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Bernard, Blanchard

Dance: As17871129

Performances

Mainpiece Title: The Man Of The World

Performances

Mainpiece Title: The Conscious Lovers

Song: As17880204

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Blanchard

Afterpiece Title: Tantara Rara, Rogues All

Performances

Mainpiece Title: The Belle's Stratagem

Dance: As17871129

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Bernard, Blanchard

Afterpiece Title: Omai

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Philippo Actor: Blanchard

Afterpiece Title: The Commissary

Ballet: End: The Wapping Landlady; or, Jack in Distress. Jack in Distress-Blurton; Wapping Landlady-Mr King; Orange Woman-Mrs Watts

Performances

Mainpiece Title: The Miser

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Philippo Actor: Blanchard

Afterpiece Title: Omai