SELECT * FROM london_stages WHERE eventid IN (46229, 46772, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47416, 47419, 47424, 47709, 47724, 47779, 47787, 47803, 47825, 47865, 47869, 47919, 48029, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48250, 48252, 48257, 48261, 48266, 48271, 48275, 48280, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48322, 48325, 48329, 48331, 48336, 48347, 48352, 48354, 48358, 48361, 48363, 48366, 48368, 48375, 48377, 48380, 48382, 48384, 48396, 48404, 48409, 48411, 48430, 48437, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48523, 48541, 48551, 48553, 48567, 48659, 48665, 48685, 48687, 48697, 48704, 48714, 48719, 48747, 48749, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48837, 48851, 48856, 48860, 48865, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48898, 48899, 48902, 48908, 48909, 48912, 48913, 48916, 48918, 48922, 48923, 48926, 48927, 48930, 48937, 48941, 48945, 48951, 48952, 48959, 48961, 48980, 48986, 48988, 48990, 48993, 49007, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49043, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49133, 49135, 49137, 49167, 49172, 49193, 49197, 49199, 49206, 49208, 49211, 49214, 49216, 49222, 49226, 49238, 49242, 49244, 49246, 49248, 49250, 49252, 49254, 49256, 49260, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49439, 49452, 49465, 49469, 49472, 49473, 49478, 49485, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49558, 49560, 49565, 49570, 49575, 49578, 49580, 49585, 49589, 49592, 49597, 49599, 49602, 49604, 49607, 49612, 49620, 49635, 49640, 49646, 49650, 49655, 49657, 49659, 49662, 49664, 49667, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49783, 49787, 49791, 49794, 49799, 49801, 49803, 49805, 49813, 49815, 49817, 49835, 49869, 49886, 49891, 49897, 49900, 49902, 49924, 49980, 49983, 49985, 49987, 49989, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50118, 50136, 50141, 50143, 50151, 50153, 50156, 50161, 50163, 50170, 50177, 50184, 50186, 50189, 50195, 50203, 50215, 50306, 50308, 50310, 50352, 50353, 50356, 50358, 50360, 50361, 50364, 50374, 50376, 50378, 50380, 50385, 50387, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50456, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50517, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50684, 50688, 50690, 50695, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50736, 50739, 50742, 50744, 50754, 50757, 50759, 50764, 50772, 50790, 50795, 50802, 50805, 50812, 50837, 50843, 50849, 50853, 50858, 50859, 50867, 50870, 50877, 50880, 50940, 50942, 50951, 50959, 50961, 50965, 50971, 50983, 50985, 50997, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51140, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51266, 51268, 51273, 51277, 51285, 51298, 51304, 51309, 51312, 51329, 51336, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51405, 51415, 51420, 51428, 51430, 51453, 51481, 51488, 51490, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51676, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51759, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51799, 51801, 51803, 51806, 51808, 51811, 51813, 51815, 51817, 51820, 51822, 51825, 51828, 51833, 51836, 51838, 51841, 51843, 51849, 51856, 51859, 51861, 51864, 51869, 51871, 51877, 51879, 51885, 51887, 51890, 51900, 51902, 51907, 51909, 51914, 51919, 51922, 51927, 51929, 51931, 51933, 51936, 51955, 51967, 51989, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52034, 52044, 52046, 52049, 52050, 52051, 52053, 52060, 52072, 52077, 52079, 52081, 52082, 52085, 52093, 52097, 52099, 52102, 52104, 52106, 52108, 52116, 52122, 52126, 52128, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52170, 52172, 52178, 52180, 52182, 52184, 52186, 52188, 52190, 52194, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52241, 52243, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52274, 52277, 52280, 52282, 52289, 52291, 52294, 52296, 52303, 52317, 52329, 52341, 52347, 52353, 52355, 52359, 52362, 52365, 52367, 52374, 52377, 52379, 52383, 52386, 52389, 52391, 52394, 52396, 52398, 52400, 52403, 52405, 52408, 52410, 52415, 52418, 52427, 52434, 52437, 52444, 52449, 52454, 52458, 52468, 52471, 52473, 52481, 52483, 52490, 52497, 52499, 52506, 52509, 52516, 52520, 52529, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52563, 52571, 52574, 52575, 52576, 52577, 52579, 52581, 52583, 52584, 52585, 52586, 52587, 52595, 52597, 52600, 52602, 52604, 52605, 52606, 52610, 52615) 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: Secrets Worth Knowing

Afterpiece Title: The Round Tower

Cast
Role: Fishermen Actor: Townsend, Linton
Role: Huntsmen Actor: Gray, Linton, Street

Performances

Mainpiece Title: Romeo And Juliet

Song: As17980101

Performances

Mainpiece Title: The Conscious Lovers

Song: As17971118

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Joan of Arc; or, The Maid of Orleans

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: In afterpiece: The Harp-Weippert

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: The Round Tower

Cast
Role: Fishermen Actor: Townsend, Linton
Role: Huntsmen Actor: Gray, Linton, Street

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: The Round Tower

Cast
Role: Fishermen Actor: Townsend, Linton
Role: Huntsmen Actor: Gray, Linton, Street

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: He's Much to Blame

Afterpiece Title: Joan of Arc

Music: As17980214

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: He's Much to Blame

Afterpiece Title: Joan of Arc

Music: In 3rd piece: As17980214

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: He's Much to Blame

Afterpiece Title: Joan of Arc

Music: 3rd piece: As17980214

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: He's Much to Blame

Afterpiece Title: Joan of Arc

Music: In 3rd piece: as17980214

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Joan of Arc

Song: As17980101

Music: As17980214

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: He's Much to Blame

Afterpiece Title: The Honest Thieves

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Honest Thieves

Dance: As17971006

Song: In afterpiece: Queen Bess [not listed on playbill; see below]-Johnstone