SELECT * FROM london_stages WHERE eventid IN (1983, 1990, 2005, 2022, 8636, 12342, 12345, 12361, 12404, 12407, 12410, 12415, 12438, 12443, 12479, 12528, 12538, 12584, 12589, 12592, 12595, 12599, 12602, 12607, 12613, 12617, 12626, 12638, 12639, 12644, 12693, 12697, 12701, 12704, 12713, 12723, 12726, 12731, 12734, 12737, 12738, 12741, 12743, 12746, 12749, 12751, 12760, 12866, 12868, 12873, 12876, 12878, 12886, 12889, 12912, 12918, 12922, 12926, 12933, 12946, 12971, 13015, 13024, 13031, 13039, 13044, 13046, 13048, 13051, 13057, 13062, 13065, 13069, 13072, 13075, 13078, 13082, 13086, 13090, 13093, 13097, 13100, 13104, 13108, 13126, 13129, 13140, 13145, 13155, 13159, 13163, 13166, 13170, 13174, 13177, 13180, 13184, 13188, 13191, 13194, 13197, 13201, 13205, 13207, 13209, 13212, 13215, 13217, 13220, 13224, 13227, 13232, 13237, 13244, 13249, 13255, 13276, 13284, 13291, 13295, 13302, 13310, 13314, 13317, 13325, 13334, 13342, 13350, 13375, 13382, 13389, 13394, 13402, 13411, 13435, 13445, 13452, 13470, 13479, 13488, 13593, 13595, 13657, 13663, 13677, 13797, 13801, 13809, 13812, 14090, 14102, 16055, 16059, 16062, 16065, 16172, 16286, 16307, 16316, 16337, 16351, 16403, 16482, 16850, 16854, 16858, 16862, 16866, 16870, 16874, 16878, 16886, 16890, 16910, 16922, 16926, 16933, 16937, 16941, 16945, 16949, 16956, 16960, 16985, 16989, 16993, 17060, 17134, 17224, 17311, 17328, 17342, 17347, 17352, 17512, 17515, 17518, 17526, 17537, 17540, 17604, 17634, 17647, 17651, 17655, 17658, 17668, 17671, 17674, 17677, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17803, 17851, 17856, 17861, 17891, 17940, 18123, 18184, 18186, 18188, 18194, 18203, 18206, 18210, 18214, 18226, 18228, 18231, 18239, 18241, 18244, 18248, 18250, 18253, 18259, 18269, 18272, 18273, 18274, 18277, 18279, 18280, 18282, 18284, 18288, 18290, 18294, 18296, 18298, 18299, 18301, 18305, 18306, 18308, 18309, 18312, 18316, 18317, 18324, 18328, 18330, 18335, 18338, 18340, 18344, 18348, 18351, 18354, 18355, 18360, 18361, 18365, 18368, 18376, 18379, 18382, 18384, 18385, 18388, 18391, 18398, 18404, 18412, 18414, 18423, 18424, 18427, 18439, 18440, 18442, 18446, 18448, 18452, 18456, 18460, 18468, 18471, 18475, 18479, 18482, 18488, 18492, 18493, 18495, 18503, 18504, 18515, 18516, 18519, 18526, 18530, 18538, 18541, 18551, 18602, 18614, 18625, 18635, 18646, 18657, 18677, 18682, 18699, 18712, 18723, 18729, 18736, 18757, 18765, 18794, 18807, 18810, 18816, 18824, 18830, 18839, 18863, 18872, 18880, 18882, 18886, 18892, 18897, 18899, 18904, 18905, 18906, 18910, 18912, 18932, 18933, 18935, 18937, 18954, 18955, 18973, 18975, 18989, 18993, 18996, 19017, 19022, 19027, 19035, 19036, 19041, 19043, 19047, 19050, 19052, 19055, 19057, 19064, 19065, 19067, 19069, 19072, 19074, 19075, 19077, 19079, 19080, 19082, 19083, 19084, 19092, 19094, 19100, 19101, 19102, 19103, 19105, 19107, 19109, 19111, 19112, 19115, 19121, 19122, 19123, 19125, 19126, 19127, 19131, 19134, 19136, 19145, 19149, 19152, 19156, 19162, 19164, 19166, 19167, 19168, 19172, 19175, 19178, 19179, 19182, 19184, 19186, 19187, 19190, 19191, 19195, 19198, 19202, 19204, 19205, 19216, 19227, 19234, 19242, 19271, 19293, 19300, 19302, 19306, 19308, 19334, 19335, 19341, 19343, 19345, 19355, 19356, 19369, 19375, 19393, 19395, 19397, 19404, 19408, 19419, 19421, 19462, 19474, 19485, 19489, 19498, 19502, 19509, 19515, 19517, 19521, 19532, 19534, 19537, 19548, 20118, 20120, 20122, 20685, 20704, 20733, 20747, 20764, 20767, 20770, 20772, 20775, 20797, 20800, 20806, 20810, 20818, 20849, 20855, 20858, 20861, 20868, 20893, 20949, 20965, 20974, 20991, 21001, 21005, 21011, 21031, 21049, 21070, 21077, 21093, 21127, 21147, 21151, 21166, 21182, 21227, 21241, 21251, 21255, 21258, 21263, 21267, 21271, 21273, 21276, 21279, 21281, 21282, 21285, 21290, 21296, 21312, 21358, 21361, 21373, 21387, 21393, 21395, 21421, 21426, 21428, 21435, 21449, 21452, 21463, 21471, 21483, 21493, 21510, 21518, 21522, 21525, 21527, 21532, 21538, 21545, 21549, 21552, 21555, 21558, 21560, 21562, 21565, 21571, 21574, 21577, 21582, 21585, 21588, 21599, 21603, 21612, 21615, 21618, 21620, 21624, 21627, 21630, 21633, 21639, 21648, 21652, 21660, 21665, 21668, 21671, 21675, 21678, 21683, 21688, 21707, 21756, 21780, 21782, 21793, 21800, 21804, 21828, 21843, 21856, 21862, 21879, 21900, 21902, 21905, 21907, 21918, 21920, 21923, 21925, 21940, 21942, 21965, 21972, 21975, 21977, 21979, 21984, 21987, 21989, 21991, 21993, 22003, 22004, 22009, 22014, 22018, 22020, 22039, 22051, 22054, 22059, 22061, 22066, 22067, 22069, 22079, 22094, 22109, 22114, 22139, 22152, 22156, 22169, 22172, 22177, 22186, 22219, 22222, 22225, 22227, 22238, 22261, 22273, 22319, 22322, 22325, 22328, 22331, 22334, 22337, 22343, 22347, 22431, 22473, 25122, 25124, 25126, 25129, 25132, 25135, 25137, 25139, 25141, 25144, 25147, 25149, 25152, 25155, 25158, 25160, 25163, 25166, 25169, 25173, 25176, 25179, 25184, 25188, 25238, 25260, 25656, 25817, 25821, 25823, 25826, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25887, 25897, 25903, 25910, 25915, 25926, 25933, 25942, 25949, 25951, 25953, 25964, 25983, 25985, 26052, 26062, 26084, 26095, 26111, 26116, 26157, 26303, 26312, 26318, 26321, 26324, 26327, 26330, 26351, 26356, 26362, 26435, 26598, 26625, 26632, 26720, 26759, 26776, 26787, 26806, 26839, 26983, 27027, 27106, 28460, 28485, 28497, 28542, 28544, 28550, 28760, 28778, 28780, 28791, 28798, 28814, 28824, 28840, 28853, 28858, 28862, 28865, 28867, 28870, 28872, 28875, 28877, 28880, 28883, 28886, 28888, 28892, 28897, 28903, 28909, 28916, 28920, 28923, 28931, 28936, 28940, 28943, 28951, 28957, 28965, 28977, 28996, 29012, 29020, 29210, 29222, 29265, 29313, 29337, 29420, 29500, 29584, 29834, 29836, 29918, 30056, 30058, 30064, 30071, 30104, 30131, 30144, 30146, 30150, 30154, 31839, 31841, 31847, 31849, 31853, 31985, 31987, 31989, 31991, 31993, 31995, 31998, 32000, 32003, 32005, 32007, 32009, 32012, 32014, 32017, 32019, 32021, 32023, 32026, 32028, 32030, 32032, 32034, 32036, 32039, 32041, 32045, 32047, 32049, 32051, 32054, 32057, 32059, 32061, 32063, 32066, 32068, 32078, 32083, 32090, 32095, 32097, 32102, 32106, 32114, 32131, 32224, 33356, 33359, 33361, 33363, 33365, 33368, 33370, 33373, 33375, 33377, 33379, 33384, 33389, 33393, 33396, 33398, 33401, 33403, 33407, 33419, 33436, 33440, 33442, 33444, 33447, 33449, 33452, 33454, 33475, 33477, 33482, 33484, 33490, 33492, 33525, 33530, 33539, 33551, 33553, 33558, 33560, 33571, 33573, 33581, 33586, 33593, 33602, 33614, 33648, 33650, 33658, 33660, 33663, 33665, 33668, 33670, 33672, 33674, 33677, 33679, 33682, 33686, 33694, 33696, 33699, 33701, 33703, 33708, 33711, 33716, 44470, 44474, 44502, 44505, 44513, 44516, 44524, 44531, 44540, 44551, 45350, 45362, 45370, 45375, 45382, 45387, 45391, 45404, 45421, 45426, 45430, 45434, 45447, 45452, 45507, 45527, 45545, 45575, 45598, 45606, 45609, 45612, 45615, 45620, 47145, 47151, 47157, 47162, 47168, 47174, 47180, 47184, 47187, 47193, 47199, 47205, 47215, 47221, 47227, 47232, 47239, 47245, 47250, 47256, 47262, 47267, 47274, 47280, 47286, 47292, 47298, 47305, 47308, 47310, 47317, 47324, 47332, 47336, 47343, 47347, 47354, 47358, 47364, 47573, 47795, 47801, 47806, 47816, 47821, 47826, 47836, 47846, 47856, 47861, 47875, 47888, 47900, 47903, 47906, 48253, 48262, 48267, 48276, 48278, 48281, 48285, 48289, 48290, 48294, 48295, 48299, 48304, 48318, 48323, 48332, 48337, 48349, 48350, 48359, 48364, 48373, 48378, 48387, 48392, 48399, 48405, 48414, 48419, 48446, 48452, 48455, 48460, 48463, 48468, 48898, 48908, 48912, 48922, 48926, 48937, 48941, 48951, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49508, 49512, 49516, 49517, 49519, 49520, 49521, 49524, 49526, 49528, 49530, 49533, 49538, 49555, 50206, 50216, 50222, 50227, 50233, 50244, 50252, 50255, 50261, 50464, 50473, 50485, 50490, 50499, 50504, 50532, 50541, 50574, 50636, 50681, 50685, 50740, 50745, 50750, 50755, 50760, 50761, 50765, 50775, 50787, 50793, 50798, 51010, 51019, 51025, 51034, 51039, 51055, 51062, 51106, 51109, 51111, 51113, 51115, 51120, 51123, 51125, 51127, 51129, 51134, 51137, 51141, 51146, 51149, 51151, 51153, 51155, 51160, 51163, 51165, 51167, 51169, 51248, 51251, 51253, 51311, 51315, 51384, 51389, 51393, 51398, 51409, 51414, 51436, 51443, 51501, 51509, 51513, 51517, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51603, 51617, 51624, 51629, 51634, 51643, 51645, 51648, 51650, 51655, 51657, 51659, 51681, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51755, 51777, 51779, 51780, 51782, 51784, 51786, 51789, 51792, 51799, 51801, 51806, 51808, 51811, 51813, 51817, 51820, 51825, 51828, 51833, 51836, 51841, 51843, 51849, 51851, 51856, 51864, 51866, 51868, 51869, 51871, 51873, 51877, 51885, 51900, 51902, 51907, 51914, 51927, 51929, 51931, 51933, 51936, 52057, 52074, 52077, 52093, 52097, 52099, 52102, 52104, 52106, 52108, 52116, 52118, 52122, 52126, 52128, 52130, 52132, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52170, 52172, 52180, 52184, 52186, 52188, 52190, 52194, 52221, 52241, 52243, 52259, 52262, 52264, 52267, 52269, 52271, 52274, 52277, 52280, 52282, 52286, 52291, 52331, 52332, 52335, 52338, 52341, 52343, 52344, 52347, 52350, 52351, 52355, 52356, 52386, 52389, 52391, 52405, 52408, 52413, 52415, 52425, 52427, 52429, 52432, 52434, 52437, 52439, 52442, 52447, 52449, 52451, 52452, 52454, 52456, 52458, 52461, 52466, 52468, 52471, 52473, 52476, 52481, 52483, 52495, 52497, 52499, 52504, 52509, 52511, 52513, 52516, 52562) 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: Il Tesoro

