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

Afterpiece Title: Thomasand Sally

Dance: As17680530

Performances

Afterpiece Title: Thomasand Sally

Dance: As17680530

Performances

Afterpiece Title: Miss in Her Teens

Dance: As17680530

Music: End: Concerto-Barthelemon

Performances

Afterpiece Title: The Lying Valet

Dance: As17680530

Performances

Afterpiece Title: Miss in Her Teens

Dance: As17680530

Performances

Afterpiece Title: The Lying Valet

Dance: As17680530

Performances

Afterpiece Title: The Old Maid

Dance: As17680530

Music: End: Concerto on violin-Barthelemon

Performances

Afterpiece Title: The Old Maid

Dance: As17680530

Performances

Afterpiece Title: Miss in Her Teens

Dance: As17680530

Performances

Mainpiece Title: The Mayor Of Garratt

Afterpiece Title: The Stratagem

Dance: As17680530

Music: CConcerto on Violin-Barthelemon

Performances

Afterpiece Title: The Old Maid

Dance: As17680530

Performances

Afterpiece Title: Thomasand Sally

Dance: As17680530

Performances

Afterpiece Title: The Devil to Pay

Dance: As17680530

Performances

Afterpiece Title: The Devil to Pay

Dance: As17680530

Performances

Afterpiece Title: Miss in Her Teens

Dance: As17680530

Performances

Afterpiece Title: The Virgin Unmask'd

Dance: As17680530

Performances

Afterpiece Title: The Lying Valet

Dance: As17680530

Performances

Afterpiece Title: Thomasand Sally

Dance: As17680530

Performances

Afterpiece Title: The Virgin Unmask'd

Dance: As17680530

Performances

Afterpiece Title: The School Boy

Dance: As17680530

Performances

Afterpiece Title: The School Boy

Dance: As17680530

Performances

Afterpiece Title: Thomasand Sally

Dance: As17680530

Performances

Afterpiece Title: Hob in the Well

Dance: As17680530

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Mayor of Garratt

Dance: As17680801

Performances

Afterpiece Title: Hob in the Well

Dance: As17680530