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: Such Things Are

Afterpiece Title: Tony Lumpkin's Ramble to Town

Afterpiece Title: The Cozeners

Cast
Role: O'Flannagan Actor: Rock

Dance: End 1st piece: A Divertisement-Byrne, Ratchford, Mrs Ratchford, Mlle St.Amand

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Robin Hood

Cast
Role: Carpenter Actor: Rock
Role: Annette Actor: Mrs Rock

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: Modern Antiques

Cast
Role: Flounce Actor: Mrs Rock

Song: II: Grand Triumphal Entry of Alexander into Babylon-; Vocal Parts-Johnston, Incledon, Darley, Cubitt, Marshall, Gray, Rock, Rowson, Letteney, Mrs Mountain, Mrs Harlowe, Miss Broadhurst, Miss Stuart, Miss Barnett, Mrs Arnold, Mrs Cross, Mrs Powell, Miss Leserve, Mrs Watts, Mrs Gray, Miss Francis, Mrs Masters, Miss Taylor, Mrs Lloyd, Mrs Martyr; End: Wine cannot cure the Pain I endure-Johnstone, Incledon; with new Accompaniments by Shield-

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Rosina

Cast
Role: Irish Haymaker Actor: Rock

Performances

Mainpiece Title: A Day In Turkey

Afterpiece Title: The Highland Reel

Entertainment: Monologue. End: (for that night only) Collins's Ode on the Passions-Mrs Esten

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Father Luke Actor: Rock

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Zelma; or, The Will o' th' Wisp

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Zelma

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: The Farmer

Dance: End: A Divertisement, as17920410

Performances

Mainpiece Title: Love In A Village

Cast
Role: Cook Actor: Rock

Afterpiece Title: The Irishman in London; or, The Happy African

Dance: I: a Fair Scene-; Statute Dance-; End: As17920410

Song: In afterpiece: a Planxty, descriptive of Ireland If you travel the wide world all over (Morning Herald, 23 Apr.)-Johnstone in Character

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Father Luke Actor: Rock

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Marian

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Zelma

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Poor Soldier

Cast
Role: Father Luke Actor: Rock

Performances

Mainpiece Title: Notoriety

Afterpiece Title: Robin Hood

Cast
Role: Carpenter Actor: Rock
Role: Annette Actor: Mrs Rock

Entertainment: Monologues Preceding: [a New Address, She Couldn't Help It-[by Harley]; End: Collins's Ode on the Passions-Mrs Esten; [Imitations End II: Dramatic Imitations [Comic, Vocal and Tragic,-Mrs Wells

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Father Luke Actor: Rock

Music: As17920125

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Lovers' Quarrels

Cast
Role: Don Alvarez Actor: Rock

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Zelma

Performances

Mainpiece Title: Love In A Village

Cast
Role: Cook Actor: Rock

Afterpiece Title: Modern Antiques

Cast
Role: Flounce Actor: Mrs Rock

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Father Luke Actor: Rock

Music: As17920125

Performances

Mainpiece Title: Fashionable Levities

Afterpiece Title: Rosina

Cast
Role: Irish Haymaker Actor: Rock

Afterpiece Title: Modern Antiques

Cast
Role: Flounce Actor: Mrs Rock

Performances

Mainpiece Title: The Beggar's Opera

Cast
Role: Ben Budge Actor: Rock

Afterpiece Title: Love in a Camp

Cast
Role: Father Luke Actor: Rock

Dance: In III: a Hornpipe-Byrne

Song: End: Black Eyed Susan-Incledon

Performances

Mainpiece Title: Just In Time

Afterpiece Title: The Deaf Lover

Cast
Role: Maid Actor: Mrs Rock

Dance: In: Dance incidental to the piece,-Byrne, Mlle St.Amand

Entertainment: Monologue End: (by way of Epilogue) Poetical Sketch, Jemmy Jumps in the Dumps; or, A Sunday Lounge in Hyde Park-Munden

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Father Luke Actor: Rock

Music: As17920125

Performances

Mainpiece Title: The Widow Of Malabar

Cast
Role: Fatima Actor: Mrs Rock

Afterpiece Title: Catherine and Petruchio

Afterpiece Title: A Cure for a Coxcomb; or, The Beau Bedevil'd

Song: In 3rd piece: will be introduced the following Favorite songs: When virtue forms-Mrs Davis; The Bottle-Davies; The Pleasures of the Chace-Incledon; Farewell each Tonish Life-Munden; Bucket of Water, 'Tis a mighty fine thing-Johnstone; Kitty Grogan, Tho' I'm no dancing master-Johnstone; Anna's Love-Incledon; The Pig, You all must have heard-Fawcett; To-morrow, In the downhill of life-Darley; You are aw nodding-Mrs Harlowe; Coach box, You may feast your ears-Cubitt