SELECT * FROM london_stages WHERE eventid IN (662, 718, 1282, 1302, 1457, 1533, 2435, 2840, 3075, 3557, 3599, 3830, 3884, 3886, 3952, 4033, 4057, 4099, 4100, 4102, 4103, 4114, 4148, 4289, 4385, 4604, 4669, 4697, 4753, 4924, 5192, 5239, 5333, 5406, 5472, 5666, 6022, 6363, 6544, 6620, 6743, 7077, 7514, 7920, 7939, 8435, 8870, 9037, 9326, 9570, 9626, 10155, 10831, 11189, 11191, 11263, 11581, 11583, 11586, 11589, 11591, 11593, 11756, 11958, 12984, 13964, 14231, 14297, 14302, 14345, 14456, 14892, 15957, 15961, 15965, 15967, 15971, 15975, 16017, 16111, 16312, 16375, 16426, 16643, 17076, 17512, 18559, 20069, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20435, 20438, 20457, 20532, 20607, 20610, 20641, 20676, 20690, 20763, 20764, 20766, 20767, 20769, 20770, 20771, 20772, 20796, 20797, 20829, 20878, 20893, 20941, 20991, 21013, 21031, 21093, 21133, 21153, 21154, 21157, 21210, 21217, 21241, 21310, 21338, 21368, 21388, 21460, 21509, 21544, 21834, 22003, 22004, 22009, 22011, 22018, 22035, 22076, 22104, 22154, 22182, 22213, 22253, 22271, 22314, 22367, 22395, 22478, 22581, 22783, 22844, 22967, 23022, 23077, 23532, 23561, 23728, 23822, 23926, 23966, 24126, 24265, 24394, 25459, 25486, 25504, 25511, 26117, 26280, 26320, 26347, 26513, 26573, 26643, 26698, 26749, 27103, 27175, 27458, 27614, 27657, 27739, 28095, 28226, 28522, 28646, 28723, 28842, 29054, 29151, 29247, 29381, 29972, 29976, 29979, 29982, 29984, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30053, 30056, 30064, 30074, 30094, 30096, 30118, 30131, 30154, 30282, 30296, 30301, 30316, 30330, 30334, 30375, 30384, 30409, 30411, 30428, 30442, 30456, 30464, 30471, 30521, 30562, 30565, 30609, 30630, 30645, 30794, 30814, 30817, 30848, 30873, 31041, 31060, 31166, 31190, 31260, 31341, 31381, 31402, 31438, 31534, 31535, 31681, 31721, 31754, 31848, 31912, 31978, 32027, 32174, 32205, 32250, 32361, 32661, 32702, 32893, 33130, 33186, 33254, 33497, 33560, 33660, 33849, 33857, 33884, 34155, 34178, 34381, 34781, 34921, 35319, 35324, 35325, 35363, 35520, 35549, 35553, 35583, 35597, 35603, 35648, 35684, 35747, 35751, 35789, 35792, 35827, 35856, 35869, 35943, 35970, 35983, 35994, 36118, 36145, 36248, 36460, 36568, 36719, 37021, 37274, 37540, 37592, 37604, 37656, 37671, 37775, 37790, 37815, 37838, 37840, 37844, 37916, 37931, 37946, 37997, 38012, 38048, 38112, 38124, 38136, 38178, 38208, 38224, 38315, 38334, 38341, 38547, 38549, 38551, 38554, 38555, 38645, 38682, 38737, 38743, 38885, 38909, 38918, 38937, 38940, 38946, 38976, 39052, 39093, 39107, 39123, 39213, 39245, 39257, 39265, 39291, 39293, 39296, 39298, 39301, 39303, 39306, 39312, 39315, 39317, 39320, 39322, 39324, 39326, 39329, 39331, 39335, 39339, 39343, 39346, 39349, 39478, 39482, 39484, 39489, 39495, 39504, 39516, 39522, 39530, 39534, 39536, 39544, 39548, 39553, 39558, 39562, 39569, 39576, 39586, 39597, 39623, 39627, 39634, 39639, 39646, 39666, 39697, 39702, 39711, 39716, 39719, 39723, 39731, 39740, 39745, 39754, 39764, 39772, 39781, 39786, 39802, 39826, 39827, 39830, 39840, 39859, 39862, 39873, 39886, 39907, 40025, 40033, 40037, 40052, 40057, 40064, 40076, 40088, 40100, 40108, 40127, 40141, 40155, 40180, 40194, 40201, 40209, 40223, 40237, 40249, 40262, 40275, 40288, 40301, 40330, 40359, 40373, 40388, 40402, 40405, 40432, 40447, 40453, 40466, 40565, 40568, 40586, 40595, 40616, 40650, 40695, 40705, 40751, 40776, 40778, 40806, 40832, 40851, 40875, 40880, 40893, 40899, 40927, 40950, 40952, 40964, 40977, 40986, 41134, 41144, 41151, 41153, 41183, 41228, 41256, 41261, 41272, 41298, 41326, 41358, 41371, 41375, 41399, 41401, 41414, 41457, 41470, 41473, 41474, 41484, 41498, 41514, 41523, 41537, 41552, 41567, 41575, 41698, 41708, 41726, 41745, 41746, 41769, 41779, 41786, 41792, 41811, 41833, 41860, 41909, 41925, 41950, 41966, 41974, 42016, 42025, 42057, 42067, 42090, 42092, 42136, 42166, 42286, 42288, 42311, 42319, 42323, 42344, 42366, 42416, 42471, 42503, 42641, 42676, 42711, 42718, 42723, 42791, 42795, 42798, 42888, 42964, 42985, 43228, 43259, 43436, 43467, 43477, 43499, 43560, 43617, 43655, 43657, 43685, 43742, 43769, 43843, 43846, 43857, 43880, 43904, 44013, 44028, 44130, 44156, 44195, 44244, 44266, 44278, 44381, 44406, 44473, 44588, 44614, 44650, 44651, 44652, 44654, 44658, 44662, 44666, 44670, 44674, 44678, 44682, 44686, 44690, 44694, 44732, 44743, 44750, 44757, 44763, 44764, 44776, 44787, 44796, 44833, 44889, 44906, 44909, 44914, 44929, 44954, 44977, 45007, 45012, 45054, 45143, 45160, 45187, 45195, 45236, 45243, 45294, 45346, 45371, 45453, 45499, 45524, 45559, 45567, 45574, 45589, 45594, 45672, 45710, 45715, 45768, 45826, 45896, 45913, 45915, 45917, 45922, 45927, 45928, 45934, 45945, 45979, 46005, 46036, 46146, 46150, 46168, 46272, 46355, 46357, 46373, 46389, 46532, 46546, 46641, 46713, 46865, 46874, 46895, 46896, 46905, 46910, 46934, 46937, 46958, 46970, 46978, 46995, 47011, 47039, 47045, 47048, 47062, 47092, 47100, 47123, 47155, 47172, 47211, 47261, 47284, 47442, 47447, 47448, 47449, 47453, 47457, 47458, 47463, 47568, 47575, 47704, 47714, 47729, 47754, 47768, 47769, 47783, 47815, 47871, 47893, 47899, 47992, 48017, 48044, 48067, 48106, 48177, 48235, 48263, 48369, 48383, 48423, 48431, 48550, 48552, 48554, 48556, 48558, 48562, 48564, 48568, 48574, 48578, 48582, 48587, 48589, 48593, 48595, 48599, 48610, 48614, 48626, 48636, 48644, 48652, 48657, 48666, 48668, 48670, 48676, 48678, 48679, 48684, 48686, 48688, 48690, 48692, 48694, 48698, 48699, 48700, 48706, 48710, 48718, 48720, 48726, 48728, 48736, 48746, 48748, 48750, 48756, 48776, 48778, 48780, 48786, 48788, 48790, 48792, 48794, 48797, 48799, 48802, 48804, 48806, 48808, 48811, 48813, 48816, 48818, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48880, 48883, 48885, 48888, 48891, 48893, 48896, 48899, 48900, 48903, 48909, 48910, 48917, 48919, 48924, 48928, 48931, 48932, 48934, 48939, 48946, 48953, 48957, 48960, 48962, 48987, 48994, 48999, 49011, 49025, 49031, 49047, 49062, 49085, 49099, 49102, 49111, 49134, 49165, 49170, 49175, 49178, 49182, 49235, 49259, 49271, 49295, 49389, 49391, 49403, 49416, 49421, 49426, 49440, 49540, 49558, 49654, 49658, 49668, 49685, 49687, 49695, 49700, 49702, 49711, 49713, 49717, 49718, 49729, 49730, 49734, 49736, 49740, 49741, 49744, 49745, 49746, 49747, 49749, 49750, 49751, 49752, 49753, 49767, 49784, 49786, 49804, 49818, 49830, 49854, 49920, 49925, 49956, 50081, 50207, 50251, 50256, 50260, 50271, 50279, 50284, 50286, 50287, 50291, 50296, 50297, 50302, 50303, 50307, 50314, 50317, 50318, 50341, 50390, 50439, 50465, 50507, 50535, 50577, 50592, 50596, 50601, 50610, 50615, 50619, 50623, 50626, 50627, 50628, 50631, 50632, 50634, 50635, 50637, 50638, 50639, 50640, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50683, 50687, 50689, 50690, 50692, 50695, 50706, 50713, 50730, 50731, 50735, 50741, 50743, 50746, 50748, 50751, 50761, 50769, 50773, 50776, 50781, 50783, 50785, 50789, 50791, 50794, 50796, 50799, 50887, 50891, 50892, 50898, 50900, 50902, 50914, 50924, 50930, 50938, 50941, 50962, 50969, 50989, 51001, 51003, 51005, 51007, 51009, 51014, 51016, 51017, 51018, 51021, 51027, 51029, 51033, 51036, 51041, 51045, 51078, 51086, 51087, 51125, 51127, 51129, 51134, 51137, 51146, 51150, 51153, 51226, 51241, 51244, 51247, 51249, 51252, 51254, 51256, 51258, 51261, 51271, 51285, 51288, 51289, 51298, 51330, 51336, 51360, 51403, 51410, 51416, 51425, 51440, 51447, 51455, 51456, 51467, 51474, 51478, 51493, 51530, 51548, 51606, 51630, 51649, 51652, 51663, 51709, 51721, 51733, 51746, 51798, 51810, 51819, 51842, 51886, 51950, 51953, 51988, 52004, 52013, 52021, 52026, 52035, 52037, 52041, 52045, 52052, 52067, 52071, 52086, 52107, 52135, 52145, 52177, 52288, 52293, 52316, 52393, 52455, 52477, 52481, 52505, 52586, 52605, 52610) 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: As You Like It

