About this Dataset

Fraud Data Manchester

Information about Counter Fraud work including use of powers, employees and fraud cases published as part of the transparency code. Consolidated data provided by HR, Legal Services, Benefits Fraud Investigation Group and Internal Audit from casework management systems.
Publisher name: Manchester City Council
Last updated: 2024-10-11T04:00:07Z

Tables

Fraud Data 2019

@ukgov.fraud_data_manchester.fraud_data_2019

9.21 KB
1 row
10 columns


CREATE TABLE fraud_data_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" BIGINT,
  "fraud_spent_amount" VARCHAR,
  "total_investigated_fraud" BIGINT
);

Fraud Data 2020

@ukgov.fraud_data_manchester.fraud_data_2020

9.07 KB
1 row
10 columns


CREATE TABLE fraud_data_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" VARCHAR,
  "total_occasions_fraud_powers" BIGINT,
  "total_fraud_employees_count" BIGINT,
  "fte_fraud_employees_count" DOUBLE,
  "total_fraud_specialists_count" BIGINT,
  "fte_fraud_specialist_count" BIGINT,
  "fraud_spent_amount" VARCHAR,
  "total_investigated_fraud" BIGINT
);

Fraud Data 2021

@ukgov.fraud_data_manchester.fraud_data_2021

9.06 KB
1 row
10 columns


CREATE TABLE fraud_data_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" VARCHAR,
  "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" VARCHAR,
  "total_investigated_fraud" BIGINT
);

Fraud Data 2023

@ukgov.fraud_data_manchester.fraud_data_2023

9.07 KB
1 row
10 columns


CREATE TABLE fraud_data_2023 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" VARCHAR,
  "total_occasions_fraud_powers" BIGINT,
  "total_fraud_employees_count" BIGINT,
  "fte_fraud_employees_count" DOUBLE,
  "total_fraud_specialists_count" BIGINT,
  "fte_fraud_specialist_count" BIGINT,
  "fraud_spent_amount" VARCHAR,
  "total_investigated_fraud" BIGINT
);

Fraud Data Manchester

@ukgov.fraud_data_manchester.fraud_data_manchester

9.19 KB
1 row
10 columns


CREATE TABLE fraud_data_manchester (
  "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" BIGINT,
  "fraud_spent_amount" VARCHAR,
  "total_investigated_fraud" BIGINT
);