SELECT * FROM london_stages WHERE eventid IN (18570, 18950, 18954, 18956, 18959, 18961, 18963, 18965, 18968, 18970, 18973, 19024, 19027, 19031, 19045, 23402, 23429, 23461, 23784, 23903, 23905, 23906, 23907, 23908, 23909, 23927, 23947, 23950, 23971, 23973, 23988, 23990, 24001, 24055, 24159, 24161, 24181, 24235, 24326, 24351, 24355, 24403, 24406, 24407, 24409, 24410, 24411, 24414, 24428, 24430, 24468, 24500, 24527, 24552, 24568, 24570, 24584, 24630, 24635, 24654, 24680, 24688, 24712, 24750, 24761, 24794, 24802, 24805, 24873, 24875, 24885, 24912, 24915, 24917, 24935, 24942, 24956, 24990, 24993, 24994, 25044, 25077, 25104, 25120, 25126, 25144, 25157, 25158, 25188, 25224, 25263, 25270, 25288, 25295, 25319, 25368, 25372, 25407, 25413, 25437, 25439, 25490, 25524, 25548, 25550, 25645, 25647, 25655, 25665, 25671, 25700, 25702, 25721, 25745, 25747, 25748, 25751, 25754, 25756, 25761, 25764, 25767, 25769, 25773, 25787, 25793, 25797, 25800, 25801, 25815, 25822, 25841, 25844, 25858, 25900, 25921, 25938, 25950, 25952, 25975, 25984, 26049, 26055, 26091, 26104, 26154, 26158, 26167, 26181, 26183, 26203, 26210, 26211, 26214, 26246, 26253, 26257, 26272, 26290, 26295, 26298, 26342, 26348, 26387, 26401, 26427, 26514, 26537, 26552, 26585, 26600, 26601, 26631, 26639, 26642, 26644, 26663, 26683, 26696, 26732, 26744, 26752, 26790, 26819, 26831, 26852, 26898, 26907, 26916, 26937, 26960, 26988, 26989, 27008, 27032, 27058, 27081, 27098, 27100, 27111, 27145, 27196, 27198, 27206, 27247, 27254, 27259, 27264, 27269, 27271, 27278, 27283, 27290, 27297, 27303, 27312, 27318, 27342, 27365, 27372, 27383, 27398, 27406, 27546, 27548, 27584, 27586, 27594, 27596, 27601, 27606, 27612, 27614, 27621, 27665, 27666, 27698, 27716, 27741, 27757, 27765, 27791, 27793, 27798, 27810, 27824, 27836, 27861, 27902, 27922, 27930, 27938, 28009, 28035, 28042, 28043, 28054, 28078, 28112, 28133, 28135, 28166, 28194, 28208, 28237, 28239, 28247, 28275, 28294, 28304, 28348, 28363, 28378, 28434, 28444, 28476, 28480, 28481, 28501, 28509, 28526, 28539, 28547, 28567, 28603, 28607, 28613, 28652, 28685, 28689, 28690, 28699, 28722, 28786, 28787, 28795, 28844, 28887, 28960, 28971, 28976, 28993, 29052, 29085, 29156, 29161, 29188, 29191, 29207, 29308, 29368, 29370, 29380, 29389, 29419, 29458, 29461, 29470, 29508, 29542, 29581, 29598, 29736, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29764, 29765, 29767, 29769, 29771, 29773, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29815, 29816, 29818, 29820, 29829, 29839, 29861, 29897, 29902, 29905, 29910, 29920, 29937, 29948, 29961, 29968, 29988, 30021, 30043, 30062, 30081, 30126, 30148, 30149, 30152, 30160, 30286, 30288, 30291, 30295, 30299, 30315, 30374, 30420, 30561, 30593, 30670, 30699, 30783, 30809, 30819, 30839, 30875, 30914, 31019, 31048, 31050, 31053, 31058, 31060, 31064, 31075, 31083, 31088, 31090, 31098, 31103, 31110, 31113, 31117, 31124, 31127, 31133, 31188, 31189, 31198, 31215, 31252, 31349, 31385, 31388, 31392, 31394, 31400, 31404, 31414, 31420, 31431, 31446, 31458, 31532, 31559, 31590, 31646, 31685, 31695, 31729, 31790, 31791, 31792, 31793, 31794, 31795, 31796, 31797, 31798, 31799, 31800, 31801, 31802, 31803, 31804, 31805, 31806, 31807, 31808, 31809, 31810, 31811, 31812, 31813, 31814, 31815, 31816, 31817, 31818, 31819, 31820, 31821, 31823, 31920, 31933, 31954, 31990, 32153, 32158, 32201, 32347, 32375, 32636, 32679, 32696, 32742, 32845, 32879, 33104, 33120, 33178, 33421, 33440, 33495, 33539, 33598, 33623, 33631, 33653, 33658, 33674, 33691, 33834, 33838, 33860, 34013, 34068, 34215, 34250, 34303, 34306, 34311, 34327, 34370, 34552, 34553, 34559, 34566, 34569, 34571, 34585, 34589, 34597, 34611, 34636, 34720, 34763, 34773, 34777, 34790, 36470, 36532, 36828, 37017, 37108, 37763, 37796, 37804, 37822, 37832, 37834, 37848, 37850, 37865, 37869, 37871, 37873, 37876, 37879, 37883, 37888, 37892, 37901, 37903, 37908, 37912, 37915, 37917, 37926, 37929, 37931, 37942, 37944, 37946, 37948, 37950, 37952, 37955, 37957, 37959, 37961, 37963, 37965, 37968, 37970, 37972, 37974, 37976, 37978, 37981, 37986, 37988, 37990, 37997, 37999, 38004, 38012, 38022, 38031, 38038, 38048, 38051, 38057, 38061, 38066, 38068, 38092, 38098, 38106, 38124, 38129, 38144, 38152, 38154, 38159, 38161, 38178, 38191, 38208, 38214, 38299, 38310, 38319, 38365, 38388, 38395, 38406, 38482, 38515, 38520, 38524, 38550, 38579, 38640, 38669, 38732, 38735, 38762, 38771, 38790, 40578, 40580, 40582, 40587, 40589, 40590, 40613, 40615, 40617, 40624, 40634, 40700, 40873, 40886, 40889, 40910, 40962, 40965, 40970, 40980, 40983, 40989, 41520, 41552, 41557, 41559, 41696, 41708, 41712, 41734, 41851, 41853, 41856, 41858, 41861, 41862, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 42013, 42017, 42039, 42124, 42126, 42129, 42132, 42144, 42148, 42153, 42239, 42241, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42254, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42302, 42306, 42312, 42318, 42324, 42330, 42338, 42354, 42357, 42589, 42602, 42671, 42677, 42697, 42733, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42817, 42818, 42829, 42839, 42841, 42843, 42923, 42925, 42929, 42931, 42933, 42937, 42943, 42951, 42957, 42962, 42967, 42969, 42976, 42983, 42990, 43000, 43009, 43011, 43021, 43079, 43081, 43084, 43093, 43098, 43104, 43108, 43113, 43115, 43122, 43127, 43130, 43143, 43198, 43227, 43229, 43232, 43263, 43270, 43321, 43439, 43446, 43453, 43460, 43494, 43622, 43632, 43635, 43637, 43640, 43646, 43650, 43655, 43662, 43663, 43664, 43667, 43706, 43717, 43853, 43854, 43877, 43941, 43952, 43955, 43958, 43963, 43970, 43975, 43977, 43979, 43981, 43984, 43985, 43986, 43988, 43991, 43992, 44006, 44007, 44009, 44010, 44011, 44012, 44013, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44034, 44035, 44039, 44041, 44046, 44047, 44055, 44062, 44084, 44085, 44088, 44096, 44102, 44119, 44166, 44169, 44171, 44537, 44540, 44950, 49031, 49051, 49069, 49072, 49095, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49432, 49439, 49452, 49465, 49520, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49556, 49560, 49570, 49575, 49578, 49580, 49589, 49592, 49602, 49607, 49612, 49635, 49640, 49650, 49655, 49662, 49667, 49783, 49794, 49805, 49815, 49886, 49891, 49897, 50108, 50118, 50170, 50203, 51383, 51521, 51525, 51527, 51962, 52514) 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 Careless Husband

