Trade Union Facility Time

Leeds City Council

@ukgov.trade_union_facility_time

Table List

2 tables(34.11 KB)

Education 2017/18 - 2019/20

Council 2012/13 - 2019/20

Education 2017/18 - 2019/20

@ukgov.trade_union_facility_time.education_2017_18_2019_20

16.16 KB
5 rows
19 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	effectivedate EffectiveDate	period Period	atlofficials ATLOfficials	nasuwtofficials NASUWTOfficials	nutofficials NUTOfficials	nahtcoordinators NAHTCoordinators	gmbleads GMBLeads	totalrepresentativecount_headcount_includes_c_ulrc_ulr_40066b11 TotalRepresentativeCount (Headcount) Includes C/ULRC/ULRL @ End Of Reporting Period	n__spentonfacilitytime1_50 %SpentOnFacilityTime1-50%	n__spentonfacilitytime51_99 %SpentOnFacilityTime51-99%	n__spentonfacilitytime100 %SpentOnFacilityTime100%	fterepresentativecount FTERepresentativeCount	totalestimatespendingamount TotalEstimateSpendingAmount	totalpaybill TotalPayBill	relativeestimatespending_of_total_pay_bill RelativeEstimateSpending % Of Total Pay Bill
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2017/18	1	4	4	1	1	11	5	4	2	6.68	£268,664	£331,218,527	0.08%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2018/19		3	2	1	1	7	2		5	4.6	£229,893	£325,067,866	0.07%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2019/20		3	2	1	1	7	2		5	4.42	£212,601	328944317	0.06%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Thu Apr 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2020/21		3	3	1	1	8	2		6	4.47	£230,771	£334,469,853	0.07%
Leeds	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021/22		3	2	1	1	7	2	3	2	4.3	£211,829	338,825,521	0.06%


CREATE TABLE education_2017_18_2019_20 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "period" VARCHAR,
  "atlofficials" BIGINT,
  "nasuwtofficials" BIGINT,
  "nutofficials" BIGINT,
  "nahtcoordinators" BIGINT,
  "gmbleads" BIGINT,
  "totalrepresentativecount_headcount_includes_c_ulrc_ulr_40066b11" BIGINT,
  "n__spentonfacilitytime0" DOUBLE,
  "n__spentonfacilitytime1_50" BIGINT,
  "n__spentonfacilitytime51_99" BIGINT,
  "n__spentonfacilitytime100" BIGINT,
  "fterepresentativecount" DOUBLE,
  "n__timeontuactivities_total_hours_spent_on_paid_activi_ac2ea4c0" BIGINT,
  "totalestimatespendingamount" VARCHAR,
  "totalpaybill" VARCHAR,
  "relativeestimatespending_of_total_pay_bill" VARCHAR
);