SELECT * FROM london_stages WHERE eventid IN (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, 48106, 48110, 48116, 48120, 48130, 48132, 48138, 48159, 48177, 48187, 48191, 48196, 48201, 48203, 48213, 48217, 48230, 48235, 48240, 48244, 48263, 48268, 48272, 48277, 48282, 48286, 48291, 48293, 48298, 48302, 48307, 48310, 48312, 48316, 48326, 48328, 48335, 48343, 48355, 48357, 48367, 48369, 48371, 48374, 48385, 48410, 49003, 49008, 49022, 49035, 49037, 49050, 49052, 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, 49233, 49239, 49243, 49249, 49255, 49257, 49261, 49273, 49275, 49279, 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, 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, 49765, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49790, 49793, 49795, 49802, 49808, 49810, 49812, 49816, 49822, 49824, 49828, 49830, 49834, 49838, 49846, 49850, 49852, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49887, 49890, 49894, 49901, 49904, 49911, 49916, 49925, 49928, 49930, 49934, 49937, 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, 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, 50377, 50386, 50393, 50395, 50399, 50401, 50403, 50409, 50417, 50419, 50427, 50434, 50448, 50457, 50460, 50462, 50465, 50471, 50474, 50476, 50479, 50481, 50483, 50505, 50507, 50516, 50519, 50521, 50523, 50525, 50528, 50530, 50539, 50545, 50550, 50555, 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, 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: Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Actor: Mr and Master Welsh

Performances

Mainpiece Title: The Messiah , Part I; Grand Selection 0

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Song: End 2nd piece: Ye spotted Snakes-(Stevens)

Performances

Mainpiece Title: At King's The Rival Sisters

Afterpiece Title: The Prisoner

Cast
Role: Narcisso Actor: Master Welsh

Performances

Mainpiece Title: At Hay The Rival Sisters

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's The Belle's Stratagem

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay The Rival Sisters

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's The Rival Sisters

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prisoner

Cast
Role: Narcisso Actor: Master Welsh

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay The Rival Sisters

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prize

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prize

Performances

Mainpiece Title: At Hay Macbeth

Cast
Role: Donalbain Actor: Master DeCamp

Afterpiece Title: The Prize

Song: The Original Music, as17921226, but _Caulfield, _Maddocks, _Alfred, _Lyons

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

Cast
Role: Child Actor: Master Harlowe

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 Hay Jane Shore

Afterpiece Title: The Prize

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: The Siege Of Belgrade

Afterpiece Title: THE MILLER OF MANSFIELD

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: THE CITIZEN

Performances

Mainpiece Title: The Jew

Afterpiece Title: THE PRIZE; or, 2