Baselight
Sign In

Homelessness In England

Cambridgeshire Insight

@ukgov.homelessness_in_england1

About this Dataset

Homelessness In England

Statistics about homelessness for every local authority in England.

This includes annual data covering 2009-10 to 2017-18 based on CLG live table 784, known as the P1E returns.

There are also quarterly returns (live table 784a) which cover April to June; July to September, September to December and January to March, since April 2013 available on the CLG webpage (see links)

Both are provided in excel and csv format.

These data help us compare trends across the country for the decisions local authorities make when people apply to them as homeless and each district's use of temporary accommodation.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-10T23:28:41Z

Tables

Table 1

@ukgov.homelessness_in_england1.table_1
  • 476.37 KB
  • 65447 rows
  • 192 columns 

CREATE TABLE table_1 (
  "ons_code" VARCHAR,
  "local_authority_area" VARCHAR,
  "region" VARCHAR,
  "n_2009_10_thousands_of_households_2006_mid_year_estimate" DOUBLE,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_44265127" VARCHAR,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_ed731969" VARCHAR,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_43adf073" VARCHAR,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_949b63eb" VARCHAR,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_cd6e5c17" VARCHAR,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_d48ce136" VARCHAR,
  "n_2009_10_numbers_accepted_as_homeless_and_in_priority_5e90324d" DOUBLE,
  "n_2009_10_number_accepted_per_1000_households" DOUBLE,
  "n_2009_10_total_decisions_where_eligible_homeless_in_p_a1d6926c" VARCHAR,
  "n_2009_10_total_decisions_where_eligible_homeless_but__9df24b1a" VARCHAR,
  "n_2009_10_total_decisions_where_eligible_but_not_homeless" VARCHAR,
  "n_2009_10_total_homelessness_decisions" VARCHAR,
  "n_31_march_2010_total_households_in_b_b_including_shared_annex" VARCHAR,
  "n_31_march_2010_total_households_in_hostels" VARCHAR,
  "n_31_march_2010_total_households_in_la_ha_stock" VARCHAR,
  "n_31_march_2010_total_households_in_private_sector_lea_49dad942" VARCHAR,
  "n_31_march_2010_total_households_in_other_temp_includi_8dcebede" VARCHAR,
  "n_31_march_2010_total_households_in_temporary_accommodation" DOUBLE,
  "n_31_march_2010_number_in_temp_per_1000_households" DOUBLE,
  "n_2009_10_duty_owed_but_no_accommodation_has_been_secu_17ebd59a" DOUBLE,
  "n_2010_11_thousands_of_households_2008_mid_year_estimate" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_0b31c3a7" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_a004d359" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_b2762090" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_d421b5d6" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_4ad9f8a2" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_441b378f" DOUBLE,
  "n_2010_11_numbers_accepted_as_homeless_and_in_priority_2c374c4b" DOUBLE,
  "n_2010_11_number_accepted_per_1000_households" DOUBLE,
  "n_2010_11_total_decisions_where_eligible_homeless_in_p_8f6b8b2d" DOUBLE,
  "n_2010_11_total_decisions_where_eligible_homeless_but__9c44bf61" DOUBLE,
  "n_2010_11_total_decisions_where_eligible_but_not_homeless" DOUBLE,
  "n_2010_11_total_homelessness_decisions" DOUBLE,
  "n_31_march_2011_total_households_in_b_b_including_shared_annex" DOUBLE,
  "n_31_march_2011_total_households_in_hostels" DOUBLE,
  "n_31_march_2011_total_households_in_la_ha_stock" DOUBLE,
  "n_31_march_2011_total_households_in_private_sector_lea_9e4d0398" DOUBLE,
  "n_31_march_2011_total_households_in_other_temp_includi_e8676c27" DOUBLE,
  "n_31_march_2011_total_households_in_temporary_accommodation" DOUBLE,
  "n_31_march_2011_number_in_temp_per_1000_households" DOUBLE,
  "n_2010_11_duty_owed_but_no_accommodation_has_been_secu_0387acee" DOUBLE,
  "n_2011_12_thousands_of_households_2008_mid_year_estimate" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_668a41ad" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_7f2930e7" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_cbb9b8b5" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_dd2ea5a0" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_326edd31" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_43f016f4" DOUBLE,
  "n_2011_12_numbers_accepted_as_homeless_and_in_priority_0276de6b" DOUBLE,
  "n_2011_12_number_accepted_per_1000_households" DOUBLE,
  "n_2011_12_total_decisions_where_eligible_homeless_in_p_9820b76a" DOUBLE,
  "n_2011_12_total_decisions_where_eligible_homeless_but__d4ea049e" DOUBLE,
  "n_2011_12_total_decisions_where_eligible_but_not_homeless" DOUBLE,
  "n_2011_12_total_homelessness_decisions" DOUBLE,
  "n_31_march_2012_total_households_in_b_b_including_shared_annex" DOUBLE,
  "n_31_march_2012_total_households_in_hostels" DOUBLE,
  "n_31_march_2012_total_households_in_la_ha_stock" DOUBLE,
  "n_31_march_2012_total_households_in_private_sector_lea_413416ba" DOUBLE,
  "n_31_march_2012_total_households_in_other_temp_includi_d30899c9" DOUBLE,
  "n_31_march_2012_total_households_in_temporary_accommodation" DOUBLE,
  "n_31_march_2012_number_in_temp_per_1000_households" DOUBLE,
  "n_2011_12_duty_owed_but_no_accommodation_has_been_secu_0a29ec42" DOUBLE,
  "n_2012_13_thousands_of_households_2008_based_interim_p_3242a780" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_c2e3344a" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_86c4a071" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_df132a8d" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_adc898dc" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_f2642ea5" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_4a354775" DOUBLE,
  "n_2012_13_numbers_accepted_as_homeless_and_in_priority_1201ac7b" DOUBLE,
  "n_2012_13_number_accepted_per_1000_households" DOUBLE,
  "n_2012_13_total_decisions_where_eligible_homeless_in_p_823faa58" DOUBLE,
  "n_2012_13_total_decisions_where_eligible_homeless_but__5d4a49eb" DOUBLE,
  "n_2012_13_total_decisions_where_eligible_but_not_homeless" DOUBLE,
  "n_2012_13_total_homelessness_decisions" DOUBLE,
  "n_31_march_2013_total_households_in_b_b_including_shared_annex" DOUBLE,
  "n_31_march_2013_total_households_in_hostels" DOUBLE,
  "n_31_march_2013_total_households_in_la_ha_stock" DOUBLE,
  "n_31_march_2013_total_households_in_private_sector_lea_1bc79659" DOUBLE,
  "n_31_march_2013_total_households_in_other_temp_includi_7148d962" DOUBLE,
  "n_31_march_2013_total_households_in_temporary_accommodation" DOUBLE,
  "n_31_march_2013_number_in_temp_per_1000_households" DOUBLE,
  "n_2012_13_duty_owed_but_no_accommodation_has_been_secu_aef18d84" DOUBLE,
  "n_2013_14_thousands_of_households_2012_based_interim_p_d0083ca0" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_dff5bfff" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_645852ff" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_052a2cbb" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_c07ebc3f" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_ba965ca6" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_c767ef74" DOUBLE,
  "n_2013_14_numbers_accepted_as_homeless_and_in_priority_9ca7bf68" DOUBLE,
  "n_2013_14_number_accepted_per_1000_households" DOUBLE,
  "n_2013_14_total_decisions_where_eligible_homeless_in_p_b6499f7b" DOUBLE,
  "n_2013_14_total_decisions_where_eligible_homeless_but__51521a30" DOUBLE,
  "n_2013_14_total_decisions_where_eligible_but_not_homeless" DOUBLE,
  "n_2013_14_total_homelessness_decisions" DOUBLE
);

