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, 21273, 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, 22920, 22987, 22998, 23003, 23008, 23059, 23080, 23185, 23284, 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, 24897, 24905, 24953, 25023, 25051, 25106, 25125, 25148, 25159, 25193, 25227, 25238, 25250, 25260, 25267, 25271, 25303, 25342, 25344, 25346, 25348, 25350, 25352, 25354, 25356, 25358, 25360, 25362, 25410, 25418, 25425, 25433, 25441, 25479, 25525, 25552, 25563, 25576, 25592, 25595, 25597, 25601, 25604, 25607, 25609, 25618, 25653, 25660, 25738, 25746, 25778, 25827, 25877, 25956, 25959, 25961, 25982, 26019, 26052, 26067, 26069, 26150, 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, 28616, 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, 31045, 31047, 31055, 31059, 31063, 31141, 31165, 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, 33804, 33813, 33817, 33832, 33874, 33897, 33902, 33916, 33930, 33969, 33990, 34010, 34023, 34037, 34050, 34058, 34070, 34076, 34086, 34132, 34162, 34173, 34202, 34207, 34213, 34258, 34342, 34349, 34366, 34388, 34434, 34466, 34469, 34471, 34474, 34476, 34478, 34521, 34546, 34580, 34599, 34601, 34643, 34668, 34684, 34713, 34722, 34730, 34739, 34770, 34787, 34796, 34816, 34866, 34870, 34901, 34910, 34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35019, 35024, 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, 35123, 35125, 35126, 35127, 35128, 35129, 35130, 35133, 35135, 35136, 35139, 35141, 35143, 35144, 35146, 35148, 35149, 35150, 35153, 35155, 35158, 35160, 35161, 35163, 35164, 35165, 35168, 35169, 35170, 35173, 35174, 35175, 35177, 35178, 35179, 35180, 35182, 35183, 35184, 35185, 35187, 35188, 35193, 35196, 35198, 35203, 35207, 35208, 35210, 35211, 35214, 35218, 35219, 35223, 35224, 35228, 35231, 35264, 35277, 35287, 35289, 35300, 35305, 35311, 35321, 35344, 35361, 35365, 35369, 35372, 35382, 35504, 35508, 35509, 35511, 35512, 35513, 35514, 35516, 35517, 35518, 35519, 35520, 35522, 35524, 35526, 35542, 35543, 35549, 35551, 35555, 35558, 35562, 35566, 35573, 35577, 35581, 35585, 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, 35876, 35890, 35907, 35925, 35968, 35983, 35990, 35995, 36002, 36127, 36180, 36325, 36380, 36434, 36453, 36454, 36461, 36479, 36486, 36505, 36562, 36573, 36617, 36647, 36649, 36655, 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, 37333, 37353, 37466, 37471, 37529, 37545, 37565, 37588, 37621, 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, 38107, 38172, 38314, 38322, 38328, 38344, 38379, 38414, 38422, 38434, 38439, 38441, 38457, 38478, 38480, 38482, 38484, 38486, 38488, 38489, 38497, 38510, 38517, 38522, 38523, 38524, 38526, 38529, 38531, 38533, 38535, 38537, 38539, 38541, 38544, 38546, 38548, 38550, 38552, 38555, 38557, 38558, 38560, 38561, 38562, 38567, 38569, 38579, 38582, 38584, 38592, 38595, 38602, 38607, 38610, 38612, 38623, 38626, 38633, 38648, 38655, 38658, 38670, 38672, 38675, 38686, 38700, 38723, 38768, 38930, 38989, 38994, 38995, 38996, 38999, 39000, 39001, 39007, 39017, 39024, 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, 39452, 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, 39717, 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, 47638, 47640, 47651, 47674, 47682, 47701, 47702, 47711, 47716, 47717, 47718, 47726, 47727, 47731, 47732, 47741, 47742, 47746, 47747, 47751, 47756, 47757, 47758, 47761, 47762, 47763, 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, 51582, 51612, 51778, 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: Macbeth

Afterpiece Title: The Rape of Proserpine

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

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Raftor, Ray.

Afterpiece Title: The Lying Valet

Dance: I: La Florana, as17430408 III: Sicilian Peasants, as17430310

Performances

Mainpiece Title: The Rehearsal

Cast
Role: Vocal Parts Actor: Beard, Lowe, Raftor, Ray

Song: I: Beard; III: Lowe; IV: Miss Edwards

Dance: II: Serious Dance, as17430504; V: Tyrolean Dance, as17421129

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Macbeth

Cast
Role: The Vocal Parts Actor:

Afterpiece Title: The Necromancer

Dance: Cooke

Performances

Mainpiece Title: Comus

Performances

Mainpiece Title: Comus

Performances

Mainpiece Title: Comus

Performances

Mainpiece Title: Macbeth

Cast
Role: The Vocal Parts Actor: Mrs _Clive.

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Macbeth

Cast
Role: The Vocal Parts Actor: Mrs _Clive.

Afterpiece Title: Flora; or, Hob in the Well

Dance: GGrand Ballet, as17440423

Performances

Mainpiece Title: Orpheus Seeking After Eurydice

Performances

Mainpiece Title: Macbeth

Dance: LLe Gondalier, as17441010; Scotch Dance-Villeneuve, Mrs Delagarde

Performances

Mainpiece Title: A Concert

Cast
Role: Vocal Parts Actor: the Misses Scott

Performances

Afterpiece Title: Pyramus and Thisbe

Performances

Mainpiece Title: A Concert Of Musick

Performances

Mainpiece Title: A Concert

Performances

Mainpiece Title: Joseph

Performances

Afterpiece Title: Pyramus and Thisbe

Dance: MMinuet-Destrade, Mrs Duval

Performances

Dance: Cooke, LaLauze, Villeneuve, Mrs Delagarde, Sga Campioni

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Afterpiece Title: Pyramus and Thisbe

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Mock Doctor

Dance: As17451109