SELECT * FROM london_stages WHERE eventid IN (500, 898, 904, 1037, 1075, 1224, 1857, 1945, 2029, 2249, 3054, 7529, 10232, 14711, 14734, 15156, 15161, 15164, 15169, 15173, 15176, 15180, 15184, 15230, 15233, 15236, 15240, 15245, 15249, 19542, 20090, 20778, 20781, 21057, 21196, 21273, 22797, 24296, 24300, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 24333, 24597, 24610, 24613, 24624, 24669, 24674, 24677, 24894, 24896, 24909, 25042, 25044, 25049, 25061, 25096, 25237, 25364, 25563, 25592, 25595, 25597, 25601, 25604, 25607, 25609, 25618, 25660, 25686, 25806, 25808, 25810, 25816, 25825, 25846, 25859, 25867, 25891, 26284, 26287, 26303, 26312, 26318, 26321, 26324, 26327, 26351, 26355, 26356, 26599, 27199, 27203, 27238, 27240, 27249, 27254, 27259, 27260, 27264, 27269, 27278, 27283, 27297, 27310, 27313, 27315, 27318, 27319, 27328, 27335, 27412, 27422, 27524, 27542, 27600, 27621, 27765, 27798, 28054, 28059, 28229, 28233, 28241, 28255, 28534, 28536, 28545, 28547, 28552, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 30813, 30827, 30833, 30897, 31152, 31163, 31221, 31231, 31382, 31441, 31908, 32004, 32156, 32209, 32261, 32857, 33101, 33173, 33321, 33326, 33331, 33716, 34937, 35085, 35134, 35179, 35379, 36163, 36473, 36649, 36653, 36688, 36696, 36704, 36717, 36752, 36764, 36773, 36806, 37068, 37296, 37301, 37448, 37505, 37587, 37656, 39560, 42517, 43406, 43410, 43411, 43417, 43426, 43909, 43916, 43946, 43953, 43984, 43999, 44016, 44493, 45973, 46013, 46569, 46588, 47171, 47218, 47295, 47741, 47756, 48175, 48231, 48255, 48283, 48301, 48971, 49091, 49446, 49473, 49515, 49645, 50024, 50036, 50530, 50813, 51213, 52333) 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: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: Hunt the Slipper

Performances

Mainpiece Title: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: Hunt the Slipper

Dance: As17840713

Performances

Mainpiece Title: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: Two To One

Afterpiece Title: The Son-in-Law

Cast
Role: Charles the Second Actor: Aickin

Dance: As17850601

Performances

Mainpiece Title: The Separate Maintenance

Afterpiece Title: The Son-in-Law

Cast
Role: Charles the Second Actor: Aickin

Dance: End of mainpiece La Giardinier Italiene by Master and Miss Michel (their 1st appearance in this Kingdom)

Song: As17850607

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Son-in-Law

Cast
Role: Charles the Second Actor: Aickin

Dance: End of Act I of mainpiece The Merry Lasses [performers not listed, but see17850623; End of Act III Dance by Giorgi's Scholars

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: Harlequin Teague

Performances

Mainpiece Title: I'll Tell You What

Afterpiece Title: The Son-in-Law

Cast
Role: Charles the Second Actor: Aickin

Performances

Mainpiece Title: I'll Tell You What

Afterpiece Title: The Son-in-Law

Cast
Role: Charles the Second Actor: Aickin

Performances

Mainpiece Title: Lord Russel

Cast
Role: Charles the Second Actor: Aickin

Afterpiece Title: The Widow's Vow

Dance: End of mainpiece How sweet's the Love that meets Return by Byrn, Mrs Goodwin, the two Miss Simonets

Performances

Mainpiece Title: A Grand Selection 0 [of Sacred Music From The Works Of handel, Chiefly Performed At westminster-abbey At The handel Commemoration, 26 May 1784]; Messiah

Afterpiece Title: The Coronation Anthem, God save the King

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Second Hautboy Concerto Actor:

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violin-Mme Gautherot

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Cast
Role: Second Hautboy Concerto Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

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: Second Hautboy Concerto Actor:

Music: As17910330

Performances

Mainpiece Title: The Brothers

Afterpiece Title: Alexander the Little; or, The Rival Queans

Dance: End: The Jockies-Ratchford, Platt, Jackson, Mrs Goodwin

Song: End II: song-Incledon; Afterpiece: The Tragedy will be interspersed with Airs, Duets, Glees, composed by Arne, Arnold, Fischer, Dibdin, with a Grand Overture(A Finale, composed by Shield), Triumphal Entry of Alexander-

Performances

Mainpiece Title: The Chances

Cast
Role: Second Constantia Actor: Mrs Pope.

Afterpiece Title: Love in a Camp

Dance: As17901204

Song: End I: The Group of Lovers-Munden; End II: a favourite Sea Song-Incledon

Performances

Mainpiece Title: A Grand Selection 0, Composed By g

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3

Cast
Role: Second Oboe Concerto Actor:

Performances

Mainpiece Title: At King's The Chances

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Second Oboe Concerto Actor:

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3

Cast
Role: Second Oboe Concerto Actor:

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3