Datasets 14 datasets

fct_workforce_main

nhs_raw · workforce NHS England

5.3mrows
43.8MBsize
23columns
2026-09-29updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.fct_workforce_main LIMIT 100

In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot

Schema

ColumnType
pillarNullable(String)
seriesNullable(String)
measureNullable(String)
geography_levelNullable(String)
geography_codeNullable(String)
geography_nameNullable(String)
regionNullable(String)
icsNullable(String)
main_staff_groupNullable(String)
staff_group_1Nullable(String)
staff_group_2Nullable(String)
care_settingNullable(String)
primary_area_of_workNullable(String)
workforce_typeNullable(String)
benchmark_groupNullable(String)
dateNullable(String)
periodNullable(String)
valueNullable(Float64)
unitNullable(String)
source_pubNullable(String)
source_urlNullable(String)
canonical_ods_codeNullable(String)
trust_typeNullable(String)

Sample rows

workforceworkforceheadcounttrustRWPWorcestershire AcuMidlandsHCHS DoctorsAcuteAcute - Large2009-09month0headcount (people)NHS England HCHS Whttps://digital.nhRWPacute
workforceworkforceheadcounttrustRWPWorcestershire Acute Hospitals NHS TMidlandsHCHS DoctorsAcuteAcute - Large2009-09month0headcount (people)NHS England HCHS Workforce Statistichttps://digital.nhs.uk/data-and-infoRWPacute
workforceworkforceheadcounttrustRWPWorcestershire Acute Hospitals NHS TMidlandsHCHS DoctorsAcuteAcute - Large2010-09month0headcount (people)NHS England HCHS Workforce Statistichttps://digital.nhs.uk/data-and-infoRWPacute
workforceworkforceheadcounttrustRWPWorcestershire Acute Hospitals NHS TMidlandsHCHS DoctorsAcuteAcute - Large2011-09month0headcount (people)NHS England HCHS Workforce Statistichttps://digital.nhs.uk/data-and-infoRWPacute

Cited by papers

  • none yet
Copilotdeep · LLM + SQL