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

Field Names - OA11CD, CTYUA18CD, CTYUA18NM

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: 2024-12-10T02:15:14Z

@ukgov.output_area_2011_to_county_and_unitary_authority_decem_ce59b803.table_1

CREATE TABLE table_1 (
  "oa11cd" VARCHAR,
  "ctyua18cd" VARCHAR,
  "ctyua18nm" VARCHAR,
  "fid" BIGINT
);