SELECT * FROM london_stages WHERE eventid IN (1959, 15884, 15891, 15899, 15906, 15910, 15964, 16004, 16008, 16012, 16016, 16021, 16049, 16054, 16058, 16070, 16097, 16101, 16107, 16114, 16118, 16129, 16135, 16394, 16661, 16665, 16668, 16673, 16678, 16697, 16725, 17284, 19510, 19516, 19520, 19527, 19534, 19536, 19538, 19556, 19562, 19576, 19590, 19595, 19611, 19646, 19648, 19650, 19653, 19656, 19658, 19659, 19663, 19683, 19685, 19713, 19715, 19741, 19793, 19795, 19798, 19845, 19847, 19878, 19881, 19883, 20002, 20012, 20053, 20067, 20102, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20359, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20917, 20928, 20937, 20948, 20951, 20960, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21103, 21119, 21172, 21184, 22754, 25654, 26588, 27510, 44829, 45995, 46000, 46009, 46025, 46526, 46530, 46540, 46558, 46568, 46569, 46582, 46587, 46588, 47111, 47136, 47141, 47153, 47176, 47195, 47196, 47701, 47741, 47746, 47756, 47771, 47776, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48240, 48244, 48269, 48273, 48283, 48301, 49486, 50059, 50633, 50654, 50682, 51192, 51213, 51711, 51748, 51757, 51772) 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 Road To Ruin

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: The Distrest Mother

Dance: As17921226

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: The Road To Ruin

Dance: As17921226

Performances

Mainpiece Title: Columbus

Dance: As17921226

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Cast
Role: But who may abide Actor: Bellamy
Role: Glory to God Actor: Chorus

Afterpiece Title: The Messiah 2

Cast
Role: He trusted in God Actor: Chorus

Afterpiece Title: The Messiah 3

Cast
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

Cast
Role: God save the King Actor: Chorus.

Afterpiece Title: Redemption 3

Song: As17930220

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

Performances

Mainpiece Title: A Grand Selection 0 Of Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: In Part III: Captivity-Mrs Crouch [, as17930220

Music: End Part I: concerto on the violoncello-C. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: Sixth concerto of Geminiani on the violin-G. Ashley

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

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

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

Music: End Part I: concerto on the Piano Forte-Miss M'Arthur; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Cast
Role: Who is in her Seventy Actor:

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

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 Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Cast
Role: Who is in her Seventy Actor:

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: End I: concerto on the oboe-W. Parke; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Cast
Role: Who is in her Seventy Actor:

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Afterpiece Title: A Grand Sacred Selection 3

Cast
Role: God save the King Actor: .
Role: Return O God of Hosts Actor: Sga Galli

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

Performances

Mainpiece Title: Acis And Galatea 0

Afterpiece Title: Acis and Galatea 3 [i

Music: End I: serenata concerto on violin-G. Ashley; End II: a new concerto, with a military rondo, on the Grand Piano Forte-Dussek

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

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

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: O God who in Actor: Chorus

Performances

Mainpiece Title: Grand Selection 0 Of Music, From The Works Of handel, boyce, arne, And purcell

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: O God of hosts Actor: Miss Waters
Role: Glory to God Actor: Incledon

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violoncello-Charles Ashley

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: O God who in Actor: Chorus

Afterpiece Title: Grand Selection 2

Cast
Role: O God who in Actor: Chorus

Afterpiece Title: Grand Selection 3

Cast
Role: O God who in Actor: Chorus

Music: End II: the favourite Military Concerto on the Grand Piano Forte-Dussek

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17990215