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 The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013. B. HOW THE DATASET IS CREATED This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. C. UPDATE PROCESS New data is added on a bi-annual basis when available for each fiscal and calendar year. D. HOW TO USE THIS DATASET Before using please first review the following two resources:

Annually, the San Francisco Health Service System (SFHSS) publishes a demographic report of its membership. SFHSS administers comprehensive health benefits for employees and retirees from the City and County of San Francisco (CCSF), San Francisco Unified School District (SFUSD), City College of San Francisco (SFCCD), and the Superior Court of San Francisco (CRT), as well as their eligible dependents.

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

A. SUMMARY This dataset contains a preliminary inventory of artificial intelligence (AI) systems declared by departments within the City and County of San Francisco (CCSF), as part of compliance with Chapter 22J of the Administrative Code. Chapter 22J requires departments and vendors to answer 22 standardized questions about AI technologies that are in use—excluding those used solely for internal administration or cybersecurity purposes. This is an initial release and may not yet reflect a complete list. A comprehensive, citywide inventory will be published by January 2026. For more information, see the full ordinance: Chapter 22J – Artificial Intelligence Tools B. HOW THE DATASET IS CREATED Each City department is required to annually submit an AI inventory as part of their compliance with Chapter 22J. Departments complete a standardized intake form that captures key details about each AI system in use or under consideration. The submitted inventories are reviewed and consolidated by the Department of Technology C. UPDATE PROCESS The full dataset of AI technologies and uses will be published by Jan 2026 and updated every two years D. HOW TO USE THIS DATASET Each row represents an individual AI technology reported by a City department, along with details about its use. The dataset includes 22 columns corresponding to the required questions outlined in Chapter 22J

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

A. SUMMARY This dataset contains information about the Employment of Local Officeholders and City Employees section of the Campaign Consultant Report. For more information, visit the Ethics Commission’s webpage on Campaign Consultants. B. HOW THE DATASET IS CREATED Data for this dataset is created when campaign consultants electronically file the following reports with employment information: Form 3 – Quarterly Disclosure Report for Campaign Consultants Form 6 – Campaign Consultant Termination Statement This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants. D. HOW TO USE THIS DATASET The unique row identifier for an employment entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”. E. RELATED DATASETS For detail reporting on campaign consultant activities, visit SFEC Campaign Consultant Report.