Pendle Government Procurement Card Spend
Pendle Borough Council
@ukgov.pendle_government_procurement_card_spend
Pendle Borough Council
@ukgov.pendle_government_procurement_card_spend
The government recommends that local authorities publish all expenditure made on government procurement cards (GPC). (Please note, areas may be redacted as they may be commercially sensitive or there may be data protection issues). The following details are not included because other purchasing tools and processes are used as the Councils main function for making payments of this kind: i) Supplier registered charity number ii) VCSE grant
Publisher name: Pendle Borough Council
Last updated: 2024-09-14T14:32:33Z
CREATE TABLE april_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE august_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE december_2018 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE december_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE february_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE january_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE july_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE june_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE march_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE may_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE november_2018 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE november_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE october_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);CREATE TABLE september_2019 (
"organisation_a" VARCHAR -- Organisation (A),
"department_b" VARCHAR -- Department (B),
"transaction_date_c" TIMESTAMP -- Transaction Date (C),
"supplier_name_d" VARCHAR -- Supplier Name (D),
"type_narrative_of_supply_e" VARCHAR -- Type/Narrative Of Supply (E),
"net_amount_f" DOUBLE -- Net Amount (F),
"irrecoverable_vat_g" VARCHAR -- Irrecoverable VAT (G)
);Anyone who has the link will be able to view this.