Skip to content

simd2012_health_domain_rank

Scottish Government SIMD 2012 health domain rank, unweighted, 1 = most deprived; copied exactly as published, may end in .5

What the health domain measures (indicators in the Scottish Government's SIMD 2020v2 glossary; earlier editions' indicators differ in detail):

  • Comparative illness factor (HlthCIFSR, standardised ratio; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
  • Hospital stays related to alcohol use (HlthAlcSR, standardised ratio; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
  • Hospital stays related to drug use (HlthDrugSR, standardised ratio; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
  • Mortality (HlthSMR, standardised ratio; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
  • Proportion of population being prescribed drugs for anxiety, depression or psychosis (HlthDprsPc, percentage; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
  • Proportion of live singleton births of low birth weight (HlthLBWTPc, percentage; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
  • Emergency stays in hospital (HlthEmerSR, standardised ratio; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
Table Type Nullable Category In the CSV export SQL Server type
history table (postcode_simd_history, SPD) rank no Scottish Government SIMD yes decimal(6,1)
main table (postcode_simd, SSPL) rank no Scottish Government SIMD yes decimal(6,1)

Provenance (the same in both tables)

Each table runs its own copy of the table-level checks, named .history. and .main..

Where it comes from

Input Field Condition Reaches the row by
data.gov.uk/SG_SIMD_2012/SG_SIMD_2012.dbf (pinned, SHA256 4dc58c30c7d0…) hlthrank DataZone2001Code = datazone

Scope: the row itself.

What was done to it: copied. The domain rank copied exactly as published; it may end in .5 where zones tie. (code: simd_ingest/core/govscot.py: read_gov_edition)

How it is checked (what each check tests; whether a build passed it is in that build's manifest.json["checks"])

  • source.hash.data.gov.uk/SG_SIMD_2012/SG_SIMD_2012.dbf: the pinned file's SHA256 equals the registry's: the bytes are exactly the ones reviewed
  • govscot.2012.columns_present: every declared shapefile column is in the file
  • govscot.2012.key_unique: each data zone appears once in the shapefile table
  • join.<table>.gov.2012.every_record_matched: every record found its data zone in the edition: no empty cell
  • readback.<table>.attached_values: every attached value in the saved file is looked up again from the sources and equal
  • govscot.2012.health_domain.present: the declared domain rank column is in the file
  • govscot.2012.health_domain.complete: every zone has a domain rank
  • govscot.2012.health_domain.half_units: every domain rank is a whole multiple of 0.5
  • govscot.2012.health_domain.range: every domain rank is between 1 and the number of zones
  • join.<table>.domain_ranks_half_units: every joined domain rank is a whole multiple of 0.5

Why: simd-domain-ranks