beta.raw.core schema

Available on backends: TPP, EMIS

This schema defines the core tables and columns which should be available in any backend providing primary care data, allowing dataset definitions written using this schema to run across multiple backends.

The data provided by this schema are minimally transformed. They are very close to the data provided by the underlying database tables. They are provided for data development and data curation purposes.

Warning

This schema is still a work-in-progress while the EMIS backend remains under development. Projects requiring EMIS data should continue to use the Cohort Extractor tool.

To use this schema in an ehrQL file:

from ehrql.tables.beta.raw.core import (
    ons_deaths,
)

many rows per patient

ons_deaths

Registered deaths

Date and cause of death based on information recorded when deaths are certified and registered in England and Wales.

In the associated database table ONS_Deaths, a small number of patients have multiple registered deaths. This table contains all registered deaths. The ehrql.tables.beta.ons_deaths table contains the earliest registered death.

Tip

To return one row per patient from ehrql.tables.beta.raw.ons_deaths, for example the latest registered death, you can use:

ons_deaths.sort_by(ons_deaths.date).last_for_patient()

Columns

date date

Patient's date of death. Only deaths registered from February 2019 are recorded.

place string

• Possible values: Care Home, Elsewhere, Home, Hospice, Hospital, Other communal establishment

underlying_cause_of_death ICD-10 code

cause_of_death_01 ICD-10 code

cause_of_death_02 ICD-10 code

cause_of_death_03 ICD-10 code

cause_of_death_04 ICD-10 code

cause_of_death_05 ICD-10 code

cause_of_death_06 ICD-10 code

cause_of_death_07 ICD-10 code

cause_of_death_08 ICD-10 code

cause_of_death_09 ICD-10 code

cause_of_death_10 ICD-10 code

cause_of_death_11 ICD-10 code

cause_of_death_12 ICD-10 code

cause_of_death_13 ICD-10 code

cause_of_death_14 ICD-10 code

cause_of_death_15 ICD-10 code