About this Dataset

Members Allowances

Members Allowances – Monthly from December 2010 onwards (format changed in January 2012) These allowances and expenses are paid direct to Members on a monthly basis. Details of the allowances and expenses which Members are entitled to claim are detailed in the Members’ Scheme of Allowances
Publisher name: City of York Council
Last updated: 2025-05-06T04:00:01Z

Tables

Members Allowances - Annual Summary 2012-13

@ukgov.members_allowances2.members_allowances_annual_summary_2012_13

10.21 KB
5829 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2012_13 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2013-14

@ukgov.members_allowances2.members_allowances_annual_summary_2013_14

10.33 KB
5829 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2013_14 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2014-15

@ukgov.members_allowances2.members_allowances_annual_summary_2014_15

10.44 KB
5830 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2014_15 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2015-16

@ukgov.members_allowances2.members_allowances_annual_summary_2015_16

11.03 KB
5851 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2015_16 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2016-17

@ukgov.members_allowances2.members_allowances_annual_summary_2016_17

9.99 KB
47 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2016_17 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2017-18

@ukgov.members_allowances2.members_allowances_annual_summary_2017_18

10.27 KB
50 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2017_18 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2018-19

@ukgov.members_allowances2.members_allowances_annual_summary_2018_19

9.98 KB
5829 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2018_19 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2019-20

@ukgov.members_allowances2.members_allowances_annual_summary_2019_20

10.83 KB
70 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2019_20 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2020-21

@ukgov.members_allowances2.members_allowances_annual_summary_2020_21

9.8 KB
5829 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2020_21 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2021-22

@ukgov.members_allowances2.members_allowances_annual_summary_2021_22

10.04 KB
47 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2021_22 (
  "councillor" VARCHAR,
  "basic" VARCHAR,
  "sra" VARCHAR,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" VARCHAR,
  "civic" VARCHAR,
  "telephone" VARCHAR,
  "total" VARCHAR
);

Members Allowances - Annual Summary 2022-23

@ukgov.members_allowances2.members_allowances_annual_summary_2022_23

10.48 KB
47 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2022_23 (
  "councillor" VARCHAR,
  "basic" DOUBLE,
  "sra" DOUBLE,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" DOUBLE,
  "dep_care" VARCHAR,
  "mileage" DOUBLE,
  "subsistence" DOUBLE,
  "internet" VARCHAR,
  "cycle" DOUBLE,
  "civic_arrears" DOUBLE,
  "telephone" VARCHAR,
  "total" DOUBLE
);

Members Allowances - Annual Summary 2023-24

@ukgov.members_allowances2.members_allowances_annual_summary_2023_24

11.03 KB
65 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2023_24 (
  "councillor" VARCHAR,
  "basic" DOUBLE,
  "sra" DOUBLE,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" DOUBLE,
  "dep_care" VARCHAR,
  "mileage" DOUBLE,
  "subsistence" DOUBLE,
  "internet" VARCHAR,
  "cycle" DOUBLE,
  "civic_arrears" DOUBLE,
  "telephone" VARCHAR,
  "total" DOUBLE
);

Members Allowances - Annual Summary 2024-25

@ukgov.members_allowances2.members_allowances_annual_summary_2024_25

9.81 KB
49 rows
14 columns


CREATE TABLE members_allowances_annual_summary_2024_25 (
  "councillor" VARCHAR,
  "basic" DOUBLE,
  "sra" DOUBLE,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" VARCHAR,
  "dep_care" VARCHAR,
  "mileage" VARCHAR,
  "subsistence" VARCHAR,
  "internet" VARCHAR,
  "cycle" DOUBLE,
  "civic" DOUBLE,
  "telephone" VARCHAR,
  "year" VARCHAR
);

Members Allowances – Monthly Data From January 2012

@ukgov.members_allowances2.members_allowances_monthly_data_from_january_2012

29.04 KB
7568 rows
16 columns


CREATE TABLE members_allowances_monthly_data_from_january_2012 (
  "councillor" VARCHAR,
  "basic" DOUBLE,
  "sra" DOUBLE,
  "basic_arrs" VARCHAR,
  "sra_arrs" VARCHAR,
  "travel" DOUBLE,
  "dep_care" DOUBLE,
  "mileage" DOUBLE,
  "subsistence" DOUBLE,
  "internet" DOUBLE,
  "cycle" DOUBLE,
  "civic" DOUBLE,
  "telephone" DOUBLE,
  "year" BIGINT,
  "month" VARCHAR,
  "notes" VARCHAR
);

Members Allowances – Monthly Data December 2010 To December 2011

@ukgov.members_allowances2.members_allowances_monthly_december_2010_to_december_2011

7.9 KB
1426 rows
5 columns


CREATE TABLE members_allowances_monthly_december_2010_to_december_2011 (
  "expense_category" VARCHAR,
  "date" TIMESTAMP,
  "amount" DOUBLE,
  "narrative" VARCHAR,
  "comment" VARCHAR
);