About this Dataset

National Clinical Audit Of Psychosis Data For EIP Spotlight Audit Report 2018/19

National Clinical Audit of Psychosis Early Intervention in Psychosis (EIP) spotlight audit 2018/19 data aggregated by Mental Health Trusts in England. Data relates to patients aged 14-65 years, with first episode psychosis, who were on the caseload of an EIP team for 6 months or more at the census date (1 February 2018) and still on the caseload in September 2018 when the list of eligible patients were submitted for sampling.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2025-01-28T04:03:44Z

Tables

National Clinical Audit Of Psychosis Data For EIP Spotlight Audit Report 2018/19

@ukgov.national_clinical_audit_of_psychosis_for_eip_spotlight_6be13989.national_clinical_audit_of_psychosis_for_eip_spotlight_6be13989

77.72 KB
60 rows
67 columns


CREATE TABLE national_clinical_audit_of_psychosis_for_eip_spotlight_6be13989 (
  "organisation_id" VARCHAR,
  "trust_name" VARCHAR,
  "start_period" VARCHAR,
  "end_period" TIMESTAMP,
  "number_of_cases_requested" DOUBLE,
  "number_of_cases_submitted" DOUBLE,
  "final_sample_after_data_cleaning" DOUBLE,
  "started_treatment_in_0_2_weeks" VARCHAR,
  "started_treatment_in_2_weeks" VARCHAR,
  "proportion_of_people_with_fep_who_took_up_cbtp" VARCHAR,
  "proportion_of_people_with_fep_who_did_not_take_up_cbtp" VARCHAR,
  "proportion_of_people_with_fep_and_their_families_who_t_60b39595" VARCHAR,
  "proportion_of_people_with_fep_and_their_families_who_d_a946815e" VARCHAR,
  "proportion_of_people_with_fep_who_were_offered_clozapi_ee89b3e1" VARCHAR,
  "proportion_of_people_with_fep_who_were_not_offered_clo_ea9adf58" VARCHAR,
  "proportion_of_people_with_fep_who_were_not_in_work_who_e885c14c" VARCHAR,
  "proportion_of_people_with_fep_who_were_not_in_work_who_c7cd2ac9" VARCHAR,
  "proportion_of_people_with_fep_who_have_taken_up_suppor_54ab5761" VARCHAR,
  "proportion_of_people_with_fep_who_have_not_taken_up_su_637ed834" VARCHAR,
  "proportion_of_people_with_fep_who_were_screened_on_all_9ad27bb8" VARCHAR,
  "proportion_of_people_with_fep_who_were_screened_on_les_ad99aae2" VARCHAR,
  "monitoring_of_cigarette_smoking_screening_status_resul_6dac5bd4" VARCHAR,
  "monitoring_of_cigarette_smoking_screening_refused" VARCHAR,
  "monitoring_of_cigarette_smoking_not_recorded" VARCHAR,
  "monitoring_of_alcohol_consumption_screening_status_res_aad85b4e" VARCHAR,
  "monitoring_of_alcohol_consumption_screening_refused" VARCHAR,
  "monitoring_of_alcohol_consumption_not_recorded" VARCHAR,
  "monitoring_of_substance_misuse_screening_status_result_60f82a18" VARCHAR,
  "monitoring_of_substance_misuse_screening_refused" VARCHAR,
  "monitoring_of_substance_misuse_not_recorded" VARCHAR,
  "monitoring_of_bmi_screening_status_results_recorded" VARCHAR,
  "monitoring_of_bmi_screening_refused_patient_was_pregnant" VARCHAR,
  "monitoring_of_bmi_not_recorded" VARCHAR,
  "monitoring_of_blood_pressure_screening_status_results_recorded" VARCHAR,
  "monitoring_of_blood_pressure_screening_refused" VARCHAR,
  "monitoring_of_blood_pressure_not_recorded" VARCHAR,
  "monitoring_of_blood_glucose_control_screening_status_r_c55f4fea" VARCHAR,
  "monitoring_of_blood_glucose_control_screening_refused__e41780ee" VARCHAR,
  "monitoring_of_blood_glucose_control_not_recorded" VARCHAR,
  "monitoring_of_blood_lipids_screening_status_results_recorded" VARCHAR,
  "monitoring_of_blood_lipids_screening_refused" VARCHAR,
  "monitoring_of_blood_lipids_not_recorded" VARCHAR,
  "all_seven_physical_health_screenings_and_relevant_inte_77bdd72e" VARCHAR,
  "not_all_seven_physical_health_screenings_and_relevant__01313566" VARCHAR,
  "intervention_for_cigarette_smoking_offered_an_interven_d38f6907" VARCHAR,
  "intervention_for_cigarette_smoking_offered_an_interven_9c98f79a" VARCHAR,
  "intervention_for_cigarette_smoking_not_offered_an_intervention" VARCHAR,
  "intervention_for_harmful_or_hazardous_use_of_alcohol_o_660d0b9a" VARCHAR,
  "intervention_for_harmful_or_hazardous_use_of_alcohol_o_d77d945b" VARCHAR,
  "intervention_for_harmful_or_hazardous_use_of_alcohol_n_35a6ccea" VARCHAR,
  "intervention_for_substance_misuse_offered_an_intervent_4aca0c4b" VARCHAR,
  "intervention_for_substance_misuse_offered_an_intervent_e810367f" VARCHAR,
  "intervention_for_substance_misuse_not_offered_an_intervention" VARCHAR,
  "intervention_for_elevated_bmi_offered_an_intervention__b70fc51d" VARCHAR,
  "intervention_for_elevated_bmi_offered_an_intervention__8f6d73b6" VARCHAR,
  "intervention_for_elevated_bmi_not_offered_an_intervention" VARCHAR,
  "intervention_for_elevated_blood_pressure_offered_an_in_a54cf254" VARCHAR,
  "intervention_for_elevated_blood_pressure_offered_an_in_5b80d264" VARCHAR,
  "intervention_for_elevated_blood_pressure_intervention__a1db500c" VARCHAR,
  "intervention_for_elevated_blood_pressure_not_offered_a_35c4dbd1" VARCHAR,
  "intervention_for_abnormal_glucose_control_offered_an_i_37cdc58e" VARCHAR,
  "intervention_for_abnormal_glucose_control_offered_an_i_d3fc786d" VARCHAR,
  "intervention_for_abnormal_glucose_control_not_offered__83ea3eba" VARCHAR,
  "proportion_of_people_with_fep_whose_carers_took_up_or__42ae2f21" VARCHAR,
  "proportion_of_people_with_fep_whose_carers_did_not_tak_c3f3b712" VARCHAR,
  "proportion_of_people_with_fep_with_clinical_outcome_me_4680f47d" VARCHAR,
  "proportion_of_people_with_fep_not_with_clinical_outcom_ff005257" VARCHAR
);