Current Number and Revenue of Registered, Filing Organizations, by Subsector
This report returns the most recent available number of all registered organizations, as well as the number and revenue of all active organizations. Organizations are defined as active if they have filed within two years previous of the date of the most recent data available (given in the first column below in YYMM format: e.g., November 2014 = 1411).| Date of Data (YY/MM) | NteeCode | Number of Registered Public Charities | Number of Active Filers | Total Revenue of Active Filers |
|---|---|---|---|---|
| 2112 | 6-Religion-Related | 89 | 12 | 5099441 |
| 2112 | 2-Education | 30 | 14 | 6321003 |
| 2112 | 5-Human Services | 72 | 27 | 18141907 |
| 2112 | 1-Arts | 30 | 7 | 1203860 |
| 2112 | 7-Other | 56 | 15 | 16003941 |
| 2112 | 4-Health Care | 19 | 7 | 163805770 |
| 2112 | 3-Environment and Animals | 16 | 4 | 1939462 |
select SUBSTRING(LastBMF,3,4) AS 'Date of Data (YY/MM)', case when a.NteeFinal like 'A%' THEN '1-Arts' WHEN a.NteeFinal LIKE 'B%' THEN '2-Education' WHEN SUBSTRING(a.NteeFinal,1,1) IN ('C','D') THEN '3-Environment and Animals' WHEN SUBSTRING(a.NteeFinal,1,1) BETWEEN 'E' AND 'H' THEN '4-Health Care' WHEN SUBSTRING(a.NteeFinal,1,1) BETWEEN 'I' AND 'P' THEN '5-Human Services' WHEN a.NteeFinal LIKE 'X%' THEN '6-Religion-Related' ELSE '7-Other' END as NteeCode, count(*) as 'Number of Registered Public Charities', SUM(IF(IFNULL(cTaxPer,'') BETWEEN ((SELECT CONCAT('20',SUBSTRING(LastBMF,3,4)) FROM nccs.nteedocAllEins WHERE LatestBMF LIMIT 1) - 200) AND (SELECT CONCAT('20',SUBSTRING(LastBMF,3,4)) FROM nccs.nteedocAllEins WHERE LatestBMF LIMIT 1) AND IRS990N = '0',1,0)) AS `Number of Active Filers`, SUM(IF(IFNULL(cTaxPer,'') BETWEEN ((SELECT CONCAT('20',SUBSTRING(LastBMF,3,4)) FROM nccs.nteedocAllEins WHERE LatestBMF LIMIT 1) - 200) AND (SELECT CONCAT('20',SUBSTRING(LastBMF,3,4)) FROM nccs.nteedocAllEins WHERE LatestBMF LIMIT 1) AND IRS990N = '0',IFNULL(ctotrev,0),0)) AS 'Total Revenue of Active Filers' from nccs.nteedocAllEins a INNER JOIN lookup.ntee2011a b ON substr(a.nteeFinal,1,3) = b.code where fips='12009' and latestBMF = 1 and subseccd = '03' and fndncd not in ('02','03','04') AND (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') GROUP BY NteeCode
Notes:
Please note that "Religion-Related" organizations include all organizations filing with the IRS, but do NOT include all religious organizations. Religious congregations and organizations with less than $5,000 in annual revenue are not required to register with the IRS, although many do. The standard source for estimates of religious congregations is the American Church Lists, a company thatprovides marketing data using phone listings and other sources. As of this note, the most recent American Church Lists estimates suggest there are about 345,000 houses of worship in the United States. Of these, approximately 220,000 are registered with the IRS, according to NCCS analysis of the June 2014 IRS Business Master File. See “Church Specialty List,” InfoUSA, accessed December 10, 2014, http://www.infousa.com/church-list