Lone Pensioner Allowance Statistics
OpenDataNI
@ukgov.lone_pensioner_allowance_statistics
OpenDataNI
@ukgov.lone_pensioner_allowance_statistics
CREATE TABLE net_amount_of_lone_pensioner_allowance_owner_occupier__3311e5c2 (
"district_council" VARCHAR,
"n_31_mar_10" DOUBLE,
"n_31_mar_11" DOUBLE,
"n_31_mar_12" DOUBLE,
"n_31_mar_13" DOUBLE,
"n_31_mar_14" DOUBLE,
"n_31_mar_15" DOUBLE,
"n_31_mar_16" DOUBLE,
"n_31_mar_17" DOUBLE,
"n_31_mar_18" DOUBLE,
"n_31_mar_19" DOUBLE,
"n_31_mar_20" DOUBLE,
"n_31_mar_21" DOUBLE,
"n_31_mar_22" DOUBLE,
"n_31_mar_23" DOUBLE,
"n_31_mar_24" DOUBLE,
"n_31_mar_25" DOUBLE
);
CREATE TABLE net_amount_of_lone_pensioner_allowance_private_rented__9cd740e3 (
"year_end" VARCHAR,
"net_amount_of_lpa_awarded_private_rented_sector" DOUBLE,
"net_amount_of_lpa_awarded_nihe" DOUBLE,
"net_amount_of_lpa_awarded_housing_association" DOUBLE
);
CREATE TABLE number_of_people_owner_occupier_awarded_lone_pensioner_26985f9e (
"year_end" VARCHAR,
"number_of_people_awarded_lpa" BIGINT,
"net_amount_of_lpa_awarded" DOUBLE
);
CREATE TABLE number_of_people_owner_occupier_in_northern_ireland_aw_a4d1132d (
"district_council" VARCHAR,
"n_31_mar_10" BIGINT,
"n_31_mar_11" BIGINT,
"n_31_mar_12" BIGINT,
"n_31_mar_13" BIGINT,
"n_31_mar_14" BIGINT,
"n_31_mar_15" BIGINT,
"n_31_mar_16" BIGINT,
"n_31_mar_17" BIGINT,
"n_31_mar_18" BIGINT,
"n_31_mar_19" BIGINT,
"n_31_mar_20" BIGINT,
"n_31_mar_21" BIGINT,
"n_31_mar_22" BIGINT,
"n_31_mar_23" BIGINT,
"n_31_mar_24" BIGINT,
"n_31_mar_25" BIGINT
);
CREATE TABLE total_net_amount_of_lone_pensioner_allowance_awarded_i_27c8ee54 (
"year_end" VARCHAR,
"net_amount_of_lpa_awarded_owner_occupier" DOUBLE,
"net_amount_of_lpa_awarded_private_rented_sector" DOUBLE,
"net_amount_of_lpa_awarded_nihe" DOUBLE,
"net_amount_of_lpa_awarded_housing_association" DOUBLE,
"total_net_amount_of_lpa_awarded_in_northern_ireland" DOUBLE
);
Anyone who has the link will be able to view this.