Issue 2967: Date for Dance

New issue submitted

Assigned changed to »Roland« (previously »None«)
Disposition changed to »Needs help« (previously »New«)

Hi Mark,

In Book 30, we read: Adapted from John Playford: The Dancing Master, Volume the Second Fourth Edition, 1728.
Please can you check the date?

Best regards
Roland

Hello Roland,

Well caught.

Oops, mea culpa.

1718 is what my brain said to type and what my fingers totally failed to produce.

BTW http://playforddances.com/dances-2-3/highland-lass-2/ was my reference.

Cheers, Mark

My conclusion from reading this is that we should use 1728 for this dance as in Book 30. But perhaps also make a note that there is another version from 1718 as mentioned in the playforddances.com website?

Hi Mark and Murrough,

Hm! I tkink that Mark is right. 1728 seems to be the Fourth Edition date of The Dancing Master Volume Two but according to Mark’s reference, the date of the tune is 1718.

IMO, Book 30 and Mark are correct.
Any comment?

Best regards
Roland

I’m wondering if it’s a case of the person who did the dance for Book 30 had access to to 1728 edition, but not the 1718. The Playford dances in the database seem to only come from certain editions. But John Playford and his successors were rolling dances in and out of the editions over time, and a lot of the dances were introduced in editions from other years. I wrote some SQl to run against a local copy of the database some time ago, let me find it and it might explain the above a whole lot better.

I am happy to go with the consensus. But whichever of the dates we assign the dance I suggest we just add an extra note summarising this discussion.

Hi Murrough,

Yes. Please add the note as your English is probably better than mine :-)

Thank you to Mark and Murrough!

Best regards
Roland

OK, found the old mods I was running on my local copy of the database. (This hasn’t been run for over 3 years, and I’d added some extra columns to some of the tables, so it doesn’t match the database structure).

Here’s the mods to the publications table so you can see what the changes were (for some reason the indexes didn’t come down):

– – Publication

ALTER TABLE publication ADD sort_name character varying(128); UPDATE publication SET sort_name = name;

ALTER TABLE publication ADD tag_id INTEGER;

CREATE UNIQUE INDEX publication_pk ON publication ( id ); CREATE INDEX publication_devisor_fk ON publication ( devisor_id ); CREATE INDEX publication_tag_fk ON publication ( tag_id ); CREATE INDEX publication_name_ix ON publication ( name );

Anyway, these are the entries for Playford that I was adding to match the dances by Playford and his successors, which I had extracted by going through an online source that lists every edition and the dances in that edition:

– – Playford’s [English] Dancing Master

INSERT INTO publication VALUES ( 50001, CURRENT_TIMESTAMP, NULL, ‘The English Dancing Master’, ‘Playford 1.01’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1651, ‘The English Dancing Master’, NULL );

INSERT INTO publication VALUES ( 50002, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 4th ed.’, ‘Playford 1.04’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1670, ‘The Dancing Master, 4th ed.’, NULL );

INSERT INTO publication VALUES ( 50003, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 6th ed.’, ‘Playford 1.06’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1679, ‘The Dancing Master, 6th ed.’, NULL );

INSERT INTO publication VALUES ( 50004, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 7th ed.’, ‘Playford 1.07’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1686, ‘The Dancing Master, 7th ed.’, NULL );

INSERT INTO publication VALUES ( 50005, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 8th ed.’, ‘Playford 1.08’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1690, ‘The Dancing Master, 8th ed.’, NULL );

INSERT INTO publication VALUES ( 50006, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 9th ed.’, ‘Playford 1.09’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1695, ‘The Dancing Master, 9th ed.’, NULL );

INSERT INTO publication VALUES ( 50007, CURRENT_TIMESTAMP, NULL, ‘The Second Part of the Dancing-Master’, ‘Playford 1.09b’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1696, ‘The Second Part of the Dancing-Master’, NULL );

