Baselight

Cambridgeshire Postcodes

Cambridgeshire Insight

@ukgov.cambridgeshire_postcodes1

PE' Postcode District
@ukgov.cambridgeshire_postcodes1.pe_postcode_district

  • 273.97 KB
  • 7635 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

PE120QX1053454230902952.662292-0.012089279E92000001E19000001E18000006E10000003E07000010E05009505CambridgeshireE10000003305400.769
PE120QY1053386930869252.659431-0.022170534E92000001E19000001E18000006E10000003E07000010E05009505CambridgeshireE10000003305400.769
PE120QZ1053394330781152.651497-0.021434606E92000001E19000001E18000006E10000003E07000010E05009505CambridgeshireE10000003305400.769
PE131AE1054608830963752.6647690.15877314E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769
PE131AF1054605430960852.6645180.15825793E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769
PE131AL1054618930983452.6665110.16035277E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769
PE131AN1054616730984752.6666340.16003345E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769
PE131AP1054617330981552.6663450.16010793E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769
PE131AQ1054611230975852.6658490.15918134E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769
PE131AR1054628530976452.6658570.16174024E92000001E19000001E18000006E10000003E07000010E05009503CambridgeshireE10000003305400.769

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

Share link

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