Cast
Role: Oliver Actor: Cashel

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: Oliver Actor: Cashel

Dance: I: La Provencale-Mlle Chateauneuf; II: Le Boufon-Fausan, Signora Fausan

Ballet: V: The Enchanted Garden. As17401226

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

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: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: I: Diane a la Chasse, as17401229; III: Ballet of Shepherds and Shepherdesses, as17401229; V: Les Jardiniers Suedois, as17410102

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: I: Diane a la Chasse, as17401229; III: La Matelote-Mlle Chateauneuf; V: Les Jardiniers Suedois, as17410102

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: III: La Matelote-Mlle Chateauneuf; V: Les Jardiniers Suedois, as17410102

Ballet: II: The Enchanted Garden. As17401226

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: II: Diane a la Chasse, as17401229; V: Les Jardiniers Suedois, as17410102

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: LLes Jardiniers Suedois-Fausan, Signora Fausan, Mlle Chateauneuf, Muilment; Les Masons & Les Sabotiers-Fausan, Signora Fausan

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Afterpiece Title: The Fortune Tellers

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

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: LLes Jardiniers Suedois, as17401229; Les Matelotes-Fausan, Signora Fausan

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: I: L'Arlequine deux visages-Mlle Chateauneuf; V: La Provencale-Mlle Chateauneuf

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Afterpiece Title: The Devil to Pay

