Bristol City Council Fraud
Bristol City Council
@ukgov.bristol_city_council_fraud
Bristol City Council
@ukgov.bristol_city_council_fraud
CREATE TABLE bristol_city_council_fraud (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" TIMESTAMP,
"total_occasions_fraud_powers" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT,
"total_identified_fraud" VARCHAR,
"value_fraud" VARCHAR,
"value_fraud_recovered" VARCHAR
);
CREATE TABLE bristol_city_council_fraud_for_the_2017_to_2018 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" TIMESTAMP,
"total_occasions_fraud_powers" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT,
"total_identified_fraud" BIGINT,
"value_fraud" BIGINT,
"value_fraud_recovered" BIGINT
);
CREATE TABLE bristol_city_council_fraud_for_the_2018_to_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"effective_date" TIMESTAMP,
"total_occasions_fraud_powers" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT,
"total_identified_fraud" BIGINT,
"value_fraud" BIGINT,
"value_fraud_recovered" BIGINT,
"unnamed_13" VARCHAR
);
Anyone who has the link will be able to view this.