SELECT * FROM london_stages WHERE eventid IN (31048, 31050, 31053, 31058, 31060, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31188, 47701, 47711, 47716, 47726, 47731, 47741, 47746, 47756, 47761, 47771, 47776, 47876, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48106, 48110, 48112, 48116, 48120, 48122, 48130, 48132, 48138, 48159, 48175, 48177, 48187, 48191, 48196, 48201, 48203, 48213, 48217, 48230, 48235, 48240, 48244, 48263, 48268, 48270, 48272, 48274, 48277, 48279, 48282, 48284, 48286, 48291, 48293, 48298, 48302, 48307, 48310, 48312, 48316, 48319, 48326, 48328, 48335, 48340, 48343, 48355, 48357, 48367, 48369, 48371, 48374, 48383, 48385, 48393, 48397, 48401, 48410, 48412, 48415, 48426, 48429, 48566, 48568, 48570, 48574, 48939, 49003, 49008, 49022, 49030, 49035, 49037, 49045, 49050, 49052, 49060, 49071, 49080, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49116, 49117, 49119, 49120, 49122, 49190, 49198, 49200, 49202, 49204, 49205, 49207, 49210, 49213, 49215, 49218, 49220, 49225, 49227, 49230, 49231, 49233, 49239, 49243, 49249, 49255, 49257, 49261, 49267, 49273, 49275, 49279, 49281, 49285, 49291, 49297, 49299, 49301, 49304, 49311, 49318, 49320, 49323, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49361, 49363, 49365, 49367, 49370, 49375, 49377, 49379, 49381, 49384, 49389, 49395, 49407, 49412, 49415, 49417, 49419, 49424, 49435, 49444, 49489, 49521, 49547, 49559, 49562, 49569, 49572, 49574, 49579, 49582, 49584, 49586, 49591, 49593, 49601, 49603, 49606, 49608, 49619, 49624, 49629, 49634, 49636, 49643, 49760, 49763, 49765, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49784, 49790, 49793, 49795, 49802, 49808, 49810, 49812, 49816, 49822, 49824, 49828, 49830, 49834, 49838, 49840, 49844, 49846, 49850, 49852, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49887, 49890, 49894, 49901, 49904, 49911, 49916, 49925, 49928, 49930, 49934, 49937, 49944, 49946, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50034, 50047, 50051, 50060, 50063, 50066, 50069, 50081, 50086, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50112, 50115, 50117, 50120, 50122, 50130, 50133, 50137, 50152, 50160, 50188, 50190, 50192, 50218, 50223, 50335, 50339, 50344, 50349, 50351, 50354, 50357, 50367, 50369, 50375, 50377, 50379, 50381, 50386, 50390, 50393, 50395, 50397, 50399, 50401, 50403, 50407, 50409, 50417, 50419, 50421, 50427, 50432, 50434, 50443, 50448, 50457, 50460, 50462, 50465, 50471, 50474, 50476, 50479, 50481, 50483, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50516, 50519, 50521, 50523, 50525, 50528, 50530, 50537, 50539, 50542, 50545, 50550, 50555, 50558, 50563, 50570, 50572, 50575, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50604, 50608, 50610, 50613, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50673, 50675, 50687, 50689, 50692, 50694, 50703, 50706, 50713, 50730, 50735, 50743, 50746, 50748, 50751, 50753, 50761, 50763, 50766, 50768, 50771, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799) 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: At King's The Pirates

Afterpiece Title: The Mayor of Garratt

Dance: As17930408

Performances

Mainpiece Title: At Hay Othello

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's The Chapter Of Accidents

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay The Grecian Daughter

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's As You Like It

Afterpiece Title: The Prize

Song: As17930304

Performances

Mainpiece Title: At Hay Isabella

Afterpiece Title: The Prize

Song: As17921217

Performances

Mainpiece Title: At King's She Wou'd And She Wou'd Not

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's The School For Scandal

Afterpiece Title: The Mariners

Song: As17921030

Performances

Mainpiece Title: At Hay Jane Shore

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's The Country Girl

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At Hay The Jealous Wife

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Sultan

Dance: As17930408

Performances

Mainpiece Title: At King's Twelfth Night

Afterpiece Title: The Mariners

Song: End II: The Lucky Escape-Dignum; End IV: Primroses deck the banks (composed by Linley? Sen.)-Master Welsh; End: Fair Rosale-Master Welsh

Cast
Role: Actor: Master Welsh
Role: Fair Rosale Actor: Master Welsh.

Performances

Mainpiece Title: At Hay The Gamester

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Mariners

Dance: As17930408

Song: End II: a New Song composed by Percy-Master Welsh

Performances

Mainpiece Title: At Hay The Recruiting Officer

Afterpiece Title: The Mariners

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Humourist

Dance: As17930408

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Royal Clemency; or, The Deserter of Naples

Performances

Mainpiece Title: The Humourist

Afterpiece Title: The Children in the Wood

Afterpiece Title: Royal Clemency

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Royal Clemency

Performances

Mainpiece Title: She Stoops To Conquer; Or, The Mistakes Of A Night

Afterpiece Title: The Humourist

Performances

Mainpiece Title: The Box-lobby Challenge

Afterpiece Title: THE CHILDREN IN THE WOOD

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: THE MILLER OF MANSFIELD

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: THE CITIZEN