SELECT * FROM london_stages WHERE eventid IN (1533, 1539, 1567, 12476, 12478, 12481, 12483, 12487, 12489, 12491, 12493, 12500, 12502, 12506, 12512, 12521, 12527, 12546, 14905, 14918, 20141, 20149, 20151, 20166, 20169, 20172, 20175, 20178, 20181, 20184, 20187, 20190, 20193, 20196, 20199, 20208, 20211, 20220, 20230, 20239, 20242, 20248, 20264, 20270, 20276, 20298, 20301, 20307, 20311, 20317, 20320, 20323, 20326, 20336, 20339, 20342, 20343, 20347, 20350, 20353, 20356, 20359, 20362, 20366, 20369, 20375, 20378, 20381, 20385, 20389, 20392, 20395, 20435, 20438, 20441, 20457, 20468, 20532, 20549, 20558, 20562, 20564, 20567, 20573, 20576, 20583, 20586, 20603, 20607, 20610, 20613, 20621, 20630, 20637, 20641, 20650, 20656, 20665, 20668, 20671, 20676, 20679, 20681, 20682, 20684, 20690, 20692, 20693, 20694, 20695, 20696, 20697, 20699, 20709, 20711, 20712, 20714, 20717, 20720, 20725, 20735, 20742, 20745, 20749, 20753, 20763, 20766, 20769, 20771, 20774, 20796, 20809, 20812, 20822, 20829, 20848, 20860, 20864, 20867, 20872, 20875, 20878, 20882, 20886, 20890, 20895, 20905, 20941, 20944, 20951, 20960, 20997, 21000, 21013, 21037, 21048, 21069, 21072, 21139, 21143, 21146, 21150, 21153, 21157, 21160, 21165, 21168, 21172, 21175, 21177, 21181, 21191, 21202, 21209, 21212, 21217, 21225, 21226, 21234, 21237, 21240, 21250, 21287, 21298, 21310, 21321, 21337, 21338, 21339, 21341, 21342, 21345, 21347, 21352, 21354, 21359, 21360, 21368, 21378, 21384, 21386, 21388, 21392, 21394, 21396, 21398, 21401, 21403, 21407, 21418, 21420, 21425, 21434, 21454, 21460, 21462, 21473, 21476, 21482, 21495, 21498, 21509, 21524, 21531, 21544, 21546, 21561, 21564, 21567, 21578, 21593, 21598, 21609, 21611, 21623, 21638, 21645, 21667, 21670, 21680, 21690, 21693, 21712, 21719, 21736, 21754, 21761, 21764, 21767, 21776, 21779, 21781, 21783, 21791, 21792, 21799, 21811, 21814, 21816, 21819, 21821, 21831, 21832, 21834, 21836, 21837, 22309, 22312, 22315, 22318, 22324, 22327, 22355, 22396, 22397, 22399, 22417, 22420, 22433, 22477, 22480, 22496, 22505, 22508, 22524, 22531, 22537, 22542, 22545, 22548, 22552, 22555, 22558, 22561, 22564, 22567, 22570, 22574, 22580, 22583, 22586, 22589, 22591, 22595, 22598, 22601, 22605, 22608, 22612, 22618, 22620, 22624, 22627, 22631, 22635, 22669, 22672, 22687, 22690, 22699, 22744, 22746, 22757, 22760, 22769, 22772, 22776, 22789, 22792, 22797, 22810, 22819, 22821, 22826, 22860, 22896, 22938, 22944, 22950, 22953, 22956, 22958, 22961, 22964, 22967, 22970, 22973, 22978, 22981, 22984, 22986, 22991, 22994, 22997, 23000, 23002, 23004, 23011, 23014, 23022, 23029, 23032, 23035, 23037, 23040, 23044, 23046, 23049, 23055, 23062, 23067, 23079, 23082, 23090, 23100, 23103, 23106, 23110, 23113, 23118, 23121, 23124, 23127, 23136, 23139, 23142, 23147, 23156, 23168, 23171, 23175, 23178, 23186, 23202, 23206, 23209, 23214, 23216, 23219, 23225, 23230, 23242, 23244, 23247, 23258, 23261, 23268, 23271, 23277, 23285, 23292, 23310, 23312, 23345, 23346, 23349, 23351, 23353, 23356, 23360, 23367, 23369, 23373, 23380, 23382, 23383, 23387, 23389, 23393, 23396, 23400, 23405, 23409, 23416, 23419, 23422, 23425, 23428, 23433, 23436, 23438, 23441, 23445, 23448, 23454, 23457, 23464, 23470, 23473, 23476, 23484, 23495, 23498, 23501, 23517, 23520, 23527, 23531, 23542, 23545, 23581, 23587, 23593, 23600, 23606, 23618, 23632, 23658, 23661, 23668, 23674, 23680, 23692, 23705, 23708, 23710, 23713, 23720, 23724, 23727, 23730, 23735, 23739, 23743, 23746, 23751, 23755, 23758, 23771, 23777, 23791, 23794, 23799, 23814, 23818, 23836, 23841, 23848, 23857, 23861, 23867, 23875, 23891, 23894, 23895, 23896, 23897, 23910, 23911, 23912, 23918, 23926, 23934, 23937, 23938, 23943, 23966, 23967, 23968, 23971, 23974, 23986, 23988, 23990, 23991, 24000, 24001, 24010, 24012, 24016, 24023, 24024, 24028, 24031, 24036, 24037, 24039, 24041, 24055, 24058, 24076, 24084, 24086, 24088, 24126, 24129, 24132, 24133, 24141, 24142, 24144, 24148, 24152, 24155, 24159, 24163, 24179, 24181, 24187, 24190, 24194, 24200, 24210, 24214, 24218, 24228, 24235, 24239, 24243, 24247, 24257, 24265, 24326, 24329, 24339, 24344, 24346, 24350, 24355, 24358, 24360, 24361, 24369, 24386, 24394, 24396, 24404, 24408, 24410, 24426, 24428, 24449, 24455, 24458, 24461, 24464, 24467, 24469, 24481, 24483, 24489, 24494, 24500, 24516, 24518, 24527, 24537, 24562, 24568, 24597, 24610, 24613, 24615, 24619, 24624, 24630, 24645, 24654, 24661, 24669, 24674, 24677, 24680, 24691, 24699, 24702, 24713, 24716, 24730, 24732, 24737, 24739, 24742, 24746, 24750, 24752, 24759, 24762, 24766, 24772, 24774, 24778, 24794, 24871, 24874, 24877, 24879, 24883, 24887, 24890, 24895, 24897, 24899, 24901, 24903, 24910, 24912, 24915, 24917, 24919, 24924, 24926, 24932, 24934, 24936, 24938, 24940, 24945, 24951, 24956, 24961, 24964, 24967, 24971, 24974, 24977, 24979, 24982, 24985, 24988, 24991, 24997, 24999, 25002, 25004, 25007, 25009, 25011, 25013, 25016, 25018, 25021, 25023, 25025, 25027, 25030, 25032, 25034, 25036, 25039, 25041, 25043, 25045, 25048, 25050, 25052, 25054, 25056, 25058, 25060, 25062, 25064, 25066, 25069, 25071, 25073, 25075, 25077, 25080, 25082, 25085, 25087, 25089, 25091, 25093, 25095, 25097, 25099, 25103, 25105, 25107, 25109, 25111, 25113, 25115, 25118, 25120, 25126, 25144, 25158, 25188, 25193, 25198, 25201, 25205, 25209, 25211, 25212, 25214, 25219, 25228, 25233, 25238, 25241, 25250, 25253, 25256, 25260, 25263, 25272, 25281, 25283, 25287, 25296, 25308, 25334, 25336, 25363, 25365, 25367, 25369, 25373, 25376, 25378, 25380, 25382, 25390, 25392, 25394, 25396, 25402, 25404, 25406, 25408, 25410, 25412, 25414, 25417, 25419, 25421, 25423, 25426, 25428, 25430, 25432, 25434, 25436, 25438, 25440, 25442, 25444, 25446, 25458, 25460, 25466, 25470, 25472, 25474, 25480, 25482, 25486, 25488, 25491, 25493, 25495, 25501, 25503, 25505, 25509, 25511, 25517, 25521, 25523, 25525, 25531, 25540, 25542, 25549, 25551, 25553, 25555, 25557, 25560, 25563, 25565, 25567, 25571, 25577, 25581, 25583, 25603, 25613, 25617, 25624, 25626, 25634, 25638, 25640, 25642, 25644, 25646, 25653, 25658, 25661, 25663, 25666, 25668, 25672, 25674, 25676, 25679, 25685, 25689, 25691, 25693, 25701, 25703, 25705, 25707, 25740, 25742, 25745, 25747, 25748, 25751, 25754, 25756, 25760, 25762, 25765, 25767, 25769, 25773, 25775, 25777, 25779, 25783, 25787, 25789, 25791, 25793, 25795, 25797, 25799, 25801, 25805, 25807, 25809, 25811, 25813, 25815, 25819, 25826, 25830, 25832, 25839, 25841, 25855, 25858, 25866, 25868, 25874, 25878, 25887, 25894, 25900, 25903, 25908, 25913, 25917, 25924, 25933, 25938, 25942, 25946, 25953, 25955, 25960, 25970, 25972, 25975, 25978, 25981, 26033, 26037, 26042, 26047, 26050, 26052, 26056, 26060, 26079, 26100, 26113, 26126, 26128, 26131, 26134, 26136, 26138, 26142, 26145, 26147, 26149, 26154, 26160, 26167, 26171, 26176, 26181, 26183, 26185, 26190, 26192, 26197, 26199, 26201, 26210, 26212, 26216, 26218, 26222, 26228, 26230, 26232, 26238, 26240, 26242, 26246, 26252, 26254, 26264, 26266, 26271, 26278, 26288, 26290, 26297, 26299, 26301, 26309, 26315, 26327, 26330, 26339, 26342, 26345, 26348, 26353, 26362, 26374, 26377, 26379, 26382, 26387, 26392, 26409, 26417, 26419, 26435, 26514, 26529, 26549, 26552, 26555, 26559, 26562, 26564, 26568, 26574, 26578, 26583, 26585, 26587, 26590, 26593, 26598, 26600, 26602, 26605, 26609, 26611, 26615, 26617, 26621, 26623, 26625, 26632, 26640, 26642, 26644, 26646, 26650, 26655, 26659, 26665, 26667, 26673, 26675, 26678, 26680, 26682, 26684, 26686, 26692, 26696, 26698, 26700, 26704, 26706, 26712, 26720, 26722, 26724, 26732, 26739, 26741, 26743, 26748, 26750, 26755, 26759, 26773, 26776, 26778, 26781, 26783, 26785, 26787, 26801, 26806, 26809, 26813, 26815, 26820, 26824, 26839, 26844, 26849, 26853, 26858, 26867, 26899, 26904, 26920, 26929, 26950, 26960, 26975, 26983, 26989, 26995, 26998, 27016, 27023, 27027, 27033, 27040, 27046, 27048, 27052, 27054, 27057, 27059, 27064, 27067, 27069, 27072, 27075, 27078, 27080, 27086, 27088, 27091, 27096, 27098, 27103, 27106, 27145, 27148, 27156, 27165, 27175, 27178, 27183, 27185, 27188, 27190, 27194, 27205, 27207, 27209, 27219, 27221, 27223, 27225, 27227, 27229, 27233, 27235, 27237, 27241, 27244, 27247, 27250, 27255, 27258, 27260, 27268, 27270, 27277, 27284, 27287, 27290, 27295, 27300, 27304, 27325, 27333, 27341, 27343, 27351, 27354, 27365, 27395, 27398, 27407, 27412, 27415, 27528, 27530, 27539, 27542, 27547, 27553, 27556, 27571, 27578, 27580, 27585, 27592, 27595, 27597, 27600, 27605, 27607, 27618, 27620, 27627, 27668, 27670, 27678, 27681, 27686, 27689, 27691, 27693, 27695, 27697, 27699, 27701, 27703, 27705, 27709, 27711, 27713, 27715, 27721, 27725, 27729, 27731, 27733, 27736, 27738, 27740, 27742, 27745, 27747, 27751, 27753, 27755, 27758, 27760, 27762, 27766, 27768, 27771, 27773, 27776, 27778, 27782, 27785, 27790, 27796, 27807, 27818, 27820, 27823, 27825, 27830, 27832, 27834, 27839, 27841, 27843, 27845, 27847, 27852, 27855, 27858, 27868, 27871, 27873, 27875, 27877, 27880, 27885, 27906, 27911, 27914, 27921, 27925, 27933, 27941, 27946, 27948, 27950, 27973, 27993, 28032, 28036, 28039, 28042, 28044, 28046, 28050, 28070, 28075, 28079, 28087, 28095, 28100, 28103, 28105, 28108, 28127, 28133, 28137, 28139, 28143, 28145, 28147, 28149, 28163, 28167, 28171, 28175, 28177, 28179, 28181, 28188, 28194, 28196, 28202, 28206, 28222, 28226, 28230, 28238, 28250, 28274, 28281, 28286, 28292, 28294, 28296, 28300, 28302, 28311, 28313, 28316, 28318, 28325, 28332, 28355, 28382, 28385, 28432, 28460, 28519, 28522, 28527, 28530, 28542, 28560, 28611, 28614, 28626, 28629, 28631, 28634, 28646, 28649, 28652, 28654, 28674, 28678, 28682, 28692, 28706, 28708, 28713, 28722, 28724, 28732, 28746, 28755, 28757, 28760, 28764, 28766, 28769, 28776, 28778, 28785, 28791, 28795, 28816, 28835, 28838, 28842, 28855, 28865, 28870, 28872, 28875, 28880, 28886, 28888, 28892, 28894, 28897, 28903, 28906, 28909, 28916, 28923, 28951, 28963, 28965, 28984, 28989, 28994, 29012, 29017, 29020, 29032, 29042, 29047, 29049, 29152, 29162, 29164, 29170, 29173, 29175, 29177, 29180, 29186, 29188, 29190, 29194, 29196, 29200, 29206, 29210, 29212, 29214, 29216, 29218, 29220, 29222, 29224, 29233, 29236, 29238, 29247, 29249, 29258, 29263, 29267, 29279, 29286, 29290, 29305, 29307, 29341, 29345, 29368, 29370, 29380, 29389, 29401, 29403, 29406, 29408, 29411, 29413, 29415, 29453, 29462, 29485, 29507, 29514, 29523, 29528, 29536, 29543, 29554, 29594, 29601, 29721, 29724, 29737, 29787, 29822, 29834, 29836, 29845, 29854, 29867, 29887, 29906, 29918, 29922, 29925, 29928, 29930, 29933, 29939, 29944, 29950, 29955, 29966, 29972, 29976, 29979, 29982, 29984, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30034, 30049, 30053, 30056, 30058, 30060, 30062, 30064, 30069, 30071, 30074, 30076, 30082, 30087, 30091, 30094, 30096, 30104, 30112, 30119, 30124, 30131, 30135, 30138, 30142, 30144, 30154, 30286, 30288, 30291, 30295, 30299, 30301, 30315, 30321, 30333, 30335, 30339, 30343, 30351, 30362, 30374, 30381, 30385, 30388, 30390, 30395, 30408, 30410, 30413, 30415, 30420, 30429, 30432, 30441, 30443, 30448, 30452, 30472, 30475, 30479, 30484, 30561, 30566, 30587, 30592, 30597, 30603, 30606, 30608, 30619, 30622, 30627, 30629, 30641, 30648, 30653, 30660, 30670, 30684, 30692, 30699, 30779, 30785, 30796, 30806, 30814, 30830, 30862, 30865, 30867, 30870, 30872, 30874, 30880, 30882, 30886, 30888, 30891, 30893, 30983, 30987, 31001, 31040, 31045, 31047, 31055, 31057, 31059, 31063, 31072, 31074, 31076, 31094, 31109, 31112, 31139, 31162, 31165, 31168, 31179, 31187, 31197, 31200, 31214, 31247, 31253, 31266, 31279, 31339, 31350, 31354, 31356, 31360, 31389, 31395, 31411, 31437, 31439, 31441, 31443, 31459, 31510, 31540, 31626, 31648, 31673, 31684, 31703, 31723, 31725, 31763, 31787, 32688, 32782, 33264, 33790, 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, 35074, 35076, 35078, 35088, 35092, 35094, 35104, 35108, 35111, 35118, 35125, 35127, 35129, 35135, 35143, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35207, 35210, 35218, 35223, 35264, 35277, 35289, 35305, 35365, 35372, 35382, 36201, 36317, 36437, 36473, 36508, 36516, 36555, 36565, 51168, 51170, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51266, 51312, 51341, 51345, 51351, 51356) 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: King Lear And His Three Daughters

