April 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.april_2022_return

9.49 KB
36 rows
9 columns


CREATE TABLE april_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
);

April 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.april_2023_return

10.62 KB
60 rows
9 columns


CREATE TABLE april_2023_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
);

August 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.august_2022_return

9.68 KB
57 rows
9 columns


CREATE TABLE august_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
);

August 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.august_2023_return

9.15 KB
42 rows
9 columns


CREATE TABLE august_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
);

August 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.august_2024_return

9.26 KB
56 rows
9 columns


CREATE TABLE august_2024_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
);

December 2021 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.december_2021_return

10.57 KB
96 rows
9 columns


CREATE TABLE december_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
);

December 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.december_2022_return

9.98 KB
46 rows
9 columns


CREATE TABLE december_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
);

December 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.december_2023_return

10.4 KB
83 rows
9 columns


CREATE TABLE december_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
);

February 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.february_2022_return

11.32 KB
134 rows
9 columns


CREATE TABLE february_2022_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
);

February 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.february_2023_return

9.89 KB
41 rows
9 columns


CREATE TABLE february_2023_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
);

February 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.february_2024_return

9.95 KB
58 rows
9 columns


CREATE TABLE february_2024_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
);

Janaury 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.janaury_2023_return

10.3 KB
94 rows
9 columns


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

January 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.january_2022_return

10.53 KB
76 rows
9 columns


CREATE TABLE january_2022_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
);

January 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.january_2024_return

10.13 KB
74 rows
9 columns


CREATE TABLE january_2024_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
);

July 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.july_2022_return

10.36 KB
106 rows
9 columns


CREATE TABLE july_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
);

July 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.july_2023_return

10.5 KB
80 rows
9 columns


CREATE TABLE july_2023_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
);

June 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.june_2022_return

9.76 KB
60 rows
9 columns


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

June 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.june_2023_return

11.05 KB
98 rows
9 columns


CREATE TABLE june_2023_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
);

June 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.june_2024_return

10.07 KB
72 rows
9 columns


CREATE TABLE june_2024_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
);

March 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.march_2022_return

11.21 KB
116 rows
9 columns


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

March 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.march_2023_return

10.71 KB
93 rows
9 columns


CREATE TABLE march_2023_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
);

March 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.march_2024_return

10.18 KB
65 rows
9 columns


CREATE TABLE march_2024_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
);

May 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.may_2022_return

9.84 KB
41 rows
9 columns


CREATE TABLE may_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
);

May 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.may_2023_return

10.14 KB
49 rows
9 columns


CREATE TABLE may_2023_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
);

May 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.may_2024_return

10.67 KB
100 rows
9 columns


CREATE TABLE may_2024_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
);

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

About this Dataset