SELECT * FROM london_stages WHERE eventid IN (17793, 19064, 19067, 19069, 19072, 19074, 19079, 19092, 19100, 19102, 19105, 19164, 19316, 19319, 19510, 19516, 19520, 19527, 19534, 19536, 19538, 19556, 19562, 19576, 19579, 19581, 19583, 19585, 19590, 19595, 19611, 19646, 19648, 19650, 19653, 19656, 19658, 19659, 19663, 19683, 19685, 19713, 19715, 19717, 19719, 19721, 19723, 19725, 19727, 19729, 19731, 19733, 19735, 19739, 19741, 19743, 19747, 19775, 19777, 19779, 19781, 19784, 19786, 19789, 19791, 19793, 19795, 19798, 19799, 19801, 19845, 19847, 19850, 19878, 19881, 19883, 19906, 19908, 19921, 20002, 20009, 20048, 20053, 20062, 20159, 20160, 20163, 20166, 20190, 20193, 20196, 20199, 20202, 20205, 20217, 20227, 20233, 20292, 20295, 20307, 20311, 20317, 20326, 20343, 20347, 20375, 20381, 20398, 20415, 20421, 20438, 20441, 20461, 20468, 20549, 20613, 20630, 20755, 20757, 20760, 20802, 20854, 20956, 20961, 20964, 20973, 20974, 20984, 20986, 20993, 20997, 21005, 21007, 21010, 21017, 21025, 21027, 21037, 21042, 21045, 21052, 21070, 21072, 21079, 21080, 21083, 21087, 21104, 21109, 21110, 21116, 21127, 21136, 21151, 21161, 21169, 21178, 21185, 21202, 21243, 21251, 21258, 21273, 21294, 21298, 21361, 21395, 21940, 22119, 22122, 22123, 22320, 22335, 22341, 22400, 22500, 22538, 22546, 22549, 22575, 22599, 22673, 22722, 22761, 22808, 22920, 22994, 22997, 23003, 23059, 23062, 23080, 23139, 23550, 23717, 23768, 23837, 23864, 33387, 33391, 33410, 33415, 33417, 33424, 33456, 33466, 33470, 33485, 33683, 33797, 33813, 33817, 33826, 33832, 33846, 33850, 33852, 33854, 33856, 33858, 33863, 33865, 33867, 33876, 33894, 33897, 33902, 33904, 33913, 33916, 33920, 33930, 33932, 33934, 33936, 33944, 33949, 33977, 33983, 33987, 33990, 33992, 33995, 33997, 33999, 34001, 34004, 34006, 34009, 34011, 34013, 34015, 34018, 34020, 34023, 34025, 34029, 34034, 34037, 34039, 34041, 34054, 34061, 34064, 34066, 34068, 34076, 34079, 34089, 34142, 34145, 34167, 34169, 34171, 34174, 34181, 34185, 34188, 34198, 34205, 34208, 34213, 34230, 34233, 34238, 34243, 34247, 34253, 34259, 34266, 34267, 34269, 34337, 34340, 34341, 34345, 34349, 34351, 34356, 34358, 34366, 34368, 34382, 34386, 34388, 34390, 34396, 34398, 34403, 34409, 34411, 34417, 34419, 34424, 34427, 34434, 34436, 34438, 34443, 34446, 34455, 34460, 34462, 34464, 34466, 34469, 34471, 34474, 34476, 34478, 34488, 34490, 34492, 34499, 34506, 34519, 34521, 34524, 34526, 34528, 34530, 34532, 34534, 34537, 34539, 34542, 34544, 34546, 34548, 34551, 34553, 34556, 34558, 34560, 34576, 34584, 34586, 34588, 34590, 34601, 34609, 34617, 34628, 34642, 34660, 34668, 34670, 34675, 34679, 34684, 34694, 34705, 34713, 34718, 34730, 34735, 34737, 34739, 34759, 34764, 34768, 34778, 34785, 34787, 34792, 34799, 34813, 34816, 34818, 34875, 34890, 34894, 34896, 34898, 34904, 34908, 34910, 34916, 34922, 34928, 34934, 34940, 34942, 34944, 34950, 34952, 34956, 34960, 34962, 34967, 34971, 34973, 34976, 34978, 34981, 34983, 34985, 34987, 34990, 34995, 34997, 34999, 35001, 35004, 35006, 35009, 35011, 35013, 35018, 35020, 35029, 35046, 35049, 35056, 35061, 35071, 35075, 35079, 35081, 35084, 35086, 35089, 35091, 35093, 35095, 35098, 35100, 35109, 35112, 35114, 35148, 35158, 35203, 35208, 35211, 35251, 35256, 35261, 35270, 35273, 35278, 35282, 35287, 35293, 35300, 35309, 35314, 35317, 35322, 35341, 35346, 35349, 35358, 35447, 35453, 35455, 35457, 35461, 35463, 35474, 35476, 35481, 35488, 35490, 35493, 35497, 35499, 35502, 35514, 35519, 35523, 35525, 35529, 35531, 35534, 35538, 35556, 35559, 35569, 35578, 35584, 35598, 35601, 35604, 35606, 35608, 35611, 35613, 35616, 35618, 35620, 35622, 35630, 35634, 35636, 35639, 35643, 35651, 35654, 35675, 35727, 35732, 35782, 35793, 35814, 35819, 35824, 35835, 35843, 35861, 35871, 35880, 35887, 35890, 35893, 35917, 35925, 35944, 35946, 35948, 35961, 35968, 35984, 35995, 36023, 36028, 36030, 36032, 36034, 36036, 36038, 36040, 36042, 36044, 36046, 36048, 36050, 36052, 36054, 36061, 36063, 36065, 36067, 36069, 36071, 36076, 36079, 36082, 36086, 36089, 36092, 36094, 36098, 36101, 36238, 36240, 36242, 36244, 36297, 36304, 36309, 36314, 36320, 36344, 36394, 36408, 36611, 36614, 36617, 36620, 36625, 36629, 36633, 36757, 36760, 36762, 36765, 36767, 36769, 36771, 36774, 36779, 36783, 36794, 36831, 36835, 36869, 36915, 36937, 37112, 37153, 37156, 37158, 37161, 37164, 37166, 37169, 37171, 37174, 37176, 37182, 37185, 37187, 37196, 37200, 37202, 37206, 37217, 37224, 37234, 37238, 37244, 37248, 37254, 37258, 37261, 37267, 37269, 37271, 37273, 37275, 37277, 37285, 37293, 37297, 37300, 37302, 37306, 37308, 37311, 37318, 37339, 37344, 37353, 37358, 37369, 37374, 37434, 37446, 37449, 37454, 37458, 37461, 37466, 37480, 37486, 37489, 37491, 37501, 37525, 37529, 37534, 37556, 37575, 37583, 37590, 37595, 37605, 37614, 37619, 37629, 37631, 37633, 37636, 37641, 37654, 37657, 37666, 37672, 37674, 37678, 37740, 37741, 37743, 37745, 37747, 37749, 37750, 37752, 37754, 37755, 37757, 37760, 37763, 37764, 37766, 37767, 37769, 37772, 37773, 37777, 37789, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 38129, 38144, 39464, 39717, 39719, 39722, 39724, 39727, 39730, 39732, 39741, 39746, 39751, 39760, 39782, 39806, 39822, 39841, 39842, 39869, 39876, 39881, 39889, 43156, 44650, 44652, 44654, 44658, 44662, 44666, 44670, 44674, 44678, 44682, 44686, 44690, 44694, 44743, 44750, 44757, 44764, 44776, 44787, 44796, 44909, 44929, 45007, 45152, 45186, 45190, 45198, 45200, 45210, 45212, 45220, 45226, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45333, 45342, 45349, 45354, 45365, 45386, 45390, 45403, 45410, 45416, 45429, 45461, 45472, 45487, 45517, 45526, 45554, 45574, 45589, 45750, 45771, 45797, 45805, 45876, 45897, 46502, 46504, 46671, 46705, 48101, 48103, 48105, 48111, 48115, 48117, 48119, 48123, 48125, 48127, 48129, 48131, 48150, 48154, 48158, 48162, 48166, 48170, 48174, 48178, 48182, 48186, 48190, 48194, 48197, 48223, 48225, 48236, 48280, 48308, 48443, 48551, 48553, 48643, 48645, 48675, 48677, 48679, 48685, 48687, 48689, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48709, 48714, 48729, 48732, 48734, 48744, 48754, 48777, 48791, 48805, 48817, 48858, 48933, 48938, 48942, 48947, 48952, 48956, 48967, 48982, 48990, 49036, 49043, 49044, 49058, 49066, 49100, 50346, 50347, 50349, 50351, 50357, 50359, 50365, 50372, 50377, 50386, 50644, 50647, 50656, 50659, 50664, 50676, 50680, 52162, 52164) 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

