SELECT * FROM london_stages WHERE eventid IN (147, 234, 270, 450, 975, 1136, 1235, 1236, 1237, 1239, 1259, 1262, 1263, 1284, 1291, 1292, 1296, 1302, 1318, 1319, 1337, 1356, 1373, 1401, 1419, 1447, 1451, 1522, 1523, 1777, 1779, 1780, 1786, 1794, 1814, 1825, 4616, 6014, 10012, 13026, 13044, 13048, 13057, 13120, 13124, 13153, 15815, 15821, 15824, 15827, 15871, 15876, 15880, 15884, 15891, 15910, 15953, 16008, 16016, 16070, 16091, 16097, 16135, 16147, 16327, 16368, 16387, 16497, 16530, 16550, 16703, 16707, 16710, 16714, 16718, 16722, 16727, 16731, 16734, 16741, 16745, 16749, 16754, 16758, 16793, 16797, 16813, 16816, 16820, 16824, 16838, 16842, 16846, 16851, 16867, 16907, 16911, 16939, 16942, 16946, 16950, 16953, 16957, 16961, 16966, 16970, 16974, 16978, 16982, 16986, 16990, 16994, 16998, 17003, 17007, 17012, 17016, 17020, 17025, 17031, 17035, 17039, 17045, 17056, 17061, 17099, 17124, 17253, 17269, 17273, 17393, 17413, 17446, 17449, 17456, 17485, 17488, 17492, 17494, 17497, 17506, 17510, 17512, 17515, 17518, 17526, 17530, 17532, 17535, 17537, 17538, 17540, 17541, 17546, 17552, 17555, 17561, 17565, 17568, 17571, 17575, 17578, 17582, 17587, 17595, 17597, 17601, 17609, 17612, 17617, 17622, 17626, 17635, 17637, 17641, 17644, 17648, 17651, 17652, 17656, 17659, 17662, 17665, 17669, 17672, 17675, 17678, 17681, 17684, 17688, 17691, 17695, 17699, 17701, 17704, 17708, 17709, 17711, 17712, 17715, 17719, 17721, 17722, 17724, 17725, 17728, 17729, 17731, 17732, 17735, 17736, 17739, 17742, 17746, 17748, 17754, 17759, 17761, 17765, 17770, 17776, 17782, 17783, 17786, 17791, 17795, 17796, 17851, 17856, 17861, 17862, 17867, 17875, 17880, 17885, 17892, 17897, 17922, 17927, 17940, 17948, 17955, 17966, 17970, 17999, 18009, 18012, 18026, 18030, 18051, 18123, 18171, 18190, 18193, 18196, 18199, 18202, 18203, 18206, 18210, 18214, 18216, 18226, 18228, 18231, 18233, 18239, 18241, 18244, 18248, 18250, 18251, 18253, 18257, 18259, 18273, 18275, 18277, 18278, 18280, 18281, 18283, 18286, 18288, 18289, 18292, 18295, 18299, 18303, 18306, 18309, 18317, 18320, 18324, 18329, 18332, 18335, 18336, 18338, 18339, 18342, 18346, 18348, 18349, 18353, 18355, 18356, 18358, 18361, 18362, 18365, 18366, 18368, 18369, 18373, 18376, 18377, 18380, 18382, 18383, 18385, 18386, 18388, 18389, 18391, 18392, 18398, 18399, 18403, 18405, 18409, 18412, 18444, 18446, 18460, 18468, 18477, 18481, 18484, 18490, 18493, 18494, 18497, 18504, 18505, 18516, 18517, 18521, 18525, 18535, 18540, 18543, 18547, 18559, 18590, 18594, 18604, 18609, 18616, 18622, 18631, 18648, 18652, 18659, 18679, 18688, 18701, 18705, 18725, 18763, 18774, 18800, 18842, 19036, 19041, 19043, 19065, 19075, 19123, 19149, 19245, 19251, 19255, 19261, 19263, 19271, 19281, 19283, 19285, 19291, 19293, 19295, 19300, 19302, 19310, 19314, 19316, 19319, 19321, 19323, 19325, 19327, 19329, 19331, 19333, 19335, 19337, 19339, 19341, 19343, 19349, 19351, 19378, 19380, 19382, 19384, 19387, 19389, 19391, 19395, 19408, 19410, 19412, 19421, 19426, 19465, 19474, 19479, 19481, 19483, 19485, 19487, 19500, 19537, 19591, 19596, 19612, 19662, 19665, 19668, 19672, 19678, 19680, 19682, 19684, 19686, 19688, 19746, 19754, 19787, 19790, 19794, 19799, 19801, 19821, 19833, 19835, 19851, 19856, 19866, 19869, 19872, 19875, 19879, 19882, 19889, 19900, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20154, 20156, 20158, 20161, 20164, 20167, 20170, 20173, 20176, 20179, 20197, 20198, 20200, 20207, 20212, 20215, 20234, 20240, 20259, 20290, 20299, 20302, 20330, 20344, 20348, 20351, 20360, 20370, 20373, 20382, 20402, 20416, 20419, 20420, 20422, 20426, 20430, 20442, 20446, 20449, 20458, 20462, 20466, 20469, 20483, 20487, 20498, 20501, 20506, 20511, 20517, 20521, 20543, 20555, 20559, 20568, 20571, 20577, 20581, 20608, 20611, 20651, 20706, 20733, 20740, 20743, 20747, 20754, 20758, 20761, 20770, 20772, 20775, 20778, 20787, 20790, 20797, 20800, 20803, 20806, 20815, 20818, 20823, 20826, 20842, 20846, 20849, 20855, 20858, 20861, 20865, 20868, 20873, 20876, 20879, 20887, 20893, 20896, 20899, 20903, 20906, 20912, 20918, 20935, 20938, 20942, 20945, 20949, 20952, 20956, 20961, 20965, 20968, 20971, 20974, 20991, 20994, 21001, 21005, 21008, 21011, 21021, 21025, 21028, 21031, 21034, 21038, 21042, 21052, 21060, 21070, 21073, 21077, 21080, 21084, 21087, 21093, 21104, 21110, 21113, 21117, 21127, 21133, 21140, 21144, 21151, 21154, 21158, 21162, 21169, 21178, 21185, 21206, 21210, 21213, 21221, 21243, 21251, 21258, 21282, 21294, 21299, 21311, 21312, 21319, 21329, 21373, 21393, 21522, 21525, 21532, 21538, 21545, 21549, 21552, 21555, 21558, 21560, 21562, 21565, 21571, 21577, 21582, 21588, 21599, 21603, 21612, 21615, 21618, 21620, 21624, 21627, 21630, 21633, 21639, 21648, 21652, 21660, 21665, 21668, 21671, 21675, 21678, 21683, 21688, 21707, 21756, 21793, 21800, 21828, 21840, 22316, 22319, 22322, 24294, 24299, 24301, 24302, 24303, 24304, 24305, 24306, 24308, 24309, 24310, 24311, 24312, 24313, 24315, 24316, 28683, 36789, 38309, 40277, 40287, 40290, 40299, 40303, 40313, 40318, 40328, 40332, 40342, 40347, 40811, 40814, 40823, 40826, 40836, 40840, 40850, 40854, 40864, 40867, 41410, 41419, 41423, 41432, 41438, 41449, 41452, 41464, 41468, 41478, 41483, 42387, 42627, 43680, 43691, 43694, 43704, 43710, 43724, 43738, 43749, 43754, 45960, 46343, 46381, 46389, 47479, 48278, 48285, 48637, 48669, 48687, 48695, 48699, 48715, 48717, 48727, 48729, 48739, 48747, 48749, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48851, 48856, 48860, 48865, 48868, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48945, 48947, 48952, 48959, 48961, 48971, 48980, 48986, 48988, 48990, 48993, 49002, 49007, 49009, 49014, 49018, 49021, 49023, 49033, 49038, 49041, 49043, 49053, 49056, 49058, 49061, 49066, 49072, 49074, 49077, 49081, 49083, 49086, 49088, 49090, 49092, 49095, 49100, 49193, 49197, 49199, 49201, 49206, 49208, 49211, 49214, 49217, 49219, 49222, 49224, 49226, 49228, 49229, 49232, 49236, 49250, 49252, 49256, 49258, 49260, 49262, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49430, 49432, 49434, 49439, 49449, 49452, 49454, 49458, 49462, 49465, 49478, 49504, 49517, 49556, 49558, 49583, 49597, 49599, 49607, 49609, 49614, 49620, 49625, 49632, 49637, 49644, 49649, 49653, 49657, 49659, 49664, 49754, 49761, 49766, 49768, 49777, 49783, 49785, 49788, 49791, 49796, 49799, 49801, 49803, 49813, 49817, 49819, 49835, 49843, 49845, 49849, 49853, 49857, 49869, 49873, 49877, 49886, 49891, 49893, 49895, 49900, 49902, 49910, 49917, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50111, 50113, 50116, 50121, 50123, 50126, 50141, 50143, 50151, 50153, 50156, 50161, 50163, 50170, 50172, 50175, 50177, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50215, 51235) 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: Hamlet

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Song: As17931216, but omitted: Miss Paye, Mrs Blurton, Mrs Castelle, Miss Leserve

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Don Caesar Actor: Richardson

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Douglas

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: A Day In Turkey; Or, The Russian Slaves

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Song: As17931008

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Just In Time

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Dance: In Act II of mainpiece a Dance by Holland and Mlle St. Amand

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The World In A Village

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Marian

Afterpiece Title: THE SIEGE OF BERWICK

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Hamlet

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Song: As17940109

Performances

Mainpiece Title: Douglas

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Macbeth

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Song: As17931227, but Mrs Follett in place of Mrs Clendining

Performances

Mainpiece Title: Love's Frailties

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Don Caesar Actor: Richardson

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: THE FARMER

Cast
Role: Farmer Blackberry Actor: Richardson

Dance: As17931022

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Cast
Role: Pillardoc Actor: Richardson

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Serjeant Actor: Richardson

Afterpiece Title: THE DEAF LOVER