SELECT * FROM london_stages WHERE eventid IN (28662, 28664, 28669, 28675, 28679, 28696, 28702, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28790, 28794, 28800, 28810, 28813, 28815, 28818, 28820, 28839, 28841, 28849, 28854, 28861, 28871, 28882, 28885, 28887, 28896, 28930, 28942, 28956, 28958, 28978, 28997, 29009, 29014, 29046, 29068, 29195, 29203, 29213, 29217, 29244, 29280, 29291, 29300, 29308, 29312, 29315, 29320, 29331, 29336, 29338, 29342, 29344, 29349, 29352, 29357, 29361, 29363, 29367, 29369, 29393, 29395, 29398, 29412, 29424, 29428, 29431, 29442, 29445, 29449, 29452, 29484, 29488, 29496, 29499, 29503, 29532, 29537, 29549, 29583, 29722, 29766, 29810, 29823, 29826, 29877, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29958, 29960, 29981, 30006, 30009, 30028, 30039, 30055, 30057, 30081, 30114, 30116, 30145, 30151, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30337, 30381, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30450, 30452, 30475, 30479, 30484, 30566, 30575, 30622, 30653, 30660, 30686, 30690, 30695, 30699, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30878, 30880, 30882, 30884, 30886, 30888, 30893, 30900, 30916, 30922, 30924, 30926, 30928, 30930, 30933, 30935, 30937, 30940, 30942, 30944, 30947, 30950, 30954, 30966, 30973, 30979, 30983, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31057, 31061, 31066, 31069, 31074, 31076, 31094, 31097, 31100, 31102, 31109, 31112, 31116, 31136, 31158, 31179, 31182, 31189, 31197, 31203, 31216, 31220, 31223, 31253, 31274, 31339, 31368, 31370, 31372, 31374, 31378, 31380, 31382, 31384, 31387, 31389, 31391, 31393, 31395, 31397, 31399, 31405, 31409, 31411, 31417, 31419, 31426, 31428, 31430, 31432, 31435, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31513, 31515, 31517, 31519, 31523, 31526, 31531, 31533, 31535, 31537, 31542, 31556, 31569, 31605, 31611, 31614, 31617, 31620, 31626, 31629, 31632, 31636, 31642, 31648, 31657, 31671, 31673, 31686, 31689, 31700, 31703, 31715, 31718, 31725, 31731, 31740, 31747, 31753, 31761, 31767, 31771, 31773, 32319, 32321, 32325, 32329, 32334, 32339, 32342, 32346, 32348, 32350, 32352, 32356, 32358, 32364, 32366, 32382, 32384, 32390, 32393, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32452, 32454, 32459, 32464, 32466, 32493, 32523, 32526, 32546, 32558, 32644, 32653, 32666, 32671, 32676, 32678, 32680, 32693, 32704, 32708, 32720, 32722, 32724, 32729, 32734, 32748, 32807, 32813, 32815, 32817, 32822, 32827, 32830, 32832, 32834, 32836, 32838, 32840, 32842, 32846, 32848, 32850, 32852, 32854, 32856, 32858, 32860, 32862, 32864, 32866, 32868, 32870, 32872, 32874, 32876, 32878, 32882, 32884, 32886, 32888, 32890, 32892, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32933, 32935, 32944, 32949, 32953, 32956, 32958, 32960, 32962, 32966, 32969, 32972, 32974, 32976, 32978, 32981, 32983, 32985, 32987, 32989, 32991, 32994, 32996, 32999, 33003, 33005, 33008, 33010, 33012, 33017, 33020, 33022, 33024, 33026, 33029, 33031, 33034, 33039, 33042, 33045, 33092, 33103, 33106, 33108, 33110, 33116, 33121, 33134, 33136, 33145, 33150, 33158, 33166, 33172, 33179, 33183, 33193, 33195, 33260, 33265, 33267, 33269, 33271, 33273, 33275, 33277, 33285, 33287, 33289, 33291, 33295, 33297, 33300, 33304, 33344, 33346, 33348, 33353, 33362, 33364, 33369, 33372, 33374, 33378, 33381, 33383, 33386, 33390, 33402, 33428, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33486, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33570, 33572, 33585, 33589, 33604, 33617, 33620, 33622, 33626, 33647, 33659, 33664, 33673, 33693, 33700, 33710, 33719, 33725, 33792, 33798, 33800, 33802, 33804, 33806, 33808, 33810, 33814, 33819, 33821, 33823, 33825, 33829, 33831, 33833, 33837, 33839, 33841, 33843, 33849, 33875, 33882, 33889, 33898, 33903, 33905, 33907, 33917, 33919, 33921, 33924, 33929, 33933, 33962, 33969, 33972, 34014, 34017, 34040, 34050, 34058, 34063, 34069, 34072, 34078, 34146, 34161, 34173, 34182, 34187, 34197, 34202, 34204, 34237, 34258, 34317, 34342, 34350, 34374, 34397, 34400, 34406, 34410, 34418, 34578, 34580, 34681, 34688, 34696, 34722, 34770, 34772, 34779, 34893, 34901, 34905, 34913, 34984, 34989, 35033, 35062, 35064, 35068, 35080, 35083, 35085, 35090, 35097, 35102, 35104, 35106, 35113, 35120, 35132, 35138, 35147, 35195, 35210, 35240, 35245, 35250, 35274, 35286, 35302, 35321, 35332, 35337, 35354, 35357, 35379, 35381, 35495, 35498, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35617, 35621, 35626, 35629, 35635, 35642, 35645, 35647, 35650, 35653, 35656, 35659, 35662, 35665, 35667, 35669, 35672, 35674, 35676, 35678, 35681, 35683, 35686, 35688, 35693, 35696, 35702, 35707, 35716, 35718, 35723, 35756, 35761, 35788, 35802, 35810, 35813, 35818, 35823, 35826, 35865, 35868, 35918, 35986, 35989, 35992, 36113, 36201, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36253, 36257, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36308, 36317, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36437, 36473, 36482, 36499, 36504, 36508, 36516, 36540, 36546, 36555, 36565, 36636, 36649, 36651, 36653, 36673, 36688, 36696, 36704, 36710, 36714, 36717, 36738, 36750, 36752, 36756, 36764, 36773, 36784, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36834, 36837, 36839, 36844, 36846, 36850, 36853, 36855, 36860, 36878, 36881, 36883, 36890, 36897, 36902, 36904, 36906, 36914, 36925, 36955, 36957, 37028, 37044, 37080, 37094, 37119, 37124, 37212, 37216, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37253, 37257, 37264, 37270, 37272, 37276, 37307, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37371, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37436, 37439, 37443, 37445, 37455, 37460, 37467, 37477, 37479, 37517, 37524, 37566, 37570, 37579, 37584, 37602, 37618, 37637, 37643, 37646, 37665, 37667, 37671, 37675, 37785, 37790, 37795, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37837, 37852, 37856, 37870, 37874, 37887, 37893, 37897, 37902, 37905, 37907, 37916, 37925, 37941, 37943, 37949, 37962, 38050, 38060, 38123, 38153, 38156, 38158, 38167, 38172, 38177, 38183, 38216, 38219, 38224, 38315, 38320, 38330, 38334, 38336, 38341, 38367, 38422, 38434, 38439, 38448, 38450, 38453, 38455, 38457, 38464, 38467, 38469, 38471, 38561, 38573, 38583, 38598, 38611, 38658, 38675, 38682, 38700, 38719, 38731, 38743, 38760, 43645, 43660, 43675, 43690, 43733, 43748, 43864, 44329, 45100, 45105) 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 Alchemist

