Scottish Health and Social Care Open Data

General description

1. Database primary purpose - To give access to statistics and reference data for information and re-use. All NHS Scotland organisations can use this platform to publish and share their open datasets.
2. Overall data type - Demographics
3. Dataset type - Longitudinal
4. Data source - Registry
5. Data level - Council area level, country level
6. Geographic location of the data collection sites - Scotland
7. Sponsor, manager, or home institution - Public Health Scotland
8. Date range - 2009 to 2023 (not all years are available for all datasets)
9. Geolocation data - Council area code, hospital's address and postcode
10. Dates - Year, complete date of financial year, quarter
11. Hospital identifiers - hospital name
12. Physician identifiers - General Medical Council number of general practitioner
13. Longitudinal tracking - Hospital and practitioner address and name
14. Financial variables - average weekly charges for self funders, publicly funded and all funded people
15. Clinical areas of interest - all
16. Other - There are several groups of datasets available under the main "themes": health and care, health protection, and practitioner services

Applicable methods

1. Association methods, such as Bayesian Poisson regression analysis (1), logistic regression (2), multiple linear regression (3)

Data dictionary

To access Scottish Health and Social Care Open Data data dictionary, click here

Variable categories

1. Patient demographics (e.g., age, sex, race, ethnicity)
2. COVID-19 (e.g., number of positive and negative tests, number of deaths)
3. Admission (e.g., type, weekly number)
4. Accident & Emergency Sites (e.g., place the injury occurred, if accidental)
5. Substance abuse (e.g., alcohol and drugs number of patients, ICD-10 code of the condition)
6. Workforce (e.g., number of vacancies and posts)

Linkage to other datasets

• Linkages can be established for any dataset that might have hospital identifier (i.e., name) and postcode.