SELECT * FROM london_stages WHERE eventid IN (28662, 28664, 28669, 28675, 28696, 28702, 28707, 28712, 28717, 28726, 28731, 28754, 28782, 28794, 28841, 28885, 28956, 29014, 29195, 29203, 29213, 29217, 29244, 29280, 29291, 29300, 29308, 29312, 29315, 29320, 29331, 29336, 29338, 29342, 29344, 29349, 29352, 29357, 29361, 29363, 29367, 29369, 29393, 29395, 29398, 29412, 29424, 29428, 29431, 29442, 29445, 29449, 29452, 29484, 29488, 29496, 29499, 29503, 29532, 29537, 29549, 29583, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30081, 30114, 30145, 30151, 30381, 30385, 30388, 30390, 30395, 30410, 30413, 30415, 30429, 30432, 30452, 30475, 30479, 30484, 30566, 30622, 30653, 30660, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30865, 30867, 30870, 30874, 30878, 30880, 30882, 30884, 30886, 30888, 30893, 30900, 30916, 30922, 30924, 30926, 30928, 30930, 30933, 30935, 30937, 30940, 30942, 30944, 30947, 30950, 30954, 30966, 30973, 30979, 30983, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31057, 31061, 31066, 31069, 31074, 31076, 31094, 31097, 31100, 31102, 31109, 31112, 31116, 31136, 31158, 31179, 31182, 31189, 31197, 31203, 31216, 31220, 31223, 31253, 31274, 31339, 31368, 31370, 31372, 31374, 31378, 31380, 31382, 31384, 31387, 31389, 31391, 31393, 31395, 31397, 31399, 31405, 31409, 31411, 31417, 31419, 31426, 31428, 31430, 31432, 31435, 31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31513, 31515, 31517, 31519, 31523, 31526, 31531, 31533, 31535, 31537, 31542, 31556, 31569, 31605, 31611, 31614, 31617, 31620, 31626, 31629, 31632, 31636, 31642, 31648, 31657, 31671, 31673, 31686, 31689, 31700, 31703, 31715, 31718, 31725, 31731, 31740, 31747, 31753, 31761, 31767, 31771, 31773, 32319, 32321, 32325, 32329, 32334, 32339, 32342, 32346, 32348, 32350, 32352, 32356, 32358, 32364, 32366, 32382, 32384, 32390, 32393, 32395, 32403, 32407, 32411, 32414, 32437, 32442, 32450, 32452, 32454, 32459, 32464, 32466, 32493, 32523, 32526, 32546, 32558, 32653, 32666, 32671, 32676, 32678, 32680, 32704, 32708, 32720, 32722, 32724, 32729, 32734, 32748, 32807, 32813, 32815, 32817, 32822, 32827, 32830, 32832, 32834, 32836, 32838, 32840, 32842, 32846, 32848, 32850, 32852, 32854, 32856, 32858, 32860, 32862, 32864, 32866, 32868, 32870, 32872, 32874, 32876, 32878, 32882, 32884, 32886, 32888, 32890, 32892, 32894, 32898, 32903, 32906, 32908, 32910, 32913, 32915, 32917, 32920, 32922, 32924, 32930, 32933, 32935, 32944, 32949, 32953, 32956, 32958, 32960, 32962, 32966, 32969, 32972, 32974, 32976, 32978, 32981, 32983, 32985, 32987, 32989, 32991, 32994, 32996, 32999, 33003, 33005, 33008, 33010, 33012, 33017, 33020, 33022, 33024, 33026, 33029, 33031, 33034, 33039, 33042, 33045, 33092, 33103, 33106, 33108, 33110, 33116, 33121, 33134, 33136, 33145, 33150, 33158, 33166, 33172, 33179, 33183, 33193, 33195, 33260, 33265, 33267, 33269, 33271, 33273, 33275, 33277, 33285, 33287, 33289, 33291, 33295, 33297, 33300, 33304, 33344, 33346, 33348, 33353, 33362, 33364, 33369, 33372, 33374, 33378, 33381, 33383, 33386, 33390, 33402, 33428, 33441, 33443, 33446, 33448, 33451, 33453, 33455, 33457, 33460, 33462, 33465, 33467, 33471, 33474, 33476, 33479, 33486, 33489, 33491, 33494, 33496, 33498, 33501, 33510, 33517, 33524, 33526, 33529, 33531, 33538, 33563, 33570, 33572, 33585, 33589, 33604, 33617, 33620, 33622, 33626, 33647, 33659, 33673, 33693, 33700, 33710, 33719, 33725, 33792, 33798, 33800, 33802, 33804, 33806, 33808, 33810, 33814, 33819, 33821, 33823, 33825, 33829, 33831, 33833, 33837, 33839, 33841, 33843, 33849, 33875, 33882, 33889, 33898, 33903, 33905, 33907, 33917, 33919, 33921, 33924, 33929, 33933, 33962, 33969, 33972, 34014, 34017, 34040, 34063, 34069, 34072, 34078, 34146, 34161, 34173, 34182, 34187, 34204, 34237, 34258, 34374, 34397, 34400, 34406, 34410, 34418, 34578, 34681, 34688, 34696, 34722, 34770, 34772, 34779, 34893, 34984, 35033, 35064, 35104, 35210, 35337, 35379, 35495, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35617, 35621, 35626, 35629, 35635, 35642, 35645, 35647, 35650, 35653, 35656, 35659, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35683, 35686, 35688, 35693, 35696, 35702, 35707, 35718, 35723, 35756, 35761, 35788, 35802, 35810, 35813, 35818, 35823, 35826, 35865, 35918, 35989, 36113, 36219, 36223, 36225, 36232, 36237, 36239, 36243, 36253, 36257, 36262, 36264, 36266, 36269, 36273, 36275, 36279, 36282, 36284, 36289, 36291, 36296, 36301, 36305, 36308, 36336, 36343, 36345, 36352, 36355, 36357, 36367, 36381, 36409, 36482, 36504, 36540, 36546, 36636, 36649, 36651, 36653, 36673, 36688, 36696, 36704, 36710, 36714, 36717, 36738, 36750, 36752, 36756, 36764, 36773, 36784, 36795, 36798, 36800, 36802, 36804, 36806, 36808, 36811, 36813, 36816, 36818, 36820, 36822, 36825, 36827, 36830, 36832, 36834, 36837, 36839, 36844, 36846, 36850, 36853, 36855, 36860, 36878, 36881, 36883, 36890, 36897, 36902, 36904, 36906, 36914, 36925, 36955, 36957, 37028, 37044, 37080, 37094, 37119, 37124, 37212, 37216, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37253, 37257, 37264, 37272, 37276, 37307, 37317, 37319, 37321, 37324, 37326, 37329, 37333, 37335, 37340, 37343, 37347, 37354, 37359, 37378, 37380, 37382, 37384, 37388, 37393, 37398, 37402, 37407, 37414, 37419, 37424, 37430, 37436, 37439, 37443, 37445, 37455, 37460, 37467, 37477, 37479, 37517, 37524, 37570, 37579, 37584, 37602, 37618, 37637, 37643, 37646, 37671, 37795, 37807, 37813, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37852, 37856, 37870, 37874, 37887, 37893, 37897, 37902, 37905, 37907, 37941, 37943, 37949, 37962, 38050, 38123, 38153, 38156, 38158, 38167, 38172, 38183, 38219, 38422, 38434, 38439, 38457, 38561, 38658, 38675, 38700, 38760, 43645, 43660, 43675, 43690, 43733, 43748, 43864) 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

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Spanish Lady

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Waterman

Song: V: (By Desire) The Soldier Tir'd-Miss Abrams

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17751003

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

Dance: As17850122 throughout

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

Dance: As17850122 throughout

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

Dance: As17850205 throughout

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

Dance: End of Act I Le Jugement de Paris, as17850212; End of Opera The Deserter, as17850122

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

Dance: End of Act I Divertissement, as17850224; End of Opera The Deserter, as17850226

Performances

Mainpiece Title: Il Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

Dance: As17850312hroughout

Performances

Mainpiece Title: Ii Pittore Parigino

Cast
Role: Eurilla Actor: Sga Schinotti
Role: Sandra Actor: Sga Pollone
Role: Cinria Actor: Sga Rachele Dorta Giorgi.

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