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: Inkle And Yarico

Cast
Role: Sailors Actor: Painter, Ledger

Afterpiece Title: Gretna Green

Cast
Role: Landlord Actor: Ledger

Dance: End: The Russian Minuet, as17870730

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Painter, Ledger

Afterpiece Title: The Guardian

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Sailors Actor: Painter, Ledger

Afterpiece Title: The Romp

Performances

Mainpiece Title: Zenobia

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Gadshill Actor: Ledger

Afterpiece Title: The Enchanted Castle

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: II: Masquerade Dance incident to the play-

Performances

Mainpiece Title: The Follies Of A Day; Or, The Marriage Of Figaro

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: Such Things Are

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871029

Performances

Mainpiece Title: He Wou'd Be A Soldier

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: End: The Piping Pedlar-

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871129

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871029

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871129

Performances

Mainpiece Title: The Inconstant; Or, The Way To Win Him

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871129

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871029

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Song: the Grand Triumphal Entry of Alexander into Babylon, as17871022; Vocal Parts, as17871022, but Bonville, +Janson, Mrs +Gray, Miss +Rowson, Miss +Paye, Mrs +Byrne, _Brown, Mrs _Morton, Miss _Blower

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Gadshill Actor: Ledger

Afterpiece Title: The Dumb Cake

Performances

Mainpiece Title: The Man Of The World

Cast
Role: Sam Actor: Ledger

Afterpiece Title: The Dumb Cake

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: End: Mirth by Moonshine, as17870928, but _Ratchford, Mrs _Invill

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: As17871107

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Farmer

Cast
Role: Landlord Actor: Ledger

Dance: End: As17880124