SELECT * FROM london_stages WHERE eventid IN (415, 3772, 4038, 5841, 5877, 6033, 6038, 6069, 6095, 6153, 6286, 6493, 6496, 6502, 6556, 6773, 8830, 8946, 8985, 12538, 12691, 12774, 12778, 12781, 12783, 12787, 12793, 12867, 13020, 13278, 13285, 13288, 13293, 13300, 13303, 13306, 13323, 13336, 13340, 13362, 13374, 13429, 13441, 13909, 14119, 14157, 14217, 14288, 14313, 14316, 14352, 15069, 15161, 15191, 15220, 15288, 15505, 15566, 15570, 15579, 15584, 15604, 15762, 15783, 15788, 15793, 15798, 15804, 15810, 15815, 15821, 15824, 15827, 15833, 15849, 15860, 15915, 15919, 15923, 15927, 15931, 15934, 15938, 15956, 15970, 15974, 15981, 15997, 16025, 16037, 16058, 16088, 16091, 16097, 16107, 16125, 16179, 16185, 16189, 16193, 16251, 16406, 16421, 16428, 16468, 16548, 16567, 16617, 16632, 16635, 16636, 16642, 16644, 16733, 16998, 17133, 17208, 17210, 17253, 17372, 17375, 17376, 17392, 17396, 17533, 17547, 17614, 18173, 18174, 18175, 18176, 18178, 18180, 18183, 18187, 18205, 18207, 18208, 18212, 18216, 18220, 18271, 18356, 18389, 18392, 18399, 18403, 18405, 18409, 18444, 18567, 18803, 18819, 18908, 18910, 18912, 18915, 18917, 18920, 18922, 18928, 18930, 18969, 18975, 19040, 19051, 19053, 19056, 19058, 19068, 19080, 19101, 19165, 19179, 19236, 19238, 19240, 19242, 19270, 19272, 19276, 19277, 19345, 19350, 19352, 19354, 19362, 19375, 19408, 19451, 19453, 19491, 19521, 19572, 19661, 19666, 19670, 19671, 19673, 19675, 19679, 19697, 19748, 19757, 19761, 19800, 19818, 19820, 19823, 19827, 19834, 19877, 19879, 19958, 20005, 20048, 20062, 20137, 20150, 20206, 20236, 20258, 20261, 20265, 20268, 20271, 20274, 20277, 20280, 20284, 20287, 20305, 20337, 20351, 20382, 20386, 20426, 20570, 20577, 20711, 20715, 20777, 20780, 20805, 20814, 20817, 20857, 20892, 20898, 20924, 20929, 20931, 20977, 20980, 20986, 20990, 21004, 21007, 21008, 21017, 21027, 21058, 21059, 21076, 21099, 21123, 21136, 21161, 21199, 21246, 21257, 21284, 21305, 21316, 21334, 21354, 21376, 21392, 21420, 21462, 21495, 21584, 21596, 21785, 21823, 21836, 21922, 22017, 22038, 22205, 22208, 22258, 22316, 22388, 22396, 22399, 22417, 22420, 22433, 22474, 22491, 22508, 22514, 22558, 22586, 22598, 22746, 22757, 22760, 22769, 22772, 22787, 22794, 22821, 22827, 22836, 22885, 22888, 22909, 22924, 22944, 22968, 22973, 22982, 23014, 23027, 23030, 23033, 23047, 23058, 23082, 23157, 23168, 23176, 23187, 23223, 23230, 23248, 23253, 23256, 23271, 23280, 23281, 23290, 23315, 23353, 23358, 23409, 23447, 23511, 23512, 23586, 23630, 23633, 23651, 23683, 23848, 23868, 23873, 23916, 23960, 23993, 23994, 23996, 24014, 24063, 24160, 24184, 24324, 24348, 24353, 24370, 24482, 24513, 24582, 24645, 24662, 24689, 24715, 24736, 24755, 24788, 24971, 24974, 25017, 25020, 25052, 25056, 25082, 25147, 25160, 25283, 25286, 25296, 25310, 25313, 25316, 25322, 25326, 25448, 25450, 25545, 25695, 25740, 25794, 25962, 26000, 26068, 26086, 26138, 26188, 26195, 26220, 26306, 26384, 26430, 26450, 26536, 26546, 26571, 26574, 26627, 26714, 26716, 27031, 27069, 27078, 27229, 27253, 27304, 27317, 27403, 27427, 27509, 27630, 27652, 27689, 27738, 27751, 27764, 27802, 27839, 27841, 27843, 27845, 27847, 27852, 27855, 27875, 27883, 27914, 27925, 27928, 27939, 27979, 28017, 28039, 28048, 28050, 28110, 28167, 28173, 28244, 28250, 28252, 28281, 28323, 28332, 28377, 28387, 28392, 28465, 28507, 28530, 28542, 28614, 28654, 28687, 28706, 28746, 28762, 29042, 29231, 29373, 29446, 29453, 29471, 29519, 29525, 29575, 29601, 29727, 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, 30112, 30115, 30126, 30144, 30148, 30152, 30332, 30336, 30421, 30647, 30685, 30841, 30844, 30846, 30848, 30850, 30853, 30855, 30857, 30859, 30863, 30866, 30868, 30871, 30873, 30875, 30877, 30879, 30881, 30883, 30885, 30887, 30889, 30892, 30901, 30903, 30906, 30908, 30911, 30913, 30915, 30917, 30920, 30923, 30925, 30927, 30929, 30931, 30934, 30936, 30938, 30941, 30943, 30945, 30948, 30951, 30953, 30988, 30994, 31180, 31371, 31398, 31402, 31404, 31406, 31408, 31410, 31412, 31416, 31425, 31429, 31436, 31438, 31452, 31456, 31460, 31463, 31501, 31503, 31516, 31520, 31524, 31530, 31532, 31534, 31536, 31541, 31547, 31572, 31750, 31928, 31936, 31942, 32064, 32087, 32161, 32178, 32396, 32515, 33243, 33245, 33252, 33259, 33261, 33266, 33268, 33270, 33292, 33354, 33431, 33641, 33807, 33811, 33885, 34259, 34303, 34306, 34311, 34327, 34348, 34357, 34358, 34359, 34369, 34389, 34393, 34400, 34422, 34457, 34620, 34683, 34703, 34717, 34724, 34737, 34758, 34767, 34792, 34793, 34821, 34824, 34826, 34891, 34892, 34901, 35013, 35077, 35133, 35152, 35157, 35162, 35272, 35341, 35349, 35503, 35525, 35550, 35555, 35564, 35611, 35677, 35849, 35868, 35882, 35894, 35934, 35957, 35975, 36001, 36081, 36645, 36647, 36667, 36700, 36706, 36719, 36733, 36747, 36778, 36817, 36963, 37021, 37041, 37055, 37066, 37076, 37091, 37260, 37262, 37288, 37299, 37457, 37472, 37577, 37589, 37662, 38383, 38387, 38390, 38394, 38399, 38420, 38500, 38890, 39026, 39046, 39436, 39438, 39443, 39835, 39867, 39881, 40002, 40004, 40018, 40020, 40183, 40536, 40564, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40712, 40722, 41712, 41734, 41862, 42013, 42039, 42126, 42142, 42148, 42153, 43399, 43402, 43407, 43415, 43423, 43698, 43728, 43735, 43755, 43778, 43848, 43904, 44028, 44040, 44045, 44073, 44144, 44283, 44408, 44431, 44458, 44463, 44634, 44726, 44771, 45238, 45448, 45518, 45546, 45578, 45603, 45697, 45715, 45721, 45741, 45770, 45790, 45828, 45830, 45873, 45893, 45910, 45931, 45964, 46004, 46072, 46079, 46097, 46108, 46132, 46219, 46222, 46247, 46256, 46279, 46280, 46283, 46288, 46291, 46300, 46310, 46312, 46317, 46320, 46332, 46346, 46354, 46358, 46414, 46503, 46565, 46621, 46848, 46874, 46884, 46892, 46902, 46914, 46926, 46938, 46950, 46962, 46992, 47006, 47060, 47103, 47123, 47155, 47172, 47453, 47488, 47542, 47554, 47783, 48003, 48042, 48141, 48147, 48151, 48159, 48161, 48171, 48426, 48616, 48652, 48666, 48696, 48700, 48716, 48740, 48760, 48762, 48768, 48770, 48772, 48776, 48778, 48786, 48794, 48808, 48841, 48857, 48931, 48948, 49194, 49198, 49205, 49313, 49327, 49384, 49393, 49500, 49504, 49507, 49509, 49513, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49545, 49548, 49550, 49706, 49787, 49854, 49864, 49920, 49923, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50060, 50081, 50096, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50181, 50276, 50288, 50295, 50302, 50399, 50403, 50409, 50417, 50421, 50481, 50548, 50693, 50794, 50837, 51492, 51498, 51543) 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: Almeyda Queen Of Granada

