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: Love In A Village

Afterpiece Title: High Life below Stairs

Dance: In Act I of mainpiece Country Dance incident to the Piece [This was danced in all subsequent performances]; End of Act II of mainpiece, as17840916; In afterpiece a Mock Minuet by Palmer and Miss Pope [This was danced, as here assigned, in all subsequent performances]

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Who's the Dupe

Dance: As17841002

Performances

Mainpiece Title: The Beggar's Opera

Dance: As17841002

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: The Musical Lady

Song: End of Act IV of mainpiece Juliet's Funeral Procession, with the Solemn Dirge. Vocal Parts by Johnstone, Brett, Baker, Cubitt, Gaudry, Pemberton, Whitaker, Darley, Doyle; Mrs Bannister, Miss Wheeler, Mrs Martyr, Mrs Morton, Miss Stuart, Mrs Davenett, Miss Cranfield, Mrs Kennedy

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: The Poor Soldier

Song: As17841025

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: Aerostation

Song: As17841025

Performances

Mainpiece Title: A New Way To Pay Old Debts

Dance: As17841002

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: Aerostation

Song: As17841025

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: The Poor Soldier

Song: As17841025, but added: Mrs Sharpe; omitted: Baker

Performances

Mainpiece Title: The School For Wives

Cast
Role: General Savage Actor: A Gentleman
Role: Belville Actor: A Gentleman

Afterpiece Title: The Romance of an Hour

Dance: End of mainpiece a new Comic Dance, The Affrighted Dwarf, with a whimsical Transformation into Mad Moll (performers not listed)

Monologue: 1784 11 16 End of Act IV of mainpiece Bucks have at ye all by Cross

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: The Poor Soldier

Song: As17841025, but omitted: Baker

Performances

Afterpiece Title: Bon Ton

Dance: In Act I of mainpiece a Dance of Cupids [performers not listed]; In Act IV a Dance of Daemons by Hamoir, &c. [These were danced, as here assigned, in all subsequent performances.]

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: Rosina

Song: As17841108, but added: Miss Francis

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: The Positive Man

Song: As17841126

Performances

Mainpiece Title: Love In A Village

Dance: End of Act II of mainpiece, as17841203

Performances

Mainpiece Title: Romeo And Juliet

Cast
Role: Romeo Actor: A Young Gentleman

Afterpiece Title: The Magic Cavern

Song: As17841126

Performances

Mainpiece Title: Oroonoko

Cast
Role: Oroonoko Actor: A Young Gentleman

Afterpiece Title: The Magic Cavern