SELECT * FROM london_stages WHERE eventid IN (1925, 1984, 1999, 2097, 2163, 2495, 2502, 2606, 2607, 2888, 2899, 2931, 3182, 3797, 3815, 3859, 3861, 3879, 4086, 4206, 4307, 4326, 4440, 4543, 4567, 5147, 5425, 5781, 5839, 5845, 5906, 5908, 6087, 6095, 6111, 6139, 6143, 6302, 6367, 6372, 6376, 6377, 6391, 6405, 6410, 6419, 6432, 6498, 6510, 6513, 6523, 6579, 6741, 6744, 6894, 6917, 6948, 7094, 7106, 7168, 7199, 7208, 7210, 7222, 7235, 7243, 7313, 7338, 7400, 7427, 7494, 7564, 7569, 7581, 7585, 7611, 7617, 7650, 7656, 7670, 7674, 7683, 8223, 8469, 8491, 8671, 9059, 9062, 9071, 9104, 9308, 9323, 9336, 9717, 9719, 9729, 9749, 9755, 9758, 9774, 9803, 9823, 9833, 9843, 9886, 9890, 9913, 9923, 9929, 9954, 9997, 10005, 10023, 10051, 10182, 10206, 10212, 10222, 10245, 10274, 10456, 10498, 10579, 10604, 10619, 10621, 10624, 10627, 10630, 10633, 10636, 10639, 10642, 10645, 10648, 10651, 10653, 10656, 10659, 10662, 10665, 10668, 10671, 10674, 10677, 10680, 10683, 10686, 10724, 10748, 10753, 10780, 10789, 10804, 10833, 10861, 10863, 10918, 10928, 10932, 10958, 10960, 10962, 10974, 10995, 11022, 11025, 11027, 11041, 11045, 11071, 11073, 11076, 11078, 11081, 11083, 11085, 11087, 11090, 11092, 11095, 11097, 11099, 11101, 11104, 11107, 11110, 11112, 11114, 11117, 11119, 11122, 11123, 11125, 11127, 11130, 11132, 11135, 11137, 11139, 11149, 11152, 11155, 11158, 11161, 11164, 11167, 11169, 11175, 11178, 11180, 11198, 11204, 11233, 11266, 11269, 11272, 11287, 11337, 11339, 11347, 11348, 11363, 11372, 11381, 11382, 11384, 11388, 11389, 11394, 11404, 11406, 11410, 11411, 11417, 11433, 11437, 11447, 11459, 11461, 11467, 11474, 11475, 11488, 11493, 11499, 11506, 11507, 11511, 11514, 11515, 11516, 11517, 11518, 11520, 11523, 11540, 11555, 11571, 11579, 11584, 11596, 11598, 11599, 11613, 11615, 11618, 11622, 11625, 11627, 11630, 11632, 11635, 11637, 11640, 11643, 11646, 11648, 11652, 11660, 11668, 11671, 11673, 11680, 11686, 11696, 11701, 11706, 11712, 11717, 11725, 11752, 11755, 11763, 11777, 11780, 11782, 11786, 11787, 11789, 11791, 11793, 11795, 11796, 11819, 11825, 11836, 11838, 11840, 11844, 11850, 11863, 11865, 11875, 11877, 11887, 11889, 11891, 11894, 11896, 11899, 11905, 11908, 11913, 11918, 11920, 11923, 11953, 11970, 11974, 11976, 11979, 11993, 11996, 12003, 12005, 12009, 12014, 12033, 12122, 12225, 12239, 12340, 12343, 12384, 12414, 12417, 12452, 12465, 12467, 12469, 12508, 12510, 12515, 12519, 12523, 12549, 12555, 12620, 12624, 12630, 12652, 12667, 12736, 12755, 12866, 12868, 12873, 12876, 12878, 12886, 12889, 12894, 12897, 12906, 12912, 12918, 12922, 12926, 12933, 12939, 12946, 12950, 12971, 13015, 13017, 13024, 13028, 13031, 13039, 13046, 13051, 13062, 13065, 13069, 13072, 13075, 13078, 13082, 13086, 13090, 13093, 13097, 13100, 13104, 13108, 13126, 13129, 13133, 13140, 13155, 13159, 13163, 13166, 13170, 13174, 13177, 13180, 13184, 13188, 13191, 13197, 13201, 13205, 13209, 13215, 13220, 13224, 13227, 13232, 13237, 13244, 13249, 13255, 13276, 13284, 13286, 13291, 13295, 13299, 13302, 13310, 13314, 13317, 13325, 13334, 13335, 13342, 13350, 13362, 13366, 13375, 13382, 13389, 13394, 13402, 13411, 13435, 13445, 13452, 13457, 13470, 13471, 13473, 13479, 13488, 13582, 13583, 13593, 13595, 13601, 13602, 13613, 13626, 13634, 13646, 13650, 13657, 13663, 13667, 13674, 13677, 13683, 13687, 13706, 13710, 13712, 13714, 13718, 13722, 13729, 13744, 13747, 13751, 13755, 13759, 13763, 13782, 13785, 13790, 13797, 13801, 13805, 13809, 13812, 13816, 13819, 13823, 13826, 13827, 13831, 13834, 13837, 13838, 13849, 13852, 13861, 13870, 13910, 13942, 13945, 13971, 13972, 13979, 13982, 13987, 13990, 13994, 13998, 14002, 14005, 14009, 14012, 14016, 14019, 14022, 14038, 14044, 14048, 14052, 14064, 14072, 14080, 14083, 14090, 14102, 14239, 14252, 14254, 14262, 14356, 14362, 14365, 14366, 14371, 14374, 14382, 14393, 14396, 14408, 14411, 14414, 14417, 14421, 14427, 14430, 14433, 14440, 14445, 14447, 14450, 14453, 14457, 14460, 14464, 14467, 14472, 14476, 14479, 14487, 14490, 14493, 14497, 14512, 14516, 14523, 14526, 14529, 14532, 14533, 14536, 14539, 14542, 14545, 14548, 14551, 14557, 14560, 14563, 14566, 14573, 14576, 14579, 14583, 14586, 14590, 14593, 14596, 14600, 14604, 14607, 14617, 14624, 14627, 14631, 14639, 14643, 14647, 14650, 14663, 14670, 14675, 14678, 14690, 14694, 14697, 14700, 14708, 14713, 14717, 14730, 14737, 14738, 14757, 14761, 14766, 14772, 14777, 14835, 14843, 14857, 14860, 14904, 14906, 14914, 14939, 14952, 14957, 14961, 14964, 14967, 14969, 14972, 15048, 15052, 15057, 15060, 15065, 15077, 15080, 15082, 15090, 15093, 15100, 15108, 15112, 15119, 15122, 15125, 15128, 15132, 15149, 15153, 15165, 15174, 15177, 15181, 15185, 15188, 15199, 15205, 15237, 15241, 15246, 15250, 15252, 15255, 15260, 15266, 15268, 15270, 15274, 15277, 15281, 15283, 15285, 15289, 15292, 15295, 15298, 15301, 15302, 15304, 15305, 15319, 15363, 15410, 15435, 15444, 15450, 15462, 15468, 15485, 15488, 15492, 15524, 15529, 15535, 15542, 15545, 15579, 15585, 15591, 15595, 15597, 15628, 15632, 15720, 15735, 15737, 15759, 15782, 15784, 15789, 15791, 15796, 15808, 15813, 15818, 15825, 15828, 15842, 15846, 15850, 15854, 15860, 15864, 15879, 15887, 15911, 15915, 15919, 15920, 15923, 15927, 15928, 15931, 15935, 15938, 15954, 15968, 15970, 15975, 15985, 15990, 16000, 16005, 16007, 16009, 16012, 16025, 16026, 16030, 16041, 16050, 16111, 16115, 16119, 16126, 16129, 16130, 16136, 16139, 16142, 16143, 16148, 16152, 16157, 16161, 16165, 16169, 16173, 16177, 16195, 16205, 16223, 16233, 16239, 16245, 16252, 16272, 16282, 16328, 16333, 16334, 16338, 16344, 16345, 16352, 16366, 16367, 16371, 16376, 16377, 16381, 16382, 16386, 16388, 16389, 16392, 16395, 16396, 16404, 16418, 16430, 16450, 16481, 16486, 16509, 16551, 16631, 16633, 16637, 16641, 16645, 16666, 16683, 16706, 16717, 16823, 16937, 17031, 17036, 17102, 17135, 17272, 17343, 17350, 17351, 17354, 17366, 17423, 17649, 17778, 17894, 17898, 17903, 17906, 17907, 17909, 17914, 17915, 17918, 17923, 17928, 17931, 17932, 17936, 17937, 17941, 17944, 17954, 17956, 17958, 17962, 17967, 17971, 17974, 17978, 17982, 17989, 17991, 17993, 18004, 18050, 18199, 18202, 18216, 18237, 18242, 18246, 18254, 18286, 18289, 18509, 18513, 18518, 18772, 19137, 19399, 19444, 19446, 19451, 19525, 20106, 20210, 20275, 20291, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20440, 20463, 20470, 20585, 20625, 20632, 20678, 20701, 20738, 20798, 20801, 20804, 20807, 20813, 20819, 20821, 20824, 20827, 20830, 20834, 20837, 20840, 20843, 20847, 20850, 20853, 20856, 20859, 20862, 20869, 20877, 20880, 20884, 20897, 20900, 20904, 20909, 20923, 20933, 20936, 20939, 21022, 21039, 21043, 21065, 21068, 21071, 21074, 21078, 21081, 21085, 21091, 21094, 21098, 21105, 21111, 21114, 21121, 21128, 21130, 21131, 21141, 21161, 21189, 21192, 21197, 21244, 21256, 21280, 21304, 21323, 21441, 21593, 21676, 21711, 21735, 21757, 22129, 22166, 22178, 22184, 22190, 22229, 22269, 22440, 22443, 22446, 22578, 22682, 22692, 22904, 22934, 22939, 22942, 22945, 22948, 22957, 22959, 22971, 22974, 22979, 22984, 23003, 23005, 23015, 23036, 23041, 23066, 23092, 23095, 23098, 23101, 23104, 23128, 23140, 23151, 23179, 23184, 23194, 23211, 23716, 23758, 23789, 23883, 23976, 23978, 23981, 24164, 24201, 24205, 24236, 24244, 24248, 24279, 24352, 24360, 24386, 24399, 24445, 24479, 24483, 24531, 24633, 24649, 24713, 24722, 24743, 25210, 25260, 25330, 25331, 25364, 25374, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25787, 25793, 25797, 25801, 25815, 25835, 25837, 25887, 25888, 25897, 25903, 25910, 25915, 25926, 25933, 25942, 25949, 25953, 26911, 26917, 26922, 26927, 26932, 27031, 27052, 27205, 27207, 27209, 27219, 27471, 27477, 27514, 27526, 27568, 27638, 27639, 27644, 27708, 27712, 27713, 27717, 27718, 27719, 27730, 27748, 27775, 27799, 27807, 27872, 27893, 27998, 28074, 28490, 28514, 28548, 28553, 28685, 28690, 28822, 28848, 28911, 28947, 28963, 28974, 28992, 29023, 29037, 29038, 29251, 29253, 29299, 29303, 29360, 29504, 29540, 29649, 29935, 29942, 30433, 30592, 30607, 30627, 30835, 30861, 30894, 30899, 30980, 31036, 31141, 31159, 31190, 31192, 31201, 31235, 31242, 31254, 31273, 31292, 31767, 31984, 32261, 32347, 32349, 32351, 32353, 32357, 32359, 32361, 32410, 32434, 32489, 32503, 32670, 32672, 32684, 32862, 32868, 33045, 33218, 33219, 33254, 33718, 33723, 33726, 33727, 34466, 34469, 34471, 34474, 34476, 34478, 34546, 34620, 34622, 34635, 34637, 34648, 34912, 34914, 34916, 34918, 34920, 34922, 34924, 34932, 34936, 34942, 34952, 34992, 35032, 35034, 35037, 35039, 35043, 35058, 35119, 35185, 35196, 35224, 35295, 35317, 35320, 35366, 35602, 35698, 35867, 35904, 35908, 35912, 36261, 36294, 36297, 36304, 36309, 36318, 36404, 36419, 36453, 36512, 36676, 36683, 36685, 36687, 36691, 36695, 36699, 36700, 36707, 36712, 36725, 36747, 36751, 36809, 36830, 36839, 36856, 36884, 36909, 36912, 36924, 36926, 36931, 36937, 36940, 36942, 36948, 36953, 37002, 37003, 37022, 37036, 37040, 37050, 37056, 37081, 37435, 37598, 37629, 37808, 37824, 37829, 37871, 37873, 37970, 38015, 38406, 38407, 38441, 38473, 38485, 38534, 38590, 38669, 38674, 38681, 38683, 38693, 38695, 38712, 38727, 38742, 38756, 38764, 38772, 38779, 38791, 38866, 38869, 38878, 38881, 39260, 39371, 39422, 39424, 39938, 40248, 40265, 40297, 40338, 40377, 41162, 41453, 41469, 42456, 43177, 43187, 43196, 43209, 43235, 43240, 43251, 43261, 43286, 43291, 43301, 43311, 43334, 43338, 43515, 43532, 43540, 43548, 43574, 43619, 43840, 43973, 43980, 44442, 44513, 44520, 44701, 44888, 44950, 45616, 46572, 47209, 48091, 48283, 48287, 48297, 49056, 49066, 49067, 49077, 49081, 49083, 49100, 49168, 49177, 49179, 49181, 49182, 49183, 49268, 49270, 49272, 49274, 49276, 49278, 49280, 49282, 49284, 49286, 49288, 49290, 49292, 49294, 49296, 49298, 49300, 49305, 49307, 49310, 49312, 49314, 49316, 49319, 49321, 49324, 49328, 49330, 49333, 49335, 49364, 49366, 49368, 49380, 49382, 49394, 49396, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49578, 49580, 49589, 49592, 49602, 49607, 49612, 49616, 49622, 49627, 49635, 49640, 49650, 49655, 49662, 49667, 50132, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51140, 51168, 51170, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51247, 51249, 51254, 51256, 51258, 51266, 51285, 51298, 51304, 51311, 51312, 51338, 51341, 51345, 51351, 51356, 51619, 51625, 51651, 51719, 51772, 51919, 51922, 51940, 52275, 52451) 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: Sir Courtly Nice; Or, It Cannot Be

