SELECT * FROM london_stages WHERE eventid IN (4608, 44645, 44654, 44668, 44696, 44780, 44857, 44887, 44927, 44949, 44964, 44966, 45032, 45135, 45150, 45154, 45186, 45190, 45194, 45198, 45200, 45202, 45210, 45212, 45220, 45236, 45238, 45246, 45250, 45255, 45260, 45264, 45269, 45276, 45278, 45283, 45285, 45287, 45289, 45291, 45293, 45295, 45297, 45300, 45305, 45310, 45314, 45316, 45319, 45324, 45326, 45328, 45333, 45335, 45342, 45347, 45349, 45352, 45354, 45361, 45365, 45369, 45378, 45384, 45386, 45390, 45397, 45403, 45407, 45410, 45416, 45420, 45425, 45429, 45436, 45438, 45440, 45442, 45449, 45461, 45464, 45469, 45472, 45482, 45487, 45497, 45500, 45502, 45511, 45517, 45526, 45534, 45537, 45539, 45542, 45547, 45554, 45559, 45562, 45567, 45574, 45584, 45589, 45591, 45693, 45696, 45704, 45709, 45716, 45717, 45719, 45722, 45726, 45735, 45740, 45748, 45754, 45756, 45758, 45759, 45761, 45763, 45765, 45767, 45769, 45775, 45777, 45781, 45785, 45787, 45791, 45793, 45807, 45815, 45823, 45829, 45833, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45871, 45874, 45878, 45880, 45883, 45885, 45890, 45892, 45894, 45897, 45899, 45902, 45904, 45906, 45911, 45914, 45916, 45918, 45920, 45925, 45928, 45930, 45932, 45934, 45937, 45939, 45944, 45948, 45951, 45958, 45962, 45965, 45967, 45975, 45980, 45988, 45993, 45997, 46002, 46007, 46011, 46018, 46020, 46024, 46028, 46031, 46033, 46036, 46038, 46040, 46042, 46045, 46047, 46050, 46052, 46055, 46058, 46060, 46063, 46065, 46068, 46070, 46073, 46078, 46080, 46083, 46085, 46088, 46090, 46093, 46098, 46100, 46103, 46109, 46112, 46121, 46124, 46127, 46133, 46146, 46148, 46154, 46166, 46169, 46171, 46174, 46176, 46178, 46273, 46275, 46281, 46286, 46287, 46289, 46294, 46295, 46299, 46303, 46307, 46309, 46313, 46315, 46317, 46319, 46321, 46323, 46327, 46329, 46331, 46333, 46336, 46338, 46341, 46343, 46345, 46347, 46349, 46351, 46355, 46365, 46367, 46369, 46373, 46375, 46381, 46385, 46387, 46395, 46397, 46401, 46407, 46409, 46411, 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, 46474, 46476, 46478, 46481, 46486, 46490, 46492, 46495, 46497, 46502, 46504, 46509, 46511, 46515, 46522, 46529, 46533, 46536, 46543, 46547, 46550, 46552, 46557, 46561, 46564, 46566, 46571, 46575, 46585, 46590, 46593, 46595, 46600, 46604, 46607, 46609, 46612, 46617, 46622, 46624, 46627, 46634, 46637, 46639, 46642, 46647, 46652, 46654, 46657, 46659, 46661, 46663, 46666, 46671, 46673, 46676, 46678, 46681, 46686, 46688, 46691, 46695, 46697, 46700, 46702, 46705, 46708, 46711, 46713, 46718, 46721, 46723, 46725, 46726, 46728, 46729, 46731, 46732, 46734, 46737, 46743, 46761, 46771, 46836, 46838, 46841, 46844, 46846, 46847, 46849, 46852, 46854, 46855, 46858, 46861, 46863, 46865, 46867, 46877, 46879, 46881, 46883, 46887, 46889, 46895, 46899, 46901, 46903, 46905, 46909, 46911, 46917, 46923, 46937, 46941, 46949, 46951, 46955, 46957, 46961, 46963, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47001, 47003, 47005, 47007, 47009, 47011, 47013, 47015, 47017, 47019, 47021, 47023, 47025, 47027, 47029, 47031, 47033, 47035, 47037, 47039, 47041, 47045, 47049, 47053, 47055, 47061, 47063, 47068, 47076, 47079, 47081, 47083, 47086, 47088, 47091, 47093, 47096, 47098, 47101, 47104, 47108, 47114, 47117, 47119, 47124, 47128, 47131, 47133, 47139, 47144, 47148, 47150, 47156, 47161, 47165, 47173, 47179, 47183, 47186, 47198, 47202, 47204, 47209, 47212, 47218, 47224, 47226, 47229, 47231, 47235, 47238, 47242, 47244, 47247, 47249, 47253, 47255, 47261, 47264, 47266, 47270, 47273, 47277, 47279, 47283, 47285, 47289, 47295, 47297, 47304, 47309, 47312, 47314, 47320, 47326, 47334, 47349, 47356, 47362, 47363, 47366, 47368, 47371, 47373, 47376, 47380, 47383, 47386, 47387, 47388, 47389, 47390, 47391, 47392, 47393, 47395, 47396, 47397, 47399, 47401, 47403, 47405, 47407, 47409, 47410, 47411, 47412, 47413, 47414, 47415, 47417, 47418, 47419, 47422, 47424, 47434, 47437, 47439, 47441, 47442, 47444, 47449, 47451, 47456, 47458, 47459, 47464, 47467, 47472, 47475, 47482, 47484, 47487, 47491, 47495, 47497, 47499, 47505, 47507, 47509, 47511, 47515, 47519, 47527, 47529, 47531, 47533, 47539, 47541, 47543, 47545, 47547, 47549, 47551, 47553, 47555, 47557, 47559, 47566, 47568, 47570, 47575, 47580, 47582, 47584, 47586, 47589, 47591, 47593, 47595, 47597, 47600, 47603, 47605, 47607, 47609, 47611, 47614, 47616, 47619, 47621, 47623, 47625, 47628, 47631, 47633, 47635, 47637, 47639, 47641, 47643, 47647, 47649, 47651, 47655, 47657, 47659, 47661, 47665, 47670, 47674, 47678, 47680, 47683, 47685, 47688, 47690, 47693, 47696, 47700, 47704, 47707, 47709, 47714, 47719, 47722, 47724, 47729, 47734, 47737, 47739, 47744, 47749, 47752, 47754, 47759, 47764, 47769, 47774, 47779, 47782, 47784, 47787, 47789, 47792, 47794, 47797, 47800, 47805, 47808, 47810, 47813, 47815, 47820, 47823, 47825, 47828, 47830, 47835, 47838, 47843, 47845, 47848, 47850, 47858, 47860, 47867, 47872, 47877, 47882, 47885, 47887, 47892, 47894, 47896, 47997, 47999, 48000, 48002, 48004, 48006, 48012, 48015, 48017, 48023, 48026, 48029, 48032, 48036, 48039, 48045, 48051, 48053, 48055, 48057, 48061, 48062, 48064, 48066, 48070, 48072, 48074, 48076, 48078, 48082, 48084, 48086, 48088, 48093, 48095, 48097, 48099, 48101, 48105, 48111, 48113, 48115, 48117, 48119, 48123, 48125, 48129, 48133, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48176, 48178, 48180, 48182, 48192, 48303, 48306, 48313, 48315, 48317, 48320, 48322, 48334, 48339, 48341, 48354, 48358, 48366, 48368, 48372, 48377, 48384, 48396, 48409, 48411, 48416, 48418, 48421, 48423, 48427, 48430, 48432, 48437, 48439, 48443, 48444, 48447, 48536, 48543, 48549, 48551, 48553, 48555, 48569, 48575, 48581, 48583, 48588, 48602, 48603, 48605, 48608, 48609, 48611, 48613, 48618, 48620, 48621, 48623, 48628, 48631, 48634, 48637, 48650, 48654, 48657, 48659, 48662, 48664, 48665, 48667, 48669, 48672, 48675, 48677, 48679, 48685, 48687, 48689, 48692, 48695, 48697, 48699, 48704, 48705, 48707, 48708, 48709, 48712, 48714, 48722, 48724, 48727, 48729, 48732, 48734, 48735, 48737, 48739, 48744, 48747, 48749, 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, 48824, 48826, 48828, 48830, 48832, 48835, 48837, 48851, 48856, 48858, 48860, 48865, 48870, 48872, 48874, 48877, 48879, 48882, 48884, 48887, 48890, 48892, 48896, 48899, 48902, 48909, 48913, 48916, 48918, 48923, 48927, 48930, 48933, 48945, 48952, 48959, 48961, 48980, 48986, 48988, 48990, 48993, 48995, 48998, 49000, 49004, 49007, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49043, 49046, 49051, 49053, 49056, 49058, 49061, 49066, 49069, 49077, 49081, 49083, 49086, 49088, 49090, 49092, 49100, 49184, 49191, 49193, 49195, 49197, 49199, 49203, 49206, 49214, 49232, 49238, 49240, 49242, 49246, 49248, 49250, 49254, 49260, 49268, 49270, 49272, 49274, 49276, 49278, 49280, 49282, 49284, 49286, 49288, 49290, 49292, 49294, 49296, 49298, 49300, 49305, 49307, 49310, 49312, 49314, 49316, 49319, 49321, 49324, 49328, 49330, 49333, 49335, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49364, 49366, 49368, 49371, 49373, 49376, 49378, 49380, 49382, 49385, 49387, 49390, 49392, 49394, 49396, 49399, 49401, 49406, 49408, 49411, 49413, 49416, 49418, 49420, 49422, 49425, 49427, 49430, 49432, 49434, 49436, 49439, 49441, 49445, 49449, 49452, 49454, 49458, 49462, 49465, 49467, 49475, 49480, 49490, 49493, 49495, 49500, 49504, 49507, 49509, 49513, 49517, 49522, 49525, 49527, 49529, 49531, 49534, 49536, 49539, 49541, 49543, 49545, 49548, 49550, 49553, 49558, 49563, 49565, 49568, 49585, 49599, 49604, 49609, 49614, 49616, 49620, 49622, 49627, 49630, 49635, 49637, 49642, 49646, 49650, 49655, 49657, 49659, 49662, 49664, 49667) 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: Every One Has His Fault