Dance: II: La Tambourine-Mlle Chateauneuf; III: Les Caprices des Rebelles-Mlle Maltere; IV: La Terpsichore-Mlle Chateauneuf; V: Miss Scott

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: LLes Masons & Les Sabotiers, Les Jardiniers Suedois-Fausan, Signora Fausan

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: SSerious Dance-Signora Fausan; Les Masons & Les Sabotiers-Fausan, Muilment, Desse

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: LLes Matelots-Fausan, Signora Fausan; The Peasants' Triumph-Fausan, Signora Fausan

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashel

Dance: LLe Boufon-Fausan, Signora Fausan; Les Jardiniers Suedois-Fausan, Signora Fausan, Desse, Mlle Chateauneuf

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: I: a Ballet-Desse; II: a Comic Dance between a Miller and his Wife-M Mechell, Mlle Mechel; A Sailor's Dance-Dumont, Mrs Walter

Song: II: Happy Pair-Beard; IV: Non Ch' Amarmi a Song of Farinelli's-Mrs Arne

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: The Royal Chace; or, Merlin's Cave

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: I: a Ballet, as17411015; III: Sailor's Dance, as17411015

Song: II: As17411015; IV: Non Ch' Amarmi-Mrs Arne

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: I: Ballet-Desse; III: Sailor's Dance-Dumont, Mrs Walter

Song: As17411015

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Song: As17411015

Dance: II: Ballet-Desse; IV: Sailor's Dance-Dumont, Mrs Walter

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: LLes Masons et Les Sabotiers, as17411027; Le Genereux Corsaire, as17411021