SELECT * FROM london_stages WHERE eventid IN (46229, 46772, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47416, 47419, 47424, 47709, 47724, 47779, 47787, 47803, 47825, 47865, 47869, 47919, 48029, 48133, 48135, 48137, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48250, 48252, 48257, 48261, 48266, 48271, 48275, 48280, 48303, 48306, 48308, 48311, 48313, 48315, 48317, 48322, 48325, 48329, 48331, 48336, 48347, 48352, 48354, 48358, 48361, 48363, 48366, 48368, 48375, 48377, 48380, 48382, 48384, 48396, 48404, 48409, 48411, 48430, 48437, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48523, 48541, 48551, 48553, 48567, 48659, 48665, 48685, 48687, 48697, 48704, 48714, 48719, 48747, 48749, 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, 48851, 48856, 48860, 48865, 48870, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48898, 48899, 48902, 48908, 48909, 48912, 48913, 48916, 48918, 48922, 48923, 48926, 48927, 48930, 48937, 48941, 48945, 48951, 48952, 48959, 48961, 48980, 48986, 48988, 48990, 48993, 49007, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49043, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49133, 49135, 49137, 49167, 49172, 49193, 49197, 49199, 49206, 49208, 49211, 49214, 49216, 49222, 49226, 49238, 49242, 49244, 49246, 49248, 49250, 49252, 49254, 49256, 49260, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49439, 49452, 49465, 49469, 49472, 49473, 49478, 49485, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49558, 49560, 49565, 49570, 49575, 49578, 49580, 49585, 49589, 49592, 49597, 49599, 49602, 49604, 49607, 49612, 49620, 49635, 49640, 49646, 49650, 49655, 49657, 49659, 49662, 49664, 49667, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49783, 49787, 49791, 49794, 49799, 49801, 49803, 49805, 49813, 49815, 49817, 49835, 49869, 49886, 49891, 49897, 49900, 49902, 49924, 49980, 49983, 49985, 49987, 49989, 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, 50087, 50089, 50092, 50094, 50097, 50099, 50102, 50104, 50108, 50111, 50118, 50136, 50141, 50143, 50151, 50153, 50156, 50161, 50163, 50170, 50177, 50184, 50186, 50189, 50195, 50203, 50215, 50306, 50308, 50310, 50352, 50353, 50356, 50358, 50360, 50361, 50364, 50374, 50376, 50378, 50380, 50385, 50387, 50418, 50420, 50422, 50424, 50428, 50433, 50435, 50438, 50440, 50444, 50447, 50452, 50456, 50463, 50468, 50472, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50517, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50684, 50688, 50690, 50695, 50702, 50704, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50728, 50736, 50739, 50742, 50744, 50754, 50757, 50759, 50764, 50772, 50790, 50795, 50802, 50805, 50812, 50837, 50843, 50849, 50853, 50858, 50859, 50867, 50870, 50877, 50880, 50940, 50942, 50951, 50959, 50961, 50965, 50971, 50983, 50985, 50997, 51003, 51005, 51007, 51009, 51012, 51014, 51016, 51018, 51021, 51024, 51027, 51029, 51031, 51033, 51036, 51038, 51041, 51043, 51045, 51047, 51050, 51059, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51130, 51133, 51140, 51159, 51161, 51164, 51166, 51168, 51170, 51173, 51182, 51185, 51187, 51191, 51194, 51197, 51199, 51206, 51209, 51211, 51215, 51218, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51244, 51247, 51249, 51254, 51256, 51258, 51266, 51268, 51273, 51277, 51285, 51298, 51304, 51309, 51312, 51329, 51336, 51338, 51341, 51345, 51349, 51351, 51354, 51356, 51358, 51363, 51365, 51368, 51405, 51415, 51420, 51428, 51430, 51453, 51481, 51488, 51490, 51505, 51509, 51513, 51517, 51521, 51525, 51527, 51529, 51535, 51537, 51539, 51541, 51543, 51545, 51547, 51549, 51551, 51553, 51555, 51559, 51563, 51567, 51571, 51575, 51579, 51583, 51585, 51589, 51598, 51601, 51603, 51605, 51607, 51610, 51613, 51615, 51617, 51619, 51621, 51624, 51627, 51629, 51631, 51634, 51636, 51639, 51641, 51643, 51648, 51655, 51662, 51676, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 51759, 51777, 51779, 51782, 51784, 51786, 51789, 51792, 51794, 51799, 51801, 51803, 51806, 51808, 51811, 51813, 51815, 51817, 51820, 51822, 51825, 51828, 51833, 51836, 51838, 51841, 51843, 51849, 51856, 51859, 51861, 51864, 51869, 51871, 51877, 51879, 51885, 51887, 51890, 51900, 51902, 51907, 51909, 51914, 51919, 51922, 51927, 51929, 51931, 51933, 51936, 51955, 51967, 51989, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52017, 52022, 52023, 52028, 52030, 52034, 52044, 52046, 52049, 52050, 52051, 52053, 52060, 52072, 52077, 52079, 52081, 52082, 52085, 52093, 52097, 52099, 52102, 52104, 52106, 52108, 52116, 52122, 52126, 52128, 52134, 52136, 52138, 52140, 52142, 52144, 52146, 52148, 52150, 52152, 52154, 52156, 52158, 52160, 52166, 52170, 52172, 52178, 52180, 52182, 52184, 52186, 52188, 52190, 52194, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52241, 52243, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52274, 52277, 52280, 52282, 52289, 52291, 52294, 52296, 52303, 52317, 52329, 52341, 52347, 52353, 52355, 52359, 52362, 52365, 52367, 52374, 52377, 52379, 52383, 52386, 52389, 52391, 52394, 52396, 52398, 52400, 52403, 52405, 52408, 52410, 52415, 52418, 52427, 52434, 52437, 52444, 52449, 52454, 52458, 52468, 52471, 52473, 52481, 52483, 52490, 52497, 52499, 52506, 52509, 52516, 52520, 52529, 52542, 52543, 52544, 52545, 52547, 52548, 52550, 52563, 52571, 52574, 52575, 52576, 52577, 52579, 52581, 52583, 52584, 52585, 52586, 52587, 52595, 52597, 52600, 52602, 52604, 52605, 52606, 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: A Quarter Of An Hour Before Dinner

Afterpiece Title: The Mountaineers

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: The Deaf Lover

Afterpiece Title: The Mountaineers

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: All In Good Humour

Afterpiece Title: The Prisoner at Large

Performances

Mainpiece Title: Romeo And Juliet

Dance: In I: As17950921

Song: As17950921

Music: In afterpiece: the Harp-Weippert [This was played, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Midnight Wanderers

Cast
Role: Guide Actor: Linton

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Ghost

Song: In V: a Dirge- [set to Music by Shield. The Words from Shakespeare [see17931009]; Vocal Parts-Mrs Martyr, Mrs Clendining, Miss Stuart, Mrs Watts, Mrs Lloyd, Mrs Blurton, Miss Walcup, Mrs Masters, Mrs Norton, Mrs Follett, Mrs Castelle, Miss Ives, Miss Leserve, Haymes, Street, Linton

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Harry Paddington Actor: Linton

Afterpiece Title: Crotchet Lodge

Dance: In III: a Hornpipe-Byrn

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Shipwreck

Dance: In afterpiece: a Dance-Byrn, Mlle St.Amand

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Harry Paddington Actor: Linton

Afterpiece Title: Crotchet Lodge

Dance: As17951024

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: The Mysteries Of The Castle

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: Speculation

Afterpiece Title: Midas

Cast
Role: Jupiter Actor: Linton

Dance: End: The Bouquet, as17951113

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Harry Paddington Actor: Linton

Afterpiece Title: The Follies of a Day

Dance: As17951024

Performances

Mainpiece Title: Oroonoko

Performances

Mainpiece Title: The Ghost

Afterpiece Title: The Widow of Malabar

Performances

Mainpiece Title: The Days Of Yore

Afterpiece Title: Lock and Key

Afterpiece Title: The Shipwreck

Dance: As17951031

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key