DWP Prompt Payment Data
Department for Work and Pensions
@ukgov.dwp_prompt_payment_data
Department for Work and Pensions
@ukgov.dwp_prompt_payment_data
CREATE TABLE prompt_payment_data_1_april_2015_to_31_march_2016 (
"department_for_work_and_pensions" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2016_to_31_march_2017 (
"department_for_work_and_pensions" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2017_to_31_march_2018 (
"department_for_work_and_pensions" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2018_to_31_march_2019 (
"department_for_work_and_pensions" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2019_to_31_march_2020 (
"financial_year_2019_to_2020" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"late_payment_interest" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2020_to_31_march_2021 (
"financial_year_2020_to_2021" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"late_payment_interest" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2021_to_31_march_2022 (
"period" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"late_payment_interest" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2022_to_31_march_2023 (
"period" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"late_payment_interest" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2023_to_31_march_2024 (
"period" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"late_payment_interest" VARCHAR
);
CREATE TABLE prompt_payment_data_1_april_2024_to_31_march_2025 (
"period" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"late_payment_interest" VARCHAR
);
Anyone who has the link will be able to view this.