SELECT * FROM london_stages WHERE eventid IN (21150, 21212, 21322, 21506, 21534, 21551, 21573, 21635, 21771, 21805, 22589, 22638, 22643, 22646, 22649, 22653, 22656, 22659, 22664, 22856, 22862, 22866, 23044, 23046, 23097, 23113, 23249, 23258, 23274, 23300, 23302, 23315, 23317, 23351, 23436, 23438, 23441, 23445, 23448, 23505, 23624, 23713, 23743, 23821, 23836, 24225, 25644, 25670, 25789, 25791, 25799, 26089, 26533, 26576, 26695, 26697, 26701, 26707, 26711, 26717, 26733, 26770, 26798, 26800, 26810, 26860, 26864, 26869, 26878, 26885, 26898, 26916, 26921, 27036, 27039, 27042, 27047, 27053, 27061, 27066, 27077, 27083, 27176, 27179, 27186, 27189, 27196, 27198, 27202, 27206, 27238, 27240, 27249, 27254, 27259, 27264, 27269, 27276, 27278, 27283, 27297, 27299, 27303, 27318, 27324, 27327, 27330, 27332, 27334, 27337, 27342, 27383, 27386, 27408, 27411, 27418, 27423, 27429, 27445, 27452, 27458, 27472, 27479, 27501, 27520, 27529, 27536, 27543, 27546, 27575, 27599, 27614, 27619, 27621, 27629, 27633, 27654, 27657, 27662, 27665, 27666, 27676, 27679, 27682, 27687, 27694, 27696, 27698, 27712, 27720, 27728, 27739, 27757, 27759, 27761, 27765, 27770, 27772, 27789, 27798, 27813, 27815, 27819, 27827, 27833, 27844, 27854, 27872, 27905, 27922, 27934, 27940, 27954, 27965, 27986, 28006, 28009, 28016, 28038, 28041, 28054, 28057, 28059, 28062, 28067, 28076, 28078, 28094, 28102, 28107, 28111, 28124, 28135, 28140, 28142, 28144, 28156, 28158, 28164, 28189, 28193, 28199, 28201, 28205, 28209, 28211, 28213, 28217, 28223, 28227, 28231, 28235, 28237, 28241, 28243, 28249, 28253, 28263, 28268, 28289, 28291, 28293, 28308, 28312, 28317, 28324, 28340, 28343, 28345, 28348, 28350, 28357, 28361, 28363, 28376, 28378, 28393, 28398, 28400, 28406, 28428, 28434, 28447, 28454, 28462, 28464, 28468, 28472, 28476, 28480, 28484, 28496, 28504, 28509, 28515, 28518, 28524, 28526, 28531, 28539, 28541, 28547, 28552, 28554, 28565, 28607, 28613, 28619, 28624, 28644, 28648, 28651, 28679, 28689, 28721, 28723, 28728, 28742, 28745, 28751, 28754, 28756, 28759, 28763, 28768, 28770, 28775, 28779, 28784, 28788, 28790, 28797, 28800, 28807, 28810, 28813, 28815, 28820, 28825, 28828, 28834, 28837, 28839, 28844, 28847, 28849, 28852, 28864, 28869, 28874, 28887, 28939, 28950, 28958, 28960, 28964, 28971, 28988, 28993, 28997, 29000, 29005, 29007, 29014, 29031, 29038, 29041, 29046, 29052, 29054, 29059, 29062, 29068, 29085, 29151, 29154, 29163, 29169, 29171, 29174, 29191, 29207, 29225, 29252, 29257, 29268, 29271, 29276, 29278, 29282, 29285, 29287, 29295, 29306, 29354, 29372, 29374, 29379, 29381, 29386, 29388, 29390, 29393, 29400, 29402, 29405, 29407, 29424, 29439, 29461, 29465, 29468, 29470, 29473, 29478, 29481, 29484, 29508, 29527, 29537, 29542, 29547, 29564, 29568, 29571, 29587, 29598, 29600, 29610, 29628, 29720, 29729, 29732, 29735, 29736, 29745, 29749, 29754, 29756, 29760, 29778, 29815, 29819, 29842, 29855, 29857, 29861, 29864, 29868, 29872, 29874, 29879, 29883, 29905, 29917, 29919, 29921, 29932, 29934, 29936, 29938, 29941, 29943, 29945, 29947, 29949, 29952, 29954, 29956, 29958, 29960, 29962, 29965, 29967, 29971, 29981, 29983, 30021, 30033, 30036, 30042, 30045, 30061, 30065, 30073, 30078, 30081, 30084, 30090, 30095, 30103, 30106, 30114, 30118, 30120, 30123, 30137, 30139, 30141, 30143, 30145, 30149, 30153, 30155, 30160, 30292, 30294, 30298, 30310, 30328, 30332, 30340, 30372, 30398, 30406, 30419, 30423, 30439, 30444, 30447, 30451, 30458, 30476, 30480, 30482, 30485, 30487, 30490, 30494, 30497, 30499, 30510, 30514, 30518, 30523, 30527, 30533, 30536, 30554, 30558, 30562, 30567, 30584, 30590, 30593, 30602, 30612, 30623, 30625, 30628, 30681, 31334, 31338, 31343, 31345, 31351, 31355, 31363, 31365, 31369, 31373, 31375, 31379, 31381, 31394, 31396, 31398, 31402, 31408, 31418, 31423, 31425, 31427, 31433, 31436, 31440, 31442, 31449, 31452, 31454, 31456, 31463, 31466, 31497, 31501, 31503, 31516, 31520, 31554, 31578, 31598, 31627, 31649, 31652, 31655, 31670, 31672, 31683, 31699, 31714, 31719, 31724, 31743, 31750, 31757, 31759, 31764, 31772, 31838, 31840, 31842, 31852, 31854, 31858, 31862, 31866, 31870, 31880, 31892, 31894, 31898, 31900, 31910, 31928, 31936, 31942, 31947, 31950, 31952, 31964, 31968, 31988, 31992, 32001, 32010, 32024, 32027, 32031, 32040, 32050, 32052, 32055, 32058, 32064, 32067, 32069, 32072, 32075, 32082, 32093, 32098, 32125, 32137, 32141, 32149, 32161, 32165, 32185, 32188, 32192, 32207, 32214, 32218, 32222, 32227, 32236, 32248, 32257, 32260, 32313, 32316, 32318, 32326, 32328, 32330, 32331, 32335, 32340, 32343, 32345, 32349, 32351, 32353, 32357, 32363, 32373, 32379, 32385, 32391, 32394, 32396, 32402, 32408, 32417, 32422, 32424, 32445, 32465, 32469, 32472, 32474, 32476, 32515, 32517, 32522, 32524, 32529, 32534, 32573, 32579, 32643, 32654, 32659, 32692, 32694, 32719, 32721, 32735, 32738, 32749, 32751, 32808, 32810, 32821, 32824, 32828, 32835, 32837, 32839, 32849, 32859, 32865, 32869, 32877, 32891, 32897, 32914, 32918, 32923, 32931, 32945, 32954, 32961, 32973, 32975, 32977, 32979, 32982, 32984, 32986, 32988, 32990, 32992, 32997, 33002, 33006, 33011, 33027, 33037, 33040, 33043, 33046, 33065, 33076, 33109, 33111, 33115, 33132, 33137, 33140, 33155, 33157, 33171, 33175, 33190, 33192, 33194, 33196, 33290, 33298, 33301, 33307, 33313, 33318, 33342, 33356, 33363, 33365, 33370, 33377, 33393, 33401, 33403, 33412, 33419, 33421, 33426, 33444, 33449, 33454, 33472, 33484, 33490, 33492, 33499, 33502, 33504, 33507, 33509, 33511, 33513, 33516, 33518, 33525, 33530, 33532, 33537, 33551, 33555, 33558, 33564, 33586, 33590, 33614, 33621, 33627, 33631, 33634, 33643, 33650, 33658, 33663, 33668, 33670, 33679, 33696, 33699, 33703, 33731, 33803, 33805, 33815, 33822, 33830, 33836, 33848, 33858, 33861, 33878, 33908, 33920, 33922, 33932, 33946, 33949, 33963, 33975, 34011, 34020, 34025, 34027, 34032, 34089, 34094, 34098, 34101, 34103, 34108, 34113, 34118, 34123, 34128, 34131, 34133, 34152, 34159, 34165, 34167, 34176, 34181, 34183, 34188, 34193, 34195, 34203, 34228, 34240, 34264, 34267, 34345, 34356, 34358, 34368, 34375, 34377, 34386, 34394, 34396, 34407, 34429, 34464, 34508, 34519, 34524, 34530, 34532, 34537, 34542, 34570, 34584, 34604, 34628, 34651, 34665, 34689, 34700, 34705, 34710, 34725, 34730, 34748, 34764, 34775, 34782, 34787, 34890, 34900, 34904, 34908, 34946, 34958, 34964, 34978, 34985, 34997, 35004, 35025, 35041, 35081, 35084, 35103, 35114, 35123, 35139, 35144, 35241, 35265, 35270, 35282, 35284, 35293, 35346, 35352, 35355, 35358, 35497, 35509, 35574, 35606, 35625, 35679, 35692, 35705, 35724, 35734, 35864, 35919, 35923, 35933, 35938, 35941, 36144, 36148, 36152, 36156, 36160, 36191, 36196, 36200, 36218, 36228, 36230, 36276, 36280, 36285, 36292, 36332, 36363, 36368, 36371, 36382, 36435, 36474, 36480, 36486, 36507, 36517, 36530, 36544, 36550, 36642, 36648, 36670, 36711, 36753, 36762, 36781, 36791, 36799, 36805, 36814, 36823, 36889, 36964, 37012, 37017, 37019, 37034, 37064, 37074, 37097, 37102, 37105, 37108, 37211, 37226, 37242, 37248, 37265, 37291, 37295, 37304, 37311, 37316, 37362, 37364, 37413, 37415, 37417, 37423, 37546, 37571, 37595, 37603, 37776, 37796, 37822, 37830, 37834, 37842, 37848, 37879, 37901, 37903, 37915, 37920, 37950, 37952, 37961, 37988, 38152, 38173, 38198, 38217, 38220, 38222, 38234, 38237, 38240, 38245, 38251, 38324, 38326, 38342, 38352, 38358, 38384, 38418, 38489, 38506, 38586, 38630, 38685, 38690, 38699, 38717, 38749, 38877, 38895, 38915, 38925, 38931, 38938, 38947, 38949, 38961, 38975, 39009, 39014, 39035, 39059, 39119, 39197, 39248) 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 Merchant Of Venice

