The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (47112, 47122, 47126, 47137, 47142, 47154, 47159, 47171, 47177, 47190, 47196, 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, 48255, 48259, 48269, 48273, 48283, 48287, 48297, 48301, 48898, 48907, 48908, 48911, 48912, 48921, 48922, 48925, 48926, 48936, 48937, 48940, 48941, 48950, 48951, 48954, 48964, 48966, 48968, 48970, 49029, 49446, 49459, 49469, 49473, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51684) 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

Music: End of Part I Giardini's Sixth Concerto on the Violin by G. Ashley

Performances

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

Music: End of Part II concerto on the organ by C. Wesley (1st appearance in public)

Performances

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

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Music: As17940319athi

Performances

Mainpiece Title: A Grand Selection

Afterpiece Title: ACIS AND GALATEA

Music: End of Part I of oratorio concerto on violin by Giornovichi

Performances

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

Music: End of Part II concerto on the organ by J. Ashley

Performances

Music: End of Part II Eighth concerto of Corelli

Performances

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

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Music: End of Part II 1st concerto, Op. 3, composed by Geminiani, by G. Ashley

Performances

Mainpiece Title: A Grand Selec Tion Of Music From The Most Eminent Masters

Afterpiece Title: THE GRAND TE DEUM, composed by Paisiello, upon the return of his Majesty the King of the Two Sicilies, from Vienna to Naples, in the summer of 1791

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Zadock the Priest Actor: Chorus
Role: The Dettingen te Deum Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Cast
Role: The trumpet's loud clangour Actor:

Music: End Part II: 3rd concerto of Giardini on the violin-G. Ashley

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

Afterpiece Title: Grand Selection 3

Music: In Part II: 1st concerto [of Geminiani]-G. Ashley

Performances

Mainpiece Title: The Messiah

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