The San Francisco Controller's Office maintains a database of actual citywide staffing data from fiscal year 2003 forward. This data is presented on the Spending and Revenue report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on a weekly basis.

The San Francisco Controller's Office maintains a database of spending and revenue data sourced from it's citywide financial system. This data is presented on the Spending and Revenue report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on a weekly basis, and is available from fiscal year 2000 forward.

The San Francisco Controller's Office maintains a database of budgetary data that appears in summarized form in each Annual Appropriation Ordinance (AAO). This data is presented on the Budget report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on an annual basis when the AAO is published for each new fiscal year. Data is available from fiscal year 2010 forward.

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.

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.

Summary The City and County of San Francisco contracts with hundreds of nonprofit organizations to provide services for San Franciscans. These services include healthcare, legal aid, shelter, children’s programming, and more. This dataset contains all payments issued to nonprofit organizations by City departments since FY2019. This dataset will be updated at the close of each fiscal year. The underlying data is pulled from Supplier Payments on SF OpenBook. Please use SF OpenBook to find current-year data. The data in this dataset are presented in easy-to-read dashboards on our website. View the dashboards here: https://www.sf.gov/data/san-francisco-nonprofit-contracts-and-spending. How the dataset is created The Controller’s Office performs several significant data cleaning steps before uploading this dataset to the SF Open Data Portal. Please read the cleaning steps below: Cleaning Steps 1. SF OpenBook provides a filter labeled “Non-Profits Only” (Yes, No), and resulting datasets exported from SF OpenBook include a “Non Profit” column to indicate whether the supplier is a nonprofit (Yes, Blank). However, this field is not always accurate and excludes about 150 known nonprofits that are not labeled as a nonprofit in the City’s financial system. To ensure a complete dataset, we exported a full list of supplier payment data from SF OpenBook with the “Non-Profits Only” field filtered to “No” which provides a list of all supplier payments regardless of nonprofit status. We cleaned this data by adding a new “Nonprofit” column within the dataset and used this column to note a nonprofit status of “Yes” for approximately 150 known nonprofit suppliers without this indicator flagged in the financial system in addition to any nonprofits already accurately flagged in the system. We then filtered the full dataset using the new nonprofit column and used the filtered data for all of the dashboards on the webpage linked above. The list of excluded nonprofits may change over time as information gets updated in the City’s data system. Download the cleaned and updated dataset on the City’s Open Data Portal, which includes all of the known nonprofits. 2. While the University of California, San Francisco (UCSF) is technically not-for-profit, a university’s financial management is very different from traditional nonprofit service providers, and the City’s agreement with UCSF includes hospital staffing in addition to contracted services to the public. As such, the Controller's Office created a nonprofit column to be able to exclude payments to UCSF when reporting on overall spending. There are divisions of UCSF that provide more traditional contracted services, but these cannot be clearly identified in the data. Note that filtering out this data may reflect an underrepresentation of overall spending. 3. The Controller's Office also excludes several specific contracts that are predominately “pass through” payments where the nonprofit provider receives funds that they disperse to other agencies, such as for childcare or workforce subsidies. These types of contracts are substantially different from contracts where the nonprofit is providing direct services to San Franciscans. Update process This dataset will be manually updated after year-end financial processing is complete, typically in September. There may be a delay between the end of the fiscal year and the publication of this dataset.

A. SUMMARY This dataset is a cleaned and anonymized version of survey data gathered in FY23 from nonprofits who contract with the City and County of San Francisco. Each row is one employee (representing one filled position), and data includes wages, position detail, position requirements, and demographic information as supplied by the person's employing organization. B. HOW THE DATASET IS CREATED This dataset was generated through conducting a two-tiered survey gathering data on organizational characteristics and position-level data from nonprofits who contract with the City and County of San Francisco in FY23. The survey was fielded in October and November of 2022. 152 nonprofits provided organizational-level data and summary data about their workforce. 29 of those organizations (referred to as "Cohort Organizations") provided additional position-level wage, demographic, and position-requirement data for each worker employed by their organization. This dataset includes position-level data from the cohort organizations. For further details on survey methodology, please review page 39 of the Nonprofit Wage and Equity Survey report, linked below in "Related Reports." C. UPDATE PROCESS Data is a one-time survey and will not update. D. HOW TO USE THIS DATASET Review code book, attached in the "About this Dataset" section. E. RELATED REPORTS This dataset informs the Nonprofit Wage and Equity Survey Report, released by the Controller's Office in April 2023. Nonprofit Wage and Equity Survey F. RELATED DATASETS This dataset is one of two datasets of survey data from the Nonprofit Wage and Equity Survey (FY23). Organization-level data can be viewed on the Open Data Portal. Nonprofit Wage and Equity Survey - Organization-Level Survey Data - FY23

A. SUMMARY This dataset is a cleaned and anonymized version of survey data gathered in FY23 from nonprofits who contract with the City and County of San Francisco. Each row is one organization and data includes general information about the nonprofit's services, finances, and operations, and summary demographic data about each nonprofit's workforce. B. HOW THE DATASET IS CREATED This dataset was generated through conducting a two-tiered survey gathering data on organizational characteristics and position-level data from nonprofits who contract with the City and County of San Francisco in FY23. The survey was fielded in October and November of 2022. 152 nonprofits provided organizational-level data and summary data about their workforce. 29 of those organizations (referred to as "Cohort Organizations") provided additional position-level data. This dataset includes organization-level data for the 152 respondent organizations. For further details on survey methodology, please review page 39 of the Nonprofit Wage and Equity Survey report, linked below in "Related Reports." C. UPDATE PROCESS Data is a one-time survey and will not update. D. HOW TO USE THIS DATASET Review code book, attached in the "About this Dataset" section. E. RELATED REPORTS This dataset informs the Nonprofit Wage and Equity Survey Report, released by the Controller's Office in April 2023. Nonprofit Wage and Equity Survey F. RELATED DATASETS This dataset is one of two datasets of survey data from the Nonprofit Wage and Equity Survey (FY23). Position-level data can be viewed on the Open Data Portal. Nonprofit Wage and Equity Survey - Position-Level Cohort Data - FY23

The San Francisco Controller's Office maintains a database of open bid opportunities sourced from it's citywide financial system. This data is available in this dataset in CSV format. The data is updated on a weekly basis.

Excel Summary of the Department's major program activities and statistical profile of California business taxpayers.