Cast
Role: Portia Actor: Miss Macklin
Role: Shylock Actor: Macklin

Afterpiece Title: Love a la Mode

Cast
Role: Lady Actor: Miss Macklin.
Role: Sir Archy Actor: Macklin.

Dance: III: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: The Upholsterer

Dance: End of Opera: A New Comic Dance, call'd the Provenzales-Mas. Blurton, Miss Besford, Miss Ford 1st time

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: The Apprentice

Dance: End of Opera: The Provenzales, as17680301

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: The Citizen

Dance: End of Opera: The Merry Sailors, as17671009

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: The Englishman in Paris

Cast
Role: Lucinda Actor: Miss Macklin
Role: With a Minuet Actor: Fishar, Miss Macklin.

Dance: End of Opera: The Irish Lilt, as17670921, but Miss Valois, Sga _Manesiere

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: The Intriguing Chambermaid

Dance: End of Opera: The Provenzales, as17680301

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: Catherine and Petruchio

Dance: End Opera: New Comic Dance, as17671126, but Miss Capon, Miss _Valois

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: The Royal Chace

Dance: II: The Highland Reel, as17680307 Provenzales, as17680301

Performances

Mainpiece Title: The Busy Body

Cast
Role: Miranda Actor: Miss Macklin.
Role: Scentwell Actor: Miss Pearce.

