The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (9192, 12714, 14775, 14924, 15569, 18662, 19561, 19765, 19774, 19807, 19822, 19976, 20513, 20545, 20599, 21705, 21729, 22158, 22699, 22740, 22754, 23213, 23263, 23781, 23819, 24675, 25245, 25920, 25934, 25947, 25966, 25973, 26163, 28597, 28598, 28601, 28608, 28612, 28632, 28637, 28640, 28650, 28933, 29973, 29977, 30262, 31265, 31710, 36361, 36464, 36484, 36877, 36929, 36962, 37963, 37965, 37968, 37970, 37972, 37974, 37976, 37978, 37981, 37986, 37988, 37990, 37999, 38004, 38022, 38031, 38038, 38048, 38051, 38057, 38061, 38066, 38068, 38092, 38098, 38106, 38129, 38144, 38152, 38159, 38161, 46000, 46009, 46026, 46527, 46531, 46541, 46554, 46555, 46568, 46569, 46573, 46582, 46583, 46588, 47111, 47112, 47126, 47137, 47141, 47154, 47159, 47171, 47196, 47702, 47712, 47717, 47732, 47741, 47742, 47747, 47756, 47757, 47777, 48231, 48255, 48269, 48273, 48282, 48283, 48297, 48301, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49432, 49439, 49446, 49452, 49460, 49465, 49473, 49515, 50021, 50024, 50033, 50036, 50059, 51189, 51204, 51213, 51229, 51711, 51723, 51757, 51772, 52324, 52333, 52357) 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: An Entertainment Of Music

Cast
Role: Concerto Actor: Pasqualino
Role: Concerto Actor: Carbonelli
Role: Concerto Actor: Miller
Role: Concerto Actor: Vincent
Role: A Grand Concerto of Handel's Actor: .

Performances

Mainpiece Title: Entertainment Of Vocal And Instrumental Music

Cast
Role: Concerto Actor: Pasqualino
Role: Concerto Actor: Dubourg
Role: Concerto Actor: Miller
Role: Concerto Actor: Vincent

Performances

Mainpiece Title: The Old Woman's Oratory 1

Afterpiece Title: Old Woman's Oratory 2

Cast
Role: a Trumpet Concerto Actor:

Afterpiece Title: Old Woman's Oratory 3

Performances

Mainpiece Title: The Old Woman's Oratory 1

Afterpiece Title: Old Woman's Oratory 2

Afterpiece Title: Old Woman's Oratory 3

Performances

Mainpiece Title: The Old Woman's Oratory 1

Afterpiece Title: Old Woman's Oratory 2

Afterpiece Title: Old Woman's Oratory 3

Cast
Role: A French Horn Concerto Actor: .

Performances

Mainpiece Title: The Old Woman's Oratory 1

Afterpiece Title: Old Woman's Oratory 2

Afterpiece Title: Old Woman's Oratory 3

Cast
Role: A French Horn Concerto Actor:

Performances

Mainpiece Title: The Old Woman's Oratory 1

Afterpiece Title: Old Woman's Oratory 2

Cast
Role: A French Horn Concerto Actor:

Afterpiece Title: Old Woman's Oratory 3

Cast
Role: A French Horn Concerto Actor:

Performances

Mainpiece Title: Mrs Midnight Will Give Caudle

Performances

Mainpiece Title: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Dance: End: As17570819

Performances

Mainpiece Title: A Medley Concert; Or, An Impromptu Of Whim And Novelty

Cast
Role: A Concerto for French Horns Actor:

Afterpiece Title: With a Lilliputian Pantomime call'dHarlequin's Frolic; or, A Voyage to Prussia

Performances

Mainpiece Title: A Medley Concert

Cast
Role: A Concerto for French Horns Actor:

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: A Medley Concert

Cast
Role: A Concerto for French Horns Actor:

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: An Impromptu Faragolio

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: An Impromptu Faragolio

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: An Impromptu Faragolio

Cast
Role: A Concerto for French Horns Actor:

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: An Impromptu Faragolio

Cast
Role: A Concerto for French Horns Actor:

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: An Impromptu Faragolio

Cast
Role: A Concerto for French Horns Actor:

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: Concerto Spirituale

Performances

Mainpiece Title: Charlottenburg Festegiante

Music: Instrumental parts: First Violin-Passerini;, with viols and the others by the best performers. Between the First and Second Part: a Concerto on the Organ-Sga Frederick

Performances

Mainpiece Title: The Universal Prayer

Performances

Mainpiece Title: A Concert

Afterpiece Title: Britannia's Triumph

Performances

Mainpiece Title: Concert Of Vocal And Instrumental Music

Cast
Role: Concerto Bassoon Actor: Miller
Role: Concerto violincello Actor:
Role: Concerto Hautboy Actor: Simpson
Role: Concerto violin Actor:

Performances

Mainpiece Title: Concert Of Vocal And Instrumental Music

Performances

Mainpiece Title: Concerto Spirituale