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
  • 16.27 kB
  • 1,055 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.78 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.76 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.98 kB
  • 1,103 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
  • 15.11 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
  • 16.09 kB
  • 1,055 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
  • 15.2 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.77 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
  • 15.11 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.87 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
  • 16.09 kB
  • 1,055 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
  • 17.22 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.51 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
  • 16.19 kB
  • 1,102 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
  • 16.07 kB
  • 1,055 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.73 kB
  • 1,102 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.74 kB
  • 1,055 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.87 kB
  • 1,102 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.54 kB
  • 1,055 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.93 kB
  • 1,102 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.53 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
  • 16.09 kB
  • 1,055 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.57 kB
  • 1,146 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.87 kB
  • 1,056 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
  • 16.09 kB
  • 1,055 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.