SELECT * FROM london_stages WHERE eventid IN (1341, 2121, 2153, 2163, 2193, 2211, 2285, 2561, 2564, 2883, 3195, 4466, 4499, 4533, 5819, 5826, 5836, 5840, 5857, 5860, 5914, 5921, 5924, 5948, 7444, 7446, 7448, 7450, 7452, 7454, 7459, 7472, 7474, 7500, 7502, 9870, 9874, 13653, 13656, 13659, 13662, 13666, 13669, 13673, 13676, 13679, 13682, 13686, 13690, 13694, 13701, 13705, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14108, 14123, 14135, 14161, 14181, 14187, 14229, 14267, 14300, 14301, 14332, 14373, 14384, 14392, 14395, 14407, 14432, 14443, 14452, 14466, 14469, 14492, 14496, 14499, 14544, 14550, 14785, 14796, 14826, 14935, 15251, 15253, 15256, 15261, 15267, 15271, 15275, 15278, 15282, 15286, 15290, 15293, 15296, 15299, 15309, 15312, 15315, 15319, 15323, 15327, 15329, 15332, 15360, 15369, 15528, 15529, 15565, 15568, 15628, 15659, 15752, 15754, 15774, 15779, 15799, 15819, 15869, 15873, 15878, 15882, 15885, 15888, 15893, 15904, 15908, 15912, 15976, 16162, 16174, 16178, 16184, 16188, 16192, 16324, 16385, 16434, 21449, 21452, 21471, 21538, 21603, 21652, 21683, 21756, 21793, 27426, 30586, 30623, 30689, 30990, 30996, 31002, 31004, 31006, 31008, 31013, 31020, 31024, 31029, 31032, 31038, 31046, 31067, 31080, 31095, 31121, 31140, 31163, 31246, 31262, 31349, 31359, 31394, 31444, 31695, 31729, 31743, 31772, 31836, 31842, 31933, 31952, 31954, 31978, 31986, 31996, 32001, 32006, 32018, 32058, 32096, 32153, 32230, 32241, 32244, 32257, 32318, 32331, 32333, 32337, 32375, 32389, 32412, 32426, 32436, 32440, 32499, 32519, 32630, 32640, 32657, 32675, 32702, 32725, 32751, 32824, 32841, 32845, 32950, 33006, 33048, 33085, 33122, 33137, 33164, 33184, 33294, 33333, 33440, 33470, 33527, 33539, 33645, 33674, 33826, 33922, 33961, 33970, 34059, 34094, 34108, 34147, 34190, 34351, 34526, 34544, 34651, 34684, 34807, 34902, 35290, 35306, 35664, 35715, 35717, 35719, 35722, 35724, 36224, 36254, 36533, 37034, 37782, 37838, 39463, 40174, 48760, 48762, 48768, 48770, 48772, 48931, 48948, 48999, 49013, 49017, 49025, 49060, 49065, 49119, 49198, 49200, 49202, 49205, 49241, 49243, 49245, 49247, 49251, 49253, 49255, 49257, 49263, 49267, 49269, 49277, 49281, 49283, 49289, 49291, 49293, 49301, 49306, 49318, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49358, 49361, 49365, 49375, 49379, 49393, 49398, 49419, 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, 49535, 49538, 49549, 49555, 49559, 49579, 49582, 49584, 49586, 49588, 49591, 49601, 49611, 49631, 49763, 49765, 49771, 49773, 49774, 49778, 49782, 49784, 49790, 49792, 49795, 49802, 49808, 49812, 49820, 49824, 49826, 49828, 49830, 49832, 49838, 49840, 49844, 49846, 49850, 49854, 49858, 49862, 49864, 49866, 49870, 49874, 49876, 49882, 49887, 49894, 49901, 49909, 49911, 49918, 49920, 49923, 49928, 49932, 49937, 49942, 49944, 49946, 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, 50034, 50037, 50047, 50054, 50056, 50076, 50078, 50083, 50086, 50091, 50093, 50098, 50101, 50103, 50105, 50107, 50115, 50117, 50120, 50122, 50125, 50127, 50130, 50133, 50135, 50137, 50152, 50155, 50157, 50169, 50171, 50176, 50178, 50185, 50188, 50190, 50194, 50202, 50209, 50212, 50219, 50220, 50223, 50225, 50228, 50337, 50341, 50344, 50349, 50357, 50362, 50367, 50369, 50373, 50375, 50379, 50381, 50384, 50386, 50388, 50390, 50395, 50397, 50399, 50401, 50403, 50407, 50409, 50411, 50413, 50415, 50417, 50419, 50421, 50427, 50429, 50432, 50434, 50437, 50439, 50441, 50443, 50446, 50448, 50451, 50455, 50457, 50460, 50465, 50467, 50469, 50474, 50481, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50516, 50523, 50525, 50528, 50530, 50535, 50537, 50542, 50544, 50545, 50548, 50552, 50553, 50555, 50558, 50561, 50567, 50570, 50572, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50608, 50610, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50667, 50673, 50683, 50687, 50689, 50692, 50694, 50696, 50698, 50701, 50703, 50706, 50708, 50713, 50716, 50718, 50721, 50723, 50725, 50727, 50730, 50732, 50735, 50743, 50746, 50748, 50751, 50753, 50756, 50758, 50761, 50766, 50768, 50771, 50773, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50801, 50811, 50823, 50918, 50920, 50928, 50931, 50935, 50939, 50945, 50947, 50949, 50952, 50956, 50958, 50960, 50962, 50964, 50966, 50968, 50970, 50972, 50976, 50978, 50980, 50982, 50984, 50986, 50988, 50990, 50992, 50994, 50996, 50998, 51000, 51002, 51004, 51006, 51011, 51013, 51015, 51017, 51020, 51035, 51040, 51042, 51051, 51053, 51056, 51060, 51063, 51068, 51080, 51084, 51089, 51096, 51100, 51103, 51106, 51109, 51111, 51113, 51115, 51118, 51120, 51123, 51125, 51127, 51129, 51132, 51134, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51158, 51160, 51163, 51165, 51167, 51169, 51172, 51190, 51196, 51198, 51202, 51217, 51222, 51230, 51233, 51236, 51240, 51243, 51246, 51248, 51251, 51253, 51255, 51257, 51260, 51262, 51267, 51270, 51272, 51276, 51279, 51284, 51287, 51289, 51292, 51294, 51297, 51299, 51301, 51303, 51308, 51311, 51316, 51318, 51321, 51323, 51326, 51328, 51330, 51332, 51335, 51337, 51344, 51348, 51353, 51357, 51362, 51364, 51367, 51369, 51371, 51373, 51376, 51377, 51380, 51382, 51385, 51387, 51483, 51485, 51497, 51499, 51500, 51502, 51504, 51507, 51510, 51515, 51516, 51520, 51526, 51534, 51540, 51542, 51544, 51546, 51548, 51550, 51552, 51554, 51556, 51570, 51572, 51574, 51576, 51580, 51582, 51584, 51586, 51588, 51590, 51592, 51595, 51597, 51600, 51602, 51606, 51609, 51618, 51623, 51626, 51630, 51633, 51635, 51638, 51640, 51642, 51647, 51649, 51652, 51656, 51658, 51663, 51672, 51675, 51677, 51698, 51703, 51705, 51709, 51715, 51717, 51727, 51749, 51752, 51754, 51758, 51761, 51764, 51766, 51770, 51773, 51776, 51778, 51781, 51783, 51785, 51791, 51793, 51796, 51798, 51800, 51807, 51810, 51814, 51819, 51821, 51824, 51827, 51830, 51832, 51835, 51837, 51844, 51848, 51850, 51853, 51855, 51863, 51870, 51872, 51876, 51878, 51889, 51892, 51901, 51903, 51906, 51908, 51911, 51913, 51916, 51918, 51921, 51923, 51926, 51928, 51930, 51932, 51935, 51937, 51939, 51941, 51942, 51943, 51946, 51949, 51952, 51954, 51956, 51958, 51961, 51963, 51966, 51968, 51970, 51972, 51980, 51984, 52061, 52080, 52084, 52086, 52088, 52091, 52092, 52095, 52101, 52103, 52105, 52109, 52111, 52115, 52117, 52119, 52123, 52125, 52127, 52129, 52137, 52141, 52143, 52147, 52149, 52151, 52153, 52157, 52163, 52165, 52169, 52171, 52175, 52179, 52183, 52187, 52191, 52195, 52197, 52199, 52201, 52203, 52205, 52209, 52211, 52213, 52215, 52217, 52220, 52222, 52224, 52226, 52228, 52233, 52235, 52238, 52240, 52242, 52244, 52247, 52254, 52256, 52261, 52263, 52266, 52268, 52276, 52281, 52283, 52285, 52290, 52293, 52295, 52297, 52304, 52311, 52318, 52322, 52325, 52328, 52334, 52340, 52342, 52354, 52373, 52385, 52388, 52390, 52395, 52397, 52399, 52402, 52404, 52409, 52414, 52443, 52448, 52453, 52455, 52457, 52460, 52462, 52467, 52472, 52477, 52480, 52494, 52503, 52505, 52508, 52510, 52515, 52524) 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 Beggar's Opera

