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

October 2019

@ukgov.government_procurement_card_transactions.october_2019

16.76 KB
1146 rows
13 columns


CREATE TABLE october_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
);

September 2017

@ukgov.government_procurement_card_transactions.september_2017

16.39 KB
1056 rows
13 columns


CREATE TABLE september_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
);

September 2018

@ukgov.government_procurement_card_transactions.september_2018

16.39 KB
1056 rows
13 columns


CREATE TABLE september_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
);

September 2019

@ukgov.government_procurement_card_transactions.september_2019

16.55 KB
688 rows
13 columns


CREATE TABLE september_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
);