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: Arrived At Portsmouth

Performances

Mainpiece Title: Arrived At Portsmouth

Performances

Mainpiece Title: Cross Purposes

Performances

Mainpiece Title: The Travellers In Switzerland

Afterpiece Title: The Follies of a Day

Dance: 1st piece to conclude with: The Savoyard-Byrn, Holland, Mlle St.Amand; In 3rd piece: a New Dance-Byrn, Holland, Mlle St.Amand

Song: End I: The Sea Storm-Incledon; In 3rd piece: We've bade the restless seas adieu-; O why to be happy, as17960314With Rosabel what joy to stray-Townsend; Here we laugh and work together-; With pride we steer'd for England's coast-Incledon; When love was a stranger-Mrs Mountain; The seaman who of wars may tell-Incledon, Bowden; Rule Britannia-; In course: Old Towler-Incledon; an entire New Song-Incledon

Performances

Mainpiece Title: A New Way To Pay Old Debts

Afterpiece Title: British Fortitude and Hibernian Friendship

Song: In 2nd piece: As17960405, but Fa la la-_; Our Simple Tale thus Ended-Incledon, Johnstone, Linton, Street, the rest of the characters; End III 1st piece: Old Towler-Incledon

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Irish Mimick

Dance: As17960420

Song: In Evening: a Hunting Song [Old Towler]-Incledon; 2nd piece: We've bade the restless seas adieu-; O why to be happy, as17960412; Here we laugh and work together-; With pride we steer'd for England's coast, as17960412; When love was a stranger, as17960412; Hearts of Oak-Incledon, Chorus