Leeds City Council Property Lets
Leeds City Council
@ukgov.leeds_city_council_property_lets
Leeds City Council
@ukgov.leeds_city_council_property_lets
This data is Leeds City Council's social housing property lets through its Choice Based Lettings scheme. Column descriptions ------------------- * CBL ID: Choice based lettings ID * AP Priority (DD + 1): Priority of the applicant and their category * AT Commencement date: Date the property was the advertised * AP Date award (DD+1): Date (if applicable) that the successful applicant was awarded any priority on their application * AP Application Date: Date the tenancy commenced * Weeks to Rehouse: No. of weeks it took the successful applicant to be rehoused * Property Type Desc: Type of property which was let * Ward Description: Ward area of the property * UDC Dte of Reg Quota: States if the property was let through the Date of Registration Quota (DORQ) policy * No of bids: Number of bids received for the property * Address\[1\]: Address line 1 of the property which was let * Address\[2\]: Address line 2 of the property which was let * Address\[3\]: Address line 3 of the property which was let * Pr Postcode: Post Code of the property which was let Product ------- * Check out the Social Housing Picker which uses these datasets to help prospective tenants when bidding for houses. * More information: https://datamillnorth.org/products/social-housing-picker/ Please note ----------- * These datasets are updated quarterly and show data on a rolling 5 year basis
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:45:59Z
CREATE TABLE choice_based_lettings (
"cbl_id" BIGINT,
"ap_priority_dd_1" VARCHAR -- AP Priority (DD + 1),
"at_commencement_date" TIMESTAMP,
"ap_application_date" TIMESTAMP,
"ap_date_award_dd_1" TIMESTAMP -- AP Date Award (DD+1),
"weeks_to_rehouse" BIGINT,
"property_type_desc" VARCHAR,
"ward_description" VARCHAR,
"udc_dte_of_reg_quota" VARCHAR,
"no_of_bids" BIGINT,
"address_1" VARCHAR -- Address[1],
"address_2" VARCHAR -- Address[2],
"address_3" VARCHAR -- Address[3],
"address_4" VARCHAR -- Address[4],
"pr_postcode" VARCHAR
);Anyone who has the link will be able to view this.