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

Afterpiece Title: The Mayor of Garratt

Dance: As17930408

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The Sultan

Dance: As17930408

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 King's The Pirates

Afterpiece Title: The Humourist

Dance: As17930408

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: The Country Girl

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: The Messiah

Music: End of Part I concerto on the flute by Ashe; End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection

Afterpiece Title: ACIS AND GALATEA

Music: End of Part I of oratorio concerto on violin by Giornovichi

Performances

Mainpiece Title: The Messiah

Music: End of Part I concerto on the oboe by W. Parke; End of Part II concerto on the violin by Giornovichi, in which the favourite air of Lullaby

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: Redemption: A Sacred Oratorio Selected From The Great And Favourite Works Of Handel

Music: As17940409

Performances

Mainpiece Title: A Grand Selection Of Music Chiefly From The Works Of Handel

Music: In Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: The Messiah

Music: As17940328but omitted: Lullaby

Performances

Mainpiece Title: A Grand Selec Tion Of Music From The Most Eminent Masters

Afterpiece Title: THE GRAND TE DEUM, composed by Paisiello, upon the return of his Majesty the King of the Two Sicilies, from Vienna to Naples, in the summer of 1791

Performances

Afterpiece Title: THE ENGLISHMAN IN PARIS

Dance: In mainpiece Dances (composed by D'Egville) by Hamoir, G. D'Egville, Master D'Egville, Miss Menage, Miss Phillips, the Miss D'Egvilles, &c.; In Act II of afterpiece a Minuet by Hamoir and Miss De Camp

Performances

Afterpiece Title: LOVE A-LA-MODE

Performances

Afterpiece Title: KATHARINE AND PETRUCHIO