About this Dataset

Private Registered Provider Housing In Our Area

This data is based on the Homes and Communities Agency (HCA) Statistical Data Return (SDR).
It provides a list of Private Registered Providers (including registered social landlords, housing associations, almshouses etc) who own and manage homes in the Cambridge housing sub-region and Peterborough.

The 2013-14 data includes a simple yes/no as to whether providers own general needs, supported housing, housing for older people and low cost homes ownership housing.

The 2014-15 and 2015-16 data includes the number of homes owned and managed under the same four headings.

The 2016-17 data is provided in three sections: housing stock, rents, and affordable rents. These are the worksheets form the SDR which provide information by local authority area. The full SDR contains much more information, but not by local authority; just by housing provider. Each provider may own and manage homes in a number of local authorities.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:33:54Z

Tables

Local Registered Provider Housing 'affordable' Rent, 2016-17

@ukgov.private_registered_provider_housing_in_our_area1.local_registered_provider_housing_affordable_rent_2016_17

192.06 kB
83 rows
167 columns

CREATE TABLE local_registered_provider_housing_affordable_rent_2016_17 (
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "size_of_organisation" VARCHAR,
  "local_authority_name" VARCHAR,
  "la_code" VARCHAR,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_91a09f4c" DOUBLE  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_b2900a8b" DOUBLE  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_b68c2cb6" DOUBLE  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_c94942b9" DOUBLE  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_4d283410" VARCHAR  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_f7019089" VARCHAR  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_1848464d" VARCHAR  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_c6774b1c" VARCHAR  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_bedspace_non_self_contain_9b41b636" DOUBLE  -- Aff Rent - General Needs - Owned - Bedspace (non-self-contained) - Total Units/bedspaces,
  "aff_rent_general_needs_owned_bedsit_total_units_bedspa_0516aa07" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_bedsit_average_weekly_ren_cca42a93" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_bedsit_accommodation_with_36c52601" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_bedsit_average_service_ch_22b64ca2" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_bedsit_accommodation_with_a71937ff" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_bedsit_average_service_ch_124d42a6" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_bedsit_total_units_bedspa_ea5f104b" VARCHAR  -- Aff Rent - General Needs - Owned - Bedsit - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_bedsit_average_weekly_ren_aa6dac3a" VARCHAR  -- Aff Rent - General Needs - Owned - Bedsit - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_bedsit_total_units_bedspaces" DOUBLE  -- Aff Rent - General Needs - Owned - Bedsit - Total Units/bedspaces,
  "aff_rent_general_needs_owned_one_bedroom_total_units_b_d84ecd51" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_one_bedroom_average_weekl_5118ec90" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_one_bedroom_accommodation_92821cd7" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_one_bedroom_average_servi_8991ebfb" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_one_bedroom_accommodation_ac514580" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_one_bedroom_average_servi_f8cf87ec" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_one_bedroom_total_units_b_71584af5" VARCHAR  -- Aff Rent - General Needs - Owned - One Bedroom - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_one_bedroom_average_weekl_f442f1be" VARCHAR  -- Aff Rent - General Needs - Owned - One Bedroom - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_one_bedroom_total_units_bedspaces" DOUBLE  -- Aff Rent - General Needs - Owned - One Bedroom - Total Units/bedspaces,
  "aff_rent_general_needs_owned_two_bedrooms_total_units__905cfe29" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_two_bedrooms_average_week_c6de2700" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_two_bedrooms_accommodatio_ed6d130b" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_two_bedrooms_average_serv_26130e57" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_two_bedrooms_accommodatio_4ede126d" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_two_bedrooms_average_serv_29cd6dd6" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_two_bedrooms_total_units__5e87c433" VARCHAR  -- Aff Rent - General Needs - Owned - Two Bedrooms - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_two_bedrooms_average_week_53244cee" VARCHAR  -- Aff Rent - General Needs - Owned - Two Bedrooms - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_two_bedrooms_total_units_bedspaces" DOUBLE  -- Aff Rent - General Needs - Owned - Two Bedrooms - Total Units/bedspaces,
  "aff_rent_general_needs_owned_three_bedrooms_total_unit_2d7acc7e" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_three_bedrooms_average_we_24f78a97" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_three_bedrooms_accommodat_fdb86b05" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_three_bedrooms_average_se_097f0b31" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_three_bedrooms_accommodat_d3438ba7" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_three_bedrooms_average_se_2b234f58" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_three_bedrooms_total_unit_74cdd866" VARCHAR  -- Aff Rent - General Needs - Owned - Three Bedrooms - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_three_bedrooms_average_we_3e60c34d" VARCHAR  -- Aff Rent - General Needs - Owned - Three Bedrooms - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_three_bedrooms_total_unit_e876c403" DOUBLE  -- Aff Rent - General Needs - Owned - Three Bedrooms - Total Units/bedspaces,
  "aff_rent_general_needs_owned_four_bedrooms_total_units_f512bf9b" DOUBLE  -- Aff Rent - General Needs - Owned - Four Bedrooms - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_four_bedrooms_average_wee_2a4d30b1" DOUBLE  -- Aff Rent - General Needs - Owned - Four Bedrooms - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_four_bedrooms_accommodati_16a6e97f" DOUBLE  -- Aff Rent - General Needs - Owned - Four Bedrooms - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_four_bedrooms_average_ser_548b0aaf" DOUBLE  -- Aff Rent - General Needs - Owned - Four Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_four_bedrooms_accommodati_b2081ab8" VARCHAR  -- Aff Rent - General Needs - Owned - Four Bedrooms - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_four_bedrooms_average_ser_8830b41f" VARCHAR  -- Aff Rent - General Needs - Owned - Four Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_four_bedrooms_total_units_664ecbd5" VARCHAR  -- Aff Rent - General Needs - Owned - Four Bedrooms - Total Units/bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_four_bedrooms_average_wee_c669317f" VARCHAR  -- Aff Rent - General Needs - Owned - Four Bedrooms - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_four_bedrooms_total_units_1197418b" DOUBLE  -- Aff Rent - General Needs - Owned - Four Bedrooms - Total Units/bedspaces,
  "aff_rent_general_needs_owned_five_bedrooms_total_units_c374adff" DOUBLE  -- Aff Rent - General Needs - Owned - Five Bedrooms - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_five_bedrooms_average_wee_344551d7" DOUBLE  -- Aff Rent - General Needs - Owned - Five Bedrooms - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_five_bedrooms_accommodati_510f6703" DOUBLE  -- Aff Rent - General Needs - Owned - Five Bedrooms - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_five_bedrooms_average_ser_c1c85369" DOUBLE  -- Aff Rent - General Needs - Owned - Five Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_five_bedrooms_accommodati_81c276cc" VARCHAR  -- Aff Rent - General Needs - Owned - Five Bedrooms - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_five_bedrooms_average_ser_438f3b1e" VARCHAR  -- Aff Rent - General Needs - Owned - Five Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_five_bedrooms_total_units_f017abc3" VARCHAR  -- Aff Rent - General Needs - Owned - Five Bedrooms - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_five_bedrooms_average_wee_57ef6108" VARCHAR  -- Aff Rent - General Needs - Owned - Five Bedrooms - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_five_bedrooms_total_units_c5985086" DOUBLE  -- Aff Rent - General Needs - Owned - Five Bedrooms - Total Units/bedspaces,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_tota_cea8559b" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_ec864226" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_acco_c9d5672e" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_38aca55e" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_acco_f23823a6" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_8883690f" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_tota_05d0aa7e" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_976c0571" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_six_or_more_bedrooms_tota_d5f6688a" VARCHAR  -- Aff Rent - General Needs - Owned - Six Or More Bedrooms - Total Units/bedspaces,
  "aff_rent_general_needs_owned_total_self_contained_weig_25122512" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_total_self_contained_weig_6ae3f4c6" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_total_self_contained_weig_18b2ae9b" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_total_self_contained_weig_558a7a93" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_total_self_contained_weig_03b32278" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_total_self_contained_weig_eafb58e6" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_total_self_contained_weig_a200b648" VARCHAR  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_owned_total_self_contained_weig_0cbb1fce" VARCHAR  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_owned_total_self_contained_weig_48819d90" DOUBLE  -- Aff Rent - General Needs - Owned - Total Self-contained/ Weighted Average - Total Units/bedspaces,
  "aff_rent_general_needs_owned_total_units_bedspaces_exc_f999171a" DOUBLE  -- Aff Rent - General Needs - Owned - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_weighted_average_weekly_r_245dcc7e" DOUBLE  -- Aff Rent - General Needs - Owned - Weighted Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_total_accommodation_with__29aab8fb" DOUBLE  -- Aff Rent - General Needs - Owned - Total Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_weighted_average_service__ec8effe5" DOUBLE  -- Aff Rent - General Needs - Owned - Weighted Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_owned_total_accommodation_with__f218ed27" DOUBLE  -- Aff Rent - General Needs - Owned - Total Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_general_needs_owned_weighted_average_service__ab8523f6" DOUBLE  -- Aff Rent - General Needs - Owned - Weighted Average Service Charge Not Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_general_needs_total_units_bedspaces_subject_t_fcfe38f0" VARCHAR  -- Aff Rent - General Needs - Total Units/ Bedspaces Subject To HIST Arrangements,
  "aff_rent_general_needs_weighted_average_weekly_rent_of_fa0838c5" VARCHAR  -- Aff Rent - General Needs - Weighted Average Weekly Rent (of Those Properties Subject To HIST Arrangements) (Łs),
  "aff_rent_general_needs_total_units_bedspaces" DOUBLE  -- Aff Rent - General Needs - Total Units/bedspaces,
  "aff_rent_supported_housing_and_housing_for_older_peopl_cd8f8c60" VARCHAR  -- Aff Rent - Supported Housing And Housing For Older People - Owned - Bedspace (non-self-contained) - Total Units/ Bedspaces (excluding Those Subject To HIST),
  "aff_rent_supported_housing_and_housing_for_older_peopl_4e0e1070" VARCHAR  -- Aff Rent - Supported Housing And Housing For Older People - Owned - Bedspace (non-self-contained) - Average Weekly Rent (excluding Those Subject To HIST) (Łs),
  "aff_rent_supported_housing_and_housing_for_older_peopl_ef6a6a7e" VARCHAR  -- Aff Rent - Supported Housing And Housing For Older People - Owned - Bedspace (non-self-contained) - Accommodation With Service Charges Eligible For Housing Benefit (excluding Those Subject To HIST),
  "aff_rent_supported_housing_and_housing_for_older_peopl_69df776b" VARCHAR  -- Aff Rent - Supported Housing And Housing For Older People - Owned - Bedspace (non-self-contained) - Average Service Charge Eligible For Housing Benefit (excluding Those Subject To HIST) (Łs),
  "aff_rent_supported_housing_and_housing_for_older_peopl_635504f6" VARCHAR  -- Aff Rent - Supported Housing And Housing For Older People - Owned - Bedspace (non-self-contained) - Accommodation With Service Charges Not Eligible For Housing Benefit (excluding Those Subject To HIST)
);

