SELECT * FROM london_stages WHERE eventid IN (287, 1205, 1401, 1959, 1995, 2164, 2211, 2318, 2400, 2491, 2547, 2550, 3108, 4418, 4429, 4571, 4573, 4608, 4698, 4765, 5842, 5920, 5955, 6131, 6149, 6157, 11003, 12122, 12239, 12831, 14008, 14055, 14924, 15628, 15656, 15659, 16286, 16307, 16316, 16337, 16351, 16366, 16403, 16408, 16433, 16470, 17148, 17152, 17153, 17165, 17177, 19807, 19904, 19907, 19909, 19912, 19914, 19917, 19919, 19922, 19926, 19929, 19931, 19933, 19935, 19939, 19942, 19945, 19948, 19952, 19961, 19966, 19969, 19979, 19994, 20000, 20003, 20008, 20010, 20013, 20018, 20023, 20028, 20033, 20039, 20044, 20054, 20058, 20063, 20068, 20072, 20082, 20088, 20098, 20103, 20107, 20111, 20113, 20116, 20154, 20156, 20158, 20161, 20164, 20167, 20170, 20173, 20176, 20200, 20234, 20240, 20290, 20299, 20302, 20330, 20344, 20348, 20370, 20373, 20382, 20402, 20469, 20501, 20543, 20559, 20568, 20581, 20608, 20611, 20625, 20651, 20682, 20787, 20790, 20797, 20823, 20826, 20842, 20846, 20849, 20855, 20858, 20861, 20938, 20956, 20961, 20974, 21005, 21025, 21042, 21052, 21070, 21080, 21087, 21104, 21110, 21127, 21151, 21169, 21178, 21185, 21243, 21251, 21258, 21294, 22506, 22509, 22515, 22518, 22522, 22532, 22553, 22556, 22565, 22609, 22617, 22619, 22660, 22670, 22702, 22750, 22770, 22773, 22831, 22939, 22942, 22945, 22948, 22957, 22959, 22971, 22974, 22979, 23003, 23005, 23015, 23036, 23041, 23066, 23098, 23101, 23104, 23128, 23140, 23151, 23179, 23207, 23210, 23215, 23226, 23267, 23298, 23526, 23544, 23558, 23561, 23594, 23654, 23662, 23706, 23711, 23721, 23728, 23744, 23747, 23812, 23826, 23842, 24597, 24610, 24613, 24624, 26015, 26018, 26027, 27324, 27647, 27652, 33203, 34512, 36638, 38052, 38406, 38881, 38899, 38901, 38903, 38904, 38906, 38908, 38910, 38912, 38914, 38916, 38920, 38924, 38926, 38928, 38934, 38939, 38944, 38948, 38953, 38960, 38965, 38970, 38982, 38995, 39000, 39017, 39022, 39024, 39026, 39028, 39032, 39034, 39036, 39038, 39041, 39043, 39047, 39049, 39051, 39054, 39056, 39058, 39060, 39065, 39067, 39072, 39074, 39076, 39078, 39083, 39086, 39088, 39095, 39098, 39104, 39114, 39123, 39137, 39142, 39149, 39163, 39177, 39181, 39199, 39202, 39210, 39225, 39234, 39242, 39255, 39262, 39268, 39270, 40465, 40473, 40479, 40481, 40487, 40489, 40494, 40502, 40507, 40520, 40526, 40538, 40543, 40551, 42726, 43412, 43902, 43916, 43934, 43993, 45840, 45842, 45844, 45846, 45848, 45850, 45852, 45854, 45856, 45858, 45860, 45862, 45864, 45866, 45869, 45874, 45878, 45883, 45890, 45894, 45899, 45902, 45904, 45911, 45951, 46031, 46036, 46038, 46040, 46042, 46050, 46052, 46055, 46058, 46068, 46080, 46093, 46100, 46103, 46121, 46130, 46133, 46137, 46148, 46151, 46154, 46166, 46171, 46174, 46178, 46266, 46321, 46342, 46343, 46344, 46346, 46348, 46353, 46354, 46356, 46358, 46363, 46365, 46366, 46371, 46387, 46399, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46422, 46423, 46425, 46427, 46429, 46431, 46433, 46435, 46436, 46438, 46441, 46443, 46445, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46463, 46464, 46466, 46468, 46469, 46471, 46474, 46476, 46478, 46481, 46483, 46486, 46488, 46489, 46490, 46492, 46495, 46500, 46509, 46511, 46515, 46519, 46521, 46522, 46529, 46533, 46536, 46566, 46571, 46593, 46614, 46628, 46632, 46633, 46642, 46700, 46711, 46729, 46737, 46743, 46746, 46751, 46758, 46844, 46846, 46847, 46849, 46852, 46854, 46861, 46895, 46905, 46909, 46917, 46941, 46949, 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, 47289, 47309, 47326, 47468, 47476, 47876, 47907, 48133, 48135, 48139, 48142, 48144, 48146, 48148, 48150, 48152, 48154, 48156, 48158, 48160, 48162, 48164, 48166, 48168, 48170, 48172, 48174, 48178, 48180, 48182, 48650, 48659, 48665, 48672, 48685, 48697, 48704, 48712, 48714, 48722, 48737, 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, 48837, 48851, 48856, 48860, 48864, 48865, 48870, 48877, 48902, 48916, 48923, 48930, 48945, 48952, 48959, 48961, 48980, 48988, 48990, 48993, 49009, 49014, 49021, 49023, 49028, 49033, 49038, 49041, 49053, 49056, 49066, 49077, 49081, 49083, 49086, 49090, 49100, 49133, 49172, 49329, 49332, 49334, 49337, 49339, 49342, 49351, 49356, 49361, 49365, 49375, 49379, 49424, 49444, 49672, 49677, 49680, 49682, 49686, 49690, 49694, 49696, 49705, 49714, 49727, 49728, 49808, 49828, 49924, 49926, 49929, 49931, 49933, 49935, 49937, 49938, 49940, 49943, 49945, 49947, 49949, 49952, 49954, 49957, 49958, 49959, 49961, 49966, 49968, 49971, 49978, 49992, 50099, 50113, 50116, 50137, 50163, 50193, 50195, 50306, 50308, 50310, 51509, 51513, 51517, 51914) 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: Hamlet