Afterpiece Title: The Virgin Unmask'd

Cast
Role: Quaver Actor: Lowe

Song: II: Song-Beard; IV: Song-Lowe

Music: III: Concerto-Piantinada

Performances

Mainpiece Title: As You Like It

Cast
Role: Amiens Actor: Lowe

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Song: I: Song-Beard

Dance: V: Turkish Seraglio, as17421025, but With New Habits and Decorations

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: Grand Serious Ballet, as17421005; Turkish Seraglio, as17421027

Song: III: Happy Pair-Beard

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Mackheath Actor: Lowe

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: Les Matelotes, as17421009; V: Turkish Seraglio, as17421027

Song: III: The Early Horn-Lowe

Performances

Mainpiece Title: The Rehearsal

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

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: I: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: Les Matelotes, as17421009; V: Turkish Seraglio, as17421027

Music: III: Concerto-Veracini

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Mock Doctor

Cast
Role: Leander Actor: Lowe.

Dance: IV: Grand Serious Ballet, as17421005

Music: IV: Concerto-Veracini

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: Grand Serious Ballet, as17421005; V: Turkish Seraglio, as17421025

Music: III: Concerto-Veracini

Performances

Mainpiece Title: King Richard Iii

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

Dance: As17421108

Song: Beard, Lowe

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: La Mascarada-Brunoro, Mlle Bonneval; IV: Turkish Seraglio-Brunoro,Signora Costanza