Afterpiece Title: The Pad

Afterpiece Title: The Shipwreck; or, French Ingratitude

Cast
Role: Female Savage Actor: Mr Rock.

Song: End: Captivity (Supposed to be sung by an Unfortunate Queen [Marie Antoinette] during her confinement)-; End 2nd piece: Black Eyed Susan-; In 3rd piece: Farewell to old England dear Mary adieu-Incledon

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Afterpiece Title: The Shipwreck

Cast
Role: Female Savage Actor: Mr Rock.

Song: In 3rd piece: Farewell to old England dear Mary adieu, as17930527

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Lying Valet

Cast
Role: Mrs Gadabout Actor: Mrs Rock

Dance: As17930525

Performances

Mainpiece Title: As You Like It

Cast
Role: Audrey Actor: Mrs Rock

Afterpiece Title: Love in a Camp

Cast
Role: Father Luke Actor: Rock

Dance: End I: Scotch Divertisement, as17930504; In V: Dance of Forresters, as17921010; End: The Wapping Landlady, as17921106

Performances

Mainpiece Title: Love In A Village

Cast
Role: Cook Actor: Rock

Afterpiece Title: The Sultan

Dance: As17921003

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Sailor's Festival

Cast
Role: Biondello Actor: Rock

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: Farley, _Powel, _Cross, _Rock

