SELECT * FROM london_stages WHERE eventid IN (38497, 38510, 38517, 38522, 38524, 38526, 38529, 38722, 38732, 39717, 39719, 39722, 39724, 39727, 39730, 39732, 39741, 39746, 39751, 39760, 39782, 39806, 39822, 39841, 39869, 39876, 39881, 39889, 40040, 40042, 40044, 40046, 40048, 40059, 40071, 40093, 40099, 40121, 40135, 40140, 40149, 40173, 40179, 40181, 40382, 40391, 40411, 40787, 40789, 40795, 40797, 40801, 40804, 40807, 40809, 40825, 40828, 40833, 40839, 40882, 40915, 40938, 40941, 40943, 40946, 40953, 40958, 40967, 40972, 40974, 40978, 40985, 40987, 40992, 40997, 41002, 41005, 41201, 41340, 41552, 41601, 41603, 41604, 41607, 41610, 41615, 41618, 41621, 41626, 41631, 41633, 41642, 41646, 41649, 41652, 41659, 41661, 41671, 41689, 41831, 41896, 41929, 42037, 42124, 42206, 42211, 42214, 42217, 42221, 42225, 42229, 42232, 42235, 42236, 42237, 42238, 42239, 42240, 42241, 42248, 42254, 42268, 42271, 42320, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42377, 42379, 42381, 42383, 42396, 42398, 42403, 42406, 42412, 42420, 42425, 42435, 42442, 42452, 42463, 42467, 42472, 42477, 42479, 42481, 42486, 42501, 42510, 42541, 42546, 42551, 42561, 42607, 42620, 42668, 42670, 42682, 42687, 42689, 42694, 42712, 42714, 42745, 42750, 42755, 42760, 42761, 42762, 42765, 42768, 42769, 42773, 42775, 42777, 42780, 42783, 42785, 42787, 42788, 42789, 42791, 42795, 42797, 42798, 42799, 42800, 42802, 42803, 42805, 42806, 42807, 42808, 42810, 42811, 42812, 42814, 42815, 42816, 42817, 42818, 42819, 42820, 42821, 42822, 42823, 42825, 42826, 42827, 42828, 42829, 42830, 42831, 42832, 42835, 42837, 42838, 42839, 42840, 42841, 42842, 42843, 42844, 42845, 42846, 42847, 42848, 42849, 42850, 42851, 42852, 42853, 42886, 42891, 42938, 43043, 43079, 43081, 43084, 43093, 43098, 43104, 43106, 43115, 43127, 43138, 43143, 43158, 43229, 43232, 43260, 43263, 43300, 43310, 43313, 43321, 43322, 43326, 43327, 43330, 43333, 43337, 43343, 43347, 43349, 43350, 43352, 43353, 43355, 43356, 43357, 43358, 43360, 43361, 43363, 43366, 43371, 43372, 43373, 43377, 43378, 43379, 43382, 43384, 43386, 43387, 43391, 43393, 43395, 43399, 43400, 43401, 43402, 43403, 43407, 43414, 43415, 43422, 43423, 43431, 43439, 43446, 43448, 43449, 43453, 43460, 43482, 43484, 43494, 43555, 43707, 43715, 43784, 43858, 43905, 43908, 43912, 43914, 43919, 43920, 43923, 43932, 43936, 43940, 43945, 43951, 43956, 43957, 43965, 43968, 43969, 43970, 43975, 43977, 43979, 43981, 43983, 43985, 43986, 43987, 43988, 43989, 43991, 43992, 44007, 44008, 44009, 44011, 44012, 44013, 44014, 44015, 44017, 44018, 44019, 44021, 44023, 44024, 44025, 44033, 44037, 44039, 44054, 44061, 44063, 44066, 44068, 44070, 44072, 44091, 44093, 44095, 44099, 44101, 44105, 44115, 44123, 44139, 44143, 44167, 44170, 44253, 44286, 44303, 44341, 44481, 44483, 44490, 44498, 44506, 44512, 44521, 44533, 44535, 44538, 44539, 44547, 44566, 44570, 44580, 44595, 44618, 44620, 44621, 44656, 44696, 44712, 44789, 44805, 44810, 44813, 44815, 44817, 44822, 44828, 44831, 44836, 44840, 44844, 44847, 44853, 44857, 44860, 44874, 44876, 44880, 44897, 44907, 44927, 44955, 44961, 44966, 45032, 45043, 45074, 45075, 45076, 45078, 45079, 45081, 45084, 45094, 45098, 45099, 45101, 45104, 45105, 45107, 45110, 45113, 45115, 45116, 45117, 45119, 45121, 45122, 45123, 45124, 45126, 45128, 45129, 45130, 45131, 45132, 45133, 45134, 45186, 45190, 45194, 45198, 45200, 45210, 45212, 45220, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45291, 45328, 45333, 45342, 45349, 45354, 45365, 45386, 45390, 45403, 45410, 45416, 45425, 45429, 45446, 45461, 45464, 45472, 45487, 45500, 45509, 45517, 45526, 45537, 45547, 45554, 45562, 45574, 45589, 45597, 45610, 45611, 45613, 45616, 45617, 45622, 45625, 45627, 45629, 45632, 45634, 45638, 45641, 45642, 45644, 45646, 45648, 45649, 45651, 45652, 45655, 45656, 45657, 45658, 45660, 45662, 45666, 45667, 45670, 45671, 45674, 45676, 45677, 45679, 45680, 45681, 45683, 45684, 45685, 45686, 45687, 45688, 45690, 45717, 45735, 45740, 45748, 45756, 45775, 45787, 45791, 45807, 45823, 45833, 45850, 45869, 45897, 45906, 45914, 45916, 45918, 45920, 45925, 45930, 45932, 45939, 45948, 45962, 45980, 46002, 46007, 46018, 46033, 46038, 46042, 46050, 46055, 46065, 46068, 46073, 46078, 46100, 46109, 46148, 46169, 46181, 46183, 46188, 46193, 46196, 46197, 46200, 46202, 46205, 46208, 46209, 46212, 46214, 46215, 46218, 46222, 46223, 46224, 46226, 46228, 46229, 46230, 46235, 46240, 46241, 46242, 46244, 46248, 46254, 46257, 46258, 46294, 46323, 46331, 46338, 46349, 46409, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46557, 46566, 46571, 46590, 46593, 46600, 46609, 46652, 46659, 46700, 46711, 46713, 46729, 46731, 46736, 46750, 46752, 46753, 46755, 46759, 46762, 46763, 46764, 46765, 46768, 46769, 46770, 46772, 46773, 46775, 46778, 46779, 46782, 46784, 46785, 46786, 46787, 46790, 46792, 46797, 46801, 46802, 46803, 46804, 46805, 46809, 46810, 46812, 46813, 46814, 46816, 46817, 46818, 46819, 46820, 46821, 46822, 46824, 46825, 46826, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46881, 46895, 46905, 46909, 46917, 46941, 46949, 46973, 47063, 47198, 47202, 47209, 47212, 47224, 47235, 47244, 47247, 47249, 47253, 47255, 47266, 47277, 47283, 47285, 47289, 47309, 47315, 47316, 47320, 47326, 47331, 47334, 47335, 47338, 47339, 47341, 47346, 47349, 47350, 47353, 47356, 47360, 47361, 47362, 47363, 47366, 47368, 47370, 47371, 47373, 47374, 47376, 47378, 47380, 47381, 47382, 47383, 47384, 47385, 47386, 47387, 47388, 47394, 47398, 47400, 47404, 47410, 47415, 47421, 47423, 47424, 47427, 47464, 47472, 47482, 47495, 47505, 47507, 47519, 47545, 47553, 47680, 47690, 47693, 47696, 47700, 47704, 47707, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47769, 47774, 47782, 47787, 47792, 47797, 47800, 47805, 47808, 47813, 47815, 47820, 47828, 47835, 47843, 47858, 47872, 47887, 47892, 47912, 47916, 47918, 47923, 47927, 47931, 47937, 47938, 47939, 47940, 47941, 47944, 47949, 47951, 47952, 47953, 47956, 47957, 47961, 47962, 47965, 47967, 47969, 47970, 47973, 47976, 47980, 47981, 47990, 48004, 48006, 48020, 48039, 48045, 48051, 48059, 48076, 48086, 48131, 48160, 48341, 48344, 48347, 48349, 48354, 48356, 48358, 48361, 48363, 48370, 48372, 48375, 48377, 48382, 48386, 48389, 48391, 48394, 48396, 48398, 48402, 48407, 48413, 48418, 48421, 48439, 48440, 48445, 48448, 48449, 48454, 48457, 48462, 48465, 48466, 48467, 48469, 48470, 48472, 48473, 48474, 48476, 48477, 48478, 48480, 48481, 48482, 48484, 48487, 48488, 48489, 48491, 48492, 48494, 48495, 48496, 48497, 48498, 48499, 48501, 48502, 48503, 48504, 48507, 48508, 48509, 48510, 48511, 48513, 48514, 48515, 48517, 48518, 48519, 48520, 48522, 48523, 48525, 48526, 48527, 48529, 48530, 48531, 48532, 48533, 48534, 48569, 48575, 48588, 48608, 48613, 48618, 48620, 48621, 48628, 48635, 48650, 48654, 48667, 48672, 48675, 48677, 48695, 48699, 48705, 48707, 48712, 48722, 48734, 48735, 48737, 48739, 48744, 48837, 48858, 48884, 49046, 49051, 49058, 49069, 49088, 49092, 49123, 49125, 49126, 49127, 49128, 49130, 49131, 49132, 49135, 49136, 49137, 49138, 49140, 49141, 49142, 49143, 49144, 49145, 49146, 49147, 49148, 49149, 49150, 49151, 49153, 49154, 49155, 49156, 49157, 49158, 49160, 49161, 49162, 49164, 49165, 49166, 49168, 49169, 49171, 49172, 49174, 49175, 49176, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49184, 49195, 49203, 49228, 49229, 49232, 49234, 49238, 49240, 49242, 49244, 49246, 49248, 49250, 49252, 49254, 49258, 49260, 49262, 49264, 49266, 49362, 49404, 49408, 49445, 49485, 49500, 49504, 49507, 49509, 49513, 49522, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49545, 49548, 49550, 49573, 49583, 49609, 49614, 49637, 49642, 49644, 49646, 49651, 49654, 49656, 49659, 49663, 49665, 49669, 49672, 49675, 49677, 49679, 49680, 49682, 49683, 49685, 49686, 49687, 49688, 49690, 49691, 49693, 49694, 49696, 49698, 49699, 49700, 49701, 49702, 49703, 49704, 49705, 49706, 49707, 49709, 49711, 49712, 49713, 49714, 49716, 49717, 49719, 49720, 49724, 49725, 49726, 49727, 49728, 49729, 49730, 49733, 49734, 49736, 49737, 49738, 49740, 49741, 49742, 49743, 49744, 49745, 49746, 49747, 49748, 49749, 49750, 49752, 49753, 49754, 49764, 49772, 49777, 49779, 49788, 49791, 49796, 49799, 49801, 49803, 49807, 49813, 49815, 49825, 49827, 49831, 49861, 49863, 49869, 49871, 49877, 49879, 49924, 49929, 49963, 49966, 49968, 49971, 49973, 49975, 49978, 49983, 49985, 49987, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50061, 50075, 50077, 50087, 50104, 50118, 50134, 50136, 50141, 50143, 50146, 50148, 50151, 50158, 50177, 50179, 50191, 50200, 50215, 50221, 50224, 50226, 50229, 50230, 50232, 50234, 50235, 50237, 50238, 50239, 50240, 50242, 50243, 50245, 50246, 50247, 50248, 50250, 50251, 50253, 50256, 50257, 50259, 50260, 50262, 50263, 50264, 50265, 50267, 50268, 50270, 50271, 50272, 50273, 50275, 50276, 50277, 50278, 50279, 50280, 50282, 50283, 50284, 50285, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50293, 50294, 50295, 50296, 50297, 50298, 50299, 50302, 50303, 50304, 50305, 50306, 50307, 50312, 50314, 50316, 50317, 50318, 50319, 50320, 50321, 50322, 50330, 50332, 50336, 50340, 50345, 50353, 50368, 50371, 50389, 50392, 50408, 50422, 50454, 50456, 50496, 50506, 50562, 50611, 50616, 50623, 50626, 50628, 50632, 50635, 50638, 50640, 50690, 50693, 50695, 50719, 50731, 50733, 50736, 50742, 50744, 50749, 50757, 50769, 50772, 50792, 50795, 50797, 50802, 50809, 50814, 50817, 50818, 50820, 50821, 50824, 50825, 50826, 50827, 50830, 50832, 50833, 50834, 50835, 50837, 50838, 50842, 50845, 50846, 50848, 50849, 50853, 50856, 50857, 50858, 50862, 50864, 50865, 50866, 50867, 50869, 50870, 50871, 50873, 50874, 50875, 50877, 50878, 50879, 50882, 50885, 50890, 50893, 50894, 50895, 50896, 50901, 50902, 50903, 50910, 50917, 50923, 50927, 50951, 50959, 50967, 50969, 50975, 50981, 50989, 50997, 51001, 51024, 51057, 51061, 51067, 51073, 51092, 51147, 51156, 51159, 51221, 51277, 51283, 51300, 51331, 51333, 51376, 51378, 51381, 51383, 51386, 51388, 51391, 51392, 51394, 51395, 51396, 51397, 51399, 51400, 51402, 51405, 51407, 51408, 51411, 51413, 51415, 51419, 51420, 51421, 51423, 51424, 51430, 51431, 51433, 51434, 51438, 51441, 51442, 51445, 51446, 51449, 51450, 51451, 51452, 51453, 51454, 51457, 51461, 51462, 51463, 51464, 51465, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51474, 51476, 51477, 51950, 51953, 51955, 51957, 51959, 51962, 51964, 51967, 51969, 51973, 51976, 51978, 51981, 51983, 51985, 51988, 51989, 51991, 51993, 51994, 51996, 51997, 51999, 52000, 52001, 52002, 52004, 52005, 52007, 52008, 52012, 52013, 52017, 52020, 52021, 52022, 52023, 52025, 52026, 52028, 52029, 52030, 52031, 52033, 52035, 52037, 52038, 52041, 52044, 52045, 52046, 52047, 52049, 52050, 52051, 52052, 52053, 52054, 52055, 52122, 52134, 52200, 52420, 52483, 52514, 52520, 52526, 52528, 52529, 52535, 52536, 52539, 52543, 52545, 52547, 52548, 52555, 52556, 52567, 52571, 52580, 52593, 52596, 52598, 52599, 52602, 52609) 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: A Cure For The Heart Ache

