SELECT * FROM london_stages WHERE eventid IN (22622, 22626, 22629, 22633, 22637, 22640, 22645, 22648, 22651, 22674, 22680, 22759, 22909, 22912, 22915, 22918, 22925, 22928, 22931, 22937, 22946, 22949, 22952, 22955, 22960, 22963, 22966, 22969, 22972, 22977, 22980, 22983, 22988, 22999, 23009, 23013, 23016, 23019, 23028, 23031, 23034, 23038, 23042, 23048, 23057, 23060, 23069, 23075, 23086, 23092, 23095, 23108, 23115, 23120, 23126, 23129, 23134, 23141, 23155, 23173, 23177, 23197, 23320, 23324, 23326, 23379, 23423, 23443, 23447, 23450, 23704, 23772, 23984, 24009, 24034, 24062, 24149, 26872, 26875, 26877, 26879, 26886, 26889, 26893, 26897, 27035, 30297, 30305, 30311, 30317, 30325, 30369, 30371, 30374, 30376, 30381, 30383, 30388, 30393, 30400, 30405, 30413, 30418, 30422, 30424, 30427, 30432, 30434, 30436, 30446, 30452, 30455, 30457, 30460, 30463, 30465, 30470, 30481, 30484, 30486, 30489, 30493, 30496, 30498, 30522, 30542, 30549, 30564, 30569, 30578, 30583, 30585, 30594, 30606, 30619, 30638, 30646, 30656, 30658, 30662, 30665, 30668, 30674, 30676, 30682, 30684, 30686, 30691, 30701, 30798, 30801, 30810, 30812, 30818, 30822, 30824, 30826, 30828, 30832, 30834, 30840, 30849, 30852, 30856, 30860, 30867, 30872, 30878, 30882, 30891, 30898, 30902, 30905, 30907, 30910, 30912, 30914, 30922, 30926, 30930, 30933, 30935, 30937, 30940, 30944, 30947, 30950, 30952, 30954, 30956, 30964, 30966, 30969, 30971, 30981, 30985, 30987, 30989, 30991, 30993, 30995, 30998, 31001, 31003, 31005, 31007, 31009, 31012, 31015, 31017, 31019, 31021, 31023, 31026, 31028, 31031, 31033, 31035, 31037, 31040, 31043, 31049, 31052, 31055, 31061, 31066, 31069, 31079, 31082, 31085, 31089, 31094, 31097, 31100, 31102, 31106, 31109, 31116, 31120, 31136, 31148, 31154, 31158, 31168, 31179, 31182, 31187, 31189, 31200, 31208, 31211, 31216, 31220, 31223, 31225, 31231, 31239, 31247, 31253, 31268, 31274, 31739, 31783, 31785, 31786, 31788, 31789, 31790, 31791, 31792, 31793, 31794, 31795, 31796, 31797, 31798, 31799, 31800, 31801, 31802, 31803, 31804, 31805, 31806, 31807, 31808, 31809, 31810, 31811, 31812, 31813, 31814, 31815, 31816, 31822, 31823, 32764, 32765, 32766, 32767, 32768, 32769, 32780, 32784, 32786, 32788, 32789, 32790, 32792, 32793, 32796, 32797, 32798, 32799, 32801, 32803, 32804, 37568, 37658, 37685, 37697, 37702, 37708, 37710, 37716, 37722, 37729, 37736, 37750, 37761, 37763, 37768, 37775, 37780, 40174, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40267, 40272, 40279, 40285, 40292, 40295, 40305, 40308, 40311, 40316, 40318, 40320, 40323, 40324, 40326, 40331, 40332, 40335, 40338, 40340, 40345, 40353, 40355, 40358, 40360, 40364, 40367, 40369, 40372, 40379, 40382, 40413, 40418, 40425, 40428, 40433, 40436, 40441, 40448, 40454, 40508, 40509, 40510, 40511, 40512, 40513, 40516, 40517, 40519, 40524, 40527, 40531, 40533, 40545, 40566, 40572, 40578, 40580, 40582, 40587, 40589, 40590, 40593, 40596, 40600, 40602, 40604, 40606, 40608, 40611, 40613, 40615, 40617, 40619, 40622, 40624, 40634, 40636, 40653, 40660, 40663, 40665, 40667, 40669, 40672, 40674, 40677, 40679, 40681, 40683, 40686, 40688, 40691, 40693, 40697, 40700, 40708, 40711, 40714, 40717, 40719, 40721, 40723, 40726, 40729, 40732, 40734, 40741, 40743, 40746, 40755, 40767, 40770, 40775, 40781, 40784, 40787, 40789, 40795, 40797, 40801, 40804, 40809, 40813, 40816, 40819, 40845, 40856, 40859, 40862, 40866, 40873, 40876, 40880, 40886, 40889, 40891, 40898, 40902, 40907, 40910, 40912, 40917, 40933, 40958, 40962, 40965, 40970, 40980, 40983, 40989, 40999, 41010, 41117, 41119, 41120, 41122, 41125, 41127, 41132, 41133, 41135, 41139, 41141, 41143, 41145, 41148, 41152, 41160, 41163, 41169, 41171, 41176, 41192, 41194, 41201, 41205, 41207, 41209, 41211, 41219, 41222, 41224, 41227, 41231, 41233, 41236, 41238, 41241, 41250, 41255, 41259, 41269, 41306, 41320, 41329, 41335, 41379, 41394, 41397, 41402, 41404, 41441, 41476, 41485, 41491, 41494, 41496, 41498, 41500, 41503, 41505, 41508, 41510, 41513, 41518, 41520, 41523, 41527, 41529, 41532, 41534, 41537, 41542, 41544, 41547, 41552, 41559, 41562, 41564, 41567, 41569, 41689, 41691, 41695, 41697, 41699, 41718, 41723, 41729, 41733, 41743, 41747, 41749, 41751, 41753, 41757, 41761, 41770, 41774, 41784, 41797, 41816, 41828, 41841, 41848, 41851, 41853, 41856, 41858, 41861, 41863, 41866, 41868, 41870, 41872, 41875, 41877, 41880, 41882, 41885, 41887, 41890, 41893, 41896, 41898, 41901, 41903, 41906, 41909, 41912, 41914, 41916, 41918, 41921, 41923, 41926, 41929, 41931, 41934, 41936, 41939, 41941, 41948, 41950, 41954, 41958, 41961, 41963, 41967, 41974, 41976, 41980, 41984, 41987, 41990, 41994, 41998, 42001, 42003, 42007, 42011, 42021, 42026, 42037, 42040, 42045, 42047, 42052, 42058, 42063, 42066, 42073, 42081, 42093, 42108, 42111, 42134, 42142, 42157, 42160, 42285, 42287, 42291, 42299, 42302, 42303, 42306, 42312, 42316, 42318, 42320, 42324, 42330, 42334, 42338, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42412, 42420, 42425, 42435, 42442, 42452, 42458, 42461, 42463, 42467, 42470, 42472, 42477, 42481, 42486, 42489, 42491, 42494, 42501, 42506, 42510, 42530, 42541, 42551, 42561, 42579, 42607, 42620, 42638, 42649, 42651, 42668, 42670, 42679, 42682, 42689, 42692, 42694, 42699, 42702, 42707, 42712, 42714, 42741, 42757, 42864, 42877, 42884, 42886, 42889, 42891, 42899, 42901, 42904, 42906, 42916, 42918, 42920, 42922, 42924, 42928, 42930, 42932, 42934, 42936, 42940, 42942, 42944, 42946, 42948, 42952, 42956, 42958, 42960, 42963, 42965, 42968, 42970, 42977, 42979, 42982, 42984, 42986, 42988, 42991, 42997, 42999, 43001, 43003, 43006, 43065, 43069, 43072, 43074, 43077, 43095, 43101, 43106, 43115, 43118, 43120, 43124, 43138, 43141, 43148, 43158, 43167, 43172, 43176, 43180, 43183, 43191, 43195, 43200, 43204, 43217, 43219, 43222, 43224, 43229, 43232, 43234, 43237, 43242, 43249, 43255, 43257, 43260, 43263, 43268, 43274, 43277, 43280, 43283, 43288, 43298, 43308, 43310, 43318, 43321, 43325, 43441, 43453, 43462, 43465, 43470, 43472, 43473, 43478, 43482, 43484, 43486, 43490, 43494, 43498, 43500, 43502, 43506, 43508, 43510, 43512, 43514, 43517, 43519, 43521, 43523, 43525, 43527, 43529, 43531, 43533, 43535, 43537, 43539, 43541, 43543, 43545, 43547, 43549, 43551, 43553, 43555, 43557, 43559, 43564, 43568, 43572, 43575, 43577, 43582, 43585, 43587, 43590, 43592, 43594, 43596, 43599, 43601, 43604, 43606, 43608, 43610, 43613, 43615, 43618, 43620, 43624, 43627, 43629, 43631, 43633, 43636, 43638, 43641, 43644, 43647, 43649, 43651, 43653, 43656, 43659, 43662, 43664, 43666, 43668, 43678, 43689, 43693, 43696, 43702, 43707, 43712, 43715, 43718, 43722, 43729, 43732, 43740, 43746, 43756, 43765, 43767, 43770, 43774, 43776, 43779, 43781, 43784, 43789, 43792, 43795, 43798, 43801, 43803, 43806, 43809, 43812, 43815, 43818, 43824, 43829, 43832, 43836, 43838, 43841, 43844, 43847, 43849, 43852, 43856, 43858, 43861, 43863, 43868, 43871, 43873, 43883, 43886, 43888, 43891, 43893, 43896, 43900, 43901, 44029, 44031, 44033, 44034, 44035, 44037, 44039, 44041, 44043, 44046, 44048, 44051, 44054, 44056, 44058, 44059, 44061, 44063, 44066, 44068, 44070, 44072, 44076, 44078, 44080, 44087, 44089, 44091, 44093, 44095, 44097, 44099, 44101, 44103, 44105, 44109, 44111, 44115, 44117, 44119, 44123, 44125, 44127, 44129, 44131, 44135, 44139, 44141, 44143, 44145, 44147, 44149, 44151, 44153, 44155, 44157, 44159, 44161, 44163, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44249, 44253, 44258, 44263, 44272, 44279, 44286, 44290, 44293, 44299, 44303, 44309, 44311, 44319, 44322, 44324, 44328, 44335, 44337, 44341, 44348, 44354, 44358, 44367, 44369, 44374, 44377, 44384, 44387, 44392, 44394, 44397, 44399, 44402, 44412, 44421, 44424, 44429, 44437, 44439, 44444, 44449, 44452, 44454, 44457, 44462, 44467, 44469, 44601, 44608, 44616, 44618, 44620, 44621, 44628, 44632, 44634, 44638, 44645, 44654, 44658, 44660, 44664, 44668, 44672, 44674, 44676, 44688, 44692, 44696, 44708, 44712, 44721, 44723, 44726, 44728, 44737, 44750, 44752, 44757, 44762, 44764, 44766, 44771, 44776, 44780, 44785, 44787, 44789, 44791, 44796, 44799, 44813, 44819, 44824, 44831, 44834, 44836, 44844, 44849, 44853, 44857, 44860, 44867, 44871, 44874, 44876, 44884, 44887, 44891, 44897, 44903, 44911, 44913, 44915, 44917, 44922, 44925, 44927, 44934, 44936, 44939, 44944, 44949, 44959, 44961, 44964, 44966, 44968, 44969, 44971, 44973, 44978, 44980, 44983, 44986, 44995, 44997, 45001, 45007, 45018, 45022, 45025, 45032, 45035, 45039, 45043, 45135, 45147, 45158, 45166, 45169, 45174, 45176, 45180, 45184, 45188, 45192, 45196, 45204, 45208, 45216, 45222, 45228, 45232, 45234, 45240, 45244, 45248, 45252, 45257, 45262, 45271, 45274, 45278, 45280, 45307, 45326, 45330, 45338, 45344, 45347, 45356, 45361, 45399, 45412, 45423, 45433, 45436, 45438, 45442, 45444, 45446, 45449, 45451, 45454, 45464, 45469, 45475, 45482, 45490, 45492, 45497, 45502, 45506, 45511, 45515, 45517, 45519, 45521, 45524, 45526, 45531, 45534, 45537, 45539, 45542, 45547, 45552, 45554, 45557, 45559, 45562, 45567, 45572, 45574, 45577, 45579, 45584, 45589, 45591, 45698, 45704, 45709, 45711, 45719, 45722, 45726, 45727, 45733, 45738, 45744, 45745, 45750, 45752, 45771, 45783, 45793, 45797, 45801, 45805, 45809, 45811, 45815, 45817, 45819, 45827, 45829, 45833, 45835, 45838, 45858, 45860, 45864, 45876, 45880, 45883, 45885, 45888, 45894, 45897, 45904, 45918, 45934, 45988, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46020, 46024, 46040, 46093, 46143, 46171, 46176, 48091) 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 Pilgrim