Music: III: Concerto-Piantinada

Performances

Mainpiece Title: The Committee

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Song: I: Beard; III: Lowe

Dance: II: La Mascarada, as17421112; IV: Grand Serious Ballet, as17421005; V: Turkish Seraglio, as17421112

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: Grand Comic Dance, as17421117; V: Harlequin Dance, as17421117

Song: III: Beard

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Lorenzo Actor: Lowe

Song: I: Lowe; III: Beard

Dance: II: Les Matelotes, as17421009; IV: Turkish Seraglio, as17421112

Performances

Mainpiece Title: As You Like It

Cast
Role: Amiens Actor: Lowe

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: I: Grand Comic Dance-Torinese, Signora Aquilanti; V: Les Moisoneurs de la Styrie, as17421126

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: Miss Lucy in Town

Cast
Role: Ballad Actor: Lowe

Dance: II: Grand Comic Dance, as17421130; V: Les Moisoneurs de la Styrie-Checo, Signora Chiaretti

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Macheath Actor: Lowe.
Role: Mackheath Actor: Lowe

Dance: I: Grand Comic Dance, as17421117; II: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Rehearsal

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

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

Performances

Mainpiece Title: The Relapse

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Valentine Actor: Lowe

Song: II: Beard; III: Lowe

Music: V: Concerto-Piantanida

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Lowe

Song: I: Beard; IV: Lowe

Performances

Mainpiece Title: The Rehearsal

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

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

Performances

Mainpiece Title: As You Like It

Cast
Role: Amiens Actor: Lowe

Dance: I: Les Moisoneurs de la Styrie, as17421126; IV: La Recrue des Houssars-Checo, Chiaretti

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Lowe

Dance: II: Tyrolean Dance, as17421129; V: Peasant Dance, as17420921

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Devil to Pay

Cast
Role: Sir John Loverule Actor: Lowe

Song: I: Beard; IV: Lowe

Music: III: A Concerto on Violincello-Cervetti; V: A Concerto-Piantinida

Performances

Mainpiece Title: As You Like It

Cast
Role: Amiens Actor: Lowe

Afterpiece Title: The King and Miller of Mansfield

Song: III: Beard

Music: II: Concerto on German Flute-Burke Thumoth; V: Concerto on Violincello-Cervetti