April 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.april_2022_return

9.72 kB
36 rows
9 columns

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

April 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.april_2023_return

10.87 kB
60 rows
9 columns

CREATE TABLE april_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" 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.92 kB
57 rows
9 columns

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

August 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.august_2023_return

9.37 kB
42 rows
9 columns

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

August 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.august_2024_return

9.48 kB
56 rows
9 columns

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

December 2021 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.december_2021_return

10.82 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

10.22 kB
46 rows
9 columns

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

December 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.december_2023_return

10.65 kB
83 rows
9 columns

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

February 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.february_2022_return

11.6 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

10.13 kB
41 rows
9 columns

CREATE TABLE february_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" BIGINT,
  "ap_amount" DOUBLE,
  "purchase_invoice_number" VARCHAR
);

February 2024 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.february_2024_return

10.19 kB
58 rows
9 columns

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

Janaury 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.janaury_2023_return

10.55 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.78 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.37 kB
74 rows
9 columns

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

July 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.july_2022_return

10.61 kB
106 rows
9 columns

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

July 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.july_2023_return

10.76 kB
80 rows
9 columns

CREATE TABLE july_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" 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.99 kB
60 rows
9 columns

CREATE TABLE june_2022_return (
  "department_family" VARCHAR,
  "entity_t" VARCHAR  -- Entity (T),
  "date" VARCHAR,
  "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
);

June 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.june_2023_return

11.32 kB
98 rows
9 columns

CREATE TABLE june_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" 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.31 kB
72 rows
9 columns

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

March 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.march_2022_return

11.48 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.97 kB
93 rows
9 columns

CREATE TABLE march_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" 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.42 kB
65 rows
9 columns

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

May 2022 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.may_2022_return

10.07 kB
41 rows
9 columns

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

May 2023 Return

@ukgov.spend_over_25_000_in_derbyshire_community_health_services.may_2023_return

10.39 kB
49 rows
9 columns

CREATE TABLE may_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" 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.93 kB
100 rows
9 columns

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

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

About this Dataset