SELECT * FROM london_stages WHERE eventid IN (992, 996, 1024, 1030, 1203, 1213, 1221, 1236, 1259, 1262, 1284, 1291, 1292, 1302, 1318, 1319, 1335, 1338, 1355, 1356, 1373, 1376, 1401, 1447, 1451, 1465, 1522, 1523, 1542, 1575, 1582, 1601, 1622, 1688, 1691, 1711, 1713, 1735, 1747, 1765, 1778, 1780, 1820, 1843, 1857, 1877, 1878, 1886, 1899, 1922, 1935, 1960, 2034, 2048, 2095, 2283, 2290, 2308, 2380, 2400, 2446, 2538, 2573, 2641, 2708, 2813, 2983, 3213, 3704, 3799, 3877, 3961, 4036, 4038, 4042, 4043, 4044, 4045, 4048, 4050, 4051, 4065, 4078, 4107, 4139, 4140, 4150, 4162, 4171, 4176, 4183, 4188, 4196, 4225, 4231, 4239, 4251, 4305, 4316, 4317, 4320, 4322, 4324, 4326, 4328, 4338, 4340, 4359, 4372, 4380, 4402, 4408, 4416, 4422, 4433, 4435, 4445, 4461, 4472, 4510, 4531, 4535, 4562, 4564, 4571, 4573, 4575, 4577, 4581, 4582, 4583, 4586, 4588, 4590, 4592, 4594, 4595, 4596, 4598, 4599, 4600, 4601, 4602, 4605, 4606, 4607, 4608, 4610, 4611, 4612, 4613, 4615, 4616, 4655, 4656, 4672, 4714, 4726, 4751, 4785, 4817, 4820, 4830, 4833, 4836, 4839, 4840, 4846, 4853, 4899, 4900, 4901, 4914, 4939, 4952, 4996, 5113, 5121, 5129, 5132, 5133, 5145, 5150, 5154, 5199, 5220, 5254, 5260, 5262, 5275, 5277, 5289, 5301, 5306, 5309, 5328, 5337, 5352, 5356, 5386, 5405, 5408, 5411, 5421, 5463, 5477, 5480, 5484, 5519, 5644, 5645, 5648, 5656, 5657, 5664, 5666, 5783, 5785, 5792, 5794, 5799, 5803, 5839, 5841, 5845, 5848, 5865, 5922, 5972, 6018, 6024, 6033, 6038, 6071, 6074, 6085, 6086, 6090, 6091, 6093, 6094, 6095, 6097, 6109, 6125, 6153, 6198, 6228, 6232, 6233, 6235, 6243, 6246, 6276, 6286, 6315, 6411, 6428, 6430, 6488, 6492, 6493, 6496, 6498, 6502, 6506, 6508, 6513, 6525, 6526, 6527, 6534, 6539, 6543, 6547, 6556, 6569, 6571, 6573, 6577, 6579, 6583, 6589, 6615, 6619, 6620, 6634, 6658, 6666, 6670, 6672, 6689, 6693, 6713, 6716, 6724, 6730, 6738, 6741, 6747, 6773, 6816, 6828, 6831, 6851, 6865, 6894, 6897, 6903, 6908, 6925, 6927, 6933, 6935, 6948, 6961, 6964, 6972, 6981, 6983, 6985, 7022, 7028, 7031, 7034, 7037, 7048, 7065, 7066, 7074, 7077, 7080, 7084, 7085, 7088, 7089, 7090, 7096, 7097, 7099, 7100, 7104, 7112, 7120, 7122, 7124, 7132, 7153, 7155, 7160, 7164, 7168, 7176, 7184, 7191, 7198, 7212, 7227, 7230, 7233, 7234, 7240, 7241, 7242, 7258, 7260, 7272, 7273, 7276, 7280, 7294, 7308, 7310, 7316, 7328, 7334, 7341, 7344, 7345, 7351, 7365, 7372, 7376, 7378, 7385, 7390, 7392, 7395, 7397, 7402, 7404, 7406, 7409, 7412, 7416, 7418, 7419, 7421, 7422, 7423, 7424, 7427, 7430, 7436, 7437, 7444, 7446, 7448, 7450, 7451, 7454, 7456, 7458, 7459, 7464, 7469, 7470, 7472, 7474, 7476, 7477, 7478, 7484, 7489, 7496, 7500, 7513, 7517, 7535, 7537, 7540, 7560, 7568, 7580, 7582, 7586, 7593, 7595, 7598, 7602, 7605, 7612, 7627, 7652, 7664, 7665, 7677, 7686, 7697, 7732, 7742, 7744, 7748, 7757, 7853, 7875, 7877, 7880, 7884, 7887, 7890, 7893, 7912, 7916, 7919, 7922, 7932, 7936, 7940, 7942, 7944, 7946, 7948, 7950, 7954, 7978, 7981, 7989, 7991, 7994, 8006, 8012, 8018, 8023, 8025, 8052, 8053, 8066, 8077, 8082, 8088, 8093, 8099, 8101, 8103, 8108, 8110, 8136, 8138, 8141, 8144, 8152, 8177, 8181, 8186, 8195, 8198, 8206, 8228, 8235, 8240, 8249, 8252, 8263, 8321, 8342, 8345, 8349, 8352, 8355, 8358, 8361, 8372, 8379, 8381, 8383, 8387, 8393, 8395, 8397, 8400, 8407, 8411, 8417, 8425, 8429, 8439, 8459, 8462, 8464, 8466, 8469, 8474, 8476, 8482, 8485, 8494, 8497, 8505, 8527, 8530, 8545, 8557, 8560, 8563, 8579, 8582, 8609, 8615, 8618, 8622, 8625, 8632, 8636, 8649, 8660, 8697, 8700, 8710, 8715, 8718, 8728, 8738, 8743, 8751, 8755, 8759, 8764, 8768, 8770, 8783, 8787, 8791, 8793, 8802, 8834, 8848, 8866, 8875, 8883, 8887, 9283, 9339, 9341, 9344, 9355, 9357, 9380, 9381, 9383, 9393, 9400, 9406, 9410, 9420, 9445, 9448, 9450, 9452, 9455, 9457, 9466, 9469, 9471, 9476, 9480, 9494, 9497, 9499, 9504, 9513, 9516, 9522, 9531, 9533, 9535, 9545, 9550, 9553, 9555, 9558, 9560, 9563, 9566, 9571, 9573, 9576, 9587, 9589, 9597, 9602, 9604, 9608, 9611, 9614, 9625, 9651, 9664, 9693, 9722, 9724, 9737, 9751, 9783, 9790, 9792, 9798, 9807, 9826, 9842, 9919, 9929, 9931, 9934, 9952, 9958, 9964, 10000, 10011, 10051, 10218, 10225, 10232, 10274, 10277, 10284, 10319, 10332, 10364, 10366, 10367, 10370, 10371, 10373, 10374, 10376, 10378, 10379, 10410, 10413, 10476, 10481, 10576, 10679, 10682, 10685, 10689, 10692, 10695, 10698, 10704, 10710, 10717, 10723, 10730, 10734, 10737, 10742, 10747, 10752, 10762, 10904, 11124, 11126, 11129, 11131, 11134, 11136, 11138, 11140, 11143, 11145, 11148, 11151, 11154, 11157, 11163, 11168, 11174, 11179, 11185, 11190, 11197, 11203, 11212, 11216, 11219, 11223, 11226, 11227, 11416, 11418, 11424, 11432, 11439, 11448, 11455, 11487, 11494, 11604, 11612, 11614, 11895, 13653, 13656, 13659, 13662, 13666, 14466, 14469, 14492, 14496, 14499, 14785, 14796, 14826, 15001, 15005, 15008, 15011, 15014, 15144, 15240, 15245, 15339, 15451, 15465, 15505, 15566, 15570, 15584, 15601, 15604, 15618, 15727, 15730, 15783, 15788, 15793, 15798, 15804, 15810, 15815, 15821, 15824, 15827, 15833, 15849, 15860, 15915, 15919, 15923, 15927, 15931, 15934, 15938, 15956, 15970, 15974, 15981, 15997, 16025, 16037, 16058, 16088, 16091, 16107, 16125, 16147, 16151, 16156, 16160, 16164, 16168, 16172, 16176, 16186, 16190, 16194, 16200, 16204, 16210, 16214, 16218, 16222, 16228, 16232, 16238, 16244, 16251, 16365, 16369, 16374, 16383, 16387, 16398, 16406, 16421, 16428, 16468, 16487, 16573, 16609, 16632, 16635, 16636, 16642, 16644, 16661, 16665, 16668, 16673, 16678, 16686, 16690, 16693, 16697, 16701, 16725, 16768, 16772, 16781, 16785, 16788, 16792, 16795, 16818, 16917, 16929, 16936, 16940, 16959, 17001, 17005, 17227, 17284, 17349, 17361, 17372, 17375, 17376, 17392, 17408, 17411, 17412, 17413, 17414, 17418, 17422, 17533, 17539, 17547, 17768, 17771, 17775, 17781, 17784, 17787, 17790, 17827, 17831, 17833, 17837, 17841, 17845, 17850, 17855, 17860, 17873, 17878, 17883, 17890, 17968, 18075, 18086, 18166, 18168, 18173, 18174, 18175, 18176, 18178, 18187, 18189, 18207, 18219, 18225, 18236, 18276, 18316, 18328, 18330, 18334, 18351, 18387, 18390, 18397, 18401, 18407, 18411, 18445, 18452, 18469, 18471, 18475, 18479, 18482, 18488, 18492, 18495, 18503, 18515, 18519, 18526, 18530, 18538, 18541, 18551, 18602, 18614, 18620, 18625, 18635, 18646, 18657, 18682, 18723, 18757, 18765, 18794, 18798, 18803, 18807, 18816, 18828, 18839, 18864, 18891, 18896, 18905, 18906, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18932, 18934, 18938, 18942, 18975, 18989, 18993, 18996, 18998, 19001, 19003, 19005, 19007, 19010, 19013, 19015, 19017, 19019, 19022, 19033, 19035, 19037, 19047, 19050, 19052, 19055, 19057, 19082, 19084, 19089, 19094, 19117, 19122, 19129, 19162, 19187, 19189, 19196, 19236, 19238, 19240, 19242, 19244, 19247, 19249, 19262, 19270, 19272, 19276, 19277, 19279, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19301, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19350, 19352, 19354, 19356, 19358, 19362, 19368, 19374, 19376, 19377, 19379, 19383, 19394, 19398, 19405, 19413, 19415, 19418, 19423, 19425, 19444, 19446, 19451, 19453, 19459, 19491, 19504, 19522, 19529, 19543, 19545, 19547, 19549, 19568, 19572, 19601, 19611, 19620, 19644, 19661, 19666, 19671, 19673, 19675, 19679, 19689, 19695, 19697, 19737, 19741, 19757, 19763, 19766, 19768, 19770, 19772, 19789, 19800, 19805, 19808, 19815, 19818, 19820, 19823, 19827, 19832, 19834, 19836, 19839, 19842, 19855, 19858, 19861, 19877, 19878, 19903, 19983, 20022, 20027, 20048, 20051, 20062, 20065, 20069, 20081, 20084, 20090, 20097, 20106, 20135, 20153, 20159, 20160, 20163, 20166, 20169, 20172, 20175, 20178, 20184, 20187, 20190, 20193, 20196, 20199, 20205, 20208, 20217, 20227, 20233, 20242, 20245, 20248, 20254, 20257, 20264, 20267, 20273, 20286, 20292, 20295, 20311, 20326, 20343, 20347, 20375, 20381, 20398, 20415, 20421, 20438, 20461, 20589, 20630, 20691, 20720, 20745, 20751, 20774, 20786, 20825, 20832, 20835, 20838, 20841, 20845, 20860, 20864, 20867, 20872, 20875, 20895, 20914, 20948, 20951, 20967, 20970, 20977, 20980, 20984, 20986, 20993, 21007, 21017, 21027, 21048, 21056, 21089, 21096, 21103, 21112, 21116, 21126, 21139, 21168, 21188, 21191, 21195, 21209, 21230, 21246, 21250, 21262, 21304, 21308, 21314, 21354, 21359, 21360, 21362, 21364, 21372, 21378, 21396, 21398, 21418, 21422, 21425, 21430, 21467, 21470, 21479, 21482, 21500, 21503, 21537, 21576, 21587, 21623, 21626, 21702, 21706, 21709, 21724, 21754, 21761, 21781, 21783, 21788, 21795, 21814, 21816, 21821, 21830, 22302, 22312, 22321, 22330, 22336, 22344, 22439, 22461, 22470, 22480, 22489, 22493, 22505, 22531, 22534, 22545, 22561, 22627, 22635, 22687, 22695, 22757, 22769, 22786, 22792, 22797, 22847, 22856, 22862, 22885, 22888, 22926, 22929, 22932, 22938, 22947, 22956, 22958, 22961, 22970, 22973, 22991, 23000, 23002, 23004, 23011, 23014, 23017, 23022, 23026, 23029, 23032, 23035, 23037, 23040, 23049, 23052, 23055, 23062, 23090, 23097, 23106, 23113, 23124, 23127, 23150, 23156, 23168, 23175, 23214, 23228, 23235, 23244, 23247, 23251, 23261, 23268, 23271, 23277, 23295, 23300, 23301, 23315, 23317, 23329, 23331, 23346, 23349, 23351, 23360, 23365, 23369, 23371, 23380, 23383, 23389, 23393, 23396, 23409, 23433, 23460, 23480, 23501, 23512, 23553, 23590, 23600, 23606, 23655, 23683, 23698, 23746, 23771, 23774, 23783, 23804, 23829, 23836, 23839, 23848, 23859, 23861, 23865, 23875, 23912, 23916, 23920, 23940, 23960, 23964, 23970, 24023, 24024, 24063, 24073, 24153, 24184, 24197, 24228, 24239, 24243, 24267) 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 Old Batchelor

