Counter Fraud

Lincolnshire County Council

@ukgov.counter_fraud2

Table List

2 tables(33.17 KB)

Table 1

Counter Fraud

Counter Fraud

@ukgov.counter_fraud2.counter_fraud

Dataset for Counter Fraud

21.08 KB
12 rows
26 columns

organisationname OrganisationName	organisationcode OrganisationCode	publisheddate PublishedDate	latestdata LatestData	durationfrom DurationFrom	durationto DurationTo	reportingperiodtype ReportingPeriodType	period Period	geoentityname GeoEntityName	geocode GeoCode	geoname GeoName	geouri GeoURI	totaloccasionsfraudpowers TotalOccasionsFraudPowers	totalfraudemployeescount TotalFraudEmployeesCount	ftefraudemployeescount FTEFraudEmployeesCount	totalfraudspecialistscount TotalFraudSpecialistsCount	ftefraudspecialistcount FTEFraudSpecialistCount	fraudspentamount FraudSpentAmount	totalinvestigatedfraud TotalInvestigatedFraud	totalidentifiedfraud TotalIdentifiedFraud	valuefraud ValueFraud	valuefraudrecovered ValueFraudRecovered	totalinvestigatedirregularities TotalInvestigatedIrregularities	totalidentifiedirregularities TotalIdentifiedIrregularities	valueirregularities ValueIrregularities	valueirregularitiesrecovered ValueIrregularitiesRecovered
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 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	n/a	5	4.4	5	4.4	187614	18	5	38117	5908	18	9	50	50
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 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	n/a	2	1.4	2	1.4	139574	16	10	862261	764872	16	10	862262	764872
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 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	n/a	5	4.8	4	2.6	207624	10	3	73676	480	10	3	73676	480
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 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	n/a	6	4.8	4	2.6	237115	20	17	4705500	4563000	20	17	4705500	4563000
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Mon Apr 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2019-2020	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	n/a	6	4.8	4	2.6	237115	19	12	1700000	114000	19	12	1700000	114000
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2018-2019	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	n/a	6	4.8	4	2.6	237115	23	12	119000	9700	23	12	119000	9700
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 31 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2017-2018	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	n/a	5	4.42	3	2.92	203915	10	9	197500	124000	10	9	197500	124000
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2016-2017	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	n/a	5	4.42	3	2.92	203676	16	11	78000	33000	16	11	78000	33000
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2016 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2015-2016	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	n/a	4	2.92	3	2.92	117608	11	6	97000	950	11	6	97000	950
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Wed May 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue Apr 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	Financial Year	2014-2015	County	E10000019	Lincolnshire	http://statistics.data.gov.uk/doc/statistical-geography/E10000019	n/a	4	3.6	4	3.6	not available	23	10	43000	25500	23	10	43000	25500


CREATE TABLE counter_fraud (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" VARCHAR,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "reportingperiodtype" VARCHAR,
  "period" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "totaloccasionsfraudpowers" VARCHAR,
  "totalfraudemployeescount" BIGINT,
  "ftefraudemployeescount" DOUBLE,
  "totalfraudspecialistscount" BIGINT,
  "ftefraudspecialistcount" DOUBLE,
  "fraudspentamount" VARCHAR,
  "totalinvestigatedfraud" BIGINT,
  "totalidentifiedfraud" BIGINT,
  "valuefraud" VARCHAR,
  "valuefraudrecovered" BIGINT,
  "totalinvestigatedirregularities" BIGINT,
  "totalidentifiedirregularities" BIGINT,
  "valueirregularities" VARCHAR,
  "valueirregularitiesrecovered" BIGINT
);