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 (37851, 37899, 37913, 37927, 37953, 37966, 37979, 37984, 37993, 38002, 38007, 38025, 38034, 38049, 38064, 38075, 38090, 38120, 38135, 38150, 38179, 38194, 38209, 38215, 38380, 38389, 38403, 38419, 38433, 38447, 38461, 38487, 38513, 38527, 38542, 38558, 38567, 38577, 38582, 38595, 38605, 38610, 38621, 38626, 38636, 38655, 38670, 38672, 38686, 38702, 38718, 38723, 38733, 38747, 38752, 38757, 38761, 38773, 38792, 38799, 38806, 38811, 38815, 38923, 38936, 38950, 38964, 39005, 39010, 39019, 39071, 39080, 39092, 39106, 39120, 39148, 39162, 39174, 39180, 39192, 39198, 39215, 39233, 39249, 39267, 39284, 39300, 39328, 39340, 39350, 39364, 39382, 41587, 41591, 41599, 41602, 41608, 43177, 43187, 43196, 43209, 43235, 43240, 43251, 43261, 43291, 43311, 43334) 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: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: As17840318hroughout

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: End of Act I Ballet, as17840318but omitted: the two Miss Simonets; End of Act II Dance, as17840318End of Opera Divertissement by all the principal Dancers

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: End of Act I Ballet, as17840420; End of Act II Dance, as17840318End of Opera Le Cocq du Village, as17840302athi

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: As17840422 throughout

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: End of Act I Ballet, as17840420; End of Act II Dance, as17840318End of Opera Divertissement, as17840415

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: End of Act I Ballet, as17840420; End of Act II Dance, as17840318End of Opera New Divertissement, as17840424

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: End of Act I Ballet, as17840420; End of Act II Dance, as17840318End of Opera Le Deserteur, as17840520

Performances

Mainpiece Title: La Regina Di Golconda

Cast
Role: Alberto Actor: Rauzzini

Dance: End of Act I Ballet, as17840420; End of Act II Dana, as17840318End of Opera Le Deserteur, as17840520, but omitted: Pas de Basque