RCOphth NOD National Cataract Audit Year 4 Data
Royal College of Ophthalmologists
@ukgov.rcophth_nod_national_cataract_audit_year_4_data
Royal College of Ophthalmologists
@ukgov.rcophth_nod_national_cataract_audit_year_4_data
CREATE TABLE rcophth_nod_national_cataract_audit_year_4_data (
"trustname" VARCHAR,
"odscode" VARCHAR,
"country" VARCHAR,
"itclocation" VARCHAR,
"centrenumber" BIGINT,
"numberhesoperations" DOUBLE,
"timefraction" DOUBLE,
"numberoperationsca" DOUBLE,
"caseascertainment" DOUBLE,
"numbereligibleoperations" DOUBLE,
"numberofsurgeons" DOUBLE,
"percentageoperationsconsultant" DOUBLE,
"percentageoperationscareergrade" DOUBLE,
"percentageoperationsmoreexperiencedtrainees" DOUBLE,
"percentageoperationslessexperiencedtrainees" DOUBLE,
"numberofpatients" DOUBLE,
"numopsexcludingbilateral" DOUBLE,
"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,
"unadjustedpcrrate" DOUBLE,
"casecomplexityindexpcr" DOUBLE,
"adjustedpcrrate" DOUBLE,
"numberopseligiblepostopva" DOUBLE,
"percentageopswithpostopva" DOUBLE,
"q1postoperativeva" DOUBLE,
"medianpostoperativeva" DOUBLE,
"q3postoperativeva" DOUBLE,
"percentageopschangevadata" DOUBLE,
"numberopseligiblevaloss" DOUBLE,
"unadjustedvalossrate" DOUBLE,
"casecomplexityindexvaloss" DOUBLE,
"adjustedvalossrate" DOUBLE,
"information" VARCHAR
);
Anyone who has the link will be able to view this.