Local Registered Provider Housing Rents, 2016-17

@ukgov.private_registered_provider_housing_in_our_area1.local_registered_provider_housing_rents_2016_17

263.9 kB
161 rows
203 columns

CREATE TABLE local_registered_provider_housing_rents_2016_17 (
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "size_of_organisation" VARCHAR,
  "local_authority_name" VARCHAR,
  "la_code" VARCHAR,
  "general_needs_owned_bedspace_non_self_contained_total__5e5f1bdb" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_bedspace_non_self_contained_averag_834b7464" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedspace_non_self_contained_number_dcaa321f" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_bedspace_non_self_contained_averag_dc1c189c" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedspace_non_self_contained_number_373f8b30" VARCHAR  -- General Needs - Owned - Bedspace (non-self-contained) - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_bedspace_non_self_contained_averag_0a58e5b8" VARCHAR  -- General Needs - Owned - Bedspace (non-self-contained) - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedspace_non_self_contained_total__a6627098" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_bedspace_non_self_contained_averag_e9e19eb6" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedspace_non_self_contained_total__5f9ab7e1" VARCHAR  -- General Needs - Owned - Bedspace (non-self-contained) - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_bedspace_non_self_contained_averag_a7260c66" VARCHAR  -- General Needs - Owned - Bedspace (non-self-contained) - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_bedspace_non_self_contained_total__94482323" DOUBLE  -- General Needs - Owned - Bedspace (non-self-contained) - Total Units / Bedspaces,
  "general_needs_owned_bedsit_total_units_bedspaces_exclu_8fdf6033" DOUBLE  -- General Needs - Owned - Bedsit - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_bedsit_average_weekly_rent_excludi_1a014e6f" DOUBLE  -- General Needs - Owned - Bedsit - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedsit_number_of_units_bedspaces_w_411fc7ba" DOUBLE  -- General Needs - Owned - Bedsit - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_bedsit_average_service_charge_elig_5415be59" DOUBLE  -- General Needs - Owned - Bedsit - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedsit_number_of_units_bedspaces_w_07f19eb7" DOUBLE  -- General Needs - Owned - Bedsit - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_bedsit_average_service_charge_not__32773705" DOUBLE  -- General Needs - Owned - Bedsit - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedsit_total_number_of_units_bedsp_678e32c6" DOUBLE  -- General Needs - Owned - Bedsit - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_bedsit_average_social_rent_rate_ca_e9a8ad0d" DOUBLE  -- General Needs - Owned - Bedsit - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_bedsit_total_number_of_units_bedsp_cc86d2a5" VARCHAR  -- General Needs - Owned - Bedsit - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_bedsit_average_weekly_rent_of_prop_5217b907" VARCHAR  -- General Needs - Owned - Bedsit - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_bedsit_total_units_bedspaces" DOUBLE  -- General Needs - Owned - Bedsit - Total Units / Bedspaces,
  "general_needs_owned_one_bedroom_total_units_bedspaces__18983523" DOUBLE  -- General Needs - Owned - One Bedroom - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_one_bedroom_average_weekly_rent_ex_7092916e" DOUBLE  -- General Needs - Owned - One Bedroom - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_one_bedroom_number_of_units_bedspa_a370bda9" DOUBLE  -- General Needs - Owned - One Bedroom - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_one_bedroom_average_service_charge_46340f40" DOUBLE  -- General Needs - Owned - One Bedroom - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_one_bedroom_number_of_units_bedspa_9ef73c67" DOUBLE  -- General Needs - Owned - One Bedroom - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_one_bedroom_average_service_charge_2d6119b3" DOUBLE  -- General Needs - Owned - One Bedroom - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_one_bedroom_total_number_of_units__b7389740" DOUBLE  -- General Needs - Owned - One Bedroom - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_one_bedroom_average_social_rent_ra_b8e9ea06" DOUBLE  -- General Needs - Owned - One Bedroom - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_one_bedroom_total_number_of_units__ff7900cf" VARCHAR  -- General Needs - Owned - One Bedroom - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_one_bedroom_average_weekly_rent_of_c304c04b" VARCHAR  -- General Needs - Owned - One Bedroom - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_one_bedroom_total_units_bedspaces" DOUBLE  -- General Needs - Owned - One Bedroom - Total Units / Bedspaces,
  "general_needs_owned_two_bedrooms_total_units_bedspaces_116f805b" DOUBLE  -- General Needs - Owned - Two Bedrooms - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_two_bedrooms_average_weekly_rent_e_c5d0b90b" DOUBLE  -- General Needs - Owned - Two Bedrooms - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_two_bedrooms_number_of_units_bedsp_8f799f43" DOUBLE  -- General Needs - Owned - Two Bedrooms - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_two_bedrooms_average_service_charg_d16c3f68" DOUBLE  -- General Needs - Owned - Two Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_two_bedrooms_number_of_units_bedsp_d2a07068" DOUBLE  -- General Needs - Owned - Two Bedrooms - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_two_bedrooms_average_service_charg_f415048c" DOUBLE  -- General Needs - Owned - Two Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_two_bedrooms_total_number_of_units_1a8fc798" DOUBLE  -- General Needs - Owned - Two Bedrooms - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_two_bedrooms_average_social_rent_r_1e1a16bf" DOUBLE  -- General Needs - Owned - Two Bedrooms - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_two_bedrooms_total_number_of_units_409caa86" VARCHAR  -- General Needs - Owned - Two Bedrooms - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_two_bedrooms_average_weekly_rent_o_c191612a" VARCHAR  -- General Needs - Owned - Two Bedrooms - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_two_bedrooms_total_units_bedspaces" DOUBLE  -- General Needs - Owned - Two Bedrooms - Total Units / Bedspaces,
  "general_needs_owned_three_bedrooms_total_units_bedspac_7976140d" DOUBLE  -- General Needs - Owned - Three Bedrooms - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_three_bedrooms_average_weekly_rent_b2a4a8a0" DOUBLE  -- General Needs - Owned - Three Bedrooms - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_three_bedrooms_number_of_units_bed_d66c0fd8" DOUBLE  -- General Needs - Owned - Three Bedrooms - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_three_bedrooms_average_service_cha_6604591f" DOUBLE  -- General Needs - Owned - Three Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_three_bedrooms_number_of_units_bed_06248f08" DOUBLE  -- General Needs - Owned - Three Bedrooms - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_three_bedrooms_average_service_cha_0b2a1393" DOUBLE  -- General Needs - Owned - Three Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_three_bedrooms_total_number_of_uni_217c6d53" DOUBLE  -- General Needs - Owned - Three Bedrooms - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_three_bedrooms_average_social_rent_55fce3bc" DOUBLE  -- General Needs - Owned - Three Bedrooms - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_three_bedrooms_total_number_of_uni_2bd6bc47" VARCHAR  -- General Needs - Owned - Three Bedrooms - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_three_bedrooms_average_weekly_rent_28af9e14" VARCHAR  -- General Needs - Owned - Three Bedrooms - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_three_bedrooms_total_units_bedspaces" DOUBLE  -- General Needs - Owned - Three Bedrooms - Total Units / Bedspaces,
  "general_needs_owned_four_bedrooms_total_units_bedspace_a976c5e2" DOUBLE  -- General Needs - Owned - Four Bedrooms - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_four_bedrooms_average_weekly_rent__13d734dc" DOUBLE  -- General Needs - Owned - Four Bedrooms - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_four_bedrooms_number_of_units_beds_2ac051e8" DOUBLE  -- General Needs - Owned - Four Bedrooms - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_four_bedrooms_average_service_char_a197c4df" DOUBLE  -- General Needs - Owned - Four Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_four_bedrooms_number_of_units_beds_f1ab5210" DOUBLE  -- General Needs - Owned - Four Bedrooms - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_four_bedrooms_average_service_char_18c008dc" DOUBLE  -- General Needs - Owned - Four Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_four_bedrooms_total_number_of_unit_0528eff0" DOUBLE  -- General Needs - Owned - Four Bedrooms - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_four_bedrooms_average_social_rent__5e4586e1" DOUBLE  -- General Needs - Owned - Four Bedrooms - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_four_bedrooms_total_number_of_unit_68bd7dc7" VARCHAR  -- General Needs - Owned - Four Bedrooms - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_four_bedrooms_average_weekly_rent__80a5734c" VARCHAR  -- General Needs - Owned - Four Bedrooms - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_four_bedrooms_total_units_bedspaces" DOUBLE  -- General Needs - Owned - Four Bedrooms - Total Units / Bedspaces,
  "general_needs_owned_five_bedrooms_total_units_bedspace_be23b5a4" DOUBLE  -- General Needs - Owned - Five Bedrooms - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_five_bedrooms_average_weekly_rent__96848f5f" DOUBLE  -- General Needs - Owned - Five Bedrooms - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_five_bedrooms_number_of_units_beds_53fa2d05" DOUBLE  -- General Needs - Owned - Five Bedrooms - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_five_bedrooms_average_service_char_8e1cbdda" DOUBLE  -- General Needs - Owned - Five Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_five_bedrooms_number_of_units_beds_9a4ba254" VARCHAR  -- General Needs - Owned - Five Bedrooms - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_five_bedrooms_average_service_char_1a78f7bf" VARCHAR  -- General Needs - Owned - Five Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_five_bedrooms_total_number_of_unit_83dc5d4f" VARCHAR  -- General Needs - Owned - Five Bedrooms - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_five_bedrooms_average_social_rent__2532ede3" DOUBLE  -- General Needs - Owned - Five Bedrooms - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_five_bedrooms_total_number_of_unit_94f135ab" VARCHAR  -- General Needs - Owned - Five Bedrooms - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_five_bedrooms_average_weekly_rent__9bef5aa4" VARCHAR  -- General Needs - Owned - Five Bedrooms - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_five_bedrooms_total_units_bedspaces" DOUBLE  -- General Needs - Owned - Five Bedrooms - Total Units / Bedspaces,
  "general_needs_owned_six_or_more_bedrooms_total_units_b_2f48c597" DOUBLE  -- General Needs - Owned - Six Or More Bedrooms - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_six_or_more_bedrooms_average_weekl_e95445c7" DOUBLE  -- General Needs - Owned - Six Or More Bedrooms - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_six_or_more_bedrooms_number_of_uni_ebea82cb" DOUBLE  -- General Needs - Owned - Six Or More Bedrooms - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_six_or_more_bedrooms_average_servi_1fb0dc08" DOUBLE  -- General Needs - Owned - Six Or More Bedrooms - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_six_or_more_bedrooms_number_of_uni_e6191923" VARCHAR  -- General Needs - Owned - Six Or More Bedrooms - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_six_or_more_bedrooms_average_servi_dc2c4729" VARCHAR  -- General Needs - Owned - Six Or More Bedrooms - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_six_or_more_bedrooms_total_number__4286e21c" VARCHAR  -- General Needs - Owned - Six Or More Bedrooms - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST),
  "general_needs_owned_six_or_more_bedrooms_average_socia_2f903c33" DOUBLE  -- General Needs - Owned - Six Or More Bedrooms - Average Social Rent Rate Calculated As Per The WRWA 2016 (excluding IR AR And HIST) (śs),
  "general_needs_owned_six_or_more_bedrooms_total_number__ee091611" VARCHAR  -- General Needs - Owned - Six Or More Bedrooms - Total Number Of Units/bedspaces Subject To HIST Arrangements,
  "general_needs_owned_six_or_more_bedrooms_average_weekl_18c63a04" VARCHAR  -- General Needs - Owned - Six Or More Bedrooms - Average Weekly Rent Of Properties Subject To HIST Arrangements (śs),
  "general_needs_owned_six_or_more_bedrooms_total_units_bedspaces" DOUBLE  -- General Needs - Owned - Six Or More Bedrooms - Total Units / Bedspaces,
  "general_needs_owned_self_contained_total_units_bedspac_89cfbd61" DOUBLE  -- General Needs - Owned - Self-contained - Total Units/bedspaces (excluding IR AR And HIST),
  "general_needs_owned_self_contained_average_weekly_rent_02ec08c8" DOUBLE  -- General Needs - Owned - Self-contained - Average Weekly Rent (excluding IR AR And HIST) (śs),
  "general_needs_owned_self_contained_number_of_units_bed_3aeb5c67" DOUBLE  -- General Needs - Owned - Self-contained - Number Of Units/bedspaces With Service Charges Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_self_contained_average_service_cha_1a361112" DOUBLE  -- General Needs - Owned - Self-contained - Average Service Charge Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_self_contained_number_of_units_bed_f453f74d" DOUBLE  -- General Needs - Owned - Self-contained - Number Of Units/bedspaces With Service Charges Not Eligible For Housing Benefit (excluding IR AR And HIST),
  "general_needs_owned_self_contained_average_service_cha_0975b067" DOUBLE  -- General Needs - Owned - Self-contained - Average Service Charge Not Eligible For Housing Benefit (excluding IR AR And HIST) (śs),
  "general_needs_owned_self_contained_total_number_of_uni_03a18269" DOUBLE  -- General Needs - Owned - Self-contained - Total Number Of Units/bedspaces That Have An Absolute (full) Exception As Defined In WRWA 2016 Regulations (excluding IR AR And HIST)
);

