Datasets 12 datasets

fct_demand_ae_weekly_scot

nhs_raw · demand Public Health Scotland

264krows
1.3MBsize
16columns
2026-09-29updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.fct_demand_ae_weekly_scot 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)
health_boardNullable(String)
departmentNullable(String)
categoryNullable(String)
dateNullable(String)
periodNullable(String)
valueNullable(Float64)
unitNullable(String)
source_pubNullable(String)
source_urlNullable(String)
canonical_ods_codeNullable(String)

Sample rows

demandae_weekly_scotattendancessiteA210HA210HS08000015Type 1UNPLANNED2015-02-22week814attendancesPHS Scotland Weeklhttps://www.openda
demandae_weekly_scotattendancessiteA210HA210HS08000015Type 1UNPLANNED2015-02-22week814attendancesPHS Scotland Weekly A&E Activity andhttps://www.opendata.nhs.scot/datase
demandae_weekly_scotattendancessiteA210HA210HS08000015Type 1ALL2015-02-22week814attendancesPHS Scotland Weekly A&E Activity andhttps://www.opendata.nhs.scot/datase
demandae_weekly_scotattendancessiteA111HA111HS08000015Type 1UNPLANNED2015-02-22week1347attendancesPHS Scotland Weekly A&E Activity andhttps://www.opendata.nhs.scot/datase

Cited by papers

  • none yet
Copilotdeep · LLM + SQL