Afterpiece Title: The Anatomist

Performances

Mainpiece Title: The Roman Father

Ballet: By Desire, The Prussian Camp. As17580120, but Officer-Blakes

Performances

Mainpiece Title: The Drummer; Or, The Haunted House

Afterpiece Title: Queen Mab

Ballet: II: The Prussian Camp. As17580131

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Lethe

Ballet: II: The Prussian Camp. As17580131

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Intriguing Chambermaid

Ballet: I: The Prussian Camp. As17580131

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: Queen Mab

Ballet: II: The Prussian Camp. As17580131

Performances

Mainpiece Title: Agis

Ballet: (BBy Desire,)The Prussian Camp. As17580131

Performances

Mainpiece Title: Agis

Afterpiece Title: The Apprentice

Ballet: I: The Prussian Camp. As17580131

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Fair Quaker Of Deal

Afterpiece Title: Queen Mab

Ballet: II: The Prussian Camp. As17580131, but Blakes_

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: The Upholsterer

Ballet: II: The Prussian Camp. As17580328

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: Queen Mab

Ballet: II: The Prussian Camp. As17580328

Performances

Mainpiece Title: King Henry Iv

Afterpiece Title: The Devil to Pay

Ballet: The Prussian Camp. As17580328 but Officer-Blakes

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Englishman in Paris

Dance: End: A new Grand Dance-the Children; End Farce: Minuet-Leviez, Miss Macklin

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: Britannia

Dance: A Hornpipe-Harrison

Ballet: TThe Prussian Camp. As17580421 but Blakes_

Performances

Mainpiece Title: The Wonder

Afterpiece Title: Harlequin Ranger

Ballet: I: The Prussian Camp. As17580421

Performances

Mainpiece Title: The Tempest

Cast
Role: Actor: Giorgi, Sga Lucchi, others.

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: Comus

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Comus

Afterpiece Title: The Diversions of the Morning

Performances

Mainpiece Title: The Tempest

Cast
Role: Actor: Giorgi, Sga Lucchi, others.

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Queen Mab

Song: III: A Cantata-Miss Young

Ballet: II: The Prussian Camp (an Entertainment). Officer-Blakes; Prussian Soldiers-the comedians; Characters of the dance-Grimaldi, Giorgi, Sga Lucchi, Mrs Vernon

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Mercury Harlequin

Ballet: II: The Prussian Camp. As17581214