SELECT * FROM london_stages WHERE eventid IN (22116, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24580, 24641, 24692, 27112, 27114, 27677, 27680, 27732, 27913, 27932, 27945, 27981, 28016, 28035, 28430, 28440, 28443, 28453, 28616, 28635, 28638, 28733, 28779, 28898, 28901, 28902, 28905, 28908, 28910, 28914, 28915, 28918, 28919, 28922, 28926, 28930, 28942, 28964, 29036, 29205, 29442, 29542, 29598, 29677, 29747, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29923, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30145, 30151, 30385, 30388, 30390, 30395, 30413, 30415, 30429, 30432, 30452, 30475, 30479, 30559, 30603, 30606, 30608, 30622, 30627, 30648, 30653, 30684, 30692, 31104, 31114, 31120, 31123, 31126, 31131, 31133, 31139, 31194, 31206, 31208, 31214, 31229, 31255, 31292, 31677, 31749, 31758, 31932, 32111, 32574, 32683, 32698, 32866, 32951, 33110, 33267, 33271, 33362, 33364, 33369, 33372, 33374, 33381, 33386, 33390, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33485, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33572, 33589, 33592, 33626, 33700, 33806, 33841, 33889, 34010, 34050, 34058, 34063, 34069, 34072, 34078, 34146, 34182, 34197, 34202, 34237, 34342, 34350, 34580, 34770, 34899, 34903, 34909, 34919, 34963, 35017, 35076, 35099, 35227, 35500, 35566, 35573, 35577, 35581, 35585, 35587, 35595, 35600, 35603, 35629, 35635, 35642, 35683, 35756, 35818, 35823, 35826, 35834, 35865, 35874, 35949, 36445, 36488, 36511, 36521, 36645, 36647, 36667, 36669, 36673, 36682, 36700, 36706, 36708, 36710, 36714, 36719, 36733, 36747, 36756, 36773, 36778, 36802, 36858, 36906, 36963, 37021, 37025, 37041, 37044, 37055, 37066, 37071, 37076, 37091, 37101, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37272, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37439, 37460, 37467, 37479, 37517, 37646, 38592, 38602, 38607, 38623, 38633, 38648, 38672, 39116, 39126, 40300, 40314, 40333, 40343, 40348, 46517, 46527, 46541, 46555, 46569, 46583, 47702, 47732) 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: Alexander's Feast

Afterpiece Title: The Coronation Anthems

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-Linley Jun

Performances

Mainpiece Title: The Messiah; Alexander's Feast

Music: As17770214

Performances

Mainpiece Title: The Messiah

Song: End Part I: an Italian duet see17790310by Vinci Tu vuoi ch'io vivi o cara-Mrs Barthelemon, Miss Cecilia Barthelemon

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

Performances

Mainpiece Title: The Messiah

Song: End Part I: duet by Vinci, Tu vuoi ch'io vivi o cara, as17790303

Performances

Mainpiece Title: Acis And Galatea; Messiah

Afterpiece Title: Victory

Music: End I Oratorio: concerto on the trumpet-Serjeant; End Oratorio: concerto on the violin, as17790303

Performances

Mainpiece Title: Omnipotence; Messiah

Music: End Part I: concerto on the hautboy-Sharp; End Part II: concerto on the violin, as17790303

Performances

Mainpiece Title: The Messiah

Music: End of Part I: concerto on the trumpet, as17790319End of Part II: concerto on the violin, as17790303

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

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

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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

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: As17900219

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Alegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso

Afterpiece Title: Grand Miscellaneous Act

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Honour and arms Actor: Champness