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: Nitteti

Dance: As17850303hroughout

Performances

Mainpiece Title: Il Curioso Indiscreto

Dance: End of Act I New Divertissement, as17850303End of Opera; Convitato di Pietra, as17850312athi

Performances

Mainpiece Title: Finta Principessa

Dance: As17850329hroughout

Performances

Mainpiece Title: La Finta Principessa

Dance: End of Act I A La Plus Sage, as17850303End of Opera Il Convitato di Pietra, as17850312athi

Performances

Mainpiece Title: La Finta Principessa

Dance: As17850329hroughout

Performances

Mainpiece Title: La Finta Principessa

Dance: As17850329hroughout

Performances

Mainpiece Title: Artaserse

Dance: As17850329hroughout

Performances

Mainpiece Title: Artaserse

Dance: As17850405 throughout

Performances

Mainpiece Title: Artaserse

Dance: As17850405 throughout

Performances

Mainpiece Title: La Finta Principessa

Dance: End of Act I New Divertissement, as17850303End of Opera The Deserter, as17850111

Performances

Mainpiece Title: Artaserse

Dance: As17850426 throughout

Performances

Mainpiece Title: Ii Pittore Parigino

Dance: End of Act I New Divertissement, as17850303but omitted: Frederic, and Dance in Wooden Shoes; End of Opera Il Convitato di Pietra, as17850312athi

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I Dance in Wooden Shoes [here entitled La Dance del Sabots], as17850303End of Opera Don Juan, as17850407

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I La Dance des Sabots, as17850609 End of Opera The Deserter, as17850111, but added: Mme Bithmer

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I an entirely New Divertissement (1st time; composed by Simonet) by Lepicq, Mme Rossi, Sg and Sga Angiolini, Zuchelli, Mme Bithmer, Duquesney, Miss Harvey, Frederic, Nivelon, Mlle Dorival; End of Opera The Deserter, as17850614

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I New Divertissement, as17850618 but omitted: Lepicq, Mme Rossi; End of Opera Robin Gray, as17850414, with a Pas de Deux, as17850115, and the Caledonian Reels, as17850421, but Nivelon in place of Lepicq

Performances

Mainpiece Title: I Viaggiatori Felici

Dance: End of Act I Robin Gray, as17850628 End of Opera The Deserter, as17850111

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Song: II: song-Incledon

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Oscar and Malvina

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Oscar and Malvina

Music: In afterpiece: The Harp and Pipes-Myres [recte C. Meyer], Courtney

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: Oscar and Malvina

Dance: End II: Negro Dance-

Music: As17911024

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Oscar and Malvina

Music: As17911024