SELECT * FROM london_stages WHERE eventid IN (26995, 27046, 30322, 30326, 30328, 30330, 30356, 30358, 30361, 30363, 30366, 30368, 30370, 30372, 30375, 30377, 30380, 30384, 30425, 30451, 30453, 30473, 30505, 30510, 30523, 30538, 30550, 30574, 30590, 30595, 30598, 30602, 30620, 30630, 30637, 30792, 30802, 30811, 30819, 30829, 30833, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 30897, 30955, 31016, 31022, 31041, 31048, 31050, 31053, 31056, 31058, 31060, 31062, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31134, 31188, 31204, 31207, 31334, 31345, 31357, 31361, 31363, 31373, 31390, 31396, 31398, 31402, 31404, 31406, 31408, 31410, 31412, 31414, 31416, 31425, 31429, 31431, 31436, 31438, 31446, 31452, 31456, 31460, 31463, 31468, 31471, 31473, 31475, 31478, 31481, 31483, 31485, 31487, 31489, 31492, 31495, 31499, 31501, 31503, 31505, 31507, 31511, 31514, 31516, 31518, 31520, 31522, 31524, 31527, 31530, 31532, 31534, 31536, 31538, 31541, 31543, 31547, 31549, 31551, 31554, 31557, 31559, 31561, 31563, 31565, 31568, 31570, 31572, 31575, 31578, 31581, 31584, 31586, 31588, 31590, 31592, 31598, 31600, 31606, 31609, 31630, 31640, 31643, 31661, 31668, 31690, 31697, 31704, 31709, 31712, 31746, 31768, 31772, 31774, 32919, 44259, 44268, 44273, 44282, 44287, 44294, 44300, 44355, 44405, 44410, 44435, 44445, 44450, 44465, 44479, 44485, 44488, 44494, 44497, 44507, 44518, 44522, 44713, 44724, 44729, 44738, 44797, 44806, 44811, 44829, 44832, 44838, 44841, 44842, 44845, 44850, 44851, 44854, 44855, 44865, 44868, 44869, 44872, 44877, 44878, 44881, 44882, 44885, 44892, 44894, 44898, 44904, 44918, 44953, 44993, 45023, 45028, 45038, 45049, 45367, 45376, 45379, 45388, 45392, 45401, 45405, 45414, 45418, 45427, 45431, 45463, 45476, 45481, 45491, 45496, 45533, 45571, 46596, 46605, 46610, 46615, 46620, 46625, 46630, 46635, 46640, 46645, 46650, 46655, 46664, 46669, 46674, 46679, 46684, 46692, 46698, 46706, 46709, 46714, 46724, 46727, 46733, 47064, 47069, 47074, 47084, 47181, 47194, 47200, 47287, 47299, 47318, 47344, 47375, 47518, 47522, 47524, 47526, 47876, 47881, 47884, 47895, 47907, 48063, 48069, 48118, 48124, 48183, 48212, 48221, 48226, 48231, 48234, 48239, 48241, 48245, 48255, 48269, 48273, 48283, 48287, 48295, 48297, 48301, 48304, 48318, 48332, 48337, 48345, 48359, 48373, 48387, 48408, 48433, 48446, 48452, 50021, 50024, 50033, 50036, 50050, 50059, 50138, 50189, 50218, 50621, 50633, 50642, 50645, 50654, 50657, 50666, 50669, 50678, 50682, 50951, 50959, 50987, 50991, 50997, 51024, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51273, 51277, 51283, 51314, 51322, 51329, 51368, 51711, 51720, 51723, 51732, 51748, 51757, 51769, 51772, 52342, 52346, 52349, 52352, 52354, 52358, 52364, 52370, 52376, 52482, 52519) 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 Messiah; Grand Selection 0

Music: End Part I: concerto on the harp-Mme Delaval

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Pious orgies Actor: Mme Mara

Afterpiece Title: Grand Selection 2

Cast
Role: Mad Bess Actor: Mme Mara

Afterpiece Title: Grand Selection 3

Cast
Role: The Soldier tir'd Actor: Mme Mara

Music: End Part I: concerto on the Piano Forte-Miss M'Arthur; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: Artaxerxes

Cast
Role: Mandane Actor: Mme Mara

Afterpiece Title: The Doldrum

Performances

Mainpiece Title: Comus

Afterpiece Title: Artaxerxes

Afterpiece Title: The Doldrum

