SELECT * FROM london_stages WHERE eventid IN (43460, 43618, 43627, 43666, 43671, 43678, 43699, 43812, 43852, 44011, 44012, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44029, 44133, 44533, 44536, 44539, 44541, 44544, 44545, 44546, 44550, 44552, 44553, 44571, 44581, 44591, 45056, 45098, 45099, 45101, 45104, 45105, 45107, 45110, 45115, 45117, 45121, 45122, 45123, 45124, 45128, 45129, 45130, 45131, 45132, 45133, 45134, 45587, 45616, 45625, 45627, 45629, 45632, 45638, 45642, 45646, 45648, 45652, 45655, 45656, 45657, 45658, 45659, 45660, 45661, 45663, 45665, 45666, 45667, 45671, 45673, 45676, 45677, 45680, 45684, 45686, 45688, 45690, 45735, 45740, 45748, 45756, 45758, 45759, 45761, 45763, 45765, 45769, 45773, 45775, 45777, 45781, 45785, 45787, 45789, 45799, 45803, 45807, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45897, 45899, 45902, 45904, 45906, 45911, 45920, 45932, 45939, 45948, 45951, 45962, 45980, 46002, 46007, 46018, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46078, 46080, 46093, 46100, 46103, 46121, 46130, 46133, 46137, 46148, 46151, 46154, 46166, 46169, 46171, 46174, 46178, 46294, 46309, 46319, 46323, 46349, 46353, 46389, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46474, 46476, 46478, 46481, 46486, 46490, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46547, 46550, 46557, 46561, 46566, 46590, 46593, 46600, 46604, 46607, 46609, 46612, 46622, 46639, 46642, 46644, 46668, 46691, 46695, 46700, 46708, 46711, 46726, 46729, 46731, 46737, 46743, 46745, 46746, 46747, 46760, 46761, 46772, 46778, 46783, 46786, 46792, 46793, 46797, 46801, 46804, 46805, 46809, 46810, 46812, 46816, 46817, 46819, 46820, 46821, 46822, 46824, 46825, 46829, 46838, 46841, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46867, 46871, 46873, 46879, 46887, 46889, 46891, 46895, 46899, 46901, 46903, 46905, 46907, 46909, 46911, 46915, 46917, 46941, 46949, 46957, 46959, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47001, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47043, 47047, 47051, 47053, 47057, 47063, 47068, 47073, 47079, 47081, 47114, 47173, 47198, 47202, 47209, 47212, 47220, 47224, 47231, 47235, 47242, 47244, 47247, 47253, 47255, 47264, 47266, 47277, 47279, 47283, 47285, 47289, 47297, 47306, 47309, 47312, 47315, 47320, 47326, 47327, 47334, 47335, 47339, 47341, 47345, 47346, 47349, 47356, 47360, 47361, 47362, 47363, 47366, 47368, 47371, 47374, 47376, 47378, 47380, 47382, 47383, 47384, 47386, 47387, 47388, 47391, 47394, 47400, 47401, 47404, 47406, 47408, 47410, 47414, 47415, 47419, 47420, 47421, 47425, 47427, 47439, 47442, 47449, 47451, 47456, 47459, 47464, 47467, 47472, 47474, 47475, 47478, 47482, 47484, 47485, 47487, 47491, 47493, 47495, 47497, 47499, 47501, 47503, 47505, 47507, 47509, 47513, 47517, 47519, 47521, 47525, 47527, 47529, 47531, 47533, 47537, 47541, 47543, 47545, 47547, 47549, 47551, 47553, 47555, 47557, 47561, 47566, 47568, 47570, 47575, 47577, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47645, 47647, 47649, 47651, 47655, 47657, 47665, 47670, 47672, 47676, 47683, 47685, 47688, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47769, 47774, 47779, 47782, 47787, 47792, 47794, 47797, 47800, 47805, 47808, 47813, 47815, 47820, 47823, 47825, 47828, 47835, 47840, 47843, 47858, 47865, 47872, 47882, 47887, 47892, 47912, 47915, 47916, 47917, 47919, 47920, 47921, 47922, 47924, 47926, 47927, 47929, 47930, 47931, 47934, 47936, 47937, 47938, 47941, 47942, 47943, 47944, 47945, 47946, 47948, 47949, 47951, 47952, 47954, 47955, 47956, 47957, 47958, 47959, 47960, 47961, 47962, 47963, 47965, 47967, 47969, 47970, 47971, 47972, 47976, 47977, 47979, 47980, 47982, 47985, 47986, 47988, 47989, 47990, 47991, 47997, 48015, 48017, 48020, 48023, 48032, 48036, 48038, 48039, 48041, 48043, 48045, 48049, 48051, 48053, 48055, 48057, 48059, 48061, 48062, 48064, 48066, 48068, 48070, 48072, 48074, 48076, 48078, 48080, 48082, 48084, 48086, 48090, 48093, 48095, 48097, 48099, 48101, 48103, 48105, 48109, 48111, 48113, 48115, 48117, 48119, 48123, 48125, 48127, 48129, 48131, 48133, 48135, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48186, 48188, 48190, 48194, 48197, 48199, 48202, 48204, 48206, 48209, 48211, 48214, 48216, 48218, 48220, 48223, 48225, 48229, 48233, 48236, 48238, 48243, 48247, 48250, 48252, 48257, 48261, 48264, 48266, 48271, 48275, 48278, 48280, 48285, 48289, 48294, 48299, 48303, 48306, 48308, 48311, 48320, 48322, 48325, 48327, 48329, 48331, 48336, 48344, 48347, 48349, 48356, 48358, 48361, 48363, 48366, 48368, 48370, 48372, 48375, 48377, 48380, 48382, 48384, 48394, 48404, 48409, 48411, 48416, 48418, 48423, 48430, 48437, 48439, 48440, 48443, 48444, 48447, 48535, 48539, 48549, 48551, 48553, 48563, 48569, 48575, 48577, 48583, 48585, 48588, 48598, 48605, 48613, 48618, 48620, 48621, 48628, 48634, 48635, 48640, 48642, 48645, 48650, 48654, 48656, 48659, 48664, 48665, 48667, 48669, 48672, 48675, 48677, 48679, 48684, 48685, 48687, 48689, 48692, 48694, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48712, 48714, 48717, 48719, 48722, 48727, 48729, 48732, 48734, 48735, 48737, 48739, 48744, 48747, 48749, 48752, 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, 48837, 48840, 48842, 48844, 48846, 48849, 48851, 48854, 48856, 48858, 48860, 48863, 48865, 48868, 48870, 48874, 48877, 48884, 48902, 48904, 48913, 48916, 48923, 48930, 48942, 48945, 48947, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 48995, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49046, 49051, 49053, 49056, 49058, 49066, 49069, 49072, 49077, 49081, 49083, 49086, 49088, 49090, 49100, 49184, 49191, 49193, 49195, 49199, 49201, 49203, 49206, 49208, 49211, 49214, 49216, 49222, 49224, 49226, 49232, 49238, 49242, 49244, 49246, 49248, 49250, 49254, 49256, 49260, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49366, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49406, 49408, 49411, 49420, 49422, 49425, 49427, 49432, 49436, 49439, 49441, 49445, 49449, 49452, 49454, 49458, 49462, 49465, 49467, 49472, 49475, 49478, 49480, 49485, 49490, 49493, 49495, 49500, 49504, 49507, 49509, 49513, 49517, 49520, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49553, 49556, 49560, 49563, 49565, 49568, 49570, 49573, 49575, 49578, 49580, 49585, 49587, 49589, 49592, 49594, 49599, 49602, 49604, 49607, 49609, 49612, 49614, 49620, 49630, 49635, 49637, 49640, 49642, 49646, 49649, 49650, 49655, 49657, 49659, 49662, 49664, 49667, 49754, 49759, 49761, 49764, 49770, 49772, 49779, 49783, 49788, 49791, 49794, 49797, 49799, 49801, 49803, 49805, 49809, 49811, 49813, 49815, 49819, 49823, 49825, 49827, 49829, 49831, 49833, 49835, 49837, 49839, 49841, 49843, 49845, 49847, 49849, 49851, 49853, 49855, 49857, 49859, 49861, 49863, 49865, 49867, 49869, 49871, 49873, 49875, 49877, 49879, 49881, 49883, 49886, 49888, 49891, 49893, 49895, 49897, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50055, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50077, 50079, 50082, 50084, 50087, 50089, 50094, 50097, 50099, 50104, 50106, 50108, 50111, 50113, 50116, 50118, 50121, 50126, 50128, 50131, 50134, 50136, 50141, 50143, 50146, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50172, 50175, 50177, 50179, 50181, 50184, 50186, 50189, 50191, 50193, 50195, 50198, 50203, 50205, 50210, 50213, 50215, 50324, 50327, 50330, 50332, 50334, 50338, 50340, 50348, 50350, 50352, 50353, 50356, 50361, 50368, 50370, 50371, 50374, 50380, 50383, 50385, 50387, 50389, 50396, 50408, 50412, 50418, 50420, 50422, 50433, 50440, 50452, 50454, 50456, 50461, 50468, 50470, 50480, 50487, 50492, 50496, 50501, 50506, 50517, 50520, 50522, 50526, 50531, 50534, 50538, 50540, 50543, 50546, 50551, 50554, 50556, 50559, 50562, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50586, 50588, 50591, 50593, 50595, 50597, 50600, 50605, 50607, 50609, 50611, 50616, 50620, 50628, 50632, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50688, 50693, 50697, 50699, 50702, 50704, 50709, 50712, 50714, 50717, 50719, 50722, 50724, 50726, 50728, 50739, 50747, 50752, 50759, 50762, 50764, 50774, 50777, 50782, 50784, 50786, 50790, 50792, 50795, 50797, 50800, 50808, 50912, 50915, 50917, 50919, 50921, 50923, 50925, 50927, 50929, 50932, 50934, 50936, 50940, 50942, 50944, 50948, 50950, 50953, 50963, 50977, 50995, 50997, 50999, 51031, 51043, 51047, 51059, 51061, 51071, 51073, 51081, 51092, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51121, 51124, 51126, 51128, 51130, 51135, 51138, 51142, 51145, 51147, 51152, 51154, 51156, 51159, 51161, 51164, 51166, 51168, 51170, 51179, 51185, 51187, 51191, 51194, 51197, 51199, 51203, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51266, 51268, 51273, 51277, 51283, 51285, 51288, 51290, 51293, 51295, 51298, 51300, 51302, 51304, 51307, 51312, 51314, 51317, 51319, 51322, 51324, 51327, 51333, 51336, 51338, 51341, 51343, 51345, 51349, 51351, 51354, 51356, 51358, 51360, 51363, 51368, 51376, 51481, 51484, 51486, 51488, 51494, 51496, 51498, 51501, 51503, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51557, 51559, 51561, 51563, 51565, 51567, 51569, 51571, 51573, 51575, 51577, 51579, 51581, 51583, 51585, 51587, 51589, 51591, 51596, 51603, 51617, 51624, 51629, 51634, 51643, 51648, 51653, 51655, 51664, 51667, 51676, 51678, 51691, 51694, 51697, 51699, 51701, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51755, 51759, 51762, 51765, 51767, 51771, 51774, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51797, 51799, 51801, 51803, 51806, 51811, 51813, 51815, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51838, 51841, 51843, 51845, 51847, 51849, 51851, 51854, 51856, 51859, 51861, 51864, 51866, 51869, 51871, 51873, 51877, 51879, 51882, 51885, 51887, 51890, 51893, 51898, 51900, 51902, 51907, 51909, 51912, 51914, 51917, 51922, 51924, 51927, 51929, 51931, 51933, 51936, 52068, 52070, 52077, 52087, 52089, 52090, 52093, 52097, 52099, 52102, 52104, 52106, 52108, 52110, 52112, 52114, 52116, 52118, 52120, 52122, 52124, 52126, 52128, 52130, 52132, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52164, 52166, 52170, 52172, 52174, 52176, 52178, 52180, 52184, 52186, 52188, 52190, 52192, 52194, 52196, 52208, 52210, 52212, 52218, 52227, 52229, 52234, 52236, 52253, 52277, 52280, 52282, 52284, 52289, 52291, 52294, 52296, 52298, 52303, 52317, 52323, 52329, 52331, 52335, 52338, 52341, 52343, 52347, 52350, 52353, 52355, 52359, 52362, 52365, 52371, 52377, 52386, 52389, 52391, 52396, 52405, 52408, 52413, 52418, 52423, 52425, 52429, 52432, 52437, 52439, 52442, 52444, 52447, 52449, 52452, 52454, 52456, 52458, 52461, 52463, 52466, 52468, 52471, 52473, 52476, 52478, 52481, 52483, 52490, 52492, 52495, 52497, 52499, 52501, 52504, 52509, 52511, 52514, 52520, 52522, 52525, 52526, 52529, 52531, 52532, 52534, 52535, 52536, 52540, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52551, 52552, 52553, 52555, 52558, 52559, 52560, 52561, 52563, 52564, 52566, 52567, 52569, 52571, 52572, 52574, 52575, 52576, 52579, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52588, 52589, 52590, 52591, 52592, 52593, 52594, 52595, 52597, 52598, 52599, 52600, 52601, 52602, 52603, 52604, 52605, 52606, 52607, 52608, 52610, 52611, 52612, 52613, 52614, 52615) 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 Richard The Third

