Data found in the NHS oversight framework dashboards are also made available in comma-separated variables (csv) files to allow users to carry out their own analyses.
Explore the dashboard below:
The data definitions table below supports the following csv data files:
- nhs-oversight-framework-acute-trust-data.csv
- nhs-oversight-framework-non-acute-hospital-trust-data.csv
- nhs-oversight-framework-ambulance-trust-data.csv
| Column name | Column description | Data type |
| Region | The NHS region in which the trust in located (one of 7 regions). | String |
| Trust_type | The specific area of healthcare services the trust is responsible for providing. | String |
| Trust_subtype | Further classification of the trust type, for example identifying if the trust is a specialist trust. | String |
| Trust_code | The NHS Organisation Data Service trust code. | String |
| Trust_name | The name of the trust. | String |
| Domain | The name of the domain the metric is assigned to. | String |
| Sub-domain | The name of the sub-domain the metric is assigned to. | String |
| Metric_ID | The identification number for the metric. | String |
| Metric_description | The metric name – further information on each metric, including links to their published source can be found in the metric metadata tab of the dashboards. | String |
| Reporting_date | The reporting date for the data in the dashboard. | String |
| Units | The units in which the metric is measured (for example count, percentage, rate). | String |
| Value | The reported trust value for the metric. | Numeric |
| Median_value | The mid-point value for the metric when values are sorted from smallest to largest (this is the same as the second quartile). Note that the median is calculated separately for each trust type. | Numeric |
| Lower_quartile | The value below which the lowest 25% of the data for that metric lies. Note that the lower quartile is calculated separately for each trust type. | Numeric |
| Upper_quartile | The value above which the highest 25% of the data for that metric lies. Note that the upper quartile is calculated separately for each trust type. | Numeric |
| Rank | The position of the trust when the metric values are ordered from best to worst. There are separate rankings for each trust type and only for metrics where it is logical to rank performance (for example metrics relating to CQC scores are not ranked as these already rank trusts by performance). | Numeric |
The data definitions table below supports the following csv data files:
- nhs-oversight-framework-acute-trust-league-table.csv
- nhs-oversight-framework-non-acute-hospital-trust-league-table.csv
- nhs-oversight-framework-ambulance-trust-league-table.csv
| Colum name | Colum description | Data type |
|---|---|---|
| Region | The NHS region in which the trust in located (one of 7 regions). | String |
| Trust_type | The specific area of healthcare services the trust is responsible for providing. | String |
| Trust_subtype | Further classification of the trust type, for example identifying if the trust is a specialist trust. | String |
| Trust_code | The NHS Organisation Data Service trust code. | String |
| Trust_name | The name of the trust. | String |
| Reporting_date | The reporting date for the data in the dashboard. | String |
| Average_score | The average (mean) score of all individual level metric scores for a trust. | Numeric |
| Likely_range_of_average_score | The range an organisation’s average metric score could fall in, with 95% certainty, depending on the combination of metrics included within the framework. Please refer to the ‘More information’ button on the Statistics table of the dashboards for further information on how this has been calculated. | String |
| Segment | The trust’s oversight framework adjusted segment (metric ID OF5000 in the trust data csv file). This is the quartiled segment for the trust following consideration of its financial position (any trust in financial deficit or in receipt of deficit support can be no higher than a segment 3). | Numeric |
| Trust_in_financial_deficit | A Yes/No flag to indicate if the trust is in financial deficit or in receipt of deficit support (when a trust is flagged as Yes, their segment can be no higher than 3). | String |
| Rank | The rank for a trust is based on the segment adjusted for the financial deficit and the average metric score. Trusts in segment 1 will have the highest ranks, followed by trusts in segment 2 and so on. Whether or not a trust is in the Recovery Support Programme does not affect its rank. There are separate rankings for each trust type. | Numeric |
| Likely_range_of_rank | The range an organisation’s rank could fall in, with 95% certainty, depending on the combination of metrics included within the framework. Please refer to the ‘More information’ button on the Statistics table of the dashboards for further information on how this has been calculated. | String |
Publication reference: PRN01916