SELECT * FROM london_stages WHERE eventid IN (1266, 1863, 2019, 2050, 2550, 4070, 4427, 4446, 4546, 4652, 4968, 5181, 5289, 7627, 7982, 12739, 14378, 15040, 15372, 15552, 16485, 16914, 17272, 17282, 17293, 17318, 18021, 18408, 19598, 20061, 20066, 20206, 20252, 20810, 20915, 21100, 21118, 21125, 21128, 21131, 21137, 21435, 21468, 21808, 21810, 21866, 21868, 21870, 21881, 21883, 21884, 21887, 21908, 21925, 21944, 22166, 22326, 22408, 22512, 22829, 22830, 22836, 22889, 22908, 23261, 23268, 23277, 23542, 23557, 23559, 23705, 24184, 25259, 27199, 27201, 27211, 27233, 27274, 27562, 27565, 27609, 27707, 27802, 27917, 27955, 28218, 28469, 28567, 28899, 29039, 29283, 29296, 29328, 29420, 29763, 29775, 29805, 30502, 30504, 30507, 30509, 30513, 30517, 30520, 30526, 30532, 30535, 30537, 30546, 30553, 30557, 30569, 30580, 30597, 30663, 30665, 30678, 30697, 30862, 30874, 30884, 30896, 30979, 31043, 31149, 31151, 31159, 31194, 31207, 31226, 31257, 31356, 31410, 31465, 31660, 31664, 31686, 31771, 31849, 31889, 31891, 31893, 31895, 31897, 31899, 31901, 31903, 31905, 31907, 31909, 31911, 31913, 31915, 31917, 31925, 31927, 31935, 31937, 31939, 31941, 31944, 31949, 31951, 31953, 31969, 31974, 31977, 32017, 32061, 32071, 32092, 32100, 32106, 32111, 32136, 32148, 32234, 32249, 32339, 32370, 32403, 32454, 32514, 32570, 32707, 32773, 32775, 32777, 32783, 32786, 32788, 32790, 32792, 32793, 32795, 32796, 32801, 32804, 32809, 32819, 32836, 32926, 32928, 32933, 32939, 32942, 32944, 32949, 32953, 32962, 32976, 32987, 32991, 33017, 33026, 33095, 33103, 33106, 33141, 33148, 33152, 33177, 33189, 33227, 33228, 33229, 33230, 33232, 33233, 33234, 33250, 33273, 33277, 33287, 33381, 33390, 33414, 33481, 33508, 33522, 33531, 33635, 33657, 33707, 33730, 33738, 33739, 33742, 33756, 33762, 33764, 33768, 33771, 33774, 33780, 33785, 33786, 33788, 33802, 33823, 33867, 33921, 33922, 33980, 34015, 34026, 34039, 34161, 34170, 34189, 34220, 34234, 34237, 34254, 34285, 34301, 34302, 34305, 34365, 34385, 34505, 34621, 34703, 34715, 34729, 34736, 34758, 34806, 34823, 34832, 34837, 34850, 34854, 34876, 34927, 34970, 35017, 35295, 35327, 35370, 35380, 35387, 35458, 35475, 35484, 35537, 35570, 35723, 35726, 35728, 35733, 35738, 35741, 35747, 35751, 35756, 35759, 35761, 35766, 35767, 35769, 35771, 35774, 35778, 35781, 35783, 35784, 35792, 35795, 35797, 35807, 35860, 35874, 35881, 35886, 35891, 35895, 35897, 35902, 35905, 35908, 35913, 35929, 35932, 35945, 35948, 35954, 35960, 35969, 35970, 35973, 36008, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36049, 36051, 36053, 36055, 36062, 36066, 36072, 36075, 36078, 36081, 36088, 36091, 36095, 36097, 36100, 36102, 36103, 36111, 36113, 36124, 36125, 36130, 36134, 36139, 36141, 36147, 36161, 36164, 36189, 36190, 36214, 36229, 36271, 36279, 36305, 36315, 36326, 36329, 36345, 36365, 36373, 36384, 36424, 36440, 36466, 36468, 36477, 36485, 36494, 36495, 36504, 36511, 36523, 36539, 36550, 36557, 36561, 36575, 36612, 36628, 36643, 36736, 36764, 36818, 36860, 36861, 36872, 36890, 36955, 37014, 37066, 37122, 37225, 37243, 37247, 37296, 37368, 37374, 37380, 37407, 37485, 37550, 37662, 37689, 37705, 37759, 37807, 37820, 37843, 37854, 37858, 37878, 37998, 38016, 38067, 38076, 38162, 38221, 38241, 38257, 38265, 38277, 38280, 38289, 38304, 38312, 38335, 38448, 38472, 38507, 38540, 38673, 38706, 38728, 38729, 38767, 38769, 38789, 38810, 38828, 38834, 38853, 38859, 38870, 38876, 38916, 38932, 39020, 39083, 39086, 39099, 39257, 39293, 39302, 39325, 39336, 39347, 39363, 39371, 39402, 39442, 39443, 39444, 39447, 39550, 39591, 39640, 39642, 39643, 39774, 39777, 39845, 39877, 39906, 39980, 39988, 39989, 39990, 39995, 39996, 39999, 40000, 40001, 40003, 40004, 40005, 40007, 40008, 40010, 40011, 40012, 40013, 40014, 40035, 40153, 40227, 40294, 40296, 40315, 40383, 40392, 40437, 40438, 40443, 40472, 40473, 40474, 40476, 40478, 40480, 40483, 40484, 40486, 40488, 40491, 40492, 40494, 40499, 40500, 40502, 40504, 40505, 40515, 40517, 40523, 40524, 40525, 40529, 40532, 40538, 40541, 40542, 40547, 40551, 40557, 40573, 40581, 40594, 40603, 40663, 40696, 40720, 40736, 40748, 40750, 40752, 40765, 40772, 40777, 40791, 40796, 40834, 40868, 40870, 40901, 40905, 40922, 40925, 40928, 40933, 40938, 40941, 40943, 40951, 40953, 40956, 40958, 40960, 40965, 40967, 40972, 40978, 40989, 40992, 41005, 41041, 41043, 41048, 41050, 41056, 41059, 41061, 41070, 41089, 41091, 41126, 41142, 41169, 41179, 41184, 41222, 41384, 41412, 41435, 41447, 41508, 41513, 41515, 41518, 41520, 41527, 41529, 41532, 41542, 41544, 41547, 41548, 41557, 41562, 41567, 41571, 41589, 41629, 41661, 41673, 41702, 41714, 41755, 41781, 41846, 41928, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42060, 42077, 42097, 42106, 42113, 42149, 42216, 42221, 42236, 42254, 42322, 42364, 42488, 42529, 42682, 42728, 42744, 42792, 42812, 42868, 42900, 42911, 42929, 42983, 42985, 43058, 43156, 43244, 43267, 43290, 43303, 43315, 43387, 43401, 43435, 43447, 43558, 43579, 43581, 43589, 43591, 43593, 43595, 43650, 43673, 43692, 43714, 43735, 43769, 43848, 43882, 43899, 43944, 43951, 43960, 43967, 43969, 43972, 43974, 43986, 43987, 43994, 44000, 44003, 44015, 44034, 44040, 44041, 44050, 44057, 44071, 44169, 44183, 44189, 44275, 44297, 44369, 44439, 44449, 44451, 44473, 44474, 44481, 44506, 44508, 44538, 44551, 44566, 44570, 44580, 44585, 44600, 44759, 44773, 44861, 44973, 45006, 45017, 45019, 45029, 45040, 45051, 45063, 45084, 45086, 45108, 45210, 45249, 45251, 45313, 45327, 45338, 45455, 45470, 45500, 45512, 45516, 45562, 45583, 45588, 45590, 45600, 45608, 45611, 45617, 45619, 45625, 45629, 45646, 45651, 45659, 45664, 45673, 45680, 45683, 45696, 45703, 45739, 45744, 45770, 45772, 45773, 45792, 45842, 45855, 45884, 45901, 45943, 46028, 46031, 46038, 46040, 46042, 46047, 46050, 46052, 46055, 46058, 46068, 46080, 46085, 46093, 46100, 46103, 46109, 46121, 46133, 46139, 46148, 46162, 46166, 46174, 46180, 46185, 46187, 46190, 46191, 46193, 46199, 46201, 46202, 46204, 46205, 46207, 46208, 46209, 46210, 46211, 46212, 46215, 46216, 46219, 46223, 46225, 46227, 46228, 46230, 46235, 46236, 46237, 46240, 46241, 46245, 46246, 46247, 46248, 46249, 46251, 46254, 46255, 46256, 46257, 46258, 46259, 46270, 46278, 46339, 46350, 46501, 46542, 46563, 46571, 46609, 46641, 46652, 46713, 46715, 46729, 46745, 46783, 46795, 46800, 46806, 46827, 46896, 46936, 46942, 46982, 47164, 47166, 47249, 47321, 47380, 47386, 47394, 47404, 47410, 47421, 47427, 47451, 47456, 47459, 47467, 47491, 47552, 47669, 47706, 47721, 47824, 47837, 47839, 47928, 47932, 47937, 47970, 48006, 48112, 48242, 48279, 48340, 48386, 48389, 48391, 48397, 48398, 48402, 48407, 48413, 48418, 48434, 48476, 48477, 48478, 48482, 48484, 48488, 48489, 48492, 48494, 48495, 48497, 48519, 48537, 48547, 48559, 48571, 48616, 48622, 48625, 48632, 48677, 48701, 48734, 48736, 48744, 48779, 48858, 48904, 48959, 48984, 49012, 49026, 49061, 49081, 49123, 49126, 49128, 49130, 49145, 49148, 49150, 49151, 49153, 49155, 49156, 49158, 49162, 49169, 49171, 49172, 49177, 49181, 49183, 49184, 49232, 49238, 49242, 49246, 49248, 49250, 49254, 49260, 49408, 49419, 49525, 49553, 49609, 49637, 49651, 49659, 49703, 49726, 49785, 49843, 49877, 49893, 49943, 49945, 49947, 49962, 49967, 49970, 49975, 49979, 49980, 49984, 49988, 49993, 50025, 50030, 50086, 50186, 50237, 50238, 50239, 50370, 50440, 50511, 50716, 50727, 50746, 50748, 50752, 50769, 50781, 50789, 50796, 50841, 50873, 50934, 50942, 50946, 50950, 50981, 51082, 51094, 51208, 51235, 51332, 51340, 51397, 51561, 51611, 51688, 51742, 51847, 51959, 51964, 51969, 51985, 52029, 52035, 52132, 52267, 52528, 52539, 52556) 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 Dead Alive

