Baselight

National Statistics Postcode Lookup Camden

London Borough of Camden

@ukgov.national_statistics_postcode_lookup_camden

Loading...
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.