SELECT * FROM london_stages WHERE eventid IN (359, 365, 876, 992, 1338, 1402, 1877, 2983, 3601, 3755, 3837, 4014, 4216, 4241, 5841, 7865, 7893, 7936, 8015, 8066, 8099, 8135, 8263, 8372, 8505, 8625, 12342, 12345, 13083, 13087, 13119, 13202, 13421, 13515, 13553, 13592, 13702, 13719, 13817, 13860, 13904, 13926, 13933, 13951, 13955, 13974, 14003, 14041, 14060, 14076, 14080, 14173, 14718, 14726, 14841, 15085, 15163, 15448, 15561, 15651, 15760, 15887, 15968, 16034, 16074, 16080, 16084, 16215, 16458, 16571, 16658, 16809, 17045, 17075, 17221, 17410, 17422, 17456, 17498, 17586, 17587, 17703, 17770, 17874, 17895, 17983, 18049, 18874, 18996, 19156, 19224, 19261, 19272, 19360, 19434, 19468, 19550, 19605, 19641, 19756, 19770, 19871, 20043, 20099, 20127, 20185, 20270, 20294, 20507, 20558, 20618, 20665, 20722, 20775, 20852, 20967, 21041, 21107, 21165, 21266, 21311, 21334, 21419, 21817, 21854, 21899, 21961, 21962, 21978, 22075, 22121, 22153, 22164, 22169, 22290, 22291, 22292, 22348, 22383, 22461, 22517, 22577, 22790, 22842, 22860, 22949, 22953, 23016, 23292, 23318, 23350, 23379, 23423, 23486, 23491, 23634, 23804, 23836, 23896, 23915, 23952, 23954, 23956, 23958, 23962, 23965, 23984, 24011, 24049, 24082, 24104, 24118, 24119, 24194, 24295, 24325, 24349, 24471, 24517, 24567, 24685, 24686, 24689, 24874, 24881, 24923, 24968, 25025, 25057, 25139, 25197, 25259, 25335, 25386, 25447, 25468, 25663, 25667, 25710, 25734, 25780, 26085, 26095, 26116, 26217, 26263, 26285, 26335, 26549, 26589, 26687, 26712, 26862, 26956, 27035, 27200, 27215, 27231, 27532, 27580, 27736, 27966, 28025, 28041, 28102, 28111, 28390, 28450, 28525, 28628, 28645, 28680, 28742, 28840, 28911, 28962, 29015, 29063, 29070, 29206, 29328, 29422, 29461, 29508, 29528, 30034, 30294, 30353, 30379, 30404, 30549, 30599, 30632, 30633, 30636, 30646, 30658, 30701, 30789, 30793, 30837, 30840, 30914, 30922, 30980, 31019, 31028, 31133, 31189, 31231, 31240, 31338, 31342, 31352, 31387, 31407, 31477, 31667, 31696, 31718, 31731, 31759, 32165, 32191, 32316, 32391, 32528, 32530, 32533, 32536, 32539, 32542, 32808, 32877, 33190, 33318, 33490, 33631, 33658, 33667, 33681, 33685, 33693, 33698, 33702, 33707, 33710, 33713, 33717, 33721, 33889, 33915, 33940, 33960, 34045, 34067, 34069, 34072, 34166, 34203, 34204, 34234, 34537, 34628, 34651, 34708, 34860, 34876, 34889, 34947, 35004, 35084, 35139, 35308, 35355, 35359, 35508, 35625, 35743, 35923, 35994, 36112, 36206, 36227, 36393, 36422, 36430, 36470, 36471, 36478, 36522, 36675, 36678, 36680, 36681, 36682, 36684, 36690, 36692, 36698, 36708, 36712, 36714, 36728, 36756, 36769, 36770, 36812, 36828, 36858, 36867, 36888, 36895, 36909, 37018, 37046, 37092, 37098, 37108, 37165, 37172, 37208, 37248, 37272, 37282, 37292, 37301, 37310, 37311, 37338, 37373, 37402, 37528, 37594, 37616, 37629, 37630, 37648, 37667, 37673, 37774, 37778, 37781, 37783, 37785, 37787, 37790, 37793, 37797, 37803, 37805, 37809, 37821, 37825, 37827, 37829, 37831, 37833, 37835, 37839, 37841, 37852, 37856, 37860, 37864, 37870, 37874, 37882, 37887, 37893, 37902, 37905, 37911, 37925, 37930, 37935, 37937, 37941, 37943, 37947, 37949, 37957, 37962, 37982, 37996, 38045, 38050, 38051, 38053, 38091, 38097, 38106, 38107, 38123, 38153, 38158, 38160, 38167, 38172, 38183, 38191, 38202, 38227, 38233, 38310, 38323, 38341, 38484, 38669, 38717, 38724, 38740, 38745, 38760, 38768, 38856, 38898, 39003, 39247, 39268, 39320, 39337, 39689, 39814, 39849, 39863, 39868, 39873, 39880, 39886, 39891, 39907, 39946, 40019, 40038, 40120, 40143, 40167, 40182, 40189, 40396, 40405, 40440, 40554, 40558, 40644, 40896, 40926, 40930, 40938, 40957, 40979, 40986, 41067, 41077, 41088, 41114, 41157, 41162, 41260, 41290, 41444, 41445, 41559, 41696, 41731, 41748, 41861, 41891, 41897, 41934, 42046, 42053, 42097, 42133, 42147, 42165, 42166, 42284, 42298, 42335, 42338, 42376, 42392, 42411, 42415, 42419, 42439, 42480, 42531, 42622, 42698, 42738, 42753, 42754, 42762, 42780, 42788, 42830, 42867, 42869, 42871, 42872, 42873, 42883, 42899, 42905, 42908, 42910, 42916, 42918, 42922, 42924, 42930, 42932, 42934, 42935, 42936, 42940, 42941, 42944, 42946, 42948, 42951, 42956, 42958, 42960, 42965, 42970, 42977, 42979, 42982, 42986, 42988, 42992, 42997, 42999, 43001, 43006, 43011, 43030, 43056, 43072, 43077, 43101, 43120, 43141, 43154, 43158, 43172, 43180, 43191, 43204, 43217, 43255, 43314, 43325, 43330, 43432, 43439, 43440, 43441, 43454, 43470, 43478, 43485, 43487, 43500, 43510, 43521, 43529, 43545, 43559, 43562, 43572, 43582, 43605, 43614, 43689, 43702, 43712, 43722, 43746, 43779, 43792, 43824, 43833, 43844, 43863, 43867, 43886, 43900, 43936, 43963, 43976, 44031, 44058, 44076, 44085, 44089, 44102, 44117, 44119, 44131, 44145, 44171, 44263, 44265, 44270, 44275, 44277, 44284, 44293, 44296, 44303, 44332, 44345, 44358, 44379, 44389, 44391, 44392, 44407, 44426, 44434, 44449, 44452, 44457, 44464, 44467, 44505, 44516, 44542, 44590, 44638, 44654, 44662, 44686, 44747, 44789, 44791, 44799, 44813, 44815, 44822, 44828, 44831, 44844, 44880, 44939, 44959, 44964, 44968, 44990, 44992, 44996, 45001, 45006, 45018, 45027, 45031, 45035, 45135, 45136, 45146, 45158, 45164, 45167, 45169, 45174, 45176, 45178, 45179, 45180, 45181, 45184, 45188, 45192, 45196, 45204, 45208, 45213, 45216, 45222, 45228, 45232, 45234, 45240, 45241, 45244, 45248, 45252, 45257, 45262, 45271, 45274, 45280, 45290, 45295, 45307, 45330, 45338, 45344, 45356, 45399, 45412, 45415, 45433, 45444, 45454, 45459, 45470, 45490, 45497, 45500, 45504, 45521, 45531, 45552, 45557, 45562, 45573, 45579, 45586, 45698, 45700, 45707, 45719, 45724, 45745, 45783, 45801, 45888, 45892, 45928, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46035, 46040, 46090, 46124, 46138, 46146, 46171, 46275, 46287, 46289, 46327, 46329, 46347, 46367, 46385, 46387, 46421, 46438, 46474, 46490, 46505, 46533, 46607, 46624, 46627, 46642, 46647, 46675, 46678, 46700, 46702, 46711, 46716, 46722, 46725, 46726, 46729, 46737, 46743, 46761, 46836, 46838, 46899, 46903, 46923, 46941, 46953, 46955, 46961, 46963, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47068, 47079, 47081, 47091, 47179, 47202, 47212, 47238, 47253, 47261, 47263, 47295, 47304, 47312, 47437, 47439, 47470, 47472, 47499, 47509, 47529, 47533, 47541, 47566, 47570, 47575, 47647, 47651, 47655, 47657, 47683, 47685, 47696, 47737, 47749, 47752, 47782, 47797, 47813, 47823, 47828, 47843, 47848, 47858, 47872, 47887, 47892, 47894, 47898, 48002, 48006, 48009, 48017, 48026, 48052, 48055, 48069, 48087, 48101, 48105, 48142, 48341, 48365, 48395, 48396, 48409, 48423, 48437, 48539, 48549, 48555, 48563, 48575, 48579, 48583, 48585, 48603, 48605, 48613, 48634, 48647, 48664, 48675, 48705, 48712, 48732, 48737, 48752, 48754, 48755, 48757, 48759, 48761, 48766, 48767, 48769, 48771, 48774, 48775, 48777, 48779, 48781, 48783, 48785, 48787, 48789, 48791, 48793, 48796, 48798, 48801, 48803, 48805, 48810, 48812, 48815, 48817, 48819, 48821, 48826, 48828, 48830, 48835, 48851, 48856, 48860, 48865, 48870, 48872, 48877, 48902, 48916, 48923, 48930, 48933, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 48995, 48998, 49000, 49004, 49006, 49009, 49014, 49018, 49021, 49023, 49028, 49033, 49038, 49041, 49053, 49056, 49061, 49066, 49077, 49081, 49083, 49086, 49090, 49097, 49100, 49120, 49184, 49191, 49199, 49214, 49232, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49422, 49425, 49432, 49439, 49445, 49449, 49452, 49454, 49462, 49465, 49577, 49585, 49609, 49620, 49637, 49642, 49646, 49657, 49664, 49667, 49759, 49772, 49791, 49801, 49813, 49853, 49924, 49929, 49963, 50084, 50092, 50113, 50141, 50223, 50324, 50345, 50366, 50480, 50572, 50597, 50600, 50605, 50607, 50611, 50616, 50628, 50632, 50638, 50640, 50714, 50724, 50728, 50733, 50736, 50742, 50744, 50757, 50764, 50794, 50795, 50802, 50811, 50897, 50917, 50919, 50921, 50941, 50945, 50989, 51028, 51066, 51073, 51138, 51218, 51252, 51258, 51263, 51290, 51300, 51304, 51333, 51376, 51457, 51468, 51481, 51488, 51586, 51588, 51590, 51592, 51595, 51678, 51755, 51765, 51767, 51771, 51845, 51854, 51883, 51949, 52040, 52043, 52062, 52070, 52118, 52155, 52196, 52225, 52284, 52473, 52486, 52556, 52558, 52559, 52560, 52561, 52563, 52564, 52566, 52568, 52579, 52581, 52584, 52585, 52588, 52589, 52590, 52591, 52592, 52593, 52595, 52597, 52598, 52599, 52604, 52615) 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: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: Harlequin Grand Volgi