Cast
Role: Prince Edward Actor: Master Farley

Afterpiece Title: Harlequin Rambler

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Master Farley

Afterpiece Title: The Magic Cavern

Performances

Mainpiece Title: King Richard The Third

Cast
Role: Prince Edward Actor: Master Farley

Afterpiece Title: The Magic Cavern

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Cast
Role: Page Actor: Master Farley

Afterpiece Title: The Magic Cavern

Performances

Mainpiece Title: The Orphan

Cast
Role: Page Actor: Master Farley

Afterpiece Title: The Blacksmith of Antwerp

Performances

Mainpiece Title: The Orphan

Cast
Role: Page Actor: Master Farley

Afterpiece Title: The Magic Cavern

Performances

Mainpiece Title: The Orphan

Cast
Role: Page Actor: Master Farley

Afterpiece Title: The Critic; or, A Tragedy Rehears'd

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Land of Enchantment

Cast
Role: , the Genius Actor: Master Farley

Afterpiece Title: Barataria

Dance: In 2nd piece, by Harris, Miss Besford, Mrs Goodwin, Mrs Ratchford, Miss Matthews

Song: As17841025, but omitted: names of singers

Performances

Mainpiece Title: Alexander The Great; Or, The Rival Queens

Afterpiece Title: The Land of Enchantment

