Datasets 10 tables · 33.6m rows
workforce
16.0mfct_workforce_main16.0mfct_workforce_main609kfct_workforce_sickness_absence609kfct_workforce_sickness_absence170kdim_gp_workforce_scot_raw74kfct_workforce_vacancies74kfct_workforce_vacancies13kmart_workforce_wte_trust_monthly231mart_workforce_per_capita_region_monthly32mart_workforce_by_staffgroup_monthly
fct_workforce_sickness_absence
nhs_raw · workforce NHS England
609krows
6.0MBsize
15columns
2026-08-17updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_raw.fct_workforce_sickness_absence LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| pillar | Nullable(String) |
| series | Nullable(String) |
| measure | Nullable(String) |
| geography_level | Nullable(String) |
| geography_code | Nullable(String) |
| geography_name | Nullable(String) |
| category | Nullable(String) |
| date | Nullable(String) |
| period | Nullable(String) |
| value | Nullable(Float64) |
| unit | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
| canonical_ods_code | Nullable(String) |
| trust_type | Nullable(String) |
Sample rows
| workforce | sickness_absence | fte_days_sick | trust | NB7 | Northern Deanery | ALL STAFF | 2009-05 | month | 404.9 | FTE-days | NHS Sickness Absen | https://digital.nh | NB7 | unknown |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| workforce | sickness_absence | fte_days_sick | trust | NB7 | Northern Deanery | ALL STAFF | 2009-05 | month | 404.9 | FTE-days | NHS Sickness Absence Rates (digital. | https://digital.nhs.uk/data-and-info | NB7 | unknown |
| workforce | sickness_absence | fte_days_sick | trust | RYH | NHS Direct NHS Trust | ALL STAFF | 2009-05 | month | 5974.83565 | FTE-days | NHS Sickness Absence Rates (digital. | https://digital.nhs.uk/data-and-info | RYH | acute |
| workforce | sickness_absence | fte_days_sick | trust | T1150 | NHS Litigation Authority | ALL STAFF | 2009-05 | month | 128.71111 | FTE-days | NHS Sickness Absence Rates (digital. | https://digital.nhs.uk/data-and-info | T1150 | unknown |