This is a best fit lookup between 2011 Output Areas (OA) and counties/unitary authorities as at 31 December 2017 in England. (File Size - 18 MB)

Field Names - OA11CD, CTYUA17CD, CTYUA17NM

Field Types - Text, Text, Text

Field Lengths - 9, 9, 28

For more information and an overview of best-fitting follow this link -

https://geoportal.statistics.gov.uk/datasets/f0aac7ccbfd04cda9eb03e353c613faa/about
Publisher name: Office for National Statistics
Last updated: 2025-04-26T04:04:03Z

@ukgov.output_area_2011_to_county_and_unitary_authority_decem_6b4d9b6b.table_1

CREATE TABLE table_1 (
  "oa11cd" VARCHAR,
  "ctyua16cd" VARCHAR,
  "ctyua16nm" VARCHAR,
  "fid" BIGINT
);