SELECT * FROM london_stages WHERE eventid IN (270, 367, 935, 946, 950, 975, 996, 1022, 1235, 1236, 1237, 1239, 1278, 1284, 1296, 1303, 1318, 1337, 2034, 2538, 4445, 4711, 4745, 4748, 4820, 4823, 4836, 4839, 4853, 4869, 4913, 4927, 4939, 4973, 5132, 5134, 5141, 5145, 5150, 5154, 5161, 7072, 7098, 7335, 7494, 9219, 9264, 9329, 9555, 10012, 11716, 11798, 11827, 11833, 11835, 11837, 11842, 11846, 11856, 11858, 11943, 11978, 11997, 12093, 12104, 12152, 12164, 12231, 12233, 12238, 12252, 12255, 12300, 12329, 12331, 12353, 12362, 12365, 12383, 12393, 12397, 12399, 12401, 12402, 12405, 12408, 12411, 12413, 12416, 12418, 12419, 12421, 12424, 12426, 12429, 12430, 12432, 12433, 12435, 12436, 12439, 12441, 12446, 12448, 12449, 12451, 12453, 12455, 12457, 12459, 12464, 12466, 12468, 12470, 12473, 12494, 12495, 12505, 12543, 12550, 12564, 12566, 12572, 12629, 12657, 12678, 12691, 12708, 12724, 12729, 12732, 12739, 12744, 12754, 12764, 12774, 12778, 12781, 12783, 12787, 12793, 12802, 12805, 12807, 12811, 12813, 12820, 12825, 12829, 12844, 12849, 12864, 12872, 12891, 12898, 12899, 12934, 12972, 12976, 12978, 12984, 12986, 13000, 13012, 13014, 13020, 13029, 13050, 13061, 13068, 13076, 13077, 13079, 13083, 13091, 13101, 13105, 13109, 13123, 13178, 13179, 13185, 13189, 13198, 13214, 13228, 13242, 13275, 13281, 13286, 13289, 13292, 13296, 13298, 13306, 13313, 13315, 13318, 13322, 13324, 13335, 13337, 13343, 13345, 13351, 13353, 13355, 13358, 13360, 13377, 13406, 13426, 13431, 13455, 13460, 13466, 13468, 13471, 13476, 13495, 13498, 13507, 13529, 13550, 13561, 13566, 13568, 13574, 13577, 13584, 13597, 13600, 13607, 13628, 13631, 13696, 13740, 13750, 13754, 13762, 13769, 13773, 13777, 13781, 13785, 13789, 13804, 13808, 13811, 13815, 13818, 13822, 13826, 13830, 13833, 13837, 13841, 13845, 13851, 13855, 13859, 13863, 13869, 13873, 13877, 13880, 13884, 13888, 13893, 13897, 13901, 13905, 13909, 13927, 13934, 13938, 13941, 13944, 13948, 13952, 13957, 13960, 13964, 13966, 13969, 13977, 13980, 13986, 13989, 13997, 14001, 14004, 14043, 14051, 14057, 14063, 14079, 14105, 14108, 14119, 14123, 14135, 14140, 14161, 14181, 14187, 14192, 14206, 14225, 14229, 14231, 14252, 14267, 14274, 14290, 14294, 14300, 14301, 14303, 14313, 14316, 14341, 14352, 14364, 14373, 14384, 14392, 14395, 14398, 14401, 14404, 14407, 14432, 14443, 14452, 14459, 14466, 14469, 14492, 14496, 14499, 14544, 14550, 14556, 14674, 14750, 14785, 14791, 14796, 14800, 14817, 14826, 14835, 14855, 14864, 14866, 14878, 14887, 14892, 14906, 14910, 14919, 14935, 15001, 15005, 15011, 15058, 15114, 15135, 15152, 15156, 15184, 15208, 15210, 15216, 15220, 15240, 15245, 15259, 15280, 15284, 15288, 15291, 15300, 15303, 15307, 15325, 15339, 15348, 15361, 15383, 15495, 15505, 15517, 15518, 15563, 15566, 15570, 15584, 15599, 15604, 15607, 15631, 15704, 15705, 15770, 15777, 15783, 15785, 15788, 15790, 15793, 15795, 15798, 15804, 15810, 15812, 15815, 15820, 15821, 15824, 15827, 15833, 15836, 15843, 15849, 15854, 15860, 15863, 15870, 15871, 15874, 15876, 15880, 15883, 15884, 15891, 15899, 15905, 15906, 15909, 15910, 15915, 15919, 15923, 15927, 15931, 15934, 15937, 15938, 15945, 15948, 15949, 15952, 15956, 15959, 15964, 15969, 15970, 15973, 15974, 15981, 15997, 16004, 16007, 16008, 16012, 16016, 16021, 16025, 16032, 16037, 16040, 16048, 16049, 16054, 16057, 16058, 16061, 16070, 16088, 16091, 16094, 16097, 16101, 16104, 16107, 16110, 16113, 16114, 16118, 16121, 16125, 16129, 16135, 16147, 16151, 16156, 16159, 16160, 16164, 16167, 16168, 16172, 16176, 16186, 16190, 16194, 16200, 16204, 16210, 16214, 16218, 16221, 16222, 16228, 16232, 16238, 16244, 16251, 16311, 16322, 16327, 16369, 16374, 16378, 16394, 16406, 16421, 16428, 16436, 16461, 16468, 16487, 16492, 16499, 16500, 16503, 16510, 16514, 16515, 16517, 16522, 16525, 16527, 16529, 16531, 16534, 16537, 16539, 16540, 16541, 16544, 16547, 16565, 16573, 16578, 16581, 16586, 16587, 16591, 16599, 16602, 16608, 16609, 16616, 16636, 16642, 16665, 16678, 16712, 16720, 16733, 16768, 16799, 16804, 16812, 16815, 16844, 16849, 16861, 16865, 16881, 16913, 16921, 16929, 16932, 16936, 16940, 16959, 16964, 17041, 17133, 17243, 17264, 17349, 17371, 17372, 17375, 17376, 17392, 17417, 18106, 18628, 18685, 18905, 18906, 18910, 18912, 18932, 19050, 19052, 19055, 19057, 19282, 19284, 19286, 19287, 19289, 19290, 19292, 19294, 19297, 19299, 19303, 19305, 19307, 19309, 19311, 19313, 19315, 19318, 19320, 19322, 19324, 19326, 19328, 19332, 19336, 19340, 19342, 19344, 19356, 19358, 19364, 19368, 19374, 19376, 19377, 19379, 19383, 19467, 19469, 19471, 19473, 19475, 19478, 19543, 19545, 19547, 19549, 19556, 19568, 19585, 19620, 19644, 19697, 19719, 19721, 19741, 19751, 19757, 19759, 19800, 19803, 19808, 19818, 19820, 19827, 19830, 19834, 19836, 19840, 19842, 19878, 19906, 19908, 19921, 19941, 19951, 19954, 19960, 19993, 20009, 20020, 20055, 20069, 20076, 20079, 20097, 20137, 20141, 20149, 20166, 20169, 20172, 20175, 20178, 20184, 20187, 20208, 20211, 20220, 20239, 20242, 20248, 20264, 20276, 20279, 20329, 20343, 20375, 20381, 20398, 20405, 20409, 20412, 20415, 20418, 20421, 20453, 20624, 20630, 20679, 20681, 20684, 20711, 20720, 20725, 20745, 20780, 20786, 20805, 20809, 20812, 20814, 20817, 20822, 20825, 20832, 20835, 20838, 20841, 20848, 20852, 20860, 20864, 20867, 20872, 20875, 20890, 20895, 20898, 20911, 20924, 20937, 20944, 20948, 20951, 20955, 20967, 20970, 20997, 21030, 21041, 21056, 21059, 21076, 21096, 21099, 21109, 21112, 21116, 21119, 21126, 21129, 21132, 21136, 21146, 21150, 21153, 21157, 21165, 21168, 21172, 21184, 21217, 21226, 21230, 21240, 21242, 21246, 21250, 21260, 21262, 21266, 21270, 21278, 21284, 21308, 21310, 21326, 21337, 21338, 21339, 21341, 21342, 21345, 21347, 21354, 21359, 21360, 21366, 21368, 21370, 21372, 21376, 21378, 21382, 21384, 21386, 21388, 21390, 21392, 21398, 21403, 21405, 21407, 21418, 21420, 21427, 21432, 21436, 21442, 21448, 21451, 21454, 21457, 21460, 21462, 21465, 21484, 21495, 21506, 21509, 21517, 21526, 21531, 21534, 21540, 21544, 21551, 21559, 21564, 21573, 21578, 21581, 21584, 21593, 21605, 21611, 21614, 21626, 21635, 21670, 21677, 21680, 21693, 21719, 21740, 21750, 21754, 21767, 21771, 21776, 21781, 21785, 21799, 21805, 21809, 21816, 21821, 21823, 21824, 21832, 21834, 21838, 21950, 21962, 21966, 21969, 21974, 21978, 21980, 21986, 21997, 22015, 22017, 22038, 22048, 22075, 22089, 22095, 22121, 22129, 22132, 22138, 22153, 22159, 22166, 22179, 22182, 22185, 22188, 22198, 22202, 22204, 22210, 22213, 22237, 22240, 22243, 22245, 22253, 22258, 22269, 22275, 22277, 22300, 22321, 22324, 22333, 22344, 22348, 22366, 22369, 22372, 22383, 22385, 22396, 22399, 22405, 22411, 22417, 22420, 22423, 22433, 22439, 22442, 22461, 22467, 22477, 22480, 22483, 22489, 22505, 22508, 22517, 22524, 22531, 22534, 22537, 22542, 22545, 22552, 22561, 22567, 22577, 22580, 22586, 22591, 22598, 22616, 22620, 22631, 22635, 22638, 22643, 22646, 22649, 22653, 22656, 22659, 22664, 22669, 22672, 22678, 22683, 22687, 22757, 22763, 22772, 22786, 22792, 22797, 22800, 22821, 22826, 22849, 22858, 22890, 22893, 22905, 22907, 22910, 22916, 22919, 22923, 22935, 22938, 22944, 22947, 22956, 22958, 22961, 22967, 22970, 22981, 22984, 22986, 22994, 22997, 23000, 23002, 23007, 23011, 23017, 23022, 23026, 23044, 23046, 23049, 23052, 23055, 23062, 23065, 23070, 23082, 23090, 23100, 23103, 23106, 23110, 23113, 23121, 23124, 23127, 23136, 23139, 23142, 23147, 23150, 23156, 23175, 23181, 23186, 23195, 23209, 23214, 23216, 23264, 23271, 23285, 28490, 29505, 29512, 29551, 36789, 38881, 39921, 39926, 39931, 39936, 39938, 39949, 40427, 40565, 40571, 40588, 40639, 40727, 41436, 41462, 41469, 41481, 41988, 43099, 43532, 43540, 43548, 43574, 43619, 43642, 43840, 43882, 43990, 43996, 44187, 44321, 44476, 44478, 44480, 44481, 44483, 44486, 44489, 44503, 44504, 44517, 44526, 44527, 44528, 44529, 44532, 44544, 44546, 44548, 44552, 44556, 44557, 44560, 44561, 44563, 44566, 44569, 44570, 44576, 44580, 44581, 44583, 44586, 44701, 45054, 45821, 45823, 45914, 45916, 45925, 45930, 45971, 45984, 46007, 46033, 46042, 46050, 46073, 46075, 46169, 46271, 46273, 46281, 46284, 46286, 46289, 46292, 46294, 46295, 46299, 46309, 46311, 46313, 46315, 46323, 46333, 46336, 46347, 46351, 46357, 46361, 46369, 46373, 46377, 46383, 46389, 46393, 46395, 46397, 46401, 46403, 46431, 46476, 46506, 46524, 46543, 46552, 46564, 46580, 46585, 46590, 46600, 46607, 46609, 46612, 46614, 46622, 46634, 46637, 46639, 46657, 46676, 46681, 46688, 46695, 46697, 46708, 46716, 46718, 46721, 46723, 46725, 46728, 46732, 46734, 46844, 46846, 46847, 46849, 46852, 46854, 46855, 46861, 46895, 46909, 46941, 46953, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47005, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47063, 47081, 47088, 47198, 47202, 47212, 47218, 47224, 47235, 47244, 47247, 47253, 47266, 47277, 47283, 47289, 47309, 47326, 47464, 47470, 47472, 47482, 47495, 47507, 47519, 47580, 47779, 47787, 47825, 48712, 48732, 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, 48851, 48856, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 50475, 50477, 50480, 50482, 50484, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50697, 50699, 50704, 50709, 50712, 50717, 50722, 50726, 50747, 50784, 50800, 50940, 50959, 50965, 50971, 51050, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51268, 51285, 51298, 51304, 51338, 51356, 51481, 51488, 51509, 51513, 51517, 51521, 51525, 51527, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51603, 51617, 51624, 51629, 51634, 51643, 51648, 51655, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51753, 51755, 51762, 51765, 51767, 51771, 51797, 51817, 51820, 51825, 51828, 51831, 51833, 51836, 51838, 51841, 51843, 51845, 51871, 51890, 51907, 51909, 51914, 52077, 52093, 52097, 52099, 52102, 52104, 52106, 52108, 52116, 52122, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52277, 52294, 52296, 52303, 52317, 52329, 52331, 52335, 52338, 52341, 52343, 52347, 52350, 52353, 52359, 52365, 52367, 52374, 52377, 52379, 52383, 52389, 52394, 52398, 52403, 52413, 52418, 52425, 52429, 52432, 52439, 52442, 52447, 52452, 52454, 52456, 52461, 52466, 52473, 52476, 52481, 52483, 52490, 52499, 52504, 52511) 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: Lover's Vows