Performances

Mainpiece Title: The Capricious Lady

Afterpiece Title: The Maid of the Oaks

Dance: End of mainpiece, as17830917; In Act I of afterpiece Dance by Harris, Miss Matthews, Miss Besford

Performances

Mainpiece Title: The Capricious Lady

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: The Castle Of Andalusia

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: All For Love

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: The Careless Husband

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: Robin Hood; Or, Sherwood Forest

Dance: End of mainpiece a New Dance by Le Bccuf and Mlle Constance (from the King's Theatre in Paris; 1st appearance)

Performances

Mainpiece Title: Robin Hood

Dance: As17840417

Performances

Mainpiece Title: Robin Hood

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: Robin Hood

Song: As17840514

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Rambler; or, The Convent in an Uproar

Performances

Mainpiece Title: Othello

Afterpiece Title: Harlequin Rambler

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Harlequin Rambler

Song: Mainpiece: Vocal Parts by Johnstone, Brett, Gaudry, Doyle, Lloyd; Mrs Kennedy, Miss Wheeler, Mrs Martyr, Mrs Morton, Mrs Chalmers, Mrs Davenett, Miss Stuart, Mrs Bannister

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Harlequin Rambler

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Harlequin Rambler

Song: In mainpiece To thee, O gentle sleep! by Brett

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Maid of the Oaks

Dance: In Act I of afterpiece a Dance by Harris, Miss Matthews, Miss Besford

Performances

Mainpiece Title: The Chances

Dance: In afterpiece, by Mr and Miss Hamoir, Mills, Miss Stageldoir. [The dances were included, as here assigned, in all subsequent performances.]

Performances

Mainpiece Title: The Beggar's Opera

Dance: As17841002