SELECT * FROM london_stages WHERE eventid IN (1457, 1479, 1879, 1882, 1981, 2114, 2555, 2986, 3527, 3531, 3542, 3544, 3579, 3641, 3763, 3855, 3881, 4001, 4097, 4211, 4214, 4283, 4287, 4339, 4445, 4530, 4566, 4583, 4586, 4592, 4728, 4794, 4908, 4979, 5164, 5174, 5263, 5299, 5481, 5573, 5792, 5803, 5848, 6199, 6286, 6640, 6823, 7095, 7120, 7201, 7261, 7337, 7344, 7388, 7452, 7470, 7480, 7641, 7787, 7892, 7930, 8047, 8056, 8111, 8183, 8194, 8508, 8570, 8675, 8825, 8912, 8916, 8927, 8931, 8933, 8963, 8988, 9020, 9058, 9068, 9193, 9259, 9317, 9332, 9368, 9412, 9431, 9437, 9478, 9687, 9701, 9728, 9775, 9829, 9900, 9933, 9948, 10208, 10209, 10248, 10250, 10350, 10362, 10414, 10443, 10464, 10583, 10707, 10741, 10783, 10806, 10829, 10894, 10945, 10956, 11057, 11058, 11059, 11062, 11067, 11069, 11251, 11258, 11307, 11361, 11375, 11427, 11587, 11719, 11732, 11807, 11839, 11933, 12136, 12190, 12195, 12316, 12530, 12539, 12666, 12848, 12888, 12892, 12919, 13003, 13016, 13022, 13225, 13250, 13271, 13277, 13281, 13294, 13339, 13362, 13365, 13430, 13456, 13462, 13498, 13583, 13586, 13588, 13591, 13617, 13631, 13647, 13692, 13798, 13886, 13890, 13895, 13896, 13899, 13903, 13977, 13983, 14049, 14055, 14166, 14208, 14221, 14241, 14342, 14360, 14363, 14406, 14418, 14473, 14500, 14520, 14570, 14631, 14638, 14646, 14676, 14740, 14793, 14836, 14840, 14881, 14894, 14900, 14947, 14951, 15040, 15049, 15150, 15162, 15193, 15231, 15437, 15442, 15460, 15477, 15500, 15656, 15753, 15802, 15809, 15812, 15874, 15979, 16036, 16061, 16063, 16081, 16090, 16132, 16153, 16187, 16191, 16384, 16394, 16409, 16416, 16457, 16474, 16517, 16542, 16577, 16698, 16923, 17073, 17102, 17179, 17223, 17284, 17355, 17387, 17397, 17415, 17527, 17577, 17793, 17828, 18010, 18092, 18105, 18203, 18295, 18345, 18540, 18543, 18547, 18665, 18679, 18748, 18889, 18933, 18935, 18937, 18949, 18955, 19014, 19127, 19139, 19159, 19172, 19184, 19235, 19240, 19295, 19330, 19361, 19393, 19410, 19413, 19472, 19481, 19487, 19512, 19547, 19577, 19586, 19613, 19632, 19637, 19648, 19676, 19718, 19738, 19747, 19811, 19814, 19845, 19849, 19873, 19982, 20017, 20041, 20067, 20084, 20096, 20130, 20223, 20275, 20283, 20291, 20333, 20363, 20414, 20416, 20463, 20481, 20584, 20622, 20642, 20674, 20692, 20725, 20748, 20826, 20908, 21042, 21063, 21127, 21151, 21167, 21170, 21177, 21213, 21220, 21227, 21237, 21248, 21263, 21281, 21312, 21439, 21461, 21512, 21515, 21521, 21529, 21557, 21590, 21617, 21619, 21670, 21761, 21807, 21808, 21837, 21872, 21891, 21918, 21976, 22071, 22253, 22289, 22306, 22313, 22340, 22378, 22415, 22426, 22452, 22499, 22502, 22511, 22555, 22574, 22608, 22609, 22624, 22660, 22733, 22801, 22810, 22856, 22858, 22900, 22911, 22915, 22965, 23017, 23041, 23057, 23060, 23065, 23086, 23111, 23147, 23151, 23155, 23165, 23197, 23219, 23226, 23234, 23310, 23312, 23324, 23329, 23330, 23370, 23382, 23402, 23429, 23461, 23536, 23621, 23663, 23665, 23784, 23870, 23909, 23927, 23971, 24055, 24089, 24092, 24094, 24097, 24098, 24099, 24102, 24103, 24106, 24109, 24112, 24121, 24142, 24161, 24182, 24190, 24260, 24339, 24393, 24437, 24547, 24554, 24556, 24591, 24622, 24657, 24670, 24709, 24724, 24759, 24907, 24950, 24979, 25202, 25216, 25264, 25278, 25332, 25370, 25481, 25530, 25537, 25662, 25736, 25941, 26016, 26127, 26134, 26180, 26184, 26207, 26218, 26241, 26270, 26274, 26318, 26353, 26416, 26484, 26567, 26610, 26652, 26666, 26689, 26763, 26848, 26871, 26933, 26997, 27034, 27091, 27113, 27160, 27184, 27321, 27394, 27397, 27528, 27584, 27602, 27656, 27671, 27676, 27679, 27680, 27682, 27687, 27694, 27703, 27728, 27752, 27761, 27767, 27789, 27813, 27819, 27854, 27905, 27934, 27997, 28038, 28047, 28055, 28100, 28140, 28141, 28148, 28164, 28174, 28176, 28197, 28225, 28236, 28251, 28269, 28293, 28299, 28336, 28339, 28365, 28373, 28428, 28431, 28441, 28478, 28513, 28516, 28642, 28673, 28765, 28797, 28882, 28891, 28958, 29050, 29062, 29376, 29381, 29384, 29386, 29388, 29390, 29400, 29402, 29405, 29410, 29414, 29421, 29439, 29466, 29492, 29503, 29515, 29520, 29568, 29591, 29604, 29606, 29637, 29726, 29782, 29808, 29833, 29890, 29914, 30052, 30059, 30061, 30117, 30132, 30137, 30300, 30311, 30327, 30342, 30403, 30429, 30460, 30584, 30589, 30599, 30601, 30614, 30639, 30648, 30672, 30786, 30795, 30798, 30919, 30964, 31113, 31168, 31211, 31217, 31261, 31266, 31331, 31332, 31364, 31375, 31416, 31435, 31682, 31692, 31723, 31743, 31747, 31822, 31829, 31831, 31899, 31930, 31968, 31987, 32013, 32132, 32160, 32187, 32212, 32218, 32325, 32502, 32631, 32713, 32806, 32822, 32827, 32947, 32963, 32975, 32977, 32979, 32982, 32984, 32986, 32988, 32990, 32992, 32997, 33002, 33006, 33011, 33046, 33137, 33140, 33168, 33204, 33241, 33342, 33442, 33581, 33690, 33695, 33696, 33738, 33877, 33899, 33926, 33931, 33953, 33958, 33978, 34014, 34082, 34102, 34198, 34202, 34227, 34285, 34311, 34327, 34333, 34384, 34385, 34533, 34558, 34750, 34804, 34828, 34909, 35118, 35127, 35143, 35154, 35300, 35434, 35501, 35502, 35516, 35528, 35566, 35575, 35788, 35907, 35964, 36114, 36194, 36208, 36212, 36237, 36287, 36311, 36399, 36470, 36513, 36547, 36785, 36841, 36862, 36903, 36921, 37018, 37111, 37256, 37263, 37275, 37286, 37288, 37289, 37290, 37299, 37305, 37306, 37312, 37315, 37326, 37335, 37343, 37345, 37348, 37354, 37357, 37385, 37397, 37425, 37439, 37441, 37463, 37473, 37548, 37572, 37594, 37619, 37626, 37666, 37668, 37777, 37779, 37787, 37835, 37841, 37852, 37853, 37875, 37889, 37929, 37943, 37975, 37976, 38063, 38118, 38133, 38139, 38153, 38189, 38190, 38201, 38231, 38306, 38331, 38345, 38382, 38416, 38429, 38460, 38468, 38473, 38503, 38560, 38575, 38578, 38580, 38583, 38585, 38588, 38596, 38598, 38603, 38609, 38611, 38613, 38624, 38639, 38668, 38669, 38674, 38681, 38683, 38684, 38693, 38694, 38695, 38703, 38712, 38727, 38736, 38742, 38756, 38764, 38772, 38775, 38779, 38791, 38859, 38865, 38873, 38874, 38882, 38883, 38891, 38909, 38922, 38929, 38931, 38934, 38940, 38951, 38956, 38968, 38974, 39124, 39191, 39214, 39229, 39245, 39246, 39273, 39288, 39304, 39316, 39325, 39345, 39351, 39355, 39376, 39378, 39401, 39517, 39521, 39537, 39563, 39629, 39698, 39705, 39712, 39727, 39770, 39787, 39803, 39819, 39824, 39827, 39837, 39862, 39872, 39878, 39884, 39887, 39891, 39892, 39895, 39910, 39952, 39956, 40065, 40092, 40143, 40202, 40224, 40265, 40283, 40320, 40364, 40387, 40391, 40401, 40416, 40446, 40535, 40571, 40635, 40644, 40655, 40680, 40727, 40735, 40750, 40757, 40827, 40869, 40883, 40896, 40914, 40979, 40997, 41002, 41019, 41020, 41115, 41120, 41244, 41245, 41313, 41366, 41371, 41399, 41455, 41466, 41523, 41528, 41538, 41544, 41552, 41567, 41693, 41738, 41749, 41763, 41783, 41869, 41871, 42020, 42105, 42154, 42165, 42279, 42300, 42339, 42345, 42407, 42414, 42457, 42516, 42659, 42691, 42727, 42739, 42742, 42865, 42964, 42971, 42976, 42978, 43047, 43067, 43077, 43084, 43093, 43104, 43143, 43185, 43191, 43208, 43222, 43231, 43255, 43283, 43325, 43374, 43376, 43392, 43443, 43605, 43661, 43670, 43674, 43712, 43726, 43736, 43743, 43752, 43772, 43786, 43821, 43838, 43866, 43898, 43978, 44039, 44056, 44107, 44125, 44147, 44155, 44170, 44251, 44281, 44358, 44404, 44409, 44467, 44470, 44603, 44610, 44620, 44638, 44733, 44761, 44785, 44809, 44899, 44901, 44903, 44911, 44922, 44925, 44931, 45053, 45068, 45096, 45138, 45145, 45167, 45299, 45310, 45321, 45326, 45347, 45352, 45365, 45390, 45394, 45412, 45425, 45449, 45492, 45544, 45566, 45574, 45645, 45681, 45702, 45754, 45759, 45831, 45859, 45874, 45890, 45896, 45913, 45915, 45917, 45922, 45927, 45946, 45951, 45997, 46040, 46050, 46052, 46073, 46075, 46145, 46148, 46171, 46187, 46201, 46266, 46339, 46341, 46345, 46356, 46365, 46381, 46422, 46435, 46489, 46550, 46661, 46699, 46702, 46707, 46712, 46839, 46841, 46908, 46912, 46918, 46924, 46930, 46975, 46976, 46990, 47014, 47038, 47052, 47114, 47290, 47550, 47670, 47867, 47911, 47971, 48027, 48077, 48095, 48132, 48152, 48163, 48341, 48344, 48347, 48349, 48356, 48358, 48361, 48363, 48372, 48375, 48377, 48382, 48386, 48389, 48391, 48398, 48402, 48407, 48413, 48418, 48421, 48438, 48442, 48545, 48551, 48563, 48574, 48580, 48590, 48626, 48766, 48767, 48821, 48913, 49044, 49094, 49152, 49191, 49195, 49354, 49573, 49583, 49587, 49609, 49614, 49637, 49644, 49759, 49888, 50106, 50121, 50143, 50163, 50175, 50379, 50383, 50385, 50387, 50391, 50392, 50398, 50400, 50402, 50404, 50406, 50410, 50414, 50416, 50428, 50430, 50435, 50442, 50444, 50449, 50466, 50494, 50549, 50707, 50731, 50821, 50904, 50907, 50934, 50942, 50944, 50948, 50950, 50953, 50957, 50961, 50963, 50969, 50977, 51054, 51135, 51254, 51261, 51266, 51298, 51302, 51317, 51332, 51354, 51462, 51484, 51507, 51535, 51539, 51704, 51815, 51858, 51887, 51888, 52082, 52223, 52274, 52386, 52465, 52506, 52511, 52589) 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: How To Grow Rich