Cast
Role: Barnaby Actor: Leigh.

Song: III: Song-Lowe

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

Performances

Mainpiece Title: Hamlet

Cast
Role: Bookseller Actor: Leigh

Song: II: Beard; IV: Lowe

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Jaques Actor: Leigh

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

Performances

Mainpiece Title: The Relapse

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Trusty Actor: Leigh

Song: II: Beard; III: Lowe

Music: V: Concerto-Piantanida

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Daniel Actor: Leigh

Dance: II: Les Moisoneurs de la Styrie, as17421201; V: La Recrue des Houssars, as17421211

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Tom Errand Actor: Leigh

Song: As17421126

Music: II: Concerto on Violincello-Cervetti

Dance: IV: Les Moisoneurs de la Styrie, as17421126

Performances

Mainpiece Title: The Committee

Cast
Role: Bookseller Actor: Leigh

Afterpiece Title: The King and Miller of Mansfield

Song: As17430103

Music: III: Concerto on Violincello-Cervetti; V: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: The Committee

Cast
Role: Bookseller Actor: Leigh

Song: I: Beard; III: Lowe

Dance: II: Neopolitan Punch, as17430114; IV: Italian Gardeners, as17421231

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Jaques Actor: Leigh

Song: As17430120

Music: II: Concerto on Violincello-Cervetti; IV: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: The Committee

