SELECT * FROM london_stages WHERE eventid IN (34797, 34803, 34814, 34819, 34821, 34823, 34824, 34826, 34828, 34832, 34837, 34850, 34852, 34853, 34854, 34861, 34873, 34876, 34878, 34880, 34885, 35347, 35359, 35364, 35376, 35380, 35387, 35393, 35397, 35400, 35403, 35416, 35421, 35426, 35429, 35434, 35436, 35438, 35440, 35443, 35446, 35448, 35452, 35454, 35460, 35462, 35464, 35468, 35470, 35471, 35477, 35480, 35484, 35486, 35492, 35505, 35959, 35966, 35969, 35975, 35979, 35988, 35993, 35996, 35999, 36001, 36004, 36006, 36008, 36010, 36012, 36014, 36016, 36019, 36024, 36027, 36029, 36031, 36035, 36043, 36047, 36049, 36051, 36053, 36055, 36059, 36062, 36066, 36068, 36072, 36078, 36081, 36088, 36093, 36099, 36102, 36103, 36106, 36591, 38640, 38643, 38989, 38994, 38996, 38999, 39001, 39007, 39025, 39029, 39031, 39050, 39055, 39061, 39075, 39079, 39087, 39089, 39103, 39110, 39115, 39138, 39152, 39161, 39164, 39178, 39188, 39194, 39214, 39246, 39258, 39299, 39316, 39473, 39475, 39479, 39483, 39485, 39492, 39494, 39496, 39498, 39507, 39512, 39517, 39528, 39531, 39533, 39535, 39537, 39540, 39545, 39549, 39551, 39556, 39559, 39561, 39565, 39568, 39577, 39579, 39582, 39584, 39587, 39589, 39598, 39604, 39626, 39628, 39642, 39658, 39738, 39748, 39752, 39762, 39767, 39779, 39784, 39795, 39800, 39810, 39816, 39848, 39850, 39862, 39867, 39872, 39874, 39876, 39881, 39884, 39887, 39895, 40015, 40017, 40020, 40021, 40022, 40023, 40024, 40025, 40028, 40030, 40032, 40034, 40036, 40038, 40044, 40046, 40051, 40053, 40057, 40067, 40069, 40071, 40075, 40077, 40079, 40081, 40089, 40091, 40095, 40097, 40107, 40112, 40114, 40116, 40118, 40121, 40123, 40126, 40130, 40131, 40135, 40140, 40144, 40146, 40154, 40158, 40160, 40163, 40165, 40179, 40181, 40183, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40231, 40257, 40270, 40282, 40316, 40350, 40358, 40360, 40362, 40372, 40379, 40382, 40384, 40387, 40389, 40396, 40403, 40408, 40413, 40416, 40422, 40444, 42992, 43156) 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: Acis And Galatea Prodigal Son

Afterpiece Title: A Miscellaneous Concert

Cast
Role: Dr Arne Actor: Mrs Farrell

Song: In I: song by Dr Arne, as17770314

Music: solo on the violoncello-Cervetto; concerto on the violin, as17770214

Performances

Mainpiece Title: Acis And Galatea Prodigal Son

Afterpiece Title: A Miscellaneous Concert

Cast
Role: Dr Arne Actor: Mrs Farrell

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Three Weeks after Marriage

Dance: As17761107

Performances

Mainpiece Title: Artaxerxes

Cast
Role: Artaxerxes Actor: Mrs Farrell
Role: with a new air Actor: Mrs Farrell

Afterpiece Title: Three Weeks after Marriage

Dance: As17770218

Performances

Mainpiece Title: Caractacus

Afterpiece Title: The Royal Chace or Harlequin Skeleton

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequins Frolicks

Dance: As17770121

Performances

Mainpiece Title: The Tempest

Cast
Role: Ariel Actor: Mrs Farrell.

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: The Commissary

Dance: End: As17771008; III: a Hornpipe-Miss Besford

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: Cross Purposes

Dance: Hornpipe, as17771017; End: As17771001

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: The Reprisal

Dance: Hornpipe, as17771017; End II: As17771021

Song: As17771021

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: The Apprentice

Dance: Hornpipe, as17771017; End II: As17771008

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: The Reprisal

Dance: Hornpipe, as17771017; End II: As17771021

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Comus

Cast
Role: Euphrosyne Actor: Mrs Farrell

Song: Afterpiece: Sweet Echo-Leoni, Mrs Farrell. [This was sung, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: The Reprisal

Dance: Hornpipe, as17771017

Performances

Mainpiece Title: Othello

Afterpiece Title: Comus

Cast
Role: Euphrosyne Actor: Mrs Farrell

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: St

Dance: Hornpipe, as17771017; End II: La Soiree a@la@Mode-Dagueville, Harris, Master Holland, Sga Tinte

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Comus

Cast
Role: Euphrosyne Actor: Mrs Farrell

Performances

Mainpiece Title: King Lear

Afterpiece Title: Comus

Cast
Role: Euphrosyne Actor: Mrs Farrell

Performances

Mainpiece Title: The Beggars Opera

Cast
Role: Macheath Actor: Mrs Farrell

Afterpiece Title: Three Weeks after Marriage

Dance: Hornpipe, as17771017; End: As17771111

Performances

Mainpiece Title: Love Finds The Way

Cast
Role: Bellford Actor: Mrs Farrell

Afterpiece Title: The Upholsterer

Dance: End II: The Minuet de la Cour, as17771111; End: The Enchantress, as17771104

Performances

Mainpiece Title: Love Finds The Way

Cast
Role: Bellford Actor: Mrs Farrell

Afterpiece Title: Catherine and Petruchio

Dance: End II: As17771111; End: The Humours of Leixlip, as17771008

Performances

Mainpiece Title: Love Finds The Way

Cast
Role: Bellford Actor: Mrs Farrell

Afterpiece Title: The Citizen

Dance: As17771111

Performances

Mainpiece Title: Love Finds The Way

Cast
Role: Bellford Actor: Mrs Farrell

Afterpiece Title: The Englishman in Paris

Dance: End: As17771111; In afterpiece: Minuet-Dagueville, Mrs Mattocks

Performances

Mainpiece Title: Love Finds The Way

Cast
Role: Bellford Actor: Mrs Farrell

Afterpiece Title: Three Weeks after Marriage

Dance: As17771111

Performances

Mainpiece Title: Love Finds The Way

Cast
Role: Bellford Actor: Mrs Farrell

Afterpiece Title: Catherine and Petruchio

Dance: As17771111