Baselight
Sign In

Pendle Council Spending

Pendle Borough Council

@ukgov.pendle_council_spending

Loading...
Loading...

About this Dataset

Pendle Council Spending

The government recommends that local authorities publish expenditure over £500 and all expenditure made on purchasing cards. In line with our commitment to openness and transparency we will now be publishing ALL transactions (note; areas may be redacted as they may be commercially sensitive or there may be data protection issues). This dataset also includes VCSE grant information.
Publisher name: Pendle Borough Council
Last updated: 2024-09-14T14:30:36Z

Tables

April 2019

@ukgov.pendle_council_spending.april_2019
  • 29.3 kB
  • 703 rows
  • 16 columns
Loading... 
CREATE TABLE april_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

April 2020

@ukgov.pendle_council_spending.april_2020
  • 67.67 kB
  • 1,996 rows
  • 14 columns
Loading... 
CREATE TABLE april_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

August 2018

@ukgov.pendle_council_spending.august_2018
  • 28.94 kB
  • 700 rows
  • 16 columns
Loading... 
CREATE TABLE august_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

August 2019

@ukgov.pendle_council_spending.august_2019
  • 31.14 kB
  • 954 rows
  • 14 columns
Loading... 
CREATE TABLE august_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

December 2018

@ukgov.pendle_council_spending.december_2018
  • 28.96 kB
  • 822 rows
  • 16 columns
Loading... 
CREATE TABLE december_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

December 2019

@ukgov.pendle_council_spending.december_2019
  • 30 kB
  • 868 rows
  • 14 columns
Loading... 
CREATE TABLE december_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

February 2019

@ukgov.pendle_council_spending.february_2019
  • 28.29 kB
  • 718 rows
  • 15 columns
Loading... 
CREATE TABLE february_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

February 2020

@ukgov.pendle_council_spending.february_2020
  • 28.66 kB
  • 791 rows
  • 14 columns
Loading... 
CREATE TABLE february_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

January 2019

@ukgov.pendle_council_spending.january_2019
  • 30.86 kB
  • 925 rows
  • 15 columns
Loading... 
CREATE TABLE january_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

January 2020

@ukgov.pendle_council_spending.january_2020
  • 30.05 kB
  • 867 rows
  • 14 columns
Loading... 
CREATE TABLE january_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

July 2018

@ukgov.pendle_council_spending.july_2018
  • 30.53 kB
  • 988 rows
  • 15 columns
Loading... 
CREATE TABLE july_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

July 2019

@ukgov.pendle_council_spending.july_2019
  • 28.41 kB
  • 839 rows
  • 14 columns
Loading... 
CREATE TABLE july_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

June 2019

@ukgov.pendle_council_spending.june_2019
  • 32.52 kB
  • 902 rows
  • 14 columns
Loading... 
CREATE TABLE june_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

March 2019

@ukgov.pendle_council_spending.march_2019
  • 32.77 kB
  • 1,014 rows
  • 14 columns
Loading... 
CREATE TABLE march_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

March 2020

@ukgov.pendle_council_spending.march_2020
  • 30.89 kB
  • 1,001 rows
  • 14 columns
Loading... 
CREATE TABLE march_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

May 2019

@ukgov.pendle_council_spending.may_2019
  • 31.65 kB
  • 942 rows
  • 14 columns
Loading... 
CREATE TABLE may_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

May 2020

@ukgov.pendle_council_spending.may_2020
  • 28.88 kB
  • 834 rows
  • 14 columns
Loading... 
CREATE TABLE may_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

November 2018

@ukgov.pendle_council_spending.november_2018
  • 32.52 kB
  • 911 rows
  • 16 columns
Loading... 
CREATE TABLE november_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

November 2019

@ukgov.pendle_council_spending.november_2019
  • 28.43 kB
  • 836 rows
  • 14 columns
Loading... 
CREATE TABLE november_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

October 2018

@ukgov.pendle_council_spending.october_2018
  • 31.77 kB
  • 979 rows
  • 15 columns
Loading... 
CREATE TABLE october_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

October 2019

@ukgov.pendle_council_spending.october_2019
  • 33.54 kB
  • 1,078 rows
  • 14 columns
Loading... 
CREATE TABLE october_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

Pendle Council Spending

@ukgov.pendle_council_spending.pendle_council_spending
  • 34.77 kB
  • 1,038 rows
  • 17 columns
Loading... 
CREATE TABLE pendle_council_spending (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

September 2018

@ukgov.pendle_council_spending.september_2018
  • 30.44 kB
  • 929 rows
  • 16 columns
Loading... 
CREATE TABLE september_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" VARCHAR  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

September 2019

@ukgov.pendle_council_spending.september_2019
  • 29.9 kB
  • 878 rows
  • 14 columns
Loading... 
CREATE TABLE september_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "department_b" VARCHAR  -- Department (B),
  "service_cat_label_c" VARCHAR  -- Service Cat Label (C ),
  "purpose_of_spend_d" VARCHAR  -- Purpose Of Spend (D),
  "expenditure_cipfa_sub_group_e" VARCHAR  -- Expenditure CIPFA Sub Group (E ),
  "supplier_f" VARCHAR  -- Supplier (F),
  "supplier_reference_g" VARCHAR  -- Supplier Reference (G),
  "pay_date_h" TIMESTAMP  -- Pay Date (H),
  "transaction_number_i" VARCHAR  -- Transaction Number (I),
  "net_amount_j" DOUBLE  -- Net Amount (J),
  "grant_to_vcse_k" VARCHAR  -- Grant To VCSE? (K),
  "charity_number_l" VARCHAR  -- Charity Number (L),
  "card_transaction_m" VARCHAR  -- Card Transaction (M),
  "irrecoverable_vat_n" VARCHAR  -- Irrecoverable VAT (N)
);

Share link

Anyone who has the link will be able to view this.