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 (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: Grand Selection 0 Of Scared Music, From The Works Of handel

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:

Music: End II: the favourite Military Concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0 Of Music, From The Works Of handel, boyce And purcell

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17990306

Performances

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

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: As17990215

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Occasional Overture Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Overture and Dead March Actor:

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the grand piano@forte-Master Neate

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Overture Actor:

Music: End II: concerto on the violoncello-Charles Ashley

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Part I Overture Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Part III Overture and March Actor:

Music: End I: sonata on the Grand Piano Forte-Miss Reinagle (1st appearance in public); with accompaniment for flute and violoncello obligata-Woidner, C. Ashley; End II: concerto on violin-G. Ashley

Performances

Mainpiece Title: Acis And Galatea 0; Grand Selection 0

Afterpiece Title: Acis and Galatea 3

Cast
Role: Overture and Dead March Actor:

Music: End I: a Military Concerto on the new Patent Grand Piano Forte-Mrs Dussek built by Corri and Dussek; with tambourine-; triangle-; End II: concerto on the oboe-W. Parke