SELECT * FROM london_stages WHERE eventid IN (194, 197, 394, 403, 1338, 1683, 2417, 2481, 3504, 3694, 3719, 4168, 4231, 4269, 4274, 4446, 4676, 4704, 4825, 4907, 4996, 5289, 5624, 6033, 6038, 6540, 6619, 6658, 6688, 6724, 6930, 6967, 7117, 7870, 7954, 7964, 7991, 8042, 8354, 8535, 8584, 8645, 8750, 8849, 8959, 9070, 9212, 9271, 9588, 9750, 10372, 11003, 11005, 11007, 11497, 11806, 11907, 12099, 12184, 12279, 12281, 12291, 12292, 12572, 12644, 12693, 12697, 12701, 12704, 12713, 12723, 12726, 12734, 12737, 12738, 12741, 12743, 12746, 12749, 12751, 12981, 13081, 13085, 13089, 13092, 13096, 13099, 13103, 13176, 13480, 13484, 13486, 13492, 13501, 13503, 13519, 13599, 13632, 13642, 13752, 13813, 13847, 13921, 13959, 14006, 14059, 14110, 14146, 14154, 14218, 14263, 14332, 14337, 14681, 14696, 14699, 14703, 14707, 14712, 14716, 14720, 14724, 14776, 15762, 16074, 16080, 16084, 16988, 16992, 16996, 17849, 18559, 20035, 21334, 21354, 21482, 21761, 21821, 22950, 22953, 22964, 22973, 22978, 23029, 23126, 23136, 23142, 23271, 23282, 23380, 23383, 23393, 23409, 23787, 24335, 24348, 24349, 24359, 24378, 24387, 24407, 24411, 24438, 24454, 24485, 24544, 24561, 24573, 24580, 24649, 24660, 24701, 24805, 24875, 24898, 24907, 24914, 24937, 24944, 24978, 25106, 25230, 25264, 25269, 25370, 25389, 25467, 25477, 25730, 25746, 25755, 25784, 25802, 25808, 25982, 26024, 26229, 26233, 26237, 26272, 26294, 26311, 26326, 26436, 26548, 26669, 27195, 27208, 27211, 27213, 27265, 27303, 27357, 27409, 27484, 27505, 27590, 27668, 27679, 27698, 27709, 27790, 27943, 28047, 28148, 28155, 28170, 28256, 28341, 28378, 28676, 28879, 28887, 29025, 29052, 29160, 29174, 29178, 29187, 29225, 29226, 29318, 29354, 29399, 29407, 29468, 29610, 29720, 29766, 29827, 29838, 29913, 29969, 29998, 30029, 30325, 30348, 30856, 30930, 31191, 31346, 31365, 31369, 31737, 31851, 32241, 32259, 32322, 32513, 32614, 32681, 32818, 32875, 32885, 33016, 33113, 33316, 33466, 33655, 34511, 34596, 34918, 35513, 35521, 35530, 35879, 35952, 35962, 35974, 36005, 37002, 37008, 37219, 37600, 38297, 38302, 38839, 38840, 38841, 38842, 38844, 38845, 38847, 38849, 38853, 38872, 38881, 38885, 38918, 38937, 38946, 38976, 39011, 39093, 39107, 39123, 39213, 39245, 39257, 39265, 39271, 39286, 39291, 39336, 39371, 39372, 39397, 39493, 39502, 39525, 39546, 39550, 39643, 39648, 39693, 39699, 39777, 39793, 39818, 39852, 39875, 39901, 39902, 39912, 39917, 39935, 39936, 39951, 39985, 39987, 40283, 40324, 40449, 40455, 40465, 40519, 40536, 40594, 40625, 40637, 40659, 40664, 40668, 40671, 40673, 40676, 40678, 40696, 40727, 40740, 40764, 40783, 40788, 40812, 40818, 40824, 40868, 40870, 40889, 40924, 40925, 40928, 40965, 41098, 41116, 41129, 41164, 41178, 41191, 41242, 41263, 41282, 41296, 41341, 41349, 41370, 41382, 41384, 41499, 41507, 41515, 41526, 41536, 41613, 41694, 41704, 41706, 41756, 41775, 41832, 41891, 41902, 41970, 42020, 42049, 42095, 42140, 42141, 42143, 42146, 42148, 42151, 42153, 42215, 42216, 42218, 42221, 42224, 42226, 42229, 42232, 42237, 42243, 42279, 42290, 42298, 42305, 42311, 42363, 42364, 42391, 42396, 42406, 42426, 42457, 42478, 42479, 42543, 42555, 42580, 42641, 42673, 42683, 42706, 42720, 42742, 42774, 42778, 42782, 42790, 42801, 42804, 42825, 42827, 42830, 42831, 42837, 42900, 42909, 42943, 42945, 42967, 43007, 43103, 43109, 43112, 43114, 43115, 43119, 43121, 43126, 43133, 43140, 43147, 43162, 43166, 43167, 43169, 43197, 43199, 43200, 43241, 43242, 43285, 43309, 43314, 43399, 43455, 43463, 43470, 43472, 43477, 43498, 43501, 43507, 43514, 43515, 43516, 43517, 43519, 43523, 43527, 43529, 43531, 43532, 43535, 43539, 43541, 43543, 43545, 43547, 43551, 43553, 43558, 43603, 43606, 43608, 43637, 43652, 43657, 43696, 43745, 43767, 43773, 43776, 43779, 43785, 43792, 43803, 43809, 43828, 43832, 43836, 43841, 43861, 43862, 43870, 43886, 43896, 43897, 43899, 43928, 43929, 43938, 43955, 43974, 43987, 43991, 44000, 44021, 44035, 44072, 44080, 44111, 44155, 44165, 44178, 44194, 44225, 44358, 44377, 44434, 44439, 44444, 44481, 44603, 44610, 44611, 44627, 44629, 44638, 44640, 44650, 44652, 44654, 44658, 44662, 44666, 44670, 44674, 44675, 44678, 44682, 44685, 44686, 44690, 44694, 44723, 44728, 44730, 44743, 44750, 44757, 44764, 44776, 44787, 44796, 44816, 44891, 44909, 44928, 44929, 44935, 44936, 44946, 44950, 44952, 44955, 44957, 44963, 44971, 44980, 44986, 44988, 45003, 45004, 45007, 45013, 45018, 45020, 45025, 45030, 45037, 45040, 45041, 45047, 45051, 45097, 45106, 45108, 45137, 45143, 45145, 45158, 45164, 45166, 45169, 45174, 45180, 45184, 45186, 45188, 45190, 45192, 45195, 45196, 45198, 45200, 45204, 45208, 45210, 45212, 45216, 45220, 45222, 45228, 45229, 45232, 45234, 45236, 45238, 45240, 45244, 45246, 45248, 45250, 45252, 45255, 45257, 45260, 45262, 45264, 45269, 45271, 45273, 45274, 45276, 45280, 45289, 45307, 45330, 45333, 45338, 45342, 45344, 45349, 45354, 45356, 45365, 45386, 45390, 45396, 45398, 45399, 45402, 45403, 45409, 45410, 45412, 45415, 45416, 45422, 45424, 45429, 45433, 45439, 45443, 45454, 45461, 45471, 45472, 45487, 45497, 45506, 45517, 45524, 45526, 45531, 45544, 45554, 45572, 45574, 45587, 45589, 45608, 45611, 45617, 45649, 45651, 45683, 45702, 45704, 45714, 45731, 45742, 45767, 45791, 45795, 45803, 45809, 45813, 45817, 45825, 45831, 45838, 45848, 45854, 45862, 45874, 45890, 45899, 45902, 45904, 45909, 45911, 45923, 45939, 45942, 45951, 45958, 45978, 45980, 46011, 46028, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46075, 46080, 46085, 46093, 46095, 46100, 46103, 46109, 46110, 46118, 46121, 46133, 46137, 46148, 46166, 46172, 46174, 46178, 46190, 46219, 46222, 46234, 46247, 46256, 46306, 46327, 46339, 46355, 46374, 46391, 46501, 46502, 46504, 46524, 46542, 46563, 46641, 46649, 46663, 46671, 46673, 46697, 46705, 46720, 46741, 46756, 46768, 46769, 46776, 46780, 46784, 46785, 46790, 46791, 46795, 46800, 46806, 46809, 46815, 46823, 46827, 46882, 46884, 46892, 46896, 46935, 46939, 46942, 46943, 46959, 46982, 46984, 46988, 46992, 46994, 46996, 46998, 47000, 47002, 47004, 47006, 47010, 47011, 47012, 47016, 47018, 47022, 47024, 47028, 47030, 47034, 47040, 47042, 47043, 47044, 47045, 47046, 47059, 47073, 47118, 47164, 47192, 47220, 47224, 47230, 47235, 47253, 47266, 47306, 47309, 47312, 47315, 47320, 47321, 47322, 47327, 47334, 47341, 47349, 47361, 47363, 47371, 47374, 47376, 47383, 47384, 47386, 47388, 47389, 47392, 47393, 47396, 47399, 47401, 47402, 47404, 47408, 47416, 47418, 47419, 47420, 47421, 47423, 47425, 47426, 47427, 47429, 47442, 47449, 47461, 47576, 47738, 47779, 47845, 47849, 47863, 47874, 47902, 47928, 47932, 47937, 47983, 47984, 47989, 48000, 48022, 48039, 48046, 48047, 48094, 48127, 48135, 48163, 48188, 48199, 48201, 48209, 48380, 48425, 48442, 48546, 48591, 48599, 48606, 48624, 48644, 48658, 48680, 48762, 48896, 48899, 48909, 49031, 49126, 49148, 49187, 49190, 49219, 49262, 49395, 49430, 49632, 49808, 50288, 50295, 50302, 50733, 50736, 50737, 50742, 50744, 50757, 50795, 50802, 50833, 50835, 50842, 50854, 50856, 50857, 50858, 50861, 50872, 50877, 50917, 50923, 50951, 50981, 50991, 51001, 51057, 51147, 51211, 51215, 51266, 51300, 51312, 51331, 51336, 51341, 51345, 51351, 51356, 51411, 51418, 51498, 51543, 51686, 51922, 52100, 52241, 52444, 52449, 52458, 52490) 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 Cutter Of Coleman Street

