SELECT * FROM london_stages WHERE eventid IN (20545, 25817, 25821, 25823, 25826, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25858, 25860, 25862, 25864, 25870, 25872, 25887, 25892, 25897, 25900, 25903, 25910, 25915, 25919, 25922, 25926, 25929, 25933, 25940, 25942, 25944, 25949, 25953, 25987, 26052, 26216, 26222, 26224, 26226, 26230, 26254, 26266, 26278, 26301, 26303, 26312, 26318, 26321, 26324, 26327, 26330, 26348, 26351, 26356, 26362, 26435, 26593, 26598, 26625, 26632, 26678, 26680, 26682, 26684, 26686, 26692, 26700, 26704, 26720, 26759, 26776, 26787, 26806, 26820, 26824, 26839, 26844, 26849, 26983, 27027, 27106, 27260, 27268, 27341, 27343, 27530, 27542, 27547, 27600, 27618, 27711, 27723, 27745, 27785, 27818, 28032, 28145, 28147, 28163, 28206, 28292, 28296, 28300, 28382, 28460, 28527, 28560, 28760, 28766, 28865, 28870, 28872, 28875, 28880, 28886, 28892, 28897, 28903, 28909, 28916, 28923, 28965, 29020, 29032, 29210, 29222, 29415, 29787, 29834, 29836, 29852, 29918, 29922, 29925, 29928, 29930, 29933, 29939, 29944, 29950, 29955, 29966, 30049, 30056, 30058, 30064, 30069, 30071, 30076, 30104, 30131, 30144, 30146, 30150, 30154, 30292, 30298, 30314, 30316, 30318, 30320, 30322, 30326, 30328, 30330, 30340, 30372, 30375, 30382, 30384, 30386, 30394, 30409, 30411, 30414, 30416, 30421, 30428, 30433, 30442, 30444, 30449, 30456, 30464, 30466, 30471, 30503, 30508, 30521, 30536, 30543, 30554, 30565, 30567, 30576, 30586, 30602, 30609, 30645, 30649, 30659, 30681, 30683, 30685, 30689, 30794, 30807, 30811, 30813, 30815, 30817, 30823, 30827, 30831, 30833, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 30897, 31048, 31050, 31053, 31058, 31060, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31134, 31152, 31188, 31204, 31237, 31248, 31334, 31357, 31373, 31390, 31398, 31402, 31404, 31406, 31408, 31410, 31412, 31416, 31423, 31425, 31427, 31429, 31433, 31436, 31438, 31442, 31452, 31454, 31456, 31460, 31463, 31466, 31501, 31503, 31516, 31520, 31524, 31530, 31532, 31534, 31536, 31541, 31547, 31554, 31559, 31561, 31563, 31568, 31572, 31578, 31581, 31586, 31590, 31598, 31609, 31640, 31704, 31709, 31757, 31768, 31772, 31787, 31828, 31838, 31854, 31858, 31860, 31862, 31866, 31870, 31882, 31890, 31892, 31894, 31898, 31906, 31908, 31910, 31918, 31928, 31931, 31936, 31940, 31947, 31956, 31961, 31964, 31970, 31975, 31986, 31988, 31990, 31992, 32001, 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, 32101, 32103, 32105, 32107, 32110, 32112, 32115, 32118, 32120, 32122, 32125, 32127, 32129, 32132, 32137, 32141, 32172, 32185, 32205, 32214, 32236, 32250, 32253, 32318, 32326, 32347, 32349, 32351, 32353, 32357, 32359, 32361, 32363, 32367, 32373, 32377, 32379, 32381, 32383, 32385, 32389, 32391, 32396, 32402, 32404, 32408, 32420, 32422, 32424, 32429, 32431, 32443, 32463, 32465, 32467, 32469, 32472, 32476, 32480, 32482, 32487, 32491, 32496, 32505, 32510, 32515, 32517, 32522, 32524, 32527, 32534, 32537, 32540, 32573, 32624, 32643, 32692, 32699, 32721, 32725, 32735, 32738, 32782, 32824, 32831, 32835, 32837, 32839, 32843, 32847, 32849, 32851, 32855, 32857, 32859, 32861, 32865, 32867, 32869, 32871, 32873, 32877, 32881, 32883, 32889, 32891, 32897, 32899, 32902, 32907, 32909, 32918, 32921, 32923, 32927, 32931, 32936, 32940, 32948, 32957, 32959, 32961, 32963, 32967, 32973, 33025, 33027, 33035, 33037, 33043, 33046, 33051, 33055, 33058, 33065, 33068, 33073, 33076, 33080, 33083, 33089, 33098, 33107, 33115, 33122, 33125, 33137, 33140, 33155, 33162, 33167, 33182, 33190, 33192, 33196, 33202, 33286, 33290, 33298, 33328, 33335, 33337, 33356, 33359, 33361, 33363, 33365, 33368, 33370, 33373, 33375, 33377, 33379, 33497, 33518, 33523, 33527, 33530, 33555, 33564, 33577, 33586, 33590, 33618, 33634, 33643, 33650, 33663, 33668, 33677, 33699, 33705, 33793, 33795, 33803, 33813, 33817, 33820, 33828, 33832, 33834, 33838, 33842, 33844, 33846, 33852, 33854, 33856, 33858, 33863, 33865, 33867, 33874, 33876, 33878, 33897, 33904, 33913, 33920, 33927, 33936, 33944, 33949, 33975, 33981, 33987, 33990, 34020, 34023, 34037, 34039, 34061, 34073, 34076, 34079, 34086, 34131, 34133, 34145, 34159, 34162, 34167, 34174, 34183, 34195, 34213, 34218, 34220, 34225, 34240, 34245, 34255, 34256, 34264, 34269, 34347, 34349, 34362, 34366, 34373, 34386, 34388, 34401, 34407, 34411, 34413, 34424, 34427, 34429, 34432, 34434, 34436, 34438, 34441, 34446, 34450, 34455, 34462, 34466, 34469, 34471, 34474, 34476, 34478, 34488, 34492, 34497, 34502, 34506, 34521, 34524, 34526, 34528, 34530, 34532, 34534, 34537, 34539, 34542, 34544, 34546, 34548, 34551, 34553, 34556, 34558, 34560, 34572, 34576, 34584, 34586, 34588, 34590, 34593, 34601, 34604, 34607, 34609, 34612, 34617, 34620, 34622, 34628, 34635, 34637, 34642, 34648, 34660, 34668, 34675, 34684, 34705, 34713, 34728, 34730, 34739, 34744, 34752, 34757, 34768, 34771, 34776, 34778, 34787, 34792, 34807, 34810, 34813, 34816, 34818, 34910, 34950, 34958, 35029, 35049, 35054, 35071, 35075, 35091, 35158, 35251, 35287, 35300, 35499, 35519, 35523, 35525, 35529, 35559, 35582, 35584, 35588, 35593, 35596, 35601, 35616, 35625, 35627, 35632, 35634, 35648, 35651, 35654, 35657, 35663, 35666, 35668, 35811, 35819, 35835, 35866, 35875, 35877, 35880, 35890, 35893, 35895, 35898, 35900, 35906, 35911, 35914, 35923, 35925, 35935, 35941, 35946, 35953, 35958, 35961, 35968, 35971, 35982, 35987, 35995, 36112, 36119, 36123, 36130, 36146, 36150, 36249, 36254, 36325, 36332, 36334, 36337, 36339, 36342, 36344, 36346, 36348, 36351, 36353, 36356, 36358, 36360, 36366, 36407, 36435, 36495, 36693, 36796, 36799, 36801, 36803, 36805, 36807, 36809, 36812, 36814, 36817, 36819, 36821, 36823, 36826, 36828, 36833, 36838, 36842, 36845, 36847, 36849, 36851, 36854, 36859, 36861, 36867, 36872, 36874, 36876, 36889, 36896, 36898, 36903, 36905, 36910, 36970, 36989, 37029, 37061, 37064, 37067, 37077, 37079, 37086, 37120, 37795, 37807, 37811, 37813, 37815, 37819, 37821, 37823, 37825, 37827, 37829, 37833, 37835, 37845, 37847, 37849, 37852, 37854, 37856, 37858, 37860, 37862, 37866, 37868, 37870, 37874, 37875, 37878, 37887, 37893, 37897, 37902, 37905, 37907, 37909, 37914, 37916, 37919, 37921, 37941, 37943, 37945, 37949, 37951, 37954, 37962, 37969, 37985, 37991, 38050, 38070, 38105, 38107, 38112, 38123, 38128, 38136, 38151, 38153, 38156, 38158, 38165, 38167, 38172, 38180, 38183, 38186, 38188, 38192, 38327, 38330, 38334, 38336, 38359, 38373, 38376, 38378, 38381, 38383, 38385, 38387, 38390, 38394, 38396, 38399, 38401, 38407, 38420, 38422, 38429, 38434, 38439, 38441, 38445, 38448, 38457, 38462, 38464, 38488, 38500, 38523, 38528, 38543, 38545, 38547, 38549, 38551, 38554, 38559, 38561, 38575, 38578, 38596, 38627, 38634, 38658, 38675, 38700, 38716, 38739, 38745, 38753, 38768, 38771, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38953, 38960, 38970, 38982, 38995, 39000, 39017, 39022, 39024, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39078, 39083, 39086, 39088, 39095, 39098, 39104, 39114, 39123, 39137, 39142, 39146, 39149, 39151, 39163, 39165, 39177, 39181, 39199, 39202, 39210, 39225, 39234, 39242, 39250, 39262, 39268, 39270, 39273, 39296, 39308, 39322, 39333, 39335, 39343, 39445, 39520, 39560, 39564, 39567, 39574, 39578, 39583, 39600, 39621, 39643, 39648, 39653, 39807, 39828, 39863, 39894, 39928, 39932, 39934, 39943, 39963, 39964, 39969, 39994, 40070, 40115, 40421) 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 Way Of The World

