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: Jane Shore

Cast
Role: Hastings Actor: Young Gentleman

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Miss in Her Teens

Song: Brett

Dance: As17461124, but Louvre and Minuet-the Gentleman, Mrs Miles

Entertainment: End Farce: Fireworks-

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Happy; or, The Frenchman Bit

Cast
Role: Harlequin Actor: a Gentleman.

Performances

Mainpiece Title: Venice Preserved; Or, A Plot Discovered

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Lottery

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Lottery

Performances

Mainpiece Title: The Suspicious Husband

Cast
Role: Parts Actor: Gentlemen, Ladies

Afterpiece Title: Miss in Her Teens

Dance: To conclude with: Country Dance called The Whim-

Performances

Mainpiece Title: The Orphan

Cast
Role: Castalio Actor: Gentlewoman

Afterpiece Title: The Lying Valet

Song: Between the Acts: a Gentleman

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: The Fair Quaker Of Deal; Or, The Humours Of The Navy

Afterpiece Title: Pyramus and Thisbe

Cast
Role: Lion Actor: a Gentleman

Song: I: Duet-Mrs Lampe, Miss Young; IV: Myself I Shall adore by Handel-Mrs Lampe

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Perplex'd Husband

Song: I: Beard; III: Consider Fond Shepherd, Tis Liberty alone-Mrs Storer

Dance: II: Drunken Peasant-Philips; IV: The Amorous Swain, or Rival Nymphs-LaLauze, Mrs Delagarde, Miss Hillyard; V: a Ball Minuet (By Desire)-three scholars of LaLauze

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Love In a Mist

Song: LLove a favourite song from Acis and Galatea-; Between the Acts: Songs-a Gentleman

Music: Solo on a German Flute-a Gentleman

Performances

Mainpiece Title: The Pilgrim

Afterpiece Title: Miss in Her Teens

Song: I: Go Rose-Miss Faulkner; II: Ellen a Roon-Mrs Storer; III: Se Spuntan Vezzoze-Miss Faulkner; V: Come Ever Smiling Liberty, 'Tis Liberty alone-Miss Faulkner

Dance: V: Minuet-Villeneuve, Miss E. Faulkner

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: Wit Without Money

Afterpiece Title: Miss in Her Teens

Dance: Master Granier, Miss Granier

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Miss in Her Teens

Performances

Afterpiece Title: The Spanish Fryar, Comic Scenes

Song: Corbet; V: The Power of Gold- a song from the Fool in the Gazetteer, set by a Gentleman, and never performed before

Performances

Song: IV: A Cantata-Doorsming, who never appeared in public

Dance: V: Drunken Peasant-Matthews

Performances

Mainpiece Title: Venice Preserved; Or, A Plot Discovered

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The King and Miller of Mansfield

Performances

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

Afterpiece Title: Flora

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Love in a Mist

Song: I: Go Rose-Mr Scott; II: 'Tis Liberty-; III: Early Morn-; IV: Dialogueby Stevens-

Dance: V: Hornpipe-Matthews

Performances

Mainpiece Title: The Funeral; Or, Grief A-la-mode

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Funeral

Afterpiece Title: Lethe

Performances

Mainpiece Title: The Suspicious Husband

Cast
Role: Husband Actor: a young Gentleman

Afterpiece Title: Miss in Her Teens

Dance: A Country Dance-