Dance: I: The Lunaticks (new)-Fausan, Signora Fausan, Muilment, Mlle Chateauneuf

Ballet: V: The Enchanted Garden (new). Harlequin Man and Woman-Fausan, Signora Fausan; Shepherd and Shepherdess-Muilment, Mlle Chateauneuf; Scaramouch Man and Woman-Desse, Mrs Walter; Pierot Man and Woman-Nivelon, Miss Thompson; Petit Maitre-Macklin

Performances

Mainpiece Title: As You Like It

Cast
Role: Audry Actor: Mrs Egerton
Role: Caelia Actor: Mrs Clive
Role: Rosalind Actor: Mrs Pritchard.

Afterpiece Title: Robin Goodfellow

Dance: II: French Peasants-Nivelon, Mlle Duval; V: Serious Ballet-Maltere, Mlle Maltere

Ballet: I: The Enchanted Garden. As17401215, but Magician-Leviez

Performances

Mainpiece Title: As You Like It

Cast
Role: Audry Actor: Mrs Egerton
Role: Caelia Actor: Mrs Clive
Role: Rosalind Actor: Mrs Pritchard.

Afterpiece Title: The Fortune Tellers

Dance: I: French Peasants, as17401226; III: L'Allamande, as17401222; V: Grand Serious Ballet-Maltere, Mlle Maltere