Afterpiece Title: Harlequin Dr Faustus With a New Additional Scene

Performances

Mainpiece Title: The Way To Keep Him

Cast
Role: Widow Belmour Actor: Miss Macklin
Role: Mignionette Actor: Miss Pearce
Role: Furnish Actor: Miss Mills

Afterpiece Title: Catherine and Petruchio

Dance: End: The Irish Lilt, as17670921

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Portia Actor: Miss Macklin
Role: Shylock Actor: Macklin

Afterpiece Title: Love a la Mode

Cast
Role: Lady Actor: Miss Macklin.
Role: Sir Archy Actor: Macklin.

Dance: I: A Minuet-Fishar, Miss Macklin; III: The Provenzales, as17680301 IV: The Irish Lilt, as17670921

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Ann Lovely Actor: Miss Macklin.

Afterpiece Title: Midas

Dance: II: Comic Dance, as17671106

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Portia Actor: Miss Macklin
Role: Shylock Actor: Macklin

Afterpiece Title: Amelia

Dance: III: The Provenzales, as17680301 IV: The Irish Lilt, as17670921

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: Orpheus and Eurydice

Cast
Role: 1st Nymph Actor: Miss Valois
Role: Dwarf Actor: Miss Ford
Role: 2nd Nymph Actor: Miss Valois

