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 (38923, 38936, 38950, 38964, 39328, 39340, 39350, 39364, 39650, 39665, 39677, 39692, 39706, 39720, 39815, 39839, 40110, 40119, 40124, 40133, 40138, 40147, 40152, 40161, 40166, 40171, 40177, 40186, 40191, 40200, 40206, 40215, 40220, 40229, 40241, 40246, 40255, 40260, 40268, 40273, 40280, 40286, 40293, 40298, 40306, 40312, 40317, 40321, 40327, 40336, 40346, 40351, 40356, 40365, 40370, 40375, 40380, 40385, 40394, 40399, 40404, 40409, 40414, 40423, 40429, 40434, 40439, 40442, 40451, 40456, 40461, 40464, 40468, 40470, 40475, 40477, 40482, 40485, 40490, 40493, 40656, 40661, 40670, 40675, 40684, 40689, 40698, 40704, 40709, 40715, 40724, 40739, 40744, 40753, 40768, 40773, 40782, 40785, 40793, 40798, 40805, 40810, 40817, 40822, 40829, 40835, 40843, 40849, 40853, 40857, 40863, 40871, 40878, 40887, 40892, 40903, 40908, 40913, 40918, 40923, 40929, 40934, 40939, 40944, 40949, 40954, 40963, 40968, 40975, 40981, 40990, 40995, 41000, 41007, 41009, 41013, 41016, 41021, 41024, 41029, 41032, 41037, 41046) 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: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124, but _Banti, LeDet; End II: +Les Moissonneurs, as17781222, but Sg and Sga _Zuchelli; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise, as17781124; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Ballet: Annette et Lubin. As17781128

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Dance: End I: new Ballet, Les Oiseleurs-Sg Zuchelli, Sga Zuchelli, Mlle Vidini, LeDet; End II: Les Moissonneurs, as17781229; End: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Dance: End I: Les Oiseleurs, as17790123, but Sga _Zuchelli, Sga Tinti; End II: +Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: La Fraschetana

Dance: End I: La Noche Hollandoise-, as17781229, but Sga _Zuchelli; End II: Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Dance: End I: Les Oiseleurs, as17790129; End Opera: Les Nymphes de Diane, as17781124

Ballet: End II: Annette et Lubin. As17781124, but unassigned-Sga _Zuchelli

Cast
Role: unassigned Actor: Sga _Zuchelli.

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17781128

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Performances

Mainpiece Title: Artaserse

Cast
Role: Semira Actor: Sga Pozzi
Role: Mandane Actor: Sga Bernasconi.

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Fatima Actor: Sga Jermoli
Role: Lesbia Actor: Sga Clara Pollone
Role: Zemira Actor: Sga Pozzi.

Dance: II: Ballet connected with the Opera, by Genii of the various Arts- (See17790302 Pedal Harp-Hochbrucher; End II: new Ballet by Fairies of the Court of Azore,-Banti, Sga Tinti, LeDet, Henry, young Miss Simonet, Mlle Baccelli (1st appearance this season); End Opera: new serious Ballet, Le Couronnement de Zemire-Mons and Mme Simonet, Banti, Sg and Sga Zuchelli, Sga Tinti, Slingsby

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Dance: End I: Les Oiseleurs, as17790129; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17791128, but Mlle Baccelli

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Fatima Actor: Sga Jermoli
Role: Lesbia Actor: Sga Clara Pollone
Role: Zemira Actor: Sga Pozzi.

Dance: II: Ballet by Genii as17790223-Sg Zuchelli, Sga Zuchelli, young Miss Simonet; also Pedal Harp, as17790223; End II: Ballet by Fairies, as17790223, but _LeDet, _Henry, young Miss _Simonet, Slingsby; End Opera: +Le Couronnement de Zemire, as17790223

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Fatima Actor: Sga Jermoli
Role: Lesbia Actor: Sga Clara Pollone
Role: Zemira Actor: Sga Pozzi.

Dance: As17790302

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Fatima Actor: Sga Jermoli
Role: Lesbia Actor: Sga Clara Pollone
Role: Zemira Actor: Sga Pozzi.

Dance: As17790302

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Dance: End of new song: Les Oiseleurs, as17790123; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17790227

Song: End I: a new song-Pacchierotti; with violin obligato composed by Bertoni-Cramer; In III: an additional song composed by Handel-Pacchierotti

Performances

Mainpiece Title: Demofoonte

Cast
Role: Creusa Actor: Sga Pozzi
Role: Dircea Actor: Sga Bernasconi.

Song: In III: an additional song, as17790311

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Fatima Actor: Sga Jermoli
Role: Lesbia Actor: Sga Clara Pollone
Role: Zemira Actor: Sga Pozzi.

Dance: As17790302

Performances

Mainpiece Title: Zemira E Azore

Cast
Role: Fatima Actor: Sga Jermoli
Role: Lesbia Actor: Sga Clara Pollone
Role: Zemira Actor: Sga Pozzi.

Dance: As17790302