Dance: As17960607

Ballet: The Caravan at Rest. As17960607

Cast
Role: Negro Caffre Actor: Mme Hilligsberg

Performances

Mainpiece Title: Antigona

Dance: End I: a new Ballet in one act, Flore et Zephire-Didelot, Gentili, Fialon, Lahante, Hamoir, Giani, Roffey, Simpson, Master Menage, Mme Rose, Mme Hilligsberg, Mme Bossi, Mlle Parisot, Mme Vidi, Mlle Cabanel [Cast from Beaumont (see below): Cleonise-Mme Hilligsberg; +Flore-Mme Rose; +Bergeres-Mlle Parisot, Mme Bossi; +Zephire-Didelot; +L'Amour-Master Menage; +Un Petit Amour-Miss Hill.]; End Opera: [a new grand Dramatic Ballet in 3 acts, in the +Scotch style, L'Heureux Naufrage [; or, Les Sorcieres Ecossoises; Principal Performers in both dances-Didelot, Gentili, Fialon, Lahante, Hamoir, Giani, Roffey, Simpson, Master Menage, Mme Rose, Mme Hilligsberg, Mme Bossi, Mlle Parisot, Mme Vidi, Mlle Cabanel

Performances

Mainpiece Title: Antigona

Dance: Flore et Zephire, as17960707 but _Fialon, _Lahante, _Hamoir, _Giani, _Roffey, _Simpson, Master _Menage, Mme _Vidi, Mlle _Cabanel; L'Heureux Naufrage, as17960707 but _Fialon, _Lahante, _Hamoir, _Giani, _Roffey, _Simpson, Master _Menage, Mme _Vidi, Mlle _Cabanel

Performances

Mainpiece Title: L'amor Fra Le Vendemmie

Dance: End I: Flora et Zephire, as17961126

Ballet: End Opera: L'Amour et Psiche. L'Amour-Didelot; Psiche-Mme Hilligsberg (Oracle, 19 Dec.); Adonis-Gentili (Morning Chronicle, 19 Dec.); unassigned-Mme Rose, Mlle Parisot, Fialon

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: L'amor Fra Le Vendemmie

Dance: As17961213

Ballet: L'Amour et Psiche. As17961213

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: Peggy's Love-, as17961220

Ballet: End 2nd piece: L'Amour et Psiche. As17961213, but unassigned-Mlle _Parisot

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: a new Divertisement Ballet, composed by Gallet [with music by Viotti] Apollon Berger- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: As17961227

Ballet: L'Amour et Psiche. As17961227

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: a new Divertissement- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: Evelina

Dance: End I: Les Delassements Militaires-Mme Rose, Didelot, Mme Hilligsberg, Mlle Parisot, Marcadet (1st appearance)

Ballet: End Opera: L'Amour et Psiche. As17961213, but Tisiphone (1st time)-Marcadet

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: Evelina

Dance: As17970117

Ballet: L'Amour et Psiche. As17970117

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: The 1st Act Of La Modista Raggiratrice

Afterpiece Title: Il Consiglio Imprudente

Dance: End 1st piece: Les Delassements Militaires- As17970124

Ballet: End 2nd piece: Pizarre; ou, La Conquete du Perou (1st time; composed by Gallet [with music by Mazzinghi]). Pizarre-Gallet; the other characters-Mme Rose, Didelot, Mme Hilligsberg, Mlle Parisot, Marcadet, Gentili

Performances

Mainpiece Title: Il Consiglio Imprudente

Afterpiece Title: Le Nozze del Tamigi e Bellona

Dance: End I: Peggy's Love-, as17961220

Ballet: Ballet succeeding to and analogous to the Cantata. Doris-Mme Rose; Nerid-Didelot; Ocean-Gentili; Amphitrite-Mlle Parisot; Thetis-Mme Hilligsberg

Cast
Role: Thetis Actor: Mme Hilligsberg.

Performances

Mainpiece Title: Gli Schiavi Per Amore

Dance: End I: L'Heureux Retour, as17970401; Minuet de la Cour-Mme Rose, Didelot

Ballet: End Opera: Sapho et Phaon. Cast from synopsis (A. Dulau, 1797): Adonis-Miss Menage; L'Amour-Master Menage; Zephyre-Gentili; Vulcain-Fialon; Phaon-Didelot; Alcee-Simpson; Nemesis-Simpson [i.e. doubled]; Le Feu-Gentili [i.e. doubled]; L'Hypocrisie-Fialon [i.e. doubled]; Sapho-Mme Rose; Damophile-Mme Hilligsberg; Venus-Mlle Parisot

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: Evelina

Dance: End I: Divertissement, as17970103

Ballet: End Opera: L'Amour et Psiche. As17961213, but L'Amour-Mlle Parisot; unassigned-_Fialon

Cast
Role: Psiche Actor: Mme Hilligsberg

Performances

Mainpiece Title: Nina

Dance: End I: Le Rendez@vous (1st time; composed by Gallet)-Mme Hilligsberg [will perform in Man's Cloaths]

Ballet: End Opera: Sapho et Phaon. As17970406

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: Nina

Dance: End I: Le Rendez@vous, as17970511, but Mme _Hilligsberg

Ballet: End Opera: Sapho et Phaon. As17970406

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: Nina

Ballet: Sapho et Phaon. As17970513

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: Alceste

Ballet: End Opera: Sapho et Phaon. As17970406

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: Nina

Dance: As17970513

Ballet: Sapho et Phaon. As17970513

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: The Haunted Tower

Afterpiece Title: Sylvester Daggerwood

Dance: End I: The Camp-[i.e. Les Delassements Militaires] (by permission of the Proprietor of the Opera House); End afterpiece: Cupid and Psyche-Mme Rose, Didelot, Mlle Parisot, Gentili, Fialon, Mme Hilligsberg, with Corps de Ballet from the Opera House [will appear, positively for that night only

Performances

Mainpiece Title: Alceste

Song: In opera: the favourite song with the violin obligato-Mme Banti

Ballet: End Opera: Sapho et Phaon. As17970406

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: L'albero Di Diana

Dance: End I: Les Delassements Militaires, as17970124

Ballet: End Opera: Sapho et Phaon. As17970406

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: Gli Schiavi Per Amore

Dance: As17970513

Ballet: Sapho et Phaon. As17970513

Cast
Role: Damophile Actor: Mme Hilligsberg

Performances

Mainpiece Title: L'albero Di Diana

Dance: As17970513

Ballet: Sapho et Phaon. As17970513

Cast
Role: Damophile Actor: Mme Hilligsberg