SELECT * FROM london_stages WHERE eventid IN (22745, 29426, 36617, 36912, 36918, 36924, 36926, 36928, 36931, 36934, 36937, 36940, 36942, 36945, 36948, 36950, 36953, 36961, 36983, 36994, 37000, 38592, 38602, 38607, 38623, 38633, 38648, 38989, 38994, 38996, 38999, 39001, 39007, 39050, 39061, 39075, 39087, 39103, 39116, 39117, 39126, 39127, 39130, 39131, 39140, 39141, 39144, 39145, 39154, 39155, 39158, 39159, 39169, 39170, 39175, 39176, 39187, 39188, 39193, 39194, 39214, 39258, 39299, 39559, 39628, 39738, 39739, 39748, 39749, 39752, 39753, 39762, 39763, 39767, 39768, 39779, 39780, 39784, 39785, 39795, 39796, 39800, 39801, 39810, 39811, 39816, 39817, 40053, 40097, 40277, 40287, 40290, 40299, 40300, 40303, 40313, 40314, 40315, 40318, 40319, 40328, 40330, 40332, 40333, 40334, 40342, 40343, 40344, 40347, 40348, 40363, 40378, 40383, 40386, 40390, 40395, 40397, 40417, 40424, 40432, 40435, 40447, 40453, 40458, 40460, 40466, 40687, 40802, 40811, 40814, 40823, 40826, 40836, 40840, 40850, 40854, 40862, 40864, 40867, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483, 43750, 44829, 44838, 44842, 44851, 44855, 44865, 44869, 44878, 44882, 44894, 44900, 44906, 44943, 44997, 45019, 45034, 45367, 45376, 45379, 45388, 45392, 45401, 45405, 45414, 45418, 45427, 45431, 45959, 45969, 45972, 45982, 45985, 46012, 46025, 46516, 46526, 46530, 46540, 46544, 46554, 46558, 46568, 46572, 46582, 47111, 47121, 47125, 47136, 47141, 47153, 47158, 47170, 47176, 47189, 47195, 47214, 47701, 47702, 47711, 47716, 47717, 47726, 47727, 47731, 47732, 47741, 47742, 47746, 47747, 47756, 47757, 47761, 47762, 47771, 47772, 47776, 47777, 48230, 48231, 48240, 48241, 48244, 48245, 48254, 48255, 48258, 48259, 48268, 48269, 48272, 48273, 48282, 48283, 48286, 48287, 48296, 48297, 48300, 48301, 49447, 49488, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50602, 50609, 50620, 50626, 50635, 50688, 50690, 50695, 50702, 50707, 50736, 50742, 50744, 50772, 50790, 50802, 50805, 50812, 50940, 50959, 50965, 50971, 51787) 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 Prodigal Son; Redemption 0

Music: End II: concerto on French Horn-Ponto

Performances

Mainpiece Title: Judas Maccabaeus; Redemption 0

Music: As17880307

Song: In Part III: The Soldier tired of War's Alarms-Mme Mara

Performances

Mainpiece Title: The Messiah; Redemption 0

Song: End Part I: a very capital Song-Mme Mara

Music: As17880307

Performances

Mainpiece Title: A Prelude, On The Happy Recovery Of His Majesty

Afterpiece Title: The Triumph of Truth 0

Performances

Mainpiece Title: A Prelude

Afterpiece Title: The Triumph of Truth 0

Music: End oratorio: God save Great George our King!-

Performances

Mainpiece Title: A Prelude

Afterpiece Title: Acis and Galatea; Triumph of Truth 0

Afterpiece Title: A Miscellaneous Concert

Music: End I: serenata solo on harp-Mme Krumpholtz (2nd appearance in this Kingdom)

Performances

Mainpiece Title: A Prelude

Afterpiece Title: Redemption 0; Triumph of Truth 0

Music: End I oratorio: serenata solo on harp, as17890306End II: a new Grand Concerto on the harp-Mme Krumpholtz; Conclude: God save Great George our King-

Performances

Mainpiece Title: The Coronation Anthem, god Save The King

Afterpiece Title: Judas Maccabaeus; Triumph of Truth 0

Music: As17890311

Performances

Mainpiece Title: A Prelude

Afterpiece Title: Acis and Galatea; Triumph of Truth 0

Afterpiece Title: The Monody on the Death of Garrick

Music: As17890311

Performances

Mainpiece Title: Redemption 0 [see 11 Mar

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: The Monody on the Death of Garrick

Music: As17890311

Performances

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

Music: End II: concerto on the violin-Master Bridgtower, Son to the African Prince

Performances

Mainpiece Title: A Grand Selection 0[from The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption, A Sacred Oratorio Selected From The Great And Favourite Works Of handel That Were Performed At His Commemoration, In westminster-abbey And At The pantheon On 26 And 27 May 1784 0; Messiah

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17900219

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Acis And Galatea; Messiah

Afterpiece Title: A Grand Selection

Music: End II oratorio: concerto on the violoncello-Mason

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violin-Weichsel

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

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; Messiah

Afterpiece Title: Acis and Galatea; Messiah

Music: End Ode: As17900219

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Cast
Role: Principal Vocal Parts Actor: Spence

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: Judas Maccabaeus; Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence

Performances

Mainpiece Title: Redemption, Selected From The Great And Favourite Works Of handel That Were Performed In westminster-abbey And At The pantheon [on 26 And 27 May 1784] 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End: concerto on the hautboy-W. Parke; End II: concerto violin-Master Clement

Performances

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

Cast
Role: 910311but Principal Vocal Parts Actor: Kelly, Mrs +Crouch.
Role: Principal Vocal Parts Actor: Spence

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3