Trade Union Facility Time

Lincolnshire County Council

@ukgov.trade_union_facility_time6

Table List

2 tables(27.89 KB)

Table 1

Trade Union Facility Time

Trade Union Facility Time

@ukgov.trade_union_facility_time6.trade_union_facility_time

Dataset of Trade Union Facility Time, published by Lincolnshire County Council

16.08 KB
21 rows
19 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	publisheddate PublishedDate	latestdata LatestData	durationfrom DurationFrom	durationto DurationTo	reportingperiodtype ReportingPeriodType	reportingperiod ReportingPeriod	geoentityname GeoEntityName	geocode GeoCode	geoname GeoName	geouri GeoURI	function Function	totalrepresentativecount TotalRepresentativeCount	fterepresentativescount FTERepresentativesCount	totalrepresentativesmajoritydutycount TotalRepresentativesMajorityDutyCount	fterepresentativesmajoritydutycount FTERepresentativesMajorityDutyCount	totalestimatespendingamount TotalEstimateSpendingAmount	relativeestimatespending RelativeEstimateSpending
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	TRUE	Sat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2024 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2023-2024	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Central Function Employees	19	15.55	4	3.12	109132.38	0.06
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	TRUE	Sat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2024 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2023-2025	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Fire & Rescue Function Employees	24	21.57			23877.26	0.52
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	TRUE	Sat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2024 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2023-2026	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Total: All Employees	43	37.12	4	3.12	133009.64	0.08
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2023 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2022-2023	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Central Function Employees	18	16.72	3	3	93886	0.19
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2023 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2022-2023	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Fire & Rescue Function Employees	17	16			11577.44	0.04
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Apr 01 2022 00:00:01 GMT+0000 (Coordinated Universal Time)	Sat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Financial Year	2022-2023	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Total: All Employees	35	32.72	3	3	105463.44	0.23
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2022 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2021-2022	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Central Function Employees	15	15	3	3	110028.15	0.08
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2022 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2021-2022	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Fire & Rescue Function Employees	20	19			4305.55	0.1
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Thu Apr 01 2021 00:00:01 GMT+0000 (Coordinated Universal Time)	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Financial Year	2021-2022	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Total: All Employees	35	34	3	3	114333.7	0.18
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Jul 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Wed Apr 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 31 2021 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2020-2021	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	Central Function Employees	20	18.32	3	2.6	71581	0.06


CREATE TABLE trade_union_facility_time (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" VARCHAR,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "reportingperiodtype" VARCHAR,
  "reportingperiod" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "function" VARCHAR,
  "totalrepresentativecount" BIGINT,
  "fterepresentativescount" DOUBLE,
  "totalrepresentativesmajoritydutycount" BIGINT,
  "fterepresentativesmajoritydutycount" DOUBLE,
  "totalestimatespendingamount" DOUBLE,
  "relativeestimatespending" DOUBLE
);