National Cataract Audit Year 2 Data
Healthcare Quality Improvement Partnership
@ukgov.national_cataract_audit_year_2_data
Healthcare Quality Improvement Partnership
@ukgov.national_cataract_audit_year_2_data
CREATE TABLE national_cataract_audit_year_2_data (
"trustname" VARCHAR,
"odscode" VARCHAR,
"country" VARCHAR,
"itclocation" VARCHAR,
"centrenumber" BIGINT,
"numberhesoperations" BIGINT,
"timefraction" DOUBLE,
"numberoperationsca" BIGINT,
"caseascertainment" DOUBLE,
"numbereligibleoperations" BIGINT,
"numberofsurgeons" BIGINT,
"percentageoperationsconsultant" DOUBLE,
"percentageoperationscareer" DOUBLE,
"percentageoperationsexperienced" DOUBLE,
"percentageoperationsless" DOUBLE,
"numberofpatients" BIGINT,
"numopsexcludingbilateral" BIGINT,
"percentagefirsteyeoperations" DOUBLE,
"q1agefirsteyeoperations" DOUBLE,
"medianagefirsteyeoperations" DOUBLE,
"q3agefirsteyeoperations" DOUBLE,
"percentagesecondeyeoperations" DOUBLE,
"q1agesecondeyeoperations" DOUBLE,
"medianagesecondeyeoperations" DOUBLE,
"q3agesecondeyeoperations" DOUBLE,
"percentageopswithpreopva" DOUBLE,
"q1preoperativeva" DOUBLE,
"medianpreoperativeva" DOUBLE,
"q3preoperativeva" DOUBLE,
"percentageanycopathology" DOUBLE,
"casecomplexityindexpcr" DOUBLE,
"unadjustedpcrrate" DOUBLE,
"adjustedpcrrate" DOUBLE,
"numberopseligiblepostopva" DOUBLE,
"percentageopswithpostopva" DOUBLE,
"q1postoperativeva" DOUBLE,
"medianpostoperativeva" DOUBLE,
"q3postoperativeva" DOUBLE,
"percentageopschangevadata" DOUBLE,
"numberopseligiblevaloss" DOUBLE,
"casecomplexityindexvaloss" DOUBLE,
"unadjustedvalossrate" DOUBLE,
"adjustedvalossrate" DOUBLE
);
Anyone who has the link will be able to view this.