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, 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) 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: Cashell

Afterpiece Title: Orpheus and Eurydice

Dance: TThe Italian Peasants, as17411024

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: LLes Matelotes-Sg and Sga Fausan; Le Genereux Corsaire, as17411102

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: Particularly, Les Matelotes, as17411110; Les Jardiniers Suedois-Fausan, Sga Fausan, LaCroix, Delamain, Dumont, Constantini, Mrs Walter, Mrs Thompson, Mrs Rayner, Miss Wright; With new decorations

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: LLe Genereux Corsaire-Fausan, Signora Fausan only; but see17411214

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: Harlequin Shipwrecked

Dance: I: The French Peasants-the Mechels; III: A Dutch Dance, as17411114; IV: Les Matelotes, as17411208

Song: II: Happy Pair-Beard

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Ballet: into it will be introduc'd the Rinto it will be introduc'd the +Rural Assembly. As17420121

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Dance: Entertainments, as17420210, but Dubuisson, Mme +Bonneval; +Chacone, as17411230; Saraband-Sga Barbarina; La Provencale, as17420212

Ballet: After: Rural Assembly. As17420121

Performances

Mainpiece Title: She Woud If She Coud

Cast
Role: Sir Oliver Actor: Hippisley.

Dance: TTyrolean Dance, as17420206; The Peasants, as17420210

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: I: A Concerto, as17420105; III: The Swiss, as17410926; V: Le Boufon, as17411030

Song: II: See from the Silent Groves-Beard; IV: Happy Pair-Beard

Performances

Mainpiece Title: She Woud If She Coud

Cast
Role: Sir Oliver Actor: Hippisley.

Dance: TThe Peasants, as17420210; Tyrolean Dance, as17420206; Les Maquignons-Delamain; accompanied- Delagarde, Richardson, Davenport, Destrade

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Song: I: a Song with French Horns-Beard; III: A Ballad-Lowe

Dance: II: Les Matelotes, as17411110

Ballet: V: Les Satires Puny. As17420304

Performances

Mainpiece Title: She Woud If She Coud

Cast
Role: Sir Oliver Actor: Hippisley.

Dance: MMusette-Picq, Mlle Auguste; New Scots Dance, as17420401 New Dance call'd the Hussar-Desnoyer, Sga Domitilla; New Comic Dance-Picq, Mlle Auguste; Louvre, Minuet By Desire-Desnoyer, Sga Barbarina

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: The Virgin Unmasked

Dance: I: Les Jardiniers Suedois-the Mechels; II: A Grand Ball Dance-Mechel Sen, Mechel Jr, Mlle Mechel; IV: The Cuckow Dance-the Mechels; V: The German Hussar-the Mechels

Song: III: Song-Beard

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Dance: I: The Peasants, as17420210; III: Minuet (by desire)-Destrade, Mlle Auguste; New Comic Dance, Pantaloon and Enamorata, as17420420

Song: II: Ruddier than the Cherry, out of Acis and Galetea (Set by Handel),-Reinhold; IV: True Blue-Roberts

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: Miss Lucy in Town

Dance: I: A Concerto, as17420105; IV: Le Boufon, as17420325

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Song: III: Song-Beard

Music: IV: Concerto-Veracini

Dance: II: La Mascarada, as17421009; V: Les Matelotes, as17421009

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: Miss Lucy in Town

Song: I: Song-Beard

Dance: V: Turkish Seraglio, as17421025, but With New Habits and Decorations

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: Miss Lucy in Town

Dance: I: Grand Comic Dance-Torinese, Signora Aquilanti; V: Les Moisoneurs de la Styrie, as17421126

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Dance: I: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars-Checo, Chiaretti

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: The King and Miller of Mansfield

Song: III: Beard

Music: II: Concerto on German Flute-Burke Thumoth; V: Concerto on Violincello-Cervetti

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Havard

Afterpiece Title: The King and Miller of Mansfield

Dance: I: New Ballet, as17430502; IV: A New Hussar Dance, as17430425

Music: II: New Concerto on German Flute-Burk Thumoth; V: Concerto on Violin-Piantanida

Song: III: The Noontide Air-Sullivan

Performances

Mainpiece Title: As You Like It

Cast
Role: Oliver Actor: Cashell

Afterpiece Title: The Royal Chace