Afterpiece Title: The Smugglers

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: Almeyda

Afterpiece Title: The Smugglers

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: Almeyda

Afterpiece Title: The Smugglers

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: Almeyda

Afterpiece Title: The Smugglers

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Smugglers

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Constable Actor: Thompson

Afterpiece Title: Hartford Bridge

Dance: As17951008

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Constable Actor: Ledger

Afterpiece Title: Katharine and Petruchio

Performances

Mainpiece Title: The Provoked Wife

Cast
Role: Constable Actor: Caulfield

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Provoked Wife

Cast
Role: Constable Actor: Caulfield

Afterpiece Title: The Agreeable Surprise

Performances

Mainpiece Title: The Follies Of A Day

Cast
Role: Constable Actor: Caulfield

Afterpiece Title: The Prize

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Harlequin Captive or The Magick Fire

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: The Wheel Of Fortune

Afterpiece Title: Harlequin Captive

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: The Conspiracy

Afterpiece Title: Harlequin Captive

Cast
Role: Constable Actor: Webb

Performances

Mainpiece Title: Isabella

Afterpiece Title: Harlequin Captive

Cast
Role: Constable Actor: Webb

Song: III: Epithalamium-; Vocal Parts-Mrs Bland, Master Welsh

Performances

Mainpiece Title: The Provokd Husband

Cast
Role: Constable Actor: Phillimore

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: The Provokd Husband

Cast
Role: Constable Actor: Phillimore

Afterpiece Title: The Shipwreck

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Provokd Husband

Cast
Role: Constable Actor: Phillimore

Afterpiece Title: No Song No Supper

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: What dye Call It

Cast
Role: Constable Actor: Abbot

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Constable Actor: Phillimore

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Poor Soldier

Song: End: The Waggoner (composed by Dibdin)-Wathen

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Constable Actor: Ledger

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Provokd Husband

Cast
Role: Constable Actor: Whitmore

Afterpiece Title: The Maid of the Mill

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Constable Actor: Thompson

Afterpiece Title: Reformed in Time

Performances

Mainpiece Title: Lovers Vows

Afterpiece Title: The Intriguing Chambermaid

Cast
Role: Constable Actor: Platt

Afterpiece Title: The Mouth of the Nile