Afterpiece Title: THE LIAR

Cast
Role: Major Benbow Actor: Suett

Afterpiece Title: MY GRANDMOTHER

Performances

Mainpiece Title: Rule Britannia

Afterpiece Title: WAYS AND MEANS

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Major Benbow Actor: Suett

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: THE BATTLE OF HEXHAM

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Major Benbow Actor: Suett

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: THE MOUNTAINEERS

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Major Benbow Actor: Suett

Performances

Mainpiece Title: Heigho For A Husband

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Major Benbow Actor: Suett

Afterpiece Title: THE PURSE

Performances

Mainpiece Title: The Liar

Afterpiece Title: PEEPING TOM

Afterpiece Title: MY GRANDMOTHER

Cast
Role: Major Benbow Actor: Suett

Performances

Mainpiece Title: The Rival Queens; Or, Drury-lane And Covent-garden

Afterpiece Title: The Suspicious Husband

Afterpiece Title: Sprigs of Laurel

Cast
Role: Major Tactic Actor: Davies

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Sprigs of Laurel

Cast
Role: Major Tactic Actor: Davies

Dance: As17941020

Song: As17941022

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Afterpiece Title: Two Strings to Your Bow

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Performances

Mainpiece Title: The Rage

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Song: As17940922

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Arrived at Portsmouth

