11 ms·
Search the Full Text of Nonprofit Tax Records for Free
- rtempaccount1 7y agoThe linux foundation results on here are quite interesting. they're showing pretty rapid "revenue" growth from $39M in 2015 to $61M in 2016 to $81M in 2017. I'm guessing this is, in no small part, down to increasing conference/event revenues. It'll be interesting to see what they do with all the additional cash.
- ec109685 7y agoI don’t think so. Corporate sponsorships are a much better source of revenue.
- rtempaccount1 7y agoWell sponsorships are part of conf. revenue in a lot of cases. I've looked at the sponsor packs for the CNCF conferences, and those higher tiers do not come cheap. Also don't underestimate smaller individual payments * very large number. E.g. Kubecon Barcelona, tickets were $900+ each and there were 7700 people, so we're talking almost $7m from ticket sales alone. Now the venue ain't cheap but that + all the sponsor cash == a fair profit, I'd expect.
- RyJones 7y agolook here on page 9: https://pp-990-rendered.s3.amazonaws.com/201823199349304962_IRS990_0.html?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIA266MJEJY4BPWHTVU%2F20190610%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190610T010454Z&X-Amz-Expires=1800&X-Amz-SignedHeaders=host&X-Amz-Security-Token=FQoGZXIvYXdzEGgaDFu7GJiems7CDWtIqiKWBIyEJe3KSCuYwUSfrCz1pGk1sf3x9K430voq74APfo4tSoZ7M9X2WosDkPnGTKjakqlOSrRo5oFaj51dg%2BiN1T9I3O4%2Fck8ZxhIoTCMbWJlsSAnksvtTAiEsA1JdJr4N9EL3p4ORQfjHpbRg4caMIrtK5q1vflqGwjX1lNlLxOjnlpxFSuhfDF%2FenCNMU%2F54n33EVQh4tT4aWC6ALs4xu%2FvLnH5zHiEERaOzflZwu5zGpMMyreYMi%2B%2FzLbFOUccTxgdOZzIkdbFId%2BRC%2BcclbLfkeav2EwyJV09safmRGbypowM8muKEHiRXzMXwQ4D1Cy%2B%2BuPLfhnnILK%2Fd9lQ9KiNy%2Fv3fYkdiy%2BJNer2voBabYPlakbD%2FjJeFG4KEodkuG9iPufxc%2Fv7qcwGLIR5hxHDPs4AObWYK6dBIi%2FxG1K1TD4PDjqq4xMay3u9Z5Jh5hoYNF5%2F678IqZ0st2Y80wpaXZAqfeuzDZuLLBVs5j2rqZRhxqFkpIGG0RWzYRbKHJHOMI%2BEJdLwmkSHYfJ%2FNQx%2FDMJkLR4x1W8Qo9VRU2P%2BJlJqTmvGFgRZsxhzUjPVLMxbSke5J79FrLBwyeCXLr3WRpgGBOSzdXpCAJWoUbYn3m45GRTQH8wIc5gM7Z%2FMmDzNaRj3E0TbkvF%2FPeg6XQBiSgGtZythlTGWJqERhp2beLlHSKRlP6mTYFIhL5Ed%2For8h%2FIxK1ijqi%2FbnBQ%3D%3D&X-Amz-Signature=867dd41becf325410ef0145b577839184ee509a57f180106fe123ddd687a5396 https://pp-990-rendered.s3.amazonaws.com/201823199349304962_... it breaks down the income into broad buckets
- RyJones 7y agoOur member lists are public and the price of membership at every level is public. ETA: look here on page 9: https://pp-990-rendered.s3.amazonaws.com/201823199349304962_IRS990_0.html?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIA266MJEJY4BPWHTVU%2F20190610%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190610T010454Z&X-Amz-Expires=1800&X-Amz-SignedHeaders=host&X-Amz-Security-Token=FQoGZXIvYXdzEGgaDFu7GJiems7CDWtIqiKWBIyEJe3KSCuYwUSfrCz1pGk1sf3x9K430voq74APfo4tSoZ7M9X2WosDkPnGTKjakqlOSrRo5oFaj51dg%2BiN1T9I3O4%2Fck8ZxhIoTCMbWJlsSAnksvtTAiEsA1JdJr4N9EL3p4ORQfjHpbRg4caMIrtK5q1vflqGwjX1lNlLxOjnlpxFSuhfDF%2FenCNMU%2F54n33EVQh4tT4aWC6ALs4xu%2FvLnH5zHiEERaOzflZwu5zGpMMyreYMi%2B%2FzLbFOUccTxgdOZzIkdbFId%2BRC%2BcclbLfkeav2EwyJV09safmRGbypowM8muKEHiRXzMXwQ4D1Cy%2B%2BuPLfhnnILK%2Fd9lQ9KiNy%2Fv3fYkdiy%2BJNer2voBabYPlakbD%2FjJeFG4KEodkuG9iPufxc%2Fv7qcwGLIR5hxHDPs4AObWYK6dBIi%2FxG1K1TD4PDjqq4xMay3u9Z5Jh5hoYNF5%2F678IqZ0st2Y80wpaXZAqfeuzDZuLLBVs5j2rqZRhxqFkpIGG0RWzYRbKHJHOMI%2BEJdLwmkSHYfJ%2FNQx%2FDMJkLR4x1W8Qo9VRU2P%2BJlJqTmvGFgRZsxhzUjPVLMxbSke5J79FrLBwyeCXLr3WRpgGBOSzdXpCAJWoUbYn3m45GRTQH8wIc5gM7Z%2FMmDzNaRj3E0TbkvF%2FPeg6XQBiSgGtZythlTGWJqERhp2beLlHSKRlP6mTYFIhL5Ed%2For8h%2FIxK1ijqi%2FbnBQ%3D%3D&X-Amz-Signature=867dd41becf325410ef0145b577839184ee509a57f180106fe123ddd687a5396 https://pp-990-rendered.s3.amazonaws.com/201823199349304962_... it breaks down the income into broad buckets
- ec109685 7y agoYep, wrong about that. 63M revenue for conferences, 12M for sponsorships and 5M for training. Though I bet a lot of that 63M is conference sponsorships. Source: https://projects.propublica.org/nonprofits/organizations/460503801/201823199349304962/IRS990 https://projects.propublica.org/nonprofits/organizations/460...
- shaki-dora 7y ago$37 million for salaries, $32 million "other expenses", and $12 million that weren't spent. see https://projects.propublica.org/nonprofits/organizations/460503801/201823199349304962/IRS990 https://projects.propublica.org/nonprofits/organizations/460... (I planned to make a smart-ass comment about this story literally being about an interface to answer such questions. But "other expenses" is just slightly to meaningless to declare victory here)
- rtempaccount1 7y agoyes unfortunately all that these forms tell us is, more money is coming in and more money is being spent, not really what it's being spent on (and I'd imagine the 2018 numbers will show another big jump in revenue if the growth of CNCF projects has anything to do with it) From having had a look round the Linux Foundation site, I couldn't easily see a lot of information about what they spend their increasing revenues on, although I may well have missed it...
- shaki-dora 7y agoI also looked there first and was surprised that they apparently do not publish their financial reports themselves. It's not a major issue, since the data is disclosed on the government side, but it's just bad service and leaves an impression of in-transparency.
- dankohn1 7y agoCNCF's 2018 annual report has some useful info: https://www.cncf.io/cncf-annual-report-2018/ https://www.cncf.io/cncf-annual-report-2018/
- gravypod 7y agoHow was this created? It would be cool to see how I could download copies of this for personal analysis.
- PowerfulWizard 7y agohttps://registry.opendata.aws/irs990/ https://registry.opendata.aws/irs990/ A dataset of IRS 990 filings are available there. It is a big collection of XML files. Here is an example of one chosen at random: https://pastebin.com/pzNYBZYQ https://pastebin.com/pzNYBZYQ EDIT: here is the same thru propublica explorer: https://projects.propublica.org/nonprofits/organizations/43740037 https://projects.propublica.org/nonprofits/organizations/437... which links here, which is the document I posted: https://s3.amazonaws.com/irs-form-990/201643199349201044_public.xml https://s3.amazonaws.com/irs-form-990/201643199349201044_pub...
- schwanksta 7y agoYup. We’ve been using this data for a while to render e-filed 990s on our site and to extract highly paid employees. Now we just strip the markup out and toss it all into elasticsearch for search. It’s really interesting to surface things like grants. I will say for personal analysis that the schema has a habit of changing, and things like grants can appear in multiple places depending on the context. What’s more, just 2/3rds of nonprofits e-file now (and I’m sure fewer and fewer the further back you go) Just some things to look out for. If you’re interested in processing the 990 XML data though, check out the truly excellent irsx: https://github.com/jsfenfen/990-xml-reader https://github.com/jsfenfen/990-xml-reader
- pbhjpbhj 7y agoIf you don't e-file does that mean the IRS don't digitise your accounts and so you avoid appearing in these sorts of data sets? Sounds like a lot of interesting data will be in that last third, in which case.
- danhilltech 7y agoWe’re building a graph of this same underlying data at https://alma.app https://alma.app (with a lot of enrichments) to help people discover and donate to nonprofits. E.g. here’s Stanford: https://alma.app/charities/941156365-the-board-of-trustees-of-the-leland-stanford-junior-university https://alma.app/charities/941156365-the-board-of-trustees-o... Would love to know what types of analysis people would like to see about organizations and their relationships?
- johnymontana 7y agoCould you clarify what you mean by “building a graph”? Are you combining the 990 data plus other enrichments in a graph database?
- danhilltech 7y agoYep basically - looking at the network of grants (who funds who), people (who works where over their careers), social media and news (who’s referenced or cited alongside whom) and so on. You start to see interesting clusters of nonprofits that are funded by the same groups and work together extensively.
- johnymontana 7y agoNeat. What technologies are you using to store and analyze the data? Are you using any graph algorithms, like PageRank, community detection, etc?
- danhilltech 7y agoDGraph and elasticsearch with some redis caching. Yea, a version of pagerank is coming soon! Love any other ideas...
- walterbell 7y ago> Would love to know what types of analysis people would like to see about organizations and their relationships? Related public records, e.g. court filings, municipal or other co-investments alongside the nonprofits, adjacent (time or geo) legislation/policy changes, rotating doors of nonprofit, gov, commercial.
- schwanksta 7y agoOh hey I built this. Let me know if you have any questions about how it works. Edit: wrote a little bit about that here - https://news.ycombinator.com/item?id=20141744 https://news.ycombinator.com/item?id=20141744
- deleted 7y ago[deleted]
- myroon5 7y agoIs it possible to sort after searching? Or filter by annual revenue? I'd like to see the organizations with the highest annual revenue for my specific searches. Thanks!
- schwanksta 7y agoThose are good suggestions! I'm planing to add sorting by year, but revenue makes sense as well.
- AutoAPI 7y agoAny update on this?
- rtempaccount1 7y agoCool. I had one question, what's the usual lead time for non-profit data to show up in this dataset (e.g. when would you expect that 2018 forms/data would appear)?
- schwanksta 7y agoThere are already some 2018 forms in there, but it's based on fiscal year. So a nonprofit whose FY is Dec 2018 would have had to just file last month -- and sometimes they file late or get extensions. And again, this only covers e-filed forms -- they could file on paper, in which case you'd have to use the nonprofit name search and check for a filing.
- 7y ago
- spenczar5 7y agoDeletable nit: could this be retitled to spell out “3 million?” I expected something about 3M, the industrial conglomerate.
- phnofive 7y agoIndeed. I would have been pretty interested in what LOB was non-profit under the umbrella of Minnesota Mining and Manufacturing.
- heimatau 7y agoI actually thought the same thing. Or maybe a $ sign prior to 3M. $3M could be easier to distinguish quickly. [edit] It seems that this is a link to 3 million records. Not a 3 million dollars worth. It seems I was even confused with another way that the headline could be perceived.
- Scipio_Afri 7y agoIts not $3 million, its 3 million tax records from non-profits, digitally filed by those non profits, from 2011 until now. "The new feature contains every electronically filed Form 990, 990-PF and 990-EZ released by the IRS from 2011 to date. That’s nearly 3 million filings. The search does not include forms filed on paper."
- heimatau 7y agoAh, then it should be something like 'Search the Full Text of 3 million records from a Non-profit tax filings' or just add the word millions. Thanks for the correction.
- todd3834 7y agoI thought this was about 3M as well
- kombucha11 7y agoI immediately thought the article was about some kind of Panama Papers but regarding 3M Corp :b
- ykevinator 7y agoThey also have an api
- cgidriver 7y agoMany of these forms are empty it seems. I tried two random ones, and I could not find any data in them. Also, could not find some non-profits. Does anyone know how much coverage does this database have?
- atomical 7y agoI guess Moms Across America didn't file a tax return electronically? Reference: https://news.ycombinator.com/item?id=20032686 https://news.ycombinator.com/item?id=20032686 Thanks for flagging my comment, jerks. What the fuck.
- atomical 7y agohttps://news.ycombinator.com/item?id=20033231 https://news.ycombinator.com/item?id=20033231
- netwanderer3 7y agoThis is amazing work that enables transparency, if every transaction was indeed reported to the IRS. Typically we would have to manually search each organization's website to obtain this information so kudos to them for publishing everything all in one place and even with full text search feature and api.