Citywide Nonprofit Spending
Resources
3 resources available
-
Resource 1
JSON -
Resource 2
XML -
Resource 3
CSV
Find Related Datasets
Search by Tags
Click any tag below to search for similar datasets
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{ "fn": "OpenData", "@type": "vcard:Contact", "hasEmail": "mailto:no-reply@data.sf.gov" } |
| description | <strong>A. SUMMARY</strong> 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 FY19. This dataset will be updated at the close of each fiscal year. The underlying data is pulled from Supplier Payments on SF OpenBook. The data pulled for the dashboards reflect supplier transactions that occurred within each fiscal year. Some payments may be made based on prior fiscal year invoices and data may not reflect payments for invoices received after the fiscal year end. 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. <strong>B. HOW THE DATASET IS CREATED</strong> The Controller's Office performs several significant data cleaning steps before uploading this dataset to the SF Open Data Portal. Starting with FY26 data, improvements to how the City's financial system identifies nonprofit suppliers allowed us to simplify the first cleaning step. As a result, Step 1 differs for data through FY25 and data from FY26 onward. Steps 2 and 3 apply to all years. Please read the cleaning steps below: Cleaning Steps 1. Identifying nonprofit suppliers and contracted services All years: Payments to suppliers may include payments for services to the City, such as memberships, use of space, and passthrough payments to beneficiaries. To identify payments specifically for contracted services delivered by nonprofits, we filtered the SF OpenBook report to only include the following types of goods and services prior to exporting the data: Community Based Org Svcs; Homeless Hsng And Supportv Service; Profess & Specialized Svcs; Professional/Specialized Svcs. Data through FY25: 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). Through FY25, this field was not always accurate and excluded about 150 known nonprofits that were 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 "CON-marked Nonprofit" 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. Data from FY26 onward: The City has since improved how nonprofit status is recorded in its financial system, and this status now feeds the "Non-Profits Only" filter in SF OpenBook. Because of this, the manual identification step above is no longer needed. Starting with FY26, we export supplier payment data from SF OpenBook with the "Non-Profits Only" filter set to "Yes", along with the types of goods and services filter described above. Nonprofit status in the City's financial system may change over time as supplier information is updated. 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. The Controller's Office used the "Nonprofit" column to be able to exclude payments to UCSF when reporting on overall spending. There are divisi |
| distribution |
[ { "@type": "dcat:Distribution", "mediaType": "application/json", "describedBy": "https://data.sf.gov/api/views/qkex-vh98/columns.json", "downloadURL": "https://data.sf.gov/api/v3/views/qkex-vh98/query.json?accessType=DOWNLOAD", "describedByType": "application/json" }, { "@type": "dcat:Distribution", "mediaType": "application/xml", "describedBy": "https://data.sf.gov/api/views/qkex-vh98/columns.xml", "downloadURL": "https://data.sf.gov/api/v3/views/qkex-vh98/query.xml?accessType=DOWNLOAD", "describedByType": "application/xml" }, { "@type": "dcat:Distribution", "mediaType": "text/csv", "downloadURL": "https://data.sf.gov/api/v3/views/qkex-vh98/export.csv?accessType=DOWNLOAD" } ] |
| identifier | https://data.sf.gov/api/views/qkex-vh98 |
| issued | 2026-10-30 |
| keyword |
[ "nonprofit" ] |
| landingPage | https://data.sf.gov/d/qkex-vh98 |
| license | http://opendatacommons.org/licenses/pddl/1.0/ |
| modified | 2026-10-30 |
| publisher |
{ "name": "data.sf.gov", "@type": "org:Organization" } |
| title | Citywide Nonprofit Spending |