SELECT * FROM london_stages WHERE eventid IN (44953, 44993, 46517, 46527, 46531, 46541, 46555, 46569, 46573, 46583, 46588, 47112, 47122, 47126, 47137, 47142, 47154, 47159, 47171, 47177, 47190, 47196, 48230, 48240, 48244, 48254, 48268, 48272, 48282, 48286, 48296, 48563, 48569, 48575, 48581, 48583, 48603, 48611, 48613, 48623, 48631, 48647, 48657, 48667, 48679, 48684, 48687, 48692, 48694, 48699, 48715, 48735, 48737, 48739, 48787, 48789, 48812, 48824, 48826, 48832, 48872, 48874, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48918, 48923, 48927, 48945, 48961, 48986, 48988, 48993, 48995, 49000, 49002, 49004, 49007, 49009, 49014, 49018, 49021, 49023, 49033, 49038, 49041, 49043, 49048, 49053, 49056, 49058, 49061, 49066, 49069, 49077, 49081, 49083, 49092, 49100, 49195, 49197, 49199, 49208, 49211, 49214, 49240, 49256, 49266, 49459, 49469, 49473, 49565, 49630, 49650, 49655, 49662, 49667, 50621, 50633, 50642, 50645, 50654, 50657, 50666, 50669, 50678, 50682, 51105, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51684, 51769, 51772, 51787, 51803, 51806, 51813, 51828, 51833, 51841, 51843, 51859, 51861, 51869, 51885, 51900, 51914, 51927, 51929) 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: La Vestale; O Sia, L'amore Protetto Dal Cielo

Dance: End I: Divertissement, as17870428; End Opera: Sylvie, as17870322but Mlle _Mozon

Performances

Mainpiece Title: La Vestale

Dance: End I: Divertissement, as17870428; End Opera: Le Cossac Jaloux-Mme Perignon, Goyon, Laborie, Henry, Mlle R. Simonet

Performances

Mainpiece Title: The Messiah, Preceded By god Save The King(coronation Anthems)

Music: End II: a concerto on the violin-Mme Gautherot (from Paris)

Performances

Mainpiece Title: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Happy Iphis Actor: Miss Poole
Role: Ye Men of Gaza Actor: Miss Poole

Afterpiece Title: Grand Selection 2

Music: As17900224

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Music: End II: As17900219; End I: Miserere Mei Deus-, composed by Sg Gregorio Allegri, in the Year 1650, from an authentic Copy brought from Italy by Greatorex. A Translation of this Work (the 51st Psalm in English) will be printed in the Books of the Night

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Music: End II: As17900224; End Part I: Miserere Mei Deus, as17900317

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Happy Iphis Actor: Miss Poole

Afterpiece Title: Grand Selection 2

Cast
Role: Ye Men of Gaza Actor: Miss Poole

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grandselection 0

Performances

Mainpiece Title: L'allegro Ed Il Penseroso; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Cast
Role: Praise the Lord Actor: Miss Poole

Performances

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

Afterpiece Title: Grand Selection 2

Cast
Role: The smiling dawn Actor: Miss Poole

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: The First Act Of Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Cast
Role: Praise the Lord Actor: Miss Poole

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Cast
Role: He was despised Actor: Miss Poole
Role: How beautiful Actor: Miss Leak

Afterpiece Title: The Messiah 3

Cast
Role: Death Actor: Miss Leak, Harrison
Role: If God be for us Actor: Miss Poole

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek