NHS - Learning Disability Health Check Scheme

[grace-spitzer-wong]

• [x] Create Jenkins job (in Jenkins).
  • [x] Create a Jenkinsfile.
  • [x] Figure out landing page.
  • [x] Create main.py and check scraper works.
  • [x] Determine eventual Tidy data column names and add to info.json.
  • [x] Map column names to codelists (existing and newly required), adding mapping to info.json.
  • [x] Add definition to reference/columns.csv
  • [x] Add newly required codelists (under reference/codelists) and add info to reference/codelists-metadata.json
  • [x] Add component definitions to reference/components.csv
  • [x] Write a transformation to Tidy CSV and output metadata dataset.trig and schema.
    • [x] Draft
    • [x] Finalised

CSV and XLS - granular data using ONS and NHS location codes right down to practice level on health checks given to people with learning disabilities of ages characterised into age groups - they have different codes to measure ages.

CSV file has info on locations and practices XLS is detail on counts of checks and age categories There's a column - the final one in the CSV that's linked to the codes in the XLS which does have lots of nil values - it makes sense as the practice may have not needed to give a health check at all, may not have checks for a certain age group etc. The XLS info could be added to the CSV as an extra column but I haven't looked at it properly.

Will need to go back to stakeholders on certain parts of the data.

Metadata

[grace-spitzer-wong]

Dependancy: https://github.com/GSS-Cogs/family-disability/issues/21

[LPerryman]

NHS codes removed just to get the pipeline working. Only ONS codes E00000000 are used. Will be reinstated when sources for the NHS codes can be found and referenced

[grace-spitzer-wong]

Red error page on PMD

http://gss-data.org.uk/dataset?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fdisability%2Fnhs-learning-disability-health-check-scheme-england

[LPerryman]

Now running successfully in pipeline but cannot be viewed in PMD (red screen of death)!

[grace-spitzer-wong]

QA notes - not yet completed.

All locations have been compressed into ONS code - removed sub region ONS code, region name, region code, sub region name, STP name, STP code, CCG name, CCG ONS code, CCG code, practice code, DQ flag on data quality and annex tab re data quality checks.

Missing metadata on notes and definitions tab of Learning disability health checks.

Unable to download tidydata and doesn't show more rows.

To check what NHS LDHC Quality Service represents.