Cast
Role: Major Drummond Actor: Townsend

Dance: In II: Masquerade Dance- incident to the Play

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: Two Strings to Your Bow

Cast
Role: Major Drummond Actor: Townsend

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Mayor of Garratt

Cast
Role: Major Sturgeon Actor: Bannister

Dance: In III: Hornpipe-G. D'Egville

Performances

Mainpiece Title: The Telegraph

Cast
Role: Major O'Donelly Actor: Haymes

Afterpiece Title: The Comedy of Errors

Afterpiece Title: The Miser

Afterpiece Title: The Devil to Pay

Song: III 2nd piece: song in character-Mrs Clendining

Performances

Mainpiece Title: The Jealous Wife

Cast
Role: Major Oakly Actor: Quick

Afterpiece Title: The British Recruit

Afterpiece Title: The Follies of a Day

Song: As17950316

Performances

Mainpiece Title: The Bank Note

Afterpiece Title: The Death of Captain Faulknor

Afterpiece Title: Sprigs of Laurel

Cast
Role: Major Tactic Actor: Davies

Song: In course of 2nd piece: As17950506; Incidental to 1st piece: The Irishman's Peep at the Continent-Johnstone; In course of entertainments: Black Eyed Susan-Incledon; Old Towler-Incledon

Music: 3rd piece: With the favorite Overture by Shield for Arrived at Portsmouth-; with a violin and oboe obligato-Mountain, W. Parke

Performances

Mainpiece Title: The Bank Note

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: The Death of Captain Faulknor

Cast
Role: Major Tactic Actor: Davies

Song: 3rd piece: As17950506; Incidental to 1st piece: The Irishman's Peep at the Continent-Johnstone; In course of entertainments: The Storm-Incledon

Performances

Mainpiece Title: The Mayor Of Garratt

Cast
Role: Major Sturgeon Actor: Bannister

Afterpiece Title: New Hay at the Old Market

Afterpiece Title: The Battle of Hexham; or, Days of Old

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Two Strings to Your Bow

Cast
Role: Major Drummond Actor: Townsend

Performances

Mainpiece Title: The Battle Of Hexham

Cast
Role: Major Sturgeon Actor: Bannister

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Flitch Of Bacon

Cast
Role: Major Benbow Actor: Suett

Afterpiece Title: The Recruiting Officer

Afterpiece Title: New Hay at the Old Market