Homelessness Prevention And Relief
Cambridgeshire Insight
@ukgov.homelessness_prevention_and_relief1
Cambridgeshire Insight
@ukgov.homelessness_prevention_and_relief1
CREATE TABLE homelessness_prevention_and_relief (
"ons_code" VARCHAR,
"local_authority" VARCHAR,
"region" VARCHAR,
"n_2009_10_thousands_of_households_2006_mid_year_estimate" BIGINT,
"n_2009_10_preventing_homelessness_households_able_to_r_ffb6b148" VARCHAR,
"n_2009_10_preventing_homelessness_households_assisted__d5e0e3e5" VARCHAR,
"n_2009_10_total_prevention_cases_households" VARCHAR,
"n_2009_10_prevention_per_thousand_households" VARCHAR,
"n_2009_10_number_of_cases_where_positive_action_was_su_656a2990" VARCHAR,
"n_2009_10_relief_per_thousand_households" VARCHAR,
"n_2010_11_thousands_of_households_2008_mid_year_estimate" BIGINT,
"n_2010_11_preventing_homelessness_households_able_to_r_4612962d" VARCHAR,
"n_2010_11_preventing_homelessness_households_assisted__e31c6aaf" VARCHAR,
"n_2010_11_total_prevention_cases_households" BIGINT,
"n_2010_11_prevention_per_thousand_households" DOUBLE,
"n_2010_11_number_of_cases_where_positive_action_was_su_729e336f" BIGINT,
"n_2010_11_relief_per_thousand_households" DOUBLE,
"n_2011_12_thousands_of_households_2008_mid_year_estimate" BIGINT,
"n_2011_12_preventing_homelessness_households_able_to_r_ea97c465" VARCHAR,
"n_2011_12_preventing_homelessness_households_assisted__3a8d40c8" VARCHAR,
"n_2011_12_total_prevention_cases_households" BIGINT,
"n_2011_12_prevention_per_thousand_households" DOUBLE,
"n_2011_12_number_of_cases_where_positive_action_was_su_61b5e436" VARCHAR,
"n_2011_12_relief_per_thousand_households" VARCHAR,
"n_2012_13_thousands_of_households_2011_based_projectio_2860066c" BIGINT,
"n_2012_13_preventing_homelessness_households_able_to_r_82c3dc25" BIGINT,
"n_2012_13_preventing_homelessness_households_assisted__ae2f7a83" BIGINT,
"n_2012_13_total_prevention_cases_households" BIGINT,
"n_2012_13_prevention_per_thousand_households" DOUBLE,
"n_2012_13_number_of_cases_where_positive_action_was_su_d9a267d9" BIGINT,
"n_2012_13_relief_per_thousand_households" DOUBLE,
"n_2013_14_thousands_of_households_2012_based_projectio_1f322e38" BIGINT,
"n_2013_14_preventing_homelessness_households_able_to_r_4a55f1b3" BIGINT,
"n_2013_14_preventing_homelessness_households_assisted__71f15d45" BIGINT,
"n_2013_14_total_prevention_cases_households" BIGINT,
"n_2013_14_prevention_per_thousand_households" DOUBLE,
"n_2013_14_number_of_cases_where_positive_action_was_su_dcbcb2f4" BIGINT,
"n_2013_14_relief_per_thousand_households" DOUBLE,
"n_2014_15_thousands_of_households_2012_based_projectio_4f7384a8" BIGINT,
"n_2014_15_preventing_homelessness_households_able_to_r_bf8788e3" BIGINT,
"n_2014_15_preventing_homelessness_households_assisted__40bf7d3c" BIGINT,
"n_2014_15_total_prevention_cases_households" BIGINT,
"n_2014_15_prevention_per_thousand_households" DOUBLE,
"n_2014_15_number_of_cases_where_positive_action_was_su_30e27661" BIGINT,
"n_2014_15_relief_per_thousand_households" DOUBLE,
"n_2015_16_thousands_of_households_2012_based_projectio_67529c5c" BIGINT,
"n_2015_16_preventing_homelessness_households_able_to_r_c12e255f" BIGINT,
"n_2015_16_preventing_homelessness_households_assisted__249b3062" BIGINT,
"n_2015_16_total_prevention_cases_households" BIGINT,
"n_2015_16_prevention_per_thousand_households" DOUBLE,
"n_2015_16_number_of_cases_where_positive_action_was_su_c8a0e72a" BIGINT,
"n_2015_16_relief_per_thousand_households" DOUBLE,
"n_2016_17_thousands_of_households_2014_based_projectio_ca34b6fe" BIGINT,
"n_2016_17_preventing_homelessness_households_able_to_r_4bfc815b" BIGINT,
"n_2016_17_preventing_homelessness_households_assisted__f7e8ef74" BIGINT,
"n_2016_17_total_prevention_cases_households" BIGINT,
"n_2016_17_prevention_per_thousand_households" DOUBLE,
"n_2016_17_number_of_cases_where_positive_action_was_su_ca83ecae" BIGINT,
"n_2016_17_relief_per_thousand_households" DOUBLE,
"n_2017_18_thousands_of_households_2014_based_projectio_e9c936d6" BIGINT,
"n_2017_18_preventing_homelessness_households_able_to_r_1005dd0c" BIGINT,
"n_2017_18_preventing_homelessness_households_assisted__6b426a4f" BIGINT,
"n_2017_18_total_prevention_cases_households" BIGINT,
"n_2017_18_prevention_per_thousand_households" DOUBLE,
"n_2017_18_number_of_cases_where_positive_action_was_su_8cbb00a7" BIGINT,
"n_2017_18_relief_per_thousand_households" DOUBLE
);
Anyone who has the link will be able to view this.