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, 36104, 36106, 36107, 36108, 36273, 36282, 36296, 36336, 36355, 36381, 36477, 36492, 36555, 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, 37887, 37893, 37895, 37897, 37902, 37905, 37907, 37909, 37914, 37916, 37919, 37921, 37925, 37941, 37943, 37945, 37949, 37951, 37954, 37962, 37969, 37985, 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, 41189, 41195, 41200, 41218, 41235, 41237, 41246, 41256, 41274, 41280, 41282, 41284, 41286, 41289, 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, 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: Jane Shore

Cast
Role: Ratcliffe Actor: Griffiths

Afterpiece Title: A Trip to Scotland

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Elopement

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: High Life below Stairs

Cast
Role: Robert Actor: Griffiths

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Election

Afterpiece Title: The Elopement

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Performances

Mainpiece Title: Jane Shore

Cast
Role: Ratcliffe Actor: Griffiths

Afterpiece Title: The Election

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Afterpiece Title: The Deserter

Cast
Role: Solders Actor: Legg, Griffiths, Kear, Carpenter.

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Election

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Afterpiece Title: The Elopement

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Deserter

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths
Role: Solders Actor: Legg, Griffiths, Kear, Carpenter.

Dance: III: The Sailors Revels, as17740920

Performances

Mainpiece Title: Hamlet

Cast
Role: Bernardo Actor: Griffiths

Afterpiece Title: The Lying Valet

Cast
Role: Guttle Actor: Griffiths

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Genii

Cast
Role: Clown Actor: Griffiths.

Dance: III: The Irish Fair, as17740917

Performances

Mainpiece Title: The Alchymist

Cast
Role: The Mob Actor: Griffiths, Wright, Carpenter, Keen.

Afterpiece Title: The Deserter

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths
Role: Solders Actor: Legg, Griffiths, Kear, Carpenter.

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Deserter

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths
Role: Solders Actor: Legg, Griffiths, Kear, Carpenter.

Dance: End: Slingsby, Mad. Hidou

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Genii

Cast
Role: Clown Actor: Griffiths.

Dance: II: A New Grand Provencalle Dance-Slingsby, Sga Hidou, with New Dresses, and a view of the Port of Marseilles

Performances

Mainpiece Title: Venice Preserv'd

Cast
Role: Officer Actor: Griffiths

Afterpiece Title: The Cobler; or, a Wife of Ten Thousand

Cast
Role: Pest Actor: Griffiths

Performances

Mainpiece Title: Hamlet

Cast
Role: Bernardo Actor: Griffiths

Afterpiece Title: The Cobler

Cast
Role: Pest Actor: Griffiths

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Cobler

Cast
Role: Pest Actor: Griffiths

Dance: I: Grand Provencalle Dance, as17741208, but with a view of the Port of Genoa

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Vocal parts Actor: Griffiths, _Carpenter in +Fete Champetre.

Afterpiece Title: The Cobler

Cast
Role: Pest Actor: Griffiths

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Cobler

Cast
Role: Pest Actor: Griffiths

Performances

Mainpiece Title: Cymbeline

Cast
Role: Claudio Actor: Griffiths.

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: The Tempest

Cast
Role: Boatswain Actor: Griffiths

Afterpiece Title: The Elopement

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Performances

Mainpiece Title: The Fair Quaker

Cast
Role: Cockswain Actor: Griffiths

Afterpiece Title: The Elopement

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Vocal parts Actor: Griffiths, _Carpenter in +Fete Champetre.

Afterpiece Title: The Cobler

Cast
Role: Pest Actor: Griffiths

Performances

Mainpiece Title: The Choleric Man

Afterpiece Title: The Deserter

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths
Role: Solders Actor: Legg, Griffiths, Kear, Carpenter.

Performances

Mainpiece Title: Zara

Afterpiece Title: The Cobler

Cast
Role: Pest Actor: Griffiths

Dance: II: The Grand Provencalle Dance, as17741213

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Harlequin's Jacket; or, The New Years Gift

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Deserter

Cast
Role: Parts Actor:
Role: Drunken Valet Actor: Griffiths
Role: Solders Actor: Legg, Griffiths, Kear, Carpenter.

Dance: II: The Grand Provencalle Dance, as17741213