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 Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: As17920125

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Cast
Role: Draco Actor: Cranfield

Music: The Harp and Pipes, as17920125, but _Courtney

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina; or, The Hall of Fingal

Music: In afterpiece: the Harp and Pipes-Weippert, Courtney

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Oscar and Malvina

Song: Vocal Parts-Johnstone, Incledon, Marshall, Rock, Gray, Blurton, Lee, Letteney, Rowson, Mrs Blanchard, Miss Broadhurst, Mrs Harlowe, Mrs Davis, Miss Stuart, Mrs Watts, Miss Francis, Mrs Davenett, Mrs Rock, Mrs Cross, Mrs Powell, Mrs Gray, Mrs Masters, Mrs Ratchford, Miss Watson, Mrs Bayzand, Miss Leserve, Mrs Martyr

Music: As17921025

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17921025

Performances

Mainpiece Title: Just In Time

Afterpiece Title: Oscar and Malvina

Music: As17921025

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Oscar and Malvina

Song: the Solemn Dirge, as17921022, but Mrs _Arnold

Music: As17921025

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: Oscar and Malvina

Music: As17921025

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Oscar and Malvina

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor; or, The Creolian Insurrection

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: Fashionable Levities

Afterpiece Title: Rosina

Afterpiece Title: The Invasion; or, All Alarm'd at Brighthelmstone

Cast
Role: Butler Actor: Cranfield

Entertainment: Monologue. Preceding 1st piece: An Eulogium on Money-Quick

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Relief of Williamstadt

Afterpiece Title: The Invasion

Cast
Role: Butler Actor: Cranfield

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Governor

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Invasion

Cast
Role: Butler Actor: Cranfield

Dance: As17930418

Performances

Mainpiece Title: May Day; Or, The Little Gipsey

Afterpiece Title: Fashionable Levities

Cast
Role: Butler Actor: Cranfield

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Hartford Bridge

Dance: As17921116

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Rosina

Cast
Role: Butler Actor: Cranfield

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Pad

Afterpiece Title: The Shipwreck; or, French Ingratitude

Song: End: Captivity (Supposed to be sung by an Unfortunate Queen [Marie Antoinette] during her confinement)-; End 2nd piece: Black Eyed Susan-; In 3rd piece: Farewell to old England dear Mary adieu-Incledon