Fraud Data
Rochdale Borough Council
@ukgov.fraud_data
Rochdale Borough Council
@ukgov.fraud_data
CREATE TABLE table_1 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_2 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_4 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_5 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" DOUBLE,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_6 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" VARCHAR,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_7 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_8 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT,
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" VARCHAR,
"total_investigated_fraud" BIGINT
);
CREATE TABLE table_9 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" 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_includes_housing_benefit" BIGINT
);
Anyone who has the link will be able to view this.