SELECT * FROM london_stages WHERE eventid IN (6885, 6892, 6900, 6901, 6906, 6909, 6952, 7046, 7058, 7094, 7106, 7126, 7150, 7174, 7199, 7208, 7210, 7222, 7235, 7243, 7260, 7277, 7305, 7346, 7615, 7619, 7658, 7715, 7737, 7746, 8051, 8216, 8456, 8469, 8476, 8479, 8491, 8502, 8521, 8728, 8863, 9014, 9062, 9071, 9717, 9719, 9729, 9749, 9755, 9758, 9766, 9774, 9803, 9823, 9833, 9843, 9905, 9913, 9923, 9936, 9938, 9954, 9997, 10005, 10017, 10029, 10032, 10035, 10043, 10045, 10055, 10063, 10067, 10070, 10073, 10075, 10077, 10080, 10083, 10086, 10088, 10091, 10093, 10096, 10099, 10102, 10104, 10106, 10108, 10111, 10113, 10116, 10119, 10122, 10126, 10128, 10131, 10134, 10136, 10138, 10141, 10143, 10146, 10148, 10151, 10156, 10158, 10161, 10166, 10185, 10191, 10197, 10202, 10206, 10212, 10222, 10228, 10251, 10268, 10295, 10297, 10336, 10347, 10352, 10353, 10400, 10404, 10406, 10408, 10424, 10428, 10435, 10438, 10441, 10445, 10452, 10454, 10458, 10472, 10488, 10498, 10570, 10579, 10584, 10590, 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, 10731, 10738, 10748, 10753, 10760, 10780, 10789, 10798, 10804, 10861, 10863, 10918, 10928, 10932, 10940, 10952, 10958, 10960, 10962, 10968, 10978, 10989, 10995, 11012, 11022, 11025, 11027, 11030, 11033, 11036, 11041, 11045, 11050, 11055, 11064, 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, 11220, 11233, 11365, 11372, 11381, 11388, 11390, 11394, 11396, 11400, 11406, 11411, 11425, 11433, 11437, 11447, 11475, 11480, 11488, 11493, 11507, 11511, 11514, 11516, 11518, 11520, 11523, 11540, 11548, 11553, 11555, 11584, 11596, 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, 11739, 11752, 11777, 11780, 11782, 11784, 11787, 11791, 11793, 11795, 11796, 11813, 11819, 11825, 11828, 11836, 11838, 11840, 11850, 11855, 11859, 11863, 11865, 11875, 11877, 11880, 11887, 11889, 11891, 11894, 11896, 11899, 11905, 11908, 11913, 11918, 11920, 11923, 11948, 11966, 11970, 11974, 11976, 11979, 11981, 11983, 11985, 11993, 11996, 12003, 12005, 12009, 12014, 12024, 12031, 12033, 12340, 12343, 12360, 12364, 12373, 12384, 12414, 12417, 12452, 12465, 12467, 12469, 12508, 12510, 12515, 12519, 12523, 12549, 12555, 12620, 12624, 12630, 12652, 12667, 12692, 12755, 12866, 12868, 12878, 12889, 12894, 12897, 12906, 12912, 12922, 12926, 12933, 12939, 12946, 12950, 13017, 13028, 13031, 13039, 13062, 13065, 13069, 13072, 13075, 13078, 13082, 13086, 13090, 13093, 13097, 13100, 13104, 13108, 13129, 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, 13291, 13295, 13302, 13310, 13317, 13325, 13334, 13342, 13350, 13375, 13382, 13389, 13394, 13402, 13411, 13435, 13445, 13452, 13470, 13479, 13488, 13593, 13595, 13601, 13602, 13613, 13626, 13634, 13646, 13657, 13663, 13674, 13677, 13683, 13687, 13706, 13710, 13714, 13718, 13722, 13729, 13744, 13747, 13751, 13755, 13759, 13782, 13790, 13797, 13801, 13805, 13809, 13812, 13816, 13819, 13823, 13827, 13831, 13834, 13838, 13849, 13852, 13942, 13945, 13972, 13979, 13982, 13987, 13990, 13994, 13998, 14002, 14005, 14009, 14012, 14016, 14019, 14022, 14038, 14044, 14048, 14052, 14064, 14072, 14083, 14090, 14102, 14254, 14262, 14356, 14362, 14371, 14382, 14393, 14396, 14408, 14411, 14414, 14421, 14427, 14433, 14440, 14447, 14450, 14453, 14457, 14460, 14464, 14472, 14479, 14487, 14493, 14497, 14512, 14516, 14523, 14526, 14532, 14536, 14539, 14545, 14548, 14557, 14560, 14563, 14566, 14573, 14576, 14579, 14583, 14586, 14593, 14596, 14600, 14617, 14624, 14627, 14631, 14639, 14643, 14647, 14650, 14656, 14663, 14670, 14675, 14678, 14682, 14690, 14694, 14697, 14700, 14708, 14713, 14717, 14721, 14725, 14730, 14737, 14757, 14761, 14766, 14772, 14777, 14843, 14860, 14939, 14952, 14961, 14964, 14967, 14969, 14972, 15048, 15052, 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, 15268, 15283, 15340, 15488, 15492, 15591, 15791, 15796, 15808, 15813, 15818, 15825, 15828, 15842, 15846, 15850, 15864, 15887, 15911, 15920, 15928, 15935, 15954, 15975, 15985, 16000, 16005, 16009, 16026, 16030, 16041, 16050, 16111, 16115, 16119, 16126, 16130, 16136, 16139, 16142, 16148, 16152, 16157, 16161, 16165, 16169, 16173, 16177, 16195, 16205, 16223, 16233, 16239, 16245, 16252, 16282, 16328, 16333, 16344, 16366, 16388, 16395, 16481, 16580, 16582, 16585, 16589, 16592, 16594, 16595, 16598, 16600, 16601, 16603, 16605, 16611, 16615, 16624, 16627, 16629, 16631, 16633, 16634, 16638, 16643, 16648, 16651, 16655, 16659, 16663, 16669, 16670, 16674, 16675, 16679, 16680, 16685, 16695, 16699, 16703, 16706, 16707, 16710, 16714, 16718, 16722, 16727, 16731, 16734, 16741, 16745, 16749, 16754, 16758, 16782, 16790, 16793, 16797, 16801, 16805, 16810, 16816, 16820, 16823, 16824, 16827, 16831, 16833, 16837, 16838, 16841, 16842, 16846, 16850, 16851, 16854, 16855, 16858, 16859, 16862, 16863, 16866, 16867, 16870, 16871, 16874, 16875, 16878, 16879, 16883, 16886, 16887, 16890, 16891, 16895, 16899, 16903, 16907, 16910, 16911, 16915, 16920, 16922, 16923, 16926, 16933, 16937, 16939, 16941, 16942, 16945, 16946, 16949, 16950, 16953, 16956, 16957, 16960, 16961, 16966, 16970, 16974, 16978, 16982, 16985, 16986, 16989, 16990, 16993, 16994, 16998, 17002, 17003, 17006, 17007, 17011, 17012, 17015, 17016, 17019, 17020, 17025, 17031, 17035, 17039, 17045, 17056, 17060, 17061, 17067, 17072, 17073, 17076, 17082, 17095, 17098, 17103, 17119, 17129, 17134, 17156, 17157, 17162, 17179, 17182, 17186, 17225, 17229, 17253, 17269, 17273, 17311, 17328, 17333, 17342, 17347, 17352, 17418, 17422, 17424, 17427, 17430, 17440, 17448, 17452, 17455, 17464, 17467, 17469, 17473, 17478, 17491, 17496, 17499, 17502, 17505, 17509, 17512, 17513, 17515, 17516, 17518, 17521, 17524, 17526, 17537, 17538, 17540, 17541, 17546, 17549, 17552, 17555, 17604, 17634, 17647, 17651, 17655, 17658, 17668, 17671, 17674, 17677, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17805, 17809, 17813, 17816, 17820, 17823, 17826, 17829, 17832, 17835, 17839, 17843, 17847, 17851, 17852, 17856, 17857, 17861, 17862, 17867, 17875, 17906, 17940, 17944, 18026, 18063, 18123, 18184, 18186, 18188, 18194, 18203, 18205, 18206, 18208, 18210, 18212, 18214, 18216, 18220, 18224, 18226, 18228, 18229, 18231, 18233, 18237, 18239, 18241, 18242, 18244, 18246, 18248, 18250, 18251, 18253, 18254, 18257, 18259, 18262, 18267, 18271, 18273, 18275, 18277, 18278, 18280, 18281, 18283, 18286, 18288, 18289, 18292, 18295, 18299, 18300, 18303, 18306, 18307, 18309, 18310, 18314, 18317, 18318, 18324, 18329, 18332, 18335, 18336, 18338, 18339, 18342, 18346, 18348, 18349, 18353, 18355, 18356, 18358, 18361, 18362, 18365, 18366, 18368, 18369, 18373, 18376, 18379, 18382, 18385, 18386, 18388, 18389, 18391, 18392, 18398, 18399, 18403, 18405, 18409, 18412, 18424, 18427, 18432, 18437, 18440, 18444, 18446, 18447, 18450, 18460, 18468, 18477, 18481, 18484, 18490, 18493, 18494, 18497, 18504, 18505, 18516, 18517, 18521, 18525, 18535, 18540, 18543, 18547, 18594, 18604, 18609, 18616, 18622, 18631, 18648, 18652, 18705, 18886, 18892, 18901, 18903, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18932, 18948, 18975, 18977, 18979, 18982, 19036, 19041, 19043, 19065, 19075, 19123, 19149, 19170, 19236, 19238, 19240, 19242, 19270, 19272, 19276, 19277, 19281, 19282, 19283, 19284, 19285, 19286, 19287, 19289, 19290, 19291, 19292, 19293, 19294, 19295, 19297, 19299, 19302, 19303, 19305, 19307, 19309, 19310, 19311, 19313, 19314, 19315, 19316, 19318, 19319, 19320, 19321, 19322, 19323, 19324, 19325, 19326, 19327, 19328, 19329, 19331, 19332, 19333, 19335, 19337, 19339, 19341, 19343, 19348, 19349, 19350, 19352, 19354, 19356, 19358, 19362, 19364, 19368, 19370, 19372, 19374, 19376, 19377, 19378, 19379, 19380, 19382, 19383, 19384, 19387, 19389, 19395, 19408, 19410, 19412, 19421, 19426, 19428, 19430, 19433, 19435, 19437, 19439, 19441, 19443, 19445, 19447, 19449, 19451, 19452, 19453, 19454, 19455, 19456, 19457, 19458, 19464, 19465, 19468, 19474, 19476, 19479, 19481, 19483, 19485, 19486, 19487, 19489, 19491, 19492, 19494, 19496, 19497, 19498, 19499, 19500, 19502, 19504, 19506, 19510, 19516, 19520, 19527, 19534, 19535, 19536, 19537, 19538, 19544, 19554, 19556, 19562, 19572, 19576, 19590, 19595, 19609, 19611, 19626, 19662, 19665, 19668, 19672, 19708, 19710, 19714, 19718, 19722, 19724, 19730, 19734, 19746, 19754, 19756, 19764, 19773, 19778, 19780, 19787, 19790, 19794, 19821, 19828, 19831, 19833, 19835, 19838, 19841, 19851, 19856, 19866, 19869, 19872, 19875, 19879, 19882, 19889, 19900, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20154, 20156, 20158, 20161, 20164, 20167, 20170, 20173, 20176, 20179, 20197, 20200, 20212, 20215, 20234, 20240, 20290, 20299, 20302, 20330, 20344, 20348, 20351, 20360, 20370, 20373, 20382, 20402, 20416, 20419, 20422, 20426, 20430, 20442, 20446, 20449, 20458, 20462, 20466, 20469, 20483, 20487, 20498, 20501, 20506, 20511, 20517, 20521, 20543, 20555, 20559, 20568, 20571, 20577, 20581, 20584, 20608, 20611, 20638, 20647, 20651, 20787, 20790, 20797, 20815, 20823, 20826, 20842, 20846, 20849, 20855, 20858, 20861, 20873, 20876, 20879, 20887, 20893, 20896, 20899, 20903, 20906, 20912, 20918, 20935, 20945, 20952, 20968, 20981, 20991, 20994, 21001, 21008, 21057, 23458, 23465, 23481, 24006, 24009, 24011, 24025, 24027, 24034, 24042, 24056, 24062, 24066, 24069, 24090, 24100, 24104, 24110, 25122, 25124, 25126, 25129, 25132, 25135, 25137, 25139, 25141, 25144, 25147, 25149, 25152, 25155, 25158, 25160, 25163, 25166, 25169, 25173, 25176, 25179, 25184, 25188, 25817, 25821, 25823, 25826, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25887, 25897, 25903, 25910, 25915, 25926, 25933, 25942, 25949, 25953, 35159, 35828, 35859) 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 Pilgrim

