Dataset: Peterborough Land And Property Assets

About this Dataset

Peterborough Land And Property Assets

Dataset detailing the land and assets owned by Peterborough City Council
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:05Z

Tables

Peterborough Land And Propert Assets 2015

@ukgov.peterborough_land_and_property_assets1.peterborough_land_and_propert_assets_2015

113.97 KB
4667 rows
25 columns


CREATE TABLE peterborough_land_and_propert_assets_2015 (
  "publisher_label" VARCHAR,
  "publisher_uri" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "date_of_extract" VARCHAR,
  "unique_property_reference_number" DOUBLE,
  "unique_asset_identity" VARCHAR,
  "name" VARCHAR,
  "street_numbers" VARCHAR,
  "street_name" VARCHAR,
  "locality" VARCHAR,
  "postal_town" VARCHAR,
  "post_code" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "psma_end_user_licence" VARCHAR,
  "ownership" VARCHAR,
  "occupied_by_local_authority" VARCHAR,
  "ground_lease" VARCHAR,
  "leasehold" VARCHAR,
  "licence" VARCHAR,
  "vacant" VARCHAR,
  "sub_lease" VARCHAR,
  "ownership_detail" VARCHAR,
  "land_ony" VARCHAR
);

Peterborough Land And Propert Assets 2018

@ukgov.peterborough_land_and_property_assets1.peterborough_land_and_propert_assets_2018

96.68 KB
1868 rows
23 columns


CREATE TABLE peterborough_land_and_propert_assets_2018 (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "dateofextract" TIMESTAMP,
  "uniquepropertyreferencenumber" VARCHAR,
  "uniqueassetidentity" VARCHAR,
  "name" VARCHAR,
  "streetnumbers" VARCHAR,
  "streetname" VARCHAR,
  "locality" VARCHAR,
  "postaltown" VARCHAR,
  "postcode" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "psmaenduserlicence" VARCHAR,
  "ownership" VARCHAR,
  "occupiedbylocalauthority" VARCHAR,
  "groundlease" VARCHAR,
  "leasehold" VARCHAR,
  "licence" VARCHAR,
  "vacant" VARCHAR,
  "sublease" VARCHAR,
  "ownershipdetail" VARCHAR,
  "landony" VARCHAR
);

Peterborough Land And Propert Assets 2016

@ukgov.peterborough_land_and_property_assets1.peterborough_land_and_propert_assets_2016

94.5 KB
1863 rows
25 columns


CREATE TABLE peterborough_land_and_propert_assets_2016 (
  "publisher_label" VARCHAR,
  "publisher_uri" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "date_of_extract" VARCHAR,
  "unique_property_reference_number" VARCHAR,
  "unique_asset_identity" VARCHAR,
  "name" VARCHAR,
  "street_numbers" VARCHAR,
  "street_name" VARCHAR,
  "locality" VARCHAR,
  "postal_town" VARCHAR,
  "post_code" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "psma_end_user_licence" VARCHAR,
  "ownership" VARCHAR,
  "occupied_by_local_authority" VARCHAR,
  "ground_lease" VARCHAR,
  "leasehold" VARCHAR,
  "licence" VARCHAR,
  "vacant" VARCHAR,
  "sub_lease" VARCHAR,
  "ownership_detail" VARCHAR,
  "land_ony" VARCHAR
);

Peterborough Land And Propert Assets 2017

@ukgov.peterborough_land_and_property_assets1.peterborough_land_and_propert_assets_2017

98.72 KB
1880 rows
25 columns


CREATE TABLE peterborough_land_and_propert_assets_2017 (
  "publisher_label" VARCHAR,
  "publisher_uri" VARCHAR,
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "date_of_extract" VARCHAR,
  "unique_property_reference_number" VARCHAR,
  "unique_asset_identity" VARCHAR,
  "name" VARCHAR,
  "street_numbers" VARCHAR,
  "street_name" VARCHAR,
  "locality" VARCHAR,
  "postal_town" VARCHAR,
  "post_code" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "psma_end_user_licence" VARCHAR,
  "ownership" VARCHAR,
  "occupied_by_local_authority" VARCHAR,
  "ground_lease" VARCHAR,
  "leasehold" VARCHAR,
  "licence" VARCHAR,
  "vacant" VARCHAR,
  "sub_lease" VARCHAR,
  "ownership_detail" VARCHAR,
  "land_ony" VARCHAR
);