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: Gretna Green

Afterpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss DeCamp.

Afterpiece Title: The Citizen

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: A Young Lady

Performances

Mainpiece Title: Fortune's Fool

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Second.

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End: Peggy's Love- [see17961206]; End 2nd piece: L'Amour et Psiche- [see17961213]

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End: Peggy's Love-, as17961220

Ballet: End 2nd piece: L'Amour et Psiche. As17961213, but unassigned-Mlle _Parisot

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End: a new Divertisement Ballet, composed by Gallet [with music by Viotti] Apollon Berger- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: As17961227

Ballet: L'Amour et Psiche. As17961227

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End: a new Divertissement- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: Cape St

Song: III: a Masquerade Scene-; with Hark! the Lark at Heaven's Gate sings-Sedgwick, Dignum, Welsh, Master Welsh

Ballet: End: The Labyrinth; or, The Country Madcap. Joseph-Gentili; Robert-Grimaldi; Philip-Master Menage; Rosina-Sga Bossi DelCaro; Countess-Mrs Wild; Lauretta-Miss S. DeCamp

Cast
Role: Rosina Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: Cape St

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Purse

Afterpiece Title: Lodoiska

Ballet: End 2nd piece: The Labyrinth. As17970306

Cast
Role: Rosina Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Lodoiska

Ballet: End: The Labyrinth. As17970306

Cast
Role: Rosina Actor: Sga Bossi DelCaro

Performances

Mainpiece Title: The Village Fete

Afterpiece Title: The School for Wives

Cast
Role: Rosina Actor: A Young Lady

Afterpiece Title: Oscar and Malvina

Song: In: Chorusses, as17970518; End II 2nd piece: The Sea Storm by G. A. Stevens (Cease rude Boreas blust'ring railer)-; End IV: Black Ey'd Susan-Incledon; In 3rd piece: Come every jovial Fellow-Gray, Mrs Martyr, Mrs Mountain; O ever in my bosom live-Mrs Martyr, Mrs Mountain

Entertainment: End 2nd piece: a variety of Imitations-Rees (1st appearance this season [i.e. as imitator])

Performances

Mainpiece Title: Rosina

Cast
Role: Rosina Actor: Miss Leak

Afterpiece Title: A Trip to Scarborough

Afterpiece Title: The Hovel

Song: In: Sweet Echo-Miss Leak; the Echo-Master Welsh

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Oscar and Malvina

Cast
Role: Rosina Actor: A Young Lady

Performances

Mainpiece Title: The Purse; Or, Benevolent Tar

Afterpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss DeCamp.

Afterpiece Title: The Irish Legacy

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss DeCamp.

Afterpiece Title: Bannian Day

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: The Purse

Cast
Role: Rosina Actor: Miss DeCamp.

Song: 2nd piece: Vocal Parts, as17970623

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Surrender of Calais

Afterpiece Title: The Purse

Cast
Role: Rosina Actor: Miss DeCamp.

Song: As17970705

Performances

Mainpiece Title: Rosina

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Heir at Law

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Honest Thieves

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Two Strings to Your Bow

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Dead Alive

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Irishman in London