About this Dataset

Spend Over £25,000 In The Crown Prosecution Service

A monthly-updated list of all financial transactions spending over £25,000 made by the Crown Prosecution Service, as part of the Government's commitment to transparency in expenditure.
Publisher name: Crown Prosecution Service
Last updated: 2022-07-01T04:01:41Z

Tables

April 2019 Return

@ukgov.financial_transactions_data_ago_cps.april_2019_return

18.05 KB
647 rows
10 columns


CREATE TABLE april_2019_return (
  "supplier" VARCHAR,
  "address_name" VARCHAR,
  "invoice_date" TIMESTAMP,
  "invoice_line_number" DOUBLE,
  "tax_status" VARCHAR,
  "tax_name" VARCHAR,
  "cost_center_description" VARCHAR,
  "budget_segment_description" VARCHAR,
  "account_description" VARCHAR,
  "invoice_line_amount" DOUBLE
);

August 2019 Return

@ukgov.financial_transactions_data_ago_cps.august_2019_return

16.87 KB
430 rows
9 columns


CREATE TABLE august_2019_return (
  "department_family" VARCHAR,
  "date_paid" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "vat_inclusive" VARCHAR,
  "unnamed_8" VARCHAR
);

July 2019 Return

@ukgov.financial_transactions_data_ago_cps.july_2019_return

16.41 KB
369 rows
9 columns


CREATE TABLE july_2019_return (
  "department_family" VARCHAR,
  "date_paid" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "vat_inclusive" VARCHAR,
  "unnamed_8" VARCHAR
);

June 2019 Return

@ukgov.financial_transactions_data_ago_cps.june_2019_return

24.37 KB
3792 rows
9 columns


CREATE TABLE june_2019_return (
  "supplier" VARCHAR,
  "address_name" VARCHAR,
  "invoice_date" VARCHAR,
  "tax_status" VARCHAR,
  "tax_name" VARCHAR,
  "cost_center_description" VARCHAR,
  "budget_segment_description" VARCHAR,
  "account_description" VARCHAR,
  "line_amount" VARCHAR
);

March 2019 Return

@ukgov.financial_transactions_data_ago_cps.march_2019_return

18.08 KB
200 rows
15 columns


CREATE TABLE march_2019_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "vat_included" VARCHAR,
  "invoice_description" VARCHAR,
  "postal_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

May 2019 Return

@ukgov.financial_transactions_data_ago_cps.may_2019_return

26.54 KB
2580 rows
9 columns


CREATE TABLE may_2019_return (
  "supplier" VARCHAR,
  "address_name" VARCHAR,
  "invoice_date" VARCHAR,
  "tax_status" VARCHAR,
  "tax_name" VARCHAR,
  "cost_center_description" VARCHAR,
  "budget_segment_description" VARCHAR,
  "account_description" VARCHAR,
  "invoice_line_amount" VARCHAR
);