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, 17917, 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, 22747, 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, 33214, 33215, 33217, 33218, 33227, 33228, 33229, 33234, 33240, 33243, 33245, 33246, 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, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44283, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44408, 44412, 44429, 44431, 44437, 44458, 44463, 44469, 44594, 44604, 44634, 44702, 44726, 44771, 45238, 45448, 45518, 45546, 45578, 45603, 45697, 45715, 45721, 45741, 45770, 45790, 45828, 45830, 45873, 45893, 45910, 45931, 45964, 46004, 46067, 46069, 46072, 46077, 46079, 46089, 46097, 46108, 46132, 46136, 46219, 46222, 46247, 46256, 46279, 46280, 46283, 46288, 46291, 46300, 46310, 46312, 46317, 46320, 46332, 46346, 46354, 46358, 46414, 46503, 46523, 46565, 46621, 46784, 46848, 46874, 46884, 46892, 46902, 46914, 46926, 46938, 46950, 46962, 46992, 47006, 47060, 47103, 47123, 47155, 47172, 47373, 47381, 47453, 47488, 47542, 47554, 47783, 48003, 48042, 48124, 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, 49701, 49704, 49706, 49719, 49733, 49745, 49780, 49787, 49788, 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, 50208, 50276, 50288, 50295, 50302, 50376, 50399, 50403, 50409, 50417, 50421, 50481, 50548, 50693, 50704, 50794, 50837, 50912, 51492, 51498, 51543, 52060) 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 Opera Of Operas

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Tempest; Or, The Enchanted Island

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Harlot's Process

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Harlequin Dr Faustus

Cast
Role: Constable Actor: Topham

Dance: La Badine by Lally Sr, Mlle Grognet, &c

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: Timon In Love

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Opera Of Operas

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Dance: Pierrot and Pierraite by Le Brun and Mrs D'Lorme

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: Or, The Force Of Love

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Committee

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Cornish Squire

Afterpiece Title: The Devil to Pay

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Cornish Squire

Afterpiece Title: The Livery Rake

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Author's Farce

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Author's Farce

Cast
Role: Constable Actor: Raftor

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Performances

Mainpiece Title: The Author's Farce

Cast
Role: Constable Actor: Raftor

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: The Cornish Squire

Afterpiece Title: The Intrigu1ng Chambermaid

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Music: With the new Overture composed for the Puppet-Shew in The Author's Farce

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Harlot's Progress

Cast
Role: Constable Actor: Jones

Dance: Hornpipe by Le Brun

Performances

Mainpiece Title: The Mother-in-law; Or, The Doctor The Disease

Cast
Role: Constable Actor: Hallam Sr

Performances

Mainpiece Title: The Mother-in-law

Cast
Role: Constable Actor: Hallam Sr

Performances

Mainpiece Title: The Mother-in-law

Cast
Role: Constable Actor: Hallam Sr

Performances

Mainpiece Title: The Mother-in-law

Cast
Role: Constable Actor: Hallam Sr