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. 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. 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.

Context

Form 990 (officially, the "Return of Organization Exempt From Income Tax"1) is a United States Internal Revenue Service form that provides the public with financial information about a nonprofit organization. It is often the only source of such information. It is also used by government agencies to prevent organizations from abusing their tax-exempt status. Source: https://en.wikipedia.org/wiki/Form_990

Content

Form 990 is used by the United States Internal Revenue Service to gather financial information about nonprofit/exempt organizations. This BigQuery dataset can be used to perform research and analysis of organizations that have electronically filed Forms 990, 990-EZ and 990-PF. For a complete description of data variables available in this dataset, see the IRS’s extract documentation: https://www.irs.gov/uac/soi-tax-stats-annual-extract-of-tax-exempt-organization-financial-data.

Update Frequency: Annual

Fork this kernel to get started with this dataset.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:irs_990

https://cloud.google.com/bigquery/public-data/irs-990

Dataset Source: U.S. Internal Revenue Service. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @rawpixel from Unplash.

Inspiration

What organizations filed tax exempt status in 2015?

What was the revenue of the American Red Cross in 2017?

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 Nonprofit organizations receiving more than $100,000 in annual funding from the City must make certain information publicly available. Each year, once nonprofits post their economic statements, they then complete an online form to let us know that they have complied. This dataset contains the responses to this form.

B. HOW THE DATASET IS CREATED Each year, nonprofit organizations complete the online form. The City stores the results and publishes them here.

C. UPDATE PROCESS An automated process runs each morning at 8:00am and publishes the form responses submitted during the previous 24 hours.

D. HOW TO USE THIS DATASET This dataset can be used to track nonprofit compliance with San Francisco Administrative Code Chapter 10.1. Annual Economic Statement -- City-funded Organizations.

E. RELATED DATASETS & LINKS

• Supplier Contracts
• ProPublica's Nonprofit Explorer
• San Francisco Administrative Code Chapter 10.1. Annual Economic Statement -- City-funded Organizations
• Post your nonprofit annual economic statement
• Learn about the nonprofit annual economic statement

The Nonprofit Research Activities (NPRA) module of the Annual Business Survey measures research and experimental development (R&D) performance and funding at U.S. 501(c) nonprofit organizations. The data is collected by the Census Bureau in partnership with the National Center for Science and Engineering Statistics within the National Science Foundation.

A. SUMMARY This dataset was created to support local nonprofit organizations seeking qualified and available auditors to perform their auditing work timely. Included in this dataset are accounting firm details on: The budget size of nonprofits the firms are interested in working with Whether the firms have prior nonprofit auditing experience The firms' ability to work on-site in San Francisco The firms' ability to perform Single Audits for nonprofits receiving Federal funding Additional types of services the firms provide in addition to auditing B. HOW THE DATASET IS CREATED The Controller’s Office surveyed over 400 local, state, and national accounting firms to develop this dataset, asking surveyed firms to provide details on their interest and history with conducting nonprofit financial audits. This dataset reflects verbatim the most recent survey responses; firms may not have answered all questions. C. UPDATE PROCESS The Controller's Office provides a live link to allow firms to submit new or updated data at any time. Approximately twice annually, the Controller's Office will refresh the posted dataset with new results submitted in the prior period. D. HOW TO USE THIS DATASET Use this dataset to find accounting firms that meet your organization's needs. Please note nonprofit organizations are strongly encouraged to do further outreach and perform additional review of qualifications to confirm firms’ nonprofit auditing expertise and capacity. Nonprofit organizations are also encouraged to do additional research to identify accounting firms best suited for their organization’s needs. E. RELATED DATASETS Not applicable.

A. SUMMARY This dataset was created to support local nonprofit organizations seeking qualified and available auditors to perform their auditing work timely. Included in this dataset are accounting firm details on:

1. The budget size of nonprofits the firms are interested in working with
2. Whether the firms have prior nonprofit auditing experience
3. The firms' ability to work on-site in San Francisco
4. The firms' ability to perform Single Audits for nonprofits receiving Federal funding
5. Additional types of services the firms provide in addition to auditing

B. HOW THE DATASET IS CREATED The Controller’s Office surveyed over 400 local, state, and national accounting firms to develop this dataset, asking surveyed firms to provide details on their interest and history with conducting nonprofit financial audits. This dataset reflects verbatim the most recent survey responses; firms may not have answered all questions.

C. UPDATE PROCESS The Controller's Office provides a live link to allow firms to submit new or updated data at any time. Approximately twice annually, the Controller's Office will refresh the posted dataset with new results submitted in the prior period.

D. HOW TO USE THIS DATASET Use this dataset to find accounting firms that meet your organization's needs. Please note nonprofit organizations are strongly encouraged to do further outreach and perform additional review of qualifications to confirm firms’ nonprofit auditing expertise and capacity. Nonprofit organizations are also encouraged to do additional research to identify accounting firms best suited for their organization’s needs.

E. RELATED DATASETS Not applicable.

This dataset is about books. It has 1 row and is filtered where the book is The 5 truths for transformational leaders : how nonprofit organizations thrive, grow, and make a profound difference. It features 7 columns including author, publication date, language, and book publisher.