Cast
Role: Wat Dreary Actor: Evans

Afterpiece Title: Sylvester Daggerwood

Cast
Role: Servant Actor: Evans.

Dance: In III: as17981129

Ballet: End afterpiece: The Scotch Ghost. As17981206

Performances

Mainpiece Title: The Stranger

Afterpiece Title: The Humourist

Cast
Role: Servants Actor: Evans, Fisher

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: The Beggar's Opera

Cast
Role: Wat Dreary Actor: Evans

Afterpiece Title: The Children in the Wood

Dance: As17981129

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Blue-Beard

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Son-in-Law

Cast
Role: John Actor: Evans

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: Aurelio And Miranda

Cast
Role: Lopez Actor: Evans

Afterpiece Title: The Children in the Wood

Song: Mainpiece: Chorusses-Danby, Wentworth, Brown, Tett, Denman, Atkins, [J.] Fisher, Aylmer, Gallot, Peck, Walker, Willoughby, Phillimore, Evans, Fisher, Caulfield Jun., Ms Arne, Ms Roffey, Ms Wentworth, Ms Jackson, Ms Maddocks, Ms Menage, Ms Menage Jun., Ms Chippendale, Ms Gawdry, Ms Butler, Ms Benson, Ms Bowyer, Ms Jacobs, Ms Coates

