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.48 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

17.28 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  -- Unnamed: 8
);

July 2019 Return

@ukgov.financial_transactions_data_ago_cps.july_2019_return

16.81 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  -- Unnamed: 8
);

June 2019 Return

@ukgov.financial_transactions_data_ago_cps.june_2019_return

24.95 kB
3,792 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.51 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

27.18 kB
2,580 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
);