SELECT * FROM london_stages WHERE eventid IN (14467, 14476, 14479, 14708, 14914, 18269, 18272, 18274, 18279, 18282, 18284, 18290, 18294, 18296, 18298, 18301, 18305, 18308, 18312, 18316, 18328, 18330, 18340, 18344, 18351, 18354, 18360, 18404, 18414, 18423, 18439, 18442, 18448, 18452, 18456, 18477, 18481, 18484, 18490, 18494, 18497, 18505, 18517, 18521, 18525, 18535, 18540, 18543, 18547, 18594, 18604, 18609, 18616, 18622, 18631, 18648, 18652, 18705, 18757, 18977, 18979, 18982, 19174, 19180, 19297, 19299, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19356, 19358, 19368, 19374, 19376, 19377, 19379, 19383, 19455, 19457, 19464, 19486, 19510, 19516, 19520, 19527, 19534, 19536, 19538, 19556, 19562, 19576, 19590, 19595, 19611, 19616, 19621, 19622, 19646, 19648, 19650, 19653, 19656, 19658, 19659, 19663, 19683, 19685, 19689, 19713, 19715, 19717, 19719, 19721, 19723, 19725, 19727, 19729, 19731, 19733, 19735, 19739, 19741, 19743, 19747, 19793, 19795, 19798, 19800, 19803, 19808, 19843, 19845, 19847, 19861, 19878, 19881, 19883, 20002, 20012, 20053, 20067, 20102, 20160, 20163, 20166, 20205, 20217, 20227, 20233, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20359, 20381, 20752, 20756, 20759, 20762, 20765, 20768, 20784, 20788, 20791, 20794, 20801, 20804, 20807, 20819, 20895, 20898, 20902, 20905, 20908, 20911, 20914, 20916, 20917, 20928, 20930, 20933, 20937, 20948, 20951, 20953, 20960, 20990, 21000, 21013, 21020, 21041, 21059, 21086, 21092, 21096, 21103, 21119, 21138, 21141, 21145, 21148, 21152, 21155, 21159, 21163, 21170, 21172, 21179, 21184, 21186, 21193, 21200, 21207, 21211, 21222, 21236, 21240, 21256, 21280, 23187, 23229, 23236, 23269, 24160, 25858, 25860, 25862, 25864, 25870, 25872, 25892, 25900, 25919, 25922, 25929, 25940, 25944, 26068, 26224, 26226, 26348, 28576, 28578, 28579, 28580, 28581, 28588, 28589, 28590, 28591, 28592, 28593, 28594, 28595, 28596, 28598, 28601, 28606, 28608, 28612, 28615, 28627, 28632, 28637, 28640, 28650, 31048, 31050, 31053, 31058, 31060, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31188, 32024, 32027, 32029, 32031, 32033, 32035, 32037, 32040, 32042, 32046, 32048, 32050, 32052, 32055, 32058, 32060, 32062, 32064, 32067, 32069, 32072, 32075, 32077, 32079, 32082, 32084, 32087, 32089, 32091, 32122, 32125, 32127, 32129, 32132, 32137, 32141, 32250, 32347, 32349, 32351, 32353, 32357, 32359, 32361, 32367, 32463, 32465, 32467, 32469, 32472, 32476, 32480, 32482, 32487, 32491, 32496, 32505, 32835, 32837, 32839, 32843, 32847, 32849, 32851, 32855, 32859, 32861, 32865, 32957, 32967, 32973, 33192, 33202, 33497, 33689, 33705, 34375, 34377, 34380, 34384, 34390, 34394, 34415, 34453, 34485, 34521, 34598, 34668, 34694, 34713, 34723, 34725, 34739, 34754, 34759, 34782, 34785, 34794, 34805, 35282, 35350, 35998, 37593, 37845, 37847, 37849, 37854, 37858, 37860, 37862, 37866, 37868, 37875, 37878, 37884, 37891, 37899, 37900, 37911, 37919, 37927, 37932, 37939, 37945, 37953, 37960, 37966, 37975, 37979, 37987, 37993, 38007, 38010, 38018, 38020, 38025, 38034, 38039, 38042, 38049, 38055, 38064, 38067, 38069, 38075, 38080, 38090, 38095, 38097, 38104, 38109, 38120, 38125, 38130, 38135, 38150, 38172, 38179, 38215, 38248, 38252, 38380, 38389, 38403, 38419, 38433, 38447, 38461, 38487, 38513, 38527, 38542, 38923, 38927, 38936, 38941, 38950, 38955, 38964, 38969, 38978, 38992, 38997, 39005, 39010, 39019, 39040, 39053, 39064, 39071, 39080, 39085, 39092, 39097, 39106, 39112, 39120, 39125, 39134, 39139, 39148, 39153, 39162, 39168, 39174, 39180, 39186, 39192, 39198, 39204, 39215, 39221, 39227, 39233, 39238, 39244, 39249, 39256, 39267, 39272, 39279, 39284, 39290, 39295, 39300, 39311, 39319, 39328, 39332, 39340, 39344, 39350, 39352, 39356, 39358, 39364, 39367, 39373, 39382, 41336, 41345, 41357, 41362, 41456, 41463, 41540, 41545, 41560, 41565, 43164, 43301, 43723, 43727, 43768, 43777, 43782, 43793, 43799, 43810, 43816, 43827, 43834, 43845, 43864, 43918, 43924, 43930, 43943, 43950, 47474, 47475, 47478, 47482, 47484, 47485, 47493, 47495, 47497, 47507, 47513, 47519, 47527, 47531, 47537, 47543, 47549, 47555, 47561, 47566, 47568, 47575, 47645, 47651, 47655, 47657, 47672, 47676, 47683, 47685, 47737, 47752, 47782, 47797, 47813, 47828, 47843, 47858, 47872, 47892, 48038, 48043, 48049, 48080, 48090, 48109, 48264, 48437, 49216, 49222, 49226, 49244, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49525, 49563, 49599, 49783, 49794, 49805, 49815, 49886, 49891, 49897, 50108, 50118, 50170, 50203, 51509, 51513, 51517, 51521, 51525, 51527, 51914) 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: The Maid Of The Oaks

