All GPC Transparency Reports
Food Standards Agency
@ukgov.all_gpc_transparency_reports
Food Standards Agency
@ukgov.all_gpc_transparency_reports
The Food Standards Agency publishes all Government procurement card (GPC) transactions. This supports the Government's drive for transparency and the Agency's own core value of openness and transparency.
Publisher name: Food Standards Agency
Last updated: 2025-03-18T04:00:11Z
CREATE TABLE all_gpc_transparency_reports_november_2021 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_november_2022 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" DOUBLE
);CREATE TABLE all_gpc_transparency_reports_november_2024 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_october_2018 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"costcode" BIGINT,
"expensetype" VARCHAR,
"transactionamount" DOUBLE
);CREATE TABLE all_gpc_transparency_reports_october_2019 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_october_2020 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_october_2021 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_october_2022 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" DOUBLE
);CREATE TABLE all_gpc_transparency_reports_october_2024 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_september_2018 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"costcode" BIGINT,
"expensetype" VARCHAR,
"transactionamount" DOUBLE
);CREATE TABLE all_gpc_transparency_reports_september_2019 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_september_2020 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_september_2021 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" DOUBLE
);CREATE TABLE all_gpc_transparency_reports_september_2022 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);CREATE TABLE all_gpc_transparency_reports_september_2024 (
"transactiondate" TIMESTAMP,
"merchantname" VARCHAR,
"transactionamount" DOUBLE,
"referencenumber" BIGINT
);Anyone who has the link will be able to view this.