Afterpiece Title: The Agreeable Surprise

Cast
Role: Cudden Actor: Ledger

Performances

Mainpiece Title: Rose And Colin

Afterpiece Title: The Jealous Wife

Afterpiece Title: The Farmer

Cast
Role: Waiters Actor: Ledger, Abbot

Performances

Mainpiece Title: Wives As They Were, And Maids As They Are

Cast
Role: Servants Actor: Lee, Wilde, Ledger, Curties

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Jailor Actor: Ledger

Afterpiece Title: The Miser

Cast
Role: Upholsterer Actor: Ledger

Dance: As17971025

Song: In: Old Towler-Incledon; a new Duetto, composed by Mme Mara,-Incledon, Mme Mara

Performances

Mainpiece Title: False Impressions

Afterpiece Title: The Farmer

Cast
Role: Waiters Actor: Ledger, Abbot

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Calvette Actor: Ledger

Afterpiece Title: The Round Tower

Performances

Mainpiece Title: The Ghost

Afterpiece Title: False Impressions

Cast
Role: Waiters Actor: Ledger, Abbot

Afterpiece Title: Britain's Brave Tars

Performances

Mainpiece Title: The Way To Get Married

Cast
Role: Postilion Actor: Ledger

Afterpiece Title: The Agreeable Surprise

