Local Authority Land 2015

@ukgov.local_authority_owned.local_authority_land_2015

96.68 kB
1,667 rows
12 columns

CREATE TABLE local_authority_land_2015 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "type_of_site" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR,
  "notes_other" VARCHAR
);

Local Authority Land 2016

@ukgov.local_authority_owned.local_authority_land_2016

130.85 kB
1,922 rows
17 columns

CREATE TABLE local_authority_land_2016 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "type_of_site" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

Local Authority Land 2017

@ukgov.local_authority_owned.local_authority_land_2017

135.89 kB
1,976 rows
13 columns

CREATE TABLE local_authority_land_2017 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2018

@ukgov.local_authority_owned.local_authority_land_2018

135.33 kB
2,014 rows
13 columns

CREATE TABLE local_authority_land_2018 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2019

@ukgov.local_authority_owned.local_authority_land_2019

173.86 kB
2,588 rows
14 columns

CREATE TABLE local_authority_land_2019 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2020

@ukgov.local_authority_owned.local_authority_land_2020

173.56 kB
2,574 rows
14 columns

CREATE TABLE local_authority_land_2020 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2021

@ukgov.local_authority_owned.local_authority_land_2021

206.72 kB
3,134 rows
14 columns

CREATE TABLE local_authority_land_2021 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2023

@ukgov.local_authority_owned.local_authority_land_2023

217.03 kB
3,241 rows
14 columns

CREATE TABLE local_authority_land_2023 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land

About this Dataset