National Cataract Audit Year 1 Data
Healthcare Quality Improvement Partnership
@ukgov.national_cataract_audit_year_1_data
Healthcare Quality Improvement Partnership
@ukgov.national_cataract_audit_year_1_data
CREATE TABLE national_cataract_audit_year_1_data (
"trust_name" VARCHAR,
"country" VARCHAR,
"ods_code" VARCHAR,
"centre_number" BIGINT,
"number_of_patients" BIGINT,
"number_of_operations" BIGINT,
"percentage_first_eye_operations" DOUBLE,
"median_age_first_eye_operations" DOUBLE,
"percentage_second_eye_operations" DOUBLE,
"median_age_second_eye_operations" DOUBLE,
"number_hes_operations" DOUBLE,
"case_ascertainment" DOUBLE,
"time_fraction" DOUBLE,
"number_of_surgeons" BIGINT,
"percentage_operations_performed_by_consultant_surgeons" DOUBLE,
"percentage_operations_performed_by_career_grade_non_co_60a0488f" DOUBLE,
"percentage_operations_performed_by_experienced_trainee_surgeons" DOUBLE,
"percentage_operations_performed_by_less_experienced_tr_664732b3" DOUBLE,
"percentage_operations_with_a_missing_pre_operative_va" DOUBLE,
"median_pre_operative_logmar_va" DOUBLE,
"percentage_any_copathology" DOUBLE,
"unadjusted_pcr_rate" DOUBLE,
"adjusted_pcr_rate" DOUBLE,
"number_operations_eligible_for_post_operative_va" BIGINT,
"percentage_operations_with_a_missing_post_operative_va" DOUBLE,
"median_post_operative_logmar_va" DOUBLE,
"percentage_operations_with_change_in_va_data" DOUBLE,
"number_operations_eligible_for_va_loss" DOUBLE,
"unadjusted_va_loss_rate" DOUBLE,
"adjusted_va_loss_rate" DOUBLE
);
Anyone who has the link will be able to view this.