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

Afterpiece Title: The Spoil'd Child

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Prisoner at Large

Song: Chorusses, as18000116, but Miss Leserve

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Volcano

Song: As18000118

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Volcano

Song: As18000118

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Volcano

Song: As18000118

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Volcano

Song: Chorusses, as18000118, but added: Mrs Bologna

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Volcano

Song: As18000124

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: _Hill

Afterpiece Title: The Volcano

Song: As18000124

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: _Hill

Afterpiece Title: The Volcano

Song: As18000124

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: _Hill

Afterpiece Title: The Volcano

Song: As18000124

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: _Hill

Afterpiece Title: The Volcano

Song: As18000124

Performances

Mainpiece Title: Joanna

Cast
Role: Vocal Parts Actor: Miss _Waters.

Afterpiece Title: The Turnpike Gate

Song: As18000124

Performances

Mainpiece Title: Joanna

Afterpiece Title: The Poor Soldier

Song: As18000124