Core (Current Registered Patients)
CORE Overview
The CORE table is the central table of the database, holding the details of all patients registered with a NEL GP Practice on the run date.
CORE (Current Register)
Regular registration with a start date prior to the run date and an end date NULL or after the run date, at a currently active GP Practice.
Excluding patients with Date of Death >= run date or with a record indicating patient has died
Excluding patients identifiable as Dummy/Test patients based on patient's name (eg 'Testy McTestface' or 'Mickey Mouse')
Excluding patients aged >= 120 years.
| fieldname | description |
|---|---|
| relrun_date | relative run date for the database build |
| person_id | identifier of person across multiple NHS organisations. Analogous to NHS Number. |
| patient_id | identifier of patient at a practice. Analogous to EMIS number. |
| age | age in years of patient on the run date |
| sex | sex (Female, Male, Other, Unknown) for patient |
| area_id | area id for GP Practice (CH, NH, TH, WF, BK, HV, RB). |
| ods_code | ODS (Organisation Data Service) identifier for the GP Practice. |
| practice_name | GP Practice name, as defined for CEG reporting. This may differ from the name on ODS records. |
| reg_date | calculated registration date for patient at practice |
| ethnicity_code | latest ethnicity SNOMED concept id. |
| ethnic_5 | ethnicity 5+1 (2011) categorisation (eg W, M, U) |
| ethnic_16 | ethnicity 16+1 categorisation (eg A-Z,99) |
| ethnic_18 | ethnicity 18+1 categorisation (eg W1-O9, NS, UU) |
| ethnic_19 | ethnicity 19+1 categorisation (eg W1-O9, NS, UU) |
| pt_lad2023 | Local Authority District ONS code (2023) based on patient's identified current address |
| pt_area_id | area_id based on patient's identified current address NULL means the patient lives outside the North East London ICB area. |
| lsoa_2011 | LSOA (Lower Super Output Area) for 2011 relating to the patient's identified current address. |
| imd2019 | Indices of Multiple Deprivation score calculated by ONS in 2019 (England only) |
| imd2019_rank | IMD rank by country calculated by ONS |
| lsoa2021 | ONS (e-code) for LSOA 2021 |
Note: Because of the difficulties identifying some registrations, there are some persons (
person_id) that appear as multiple patients (patient_id) at different practices. This may be due to patients moving practice; errors in the registration data held by a practice; or a patient deliberately registering and receiving healthcare with multiple practices. It is not possible to better define or clean the data. For most analyses, we recommend usingpatient_id.
CORE Views
Views are virtual tables within a SQL database that provide a specified subset of the actual data. Within some applications, such MS Access, Views will appear as standard tables and can be linked for use in queries in the same way.
A series of Views are provided that filter the CORE table for each area.
CORE Area: Patient Registration
View based on area_id, which is defined by the location of the registered GP Practice.
CORE_BK
CORE_CH
CORE_HV
CORE_NH
CORE_RB
CORE_TH
CORE_WF
CORE Area: Patient Residency
View based on pt_area_id, which is defined by patient's identified current address. These are the patients actually resident within the borough.
CORE_BK_pt
CORE_CH_pt
CORE_HV_pt
CORE_NH_pt
CORE_RB_pt
CORE_TH_pt
CORE_WF_pt
Backlinks:
Cancer Screening
The cancer screening tables are created from CORE with no age restriction or any other exclusions, except gender in breast cancer screening and cervical screening. The age_at_event column shows the age of the patient when the screening took place in order to assist identification of patients screened within the national programme.
LSOA & IMD
For ELDB2025 we have used ONS postcodes-LSOA lookup tables, with the patient's postcode available via Compass, to map each patient's address to a LSOA2021 and a LSOA2011. This gets round the issue of split or merged LSOA and allows us, in turn, to provide an IMD 2019 score and rank for the patient. All this information is provide in the CORE table.
Lookup Tables
> The boundary changes in LSOA 2021 make it difficult to map to the LSOA 2011 based IMD 2019 scores and ranking. See lu_lsoa2021 for more detail. LSOA and IMD based on the patient's postcode are provided in CORE.