SELECT * FROM london_stages WHERE eventid IN (234, 1022, 1581, 2034, 2475, 2526, 2578, 2727, 3924, 4027, 4198, 4207, 4294, 4297, 4304, 4344, 4650, 4686, 4787, 4805, 4869, 4886, 4957, 4995, 5166, 5233, 5274, 5285, 5370, 5442, 5635, 5656, 5680, 5857, 5860, 5862, 6156, 6310, 6385, 6519, 6554, 6937, 7160, 7164, 7327, 7364, 7445, 7448, 7485, 7565, 7616, 7770, 7804, 7971, 8030, 8193, 8234, 8317, 8318, 8547, 8709, 8855, 8876, 8932, 8987, 9049, 9055, 9189, 9215, 9256, 9274, 9303, 9309, 9397, 9505, 9517, 9707, 9759, 9793, 9899, 9920, 10105, 10240, 10296, 10313, 10370, 10371, 10433, 10461, 10465, 10693, 10897, 10898, 10900, 10902, 10914, 10919, 10921, 10940, 10952, 10963, 10968, 10978, 10982, 10983, 10985, 10988, 10989, 10990, 11012, 11019, 11030, 11033, 11036, 11055, 11064, 11082, 11089, 11220, 11238, 11328, 11329, 11365, 11382, 11383, 11384, 11389, 11390, 11400, 11404, 11407, 11410, 11425, 11444, 11459, 11461, 11467, 11474, 11480, 11487, 11499, 11506, 11515, 11517, 11524, 11526, 11529, 11531, 11533, 11536, 11538, 11542, 11544, 11547, 11548, 11549, 11552, 11554, 11557, 11560, 11562, 11568, 11571, 11579, 11598, 11599, 11614, 11634, 11636, 11639, 11642, 11645, 11647, 11651, 11654, 11659, 11667, 11671, 11672, 11677, 11679, 11683, 11685, 11688, 11700, 11705, 11722, 11751, 11754, 11763, 11766, 11770, 11774, 11784, 11786, 11789, 11803, 11813, 11822, 11827, 11828, 11833, 11837, 11842, 11846, 11855, 11856, 11858, 11859, 11867, 11880, 11948, 11966, 11981, 11983, 11985, 11997, 12024, 12031, 12233, 12238, 12252, 12254, 12255, 12360, 12364, 12365, 12373, 12566, 12572, 12584, 12589, 12592, 12594, 12595, 12599, 12602, 12607, 12613, 12617, 12626, 12628, 12639, 12674, 12678, 12712, 12724, 12754, 12760, 12764, 12776, 12782, 12784, 12785, 12806, 12808, 12810, 12814, 12827, 12829, 12831, 12841, 12861, 12873, 12876, 12884, 12886, 12891, 12918, 12966, 12968, 12971, 12975, 13015, 13024, 13034, 13038, 13042, 13046, 13051, 13081, 13085, 13089, 13092, 13096, 13099, 13103, 13106, 13112, 13115, 13118, 13121, 13125, 13126, 13133, 13143, 13168, 13182, 13288, 13294, 13299, 13371, 13450, 13559, 13570, 13581, 13600, 13601, 13602, 13607, 13628, 13634, 13646, 13650, 13667, 13674, 13732, 13746, 13763, 13838, 13870, 13910, 14052, 14078, 14153, 14197, 14257, 14365, 14371, 14374, 14382, 14389, 14408, 14411, 14417, 14430, 14472, 14479, 14490, 14497, 14529, 14542, 14551, 14590, 14604, 14607, 14611, 14643, 14663, 14708, 14725, 14910, 14935, 14967, 14969, 15056, 15058, 15065, 15080, 15082, 15093, 15145, 15156, 15161, 15164, 15169, 15173, 15176, 15180, 15184, 15220, 15230, 15233, 15236, 15240, 15245, 15249, 15503, 15529, 15563, 15631, 15783, 15788, 15793, 15798, 15801, 15804, 15810, 15833, 15863, 15872, 15928, 15934, 15945, 15949, 16229, 16233, 16239, 16245, 16252, 16282, 16328, 16344, 16366, 16388, 16395, 16447, 16555, 16557, 16580, 16582, 16585, 16589, 16592, 16595, 16598, 16601, 16603, 16605, 16611, 16615, 16627, 16629, 16634, 16638, 16648, 16655, 16659, 16663, 16670, 16675, 16680, 16685, 16694, 16695, 16699, 16703, 16707, 16710, 16714, 17236, 17372, 17375, 17376, 17379, 17392, 17538, 17541, 17546, 17549, 17552, 17555, 17721, 17724, 17728, 17731, 17735, 17739, 17742, 17746, 17754, 17761, 17765, 17776, 17782, 17791, 17795, 17916, 17933, 17940, 18061, 18123, 18179, 18184, 18186, 18188, 18194, 18328, 18330, 18334, 18379, 18424, 18427, 18440, 18516, 18828, 18886, 18892, 18897, 18904, 18947, 19036, 19041, 19043, 19065, 19075, 19101, 19123, 19149, 19245, 19251, 19255, 19261, 19263, 19271, 19281, 19283, 19285, 19291, 19293, 19295, 19297, 19300, 19302, 19310, 19314, 19330, 19349, 19351, 19362, 19382, 19384, 19386, 19389, 19391, 19395, 19396, 19408, 19410, 19412, 19428, 19465, 19479, 19481, 19489, 19492, 19494, 19498, 19502, 19535, 19544, 19554, 19576, 19591, 19596, 19611, 19612, 19621, 19626, 19698, 19700, 19702, 19704, 19706, 19708, 19710, 19714, 19716, 19720, 19724, 19726, 19728, 19732, 19740, 19748, 19750, 19751, 19758, 19780, 19785, 19796, 19838, 19906, 19908, 19921, 20009, 20066, 20126, 20179, 20197, 20212, 20215, 20351, 20360, 20416, 20419, 20422, 20426, 20430, 20442, 20446, 20449, 20458, 20462, 20466, 20478, 20483, 20484, 20487, 20498, 20506, 20521, 20526, 20555, 20571, 20584, 20647, 20706, 20733, 20740, 20743, 20747, 20754, 20758, 20761, 20778, 20803, 20806, 20810, 20815, 20865, 20942, 20971, 21001, 21019, 21029, 21203, 21246, 21251, 21373, 21393, 21426, 21428, 21435, 21463, 21493, 21527, 21577, 21627, 21678, 21780, 21800, 21840, 21915, 21917, 21921, 21922, 21924, 21935, 21946, 21952, 21965, 21974, 21980, 21981, 21983, 21987, 21988, 21990, 22000, 22011, 22054, 22056, 22058, 22060, 22062, 22065, 22068, 22071, 22075, 22078, 22079, 22081, 22086, 22089, 22092, 22108, 22113, 22118, 22126, 22129, 22134, 22138, 22142, 22151, 22153, 22161, 22163, 22179, 22188, 22190, 22192, 22195, 22204, 22207, 22210, 22211, 22224, 22229, 22231, 22237, 22245, 22258, 22267, 22272, 22275, 22277, 22302, 22312, 22321, 22330, 22336, 22341, 22344, 22345, 22348, 22352, 22362, 22364, 22370, 22381, 22389, 22437, 22461, 22470, 22480, 22493, 22503, 22505, 22534, 22592, 22618, 22695, 22786, 22792, 22815, 22950, 23132, 23266, 23345, 23363, 23377, 23389, 23432, 23433, 23435, 23440, 23443, 23451, 23472, 23478, 23509, 23533, 23560, 23613, 23636, 23655, 23666, 23698, 23706, 23736, 23829, 23920, 23970, 24425, 25008, 25817, 25821, 25823, 25826, 25832, 25834, 25837, 25839, 25841, 25843, 25845, 25847, 25849, 25851, 25853, 25855, 25887, 25897, 25903, 25910, 25915, 25926, 25933, 25942, 25949, 25953, 26303, 26312, 26318, 26321, 26324, 26327, 26351, 26356, 26526, 26597, 26726, 27652, 29852, 29854, 29858, 29860, 29862, 29865, 29869, 29871, 29875, 29878, 29882, 29884, 29887, 29889, 29891, 29893, 29900, 29904, 29906, 29908, 29913, 29915, 29935, 29942, 29953, 29957, 29959, 29963, 29970, 29982, 29984, 29992, 29995, 29998, 30001, 30004, 30010, 30022, 30025, 30029, 30053, 30126, 30144, 30148, 30152, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 31148, 31231, 31422, 31846, 31922, 31980, 32006, 32089, 32159, 32196, 32255, 32303, 32371, 32406, 32491, 32529, 32620, 32665, 32714, 32833, 32887, 32948, 33023, 33098, 33125, 33167, 33301, 33351, 33396, 33447, 33573, 33639, 33665, 33686, 33799, 33913, 34034, 34079, 34179, 34185, 34223, 34314, 34316, 34331, 34401, 34403, 34407, 34413, 34427, 34429, 34432, 34436, 34441, 34450, 34455, 34469, 34480, 34483, 34488, 34497, 34502, 34562, 34572, 34648, 34728, 34744, 34752, 34757, 34768, 34771, 34776, 34790, 34807, 34810, 34818, 34902, 34954, 35504, 35509, 35512, 35517, 35519, 35633, 35721, 35889, 35905, 35906, 35927, 35935, 35937, 35953, 35958, 35971, 35987, 36135, 36393, 36422, 36430, 36446, 36491, 36519, 36562, 36568, 36593, 36595, 36601, 36609, 36920, 37078, 37318, 37325, 37327, 37330, 37339, 37348, 37355, 37358, 37379, 37381, 37396, 37412, 37785, 37809, 37815, 37819, 37821, 37825, 37827, 37829, 37833, 37835, 37852, 37856, 37870, 37874, 37887, 37893, 37902, 37905, 37930, 37941, 37943, 37949, 37962, 38045, 38050, 38123, 38153, 38158, 38167, 38172, 38183, 38291, 38292, 38293, 38300, 38735, 38794, 38897, 39007, 39018, 39021, 39027, 39037, 39084, 39089, 39096, 39108, 39200, 39202, 39206, 39211, 39217, 39220, 39223, 39226, 39231, 39235, 39243, 39251, 39263, 39266, 39281, 39289, 39304, 39307, 39316, 39379, 39381, 39384, 39386, 39403, 39409, 39428, 39440, 40324, 40330, 40398, 40406, 40408, 40431, 40444, 40446, 40448, 40708, 40877, 40962, 40965, 40970, 40980, 40983, 40989, 41114, 41116, 41122, 41125, 41129, 41130, 41131, 41137, 41145, 41208, 41224, 41233, 41250, 41264, 41269, 41474, 41503, 41520, 41523, 41529, 41532, 41552, 41557, 41559, 41564, 41568, 41569, 41570, 41727, 41729, 41739, 41741, 41891, 42039, 42041, 42065, 42097, 42133, 42165, 42166, 42248, 42369, 42825, 42827, 42830, 42831, 42837, 43848, 44244, 44247, 44249, 44253, 44286, 44319, 44605, 44618, 44648, 44708, 44712, 44819, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45305, 45310, 45314, 45316, 45319, 45324, 45328, 45335, 45352, 45378, 45384, 45397, 45448, 45518, 45546, 45578, 45603, 45655, 45656, 45657, 45658, 45660, 45664, 45677, 45697, 45721, 45741, 45790, 45830, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45873, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45931, 45951, 45964, 46004, 46031, 46033, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46072, 46073, 46080, 46093, 46100, 46103, 46108, 46121, 46132, 46133, 46142, 46148, 46166, 46169, 46174, 46281, 46286, 46288, 46294, 46295, 46313, 46315, 46333, 46351, 46354, 46395, 46476, 46503, 46543, 46552, 46564, 46565, 46600, 46637, 46661, 46681, 46721, 46723, 46725, 46728, 46734, 46843, 46948, 47005, 47022, 47040, 47050, 47088, 47444, 47678, 47867, 47909, 48004, 48603, 48616, 48747, 48749, 48754, 48755, 48757, 48759, 48760, 48761, 48762, 48766, 48767, 48768, 48769, 48770, 48771, 48772, 48774, 48775, 48776, 48777, 48779, 48781, 48782, 48783, 48784, 48785, 48786, 48787, 48788, 48789, 48790, 48791, 48792, 48793, 48796, 48797, 48798, 48801, 48803, 48804, 48805, 48808, 48810, 48812, 48813, 48815, 48816, 48817, 48818, 48819, 48821, 48826, 48827, 48828, 48830, 48831, 48835, 48845, 48850, 48851, 48852, 48856, 48857, 48859, 48864, 48865, 48866, 48870, 48877, 48880, 48883, 48891, 48902, 48903, 48916, 48919, 48923, 48928, 48930, 48931, 48945, 48948, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49033, 49038, 49041, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49116, 49117, 49119, 49120, 49122, 49193, 49199, 49206, 49214, 49594, 49612, 49620, 49629, 49635, 49640, 49650, 49655, 49657, 49662, 49664, 49667, 49854, 49920, 51349, 51354, 51358, 51505, 51506, 51511, 51513, 51514, 51517, 51519, 51521, 51522, 51525, 51527, 51529, 51531, 51532, 51535, 51537, 51541, 51543, 51545, 51557, 51561, 51565, 51569, 51573, 51577, 51581, 51587, 51591, 51613, 51639, 51650, 51657, 51683, 51694, 51710, 51722, 51728, 51750, 51762, 51789, 51909, 52081, 52102, 52194, 52204, 52400, 52497, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52551, 52552, 52553, 52555, 52558, 52559, 52560, 52561, 52564, 52566, 52567, 52569, 52571, 52572, 52574, 52575, 52576, 52579, 52581, 52582, 52583, 52584, 52585, 52586, 52587, 52594, 52595, 52597, 52600, 52601, 52602, 52605, 52610, 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: Lover's Vows

Afterpiece Title: The Intriguing Chambermaid

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Deaf Lover

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Two Strings to Your Bow

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Mayor of Garratt

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Tobacconist

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Jew and the Doctor

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Jew and the Doctor

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Jew and the Doctor

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Rosina

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Rosina

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: Robin Hood

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: Lover's Vows

Afterpiece Title: The Magic Oak

Music: As17990205

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Lover's Vows

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: Lover's Vows

Afterpiece Title: Oscar and Malvina

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

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Saturday Night at Sea; or, Tars at Anchor

Song: End II 1st piece: Admiral Benbow-Incledon; End 1st piece: The Group of Lovers-Munden

Performances

Mainpiece Title: Lover's [recte Lovers'] Vows

Afterpiece Title: The Naval Pillar

Dance: As17991007

Song: afterpiece: As17991007