Cast
Role: Bookseller Actor: Leigh

Afterpiece Title: The Devil to Pay

Dance: As17430120

Performances

Mainpiece Title: 1 Henry Iv: With The Humours Of Sir John Falstaff

Cast
Role: Gadshill Actor: Leigh

Song: 1 As17430120

Music: 1 As17430205

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Tom Errand Actor: Leigh

Afterpiece Title: The Lying Valet

Song: As17430120

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Tom Errand Actor: Leigh

Afterpiece Title: The Lying Valet

Dance: I: The Sicilian Peasant, as17430310 III: La Mascarade de Florana-Checo, Chiaretta; V: Italian Gardeners, as17421231

Performances

Mainpiece Title: The Alchemist

Cast
Role: Dapper Actor: Leigh

Afterpiece Title: The School Boy

Dance: II: Sicilian Peasant, as17430310 IV: Italian Gardeners, as17421231

Song: III: Beard

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Tom Errand Actor: Leigh

Song: As17430120

Dance: II: La Mascarade de Florana, as17430319 IV: Italian Gardeners, as17421231

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Barnaby Actor: Leigh.

Afterpiece Title: The Virgin Unmask'd

Music: I: Concerto-Piantinida; IV: A New Concerto (never perform'd before) on the German Flute-Burk Thumoth

Dance: II: Neopolitan Punch, as17430324

Song: III: Distracted I Turn-Beard

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Trusty Actor: Leigh

Song: II: Beard; IV: Lowe

Dance: III: Sicilian Peasant, as17430310

Music: V: Concerto on German Flute-Burk Thumoth

Performances

Mainpiece Title: The Alchemist

Cast
Role: Dapper Actor: Leigh

Afterpiece Title: The Virgin Unmask'd

Song: III: Was Ever Nymph Like Rosamond-Beard

Dance: II: Sicilian Peasant, as17430310 IV: La Florana, as17430408

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Barnaby Actor: Leigh.

Afterpiece Title: The Devil To Pay

Dance: I: Grand Serious Ballet, as17421005; V: Sicilian Peasant, as17430310

Music: II: Concerto-Piantanida; IV: Solo-Piantanida

Song: III: An Italian Song-a Gentlewoman

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Daniel Actor: Leigh

Afterpiece Title: The Lying Valet

Dance: II: Serious Ballet-Mlle Bonneval; III: La Florana, as17430408 IV: A New Hussar Dance-Boromeo, Mlle Bonneval

Music: V: A concerto-Piantanida

Performances

Mainpiece Title: Love Makes A Man

Cast
Role: Jaques Actor: Leigh

Afterpiece Title: The Lying Valet

Song: II: Beard; III: Lowe

Music: IV: Concerto-Burk Thumoth

Performances

Mainpiece Title: The Alchemist

Cast
Role: Dapper Actor: Leigh

Afterpiece Title: The Devil to Pay

Song: I: Lowe; IV: Beard

Dance: II: Les Moisoneurs de la Styrie, as17421201; La Florana, as17430408

Performances

Mainpiece Title: The Old Batchelor

Cast
Role: Barnaby Actor: Leigh.

Afterpiece Title: The Virgin Unmask'd

Song: As17430120

Dance: II: Tyrolean Dance, as17421129; IV: New Serious Ballet, as17430425

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Trusty Actor: Leigh

Song: I: A New Song by Boyce-Beard; IV: A Cantata by Stanley-Lowe

Dance: II: Tyrolean Dance, as17421129; V: a Minuet-Froment, Mrs Freeman

Performances

Mainpiece Title: The Conscious Lovers

Cast
Role: Daniel Actor: Leigh

Afterpiece Title: The Lying Valet

Song: III: Song-Lowe

Dance: II: Tyrolean Dance, as17421129; IV: Sicilian Peasant, as17430310