Afterpiece Title: Harlequin Doctor Faustus

Song: Singing in Italian-Mrs Robinson

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Harlequin Doctor Faustus

Song: As17261001

Performances

Mainpiece Title: Aesop

Afterpiece Title: Harlequin a Sorcerer

Cast
Role: Prometheus Actor: Newhouse

Performances

Mainpiece Title: The Chances

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: She Wou'd If She Cou'd

Afterpiece Title: Apollo and Daphne

Cast
Role: Scaramouch Actor: Newhouse
Role: Peasants Actor: Newhouse, Pelling, Lanyon
Role: Satyrs Actor: Nivelon, Newhouse

Performances

Mainpiece Title: The Silent Woman

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Apollo and Daphne

Cast
Role: Scaramouch Actor: Newhouse
Role: Peasants Actor: Newhouse, Pelling, Lanyon
Role: Satyrs Actor: Nivelon, Newhouse

Performances

Mainpiece Title: Don John; Or, The Libertine Destroy'd

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: The London Cuckolds

Afterpiece Title: Jupiter and Europa

Cast
Role: Punch Actor: Newhouse

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: The Humours of Bedlam

Cast
Role: Mad Taylor Actor: Newhouse

Afterpiece Title: Pan and Syrinx

Dance: As17261024

Performances

