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 Messiah; Grand Selection 0

Afterpiece Title: The Coronation Anthem

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: End II: Mad Bess-Mrs Crouch (Purcell)

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

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

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Music: End II oratorio: concerto on the violin-Mme Gautherot

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220

Performances

Mainpiece Title: A Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Leete

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption; Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Leete

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Song: End oratorio: Captivity [see17930220]-Incledon

Music: End Part II: the favourite concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: L'allegro Ed Il Penseroso [, Part I Only]; Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Leete

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

Mainpiece Title: A Grand Selection 0 Of Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: In Part III: Captivity-Mrs Crouch [, as17930220

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

Performances

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

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah , Part I; Grand Selection 0

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Song: End 2nd piece: Ye spotted Snakes-(Stevens)

Performances

Music: End Part II: concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: The Messiah

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Performances

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: a trio for violin viola and violoncello-G. and R. and C. Ashley

Performances

Mainpiece Title: Judas Maccabaeus [part I Only

Cast
Role: Principal Vocal Parts Actor:

Afterpiece Title: Favourite Selections from Samson

Afterpiece Title: The Messiah

Song: In 3rd piece: He was eyes unto the blind-Harrison [Siroe]; after violin concerto: The Woody Vale (composed by Miss Poole)-Master Welsh

Music: End 1st piece: a new concerto on the hautboy (composed by W. Parke)-W. Parke; End 2nd piece: a new concerto on the violin-Alday

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: Sixth concerto of Geminiani on the violin-G. Ashley