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 (1433, 2290, 3798, 3822, 3853, 3876, 3878, 3880, 3884, 3886, 3890, 3896, 4218, 4638, 4674, 4812, 5117, 5131, 6115, 6539, 7084, 7560, 7593, 7627, 7744, 7912, 8235, 8276, 12529, 12839, 12915, 12957, 13206, 13439, 13522, 13650, 13943, 13946, 15283, 17318, 18286, 18289, 18687, 19023, 19025, 19028, 19030, 19032, 19034, 19038, 19048, 19073, 19160, 19663, 19664, 19666, 19667, 19668, 19669, 19671, 19673, 19675, 19772, 20288, 22988, 24352, 24445, 24531, 24633, 24722, 35290, 39472, 39476, 39502, 39511, 39532, 39572, 39607, 39651, 39769, 39938, 40393, 40598, 40605, 40607, 40609, 40610, 40612, 40614, 40618, 40621, 40623, 40625, 40627, 40641, 40643, 40645, 40648, 40649, 40652, 40654, 40657, 40659, 40662, 40666, 40680, 40703, 40722, 40742, 40757, 40766, 40771, 40778, 40788, 40800, 40803, 40808, 40824, 40830, 40838, 40844, 40865, 40872, 40904, 40909, 40919, 40930, 40950, 40971, 40977, 40984, 41003, 41130, 41134, 41149, 41159, 41180, 41198, 41210, 41216, 41249, 41254, 41258, 41270, 41284, 41305, 41312, 41334, 41341, 41420, 41474, 41490, 41503, 41519, 41561, 41564, 41569, 41601, 41603, 41604, 41607, 41610, 41615, 41618, 41621, 41626, 41631, 41633, 41642, 41646, 41649, 41712, 41734, 41862, 42013, 42039, 42126, 42148, 42153, 42206, 42211, 42214, 42217, 42221, 42225, 42229, 42238, 42248, 42398, 42467, 42745, 42815, 42821, 42825, 42827, 42830, 42831, 42837, 42839, 42891, 42938, 43043, 43310, 43392, 43394, 43397, 43398, 43400, 43401, 43404, 43409, 43421, 43424, 43434, 43449, 43484, 43698, 43728, 43735, 43755, 43778, 43904, 43997, 44005, 44028, 44033, 44040, 44045, 44061, 44073, 44144, 44283, 44408, 44458, 44533, 44582, 44594, 44604, 44656, 44702, 45089, 45194, 45291, 45471, 45491, 45501, 45510, 45672, 45715, 45717, 45770, 45828, 45869, 45893, 45910, 46079, 46097, 46321, 46522, 46647, 46874, 46902, 46914, 46926, 46938, 46950, 46962, 47060, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47103, 47104, 47108, 47114, 47117, 47119, 47123, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47155, 47156, 47161, 47165, 47172, 47186, 47204, 47270, 47320, 47334, 47342, 47349, 47371, 47376, 47380, 47383, 47386, 47387, 47388, 47389, 47390, 47392, 47393, 47395, 47396, 47397, 47399, 47405, 47407, 47409, 47411, 47413, 47414, 47419, 47424, 47426, 47453, 47500, 47548, 47559, 47564, 47619, 47635, 47651, 47674, 47773, 47783, 47786, 47919, 47920, 47921, 47924, 47930, 47936, 47948, 47953, 47954, 47956, 47958, 47977, 47988, 48029, 48453, 48461, 48505, 48507, 48508, 48511, 48513, 48516, 48522, 48550, 48552, 48554, 48556, 48558, 48562, 48564, 48568, 48574, 48578, 48582, 48587, 48589, 48593, 48595, 48599, 48610, 48614, 48626, 48636, 48644, 48652, 48666, 48668, 48670, 48676, 48678, 48686, 48688, 48690, 48698, 48700, 48706, 48710, 48715, 48718, 48720, 48726, 48728, 48736, 48746, 48748, 48750, 48756, 48776, 48778, 48780, 48786, 48788, 48790, 48792, 48794, 48797, 48799, 48802, 48804, 48806, 48808, 48811, 48813, 48816, 48818, 48822, 48825, 48827, 48829, 48831, 48833, 48836, 48838, 48841, 48843, 48845, 48847, 48850, 48852, 48855, 48857, 48859, 48861, 48864, 48866, 48869, 48871, 48873, 48875, 48880, 48883, 48885, 48888, 48891, 48893, 48900, 48903, 48910, 48917, 48919, 48924, 48928, 48931, 48934, 48939, 48946, 48953, 48957, 48960, 48962, 48987, 48994, 48999, 49011, 49025, 49047, 49060, 49062, 49085, 49132, 49134, 49136, 49138, 49140, 49141, 49142, 49143, 49144, 49145, 49148, 49149, 49150, 49155, 49157, 49162, 49163, 49165, 49166, 49168, 49170, 49174, 49175, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49187, 49313, 49327, 49384, 49449, 49452, 49454, 49458, 49462, 49465, 49540, 49556, 49565, 49654, 49658, 49660, 49663, 49664, 49668, 49670, 49677, 49680, 49682, 49685, 49686, 49687, 49688, 49695, 49696, 49698, 49700, 49702, 49705, 49709, 49711, 49712, 49713, 49715, 49717, 49718, 49721, 49722, 49724, 49725, 49726, 49729, 49730, 49731, 49734, 49735, 49736, 49740, 49741, 49744, 49745, 49746, 49747, 49748, 49749, 49750, 49751, 49752, 49753, 49767, 49784, 49818, 49854, 49878, 49920, 50051, 50063, 50066, 50069, 50132, 50136, 50224, 50251, 50256, 50260, 50264, 50271, 50272, 50279, 50284, 50286, 50287, 50291, 50296, 50297, 50299, 50302, 50303, 50304, 50306, 50307, 50308, 50310, 50314, 50317, 50318, 50364, 50376, 50592, 50596, 50601, 50610, 50615, 50619, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50687, 50689, 50692, 50706, 50713, 50730, 50735, 50741, 50743, 50746, 50748, 50751, 50759, 50761, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799, 50826, 50832, 50865, 50886, 50887, 50891, 50892, 50896, 50898, 50900, 50902, 50912, 50914, 50924, 50938, 50962, 50963, 51017, 51056, 51086, 51145, 51154, 51226, 51289, 51317, 51342, 51371, 51403, 51410, 51416, 51421, 51425, 51440, 51442, 51446, 51447, 51455, 51456, 51467, 51474, 51478, 51493, 51530, 51548, 51584, 51606, 51630, 51652, 51815, 51892, 51950, 51953, 51978, 51983, 51988, 52004, 52013, 52021, 52026, 52035, 52037, 52041, 52045, 52052, 52067, 52107, 52119, 52135, 52177, 52208, 52288, 52391, 52423, 52437, 52468, 52526, 52535) 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 Unhappy Favourite; Or, The Earl Of Essex

