SELECT * FROM london_stages WHERE eventid IN (1716, 2932, 2933, 2956, 2963, 2997, 3049, 3126, 3147, 3790, 3816, 4316, 4317, 4510, 4564, 7480, 7508, 7904, 10359, 10360, 10363, 10375, 10383, 10898, 10900, 10902, 10982, 11333, 11334, 11335, 11336, 11337, 11344, 12122, 12239, 12385, 12390, 12725, 12755, 12895, 12937, 13251, 13374, 13414, 13441, 13443, 13457, 13482, 13492, 13493, 13498, 13501, 13511, 13514, 13517, 13522, 13528, 13533, 13544, 14220, 14292, 14785, 14796, 14826, 15049, 15052, 15133, 15137, 15150, 15158, 15193, 15312, 15460, 15571, 15624, 15783, 15833, 15854, 15860, 15916, 15953, 15970, 16429, 16551, 16586, 16591, 16594, 16599, 16600, 16617, 16624, 16631, 16633, 16643, 16651, 16669, 16674, 16679, 16706, 16782, 16850, 16854, 16858, 16862, 16866, 16870, 16874, 16878, 16886, 16890, 16910, 16922, 16926, 16933, 16937, 16941, 16945, 16949, 16956, 16960, 16985, 16989, 16993, 17060, 17134, 17218, 17264, 17311, 17328, 17342, 17347, 17385, 17696, 17924, 17992, 18235, 18614, 18859, 18901, 18933, 18935, 18937, 18955, 19015, 19024, 19127, 19183, 19184, 19186, 19195, 19628, 19643, 19655, 19677, 19678, 19804, 19863, 19882, 20006, 20060, 20106, 20129, 20130, 20132, 20133, 20135, 20137, 20139, 20143, 20147, 20153, 20155, 20157, 20175, 20187, 20202, 20214, 20223, 20236, 20289, 20304, 20314, 20332, 20401, 20465, 20648, 20711, 20712, 20723, 20730, 20780, 20789, 20883, 20891, 20894, 20898, 20919, 20924, 20929, 20957, 20998, 21008, 21015, 21032, 21039, 21043, 21058, 21059, 21076, 21088, 21118, 21128, 21134, 21136, 21189, 21199, 21228, 21239, 21246, 21275, 21284, 21305, 21317, 21341, 21344, 21346, 21348, 21372, 21407, 21443, 21466, 21469, 21491, 21497, 21502, 21506, 21508, 21514, 21517, 21531, 21534, 21551, 21573, 21605, 21611, 21615, 21619, 21626, 21635, 21660, 21711, 21734, 21743, 21771, 21785, 21797, 21805, 21809, 21821, 21824, 21828, 21868, 21892, 21908, 21917, 21952, 21960, 21974, 22000, 22058, 22249, 22341, 22345, 22361, 22406, 22407, 22474, 22477, 22480, 22505, 22531, 22537, 22542, 22552, 22567, 22591, 22593, 22669, 22733, 22792, 22826, 22845, 22892, 22896, 22902, 22938, 22970, 22975, 23049, 23051, 23097, 23116, 23121, 23209, 23239, 23249, 23271, 23278, 23282, 23285, 23295, 23350, 23355, 23356, 23360, 23363, 23365, 23367, 23368, 23371, 23372, 23373, 23377, 23379, 23387, 23423, 23443, 23464, 23492, 23539, 23560, 23647, 23656, 23698, 23704, 23787, 23802, 23860, 23862, 23883, 24038, 24040, 24046, 24082, 24114, 24307, 24319, 24321, 24322, 24326, 24328, 24330, 24334, 24337, 24339, 24343, 24344, 24352, 24355, 24361, 24363, 24364, 24376, 24396, 24410, 24422, 24428, 24445, 24449, 24451, 24455, 24458, 24461, 24467, 24469, 24499, 24500, 24512, 24527, 24531, 24538, 24540, 24568, 24577, 24615, 24619, 24625, 24629, 24630, 24633, 24657, 24660, 24680, 24682, 24687, 24722, 24750, 24754, 24787, 24793, 24794, 24877, 24895, 24898, 24899, 24915, 24917, 24924, 24926, 24936, 24942, 24944, 24982, 24984, 24985, 24987, 24990, 24994, 25077, 25098, 25120, 25122, 25124, 25126, 25129, 25132, 25135, 25137, 25139, 25141, 25144, 25147, 25149, 25152, 25155, 25158, 25160, 25163, 25164, 25166, 25169, 25170, 25173, 25176, 25179, 25182, 25184, 25188, 25270, 25281, 25303, 25334, 25369, 25414, 25472, 25567, 25658, 25703, 25743, 25744, 25749, 25755, 25775, 25777, 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, 25978, 25981, 26033, 26037, 26042, 26047, 26050, 26056, 26089, 26115, 26126, 26128, 26134, 26136, 26145, 26147, 26149, 26160, 26185, 26187, 26188, 26277, 26374, 26377, 26379, 26382, 26384, 26389, 26398, 26475, 26490, 26523, 26533, 26541, 26558, 26575, 26606, 26622, 26646, 26650, 26668, 26674, 26679, 26685, 26688, 26720, 26729, 26750, 26757, 26803, 26813, 26898, 26899, 26916, 26934, 27012, 27026, 27040, 27079, 27088, 27091, 27096, 27215, 27231, 27638, 27652, 27662, 27684, 27685, 27688, 27696, 27703, 27750, 27759, 27791, 27793, 27810, 27822, 27824, 27831, 27833, 27850, 27860, 27861, 27902, 27930, 28043, 28064, 28137, 28150, 28152, 28154, 28160, 28168, 28178, 28185, 28189, 28190, 28215, 28220, 28224, 28229, 28233, 28234, 28241, 28255, 28269, 28339, 28353, 28362, 28364, 28376, 28377, 28387, 28392, 28395, 28511, 28516, 28530, 28564, 28567, 28597, 28636, 28647, 28653, 28665, 28687, 28729, 28848, 29011, 29085, 29165, 29167, 29169, 29171, 29172, 29179, 29203, 29257, 29280, 29312, 29393, 29564, 29737, 29741, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29773, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29829, 29839, 29846, 29853, 29855, 29857, 29864, 29877, 29881, 29897, 29902, 29910, 29920, 29937, 29948, 29961, 29968, 29988, 30043, 30062, 30086, 30111, 30124, 30126, 30133, 30139, 30148, 30152, 30180, 30286, 30288, 30291, 30295, 30299, 30304, 30305, 30309, 30315, 30325, 30337, 30341, 30374, 30388, 30420, 30423, 30444, 30447, 30458, 30550, 30561, 30570, 30579, 30587, 30590, 30602, 30622, 30629, 30632, 30634, 30639, 30653, 30654, 30662, 30670, 30683, 30691, 30699, 30708, 30786, 30802, 30811, 30819, 30849, 30852, 30853, 30871, 30916, 30919, 31017, 31056, 31062, 31070, 31077, 31086, 31092, 31097, 31101, 31103, 31113, 31123, 31127, 31134, 31173, 31185, 31212, 31217, 31221, 31224, 31226, 31268, 31281, 31332, 31333, 31334, 31335, 31337, 31338, 31341, 31343, 31344, 31346, 31349, 31353, 31354, 31355, 31357, 31372, 31373, 31375, 31377, 31381, 31385, 31388, 31390, 31392, 31400, 31404, 31414, 31416, 31420, 31431, 31432, 31446, 31458, 31460, 31491, 31513, 31515, 31532, 31559, 31590, 31612, 31633, 31637, 31646, 31658, 31660, 31665, 31674, 31677, 31678, 31684, 31685, 31687, 31690, 31692, 31699, 31701, 31704, 31705, 31716, 31719, 31725, 31726, 31729, 31732, 31734, 31741, 31743, 31748, 31749, 31758, 31759, 31762, 31767, 31769, 31777, 31783, 31784, 31785, 31788, 31790, 31794, 31797, 31801, 31805, 31810, 31811, 31816, 31820, 31837, 31841, 31843, 31845, 31851, 31855, 31859, 31863, 31867, 31871, 31875, 31879, 31883, 31887, 31901, 31908, 31917, 31920, 31977, 32028, 32057, 32081, 32143, 32172, 32201, 32215, 32256, 32258, 32260, 32322, 32327, 32347, 32349, 32350, 32351, 32353, 32357, 32359, 32361, 32367, 32368, 32376, 32388, 32419, 32421, 32423, 32425, 32428, 32430, 32433, 32435, 32437, 32438, 32443, 32448, 32451, 32453, 32455, 32458, 32460, 32463, 32465, 32467, 32469, 32472, 32473, 32476, 32480, 32482, 32487, 32491, 32496, 32505, 32544, 32575, 32605, 32643, 32686, 32688, 32734, 32815, 32816, 32817, 32819, 32821, 32822, 32823, 32827, 32830, 32847, 32851, 32853, 32855, 32857, 32861, 32863, 32869, 32899, 32906, 32910, 32940, 32947, 33010, 33012, 33018, 33027, 33035, 33037, 33080, 33164, 33180, 33194, 33214, 33215, 33217, 33218, 33220, 33224, 33227, 33228, 33229, 33234, 33250, 33253, 33294, 33306, 33316, 33320, 33323, 33335, 33345, 33346, 33347, 33349, 33361, 33384, 33405, 33440, 33539, 33674, 33702, 33718, 33723, 33726, 33727, 33730, 33732, 33733, 33736, 33738, 33739, 33741, 33742, 33743, 33756, 33762, 33769, 33772, 33777, 33779, 33783, 33785, 33793, 33795, 33797, 33800, 33804, 33806, 33812, 33821, 33834, 33835, 33838, 33839, 33841, 33847, 33853, 33855, 33867, 33874, 33876, 33877, 33878, 33889, 33894, 33913, 33939, 33976, 33978, 33979, 33986, 34015, 34039, 34168, 34170, 34180, 34208, 34214, 34215, 34218, 34220, 34227, 34235, 34243, 34245, 34247, 34250, 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, 34328, 34329, 34331, 34332, 34333, 34334, 34337, 34338, 34397, 34400, 34401, 34404, 34406, 34410, 34413, 34414, 34418, 34433, 34437, 34442, 34445, 34459, 34470, 34487, 34512, 34524, 34526, 34528, 34530, 34532, 34534, 34537, 34539, 34542, 34544, 34548, 34551, 34553, 34556, 34558, 34560, 34576, 34578, 34584, 34586, 34588, 34590, 34597, 34722, 34741, 34790, 34797, 34803, 34806, 34825, 34828, 34840, 34880, 34885, 34909, 34950, 34973, 34983, 34990, 35006, 35041, 35054, 35061, 35095, 35103, 35105, 35107, 35112, 35117, 35141, 35145, 35147, 35152, 35157, 35162, 35169, 35177, 35184, 35218, 35277, 35290, 35296, 35312, 35319, 35353, 35375, 35376, 35400, 35416, 35421, 35426, 35438, 35468, 35501, 35503, 35507, 35523, 35553, 35555, 35566, 35575, 35582, 35873, 35894, 35895, 35901, 35932, 35938, 35940, 35974, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36049, 36051, 36053, 36055, 36062, 36066, 36072, 36075, 36081, 36091, 36097, 36100, 36103, 36106, 36108, 36118, 36120, 36129, 36137, 36167, 36171, 36181, 36186, 36223, 36232, 36237, 36239, 36243, 36251, 36253, 36266, 36275, 36291, 36308, 36343, 36476, 36495, 36499, 36528, 36532, 36585, 36637, 36639, 36641, 36645, 36646, 36647, 36648, 36649, 36650, 36652, 36654, 36655, 36656, 36661, 36666, 36674, 36679, 36707, 36710, 36714, 36716, 36721, 36728, 36730, 36733, 36755, 36756, 36774, 36794, 36821, 36834, 36851, 36876, 36905, 36907, 36989, 37017, 37021, 37031, 37039, 37040, 37042, 37044, 37050, 37077, 37081, 37088, 37089, 37092, 37103, 37128, 37137, 37143, 37146, 37159, 37173, 37217, 37224, 37227, 37234, 37238, 37239, 37244, 37248, 37261, 37265, 37270, 37272, 37273, 37279, 37281, 37282, 37284, 37285, 37286, 37292, 37293, 37297, 37301, 37302, 37306, 37310, 37311, 37318, 37322, 37325, 37338, 37339, 37345, 37355, 37358, 37361, 37369, 37371, 37373, 37381, 37393, 37399, 37400, 37402, 37428, 37434, 37454, 37458, 37489, 37501, 37525, 37533, 37534, 37556, 37560, 37580, 37587, 37593, 37594, 37604, 37605, 37608, 37616, 37631, 37633, 37665, 37675, 37678, 37723, 37781, 37788, 37799, 37801, 37822, 37833, 37834, 37836, 37839, 37848, 37855, 37876, 37894, 37901, 37952, 37957, 37959, 37963, 37965, 37968, 37970, 37972, 37974, 37976, 37978, 37981, 37986, 37988, 37990, 37999, 38004, 38015, 38022, 38031, 38038, 38043, 38044, 38048, 38051, 38057, 38061, 38066, 38068, 38085, 38092, 38098, 38105, 38106, 38118, 38129, 38136, 38144, 38152, 38154, 38159, 38161, 38166, 38175, 38180, 38190, 38198, 38210, 38247, 38312, 38313, 38320, 38325, 38326, 38328, 38335, 38337, 38342, 38347, 38348, 38349, 38351, 38355, 38356, 38357, 38358, 38359, 38360, 38364, 38367, 38370, 38372, 38373, 38374, 38376, 38378, 38381, 38383, 38385, 38386, 38392, 38397, 38400, 38401, 38402, 38406, 38407, 38415, 38426, 38427, 38434, 38445, 38462, 38472, 38515, 38520, 38524, 38528, 38545, 38550, 38559, 38575, 38579, 38581, 38597, 38625, 38640, 38654, 38657, 38675, 38685, 38688, 38698, 38701, 38703, 38716, 38717, 38719, 38722, 38726, 38732, 38735, 38740, 38741, 38750, 38754, 38762, 38767, 38769, 49239, 51168, 51170, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51266, 51312, 51341, 51345, 51351, 51356) 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 London Merchant

