A best fit lookup between 2011 Output Areas (OA) and counties (CTY) as at 31 December 2011 in England. (File Size 5.5MB).

Field Names – OA11CD, CTY11CD, CTY11NM

Field Types – Text, Text, Text

Field Lengths – 9, 9, 16

@ukgov.output_area_2011_to_county_and_unitary_authority_decem_f6fb10ff.table_1

CREATE TABLE table_1 (
  "oa11cd" VARCHAR,
  "cty11cd" VARCHAR,
  "cty11nm" VARCHAR,
  "objectid" BIGINT
);