National Clinical Audit Of Psychosis Data For EIP Audit Report 2021/22
Healthcare Quality Improvement Partnership
@ukgov.national_clinical_audit_of_psychosis_for_eip_audit_rep_4e9c0cc6
Healthcare Quality Improvement Partnership
@ukgov.national_clinical_audit_of_psychosis_for_eip_audit_rep_4e9c0cc6
CREATE TABLE casenote_audit_data_for_england (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"gender" VARCHAR,
"unnamed_4" VARCHAR,
"age" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"ethnicity" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"work_education_or_training" VARCHAR,
"unnamed_17" VARCHAR,
"carer_family_support" VARCHAR,
"unnamed_19" VARCHAR,
"timely_access" VARCHAR,
"unnamed_21" VARCHAR,
"outcome_measures_honos" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"outcome_measure_honosca" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"outcome_measure_dialog" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"outcome_measures_qpr" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"outcome_measures_other" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"proportion_of_people_with_fep_with_clinical_outcome_me_4680f47d" VARCHAR,
"unnamed_43" VARCHAR,
"cognitive_behavioural_therapy_for_psychosis_cbtp" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"family_intervention" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"supported_employment_programme" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"commenced_a_course_of_antipsychotic_medication" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"proportion_of_people_with_fep_who_have_had_two_adequat_c8bf0695" VARCHAR,
"unnamed_61" VARCHAR,
"proportion_of_people_with_fep_who_were_offered_clozapine" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"carer_commenced_a_course_of_carer_focussed_education_a_1dbede00" VARCHAR,
"unnamed_66" VARCHAR,
"smoking_status_screening_carried_out_between_01_11_202_29f82674" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"alcohol_consumption_screening_carried_out_between_01_1_5cd00ce1" VARCHAR,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"harmful_or_hazardous_use_of_alcohol" VARCHAR,
"unnamed_76" VARCHAR,
"substance_misuse_screening_carried_out_between_01_11_2_17c4b3b2" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"bmi_screening_carried_out_between_01_11_2020_and_31_10_70f2f826" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"weight_recorded_before_and_after_commencing_antipsycho_0482034c" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"blood_pressure_screening_carried_out_between_01_11_202_b4ced8da" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"glucose_screening_carried_out_between_01_11_2020_and_3_c14045e9" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" VARCHAR,
"cholesterol_screening_carried_out_between_01_11_2020_a_12276fe3" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" VARCHAR,
"proportion_of_people_with_fep_who_were_screened_on_all_f327e507" VARCHAR
);
CREATE TABLE eip_2021_22_casenote_audit_data_for_wales (
"unnamed_0" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"gender" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"age" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"ethnicity" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"work_education_or_training" VARCHAR,
"unnamed_17" VARCHAR,
"carer_family_support" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"timely_access" VARCHAR,
"outcome_measures_honos" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"outcome_measure_honosca" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"outcome_measure_dialog" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"outcome_measures_qpr" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"outcome_measures_other" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"proportion_of_people_with_fep_with_clinical_outcome_me_4680f47d" VARCHAR,
"unnamed_43" VARCHAR,
"cognitive_behavioural_therapy_for_psychosis_cbtp" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"family_intervention" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"supported_employment_programme" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"commenced_a_course_of_antipsychotic_medication" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"proportion_of_people_with_fep_who_have_had_two_adequat_c8bf0695" VARCHAR,
"unnamed_61" VARCHAR,
"proportion_of_people_with_fep_who_were_offered_clozapine" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"carer_commenced_a_course_of_carer_focussed_education_a_1dbede00" VARCHAR,
"unnamed_66" VARCHAR,
"smoking_status_screening_carried_out_between_01_11_202_29f82674" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"alcohol_consumption_screening_carried_out_between_01_1_5cd00ce1" VARCHAR,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"harmful_or_hazardous_use_of_alcohol" VARCHAR,
"unnamed_76" VARCHAR,
"substance_misuse_screening_carried_out_between_01_11_2_17c4b3b2" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"bmi_screening_carried_out_between_01_11_2020_and_31_10_70f2f826" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"blood_pressure_screening_carried_out_between_01_11_202_b4ced8da" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"glucose_screening_carried_out_between_01_11_2020_and_3_c14045e9" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"cholesterol_screening_carried_out_between_01_11_2020_a_12276fe3" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"proportion_of_people_with_fep_who_were_screened_on_all_f327e507" VARCHAR,
"unnamed_96" VARCHAR,
"interventions_for_smoking_cessation_carried_out_at_any_fb293bbd" VARCHAR,
"unnamed_98" VARCHAR,
"unnamed_99" VARCHAR
);
Anyone who has the link will be able to view this.