Dance: In 3rd piece: The Lucky Escape, as17921116

Song: End II: Black Eyed Susan, as17930510; III: a song in character-Miss Barnett

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Rapino Actor: Rock

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: Fashionable Levities

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: Love in a Camp

Cast
Role: Father Luke Actor: Rock

Afterpiece Title: Oscar and Malvina

Song: In course: a favorite Sea Song-Incledon

Music: 4th piece: The Harp-Weippert

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: The Prisoner at Large

Cast
Role: Tough Actor: Rock

Performances

Mainpiece Title: Columbus

Afterpiece Title: The Pad

Cast
Role: Female Savage Actor: Mr Rock.

Afterpiece Title: The Shipwreck

Cast
Role: Female Savage Actor: Mr Rock.

Song: End of 1st piece: Dibdin's song; The Lucky Escape; or, The Ploughboy's Return from Sea in character-Mrs Harlowe; End of 2nd piece: Sally in our Alley-Marshall; In 3rd piece: Farewell to old England dear Mary adieu-Incledon; Rule Britannia-Marshall, full Chorus; In the course of the Evening: Black eyed Susan-Incledon

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: Farley, _Powel, _Cross, _Rock

Dance: As17921116

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Robin Hood

Cast
Role: Annette Actor: Mrs Rock

