Fraud Data
Rochdale Borough Council
@ukgov.fraud_data
Rochdale Borough Council
@ukgov.fraud_data
This information relates to counter fraud work undertaken by the Council. The data relates mainly to the number of staff employed, number of investigations undertaken and the occasions when statutory powers were used. The Transparency Code 2014 refers to the Audit Commission definition of fraud as an intentional false representation, including failure to declare information or abuse of position that is carried out to make gain, cause loss or expose another to the risk of loss. The ‘powers’ referred to are those in place allowing the Council to compel certain prescribed bodies to supply it with information.
Publisher name: Rochdale Borough Council
Last updated: 2024-11-03T04:15:01Z
CREATE TABLE table_1 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_2 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_4 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_5 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" DOUBLE -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_6 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" VARCHAR -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_7 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" DOUBLE,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_8 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" VARCHAR -- Fraud Spent Amount (£),
"total_investigated_fraud" BIGINT
);CREATE TABLE table_9 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"total_occasions_fraud_powers_used_estimate" BIGINT -- Total Occasions Fraud Powers Used (estimate),
"total_fraud_employees_count" BIGINT,
"fte_fraud_employees_count" DOUBLE,
"total_fraud_specialists_count" BIGINT,
"fte_fraud_specialist_count" DOUBLE,
"fraud_spent_amount" BIGINT -- Fraud Spent Amount (£),
"total_investigated_fraud_includes_housing_benefit" BIGINT -- Total Investigated Fraud (includes Housing Benefit)
);Anyone who has the link will be able to view this.