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: All In The Wrong

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891221

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: In afterpiece: Byrne, Miss Simonet

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Farmer

Afterpiece Title: The Follies of a Day

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Midnight Hour

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Song: In III: song-Duffey

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: In afterpiece: As17891231.; End II: Divertissement, as17891002

Performances

Mainpiece Title: King Lear

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Song: As17900113

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Gamesters

Cast
Role: Drawer Actor: Ledger

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891231

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: The Miser

Cast
Role: Upholsterer Actor: Ledger

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As 31 Dec. 1789

Performances

Mainpiece Title: The Poor Soldier

Afterpiece Title: The Child of Nature

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: As17891221

Performances

Mainpiece Title: Eudora

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Gardener Actor: Ledger

Dance: In afterpiece: Additional Dances (1st time)-Byrne, Mrs Goodwin, the two Miss Simonets