SELECT * FROM london_stages WHERE eventid IN (30726, 30729, 30733, 30745, 30746, 30748, 30752, 30757, 31310, 31311, 31312, 31313, 31314, 31315, 31316, 31317, 31319, 31320, 31322, 31323, 31324, 31332, 31341, 31343, 31349, 31355, 31367, 31373, 31375, 31385, 31390, 31416, 31418, 31423, 31427, 31433, 31436, 31440, 31442, 31454, 31466, 31545, 31554, 31568, 31586, 31624, 31627, 31649, 31655, 31665, 31692, 31695, 31709, 31719, 31729, 31732, 31734, 31743, 31748, 31757, 31768, 31769, 31770, 31828, 31830, 31832, 31838, 31840, 31846, 31848, 31852, 31856, 31860, 31872, 31874, 31878, 31886, 31896, 31902, 31912, 31914, 31928, 31933, 31936, 31938, 31940, 31942, 31952, 31964, 31968, 31970, 31978, 31992, 31996, 32013, 32015, 32018, 32020, 32033, 32042, 32064, 32072, 32075, 32091, 32093, 32098, 32127, 32132, 32149, 32159, 32161, 32172, 32178, 32182, 32185, 32212, 32220, 32225, 32236, 32239, 32261, 32326, 32328, 32330, 32337, 32340, 32343, 32381, 32396, 32398, 32404, 32406, 32408, 32412, 32426, 32436, 32438, 32505, 32519, 32620, 32624, 32630, 32632, 32661, 32672, 32675, 33100, 33335, 33347, 33375, 33384, 33393, 33436, 33442, 33458, 33461, 33463, 33468, 33472, 33535, 33553, 33555, 33564, 33581, 33694, 43408, 43413, 43416, 43418, 49446, 49459, 49482, 49486, 49497, 49501, 49511, 49515, 49999, 50059, 50621, 50633, 50642, 50645, 50654, 50657, 50666, 50669, 50678, 50682, 50930, 50931, 50933, 50935, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51684, 51703, 51709, 51711, 51720, 51723, 51749, 51752, 51754, 51757, 51764, 51766, 51770, 51772, 51773, 51776, 51778, 51781, 51783, 51787, 51791, 51807, 51824, 52040, 52043, 52084, 52086, 52088, 52091, 52092, 52095, 52103, 52105, 52111, 52115, 52117, 52125, 52127, 52143, 52149, 52153, 52163, 52171, 52175, 52201, 52203, 52211, 52213, 52215, 52220, 52224, 52226, 52233, 52238, 52240, 52244, 52254, 52261, 52266, 52281, 52324, 52333, 52334, 52340, 52342, 52346, 52348, 52349, 52352, 52354, 52357, 52358, 52360, 52364, 52369, 52370, 52376, 52381, 52384, 52388, 52390, 52395, 52397, 52448, 52455, 52467, 52480, 52482, 52519) 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; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Happy Iphis Actor: Master Elliot

Afterpiece Title: Grand Selection 3

Music: End Part II: violin concerto by Giardini-G. Ashley

Performances

Mainpiece Title: A Grand Selection 0of Sacred Music From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast Or, the Power Of Music; Grand Selection 0

Afterpiece Title: Alexander's Feast 3

Music: End Part I: concerto on the harp-Mme Delaval; Beginning Part II: concerto for two violins and violoncello obligato-, as originally composed for this Ode, by Handel and performed in the year 1736; End Part II: concerto on the Grand Piano Forte-Dussek

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Happy Iphis Actor: Master Elliot

Afterpiece Title: Grand Selection 3

Music: End Part I: concerto on the Piano Forte-Miss M'Arthur; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: The Messiah 0

Music: End I: concerto on the violoncello-C. Ashley

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Afterpiece Title: A Grand Sacred Selection 3

Music: End I: concerto on pedal harp-Miss Dupree (1st appearance in public)

Performances

Mainpiece Title: Alexander's Feast 0; Or, the Power Of Music Messiah 0

Afterpiece Title: Alexander's Feast 3

Music: Preceding II: concerto for two violins and violoncello obligato- , as originally composed for this Ode by Handel, and performed under his Direction in the year 1736; End II: concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: L'Allegro ed Il Penseroso 3

Music: End I: concerto on the Grand Piano Forte-Miss MacArthur; End II: concerto on the clarionet-John Mahon

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: End I: concerto on the oboe-W. Parke; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: Acis And Galatea 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: Acis and Galatea 3

Music: End I: Handel's 4th concerto on the organ-J. Ashley; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: As17970315

Performances

Mainpiece Title: The Messiah 0

Music: End II: concerto on the Piano Forte-Miss MacArthur; Preceding III: Eighth concerto of Corelli-

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Afterpiece Title: A Grand Sacred Selection 3

Music: End II: concerto on Piano Forte-Miss MacArthur

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Chimney Corner

Cast
Role: Henry Actor: Master Elliot

Song: In V: song-Mrs Bland

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Chimney Corner

Cast
Role: Henry Actor: Master Elliot

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Chimney Corner

Cast
Role: Henry Actor: Master Elliot

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Chimney Corner

Cast
Role: Henry Actor: Master Elliot

Performances

Music: End I: concerto on the violin-Master Pinto (aged Eleven Years, Grandson to the celebrated Performer of that Name [ThomasPinto])

Performances

Mainpiece Title: L'allegro [ed] Il Pensieroso 0; Messiah

Afterpiece Title: L'Allegro Il Pensieroso 3

Performances

Mainpiece Title: Acis And Galatea 0

Afterpiece Title: Acis and Galatea 3 [i

Music: End I: serenata concerto on violin-G. Ashley; End II: a new concerto, with a military rondo, on the Grand Piano Forte-Dussek

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: concerto on violin-Master Pinto; End II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: concerto on the violoncello-C. Ashley; End II: concerto= on the Piano Forte-Dussek

Performances

Mainpiece Title: Judas Maccabaeus; Messiah

Music: End I: 1st concerto of Geminiani; Geminiani, Op. 3,-G. Ashley; End II: concerto on the Piano Forte-Dussek

Performances

Music: As17980309