SELECT * FROM london_stages WHERE eventid IN (287, 321, 359, 365, 937, 1288, 1302, 1337, 1341, 1344, 1356, 1359, 1367, 1371, 1373, 1376, 1388, 1402, 1408, 1410, 1413, 1415, 1419, 1425, 1430, 1447, 1451, 1457, 1465, 1475, 1479, 1549, 1567, 1581, 1582, 1601, 1683, 1728, 1732, 1735, 1736, 1737, 1740, 1746, 1747, 1765, 1769, 1772, 1778, 1779, 1794, 1814, 1825, 1828, 1843, 1878, 1882, 1899, 1914, 1919, 1984, 1988, 1999, 2020, 2022, 2059, 2113, 2163, 2165, 2217, 2274, 2362, 2395, 2593, 2727, 3145, 3170, 3264, 3440, 7090, 7128, 7132, 7160, 7164, 7168, 7268, 7304, 7336, 7388, 7401, 7404, 7406, 7416, 7419, 7422, 7423, 7424, 7425, 7426, 7429, 7486, 7550, 7554, 7556, 7559, 7561, 7563, 7578, 7589, 7592, 7639, 7647, 7659, 7709, 7804, 7838, 7846, 7860, 7886, 7891, 7898, 7982, 8076, 8092, 8159, 8233, 8302, 8303, 8318, 8321, 8424, 8458, 8562, 8631, 8654, 8665, 8711, 8740, 8790, 8810, 8813, 8825, 8826, 8830, 8832, 8834, 8853, 8862, 8868, 8894, 8898, 8900, 8903, 8906, 8942, 8956, 9016, 9022, 9037, 9052, 9064, 9080, 9083, 9093, 9097, 9112, 9136, 9143, 9146, 9149, 9154, 9157, 9160, 9164, 9178, 9198, 9218, 9223, 9243, 9251, 9255, 9262, 9267, 9312, 9314, 9328, 9353, 9379, 9395, 9404, 9407, 9413, 9419, 9421, 9433, 9440, 9442, 9444, 9515, 9530, 9532, 9536, 9546, 9570, 9607, 9616, 9635, 9643, 9648, 9675, 9680, 9716, 9736, 9757, 9773, 9779, 9787, 9789, 9797, 9806, 9809, 9839, 9882, 9887, 9897, 9912, 9922, 9928, 9935, 9937, 9940, 9953, 9993, 10004, 10012, 10047, 10057, 10062, 10076, 10085, 10121, 10132, 10145, 10147, 10150, 10152, 10157, 10159, 10171, 10193, 10260, 10276, 10286, 10304, 10310, 10362, 10365, 10368, 10369, 10372, 10386, 10389, 10395, 10398, 10401, 10434, 10440, 10451, 10453, 10468, 10471, 10480, 10495, 10497, 10513, 10523, 10537, 10542, 10552, 10572, 10578, 10609, 10626, 10641, 10644, 10650, 10652, 10661, 10673, 10701, 10726, 10740, 10750, 10782, 10785, 10788, 10791, 10797, 10803, 10820, 10833, 10836, 10875, 10877, 10879, 10881, 10884, 10886, 10889, 10893, 10895, 10903, 10906, 10916, 10917, 10941, 10943, 10955, 10957, 10959, 10969, 10971, 10975, 11002, 11008, 11029, 11044, 11047, 11080, 11094, 11116, 11171, 11208, 11232, 11235, 11257, 11262, 11274, 11304, 11356, 11357, 11358, 11362, 11419, 11421, 11429, 11436, 11443, 11450, 11453, 11476, 11479, 11481, 11508, 11513, 11519, 11576, 11595, 11609, 11617, 11626, 11631, 11663, 11676, 11693, 11698, 11711, 11714, 11740, 11744, 11758, 11761, 11763, 11766, 11769, 11774, 11801, 11802, 11804, 11808, 11812, 11814, 11820, 11823, 11831, 11849, 11851, 11854, 11867, 11870, 11876, 11879, 11922, 11929, 11947, 11955, 11957, 11960, 11962, 11965, 11967, 11969, 11971, 11973, 11975, 11980, 11984, 11992, 11994, 12084, 12087, 12144, 12150, 12155, 12177, 12186, 12199, 12201, 12213, 12216, 12224, 12244, 12252, 12255, 12291, 12292, 12313, 12315, 12317, 12319, 12331, 12333, 12339, 12341, 12342, 12345, 12352, 12353, 12361, 12374, 12376, 12386, 12394, 12396, 12404, 12407, 12410, 12415, 12443, 12461, 12473, 12475, 12479, 12486, 12490, 12495, 12501, 12509, 12522, 12528, 12529, 12538, 12545, 12550, 12559, 12578, 12580, 12593, 12596, 12619, 12623, 12631, 12633, 12638, 12642, 12644, 12660, 12666, 12681, 12693, 12697, 12701, 12704, 12713, 12720, 12723, 12726, 12731, 12734, 12737, 12738, 12741, 12743, 12746, 12748, 12749, 12751, 12752, 12825, 12831, 12840, 12842, 12844, 12845, 12849, 12852, 12858, 12862, 12864, 12877, 12879, 12880, 12885, 12887, 12892, 12893, 12895, 12896, 12898, 12901, 12904, 12905, 12907, 12908, 12910, 12911, 12913, 12914, 12915, 12917, 12919, 12923, 12927, 12931, 12937, 12940, 12942, 12944, 12947, 12951, 12952, 12954, 12957, 12961, 12964, 12967, 12972, 12976, 12980, 12983, 12992, 12994, 12996, 12998, 13002, 13005, 13008, 13012, 13014, 13016, 13018, 13022, 13025, 13029, 13030, 13032, 13035, 13038, 13040, 13041, 13043, 13047, 13050, 13052, 13056, 13060, 13061, 13063, 13066, 13070, 13073, 13074, 13076, 13077, 13079, 13083, 13087, 13091, 13094, 13098, 13101, 13105, 13109, 13113, 13116, 13117, 13119, 13127, 13128, 13130, 13132, 13134, 13135, 13137, 13139, 13141, 13142, 13144, 13146, 13148, 13150, 13152, 13154, 13156, 13158, 13160, 13162, 13164, 13165, 13167, 13169, 13171, 13173, 13178, 13179, 13189, 13198, 13202, 13206, 13210, 13214, 13216, 13219, 13221, 13225, 13228, 13233, 13238, 13242, 13245, 13247, 13250, 13263, 13266, 13268, 13270, 13272, 13277, 13281, 13287, 13289, 13292, 13296, 13301, 13304, 13309, 13312, 13318, 13322, 13324, 13326, 13328, 13330, 13333, 13337, 13343, 13345, 13347, 13351, 13355, 13358, 13360, 13363, 13367, 13370, 13372, 13377, 13388, 13396, 13399, 13412, 13414, 13416, 13419, 13421, 13424, 13426, 13431, 13436, 13439, 13443, 13446, 13453, 13455, 13457, 13460, 13466, 13468, 13471, 13474, 13476, 13480, 13482, 13484, 13486, 13489, 13492, 13493, 13495, 13497, 13498, 13501, 13503, 13507, 13509, 13514, 13515, 13517, 13519, 13522, 13524, 13525, 13528, 13529, 13530, 13532, 13533, 13537, 13544, 13548, 13550, 13553, 13554, 13556, 13559, 13561, 13562, 13566, 13568, 13574, 13576, 13577, 13579, 13582, 13584, 13586, 13592, 13594, 13597, 13599, 13600, 13603, 13606, 13608, 13610, 13614, 13623, 13625, 13630, 13631, 13632, 13635, 13637, 13638, 13642, 13644, 13645, 13647, 13651, 13653, 13655, 13656, 13658, 13659, 13662, 13664, 13666, 13668, 13669, 13673, 13675, 13676, 13678, 13679, 13681, 13682, 13684, 13686, 13688, 13690, 13692, 13694, 13696, 13700, 13701, 13703, 13705, 13707, 13711, 13719, 13723, 13724, 13726, 13730, 13736, 13738, 13740, 13742, 13745, 13748, 13750, 13752, 13756, 13758, 13760, 13768, 13769, 13771, 13773, 13775, 13777, 13779, 13781, 13783, 13785, 13787, 13789, 13794, 13798, 13802, 13804, 13808, 13810, 13811, 13813, 13815, 13817, 13818, 13822, 13824, 13826, 13828, 13830, 13832, 13833, 13835, 13837, 13839, 13841, 13843, 13845, 13847, 13851, 13853, 13855, 13857, 13859, 13861, 13863, 13864, 13867, 13869, 13871, 13873, 13875, 13877, 13879, 13880, 13884, 13888, 13893, 13895, 13897, 13901, 13905, 13907, 13909, 13911, 13915, 13918, 13921, 13925, 13927, 13929, 13930, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13959, 13960, 13966, 13969, 13977, 13980, 13986, 13988, 13989, 13991, 13993, 13997, 14001, 14003, 14004, 14006, 14010, 14013, 14017, 14020, 14028, 14032, 14035, 14039, 14043, 14045, 14051, 14057, 14059, 14063, 14065, 14069, 14073, 14079, 14084, 14088, 14096, 14108, 14110, 14114, 14119, 14121, 14123, 14131, 14135, 14137, 14142, 14146, 14151, 14154, 14158, 14161, 14170, 14174, 14181, 14187, 14189, 14194, 14201, 14208, 14210, 14214, 14218, 14221, 14223, 14227, 14229, 14239, 14255, 14258, 14263, 14270, 14274, 14297, 14300, 14301, 14302, 14306, 14319, 14325, 14345, 14355, 14358, 14361, 14363, 14364, 14366, 14370, 14373, 14377, 14380, 14384, 14387, 14388, 14391, 14392, 14394, 14395, 14399, 14403, 14404, 14407, 14409, 14410, 14412, 14413, 14416, 14418, 14423, 14426, 14431, 14432, 14436, 14438, 14441, 14443, 14445, 14448, 14451, 14452, 14456, 14459, 14463, 14466, 14469, 14470, 14473, 14478, 14480, 14486, 14488, 14489, 14491, 14492, 14496, 14498, 14499, 14503, 14517, 14518, 14522, 14524, 14528, 14530, 14531, 14533, 14535, 14537, 14544, 14547, 14550, 14555, 14556, 14558, 14559, 14561, 14564, 14567, 14571, 14574, 14577, 14580, 14584, 14587, 14591, 14597, 14601, 14605, 14608, 14612, 14621, 14632, 14640, 14644, 14651, 14664, 14671, 14691, 14698, 14703, 14720, 14722, 14724, 14731, 14738, 14742, 14750, 14760, 14780, 14782, 14785, 14787, 14791, 14796, 14798, 14800, 14807, 14811, 14813, 14826, 14831, 14848, 14851, 14855, 14857, 14859, 14861, 14866, 14871, 14876, 14878, 14881, 14883, 14887, 14889, 14894, 14904, 14906, 14910, 14921, 14925, 14927, 14934, 14935, 14946, 14953, 14957, 14959, 14966, 14970, 14974, 14977, 14983, 14986, 14989, 14991, 14992, 15001, 15002, 15005, 15006, 15008, 15011, 15012, 15023, 15032, 15034, 15043, 15046, 15051, 15057, 15058, 15071, 15088, 15089, 15091, 15096, 15114, 15123, 15144, 15148, 15152, 15156, 15161, 15164, 15169, 15171, 15173, 15176, 15180, 15182, 15184, 15191, 15197, 15200, 15220, 15230, 15233, 15235, 15236, 15240, 15245, 15249, 15254, 15259, 15280, 15284, 15288, 15291, 15300, 15303, 15315, 15347, 15350, 15357, 15360, 15401, 15493, 15517, 15542, 15545, 15548, 15588, 15620, 15633, 15735, 15737, 15740, 15762, 15769, 15784, 15787, 15799, 15869, 16530, 16590, 16596, 17373, 17374, 17378, 17382, 17384, 17393, 17398, 18000, 19986, 20705, 20828, 21840, 22431, 22473, 23020, 23551, 23555, 23595, 23599, 23605, 23608, 23626, 23660, 23667, 23670, 23707, 24491, 24681, 24764, 24771, 24775, 24779, 24789, 24796, 24799, 25127, 25133, 25164, 25170, 25182, 25195, 31228, 31259, 31839, 31847, 31891, 31985, 31987, 31989, 31991, 31993, 31995, 31998, 32000, 32003, 32005, 32007, 32009, 32012, 32014, 32017, 32019, 32021, 32023, 32026, 32028, 32030, 32032, 32034, 32036, 32039, 32041, 32045, 32047, 32049, 32051, 32054, 32057, 32059, 32061, 32063, 32066, 32068, 32078, 32083, 32090, 32095, 32097, 32102, 32106, 32114, 32131, 32224, 32372, 32378, 32386, 32397, 32401, 32409, 33311, 35812, 35891, 37125, 37135, 37137, 37139, 37143, 37148, 37149, 37150, 37154, 37157, 37160, 37162, 37163, 37165, 37167, 37168, 37170, 37172, 37173, 37177, 37178, 37179, 37180, 37183, 37186, 37188, 37190, 37191, 37193, 37195, 37197, 37199, 37201, 37203, 37204, 37208, 37210, 37721, 37722, 37723, 37724, 37727, 37729, 37731, 37733, 37736, 37738, 37741, 37743, 37745, 37747, 37750, 37752, 37755, 37757, 37759, 37761, 37764, 37767, 37769, 37772, 37777, 37782, 37789, 38015, 38218, 38223, 38229, 38235, 38246, 38250, 38253, 38254, 38260, 38261, 38263, 38267, 38270, 38271, 38278, 38279, 38283, 38292, 38295, 38299, 38300, 38303, 38304, 38306, 38307, 38308, 38309, 38319, 38379, 38397, 38402, 38416, 38444, 38458, 38465, 39360, 39463, 40324, 40591, 40641, 40645, 40652, 40657, 40662, 40666, 40682, 40712, 40722, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40742, 40766, 40769, 40771, 40776, 40780, 40783, 40786, 40794, 40796, 40800, 40806, 40808, 40812, 40815, 40818, 40820, 40841, 40847, 40851, 40855, 40861, 40869, 40875, 40877, 40879, 40881, 40883, 40893, 40901, 40909, 40930, 40942, 40947, 40952, 40959, 40964, 40982, 40984, 40996, 41003, 41114, 41116, 41118, 41129, 41157, 41178, 41197, 41242, 41260, 41263, 41280, 41282, 41284, 41286, 41289, 41296, 41303, 41308, 41310, 41314, 41317, 41319, 41324, 41328, 41333, 41351, 41363, 41368, 41378, 41384, 41387, 41389, 41393, 41396, 41398, 41403, 41416, 41440, 41444, 41446, 41459, 41465, 41470, 41497, 41502, 41517, 41519, 41526, 41538, 41553, 41563, 41572, 41687, 41690, 41694, 41696, 41706, 41710, 41715, 41717, 41720, 41728, 41740, 41748, 41764, 41780, 41785, 41789, 41794, 41827, 41865, 41897, 41905, 41907, 41933, 41957, 41988, 42002, 42006, 42049, 42070, 42080, 42107, 42118, 42140, 44470, 44474, 44502, 44505, 44513, 44520, 44531, 44537, 44540, 44551, 46879, 46887, 46889, 47001, 47005, 47013, 47022, 47025, 47037, 47040, 47049, 47050, 47061, 47076, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47179, 47186, 47204, 47214, 47229, 47270, 47273, 47283, 47304, 47320, 48602, 50017, 51022, 51235, 51940) 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: Love In A Village

