SELECT * FROM london_stages WHERE eventid IN (45175, 45718, 45730, 45736, 45739, 45741, 45746, 45747, 45751, 45755, 45757, 45760, 45764, 45772, 45774, 45776, 45784, 45792, 45804, 45816, 45820, 45822, 45841, 45845, 45853, 45859, 45870, 45879, 45898, 45901, 45905, 45913, 45915, 45927, 45933, 45938, 45953, 45977, 45987, 46006, 46039, 46051, 46082, 46087, 46092, 46094, 46105, 46111, 46114, 46129, 46142, 46147, 46153, 46276, 46290, 46293, 46298, 46302, 46304, 46306, 46308, 46312, 46314, 46322, 46326, 46335, 46342, 46344, 46346, 46348, 46354, 46356, 46358, 46360, 46362, 46364, 46366, 46368, 46372, 46376, 46378, 46380, 46382, 46384, 46386, 46388, 46390, 46392, 46396, 46398, 46400, 46402, 46404, 46406, 46408, 46412, 46414, 46416, 46418, 46420, 46422, 46424, 46426, 46428, 46432, 46435, 46437, 46440, 46442, 46445, 46447, 46449, 46451, 46454, 46456, 46459, 46461, 46463, 46465, 46468, 46470, 46473, 46475, 46477, 46480, 46482, 46487, 46489, 46491, 46494, 46496, 46501, 46505, 46510, 46518, 46521, 46528, 46535, 46542, 46556, 46563, 46570, 46584, 46592, 46599, 46608, 46613, 46616, 46621, 46628, 46631, 46633, 46638, 46643, 46646, 46651, 46653, 46658, 46665, 46672, 46675, 46677, 46680, 46682, 46685, 46687, 46694, 46696, 46701, 46704, 46710, 46717, 46738, 46827, 46842, 46843, 46845, 46850, 46851, 46853, 46859, 46862, 46866, 46872, 46876, 46878, 46880, 46882, 46886, 46890, 46894, 46898, 46902, 46904, 46908, 46910, 46912, 46914, 46916, 46920, 46924, 46926, 46928, 46932, 46934, 46936, 46938, 46940, 46944, 46946, 46948, 46950, 46952, 46962, 46970, 47010, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47038, 47040, 47042, 47044, 47046, 47050, 47054, 47058, 47065, 47067, 47070, 47072, 47078, 47082, 47085, 47087, 47095, 47097, 47103, 47107, 47113, 47118, 47127, 47138, 47149, 47166, 47182, 47185, 47197, 47206, 47208, 47213, 47219, 47225, 47230, 47243, 47252, 47254, 47258, 47260, 47269, 47272, 47276, 47288, 47296, 47303, 47443, 47445, 47448, 47450, 47452, 47453, 47455, 47457, 47460, 47461, 47463, 47465, 47468, 47471, 47476, 47477, 47481, 47483, 47486, 47488, 47490, 47492, 47494, 47498, 47502, 47504, 47506, 47510, 47514, 47518, 47524, 47528, 47530, 47532, 47536, 47538, 47540, 47544, 47546, 47548, 47552, 47556, 47558, 47563, 47565, 47567, 47571, 47576, 47579, 47583, 47588, 47590, 47594, 47596, 47599, 47602, 47604, 47606, 47608, 47610, 47613, 47615, 47618, 47620, 47622, 47624, 47627, 47630, 47632, 47634, 47636, 47640, 47642, 47646, 47648, 47652, 47656, 47660, 47664, 47669, 47671, 47673, 47677, 47679, 47682, 47684, 47687, 47692, 47703, 47708, 47718, 47721, 47736, 47743, 47751, 47758, 47761, 47763, 47768, 47771, 47776, 47778, 47781, 47783, 47791, 47796, 47799, 47804, 47807, 47809, 47817, 47827, 47832, 47834, 47849, 47859, 47864, 47873, 47876, 47881, 47884, 47889, 47891, 47893, 47895, 47899, 47901, 47902, 47905, 47907, 47909, 47910, 47995, 47996, 47998, 48001, 48003, 48005, 48009, 48011, 48013, 48014, 48016, 48018, 48021, 48022, 48025, 48027, 48030, 48031, 48034, 48035, 48037, 48040, 48042, 48044, 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, 48136, 48138, 48145, 48149, 48151, 48153, 48157, 48165, 48169, 48173, 48177, 48179, 48181, 48185, 48187, 48191, 48196, 48201, 48203, 48208, 48210, 48213, 48217, 48219, 48222, 48224, 48230, 48235, 48237, 48240, 48242, 48244, 48254, 48263, 48270, 48272, 48274, 48277, 48279, 48282, 48284, 48286, 48291, 48296, 48300, 48305, 48310, 48319, 48340, 48381, 48383, 48393, 48395, 48397, 48401, 48403, 48410, 48412, 48415, 48420, 48426, 48429, 48431, 48436, 48500, 48696, 48716, 48738, 48740, 48746, 48748, 48750, 48758, 48772, 48780, 48788, 48792, 48797, 48804, 48818, 48820, 48831, 48836, 48838, 48843, 48850, 48878, 48897, 48914, 48989, 48992, 48997, 49001, 49003, 49008, 49015, 49020, 49027, 49030, 49037, 49040, 49042, 49045, 49052, 49055, 49057, 49060, 49068, 49073, 49076, 49080, 49082, 49087, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49116, 49117, 49119, 49120, 49122, 49127, 49131, 49133, 49134, 49140, 49141, 49143, 49144, 49145, 49146, 49148, 49149, 49157, 49159, 49160, 49162, 49165, 49167, 49168, 49169, 49172, 49175, 49176, 49177, 49178, 49179, 49181, 49182, 49183, 49186, 49192, 49194, 49196, 49198, 49200, 49202, 49205, 49207, 49210, 49212, 49213, 49215, 49218, 49220, 49221, 49223, 49225, 49227, 49230, 49231, 49235, 49239, 49243, 49249, 49255, 49257, 49259, 49261, 49265, 49267, 49271, 49273, 49279, 49281, 49285, 49287, 49291, 49295, 49297, 49301, 49304, 49306, 49309, 49311, 49318, 49320, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49358, 49361, 49363, 49365, 49367, 49370, 49372, 49375, 49377, 49379, 49381, 49384, 49389, 49395, 49398, 49407, 49412, 49415, 49417, 49421, 49424, 49426, 49444, 49521, 49542, 49544, 49549, 49559, 49564, 49572, 49574, 49579, 49593, 49596, 49598, 49603, 49613, 49615, 49619, 49621, 49624, 49626, 49629, 49634, 49636, 49639, 49643, 49645, 49648, 49758, 49769, 49802, 49808, 49816, 49822, 49824, 49828, 49830, 49834, 49838, 49846, 49850, 49856, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49880, 49885, 49887, 49890, 49894, 49901, 49904, 49906, 49909, 49911, 49914, 49923, 49925, 49928, 49930, 49932, 49937, 49939, 49942, 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, 50037, 50040, 50043, 50047, 50051, 50054, 50056, 50063, 50066, 50069, 50072, 50074, 50076, 50078, 50083, 50088, 50091, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50112, 50115, 50117, 50120, 50122, 50130, 50133, 50137, 50140, 50145, 50152, 50155, 50157, 50165, 50171, 50176, 50180, 50183, 50185, 50188, 50190, 50192, 50194, 50197, 50199, 50202, 50204, 50207, 50209, 50212, 50214, 50219, 50220, 50228, 50346, 50357, 50372, 50373, 50386, 50393, 50395, 50401, 50405, 50411, 50423, 50427, 50429, 50432, 50434, 50437, 50441, 50443, 50446, 50453, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50535, 50537, 50542, 50548, 50553, 50558, 50563, 50567, 50570, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50604, 50606, 50608, 50610, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50661, 50683, 50687, 50689, 50692, 50706, 50713, 50721, 50723, 50730, 50735, 50743, 50746, 50748, 50751, 50753, 50756, 50758, 50761, 50763, 50771, 50773, 50776, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50801, 50813, 50918, 50920, 50928, 50939, 50943, 50947, 50949, 50970, 50972, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51002, 51011, 51013, 51020, 51023, 51026, 51030, 51032, 51035, 51037, 51042, 51049, 51051, 51060, 51063, 51066, 51070, 51075, 51080, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51134, 51137, 51139, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51172, 51174, 51178, 51181, 51186, 51190, 51193, 51196, 51198, 51202, 51205, 51210, 51217, 51222, 51233, 51236, 51240, 51243, 51246, 51248, 51251, 51253, 51260, 51262, 51267, 51270, 51276, 51279, 51282, 51284, 51287, 51292, 51294, 51299, 51301, 51303, 51313, 51316, 51323, 51330, 51332, 51335, 51340, 51355, 51357, 51362, 51364, 51367, 51369, 51373, 51377, 51380, 51382, 51385, 51390, 51483, 51495, 51499, 51502, 51504, 51507, 51510, 51512, 51516, 51518, 51520, 51523, 51524, 51526, 51528, 51534, 51542, 51544, 51546, 51570, 51572, 51582, 51592, 51595, 51602, 51609, 51623, 51626, 51628, 51633, 51638, 51640, 51642, 51647, 51649, 51663, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51729, 51749, 51752, 51754, 51758, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51793, 51796, 51800, 51802, 51807, 51819, 51821, 51824, 51830, 51832, 51837, 51840, 51842, 51844, 51846, 51848, 51850, 51853, 51855, 51860, 51863, 51865, 51868, 51872, 51876, 51878, 51884, 51886, 51897, 51913, 51926, 51937, 51942, 51954, 51963, 51966, 51982, 52119, 52131, 52133, 52141, 52157, 52167, 52187, 52211, 52213, 52215, 52220, 52224, 52226, 52233, 52238, 52240, 52244, 52254, 52261, 52266, 52281, 52290, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52370, 52376, 52388, 52390, 52395, 52397, 52412, 52422, 52438, 52448, 52455, 52460, 52465, 52467, 52470, 52477, 52480, 52482, 52491, 52494, 52498, 52500, 52508, 52510, 52515) 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 Hay Mary Queen Of Scots

