SELECT * FROM london_stages WHERE eventid IN (1024, 1899, 1945, 2104, 2306, 2641, 3553, 3793, 3808, 3839, 4033, 4058, 4126, 4233, 4307, 4326, 4587, 4628, 4956, 5177, 5251, 5253, 5254, 5260, 5275, 5282, 5309, 5356, 5463, 5519, 5644, 5702, 5746, 5747, 5789, 5985, 6009, 6114, 6580, 7101, 7259, 7395, 7396, 7397, 7399, 7419, 7425, 7476, 7478, 7496, 7546, 7649, 7948, 7966, 8083, 8087, 8187, 8208, 8228, 8239, 8349, 8374, 8381, 8417, 8511, 8517, 8560, 8624, 8696, 8740, 8743, 8823, 8861, 8947, 8949, 8979, 9044, 9118, 9122, 9140, 9172, 9175, 9210, 9228, 9258, 9282, 9289, 9315, 9378, 9402, 9416, 9512, 9542, 9631, 9721, 9733, 9746, 9795, 9895, 9951, 10103, 10231, 10241, 10301, 10351, 10403, 10418, 10487, 10607, 10801, 10817, 10885, 10901, 10938, 10997, 11006, 11096, 11188, 11241, 11278, 11287, 11379, 11387, 11434, 11716, 11720, 11743, 11835, 11978, 11995, 12104, 12163, 12183, 12231, 12329, 12357, 12439, 12518, 12609, 12657, 12664, 12711, 12739, 12854, 12872, 12972, 12976, 13012, 13109, 13114, 13242, 13349, 13353, 13372, 13426, 13446, 13509, 13629, 13745, 13906, 14079, 14088, 14158, 14184, 14348, 14441, 14478, 14564, 14567, 14571, 14574, 14577, 14580, 14584, 14587, 14591, 14597, 14601, 14605, 14608, 14611, 14632, 14636, 14722, 14731, 14786, 14811, 14831, 14866, 14902, 14904, 14912, 14923, 14950, 15032, 15084, 15120, 15124, 15169, 15173, 15186, 15303, 15380, 15453, 15465, 15573, 15583, 15596, 15623, 15770, 15812, 15814, 15816, 15836, 15874, 15883, 15884, 15891, 15899, 15906, 15910, 15964, 15973, 15997, 16004, 16008, 16010, 16012, 16016, 16021, 16049, 16054, 16058, 16061, 16070, 16097, 16101, 16107, 16114, 16118, 16129, 16135, 16159, 16394, 16425, 16443, 16581, 16629, 16678, 16712, 16730, 16831, 16844, 16850, 16875, 17006, 17023, 17067, 17095, 17202, 17207, 17233, 17247, 17325, 17411, 17413, 17418, 17422, 17430, 17457, 17460, 17463, 17466, 17468, 17490, 17501, 17517, 17540, 17557, 17566, 17599, 17607, 17738, 17772, 17814, 17900, 17932, 17969, 17997, 18025, 18065, 18176, 18231, 18243, 18255, 18276, 18296, 18316, 18440, 18479, 18483, 18485, 18703, 18757, 18771, 18864, 18915, 18970, 19037, 19174, 19189, 19232, 19269, 19279, 19280, 19348, 19371, 19407, 19459, 19483, 19492, 19494, 19496, 19504, 19544, 19582, 19598, 19601, 19603, 19606, 19649, 19662, 19691, 19705, 19769, 19808, 19818, 19821, 19832, 19872, 19897, 19899, 19903, 19971, 19981, 20036, 20080, 20090, 20093, 20138, 20142, 20144, 20145, 20217, 20237, 20260, 20269, 20285, 20286, 20299, 20313, 20487, 20590, 20625, 20645, 20691, 20759, 20865, 20879, 20902, 20942, 20962, 20984, 20993, 21021, 21048, 21066, 21169, 21178, 21195, 21198, 21230, 21268, 21296, 21362, 21377, 21425, 21431, 21464, 21470, 21537, 21576, 21623, 21697, 21742, 21772, 21855, 21871, 22006, 22213, 22231, 22250, 22321, 22471, 22489, 22553, 22561, 22612, 22635, 22670, 22684, 22757, 22820, 22831, 22862, 22971, 22979, 23029, 23032, 23035, 23037, 23040, 23067, 23068, 23118, 23120, 23169, 23283, 23300, 23368, 23372, 23396, 23453, 23459, 23462, 23480, 23537, 23590, 23611, 23640, 23655, 23673, 23721, 23748, 23778, 23851, 23860, 23865, 23920, 23995, 24087, 24229, 24480, 24550, 24565, 24634, 24702, 24716, 24766, 24895, 24899, 24903, 24930, 24964, 24984, 24985, 25021, 25093, 25260, 25287, 25367, 25378, 25434, 25473, 25477, 25495, 25549, 25589, 25690, 25811, 25908, 25978, 26092, 26151, 26171, 26224, 26333, 26336, 26356, 26440, 26445, 26460, 26467, 26502, 26564, 26581, 26617, 26670, 26673, 26710, 26738, 26783, 26822, 27059, 27190, 27235, 27284, 27298, 27395, 27435, 27622, 27627, 27693, 27727, 27778, 27787, 27953, 27959, 28065, 28091, 28165, 28169, 28183, 28185, 28189, 28228, 28246, 28254, 28290, 28330, 28344, 28395, 28490, 28622, 28659, 28663, 28727, 28788, 28790, 28810, 28813, 28820, 28839, 28850, 29034, 29055, 29160, 29200, 29226, 29239, 29318, 29399, 29435, 29594, 29745, 29749, 29756, 29760, 29845, 29878, 29883, 30141, 30413, 30676, 30843, 30867, 31035, 31208, 31642, 31733, 32013, 32015, 32018, 32033, 33174, 34354, 34366, 34405, 34443, 34460, 34474, 34514, 34546, 34679, 34708, 34742, 34796, 34930, 34992, 35099, 35160, 35261, 35280, 35310, 35331, 35854, 35894, 35916, 35940, 35963, 36262, 36314, 36449, 36482, 36537, 36565, 36806, 36902, 36974, 37011, 37068, 37599, 37656, 38151, 38233, 38614, 38731, 38894, 39009, 39250, 39293, 39296, 39298, 39301, 39303, 39306, 39308, 39312, 39315, 39317, 39320, 39322, 39324, 39326, 39329, 39331, 39335, 39339, 39343, 39346, 39349, 39478, 39482, 39484, 39489, 39495, 39504, 39516, 39522, 39530, 39534, 39536, 39544, 39548, 39553, 39562, 39569, 39576, 39586, 39597, 39623, 39627, 39634, 39639, 39646, 39666, 39697, 39702, 39711, 39716, 39723, 39731, 39740, 39745, 39754, 39764, 39772, 39781, 39786, 39802, 39823, 39826, 39830, 39840, 39859, 39886, 39907, 40033, 40037, 40052, 40064, 40076, 40088, 40100, 40108, 40127, 40141, 40155, 40180, 40194, 40209, 40223, 40237, 40249, 40262, 40275, 40288, 40301, 40330, 40359, 40373, 40381, 40388, 40402, 40405, 40432, 40447, 40453, 40455, 40466, 40565, 40586, 40595, 40616, 40650, 40705, 40716, 40751, 40776, 40806, 40832, 40851, 40870, 40872, 40875, 40893, 40927, 40950, 40961, 40964, 40977, 40986, 41139, 41144, 41153, 41183, 41186, 41228, 41256, 41272, 41298, 41326, 41358, 41375, 41401, 41414, 41457, 41473, 41484, 41514, 41542, 41575, 41698, 41699, 41708, 41726, 41746, 41769, 41792, 41811, 41860, 41925, 41966, 42016, 42017, 42025, 42067, 42068, 42090, 42136, 42154, 42286, 42295, 42309, 42319, 42323, 42358, 42366, 42416, 42449, 42451, 42471, 42503, 42543, 42641, 42648, 42676, 42701, 42718, 43053, 43061, 43171, 43274, 43423, 43425, 43427, 43430, 43433, 43467, 43499, 43544, 43552, 43560, 43567, 43598, 43646, 43655, 43667, 43685, 43742, 43769, 43778, 43828, 43846, 43855, 43867, 43897, 43904, 43912, 43919, 43945, 43956, 44011, 44013, 44028, 44130, 44137, 44156, 44195, 44278, 44381, 44406, 44495, 44588, 44599, 44614, 44651, 44732, 44763, 44833, 44889, 44906, 44954, 44977, 45160, 45187, 45235, 45243, 45277, 45294, 45346, 45364, 45371, 45453, 45499, 45576, 45594, 45596, 45672, 45760, 46896, 46910, 46934, 46958, 46970, 46978, 47048, 47062, 47092, 47100, 47155, 47172, 47242, 47448, 47457, 47463, 47768, 47783, 47871, 47893, 47899, 47992, 48044, 48067, 48106, 48177, 48235, 48383, 48431, 48609, 48932, 49259, 49271, 49295, 49391, 49403, 49426, 49440, 49767, 49786, 49804, 49956, 50081, 50207, 50341, 50390, 50439, 50465, 50507, 50535, 50577, 50610, 50651, 50683, 50684, 50733, 50736, 50742, 50744, 50746, 50757, 50776, 50791, 50795, 50799, 50802, 50833, 50835, 50842, 50854, 50856, 50857, 50858, 50861, 50872, 50877, 50914, 50923, 50941, 50951, 50991, 51147, 51211, 51215, 51244, 51247, 51249, 51254, 51256, 51258, 51261, 51266, 51285, 51288, 51298, 51312, 51330, 51336, 51341, 51345, 51351, 51356, 51360, 51395, 51399, 51405, 51411, 51413, 51424, 51431, 51441, 51446, 51451, 51453, 51468, 51649, 51663, 51686, 51709, 51810, 51858, 51922, 52100, 52293, 52444, 52449, 52455, 52458, 52477, 52505, 52586) 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 School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Maid of the Oaks

