Baselight
Sign In

Government Procurement Card Transactions

South Lakeland District Council

@ukgov.government_procurement_card_transactions

Loading...
Loading...

About this Dataset

Government Procurement Card Transactions

This dataset contains the details of every transaction on the Government Procurement Cards held by the council.
Publisher name: South Lakeland District Council
Last updated: 2022-07-01T04:03:54Z

Tables

April 2018

@ukgov.government_procurement_card_transactions.april_2018
  • 15.89 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE april_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

April 2019

@ukgov.government_procurement_card_transactions.april_2019
  • 15.41 KB
  • 688 rows
  • 13 columns
Loading... 

CREATE TABLE april_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

August 2018

@ukgov.government_procurement_card_transactions.august_2018
  • 16.37 KB
  • 687 rows
  • 13 columns
Loading... 

CREATE TABLE august_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

August 2019

@ukgov.government_procurement_card_transactions.august_2019
  • 14.63 KB
  • 1103 rows
  • 13 columns
Loading... 

CREATE TABLE august_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

December 2017

@ukgov.government_procurement_card_transactions.december_2017
  • 14.75 KB
  • 660 rows
  • 13 columns
Loading... 

CREATE TABLE december_2017 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

December 2018

@ukgov.government_procurement_card_transactions.december_2018
  • 15.72 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE december_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

December 2019

@ukgov.government_procurement_card_transactions.december_2019
  • 14.84 KB
  • 662 rows
  • 13 columns
Loading... 

CREATE TABLE december_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

February 2018

@ukgov.government_procurement_card_transactions.february_2018
  • 15.4 KB
  • 675 rows
  • 13 columns
Loading... 

CREATE TABLE february_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

February 2019

@ukgov.government_procurement_card_transactions.february_2019
  • 14.75 KB
  • 660 rows
  • 13 columns
Loading... 

CREATE TABLE february_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

Government Procurement Card Transactions

@ukgov.government_procurement_card_transactions.government_procurement_card_transactions
  • 16.48 KB
  • 99 rows
  • 13 columns
Loading... 

CREATE TABLE government_procurement_card_transactions (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" BIGINT
);

January 2018

@ukgov.government_procurement_card_transactions.january_2018
  • 15.72 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE january_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

January 2019

@ukgov.government_procurement_card_transactions.january_2019
  • 16.82 KB
  • 731 rows
  • 13 columns
Loading... 

CREATE TABLE january_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

July 2018

@ukgov.government_procurement_card_transactions.july_2018
  • 15.14 KB
  • 666 rows
  • 13 columns
Loading... 

CREATE TABLE july_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

July 2019

@ukgov.government_procurement_card_transactions.july_2019
  • 15.81 KB
  • 1102 rows
  • 13 columns
Loading... 

CREATE TABLE july_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

June 2018

@ukgov.government_procurement_card_transactions.june_2018
  • 15.7 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE june_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

June 2019

@ukgov.government_procurement_card_transactions.june_2019
  • 15.36 KB
  • 1102 rows
  • 13 columns
Loading... 

CREATE TABLE june_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

March 2018

@ukgov.government_procurement_card_transactions.march_2018
  • 15.38 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE march_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

March 2019

@ukgov.government_procurement_card_transactions.march_2019
  • 15.5 KB
  • 1102 rows
  • 13 columns
Loading... 

CREATE TABLE march_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

May 2018

@ukgov.government_procurement_card_transactions.may_2018
  • 15.18 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE may_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

May 2019

@ukgov.government_procurement_card_transactions.may_2019
  • 15.55 KB
  • 1102 rows
  • 13 columns
Loading... 

CREATE TABLE may_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

November 2017

@ukgov.government_procurement_card_transactions.november_2017
  • 15.16 KB
  • 679 rows
  • 13 columns
Loading... 

CREATE TABLE november_2017 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

November 2018

@ukgov.government_procurement_card_transactions.november_2018
  • 15.72 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE november_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

November 2019

@ukgov.government_procurement_card_transactions.november_2019
  • 14.23 KB
  • 1146 rows
  • 13 columns
Loading... 

CREATE TABLE november_2019 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" TIMESTAMP,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

October 2017

@ukgov.government_procurement_card_transactions.october_2017
  • 16.47 KB
  • 1056 rows
  • 13 columns
Loading... 

CREATE TABLE october_2017 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

October 2018

@ukgov.government_procurement_card_transactions.october_2018
  • 15.72 KB
  • 1055 rows
  • 13 columns
Loading... 

CREATE TABLE october_2018 (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "paymentdate" VARCHAR,
  "directorate_servicewhereexpenditureincurred" VARCHAR,
  "servicecategorylabel" VARCHAR,
  "servicecategoryuri" VARCHAR,
  "supplier" VARCHAR,
  "netamount" DOUBLE,
  "irrecoverablevat" DOUBLE,
  "purposeofexpenditure" VARCHAR,
  "procurementclassification_proclasslabel" VARCHAR,
  "procrementclassification_proclasscode" DOUBLE
);

Share link

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