SELECT * FROM london_stages WHERE eventid IN (34923, 34925, 34927, 34929, 34931, 34933, 34935, 34937, 34939, 34941, 34943, 34945, 34947, 34949, 34951, 34953, 34955, 34957, 34959, 34961, 34966, 34968, 34970, 34972, 34975, 34980, 34984, 34986, 34989, 34991, 34996, 34998, 35000, 35003, 35005, 35010, 35012, 35014, 35019, 35024, 35026, 35031, 35033, 35038, 35040, 35042, 35045, 35048, 35053, 35057, 35060, 35062, 35064, 35066, 35070, 35074, 35076, 35078, 35080, 35083, 35085, 35088, 35090, 35092, 35094, 35097, 35102, 35104, 35106, 35108, 35111, 35113, 35118, 35120, 35125, 35127, 35129, 35132, 35135, 35138, 35143, 35147, 35149, 35160, 35164, 35169, 35174, 35177, 35179, 35182, 35184, 35187, 35195, 35207, 35210, 35218, 35223, 35245, 35264, 35277, 35286, 35289, 35305, 35308, 35321, 35337, 35357, 35365, 35368, 35372, 35379, 35381, 35382, 35495, 35498, 35508, 35535, 35577, 35607, 35610, 35612, 35617, 35619, 35621, 35624, 35629, 35633, 35635, 35638, 35667, 35676, 35683, 35693, 35716, 35810, 35818, 35823, 35868, 35907, 35918, 35927, 35937, 35943, 35947, 35967, 35986, 35992, 35994, 36113, 36118, 36131, 36145, 36157, 36176, 36179, 36181, 36201, 36223, 36225, 36232, 36237, 36239, 36243, 36248, 36253, 36266, 36275, 36291, 36308, 36317, 36343, 36437, 36460, 36468, 36473, 36504, 36508, 36516, 36555, 36565, 36568, 36636, 36651, 36653, 36673, 36704, 36719, 36738, 36761, 36784, 36790, 36795, 36813, 36881, 36904, 36925, 36974, 37011, 37021, 37028, 37039, 37058, 37060, 37063, 37068, 37080, 37082, 37094, 37119, 37124, 37212, 37223, 37227, 37233, 37235, 37237, 37239, 37243, 37245, 37247, 37262, 37270, 37272, 37274, 37278, 37280, 37286, 37288, 37290, 37299, 37305, 37312, 37326, 37335, 37343, 37349, 37354, 37357, 37366, 37371, 37373, 37386, 37391, 37393, 37396, 37400, 37405, 37410, 37416, 37424, 37426, 37433, 37441, 37443, 37451, 37453, 37455, 37457, 37465, 37470, 37472, 37477, 37479, 37503, 37524, 37540, 37548, 37550, 37570, 37572, 37579, 37594, 37621, 37626, 37659, 37665, 37667, 37671, 37675, 37680, 37783, 37785, 37787, 37799, 37801, 37803, 37805, 37813, 37817, 37835, 37837, 37839, 37841, 37843, 37845, 37847, 37849, 37852, 37854, 37858, 37860, 37862, 37866, 37868, 37870, 37875, 37878, 37884, 37889, 37891, 37900, 37911, 37919, 37925, 37943, 37945, 37947, 37951, 37956, 37960, 37971, 37975, 37987, 38018, 38028, 38042, 38045, 38047, 38050, 38053, 38056, 38058, 38060, 38062, 38065, 38067, 38070, 38073, 38078, 38083, 38088, 38091, 38097, 38102, 38105, 38107, 38118, 38121, 38128, 38133, 38136, 38138, 38143, 38148, 38153, 38158, 38165, 38167, 38172, 38177, 38186, 38188, 38190, 38192, 38195, 38197, 38200, 38202, 38205, 38216, 38224, 38345, 38347, 38349, 38351, 38353, 38355, 38357, 38359, 38364, 38367, 38371, 38373, 38376, 38378, 38381, 38383, 38385, 38387, 38390, 38392, 38394, 38396, 38399, 38404, 38410, 38412, 38420, 38422, 38427, 38429, 38434, 38439, 38455, 38457, 38459, 38462, 38464, 38469, 38471, 38473, 38477, 38479, 38492, 38494, 38496, 38500, 38511, 38514, 38516, 38519, 38525, 38528, 38530, 38534, 38538, 38540, 38543, 38545, 38551, 38554, 38559, 38561, 38563, 38565, 38568, 38570, 38575, 38578, 38580, 38583, 38585, 38588, 38596, 38598, 38603, 38611, 38613, 38619, 38624, 38629, 38639, 38642, 38644, 38653, 38658, 38663, 38668, 38673, 38675, 38680, 38684, 38689, 38692, 38694, 38698, 38700, 38703, 38706, 38711, 38719, 38721, 38724, 38726, 38729, 38734, 38736, 38741, 38748, 38750, 38753, 38758, 38768, 38775, 38796, 38873, 38876, 38879, 38883, 38885, 38888, 38891, 38899, 38910, 38912, 38916, 38918, 38930, 38932, 38934, 38937, 38939, 38942, 38944, 38946, 38948, 38951, 38956, 38958, 38962, 38965, 38967, 38972, 38974, 38976, 38979, 38984, 38988, 38995, 39000, 39008, 39011, 39015, 39017, 39020, 39024, 39026, 39086, 39090, 39093, 39107, 39114, 39121, 39123, 39128, 39135, 39137, 39142, 39146, 39151, 39156, 39160, 39184, 39202, 39205, 39219, 39225, 39245, 39449, 39474, 39486, 39491, 39493, 39499, 39502, 39518, 39525, 39527, 39546, 39550, 39555, 39558, 39560, 39567, 39574, 39588, 39590, 39592, 39595, 39611, 39613, 39615, 39618, 39629, 39632, 39648, 39657, 39660, 39663, 39668, 39670, 39673, 39675, 39678, 39680, 39684, 39687, 39690, 39693, 39695, 39699, 39704, 39709, 39713, 39729, 39775, 39818, 39823, 39828, 39835, 39837, 39843, 39847, 39852, 39857, 39871, 39873, 39875, 39888, 39891, 39894, 39902, 40023, 40025, 40029, 40033, 40035, 40037, 40041, 40049, 40050, 40052, 40057, 40062, 40064, 40068, 40074, 40076, 40082, 40084, 40088, 40092, 40100, 40108, 40113, 40117, 40127, 40141, 40143, 40153, 40155, 40157, 40159, 40162, 40164, 40169, 40175, 40178, 40180, 40184, 40187, 40189, 40192, 40194, 40201, 40207, 40209, 40211, 40223, 40227, 40235, 40237, 40242, 40244, 40247, 40249, 40251, 40262, 40275, 40288, 40291, 40294, 40296, 40301, 40304, 40307, 40315, 40322, 40330, 40352, 40357, 40359, 40361, 40363, 40366, 40373, 40376, 40378, 40381, 40383, 40386, 40388, 40390, 40392, 40395, 40397, 40400, 40402, 40405, 40407, 40410, 40415, 40417, 40419, 40421, 40424, 40427, 40430, 40432, 40435, 40440, 40447, 40453, 40455, 40457, 40458, 40460, 40466, 40565, 40567, 40569, 40571, 40573, 40579, 40586, 40595, 40597, 40601, 40616, 40621, 40625, 40631, 40635, 40637, 40641, 40645, 40648, 40650, 40652, 40657, 40659, 40662, 40664, 40666, 40668, 40671, 40673, 40676, 40678, 40680, 40682, 40690, 40699, 40702, 40705, 40710, 40713, 40716, 40718, 40720, 40722, 40725, 40733, 40735, 40740, 40742, 40745, 40749, 40751, 40757, 40760, 40764, 40766, 40771, 40774, 40776, 40778, 40780, 40783, 40788, 40791, 40800, 40803, 40806, 40808, 40812, 40818, 40820, 40824, 40827, 40830, 40832, 40838, 40841, 40844, 40847, 40851, 40855, 40865, 40869, 40872, 40875, 40881, 40883, 40885, 40890, 40893, 40897, 40899, 40901, 40904, 40906, 40909, 40914, 40919, 40924, 40927, 40930, 40932, 40940, 40945, 40947, 40950, 40952, 40955, 40959, 40961, 40964, 40969, 40971, 40977, 40979, 40982, 40984, 40986, 40988, 40991, 40993, 40996, 40998, 41001, 41003, 41008, 41121, 41124, 41129, 41131, 41134, 41138, 41140, 41142, 41144, 41146, 41147, 41149, 41151, 41153, 41155, 41161, 41164, 41173, 41175, 41178, 41180, 41183, 41186, 41189, 41191, 41195, 41200, 41202, 41204, 41206, 41208, 41221, 41226, 41228, 41235, 41240, 41244, 41249, 41256, 41258, 41263, 41265, 41270, 41272, 41277, 41291, 41296, 41298, 41303, 41310, 41314, 41322, 41324, 41326, 41334, 41337, 41339, 41341, 41343, 41346, 41349, 41353, 41355, 41358, 41360, 41370, 41373, 41375, 41382, 41393, 41401, 41411, 41414, 41424, 41427, 41429, 41434, 41450, 41454, 41457, 41470, 41473, 41475, 41479, 41484, 41488, 41490, 41495, 41499, 41502, 41504, 41507, 41509, 41512, 41514, 41517, 41519, 41522, 41524, 41528, 41531, 41536, 41538, 41541, 41543, 41546, 41548, 41551, 41553, 41561, 41563, 41566, 41568, 41572, 41575, 41577, 41687, 41692, 41698, 41700, 41702, 41704, 41706, 41708, 41717, 41722, 41724, 41726, 41728, 41730, 41732, 41734, 41736, 41738, 41744, 41746, 41750, 41752, 41756, 41758, 41760, 41762, 41769, 41771, 41773, 41775, 41778, 41783, 41785, 41787, 41792, 41811, 41822, 41830, 41832, 41860, 41862, 41865, 41869, 41871, 41895, 41905, 41908, 41911, 41913, 41915, 41920, 41922, 41925, 41928, 41933, 41935, 41938, 41947, 41953, 41966, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42010, 42013, 42016, 42020, 42025, 42049, 42051, 42055, 42057, 42060, 42062, 42065, 42067, 42072, 42075, 42077, 42087, 42090, 42092, 42095, 42097, 42100, 42105, 42113, 42121, 42128, 42131, 42133, 42136, 42146, 42162, 42164, 42165, 42166, 42273, 42277, 42279, 42281, 42286, 42288, 42290, 42292, 42298, 42301, 42305, 42307, 42311, 42315, 42319, 42323, 42327, 42331, 42333, 42337, 42339, 42342, 42344, 42351, 42358, 42361, 42363, 42366, 42368, 42371, 42373, 42376, 42380, 42388, 42391, 42395, 42397, 42400, 42402, 42407, 42409, 42414, 42421, 42426, 42436, 42439, 42441, 42444, 42447, 42451, 42457, 42460, 42462, 42464, 42466, 42471, 42474, 42476, 42478, 42483, 42485, 42488, 42490, 42493, 42498, 42503, 42509, 42516, 42517, 42524, 42526, 42529, 42535, 42538, 42543, 42550, 42553, 42555, 42558, 42560, 42563, 42568, 42570, 42578, 42580, 42583, 42585, 42593, 42596, 42598, 42602, 42606, 42611, 42615, 42619, 42624, 42628, 42641, 42645, 42648, 42650, 42654, 42658, 42667, 42671, 42673, 42676, 42681, 42683, 42688, 42691, 42701, 42706, 42708, 42711, 42716, 42718, 42720, 42727, 42730, 42732, 42736, 42738, 42740, 42742, 42744, 42746, 42752, 42857, 42859, 42861, 42865, 42875, 42885, 42888, 42890, 42892, 42893, 42895, 42897, 42902, 42903, 42907, 42913, 42917, 42921, 42927, 42929, 42935, 42941, 42943, 42945, 42947, 42949, 42953, 42955, 42959, 42962, 42964, 42967, 42973, 42983, 42990, 42993, 42996, 42998, 43000, 43002, 43005, 43014, 43016, 43019, 43023, 43025, 43033, 43047, 43051, 43053, 43058, 43061, 43066, 43078, 43080, 43083, 43088, 43092, 43100, 43103, 43107, 43109, 43112, 43114, 43119, 43121, 43123, 43126, 43129, 43133, 43137, 43140, 43147, 43157, 43162, 43166, 43169, 43171, 43185, 43194, 43197, 43199, 43203, 43207, 43223, 43231, 43238, 43241, 43246, 43248, 43252, 43254, 43262, 43264, 43269, 43273, 43276, 43279, 43284, 43289, 43292, 43297, 43302, 43309, 43312, 43314, 43435, 43438, 43443, 43447, 43450, 43454, 43456, 43458, 43466, 43467, 43469, 43471, 43477, 43481, 43493, 43501, 43505, 43511, 43513, 43516, 43520, 43522, 43524, 43526, 43528, 43530, 43532, 43534, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43586, 43598, 43600, 43603, 43605, 43609, 43626, 43632, 43637, 43640, 43643, 43646, 43652, 43655, 43658, 43661, 43665, 43667, 43670, 43673, 43681, 43685, 43688, 43695, 43701, 43711, 43721, 43725, 43739, 43742, 43745, 43751, 43769, 43771, 43773, 43775, 43778, 43785, 43794, 43797, 43800, 43802, 43808, 43814, 43823, 43825, 43828, 43835, 43843, 43846, 43848, 43851, 43853, 43855, 43857, 43860, 43862, 43865, 43867, 43875, 43880, 43882, 43885, 43892, 43897, 43904, 44028, 44032, 44034, 44053, 44064, 44071, 44073, 44077, 44079, 44084, 44088, 44090, 44092, 44094, 44100, 44104, 44112, 44116, 44118, 44120, 44122, 44124, 44128, 44130, 44132, 44134, 44136, 44138, 44148, 44152, 44156, 44158, 44160, 44162, 44175, 44179, 44181, 44183, 44189, 44191, 44193, 44195, 44199, 44205, 44229, 44241, 44269, 44278, 44295, 44314, 44331, 44366, 44373, 44396, 44401, 44406, 44418, 44433, 44438, 44441, 44451, 44453, 44456, 44461, 44463, 44471, 44588, 44592, 44596, 44600, 44604, 44606, 44614, 44615, 44622, 44635, 44637, 44644, 44646, 44651, 44657, 44661, 44665, 44667, 44681, 44683, 44689, 44693, 44695, 44697, 44714, 44722, 44732, 44736, 44751, 44756, 44759, 44761, 44763, 44765, 44807, 44809, 44833, 44843, 44846, 44848, 44852, 44859, 44862, 44870, 44873, 44879, 44883, 44906, 44912, 44916, 44921, 44940, 44948, 44951, 44954, 44960, 44968, 44977, 44982, 44994, 45017, 45029, 45031, 45138, 45142, 45148, 45151, 45155, 45157, 45160, 45163, 45168, 45173, 45177, 45183, 45185, 45187, 45189, 45201, 45207, 45211, 45215, 45217, 45221, 45225, 45229, 45239, 45243, 45245, 45247, 45249, 45251) 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 Maid Of Kent

