Fraud Data Published Under The Local Government Transparency Code

CREATE TABLE table_1 (
  "organisation_label" VARCHAR,
  "organisation_uri" VARCHAR,
  "period" VARCHAR,
  "number_of_occasions_they_use_powers_under_the_preventi_1461e70e" BIGINT  -- Number Of Occasions They Use Powers Under The Prevention Of Social Housing Fraud (Power To Require Information) (England) Regulations 201432, Or Similar Powers,
  "total_number_absolute_of_employees_undertaking_investi_5107ab79" BIGINT  -- Total Number (absolute) Of Employees Undertaking Investigations And Prosecutions Of Fraud,
  "total_number_full_time_equivalent_of_employees_underta_1293336b" BIGINT  -- Total Number (full Time Equivalent) Of Employees Undertaking Investigations And Prosecutions Of Fraud,
  "total_number_absolute_of_professionally_accredited_cou_d49e378a" BIGINT  -- Total Number (absolute) Of Professionally Accredited Counter Fraud Specialists,
  "total_number_full_time_equivalent_of_professionally_ac_0e0d0064" BIGINT  -- Total Number (full Time Equivalent) Of Professionally Accredited Counter Fraud Specialists,
  "total_amount_spent_by_the_authority_on_the_investigati_0ad76787" DOUBLE  -- Total Amount Spent By The Authority On The Investigation And Prosecution Of Fraud,
  "total_number_of_fraud_cases_investigated" BIGINT  -- Total Number Of Fraud Cases Investigated.,
  "notes" VARCHAR
);