Success.ai’s User Profiles Data for Nonprofit and NGO Leaders provides businesses, organizations, and researchers with comprehensive access to global leaders in the nonprofit and NGO sectors. With data sourced from over 700 million verified LinkedIn profiles, this dataset includes actionable insights and contact details for executives, program managers, administrators, and decision-makers. Whether your goal is to partner with nonprofits, support global causes, or conduct research into social impact, Success.ai ensures your outreach is backed by accurate, enriched, and continuously updated data.

Why Choose Success.ai’s User Profiles Data for Nonprofit and NGO Leaders? Comprehensive Professional Profiles

Access verified LinkedIn profiles of nonprofit leaders, NGO managers, program directors, grant writers, and administrative executives. AI-driven validation ensures 99% accuracy for efficient communication and minimized bounce rates. Global Coverage Across Nonprofit Sectors

Includes profiles from nonprofits, humanitarian organizations, environmental groups, social enterprises, and advocacy organizations. Covers key markets across North America, Europe, APAC, South America, and Africa for global reach. Continuously Updated Dataset

Reflects real-time professional updates, organizational changes, and emerging trends in the nonprofit landscape to keep your targeting relevant and effective. Tailored for Nonprofit Insights

Enriched profiles include work histories, organizational affiliations, areas of expertise, and social impact projects for deeper engagement opportunities. Data Highlights: 700M+ Verified LinkedIn Profiles: Access a vast network of nonprofit and NGO professionals worldwide. 100M+ Work Emails: Direct communication with executives, managers, and decision-makers in the nonprofit sector. Enriched Organizational Data: Gain insights into leadership structures, mission focuses, and operational scales. Industry-Specific Segmentation: Target nonprofits focused on healthcare, education, environmental sustainability, human rights, and more. Key Features of the Dataset: Nonprofit and NGO Leader Profiles

Identify and connect with executives, program managers, fundraisers, and policy directors in global nonprofit and NGO sectors. Engage with individuals who drive decision-making and operational strategies for impactful organizations. Detailed Organizational Insights

Leverage firmographic data, including organizational size, mission, regional activity, and funding sources, to align with specific nonprofit goals. Advanced Filters for Precision Targeting

Refine searches by region, mission type, role, or organizational focus for tailored outreach. Customize campaigns based on social impact priorities, such as climate action, gender equality, or economic development. AI-Driven Enrichment

Enhanced datasets provide actionable insights into professional accomplishments, partnerships, and leadership achievements for targeted engagement. Strategic Use Cases: Partnership Development and Outreach

Identify nonprofits and NGOs for collaboration on social impact projects, sponsorships, or grant distribution. Build relationships with decision-makers driving advocacy, fundraising, and community initiatives. Donor Engagement and Fundraising

Target nonprofit leaders responsible for managing fundraising campaigns and donor relationships. Tailor outreach efforts to align with specific causes and funding priorities. Research and Analysis

Analyze leadership trends, mission focuses, and regional nonprofit activities to inform program design and funding strategies. Use insights to evaluate the effectiveness of social impact initiatives and partnerships. Recruitment and Talent Acquisition

Target HR professionals and administrators seeking qualified staff, consultants, or volunteers for nonprofits and NGOs. Offer talent solutions for specialized roles in program management, advocacy, and administration. Why Choose Success.ai? Best Price Guarantee

Access industry-leading, verified User Profiles Data at unmatched pricing to ensure your campaigns are cost-effective and impactful. Seamless Integration

Easily integrate verified nonprofit data into your CRM or marketing platforms with APIs or downloadable formats. AI-Validated Accuracy

Rely on 99% accuracy to minimize wasted outreach efforts and maximize engagement outcomes. Customizable Solutions

Tailor datasets to focus on specific nonprofit types, geographical regions, or areas of social impact to meet your strategic objectives. Strategic APIs for Enhanced Campaigns: Data Enrichment API

Update your internal records with verified nonprofit leader profiles to enhance targeting and engagement. Lead Generation API

Automate lead generation for a consistent pipeline of nonprofit and NGO professionals, scaling your outreach efforts efficiently. Success.ai’s User Profiles Data for Nonprofit and NGO Leader...

Percentage of total non-profit organizations, by region, size, International Classification of Non-Profit Organizations (ICNPO) and organization type, Canada, 2023.

Analysis of ‘King County Employee Giving Program’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/88d914de-0eb8-45c6-bc44-941e23c4416c on 26 January 2022.

--- Dataset description provided by original source is as follows ---

The Employee Giving Program (EGP) is the workplace giving program for employees of King County government. It was established in 1988 to create an easy and cost-effective way for employees to support their favorite nonprofit organizations, reduce the disruption to the workplace that multiple campaigns caused, and introduce an avenue for different nonprofits to participate. Essentially, EGP exists to make it easy for you to do good.

In 1988, there were fewer than 10 nonprofit organizations participating. Today there are more than 1,000 with more added every year. Over this time, more than $25 million have been donated by King County employees, making this the third largest public sector workplace giving program in the state.

More information: https://www.kingcounty.gov/audience/employees/giving/about-the-egp.aspx

--- Original source retains full ownership of the source dataset ---

Average percentage of expenditures by non-profit organizations, by region, size, International Classification of Non-Profit Organizations (ICNPO) and organization type, Canada, 2023.

Percentage change in the level of demand and in the overall capacity for non-profit organizations to meet demand for its services and products, by region, size, International Classification of Non-Profit Organizations (ICNPO) and organization type, Canada, 2023.