Dataset: National Statistics Postcode Lookup Camden

About this Dataset

National Statistics Postcode Lookup Camden

This dataset contains the National Statistics Postcode Lookup (NSPL) for the London Borough of Camden. 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_camden.table_1

564.75 KB
8226 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
);