About this Dataset

HMO Licensing Register

WARNING: This register is intended for the purpose of identifying licensed HMOs and management arrangements in the London Borough of Camden. It is not intended for marketing purposes and none of the individuals or organisations mentioned within this register have given their consent for such use. If you receive unsolicited direct marketing from agencies, please contact them directly and ask them to stop.

The maximum permitted number of persons has been determined following an inspection. Other background data relating to number of bedrooms, amenities etc. has been populated according to the application as submitted. This may not represent the actual number of usable bedrooms and facilities permitted under the final licence subsequently granted.
Publisher name: London Borough of Camden
Last updated: 2025-06-26T04:02:03Z

Tables

Table 1

@ukgov.hmo_licensing_register.table_1

399.41 kB
2,985 rows
33 columns

CREATE TABLE table_1 (
  "notice" VARCHAR,
  "licence_number" BIGINT,
  "type_of_licence" VARCHAR,
  "status" VARCHAR,
  "property_address" VARCHAR,
  "name_of_licence_holder" VARCHAR,
  "address_of_licence_holder" VARCHAR,
  "name_of_person_managing" VARCHAR,
  "address_of_manager" VARCHAR,
  "maximum_number_of_persons" BIGINT,
  "commencement_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "duration_in_years" DOUBLE,
  "storeys_of_hmo" DOUBLE,
  "number_of_rooms" DOUBLE,
  "number_of_living_rooms" DOUBLE,
  "number_of_bedrooms" DOUBLE,
  "number_of_kitchens" DOUBLE,
  "number_of_self_contained_flats" DOUBLE,
  "number_of_non_self_contained_flats" DOUBLE,
  "number_of_shared_sinks" DOUBLE,
  "number_of_shared_whbs" DOUBLE,
  "number_of_shared_showers" DOUBLE,
  "number_of_shared_wcs" DOUBLE,
  "number_of_shared_baths" DOUBLE,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR
);