SELECT * FROM london_stages WHERE eventid IN (7313, 7338, 7763, 7765, 7767, 7778, 11003, 11005, 11007, 12676, 15597, 18174, 18503, 18515, 18519, 18673, 18686, 18723, 18901, 18903, 18932, 18948, 18977, 18979, 18982, 19064, 19067, 19069, 19072, 19074, 19079, 19092, 19100, 19102, 19105, 19164, 19690, 19692, 19694, 19696, 19698, 19700, 19702, 19704, 19706, 19708, 19720, 19726, 19740, 19750, 19758, 19762, 19767, 19771, 19785, 19809, 19816, 19833, 19846, 19866, 19875, 19889, 19900, 19906, 19908, 19921, 19924, 19936, 19950, 19962, 19977, 20042, 20531, 20860, 20864, 20867, 20872, 20875, 20895, 20951, 20956, 20961, 20974, 21005, 21025, 21037, 21042, 21052, 21070, 21072, 21080, 21087, 21104, 21110, 21127, 21151, 21169, 21178, 21185, 21243, 21251, 21258, 21294, 21321, 21359, 21360, 21361, 21378, 21395, 21398, 21418, 21476, 21498, 21532, 21546, 21567, 21598, 21609, 21610, 21667, 21671, 21680, 21729, 21733, 21744, 21801, 21811, 21940, 21989, 22072, 22119, 22122, 22123, 22191, 22232, 22263, 22320, 22335, 22400, 22500, 22541, 22673, 22699, 22740, 22745, 22761, 22808, 22859, 23185, 23326, 23413, 23416, 23417, 23419, 23422, 23425, 23457, 23528, 23545, 23550, 23588, 23717, 23739, 23841, 23864, 23961, 23963, 24067, 24077, 24453, 24488, 24493, 24496, 24691, 24714, 24737, 24774, 24778, 24905, 24953, 25051, 25106, 25125, 25148, 25159, 25227, 25238, 25260, 25267, 25271, 25303, 25342, 25344, 25346, 25348, 25350, 25352, 25354, 25356, 25358, 25360, 25362, 25418, 25425, 25433, 25441, 25479, 25525, 25552, 25563, 25576, 25592, 25595, 25597, 25601, 25604, 25607, 25609, 25618, 25653, 25660, 25959, 25961, 25982, 26052, 26067, 26202, 26205, 26213, 26216, 26221, 26222, 26229, 26230, 26249, 26254, 26265, 26266, 26278, 26296, 26301, 26330, 26362, 26411, 26435, 26541, 26593, 26598, 26601, 26604, 26625, 26632, 26669, 26671, 26672, 26678, 26680, 26682, 26684, 26686, 26692, 26693, 26700, 26704, 26720, 26735, 26759, 26776, 26787, 26806, 26839, 26855, 26857, 26910, 26983, 27027, 27041, 27071, 27106, 27170, 27193, 27218, 27230, 27260, 27268, 27341, 27343, 27420, 27436, 27438, 27488, 27530, 27547, 27591, 27600, 27618, 27677, 27680, 27695, 27711, 27723, 27732, 27745, 27782, 27785, 27818, 27820, 27823, 27825, 27830, 27895, 27921, 27941, 27983, 27993, 28016, 28032, 28044, 28087, 28145, 28147, 28150, 28152, 28154, 28160, 28162, 28163, 28168, 28178, 28206, 28215, 28292, 28296, 28300, 28382, 28403, 28457, 28460, 28486, 28511, 28527, 28560, 28635, 28638, 28733, 28760, 28766, 28778, 28779, 28798, 28865, 28870, 28872, 28875, 28880, 28886, 28888, 28892, 28897, 28898, 28902, 28903, 28905, 28908, 28909, 28910, 28915, 28916, 28919, 28922, 28923, 28926, 28927, 28930, 28942, 28957, 28964, 28965, 29020, 29032, 29033, 29036, 29046, 29165, 29167, 29172, 29179, 29203, 29210, 29222, 29265, 29280, 29312, 29313, 29337, 29375, 29420, 29426, 29488, 29500, 29538, 29549, 29552, 29555, 29559, 29563, 29567, 29570, 29573, 29576, 29584, 29608, 29609, 29619, 29620, 29621, 29623, 29624, 29626, 29627, 29631, 29634, 29636, 29639, 29640, 29642, 29644, 29646, 29648, 29651, 29653, 29655, 29657, 29659, 29661, 29722, 29747, 29766, 29834, 29836, 29877, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29958, 29960, 29973, 29981, 30006, 30009, 30028, 30039, 30050, 30055, 30057, 30071, 30081, 30114, 30116, 30145, 30151, 30159, 30164, 30307, 30309, 30311, 30315, 30321, 30323, 30329, 30333, 30335, 30337, 30339, 30408, 30410, 30420, 30450, 30478, 30566, 30575, 30586, 30592, 30606, 30622, 30641, 30653, 30686, 30689, 30690, 30695, 30699, 30785, 30787, 30793, 30801, 30808, 30814, 30852, 30878, 30888, 30900, 30916, 30928, 30947, 30983, 31040, 31141, 31203, 31248, 31253, 31265, 31271, 31334, 31339, 31340, 31342, 31358, 31373, 31376, 31389, 31424, 31459, 31482, 31486, 31510, 31540, 31554, 31602, 31626, 31648, 31651, 31684, 31694, 31703, 31708, 31723, 31728, 31736, 31742, 31763, 31772, 31881, 31925, 31932, 32111, 32116, 32179, 32252, 32253, 32319, 32364, 32416, 32493, 32593, 32618, 32644, 32683, 32693, 32725, 32734, 32807, 32831, 32843, 32866, 32902, 32951, 32956, 32957, 33051, 33110, 33122, 33162, 33169, 33172, 33202, 33267, 33271, 33298, 33428, 33485, 33530, 33586, 33592, 33628, 33634, 33681, 33693, 33699, 33719, 33813, 33817, 33832, 33874, 33897, 33902, 33916, 33930, 33990, 34010, 34023, 34037, 34050, 34058, 34070, 34076, 34086, 34132, 34162, 34202, 34207, 34213, 34366, 34580, 34599, 34601, 34643, 34684, 34722, 34730, 34770, 34796, 34816, 34866, 34870, 34901, 34910, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35071, 35074, 35075, 35076, 35078, 35088, 35091, 35092, 35094, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35135, 35143, 35149, 35158, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35264, 35277, 35287, 35289, 35300, 35305, 35321, 35365, 35372, 35382, 35514, 35519, 35542, 35555, 35558, 35562, 35566, 35573, 35577, 35581, 35587, 35595, 35603, 35613, 35629, 35635, 35642, 35647, 35650, 35651, 35653, 35656, 35662, 35665, 35669, 35672, 35674, 35678, 35681, 35683, 35686, 35688, 35696, 35702, 35707, 35718, 35756, 35788, 35802, 35813, 35818, 35823, 35826, 35835, 35865, 35875, 35890, 35925, 35968, 35983, 35990, 35995, 36002, 36127, 36180, 36325, 36380, 36434, 36453, 36454, 36461, 36479, 36486, 36505, 36562, 36573, 36617, 36912, 36917, 36918, 36924, 36926, 36927, 36928, 36931, 36933, 36934, 36937, 36940, 36942, 36944, 36945, 36948, 36949, 36950, 36953, 36960, 36961, 36966, 36973, 36977, 36982, 36983, 36993, 36994, 36999, 37000, 37003, 37007, 37026, 37071, 37072, 37112, 37118, 37127, 37129, 37134, 37140, 37145, 37147, 37184, 37187, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37258, 37271, 37272, 37283, 37295, 37353, 37466, 37471, 37529, 37545, 37565, 37588, 37622, 37845, 37847, 37849, 37854, 37858, 37860, 37862, 37866, 37868, 37875, 37878, 37882, 37884, 37887, 37891, 37900, 37911, 37919, 37945, 37960, 37975, 37987, 38011, 38018, 38042, 38067, 38097, 38172, 38314, 38322, 38328, 38344, 38379, 38414, 38457, 38480, 38533, 38558, 38561, 38567, 38582, 38592, 38595, 38602, 38607, 38610, 38623, 38626, 38633, 38648, 38655, 38658, 38670, 38672, 38675, 38686, 38700, 38723, 38768, 38930, 38989, 38994, 38996, 38999, 39001, 39007, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39050, 39051, 39054, 39056, 39058, 39060, 39061, 39065, 39067, 39072, 39074, 39075, 39076, 39086, 39087, 39098, 39103, 39114, 39116, 39117, 39126, 39127, 39128, 39130, 39131, 39137, 39140, 39141, 39144, 39145, 39154, 39155, 39158, 39159, 39163, 39169, 39170, 39175, 39176, 39187, 39188, 39193, 39194, 39199, 39214, 39242, 39258, 39262, 39270, 39299, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39559, 39561, 39563, 39565, 39568, 39570, 39582, 39601, 39604, 39606, 39608, 39610, 39612, 39614, 39616, 39619, 39622, 39624, 39626, 39628, 39630, 39633, 39635, 39638, 39644, 39649, 39661, 39664, 39671, 39674, 39676, 39688, 39700, 39738, 39739, 39748, 39749, 39752, 39753, 39758, 39762, 39763, 39765, 39767, 39768, 39779, 39780, 39784, 39785, 39795, 39796, 39800, 39801, 39810, 39811, 39813, 39816, 39817, 39829, 39844, 39853, 39874, 39894, 39899, 39926, 40053, 40097, 40277, 40287, 40290, 40299, 40300, 40303, 40313, 40314, 40315, 40318, 40319, 40328, 40330, 40332, 40333, 40334, 40342, 40343, 40344, 40347, 40348, 40363, 40378, 40383, 40386, 40390, 40395, 40397, 40417, 40424, 40432, 40435, 40447, 40453, 40458, 40460, 40466, 40687, 40710, 40802, 40811, 40814, 40823, 40826, 40830, 40836, 40838, 40840, 40850, 40854, 40862, 40864, 40867, 41214, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483, 42627, 43750, 43853, 43855, 44185, 44189, 44606, 44829, 44838, 44842, 44851, 44855, 44865, 44869, 44878, 44882, 44894, 44900, 44906, 44943, 44997, 45019, 45034, 45367, 45376, 45379, 45388, 45392, 45401, 45405, 45414, 45418, 45427, 45431, 45516, 45670, 45676, 45718, 45730, 45774, 45776, 45804, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45898, 45899, 45902, 45904, 45911, 45938, 45951, 45959, 45969, 45972, 45982, 45985, 46012, 46025, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46087, 46093, 46100, 46103, 46121, 46133, 46148, 46166, 46174, 46228, 46229, 46231, 46232, 46233, 46234, 46238, 46239, 46257, 46258, 46259, 46314, 46326, 46407, 46412, 46414, 46416, 46418, 46420, 46424, 46426, 46428, 46432, 46437, 46440, 46442, 46447, 46451, 46461, 46470, 46473, 46477, 46482, 46487, 46494, 46516, 46526, 46530, 46535, 46540, 46544, 46554, 46558, 46568, 46572, 46582, 46646, 46677, 46682, 46872, 46878, 46880, 46890, 46894, 46908, 46924, 46932, 46970, 47001, 47005, 47013, 47025, 47037, 47049, 47053, 47054, 47061, 47065, 47066, 47076, 47083, 47086, 47088, 47091, 47093, 47096, 47097, 47098, 47101, 47104, 47108, 47111, 47113, 47114, 47117, 47119, 47121, 47124, 47125, 47127, 47128, 47131, 47133, 47136, 47139, 47141, 47144, 47145, 47148, 47150, 47151, 47153, 47156, 47157, 47158, 47161, 47162, 47165, 47168, 47170, 47174, 47176, 47180, 47184, 47186, 47187, 47189, 47193, 47195, 47197, 47199, 47204, 47206, 47214, 47227, 47229, 47232, 47239, 47245, 47250, 47256, 47267, 47270, 47271, 47298, 47305, 47310, 47317, 47320, 47324, 47332, 47336, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47412, 47413, 47414, 47416, 47419, 47420, 47421, 47423, 47424, 47425, 47426, 47427, 47429, 47448, 47450, 47452, 47453, 47455, 47457, 47460, 47461, 47463, 47465, 47468, 47476, 47477, 47481, 47486, 47498, 47504, 47506, 47510, 47514, 47528, 47530, 47532, 47536, 47538, 47544, 47546, 47552, 47556, 47558, 47559, 47563, 47564, 47576, 47579, 47580, 47583, 47588, 47619, 47635, 47640, 47651, 47674, 47682, 47701, 47702, 47711, 47716, 47717, 47718, 47726, 47727, 47731, 47732, 47741, 47742, 47746, 47747, 47751, 47756, 47757, 47758, 47761, 47762, 47771, 47772, 47773, 47776, 47777, 47781, 47786, 47791, 47796, 47834, 47849, 47850, 47873, 47889, 47893, 47901, 47902, 47905, 47910, 47919, 47920, 47921, 47924, 47930, 47936, 47948, 47954, 47958, 47975, 47979, 47986, 47991, 48029, 48230, 48231, 48240, 48241, 48244, 48245, 48254, 48255, 48258, 48259, 48268, 48269, 48272, 48273, 48282, 48283, 48286, 48287, 48296, 48297, 48300, 48301, 48303, 48306, 48308, 48311, 48322, 48325, 48329, 48331, 48336, 48347, 48358, 48361, 48363, 48366, 48375, 48377, 48380, 48382, 48404, 48409, 48437, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48538, 48544, 48552, 48560, 48568, 48572, 48576, 48587, 48589, 48597, 48604, 48612, 48622, 48632, 48638, 48646, 48648, 48756, 48790, 48864, 49199, 49214, 49343, 49447, 49488, 49493, 49517, 49553, 49558, 49565, 49568, 49585, 49604, 49614, 49626, 49657, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49728, 49791, 49801, 49813, 50339, 50377, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50528, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50602, 50609, 50620, 50626, 50635, 50675, 50688, 50690, 50695, 50702, 50707, 50736, 50742, 50744, 50772, 50790, 50802, 50805, 50812, 50940, 50959, 50965, 50971, 51335, 51481, 51488, 51787, 51803, 51806, 51808, 51813, 51820, 51828, 51833, 51841, 51843, 51859, 51861, 51869, 51879, 51885, 51900, 51914, 51927, 52034, 52077, 52140, 52176, 52241, 52243, 52245, 52248, 52250, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52280, 52284) 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 Amorous Widow

