SELECT * FROM london_stages WHERE eventid IN (1136, 2211, 8298, 13384, 15576, 15596, 17827, 17831, 17833, 17841, 17845, 17850, 17855, 17860, 17873, 17883, 17890, 17946, 17953, 18773, 19157, 22240, 23867, 26895, 26900, 27177, 28048, 28627, 31824, 36464, 37774, 37778, 37781, 37783, 37785, 37787, 37790, 37793, 37797, 37803, 37805, 37809, 37821, 37825, 37827, 37829, 37831, 37833, 37835, 37839, 37841, 37852, 37856, 37860, 37864, 37870, 37874, 37882, 37887, 37893, 37902, 37905, 37911, 37925, 37930, 37935, 37937, 37941, 37943, 37947, 37949, 37962, 37982, 37996, 38045, 38050, 38053, 38091, 38097, 38107, 38123, 38153, 38158, 38160, 38167, 38172, 38183, 38202, 38227, 38233, 38311, 41285, 41287, 41290, 41292, 41295, 41297, 41299, 41301, 41304, 41306, 41309, 41311, 41313, 41315, 41318, 41320, 41323, 41325, 41327, 41329, 41332, 41335, 41338, 41340, 41342, 41344, 41347, 41350, 41352, 41354, 41356, 41359, 41361, 41369, 41374, 41383, 41385, 41388, 41408, 41415, 41417, 41428, 41441, 41445, 41451, 41461, 41466, 41480, 41489, 41525, 41554, 41576, 43993, 45973, 45995, 46013, 46025, 46526, 46527, 46530, 46540, 46555, 46558, 46587, 46588, 46687, 47111, 47112, 47121, 47125, 47136, 47137, 47141, 47153, 47158, 47159, 47170, 47176, 47189, 47195, 47701, 47726, 47732, 47746, 47771, 47912, 47914, 47915, 47916, 47917, 47919, 47920, 47923, 47925, 47929, 47931, 47933, 47934, 47935, 47936, 47940, 47942, 47945, 47948, 47950, 47954, 47957, 47961, 47962, 47963, 47965, 47966, 47967, 47968, 47969, 47971, 47972, 47973, 47974, 47975, 47976, 47978, 47979, 47980, 47981, 47983, 47984, 47985, 47986, 47987, 47991, 48230, 48244, 48269, 48273, 48283, 48286, 48301, 48616, 48632, 48676, 48678, 48686, 48690, 49032, 49111, 49123, 49126, 49127, 49128, 49130, 49134, 49136, 49138, 49140, 49141, 49142, 49143, 49144, 49145, 49146, 49148, 49149, 49150, 49151, 49152, 49155, 49156, 49157, 49158, 49162, 49165, 49166, 49168, 49169, 49170, 49171, 49172, 49174, 49175, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49486, 49594, 49612, 49635, 49640, 49650, 49655, 49662, 49667, 50024, 50036, 50633, 50682, 51213, 51311, 51723) 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: Heigho For A Husband

Afterpiece Title: MY GRANDMOTHER

Cast
Role: ParsonsKate Actor: Miss Heard
Role: ParsonsDiana Actor: Miss Heard

Afterpiece Title: THE PURSE

Cast
Role: ParsonsKate Actor: Miss Heard

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: THE SON-IN-LAW

Cast
Role: ParsonsKate Actor: Miss Heard
Role: ParsonsIrene Actor: Miss De Camp

Performances

Mainpiece Title: The Liar

Afterpiece Title: PEEPING TOM

Cast
Role: ParsonsKate Actor: Miss Heard

Afterpiece Title: MY GRANDMOTHER

Cast
Role: ParsonsKate Actor: Miss Heard
Role: ParsonsDiana Actor: Miss Heard

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Ye sons of Israel Actor: Chorus

Music: 6th concerto of Giordani on the violin-C. Ashley

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: The Tythe Pig

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: The Tythe Pig

Afterpiece Title: The Irish Mimick

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Rosina

Afterpiece Title: The Tythe Pig

Performances

Mainpiece Title: The Secret Tribunal

Afterpiece Title: The Irish Mimick

Afterpiece Title: The Tythe Pig

Performances

Mainpiece Title: The Secret Tribunal

Afterpiece Title: The Poor Sailor

Afterpiece Title: The Tythe Pig

Dance: In 2nd piece: Double Hornpipe, as17950529

Performances

Mainpiece Title: The Secret Tribunal

Afterpiece Title: The Poor Sailor

Afterpiece Title: The Tythe Pig

Dance: As17950609

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: The Poor Sailor

Afterpiece Title: The Tythe Pig

Dance: As17950609

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Poor Sailor

Dance: Afterpiece: With a Treble Hornpipe-Ratchford, King, Mrs Ratchford

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Ye sons of Israel Actor: byChorus

Music: As17960219

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Cast
Role: Ye sons of Israel Actor: byChorus

Afterpiece Title: Grand Selection 2

Cast
Role: Ye sons of Israel Actor: byChorus

Afterpiece Title: Grand Selection 3

Cast
Role: Ye sons of Israel Actor: byChorus

Music: End Part I: concerto on the violin-G. Ashley; End Part II: concerto on the Grand Piano Forte-Miss M'Arthur

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Cast
Role: Ye Sons of Israel Actor: Chorus

Afterpiece Title: A Grand Sacred Selection 3

Music: End I: concerto on pedal harp-Miss Dupree (1st appearance in public)

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Cast
Role: Ye Sons of Israel Actor: Chorus

Afterpiece Title: A Grand Sacred Selection 2

Cast
Role: Ye Sons of Israel Actor: Chorus

Afterpiece Title: A Grand Sacred Selection 3

Cast
Role: Ye Sons of Israel Actor: Chorus

Music: End II: concerto on Piano Forte-Miss MacArthur

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Ye sons of Israel Actor: Chorus

Music: End I: concerto on the violoncello-C. Ashley; End II: concerto= on the Piano Forte-Dussek

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Blue-Beard

Ballet: End II: the Grand Anacreontic Ballet, Bacchus et Ariadne. Bacchus-Laborie; Ariadne-Mme Lombard Laborie; Theseus-St. Pierre; Phedra-Miss D'Egville; Silenus-Blake; Cupid-Master Menage; Hymen-Miss Denys; Chief Persons of the Train of Bacchus representing Divinities of Olympus-Didelot, Mme Hilligsberg, Miss J. Hilligsberg; Deities of the Olympus, with a Grand Procession of Bacchanals, Bacchants, Nymphs, Satyrs, Fauns-The whole Corps de Ballet from the Opera House; the celebrated Pas de Quatre from Panurge-Didelot, Laborie, Mme Laborie, Mme Hilligsberg

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Ye sons of Israel Actor: Chorus

Music: End II: Bach's concertante for violin oboe viola and violoncello-Messrs [G., R. and C.] Ashley, W. Parke