SELECT * FROM london_stages WHERE eventid IN (22116, 24427, 24433, 24436, 24438, 24441, 24444, 24447, 24448, 24451, 24454, 24457, 24460, 24463, 24466, 24477, 24503, 24536, 24580, 24641, 24692, 27112, 27114, 27608, 27677, 27680, 27732, 27913, 27932, 27945, 27981, 28016, 28035, 28150, 28152, 28154, 28160, 28162, 28168, 28178, 28215, 28229, 28233, 28241, 28255, 28278, 28329, 28338, 28403, 28430, 28440, 28443, 28453, 28486, 28511, 28531, 28616, 28635, 28638, 28733, 28779, 28898, 28901, 28902, 28905, 28908, 28910, 28914, 28915, 28918, 28919, 28922, 28926, 28930, 28942, 28964, 28970, 29033, 29036, 29046, 29085, 29165, 29167, 29172, 29179, 29203, 29205, 29213, 29217, 29280, 29312, 29329, 29334, 29340, 29346, 29359, 29442, 29488, 29503, 29538, 29542, 29549, 29574, 29598, 29628, 29677, 29722, 29747, 29766, 29823, 29826, 29835, 29838, 29840, 29844, 29848, 29851, 29853, 29877, 29881, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29923, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30137, 30145, 30151, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30333, 30335, 30337, 30339, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30450, 30452, 30475, 30479, 30559, 30566, 30575, 30592, 30603, 30606, 30608, 30622, 30627, 30641, 30648, 30653, 30684, 30686, 30690, 30692, 30695, 30699, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30876, 30878, 30886, 30888, 30893, 30898, 30900, 30916, 30983, 31009, 31040, 31057, 31074, 31076, 31104, 31112, 31114, 31120, 31123, 31126, 31131, 31133, 31139, 31194, 31197, 31206, 31208, 31214, 31229, 31253, 31255, 31292, 31339, 31340, 31342, 31354, 31358, 31376, 31389, 31424, 31437, 31439, 31441, 31443, 31459, 31482, 31486, 31510, 31540, 31602, 31626, 31648, 31651, 31677, 31684, 31694, 31703, 31708, 31713, 31723, 31728, 31736, 31742, 31749, 31758, 31763, 31877, 31881, 31885, 31887, 31925, 31932, 31985, 32104, 32109, 32111, 32116, 32117, 32119, 32124, 32128, 32134, 32140, 32146, 32168, 32177, 32208, 32213, 32235, 32252, 32258, 32264, 32319, 32321, 32325, 32329, 32339, 32342, 32346, 32348, 32366, 32372, 32378, 32386, 32392, 32397, 32401, 32409, 32416, 32523, 32526, 32546, 32574, 32593, 32666, 32671, 32676, 32683, 32698, 32722, 32724, 32748, 32807, 32813, 32815, 32817, 32822, 32838, 32866, 32951, 32956, 33029, 33047, 33106, 33110, 33136, 33169, 33172, 33267, 33271, 33362, 33364, 33369, 33372, 33374, 33381, 33386, 33390, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33485, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33572, 33589, 33592, 33626, 33664, 33681, 33683, 33700, 33804, 33806, 33841, 33889, 33947, 33969, 34010, 34050, 34054, 34058, 34063, 34069, 34072, 34078, 34146, 34173, 34182, 34197, 34202, 34207, 34237, 34251, 34258, 34342, 34350, 34580, 34746, 34770, 34899, 34901, 34903, 34905, 34909, 34919, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34963, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35017, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35088, 35092, 35094, 35099, 35104, 35108, 35111, 35113, 35118, 35125, 35127, 35129, 35135, 35138, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35227, 35240, 35250, 35264, 35277, 35286, 35289, 35302, 35305, 35315, 35332, 35354, 35365, 35372, 35382, 35500, 35508, 35511, 35513, 35516, 35518, 35520, 35522, 35524, 35526, 35543, 35549, 35551, 35555, 35558, 35566, 35573, 35577, 35581, 35585, 35587, 35595, 35600, 35603, 35629, 35635, 35642, 35647, 35650, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35683, 35686, 35688, 35696, 35702, 35707, 35718, 35756, 35788, 35802, 35813, 35818, 35823, 35826, 35834, 35865, 35874, 35885, 35907, 35949, 35983, 36127, 36434, 36445, 36479, 36488, 36511, 36521, 36573, 36645, 36647, 36649, 36655, 36667, 36669, 36673, 36682, 36700, 36706, 36708, 36710, 36714, 36719, 36733, 36747, 36756, 36773, 36778, 36802, 36858, 36906, 36914, 36963, 37021, 37025, 37041, 37044, 37055, 37066, 37071, 37076, 37091, 37101, 37113, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37260, 37262, 37272, 37288, 37299, 37333, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37439, 37457, 37460, 37467, 37472, 37479, 37484, 37494, 37499, 37509, 37513, 37517, 37523, 37527, 37539, 37544, 37545, 37554, 37559, 37565, 37577, 37589, 37621, 37646, 37662, 38592, 38602, 38607, 38623, 38633, 38648, 38672, 39116, 39126, 40300, 40314, 40333, 40343, 40348, 46517, 46527, 46541, 46555, 46569, 46583, 47702, 47732) 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: Romeo And Juliet

