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 (23697, 23729, 23745, 24173, 24295, 24634, 24697, 24820, 24829, 24830, 24831, 24832, 24834, 24836, 24837, 24838, 24840, 24842, 24843, 24844, 24845, 24847, 24849, 24852, 24888, 24907, 24950, 25017, 25020, 25033, 25035, 25038, 25044, 25059, 25127, 25133, 25142, 25153, 25164, 25170, 25182, 25185, 25195, 25280, 25286, 25333, 25379, 25393, 25395, 25411, 25443, 25500, 25506, 25535, 25545, 25682, 25728, 25734, 25741, 25750, 25757, 25770, 25772, 25812, 25848, 25852, 25857, 25861, 25865, 25869, 25873, 25884, 25889, 25893, 25896, 25899, 25902, 25905, 25907, 25909, 25925, 25928, 25937, 25945, 25948, 25950, 25952, 25954, 25963, 26038, 26055, 26072, 26078, 26080, 26083, 26091, 26094, 26117, 26123, 26127, 26130, 26139, 26141, 26153, 26907, 26913, 26916, 26921, 26935, 27004, 27013, 27197, 27229, 27250, 27253, 27287, 27304, 27310, 27313, 27315, 27317, 27319, 27328, 27335, 27349, 27351, 27354, 27370, 27375, 27377, 27384, 27387, 27389, 27401, 27403, 27405, 27409, 27412, 27427, 27446, 27473, 27509, 27512, 27524, 27537, 27542, 27544, 27553, 27571, 27582, 27590, 27597, 27602, 27613, 27615, 27622, 27630, 27683, 27689, 27717, 27723, 27738, 27749, 27751, 27753, 27764, 27780, 27785, 27792, 27802, 27809, 27811, 27839, 27841, 27843, 27845, 27847, 27852, 27855, 27875, 27883, 27888, 27897, 27903, 27909, 27914, 27919, 27923, 27925, 27928, 27933, 27935, 27939, 27943, 27948, 27953, 27959, 27966, 27979, 27996, 28003, 28007, 28010, 28012, 28017, 28022, 28039, 28046, 28048, 28050, 28073, 28082, 28097, 28110, 28127, 28145, 28153, 28155, 28161, 28163, 28167, 28173, 28183, 28186, 28192, 28202, 28204, 28206, 28220, 28226, 28228, 28230, 28232, 28240, 28242, 28244, 28250, 28252, 28254, 28269, 28279, 28281, 28286, 28296, 28309, 28323, 28332, 28353, 28362, 28364, 28366, 28368, 28371, 28399, 28412, 28423, 28460, 28465, 28472, 28481, 28492, 28507, 28522, 28525, 28542, 28550, 28614, 28622, 28626, 28657, 28668, 28670, 28672, 28687, 28700, 28710, 28743, 28746, 28774, 28780, 28783, 28811, 28824, 28832, 28842, 28858, 28862, 28865, 28867, 28870, 28872, 28875, 28880, 28883, 28886, 28892, 28897, 28903, 28909, 28916, 28920, 28923, 28936, 28940, 28943, 28959, 28961, 28965, 28972, 28977, 28979, 28994, 28996, 28998, 29003, 29008, 29012, 29015, 29017, 29020, 29023, 29042, 29053, 29058, 29160, 29162, 29168, 29190, 29208, 29212, 29222, 29242, 29251, 29253, 29267, 29288, 29316, 29330, 29332, 29355, 29360, 29429, 29453, 29458, 29466, 29471, 29479, 29493, 29504, 29516, 29521, 29525, 29533, 29543, 29561, 29575, 29591, 29601, 29724, 29727, 29733, 29751, 29753, 29771, 29777, 29779, 29791, 29793, 29795, 29798, 29800, 29802, 29805, 29807, 29809, 29811, 29814, 29816, 29818, 29820, 29829, 29839, 29858, 29884, 29887, 29897, 29902, 29904, 29906, 29908, 29910, 29918, 29920, 29937, 29946, 29948, 29953, 29957, 29961, 29968, 29972, 29976, 29979, 29982, 29984, 29988, 30004, 30007, 30010, 30013, 30016, 30019, 30022, 30025, 30043, 30053, 30056, 30062, 30064, 30074, 30076, 30079, 30094, 30096, 30099, 30107, 30109, 30112, 30115, 30131, 30142, 30146, 30150, 30154, 30308, 30310, 30318, 30332, 30352, 30389, 30401, 30430, 30451, 30461, 30503, 30586, 30618, 30625, 30628, 30661, 30689, 30807, 30813, 30823, 30837, 30844, 30846, 30850, 30879, 30887, 30957, 30959, 30962, 30965, 30970, 30972, 30974, 30977, 30980, 30982, 30984, 30992, 30999, 31006, 31010, 31027, 31034, 31044, 31073, 31075, 31107, 31127, 31132, 31145, 31152, 31177, 31183, 31192, 31224, 31240, 31242, 31248, 31267, 31269, 31278, 31338, 31347, 31351, 31355, 31365, 31369, 31375, 31377, 31379, 31381, 31383, 31385, 31388, 31392, 31394, 31396, 31400, 31402, 31404, 31408, 31414, 31418, 31420, 31423, 31427, 31429, 31431, 31433, 31440, 31442, 31446, 31454, 31458, 31466, 31497, 31501, 31509, 31520, 31532, 31545, 31559, 31561, 31572, 31590, 31598, 31627, 31646, 31649, 31652, 31670, 31672, 31685, 31690, 31692, 31695, 31709, 31714, 31721, 31724, 31732, 31734, 31743, 31750, 31754, 31757, 31759, 31764, 31768, 31770, 31772, 31826, 31830, 31832, 31834, 31838, 31840, 31842, 31846, 31848, 31852, 31862, 31864, 31872, 31880, 31894, 31898, 31900, 31922, 31928, 31933, 31936, 31942, 31950, 31952, 31978, 31980, 31996, 32006, 32010, 32013, 32015, 32018, 32020, 32033, 32037, 32050, 32058, 32064, 32079, 32089, 32091, 32093, 32098, 32129, 32149, 32159, 32161, 32165, 32172, 32178, 32182, 32185, 32192, 32196, 32203, 32212, 32222, 32225, 32227, 32244, 32253, 32255, 32261, 32313, 32316, 32318, 32324, 32330, 32331, 32335, 32338, 32343, 32345, 32371, 32385, 32391, 32394, 32396, 32398, 32406, 32417, 32420, 32440, 32465, 32469, 32474, 32476, 32478, 32491, 32515, 32517, 32527, 32529, 32573, 32620, 32640, 32654, 32665, 32686, 32692, 32694, 32714, 32719, 32725, 32756, 32757, 32758, 32760, 32761, 32762, 32764, 32765, 32766, 32767, 32768, 32769, 32770, 32771, 32772, 32774, 32776, 32778, 32780, 32781, 32784, 32785, 32786, 32787, 32788, 32789, 32790, 32791, 32792, 32793, 32794, 32795, 32796, 32798, 32799, 32801, 32802, 32803, 32804, 32808, 32810, 32816, 32821, 32824, 32828, 32833, 32841, 32843, 32865, 32869, 32871, 32877, 32887, 32897, 32914, 32918, 32921, 32923, 32925, 32929, 32934, 32938, 32943, 32948, 32959, 32961, 32973, 32992, 32995, 33000, 33004, 33009, 33013, 33016, 33021, 33023, 33030, 33040, 33043, 33058, 33065, 33068, 33076, 33098, 33115, 33125, 33132, 33146, 33155, 33164, 33167, 33171, 33182, 33190) 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 Recruiting Officer

