Baselight
Sign In

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

Loading...
Loading...

About this Dataset

National Clinical Audit Of Psychosis Data For EIP Audit Report 2021/22

National Clinical Audit of Psychosis (NCAP) early intervention psychosis (EIP) 2021/22 audit report data. The data were first published in July 2022, separate reports were provided for for England and Wales: ‘National Clinical Audit of Psychosis – National Report for England: Early Intervention in Psychosis Audit 2021/22’. ‘National Clinical Audit of Psychosis – National Report for Wales: Early Intervention in Psychosis Audit 2021/22’. Data are provided at a Trust/Health Board level and relate to patients aged 65 years and under, with first-episode psychosis, who were on the caseload of an EIP team for 6 months or more at the census date (1 April 2021) and still on the caseload in September 2021 when the list of eligible patients were submitted for sampling.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-06-14T04:02:58Z

Tables

Casenote Audit Data For England

@ukgov.national_clinical_audit_of_psychosis_for_eip_audit_rep_4e9c0cc6.casenote_audit_data_for_england
  • 161.65 kB
  • 55 rows
  • 177 columns
Loading... 
CREATE TABLE casenote_audit_data_for_england (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "gender" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "age" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "ethnicity" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "work_education_or_training" VARCHAR  -- Work, Education Or Training,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "carer_family_support" VARCHAR,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "timely_access" VARCHAR,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "outcome_measures_honos" VARCHAR  -- Outcome Measures - HoNOS,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "outcome_measure_honosca" VARCHAR  -- Outcome Measure - HoNOSCA,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "outcome_measure_dialog" VARCHAR  -- Outcome Measure - DIALOG,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "outcome_measures_qpr" VARCHAR  -- Outcome Measures - QPR,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "outcome_measures_other" VARCHAR  -- Outcome Measures - Other,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "proportion_of_people_with_fep_with_clinical_outcome_me_4680f47d" VARCHAR  -- Proportion Of People With FEP With Clinical Outcome Measurement Data (two Or More Outcome Measures) Recorded At Least Twice,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "cognitive_behavioural_therapy_for_psychosis_cbtp" VARCHAR  -- Cognitive Behavioural Therapy For Psychosis (CBTp),
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "family_intervention" VARCHAR,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "supported_employment_programme" VARCHAR,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "commenced_a_course_of_antipsychotic_medication" VARCHAR,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "proportion_of_people_with_fep_who_have_had_two_adequat_c8bf0695" VARCHAR  -- Proportion Of People With FEP Who Have Had Two Adequate But Unsuccessful Trials Of Antipsychotic Medications,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "proportion_of_people_with_fep_who_were_offered_clozapine" VARCHAR,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "carer_commenced_a_course_of_carer_focussed_education_a_1dbede00" VARCHAR  -- Carer Commenced A Course Of Carer-focussed Education And Support Programme,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "smoking_status_screening_carried_out_between_01_11_202_29f82674" VARCHAR  -- Smoking Status Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "alcohol_consumption_screening_carried_out_between_01_1_5cd00ce1" VARCHAR  -- Alcohol Consumption Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "harmful_or_hazardous_use_of_alcohol" VARCHAR,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "substance_misuse_screening_carried_out_between_01_11_2_17c4b3b2" VARCHAR  -- Substance Misuse Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "bmi_screening_carried_out_between_01_11_2020_and_31_10_70f2f826" VARCHAR  -- BMI Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "weight_recorded_before_and_after_commencing_antipsycho_0482034c" VARCHAR  -- Weight Recorded Before And After Commencing Antipsychotic Medication,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "blood_pressure_screening_carried_out_between_01_11_202_b4ced8da" VARCHAR  -- Blood Pressure Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "glucose_screening_carried_out_between_01_11_2020_and_3_c14045e9" VARCHAR  -- Glucose Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "cholesterol_screening_carried_out_between_01_11_2020_a_12276fe3" VARCHAR  -- Cholesterol Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "proportion_of_people_with_fep_who_were_screened_on_all_f327e507" VARCHAR  -- Proportion Of People With FEP Who Were Screened On All Seven Physical Health Measures
);

