Baselight

Council Housing Stock

Leeds City Council

@ukgov.council_housing_stock

September 2019
@ukgov.council_housing_stock.september_2019

  • 600.81 KB
  • 76522 rows
  • 9 columns
n__id

Id

address1

Address1

address2

Address2

postcode

Postcode

ward

Ward

property_type

Property Type

year_built

Year Built

sold_date

Sold Date

demolished_date

Demolished Date

1YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979Mon Aug 21 1989 00:00:00 GMT+0000 (Coordinated Universal Time)
2YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979Mon Apr 09 1990 00:00:00 GMT+0000 (Coordinated Universal Time)
3YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979Mon Aug 05 1996 00:00:00 GMT+0000 (Coordinated Universal Time)
4YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979Mon Jul 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)
5YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979
6YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979
7YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979
8YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979
9YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979
10YeadonYeadonLS19 7Otley & Yeadon2 Bed Flat1979

CREATE TABLE september_2019 (
  "n__id" BIGINT,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "postcode" VARCHAR,
  "ward" VARCHAR,
  "property_type" VARCHAR,
  "year_built" BIGINT,
  "sold_date" TIMESTAMP,
  "demolished_date" TIMESTAMP
);

Share link

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