About this Dataset

Online ONS Postcode Directory (Live)

This file contains the digital vector centroids for the Live Postcodes in the UK as at May 2025.

The centroids are of every live postcode in the United Kingdom

Contains both Ordnance Survey and ONS Intellectual Property Rights.

REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/Online_ONS_Postcode_Directory_Live/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2025-06-10T04:01:14Z

Tables

Table 1

@ukgov.online_ons_postcode_directory_live1.table_1

106.91 MB
1,804,637 rows
46 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "bua11" VARCHAR,
  "buasd11" VARCHAR,
  "calncv" VARCHAR,
  "ced" VARCHAR,
  "ctry" VARCHAR,
  "dointr" BIGINT,
  "doterm" VARCHAR,
  "icb" VARCHAR,
  "imd" BIGINT,
  "itl" VARCHAR,
  "lat" DOUBLE,
  "lep1" VARCHAR,
  "lep2" VARCHAR,
  "long" DOUBLE,
  "lsoa11" VARCHAR,
  "lsoa21" VARCHAR,
  "msoa11" VARCHAR,
  "msoa21" VARCHAR,
  "nhser" VARCHAR,
  "oa11" VARCHAR,
  "oa21" VARCHAR,
  "oac11" VARCHAR,
  "oscty" VARCHAR,
  "oseast1m" DOUBLE,
  "osgrdind" BIGINT,
  "oshlthau" VARCHAR,
  "oslaua" VARCHAR,
  "osnrth1m" DOUBLE,
  "osward" VARCHAR,
  "parish" VARCHAR,
  "park" VARCHAR,
  "pcd" VARCHAR,
  "pcd2" VARCHAR,
  "pcds" VARCHAR,
  "pcon" VARCHAR,
  "pfa" VARCHAR,
  "rgn" VARCHAR,
  "ru11ind" VARCHAR,
  "ruc21ind" VARCHAR,
  "sicbl" VARCHAR,
  "ttwa" VARCHAR,
  "usertype" BIGINT,
  "wz11" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);