EIP 2021/22 Casenote Audit Data For Wales

@ukgov.national_clinical_audit_of_psychosis_for_eip_audit_rep_4e9c0cc6.eip_2021_22_casenote_audit_data_for_wales
  • 126.02 kB
  • 55 rows
  • 179 columns
Loading... 
CREATE TABLE eip_2021_22_casenote_audit_data_for_wales (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "gender" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "age" VARCHAR,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "ethnicity" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "work_education_or_training" VARCHAR  -- Work, Education Or Training,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "carer_family_support" VARCHAR,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "timely_access" VARCHAR,
  "outcome_measures_honos" VARCHAR  -- Outcome Measures - HoNOS,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "outcome_measure_honosca" VARCHAR  -- Outcome Measure - HoNOSCA,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "outcome_measure_dialog" VARCHAR  -- Outcome Measure - DIALOG,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "outcome_measures_qpr" VARCHAR  -- Outcome Measures - QPR,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "outcome_measures_other" VARCHAR  -- Outcome Measures - Other,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "proportion_of_people_with_fep_with_clinical_outcome_me_4680f47d" VARCHAR  -- Proportion Of People With FEP With Clinical Outcome Measurement Data (two Or More Outcome Measures) Recorded At Least Twice,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "cognitive_behavioural_therapy_for_psychosis_cbtp" VARCHAR  -- Cognitive Behavioural Therapy For Psychosis (CBTp),
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "family_intervention" VARCHAR,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "supported_employment_programme" VARCHAR,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "commenced_a_course_of_antipsychotic_medication" VARCHAR,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "proportion_of_people_with_fep_who_have_had_two_adequat_c8bf0695" VARCHAR  -- Proportion Of People With FEP Who Have Had Two Adequate But Unsuccessful Trials Of Antipsychotic Medications,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "proportion_of_people_with_fep_who_were_offered_clozapine" VARCHAR,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "carer_commenced_a_course_of_carer_focussed_education_a_1dbede00" VARCHAR  -- Carer Commenced A Course Of Carer-focussed Education And Support Programme,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "smoking_status_screening_carried_out_between_01_11_202_29f82674" VARCHAR  -- Smoking Status Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "alcohol_consumption_screening_carried_out_between_01_1_5cd00ce1" VARCHAR  -- Alcohol Consumption Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "harmful_or_hazardous_use_of_alcohol" VARCHAR,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "substance_misuse_screening_carried_out_between_01_11_2_17c4b3b2" VARCHAR  -- Substance Misuse Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "bmi_screening_carried_out_between_01_11_2020_and_31_10_70f2f826" VARCHAR  -- BMI Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "blood_pressure_screening_carried_out_between_01_11_202_b4ced8da" VARCHAR  -- Blood Pressure Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "glucose_screening_carried_out_between_01_11_2020_and_3_c14045e9" VARCHAR  -- Glucose Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "cholesterol_screening_carried_out_between_01_11_2020_a_12276fe3" VARCHAR  -- Cholesterol Screening Carried Out Between 01/11/2020 And 31/10/2021 While The Person Was On The EIP Caseload,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "proportion_of_people_with_fep_who_were_screened_on_all_f327e507" VARCHAR  -- Proportion Of People With FEP Who Were Screened On All Seven Physical Health Measures,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "interventions_for_smoking_cessation_carried_out_at_any_fb293bbd" VARCHAR  -- Interventions For Smoking Cessation Carried Out At Any Time Between 01/11/2020 And 31/10/2021, While The Person Was On The EIP Caseload (percentages Will Not Add Up To 100% As This Was A Multiple Choice Question),
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

Share link

Anyone who has the link will be able to view this.