SELECT * FROM london_stages WHERE eventid IN (27145, 27247, 27290, 27349, 27351, 27354, 27365, 27398, 27446, 27473, 27521, 27553, 27571, 27573, 27615, 35342, 35359, 35370, 35376, 35380, 35393, 35397, 35400, 35403, 35416, 35421, 35426, 35429, 35436, 35438, 35448, 35452, 35458, 35460, 35464, 35468, 35470, 35471, 35473, 35480, 35484, 35505, 36019, 36029, 36047, 36057, 36084, 36099, 36104, 36106, 36107, 36108, 36273, 36282, 36296, 36336, 36355, 36381, 36477, 36492, 36555, 36563, 36584, 36598, 36627, 36634, 36635, 36663, 36667, 36680, 36684, 36752, 36866, 37008, 37088, 37214, 37216, 37218, 37229, 37241, 37251, 37253, 37268, 37303, 37477, 37524, 37566, 37579, 37623, 37675, 37777, 37787, 37793, 37795, 37797, 37803, 37813, 37823, 37825, 37827, 37829, 37831, 37833, 37835, 37837, 37852, 37862, 37870, 37874, 37884, 37887, 37891, 37893, 37895, 37897, 37900, 37902, 37905, 37907, 37909, 37911, 37914, 37916, 37919, 37921, 37925, 37941, 37943, 37945, 37949, 37951, 37954, 37960, 37962, 37969, 37975, 37985, 37987, 37991, 37994, 38018, 38030, 38042, 38045, 38047, 38050, 38053, 38056, 38058, 38060, 38062, 38065, 38070, 38073, 38083, 38088, 38091, 38105, 38107, 38112, 38118, 38123, 38128, 38133, 38136, 38143, 38151, 38153, 38156, 38158, 38165, 38167, 38172, 38175, 38177, 38183, 38186, 38188, 38192, 38195, 38197, 38205, 38212, 38218, 38219, 38230, 38233, 38239, 38246, 38263, 38271, 38279, 38290, 38300, 38313, 38317, 38330, 38332, 38334, 38336, 38339, 38343, 38349, 38361, 38367, 38369, 38371, 38376, 38381, 38385, 38396, 38410, 38412, 38417, 38425, 38427, 38441, 38443, 38448, 38464, 38469, 38471, 38488, 38494, 38502, 38509, 38521, 38523, 38525, 38540, 38568, 38570, 38593, 38634, 38642, 38644, 38656, 38663, 38678, 38680, 38689, 38703, 38706, 38709, 38716, 38719, 38739, 38741, 38745, 38753, 38785, 38789, 38803, 38834, 38853, 38855, 38856, 38859, 38860, 38864, 38867, 38870, 38873, 38883, 38885, 38888, 38891, 38894, 38904, 38906, 38914, 38918, 38920, 38928, 38934, 38948, 38951, 38956, 38958, 38962, 38965, 38967, 38972, 38974, 38976, 38979, 38982, 38984, 38986, 38988, 38993, 39008, 39015, 39022, 39026, 39028, 39030, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39081, 39083, 39086, 39090, 39093, 39098, 39100, 39114, 39137, 39163, 39171, 39181, 39196, 39199, 39202, 39208, 39216, 39236, 39239, 39242, 39245, 39247, 39250, 39253, 39257, 39260, 39262, 39270, 39273, 39276, 39280, 39282, 39285, 39288, 39296, 39298, 39301, 39303, 39308, 39317, 39322, 39329, 39338, 39343, 39345, 39346, 39347, 39348, 39351, 39355, 39357, 39359, 39361, 39362, 39365, 39368, 39370, 39371, 39374, 39376, 39377, 39379, 39381, 39385, 39386, 39388, 39390, 39392, 39393, 39395, 39401, 39402, 39405, 39406, 39408, 39409, 39411, 39417, 39421, 39422, 39424, 39425, 39431, 39433, 39434, 39436, 39437, 39438, 39440, 39442, 39443, 39451, 39453, 39455, 39457, 39460, 39465, 39472, 39474, 39476, 39480, 39497, 39499, 39502, 39511, 39513, 39518, 39520, 39527, 39532, 39541, 39553, 39558, 39564, 39572, 39578, 39583, 39600, 39603, 39605, 39607, 39611, 39613, 39615, 39618, 39621, 39625, 39629, 39632, 39637, 39641, 39646, 39651, 39673, 39675, 39678, 39682, 39687, 39690, 39693, 39695, 39704, 39707, 39735, 39750, 39757, 39759, 39769, 39775, 39840, 39857, 39866, 39871, 39904, 40019, 40023, 40029, 40035, 40041, 40074, 40084, 40113, 40125, 40153, 40175, 40189, 40192, 40196, 40198, 40201, 40204, 40207, 40211, 40213, 40216, 40218, 40223, 40225, 40227, 40230, 40232, 40275, 40284, 40357, 40366, 40368, 40376, 40388, 40415, 40427, 40443, 40449, 40460, 40820, 40932, 40982, 41121, 41128, 41136, 41140, 41146, 41155, 41165, 41170, 41178, 41189, 41195, 41200, 41218, 41235, 41237, 41242, 41246, 41256, 41263, 41274, 41280, 41282, 41284, 41286, 41289, 41296, 41300, 41303, 41305, 41308, 41310, 41314, 41317, 41319, 41322, 41324, 41328, 41351, 41363, 41368, 41378, 41384, 41387, 41389, 41393, 41396, 41398, 41403, 41434, 41440, 41444, 41446, 41465, 41470, 41475, 41488, 41497, 41502, 41517, 41526, 41541, 41558, 41572, 41690, 41696, 41708, 41712, 41717, 41724, 41728, 41732, 41734, 41736, 41748, 41758, 41762, 41764, 41767, 41771, 41773, 41775, 41778, 41780, 41785, 41794, 41822, 41827, 41835, 41837, 41840, 41842, 41845, 41847, 41857, 41862, 41865, 41897, 41908, 41913, 41922, 41925, 41983, 42013, 42016, 42020, 42036, 42039, 42041, 42044, 42049, 42055, 42060, 42067, 42075, 42080, 42082, 42090, 42102, 42116, 42118, 42126, 42128, 42140, 42141, 42143, 42146, 42148, 42151, 42153, 42164, 43657, 44297, 44701, 44741, 44861, 45512, 45708, 46013, 46517, 46527, 46541, 46555, 46569, 46583, 46588, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 50684, 51392, 51395, 51399, 51402, 51405, 51407, 51411, 51413, 51418, 51420, 51424, 51431, 51435, 51441, 51442, 51444, 51446, 51448, 51449, 51450, 51451, 51452, 51453, 51454, 51457, 51459, 51461, 51462, 51464, 51465, 51468, 51472, 51478, 51950, 51971, 51982, 51983, 51985, 51992, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52005, 52007, 52008, 52012, 52016, 52017, 52021, 52022, 52023, 52025, 52026, 52028, 52030, 52032, 52034, 52040, 52041, 52043, 52044, 52046, 52048, 52049, 52050, 52051, 52053, 52200, 52202, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253) 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: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900224

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

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

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Harlequin's Museum [and see17921220]

Cast
Role: Starved Friar Actor: Griffiths

Dance: In afterpiece: the Burlesque Pas de Russe-Byrn, Miss Smith; Hornpipe-Holland; rest of the Dances-Byrn, Ratchford, Cranfield, Rayner, Platt, Jackson, Wilde, Mrs Watts, Miss Francis, Mrs Ratchford, Mrs Lloyd, Mrs Crowe, Mrs Bayzand, Mme Rossi

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Song: As17921126

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Cast
Role: Starved Friar Actor: Griffiths

Dance: As17921226