Dance: V: Le Tambourine-Mlle Chateauneuf

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Fortune Tellers

Ballet: AA Voyage to the Land of Cytherea. As17400115

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Tragedy of Tragedies

Dance: I: Le Tambourine-Mlle Chateauneuf; III: Comic Pantomime Dance-Lalauze, Mlle Chateauneuf; IV: Muilment; V: La Matelote-Desnoyer, Mlle Chateauneuf

Music: Kettle Drum-Master Ferg

Song: II: Beard

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Mock Doctor

Dance: II: Le Tambourine-Mlle Chateauneuf; III: Wooden Shoe-Master Ferg

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Dance: Muilment, Mlle Chateauneuf

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Neale

Afterpiece Title: Nancy; or, The Parting Lovers

Dance: As17401023

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Virgin Unmask'd

Dance: III: Ballet-Desse; V: Ethiopian-Muilment

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Peterson

Afterpiece Title: The Virgin Unmask'd

Dance: III: A new dance-Master Matthews; V: Drunken Peasant and Clown-Master Matthews, Master Shawford

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Peterson

Afterpiece Title: The Virgin Unmask'd

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Virgin Unmask'd

Dance: II: L'Arlequine deux visages-Mlle Chateauneuf; III: La Tambourin Matelote-Maltere, Mlle Maltere; IV: L'Allemande-Muilment, Mlle Chateauneuf; V: La Tambourine-Mlle Chateauneuf

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Whim; or, The Merry Cheat

