SELECT * FROM london_stages WHERE eventid IN (234, 950, 1160, 20203, 20555, 29886, 29888, 29890, 29892, 29894, 29899, 29901, 29903, 29907, 29909, 29912, 29914, 29927, 29929, 29960, 29981, 30006, 30009, 30028, 30055, 30057, 30068, 30081, 30114, 30145, 30151, 41116, 41129, 41436, 41609, 41612, 41617, 41620, 41624, 41632, 41638, 41640, 41644, 41645, 42187, 42194, 42198, 42222, 42226, 42227, 42243, 42244, 42245, 42246, 42247, 42249, 42250, 42253, 42255, 42256, 42258, 42259, 42260, 42261, 42262, 42263, 42264, 42265, 42266, 42267, 42268, 42270, 42271, 42272, 42405, 42456, 42469, 42476, 42517, 42558, 42565, 42580, 42711, 42759, 42764, 42766, 42767, 42770, 42772, 42780, 42787, 42788, 42791, 42795, 42798, 42799, 42800, 42805, 42807, 42817, 42818, 42829, 42831, 42833, 42834, 42835, 42837, 42841, 42843, 42847, 42849, 42923, 42925, 42929, 42931, 42933, 42937, 42951, 42957, 42962, 42964, 42967, 42969, 42971, 42976, 42985, 42990, 43000, 43009, 43011, 43021, 43223, 43228, 43259, 43262, 43271, 43273, 43276, 43287, 43309, 43371, 43380, 43390, 43398, 43399, 43402, 43407, 43415, 43420, 43423, 43461, 43503, 43617, 43632, 43635, 43637, 43640, 43646, 43650, 43655, 43663, 43667, 43701, 43706, 43717, 43817, 43853, 43877, 44034, 44047, 44055, 44062, 44065, 44069, 44075, 44084, 44088, 44096, 44102, 44126, 44128, 44148, 44160, 44166, 44169, 44171, 44207, 44232, 44248, 44264, 44283, 44292, 44302, 44305, 44308, 44368, 44371, 44401, 44453, 44592, 44626, 44627, 44629, 44631, 44633, 44635, 44637, 44642, 44644, 44646, 44651, 44663, 44665, 44667, 44669, 44675, 44687, 44689, 44693, 44699, 44704, 44720, 44730, 44736, 44745, 44749, 44751, 44754, 44756, 44759, 44761, 44763, 44765, 44768, 44770, 44773, 44775, 44777, 44779, 44784, 44786, 44793, 44795, 44802, 44809, 44812, 44816, 44818, 44823, 44827, 44830, 44833, 44835, 44843, 44848, 44856, 44862, 44866, 44873, 44886, 44896, 44908, 44912, 44916, 44928, 44956, 44958, 44972, 44974, 44979, 44982, 44985, 44991, 44994, 45012, 45021, 45036, 45136, 45140, 45144, 45149, 45165, 45177, 45181, 45185, 45189, 45199, 45203, 45205, 45207, 45211, 45215, 45217, 45221, 45223, 45225, 45229, 45231, 45233, 45235, 45241, 45259, 45265, 45275, 45277, 45282, 45284, 45286, 45288, 45290, 45294, 45296, 45299, 45304, 45306, 45309, 45311, 45313, 45318, 45320, 45323, 45327, 45329, 45334, 45341, 45343, 45364, 45371, 45377, 45383, 45409, 45411, 45439, 45441, 45450, 45458, 45460, 45468, 45476, 45479, 45489, 45518, 45543, 45556, 45568, 45581, 45586, 45590, 45592, 45594, 45596, 45599, 45603, 45705, 45707, 45782, 45790, 45806, 45808, 45816, 45834, 45837, 45843, 45849, 45851, 45855, 45861, 45868, 45870, 45875, 45877, 45882, 45884, 45896, 45898, 45908, 45938, 45941, 45943, 46117, 46136, 46159, 46260, 46293, 46306, 46318, 46362, 46376, 46378, 46494, 46496, 46510, 46528, 46535, 46556, 46579, 46606, 46613, 46648, 46707, 46715, 46831, 46840, 46859, 46980, 46988, 46996, 47010, 47020, 47072, 47149, 47211, 47223, 47246, 47254, 47303, 50937, 50944, 50965, 50971, 50979, 50983, 50993, 50995, 51052, 51054, 51064, 51067, 51076, 51090, 51095, 51097, 51099, 51101, 51104, 51107, 51110, 51112, 51114, 51116, 51119, 51121, 51124, 51128, 51130, 51138, 51142, 51156, 51203) 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: Romeo And Juliet

Performances

Mainpiece Title: Herod And Mariamne

Cast
Role: Mariamne Actor: Mrs Spencer

Performances

Mainpiece Title: The Conquest Of China By The Tartars

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Cast
Role: Phillip Actor: Spencer

Afterpiece Title: The Dragon of Wantley

Dance: MMiller and his Wife, The Swiss-Mechell, Mlle Mechell; Comic Ballet-Villeneuve, Miss Oates; Drunken Peasant-Phillips

Performances

Mainpiece Title: The Rival Queens

Cast
Role: Phillip Actor: Spencer

Afterpiece Title: The Royal Chace

Dance: A new Tambourine-Desnoyer, Signora Barberini

Performances

Mainpiece Title: The London Merchant; Or, The History Of George Barnwell

Afterpiece Title: Harlequin's Invasion; or, A ChristmasGambol

Performances

Mainpiece Title: The Earl Of Essex

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Merope

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Douglas

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Douglas

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Funeral; Or, Grief A La Mode

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Funeral

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Harlequin's Invasion

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Harlequin's Invasion