SELECT * FROM london_stages WHERE eventid IN (2888, 2890, 2899, 3182, 3718, 3797, 3815, 3818, 3861, 3895, 3950, 3968, 4204, 4440, 4618, 5425, 6087, 6115, 6139, 6143, 6377, 6435, 6744, 7072, 7385, 8337, 9886, 10245, 10274, 11150, 13049, 13196, 13200, 13266, 13270, 13286, 13287, 13300, 13306, 13333, 13335, 13347, 13351, 13355, 13374, 13441, 13457, 13471, 13497, 13583, 13614, 13765, 13845, 14032, 14047, 14080, 14086, 14117, 14131, 14164, 14186, 14190, 14195, 14239, 14246, 14258, 14273, 14282, 14292, 14386, 14419, 14542, 14551, 14640, 14644, 14698, 14738, 14807, 14813, 14835, 14853, 14866, 14878, 14929, 14962, 15005, 15435, 15571, 15579, 15720, 15723, 15735, 15737, 15782, 15784, 15789, 15879, 15968, 16007, 16143, 16381, 16468, 16486, 16613, 17031, 17058, 17243, 17318, 17343, 17350, 17351, 17354, 17355, 17366, 17387, 17423, 17614, 17623, 17686, 17689, 17693, 17697, 17700, 17702, 17778, 17906, 17944, 18004, 18142, 18199, 18202, 18216, 18237, 18242, 18246, 18254, 18286, 18289, 18509, 18513, 18518, 18755, 18772, 19349, 19731, 20114, 20152, 20210, 20358, 20361, 20364, 20368, 20371, 20374, 20377, 20380, 20383, 20387, 20391, 20394, 20397, 20434, 20440, 20629, 20738, 20762, 20773, 20776, 20779, 20782, 20788, 20791, 20794, 20798, 20801, 20804, 20807, 20811, 20813, 20815, 20818, 20819, 20821, 20824, 20827, 20830, 20834, 20837, 20840, 20843, 20847, 20850, 20853, 20856, 20859, 20862, 20866, 20869, 20874, 20877, 20880, 20884, 20897, 20900, 20904, 20923, 20926, 20933, 20936, 20939, 20950, 21022, 21039, 21043, 21111, 21128, 21131, 21141, 21161, 21188, 21189, 21197, 21236, 21239, 21244, 21246, 21274, 21284, 21297, 21304, 21313, 21469, 21475, 21481, 21491, 21497, 21553, 21586, 21592, 21593, 21608, 21637, 21640, 21649, 21653, 21657, 21711, 21735, 21743, 21757, 21791, 21859, 21885, 22067, 22094, 22129, 22160, 22178, 22184, 22190, 22290, 22291, 22292, 22406, 22407, 22440, 22443, 22446, 22523, 22578, 22594, 22658, 22682, 22699, 22784, 22797, 22875, 22878, 22881, 22887, 22904, 22915, 22934, 22939, 22942, 22945, 22948, 22955, 22957, 22959, 22971, 22974, 22979, 22984, 23003, 23005, 23010, 23015, 23036, 23041, 23066, 23092, 23095, 23098, 23101, 23104, 23128, 23140, 23151, 23170, 23179, 23184, 23194, 23226, 23507, 23511, 23539, 23564, 23586, 23615, 23628, 23645, 23697, 23716, 23758, 23764, 23789, 23883, 23976, 23978, 23981, 24057, 24114, 24164, 24182, 24201, 24203, 24205, 24236, 24244, 24248, 24279, 24297, 24399, 24479, 24483, 24490, 24538, 24540, 24627, 24629, 24687, 25199, 25210, 25233, 25260, 25330, 25331, 25364, 25374, 25745, 25747, 25748, 25751, 25754, 25756, 25767, 25769, 25773, 25775, 25777, 25787, 25793, 25797, 25801, 25815, 25888, 25901, 25911, 25920, 26044, 26053, 26377, 26379, 26382, 26384, 26673, 26675, 26678, 26680, 26682, 26684, 26686, 26692, 26790, 26849, 26853, 26858, 26863, 26867, 26904, 26924, 26929, 27031, 27205, 27207, 27209, 27219, 27324, 27327, 27330, 27332, 27334, 27337, 27423, 27429, 27445, 27452, 27471, 27477, 27526, 27568, 27633, 27638, 27639, 27643, 27647, 27713, 27717, 27719, 27799, 27807, 27998, 28185, 28189, 28220, 28224, 28229, 28233, 28234, 28241, 28255, 28353, 28362, 28364, 28395, 28400, 28406, 28647, 28653, 28687, 28822, 28836, 28848, 28911, 28947, 28963, 28974, 28992, 29011, 29023, 29037, 29251, 29253, 29299, 29303, 29345, 29360, 29362, 29375, 29504, 29540, 29583, 29649, 29728, 29737, 29741, 29743, 29746, 29748, 29750, 29751, 29753, 29755, 29757, 29759, 29761, 29763, 29765, 29767, 29769, 29771, 29772, 29773, 29774, 29775, 29777, 29779, 29781, 29783, 29785, 29789, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29823, 29826, 29829, 29839, 29897, 29902, 29910, 29920, 29935, 29937, 29942, 29948, 29961, 29968, 29988, 30043, 30062, 30126, 30148, 30152, 30262, 30319, 30323, 30325, 30433, 30579, 30587, 30602, 30607, 30622, 30627, 30629, 30654, 30681, 30683, 30706, 30707, 30709, 30710, 30711, 30714, 30716, 30718, 30720, 30723, 30726, 30729, 30733, 30741, 30755, 30761, 30835, 30861, 30894, 30899, 30902, 30980, 31036, 31058, 31078, 31110, 31159, 31180, 31190, 31192, 31201, 31221, 31224, 31235, 31242, 31254, 31273, 31281, 31354, 31460, 31677, 31699, 31725, 31749, 31758, 31767, 31783, 31784, 31785, 31798, 31843, 31845, 31851, 31855, 31859, 31863, 31867, 31871, 31875, 31879, 31883, 31917, 31977, 32057, 32081, 32143, 32215, 32273, 32274, 32275, 32276, 32277, 32279, 32281, 32284, 32286, 32291, 32295, 32302, 32303, 32307, 32323, 32376, 32407, 32410, 32419, 32421, 32423, 32425, 32428, 32430, 32433, 32434, 32435, 32437, 32448, 32451, 32453, 32455, 32458, 32460, 32489, 32503, 32575, 32605, 32618, 32643, 32670, 32672, 32684, 32795, 32815, 32817, 32819, 32820, 32825, 32830, 32832, 32854, 32862, 32868, 32874, 32880, 32888, 32958, 33029, 33045, 33047, 33104, 33168, 33191, 33214, 33215, 33217, 33218, 33219, 33227, 33228, 33229, 33231, 33234, 33241, 33250, 33253, 33254, 33400, 33404, 33541, 33544, 33546, 33549, 33604, 33613, 33685, 33718, 33723, 33726, 33727, 33730, 33732, 33733, 33736, 33738, 33739, 33741, 33742, 33756, 33762, 33769, 33772, 33777, 33779, 33783, 33785, 33800, 33840, 33856, 33877, 33878, 33883, 33939, 33978, 33979, 34018, 34156, 34169, 34180, 34208, 34211, 34213, 34215, 34218, 34227, 34235, 34243, 34245, 34247, 34260, 34265, 34268, 34271, 34273, 34274, 34276, 34278, 34279, 34281, 34284, 34285, 34286, 34288, 34290, 34292, 34293, 34294, 34296, 34298, 34300, 34302, 34305, 34307, 34310, 34311, 34312, 34316, 34318, 34323, 34325, 34326, 34327, 34329, 34331, 34332, 34333, 34334, 34337, 34338, 34397, 34400, 34401, 34406, 34410, 34413, 34418, 34433, 34437, 34442, 34466, 34469, 34470, 34471, 34474, 34475, 34476, 34478, 34482, 34493, 34512, 34546, 34578, 34597, 34722, 34737, 34741, 34742, 34759, 34780, 34789, 34815, 34828, 34874, 34880, 34885, 34912, 34914, 34916, 34918, 34920, 34922, 34924, 34930, 34932, 34934, 34936, 34938, 34942, 34952, 34967, 34973, 34976, 34983, 34990, 34992, 35061, 35079, 35083, 35090, 35103, 35105, 35107, 35112, 35117, 35130, 35141, 35145, 35147, 35152, 35157, 35162, 35169, 35177, 35178, 35184, 35218, 35229, 35244, 35277, 35296, 35298, 35317, 35319, 35320, 35338, 35342, 35347, 35364, 35376, 35384, 35385, 35393, 35397, 35400, 35416, 35418, 35421, 35424, 35426, 35432, 35434, 35438, 35448, 35450, 35452, 35468, 35471, 35473, 35480, 35482, 35498, 35501, 35503, 35518, 35524, 35532, 35555, 35557, 35558, 35563, 35566, 35567, 35571, 35575, 35580, 35584, 35591, 35593, 35602, 35608, 35622, 35652, 35660, 35664, 35698, 35743, 35762, 35812, 35866, 35867, 35873, 35895, 35899, 35901, 35902, 35904, 35908, 35932, 35940, 35952, 35955, 35959, 35974, 35975, 35979, 35988, 36004, 36006, 36012, 36014, 36019, 36039, 36043, 36045, 36047, 36064, 36066, 36068, 36070, 36072, 36075, 36078, 36081, 36085, 36088, 36091, 36093, 36095, 36096, 36097, 36099, 36100, 36103, 36104, 36106, 36107, 36108, 36118, 36120, 36124, 36129, 36133, 36137, 36167, 36171, 36175, 36182, 36185, 36186, 36187, 36189, 36191, 36194, 36196, 36198, 36200, 36202, 36204, 36207, 36209, 36211, 36213, 36215, 36218, 36220, 36222, 36224, 36226, 36228, 36233, 36251, 36283, 36285, 36288, 36290, 36292, 36299, 36375, 36476, 36479, 36495, 36512, 36513, 36532, 36534, 36539, 36541, 36545, 36551, 36570, 36572, 36583, 36585, 36586, 36603, 36623, 36626, 36631, 36634, 36647, 36649, 36655, 36663, 36667, 36669, 36673, 36680, 36682, 36694, 36700, 36702, 36708, 36712, 36747, 36752, 36773, 36782, 36830, 36839, 36858, 36906, 36909, 36923, 37002, 37014, 37025, 37036, 37042, 37077, 37101, 37109, 37110, 37167, 37168, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37189, 37190, 37193, 37199, 37201, 37204, 37207, 37272, 37279, 37282, 37284, 37285, 37292, 37301, 37310, 37322, 37325, 37338, 37361, 37373, 37402, 37501, 37506, 37515, 37525, 37580, 37583, 37593, 37594, 37598, 37604, 37616, 37629, 37640, 37796, 37799, 37801, 37804, 37808, 37818, 37828, 37829, 37832, 37839, 37869, 37893, 37897, 37907, 37923, 37957, 38015, 38044, 38052, 38085, 38105, 38136, 38182, 38186, 38309, 38311, 38339, 38343, 38407, 38481, 38485, 38515, 38520, 38524, 38550, 38579, 38614, 38634, 38640, 38653, 38654, 38688, 38698, 38703, 38705, 38717, 38728, 38740, 38857, 38859, 38866, 38869, 38870, 38875, 38876, 38878, 38881, 38882, 38893, 38899, 38932, 38946, 39063, 39066, 39068, 39072, 39111, 39260, 39293, 39310, 39334, 39342, 39347, 39348, 39351, 39355, 39359, 39361, 39362, 39365, 39368, 39371, 39374, 39376, 39377, 39385, 39388, 39395, 39404, 39426, 39432, 39436, 39438, 39461, 39467, 39507, 39616, 39757, 39777, 39792, 39806, 39814, 39855, 39893, 39896, 39905, 39909, 39915, 39916, 39949, 40032, 40083, 40210, 40228, 40248, 40265, 40297, 40302, 40309, 40338, 40360, 40377, 40403, 40422, 40426, 40427, 40433, 40507, 40508, 40513, 40514, 40516, 40585, 40588, 40607, 40623, 40628, 40632, 40636, 40638, 40640, 40649, 40651, 40653, 40655, 40693, 40701, 40712, 40727, 40756, 40813, 40819, 40868, 40874, 40896, 40933, 41022, 41028, 41034, 41052, 41057, 41079, 41082, 41143, 41217, 41478, 41483, 41487, 41579, 41580, 41582, 41585, 41586, 41588, 41590, 41609, 41612, 41664, 41695, 41701, 41707, 41716, 41719, 41765, 41891, 42007, 42022, 42091, 42250, 42256, 42287, 42292, 42296, 42393, 42456, 42519, 42589, 42723, 43033, 43035, 43037, 43039, 43042, 43063, 43184, 43402, 43437, 43443, 43445, 43447, 43459, 43464, 43471, 43475, 43476, 43478, 43488, 43489, 43496, 43499, 43500, 43507, 43515, 43518, 43521, 43532, 43533, 43540, 43548, 43549, 43574, 43584, 43590, 43591, 43595, 43610, 43612, 43613, 43619, 43623, 43656, 43657, 43683, 43707, 43708, 43765, 43840, 43890, 43891, 43973, 43976, 43978, 43980, 44126, 44297, 44490, 44513, 44520, 44530, 44533, 44535, 44555, 44578, 44701, 44741, 44861, 44888, 44950, 45119, 45147, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45305, 45310, 45314, 45316, 45319, 45324, 45328, 45335, 45352, 45378, 45384, 45397, 45516, 45537, 45542, 45586, 45645, 45662, 45670, 45671, 45676, 45681, 45708, 45774, 45776, 45798, 46027, 46044, 46060, 46138, 46221, 46318, 46739, 46844, 47209, 47273, 47285, 47291, 47306, 47400, 47413, 47414, 47419, 47424, 47447, 47459, 47479, 47587, 47694, 47867, 47928, 47932, 47937, 48556, 48566, 48616, 48632, 48718, 48758, 48796, 48828, 48932, 48946, 49016, 49056, 49066, 49067, 49077, 49081, 49083, 49100, 49599, 49604, 49716, 49791, 49801, 49924, 49929, 50141, 50158, 50160, 50343, 50388, 50479, 50579, 50841, 50919, 51004, 51274, 51338, 51369, 51381, 51463, 51479, 51509, 51741, 51838, 51864, 51890, 51940, 51971, 51997, 52026, 52029, 52046, 52047, 52119, 52275, 52458, 52497, 52601, 52616) 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 Chapter Of Accidents