Cast
Role: Cudden Actor: Ledger

Performances

Mainpiece Title: Jane Shore

Cast
Role: Servant Actor: Ledger

Afterpiece Title: Harlequin and Quixotte

Performances

Mainpiece Title: The Suspicious Husband

Cast
Role: Chairmen Actor: Ledger, Rees

Afterpiece Title: Harlequin and Quixotte

Performances

Mainpiece Title: The Busy Body

Cast
Role: William Actor: Ledger

Afterpiece Title: Harlequin and Quixotte

Performances

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

Afterpiece Title: The Farmer

Cast
Role: Waiters Actor: Ledger, Abbot

Performances

Mainpiece Title: Secrets Worth Knowing

Afterpiece Title: The Agreeable Surprise

Cast
Role: Cudden Actor: Ledger

Performances

Mainpiece Title: The Busy Body

Cast
Role: William Actor: Ledger

Afterpiece Title: Joan of Arc; or, The Maid of Orleans

Performances

Mainpiece Title: Jane Shore

Cast
Role: Servant Actor: Ledger

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Song: In afterpiece: Come every jovial Fellow-Mrs Martyr, Gray, Mrs Mountain; O ever in my Bosom live-Mrs Martyr, Mrs Mountain

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Jailor Actor: Ledger

Afterpiece Title: Raymond and Agnes

