SELECT * FROM london_stages WHERE eventid IN (12443, 12731, 12760, 12776, 12782, 12784, 12785, 12827, 12831, 13207, 13212, 13217, 13308, 13311, 13356, 13364, 13393, 13398, 13401, 13403, 13409, 13417, 13422, 13427, 13432, 13440, 13444, 13447, 13451, 13458, 13461, 13463, 13467, 13472, 13475, 13477, 13481, 13485, 13487, 13490, 13494, 13496, 13499, 13500, 13502, 13523, 13555, 13559, 13575, 13996, 14000, 14070, 14075, 14093, 14155, 14943, 15002, 15495, 15678, 15681, 15683, 15686, 15687, 15688, 15690, 15692, 15693, 15697, 15727, 15730, 15783, 15788, 15793, 15798, 15804, 15810, 15833, 15913, 15918, 15922, 15930, 15934, 15952, 15959, 15963, 15979, 15984, 15987, 16011, 16019, 16503, 16509, 16539, 16540, 16648, 16655, 16659, 16663, 16670, 16675, 16680, 16685, 16695, 16699, 16703, 16707, 16710, 16714, 17538, 17541, 17546, 17549, 17552, 17555, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17711, 17715, 17719, 17722, 17725, 17729, 17732, 17736, 17783, 17786, 17880, 17885, 17927, 17999, 18190, 18193, 18196, 18224, 18229, 18233, 18237, 18242, 18246, 18251, 18254, 18257, 18262, 18267, 18271, 18275, 18278, 18281, 18283, 18286, 18289, 18292, 18295, 18300, 18303, 18307, 18310, 18314, 18318, 18377, 18380, 18383, 18432, 18437, 18444, 18447, 18450, 18628, 18725, 19906, 19908, 19921, 19951, 19954, 19957, 19965, 19970, 19981, 19993, 19999, 20009, 20076, 20204, 20269, 20313, 20316, 20322, 20325, 20328, 20331, 20334, 20338, 20341, 20345, 20349, 20352, 20355, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20400, 20403, 20407, 20411, 20414, 20417, 20423, 20427, 20431, 20434, 20437, 20443, 20450, 20455, 20459, 20470, 20478, 20481, 20484, 20488, 20495, 20499, 20502, 20556, 20562, 20652, 20715, 28602, 31334, 31357, 31373, 31390, 31398, 31423, 31427, 31433, 31442, 31454, 31466, 31554, 31704, 31757, 31772, 31828, 31838, 31854, 31858, 31860, 31862, 31866, 31870, 31882, 31890, 31892, 31894, 31898, 31906, 31908, 31910, 31918, 31928, 31931, 31933, 31936, 31964, 31992, 32001, 32055, 32172, 32185, 32214, 32236, 32253, 32318, 32326, 32363, 32373, 32377, 32379, 32381, 32383, 32385, 32389, 32391, 32396, 32402, 32404, 32408, 32420, 32422, 32424, 32429, 32431, 32443, 32522, 32534, 32624, 32643, 32699, 32725, 32735, 32824, 32831, 32843, 32857, 32899, 32902, 32925, 32929, 32934, 32938, 32943, 32957, 32967, 32973, 32995, 33000, 33004, 33009, 33013, 33035, 33051, 33122, 33162, 33202, 33298, 33363, 33527, 33530, 33586, 33634, 33699, 33813, 33817, 33832, 33865, 33874, 33897, 33930, 33990, 34023, 34037, 34070, 34076, 34086, 34213, 34349, 34366, 34388, 34434, 34466, 34469, 34471, 34474, 34476, 34478, 34521, 34546, 34601, 34668, 34684, 34713, 34730, 34739, 34787, 34816, 34910, 35071, 35075, 35091, 35158, 35251, 35287, 35300, 35519, 35651, 35890, 35925, 35968, 36150, 36238, 36240, 36242, 36244, 36249, 36297, 36304, 36309, 36314, 36320, 36325, 36344, 36366, 36407, 36461, 36495, 36505, 36693, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36842, 36845, 36847, 36849, 36973, 37003, 37026, 37072, 37086, 37258, 37271, 37353, 37466, 37471, 37592, 37806, 38314, 38344, 40163, 40168, 40282, 40285, 40289, 40292, 40295, 40297, 40302, 40305, 40308, 40340, 40353, 40355, 40358, 40360, 40367, 40372, 40403, 40413, 40422, 40426, 40438, 40450, 41123, 41179, 42283, 42757, 43562, 44661, 48390, 48458, 48473, 48480, 48496, 48604, 48648, 48760, 48762, 48768, 48770, 48772, 48782, 48784, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48820, 48827, 48831, 48845, 48850, 48852, 48859, 48864, 48866, 48880, 48883, 48891, 48903, 48905, 48919, 48928, 48931, 48948, 49003, 49044, 49126, 49187, 49271, 49419, 49431, 49433, 49716, 49762, 49793, 49800, 49806, 49864, 49868, 49918, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50214, 50221, 50224, 50226, 50229, 50230, 50232, 50234, 50235, 50238, 50239, 50242, 50243, 50245, 50247, 50250, 50253, 50257, 50259, 50262, 50263, 50265, 50267, 50268, 50270, 50272, 50276, 50277, 50278, 50279, 50280, 50282, 50283, 50285, 50287, 50289, 50293, 50294, 50295, 50297, 50298, 50299, 50302, 50303, 50314, 50316, 50317, 50319, 50321, 50322, 50737, 50756, 50809, 50817, 50821, 50825, 50830, 50835, 50838, 50845, 50848, 50849, 50853, 50857, 50858, 50864, 50867, 50869, 50870, 50877, 50879, 50885, 50890, 50893, 50896, 50901, 50902, 50903, 50910, 50935, 50988, 51002, 51008, 51013, 51056, 51149, 51230, 51233, 51236, 51240, 51243, 51248, 51251, 51253, 51257, 51260, 51262, 51267, 51270, 51276, 51284, 51289, 51294, 51299, 51301, 51303, 51308, 51316, 51318, 51323, 51326, 51328, 51337, 51344, 51380, 51381, 51392, 51407, 51424, 51441, 51446, 51471, 51544, 51564, 51572, 51576, 51580, 51597, 51606, 51618, 51652, 51698, 51805, 51821, 51835, 51853, 51858, 51888, 51892, 51941, 51956, 51959, 51969, 51984, 51985, 52025, 52029, 52035, 52075, 52091, 52101, 52121, 52129, 52151, 52157, 52173, 52177, 52181, 52185, 52195, 52203, 52205, 52226, 52299, 52334) 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 Summer's Tale

