About this Dataset

Vendor Payments (Vouchers)

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 detailed data by voucher. 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.

City Department spending may occur three ways: 1) from Contract to Purchase Order (i.e. a PO with an accounting Encumbrance) to Payment (i.e. an accounting Voucher), AKA On-Contract spending, 2) direct-to-Purchase Order (no contract, only a PO agreement and accounting Encumbrance) to Payment, and 3) Direct Voucher Payment (for limited one-time, non-recurring payments, e.g. a membership or a subscription). Therefore, it is helpful to use both the Supplier Contracts and Supplier Payments reports on SFOpenBook, as well as on DataSF.

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:46.390821
Tags: amount, open-book, openbook, sfopenbook, spending, vendor, voucher

Tables

Table 1

@usgov.city_of_san_francisco_vendor_payments_vouchers.table_1

135.99 MB
7503486 rows
32 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" VARCHAR,
  "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,
  "vouchers_paid" DOUBLE,
  "vouchers_pending" DOUBLE,
  "vouchers_pending_retainage" DOUBLE,
  "voucher" VARCHAR,
  "data_as_of" TIMESTAMP,
  "data_loaded_at" VARCHAR,
  "non_profit_indicator" VARCHAR,
  "contract_number" DOUBLE,
  "contract_title" VARCHAR,
  "purchasing_authority_title" VARCHAR
);