Performances

Mainpiece Title: As You Like It

Cast
Role: Audry Actor: Mrs Egerton
Role: Caelia Actor: Mrs Clive
Role: Rosalind Actor: Mrs Pritchard.

Afterpiece Title: Robin Goodfellow

Dance: I: French Peasants-Nivelon, Mlle Duval; III: La Tambourine Matelote-Maltere, Mlle Maltere

Performances

Mainpiece Title: As You Like It

Cast
Role: Audry Actor: Mrs Egerton
Role: Caelia Actor: Mrs Clive
Role: Rosalind Actor: Mrs Pritchard.

Afterpiece Title: Robin Goodfellow

Dance: I: French Peasants-Nivelon, Mlle Duval; III: La Provencale-Mlle Chateauneuf; IV: La Tambourin Matelote-Maltere, Mlle Maltere

Performances

Mainpiece Title: Twelfth Night; Or, What You Will

Cast
Role: Maria Actor: Mrs Macklin
Role: Viola Actor: Mrs Pritchard
Role: Olivia Actor: Mrs Clive.

Afterpiece Title: The Fortune Tellers

Song: In II: Songs by Mr Arne-Lowe

Dance: II: French Peasants-Nivelon, Mlle Duval; IV: La Tambourin Matelote-Maltere, Mlle Maltere

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Maria Actor: Mrs Macklin
Role: Viola Actor: Mrs Pritchard
Role: Olivia Actor: Mrs Clive.

Afterpiece Title: The Fortune Tellers

Song: As17410115

Dance: III: L'Arlequine deux Visages-Mlle Chateauneuf; V: La Tambourin Matelote-Maltere, Mlle Maltere

Performances

Mainpiece Title: Twelfth Night

Cast
Role: Maria Actor: Mrs Macklin
Role: Viola Actor: Mrs Pritchard
Role: Olivia Actor: Mrs Clive.

Afterpiece Title: The Fortune Tellers

Song: As17410115

Dance: I: Desse; III: La Tambourin Matelote-Maltere, Mlle Maltere; V: L'Arlequin deux Visages-Mlle Chateauneuf

Performances

Mainpiece Title: As You Like It

Cast
Role: Audry Actor: Mrs Egerton
Role: Caelia Actor: Mrs Clive
Role: Rosalind Actor: Mrs Pritchard.

Afterpiece Title: The Fortune Tellers

Dance: I: Desse; III: French Peasants-Nivelon, Mlle Duval; V: La Tambourin Matelote-Maltere, Mlle Maltere

Performances

Dance: LLes Masons & Les Sabotiers-Fausan, Signora Fausan; Les Matelotes-Fausan, Signora Fausan

Performances

Mainpiece Title: The Provok'd Husband

Cast
Role: Lady Grace Actor: Mrs Mills
Role: Lady Wronghead Actor: Mrs Macklin
Role: Jenny Actor: Mrs Walter
Role: Mrs Motherly Actor: Mrs Egerton
Role: Myrtilla Actor: Mrs Wright
Role: Lady Townly Actor: Mrs Clive.

Afterpiece Title: The Fortune Tellers

Dance: II: French Peasants-Nivelon, Mlle Duval; IV: La Tambourin Matelote-Maltere, Mlle Maltere

Performances

Dance: LL'Hydropique Amoureux, Les Matelotes-Fausan, Signora Fausan

Performances

Afterpiece Title: The Virgin Unmask'd

Cast
Role: Lucy Actor: Mrs Clive

Dance: I: L'Allemande-Muilment, Mlle Chateauneuf; III: Shepherds and Shepherdesses-Muilment, Mlle Chateauneuf

Music: V: Solo on Violin-Collett

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Molly Actor: Mrs Thompson.
Role: Polly Actor: Mrs Clive
Role: Lucy Actor: Mrs Pritchard
Role: Diana Trapes Actor: Mrs Macklin
Role: Mrs Coaxer Actor: Mrs Wright
Role: Dolly Trull Actor: Mrs Penkethman
Role: Molly Brazen Actor: Mrs Sampson
Role: Mrs Vixen Actor: Mrs Walter.

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: La Tambourine-Mlle Chateauneuf; II: Shepherds and Shepherdesses-Muilment, Mlle Chateauneuf; in III: Hornpipe-Vaughan

Performances

Mainpiece Title: Comus

Dance: LLe Boufon-the Fausans; Le Genereux Corsaire, as17411021

Performances

Mainpiece Title: Comus

Dance: LLe Boufon, as17411030; Les Masons et Les Sabotiers, as17411218