Dance: As17660122

Performances

Mainpiece Title: The Summer's Tale

Dance: I: Rural Love, as17651115; II: The Garland, as17651003

Performances

Mainpiece Title: The Summer's Tale

Afterpiece Title: The Upholsterer

Cast
Role: Harriet Actor: Mrs Baker
Role: Termagant Actor: Mrs Green.

Dance: I: Rural Love, as17651115; II: The Garland, as17651003

Performances

Mainpiece Title: The Royal Convert

Afterpiece Title: Midas

Cast
Role: Juno Actor: Mrs Stephens
Role: Nysa Actor: Mrs Mattocks
Role: Daphne Actor: Mrs Baker
Role: Mysis Actor: Mrs Poitier

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Midas

Cast
Role: Juno Actor: Mrs Stephens
Role: Nysa Actor: Mrs Mattocks
Role: Daphne Actor: Mrs Baker
Role: Mysis Actor: Mrs Poitier

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Apprentice

Cast
Role: Charlotte Actor: Mrs Evans.

Dance: II: Hornpipe-Miss Pitt; End: The Sicilian Peasants, as17660311

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Midas

Cast
Role: Juno Actor: Mrs Stephens
Role: Nysa Actor: Mrs Mattocks
Role: Daphne Actor: Mrs Baker
Role: Mysis Actor: Mrs Poitier

Dance: III: The Village Romps, as17651019

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Perseus and Andromeda

Cast
Role: Amazon Actor: Mrs Jones
Role: Cassiope Actor: Mrs Lampe.
Role: Andromeda Actor: Mrs Weichsel
Role: Colombine Actor: Mrs Dyer

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Upholsterer

Cast
Role: Harriet Actor: Mrs Baker
Role: Termagant Actor: Mrs Green.

Dance: III: The Village Romps, as17661008

Performances

Mainpiece Title: The Royal Convert

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Comus

Afterpiece Title: The Apprentice

Cast
Role: Charlotte Actor: Mrs Evans.

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Thomasand Sally

Cast
Role: Sally Actor: Mrs Pinto

Dance: End: The Village Romps, as17661008

Performances

Afterpiece Title: Thomasand Sally

Cast
Role: Sally Actor: Mrs Pinto

Dance: III: Blind Man's Buff, as17670516; End: Double Hornpipe, as17670427

Ballet: End: The Wapping Landlady. As17670427

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Perseus and Andromeda

Cast
Role: Andromeda Actor: Mrs Baker
Role: Cassiope Actor: Mrs Lampe
Role: Colombine Actor: Mrs Dyer

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Perseus and Andromeda

Cast
Role: Andromeda Actor: Mrs Baker
Role: Cassiope Actor: Mrs Lampe
Role: Colombine Actor: Mrs Dyer

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Comus

Afterpiece Title: The Royal Chace

Cast
Role: Diana Actor: Mrs Thompson
Role: Colombine Actor: Mrs Dyer

Performances

Mainpiece Title: Tamerlane

Performances

Mainpiece Title: Romeo And Juliet

Dance: End: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: The Roman Father

Cast
Role: Vocal Parts Actor: Mrs Lampe, Mrs +Jones.
Role: Valeria Actor: Mrs Mattocks
Role: Horatia Actor: Mrs Yates

Afterpiece Title: Thomasand Sally

Dance: End: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Royal Chace

Cast
Role: Diana Actor: Mrs Baker
Role: Colombine Actor: Mrs Dyer