Cast
Role: , the Genius Actor: Master Farley

Afterpiece Title: Lethe

Song: Vocal Parts [in Entry] by Johnstone, Brett, Doyle, Darley; Mrs Kennedy, Mrs Martyr, Miss Stuart, Mrs Bannister; End of 1st piece Moderation and Alteration by Edwin

Performances

Mainpiece Title: The Two Connoisseurs

Dance: In afterpiece, by Byrne, Ratchford, Giorgi Jun., Miss Francis, Miss Rowson, Mrs Invill, Giorgi's Scholars, the two Miss Simonets. [The dances were included, as here assigned, in all subsequent performances.]

Performances

Mainpiece Title: The Suicide

Performances

Mainpiece Title: The Jealous Wife

Performances

Mainpiece Title: The Manager In Distress

Afterpiece Title: A Mogul Tale

Dance: End of 1st piece, as17850728

Performances

Mainpiece Title: Othello

Performances

Mainpiece Title: Rosina

Dance: As17850811

Performances

Mainpiece Title: The English Merchant

Performances

Mainpiece Title: I'll Tell You What

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Sons of Anacreon

Performances

Mainpiece Title: K

Cast
Role: Prince Edward Actor: Master Farley

Afterpiece Title: Rosin a

Performances

Mainpiece Title: K

Cast
Role: Prince Edward Actor: Master Farley

Afterpiece Title: Poor Vulcan

Performances

Mainpiece Title: The First Part Of King Henry Iv, With The Humours Of Sir John Falstaff

Cast
Role: Prince John Actor: Master Farley

Afterpiece Title: Gretna Green

Performances

Mainpiece Title: The Disbanded Officer; Or, The Baroness Of Bruchsal

Cast
Role: Boy Actor: Master Farley

Afterpiece Title: The Quaker

Performances

Mainpiece Title: The Disbanded Officer

Cast
Role: Boy Actor: Master Farley

Afterpiece Title: Gretna Green

Performances

Mainpiece Title: The Disbanded Officer

Cast
Role: Boy Actor: Master Farley

Afterpiece Title: The Guardian

Performances

Mainpiece Title: The Disbanded Officer

Cast
Role: Boy Actor: Master Farley

Afterpiece Title: Comus

Dance: As17860706