Afterpiece Title: The Englishman in Paris

Song: I: A Song by Arne-Beard; II: The Anniversary Ode in Commemoration of Shakespeare, written by Havard, set to music by Dr Boyce,-Beard, Champnes

Performances

Mainpiece Title: Acis And Galatea

Cast
Role: Polyphemus Actor: Champnes

Music: First Violin-Brown; Second Violin-Froud; First Violoncello-Gordon; Harpsichord-Cooke; Between I and II: a Concerto on Hautboy-Vincent

Performances

Mainpiece Title: The Squire Of Alsatia

Afterpiece Title: Britannia

Dance: IV: A Minuet, Louvre-Noverre, Mrs Addison

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: Britannia

Dance: A Hornpipe-Harrison

Ballet: TThe Prussian Camp. As17580421 but Blakes_

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Lockit Actor: Champnes

Afterpiece Title: The Oracle

Dance: II: The Prussian Sailors, as17580601 End Opera: The Faggot Binders, as17580601

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The King and the Miller of Mansfield

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Chaplet

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Romeo And Juliet

Dance: TThe Millers, as17581012

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: A Duke and no Duke

Performances

Mainpiece Title: Macbeth

Cast
Role: Hecate Actor: Champness
Role: Hecate Actor: Champness
Role: The Vocal Part Actor: Beard, Champnes, Mrs Vernon.

Afterpiece Title: The Diversions of the Morning

Performances

Mainpiece Title: Comus

Cast
Role: Bacchanals Actor: Beard, Champnes

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Comus

Cast
Role: Bacchanals Actor: Beard, Champnes

Afterpiece Title: The Diversions of the Morning

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Queen Mab

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin Ranger

Ballet: II: The Prussian Camp. As17581214

Performances

Mainpiece Title: Antony And Cleopatra

Performances

Mainpiece Title: Antony And Cleopatra

Performances

Mainpiece Title: Antony And Cleopatra

Performances

Mainpiece Title: Antony And Cleopatra

Performances

Mainpiece Title: Antony And Cleopatra

Performances

Mainpiece Title: Macbeth

Cast
Role: Hecate Actor: Champness
Role: Hecate Actor: Champness
Role: The Vocal Part Actor: Beard, Champnes, Mrs Vernon.

Afterpiece Title: Fortunatus

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Miss in Her Teens

Entertainment: S+Specialty Anniversary Ode in Commemoration of Shakespeare set to music by Dr Boyce; The Vocal Parts-Champnes, Beard

Performances

Mainpiece Title: Comus

Cast
Role: Bacchanals Actor: Beard, Champnes

Afterpiece Title: The Guardian

Performances

Mainpiece Title: Oncerto Spirituale