Afterpiece Title: Orpheus and Eurydice

Dance: II: A New Comic Dance-Richardson, Delagarde, Mrs Jackson; IV: Sailor's Dance-Richardson

Performances

Mainpiece Title: Rule A Wife

Afterpiece Title: Orpheus and Eurydice

Dance: LLouvre, Minuet-Dupre, a scholar of his

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Orpheus and Eurydice

Ballet: RRural Assembly. As17420508, By particular desire

Performances

Mainpiece Title: The Rehearsal

Dance: The Mechels

Performances

Mainpiece Title: The Rehearsal

Song: I: Songs-Beard

Music: III: Concerto-Veracini

Dance: II: Peasant Dance, as17420921; IV: Tyrolean Dance, as17420921

Performances

Mainpiece Title: The Rehearsal

Dance: I: Grand Serious Ballet, as17421005; III: Tyrolean Dance, as17420921

Song: II: Hark the little warbling Choir-Beard

Music: IV: Concerto-Veracini

Performances

Afterpiece Title: Old Man Taught Wisdom

Song: By Desire, Arrah my Judy-Stoppelaer

Dance: Villeneuve, Dumont, Richardson, Delagarde, Destrade, Dupre, DeVaul

Performances

Mainpiece Title: The Rehearsal

Dance: I: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Miss Lucy in Town

