Baselight
Sign In

Camden Housing Stock

London Borough of Camden

@ukgov.camden_housing_stock

Table 1
@ukgov.camden_housing_stock.table_1

  • 716.73 KB
  • 40727 rows
  • 17 columns
property_reference

Property Reference

property_type

Property Type

property_subtype

Property Subtype

bedroom_count

Bedroom Count

leased

Leased

lease_start_date

Lease Start Date

district_name

District Name

estate_name

Estate Name

ward_name

Ward Name

easting

Easting

northing

Northing

longitude

Longitude

latitude

Latitude

location

Location

spatial_accuracy

Spatial Accuracy

last_uploaded

Last Uploaded

organisation_uri

Organisation URI

37543Flat2NoHOLBORN-Holborn and Covent GardenNo spatial data06/05/2025 08:52:05 AMhttp://opendatacommunities.org/id/london-borough-council/camden
41423Flat1YesMon Dec 02 1991 00:00:00 GMT+0000 (Coordinated Universal Time)HAMPSTEAD-BelsizeNo spatial data06/05/2025 08:52:06 AMhttp://opendatacommunities.org/id/london-borough-council/camden
39285Flat3YesMon Oct 15 1990 00:00:00 GMT+0000 (Coordinated Universal Time)CAMDEN TOWN-St Pancras and Somers TownNo spatial data06/05/2025 08:52:05 AMhttp://opendatacommunities.org/id/london-borough-council/camden
41437FlatNoKENTISH TOWN-Kentish Town SouthNo spatial data06/05/2025 08:52:05 AMhttp://opendatacommunities.org/id/london-borough-council/camden
41158Flat2NoGOSPEL OAK-HaverstockNo spatial data06/05/2025 08:52:06 AMhttp://opendatacommunities.org/id/london-borough-council/camden
42792GarageNoUNKNOWN DISTRICTUNKNOWN ESTATEGospel Oak528218185313No spatial data06/05/2025 08:52:24 AMhttp://opendatacommunities.org/id/london-borough-council/camden
42111GarageNoUNKNOWN DISTRICTUNKNOWN ESTATEHolborn and Covent Garden530208181293No spatial data06/05/2025 08:52:24 AMhttp://opendatacommunities.org/id/london-borough-council/camden
39208Flat2NoGOSPEL OAK-HaverstockNo spatial data06/05/2025 08:52:06 AMhttp://opendatacommunities.org/id/london-borough-council/camden
36073Flat4NoKENTISH TOWN-Kentish Town SouthNo spatial data06/05/2025 08:52:05 AMhttp://opendatacommunities.org/id/london-borough-council/camden
42820GarageNoUNKNOWN DISTRICTUNKNOWN ESTATEKilburn526144183951No spatial data06/05/2025 08:52:25 AMhttp://opendatacommunities.org/id/london-borough-council/camden

CREATE TABLE table_1 (
  "property_reference" DOUBLE,
  "property_type" VARCHAR,
  "property_subtype" VARCHAR,
  "bedroom_count" DOUBLE,
  "leased" VARCHAR,
  "lease_start_date" TIMESTAMP,
  "district_name" VARCHAR,
  "estate_name" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR
);