SELECT * FROM london_stages WHERE eventid IN (117, 136, 147, 157, 166, 194, 197, 234, 270, 274, 282, 301, 303, 321, 367, 394, 403, 415, 420, 432, 435, 450, 501, 517, 560, 577, 619, 662, 679, 699, 702, 718, 734, 771, 858, 869, 886, 894, 898, 904, 935, 942, 946, 964, 975, 992, 996, 1010, 1013, 1022, 1023, 1030, 1037, 1053, 1079, 1129, 1136, 1159, 1160, 1174, 1183, 1203, 1207, 1212, 1213, 1224, 1235, 1236, 1237, 1278, 1288, 1291, 1303, 1318, 1335, 1337, 1341, 1344, 1356, 1366, 1371, 1430, 1567, 1582, 1601, 1622, 1670, 1728, 1732, 1786, 1794, 1814, 1825, 1828, 1919, 1935, 1937, 2004, 2019, 2034, 2048, 2114, 2251, 2290, 2381, 2400, 3145, 4329, 6069, 10388, 10619, 10621, 10624, 10627, 10630, 10633, 10636, 10639, 10642, 10645, 10648, 10651, 10653, 10656, 10659, 10662, 10665, 10668, 10671, 10674, 10677, 10680, 10683, 10686, 10724, 10748, 10753, 10804, 10861, 10958, 10960, 10962, 10995, 11022, 11025, 11027, 11041, 11045, 11233, 11372, 11388, 11488, 11493, 11507, 11511, 11514, 11516, 11518, 11520, 11523, 11819, 11825, 11865, 11974, 11976, 12340, 12343, 12384, 12889, 12912, 12922, 13026, 13044, 13048, 13057, 13062, 13065, 13069, 13072, 13075, 13078, 13082, 13086, 13090, 13093, 13097, 13100, 13104, 13108, 13145, 13155, 13159, 13163, 13166, 13170, 13174, 13177, 13180, 13184, 13188, 13191, 13194, 13197, 13201, 13205, 13209, 13215, 13220, 13224, 13227, 13232, 13237, 13244, 13249, 13255, 13276, 13278, 13284, 13285, 13291, 13293, 13295, 13300, 13302, 13303, 13310, 13317, 13323, 13325, 13334, 13336, 13340, 13342, 13348, 13350, 13375, 13382, 13389, 13394, 13402, 13411, 13435, 13445, 13452, 13470, 13479, 13488, 13613, 13626, 13805, 13816, 13819, 13823, 13827, 13979, 13982, 13987, 13990, 13994, 13998, 14002, 14005, 14009, 14012, 14016, 14019, 14022, 14038, 14044, 14048, 14072, 14083, 14254, 15562, 17323, 17802, 23155, 23339, 24195, 24296, 24300, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24333, 24366, 24372, 24376, 24621, 24625, 24750, 24787, 24825, 24946, 24949, 24950, 24953, 24955, 24958, 24963, 24966, 24968, 24970, 24976, 24998, 25001, 25003, 25006, 25008, 25010, 25012, 25015, 25017, 25020, 25022, 25024, 25026, 25029, 25031, 25035, 25040, 25047, 25049, 25057, 25059, 25072, 25086, 25094, 25123, 25128, 25134, 25148, 25192, 25206, 25213, 25227, 25286, 25418, 25425, 25893, 25896, 25899, 25902, 25905, 25907, 25909, 25959, 25961, 25982, 26067, 27677, 27728, 27732, 27737, 28016, 28059, 28128, 28134, 28136, 31792, 31793, 34138, 34174, 34262, 34343, 34364, 34373, 34382, 34392, 34424, 34502, 34519, 34584, 34697, 34805, 34906, 34948, 35065, 35121, 35336, 35499, 35552, 35682, 35935, 35950, 35990, 36132, 36207, 36247, 36337, 36493, 36514, 36644, 36666, 36668, 36670, 36679, 36683, 36685, 36689, 36691, 36695, 36697, 36699, 36711, 36713, 36718, 36727, 36753, 36776, 36781, 36803, 36840, 36958, 36981, 37047, 37095, 37099, 37108, 37246, 37250, 37252, 37263, 37267, 37269, 37273, 37275, 37277, 37279, 37291, 37302, 37392, 37394, 37397, 37399, 37403, 37406, 37408, 37413, 37417, 37420, 37423, 37425, 37427, 37429, 37431, 37437, 37534, 37578, 37588, 37595, 37600, 37603, 37612, 37614, 37617, 37619, 37624, 37636, 37638, 37644, 37647, 37649, 37652, 37666, 37676, 37782, 37816, 37818, 37820, 37822, 37826, 37836, 37846, 37859, 37867, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37934, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38015, 38027, 38046, 38063, 38071, 38094, 38119, 38251, 38340, 38348, 38730, 38735, 38740, 38749, 38751, 38754, 38762, 38772, 38779, 38786, 38791, 38858, 39310, 39334, 39338, 39342, 39348, 39368, 39385, 39392, 39393, 39395, 39396, 39401, 39418, 39422, 39429, 39432, 39796, 40324, 40411, 40435, 40965, 40970, 40974, 40980, 41333, 41459, 41557, 42035, 42124, 42440, 43152, 43156, 43170, 43239, 43480, 43682, 43966, 43973, 43978, 45960, 45973, 46000, 46013, 46026, 46334, 46517, 46527, 46531, 46541, 46555, 46569, 46573, 46583, 46588, 46972, 46974, 46976, 46978, 46980, 46984, 46986, 46990, 47008, 47012, 47014, 47018, 47020, 47024, 47026, 47032, 47044, 47052, 47070, 47075, 47087, 47112, 47116, 47122, 47126, 47130, 47137, 47142, 47154, 47159, 47171, 47177, 47182, 47190, 47196, 47498, 47504, 47532, 47544, 47576, 47588, 47702, 47712, 47717, 47727, 47732, 47742, 47747, 47757, 47762, 47777, 48081, 48083, 48085, 48087, 48089, 48092, 48094, 48096, 48098, 48100, 48102, 48112, 48122, 48136, 48145, 48149, 48153, 48157, 48169, 48173, 48181, 48185, 48208, 48222, 48230, 48240, 48244, 48254, 48268, 48272, 48277, 48282, 48286, 48296, 48319, 48340, 48401, 48415, 48429, 48763, 48765, 48773, 48907, 48911, 48921, 48925, 48936, 48940, 48950, 48954, 48964, 48966, 48968, 48970, 49029, 49030, 49045, 49060, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49384, 49417, 49424, 49431, 49433, 49444, 49447, 49460, 49488) 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: A Grand Selection 0 [of Sacred Music From The Works Of handel, Chiefly Performed At westminster-abbey At The handel Commemoration, 26 May 1784]; Messiah