Afterpiece Title: Don Quixote

Cast
Role: Sancho Actor: Costollo

Dance: I: A Hornpipe-the Little Swiss; II: A Comic Dance-Harvey, Miss Shawford; III: A Dance-Sg Piettro, Mad Janeton Auretti; IV: A Scotch Dance-Harvey, Miss Shawford; V: The Minuet, Louvre-Harvey, Mrs Addison

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Don Quixote

Cast
Role: Sancho Actor: Costollo

Dance: II: The Pierrots-Roger, Shawford Jun; III: A Scotch Dance, as17520427 IV: A Hornpipe-Shawford Jun; V: A Comic Dance-Shawford Jun, Miss Shawford

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Don Quixote

Cast
Role: Sancho Actor: Costollo

Dance: IV: A Hornpipe-the Little Swiss; V: A Comic Dance-Shawford Jun, Miss Shawford

Song: III: Mattocks

Performances

Mainpiece Title: Every Man In His Humour

Cast
Role: Formal Actor: Costollo

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Knights

Cast
Role: Tim Actor: Costollo

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Knights

Cast
Role: Tim Actor: Costollo

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Knights

Cast
Role: Tim Actor: Costollo

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Knights

Cast
Role: Tim Actor: Costollo

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Knights

Cast
Role: Tim Actor: Costollo

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Knights

Dance: LLes Taileurs, as17531210; Les Charboniers, as17540307

Performances

Mainpiece Title: Othello

Afterpiece Title: The Knights

Dance: LLes Taileurs, as17531210

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Knights

Performances

Mainpiece Title: The Constant Couple; Or, A Trip To The Jubilee

Cast
Role: Dicky Actor: Costollo

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: The Englishman in Paris

Cast
Role: Subtle Actor: Costollo

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Dicky Actor: Costollo

Afterpiece Title: The Lying Valet

Performances

Mainpiece Title: The Relapse

Cast
Role: Shoemaker Actor: Costollo

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: The Constant Couple

Cast
Role: Dicky Actor: Costollo

Afterpiece Title: The Contrivances

Dance: As17541203

Performances

Mainpiece Title: Coriolanus; Or, The Roman Matron

Performances

Mainpiece Title: Coriolanus

Performances

Mainpiece Title: Coriolanus

Dance: As17541203

Performances

Mainpiece Title: The Recruiting Officer

Cast
Role: Recruits Actor: Bencraft, Costollo

Afterpiece Title: The What D'ye Call It

Performances

Mainpiece Title: Coriolanus

Dance: As17541203

Performances

Mainpiece Title: Coriolanus

Dance: As17541203

Performances

Mainpiece Title: Coriolanus

Dance: As17541203

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Schoolboy

Dance: As17541203