SELECT * FROM london_stages WHERE eventid IN (39366, 39378, 39542, 39545, 39547, 39549, 39551, 39554, 39556, 40053, 40061, 40073, 40431, 40741, 40743, 40746, 40755, 40767, 40770, 40775, 40781, 40816, 40845, 40859, 40876, 40956, 40960, 40962, 40983, 40989, 41718, 41723, 41729, 41739, 41741, 42670, 42735, 43444, 44031, 44037, 44078, 44167, 44170, 44172, 44174, 44176, 44178, 44180, 44182, 44184, 44186, 44188, 44190, 44194, 44196, 44198, 44200, 44202, 44204, 44206, 44208, 44210, 44212, 44214, 44216, 44218, 44221, 44223, 44225, 44227, 44239, 44258, 44272, 44279, 44286, 44309, 44348, 44354, 44367, 44374, 44384, 44397, 44412, 44429, 44437, 44444, 44469, 44608, 44632, 44650, 44652, 44664, 44674, 44676, 45537, 45547, 45991, 45993, 45997, 46002, 46005, 46007, 46011, 46018, 46024, 46040, 46130, 46137, 46151, 46154, 46171, 46178, 46266, 46271, 46273, 46284, 46292, 46299, 46311, 46321, 46323, 46336, 46343, 46353, 46357, 46361, 46363, 46365, 46369, 46373, 46383, 46387, 46389, 46393, 46397, 46399, 46401, 46403, 46431, 46474, 46483, 46488, 46490, 46492, 46500, 46506, 46511, 46519, 46524, 46533, 46543, 46552, 46564, 46571, 46580, 46585, 46590, 46607, 46612, 46614, 46622, 46632, 46634, 46637, 46639, 46642, 46657, 46676, 46688, 46695, 46697, 46700, 46708, 46716, 46718, 46732, 46737, 46743, 46746, 46751, 46758, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46891, 46893, 46895, 46897, 46907, 46909, 46965, 46967, 46969, 46971, 46973, 46975, 46977, 46979, 46981, 46983, 46985, 46989, 46991, 46993, 46995, 46997, 46999, 47003, 47007, 47009, 47015, 47017, 47019, 47021, 47023, 47027, 47029, 47031, 47033, 47035, 47039, 47041, 47053, 47063, 47081, 47198, 47202, 47220, 47235, 47253, 47289, 47306, 47309, 47312, 47315, 47320, 47326, 47474, 47475, 47478, 47482, 47484, 47485, 47493, 47495, 47497, 47507, 47513, 47519, 47527, 47531, 47537, 47543, 47549, 47555, 47561, 47566, 47568, 47575, 47645, 47651, 47655, 47657, 47672, 47676, 47683, 47685, 47737, 47752, 47782, 47797, 47813, 47828, 47843, 47858, 47872, 47892, 48038, 48043, 48049, 48080, 48090, 48109, 48264, 48278, 48285, 48289, 48294, 48299, 48320, 48322, 48349, 48358, 48366, 48368, 48416, 48418, 48437, 48443, 48620, 48628, 48654, 48677, 48734, 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, 48826, 48828, 48830, 48835, 48842, 48844, 48846, 48849, 48851, 48854, 48856, 48858, 48863, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49012, 49014, 49021, 49023, 49026, 49033, 49038, 49041, 49051, 49053, 49056, 49058, 49061, 49066, 49069, 49077, 49081, 49083, 49086, 49090, 49100, 49216, 49222, 49226, 49244, 49472, 49478, 49485, 49490, 49495, 49507, 49513, 49525, 49563, 49594, 49599, 49612, 49635, 49640, 49650, 49655, 49662, 49667, 49783, 49794, 49797, 49801, 49805, 49811, 49815, 49819, 49825, 49827, 49831, 49837, 49849, 49886, 49891, 49897, 49900, 49902, 49905, 49907, 49910, 49912, 49915, 49917, 49919, 49921, 49924, 49926, 49929, 49931, 49933, 49935, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49959, 49961, 49966, 49968, 49971, 49978, 49980, 49983, 49985, 49987, 49989, 49992, 49994, 49998, 50001, 50004, 50006, 50010, 50013, 50016, 50019, 50023, 50026, 50029, 50031, 50035, 50038, 50041, 50044, 50048, 50052, 50057, 50061, 50064, 50067, 50070, 50073, 50075, 50079, 50082, 50087, 50089, 50097, 50099, 50104, 50108, 50111, 50113, 50116, 50118, 50128, 50134, 50141, 50143, 50148, 50151, 50153, 50156, 50158, 50161, 50163, 50166, 50170, 50177, 50184, 50186, 50189, 50193, 50195, 50203, 50205, 50215, 50360, 50366, 50475, 50477, 50480, 50482, 50484, 50487, 50489, 50492, 50494, 50496, 50498, 50501, 50503, 50506, 50508, 50510, 50512, 50515, 50520, 50522, 50524, 50526, 50529, 50531, 50534, 50536, 50538, 50540, 50543, 50546, 50549, 50551, 50554, 50556, 50559, 50564, 50566, 50568, 50571, 50573, 50576, 50578, 50581, 50583, 50588, 50591, 50593, 50595, 50597, 50600, 50602, 50605, 50607, 50609, 50611, 50616, 50620, 50626, 50628, 50632, 50635, 50638, 50640, 50644, 50647, 50650, 50652, 50656, 50659, 50662, 50664, 50668, 50671, 50674, 50676, 50680, 50684, 50688, 50690, 50695, 50697, 50699, 50702, 50707, 50709, 50712, 50714, 50717, 50722, 50724, 50726, 50736, 50742, 50744, 50747, 50762, 50764, 50772, 50777, 50784, 50790, 50800, 50802, 50805, 50812, 50932, 50936, 51064, 51067, 51069, 51071, 51073, 51076, 51078, 51081, 51083, 51085, 51087, 51090, 51092, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51126, 51128, 51133, 51221, 51223, 51227, 51231, 51234, 51237, 51241, 51247, 51249, 51254, 51256, 51258, 51268, 51277, 51283, 51285, 51293, 51298, 51304, 51314, 51338, 51356, 51363, 51521, 51525, 51527, 51694, 51697, 51699, 51704, 51706, 51710, 51713, 51716, 51718, 51722, 51725, 51728, 51730, 51734, 51737, 51740, 51743, 51747, 51750, 52200, 52202, 52331, 52335, 52338, 52343, 52350, 52413, 52497) 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 Raft

