Name: Council Spend Above £500
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Council Spend Above £500

Details of payments with an individual value of £500 or more, the information excludes payments to individuals such as refunds and benefit payments etc
Publisher name: Royal Borough of Kensington and Chelsea
Last updated: 2022-07-01T04:07:51Z

Tables

Council Spend Above £500

@ukgov.council_spend_above_500.council_spend_above_500

172.82 KB
2913 rows
19 columns


CREATE TABLE council_spend_above_500 (
  "body_name" VARCHAR,
  "ons_body_code" VARCHAR,
  "service_label" VARCHAR,
  "service_code" VARCHAR,
  "service_division" VARCHAR,
  "service_division_code" VARCHAR,
  "organisational_unit" VARCHAR,
  "expenditure_category" VARCHAR,
  "expenditure_code" VARCHAR,
  "cipfa_detailed_expenditure_type" VARCHAR,
  "glcode" VARCHAR,
  "cipfa_detailed_expenditure_code" DOUBLE,
  "narrative" VARCHAR,
  "date" VARCHAR,
  "transaction_number" VARCHAR,
  "net_amount" VARCHAR,
  "capital_and_revenue" VARCHAR,
  "suppliernameedit" VARCHAR,
  "supplierno" VARCHAR
);