Cast
Role: Sir Walter Rawleigh Actor: Disney

Performances

Mainpiece Title: King Henry The Fourth; With The Humours Of Sir John Falstaff

Cast
Role: Sir Walter Blunt Actor: Trout

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: Mackbeth

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: Mackbeth

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Jovial Crew

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Jovial Crew

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Jovial Crew

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: Mackbeth

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Husband.

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Husband

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Young Norris

Song: Italian songs from Hydaspes-Young Boman

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Young Norris

Song: A young Gentleman for his Diversion

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Cast
Role: Sir Walter Actor: Watson

Song: Randal, the Boy; Trumpet Song-Mrs Fletcher,accompanied Mr Granno

Dance: Spanish Entry, Dutch Skipper-delaGarde, Mrs Bullock; Punchanello-Shaw

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Ogden

Dance: Serious and Comic Dancing-two Children Scholars of M Ballon, lately arriv'd from the Opera at Paris [M and Mlle Salle]; [particularly Two Punchanellos, Two Harlequins and a Dame Ragonde-; The Harlequins-the two Children

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Cast
Role: Sir Walter Actor: Ogden

Afterpiece Title: The Jealous Doctor

Performances

Mainpiece Title: The Unhappy Favourite; Or, The Earl Of Essex

Cast
Role: Sir Walter Actor: Ogden

Afterpiece Title: Venus and Adonis (Second Interlude)

Dance: As17181024

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Ogden

Afterpiece Title: Venus and Adonis (Second Interlude)

Dance: As17181209

Performances

Mainpiece Title: Sir Walter Raleigh

Cast
Role: Sir Walter Actor: Quin

Performances

Mainpiece Title: The Unhappy Favourite

Cast
Role: Sir Walter Actor: Ogden

Afterpiece Title: Hob

Dance: As17190113