Dance: In III: Hornpipe in Fetters, as17971025; Afterpiece to conclude: Spanish Fandango-; Finale- as17971009

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Calvette Actor: Ledger

Afterpiece Title: Raymond and Agnes

Dance: As17971012

Performances

Mainpiece Title: The Suspicious Husband

Cast
Role: Chairmen Actor: Ledger, Rees

Afterpiece Title: The Farmer

Cast
Role: Waiters Actor: Ledger, Abbot

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Balthazar Actor: Ledger

Afterpiece Title: The Farmer

Cast
Role: Waiters Actor: Ledger, Abbot

Performances

Mainpiece Title: The Busy Body

Cast
Role: William Actor: Ledger

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Farmer

Cast
Role: Chairmen Actor: Ledger, Rees

Afterpiece Title: The Child of Nature

Dance: End 1st piece: Peggy's Love- in which, by permission of the Proprietor of the Opera House, who has generously allowed Principal Dancers and Whole Corps de Ballet to appear, the following Ladies and Gentlemen will exert their well known Abilities:Laborie, Didelot, Mme Laborie, Mme Hilligsberg; End 2nd piece: La Vengeance d'Amour, in which the Pas de Quatre de Panurge-Laborie, Didelot, Mme Laborie, Mme Hilligsberg

Performances

Mainpiece Title: The Deaf Lover

Afterpiece Title: The Battle of Hexham; or, Days of Old

Cast
Role: Robbers Actor: Bannister, Davies, Abbot, Ledger

Afterpiece Title: Blue Devils

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Cast
Role: Plainwell Actor: Ledger

Afterpiece Title: The Beggar's Opera

Cast
Role: Jailor Actor: Ledger

Afterpiece Title: Blue Devils

Cast
Role: Robbers Actor: Bannister, Davies, Abbot, Ledger

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: The Prisoner at Large

Cast
Role: Father Frank Actor: Ledger

Performances

Mainpiece Title: The Purse; Or, Benevolent Tar

Afterpiece Title: The London Hermit; or, Rambles in Dorsetshire

Cast
Role: Carter Actor: Ledger

Afterpiece Title: Peeping Tom