SELECT * FROM london_stages WHERE eventid IN (1136, 1728, 9133, 9199, 10347, 10353, 10404, 10406, 10424, 10435, 10445, 10458, 10488, 10570, 10584, 10590, 10731, 10738, 10760, 10798, 10863, 11813, 11828, 11855, 11859, 11880, 11948, 11966, 11981, 11983, 11985, 12024, 12031, 12078, 12083, 12089, 12095, 12108, 12118, 12123, 12134, 12138, 12148, 12172, 12644, 12693, 12697, 12701, 12704, 12713, 12723, 12726, 12734, 12737, 12738, 12741, 12743, 12746, 12749, 12751, 13026, 13044, 13048, 13057, 13145, 13194, 13566, 13568, 14332, 14866, 14878, 14929, 15003, 16233, 16239, 16245, 16252, 16282, 16328, 16344, 16366, 16388, 16395, 17827, 17831, 17833, 17841, 17845, 17850, 17855, 17860, 17873, 17883, 17890, 17916, 17925, 17986, 17997, 18002, 18007, 18014, 18019, 18020, 18022, 18031, 18033, 18037, 18041, 18044, 18047, 18049, 18052, 18056, 18067, 18070, 18085, 18087, 18090, 18092, 18094, 18098, 18100, 18110, 18184, 18186, 18188, 18194, 18269, 18272, 18274, 18279, 18282, 18284, 18290, 18294, 18296, 18298, 18301, 18305, 18308, 18312, 18316, 18328, 18330, 18340, 18344, 18351, 18354, 18360, 18379, 18404, 18414, 18423, 18424, 18427, 18435, 18439, 18440, 18442, 18448, 18452, 18456, 18677, 18699, 18712, 18736, 18757, 18886, 18892, 18897, 18901, 18903, 18904, 18932, 18948, 18977, 18979, 18982, 19101, 19245, 19251, 19255, 19261, 19263, 19271, 19300, 19348, 19351, 19364, 19370, 19372, 19391, 19591, 19596, 19612, 19708, 19710, 19714, 19717, 19719, 19721, 19723, 19724, 19725, 19727, 19729, 19731, 19733, 19735, 19739, 19743, 19747, 19759, 19780, 19803, 19808, 19838, 26113, 27112, 27114, 27608, 28278, 28329, 28338, 28352, 31984, 34375, 34377, 34380, 34384, 34390, 34394, 34415, 34453, 34485, 34521, 34598, 34668, 34694, 34713, 34723, 34725, 34739, 34754, 34759, 34782, 34785, 34794, 34805, 36153, 36655, 38158, 40591, 40905, 40951, 40956, 40960, 41102, 41103, 41105, 41106, 41107, 41108, 41109, 41110, 41111, 41112, 41113, 41476, 41485, 41491, 41494, 41496, 41500, 41502, 41503, 41505, 41508, 41510, 41513, 41518, 41527, 41529, 41532, 41534, 41542, 41544, 41547, 41559, 41562, 41564, 41569, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 42085, 42102, 42111, 42142, 42187, 42194, 42198, 42222, 42226, 42227, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42764, 42766, 42767, 42770, 42772, 42780, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42815, 42817, 42818, 42821, 42825, 42827, 42829, 42830, 42831, 42833, 42834, 42835, 42837, 42841, 42843, 42847, 42849, 42924, 42934, 42940, 42946, 42954, 42965, 43024, 43174, 43189, 43206, 43250, 43380, 43390, 43398, 43402, 43407, 43420, 43423, 43812, 43852, 43963, 43970, 43975, 43977, 43979, 43981, 43984, 43985, 43986, 43988, 43991, 43992, 44001, 44006, 44007, 44009, 44010, 44011, 44012, 44013, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44469, 44508, 44512, 44519, 44528, 44545, 44577, 44579, 44583, 44585, 44715, 44717, 44719, 44721, 44723, 44726, 44728, 44731, 44733, 44735, 44737, 44740, 44743, 44746, 44748, 44750, 44752, 44755, 44757, 44760, 44762, 44764, 44766, 44769, 44771, 44774, 44776, 44783, 44794, 44805, 44808, 44811, 44817, 44820, 44825, 44832, 44834, 44837, 44847, 44853, 44863, 44907, 44957, 48760, 48762, 48768, 48770, 48772, 48782, 48784, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48827, 48831, 48845, 48850, 48852, 48859, 48864, 48866, 48880, 48883, 48891, 48903, 48919, 48928, 48931, 48948, 51055, 51062, 51189, 51204, 51229) 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: A Quarter Of An Hour Before Dinner

Afterpiece Title: THE HAUNTED TOWER

Afterpiece Title: THE CITIZEN

Performances

Mainpiece Title: Merope

Dance: End I: L'Offrande a Terpsichore, as17971202

Ballet: End Opera: an entirely new allegorical Ballet, composed by Gallet [with music by Bossi] Le Triomphe de Themis[-Mme Rose, Mme Laborie, Laborie, Didelot, Mlle Hilligsberg, Mme Hilligsberg. [Cast from Morning Herald, 25 Dec.: America-Mme Rose, Didelot; Europe-Mme Laborie; Africa-Mlle Hilligsberg; Asia-Mme Hilligsberg[. Ibid, 26 Dec., also lists, unassigned: Themis-; Neptune-; Eolus-; Hope-; Genius of Britain-; Thames-; Genius of France-; Genius of Spain-; Genius of Holland-; Arts and Commerce-; Discord-; Jacobinism-; The Eumenides-; The Crimes-[and has synopsis of action]

Cast
Role: Genius of Britain Actor:
Role: Genius of France Actor:
Role: Genius of Spain Actor:
Role: Genius of Holland Actor:

Performances

Mainpiece Title: Merope

Dance: As17971220

Ballet: Le Triomphe de Themis. As17971220

Cast
Role: Genius of Britain Actor:
Role: Genius of France Actor:
Role: Genius of Spain Actor:
Role: Genius of Holland Actor:

Performances

Mainpiece Title: L'allegro [ed] Il Pensieroso 0; Messiah

Afterpiece Title: L'Allegro Il Pensieroso 3

Cast
Role: Genius of England Actor:

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of Handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: concerto on violin-Master Pinto; End II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of handel; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End I: Bach's Bach's favourite concertante for flute oboe violin and violoncello-Monzani, W. Parke, G. and C. Ashley