Performances

Mainpiece Title: The Busy Body

Cast
Role: Miranda Actor: Miss Macklin.
Role: Scentwell Actor: Miss Pearce.

Afterpiece Title: Harlequin Dr Faustus

Dance: III: A Hornpipe-Miss Ford

Performances

Mainpiece Title: Cymbeline

Cast
Role: Helen Actor: Miss Mills.

Afterpiece Title: The Englishman in Paris

Cast
Role: Lucinda Actor: Miss Macklin
Role: With a Minuet Actor: Fishar, Miss Macklin.

Dance: III: The Merry Sailors, as17671009

Performances

Mainpiece Title: Coriolanus

Cast
Role: Volumnia Actor: Miss Macklin

Afterpiece Title: Love a la Mode

Cast
Role: Lady Actor: Miss Macklin.
Role: Sir Archy Actor: Macklin.

Dance: End: The Irish Lilt, as17670921

Performances

Mainpiece Title: Lionel And Clarissa

Cast
Role: Clarissa Actor: Miss Macklin

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: Hamlet

Cast
Role: Ophelia Actor: Miss Macklin

Afterpiece Title: The Musical Lady

Dance: II: The Dutch Milkmaid, as17671114

Performances

Mainpiece Title: The Wonder

Cast
Role: Violante Actor: Miss Macklin.

Afterpiece Title: The Musical Lady

Ballet: End: The Wapping Landlady. Double Hornpipe As17680416

Performances

Mainpiece Title: The Busy Body

Cast
Role: Miranda Actor: Miss Macklin.
Role: Scentwell Actor: Miss Pearce.

Afterpiece Title: The Royal Chace

Dance: IV: A Hornpipe-Miss Stede, 1st time (Scholar to Fishar)

Performances

Mainpiece Title: The Wonder

Cast
Role: Violante Actor: Miss Macklin.

Afterpiece Title: The Royal Chace

Dance: II: The Merry Sailors, as17671009

Performances

Mainpiece Title: A Bold Stroke For A Wife

Cast
Role: Ann Lovely Actor: Miss Macklin.

Afterpiece Title: Orpheus and Eurydice

Cast
Role: 1st Nymph Actor: Miss Valois
Role: Dwarf Actor: Miss Ford
Role: 2nd Nymph Actor: Miss Valois

Dance: II: Hornpipe-Miss Stede, 2nd time (scholar of Fishar)

Performances

Mainpiece Title: She Woud And She Woud Not Or The Kind Imposter

Cast
Role: Hypolita Actor: Miss Macklin.

Afterpiece Title: Orpheus and Eurydice

Cast
Role: Dwarf Actor: Miss Ford
Role: Nymph Actor: Miss Valois