About this Dataset

Http://www.dchs.nhs.uk/assets////CopyofDCHSNov18.xlsx

A monthly list of financial transactions over £25,000 made by Derbyshire Community Health Services as part of the Government's commitment to transparency in expenditure.
Publisher name: Derbyshire Community Health Services NHS Foundation Trust
Last updated: 2025-05-01T04:00:23Z

Tables

November 2021 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.november_2021_return

10.85 kB
77 rows
9 columns

CREATE TABLE november_2021_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);

November 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.november_2022_return

10.2 kB
55 rows
9 columns

CREATE TABLE november_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR  -- Entity (T),
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR  -- Expense Type (T),
  "expense_area_t" VARCHAR  -- Expense Area (T),
  "supplier_t" VARCHAR  -- Supplier (T),
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);

November 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.november_2023_return

10.22 kB
58 rows
9 columns

CREATE TABLE november_2023_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR  -- Entity (T),
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR  -- Expense Type (T),
  "expense_area_t" VARCHAR  -- Expense Area (T),
  "supplier_t" VARCHAR  -- Supplier (T),
  "transaction_number" DOUBLE,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);

October 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.october_2022_return

10.37 kB
63 rows
9 columns

CREATE TABLE october_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR  -- Entity (T),
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR  -- Expense Type (T),
  "expense_area_t" VARCHAR  -- Expense Area (T),
  "supplier_t" VARCHAR  -- Supplier (T),
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);

October 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.october_2023_return

10.31 kB
62 rows
9 columns

CREATE TABLE october_2023_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR  -- Entity (T),
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR  -- Expense Type (T),
  "expense_area_t" VARCHAR  -- Expense Area (T),
  "supplier_t" VARCHAR  -- Supplier (T),
  "transaction_number" DOUBLE,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);

September 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.september_2022_return

11.18 kB
84 rows
9 columns

CREATE TABLE september_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR  -- Entity (T),
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR  -- Expense Type (T),
  "expense_area_t" VARCHAR  -- Expense Area (T),
  "supplier_t" VARCHAR  -- Supplier (T),
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);