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 2010-11

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2010_11

15.72 kB
71 rows
16 columns

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

Member Allowances 2011-12

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2011_12

15.71 kB
71 rows
17 columns

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 2012-13

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2012_13

14.78 kB
70 rows
17 columns

CREATE TABLE member_allowances_2012_13 (
  "title" VARCHAR,
  "surname" VARCHAR,
  "initials" VARCHAR,
  "n__basic" VARCHAR  -- Basic,
  "n__sra" VARCHAR  -- SRA,
  "n__meal_deductions" VARCHAR  -- Meal Deductions,
  "n__sub_total" VARCHAR  -- Sub Total,
  "n__carers_allowance" VARCHAR  -- Carers Allowance,
  "vehicle_miles" VARCHAR,
  "n__vehicle_mileage" VARCHAR  -- Vehicle Mileage,
  "bicycle_miles" VARCHAR,
  "bicycle_mileage" VARCHAR,
  "n__taxable_subsistence" VARCHAR  -- Taxable Subsistence,
  "n__non_taxable_subsistence" VARCHAR  -- Non Taxable Subsistence,
  "n__other_expenses" VARCHAR  -- Other Expenses,
  "n__broadband" VARCHAR  -- Broadband,
  "grand_total" VARCHAR
);

Member Allowances 2013-14

@ukgov.cambridgeshire_county_council_members_allowances_and_e_f0a28889.member_allowances_2013_14

14.26 kB
108 rows
13 columns

CREATE TABLE member_allowances_2013_14 (
  "name" VARCHAR,
  "n__basic" VARCHAR  -- BASIC,
  "n__sra" VARCHAR  -- SRA,
  "n__meal_deduction" VARCHAR  -- Meal Deduction,
  "n__sub_total" VARCHAR  -- Sub Total,
  "n__mileage_expenses" VARCHAR  -- Mileage Expenses,
  "n__bicycle_mileage" VARCHAR  -- Bicycle Mileage,
  "n__other_expenses" VARCHAR  -- Other Expenses,
  "n__broadband" VARCHAR  -- Broadband,
  "n__shire_hall_and_other_subsistence" VARCHAR  -- Shire Hall And Other Subsistence,
  "n__carers_allowance" VARCHAR  -- Carers Allowance,
  "n__total" VARCHAR  -- Total,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);