Performances

Mainpiece Title: Aurelio And Miranda

Cast
Role: Lopez Actor: Evans

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

Cast
Role: Lopez Actor: Evans

Afterpiece Title: The Prize

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Cast
Role: Lopez Actor: Evans

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Cast
Role: Lopez Actor: Evans

Afterpiece Title: Blue-Beard

Song: As17981231

Performances

Mainpiece Title: Aurelio And Miranda

Cast
Role: Lopez Actor: Evans

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

Cast
Role: Servants Actor: Fisher, Evans, Webb

Afterpiece Title: Blue-Beard

Song: In III: song-Dignum

Performances

Mainpiece Title: The Rivals

Cast
Role: Servants Actor: Fisher, Webb, Evans

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Humourist

Cast
Role: Servants Actor: Evans, Fisher

Performances

Mainpiece Title: The Castle-spectre

Afterpiece Title: The Apprentice

Cast
Role: Spouters Actor: Fisher, Evans, Grimaldi

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Servants Actor: Fisher, Evans, Webb

Afterpiece Title: My Grandmother

Song: As17990108

Performances

Mainpiece Title: Jane Shore

Cast
Role: Servants Actor: Maddocks, Evans

Afterpiece Title: Feudal Times; or, The Banquet Gallery

Performances

Mainpiece Title: Love Makes A Man

Performances

Mainpiece Title: The Wheel Of Fortune

Performances

Mainpiece Title: The Rivals

Cast
Role: Servants Actor: Fisher, Webb, Evans

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Rule A Wife And Have A Wife