The 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.
(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)
yes 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...
Yup. 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.
Yep 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.
> 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.
This is neat! I thought about extracting the grants (still might), but full-text seemed like good bang for the buck. Your tools sound like they might be very useful for reporters. Have you given any thought to that? We love mapping these sorts of connections.
Hey, first up really amazing work you’re doing, hugely inspiring for us! Thank you.
Whilst our focus has been delivering a consumer layer on top of all this data, yea, very open to exposing our underlying graph to others. Want to drop me a note at dan at alma.app?
As you mention elsewhere, half the battle is cleaning the data and getting quality.
Is 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!
Cool. 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)?
There 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.
Just thought this was curious, if I search for "HOCKANUM VALLEY COMMUNITY COUNCIL" nothing comes up for them specifically but if I search for the town they are in then the business appears in that list.
There are 2018 filings in there, but many charities have fiscal years that end in Dec. IIRC, they generally file within 6 months. Given things like human error, bureaucracy and filing extensions... more should start rolling in over time.
I 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.
Its 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."
Ah, 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.
Many 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?
This 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.
53 comments
[ 2.8 ms ] story [ 117 ms ] threadI'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.
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.
https://pp-990-rendered.s3.amazonaws.com/201823199349304962_...
it breaks down the income into broad buckets
ETA:
look here on page 9:
https://pp-990-rendered.s3.amazonaws.com/201823199349304962_...
it breaks down the income into broad buckets
Though I bet a lot of that 63M is conference sponsorships.
Source: https://projects.propublica.org/nonprofits/organizations/460...
see 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)
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...
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.
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
EDIT: here is the same thru propublica explorer:
https://projects.propublica.org/nonprofits/organizations/437...
which links here, which is the document I posted:
https://s3.amazonaws.com/irs-form-990/201643199349201044_pub...
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
Sounds like a lot of interesting data will be in that last third, in which case.
E.g. here’s Stanford: 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?
Yea, a version of pagerank is coming soon! Love any other ideas...
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.
Whilst our focus has been delivering a consumer layer on top of all this data, yea, very open to exposing our underlying graph to others. Want to drop me a note at dan at alma.app?
As you mention elsewhere, half the battle is cleaning the data and getting quality.
Edit: wrote a little bit about that here - https://news.ycombinator.com/item?id=20141744
There are 2018 filings in there, but many charities have fiscal years that end in Dec. IIRC, they generally file within 6 months. Given things like human error, bureaucracy and filing extensions... more should start rolling in over time.
[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.
"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."
Reference: https://news.ycombinator.com/item?id=20032686
Thanks for flagging my comment, jerks. What the fuck.
https://news.ycombinator.com/newsguidelines.html