SELECT * FROM london_stages WHERE eventid IN (2888, 2890, 2899, 3182, 3718, 3797, 3815, 3818, 3861, 3895, 3950, 3968, 4204, 4440, 4618, 5425, 6087, 6115, 6139, 6143, 6377, 6435, 6744, 7072, 7385, 8337, 9886, 10245, 10274, 11150, 13049, 13196, 13200, 13266, 13270, 13286, 13287, 13300, 13306, 13333, 13335, 13347, 13351, 13355, 13374, 13441, 13457, 13471, 13497, 13583, 13614, 13765, 13845, 14032, 14047, 14080, 14086, 14117, 14131, 14164, 14186, 14190, 14195, 14239, 14246, 14258, 14273, 14282, 14292, 14386, 14419, 14542, 14551, 14640, 14644, 14698, 14738, 14807, 14813, 14835, 14853, 14866, 14878, 14929, 14962, 15005, 15435, 15571, 15579, 15720, 15723, 15735, 15737, 15782, 15784, 15789, 15879, 15968, 16007, 16143, 16381, 16468, 16486, 16613, 17031, 17058, 17243, 17318, 17343, 17350, 17351, 17354, 17355, 17366, 17387, 17423, 17614, 17623, 17686, 17689, 17693, 17697, 17700, 17702, 17778, 17906, 17944, 18004, 18142, 18199, 18202, 18216, 18237, 18242, 18246, 18254, 18286, 18289, 18509, 18513, 18518, 18755, 18772, 19349, 19731, 20114, 20152, 20210, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20434, 20440, 20629, 20738, 20762, 20773, 20776, 20779, 20782, 20788, 20791, 20794, 20798, 20801, 20804, 20807, 20811, 20813, 20815, 20818, 20819, 20821, 20824, 20827, 20830, 20834, 20837, 20840, 20843, 20847, 20850, 20853, 20856, 20859, 20862, 20866, 20869, 20874, 20877, 20880, 20884, 20897, 20900, 20904, 20923, 20926, 20933, 20936, 20939, 20950, 21022, 21039, 21043, 21111, 21128, 21131, 21141, 21161, 21188, 21189, 21197, 21236, 21239, 21244, 21246, 21274, 21284, 21297, 21304, 21313, 21469, 21475, 21481, 21491, 21497, 21553, 21586, 21592, 21593, 21608, 21637, 21640, 21649, 21653, 21657, 21711, 21735, 21743, 21757, 21791, 21859, 21885, 22067, 22094, 22129, 22160, 22178, 22184, 22190, 22290, 22291, 22292, 22406, 22407, 22440, 22443, 22446, 22523, 22578, 22594, 22658, 22682, 22699, 22784, 22797, 22875, 22878, 22881, 22887, 22904, 22915, 22934, 22939, 22942, 22945, 22948, 22955, 22957, 22959, 22971, 22974, 22979, 22984, 23003, 23005, 23010, 23015, 23036, 23041, 23066, 23092, 23095, 23098, 23101, 23104, 23128, 23140, 23151, 23170, 23179, 23184, 23194, 23226, 23507, 23511, 23539, 23564, 23586, 23615, 23628, 23645, 23697, 23716, 23758, 23764, 23789, 23883, 23976, 23978, 23981, 24057, 24114, 24164, 24182, 24201, 24203, 24205, 24236, 24244, 24248, 24279, 24297, 24399, 24479, 24483, 24490, 24538, 24540, 24627, 24629, 24687, 25199, 25210, 25233, 25260, 25330, 25331, 25364, 25374, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25775, 25777, 25787, 25793, 25797, 25801, 25815, 25888, 25901, 25911, 25920, 26044, 26053, 26377, 26379, 26382, 26384, 26673, 26675, 26678, 26680, 26682, 26684, 26686, 26692, 26790, 26849, 26853, 26858, 26863, 26867, 26904, 26924, 26929, 27031, 27205, 27207, 27209, 27219, 27324, 27327, 27330, 27332, 27334, 27337, 27423, 27429, 27445, 27452, 27471, 27477, 27526, 27568, 27633, 27638, 27639, 27643, 27647, 27713, 27717, 27719, 27799, 27807, 27998, 28185, 28189, 28220, 28224, 28229, 28233, 28234, 28241, 28255, 28353, 28362, 28364, 28395, 28400, 28406, 28647, 28653, 28687, 28822, 28836, 28848, 28911, 28947, 28963, 28974, 28992, 29011, 29023, 29037, 29251, 29253, 29299, 29303, 29345, 29360, 29362, 29375, 29504, 29540, 29583, 29649, 29728, 29737, 29741, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29772, 29773, 29774, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29823, 29826, 29829, 29839, 29897, 29902, 29910, 29920, 29935, 29937, 29942, 29948, 29961, 29968, 29988, 30043, 30062, 30126, 30148, 30152, 30262, 30319, 30323, 30325, 30433, 30579, 30587, 30602, 30607, 30622, 30627, 30629, 30654, 30681, 30683, 30706, 30707, 30709, 30710, 30711, 30714, 30716, 30718, 30720, 30723, 30726, 30729, 30733, 30741, 30755, 30761, 30835, 30861, 30894, 30899, 30902, 30980, 31036, 31058, 31078, 31110, 31159, 31180, 31190, 31192, 31201, 31221, 31224, 31235, 31242, 31254, 31273, 31281, 31354, 31460, 31677, 31699, 31725, 31749, 31758, 31767, 31783, 31784, 31785, 31798, 31843, 31845, 31851, 31855, 31859, 31863, 31867, 31871, 31875, 31879, 31883, 31917, 31977, 32057, 32081, 32143, 32215, 32273, 32274, 32275, 32276, 32277, 32279, 32281, 32284, 32286, 32291, 32295, 32302, 32303, 32307, 32323, 32376, 32407, 32410, 32419, 32421, 32423, 32425, 32428, 32430, 32433, 32434, 32435, 32437, 32448, 32451, 32453, 32455, 32458, 32460, 32489, 32503, 32575, 32605, 32618, 32643, 32670, 32672, 32684, 32795, 32815, 32817, 32819, 32820, 32825, 32830, 32832, 32854, 32862, 32868, 32874, 32880, 32888, 32958, 33029, 33045, 33047, 33104, 33168, 33191, 33214, 33215, 33217, 33218, 33219, 33227, 33228, 33229, 33231, 33234, 33241, 33250, 33253, 33254, 33400, 33404, 33541, 33544, 33546, 33549, 33604, 33613, 33685, 33718, 33723, 33726, 33727, 33730, 33732, 33733, 33736, 33738, 33739, 33741, 33742, 33756, 33762, 33769, 33772, 33777, 33779, 33783, 33785, 33800, 33840, 33856, 33877, 33878, 33883, 33939, 33978, 33979, 34018, 34156, 34169, 34180, 34208, 34211, 34213, 34215, 34218, 34227, 34235, 34243, 34245, 34247, 34260, 34265, 34268, 34271, 34273, 34274, 34276, 34278, 34279, 34281, 34284, 34285, 34286, 34288, 34290, 34292, 34293, 34294, 34296, 34298, 34300, 34302, 34305, 34307, 34310, 34311, 34312, 34316, 34318, 34323, 34325, 34326, 34327, 34329, 34331, 34332, 34333, 34334, 34337, 34338, 34397, 34400, 34401, 34406, 34410, 34413, 34418, 34433, 34437, 34442, 34466, 34469, 34470, 34471, 34474, 34475, 34476, 34478, 34482, 34493, 34512, 34546, 34578, 34597, 34722, 34737, 34741, 34742, 34759, 34780, 34789, 34815, 34828, 34874, 34880, 34885, 34912, 34914, 34916, 34918, 34920, 34922, 34924, 34930, 34932, 34934, 34936, 34938, 34942, 34952, 34967, 34973, 34976, 34983, 34990, 34992, 35061, 35079, 35083, 35090, 35103, 35105, 35107, 35112, 35117, 35130, 35141, 35145, 35147, 35152, 35157, 35162, 35169, 35177, 35178, 35184, 35218, 35229, 35244, 35277, 35296, 35298, 35317, 35319, 35320, 35338, 35342, 35347, 35364, 35376, 35384, 35385, 35393, 35397, 35400, 35416, 35418, 35421, 35424, 35426, 35432, 35434, 35438, 35448, 35450, 35452, 35468, 35471, 35473, 35480, 35482, 35498, 35501, 35503, 35518, 35524, 35532, 35555, 35557, 35558, 35563, 35566, 35567, 35571, 35575, 35580, 35584, 35591, 35593, 35602, 35608, 35622, 35652, 35660, 35664, 35698, 35743, 35762, 35812, 35866, 35867, 35873, 35895, 35899, 35901, 35902, 35904, 35908, 35932, 35940, 35952, 35955, 35959, 35974, 35975, 35979, 35988, 36004, 36006, 36012, 36014, 36019, 36039, 36043, 36045, 36047, 36064, 36066, 36068, 36070, 36072, 36075, 36078, 36081, 36085, 36088, 36091, 36093, 36095, 36096, 36097, 36099, 36100, 36103, 36104, 36106, 36107, 36108, 36118, 36120, 36124, 36129, 36133, 36137, 36167, 36171, 36175, 36182, 36185, 36186, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36251, 36283, 36285, 36288, 36290, 36292, 36299, 36375, 36476, 36479, 36495, 36512, 36513, 36532, 36534, 36539, 36541, 36545, 36551, 36570, 36572, 36583, 36585, 36586, 36603, 36623, 36626, 36631, 36634, 36647, 36649, 36655, 36663, 36667, 36669, 36673, 36680, 36682, 36694, 36700, 36702, 36708, 36712, 36747, 36752, 36773, 36782, 36830, 36839, 36858, 36906, 36909, 36923, 37002, 37014, 37025, 37036, 37042, 37077, 37101, 37109, 37110, 37167, 37168, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37189, 37190, 37193, 37199, 37201, 37204, 37207, 37272, 37279, 37282, 37284, 37285, 37292, 37301, 37310, 37322, 37325, 37338, 37361, 37373, 37402, 37501, 37506, 37515, 37525, 37580, 37583, 37593, 37594, 37598, 37604, 37616, 37629, 37640, 37796, 37799, 37801, 37804, 37808, 37818, 37828, 37829, 37832, 37839, 37869, 37893, 37897, 37907, 37923, 37957, 38015, 38044, 38052, 38085, 38105, 38136, 38182, 38186, 38309, 38311, 38339, 38343, 38407, 38481, 38485, 38515, 38520, 38524, 38550, 38579, 38614, 38634, 38640, 38653, 38654, 38688, 38698, 38703, 38705, 38717, 38728, 38740, 38857, 38859, 38866, 38869, 38870, 38875, 38876, 38878, 38881, 38882, 38893, 38899, 38932, 38946, 39063, 39066, 39068, 39072, 39111, 39260, 39293, 39310, 39334, 39342, 39347, 39348, 39351, 39355, 39359, 39361, 39362, 39365, 39368, 39371, 39374, 39376, 39377, 39385, 39388, 39395, 39404, 39426, 39432, 39436, 39438, 39461, 39467, 39507, 39616, 39757, 39777, 39792, 39806, 39814, 39855, 39893, 39896, 39905, 39909, 39915, 39916, 39949, 40032, 40083, 40210, 40228, 40248, 40265, 40297, 40302, 40309, 40338, 40360, 40377, 40403, 40422, 40426, 40427, 40433, 40507, 40508, 40513, 40514, 40516, 40585, 40588, 40607, 40623, 40628, 40632, 40636, 40638, 40640, 40649, 40651, 40653, 40655, 40693, 40701, 40712, 40727, 40756, 40813, 40819, 40868, 40874, 40896, 40933, 41022, 41028, 41034, 41052, 41057, 41079, 41082, 41143, 41217, 41478, 41483, 41487, 41579, 41580, 41582, 41585, 41586, 41588, 41590, 41609, 41612, 41664, 41695, 41701, 41707, 41716, 41719, 41765, 41891, 42007, 42022, 42091, 42250, 42256, 42287, 42292, 42296, 42393, 42456, 42519, 42589, 42723, 43033, 43035, 43037, 43039, 43042, 43063, 43184, 43402, 43437, 43443, 43445, 43447, 43459, 43464, 43471, 43475, 43476, 43478, 43488, 43489, 43496, 43499, 43500, 43507, 43515, 43518, 43521, 43532, 43533, 43540, 43548, 43549, 43574, 43584, 43590, 43591, 43595, 43610, 43612, 43613, 43619, 43623, 43656, 43657, 43683, 43707, 43708, 43765, 43840, 43890, 43891, 43973, 43976, 43978, 43980, 44126, 44297, 44490, 44513, 44520, 44530, 44533, 44535, 44555, 44578, 44701, 44741, 44861, 44888, 44950, 45119, 45147, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45305, 45310, 45314, 45316, 45319, 45324, 45328, 45335, 45352, 45378, 45384, 45397, 45516, 45537, 45542, 45586, 45645, 45662, 45670, 45671, 45676, 45681, 45708, 45774, 45776, 45798, 46027, 46044, 46060, 46138, 46221, 46318, 46739, 46844, 47209, 47273, 47285, 47291, 47306, 47400, 47413, 47414, 47419, 47424, 47447, 47459, 47479, 47587, 47694, 47867, 47928, 47932, 47937, 48556, 48566, 48616, 48632, 48718, 48758, 48796, 48828, 48932, 48946, 49016, 49056, 49066, 49067, 49077, 49081, 49083, 49100, 49599, 49604, 49716, 49791, 49801, 49924, 49929, 50141, 50158, 50160, 50343, 50388, 50479, 50579, 50841, 50919, 51004, 51274, 51338, 51369, 51381, 51463, 51479, 51509, 51741, 51838, 51864, 51890, 51940, 51971, 51997, 52026, 52029, 52046, 52047, 52119, 52275, 52458, 52497, 52601, 52616) 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 Twin Rivals

