SELECT * FROM london_stages WHERE eventid IN (1235, 1283, 1284, 1457, 1820, 2435, 2519, 3475, 3603, 3650, 3851, 3877, 3944, 3953, 3982, 4063, 4143, 4208, 4976, 5301, 5484, 5748, 6005, 6266, 6604, 6971, 7069, 7214, 7370, 7388, 7526, 8053, 8108, 8336, 8343, 8416, 8459, 8462, 8581, 8771, 8924, 9382, 9965, 11183, 11745, 11751, 11762, 12184, 12219, 12242, 12279, 12281, 12381, 12923, 12927, 13005, 13079, 13493, 13530, 14218, 14263, 14349, 14394, 14489, 14498, 14524, 14530, 14540, 14543, 14794, 14822, 14828, 14921, 15096, 15171, 15491, 15675, 15805, 15950, 16219, 16422, 16883, 16969, 17082, 18552, 18558, 18564, 18572, 18583, 18630, 18651, 18701, 18988, 18990, 19186, 19204, 19278, 19335, 19411, 19415, 19418, 19420, 19455, 19509, 19697, 19710, 19978, 20056, 20220, 20425, 20520, 20555, 20768, 21064, 21073, 21182, 21302, 21912, 21913, 21944, 21980, 22241, 22323, 22625, 22636, 22639, 22644, 22647, 22650, 22654, 22657, 22747, 22917, 22918, 23019, 23045, 23128, 23203, 23275, 23364, 23594, 23648, 23824, 24179, 24319, 24488, 24493, 24663, 24679, 24758, 24777, 25047, 25249, 25466, 25470, 25482, 25689, 25907, 25913, 25944, 26142, 26146, 26212, 26281, 26282, 26399, 26429, 26496, 26499, 26501, 26504, 26508, 26511, 26517, 26521, 26621, 26667, 26736, 26824, 26874, 26880, 26883, 26888, 26892, 26901, 26905, 26978, 27029, 27188, 27443, 27753, 27870, 27874, 27876, 27879, 27882, 27884, 27887, 27889, 27896, 27899, 27938, 27975, 28027, 28057, 28097, 28668, 28670, 28672, 28743, 28830, 28832, 29238, 29240, 29332, 29516, 29778, 29780, 29782, 29784, 29786, 29788, 29790, 29792, 29794, 29799, 29801, 29804, 29808, 29810, 29817, 29828, 29840, 29844, 29848, 29865, 29870, 29883, 29905, 29913, 29924, 29965, 29975, 29998, 30029, 30031, 30039, 30070, 30088, 30098, 30118, 30147, 30293, 30317, 30319, 30367, 30377, 30380, 30393, 30394, 30400, 30405, 30406, 30425, 30427, 30446, 30573, 30580, 30585, 30617, 30624, 30641, 30660, 30680, 30694, 30785, 30872, 30876, 30900, 30950, 30990, 30993, 30996, 31004, 31032, 31046, 31080, 31087, 31144, 31176, 31234, 31272, 31413, 31546, 31553, 31597, 31636, 31655, 31667, 31696, 31699, 31866, 31879, 31947, 31963, 32013, 32015, 32018, 32033, 32069, 32148, 32152, 32155, 32181, 32184, 32198, 32202, 32217, 32243, 32254, 32256, 32321, 32335, 32352, 32360, 32366, 32370, 32376, 32444, 32462, 32464, 32517, 32523, 32565, 32626, 32658, 32691, 32718, 32719, 32811, 32825, 32880, 32918, 33076, 33119, 33155, 33179, 33180, 33290, 33403, 33409, 33420, 33423, 33486, 33492, 33512, 33538, 33559, 33595, 33601, 33609, 33642, 33644, 33664, 33703, 33835, 33847, 33967, 34060, 34107, 34127, 34227, 34238, 34345, 34377, 34542, 34564, 34738, 34786, 34801, 34809, 34904, 35015, 35018, 35020, 35023, 35025, 35027, 35029, 35032, 35034, 35037, 35039, 35043, 35046, 35058, 35086, 35100, 35119, 35136, 35144, 35150, 35170, 35193, 35340, 35361, 35375, 35540, 35548, 35561, 35616, 35630, 35703, 35760, 35944, 35967, 35988, 36022, 36024, 36027, 36029, 36031, 36033, 36035, 36037, 36039, 36041, 36043, 36045, 36049, 36051, 36053, 36055, 36062, 36066, 36072, 36075, 36081, 36091, 36097, 36100, 36103, 36109, 36140, 36153, 36193, 36202, 36265, 36313, 36331, 36363, 36382, 36455, 36524, 36535, 36641, 36669, 36766, 36790, 36791, 36814, 36911, 36952, 37005, 37209, 37237, 37361, 37391, 37417, 37451, 37455, 37465, 37470, 37490, 37550, 37679, 37795, 37842, 37862, 37961, 37988, 38042, 38058, 38152, 38173, 38195, 38230, 38313, 38642, 38872, 38897, 38977, 38991, 39016, 39091, 39270, 39341, 39397, 39520, 39532, 39550, 39555, 39558, 39611, 39640, 39683, 39694, 39708, 39793, 39936, 40017, 40020, 40022, 40024, 40028, 40034, 40038, 40067, 40069, 40144, 40168, 40194, 40209, 40256, 40337, 40396, 40431, 40449, 40585, 40643, 40879, 40998, 41114, 41116, 41129, 41157, 41178, 41242, 41260, 41263, 41282, 41296, 41526, 41902, 41908, 41913, 41970, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42411, 42412, 42420, 42425, 42427, 42435, 42442, 42452, 42463, 42472, 42481, 42486, 42501, 42510, 42512, 42541, 42551, 42561, 42607, 42620, 42668, 42689, 42712, 42868, 42869, 42888, 42906, 42920, 42928, 42931, 42942, 42952, 42968, 42981, 42987, 42993, 43003, 43009, 43023, 43031, 43069, 43095, 43199, 43216, 43231, 43267, 43294, 43299, 43464, 43528, 43536, 43586, 43623, 43770, 43797, 43829, 43870, 43888, 43895, 44007, 44036, 44051, 44098, 44110, 44123, 44202, 44334, 44347, 44371, 44374, 44391, 44394, 44398, 44437, 44596, 44609, 44624, 44627, 44659, 44660, 44681, 44725, 44728, 44749, 44814, 44839, 44886, 44939, 44943, 44944, 44971, 44973, 44997, 45018, 45137, 45140, 45156, 45172, 45203, 45261, 45289, 45339, 45398, 45451, 45469, 45474, 45480, 45481, 45495, 45542, 45557, 45561, 45577, 45587, 45712, 45725, 45734, 45795, 45803, 45809, 45824, 45825, 45838, 45847, 45854, 45874, 45887, 45890, 45899, 45902, 45904, 45909, 45911, 45923, 45939, 45945, 45951, 45957, 45958, 45978, 45980, 45990, 46020, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46064, 46068, 46080, 46093, 46100, 46103, 46121, 46133, 46137, 46147, 46148, 46153, 46166, 46174, 46178, 46273, 46299, 46372, 46396, 46486, 46514, 46549, 46550, 46551, 46557, 46560, 46561, 46566, 46574, 46575, 46589, 46594, 46603, 46606, 46618, 46656, 46677, 46771, 46857, 46870, 46922, 46974, 47090, 47183, 47218, 47228, 47260, 47490, 47526, 47585, 47636, 47662, 47684, 47713, 47736, 47819, 47822, 47866, 47886, 47895, 48016, 48224, 48599, 48606, 48624, 48644, 48658, 48680, 48762, 48874, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48918, 48923, 48927, 48945, 48961, 48986, 48993, 49007, 49043, 49053, 49077, 49083, 49109, 49114, 49117, 49138, 49155, 49197, 49203, 49356, 49362, 49393, 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, 49621, 49646, 49685, 49702, 49711, 49717, 49729, 49730, 49736, 49747, 49764, 49822, 49892, 49894, 50015, 50040, 50055, 50072, 50099, 50158, 50190, 50208, 50209, 50257, 50268, 50335, 50365, 50367, 50371, 50425, 50439, 50488, 50533, 50565, 50585, 50625, 50631, 50637, 50679, 50738, 50766, 50768, 50783, 50792, 50797, 50801, 50807, 50816, 50827, 50874, 50878, 50918, 50922, 50923, 50984, 51024, 51042, 51044, 51046, 51049, 51051, 51053, 51056, 51058, 51063, 51066, 51068, 51070, 51075, 51077, 51080, 51082, 51084, 51089, 51091, 51094, 51096, 51100, 51103, 51118, 51132, 51139, 51144, 51155, 51158, 51172, 51184, 51196, 51208, 51214, 51220, 51226, 51246, 51255, 51265, 51272, 51282, 51283, 51297, 51313, 51335, 51340, 51350, 51355, 51357, 51373, 51375, 51390, 51465, 51470, 51485, 51493, 51499, 51500, 51508, 51518, 51530, 51534, 51538, 51550, 51556, 51568, 51604, 51611, 51620, 51628, 51644, 51658, 51693, 51705, 51717, 51761, 51794, 51797, 51814, 51830, 51865, 51884, 51889, 51894, 51946, 51980, 52038, 52055, 52059, 52067, 52068, 52071, 52078, 52096, 52098, 52107, 52123, 52125, 52135, 52167, 52189, 52213, 52240, 52241, 52243, 52245, 52248, 52250, 52252, 52255, 52257, 52259, 52262, 52264, 52269, 52270, 52271, 52280, 52284, 52286, 52289, 52291, 52294, 52296, 52298, 52300, 52302, 52303, 52305, 52308, 52310, 52312, 52313, 52314, 52317, 52319, 52323, 52326, 52329, 52331, 52335, 52338, 52343, 52350, 52355, 52359, 52362, 52365, 52367, 52374, 52383, 52389, 52390, 52394, 52398, 52403, 52412, 52413, 52417, 52418, 52429, 52438, 52442, 52453, 52461, 52466, 52475, 52476, 52489, 52491, 52504, 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 Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Bullock

Afterpiece Title: The Devil to Pay

Ballet: The Difference of Nations. As17330317

Performances

Mainpiece Title: She Woud And She Woud Not

Cast
Role: Philip Actor: Ryan

Dance: MMusette-LeSac, Miss Baston; Tambourine-Miss Rogers; Scotch Dance-Glover, Mrs Laguerre, LeSac, Miss Baston, Delagarde, Mrs Ogden

Performances

Mainpiece Title: She Woud And She Woud Not Or The Kind Imposter

Cast
Role: Philip Actor: Ryan

Afterpiece Title: The Mock Lawyer

Dance: As17331018

Performances

Mainpiece Title: She Woud And She Woud Not

Cast
Role: Philip Actor: Ryan

Afterpiece Title: The CountryHouse

Dance: As17331203 Also The Nassau, as17331112

Performances

Mainpiece Title: She Woud And She Woud Not

Cast
Role: Philip Actor: Ryan

Dance: Shepherd and Shepherdess by Maker and Mlle Salle. Scots Dance, as17331004. Pigmalion, as17340114

Performances

Mainpiece Title: She Woud And She Woud Not

Cast
Role: Philip Actor: Ryan

Afterpiece Title: The Lottery

Dance: Tambourine by Glover and Miss Rogers. Shepherd and Shepherdess by Malter and Mlle Salle. Scots Dance, as17331004

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Bardin

Afterpiece Title: The Chymical Counterfeits

Dance: As17341231

Performances

Mainpiece Title: She Woud And She Woud Not Or The Kind Impostor

Cast
Role: Philip Actor: Ryan

Afterpiece Title: The Toy Shop

Dance: As17350203

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Bardin

Afterpiece Title: Jupiter and Io

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Performances

Mainpiece Title: The Life And Death Of King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Bardin

Afterpiece Title: The Lovers Opera

Song: I: Italian Song-Miss Jones

Dance: II: By Desire of several Ladies of Quality, a new Ball Dance, Dedicated to the Princess of Wales, concluding with a Minuet-Vallois, Miss Oates; III: Clown-Vallois; IV: Two Pierrots-Vallois, Delagarde; V: French Peasant-Vallois, Miss Oates

Performances

Mainpiece Title: The Northern Lass

Cast
Role: Sir Philip Actor: Ryan

Afterpiece Title: The Dragon of Wantley

Performances

Mainpiece Title: The Northern Lass

Cast
Role: Sir Philip Actor: Ryan

Afterpiece Title: The Dragon of Wantley

Dance: As17380103

Performances

Mainpiece Title: The Squire Of Alsatia

Afterpiece Title: The Rival Queans With the odd Humours of little Alexander the Great

Cast
Role: Philip Actor: Marshall

Dance: I: Punch-Master Ferg; II: A new Sailor's Dance-Phillips; III: Dance of Turks-Muilment; End I Afterpiece: Pierrots-Pelling, Vallois; II: Drunken Peasant (for the Entertainment of Alexander)-Phillips; III: Flanderkins-Master Ferg, Miss Wright

Song: IV: See from the Silent Groves-Beard

Music: H$Handel's Water Musick-; with Preamble on the Kettle Drums-Woodbridge, his first appearance here

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Ware

Afterpiece Title: The Honest Yorkshireman

Performances

Mainpiece Title: She Woud And She Woud Not Or The Kind Impostor

Cast
Role: Philip Actor: Ryan

Afterpiece Title: The Devil to Pay

Dance: Richardson, Miss Cantrel; A new Comic Dance-Villeneuve, Miss Oates, Desse, Richardson, Miss Cantrel, Mrs LeBrun; Grand Ballet-Glover, Mlle Roland

Performances

Mainpiece Title: King John

Cast
Role: Philip King of France Actor: Ryan

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Macklin

Afterpiece Title: Colombine Courtezan

Dance: II: Moors Dance-Muilment, Mrs Walter; V: Grand Ballet-Denoyer, Mlle Roland

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Sir Philip Actor: Macklin

Afterpiece Title: The King and the Miller of Mansfield

Dance: II: Grand Aethiopian Dance-Muilment, Mrs Walter; V: Grand Ballet-Denoyer, Mlle Roland