Electronic Purchasing Card Solution Use - HM Revenue & Customs
HM Revenue and Customs
@ukgov.government_procurement_card_use_hmrc
HM Revenue and Customs
@ukgov.government_procurement_card_use_hmrc
CREATE TABLE electronic_purchasing_card_solution_use_april_2019 (
"apr_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_april_2020 (
"apr_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_april_2021 (
"apr_21" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_april_2022 (
"apr_22" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_august_2019 (
"aug_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_august_2020 (
"aug_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_august_2021 (
"aug_21" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_august_2022 (
"aug_22" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_august_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount_gbp" DOUBLE,
"comments" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_december_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_december_2019 (
"dec_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_december_2020 (
"dec_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_december_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_december_2023 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount_gbp" DOUBLE,
"description" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_february_2019 (
"feb_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_february_2020 (
"feb_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_february_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_february_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_hm_revenue_customs (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_january_2019 (
"jan_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_january_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" BIGINT,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_january_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_january_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_july_2019 (
"jul_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_july_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" BIGINT,
"description" VARCHAR,
"description_1" VARCHAR
);
Anyone who has the link will be able to view this.