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 Rehearsal

Song: I: Bright Author of my Present Flame-Lowe; II: Happy Pair-Beard; IV: If all that I love is her Face-Mrs Arne

Dance: III: A Dutch Dance, as17411114; V: Miller and his Wife, as17411015

Performances

Mainpiece Title: The Rehearsal

Dance: LLe Boufon, as17411030; Le Genereux Corsaire, as17411102

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Fortune Tellers

Song: I: Bright Author of my Present Flame-Lowe; II: Happy Pair-Beard,

Dance: III: A Dutch Dance, as17411114; IV: Sailor's Dance, as17411015; V: The Swiss, as17410926

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Harlequin Shipwrecked

Dance: Mlle Auguste (who never appeared on the English stage before); The Swiss, as17410926

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; II: Early Horn-Lowe

Dance: III: The Drunken Peasant, as17411029; IV: A Dutch Dance, as17411114; V: The Swiss, as17410926

Performances

Mainpiece Title: The Royal Merchant

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Drummer

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Funeral; Or, Grief A-la-mode

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Orpheus and Eurydice

Dance: Sga Barberina

Performances

Mainpiece Title: The Rehearsal

Dance: LLa Foullies-the Fausans

Ballet: LLes Satires Puny. As17420106

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: Rule A Wife

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Rehearsal

Dance: I: A Concerto, as17420105; II: The Drunken Peasant-Phillips; III: A Dutch Dance, as17411114; IV: Les Matelotes, as17411208

Ballet: V: Les Satires Puny. As17420106

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Orpheus and Eurydice

Dance: TTambourine-Mlle Auguste; Tyrolean Dance, as17420206

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Miser

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Mistake

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Fair Quaker Of Deal; Or, The Humours Of The Navy

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Fair Quaker Of Deal

Afterpiece Title: Orpheus and Eurydice

Dance: Desnoyer, Sga Barberina

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: Orpheus and Eurydice

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Orpheus and Eurydice

Ballet: RRural Assembly. As17420121

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Orpheus and Eurydice

Dance: Sga Barbarina