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 (2274, 20307, 20311, 20317, 20326, 20441, 20468, 20549, 20613, 20775, 21107, 21311, 25164, 25170, 25182, 25195, 31120, 31123, 31126, 31131, 31133, 31139, 31194, 31208, 31214, 31229, 31255, 31337, 31340, 31342, 31358, 31376, 31424, 31482, 31486, 31602, 31651, 31694, 31708, 31728, 31736, 31742, 31763, 32689, 33941, 34046, 34138, 34203, 34228, 34243, 38474, 38566, 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, 43444, 43449, 43451, 43455, 43476, 43482, 43506, 43512, 43525, 43533, 43555, 43568, 43577, 43659, 43668, 43689, 43707, 43732, 43764, 43770, 43783, 43784, 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, 44558, 44559, 44561, 44564, 44565, 44567, 44573, 44579, 44580, 44582, 44586, 44645, 44668, 44696, 44820, 44825, 44857, 44858, 44887, 44927, 44949, 44966, 45032, 45044, 45067, 45070, 45075, 45102, 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, 47573, 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, 51855, 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 Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Atkins

Song: 1st piece: General Chorus, as17970815, but _Dibble, _Kenrick, _Caulfield Jun., Mrs _Gaudry, Mrs _Brown

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Atkins

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Poor Soldier

Cast
Role: Rosina Actor: Mrs Atkins

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Heir at Law

Afterpiece Title: The Purse

Cast
Role: Rosina Actor: Miss DeCamp.

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Italian Monk

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Atkins

Song: As17970816

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: The Guardian

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: The Heir At Law

Cast
Role: Rosina Actor: Miss Andrews.

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Peeping Tom

Song: End II: The Nightingale-Mrs Atkins; End: The Flowing can-Mrs Harlowe; End 2nd piece: Sweet Echo, as17970904

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: Il Consiglio Imprudente

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: As17980331

Performances

Mainpiece Title: Il Consiglio Imprudente

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: As17980313

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End 1st piece: Peggy's Love, as17980428; End 2nd piece: La Vengeance de l'Amour, as17980324

Performances

Mainpiece Title: An Act Of Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End: Les Rivaux Genereux, as17980306End 2nd piece: Elisa- [see17980510]

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: As17980501

Performances

Mainpiece Title: He's Much To Blame

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: A Young Lady

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss DeCamp.

Afterpiece Title: The Honest Thieves

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Spanish Barber

Cast
Role: Rosina Actor: Miss DeCamp.

Afterpiece Title: The Children in the Wood

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Cast
Role: Rosina Actor: Sga Pastorelli.

Dance: End 1st piece: Peggy's Love, as17980428; End 2nd piece: Ariadne et Bacchus, as17971216

Performances

Mainpiece Title: The Purse

Afterpiece Title: The Merchant of Venice

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Miss Griffiths

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Atkins

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Atkins

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Rosina

Cast
Role: Rosina Actor: Mrs Atkins