Department Of Health Government Procurement Card Spend - Transactions Over £500 by UK Government | Finance and Economics

Department Of Health Government Procurement Card Spend - Transactions Over £500

@ukgov.dh_gpc_spend_over_500.department_of_health_government_procurement_card_spend_939c7df9

3.55 KB
6 rows
3 columns


CREATE TABLE department_of_health_government_procurement_card_spend_939c7df9 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2021

@ukgov.dh_gpc_spend_over_500.september_2021

3.65 KB
20 rows
3 columns


CREATE TABLE september_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2022

@ukgov.dh_gpc_spend_over_500.october_2022

3.8 KB
18 rows
3 columns


CREATE TABLE october_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

April 2019

@ukgov.dh_gpc_spend_over_500.april_2019

3.66 KB
14 rows
3 columns


CREATE TABLE april_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

February 2019

@ukgov.dh_gpc_spend_over_500.february_2019

3.64 KB
14 rows
3 columns


CREATE TABLE february_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

December 2020

@ukgov.dh_gpc_spend_over_500.december_2020

3.72 KB
19 rows
3 columns


CREATE TABLE december_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2019

@ukgov.dh_gpc_spend_over_500.march_2019

3.58 KB
15 rows
3 columns


CREATE TABLE march_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

December 2021

@ukgov.dh_gpc_spend_over_500.december_2021

3.5 KB
12 rows
3 columns


CREATE TABLE december_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR,
  "mch_merchant_name" VARCHAR
);

June 2019

@ukgov.dh_gpc_spend_over_500.june_2019

3.49 KB
5 rows
3 columns


CREATE TABLE june_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

August 2021

@ukgov.dh_gpc_spend_over_500.august_2021

3.82 KB
20 rows
3 columns


CREATE TABLE august_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2021

@ukgov.dh_gpc_spend_over_500.march_2021

3.63 KB
19 rows
3 columns


CREATE TABLE march_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2022

@ukgov.dh_gpc_spend_over_500.september_2022

3.78 KB
22 rows
3 columns


CREATE TABLE september_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2022

@ukgov.dh_gpc_spend_over_500.may_2022

3.69 KB
13 rows
3 columns


CREATE TABLE may_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2022

@ukgov.dh_gpc_spend_over_500.march_2022

3.62 KB
11 rows
3 columns


CREATE TABLE march_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

April 2021

@ukgov.dh_gpc_spend_over_500.april_2021

3.81 KB
20 rows
3 columns


CREATE TABLE april_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2021

@ukgov.dh_gpc_spend_over_500.october_2021

3.58 KB
11 rows
3 columns


CREATE TABLE october_2021 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2020

@ukgov.dh_gpc_spend_over_500.november_2020

3.65 KB
14 rows
3 columns


CREATE TABLE november_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2020

@ukgov.dh_gpc_spend_over_500.september_2020

3.38 KB
5 rows
3 columns


CREATE TABLE september_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2022

@ukgov.dh_gpc_spend_over_500.november_2022

3.59 KB
11 rows
3 columns


CREATE TABLE november_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

January 2020

@ukgov.dh_gpc_spend_over_500.january_2020

3.64 KB
13 rows
3 columns


CREATE TABLE january_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

June 2020

@ukgov.dh_gpc_spend_over_500.june_2020

3.49 KB
8 rows
3 columns


CREATE TABLE june_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2020

@ukgov.dh_gpc_spend_over_500.october_2020

3.55 KB
11 rows
3 columns


CREATE TABLE october_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

June 2022

@ukgov.dh_gpc_spend_over_500.june_2022

3.45 KB
7 rows
3 columns


CREATE TABLE june_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

August 2022

@ukgov.dh_gpc_spend_over_500.august_2022

3.6 KB
9 rows
3 columns


CREATE TABLE august_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

December 2018

@ukgov.dh_gpc_spend_over_500.december_2018

3.6 KB
9 rows
3 columns


CREATE TABLE december_2018 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

