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: The Careless Husband

Performances

Mainpiece Title: The Careless Husband

Performances

Mainpiece Title: Macbeth

Song: As17831218, but omitted: Mrs Bannister, Mrs Johnstone

Performances

Mainpiece Title: The Careless Husband

Performances

Mainpiece Title: The Man Of The World

Cast
Role: Sam Actor: Ledger

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Castle Of Andalusia

Performances

Mainpiece Title: All For Love

Performances

Mainpiece Title: The Man Of Theworld

Cast
Role: Sam Actor: Ledger

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Careless Husband

Performances

Mainpiece Title: The Man Of The World

Cast
Role: Sam Actor: Ledger

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Robin Hood; Or, Sherwood Forest

Dance: End of mainpiece a New Dance by Le Bccuf and Mlle Constance (from the King's Theatre in Paris; 1st appearance)

Performances

Mainpiece Title: Robin Hood

Dance: As17840417

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Ben Budge Actor: Ledger

Afterpiece Title: Rosina

Dance: In Act III of mainpiece, as17831014; End of mainpiece The Poney Races, as17840428

Song: End of Act I of mainpiece a favourite song by Leoni; End of Act II When Phoebus the tops of the bills does adorn by Leoni and Brett

Performances

Mainpiece Title: Robin Hood

Performances

Mainpiece Title: The Man Of The World

Cast
Role: Sam Actor: Ledger

Afterpiece Title: Harlequin Rambler

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Gadshill Actor: Ledger

Afterpiece Title: Rosina

Dance: End of mainpiece The Charms of a Camp, as17840521

Song: End of Act II of mainpiece Tally Ho! by Mrs Martyr; End of Act iv Poor ThomasDay by Edwin, Davies, Brett

Performances

Mainpiece Title: A Jubilee In Commemoration Of Handel

Afterpiece Title: The Funeral; or, Grief a-la-Mode

Cast
Role: Nathan Matchlock Actor: Ledger

Afterpiece Title: Hob in the Well

Dance: End of mainpiece The Charms of a Camp (performers not listed, but see17840521)

Performances

Mainpiece Title: Robin Hood

Song: As17840514

Performances

Mainpiece Title: The Fox

Afterpiece Title: Gretna Green

Cast
Role: Landlord Actor: Ledger

Music: [Prologue by George Colman, the elder.]

Dance: End of Act III of mainpiece, as17840528

Performances

Mainpiece Title: The Election Of The Managers

Afterpiece Title: The English Merchant

Performances

Mainpiece Title: The Election Of The Managers

Afterpiece Title: The Spanish Barber

Performances

Mainpiece Title: The Tobacconist

Afterpiece Title: The Election of the Managers

Afterpiece Title: Gretna Green

Cast
Role: Landlord Actor: Ledger

Performances

Mainpiece Title: The Agreeable Surprise

Afterpiece Title: The Tobacconist

Cast
Role: Landlord Actor: Ledger

Afterpiece Title: The Election of the Managers

Performances

Mainpiece Title: Seeing Is Believing: A Dramatic Proverb

Afterpiece Title: Gretna Green

Cast
Role: Landlord Actor: Ledger

Afterpiece Title: The Election of the Managers

Performances

Mainpiece Title: The Young Quaker

Cast
Role: Coachman Actor: Ledger

Afterpiece Title: The Son-in-Law