Afterpiece Title: No Song No Supper

Cast
Role: William Actor: Sedgwick

Performances

Mainpiece Title: At King's The Pirates

Cast
Role: Don Guillermo Actor: Sedgwick

Afterpiece Title: The Cheats of Scapin

Performances

Mainpiece Title: At Hay King John

Afterpiece Title: No Song No Supper

Cast
Role: William Actor: Sedgwick

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Cast
Role: Arm ye brave Actor: Sedgwick

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: At King's The School For Scandal

Afterpiece Title: The Prisoner

Cast
Role: Pasqual Actor: Sedgwick

Song: As17921030

Performances

Mainpiece Title: At Hay The Gamester

Afterpiece Title: No Song No Supper

Cast
Role: William Actor: Sedgwick

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

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

Cast
Role: Charles Actor: Sedgwick

Afterpiece Title: The Deuce is in Him

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: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: At King's As You Like It

Afterpiece Title: The Prisoner

Cast
Role: Pasqual Actor: Sedgwick

Song: V: a song-Mrs Bland

Performances

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

Afterpiece Title: Ozmyn and Daraxa

Cast
Role: Ferdinand Actor: Sedgwick

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

Cast
Role: Ferdinand Actor: Sedgwick

Dance: As17930307

Performances

Mainpiece Title: At King's The Pirates

Cast
Role: Don Guillermo Actor: Sedgwick

Afterpiece Title: The Prize; or, 2

Performances

Mainpiece Title: At Hay The Jealous Wife

Afterpiece Title: Ozmyn and Daraxa

Cast
Role: Ferdinand Actor: Sedgwick

Dance: As17930307

Performances

Mainpiece Title: Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: At King's The Confederacy

Afterpiece Title: Ozmyn and Daraxa

Cast
Role: Ferdinand Actor: Sedgwick

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: Pasqual Actor: Sedgwick

Performances

Mainpiece Title: The Messiah

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

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 King's The Siege Of Belgrade

Cast
Role: Anselm Actor: Sedgwick

Afterpiece Title: The Sultan

Performances

Mainpiece Title: At King's False Colours

Afterpiece Title: The Prisoner

Cast
Role: Pasqual Actor: Sedgwick

Performances

Mainpiece Title: At King's The Pirates

Cast
Role: Don Guillermo Actor: Sedgwick

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