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_main
nhs_marts · workforce NHS England
16.0mrows
142.9MBsize
29columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.fct_workforce_main 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) |
| region | Nullable(String) |
| ics | Nullable(String) |
| main_staff_group | Nullable(String) |
| staff_group_1 | Nullable(String) |
| staff_group_2 | Nullable(String) |
| care_setting | Nullable(String) |
| primary_area_of_work | Nullable(String) |
| workforce_type | Nullable(String) |
| benchmark_group | 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) |
| month_date | Nullable(Date) |
| trust_name | Nullable(String) |
| t.trust_type | Nullable(String) |
| trust_region | Nullable(String) |
| trust_icb_code | Nullable(String) |
| trust_icb_name | Nullable(String) |
Sample rows
| workforce | workforce | fte | trust | RGT | Cambridge Universi | East of England | Cambridgeshire and | Professionally qua | HCHS doctors - Fou | General Acute | Acute | Acute - Teaching | 2025-12 | month | 3 | FTE (whole-time eq | NHS England HCHS W | https://digital.nh | RGT | acute | 2025-12-01 | CAMBRIDGE UNIVERSI | acute | East of England Co | QUE | NHS Cambridgeshire | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| workforce | workforce | fte | trust | RGT | Cambridge University Hospitals NHS F | East of England | Cambridgeshire and Peterborough | Professionally qualified clinical st | HCHS doctors - Foundation Doctor Yea | General Acute | Acute | Acute - Teaching | 2025-12 | month | 3 | FTE (whole-time equivalents) | NHS England HCHS Workforce Statistic | https://digital.nhs.uk/data-and-info | RGT | acute | 2025-12-01 | CAMBRIDGE UNIVERSITY HOSPITALS NHS F | acute | East of England Commissioning Region | QUE | NHS Cambridgeshire And Peterborough | ||
| workforce | workforce | fte | trust | RGT | Cambridge University Hospitals NHS F | East of England | Cambridgeshire and Peterborough | Professionally qualified clinical st | HCHS doctors - Foundation Doctor Yea | Medicine | Acute | Acute - Teaching | 2025-12 | month | 17.675 | FTE (whole-time equivalents) | NHS England HCHS Workforce Statistic | https://digital.nhs.uk/data-and-info | RGT | acute | 2025-12-01 | CAMBRIDGE UNIVERSITY HOSPITALS NHS F | acute | East of England Commissioning Region | QUE | NHS Cambridgeshire And Peterborough | ||
| workforce | workforce | fte | trust | RGT | Cambridge University Hospitals NHS F | East of England | Cambridgeshire and Peterborough | Professionally qualified clinical st | HCHS doctors - Foundation Doctor Yea | Medicine | Acute | Acute - Teaching | 2025-12 | month | 1 | FTE (whole-time equivalents) | NHS England HCHS Workforce Statistic | https://digital.nhs.uk/data-and-info | RGT | acute | 2025-12-01 | CAMBRIDGE UNIVERSITY HOSPITALS NHS F | acute | East of England Commissioning Region | QUE | NHS Cambridgeshire And Peterborough |