Mainpiece Title: The Rover

Afterpiece Title: Pan and Syrinx

Cast
Role: Scaramouch Actor: Newhouse
Role: Peasants Actor: Newhouse, Pelling, Lanyon
Role: Satyrs Actor: Nivelon, Newhouse

Dance: As17261024

Performances

Mainpiece Title: The False Friend

Afterpiece Title: Apollo and Daphne; or, The Burgo-Master Trick'd

Cast
Role: Scaramouch Actor: Newhouse
Role: Peasants Actor: Newhouse, Pelling, Lanyon
Role: Satyrs Actor: Nivelon, Newhouse

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Apollo and Daphne; or, The Burgo-Master Trick'd

Cast
Role: Scaramouch Actor: Newhouse
Role: Peasants Actor: Newhouse, Pelling, Lanyon
Role: Satyrs Actor: Nivelon, Newhouse

Performances

Mainpiece Title: The Albion Queens

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: Aesop

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: Mithridates, King Of Pontus

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Apollo and Daphne; or, The Burgo-Master Trick'd

Cast
Role: Scaramouch Actor: Newhouse
Role: Peasants Actor: Newhouse, Pelling, Lanyon
Role: Satyrs Actor: Nivelon, Newhouse

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Harlequin a Sorcerer

Cast
Role: Prometheus Actor: Newhouse

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: Harlequin a Sorcerer

Cast
Role: Prometheus Actor: Newhouse

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: The Committee

Afterpiece Title: Harlequin Doctor Faustus

Performances

Mainpiece Title: The Dissembled Wanton

Afterpiece Title: Harlequin a Sorcerer

Cast
Role: Prometheus Actor: Newhouse

Performances

Mainpiece Title: The Dissembled Wanton

Afterpiece Title: Harlequin a Sorcerer

Cast
Role: Prometheus Actor: Newhouse

Performances

Mainpiece Title: The Soldier's Fortune

Afterpiece Title: Harlequin a Sorcerer

Cast
Role: Prometheus Actor: Newhouse