Afterpiece Title: A Trip to Scotland

Cast
Role: Jemmy Actor: Brereton

Entertainment: End II: (By Particular Desire, and for the last time this season) Imitations-Bannister

Performances

Mainpiece Title: Amphitryon

Cast
Role: Mercury Actor: Brereton, first time

Afterpiece Title: The Irish Widow

Dance: I: The Sailors Revels, as17730928

Performances

Mainpiece Title: Cymbeline

Cast
Role: Arviragus Actor: Brereton

Afterpiece Title: The Ladies Frolick

Dance: End: A Hornpipe-Walker

Performances

Afterpiece Title: A Trip to Scotland

Cast
Role: Jemmy Actor: Brereton

Entertainment: End: (By Particular Desire) Bannister's Imitations-Bannister

Performances

Mainpiece Title: The London Merchant; Or, The History Of George Barnwell

Cast
Role: Trueman Actor: Brereton

Afterpiece Title: The Wedding Ring

Dance: V: The Sailors Revels, as17730928

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Sir John Melvil Actor: Brereton

Afterpiece Title: The Meeting of the Company

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Cymbeline

Cast
Role: Arviragus Actor: Brereton

Afterpiece Title: The Meeting of the Company

Afterpiece Title: The Anatomist

Dance: III: The Sailors Revels, as17740920

