Skip to main content

Exposing more columns for HES outpatient appointments data

20 May 2025

We have exposed two more columns on the outpatient appointments table from the HES data: outcome_of_attendance and referral_request_received_date. These are examples of data that are held in the backend database, but that had not been exposed via ehrQL. These columns were requested in the past week and are now available.

More details about these columns can be found in the HES data dictionary and the NHS data dictionary (see the spec for outcome of attendance).