Dance: As17820307athi

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Divorce

Dance: As17820302athi

Song: End of Act III of mainpiece Tally Ho! by Mrs Wrighten

Performances

Mainpiece Title: The Double Dealer

Cast
Role: Careless Actor: Lewis

Afterpiece Title: Barnaby Brittle

Dance: As17820409

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Alchymist

Dance: As17820302athi

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Maid of the Oaks

Dance: End of mainpiece Minuet and Gavot, as17820508; End of Act I of afterpiece New Dance, as17820121, but Duprez in place of Lemercier

Performances

Mainpiece Title: The Double Dealer

Cast
Role: Careless Actor: Lewis

Afterpiece Title: Three Weeks after Marriage

Dance: End of Act III of mainpiece a New Quadrille, also The Belle of the Village, as17811101; End of Act IV The Devonshire Minuet and a New Rondeau by Holloway and Miss Besford; End of mainpiece, as17811219

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: Robinson Crusoe

Dance: As17820921

Song: In Act III of mainpiece song by Williames. [This was sung, as here assigned, at all subsequent performances, except on 10 Dec]

Performances

Mainpiece Title: The Gamesters

Cast
Role: Careless Actor: Williames

Afterpiece Title: The Capricious Lovers

Dance: End of Act I of afterpiece The Irish Fair by Blurton, Miss M. Stageldoir

