Grab U.S. nonprofit tax information from the ProPublica Nonprofit Explorer API and put it in a Google spreadsheet!
Nonprofit corporations in the United States have to submit one of a few types of tax forms to the IRS each year, which are then made public. If their total revenue is over $200,000 in a year, they submit a form 990, if it is between $50,000 and $199,999, they submit a form 990-ez, and if it is under $50,000, they submit a 990-N (e-postcard). The information obtained from these forms from 2011-2014 is what has been made available through the ProPublica Nonprofit Explorer API. From this, we can learn:
- Total number of individuals employed
- Total number of employees
- Amount of contributions and grants
- Year of formation
- City and State
- and more!
If you have a list of nonprofit organizations, this will loop through that list, use the API's Search Method to find an org's EIN number, and then use the EIN number and the Organization Method to find out whatever else you want to find out (e.g. total revenues, location, number of volunteers, etc). It then gently places all of that info into your Google Spreadsheet.
Nowhere yet. plz help
Thanks for your interest in contributing! To get started, take a look at CONTRIBUTING.md, and join the chatroom on Gitter.
This project adheres to a code of conduct. By participating, you are expected to uphold this code. Please report unacceptable behavior to maya@opentechinstitute.org.
- Useful code snippets for working with the ProPublica APIs
- Coding with Google Apps Script
- How to work with the Google Sheets API
- ckan-tutorial by Nat
- another piece of that tutorial
- Python client for ProPublica Nonprofit Explorer API
Join us at the Mozilla Global Sprint June 1-2, 2017! We'll be gathering in-person at sites around the world and online to collaborate on this project and learn from each other. Get your #mozsprint tickets now!
