Skip to main content

Exposing more columns for HES data

05 February 2025

We have exposed two more columns on the admitted patient care table from the HES data: discharge_destination and discharge_method. These are examples of data that are held in the backend database, but that had not been exposed via ehrQL. We’re always happy to add existing data to ehrQL, but typically we wait for someone to ask so we know there’s a real need. These columns were requested last week and are now available.

More details about these columns can be found in the NHS spec for HES data. Here is the spec for discharge destination and here is the spec for discharge method.