About this Dataset

Rushmoor Procurement Card Spend

This dataset is a list of the spend by Rushmoor Borough Council on procurement cards. Issued following the transparency code 2014, it follows the recommended schema issued by the LGA. PLEASE NOTE: This is currently a draft release and is incomplete, there will be regular updates, so please check back frequently. Please contact us if you have any specific queries
Publisher name: Rushmoor Borough Council
Last updated: 2024-06-14T04:03:03Z

Tables

Procurement Card Spend May 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_may_2020

14.15 kB
75 rows
13 columns

CREATE TABLE procurement_card_spend_may_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend May 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_may_2021

13.97 kB
102 rows
13 columns

CREATE TABLE procurement_card_spend_may_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" BIGINT,
  "cost_centre" BIGINT,
  "detail_code" VARCHAR,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend November 2018

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2018

18.45 kB
183 rows
13 columns

CREATE TABLE procurement_card_spend_november_2018 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend November 2019

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2019

20.61 kB
281 rows
13 columns

CREATE TABLE procurement_card_spend_november_2019 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend November 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2020

12.58 kB
35 rows
13 columns

CREATE TABLE procurement_card_spend_november_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend November 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2021

15.95 kB
152 rows
13 columns

CREATE TABLE procurement_card_spend_november_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend October 2019

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_october_2019

16.41 kB
151 rows
13 columns

CREATE TABLE procurement_card_spend_october_2019 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend October 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_october_2020

12.72 kB
46 rows
13 columns

CREATE TABLE procurement_card_spend_october_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend October 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_october_2021

14.15 kB
88 rows
13 columns

CREATE TABLE procurement_card_spend_october_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend September 2019

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_september_2019

17.52 kB
165 rows
13 columns

CREATE TABLE procurement_card_spend_september_2019 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend September 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_september_2020

13.01 kB
53 rows
13 columns

CREATE TABLE procurement_card_spend_september_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Procurement Card Spend September 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_september_2021

17.73 kB
174 rows
13 columns

CREATE TABLE procurement_card_spend_september_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" BIGINT,
  "detail_code" BIGINT,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR
);

Rushmoor Procurement Card Spend

@ukgov.rushmoor_procurement_card_spend.rushmoor_procurement_card_spend

16.76 kB
122 rows
17 columns

CREATE TABLE rushmoor_procurement_card_spend (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" DOUBLE,
  "detail_code" DOUBLE,
  "service_category_label" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE,
  "purpose_of_spend" VARCHAR,
  "procurement_classification" VARCHAR,
  "card_transaction" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);