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_july_2021 (
"jul_21" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_july_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_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount_gbp" DOUBLE,
"comments" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_june_2019 (
"jun_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_june_2020 (
"jun_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_june_2021 (
"jun_21" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_june_2022 (
"jun_22" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_june_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount_gbp" DOUBLE,
"comments" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_march_2019 (
"mar_19" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_march_2020 (
"mar_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_march_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_march_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_may_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_may_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_may_2021 (
"may_21" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_may_2022 (
"may_22" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_november_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_november_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" BIGINT,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_november_2020 (
"nov_20" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_november_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_october_2019 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_october_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_october_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"supplier" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR,
"description_1" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_october_2024 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"supplier" VARCHAR,
"amount_gbp" DOUBLE,
"comments" VARCHAR
);
CREATE TABLE electronic_purchasing_card_solution_use_september_2019 (
"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.