Local Registered Provider Housing Stock, 2016-17

@ukgov.private_registered_provider_housing_in_our_area1.local_registered_provider_housing_stock_2016_17

32.32 kB
221 rows
26 columns

CREATE TABLE local_registered_provider_housing_stock_2016_17 (
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "size_of_organisation" VARCHAR,
  "local_authority_name" VARCHAR,
  "la_code" VARCHAR,
  "general_needs_self_contained_owned_low_cost_rental_acc_c2d12657" DOUBLE  -- General Needs - Self Contained - Owned Low Cost Rental Accommodation By Local Authority Area,
  "general_needs_bedspace_non_self_contained_owned_low_co_7e17879e" DOUBLE  -- General Needs - Bedspace (non-self-contained) - Owned Low Cost Rental Accommodation By Local Authority Area,
  "supported_housing_owned_low_cost_rental_accommodation__4731bd43" DOUBLE  -- Supported Housing - Owned Low Cost Rental Accommodation (units / Bedspaces) By Local Authority Area,
  "housing_for_older_people_owned_low_cost_rental_accommo_57183488" DOUBLE  -- Housing For Older People - Owned Low Cost Rental Accommodation (units / Bedspaces) By Local Authority Area,
  "total_number_of_owned_units_which_fail_the_dhs_by_loca_aca88bde" DOUBLE  -- Total Number Of Owned Units Which Fail The DHS By Local Authority Area,
  "general_needs_self_contained_managed_low_cost_rental_a_1886c17e" DOUBLE  -- General Needs - Self Contained - Managed Low Cost Rental Accommodation By Local Authority Area,
  "general_needs_bedspace_non_self_contained_managed_low__9c16970d" DOUBLE  -- General Needs - Bedspace (non-self-contained) - Managed Low Cost Rental Accommodation By Local Authority Area,
  "supported_housing_managed_low_cost_rental_accommodatio_39062d8b" DOUBLE  -- Supported Housing - Managed Low Cost Rental Accommodation (units / Bedspaces) By Local Authority Area,
  "housing_for_older_people_managed_low_cost_rental_accom_8318be5f" DOUBLE  -- Housing For Older People - Managed Low Cost Rental Accommodation (units / Bedspaces) By Local Authority Area,
  "low_cost_home_ownership_units_owned_where_purchaser_ha_508e7878" DOUBLE  -- Low Cost Home Ownership Units Owned Where Purchaser Has <100% Equity,
  "low_cost_home_ownership_units_managed_only_where_purch_6b2d2321" DOUBLE  -- Low Cost Home Ownership Units (Managed Only) Where Purchaser Has <100% Equity,
  "first_tranche_low_cost_home_ownership_sales" DOUBLE,
  "n_100_staircased_low_cost_home_ownership_sales" DOUBLE  -- 100% Staircased Low Cost Home Ownership Sales,
  "total_sales_to_registered_providers" DOUBLE,
  "total_sales_to_tenants" DOUBLE,
  "total_sales_to_other" DOUBLE,
  "total_demolitions" DOUBLE,
  "other_losses" DOUBLE,
  "general_needs_self_contained_units_vacant_and_availabl_549bddea" DOUBLE  -- General Needs Self Contained Units Vacant And Available For Letting,
  "general_needs_self_contained_units_vacant_and_not_avai_c17a64b2" DOUBLE  -- General Needs Self Contained Units Vacant And Not Available For Letting,
  "total_general_needs_self_contained_units_vacant" DOUBLE
);

