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: The Foundling Or Virtue Rewarded

Cast
Role: Sir Charles Raymond Actor: Banks
Role: Sir Roger Belmont Actor: Jones

Afterpiece Title: The Deuce is in Him

Afterpiece Title: The Shipwreck or Walking Statue

Dance: End: a comic dance, The Affrighted Dwarf; or, Whimsical Transformation into Mad Moll-Blandford

Entertainment: Monologues. End I: Epilogue-Somebody in the Character of Nobody; End II: British Loyalty; or, A Squeeze for St. Paul's, will be introduced the characters of a Fide Lady? a Beau, an Irishman, a Scotchman, a Welshman, a Jew, an Old Man, and a British Sailor-Randall

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Lewis

Dance: As17891021

Performances

Mainpiece Title: The Lady Of The Manor

Cast
Role: Sir John English Actor: Quick
Role: Sir Charles Manly Actor: Duffey

Afterpiece Title: Animal Magnetism

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Haymes

Afterpiece Title: The Island of St

Dance: End IV: The Minuet de la Cour and Gavot-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Lewis

Dance: As17891125

Performances

Mainpiece Title: The Force Of Fashion

Cast
Role: Sir Charles Dormer Actor: Farren

Afterpiece Title: The Citizen

Cast
Role: Sir Jasper Wilding Actor: Thompson

Performances

Mainpiece Title: The Careless Husband

Cast
Role: Sir Charles Easy Actor: Kemble

Afterpiece Title: The Island of St

Performances

Mainpiece Title: The Careless Husband

Cast
Role: Sir Charles Easy Actor: Kemble

Afterpiece Title: The Island of St

Performances

Mainpiece Title: The Careless Husband

Cast
Role: Sir Charles Easy Actor: Kemble

Afterpiece Title: The Island of St

Performances

Mainpiece Title: The Czar

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Sir Charles Racket Actor: Lewis

Song: III: The Prince unable to conceal his Pain, from Alexander's Feast-Mrs Billington. [This was included, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Sir Charles Marlow Actor: Powel

Afterpiece Title: The Recruiting Serjeant

Afterpiece Title: Rose and Colin

Entertainment: Monologue. End 2nd piece: A Dissertation on Macaronyism-Bernard

Performances

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

Cast
Role: Sir Charles Marlow Actor: Packer

Afterpiece Title: The Island of St

Dance: End II: As17900308

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Evatt

Afterpiece Title: Love in a Camp

Dance: End: A Dance of Jockies-Ratchford, Blurton, Jackson, Miller, Mrs Ratchford

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Haymes

Afterpiece Title: The Humourist

Cast
Role: Sir Anthony Halfwit Actor: Suett

Dance: As17891121

Performances

Mainpiece Title: The Runaway

Afterpiece Title: The Gentle Shepherd

Cast
Role: Sir William Worthy Actor: Aickin

Dance: End: L'Amour au Rende'vous; or, The Conflict of Love, in which will be displayed the Customs of the American Indians, to conclude with the War Dance,-the young D'Egvilles, Miss Blanchet, Miss D'Egville, Miss DeCamp; End I afterpiece: A Highland Reel-the young D'Egvilles, Miss Blanchet, Miss DeCamp

Performances

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

Cast
Role: Sir Charles Marlow Actor: Silvester

Afterpiece Title: The Romp

Entertainment: Monologues. Preceding: [Collins's Ode on the Passions-a Young Lady [unidentified]; End: [Hippisley's Drunken Man=-Harper

Music: End III: concerto on the violin-Hindmarsh

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Sir Charles Marlow Actor: Powel

Afterpiece Title: Cymon

Performances

Mainpiece Title: Better Late Than Never

Cast
Role: Sir Charles Chouse Actor: Palmer

Afterpiece Title: Don Juan

Dance: As17901026

Performances

Mainpiece Title: Better Late Than Never

Cast
Role: Sir Charles Chouse Actor: Palmer

Afterpiece Title: The Island of St

Performances

Mainpiece Title: Better Late Than Never

Cast
Role: Sir Charles Chouse Actor: Palmer

Afterpiece Title: The Pannel

Performances

Mainpiece Title: Better Late Than Never

Cast
Role: Sir Charles Chouse Actor: Palmer

Afterpiece Title: Don Juan

Dance: As17901026

Performances

Mainpiece Title: Better Late Than Never

Cast
Role: Sir Charles Chouse Actor: Palmer

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The Beaux Stratagem

Cast
Role: Sir Charles Freeman Actor: Evatt

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: Better Late Than Never

Afterpiece Title: The Fairy Favour

Performances

Mainpiece Title: Better Late Than Never

Cast
Role: Sir Charles Chouse Actor: Palmer

Afterpiece Title: The Fairy Favour