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, 48296, 48298, 48300, 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 School For Scandal

Afterpiece Title: The Prisoner

Cast
Role: Narcisso Actor: Master Welsh

Song: As17921030

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Cast
Role: Rejoice greatly Actor: Master Welsh

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: At King's As You Like It

Afterpiece Title: The Prisoner

Cast
Role: Narcisso Actor: Master Welsh

Song: V: a song-Mrs Bland

Performances

Mainpiece Title: L'allegro Ed Il Penseroso [, Part I Only]; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

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

Afterpiece Title: Ozmyn and Daraxa

Dance: In afterpiece: Miss Menage, the Miss D'Egvilles

Performances

Mainpiece Title: L'allegro Ed Il Penseroso , Part I; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Performances

Mainpiece Title: At Hay King Henry The Eighth

Afterpiece Title: Ozmyn and Daraxa

Dance: As17930307

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Prize; or, 2

Cast
Role: Boy Actor: Master Welsh

Performances

Mainpiece Title: At Hay The Jealous Wife

Afterpiece Title: Ozmyn and Daraxa

Dance: As17930307

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: At King's The Confederacy

Afterpiece Title: Ozmyn and Daraxa

Dance: As17930307

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: The Messiah

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Performances

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

Afterpiece Title: The Prize

Performances

Mainpiece Title: Judas Maccabaeus [part I Only

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: Favourite Selections from Samson

Afterpiece Title: The Messiah

Song: In 3rd piece: He was eyes unto the blind-Harrison [Siroe]; after violin concerto: The Woody Vale (composed by Miss Poole)-Master Welsh

Music: End 1st piece: a new concerto on the hautboy (composed by W. Parke)-W. Parke; End 2nd piece: a new concerto on the violin-Alday

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 The Pirates

Afterpiece Title: The Agreeable Surprise

Dance: As17921121, but The Dances-Miss _Prevot

Song: In the course of the Evening The Little Farthing Rushlight-Bannister Jun

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prize