SELECT * FROM london_stages WHERE eventid IN (25122, 25124, 25126, 25129, 25132, 25135, 25137, 25139, 25141, 25144, 25147, 25149, 25152, 25155, 25158, 25160, 25163, 25166, 25169, 25173, 25176, 25179, 25184, 25188, 26236, 26238, 26240, 26242, 26244, 26246, 26248, 26250, 26252, 26254, 26257, 26259, 26261, 26264, 26266, 26268, 26271, 26273, 26275, 26278, 26281, 26283, 26285, 26288, 26290, 26293, 26295, 26297, 27897, 27903, 27909, 27914, 27919, 27923, 27928, 27933, 27939, 27943, 27948, 27953, 27959, 27966, 27979, 28009, 28010, 28035, 28083, 28092, 28119, 28289, 28291, 28293, 28295, 28297, 28299, 28301, 28303, 28308, 28310, 28312, 28315, 28317, 28320, 28322, 28324, 28326, 28373, 28384, 28403, 28409, 28411, 28416, 28441, 28444, 28464, 28476, 28486, 28494, 28498, 28501, 28524, 28543, 28565, 28642, 28644, 28653, 28671, 28745, 28797, 29317, 29325, 29331, 29338, 29342, 29395, 29410, 30347, 30349, 30352, 30354, 30356, 30366, 30396, 30731, 30732, 30734, 30735, 30736, 30737, 30740, 30742, 30743, 30744, 30751, 30754, 30865, 30867, 30870, 30874, 30886, 30888, 30893, 30922, 30926, 31151, 31236, 31245, 31612, 31633, 31637, 31654, 31658, 31674, 31678, 31687, 31701, 31716, 31726, 31741, 31762, 32149, 32665, 32728, 33092, 33097, 34164, 34175, 34207, 34229, 34246, 34797, 34803, 34808, 34814, 34821, 34824, 34831, 34834, 34839, 34849, 34855, 34859, 34877, 34882, 34884, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35543, 35551, 35558, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35629, 35635, 35642, 35683, 35756, 35818, 35823, 35826, 35865, 36438, 36637, 36666, 36668, 36670, 36679, 36683, 36685, 36689, 36691, 36695, 36715, 36725, 36753, 36776, 36781, 36887, 36931, 37015, 37267, 37269, 37273, 37275, 37277, 37350, 37360, 37362, 37367, 37372, 37383, 37385, 37411, 37415, 37420, 37427, 37431, 37434, 37442, 37444, 37456, 37477, 37478, 37496, 37506, 37511, 37518, 37520, 37524, 37541, 37567, 37575, 37579, 37585, 37603, 37633, 37672, 37675, 38118, 38478, 38480, 38482, 38484, 38486, 38489, 38497, 38510, 38517, 38522, 38524, 38526, 38529, 38531, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38560, 38562, 38569, 38579, 38584, 38612, 38919, 38921, 38985, 39097, 39112, 39125, 39153, 39168, 39180, 39198, 39202, 39204, 39215, 39227, 39233, 39238, 39244, 39249, 39256, 39267, 39272, 39284, 39295, 39300, 39319, 39332, 39333, 39335, 39344, 39352, 39356, 39367, 39373, 39394, 39463, 39464, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39559, 39561, 39563, 39565, 39568, 39570, 39582, 39588, 39590, 39592, 39595, 39601, 39604, 39606, 39608, 39610, 39612, 39614, 39616, 39619, 39622, 39624, 39626, 39628, 39630, 39633, 39635, 39638, 39644, 39649, 39661, 39664, 39671, 39674, 39676, 39686, 39688, 39700, 39701, 39715, 39728, 39742, 39756, 39758, 39765, 39771, 39783, 39788, 39799, 39813, 39829, 39842, 39844, 39846, 39853, 39874, 39899, 39908, 39931, 40040, 40042, 40044, 40046, 40048, 40053, 40059, 40061, 40071, 40073, 40093, 40099, 40121, 40135, 40140, 40149, 40163, 40166, 40168, 40173, 40177, 40179, 40181, 40191, 40196, 40198, 40201, 40202, 40204, 40205, 40206, 40207, 40208, 40210, 40211, 40212, 40213, 40214, 40216, 40217, 40218, 40219, 40220, 40222, 40223, 40224, 40225, 40226, 40227, 40228, 40230, 40232, 40233, 40235, 40236, 40237, 40238, 40239, 40240, 40242, 40243, 40244, 40245, 40246, 40247, 40248, 40249, 40250, 40251, 40252, 40253, 40254, 40257, 40259, 40271, 40275, 40278, 40279, 40281, 40282, 40284, 40285, 40289, 40291, 40292, 40295, 40296, 40297, 40302, 40304, 40305, 40307, 40308, 40310, 40311, 40316, 40323, 40326, 40331, 40340, 40349, 40352, 40353, 40355, 40358, 40359, 40360, 40367, 40372, 40373, 40379, 40382, 40391, 40403, 40404, 40413, 40414, 40422, 40425, 40429, 40431, 40438, 40450, 40454, 40461, 40468, 40475, 40482, 40493, 40497, 40547, 40548, 40549, 40550, 40552, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40573, 40579, 40584, 40585, 40587, 40593, 40602, 40603, 40611, 40631, 40638, 40673, 40689, 40692, 40704, 40709, 40715, 40716, 40719, 40724, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40742, 40744, 40745, 40747, 40749, 40751, 40754, 40757, 40760, 40762, 40764, 40766, 40769, 40771, 40773, 40774, 40776, 40778, 40780, 40783, 40785, 40786, 40788, 40794, 40796, 40800, 40803, 40806, 40808, 40812, 40818, 40820, 40821, 40824, 40825, 40828, 40830, 40831, 40833, 40838, 40839, 40841, 40842, 40844, 40845, 40847, 40848, 40851, 40852, 40853, 40856, 40859, 40861, 40865, 40866, 40869, 40872, 40875, 40876, 40879, 40881, 40882, 40883, 40884, 40890, 40891, 40895, 40898, 40900, 40901, 40902, 40904, 40909, 40912, 40913, 40914, 40916, 40917, 40919, 40920, 40923, 40927, 40928, 40929, 40930, 40931, 40933, 40937, 40939, 40941, 40942, 40944, 40950, 40951, 40953, 40954, 40955, 40956, 40960, 40967, 40970, 40971, 40977, 40978, 40984, 40992, 41000, 41003, 41005, 41026, 41031, 41040, 41041, 41043, 41048, 41050, 41056, 41059, 41060, 41061, 41064, 41072, 41082, 41089, 41091, 41101, 41179, 41201, 41207, 41209, 41225, 41235, 41333, 41346, 41349, 41351, 41353, 41355, 41358, 41360, 41363, 41365, 41368, 41370, 41373, 41375, 41378, 41380, 41382, 41396, 41398, 41399, 41401, 41403, 41407, 41411, 41414, 41416, 41427, 41429, 41440, 41446, 41450, 41454, 41465, 41473, 41479, 41484, 41495, 41497, 41498, 41518, 41523, 41524, 41533, 41537, 41546, 41552, 41567, 41575, 41577, 41590, 41604, 41611, 41614, 41619, 41622, 41624, 41633, 41661, 41681, 41684, 44589, 44593, 44599, 44650, 44652, 44654, 44658, 44661, 44662, 44666, 44670, 44674, 44678, 44680, 44681, 44682, 44683, 44686, 44689, 44690, 44693, 44694, 44697, 44705, 44708, 44710, 44743, 44750, 44757, 44764, 44776, 44787, 44796, 44843, 44846, 44848, 44859, 44860, 44862, 44867, 44870, 44873, 44874, 44876, 44879, 44883, 44897, 44898, 44909, 44912, 44915, 44916, 44920, 44925, 44929, 44933, 44934, 44936, 44937, 44942, 44946, 44947, 44951, 44952, 44955, 44956, 44960, 44962, 44967, 44969, 44971, 44972, 44974, 44976, 44979, 44980, 44981, 44985, 44986, 44987, 44994, 44999, 45004, 45005, 45007, 45013, 45014, 45020, 45022, 45025, 45030, 45033, 45037, 45041, 45042, 45046, 45047, 45052, 45056, 45058, 45061, 45066, 45072, 45152, 45186, 45190, 45198, 45200, 45203, 45205, 45207, 45210, 45211, 45212, 45215, 45217, 45220, 45221, 45225, 45226, 45229, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45321, 45333, 45342, 45349, 45354, 45365, 45386, 45390, 45403, 45410, 45416, 45429, 45461, 45472, 45487, 45517, 45526, 45545, 45554, 45570, 45574, 45585, 45589, 45598, 45693, 45704, 45726, 45735, 45740, 45748, 45750, 45752, 45756, 45771, 45797, 45805, 45815, 45834, 45835, 45837, 45843, 45849, 45855, 45861, 45868, 45875, 45876, 45882, 45884, 45896, 45897, 45908, 45911, 45914, 45916, 45918, 45925, 45930, 45934, 45937, 45941, 45944, 45958, 45965, 46024, 46028, 46042, 46058, 46070, 46083, 46098, 46104, 46105, 46110, 46116, 46122, 46127, 46128, 46131, 46134, 46138, 46144, 46149, 46154, 46155, 46161, 46167, 46172, 46177, 46182, 46183, 46184, 46196, 46206, 46208, 46209, 46211, 46214, 46217, 46219, 46221, 46228, 46229, 46230, 46231, 46232, 46233, 46234, 46236, 46238, 46239, 46240, 46241, 46243, 46248, 46249, 46250, 46254, 46255, 46256, 46257, 46258, 46259, 46342, 46343, 46344, 46346, 46348, 46353, 46354, 46356, 46358, 46363, 46365, 46366, 46382, 46386, 46387, 46399, 46402, 46406, 46422, 46430, 46434, 46435, 46439, 46444, 46445, 46449, 46453, 46454, 46458, 46459, 46463, 46464, 46467, 46468, 46472, 46474, 46478, 46479, 46483, 46484, 46488, 46489, 46490, 46492, 46493, 46498, 46500, 46502, 46503, 46504, 46507, 46511, 46512, 46519, 46520, 46521, 46525, 46533, 46534, 46539, 46548, 46550, 46553, 46557, 46561, 46562, 46566, 46567, 46571, 46576, 46581, 46591, 46592, 46596, 46605, 46610, 46614, 46615, 46620, 46625, 46630, 46632, 46633, 46635, 46640, 46642, 46671, 46689, 46692, 46698, 46700, 46703, 46705, 46714, 46737, 46743, 46746, 46751, 46758, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46865, 46867, 46871, 46873, 46875, 46881, 46885, 46887, 46889, 46891, 46893, 46895, 46897, 46907, 46909, 46921, 46923, 46925, 46927, 46929, 46931, 46933, 46937, 46945, 46947, 46953, 46955, 46963, 47001, 47005, 47013, 47025, 47037, 47047, 47049, 47061, 47063, 47064, 47066, 47069, 47071, 47074, 47076, 47083, 47084, 47086, 47088, 47089, 47091, 47093, 47094, 47096, 47098, 47099, 47101, 47102, 47104, 47105, 47108, 47110, 47114, 47115, 47117, 47119, 47120, 47124, 47128, 47129, 47131, 47133, 47135, 47139, 47140, 47144, 47146, 47148, 47150, 47152, 47156, 47161, 47163, 47165, 47167, 47169, 47181, 47186, 47188, 47198, 47204, 47207, 47235, 47238, 47253, 47270, 47273, 47277, 47279, 47289, 47302, 47309, 47312, 47315, 47320, 47326, 47361, 47379, 47559, 47564, 47580, 47619, 47635, 47651, 47674, 47751, 47796, 48038, 48043, 48049, 48080, 48090, 48101, 48103, 48105, 48109, 48111, 48115, 48117, 48119, 48123, 48125, 48127, 48129, 48131, 48133, 48135, 48137, 48150, 48154, 48158, 48162, 48166, 48170, 48174, 48178, 48182, 48186, 48190, 48194, 48195, 48197, 48200, 48207, 48223, 48225, 48236, 48248, 48264, 48280, 48308, 48354, 48437, 48443, 48446, 48452, 48463, 48468, 48551, 48553, 48569, 48588, 48613, 48618, 48620, 48621, 48628, 48654, 48677, 48734, 48744, 48858, 48884, 49046, 49051, 49058, 49069, 49216, 49222, 49226, 49244, 49331, 49336, 49341, 49346, 49355, 49360, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49525, 49563, 49599, 49628, 49646, 49676, 49684, 49692, 49732, 49742, 49743, 49783, 49785, 49794, 49805, 49815, 49865, 49886, 49891, 49897, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49927, 49929, 49931, 49933, 49935, 49936, 49938, 49940, 49941, 49943, 49945, 49947, 49949, 49950, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50058, 50064, 50065, 50071, 50073, 50080, 50085, 50099, 50108, 50113, 50116, 50118, 50149, 50151, 50163, 50170, 50186, 50193, 50195, 50203, 50215, 50274, 50281, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50544, 50546, 50549, 50551, 50552, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50589, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50641, 50644, 50647, 50648, 50650, 50652, 50653, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50681, 50684, 50688, 50690, 50695, 50697, 50699, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50719, 50722, 50724, 50726, 50728, 50736, 50737, 50739, 50742, 50744, 50747, 50764, 50772, 50779, 50782, 50784, 50790, 50802, 50805, 50812, 50855, 50927, 50929, 50932, 50936, 50940, 50959, 50965, 50971, 51052, 51057, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51079, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51140, 51183, 51188, 51195, 51219, 51238, 51247, 51249, 51254, 51256, 51258, 51261, 51263, 51269, 51277, 51283, 51285, 51293, 51298, 51304, 51314, 51319, 51322, 51329, 51336, 51338, 51356, 51360, 51361, 51363, 51365, 51366, 51368, 51374, 51379, 51393, 51398, 51401, 51406, 51509, 51513, 51517, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51557, 51561, 51565, 51569, 51577, 51581, 51591, 51598, 51601, 51605, 51607, 51610, 51613, 51615, 51619, 51621, 51624, 51625, 51627, 51629, 51631, 51634, 51636, 51637, 51639, 51641, 51643, 51648, 51651, 51653, 51655, 51662, 51664, 51665, 51667, 51676, 51701, 51719, 51731, 51759, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51806, 51811, 51813, 51815, 51817, 51820, 51822, 51825, 51828, 51833, 51836, 51840, 51841, 51842, 51843, 51846, 51849, 51856, 51861, 51864, 51869, 51871, 51884, 51885, 51887, 51890, 51900, 51907, 51914, 51926, 51929, 51933, 51936, 51940, 52232, 52237, 52246, 52251, 52260, 52265, 52272, 52278, 52331, 52332, 52335, 52338, 52343, 52350, 52363, 52375, 52408, 52411, 52413, 52417, 52421, 52430, 52440, 52444, 52449, 52450, 52451, 52458, 52459, 52464, 52485, 52487, 52493, 52497, 52505, 52507, 52530, 52533, 52538, 52541, 52546, 52554, 52557, 52562, 52565, 52570, 52573, 52578) 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 Suspicious Husband