Song: In 1st piece: Sweet Echo (1st time)-Mme Mara; accompanied on the hautboy-W. Parke; End I 1st piece: Mad Bess (in character)-Mme Mara (1st time); In 2nd piece: a new song [High rolling seas that bear afar]-Mme Mara [written for the Occasion, and set to music by Herself

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Sultan

Song: End I: Whither my Love, Ah! Whither art thou fled? (from The Haunted Tower)-Sga Storace; From Shades of Night-Braham; This fond Sorrow-Braham, Sga Storace (both from Mahmoud); End II: the celebrated Harp Song Ah che nel petto io sento, from Idalide,-Mme Mara; In IV: a Masquerade Scene, in which Ally Croker-Miss Leak, Master Welsh

Cast
Role: from Idalide, Actor: Mme Mara

Entertainment: MonologueEnd: a new Occasional Address-Mrs Jordan

Performances

Mainpiece Title: The Messiah 0

Music: End I: concerto on the violoncello-C. Ashley

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Cast
Role: Holy Holy Lord Actor: Mme Mara

Afterpiece Title: A Grand Sacred Selection 3

Music: End I: concerto on pedal harp-Miss Dupree (1st appearance in public)

Performances

Mainpiece Title: Alexander's Feast 0; Or, the Power Of Music Messiah 0

Afterpiece Title: Alexander's Feast 3

Music: Preceding II: concerto for two violins and violoncello obligato- , as originally composed for this Ode by Handel, and performed under his Direction in the year 1736; End II: concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: L'Allegro ed Il Penseroso 3

Music: End I: concerto on the Grand Piano Forte-Miss MacArthur; End II: concerto on the clarionet-John Mahon

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Cast
Role: Lord remember David Actor: Mme Mara

Afterpiece Title: A Grand Selection of Sacred Music 3

Cast
Role: Agitata Actor: Mme Mara

Music: End I: concerto on the oboe-W. Parke; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: Acis And Galatea 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: Acis and Galatea 3

Cast
Role: Mad Bess Actor: Mme Mara

Music: End I: Handel's 4th concerto on the organ-J. Ashley; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Cast
Role: Pious orgies Actor: Mme Mara

Afterpiece Title: A Grand Selection of Sacred Music 2

Cast
Role: What though I trace Actor: Mme Mara

Afterpiece Title: A Grand Selection of Sacred Music 3

Cast
Role: Mad Bess Actor: Mme Mara

Music: As17970315

Performances

Mainpiece Title: The Messiah 0

Music: End II: concerto on the Piano Forte-Miss MacArthur; Preceding III: Eighth concerto of Corelli-

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Afterpiece Title: A Grand Sacred Selection 3

Music: End II: concerto on Piano Forte-Miss MacArthur

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Mme Mara

Afterpiece Title: The Honest Thieves

Dance: III: a Hornpipe in Fetters-Blurton

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Mme Mara

Afterpiece Title: Harlequin and Oberon

Dance: As17971025

Song: In: Old Towler-Incledon

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mme Mara

Afterpiece Title: Catherine and Petruchio

Dance: End I: The Statute Dance- [performers not listed]

Performances

Mainpiece Title: Love In A Village

Cast
Role: Rosetta Actor: Mme Mara

Afterpiece Title: The Honest Thieves

Dance: As17971115

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Polly Actor: Mme Mara

Afterpiece Title: The Miser

Dance: As17971025

Song: In: Old Towler-Incledon; a new Duetto, composed by Mme Mara,-Incledon, Mme Mara

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Lorenza Actor: Mme Mara

Afterpiece Title: The Round Tower

Performances

Music: End I: concerto on the violin-Master Pinto (aged Eleven Years, Grandson to the celebrated Performer of that Name [ThomasPinto])

Performances

Mainpiece Title: L'allegro [ed] Il Pensieroso 0; Messiah

Afterpiece Title: L'Allegro Il Pensieroso 3

Cast
Role: Bravura Agitata Actor: Mme Mara

Performances

Mainpiece Title: Acis And Galatea 0

Cast
Role: Galatea Actor: Mme Mara

Afterpiece Title: Acis and Galatea 3 [i

Cast
Role: The soldier tir'd Actor: Mme Mara

Music: End I: serenata concerto on violin-G. Ashley; End II: a new concerto, with a military rondo, on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of Handel; Messiah

Afterpiece Title: Grand Selection 1

Cast
Role: Holy holy Lord Actor: Mme Mara.

Afterpiece Title: Grand Selection 2

Cast
Role: Farewell ye limpid Actor: Mme Mara

Afterpiece Title: Grand Selection 3

Music: End I: concerto on violin-Master Pinto; End II: concerto on the Piano Forte-Dussek