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: Columbus

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: Powel, Thompson, Cross, Rock

Dance: As17921116

Performances

Mainpiece Title: Columbus

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: Powel, Thompson, Cross, Rock

Dance: As17921116

Performances

Mainpiece Title: Columbus

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: Powel, Thompson, Cross, Rock

Dance: As17921116

Performances

Mainpiece Title: Columbus

Afterpiece Title: Hartford Bridge

Cast
Role: Travellers Actor: Powel, Thompson, Cross, Rock

Dance: As17921116

Performances

Mainpiece Title: Columbus

Afterpiece Title: Rosina

Cast
Role: Irish Haymaker Actor: Rock.

Performances

Mainpiece Title: Columbus

Afterpiece Title: Modern Antiques

Cast
Role: Flounce Actor: Mrs Rock

Performances

Mainpiece Title: Douglas

Cast
Role: Anna Actor: Mrs Rock

Afterpiece Title: Harlequin's Museum; or, Mother Shipton Triumphant

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: Harlequin's Museum [and see17921220]

Dance: In afterpiece: the Burlesque Pas de Russe-Byrn, Miss Smith; Hornpipe-Holland; rest of the Dances-Byrn, Ratchford, Cranfield, Rayner, Platt, Jackson, Wilde, Mrs Watts, Miss Francis, Mrs Ratchford, Mrs Lloyd, Mrs Crowe, Mrs Bayzand, Mme Rossi

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Slang Actor: Rock

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226

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: Romeo And Juliet

Afterpiece Title: Harlequin's Museum

Song: As17921126

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Castle Of Andalusia

Cast
Role: Rapino Actor: Rock

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Harlequin's Museum

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Harlequin's Museum

Dance: As17921226

Performances

Mainpiece Title: Columbus

Afterpiece Title: Harlequin's Museum

Dance: As17921226