Afterpiece Title: The Contrivances

Dance: Comic Dance,The Threshers-Leppie, Granier, Mlle Capdeville

Performances

Mainpiece Title: The Twin Rivals

Afterpiece Title: The Lying Valet

Dance: As17591005

Performances

Mainpiece Title: The Beggar's Opera

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Englishman Returned from Paris

Dance: As17591010

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Cheats of Scapin

Dance: CCountry Dance-characters of the play; by Desire, a Hornpipe-Miss Dawson

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Catherine and Petruchio

Dance: As17591012; The Threshers, as17591005

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Knights

Dance: As17591012; with a New Comic Dance call'd The Irish Turf@Cutters-Poitier Jr, 1st time here in 3 years, Miss Capdeville

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Knights

Dance: As17591015

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: A Duke and no Duke

Dance: As17591015; End I: The Dutch Skipper-Poitier Jr

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Lying Valet

Dance: As17591017

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Catherine and Petruchio

Dance: As17591017

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Englishman Returned from Paris

Dance: As17591017

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The School Boy

Dance: As17591017

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Cheats of Scapin

Dance: Country Dance, as17591017; Hornpipe, as17591017; The Dutch Skipper, as17591017; The Threshers, as17591005

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Englishman Returned from Paris

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: A Duke and no Duke

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Knights

Dance: As17591023

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Catherine and Petruchio

Dance: As17591023

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The School Boy

Dance: AAs 23 Oct

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Miss in Her Teens

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Miss in Her Teens

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Lying Valet

Dance: As17591023

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: A Duke and no Duke

Dance: CCountry Dance, as17591023; Hornpipe, as17591023; The Dutch Skipper, as17591023; Fingalian Dance-Miss Hilliard,