About this Dataset

Council Spend Over £500

Data showing Plymouth City Council spend over £500.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:04:31Z

Tables

PCC Spend Over £500 - December 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_december_2015

91.21 KB
5002 rows
12 columns


CREATE TABLE pcc_spend_over_500_december_2015 (
  "body_name" VARCHAR,
  "body" VARCHAR,
  "service_label" VARCHAR,
  "organisational_unit" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "capital_revenue" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);

PCC Spend Over £500 - March 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_march_2015

104.45 KB
5409 rows
12 columns


CREATE TABLE pcc_spend_over_500_march_2015 (
  "body_name" VARCHAR,
  "body" VARCHAR,
  "service_label" VARCHAR,
  "organisational_unit" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "capital_revenue" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);

PCC Spend Over £500 - November 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_november_2015

88.71 KB
4766 rows
12 columns


CREATE TABLE pcc_spend_over_500_november_2015 (
  "body_name" VARCHAR,
  "body" VARCHAR,
  "service_label" VARCHAR,
  "organisational_unit" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "capital_revenue" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);

PCC Spend Over £500 - September 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_september_2015

92.37 KB
5040 rows
12 columns


CREATE TABLE pcc_spend_over_500_september_2015 (
  "body_name" VARCHAR,
  "body" VARCHAR,
  "service_label" VARCHAR,
  "organisational_unit" VARCHAR,
  "expenditure_category" VARCHAR,
  "detailed_expenses_type" VARCHAR,
  "date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "capital_revenue" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);