SELECT * FROM london_stages WHERE eventid IN (234, 950, 1160, 20203, 20555, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30068, 30081, 30114, 30145, 30151, 41116, 41129, 41436, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 42187, 42194, 42198, 42222, 42226, 42227, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42405, 42456, 42469, 42476, 42517, 42558, 42565, 42580, 42711, 42759, 42764, 42766, 42767, 42770, 42772, 42780, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42817, 42818, 42829, 42831, 42833, 42834, 42835, 42837, 42841, 42843, 42847, 42849, 42923, 42925, 42929, 42931, 42933, 42937, 42951, 42957, 42962, 42964, 42967, 42969, 42971, 42976, 42985, 42990, 43000, 43009, 43011, 43021, 43223, 43228, 43259, 43262, 43271, 43273, 43276, 43287, 43309, 43371, 43380, 43390, 43398, 43399, 43402, 43407, 43415, 43420, 43423, 43461, 43503, 43617, 43632, 43635, 43637, 43640, 43646, 43650, 43655, 43663, 43667, 43701, 43706, 43717, 43817, 43853, 43877, 44034, 44047, 44055, 44062, 44065, 44069, 44075, 44084, 44088, 44096, 44102, 44126, 44128, 44148, 44160, 44166, 44169, 44171, 44207, 44232, 44248, 44264, 44283, 44292, 44302, 44305, 44308, 44368, 44371, 44401, 44453, 44592, 44626, 44627, 44629, 44631, 44633, 44635, 44637, 44642, 44644, 44646, 44651, 44663, 44665, 44667, 44669, 44675, 44687, 44689, 44693, 44699, 44704, 44720, 44730, 44736, 44745, 44749, 44751, 44754, 44756, 44759, 44761, 44763, 44765, 44768, 44770, 44773, 44775, 44777, 44779, 44784, 44786, 44793, 44795, 44802, 44809, 44812, 44816, 44818, 44823, 44827, 44830, 44833, 44835, 44843, 44848, 44856, 44862, 44866, 44873, 44886, 44896, 44908, 44912, 44916, 44928, 44956, 44958, 44972, 44974, 44979, 44982, 44985, 44991, 44994, 45012, 45021, 45036, 45136, 45140, 45144, 45149, 45165, 45177, 45181, 45185, 45189, 45199, 45203, 45205, 45207, 45211, 45215, 45217, 45221, 45223, 45225, 45229, 45231, 45233, 45235, 45241, 45259, 45265, 45275, 45277, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45327, 45329, 45334, 45341, 45343, 45364, 45371, 45377, 45383, 45409, 45411, 45439, 45441, 45450, 45458, 45460, 45468, 45476, 45479, 45489, 45518, 45543, 45556, 45568, 45581, 45586, 45590, 45592, 45594, 45596, 45599, 45603, 45691, 45705, 45707, 45747, 45782, 45790, 45806, 45808, 45816, 45834, 45837, 45843, 45849, 45851, 45855, 45861, 45868, 45870, 45875, 45877, 45882, 45884, 45896, 45898, 45908, 45938, 45941, 45943, 46117, 46136, 46159, 46260, 46293, 46306, 46318, 46362, 46376, 46378, 46494, 46496, 46510, 46528, 46535, 46556, 46579, 46606, 46613, 46648, 46707, 46715, 46831, 46840, 46859, 46980, 46988, 46996, 47010, 47020, 47072, 47111, 47121, 47125, 47136, 47141, 47149, 47153, 47158, 47170, 47176, 47189, 47195, 47211, 47223, 47246, 47254, 47303, 50937, 50944, 50965, 50971, 50979, 50983, 50993, 50995, 51052, 51054, 51064, 51067, 51076, 51090, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51128, 51130, 51138, 51142, 51156, 51203) 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 Country Girl

Cast
Role: Footman Actor: Spencer

Afterpiece Title: The Devil to Pay

Dance: As17900210

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: The Humourist

Cast
Role: Servant Actor: Spencer

Dance: As17891121

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The First Floor

Cast
Role: Frank Actor: Spencer

Dance: End III: Hornpipe-Whittow; End: Minuet de la Cour-Mr and Mrs Brigg; in which Codrile-; to conclude with a Scotch Reel-Whittow

Performances

Mainpiece Title: The Country Girl

Cast
Role: Footman Actor: Spencer

Afterpiece Title: The Liar

Performances

Mainpiece Title: The Country Girl

Cast
Role: Footman Actor: Spencer

Afterpiece Title: The Sultan or A Peep into the Seraglio

Dance: In afterpiece: Grand Dance-Hamoir, Miss Blanchet

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: The Citizen

Cast
Role: Will Actor: Spencer

Performances

Mainpiece Title: The Country Girl

Cast
Role: Footman Actor: Spencer

Afterpiece Title: The Fairy Favour

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Citizen

Cast
Role: Will Actor: Spencer

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Apprentice

Cast
Role: Spouters Actor: Spencer, Haymes, Webb, Lyons

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Citizen

Cast
Role: Will Actor: Spencer

Performances

Mainpiece Title: The Country Girl

Cast
Role: Footman Actor: Spencer

Afterpiece Title: The Fairy Favour

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The Citizen

Cast
Role: Will Actor: Spencer

Performances

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

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Grand Selection 2

Cast
Role: Actor: Spence

Afterpiece Title: Grand Selection 3

Cast
Role: O come let us worship Actor: Spence

Performances

Mainpiece Title: The Messiah Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Performances

Mainpiece Title: Judas Maccabaeus Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Performances

Mainpiece Title: Redemption Selected From The Great And Favourite Works Of handel That Were Performed In westminster abbey And At The pantheon on 26 And 27 May 1784 0 Messiah Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Cast
Role: Lord remember David Actor: Spence

Afterpiece Title: Redemption 3

Music: End: concerto on the hautboy-W. Parke; End II: concerto violin-Master Clement

Performances

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

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Grand Selection 1

Cast
Role: Actor: Spence
Role: O come let us worship Actor: Spence

Afterpiece Title: Grand Selection 2

Cast
Role: Actor: Spence
Role: O come let us worship Actor: Spence

Afterpiece Title: Grand Selection 3

Cast
Role: Actor: Spence
Role: O come let us worship Actor: Spence

Performances

Mainpiece Title: The Country Girl

Cast
Role: Footman Actor: Spencer

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: Redemption 0 Messiah Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End I: concerto on the bassoon-Parkinson; End II: concerto violin-Master Clement

Performances

Mainpiece Title: Acis And Galatea 0 Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Acis and Galatea 1

Cast
Role: Where shall I seek Actor: Spence

Afterpiece Title: Acis and Galatea 2

Cast
Role: Help Galatea Actor: Spence

Afterpiece Title: PART III

Music: As17910323

Performances

Mainpiece Title: The Messiah

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Song: End I: Da forte morir sapro-Miss Davies (Sarti)

Music: End II: concerto violin-Master Clement

Performances

Mainpiece Title: Redemption 0 Messiah Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17910330

Performances

Mainpiece Title: Israel In Egypt Messiah Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: A New Selection

Performances

Mainpiece Title: Redemption 0 Grand Selection 0

Cast
Role: Principal Vocal Parts Actor: Spence
Role: Total Eclipse Actor: Spence

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: End II: Da forte morir sapro-Miss Davies (Sarti)

Music: End I: concerto violin-Master Clement

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Citizen

Cast
Role: Will Actor: Spencer

Dance: End I: The Russian Minuet-Master D'Egville, Miss DeCamp

Song: As17901027