Fraud Investigations
Leeds City Council
@ukgov.fraud_investigations
Leeds City Council
@ukgov.fraud_investigations
CREATE TABLE n_2013_14 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"fraudtype" VARCHAR,
"period" VARCHAR,
"totaloccasionsfraudpowers" BIGINT,
"totalfraudemployeescount" BIGINT,
"ftefraudemployeescount" DOUBLE,
"totalfraudspecialistscount" BIGINT,
"ftefraudspecialistcount" DOUBLE,
"fraudspentamount" BIGINT,
"totalinvestigatedfraud" BIGINT,
"comments" VARCHAR
);
CREATE TABLE n_2015_16 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"fraudtype" VARCHAR,
"period" VARCHAR,
"totaloccasionsfraudpowers" VARCHAR,
"totalfraudemployeescount" BIGINT,
"ftefraudemployeescount" DOUBLE,
"totalfraudspecialistscount" BIGINT,
"ftefraudspecialistcount" DOUBLE,
"fraudspentamount" VARCHAR,
"totalinvestigatedfraud" BIGINT,
"comments" VARCHAR
);
CREATE TABLE n_2016_17 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"fraudtype" VARCHAR,
"period" VARCHAR,
"totaloccasionsfraudpowers" VARCHAR,
"totalfraudemployeescount" DOUBLE,
"ftefraudemployeescount" DOUBLE,
"totalfraudspecialistscount" DOUBLE,
"ftefraudspecialistcount" DOUBLE,
"fraudspentamount" VARCHAR,
"totalinvestigatedfraud" DOUBLE,
"comments" VARCHAR
);
CREATE TABLE n_2018_19 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"fraudtype" VARCHAR,
"period" VARCHAR,
"totaloccasionsfraudpowers" VARCHAR,
"totalfraudemployeescount" BIGINT,
"ftefraudemployeescount" DOUBLE,
"totalfraudspecialistscount" BIGINT,
"ftefraudspecialistcount" DOUBLE,
"fraudspentamount" VARCHAR,
"totalinvestigatedfraud" BIGINT,
"comments" VARCHAR
);
CREATE TABLE n_2019_20 (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"fraudtype" VARCHAR,
"period" VARCHAR,
"totaloccasionsfraudpowers" VARCHAR,
"totalfraudemployeescount" BIGINT,
"ftefraudemployeescount" DOUBLE,
"totalfraudspecialistscount" BIGINT,
"ftefraudspecialistcount" DOUBLE,
"fraudspentamount" VARCHAR,
"totalinvestigatedfraud" BIGINT,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.