LSOA to CCG to STP Lookup: England's 2018 Healthcare Administrative Geography

Office for National Statistics provides a lookup file mapping 2011 Lower Layer Super Output Areas (LSOAs) to 2018 Clinical Commissioning Groups (CCGs) and 2017 Sustainability and Transformation Partnerships (STPs) in England as of 1 April 2018. The 11MB file includes codes and names for newly formed and boundary-changed CCGs. Field names include LSOA11CD, LSOA11NM, CCG18CD, CCG18CDH, CCG18NM, STP18CD, and STP18NM.

Use Cases

• Aggregating small-area census or health data to Clinical Commissioning Group level based on the LSOA11CD to CCG18CD mapping.
• Analyzing healthcare service boundaries and their changes using the provided CCG and STP codes and names.
• Joining demographic or socioeconomic datasets to Sustainability and Transformation Partnership regions using the STP18CD field.
• Studying the impact of administrative boundary changes on health statistics, as the description notes specific CCG code updates.

Strengths

• Provides a specific snapshot date (1 April 2018) for the administrative relationships.
• Includes explicit details on newly formed CCGs and boundary changes, such as for NHS Birmingham and Solihull CCG.
• Field lengths are specified (e.g., LSOA11NM is 33 characters), which can aid in data validation and schema design.

Limitations

• Row count is unknown, which may limit suitability assessment for large-scale joins.
• The data is a static snapshot from April 2018; relationships may have changed for more recent analyses.
• Column-level documentation is absent; field semantics must be inferred after download.

Provenance

Source

Office for National Statistics

Collection Method

Likely compiled from official administrative geography registers.

Time Range

Snapshot as of 1 April 2018.

Freshness

Last updated 2026-07-08 13:31:41.652308; freshness should be verified as the data represents a 2018 snapshot.

Geography

England