National Statistics Postcode Lookup Camden
London Borough of Camden
@ukgov.national_statistics_postcode_lookup_camden
London Borough of Camden
@ukgov.national_statistics_postcode_lookup_camden
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
);
Anyone who has the link will be able to view this.