Afterpiece Title: The Magic Oak; or, Harlequin Woodcutter

Music: End I afterpiece: A Medley Overture on the Union Pipes and Pedal Harp-Murphy, Weippert

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Music: Afterpiece: The Overture-; accompanied on the Union Pipes-Murphy; accompanied on the Pedal Harp-Weippert

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: The Magic Oak

Music: As17990131

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Guardian

Afterpiece Title: The Magic Oak

Music: In 3rd piece: As17990131

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Music: Afterpiece: The overture Accompanied on the Pedal Harp-Weippert

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak

Music: As17990205

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Music: As17990205

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: The Magic Oak

Music: As17990205

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Music: As17990205

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Ramah Droog

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Ramah Droog

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Ramah Droog

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Song: In afterpiece: Come every jovial fellow-Mrs Chapman, Gray, Mrs Atkins; O ever in my bosom live-Mrs Chapman, Mrs Atkins

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: Oscar and Malvina

Song: As17990302Come every jovial fellow-Miss Mitchell, Gray, Miss Wheatley

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: British Fortitude

Afterpiece Title: Oscar and Malvina

Dance: II: Negro Dance-Blurton, Platt, Jackson

Song: In 3rd piece: As17990304but O ever in my bosom live-Mrs Chapman, Mrs Iliff

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Oscar and Malvina

Song: As17990304but O ever in my bosom live-Mrs Chapman, Mrs Iliff

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: Oscar and Malvina

Song: As17990309