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 Duenna

Afterpiece Title: Omai

Performances

Mainpiece Title: Werter

Afterpiece Title: Omai

Song: As17860325athi

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Omai

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Omai

Song: As17851114

Performances

Mainpiece Title: The Castle Of Andalusia [and See 14 Oct

Afterpiece Title: Omai

Performances

Mainpiece Title: The Foundling, As 8 Apr

Afterpiece Title: Omai

Performances

Mainpiece Title: Werter

Afterpiece Title: Omai

Song: As17860325athi

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Omai

Song: As17860502 throughout

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Omai

Song: As17860502 throughout

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Omai

Performances

Mainpiece Title: Fontainbleau

Cast
Role: Nannette Actor: Miss Cranfield

Afterpiece Title: The Drummer

Dance: End of mainpiece The Wafping Landlady [perfomers not listed, but see17860426]

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Omai

Song: As17860502 throughout

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Omai; or, A Trip round the World

Cast
Role: Londina Actor: Miss Cranfield

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Omai

Cast
Role: Londina Actor: Miss Cranfield

Performances

Mainpiece Title: He Wou'd Be A Soldier

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: He Wou'd Be A Soldier

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Omai

Cast
Role: Londina Actor: Miss Cranfield

Performances

Mainpiece Title: He Wou'd Be A Soldier

Afterpiece Title: Omai

Cast
Role: Londina Actor: Miss Cranfield

Performances

Mainpiece Title: Mahomet

Afterpiece Title: Omai

Cast
Role: Londina Actor: Miss Cranfield

Performances

Mainpiece Title: Tit For Tat

Afterpiece Title: The Nunnery

Afterpiece Title: The Royal Chace; or, Harlequin Skeleton

Cast
Role: Hercules Actor: Cranfield

Song: End I 1st piece: Oh say Bonny Lass will you carry a Wallet?-Mrs Kennedy, Mrs Martyr

Entertainment: Monologue. End II 1st piece: A Description of the Curiosities in the Tower-Edwin

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Royal Chace

Cast
Role: Hercules Actor: Cranfield

Song: In afterpiece: a Hunting Song-Darley

Entertainment: Monologue. End afterpiece: an Occasional Epilogue[, in the character of Harlequin] (written by Miss Ross)-Brown

Performances

Mainpiece Title: The Comedy Of Errors

Afterpiece Title: The Death of Captain Cook

Cast
Role: Captain Cook Actor: Cranfield

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Death of Captain Cook

Cast
Role: Captain Cook Actor: Cranfield

Afterpiece Title: Rosina

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Death of Captain Cook

Cast
Role: Captain Cook Actor: Cranfield

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Death of Captain Cook

Cast
Role: Captain Cook Actor: Cranfield

Dance: As17890101