Cast
Role: Colonel Jolly Actor: Betterton

Performances

Mainpiece Title: The Cutter Of Coleman Street

Cast
Role: Colonel Jolly Actor: Betterton

Performances

Mainpiece Title: The Comical Revenge Or Love In A Tub

Cast
Role: Colonel Bruce Actor: Smith

Performances

Mainpiece Title: Love In A Tub

Cast
Role: Colonel Bruce Actor: Smith?

Performances

Mainpiece Title: Squire Oldsapp Or The Night adventurers

Cast
Role: Colonel Buff Actor: Sandford

Performances

Mainpiece Title: The Injured Lovers Or The Ambitious Father

Cast
Role: Old Colonel Actor: Sanford

Performances

Mainpiece Title: Sir Harry Wildair

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Beaus Duel Or A Soldier For The Ladies

Cast
Role: Colonel Manly Actor: Cory

Performances

Mainpiece Title: The Siege Of Barcelona Or The Soldiers Fortune With The Taking Of Fort Montjouy Containing The Pleasant And Comical Exploits Of That Renownd Hero Captain Blunderbuss And His Man Squib

Cast
Role: Colonel Lovewell Actor: Mills

Song: The Dame of Honour-Mrs Willis

Entertainment: Vaulting-Simpson, that most celebrated Master, the famous Vaulter, who Performs with Mr Penkethman at the Request of the Quality, being lately arriv'd from Italy

