Data Description
Social Care Provider - the owning organisation of each individual Social Care Site (i.e. care home or domiciliary care site). In the case of single site organisations, where the one location effectively takes on the role of owning organisation or ‘HQ’ and that of an operating site, the entity will have both a social care HQ and site code.
In the case of single site organisations, where the one location effectively takes on the role of owning organisation or ‘HQ’ and that of an operating site, the entity will have both a social care HQ and site code.
How Data is Maintained
ODS obtains Social Care Provider data on a monthly basis from two third-party suppliers. For Welsh data this is CSSIW (Care and Social Services Inspectorate Wales) and for English data this is CQC (Care Quality Commission).
Each supplier has responsibility for the statutory inspection of care provided in care homes within their respective geographies. All care homes are required by law to be registered with one of these regulatory bodies. This data is published by ODS to ensure the supply of a reliable dataset to allow social care provider/site identification within systems and services throughout the NHS and those of its stakeholders.
Data Quality Assessment
For further information re the: ODS Data Quality Assessment Framework
| Data Quality Dimension | |||||||||||
| Last updated: |
| 1 | 2 | 3 | 4 | 5 | ODS mastered or 3rd party data | 6 | 7 | 8 | 9 |
| OVERALL | Frequency of Update | Data Collection Method | Fit for Purpose | Coverage / Completeness | Reliability / Accuracy | Data Agreement | 3rd Party Escalation Routes | System Application / Downstream System Feedback | Future Refinement / Improvement Plan | ||
| Social Care Providers and Sites | GREEN | Red | Green | Green | Green | Green | 3rd party | Amber | Green | Green | Green |
| Monthly | API | Regulated services, sourced from CQC and CSSIW | Regulated so coverage very good | No significant issues, data maps exactly to ODS data model | CQC and CSSIW | SLA to be drafted with CQC based on new API feed | Named contacts, regular stakeholder meeting/forum | Very low volume of queries/issues | Move to API feed completed. Not further improvement required at present. | ||
Social Care Providers
Key Information - Roles, Code Formats and Data Source
| Key Information | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Geographic coverage |
| ||||||||||||||||||
| Primary Role ID | RO104 | Primary Role Name | SOCIAL CARE PROVIDER | ||||||||||||||||
| Non Primary Role ID | N/A | Non Primary Role Name | N/A | ||||||||||||||||
| Raw Data Source |
| Update Frequency | Monthly | ||||||||||||||||
| Code Format |
| ||||||||||||||||||
Permitted Relationships
Permitted Relationships - Social Care Providers/HQs can be linked to (upward): | ||||
Source Primary role ID | Relationship Type Id | Relationship Type Name | Target Primary Role ID | Target Primary Role Name |
| RO104 | N/A | N/A | N/A | N/A |
Legacy .csv File Mapping
Click here for an explanation of the baseline data differences between legacy csv files and ODS Data Search and Export and the ODS APIs.
Ecarehomehq.csv
Primary Role / OrgTypeID – RO104
Note that the legacy csv report did not include Social Care Providers who only had Domiciliary Care Sites (RO270). Domiciliary Care site data is available via the ODS API and the ODS Data Search and Export tool (user defined report/search). However, the predefined report for ecarehomehq replicates the legacy product so does not contain providers of domiciliary care only.
Col | Data Item | Report Alias (legacy csv) | Notes |
1 | [OrganisationCode] | Organisation Code | |
2 | [OrgName] | Name | |
3 | NULL | Column 3 | |
4 | NULL | Column 4 | |
5 | [Address1] | Address Line 1 | |
6 | [Address2] | Address Line 2 | |
7 | [Address3] | Address Line 3 | |
8 | [Town] | Address Line 4 | |
9 | [County] | Address Line 5 | Change from legacy csv: As this is a legacy field, not populated for new addresses since 2018, this field within the ODS Data Search & Export tool (including pre defined reports) will not be populated. Note that the value (where populated) is available via the FHIR Organization Resource in the address.district property. |
10 | [Postcode] | Postcode | |
11 | [LegalStartDate] | Open Date | |
12 | [LegalEndDate] | Close Date | |
13 | NULL | Column 13 | |
14 | NULL | Column 14 | |
15 | NULL | Column 15 | |
16 | NULL | Column 16 | |
17 | NULL | Column 17 | |
18 | NULL | Column 18 | |
19 | NULL | Column 19 | |
20 | NULL | Column 20 | |
21 | NULL | Column 21 | |
22 | ‘1’ | Amended Record Indicator | Set to 1 for Report |
23 | NULL | Column 23 | |
24 | NULL | Column 24 | |
25 | NULL | Column 25 | |
26 | NULL | Column 26 | |
27 | [Country] | Country | Change from legacy csv: Previously populated with a country code (1 = England, 2 = Scotland, 3 = Wales, 4 = Northern Ireland, 5 Isle of Man, 10 = Channel Islands). Now contains Country name . |
Social Care Sites
Key Information - Roles, Code Formats and Data Source
| Key Information | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Geographic coverage |
| |||||||||||||||||||||
| Primary Role ID | RO101 | Primary Role Name | SOCIAL CARE SITE | |||||||||||||||||||
| Non Primary Role ID | RO269 | Non Primary Role Name | CARE HOME | |||||||||||||||||||
| RO270 | DOMICILIARY CARE | |||||||||||||||||||||
| Raw Data Source |
| Update Frequency | Monthly | |||||||||||||||||||
| Code Format |
| |||||||||||||||||||||
Permitted Relationships
Permitted Relationships - Social Care Provider Sites can be linked to (upward): | ||||
Source Primary Role ID | Relationship Type Id | Relationship Type Name | Target Primary Role ID | Target Primary Role Name |
RO101 | RE5 | IS LOCATED IN THE GEOGRAPHY OF | RO137 | ISLE OF MAN GOVERNMENT DIRECTORATE |
| RE5 | IS LOCATED IN THE GEOGRAPHY OF | RO142 | LOCAL HEALTH BOARD | |
| RE5 | IS LOCATED IN THE GEOGRAPHY OF | RO144 | WELSH LOCAL HEALTH BOARD | |
| RE5 | IS LOCATED IN THE GEOGRAPHY OF | RO179 | PRIMARY CARE TRUST | |
| RE5 | IS LOCATED IN THE GEOGRAPHY OF | RO98 | CLINICAL COMMISSIONING GROUP | |
| RE6 | IS OPERATED BY | RO104 | SOCIAL CARE PROVIDER | |
| RE6 | IS OPERATED BY | RO107 | CARE TRUST | |
| RE6 | IS OPERATED BY | RO141 | LOCAL AUTHORITY | |
| RE6 | IS OPERATED BY | RO197 | NHS TRUST | |
Legacy .csv File Mapping
Click here for an explanation of the baseline data differences between legacy csv files and ODS Data Search and Export and the ODS APIs.
Ecarehomesite.csv
Primary Role / OrgTypeID – RO101 and non primary role RO269 Care Home Sites only.
Note that the legacy csv report was limited to Social Care Sites with a non primary role of RO269 Care Home only, it did not contain Domiciliary Care sites (RO270). Domiciliary Care site data is available via the ODS API and the ODS Data Search and Export tool (user defined report/search). However, the predefined report for ecarehomesite replicates the legacy product so does not contain domiciliary care sites.
Col | Data Item | Report Alias (legacy csv) | Notes |
1 | [OrganisationCode] | Organisation Code | |
2 | [OrgName] | Name | |
3 | [NHSER_code] | National Grouping | Change from legacy csv: Geographic extension of the postcode |
4 | [ICB_code] | High Level Health Geography | Change from legacy csv: Geographic extension of the postcode |
5 | [Address1] | Address Line 1 | |
6 | [Address2] | Address Line 2 | |
7 | [Address3] | Address Line 3 | |
8 | [Town] | Address Line 4 | |
9 | [County] | Address Line 5 | Change from legacy csv: As this is a legacy field, not populated for new addresses since 2018, this field within the ODS Data Search & Export tool (including pre defined reports) will not be populated. Note that the value (where populated) is available via the FHIR Organization Resource in the address.district property. |
10 | [Postcode] | Postcode | |
11 | [LegalStartDate] | Open Date | |
12 | [LegalEndDate] | Close Date | |
13 | NULL | Column 13 | |
14 | NULL | Column 14 | |
15 | [TargetOrgCode] | Parent Organisation Code | Uses RE6 'is operated by' relationship – Where LegalEndDate is null, or where the relationship LegalEndDate is equal to the organisation LegalEndDate * |
16 | [LegalStartDate] | Join Parent Date | RE6 relationship legal start date |
17 | [LegalEndDate] | Left Parent Date | RE6 relationship legal end date |
18 | [TelephoneNumber] | Contact Telephone Number | |
19 | NULL | Column 19 | |
20 | NULL | Column 20 | |
21 | NULL | Column 21 | |
22 | ‘1’ | Amended Record Indicator | Set to 1 for Report |
23 | NULL | Column 23 | |
24 | [PCO_code] | Current Care Organisation | Change from legacy csv: Geographic extension of the postcode |
25 | NULL | Column 25 | |
26 | NULL | Column 26 | |
27 | [Country] | Country | Change from legacy csv: Previously populated with a country code (1 = England, 2 = Scotland, 3 = Wales, 4 = Northern Ireland, 5 Isle of Man, 10 = Channel Islands). Now contains Country name . |
Attachments:
Care Homes HQ Data in England and Wales (application/vnd.jgraph.mxfile)
Care Homes HQ Data in England and Wales.png (image/png)
Care Homes HQ Data in England and Wales (application/vnd.jgraph.mxfile)
Care Homes HQ Data in England and Wales.png (image/png)
Care Homes HQ Data in England and Wales (application/vnd.jgraph.mxfile)
Care Homes HQ Data in England and Wales.png (image/png)
Care Homes HQ Data in England and Wales (application/vnd.jgraph.mxfile)
Care Homes HQ Data in England and Wales.png (image/png)
Care Homes HQ Data in England and Wales (application/vnd.jgraph.mxfile)
Care Homes HQ Data in England and Wales.png (image/png)
