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 Dramatist

Afterpiece Title: The Highland Reel

Cast
Role: Doctor's Man Actor: Rock
Role: Dominique Actor: Rock

Performances

Mainpiece Title: Robin Hood; Or, Sherwood Forest

Afterpiece Title: The Little Hunchback

Cast
Role: Doctor's Man Actor: Rock
Role: Dominique Actor: Rock

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Positive Man

Cast
Role: Maurice Actor: Rock

Dance: As17890930

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Devil upon Two Sticks

Cast
Role: Calomel Actor: Rock

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Cast
Role: Bardolph Actor: Rock

Afterpiece Title: Don Juan

Dance: As17890916

Performances

Mainpiece Title: Inkle And Yarico

Cast
Role: Patty Actor: Mrs Rock

Afterpiece Title: The Death of Captain Cook

Dance: As17891013

Performances

Mainpiece Title: The Hypocrite

Afterpiece Title: Love in a Camp

Cast
Role: Father Luke Actor: Rock

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Poor Soldier

Cast
Role: Fater Luke Actor: Rock

Dance: End IV: Tamborine Dance, as17891021

Performances

Mainpiece Title: Love In A Village

Cast
Role: Cook Actor: Rock

Afterpiece Title: The Miser

Cast
Role: Lawyer Actor: Rock

Dance: End II: Tamborine Dance, as17891021

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Highland Reel

Cast
Role: Doctor's Man Actor: Rock
Role: Dominique Actor: Rock

Song: Juliet's Funeral Procession-; Dirge-; Vocal Parts, as17890914, but W. _Thompson, Duffey, Mrs _Powell

Performances

Mainpiece Title: Marcella

Afterpiece Title: Rosina

Cast
Role: Irish Haymaker Actor: Rock

Afterpiece Title: The Death of Captain Cook

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Nunnery

Cast
Role: Monks Actor: Rock, Ledger, Evatt

Dance: As17891021

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Dimity Actor: Mrs Rock

Dance: As17891021

Performances

Mainpiece Title: Marcella

Afterpiece Title: The Citizen

Cast
Role: Dapper Actor: Rock

Dance: End afterpiece: A Grand Ballet of Action, as performed at the King's Opera House in the Hay-market [most recently in season of 1787-88] The Deserter[. Principal Characters-Cranfield, Delpini, Boyce, Byrne, Mrs Davenett, the two Miss Simonets (1st appearance [at this theatre])

Performances

Mainpiece Title: The Lady Of The Manor

Afterpiece Title: Animal Magnetism

Cast
Role: Picard Actor: Rock

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Poor Soldier

Cast
Role: Fater Luke Actor: Rock

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Miser

Cast
Role: Lawyer Actor: Rock

Performances

Mainpiece Title: The Dramatist

Afterpiece Title: The Highland Reel

Cast
Role: Doctor's Man Actor: Rock
Role: Dominique Actor: Rock

Performances

Mainpiece Title: As You Like It

Cast
Role: Audrey Actor: Mrs Rock

Afterpiece Title: Bon Ton

Dance: End I: Divertissement-[See17891002]; End: Tamborine Dance, as17891021

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Cast
Role: Dimity Actor: Mrs Rock

Dance: As17891125

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Chambermaid Actor: Mrs Rock

Afterpiece Title: The Poor Soldier

Cast
Role: Fater Luke Actor: Rock

Performances

Mainpiece Title: Robin Hood

Cast
Role: Annette Actor: Mrs Rock.

Afterpiece Title: The Follies of a Day

Afterpiece Title: Thomasand Sally

Dance: 3rd piece to Conclude: a Dance-

Performances

Mainpiece Title: As You Like It

Cast
Role: Audrey Actor: Mrs Rock

Afterpiece Title: Rosina

Cast
Role: Irish Haymaker Actor: Rock

Dance: End I: Divertissement=, as17891002

Performances

Mainpiece Title: The Clandestine Marriage

Cast
Role: Chambermaid Actor: Mrs Rock

Afterpiece Title: Barnaby Brittle

Cast
Role: Jeffery Actor: Rock

Performances

Mainpiece Title: The Force Of Fashion

Afterpiece Title: The Citizen

Cast
Role: Dapper Actor: Rock