Cast
Role: The Ballets Actor: M. Larevier

Afterpiece Title: The Guardian

Performances

Mainpiece Title: Armida

Dance: As17750107

Cast
Role: New Ballet Actor:

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: The Ballets Actor: M. Larevier

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Armida

Dance: As17741217

Cast
Role: New Ballet Actor:

Performances

Mainpiece Title: Armida

Dance: As17741217

Cast
Role: New Ballet Actor:

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17741217, but Allemande-_ from Le Bal Masquer

Cast
Role: New Ballet Actor:

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: The Ballets Actor: M. Larevier

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17741217

Cast
Role: New Ballet Actor:

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany

Dance: I: New Ballet, La Fete de Flora-; In which a Grand Chaconne-Mlle Baccelli; II: Grand Ballet, Les Mexicains-S. Vallouis, Mme Vallouis; End opera: Grand Heroic Historic Ballet-Lany, M and Mme Vallouis, Mlle Baccelli; with Chaconnes-Vallouis, Mlle Baccelli

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Ballet, Chaconne-Mlle Baccelli; II: Silvie-S. Vallouis, Mme Vallouis; End Opera: Grand Heroic Historic Ballet, as17750207; Chaconnes, as17750207

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: The Ballets Actor: M. Larevier

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17750214; End Opera: Le Bal Masques, but with Chaconnes-Vallouis, Mlle Baccelli

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany

Dance: As17750207; End II: Silvie-Vallouis, Mlle Vallouis

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: The Ballets Actor: M. Larevier

Afterpiece Title: The Deuce Is in Him

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Ballet-; with Grand Chaconne-Mlle Baccelli; II: Silvie, as17741203; End Opera: La Bal Masquer, as17741213

Cast
Role: New Ballet Actor:

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany

Dance: As17750207; End II: Silvie, as17741203

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750207; End II: New Ballet-S. Vallouis, Mlle Vallouis

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany

Performances

Mainpiece Title: La Marchesa Giardiniera

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: The Ballets Actor: M. Larevier

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17740917

Performances

Mainpiece Title: La Marchesa Giardiniera

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: Motezuma

Cast
Role: Ballet Master Actor: Lany