SELECT * FROM london_stages WHERE eventid IN (1992, 4070, 10693, 10926, 11217, 13289, 13292, 13296, 13318, 13322, 13343, 13351, 13355, 13360, 13460, 13468, 13495, 13550, 13696, 13771, 14189, 14797, 14806, 14818, 14843, 14860, 18608, 23811, 23818, 28367, 28370, 28376, 28381, 28386, 28391, 28395, 28400, 28406, 28419, 28428, 28437, 28462, 28513, 28541, 28556, 28655, 28659, 28667, 31190, 34863, 34865, 34867, 34868, 34869, 34879, 34881, 34883, 35347, 35364, 35376, 35385, 35418, 35424, 35432, 35450, 35473, 35482, 35536, 35563, 35567, 35576, 35588, 35627, 35668, 35798, 35834, 35845, 35869, 35892, 35901, 35977, 35979, 36014, 36066, 36072, 36093, 36103, 36138, 36167, 36258, 36434, 36460, 36480, 36514, 36526, 36534, 36545, 36570, 36583, 36603, 36623, 36626, 36631, 36726, 36754, 36892, 36939, 37031, 37085, 37104, 37131, 37133, 37157, 37188, 37203, 37548, 37580, 37593, 37688, 37693, 37699, 37710, 37719, 37753, 37771, 37866, 38170, 38195, 38212, 38218, 38246, 38260, 38268, 38274, 38278, 38288, 38296, 38309, 38423, 38495, 38538, 38780, 38807, 38812, 38829, 38851, 38860, 38864, 38867, 38870, 38873, 38883, 38885, 38888, 38906, 38918, 38920, 38962, 39128, 39181, 39216, 39239, 39245, 39260, 39276, 39280, 39282, 39285, 39288, 39298, 39301, 39317, 39329, 39383, 39399, 39445, 39453, 39508, 39522, 39683, 39807, 40325, 40387, 41121, 41197, 41303, 41314, 41393, 41434, 41470, 41502, 41541, 41572, 41582, 41588, 41595, 41613, 41628, 41650, 41668, 41670, 41673, 41717, 41785, 41865, 42137, 42164, 42239, 42240, 42241, 42292, 42307, 42343, 42352, 42412, 42466, 42535, 42585, 42611, 42622, 42628, 42635, 42637, 42645, 42691, 42708, 42713, 42720, 42732, 42740, 42758, 42885, 42903, 42906, 43016, 43269, 43298, 43307, 43357, 43438, 43458, 43563, 43621, 43643, 43679, 43688, 43739, 43747, 43771, 43897, 43971, 43987, 44032, 44053, 44100, 44138, 44201, 44203, 44205, 44209, 44211, 44213, 44215, 44217, 44220, 44222, 44224, 44226, 44234, 44236, 44243, 44250, 44257, 44262, 44274, 44280, 44285, 44310, 44327, 44340, 44357, 44373, 44376, 44388, 44403, 44420, 44436, 44475, 44520, 44531, 44538, 44562, 44588, 44598, 44617, 44653, 44669, 44711, 44739, 44775, 44823, 44852, 44861, 44910, 44924, 44970, 45026, 45138, 45168, 45177, 45197, 45239, 45358, 45396, 45479, 45501, 45530, 45536, 45588, 45616, 45689, 45718, 45736, 45751, 45802, 45961, 46037, 46082, 46095, 46097, 46114, 46169, 46268, 46276, 46285, 46337, 46410, 46696, 46736, 46744, 46760, 46765, 46768, 46773, 46776, 46780, 46785, 46789, 46835, 46898, 46951, 47013, 47078, 47213, 47243, 47248, 47276, 47284, 47362, 47411, 47450, 47465, 47490, 47498, 47518, 47524, 47534, 47569, 47581, 47594, 47596, 47620, 47642, 47679, 47699, 47807, 47864, 47878, 47904, 47907, 47913, 47921, 47947, 47958, 47992, 48014, 48025, 48083, 48116, 48179, 48490, 48542, 48584, 48724, 48890, 49110, 49122, 49125, 49130, 49152, 49153, 49156, 49192, 49237, 49412, 49641, 49693, 50127, 50256, 50259, 50386, 50606, 50806, 50816, 50817, 50938, 50986) 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 Married Philosopher

Cast
Role: Sir Harry Sprightly Actor: Ryan

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Walking Statue; or, The Devil in the Wine Cellar

Cast
Role: Sprightly Actor: Houghton

Dance: I: Comic Dance-Nivelon, Mrs LeBrun; II: Comic Dance-Nivelon, Lalauze, Mrs Laguerre, Miss LeBrun; In III: Hornpipe-Ferguson; End Afterpiece: Glover's Dance of Sailors-

Song: V: As I saw Fair Clara-Beard, Salway

Performances

Mainpiece Title: The Fine Lady's Airs; Or, An Equipage Of Lovers

Cast
Role: Sir Harry Sprightly Actor: Giffard

Afterpiece Title: The King and the Miller of Mansfield

Song: I: By particular Desire, Arrah my Judy-Barrington

Dance: Salomon, Sga Padouana, Salomon's Son

Performances

Mainpiece Title: The Fine Lady's Airs

Cast
Role: Sir Harry Sprightly Actor: Giffard

Afterpiece Title: The Dragon of Wantley

Dance: Salomon, Sga Padouana, the Mechels, Salomon's son

Song: III: A Duet of Purcell's call'd Caesar and Urania-Mrs Clive, Mrs Mozeen

Performances

Mainpiece Title: Cato

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Dance: IV: The Millers, as17570129

Performances

Mainpiece Title: Merope

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: King Henry Viii

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Spanish Fryar

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Dance: TThe Millers, as17570129

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Song: By particular Desire, Ellen@a@roon-Mrs Clive

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher.

Dance: New entertainment of dancing, particularly End: , by Desire a Minuet-Leviez, Miss Pritchard

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher.

Dance: HHornpipe-Walker

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher.

Dance: IV: A Hornpipe-Walker

Performances

Mainpiece Title: Merope

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: Usher

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: The Counterfeit Heiress; or, The Boarding School

Dance: TThe Taylors, as17620107

Entertainment: After Comedy: Mr Hippisley's Drunken Man-Shuter

Performances

Mainpiece Title: The Minor

Afterpiece Title: The Author

Cast
Role: Sprightly Actor: DuBellamy

Dance: As17690515