The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE eventid IN (39023, 39048, 39050, 39052, 39057, 39061, 39070, 39075, 39077, 39082, 39203, 39209, 39237, 39258, 39261, 39277, 39283, 39294, 39299, 39313, 39318, 39330, 39454, 39456, 39458, 39461, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 39559, 39561, 39563, 39565, 39568, 39570, 39582, 39601, 39604, 39606, 39608, 39610, 39612, 39614, 39616, 39619, 39622, 39624, 39626, 39628, 39630, 39633, 39635, 39638, 39644, 39649, 39661, 39664, 39671, 39674, 39676, 39688, 39700, 39758, 39765, 39813, 39829, 39844, 39853, 39874, 39899, 40040, 40042, 40044, 40046, 40048, 40053, 40059, 40061, 40071, 40073, 40093, 40099, 40121, 40135, 40140, 40149, 40173, 40179, 40181, 40188, 40190, 40193, 40195, 40197, 40199, 40202, 40205, 40208, 40210, 40212, 40214, 40217, 40219, 40222, 40224, 40226, 40228, 40233, 40236, 40238, 40240, 40243, 40245, 40248, 40250, 40252, 40254, 40257, 40259, 40279, 40311, 40316, 40323, 40326, 40331, 40358, 40367, 40379, 40382, 40413, 40425, 40431, 40454, 40578, 40580, 40582, 40587, 40589, 40590, 40605, 40607, 40609, 40610, 40612, 40613, 40614, 40615, 40617, 40618, 40621, 40623, 40624, 40625, 40627, 40634, 40641, 40643, 40645, 40648, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40700, 40722, 40725, 40728, 40731, 40733, 40735, 40737, 40740, 40776, 40780, 40783, 40786, 40794, 40796, 40806, 40812, 40818, 40820, 40841, 40847, 40851, 40861, 40869, 40873, 40875, 40879, 40881, 40883, 40886, 40889, 40900, 40901, 40910, 40952, 40959, 40962, 40964, 40965, 40966, 40970, 40973, 40980, 40982, 40983, 40989, 41116, 41128, 41129, 41136, 41165, 41178, 41237, 41242, 41246, 41256, 41263, 41280, 41282, 41286, 41296, 41300, 41308, 41322, 41346, 41349, 41351, 41353, 41355, 41358, 41360, 41363, 41365, 41368, 41370, 41373, 41375, 41378, 41380, 41382, 41395, 41396, 41398, 41400, 41401, 41403, 41405, 41407, 41409, 41411, 41414, 41416, 41418, 41426, 41427, 41429, 41431, 41440, 41443, 41446, 41448, 41450, 41454, 41456, 41463, 41465, 41473, 41479, 41484, 41495, 41497, 41507, 41509, 41514, 41516, 41522, 41524, 41526, 41530, 41531, 41538, 41546, 41548, 41550, 41560, 41568, 41574, 41575, 41577, 41578, 41579, 41580, 41585, 41586, 41590, 41594, 41598, 41609, 41611, 41612, 41617, 41620, 41622, 41624, 41632, 41638, 41640, 41644, 41645, 41653, 41654, 41655, 41656, 41657, 41658, 41660, 41662, 41663, 41666, 41669, 41671, 41672, 41674, 41678, 41680, 41682, 41685, 41686, 41712, 41734, 41862, 42013, 42039, 42121, 42124, 42126, 42129, 42132, 42144, 42148, 42153, 42168, 42171, 42175, 42183, 42186, 42187, 42191, 42194, 42195, 42198, 42199, 42205, 42211, 42214, 42217, 42221, 42222, 42225, 42226, 42227, 42229, 42238, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42447, 42449, 42451, 42454, 42457, 42460, 42464, 42471, 42474, 42478, 42483, 42488, 42493, 42495, 42500, 42503, 42507, 42512, 42519, 42524, 42529, 42531, 42533, 42540, 42543, 42548, 42560, 42565, 42570, 42583, 42596, 42609, 42760, 42762, 42764, 42765, 42766, 42767, 42769, 42770, 42772, 42775, 42777, 42780, 42783, 42785, 42787, 42788, 42791, 42795, 42797, 42798, 42799, 42800, 42803, 42805, 42807, 42808, 42810, 42814, 42816, 42817, 42818, 42819, 42823, 42829, 42831, 42833, 42834, 42835, 42837, 42841, 42843, 42847, 42849, 42851, 43380, 43390, 43398, 43402, 43407, 43415, 43672, 43687, 43700, 43716, 43730, 43737, 43744, 43796, 43807, 43813, 43842, 43963, 43970, 43975, 43977, 43979, 43981, 43984, 43985, 43986, 43988, 43991, 43992, 43993, 44001, 44006, 44007, 44009, 44010, 44011, 44012, 44013, 44015, 44017, 44019, 44021, 44023, 44024, 44025, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44469, 45512, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45951, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46093, 46100, 46103, 46121, 46130, 46133, 46137, 46148, 46151, 46166, 46171, 46174, 46178, 46266, 46271, 46273, 46284, 46292, 46299, 46311, 46321, 46323, 46336, 46343, 46353, 46357, 46361, 46363, 46365, 46369, 46373, 46383, 46387, 46389, 46393, 46397, 46399, 46401, 46403, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46464, 46466, 46469, 46471, 46474, 46476, 46478, 46481, 46483, 46486, 46488, 46490, 46492, 46495, 46500, 46506, 46509, 46511, 46515, 46519, 46522, 46524, 46529, 46533, 46536, 46543, 46552, 46564, 46566, 46571, 46580, 46585, 46590, 46593, 46607, 46612, 46614, 46622, 46632, 46634, 46637, 46639, 46642, 46657, 46676, 46688, 46695, 46697, 46700, 46708, 46711, 46716, 46718, 46729, 46732, 46737, 46743, 46746, 46751, 46758, 48566, 48568, 48570, 48574, 48760, 48762, 48768, 48770, 48786, 48788, 48790, 48792, 48797, 48804, 48808, 48813, 48816, 48818, 48827, 48831, 48845, 48850, 48852, 48859, 48864, 48866, 48880, 48883, 48891, 48903, 48919, 48928, 48931, 48939, 48948, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50111, 50141, 50143, 50151, 50153, 50156, 50161, 50170, 50177, 50184, 50186, 50189, 50203, 50215, 50394, 50396, 50398, 50400, 50402, 50404, 50408, 50410, 50414, 50416, 50430, 50442, 50449, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50688, 50690, 50695, 50697, 50699, 50702, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50736, 50742, 50744, 50747, 50764, 50772, 50784, 50790, 50800, 50802, 50805, 50812, 52093, 52097, 52102, 52104, 52106, 52116, 52122, 52200, 52202, 52204, 52206, 52208, 52210, 52212, 52214, 52216, 52218, 52221, 52223, 52225, 52227, 52229, 52231, 52234, 52236, 52239, 52248, 52250, 52253, 52255, 52257, 52259, 52262, 52264, 52269, 52271, 52289, 52294, 52296, 52303, 52317, 52329, 52353, 52359, 52365, 52418, 52420, 52423, 52425, 52429, 52432, 52439, 52442, 52447, 52452, 52456, 52461, 52466, 52468, 52476, 52478, 52490, 52499, 52504, 52511) 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: King Henry The Second; Or, The Fall Of Rosamond

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: End Afterpiece: Rural Dance-Bishop, Sga Tinte

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17761226

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: End: The Merry Sailors, as17761106; In afterpiece: Rural Dance, as17761226

Performances

Mainpiece Title: The Jovial Crew

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17761226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17761226

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17761226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: Afterpiece conclude: Rural Dance-Harris, Miss Matthews

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17770121

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17770121

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17770121

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17761226

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17761226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17770121

Performances

Mainpiece Title: Caractacus

Afterpiece Title: The Royal Chace; or, Harlequin Skeleton

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: Sir Thomas Overbury

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Dance: End: The Serenade, as17770426

Music: End II: solo on the pedal harp-Jones

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: Caractacus

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: As17770121

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: Harlequin's Frolicks

Cast
Role: Pierrot Actor: Delpini

Dance: End III: Minuet de la Cour, Allemande-Mr and Mrs Holloway; End IV: The Shepherd's Wedding, as17770215; End: a Minuet-Dumay, Sga Tinte; Afterpiece: Rural Dance, as17770121

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Dance: End: The Humours of Leixlip, as17770425

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Royal Chace; or, Harlequin Skeleton

Cast
Role: Pierrot Actor: Delpini

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

Performances

Mainpiece Title: Lionel And Clarissa

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Dance: End II: The Pilgrim-Harris, Miss Matthews

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Royal Chace

Cast
Role: Pierrot Actor: Delpini

Dance: As17771001