About this Dataset

Spend Over £25,000 In The Scotland Office

A monthly-updated list of all financial transactions spending over £25,000 made by the Scotland Office, as part of the Government's commitment to transparency in expenditure. The final column contains a readable explanation of what the money was spent on. No transactions for July 2010-March 2011 were over the threshold, so no file is given.
Publisher name: Scotland Office
Last updated: 2022-07-01T04:07:56Z

Tables

Spend Over £25,000 In The Scotland Office

@ukgov.financial_transactions_data_so.spend_over_25_000_in_the_scotland_office

14.93 KB
3 rows
23 columns


CREATE TABLE spend_over_25_000_in_the_scotland_office (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_reason" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" VARCHAR,
  "vat_registration_no" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" DOUBLE,
  "unnamed_21" DOUBLE,
  "unnamed_22" DOUBLE
);