Datasets 12 datasets

fct_demand_gp_appointments

nhs_raw · demand NHS England

469krows
3.2MBsize
23columns
2026-09-29updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.fct_demand_gp_appointments 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)
category_codeNullable(String)
categoryNullable(String)
appt_statusNullable(String)
hcp_typeNullable(String)
appt_modeNullable(String)
time_to_appointmentNullable(String)
service_settingNullable(String)
context_typeNullable(String)
national_categoryNullable(String)
dateNullable(String)
periodNullable(String)
valueNullable(Float64)
unitNullable(String)
source_pubNullable(String)
source_urlNullable(String)
canonical_ods_codeNullable(String)
trust_typeNullable(String)

Sample rows

demandgp_appointmentsappointmentsicbQUENHS CambridgeshireDETAILALL APPOINTMENTSAttendedOther Practice staFace-to-Face2 to 7 Days2023-10month50299appointmentsNHS Digital Appoinhttps://digital.nhS1Y5Dunknown
demandgp_appointmentsappointmentsicbQUENHS Cambridgeshire and Peterborough DETAILALL APPOINTMENTSAttendedOther Practice staffFace-to-Face2 to 7 Days2023-10month50299appointmentsNHS Digital Appointments in General https://digital.nhs.uk/data-and-infoS1Y5Dunknown
demandgp_appointmentsappointmentsicbQUENHS Cambridgeshire and Peterborough DETAILALL APPOINTMENTSAttendedOther Practice staffFace-to-Face22 to 28 Days2023-10month17085appointmentsNHS Digital Appointments in General https://digital.nhs.uk/data-and-infoS1Y5Dunknown
demandgp_appointmentsappointmentsicbQUENHS Cambridgeshire and Peterborough DETAILALL APPOINTMENTSAttendedOther Practice staffFace-to-Face8 to 14 Days2023-10month43184appointmentsNHS Digital Appointments in General https://digital.nhs.uk/data-and-infoS1Y5Dunknown

Cited by papers

  • none yet
Copilotdeep · LLM + SQL