Pendle Council Spending
Pendle Borough Council
@ukgov.pendle_council_spending
Pendle Borough Council
@ukgov.pendle_council_spending
CREATE TABLE april_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE april_2020 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE august_2018 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE august_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE december_2018 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE december_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE february_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE february_2020 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE january_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE january_2020 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE july_2018 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE july_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE june_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE march_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE march_2020 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE may_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE may_2020 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE november_2018 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE november_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE october_2018 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE october_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
CREATE TABLE pendle_council_spending (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE september_2018 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" VARCHAR,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR
);
CREATE TABLE september_2019 (
"organisation_name_a" VARCHAR,
"department_b" VARCHAR,
"service_cat_label_c" VARCHAR,
"purpose_of_spend_d" VARCHAR,
"expenditure_cipfa_sub_group_e" VARCHAR,
"supplier_f" VARCHAR,
"supplier_reference_g" VARCHAR,
"pay_date_h" TIMESTAMP,
"transaction_number_i" VARCHAR,
"net_amount_j" DOUBLE,
"grant_to_vcse_k" VARCHAR,
"charity_number_l" VARCHAR,
"card_transaction_m" VARCHAR,
"irrecoverable_vat_n" VARCHAR
);
Anyone who has the link will be able to view this.