Afterpiece Title: The Coronation Anthem, God save the King

Afterpiece Title: Grand Selection 1

Cast
Role: Total Eclipse Actor: Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Glory to God Actor: Harrison, Chorus

Music: End II: concerto on the violin-Mme Gautherot

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17890227; End Part I: Concerto by Handel on organ-Greatorex

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: How vain is Man Actor: Harrison

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Cast
Role: Then when the Sun Actor: Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Planters Actor: Randall, Harris

Afterpiece Title: Chrononhotonthologos

Cast
Role: Cook Actor: Harris

Entertainment: Monologue. End: the tale of Edwin and Emma-Jones

Performances

Mainpiece Title: The Messiah, Preceded By god Save The King(coronation Anthems)

Music: End II: a concerto on the violin-Mme Gautherot (from Paris)

Performances

Mainpiece Title: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Total Eclipse Actor: Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Actor: Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Oft on a Plat Actor: Harrison

Music: As17900224

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Cast
Role: Softly rise Actor: Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900219; End I: Miserere Mei Deus-, composed by Sg Gregorio Allegri, in the Year 1650, from an authentic Copy brought from Italy by Greatorex. A Translation of this Work (the 51st Psalm in English) will be printed in the Books of the Night

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17900224; End Part I: Miserere Mei Deus, as17900317

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Cast
Role: Every valley Actor: Harrison

Music: As17900219

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Fairy Favour; or, Harlequin Animated

Cast
Role: Scaramouch Actor: Harris

Dance: Afterpiece conclude: Dance of Fairies and Pantomimic Characters-Hamoir, the young D'Egvilles, Miss Blanchet, Miss DeCamp. [This was danced, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: Better Late Than Never

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: Better Late Than Never

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: Better Late Than Never

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris