Wirral Expenditure Exceeding £500
Wirral Metropolitan Borough Council
@ukgov.https_www_wirral_gov_uk_about_council_budgets_and_spen_1bddcdc9
Wirral Metropolitan Borough Council
@ukgov.https_www_wirral_gov_uk_about_council_budgets_and_spen_1bddcdc9
This dataset provides information on Wirral Councils spend over £500. Details are provided to meet the Local Government Transparency Code 2015. The payment date for credit card payments gives the actual date of spend, the payment of the statement may be later.
Publisher name: Wirral Metropolitan Borough Council
Last updated: 2024-12-19T04:00:09Z
CREATE TABLE expenditure_exceeding_500_april_2021 (
"payments_for_publishing_for_invoices_paid_between_01_a_5ebdd018" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-APR-2021 And 30-APR-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_april_2023 (
"payments_for_publishing_for_invoices_paid_between_01_a_44d07358" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-APR-2023 And 30-APR-2023,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_august_2021 (
"payments_for_publishing_for_invoices_paid_between_01_a_2ed0c55a" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-AUG-2021 And 31-AUG-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_december_2021 (
"payments_for_publishing_for_invoices_paid_between_01_d_7c4e42f4" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-DEC-2021 And 31-DEC-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_february_2021 (
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__paid_date" TIMESTAMP -- Paid Date,
"paid_amount" DOUBLE,
"n__department" VARCHAR -- Department,
"cost_centre" VARCHAR,
"description" VARCHAR,
"irrecoverable_vat" DOUBLE
);CREATE TABLE expenditure_exceeding_500_february_2022 (
"payments_for_publishing_for_invoices_paid_between_01_f_9b318167" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-FEB-2022 And 28-FEB-2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE expenditure_exceeding_500_january_2021 (
"payments_for_publishing_for_invoices_paid_between_01_j_190710eb" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-JAN-2021 And 31-JAN-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_january_2022 (
"payments_for_publishing_for_invoices_paid_between_01_j_a7f79c4e" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-JAN-2022 And 31-JAN-2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_july_2021 (
"payments_for_publishing_for_invoices_paid_between_01_j_bff2c0e5" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-JUL-2021 And 31-JUL-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_june_2021 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"payments_for_publishing_for_invoices_paid_between_01_j_d030d2e9" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-JUN-2021 And 30-JUN-2021,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_march_2021 (
"payments_for_publishing_for_invoices_paid_between_01_m_99e1e193" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-MAR-2021 And 31-MAR-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_march_2022 (
"payments_for_publishing_for_invoices_paid_between_01_m_b5ca3518" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-MAR-2022 And 31-MAR-2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_may_2021 (
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__paid_date" TIMESTAMP -- Paid Date,
"paid_amount" DOUBLE,
"n__department" VARCHAR -- Department,
"cost_centre" VARCHAR,
"description" VARCHAR,
"irrecoverable_vat" DOUBLE
);CREATE TABLE expenditure_exceeding_500_may_2023 (
"payments_for_publishing_for_invoices_paid_between_01_m_3868cef3" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-MAY-2023 And 31-MAY-2023,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_november_2021 (
"payments_for_publishing_for_invoices_paid_between_01_n_d03a3feb" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-NOV-2021 And 30-NOV-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_november_2022 (
"payments_for_publishing_for_invoices_paid_between_01_n_4540fbf6" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-NOV-2022 And 30-NOV-2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_october_2021 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"payments_for_publishing_for_invoices_paid_between_01_o_5864ef12" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-OCT-2021 And 31-OCT-2021,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_october_2022 (
"payments_for_publishing_for_invoices_paid_between_01_o_8633c07f" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-OCT-2022 And 31-OCT-2022,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE expenditure_exceeding_500_september_2021 (
"payments_for_publishing_for_invoices_paid_between_01_s_822561b2" VARCHAR -- Payments For Publishing For Invoices Paid Between 01-SEP-2021 And 30-SEP-2021,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);Anyone who has the link will be able to view this.