Trafford Council

@ukgov.trafford_council_fraud

Table List

2 tables(13.34 KB)

Trafford-counter-fraud

@ukgov.trafford_council_fraud.trafford_counter_fraud

9.36 KB
10 rows
10 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	effectivedate EffectiveDate	totaloccasionsfraudpowers TotalOccasionsFraudPowers	totalfraudemployeescount TotalFraudEmployeesCount	ftefraudemployeescount FTEFraudEmployeesCount	totalfraudspecialistscount TotalFraudSpecialistsCount	ftefraudspecialistcount FTEFraudSpecialistCount	fraudspentamount FraudSpentAmount	totalinvestigatedfraud TotalInvestigatedFraud
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	710	11	7	8	8	327310	517
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Thu Mar 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	332	10	7.5	7	7	290962	648
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Fri Mar 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	13	6	4.5	3	3	168486	265
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Sat Mar 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	15	6	5.3	3	3	174997	284
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	7	4	3.8	4	3.8	148831	278
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	30	4	4	3	3	132499	185
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Wed Mar 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13	4	3	3	2	110176	132
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Thu Mar 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19	4	3	3	2	115864	163
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	14	3	2	2	1	113838	124
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	Sun Mar 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	8	3	2.5	3	2.5	143600	165


CREATE TABLE trafford_counter_fraud (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "totaloccasionsfraudpowers" BIGINT,
  "totalfraudemployeescount" BIGINT,
  "ftefraudemployeescount" DOUBLE,
  "totalfraudspecialistscount" BIGINT,
  "ftefraudspecialistcount" DOUBLE,
  "fraudspentamount" BIGINT,
  "totalinvestigatedfraud" BIGINT
);

Trafford Council - Fraud

Table List

Trafford-counter-fraud

@ukgov.trafford_council_fraud.trafford_counter_fraud

organisationlabel

organisationuri

effectivedate

totaloccasionsfraudpowers

totalfraudemployeescount

ftefraudemployeescount

totalfraudspecialistscount

ftefraudspecialistcount

fraudspentamount

totalinvestigatedfraud

Share link