SELECT * FROM london_stages WHERE eventid IN (13292, 13296, 13318, 13322, 13343, 13351, 13355, 13360, 17805, 17809, 17813, 17816, 17820, 17823, 17826, 17829, 17832, 17835, 17839, 17843, 17847, 17852, 17857, 17862, 17867, 17875, 17906, 17944, 17954, 18224, 18229, 18233, 18237, 18242, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18278, 18281, 18283, 18286, 18289, 18292, 18295, 18300, 18303, 18307, 18310, 18314, 18318, 18432, 18437, 18444, 18447, 18450, 19510, 19516, 19520, 19527, 19534, 19536, 19538, 19556, 19562, 19576, 19590, 19595, 19611, 19646, 19648, 19650, 19653, 19656, 19658, 19659, 19663, 19683, 19685, 19713, 19715, 19741, 19791, 19793, 19795, 19798, 19845, 19847, 19878, 19881, 19883, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20002, 20003, 20008, 20010, 20012, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20053, 20054, 20058, 20063, 20067, 20068, 20072, 20082, 20088, 20098, 20102, 20103, 20107, 20111, 20113, 20116, 20122, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20359, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21103, 21119, 21138, 21141, 21145, 21148, 21152, 21155, 21159, 21163, 21170, 21172, 21179, 21184, 21186, 22082, 22087, 22090, 22093, 22096, 22099, 22104, 22107, 22114, 22130, 22143, 22154, 22385, 22388, 22390, 22392, 22442, 22445, 22449, 22506, 22509, 22515, 22518, 22522, 22532, 22553, 22556, 22565, 22609, 22617, 22619, 22660, 22670, 22702, 22750, 22770, 22773, 22831, 22939, 22942, 22945, 22948, 22957, 22959, 22971, 22974, 22979, 23003, 23005, 23015, 23036, 23041, 23066, 23098, 23101, 23104, 23128, 23140, 23151, 23179, 23207, 23210, 23215, 23226, 23267, 23298, 23558, 23561, 23594, 23662, 23706, 23711, 23721, 23728, 23744, 23747, 23812, 23826, 23842, 26178, 28823, 28825, 28828, 28831, 28837, 28841, 28844, 28847, 28871, 28876, 28885, 28891, 28893, 28896, 28956, 28958, 28983, 28997, 29070, 29173, 29180, 29190, 29196, 29415, 29537, 29547, 29549, 29593, 29610, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29935, 29942, 29953, 29957, 29959, 29963, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30053, 30126, 30133, 30144, 30148, 30152, 30745, 30746, 30748, 30752, 30757, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 31398, 31402, 31404, 31406, 31408, 31410, 31412, 31416, 31425, 31429, 31436, 31438, 31452, 31456, 31460, 31463, 31501, 31503, 31513, 31515, 31516, 31517, 31520, 31524, 31530, 31532, 31534, 31536, 31541, 31547, 31854, 31858, 31860, 31862, 31866, 31870, 31882, 31890, 31892, 31894, 31898, 31906, 31910, 31918, 31928, 31931, 31936, 31940, 31947, 31956, 31961, 31970, 31975, 31986, 31988, 31990, 32205, 32377, 32379, 32383, 32385, 32389, 32391, 32396, 32402, 32404, 32408, 32420, 32422, 32424, 32429, 32431, 32443, 32471, 32473, 32475, 32477, 32479, 32481, 32486, 32488, 32493, 32495, 32500, 32502, 32507, 32510, 32514, 32515, 32516, 32517, 32524, 32527, 32537, 32540, 32554, 32556, 32558, 32563, 32568, 32573, 32575, 32580, 32593, 32619, 32648, 32656, 32658, 32692, 32721, 32738, 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, 33042, 33265, 33269, 33271, 33273, 33275, 33277, 33285, 33289, 33295, 33300, 33304, 33315, 33317, 33322, 33325, 33327, 33330, 33332, 33339, 33341, 33344, 33346, 33353, 33383, 33397, 33400, 33402, 33428, 33430, 33435, 33439, 33481, 33483, 33506, 33515, 33520, 33536, 33654, 33794, 33796, 33804, 33808, 33810, 33896, 33995, 33997, 33999, 34001, 34004, 34006, 34009, 34011, 34013, 34015, 34018, 34025, 34029, 34034, 34068, 34089, 34181, 34187, 34198, 34199, 34230, 34253, 34259, 34267, 34340, 34345, 34356, 34368, 34375, 34376, 34377, 34380, 34384, 34390, 34394, 34415, 34431, 34433, 34435, 34437, 34440, 34442, 34445, 34449, 34452, 34453, 34456, 34459, 34461, 34463, 34465, 34470, 34475, 34485, 34521, 34531, 34536, 34541, 34547, 34552, 34559, 34566, 34569, 34571, 34585, 34589, 34598, 34668, 34694, 34713, 34720, 34723, 34725, 34732, 34739, 34751, 34754, 34759, 34761, 34777, 34779, 34782, 34785, 34794, 34805, 34895, 34911, 34917, 35281, 35308, 35504, 35509, 35512, 35517, 35519, 35528, 35530, 35533, 35537, 35539, 35545, 35547, 35560, 35562, 35568, 35570, 35575, 35579, 35585, 35592, 35604, 35606, 35608, 35611, 35613, 35618, 35619, 35620, 35621, 35622, 35630, 35639, 35651, 35693, 35749, 35763, 35810, 35814, 35824, 35843, 35870, 35910, 35929, 35945, 36141, 36143, 36145, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36482, 36523, 36529, 36540, 36649, 36653, 36688, 36696, 36704, 36717, 36722, 36731, 36736, 36742, 36746, 36748, 36752, 36755, 36764, 36773, 36780, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36842, 36845, 36847, 36849, 36851, 36854, 36859, 36861, 36867, 36872, 36874, 36876, 36889, 36896, 36898, 36903, 36905, 36910, 36970, 36989, 37029, 37036, 37058, 37061, 37064, 37067, 37068, 37077, 37079, 37086, 37096, 37120, 37212, 37214, 37218, 37228, 37229, 37230, 37236, 37241, 37251, 37268, 37303, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37430, 37436, 37443, 37445, 37455, 37477, 37480, 37486, 37491, 37524, 37566, 37579, 37623, 37643, 37787, 37793, 37797, 37803, 37825, 37827, 37829, 37833, 37835, 37852, 37870, 37874, 37887, 37893, 37902, 37905, 37941, 37943, 37949, 37962, 38050, 38123, 38153, 38158, 38167, 38172, 38183, 38335, 38338, 38339, 38343, 38346, 38350, 38352, 38354, 38361, 38362, 38365, 38368, 38369, 38370, 38371, 38377, 38379, 38416, 38430, 38444, 38448, 38458, 38464, 38465, 38706, 38731, 38873, 38883, 38891, 38893, 38951, 38956, 38974, 39023, 39025, 39029, 39031, 39033, 39035, 39039, 39042, 39048, 39050, 39052, 39057, 39061, 39070, 39075, 39077, 39082, 39203, 39209, 39237, 39258, 39261, 39277, 39283, 39294, 39299, 39313, 39318, 39330, 39398, 39400, 39404, 39407, 39411, 39413, 39415, 39426, 39435, 39439, 39454, 39456, 39458, 39461, 39511, 39513, 39518, 39603, 39611, 39613, 39615, 39618, 39621, 39625, 39629, 39632, 39637, 39641, 39646, 39675, 39678, 39687, 39707, 39735, 39750, 39840, 39866, 39871, 39966, 39968, 39973, 40035, 40125, 40153, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40279, 40311, 40316, 40323, 40326, 40331, 40358, 40367, 40379, 40382, 40388, 40413, 40425, 40427, 40454, 40565, 40571, 40577, 40588, 40597, 40639, 40846, 40860, 40959, 40964, 40982, 41102, 41103, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41128, 41136, 41165, 41189, 41237, 41246, 41256, 41280, 41286, 41300, 41308, 41322, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 42187, 42194, 42198, 42222, 42226, 42227, 42293, 42294, 42447, 42449, 42451, 42454, 42457, 42460, 42464, 42471, 42474, 42478, 42483, 42488, 42493, 42495, 42500, 42503, 42507, 42512, 42519, 42524, 42529, 42531, 42533, 42540, 42543, 42548, 42560, 42565, 42570, 42583, 42596, 42609, 42670, 42726, 42764, 42766, 42767, 42770, 42772, 42780, 42831, 42833, 42834, 42835, 42837, 42847, 42849, 43271, 43380, 43390, 43398, 43402, 43407, 43420, 43423, 43966, 43976, 43980, 44001, 44011, 44012, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44508, 44512, 44519, 44520, 44528, 44545, 45537, 45547, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45951, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46093, 46100, 46103, 46121, 46133, 46148, 46154, 46166, 46174, 46220, 46407, 46409, 46411, 46412, 46413, 46414, 46415, 46416, 46417, 46418, 46419, 46420, 46421, 46423, 46424, 46425, 46426, 46427, 46428, 46429, 46431, 46432, 46433, 46436, 46437, 46438, 46440, 46441, 46442, 46443, 46446, 46447, 46448, 46451, 46452, 46455, 46457, 46460, 46461, 46462, 46464, 46466, 46469, 46470, 46471, 46473, 46476, 46477, 46478, 46481, 46482, 46486, 46487, 46492, 46494, 46495, 46509, 46511, 46515, 46522, 46529, 46535, 46536, 46566, 46593, 46700, 46711, 46729, 46905, 46917, 46941, 46949, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46990, 47008, 47012, 47014, 47018, 47020, 47024, 47026, 47032, 47044, 47052, 47070, 47075, 47087, 47116, 47130, 47182, 48551, 48553, 48569, 48588, 48613, 48618, 48620, 48621, 48628, 48650, 48654, 48672, 48677, 48712, 48722, 48734, 48737, 48744, 48760, 48762, 48763, 48765, 48768, 48770, 48772, 48773, 48782, 48784, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48827, 48831, 48837, 48845, 48850, 48852, 48858, 48859, 48864, 48866, 48880, 48883, 48884, 48891, 48903, 48919, 48928, 48931, 48948, 49046, 49051, 49058, 49069, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50210, 50215, 50374, 50380, 50385, 50387, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50537, 50542, 50558, 50570, 50800, 51360, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51853, 51877, 51927, 51929) 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 Suicide

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17810612

Performances

Mainpiece Title: Summer Amusement

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17810612

Performances

Mainpiece Title: The Separate Maintenance

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17810601

Performances

Mainpiece Title: Summer Amusement

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17810612

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17820606

Performances

Mainpiece Title: The Spanish Friar

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17820613

Performances

Mainpiece Title: The East Indian

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Performances

Mainpiece Title: Summer Amusement

Afterpiece Title: The Genius of Nonsense

Cast
Role: Pantaloon Actor: Massey

Dance: As17820606

Performances

Mainpiece Title: The Count Of Narbonne

Afterpiece Title: The Wishes

Cast
Role: Pantaloon Actor: Booth

Performances

Mainpiece Title: The Walloons

Afterpiece Title: The Wishes

Cast
Role: Pantaloon Actor: Booth

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Triumph of Mirth; or, Harlequin's Wedding

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Dance: As17821205

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Foundling

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Dance: End of Act II of mainpiece, as17820917

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Triumph of Mirth

Cast
Role: Pantaloon Actor: Delpini