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 Conscious Lovers

Afterpiece Title: Prometheus

Cast
Role: The Principal Characters Actor:

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Prometheus

Performances

Mainpiece Title: Douglas

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Prometheus

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Man of Quality

Cast
Role: Mendlegs Actor: Ledger

Dance: End: Mirth and Jollity, as17760102

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Man of Quality

Cast
Role: Mendlegs Actor: Ledger

Dance: I: A Minuet-Holloway, Miss Cranfield; II: A Minuet-Dagueville, Mrs Masters (Daughter of the late Mr Lalauze)

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Mother Shipton

Dance: In: As17770929; In afterpiece: Langrish, Miss Besford [who danced in all subsequent performances]

Song: End IV: Solemn Dirge, as17770929, but _Reinhold, Battishill

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Mother Shipton

Dance: End I: As17771222; In V: a Dance of Foresters-Dagueville

Performances

Mainpiece Title: Love Makes A Man; Or, The Fop's Fortune

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Mother Shipton

Song: As17771008

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Mother Shipton

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Mother Shipton

Dance: End: The Humours of New@Market-Dagueville, Harris, Master Holland, Miss Ross, Sga Tinte

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Mother Shipton

Entertainment: Monologue.As17780427

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Mother Shipton

Dance: As17770926