About this Dataset

Cambridgeshire Postcodes

Data identifying the location of all the postcodes in Cambridgeshire. Extracted from OS Code-Point data® published by Ordnance Survey.

If data is used, please acknowledge the copyright and the source of the data by including the following attribution statements:

Contains OS data © Crown copyright and database right (2016)

Contains Royal Mail data © Royal Mail copyright and database right (2016)

Contains National Statistics data © Crown copyright and database right (2016)

For more details about licencing go to: https://certificates.theodi.org/en/datasets/352/certificate

Source: Code-Point® Open (Ordnance Survey) https://www.ordnancesurvey.co.uk/opendatadownload/products.html

All data is correct as of download date: 06/09/2016
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:27:26Z

Tables

CB' Postcode District

@ukgov.cambridgeshire_postcodes1.cb_postcode_district

279.46 kB
7,741 rows
15 columns

CREATE TABLE cb_postcode_district (
  "postcode" VARCHAR,
  "positional_quality_indicator" BIGINT,
  "eastings" BIGINT,
  "northings" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "country_code" VARCHAR,
  "nhs_regional_ha_code" VARCHAR,
  "nhs_ha_code" VARCHAR,
  "admin_county_code" VARCHAR,
  "admin_district_code" VARCHAR,
  "admin_ward_code" VARCHAR,
  "county" VARCHAR,
  "census_code" VARCHAR,
  "hectares" DOUBLE
);

MK' Postcode District

@ukgov.cambridgeshire_postcodes1.mk_postcode_district

11.15 kB
3 rows
15 columns

CREATE TABLE mk_postcode_district (
  "postcode" VARCHAR,
  "positional_quality_indicator" BIGINT,
  "eastings" BIGINT,
  "northings" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "country_code" VARCHAR,
  "nhs_regional_ha_code" VARCHAR,
  "nhs_ha_code" VARCHAR,
  "admin_county_code" VARCHAR,
  "admin_district_code" VARCHAR,
  "admin_ward_code" VARCHAR,
  "county" VARCHAR,
  "census_code" VARCHAR,
  "hectares" DOUBLE
);

PE' Postcode District

@ukgov.cambridgeshire_postcodes1.pe_postcode_district

280.55 kB
7,635 rows
15 columns

CREATE TABLE pe_postcode_district (
  "postcode" VARCHAR,
  "positional_quality_indicator" BIGINT,
  "eastings" BIGINT,
  "northings" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "country_code" VARCHAR,
  "nhs_regional_ha_code" VARCHAR,
  "nhs_ha_code" VARCHAR,
  "admin_county_code" VARCHAR,
  "admin_district_code" VARCHAR,
  "admin_ward_code" VARCHAR,
  "county" VARCHAR,
  "census_code" VARCHAR,
  "hectares" DOUBLE
);

SG' Postcode District

@ukgov.cambridgeshire_postcodes1.sg_postcode_district

38.87 kB
794 rows
15 columns

CREATE TABLE sg_postcode_district (
  "postcode" VARCHAR,
  "positional_quality_indicator" BIGINT,
  "eastings" BIGINT,
  "northings" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "country_code" VARCHAR,
  "nhs_regional_ha_code" VARCHAR,
  "nhs_ha_code" VARCHAR,
  "admin_county_code" VARCHAR,
  "admin_district_code" VARCHAR,
  "admin_ward_code" VARCHAR,
  "county" VARCHAR,
  "census_code" VARCHAR,
  "hectares" DOUBLE
);