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 Busy Body

Afterpiece Title: Perseus and Andromeda

Cast
Role: Bride@Men Actor: Evans, F. Tench

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Cephalus and Procris

Dance: In: Grand Ballad D'Amour, as17311222

Music: Select Pieces-

Song: Miss Raftor

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Cephalus and Procris

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Perseus and Andromeda

Cast
Role: Bride@Men Actor: Lally Jr, F. Tench, Evans

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Perseus and Andromeda

Cast
Role: Bride@Men Actor: Lally Jr, F. Tench, Evans

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Perseus and Andromeda

Cast
Role: Bride@Men Actor: Lally Jr, F. Tench, Evans

Performances

Mainpiece Title: The Tragedy Of Tragedies

Afterpiece Title: The Comical Revenge; or, A Doctor in Spight of his Teeth

Afterpiece Title: Cephalus and Procris

Cast
Role: Tritons Actor: Houghton, Lally Jr, Tench, Evans

Performances

Mainpiece Title: Henry Iv, Part I

Afterpiece Title: The Amorous Sportsman; or, The Death of the Stag

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Amorous Sportsman

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Amorous Sportsman

Song: Master Cuttin

Performances

Mainpiece Title: Julius Caesar

Afterpiece Title: The Amorous Sportsman

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Amorous Sportsman

Dance: MMasquerade Dance-Thurmond; Le Petit Maitre-Jovan De Vallois

Song: Master Cuttin

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Amorous Sportsman

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Amorous Sportsman

Dance: PPierot and Pierate-Mons and Madam de Vallois; Sailor's Dance-Jones

Song: Master Cuttin

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Amorous Sportsman

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Amorous Sportsman

Song: As17321229

Dance: As17321229

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Amorous Sportsman

Song: As17321229

Dance: As17321229

Performances

Mainpiece Title: Julius Caesar

Afterpiece Title: The Amorous Sportsman

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Amorous Sportsman

Song: As17321229

Dance: As17321229

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Amorous Sportsman

Song: As17321229

Dance: As17321229

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: The Amorous Sportsman

Dance: M+Masquerade Dance by Thurmond: Le Petite Maitre-De Vallois

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Amorous Sportsman

Dance: FFriendly Lasses-Miss Wherrit, Miss Sandham; French Peasant, Pierot and Pieraite-Mons and Madam Jouan de Vallois; Sailor's Dance-Jones

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Amorous Sportsman

Dance: MMerry Lasses-Miss Wherrit, Miss Sandham; Sailor's Dance-Jones; Pierrot and Pierrate-de Vallois and Madam de Vallois

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Tavern Bilkers

Cast
Role: Punch Actor: Evans

Dance: FFriendly Lasses-Miss Wherrit, Miss Sandham; Sailor's Dance-Jones

Performances

Mainpiece Title: Virtue Betrayed

Afterpiece Title: The Tavern Bilkers

Cast
Role: Punch Actor: Evans