Afterpiece Title: Fortunatus

Dance: I: By Desire, The Irish Lilt, as17651004

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Polly Honeycombe

Dance: II: A New Grand Pantomime Ballet, call'd The Village Romps-Fichar, Arnauld, Sga Manesiere

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: Comus

Afterpiece Title: Polly Honeycombe

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Polly Honeycombe

Dance: II: The Village Romps, as17651019

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Royal Convert

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Harlequin's Invasion

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Foundling

Afterpiece Title: A Fairy Tale

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Hermit

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Hermit

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Polly Honeycombe

Dance: II: Rural Love, as17651115

Performances

Mainpiece Title: The Mistake

Afterpiece Title: Midas

Performances

Mainpiece Title: The Royal Convert

Afterpiece Title: Midas

Performances

Mainpiece Title: The Mistake

Afterpiece Title: Midas

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: Midas

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Apprentice

Dance: I: A Hornpipe-Miss Twist; III: The Venetian Gardeners, as17650925; End: The Village Romps, as17651019

Performances

Mainpiece Title: King John

Afterpiece Title: Catherine and Petruchio

Dance: II: Hornpipe-Miss Twist; IV: Minuet-Hussey, Miss Wilford; End: Rural Love, as17651115

Performances

Mainpiece Title: The Mistake

Afterpiece Title: The Devil to Pay

Dance: II: Hornpipe-Miss Twist; End: The Village Romps, as17651019

Performances

Mainpiece Title: The Minor

Afterpiece Title: Miss in Her Teens

Entertainment: Dancing-