Afterpiece Title: Rule a Wife and Have a Wife

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Lie of the Day; or, A Party at Hampton Court

Performances

Mainpiece Title: The Raft

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Road To Ruin

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Raymond and Agnes

Cast
Role: Don Felix Actor: Cranfield

Dance: In III: Hornpipe in Fetters, as17971025; Afterpiece to conclude: Spanish Fandango-; Finale- as17971009

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Raymond and Agnes

Cast
Role: Don Felix Actor: Cranfield

Dance: As17971012

Performances

Mainpiece Title: The Eccentric Lover

Afterpiece Title: Raymond and Agnes

Cast
Role: Don Felix Actor: Cranfield

Dance: Afterpiece to conclude with: Dance of Savoyards-Platt, Miss Cranfield, Mlle St.Amand

Performances

Mainpiece Title: The Raft

Afterpiece Title: Raymond and Agnes

Cast
Role: Don Felix Actor: Cranfield

Dance: 3rd piece to conclude: as17980430

Performances

Mainpiece Title: Hooly And Fairly

Dance: 1st piece to conclude with: a Highland Reel, as17980428

Song: In 1st piece: Highland Laddy-; Hooly and Fairly-; Katharine Ogie-; Andrew and his Cutty Gun-; Todlen Hame-; Tulloch Goram-; End II 2nd piece: Old Towler-Incledon; End 2nd piece: Admiral Benbow-Incledon

Music: In 3rd piece: The Union Pipes-Murphy

Performances

Mainpiece Title: Lionel And Clarissa

Afterpiece Title: Raymond and Agnes

Cast
Role: Don Felix Actor: Cranfield

Dance: As17980430

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: Lock and Key

Dance: In 2nd piece: Highland Reel, as17980428

Song: End III 1st piece: Black Ey'd Susan-Incledon

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Reformed in Time

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: Unanimity; or, War, Love, and Loyalty

Cast
Role: Jenny Actor: Miss Cranfield

Afterpiece Title: Raymond and Agnes

Cast
Role: Don Felix Actor: Cranfield

Dance: 3rd piece to conclude with: Dance of Savoyards, as17980430; Ascension of the Bleeding Nun-

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Ghost

Afterpiece Title: The Mouth of the Nile

Performances

Mainpiece Title: Lover's Vows

Music: End I afterpiece: A Medley Overture on the Union Pipes and Pedal Harp-Murphy, Weippert

Performances

Mainpiece Title: The Votary Of Wealth

Music: Afterpiece: The Overture-; accompanied on the Union Pipes-Murphy; accompanied on the Pedal Harp-Weippert

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Guardian

Music: In 3rd piece: As17990131

Performances

Mainpiece Title: The Votary Of Wealth

Music: Afterpiece: The overture Accompanied on the Pedal Harp-Weippert