Baselight

Cambridgeshire Postcodes

Cambridgeshire Insight

@ukgov.cambridgeshire_postcodes1

CB' Postcode District
@ukgov.cambridgeshire_postcodes1.cb_postcode_district

  • 272.92 KB
  • 7741 rows
  • 15 columns
postcode

Postcode

positional_quality_indicator

Positional Quality Indicator

eastings

Eastings

northings

Northings

latitude

Latitude

longitude

Longitude

country_code

Country Code

nhs_regional_ha_code

NHS Regional HA Code

nhs_ha_code

NHS HA Code

admin_county_code

Admin County Code

admin_district_code

Admin District Code

admin_ward_code

Admin Ward Code

county

County

census_code

Census Code

hectares

Hectares

CB1 0AH1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0AN1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0AP1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0BD1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0BX1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0FY1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0GJ1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0GL1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0GN1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769
CB1 0GR1054618225704352.1922540.13717936E92000001E19000001E18000006E10000003E07000008E05002706CambridgeshireE10000003305400.769

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

Share link

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