Primary Care Dementia Data: Publication Format Update

ASS_Declined_GP_Mem_Ass

ASS_Declined_GP_Mem_Clinic

ASS_Received_GP

ASS_Received_GP_Mem_Ass

ASS_Received_GP_Mem_Clinic

DEMENTIA_REGISTER_0_64

DEMENTIA_REGISTER_65_PLUS

DIAG_Declined_Care_Plan

DIAG_Received_Care_Plan

DIAG_Received_Med_Rev

PAT_LIST_0_64

PAT_LIST_65_PLUS

ASIAN_OR_ASIAN_BRITISH

BLACK_OR_AFRICAN_OR_CARIBBEAN_OR_BLACK_BRITISH

INCONCLUSIVE_ETHNIC_GROUP

MIXED_OR_MULTIPLE_ETHNIC_GROUPS

NOT_DEFINED

NOT_STATED

OTHER_ETHNIC_GROUP

WHITE

ALZHEIMERS_DISEASE

FRONTOTEMPORAL

INCONCLUSIVE_DEMENTIA_TYPE

LEWY_BODY

MIXED_DEMENTIA_TYPES

OTHER_SPECIFIED_DEMENTIA_TYPES

OTHER_UNSPECIFIED_DEMENTIA_TYPES

VASCULAR_DEMENTIA

INCONCLUSIVE_RESIDENTIAL_TYPE

NO_PERMANENT_ADDRESS

NURSING_HOME

OTHER_RESIDENTIAL_TYPE

PRIVATE_RESIDENCE

RESIDENTIAL_CARE_HOME

ilter MEASURE field to 'DEMENTIA_REGISTER' and filter BREAKDOWN to 'AGE_GENDER' and filter AGE field to:

• 65_69
• 70_74
• 75_79
• 80_84
• 85_89
• 90_plus

and aggregate the values

This proportion is no longer provided as data coverage is consistently high at ~98%. Where this is not the case, a caveat will be provided within the publication notes and caveats

This proportion can be calculated using the open and included counts described below with the following formula:

Practice coverage = Included / Open * 100

Recorded dementia diagnoses

• all ages
• 0-64
• 65+

These counts can be derived from the pcdem-practice-mmm-yyyy.csv file by filtering MEASURE to 'DEMENTIA_REGISTER' and aggregating the values accordingly dependent on the age breakdown you require.

This data is also available within the pcdem-sub-icb-mmm-yyyy.csv file by filtering MEASURE to 'DEMENTIA_REGISTER', filtering BREAKDOWN to AGE_GENDER' and aggregating the values accordingly dependent on the age breakdown you require.

Registered to a GP

• all ages
• 0-64
• 65+

These counts can be derived from the pcdem-practice-mmm-yyyy.csv file by filtering MEASURE to 'PAT_LIST' and aggregating the values accordingly dependent on the age breakdown you require.

This data is also available within the ppcdem-sub-icb-mmm-yyyy.csv file by filtering MEASURE to 'PAT_LIST', filtering BREAKDOWN to AGE_GENDER' and aggregating the values accordingly dependent on the age breakdown you require.

Recorded prevalence

• All ages
• 0-64
• 65+

This calculation is no longer provided. 

This proportion can be calculated using the 'Recorded dementia diagnoses' and 'Registered to a GP' counts described above with the following formula (for whichever age breakdown you require):

Prevalence = Recorded dementia diagnoses / Registered to a GP * 100

Diagnosis rate

• Estimated diagnoses
• Diagnosis rate (%)
• Lower 95& confidence limit
• Upper 95% confidence limit

This data is available in either the pcdem-nhs-rate-mmm-yyyy or pcdem-la-rate-mmm-yyyy CSVs.

Filter ORG_TYPE to COUNTRY_RESPONSIBILITITY or COUNTRY_GEOGRAPHICAL and the associated values for estimated diagnoses, diagnosis rate and confidence intervals are provided.

Assessments in reporting year

• Record of receiving a dementia assessment
• Record of an initial memory assessment
• Record of declining an initial memory assessment
• Record of referral to a memory clinic
• Record of declining a referral to a memory clinic

Data is no longer collected as it was removed from the service specification therefore the data is no longer extracted, and is not available for publication.

Additional measures relating to referrals have been added to the specification and are published within the pcdem-sub-icb-mmm-yyyy CSV file.

Care plans and reviews

• Received
• Declined

Recorded dementia diagnoses:

• With a diagnosis of psychosis
• Without a diagnosis of psychosis

Antipsychotic prescribing:

• with a diagnosis of psychosis
• without a diagnosis of psychosis

These counts can be derived from the pcdem-sub-icb-mmm-yyyy.csv file by filtering MEASURE to 'PRESCRIBING' and filtering BREAKDOWN to:

• PSY_DIAG
• NO_PSY_DIAG
• PSY_DIAG_WITH_ANTIPSYMEDS
• NO_PSY_DIAG_WITH_ANTIPSYMEDS

and aggregating the values accordingly

These counts can be derived from the pcdem-sub-icb-mmm-yyyy.csv file by filtering MEASURE to 'YOUNG_ONSET' and aggregating the values accordingly

These proportions can be derived using the counts described above. Proportions are calculated using the following formula:

Count of patients with recorded diagnosis of dementia in relevant age band and gender / Count of patients with recorded diagnosis of dementia in relevant gender

e.g. male patients aged 90+ with dementia / all male patients with dementia

These proportions can be derived using the counts described above. Proportions are calculated using the following formula:

Count of patients with recorded diagnosis of dementia in relevant ethnic group / Count of all patients with recorded diagnosis of dementia

e.g. Asian or Asian British patients with dementia / all patients with dementia

These proportions can be derived using the counts described above. Proportions are calculated using the following formula:

Count of patients with recorded diagnosis of dementia in relevant dementia type / Count of all patients with recorded diagnosis of dementia

e.g. patients with Alzheimer's disease / all patients with dementia

These proportions can be derived using the counts described above. Proportions are calculated using the following formula:

Count of patients with recorded diagnosis of dementia in relevant residence type / Count of all patients with recorded diagnosis of dementia

e.g. patients with dementia living in a nursing home / all patients with dementia