Performances

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

Afterpiece Title: The Meeting of the Company

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Alexander The Great; Or, The Rival Queens

Cast
Role: Lysimachus Actor: Brereton

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: Alexander The Great

Cast
Role: Lysimachus Actor: Brereton

Afterpiece Title: The Deserter

Performances

Mainpiece Title: The School For Wives

Cast
Role: Savage Actor: Brereton

Afterpiece Title: The Meeting of the Company

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Zara

Cast
Role: Nerestan Actor: Brereton, first time

Afterpiece Title: The Irish Widow

Dance: End I of Farce: The Irish Fair, as17740917

Performances

Mainpiece Title: Cymbeline

Cast
Role: Arviragus Actor: Brereton

Afterpiece Title: The Genii

Dance: III: The Sailors Revels, as17740920

Performances

Mainpiece Title: Every Man In His Humour

Cast
Role: Cash Actor: Brereton

Afterpiece Title: The Devil to Pay

Dance: V: The Sailors Revels, as17740920

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Election

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: A Trip to Scotland

Cast
Role: Jemmy Twinkle Actor: Brereton

Performances

Mainpiece Title: Alexander The Great

Cast
Role: Lysimachus Actor: Brereton

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17740917

Performances

Mainpiece Title: The Stratagem

Cast
Role: Sir Charles Freeman Actor: Brereton

Afterpiece Title: Miss in Her Teens

Dance: IV: The Irish Fair, as17740917

Performances

Mainpiece Title: Tamerlane

Cast
Role: Axalla Actor: Brereton

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Sir Harry Groveby Actor: Brereton

Afterpiece Title: The Miller of Mansfield

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Sir Harry Groveby Actor: Brereton

Afterpiece Title: The Register Office

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Sir Harry Groveby Actor: Brereton

Afterpiece Title: The Lyar

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Elopement

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Sir Harry Groveby Actor: Brereton

Afterpiece Title: The Deuce Is in Him

Performances

Mainpiece Title: The Maid Of The Oaks

Cast
Role: Sir Harry Groveby Actor: Brereton

Afterpiece Title: The Mayor of Garratt