Baselight

Cambridgeshire County Council Members' Allowances And Expenses (pre-2014)

Cambridgeshire Insight

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889

Loading...
Loading...

About this Dataset

Cambridgeshire County Council Members' Allowances And Expenses (pre-2014)

Please note, Councillor expenses details from 2014-15 onwards are published on the county Council's main website here: https://www.cambridgeshire.gov.uk/council/county-councillors/councillors...

Information about Cambridgeshire County Council Member allowances and expenses.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:04Z

Tables

Member Allowances 2013-14

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2013_14
  • 13.93 KB
  • 108 rows
  • 13 columns
Loading...

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
);

Member Allowances 2012-13

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2012_13
  • 14.43 KB
  • 70 rows
  • 17 columns
Loading...

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
);

Member Allowances 2011-12

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2011_12
  • 15.34 KB
  • 71 rows
  • 17 columns
Loading...

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
);

Member Allowances 2010-11

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2010_11
  • 15.35 KB
  • 71 rows
  • 16 columns
Loading...

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
);

Share link

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