Cambridgeshire County Council Members' Allowances And Expenses (pre-2014)
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889
CREATE TABLE member_allowances_2013_14 (
"name" VARCHAR,
"n__basic" VARCHAR,
"n__sra" VARCHAR,
"n__meal_deduction" VARCHAR,
"n__sub_total" VARCHAR,
"n__mileage_expenses" VARCHAR,
"n__bicycle_mileage" VARCHAR,
"n__other_expenses" VARCHAR,
"n__broadband" VARCHAR,
"n__shire_hall_and_other_subsistence" VARCHAR,
"n__carers_allowance" VARCHAR,
"n__total" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE member_allowances_2012_13 (
"title" VARCHAR,
"surname" VARCHAR,
"initials" VARCHAR,
"n__basic" VARCHAR,
"n__sra" VARCHAR,
"n__meal_deductions" VARCHAR,
"n__sub_total" VARCHAR,
"n__carers_allowance" VARCHAR,
"vehicle_miles" VARCHAR,
"n__vehicle_mileage" VARCHAR,
"bicycle_miles" VARCHAR,
"bicycle_mileage" VARCHAR,
"n__taxable_subsistence" VARCHAR,
"n__non_taxable_subsistence" VARCHAR,
"n__other_expenses" VARCHAR,
"n__broadband" VARCHAR,
"grand_total" VARCHAR
);
CREATE TABLE member_allowances_2011_12 (
"title" VARCHAR,
"surname" VARCHAR,
"initials" VARCHAR,
"basic" DOUBLE,
"sra" DOUBLE,
"meal_deductions" DOUBLE,
"sub_total" DOUBLE,
"carers_allowance" DOUBLE,
"vehicle_miles" BIGINT,
"vehicle_mileage" DOUBLE,
"bicycle_miles" BIGINT,
"bicycle_mileage" DOUBLE,
"taxable_subsistence" DOUBLE,
"non_taxable_subsistence" DOUBLE,
"other_expenses" DOUBLE,
"broadband" DOUBLE,
"grand_total" DOUBLE
);
CREATE TABLE member_allowances_2010_11 (
"councillor_surname" VARCHAR,
"initials" VARCHAR,
"basic_allowance" DOUBLE,
"sra" DOUBLE,
"meal_deductions" DOUBLE,
"sub_total" DOUBLE,
"carers_allowance" DOUBLE,
"number_of_vehicle_miles" BIGINT,
"vehicle_mileage_reimbursed" DOUBLE,
"number_of_bicycle_miles" BIGINT,
"bicycle_mileage_reimbursed" DOUBLE,
"taxable_subsistence" DOUBLE,
"non_taxable_subsistence" DOUBLE,
"other_expenses" DOUBLE,
"broadband" DOUBLE,
"grand_total" DOUBLE
);
Anyone who has the link will be able to view this.