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 (33128, 33371, 33385, 33399, 33408, 33413, 33427, 33432, 33445, 33450, 33464, 33478, 33493, 33500, 33505, 33519, 34124, 35237, 35252, 35266, 35350, 35706, 35720, 35735, 35765, 35768, 35773, 35780, 35804, 35820, 36361, 36454, 36484, 36877, 38366, 38375, 38380, 38389, 38398, 38403, 38409, 38419, 38424, 38433, 38438, 38447, 38452, 38461, 38466, 38475, 38487, 38504, 38513, 38518, 38527, 38532, 38542, 38558, 38567, 38582, 38595, 38605, 38610, 38621, 38626, 38636, 38655, 38665, 38670, 38677, 38686, 38691, 38702, 38718, 38723, 38733, 38747, 38752, 38757, 38761, 38773, 38782, 38792, 38799, 38806, 38808, 38811, 38815, 38923, 38927, 38936, 38941, 38950, 38955, 38964, 38969, 38978, 38992, 38997, 39005, 39010, 39019, 39040, 39053, 39064, 39071, 39080, 39085, 39092, 39097, 39106, 39112, 39120, 39125, 39134, 39139, 39148, 39153, 39162, 39168, 39174, 39180, 39186, 39192, 39198, 39204, 39215, 39221, 39227, 39233, 39238, 39244, 39249, 39256, 39267, 39272, 39279, 39284, 39290, 39295, 39300, 39311, 39328, 39340, 39350, 39358, 39364, 39382) 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: Concert

Cast
Role: Songs Actor: Sga Visconti, Savoi
Role: Songs Actor: Sga Visconti, Elisi, Savoi, Sga Scotti

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Dance: Ballet Master-Sodi; Dancers-Adriani, Slingsby, Signora Radicati, Signora Santoli, Hamoir, Mlle Hamoir

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola Maritata

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: La Buona Figliuola

Cast
Role: Amidoro Actor: Savoi

Performances

Mainpiece Title: Sesostri

Cast
Role: Fanetes Actor: Savoi

Performances

Mainpiece Title: Gioas Re Di Giuda

Song: I: A Song-Guadagni, accompanied on the French Horn-Rodolfe

Music: I: Concerto on Violin-LaHaussage; II: A Sonata on the Violincello-Duport

Performances

Mainpiece Title: Gioas Re Di Giuda

Music: End Act I: Concerto on Violin-LaHaussage; In Act I: Sonata on Violincello-Dupart

Song: II: Song-Sga Guglielmi, accompanied by Dupart

Performances

Mainpiece Title: Gioas Re Di Giuda

Song: As17700329

Music: As17700329

Performances

Mainpiece Title: Il Disertore

Cast
Role: Beltramino Actor: Savoi

Performances

Mainpiece Title: Gioas Re Di Giuda

Music: I: Solo on Violincello-Duport; II, after the Duetto: A Concerto on the Violin-the celebratedMrs Lombardini Sirmen

Song: II: Song-Sga Guglielmi, accompanied by Duport

Performances

Mainpiece Title: Gioas Re Di Giuda

Music: As17710110

Song: As17710110

Performances

Mainpiece Title: Gioas Re Di Giuda

Music: As17710110

Performances

Mainpiece Title: A Concert Of Vocal And Instrumental Music

Cast
Role: Songs Actor: Sga Grassi, Savoi, Sga Guglielmi