Afterpiece Title: HARLEQUIN AND FAUSTUS

Song: As17940109

Performances

Mainpiece Title: Douglas

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Macbeth

Afterpiece Title: HARLEQUIN AND FAUSTUS

Song: As17931227, but Mrs Follett in place of Mrs Clendining

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: THE MIDNIGHT WANDERERS

Cast
Role: Harlequin Actor: Boyce

Performances

Mainpiece Title: Love's Frailties

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: THE SCHOOL FOR ARROGANCE

Cast
Role: Harlequin Actor: Boyce

Performances

Mainpiece Title: The Citizen

Afterpiece Title: THE FIRST FLOOR

Cast
Role: , Post Actor: boy

Afterpiece Title: HARLEQUIN PEASANT

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: THE SAILOR'S FESTIVAL; or, All Alive at Portsmouth

Afterpiece Title: MARIAN

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: King Lear

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: Everyone Has His Fault

Afterpiece Title: THE SAILOR'S FESTIVAL

Afterpiece Title: THE TWO MISERS

Music: End of Act II of mainpiece concerto on the Piano Forte, composed by Krumpholtz, accompanied by the Full Band, by Miss Poole

Song: End of Act IV of mainpiece Mad Bm, in character, by Miss Poole

Performances

Mainpiece Title: Fontainville Forest

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: HARLEQUIN AND FAUSTUS

Dance: As17940225

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: THE SAILOR'S FESTIVAL

Afterpiece Title: THE POOR SOLDIER

Song: In Act II of mainpiece the Grand Triumphal Entry of Alexander into Babylon. Vocal Parts by Johnstone, Incledon, Cubitt, Rock//Mrs Mountain, Miss Stuart, Miss Leserve, Miss Barnett, Mrs Lloyd, Mrs Martyr. In the course of the Evening Black-Eyed Susan by Incledon