How to use the CSV file
Published 18 December 2025
Applies to England
© Crown copyright 2025
This publication is licensed under the terms of the Open Government Licence v3.0 except where otherwise stated. To view this licence, visit nationalarchives.gov.uk/doc/open-government-licence/version/3 or write to the Information Policy Team, The National Archives, Kew, London TW9 4DU, or email: psi@nationalarchives.gov.uk.
Where we have identified any third party copyright information you will need to obtain permission from the copyright holders concerned.
This publication is available at https://www.gov.uk/government/statistics/measures-from-the-adult-social-care-outcomes-framework-england-2024-to-2025/how-to-use-the-csv-file
Introduction
This document provides guidance on how to use the comma-separated value (CSV) file that contains the full set of measures (also called metrics) from the adult social care outcomes framework (ASCOF) covering 1 April 2024 to 31 March 2025.
The CSV file provides a structured machine-readable presentation of the ASCOF data in a long table format.
For more information on how the ASCOF metrics are produced, see the ASCOF handbook of definitions.
Description of ASCOF CSV data
The following example shows a sample of records from the CSV data file.
| Geographical code | Geographical description | Geographical level | ONS code | ASCOF measure code | Disaggregation level | Measure type | Measure value |
|---|---|---|---|---|---|---|---|
| England | England | England | E92000001 | 1A | Total | Numerator | 100 |
| NE | North East | Regional | E1200001 | 1A | Female | Denominator | 500 |
| 104 | Northumberland | Local authority | E123456789 | 1A | 18 to 64 | Outcome | 25.0 |
The fields should be interpreted as follows:
1. Geographical code - this is the geographical level code represented by the row. This will be one of the following:
- council with adult social services responsibilities (CASSR) code
- region code
- council type code
- ‘England’ for England
2. Geographical description - this is the geographical level description represented by the row and defines the geographical code.
3. Geographical level - this is provided to help with analysis. As data is made available to various levels (that is, England, council type, regional and council totals) within the same data sets, this field enables users to access a single subset of the data which represents the overall total and the required level of detail. The levels will be one of the following:
- local authority
- regional
- council type
- national
3. ONS code - this is the geographical level represented by the row as defined by the Office for National Statistics (ONS) administrative categories. These codes are designed to support integrating data sets from different sources. Geographical groupings are not presented hierarchically in the CSV file. Councils, regions and national totals are all included in the accompanying data file. For details about how councils can be grouped into regions, see the ‘Geography’ section in the accompanying document ‘Measures from ASCOF, England: 2024 to 2025 - data sources, quality and uses’. For further details of the ONS administrative geographies, see the Open Geography Portal.
Details of all the regional and national codes used in the data file are provided in the table below:
| ONS area code | Geographical level |
|---|---|
| E12000001 | North East |
| E12000002 | North West |
| E12000003 | Yorkshire and the Humber |
| E12000004 | East Midlands |
| E12000005 | West Midlands |
| E12000006 | East of England |
| E12000007 | London |
| E12000008 | South East |
| E12000009 | South West |
| E92000001 | England |
4. ASCOF measure code - this field represents the code for each measure provided by each row. Some measures are 2-part metrics and are labelled with (1) and (2) or (a) and (b). More information on what these measures represent is included in the ASCOF handbook of definitions.
5. Disaggregation level - as with the measure code above, this field contains a description of the disaggregation level (for example, ‘total’, ‘gender’ or ‘age band’) represented by the data.
6. Measure type - this field represents the type of measure provided by each row, as follows:
- ‘base’ is the number of survey respondents (which are only relevant and included for survey-based measures)
- ‘denominator’ is the total available population who could have experienced the desired outcome with a given measure
- ‘numerator’ is the total number of people surveyed or eligible for a given measure
- ‘outcome’ is calculated as the numerator divided by the denominator
- ‘margin of error’ is the range above and below the reported value or outcome that shows how much the true population value might differ from the sample result. It tells you how confident you can be that your sample reflects the population
7. Measure value - this is the value represented by the unique combination of ASCOF measure code, geographical level, disaggregation level and measure type for a given measure. Some of the cells within the data file contain a non-numeric value. These will be as a result of one of the following:
- small numbers having been suppressed (represented as ‘[c]’)
- data not having been submitted by a council (represented as ‘[x]’)
Data sources for the ASCOF metrics
Data sources and the corresponding ASCOF metrics are as follows:
- adult social care survey (ASCS) - metrics 1A, 1B, 1D, 3A, 3C (part 1), 4A, and 5A (part 1)
- survey of adult carers in England (SACE) - metrics 1C ,1E, 3B, 3C (part 2), and 5A (part 2)
- client level data (CLD) activity - metrics 2A, 2E, 3D(1a), 3D(1b), 3D(2a), and 3D(2b)
- CLD activity and secondary uses service (hospital statistics) (SUS) - metrics 2D (part 1) and 2D (part 2)
- CLD activity and the Office for National Statistics - metrics 2B and 2C
- safeguarding adults collection (SAC) - metric 4B
- adult social care workforce data set (ASC-WDS) - metric 6A
- Care Quality Commission (CQC) - metric 6B
SACE is carried out every 2 years. It last took place in 2023 to 2024, so metrics for SACE are included using the 2023 to 2024 survey.
Survey-based metrics and rounding
For the survey-based metrics, the base (that is, the number of responses on which the outcome is based) should be considered when assessing the reliability of the outcome values. Outcomes based on a small base should be treated with caution. Where the base is less than 3, the values are suppressed.
Survey base, numerator and denominator data are rounded to the nearest 5.
No rounding has been applied to metrics 2A, 2B, 2C, 2D (part 1), 2D (part 2), 2E, 3D (part 1a), 3D (part 1b), 3D (part 2a), 3D (part 2b).
Measure 1B was introduced in 2016 to 2017. Details of how the scores for 1B are calculated and a worked example are available in the report summary of the 2014 to 2015 ASCOF publication on the NHS England website.
Key
[c] means the value is suppressed.
[x] means data is not available.
[z] means data is not applicable.
Additional information
Derby did not submit 2024 to 2025 ASCS data, and therefore no ASCS ASCOF metrics are reported for this local authority.
Metrics for CLD are reported for the first time this year and should not be compared to previous short and long term (SALT) metrics due to changes in methodology.