Afterpiece Title: The Relief of Williamstadt

Cast
Role: Sir Gregory Forester Actor: Quick

Afterpiece Title: The Highland Reel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Relief of Williamstadt

Cast
Role: Sir Gregory Forester Actor: Quick

Afterpiece Title: Hartford Bridge

Cast
Role: Sir Gregory Forester Actor: Quick

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Relief of Williamstadt

Cast
Role: Sir Gregory Forester Actor: Quick

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Dance: End: Scotch Divertisement, as17930504

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Afterpiece Title: The Shipwreck

Cast
Role: Sir Simon Meagre Actor: Quick

Song: In 3rd piece: Farewell to old England dear Mary adieu, as17930527

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Lying Valet

Dance: As17930525

Performances

Mainpiece Title: At Kings The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Benson

Afterpiece Title: The Cheats of Scapin

Dance: End IV: Le Pas Russe, as17930531; End: a New Comic Dance composed by D'Egville-the young D'Egvilles, Miss Phillips

Performances

Mainpiece Title: At Kings The Foundling

Afterpiece Title: The Quaker

Dance: End: New Comic Dance, as17930607 but Miss _Phillips

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Evatt

Afterpiece Title: The Farmer

Dance: End: The Irish Lilt-

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Harlequins Chaplet

Entertainment: Afterpiece: [To conclude with Three Entire New Scenes, representing the Town and Harbour of Toulon; with a View of the Manoeuvring of the British, Spanish, and French Fleets, after the Surrender of the Town and Fortifications to the English] on the Twenty-ninth of August [1793]. In which, When in War on the Ocean-Davies; an Entire New Song [composed by Shield,-Incledon; The Music- [Selected by Shaw from Pepusch, Dr Arne, Arnold, Fisher, [Michael] Arne, Vincent, Dibdin, Reeve, Shield; The Dances-Byrn, Holland[; The Scenery-Hodgins, Walmsley, Phillips

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Lewis

Song: In V: a Dirge set to music by Shield, the words from Shakespeare; Vocal Parts-Mrs Martyr, Mrs Mountain, Mrs Clendining, Miss Hopkins, Miss Stuart, Miss Barnett, Mrs Watts, Mrs Follett, Mrs Lloyd, Mrs Masters, Miss Paye, Mrs Blurton, Mrs Castelle, Miss Leserve, Williamson, Linton, Street, Gray

Performances

Mainpiece Title: She Stoops To Conquer Or The Mistakes Of A Night

Cast
Role: Sir Charles Marlow Actor: Maddocks

Afterpiece Title: The Humourist

Cast
Role: Sir Rowland Actor: Barrymore

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Sir Charles Marlow Actor: Maddocks

Afterpiece Title: The Virgin Unmaskd

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: THE WARD OF THE CASTLE

Cast
Role: : Sir Bertram Actor: Incledon

Song: In afterpiece Chorusses by Linton, Tett, Sawyer, Little, Street, Kendrick//Miss Stuart, Mrs Watts, Mrs Follett, Mrs Castelle, Miss Kirton, Mrs Lloyd, Miss Paye, Miss Leserve, Mrs Bayzand, Mrs Blurton

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Sir Charles Marlow Actor: Maddocks

Afterpiece Title: NO SONG NO SUPPER

Cast
Role: Sir Rowland Actor: Barrymore

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Evatt

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Evatt

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Evatt

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Cast
Role: Sir Leinster M'Loghlin Actor: Rock

Afterpiece Title: THREE WEEKS AFTER MARRIAGE

Cast
Role: Sir Charles Racket Actor: Lewis

Dance: As17940225