Afterpiece Title: Tristram Shandy

Dance: In Act III of mainpiece a new Ballet in Demi-character (composed by Mons Lunatiq) La Tarantula; or, The Merry Bedlamites, with a grand Pas de Deux, to conclude with a Fandango in the Spanish stile (performers not listed)

Song: In Act iv of mainpiece The Pigeon, as17830507

Monologue: 1783 05 09 End of mainpiece Joe Haynes's Epilogue spoken by Wilson, riding on an Ass

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Don Alphonso Actor: Mrs Kennedy

Afterpiece Title: Tristram Shandy

Dance: End of mainpiece, as17830510

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Captain Macheath Actor: Mrs Kennedy

Afterpiece Title: Tristram Shandy

Dance: In Act III of mainpiece, as17830422; End of mainpiece, as17830510

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Tom Thumb

Cast
Role: Huncamunca Actor: Mrs Kennedy

Dance: As17821214

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Tom Thumb

Cast
Role: Huncamunca Actor: Mrs Kennedy

Dance: End of Act III of mainpiece, as17821231; End of mainpiece Diversion a-la-Mode, as n Dec. 1782, in which The Devonshire Minuet, as17821129

Performances

Mainpiece Title: A New Way To Pay Old Debts

Afterpiece Title: Tom Thumb