Song: End I: Salley in our Alley-Incledon

Entertainment: Monologue. End: as17930323

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Maid Actor: Mr Rock

Afterpiece Title: Tom Thumb

Dance: End: The Wapping Landlady-Blurton, King, Mrs Watts

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Rapino Actor: Rock

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Poor Soldier

Cast
Role: Father Luke Actor: Rock

Performances

Mainpiece Title: How To Grow Rich

Entertainment: Afterpiece: [To conclude with Three Entire New Scenes, representing the Town and Harbour of Toulon; with a View of the Manoeuvring of the British, Spanish, and French Fleets, after the Surrender of the Town and Fortifications to the English] on the Twenty-ninth of August [1793]. In which, When in War on the Ocean-Davies; an Entire New Song [composed by Shield,-Incledon; The Music- [Selected by Shaw from Pepusch, Dr Arne, Arnold, Fisher, [Michael] Arne, Vincent, Dibdin, Reeve, Shield; The Dances-Byrn, Holland[; The Scenery-Hodgins, Walmsley, Phillips

Performances

Mainpiece Title: The Road To Ruin

Entertainment: As17931002

Performances

Mainpiece Title: Columbus; Or, A World Discovered

Afterpiece Title: Love in a Camp; or, Patrick in Prussia

Cast
Role: Father Luke Actor: Rock

Entertainment: End: As17931002

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Ben Budge Actor: Rock

Afterpiece Title: Harlequin's Chaplet

Cast
Role: Woodcutter Actor: Rock

Dance: III: a Hornpipe in Character-Byrn

Entertainment: When in War on the Ocean, as17931002; New Song-Gray in place of Incledon; The Music, as17931002; The Dances, as17931002

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Prisoner at Large

Cast
Role: Tough Actor: Rock

Song: As17931009

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Ben Budge Actor: Rock

Afterpiece Title: The Follies of a Day

Dance: As17931012

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Invasion; or, All Alarm'd at Brighthelmstone

Cast
Role: Roger Actor: Rock

Song: Vocal Parts, as17931009, but Miss Kirton, Mrs _Masters

Performances

Mainpiece Title: Lovers' Quarrels

Cast
Role: Don Alvarez Actor: Rock

Afterpiece Title: HARTFORD BRIDGE

Afterpiece Title: HARLEQUIN'S CHAPLET

Cast
Role: Woodcutter Actor: Rock

Entertainment: As17931002

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Cast
Role: Irish Haymaker Actor: Rock

Performances

Mainpiece Title: Hamlet

Afterpiece Title: THE LITTLE HUNCHBACK

Cast
Role: Doctor's Man Actor: Rock

Song: As17931021, but omitted: Williamson