Afterpiece Title: The Fair

Dance: Maranesi, Sga Bugiani

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Fair

Dance: Maranesi, Sga Bugiani

Performances

Mainpiece Title: Lady Jane Gray

Afterpiece Title: The Englishman Return'd from Paris

Performances

Mainpiece Title: Phaedra And Hippolitus

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: Old Batchelor

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Country Lasses

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551114

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551114

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Non Juror

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Englishman Return'd from Paris

Dance: As17551101

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Englishman Return'd from Paris

Dance: Granier Jun, Mlle Capdeville

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Englishman Return'd from Paris

Dance: LLes Statues Animees, as17560302

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Englishman Return'd from Paris

Dance: LLes Statues Animees, as17560302

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Englishman Return'd from Paris

Dance: New Ballet call'd the%Villagers-Granier, Miss Hilliard

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: A Will and no Will; or, A new case for the Lawyers

Dance: II: New Sailor's Dance, as17560217; End: A Minuet-Miss Macklin, Leviez. By Desire

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Englishman Return'd from Paris

Dance: FFingalian Dance, as17551126; Les Statues Animees, as17560302

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Mock Orators

Dance: NNew Comic Dance-

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: Harlequin Mountebank

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Harlequin Mountebank

Dance: II: New Comic Dance, call'd The Indian Peasants-

Performances

Mainpiece Title: Love And Duty

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Mercury Harlequin

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Mercury Harlequin