INSERT INTO publication VALUES ( 50008, CURRENT_TIMESTAMP, NULL, ‘An Additional Sheet of New Dances for the Second Part of the Country-Dancing-Master’, ‘Playford 1.09c’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1697, ‘An Additional Sheet of New Dances for the Second Part of the Country-Dancing-Master’, NULL );

INSERT INTO publication VALUES ( 50009, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 10th ed.’, ‘Playford 1.10’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1698, ‘The Dancing Master, 10th ed.’, NULL );

INSERT INTO publication VALUES ( 50011, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 11th ed.’, ‘Playford 1.11’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1701, ‘The Dancing Master, 11th ed.’, NULL );

INSERT INTO publication VALUES ( 50012, CURRENT_TIMESTAMP, NULL, ‘New Country Dances’, ‘Playford 1.11b’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1701, ‘New Country Dances’, NULL );

INSERT INTO publication VALUES ( 50013, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 12th ed.’, ‘Playford 1.12’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1703, ‘The Dancing Master, 12th ed.’, NULL );

INSERT INTO publication VALUES ( 50014, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, 14th ed.’, ‘Playford 1.14’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1709, ‘The Dancing Master, 14th ed.’, NULL );

INSERT INTO publication VALUES ( 50015, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, Vol. II’, ‘Playford 2.01’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1710, ‘The Dancing Master, Vol. II’, NULL );

INSERT INTO publication VALUES ( 50016, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, Vol. II, 3rd ed.’, ‘Playford 2.03’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1718, ‘The Dancing Master, Vol. II, 3rd ed.’, NULL );

INSERT INTO publication VALUES ( 50017, CURRENT_TIMESTAMP, NULL, ‘The Dancing Master, Vol. III, 2nd ed.’, ‘Playford 3.02’, 446, 1, 1, 1, 1, NULL, NULL, 0, ‘’, 0, 1726, ‘The Dancing Master, Vol. III, 2nd ed.’, NULL );

You’ll notice the 1928 edition doesn’t appear, which means there was no SCD in that edition that wasn’t published in an earlier edition.

These are the changes to the dance publications table:

– – Dance <=> Publication Map

ALTER TABLE dancespublicationsmap ADD tag_id INTEGER;

CREATE UNIQUE INDEX dancespublicationsmap_pk ON dancespublicationsmap ( id ); – Data fix DELETE FROM dancespublicationsmap WHERE id IN ( 22863, 16628, 16629 ); CREATE UNIQUE INDEX dancespublicationsmap_real_pk ON dancespublicationsmap ( dance_id, publication_id ); – SELECT dpm1.id, – dpm1.dance_id, – dpm1.publication_id, – dpm1.number, – dpm1.priority – FROM dancespublicationsmap dpm1 – INNER JOIN dancespublicationsmap dpm2 – ON dpm1.dance_id = dpm2.dance_id – AND dpm1.publication_id = dpm2.publication_id – and dpm1.id <> dpm2.id – ORDER BY dpm1.dance_id, – dpm1.publication_id, – dpm1.id; CREATE INDEX dancespublicationsmap_dance_fk ON dancespublicationsmap ( dance_id ); CREATE INDEX dancespublicationsmap_publication_fk ON dancespublicationsmap ( publication_id ); CREATE INDEX dancespublicationsmap_tag_fk ON dancespublicationsmap ( tag_id );

Then I was inserting links between the Playford dances and their original editions (for my purposes I conly cared about the first publication and not subsequent editions) using a python program to read a datafile and run SQL inserts:

Dance Pub Pge Pty Comment

