SELECT * FROM london_stages WHERE eventid IN (49210, 49213, 49218, 49225, 49227, 49230, 49249, 49255, 49261, 49273, 49279, 49285, 49297, 49304, 49311, 49320, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49361, 49363, 49365, 49367, 49370, 49375, 49377, 49379, 49381, 49384, 49389, 49395, 49407, 49417, 49424, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49508, 49512, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49538, 49555, 49611, 49793, 49800, 49806, 49808, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50060, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50255, 50261, 50346, 50347, 50349, 50351, 50357, 50359, 50365, 50372, 50377, 50382, 50384, 50397, 50399, 50403, 50405, 50407, 50409, 50417, 50423, 50432, 50437, 50439, 50453, 50460, 50474, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50533, 50535, 50537, 50542, 50548, 50553, 50558, 50561, 50567, 50570, 50572, 50592, 50596, 50601, 50606, 50610, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50673, 50687, 50689, 50692, 50706, 50713, 50723, 50730, 50735, 50743, 50746, 50748, 50751, 50756, 50761, 50773, 50776, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50801, 50811, 50816, 50916, 50918, 50920, 50926, 50928, 50935, 50949, 50952, 50954, 50974, 50988, 50990, 50992, 50994, 51004, 51023, 51037, 51051, 51070, 51077, 51100, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51134, 51137, 51139, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51174, 51178, 51181, 51184, 51186, 51190, 51193, 51198, 51202, 51205, 51210, 51217, 51222, 51230, 51233, 51236, 51240, 51243, 51248, 51251, 51253, 51260, 51262, 51267, 51270, 51276, 51279, 51284, 51287, 51294, 51299, 51301, 51303, 51311, 51313, 51316, 51321, 51323, 51326, 51328, 51335, 51337, 51344, 51348, 51353, 51359, 51362, 51364, 51369, 51377, 51380, 51385, 51485, 51487, 51495, 51499, 51502, 51504, 51507, 51516, 51520, 51526, 51534, 51536, 51542, 51546, 51550, 51552, 51554, 51556, 51558, 51560, 51562, 51564, 51566, 51568, 51570, 51572, 51576, 51578, 51580, 51582, 51586, 51588, 51590, 51592, 51595, 51597, 51600, 51602, 51604, 51606, 51609, 51612, 51614, 51616, 51618, 51623, 51626, 51628, 51633, 51635, 51638, 51640, 51642, 51647, 51649, 51654, 51670, 51672, 51675, 51677, 51680, 51682, 51685, 51687, 51690, 51693, 51696, 51698, 51700, 51703, 51709, 51712, 51715, 51717, 51721, 51724, 51727, 51729, 51733, 51736, 51739, 51742, 51746, 51749, 51752, 51754, 51761, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51791, 51793, 51796, 51807, 51810, 51814, 51819, 51821, 51824, 51830, 51832, 51837, 51840, 51842, 51844, 51846, 51848, 51850, 51855, 51863, 51872, 51876, 51878, 51881, 51884, 51889, 51913, 51926, 51932, 51946, 51963, 51970, 51972, 51980, 51982, 51984, 52059, 52071, 52078, 52084, 52086, 52088, 52091, 52092, 52095, 52101, 52103, 52105, 52109, 52111, 52115, 52117, 52123, 52125, 52127, 52129, 52143, 52149, 52153, 52163, 52165, 52171, 52173, 52175, 52189, 52201, 52203, 52211, 52213, 52215, 52220, 52224, 52226, 52233, 52238, 52240, 52244, 52252, 52254, 52261, 52266, 52281, 52334, 52340, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52376, 52388, 52390, 52395, 52397, 52448, 52455, 52460, 52467, 52480, 52494, 52510) 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 Suspicious Husband

Cast
Role: Millener Actor: Mrs Roffey

Afterpiece Title: The Shipwreck

Performances

Mainpiece Title: The Purse; Or, Benevolent Tar

Afterpiece Title: The Children in the Wood

Afterpiece Title: Lodoiska

Ballet: The Scotch Ghost. As17970105

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: The Purse

Afterpiece Title: The Children in the Wood

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: The Heiress

Afterpiece Title: No Song No Supper

Cast
Role: Nelly Actor: Mrs Roffey.

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: Lodoiska

Song: As17960927

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Lodoiska

Song: As17970222

Monologue: The Masque of Neptune and Amphitrite. As 22 Feb

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Lodoiska

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Cape St

Song: IV: song [as17970206]-Dignum

Performances

Mainpiece Title: Cape St

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Purse

Afterpiece Title: Lodoiska

Ballet: End 2nd piece: The Labyrinth. As17970306

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Apprentice

Afterpiece Title: Cape St

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Mrs Roffey

Afterpiece Title: Lodoiska

Ballet: End: The Labyrinth. As17970306

Performances

Mainpiece Title: Macbeth

Afterpiece Title: My Grandmother

Afterpiece Title: Cape St

Song: In 1st piece: as17961010, but Mrs Bland_

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Lodoiska

Song: Vocal Parts, as17970222, but Miss Granger, Master _Welsh

Monologue: The Masque of Neptune and Amphitrite. As 22 Feb

Performances

Mainpiece Title: Othello

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: Lodoiska

Song: As17960927

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Cape St

Dance: II: Masquerade-; with a Dance, as17970112

Song: Sigh no more Ladies, as17970112, but Miss Leak, Miss +Granger, Master _Welsh, Mrs _Bland

Ballet: End: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Lodoiska

Song: As17970307

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17970104

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Clara Actor: Mrs Roffey

Afterpiece Title: The Smugglers

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Lodoiska

Performances

Mainpiece Title: The Will

Afterpiece Title: The Purse

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Will

Afterpiece Title: The Apprentice

Ballet: The Scotch Ghost. As17961221