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: She Would And She Would Not

Afterpiece Title: A Trip to Scotland

Cast
Role: Cupid Actor: Mas. Blanchard

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Jubilee

Dance: II: The Jealous Harlequin, as17760117

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: Medea

Afterpiece Title: The Deserter

Dance: End: The Grand Garland Dance-, as17760302 but Sga _Pacini

Performances

Mainpiece Title: Cyrus

Afterpiece Title: A Peep behind the Curtain

Entertainment: End: (for the last time) Comic Paraphrase on Shakespeare's Seven Ages-King

Dance: End Entertainment: The Irish Fair, as17751003

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Spanish Lady

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Spleen

Dance: V: The Irish Fair, as17751003

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Waterman

Song: V: (By Desire) The Soldier Tir'd-Miss Abrams

Performances

Mainpiece Title: The Committee

Cast
Role: Jack Actor: Mas. Blanchard.

Afterpiece Title: The Genii

Dance: IV: The Jealous Harlequin, as17760117

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Cast
Role: Soldier Actor: Blanchard

Afterpiece Title: The Waterman

Performances

Mainpiece Title: The Committee

Cast
Role: Soldier Actor: Blanchard

Afterpiece Title: The Deserter

Dance: As17761214

Song: End: O What a Charming Thing's a Battle-Bannister

Performances

Mainpiece Title: The Committee

Cast
Role: Soldier Actor: Blanchard

Afterpiece Title: The Deserter

Dance: End I: The Corn Thrashers, as17770419; End II: a Hornpipe-Master Staples (scholar of Blurton)

Ballet: End: The Wapping Landlady. Jack in Distress-Blurton; Wapping Landlady-Mr Griffiths; Orange Woman-Mrs Sutton

Performances

Mainpiece Title: The Touchstone Of Invention; Or, The Soldier's Fortune

Afterpiece Title: Henry And Emma

Afterpiece Title: The Busy Body

Cast
Role: Sir Francis Gripe Actor: Blanchard

Dance: 2nd piece: With a Hornpipe-Lonsdale

Song: End I: two part song, Damon and Clora-Leach, Miss Mitchell (1st appearance); End III: My sweet pretty Mogg-Wright

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Blanchard

Afterpiece Title: The Lying Valet

Cast
Role: Sharp Actor: Blanchard

Performances

Mainpiece Title: Love In A Village

Cast
Role: Hodge Actor: Blanchard

Afterpiece Title: The Lying Valet

Cast
Role: Sharp Actor: Blanchard

Dance: End II: As17870928

Performances

Mainpiece Title: Othello

Cast
Role: Roderigo Actor: Blanchard

Afterpiece Title: The Romp

Performances

Mainpiece Title: Othello

Cast
Role: Roderigo Actor: Blanchard

Afterpiece Title: Orpheus and Eurydice; or, The Metamorphoses of Harlequin

Performances

Mainpiece Title: Zenobia

Performances

Mainpiece Title: All In The Wrong

Performances

Mainpiece Title: Much Ado About Nothing

Dance: II: Masquerade Dance incident to the play-

Performances

Mainpiece Title: The Follies Of A Day; Or, The Marriage Of Figaro

Performances

Mainpiece Title: The West Indian