Spotlight Dataset 49: Data Quality Maturity Index (DQMI)
https://factsanddimensions.co.uk
Facts and Dimensions provide 1000s of tables of publicly available stats and reference data, ready to query immediately.
This video concentrates on schema Data_Quality_Maturity_Index
Data back to 2016
As at time of video: 1.3million rows
All sorts of data covering
1. Various Datasets
MAT
DID
CYPHS
A&E
CSDS
AE
MHSDS
IAPT
MSDS
ECDS
APC
OP
2. Various Data Items
ESTIMATED DATE OF DELIVERY METHOD (AGREED)
SOURCE OF REFERRAL FOR OUTPATIENTS
SOURCE OF REFERRAL FOR MENTAL HEALTH
ORGANISATION CODE (CODE OF PROVIDER)
ETHNIC CATEGORY (MOTHER)
EX-BRITISH ARMED FORCES INDICATOR
ETHNIC CATEGORY
CARE PROFESSIONAL MAIN SPECIALTY CODE
SITE CODE (OF TREATMENT)
DECIDED TO ADMIT DATE
GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION)
NHS NUMBER STATUS INDICATOR CODE (MOTHER)
SOURCE OF REFERRAL FOR A and E
MENTAL HEALTH ACT LEGAL STATUS CLASSIFICATION CODE
POSTCODE OF USUAL ADDRESS (MOTHER)
ORGANISATION CODE (CODE OF COMMISSIONER)
DISCHARGE DESTINATION CODE (HOSPITAL PROVIDER SPELL)
PERSON BIRTH DATE
CONSULTANT CODE
ADMINISTRATIVE CATEGORY CODE (ON ADMISSION)
SOURCE OF ADMISSION CODE (HOSPITAL PROVIDER SPELL)
NHS NUMBER
ORGANISATION IDENTIFIER (CODE OF COMMISSIONER)
PERSON BIRTH DATE (Experimental, does not contribute towards scores)
TREATMENT FUNCTION CODE (MENTAL HEALTH) (Experimental, does not contribute towards scores)
CARE PROFESSIONAL SERVICE OR TEAM TYPE ASSOCIATION (MENTAL HEALTH) (Experimental, does not contribute towards scores)
POSTCODE OF USUAL ADDRESS
ORGANISATION SITE IDENTIFIER (OF TREATMENT)
NULL
PERSON BIRTH DATE (MOTHER)
HOSPITAL BED TYPE (MENTAL HEALTH)
SERVICE OR TEAM TYPE REFERRED TO (MENTAL HEALTH)
REFERRED OUT OF AREA REASON (ADULT ACUTE MENTAL HEALTH) (Experimental, does not contribute towards scores)
REFERRED OUT OF AREA REASON (ADULT ACUTE MENTAL HEALTH)
PATIENT CLASSIFICATION CODE
PERSON STATED GENDER CODE
DISCHARGE DATE (HOSPITAL PROVIDER SPELL)
GENERAL MEDICAL PRACTICE CODE (PATIENT REGISTRATION (MOTHER))
ADMINISTRATIVE CATEGORY CODE
PRIMARY REASON FOR REFERRAL (MENTAL HEALTH) (REFERRAL RECEIVED ON OR AFTER 1ST JAN 2016) (Experimental, does not contribute towards scores)
EX-BRITISH ARMED FORCES INDICATOR (Experimental, does not contribute towards scores)
NHS NUMBER STATUS INDICATOR CODE
CARE PROFESSIONAL SERVICE OR TEAM TYPE ASSOCIATION (MENTAL HEALTH)
ADMISSION METHOD (HOSPITAL PROVIDER SPELL)
PERSON GENDER CODE CURRENT
NHS NUMBER (MOTHER)
SOURCE OF REFERRAL FOR COMMUNITY
ACTIVITY TREATMENT FUNCTION CODE
PRIMARY DIAGNOSIS (ICD)
CLINICAL RESPONSE PRIORITY TYPE (Experimental, does not contribute towards scores)
MENTAL HEALTH ACT LEGAL STATUS CLASSIFICATION CODE (Experimental, does not contribute towards scores)
CLINICAL RESPONSE PRIORITY TYPE
PRIMARY REASON FOR REFERRAL (MENTAL HEALTH) (REFERRAL RECEIVED ON OR AFTER 1ST JAN 2016)
SERVICE OR TEAM TYPE REFERRED TO (MENTAL HEALTH) (Experimental, does not contribute towards scores)
TREATMENT FUNCTION CODE (MENTAL HEALTH)
ORGANISATION SITE IDENTIFIER (OF TREATMENT) (Experimental, does not contribute towards scores)
DISCHARGE METHOD CODE (HOSPITAL PROVIDER SPELL)
3. Measures
Dataset
Data Provider Code
Recorded Data Item
Complete Denominator
Valid Numerator
Valid Numerator Str
Default Numerator
Default Numerator str
Threshold Value
Threshold Value Str
Defaults In Excess
Defaults In Excess Str
Coverage Per Dataset
DQMI
Dataset Score
Data Item Score
Data Item Score Str
National Data Item Average
Reporting Period
Experimental DQMI Score
Experimental Dataset Score