Three Monthly Update On Homelessness Across England

@ukgov.homelessness_in_england1.three_monthly_update_on_homelessness_across_england
  • 247.18 KB
  • 327 rows
  • 149 columns 

CREATE TABLE three_monthly_update_on_homelessness_across_england (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "apr_to_june_2014_thousands_of_households_2012_based_ho_e2dcdba1" DOUBLE,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__eec65b53" VARCHAR,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__e34e4e66" VARCHAR,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__476806b9" VARCHAR,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__690a00ed" VARCHAR,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__cade9d0a" VARCHAR,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__1c6302aa" VARCHAR,
  "apr_to_june_2014_accepted_as_homeless_and_in_priority__c6e407cd" VARCHAR,
  "apr_to_june_2014_accepted_homeless_per_1000_households" VARCHAR,
  "apr_to_june_2014_eligible_homeless_and_in_priority_nee_99fddab3" VARCHAR,
  "apr_to_june_2014_eligible_homeless_but_not_in_priority_need" VARCHAR,
  "apr_to_june_2014_eligible_but_not_homeless" VARCHAR,
  "apr_to_june_2014_total_decisions" VARCHAR,
  "on_30_june_2014_households_accommodated_in_bed_and_bre_669d19c8" VARCHAR,
  "on_30_june_2014_households_accommodated_in_hostels" VARCHAR,
  "on_30_june_2014_households_accommodated_in_la_ha_stock" VARCHAR,
  "on_30_june_2014_households_accommodated_in_private_sec_7cf37c36" VARCHAR,
  "on_30_june_2014_households_accommodated_in_other_tempo_a092cf04" VARCHAR,
  "on_30_june_2014_total_households_in_temporary_accommodation" VARCHAR,
  "on_30_june_2014_number_in_temp_per_1000_households" VARCHAR,
  "on_30_june_2014_duty_owed_but_no_accommodation_secured" VARCHAR,
  "jul_to_sept_2014_thousands_of_households_2012_based_ho_a0e5af1d" DOUBLE,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__1fe9e5db" VARCHAR,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__390f9760" VARCHAR,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__81ed8425" VARCHAR,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__3ec0c8cd" VARCHAR,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__1c65760f" VARCHAR,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__c8fea202" VARCHAR,
  "jul_to_sept_2014_accepted_as_homeless_and_in_priority__d98b9bca" VARCHAR,
  "jul_to_sept_2014_accepted_homeless_per_1000_households" VARCHAR,
  "jul_to_sept_2014_eligible_homeless_and_in_priority_nee_9eaecf2c" VARCHAR,
  "jul_to_sept_2014_eligible_homeless_but_not_in_priority_need" VARCHAR,
  "jul_to_sept_2014_eligible_but_not_homeless" VARCHAR,
  "jul_to_sept_2014_total_decisions" VARCHAR,
  "on_30_sept_2014_households_accommodated_in_bed_and_bre_22c43a1d" VARCHAR,
  "on_30_sept_2014_households_accommodated_in_hostels" VARCHAR,
  "on_30_sept_2014_households_accommodated_in_la_ha_stock" VARCHAR,
  "on_30_sept_2014_households_accommodated_in_private_sec_815d3967" VARCHAR,
  "on_30_sept_2014_households_accommodated_in_other_tempo_5d0a47c1" VARCHAR,
  "on_30_sept_2014_total_households_in_temporary_accommodation" VARCHAR,
  "on_30_sept_2014_number_in_temp_per_1000_households" VARCHAR,
  "on_30_sept_2014_duty_owed_but_no_accommodation_has_bee_31aac1b8" VARCHAR,
  "oct_to_dec_2014_thousands_of_households_2012_based_hou_90746774" DOUBLE,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_need_white" VARCHAR,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_n_04fb2d2e" VARCHAR,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_n_66cca71c" VARCHAR,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_need_mixed" VARCHAR,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_n_6ab3b7e8" VARCHAR,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_n_a9917ea8" VARCHAR,
  "oct_to_dec_2014_accepted_as_homeless_and_in_priority_need_total" VARCHAR,
  "oct_to_dec_2014_accepted_homeless_per_1000_households" VARCHAR,
  "oct_to_dec_2014_eligible_homeless_and_in_priority_need_6bc3757c" VARCHAR,
  "oct_to_dec_2014_eligible_homeless_but_not_in_priority_need" VARCHAR,
  "oct_to_dec_2014_eligible_but_not_homeless" VARCHAR,
  "oct_to_dec_2014_total_decisions" VARCHAR,
  "on_31_dec_2014_households_accommodated_in_bed_and_brea_5ea379e7" VARCHAR,
  "on_31_dec_2014_households_accommodated_in_hostels" VARCHAR,
  "on_31_dec_2014_households_accommodated_in_la_ha_stock" VARCHAR,
  "on_31_dec_2014_households_accommodated_in_private_sect_76945a01" VARCHAR,
  "on_31_dec_2014_households_accommodated_in_other_tempor_3bd77cce" VARCHAR,
  "on_31_dec_2014_total_households_in_temporary_accommodation" VARCHAR,
  "on_31_dec_2014_number_in_temp_per_1000_households" VARCHAR,
  "on_31_dec_2014_duty_owed_but_no_accommodation_has_been_3ff1ba42" VARCHAR,
  "jan_to_mar_2014_thousands_of_households_2012_based_hou_be32025f" DOUBLE,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_need_white" VARCHAR,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_n_e3ad3c10" VARCHAR,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_n_79c82698" VARCHAR,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_need_mixed" VARCHAR,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_n_8246f935" VARCHAR,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_n_5a84dd58" VARCHAR,
  "jan_to_mar_2015_accepted_as_homeless_and_in_priority_need_total" VARCHAR,
  "jan_to_mar_2015_accepted_homeless_per_1000_households" VARCHAR,
  "jan_to_mar_2015_eligible_homeless_and_in_priority_need_edba65ef" VARCHAR,
  "jan_to_mar_2015_eligible_homeless_but_not_in_priority_need" VARCHAR,
  "jan_to_mar_2015_eligible_but_not_homeless" VARCHAR,
  "jan_to_mar_2015_total_decisions" VARCHAR,
  "on_31_mar_2015_households_accommodated_in_bed_and_brea_0a66ae69" VARCHAR,
  "on_31_mar_2015_households_accommodated_in_hostels" VARCHAR,
  "on_31_mar_2015_households_accommodated_in_la_ha_stock" VARCHAR,
  "on_31_mar_2015_households_accommodated_in_private_sect_d4efb6e6" VARCHAR,
  "on_31_mar_2015_households_accommodated_in_other_tempor_4116b29e" VARCHAR,
  "on_31_mar_2015_total_households_in_temporary_accommodation" VARCHAR,
  "on_31_mar_2015_number_in_temp_per_1000_households" VARCHAR,
  "on_31_mar_2015_duty_owed_but_no_accommodation_has_been_2f1d6f0c" VARCHAR,
  "apr_to_june_2014_thousands_of_households_2012_based_ho_ba0722ce" DOUBLE,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__33713e10" VARCHAR,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__870d768a" VARCHAR,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__f5fc743e" VARCHAR,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__514ff654" VARCHAR,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__12651eae" VARCHAR,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__ca44b08c" VARCHAR,
  "apr_to_june_2015_accepted_as_homeless_and_in_priority__ece11542" VARCHAR,
  "apr_to_june_2015_accepted_homeless_per_1000_households" VARCHAR,
  "apr_to_june_2015_eligible_homeless_and_in_priority_nee_4f9b995f" VARCHAR,
  "apr_to_june_2015_eligible_homeless_but_not_in_priority_need" VARCHAR,
  "apr_to_june_2015_eligible_but_not_homeless" VARCHAR,
  "apr_to_june_2015_total_decisions" VARCHAR,
  "on_30_june_2015_households_accommodated_in_bed_and_bre_d2c73593" VARCHAR
);

Share link

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