SLDC Trade Union Facility Time
South Lakeland District Council
@ukgov.sldc_trade_union_facility_time
South Lakeland District Council
@ukgov.sldc_trade_union_facility_time
CREATE TABLE n_2018_to_2019 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"totalrepresentativecount" DOUBLE,
"ftetotalrepresentativecount" DOUBLE,
"totalrepresentaativesmajoritydutycount" VARCHAR,
"fterepresentativesmajoritydutycount" DOUBLE,
"totalestimatespendingamount" VARCHAR,
"relativeestimatespending" VARCHAR,
"totaldaysper_year" DOUBLE,
"totalexpectedpaybill" DOUBLE,
"averagesalary" DOUBLE
);
CREATE TABLE sldc_trade_union_facility_time (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"totalrepresentativecount" BIGINT,
"ftetotalrepresentativecount" DOUBLE,
"totalrepresentaativesmajoritydutycount" BIGINT,
"fterepresentativesmajoritydutycount" BIGINT,
"totalestimatespendingamount" VARCHAR,
"relativeestimatespending" VARCHAR,
"totaldaysper_year" BIGINT,
"totalexpectedpaybill" BIGINT,
"averagesalary" BIGINT
);
Anyone who has the link will be able to view this.