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

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: Twelfth Night

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: Better Late Than Never

Afterpiece Title: The Fairy Favour

Cast
Role: Scaramouch Actor: Harris

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Total Eclipse Actor: Harrison

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: The Messiah; Grandselection 0

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

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

Afterpiece Title: Grand Selection 2

Cast
Role: Gentle Airs Actor: Harrison

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

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

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17910330

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Fairy Favour

Cast
Role: Pantaloon Actor: Harris

Performances

Mainpiece Title: The First Act Of Alexander's Feast; Grand Selection 0

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

Performances

Mainpiece Title: The Heiress

Afterpiece Title: Don Juan; or, The Libertine Destroyed

Song: II: a song-Mrs Crouch. [This was sung, as here assigned, in all subsequent performances.