{"@type": "dcat:Dataset", "accessLevel": "public", "contactPoint": {"@type": "vcard:Contact", "fn": "arjun.paul@sfgov.org", "hasEmail": "mailto:no-reply@data.sfgov.org"}, "description": "<strong>Summary</strong>\nThe 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\u2019s 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. 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.\n\nThe 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.\n\n<strong>How the dataset is created</strong>\nThe Controller\u2019s Office performs several significant data cleaning steps before uploading this dataset to the SF Open Data Portal. Please read the cleaning steps below:\n\nCleaning Steps\n1. SF OpenBook provides a filter labeled \u201cNon-Profits Only\u201d (Yes, No), and resulting datasets exported from SF OpenBook include a \u201cNon Profit\u201d 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\u2019s financial system. To ensure a complete dataset, we exported a full list of supplier payment data from SF OpenBook with the \u201cNon-Profits Only\u201d field filtered to \u201cNo\u201d which provides a list of all supplier payments regardless of nonprofit status. 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 also filtered the SF Open Book 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.\u00a0\n\nWe cleaned this data by adding a new \u201cNonprofit\u201d column within the dataset and used this column to note a nonprofit status of \u201cCON-marked Nonprofit\u201d 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\u2019s data system. Download the cleaned and updated dataset on the City\u2019s Open Data Portal, which includes all of the known nonprofits.\n\n2. While the University of California, San Francisco (UCSF) is technically not-for-profit, a university\u2019s financial management is very different from traditional nonprofit service providers, and the City\u2019s 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 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.\n\n3. The Controller's Office also excludes several specific contracts that are predominately \u201cpass through\u201d 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.\n\nAs of report", "distribution": [{"@type": "dcat:Distribution", "downloadURL": "https://data.sfgov.org/api/views/qkex-vh98/rows.csv?accessType=DOWNLOAD", "mediaType": "text/csv"}, {"@type": "dcat:Distribution", "describedBy": "https://data.sfgov.org/api/views/qkex-vh98/columns.rdf", "describedByType": "application/rdf+xml", "downloadURL": "https://data.sfgov.org/api/views/qkex-vh98/rows.rdf?accessType=DOWNLOAD", "mediaType": "application/rdf+xml"}, {"@type": "dcat:Distribution", "describedBy": "https://data.sfgov.org/api/views/qkex-vh98/columns.json", "describedByType": "application/json", "downloadURL": "https://data.sfgov.org/api/views/qkex-vh98/rows.json?accessType=DOWNLOAD", "mediaType": "application/json"}, {"@type": "dcat:Distribution", "describedBy": "https://data.sfgov.org/api/views/qkex-vh98/columns.xml", "describedByType": "application/xml", "downloadURL": "https://data.sfgov.org/api/views/qkex-vh98/rows.xml?accessType=DOWNLOAD", "mediaType": "application/xml"}], "identifier": "https://data.sfgov.org/api/views/qkex-vh98", "issued": "2025-10-06", "keyword": ["nonprofit"], "landingPage": "https://data.sfgov.org/d/qkex-vh98", "modified": "2025-11-25", "publisher": {"@type": "org:Organization", "name": "data.sfgov.org"}, "title": "Citywide Nonprofit Spending"}