1797 50001 81 0 Playford 1e Dull Sir John 2892 50001 91 0 Playford 1e Hide Park 3311 50001 53 0 Playford 1e Jog On 4923 50001 98 0 Playford 1e New New Nothing 5365 50001 57 0 Playford 1e Prince Rupert’s March 5246 50002 112 0 Playford 4e The Phoenix 5789 50002 18 0 Playford 4e Sage Leaf 2888 50003 106 0 Playford 5e Hey-boys Up We Go 6108 50004 173 0 Playford 7e Sion House 3809 50005 216 0 Playford 8e Lilli Burlero 3184 50006 182 0 Playford 9e Jacob Hall’s Jigg 3442 50006 161 0 Playford 9e Kensington Court 4711 50006 193 0 Playford 9e Mr Isaac’s Maggot 4712 50006 194 0 Playford 9e Mr Lane’s Maggot 5497 50006 177 0 Playford 9e Red House 2700 50007 24 0 Playford 9e p2 The Guidman of Balangigh 2776 50007 3 0 Playford 9e p2 The Happy Marriage 2953 50007 30 0 Playford 9e p2 Hole In The Wall 5841 50007 5 0 Playford 9e p2 Saint Martin’s Lane 2676 50008 33 0 Playford 9e p3 Greenwich Park 3355 50008 41 0 Playford 9e p3 The Jovial Beggars 6083 50008 45 0 Playford 9e p3 Frae Aberdeen 3815 50009 205 0 Playford 10e Lincoln 5934 50009 199 0 Playford 10e Scotland 1270 50011 304 0 Playford 11e Cockle Shells 2341 50011 266 0 Playford 11e The French Ambassador 3089 50011 267 0 Playford 11e Indian Queen 3927 50011 245 0 Playford 11e Lord Byron’s Jig 3950 50011 273 0 Playford 11e Lord Phoppington 4678 50011 300 0 Playford 11e Mother Brown’s Cat 5328 50011 243 0 Playford 11e Portsmouth 5716 50011 282 0 Playford 11e The Round 7126 50011 294 0 Playford 11e Whitehall Minuet 196 50012 9 0 Playford 11e p2 Apley House 3181 50012 19 0 Playford 11e p2 Jack’s Maggot 6850 50013 343 0 Playford 12e Up With Aily 2792 50014 255 0 Playford 14e The Hare’s Maggot 865 50015 178 0 Playford v2 Burgundy’s Flight 1772 50015 104 0 Playford v2 Dublin Bay 2012 50015 60 0 Playford v2 Ever Happy 2741 50015 105 0 Playford v2 Hambleton’s Round 2918 50015 52 0 Playford v2 The Highland Lass 3970 50015 166 0 Playford v2 Love’s Triumph 5113 50015 113 0 Playford v2 Orleance Baffled 5411 50015 107 0 Playford v2 Queen Bess’s Dame of Honour 5838 50015 27 0 Playford v2 Saint Margaret’s Hill 6710 50015 142 0 Playford v2 A Trip o’er the Tweed 6795 50015 55 0 Playford v2 Twas O’er The Hills And Far Awa 99 50016 284 0 Playford v2 3e All Together One After Another 1287 50016 209 0 Playford v2 3e The Collier’s Daughter 3356 50016 324 0 Playford v2 3e Joy After Sorrow 3425 50017 82 0 Playford v3 2e Kelsterne Gardens 3683 50017 26 0 Playford v3 2e Lancaster Lasses 4861 50017 9 0 Playford v3 2e My Lady Winwood’s Maggot 6499 50017 187 0 Playford v3 2e Temple Bar 7951 50017 22 0 Playford v3 2e Smith’s Round O

What all this shows is that there isn’t a single Playford dance now counted as an SCD that was introduced in the 1728 edition.

Hope this helps.

Well, that didn’t format all that well, striped out most of the line breaks. The joys of cross platform cut and paste :)

Disposition changed to »Fixed« (previously »Needs help«)

OK, I added an extra info note and assigned 1728 to the dance.

Mark, the emails the editors get sent in response to an issue have it as plain text. The web display uses Anselms ACE formatting, a variant of Markdown syntax. It may take a while for me to have a look at your SQL output but I will try and remember to keep the original mail which is likely to be more comprehensible.