/990-scraper

Grab nonprofit tax information from the ProPublica API and put it in a Google spreadsheet!

Primary LanguageHTMLOtherNOASSERTION

990-scraper

An add-on to grab whatever U.S. nonprofit tax information you want from the ProPublica Nonprofit Explorer API and put it in a Google spreadsheet!

What's a 990?

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 might be able to learn:

  • Total number of individuals employed
  • Total number of employees
  • Amount of contributions and grants
  • Year of formation
  • City and State
  • and more!

What does this do?

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.

Where is the project now?

Check the Gitter chatroomfor the most up-to-date project information!

Want to quickly test it out? We'll be creating a Google Add-on soon, but for now:

  1. Open a blank Google Spreadsheet
  2. Click on the menu item "Tools" > "Script editor..." This will open up another window for editing your own custom scripts.
  3. Copy Code.gs into the box you see before you.
  4. Go to File > New > Html file
  5. Copy in sidebar.html
  6. Press the play button and accept all the permissions
  7. Go back to your original spreadsheet, and refresh the page
  8. Enter an EIN number into a cell (lets say the EIN number is 142007220 and the cell is A1), go to another cell and enter =lookUpByEIN(A1)
  9. Press enter, and you have information on that nonprofit!

Contributing

Thanks for your interest in contributing! To get started, take a look at CONTRIBUTING.md, and join the chatroom on Gitter.

Participation Guidelines

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.

Tutorials

Might be useful?

MozSprint

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!

Global Sprint