Community Platform DC/DC Tutoring & Mentoring Initiative Our Logo

Number of Organizations by Legal Type and Revenue

CategoryNumber Registered Organizations
Public Charity Epostcard Filers OR Non-Filers8537
Non-501(C)(3)s4676
Public Charity 990/Ez Filers With $50,000+ Revenue4029
Private Foundations1134
Public Charity 990/Ez Filers -- Smaller1249
Elapsed time: 04:41:05 - fin: 04:41:06

SELECT CASE WHEN subseccd = '03' and fndncd not in ('02','03','04') and cTotRev >= 50000 then 'Public Charity 990/Ez Filers With $50,000+ Revenue' WHEN subseccd = '03' and fndncd not in ('02','03','04') and cTotRev > 0 then 'Public Charity 990/Ez Filers -- Smaller' WHEN subseccd = '03' and fndncd not in ('02','03','04') and ifnull(cTotRev,0) = 0 then 'Public Charity Epostcard Filers OR Non-Filers' WHEN subseccd = '03' and fndncd in ('02','03','04') then 'Private Foundations' else 'Non-501(C)(3)s' end as Category, count(*) as Number_Registered_Organizations from nccs.nteedocAllEins where latestBMF = 1 AND state in ('DC','MD','VA') GROUP BY Category;