Afterpiece Title: The Devil to Pay; or, the Wives Metamorphosed

Cast
Role: Fiddler Actor: Williams

Dance: II: Hornpipe-Rawlins

Song: End Opera: Aileen a Roon-Mrs Woodman

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Dance: As17750515

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Virgin Unmask'd

Cast
Role: Coupee Actor: Williams

Dance: End: A Dance-

Performances

Afterpiece Title: The Virgin Unmask'd

Cast
Role: Coupee Actor: Williams

Dance: End: A Dance-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: Cross Purposes

Cast
Role: Harry Actor: Williams

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Dance: End: A Dance-

Performances

Afterpiece Title: The Waterman; or, The First of August

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Waterman

Dance: The Merry Lasses-

Performances

Afterpiece Title: The Waterman

Dance: The Haymakers-

Performances

Afterpiece Title: The Author

Dance: The Medley-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Devil to Pay

Dance: The Medley-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Waterman

Dance: The Haymakers-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Devil to Pay

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Medley-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Author

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Patron

Cast
Role: Juliet Actor: Mrs Williams.

Afterpiece Title: Cross Purposes

Cast
Role: Harry Actor: Williams

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Dutchman

Dance: Tambourine Dance-

Performances

Mainpiece Title: The Maid Of Bath

Cast
Role: Parts Actor: Davies, _Williams.

Afterpiece Title: The Lyar

Dance: Tambourine Dance-

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Diana Trapes Actor: Mrs Williams

Afterpiece Title: The Waterman

Dance: A Tambourine Dance-

Entertainment: End: A Variety of Imitations-Hutton, Bannister

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Dutchman

Dance: The Medley-

Performances

Mainpiece Title: The Commissary

Afterpiece Title: Cross Purposes

Cast
Role: Harry Actor: Williams.

Dance: The Haymakers-

Performances

Mainpiece Title: The Cozeners

Afterpiece Title: The Mayor of Garratt

Monologue: Piety in Pattens. As 11 Sept

Dance: The Medley-

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Bonniface Actor: Williams
Role: Mrs Sullen Actor: Mrs Williams

Afterpiece Title: The Lyar

Entertainment: Imitations, Vocal and Rhetorical-Bannister