search

GSS-Cogs / family-covid-19

0 stars 0 forks source link

NRS-Weekly-Data-on-Births-and-Deaths-Registered-in-Scotland #102

Open ajtucker opened 4 years ago

LPerryman commented 4 years ago

Looking at alignment for this dataset just putting some notes down: Only the following 3 sheets have been transformed Table 1 - COVID Deaths Table 2 - All Deaths Table 3 - Deaths by location all the other sheets are graphs and data for those graphs. Although most of these other sheets reference the first 3 sheets there is some extra data, such as population on sheet Figure 4 data. Ignoring for now just to get datasets through to PMD4

robons commented 3 years ago

There's an inconsietency in the documentation here:

The spreadsheet specifies that "Week numbers are allocated in accordance with ISO8601. We have used this method since 2016 for the data for 2016 onwards.". This ISO standard requires that weeks are said to start on mondays, however the notes associated with the dataset specify that the weeks begin on sundays.

Could a BA get back to the producer and clarify which is the case?

robons commented 3 years ago

Ike Adiele contacted NRS and they have confirmed that the dates do indeed conform with the ISO8601 specification and so start on Mondays. NRS will be updating the 'Notes' document accordingly.

ikeadiele1 commented 3 years ago

Thanks Rob, I was just about to add same comments, Cheers.

LPerryman commented 3 years ago

Could possibly be joined up with https://github.com/GSS-Cogs/family-covid-19/issues/96. Needs investigating