SLDC Councillor Allowances
South Lakeland District Council
@ukgov.sldc_councillor_allowances
South Lakeland District Council
@ukgov.sldc_councillor_allowances
CREATE TABLE councillor_allowances_2018_to_2019 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"name" VARCHAR,
"basic" DOUBLE,
"specialresponsibility" DOUBLE,
"childcarers" DOUBLE,
"dependentcarers" DOUBLE,
"travel" DOUBLE,
"subsistence" DOUBLE,
"total" DOUBLE,
"notes" VARCHAR,
"geoareauri" VARCHAR,
"geoarealabel" VARCHAR
);
CREATE TABLE sldc_councillor_allowances (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"name" VARCHAR,
"co_optees" VARCHAR,
"basic" DOUBLE,
"specialresponsibility" DOUBLE,
"childcarers" DOUBLE,
"dependentcarers" DOUBLE,
"travel" DOUBLE,
"subsistence" DOUBLE,
"co_opteeallowance" DOUBLE,
"total" DOUBLE,
"notes" VARCHAR,
"geoareauri" VARCHAR,
"geoarealabel" VARCHAR
);
Anyone who has the link will be able to view this.