Performances

Mainpiece Title: The Constant Couple Or A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple Or A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Afterpiece Title: The Stage Coach

Performances

Mainpiece Title: The Spanish Fryar Or The Double Discovery

Cast
Role: Colonel Actor: Wilks

Performances

Mainpiece Title: The Constant Couple Or A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Colonel Standard Actor: Mills

Afterpiece Title: The School Boy

Performances

Mainpiece Title: Marplot

Cast
Role: Colonel Ravelin Actor: Wilks

Performances

Mainpiece Title: The Constant Couple Or A Trip To The Jubilee

Cast
Role: Colonel Standard Actor: Mills

Performances

Mainpiece Title: Marplot

Cast
Role: Colonel Ravelin Actor: Wilks

Performances

Mainpiece Title: The Volunteers Or The Stock Jobbers

Cast
Role: Colonel Hackwell Actor: Norris

Performances

Mainpiece Title: The Perplexd Lovers

Cast
Role: Colonel Bastion Actor: Wilks
Role: Colonel Merryman Actor: Bullock Sr

Performances

Mainpiece Title: The Humours Of The Army

Cast
Role: Colonel Hyland Actor: Bullock Sr

Performances

Mainpiece Title: The Wonder A Woman Keeps A Secret

Cast
Role: Colonel Britton Actor: Mills

Performances

Mainpiece Title: The Boating Lovers Or The Libertine Tamd

Cast
Role: Colonel Winfield Actor: Keene

Dance: delaGarde, Mrs Bullock

Performances

Mainpiece Title: The Boating Lovers

Cast
Role: Colonel Winfield Actor: Keene