Afterpiece Title: Piety in Pattens

Cast
Role: Macheath Actor: A Gentleman

Performances

Mainpiece Title: Summer Amusement

Afterpiece Title: The Deserter

Cast
Role: Simkin Actor: A Gentleman

Dance: As17800615

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Cast
Role: Clodio Actor: A Young Gentleman

Afterpiece Title: Tom Thumb

Dance: End I: The Shepherd's Wedding, as17801003; End: The Villagers, as17801011

Performances

Mainpiece Title: Theodosius

Cast
Role: Varanes Actor: A Young Gentleman

Afterpiece Title: The Upholsterer

Song: Principal Vocal Parts-Davies, Mrs Morton, Miss Morris. [The music by Purcell.

Performances

Mainpiece Title: The Messiah

Music: End Part I: concerto on the organ, as17810302

Performances

Mainpiece Title: The Messiah

Music: End Part I: concerto on the hautboy, as17810307End Part II: concerto on the violin, as17810302

Song: As17810328

Performances

Mainpiece Title: George Barnwell; Or, The London Merchant

Cast
Role: Trueman Actor: A Gentleman

Afterpiece Title: The Mock Doctor; or, Dumb Lady Cured

Afterpiece Title: Linco's Travels

Entertainment: Monologue.End: Comic Paraphrase on Shakespear's Seven Ages of Man-Farrel

Performances

Mainpiece Title: The Spanish Barber; Or, The Fruitless Precaution

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Dance: afterpiece: Master Byrn, Miss Byrn. [Danced, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Author

Dance: End II: Tambourine Dance-Master Byrn, Miss Byrn

Performances

Mainpiece Title: The Spanish Friar

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Performances

Mainpiece Title: The Separate Maintenance

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Song: I: air-the Gentlewoman who sings in the Pantomime [Miss Lyon]

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Author

Dance: As17810601

Performances

Mainpiece Title: The Suicide

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Performances

Mainpiece Title: The Separate Maintenance

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Performances

Mainpiece Title: The Spanish Barber

Afterpiece Title: The Genius of Nonsense

Cast
Role: Ballad Singer Actor: A Gentlewoman

Performances

Mainpiece Title: The Confederacy

Cast
Role: Corinna Actor: A Young Gentlewoman

Afterpiece Title: The Son-in-Law

Entertainment: Imitations End II: Vocal Imitations-Bannister Sen.; End: Rhetorical Imitations-Bannister Jun

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Gentleman

Afterpiece Title: The Marriage Act

Dance: In Act I of mainpiece a Masquerade Scene incident to the Play and a Minuet by Aldridge and Miss Besford. [These were included, as here assigned, in all subsequent performances.]

Song: End of Act iv of mainpiece Juliet's Funeral Procession with the Solemn Dirge. Vocal Parts by Mattocks, Reinhold, Davies, Robson, J. Wilson, Baker, Darley, Doyle, Simpkinson; Miss Harper, Mrs Martyr, Miss Morris, Mrs Morton, Miss Stuart, Mrs Kennedy

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Gentleman

Afterpiece Title: Harlequin Free-Mason

Song: As17810924

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Gentleman

Afterpiece Title: Harlequin Free-Mason

Song: As17810924

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Gentleman

Afterpiece Title: Harlequin Free-Mason

Song: As17810924

Performances

Mainpiece Title: The Artifice

Afterpiece Title: The Ghost

Song: End of mainpiece Auld Robin Gray by Miss Lyon

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Gentleman

Afterpiece Title: Poor Vulcan

Song: As17810924, but omitted: Simpkinson, Mrs Martyr

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Beau Clincher Actor: A Gentleman

Afterpiece Title: The Irish Widow

Song: End of Act I of afterpiece Horn sweet are the Woodlands by Forrest and Groves. imitations. End of mainpiece, Vocal and Rhetorical, by the Gentleman who performs Beau Clincher

Performances

Mainpiece Title: The Distress'd Mother

Cast
Role: Orestes Actor: A Young Gentleman

Afterpiece Title: Tom Thumb