Pendle Government Procurement Card Spend
Pendle Borough Council
@ukgov.pendle_government_procurement_card_spend
Pendle Borough Council
@ukgov.pendle_government_procurement_card_spend
CREATE TABLE april_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE august_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE december_2018 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE december_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE february_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE january_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE july_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE june_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE march_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE may_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE november_2018 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE november_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE october_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
CREATE TABLE september_2019 (
"organisation_a" VARCHAR,
"department_b" VARCHAR,
"transaction_date_c" TIMESTAMP,
"supplier_name_d" VARCHAR,
"type_narrative_of_supply_e" VARCHAR,
"net_amount_f" DOUBLE,
"irrecoverable_vat_g" VARCHAR
);
Anyone who has the link will be able to view this.