Cast
Role: Trickwell Actor: Mullart

Song: Leveridge, Salway

Dance: Glover, Mlle Roland, Mechel

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Lover's Opera

Dance: I: Indian Dance-Maltere; II: La Tambourine-Mlle Chateauneuf; IV: L'Allemande-Muilment, Mlle Chateauneuf; End Afterpiece: The Dance in The Beggar's Opera-Mrs Clive, Lowe

Song: III: Blow Blow-Lowe; V: See from the Silent Groves-Savage

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The King and Miller of Mansfield

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Woodward

Afterpiece Title: The Royal Chace

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Macklin

Dance: LLes Matelotes, as17411110; Le Genereux Corsaire, as17411102

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Fortune Tellers

Song: I: Happy Pair-Beard; III: Early Horn-Lowe

Dance: II: A Dutch Dance, as17411114; IV: Matelote Polonnes-Mechel

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: a Ballad-Lowe

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Woodward

Dance: As17420213

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The Virgin Unmasked

Song: I: Song with French Horns-Beard; III: a Ballad-Lowe; IV: Song-Mrs Arne

Dance: II: A Concerto, as17420105; V: The Italian Peasants, as17411205

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Macklin

Afterpiece Title: The King and Miller of Mansfield

Song: IV: Bumper Squire Jones-Beard

Dance: I: a New Scots Dance-Miss Scott; II: a New Comic Dance-Froment, Miss Scott; III: Running Footman's Dance, as17420428

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Woodward

Dance: SScots Dance-Sga Barbarina; Les Savoyardes, as17420501; La Provencale, as17420212

Ballet: RRural Assembly. As17420508

Performances

Mainpiece Title: The Indian Merchant; Or, The Happy Pair; Interspers'd With The Comical Humours Of The intriguing Chambermaid, sir John Oldcastle, And The drunken Colonel

Cast
Role: Trick Actor: Evenel

Afterpiece Title: The Miser Bit; or, Harlequin Reveller

Song: I: Bumper Squire Jones-Phillips

Dance: LLa Mason and Sabotiers-Phillips, Mrs Dove

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Woodward

Dance: As17421026

Performances

Mainpiece Title: Hamlet

Cast
Role: Ostrick Actor: Woodward

Dance: TThe Happy Lovers, as17421006; Characters of Dancing, as17421025; Grand Comic Ballet, as17430407

Performances

Mainpiece Title: Hamlet, Prince Of Denmark

Cast
Role: Ostrick Actor: Woodward