Datasets 14 datasets
workforce
5.3mfct_workforce_main1.1mfct_workforce_staff_survey_archive510kfct_workforce_staff_survey510kdim_staff_survey203kfct_workforce_sickness_absence170kdim_gp_workforce_scot_raw74kfct_workforce_vacancies19kfct_workforce_vacancies_ingest13kmart_workforce_wte_trust_monthly7kstg_workforce_scot_vacancies3kmart_workforce_by_staffgroup_monthly1krq02b_workforce1kfct_rq02b_workforce231mart_workforce_per_capita_region_monthly
stg_workforce_scot_vacancies
nhs_raw · workforce Public Health Scotland
7krows
6.0KBsize
8columns
2026-09-24updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.stg_workforce_scot_vacancies LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| date | Date |
| health_board | String |
| region | String |
| specialty | String |
| establishment | UInt32 |
| staff_in_post | UInt32 |
| total_vacancies | UInt32 |
| source_tag | LowCardinality(String) |
Sample rows
| 2019-12-31 | S08000015 | West | A1 | 6 | 0 | 6 | w1-rq22212@nhs-res |
|---|---|---|---|---|---|---|---|
| 2019-12-31 | S08000015 | West | A1 | 6 | 0 | 6 | w1-rq22212@nhs-research |
| 2019-12-31 | S08000015 | West | A1 | 6 | 0 | 6 | w1-rq22212@nhs-research |
| 2019-12-31 | S08000015 | West | A1 | 6 | 0 | 6 | w1-rq22212@nhs-research |
Cited by papers
- none yet