Dance: I: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: King Richard Iii

Dance: As17421108

Song: Beard, Lowe

Performances

Mainpiece Title: The Rehearsal

Dance: I: Peasant Dance, as17420921; III: Tyrolean Dance, as17421129

Performances

Mainpiece Title: The Rehearsal

Dance: I: Les Moisoneurs de la Styrie, as17421201; III: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: The Rehearsal

Song: I: Beard; III: Lowe

Music: II: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Devil to Pay

Music: I: Concerto on German Flute-Burk Thumoth; IV: Concerto-Piantanida

Song: II: Baard

Performances

Mainpiece Title: The Rehearsal

Song: As17430120

Music: II: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: The Rehearsal

Dance: I: The Italian Gardeners-Checa, Siga Chiaretta, Mlle Bonneval; III: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Necromancer

Dance: LLa Provencale, as17421105; Dutch Skipper, as17421025; Peasants, as17421230

Performances

Mainpiece Title: The Rehearsal

Dance: II: Les Chasseurs, as17430226; IV: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Virgin Unmasked

Performances

Mainpiece Title: The Rehearsal

Dance: As17430324

Song: II: Song-Beard

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Rape of Proserpine

Dance: PPeasants, as17421230; New Grand Comic Ballet-Picq, Mlle Auguste