About this Dataset

National Statistics Postcode Lookup UK

This dataset contains the National Statistics Postcode Lookup (NSPL) for the United Kingdom. The NSPL relates current postcodes to a range of current statutory administrative, electoral, health and other statistical geographies via ‘best-fit’ allocation from the 2021 Census output areas. It supports the production of area based statistics from postcoded data. The NSPL is produced by ONS Geography, which provides geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations.
Publisher name: London Borough of Camden
Last updated: 2025-06-04T04:00:49Z

Tables

Table 1

@ukgov.national_statistics_postcode_lookup_uk.table_1

211.46 MB
1,791,830 rows
36 columns

CREATE TABLE table_1 (
  "postcode_1" VARCHAR,
  "postcode_2" VARCHAR,
  "postcode_3" VARCHAR,
  "date_introduced" BIGINT,
  "user_type" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "positional_quality" BIGINT,
  "county_code" VARCHAR,
  "county_name" VARCHAR,
  "local_authority_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "region_code" VARCHAR,
  "region_name" VARCHAR,
  "parliamentary_constituency_code" VARCHAR,
  "parliamentary_constituency_name" VARCHAR,
  "european_electoral_region_code" VARCHAR,
  "european_electoral_region_name" VARCHAR,
  "primary_care_trust_code" VARCHAR,
  "primary_care_trust_name" VARCHAR,
  "lower_super_output_area_code" VARCHAR,
  "lower_super_output_area_name" VARCHAR,
  "middle_super_output_area_code" VARCHAR,
  "middle_super_output_area_name" VARCHAR,
  "output_area_classification_code" VARCHAR,
  "output_area_classification_name" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" TIMESTAMP,
  "location" VARCHAR,
  "socrata_id" BIGINT
);