Purchasing Commodity Data

The San Francisco Controller's Office maintains a database of purchasing activity from fiscal year 2007 forward. This data is presented on the Purchasing Commodity Data report in CSV format, and represents detailed commodity-level data by purchase order. Additional lines have been added to this dataset to reconcile some document totals from the City's purchasing system to the totals from the City's accounting system in cases when the two amounts are different, which sometimes occurs due to adjustments entered into the accounting system but not the purchasing system. 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.

旧金山财政局持续维护自2007财年以来采购活动的数据库。该数据以CSV格式呈现于采购商品数据报告中，详尽地展示了按采购订单的商品级数据。此外，为了调和市采购系统与市会计系统之间在某些情况下存在的金额差异，数据集中增加了额外的行。这种差异有时是由于会计系统中但非采购系统中输入的调整所导致。我们从数据中移除了敏感信息，此举措旨在展示向为市及县提供商品和服务的实体所支付的款项，并保护个人隐私。例如，我们移除了对员工的支付（报销、扣款）和陪审团成员的支付，以及收入退款、判决和索赔的支付、证人费用、搬迁和重新安置，以及各类人类服务支付。新数据每周定期更新。供应商支付代表了支付给为城市提供商品和/或服务的城市承包商和供应商的款项。此外，本数据集还包括支付给除传统城市承包商和供应商以外的其他非供应商收款人的款项，这些款项包括税款和费用退款、折扣、和解金等。