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: The Rivals

Afterpiece Title: Two Strings to Your Bow

Cast
Role: Drunken Porter Actor: Farley

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Song: As17921029

Performances

Mainpiece Title: Just In Time

Cast
Role: Le Frizz Actor: Farley

Afterpiece Title: Lovers' Quarrels

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Performances

Mainpiece Title: Just In Time

Cast
Role: Le Frizz Actor: Farley

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Welsh Collier Actor: Farley

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Welsh Collier Actor: Farley

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: In afterpiece: a new ballet The Lucky Escape-Byrn, Holland, Mrs Watts, Mme Rossi

Performances

Mainpiece Title: Just In Time

Cast
Role: Le Frizz Actor: Farley

Afterpiece Title: The Prisoner at Large

Cast
Role: Frill Actor: Farley

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Performances

Mainpiece Title: Just In Time

Cast
Role: Le Frizz Actor: Farley

Afterpiece Title: Oscar and Malvina

Music: As17921025

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Song: II: song-Miss Broadhurst

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Performances

Mainpiece Title: Just In Time

Cast
Role: Le Frizz Actor: Farley

Afterpiece Title: The Prisoner at Large

Cast
Role: Frill Actor: Farley

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Oscar and Malvina

Song: the Solemn Dirge, as17921022, but Mrs _Arnold

Music: As17921025

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116

Performances

Mainpiece Title: Columbus; Or, A World Discovered

Cast
Role: Captain Actor: Farley

Afterpiece Title: Love in a Camp

Performances

Mainpiece Title: Columbus

Cast
Role: Captain Actor: Farley

Afterpiece Title: The Highland Reel

Performances

Mainpiece Title: Columbus

Cast
Role: Captain Actor: Farley

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17921025

Performances

Mainpiece Title: Columbus

Cast
Role: Captain Actor: Farley

Afterpiece Title: Hartford Bridge

Cast
Role: Waiter Actor: Farley

Dance: As17921116