Spend Over £25,000 In South Central Ambulance Service NHS Foundation Trust
South Central Ambulance Service NHS Foundation Trust
@ukgov.financial_transactions_south_central_ambulance_service_343f41b2
South Central Ambulance Service NHS Foundation Trust
@ukgov.financial_transactions_south_central_ambulance_service_343f41b2
CREATE TABLE april_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE april_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE april_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE august_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE august_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE august_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE december_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE december_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE december_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE february_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE february_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE february_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE january_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE january_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE january_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE july_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE july_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE july_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE june_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE june_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE june_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE march_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
CREATE TABLE march_2023_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE march_2024_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE may_2022_return (
"department" VARCHAR,
"entity" VARCHAR,
"document_date" TIMESTAMP,
"vendor_name" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"transaction_description" VARCHAR
);
Anyone who has the link will be able to view this.