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

9.96 KB
55 rows
9 columns


CREATE TABLE november_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR,
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR,
  "expense_area_t" VARCHAR,
  "supplier_t" VARCHAR,
  "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

9.98 KB
58 rows
9 columns


CREATE TABLE november_2023_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR,
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR,
  "expense_area_t" VARCHAR,
  "supplier_t" VARCHAR,
  "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.13 KB
63 rows
9 columns


CREATE TABLE october_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR,
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR,
  "expense_area_t" VARCHAR,
  "supplier_t" VARCHAR,
  "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.07 KB
62 rows
9 columns


CREATE TABLE october_2023_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR,
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR,
  "expense_area_t" VARCHAR,
  "supplier_t" VARCHAR,
  "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

10.92 KB
84 rows
9 columns


CREATE TABLE september_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR,
  "date" TIMESTAMP,
  "expense_type_t" VARCHAR,
  "expense_area_t" VARCHAR,
  "supplier_t" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);