Department Of Health Government Procurement Card Spend - Transactions Over £500
Department of Health and Social Care
@ukgov.dh_gpc_spend_over_500
Department of Health and Social Care
@ukgov.dh_gpc_spend_over_500
The data published includes transactions that have a single transaction value of £500 or above.
Publisher name: Department of Health and Social Care
Last updated: 2023-02-06T01:09:32Z
CREATE TABLE april_2019 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE april_2020 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE april_2021 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE april_2022 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE august_2019 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE august_2020 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE august_2021 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE august_2022 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE december_2018 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE december_2019 (
"fin_posting_date" TIMESTAMP,
"fin_transaction_amount" DOUBLE,
"mch_merchant_name" VARCHAR
);CREATE TABLE december_2020 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE december_2021 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" VARCHAR -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE department_of_health_government_procurement_card_spend_939c7df9 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE february_2019 (
"fin_posting_date" TIMESTAMP,
"fin_transaction_amount" DOUBLE,
"mch_merchant_name" VARCHAR
);CREATE TABLE february_2020 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE february_2021 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE february_2022 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" VARCHAR -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE january_2020 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE january_2021 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE january_2022 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" VARCHAR -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE july_2019 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE july_2020 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE july_2021 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE july_2022 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);CREATE TABLE june_2019 (
"fin_posting_date" TIMESTAMP,
"n__fin_transaction_amount" DOUBLE -- FIN.TRANSACTION AMOUNT,
"mch_merchant_name" VARCHAR
);Anyone who has the link will be able to view this.