Afterpiece Title: Harlequin's Invasion

Dance: In: As17761024

Performances

Mainpiece Title: Semiramis

Afterpiece Title: Harlequin's Invasion

Performances

Afterpiece Title: Harlequin's Invasion

Dance: I: a Dance of Spirits (composed by Gallet)-Mlle Dupre; III: [a Fantastic Dance-Grimaldi; [Both these dances, as here assigned, except on 14, 25 Apr. and 0 May, were included in all subsequent performances.] End IV: The Double Festival, as17761107, but Giorgi, +Blurton

Performances

Afterpiece Title: Harlequin's Invasion

Dance: In IV: The Double Festival, as17770104

Performances

Mainpiece Title: Semiramis

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Invasion

Dance: As17761212

Performances

Afterpiece Title: Harlequin's Invasion

Dance: IV: The Triumph of Love, as17761107

Performances

Mainpiece Title: Semiramis

Afterpiece Title: Harlequin's Invasion

Performances

Afterpiece Title: Harlequin's Invasion

Dance: In IV: The Triumph of Love, as17761107

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Semiramis

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Semiramis

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Merope

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Invasion

Dance: In: The Triumph of Love, as17761107

Performances

Afterpiece Title: A ChristmasTale

Cast
Role: Nigromant Actor: Legg

Dance: As17770118

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: A ChristmasTale

Cast
Role: Nigromant Actor: Legg

Dance: In: as17770117

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Harlequin's Invasion

Dance: As17770128

Performances

Afterpiece Title: Harlequin's Invasion

Dance: As17770118

Performances

Afterpiece Title: A ChristmasTale

Cast
Role: Nigromant Actor: Legg

Dance: As17770110

Performances

Mainpiece Title: Semiramis

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Hamlet

Afterpiece Title: A ChristmasTale

Cast
Role: Nigromant Actor: Legg

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Harlequin's Invasion

Dance: In II: The Double Festival, as17770210, but Slingsby; In V: +The Triumph of Love, as17761107

Song: As17770210