Community Platform DC/DC Tutoring & Mentoring Initiative Our Logo

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
Public Charity2017469
Public Charity2004425
Private Foundation200633
Public Charity20101681
Public Charity199942
Private Foundation2010351
Public Charity2003119
Public CharityActive13839
Private FoundationActive1134
Public Charity2008332
Public Charity2015573
Public Charity2012903
Private Foundation201527
Public Charity2006128
Public Charity2009258
Public Charity2018421
Public Charity20111017
Public Charity20131288
Public Charity2014717
Public Charity2019477
Public Charity2016519
Public Charity200556
Private Foundation2011115
Public Charity2007387
Private Foundation200425
Private Foundation201250
Private Foundation201645
Private Foundation200745
Private Foundation200830
Private Foundation201440
Private Foundation201840
Private Foundation201744
Private Foundation201367
Public Charity200285
Public Charity199893
Public Charity199675
Private Foundation201939
Private Foundation200921
Private Foundation199614
Public Charity199778
Private Foundation199813
Private Foundation20025
Private Foundation200317
Private Foundation20058
Private Foundation19976
Private Foundation19993
Elapsed time: 08:17:08 - fin: 08:17:08

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 state in ('DC','MD','VA') and subseccd = '03' group by level1, End_Year having end_year > '1995' and end_year <> 'Unknown';