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: A Word For Nature

Afterpiece Title: The Shipwreck

Ballet: End: The Scotch Ghost; or, Little Fanny's Love. Jamie-Dubois; Glaude-Grimaldi; Saundy-Master Chatterley; Donald-Whitmell; The Lady of Dunblain-Mlle Parisot; Elpsa-Mrs Brooker; Fanny (with Hornpipe)-Sga Bossi DelCaro; Villagers-Roffey, Garman, Wells, Gauron, Goodman, Johnston, Bisan, Ms Brigg, Ms Byrne, Ms Daniels, Ms Vining, Ms Luciet, Ms Riches, Ms Drake

Performances

Mainpiece Title: A Word For Nature

Dance: As17981205

Performances

Mainpiece Title: A Word For Nature

Afterpiece Title: My Grandmother

Ballet: End: The Scotch Ghost. As17981206

Performances

Mainpiece Title: A Word For Nature

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Jenny Diver Actor: Mrs Roffey

Afterpiece Title: Sylvester Daggerwood

Dance: In III: as17981129

Ballet: End afterpiece: The Scotch Ghost. As17981206

Performances

Mainpiece Title: The Stranger

Afterpiece Title: The Humourist

Music: As17980915

Dance: In: As17980915

Ballet: End: The Scotch Ghost. As17981206

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Lady Actor: Mrs Roffey.

Dance: As17981205

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Jenny Diver Actor: Mrs Roffey

Afterpiece Title: The Children in the Wood

Dance: As17981129

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Shipwreck

Song: As17981203

Ballet: End: The Scotch Ghost. As17981206

Performances

Mainpiece Title: Love Makes A Man

Dance: As17981205

Performances

Mainpiece Title: The Grecian Daughter

Dance: As17981205

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Son-in-Law

Ballet: End: The Scotch Ghost. As17981206

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: Douglas

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: No Song No Supper

Cast
Role: Nelly Actor: Mrs Roffey.

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: Chorusses, as17981229, but _Tett, _Denman, _Atkins, _Aylmer, _Gallot, _Peck, _Walker, _Willoughby, _Phillimore, _Caulfield Jun

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: The Prize

Cast
Role: Juba Actor: Mrs Roffey

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: The Stranger

Afterpiece Title: Blue-Beard

Music: As17980915

Dance: As17980915

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: Blue-Beard

Song: In III: song-Dignum

Performances

Mainpiece Title: Douglas

Afterpiece Title: No Song No Supper

Cast
Role: Nelly Actor: Mrs Roffey.