SELECT * FROM london_stages WHERE eventid IN (14775, 18662, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18975, 22347, 22754, 24453, 25898, 25904, 25911, 25934, 25947, 27510, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28933, 36090, 36459, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37439, 37460, 37467, 37479, 37517, 37646, 38002, 40329, 40905, 40951, 40956, 40960, 41009, 45392, 45414, 45973, 45995, 45999, 46000, 46009, 46013, 46025, 46026, 46048, 46526, 46527, 46530, 46531, 46540, 46541, 46554, 46555, 46558, 46568, 46569, 46572, 46573, 46582, 46583, 46587, 46588, 47111, 47112, 47121, 47125, 47126, 47136, 47137, 47141, 47142, 47153, 47154, 47158, 47159, 47170, 47171, 47176, 47189, 47190, 47195, 47196, 47205, 47215, 47221, 47701, 47702, 47712, 47717, 47727, 47732, 47741, 47742, 47746, 47747, 47756, 47757, 47761, 47762, 47771, 47776, 47777, 48230, 48231, 48240, 48241, 48244, 48245, 48255, 48268, 48269, 48273, 48282, 48283, 48297, 48301, 48366, 49446, 49459, 49460, 49469, 49473, 49486, 49488, 49511, 49515, 49915, 49917, 49919, 49921, 50021, 50024, 50033, 50036, 50059, 50203, 50633, 50645, 50654, 50669, 50682, 51192, 51204, 51213, 51229, 51239, 51242, 51711, 51723, 51732, 51748, 51757, 51769, 51772, 52324, 52333, 52357, 52360) 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 Christmas Tale

Cast
Role: after which a New Overture Actor:

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: Concert Of Vocal And Instrumental Music

Cast
Role: Overture Actor:

Performances

Mainpiece Title: A Miscellaneous Act

Afterpiece Title: Victory, an Ode Inscribed to Admiral Keppel; Messiah

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: A Fete The Fete Anticipated

Cast
Role: Overture by Dr Arne Actor:

Afterpiece Title: The Flitch Of Bacon

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: A Fete

Cast
Role: Overture by Dr Arne Actor:

Afterpiece Title: The Elders

Song: In: To thee O gentle sleep-Leoni

Performances

Mainpiece Title: The Funeral

Afterpiece Title: A Fete

Cast
Role: Overture by Dr Arne Actor:

Afterpiece Title: The Elders

Cast
Role: Overture by Dr Arne Actor:

Performances

Mainpiece Title: The Duenna

Afterpiece Title: A Fete

Cast
Role: Overture by Dr Arne Actor:

Afterpiece Title: The Elders

Cast
Role: Overture by Dr Arne Actor:

Performances

Mainpiece Title: Orfeo

Cast
Role: Overture Actor:

Performances

Mainpiece Title: Acis And Galatea 0; Redemption 0

Afterpiece Title: Acis and Galatea 3 [i

Cast
Role: Overture to Samson Actor:

Performances

Mainpiece Title: Acis And Galatea 0; Redemption 0

Afterpiece Title: Acis and Galatea 3 [i

Cast
Role: Overture to Artaxerxes Actor:

Performances

Mainpiece Title: A Grand Selection 0 [of Sacred Music From The Works Of handel, Chiefly Performed At westminster-abbey At The handel Commemoration, 26 May 1784]; Messiah

Afterpiece Title: The Coronation Anthem, God save the King

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Overture and Dead March Actor:

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

Performances

Mainpiece Title: Redemption 0; Triumph Of Truth 0

Afterpiece Title: Redemption 1

Cast
Role: Overture Actor:

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17890311

Performances

Mainpiece Title: The Triumph Of Truth 0

Afterpiece Title: Triumph of Truth 1

Cast
Role: New Overture Actor:

Afterpiece Title: Triumph of Truth 2

Afterpiece Title: Triumph of Truth 3

Music: As17890311

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Overture and March Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Overture Actor:

Music: End II: As17890227; End Part I: Concerto by Handel on organ-Greatorex

Performances

Mainpiece Title: A Grand Concerto Spirituale 0

Afterpiece Title: Grand Concerto Spirituale 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Concerto Spirituale 2

Afterpiece Title: Grand Concerto Spirituale 3

Music: As17890311

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:
Role: Overture and Dead March Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: Redemption 0 [see 11 Mar

Afterpiece Title: Redemption 1

Cast
Role: Overture Actor:

Afterpiece Title: Redemption 2

Cast
Role: Overture Actor:

Afterpiece Title: The Monody on the Death of Garrick

Music: As17890311

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A gala Sponsored By brooks's Club, Celebration Of king's Recovery [and See 15, 24 Apr

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Overture and Dead March Actor:

Performances

Mainpiece Title: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

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

Cast
Role: Overture Actor:

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Overture and Dead March Actor:

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:
Role: Overture and Dead March Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Overture Actor:
Role: Overture and Dead March Actor:

Afterpiece Title: Grand Selection 3

Cast
Role: Overture Actor:
Role: Overture and Dead March Actor:

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900224