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

93.4 kB
5,002 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  -- Capital/ Revenue,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);

PCC Spend Over £500 - March 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_march_2015

106.95 kB
5,409 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  -- Capital/ Revenue,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);

PCC Spend Over £500 - November 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_november_2015

90.84 kB
4,766 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  -- Capital/ Revenue,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);

PCC Spend Over £500 - September 2015

@ukgov.plymouth_spend_over_f500_2015.pcc_spend_over_500_september_2015

94.59 kB
5,040 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  -- Capital/ Revenue,
  "supplier_name" VARCHAR,
  "supplier_id" VARCHAR
);