Performances

Mainpiece Title: The Gamesters

Cast
Role: Careless Actor: Williames

Afterpiece Title: The Gentle Shepherd

Dance: End of Act I of afterpiece a Highland Reel by Blurton and the two Miss Stageldoirs. [This was danced, as here assigned, at all subsequent performances.]

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: Who's the Dupe

Dance: As17821005

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: Robinson Crusoe

Dance: As17820921

Performances

Mainpiece Title: The Double Gallant; Or, The Sick Lady's Cure

Cast
Role: Careless Actor: Brereton

Afterpiece Title: Too Civil by Half

Dance: End of Act IV of mainpiece The Devonshire Minuet, as17821003

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: Too Civil by Half

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: Too Civil by Half

Song: In Act III of mainpiece song [see17820926] by Barrymore

Performances

Mainpiece Title: The Gamesters

Cast
Role: Careless Actor: Williames

Afterpiece Title: The Triumph of Mirth

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Careless Actor: Brereton

Afterpiece Title: The Triumph of Mirth

Dance: As17821205

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Triumph of Mirth

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Triumph of Mirth

Performances

Mainpiece Title: The Committee; Or, The Faithful Irishman

Cast
Role: Careless Actor: Brereton

Afterpiece Title: The Triumph of Mirth

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: Bon Ton

Dance: As17830329athi

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Careless Actor: Brereton

Afterpiece Title: Comus

Dance: End of Act IV of mainpiece, as17821016; End of mainpiece, as17820917

Song: End of Act II of mainpiece A Soldier for Me (composed by Hook for The Best Bidder) by Mrs Wrighten

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Citizen

Dance: As17821122. imitations. After the dance, (for that night only) various Imitations, Vocal and Rhetorical, by Bannister Jun

Performances

Mainpiece Title: The Double Gallant

Cast
Role: Careless Actor: Brereton

Afterpiece Title: The Gentle Shepherd

Dance: End of Act iv of mainpiece The Butterfly, as17830426

Performances

Mainpiece Title: The School For Scandal

Cast
Role: Careless Actor: Farren

Afterpiece Title: The Lyar

Dance: As17830505

Song: As17830514

Performances

Mainpiece Title: The Double Gallant; Or, The Sick Lady's Cure

Cast
Role: Careless Actor: Brereton

Afterpiece Title: Harlequin Junior