Afterpiece Title: Perseus and Andromeda

Cast
Role: Harlequin Actor: Lun

Dance: LLes Allemands Joyeux, as17411222; La Provencale, as17411215

Performances

Mainpiece Title: The Miser

Afterpiece Title: Perseus and Andromeda

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Rape of Proserpine with the Birth and Adventures of Harlequin

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Rover

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Dance: Picq, Mlle Auguste

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Dance: As17420125

Performances

Mainpiece Title: Sir Courtly Nice Or It Cannot Be

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Nonjuror

Afterpiece Title: The Rape of Proserpine

Cast
Role: Harlequin Actor: Lun

Performances

Mainpiece Title: The Country Lasses

Afterpiece Title: The Royal Chace or Harlequin Skeleton

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Love Makes A Man Or The Fops Fortune

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Merry Wives Of Windsor With The Humours Of Sir John Falstaff

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Oroonoko Or The Royal Slave

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Woman Is A Riddle

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Royal Merchant Or The Beggars Bush

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Funeral Or Grief A la mode

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Royal Chace

Song: Singing In Italian and English-Miss Faulkner; viz: End II: Ah Se amanti fasti mai, Felice Belve-Miss Faulkner; End IV: O Sleep Why dost thou leave me?, Tis Liberty dear Liberty alone-Miss Faulkner

Performances

Mainpiece Title: The Provokd Husband

Afterpiece Title: The Royal Chace

Song: II: As17480213; IV: Go Rose, My Chloe's bosom Grace, Tis Liberty dear Liberty-Miss Faulkner

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Royal Chace

Song: As17480220