SELECT * FROM london_stages WHERE eventid IN (39427, 39428, 39429, 39431, 39434, 39437, 39441, 39650, 39665, 39677, 39692, 39706, 39720, 39733, 39747, 39761, 39794, 39809, 39815, 39825, 39839, 39927, 39928, 39932, 39934, 39943, 39945, 39950, 39955, 39965, 39967, 39969, 39976, 39983, 39994, 40003, 40007, 40010, 40465, 40473, 40479, 40481, 40487, 40489, 40494, 40502, 40507, 40520, 40526, 40538, 40543, 40551, 41036, 41039, 41074, 41080, 41106, 41579, 41580, 41594, 41603, 41612, 41621, 41640, 41683, 42251, 42257, 42263, 42458, 42461, 42467, 42470, 42477, 42489, 42491, 42494, 42755, 42768, 42773, 42783, 42802, 42808, 42815, 42829, 42847, 42877, 42884, 42891, 42899, 42904, 42963, 42991, 43074, 43106, 43118, 43138, 43148, 43167, 43176, 43183, 43195, 43200, 43222, 43237, 43260, 43277, 43310, 43317, 43318, 43335, 43344, 43364, 43368, 43375, 43383, 43405, 43419, 43428, 43482, 43506, 43512, 43525, 43533, 43555, 43568, 43577, 43659, 43668, 43689, 43707, 43732, 43764, 43770, 43783, 43794, 43811, 43823, 43855, 43882, 43891, 43910, 43935, 43954, 43985, 43988, 43991, 44013, 44029, 44048, 44087, 44127, 44290, 44341, 44399, 44421, 44477, 44480, 44504, 44556, 44559, 44580, 44586, 44645, 44668, 44696, 44820, 44825, 44857, 44858, 44887, 44927, 44949, 44966, 45032, 45044, 45278, 45326, 45347, 45494, 45619, 45631, 45662, 45677, 45722, 45754, 45885, 45993, 46024, 46046, 46074, 46112, 46142, 46164, 46220, 46336, 46373, 46590, 46612, 46622, 46639, 46695, 46719, 46730, 46754, 46767, 46798, 46805, 46811, 46821, 46856, 46879, 47244, 47307, 47323, 47352, 47709, 47719, 47739, 47744, 47764, 47774, 47792, 47845, 47882, 47894, 47918, 48121, 48125, 48320, 48322, 48358, 48366, 48368, 48445, 48462, 48509, 48510, 48514, 48602, 48623, 48832, 48852, 48859, 48866, 48873, 48893, 48903, 48919, 48934, 48943, 48957, 48962, 49069, 49129, 49139, 49143, 49144, 49148, 49149, 49157, 49195, 49240, 49500, 49635, 49768, 49823, 49836, 49840, 49842, 50192, 50195, 50234, 50242, 50248, 50263, 50289, 50350, 50391, 50478, 50485, 50490, 50499, 50504, 50625, 50631, 50637, 50762, 50763, 50777, 50829, 50838, 50840, 50850, 50851, 50854, 50859, 50862, 50864, 50865, 50866, 50869, 50871, 50873, 50874, 50875, 50883, 50884, 50887, 50891, 50897, 50900, 50905, 50906, 50907, 50909, 50910, 51250, 51259, 51296, 51325, 51339, 51370, 51395, 51416, 51417, 51464, 51645, 51650, 51657, 51659, 51681, 51971, 51991, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52044, 52046, 52049, 52050, 52051, 52053, 52057, 52286, 52415, 52427, 52434, 52500, 52510, 52516, 52523, 52568, 52577, 52580, 52594, 52596, 52609, 52615) 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: The Spanish Barber; Or, The Fruitless Precaution

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Thomasand Sally

Dance: End: Dance-. [This was included in all subsequent performances.

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Recruiting Serjeant

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Lilliput

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Waterman

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Les Bohemiens, as17771216; End II: Serious Ballet, as17771209, but Mme _Simonet; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Les Bohemiens, as17771216; End II: Serious Ballet, as17780120; End Opera: La Clochette, as17771115

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Le Devin du Village, as17771104; End II: Serious Ballet, as17780120; End Opera: Les Bohemiens, as17771216

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Serious Ballet, as17780120; End II: Le Devin du Village, as17771104; End Opera: La Polonaise Favourite, as17780131

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: As17780210

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Le Devin du Village, as17771104; End II: Divertisement, as17780207; End Opera: a new Grand Ballet Espagnol, La Serenade Interrompuee-Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet; in which a Pas de Deux du Masque-Simonet, Mlle Baccelli; accompanied on the Guitarre-Noferi

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Rosina Actor: Sga Todi.

Dance: End I: a Masquerade Dance incident to the opera, in which the-; Minuet de la Cour and Gavot-Simonet, Mlle Baccelli; Provencal-Vallouy@le@cadet; Allemande a la Strasbourgoise-Mons and Mlle Banti; End II: Le Devin du Village, as17771104; End Opera: La Serenade Interrompuee, as17780224

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Rosina Actor: Sga Todi.

Dance: End I: Le Devin du Village, as17771104; End II: Masquerade Dance, as17780303but a Minuet-Simonet, Sga Jermoli in place of Minuet de la Cour and Gavot; Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: La Polonaise Favourite, as17780131, but Mlle _Baccelli

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Rosina Actor: Sga Todi.

Dance: End I: Le Devin du Village, as17780303End II: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande al la Strasbourgeiose, as17780303End Opera: La Serenade Interrompuee, as17780303

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Rosina Actor: Sga Todi.

Dance: End II: Masquerade Dance, as17780303Minuet de la Cour and Gavot, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303End Opera: La Serenade Interrompuee, as17780224

Ballet: End I: new Ballet Pastoral (composed by Simonet; the introduction by Banti), La Surprize de Daphnis et Cephise. Pas de Deux-Sg and Sga Zuchelli; Daphnis Banti; Cephise-Mlle Banti

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Rosina Actor: Sga Todi.

Dance: As17780331

Ballet: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: As17780203

Song: II: new song (composed by Sacchini)-Pozzi; accompanied on the flute-Florio; III: Che dirnen so-Jermoli

Performances

Mainpiece Title: L'amore Artigiano

Cast
Role: Rosina Actor: Sga Todi.

Dance: As17780331

Ballet: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: La Vera Costanza

Cast
Role: Rosina Actor: Sga Pozzi.

Dance: End I: Divertisement, as17780207; End II: Les Bohemiens, as17771216; End Opera: Masquerade Dance, as17780303Minuet de la Cour=, as17780303Provencal, as17780303Allemande a la Strasbourgoise, as17780303

Performances

Mainpiece Title: The Spanish Barber; Or, The Fruitless Precaution

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: The Waterman; or, The First of August

Dance: End I: The Merry Lasses, as17780518; End: Provencalle Dance, as17780518

Song: Mainpiece: some additional songs-

Music: Mainpiece: With a new Fandango Overture-

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Dance: End II: The Merry Lasses, as17780518; End afterpiece: Provencalle Dance, as17780518

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Dance: End II: Provencalle Dance, as17780518; End afterpiece: The Merry Lasses, as17780529

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss Farren

Afterpiece Title: Midas

Dance: As17780616