About this Dataset

Vendor Payments (Purchase Order Summary)

The San Francisco Controller's Office maintains a database of payments made to vendors from fiscal year 2007 forward. This data is presented on the Vendor Payments report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format, which represents summary data by purchase order. We have removed sensitive information from this data – this is intended to show payments made to entities providing goods and services to the City and County and to protect individuals. For example, we have removed payments to employees (reimbursements, garnishments) and jury members, revenue refunds, payments for judgments and claims, witnesses, relocation and rehousing, and a variety of human services payments. New data is added on a weekly basis.

Supplier payments represent payments to City contractors and vendors that provide goods and/or services to the City. Certain other non-supplier payee payments, which are made to parties other than traditional City contractors and vendors, are also included in this dataset, These include payments made for tax and fee refunds, rebates, settlements, etc.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:48.155323
Tags: amount, open-book, openbook, procurement-contract, purchase-order, sfopenbook, spending, vendor

Tables

Table 1

@usgov.city_of_san_francisco_vendor_payments_purchase_order_summary.table_1

86.82 MB
3,221,400 rows
33 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "related_govt_units" VARCHAR,
  "organization_group_code" BIGINT,
  "organization_group" VARCHAR,
  "department_code" VARCHAR,
  "department" VARCHAR,
  "program_code" VARCHAR,
  "program" VARCHAR,
  "character_code" VARCHAR,
  "character" VARCHAR,
  "object_code" VARCHAR,
  "object" VARCHAR,
  "sub_object_code" BIGINT,
  "sub_object" VARCHAR,
  "fund_type_code" VARCHAR,
  "fund_type" VARCHAR,
  "fund_code" VARCHAR,
  "fund" VARCHAR,
  "fund_category_code" DOUBLE,
  "fund_category" VARCHAR,
  "purchase_order" VARCHAR,
  "supplier_other_non_supplier_payees" VARCHAR  -- Supplier & Other Non-Supplier Payees,
  "vouchers_paid" DOUBLE,
  "vouchers_pending" DOUBLE,
  "encumbrance_balance" DOUBLE,
  "vouchers_pending_retainage" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "non_profit_indicator" VARCHAR,
  "contract_number" DOUBLE,
  "contract_title" VARCHAR,
  "purchase_order_date" TIMESTAMP,
  "purchasing_authority_description" VARCHAR
);