Cast
Role: Huncamunca Actor: Mrs Kennedy

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Rosina

Cast
Role: William Actor: Mrs Kennedy

Song: In Act II of mainpiece song by Brett

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: (End of Act II) The Rival Knights

Afterpiece Title: Rosina

Cast
Role: William Actor: Mrs Kennedy

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Lucy Actor: Mrs Kennedy

Afterpiece Title: (End of Act I) The Rival Knights

Afterpiece Title: Three Weeks after Marriage

Dance: In Act III of mainpiece Hornpipe by Miss Besford

Performances

Mainpiece Title: Artaxerxes

Cast
Role: Artaxerxes Actor: Mrs Kennedy

Afterpiece Title: Barnaby Brittle; or, A Wife at her Wit's End

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Cast
Role: William Actor: Mrs Kennedy

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Rosina

Cast
Role: William Actor: Mrs Kennedy

Performances

Mainpiece Title: The Maid Of The Mill

Cast
Role: Fanny Actor: Mrs Kennedy

Afterpiece Title: The Rival Knights

Afterpiece Title: Tristram Shandy

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Cast
Role: William Actor: Mrs Kennedy

Dance: As17830922

Song: As17830922, but added: Johnstone; Mrs Chalmers, Mrs Davenett

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Alphonso Actor: Mrs Kennedy

Afterpiece Title: The Author

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Song: In mainpiece To thee, O, gentle sleep by Brett

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Song: As17831104eggar's.

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Alphonso Actor: Mrs Kennedy

Afterpiece Title: The Rival Knights

Afterpiece Title: St

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Song: In Act II of mainpiece a Grand Chorus [Crowned with conquest] by Bannister, Reinhold, Johnstone, Mattocks, Brett, Mahon, Doyle, Darley; Mrs Bannister, Mrs Johnstone, Mrs Martyr, Mrs Morton, Miss Stuart, Mrs Davenett, Mrs Kennedy. [For songs, see below.]

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Alphonso Actor: Mrs Kennedy

Afterpiece Title: Lord Mayor's Day

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy

Song: As17831108

Performances

Mainpiece Title: Douglas

Afterpiece Title: The Poor Soldier

Cast
Role: : Patrick Actor: Mrs Kennedy