SELECT * FROM london_stages WHERE eventid IN (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, 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: The Road To Ruin

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Love In A Village

Cast
Role: Cook Actor: Rock

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Relief of Williamstadt; or, The Return from Victory

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: _Cross, _Rock

Dance: In 2nd piece: Byrn, Holland, Mrs Watts, Mme Rossi

Entertainment: Monologue. A new Occasional Address in the character of Goldfinch ,-Lewis

Performances

Mainpiece Title: The Governor

Afterpiece Title: Hartford Bridge

Afterpiece Title: The Relief of Williamstadt

Cast
Role: Travellers Actor: _Cross, _Rock

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: The Armourer

Afterpiece Title: Lovers' Quarrels

Cast
Role: Don Alvarez Actor: Rock

Performances

Mainpiece Title: The Armourer

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Armourer

Afterpiece Title: The Irishman in London

Performances

Mainpiece Title: Fashionable Levities

Afterpiece Title: Rosina

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

Cast
Role: Roger Actor: Rock
Role: Cook Actor: Mrs Rock

Entertainment: Monologue. Preceding 1st piece: An Eulogium on Money-Quick

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: The Invasion

Cast
Role: Roger Actor: Rock
Role: Cook Actor: Mrs Rock

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: The Lying Valet

Cast
Role: Mrs Gadabout Actor: Mrs Rock

Dance: End: The Bouquet-Byrn, Mme Rossi

Song: III: a song in character-Mrs Clendining

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Cast
Role: Maid Actor: Mr Rock

Afterpiece Title: True Blue

Afterpiece Title: The Sultan

Dance: In 3rd piece: As17921003; In 2nd piece: Hornpipe, as17930411

Entertainment: Monologue End 2nd piece: Collins's Ode on the Passions-Mrs Esten

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Poor Soldier

Cast
Role: Father Luke Actor: Rock

Dance: End: The Bouquet, as17930415

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Planters Actor: Evatt, Rock, Thompson

Afterpiece Title: Money at a Pinch; or, The Irishman's Frolicks

Dance: End: The Merry Sailors-

Song: In afterpiece: the following songs (incidental to the Piece) The Row, The Land of Potatoes, My sweetest Honoria (to a favorite air of Carolan's)-Johnstone

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Invasion

Cast
Role: Roger Actor: Rock
Role: Cook Actor: Mrs Rock

Dance: As17930418

Performances

Mainpiece Title: May Day; Or, The Little Gipsey

Afterpiece Title: Fashionable Levities

Cast
Role: Roger Actor: Rock
Role: Cook Actor: Mrs Rock

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: _Cross, _Rock

Dance: As17921116

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Rosina

Cast
Role: Roger Actor: Rock
Role: Cook Actor: Mrs Rock

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Hartford Bridge

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

Dance: Scotch Divertisement-Byrn, Holland, Mme Rossi; In afterpiece: The Lucky Escape, as17921116

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: _Cross, _Rock

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Ben Budge Actor: Rock

Afterpiece Title: The Sailor's Festival; or, All Alive at Portsmouth

Afterpiece Title: Catherine and Petruchio

Cast
Role: Biondello Actor: Rock

Dance: III: Hornpipe, as17920920

Song: End I: Black Eyed Susan-Incledon

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Planters Actor: Evatt, Rock, Thompson

Afterpiece Title: The Soldier's Festival

Afterpiece Title: The Poor Soldier

Cast
Role: Father Luke Actor: Rock

Music: End: a concerto of his own composition, on the Grand Piano Forte-King (1st appearance in public)

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: Catherine and Petruchio

Cast
Role: Biondello Actor: Rock

Song: In course: The Mid Watch-Incledon

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: The Sailor's Festival

Cast
Role: Biondello Actor: Rock

Afterpiece Title: The Follies of A Day

Song: III: a song-Mrs Clendining

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