September 2019

@ukgov.dh_gpc_spend_over_500.september_2019

3.78 KB
19 rows
3 columns


CREATE TABLE september_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

August 2019

@ukgov.dh_gpc_spend_over_500.august_2019

3.49 KB
8 rows
3 columns


CREATE TABLE august_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2020

@ukgov.dh_gpc_spend_over_500.may_2020

3.33 KB
8 rows
3 columns


CREATE TABLE may_2020 (
  "n_11_05_2020" TIMESTAMP,
  "n__944_00" DOUBLE,
  "the_wheatsheaf" VARCHAR
);

February 2020

@ukgov.dh_gpc_spend_over_500.february_2020

3.75 KB
22 rows
3 columns


CREATE TABLE february_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

April 2020

@ukgov.dh_gpc_spend_over_500.april_2020

3.51 KB
14 rows
3 columns


CREATE TABLE april_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

October 2019

@ukgov.dh_gpc_spend_over_500.october_2019

3.86 KB
17 rows
3 columns


CREATE TABLE october_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

July 2021

@ukgov.dh_gpc_spend_over_500.july_2021

3.64 KB
15 rows
3 columns


CREATE TABLE july_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

January 2022

@ukgov.dh_gpc_spend_over_500.january_2022

3.56 KB
9 rows
3 columns


CREATE TABLE january_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR,
  "mch_merchant_name" VARCHAR
);

February 2021

@ukgov.dh_gpc_spend_over_500.february_2021

3.59 KB
13 rows
3 columns


CREATE TABLE february_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

February 2022

@ukgov.dh_gpc_spend_over_500.february_2022

3.71 KB
11 rows
3 columns


CREATE TABLE february_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" VARCHAR,
  "mch_merchant_name" VARCHAR
);

November 2019

@ukgov.dh_gpc_spend_over_500.november_2019

3.67 KB
13 rows
3 columns


CREATE TABLE november_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

November 2021

@ukgov.dh_gpc_spend_over_500.november_2021

3.43 KB
4 rows
3 columns


CREATE TABLE november_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

January 2021

@ukgov.dh_gpc_spend_over_500.january_2021

3.37 KB
3 rows
3 columns


CREATE TABLE january_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

June 2021

@ukgov.dh_gpc_spend_over_500.june_2021

3.74 KB
14 rows
3 columns


CREATE TABLE june_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2021

@ukgov.dh_gpc_spend_over_500.may_2021

3.98 KB
27 rows
3 columns


CREATE TABLE may_2021 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

March 2020

@ukgov.dh_gpc_spend_over_500.march_2020

3.6 KB
13 rows
3 columns


CREATE TABLE march_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

August 2020

@ukgov.dh_gpc_spend_over_500.august_2020

3.67 KB
10 rows
3 columns


CREATE TABLE august_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

December 2019

@ukgov.dh_gpc_spend_over_500.december_2019

3.58 KB
13 rows
3 columns


CREATE TABLE december_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

July 2020

@ukgov.dh_gpc_spend_over_500.july_2020

3.4 KB
5 rows
3 columns


CREATE TABLE july_2020 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

July 2022

@ukgov.dh_gpc_spend_over_500.july_2022

3.8 KB
19 rows
3 columns


CREATE TABLE july_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

July 2019

@ukgov.dh_gpc_spend_over_500.july_2019

3.65 KB
14 rows
3 columns


CREATE TABLE july_2019 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

April 2022

@ukgov.dh_gpc_spend_over_500.april_2022

3.67 KB
13 rows
3 columns


CREATE TABLE april_2022 (
  "fin_posting_date" TIMESTAMP,
  "n__fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

May 2019

@ukgov.dh_gpc_spend_over_500.may_2019

3.59 KB
10 rows
3 columns


CREATE TABLE may_2019 (
  "fin_posting_date" TIMESTAMP,
  "fin_transaction_amount" DOUBLE,
  "mch_merchant_name" VARCHAR
);

Tables