Private Registered Provider Housing 2014-15

@ukgov.private_registered_provider_housing_in_our_area1.private_registered_provider_housing_2014_15

16.49 kB
238 rows
12 columns

CREATE TABLE private_registered_provider_housing_2014_15 (
  "la_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "total_general_needs_stock_owned" DOUBLE  -- Total General Needs Stock (owned),
  "total_general_needs_stock_managed" DOUBLE  -- Total General Needs Stock (managed),
  "total_supported_housing_owned" DOUBLE  -- Total Supported Housing (owned),
  "total_supported_housing_managed" DOUBLE  -- Total Supported Housing (managed),
  "total_housing_for_older_people_owned" DOUBLE  -- Total Housing For Older People (owned),
  "total_housing_for_older_people_managed" DOUBLE  -- Total Housing For Older People (managed),
  "total_low_cost_home_ownership_where_purchaser_has_100__6fa7c935" DOUBLE  -- Total Low Cost Home Ownership Where Purchaser Has <100% Equity (owned),
  "total_low_cost_home_ownership_where_purchaser_has_100__77836771" DOUBLE  -- Total Low Cost Home Ownership Where Purchaser Has <100% Equity (managed)
);

Private Registered Provider Housing 2015-16

@ukgov.private_registered_provider_housing_in_our_area1.private_registered_provider_housing_2015_16

16.87 kB
227 rows
12 columns

CREATE TABLE private_registered_provider_housing_2015_16 (
  "la_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "total_general_needs_stock_owned" BIGINT  -- Total General Needs Stock (owned),
  "total_general_needs_stock_managed" DOUBLE  -- Total General Needs Stock (managed),
  "total_supported_housing_owned" DOUBLE  -- Total Supported Housing (owned),
  "total_supported_housing_managed" DOUBLE  -- Total Supported Housing (managed),
  "total_housing_for_older_people_owned" DOUBLE  -- Total Housing For Older People (owned),
  "total_housing_for_older_people_managed" DOUBLE  -- Total Housing For Older People (managed),
  "total_low_cost_home_ownership_where_purchaser_has_100__6fa7c935" DOUBLE  -- Total Low Cost Home Ownership Where Purchaser Has <100% Equity (owned),
  "total_low_cost_home_ownership_where_purchaser_has_100__77836771" DOUBLE  -- Total Low Cost Home Ownership Where Purchaser Has <100% Equity (managed)
);