Community Platform

Public charity and private foundation deaths

This shows the last year that an organization appeared in the IRS Business Master File.
level1End YearNumber of orgs
Private Foundation20132
Public CharityActive312
Public Charity201232
Public Charity200711
Private Foundation20112
Public Charity201120
Public Charity201037
Public Charity201818
Private Foundation20071
Public Charity201418
Public Charity201338
Public Charity20088
Public Charity20054
Private Foundation20105
Public Charity201614
Public Charity20044
Public Charity201720
Private FoundationActive21
Public Charity19964
Private Foundation20062
Private Foundation20082
Private Foundation20171
Public Charity201513
Public Charity201912
Public Charity20094
Private Foundation20124
Private Foundation20182
Public Charity19973
Public Charity19983
Public Charity20021
Public Charity20063
Public Charity20033
Private Foundation20151
Elapsed time: 09:06:15 - fin: 09:06:15

select case when fndncd in ('02','03','04') then 'Private Foundation' when subseccd ='03' then 'Public Charity' else 'Other' end as level1, case when latestBMF = 1 then 'Active' when substr(lastbmf,1,3) = 'bmf' then concat('19',substr(lastbmf,4,2)) when substr(lastbmf,3,1) in ('0','1') then concat('20',substr(lastbmf,3,2)) when substr(lastbmf,3,1) in ('8','9') then concat('19',substr(lastbmf,3,2)) else 'Unknown' end as End_Year, count(*) as Number_of_orgs from nccs.nteedocAllEins where fips='12009' and subseccd = '03' group by level1, End_Year having end_year > '1995' and end_year <> 'Unknown';