Prompt Payment Data
Food Standards Agency
@ukgov.fsa_prompt_payment_data
Food Standards Agency
@ukgov.fsa_prompt_payment_data
CREATE TABLE prompt_payment_data_2017_to_2018 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" BIGINT
);
CREATE TABLE prompt_payment_data_2018_to_2019 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" BIGINT
);
CREATE TABLE prompt_payment_data_2019_to_2020 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" DOUBLE
);
CREATE TABLE prompt_payment_data_2020_to_2021 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" BIGINT
);
CREATE TABLE prompt_payment_data_2021_to_2022 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" DOUBLE
);
CREATE TABLE prompt_payment_data_2022_to_2023 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" VARCHAR
);
CREATE TABLE prompt_payment_data_2023_to_2024 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE prompt_payment_data_2024_to_2025 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" VARCHAR
);
Anyone who has the link will be able to view this.