Number of Registered Nonprofit Organizations Other Than Public Charities and Private Foundations
Filing Forms 990 in the Past 2 Years by State, 2012
SELECT 'United States' AS State, SUM(x.`Total__Number_of__Registered__Other__Nonprofit__Organizations1`) AS `Total__Number_of__Registered__Other__Nonprofit__Organizations1`, SUM(x.`Number_of__Other__Nonprofit__Active__Filers2`) AS `Number_of__Other__Nonprofit__Active__Filers2`, SUM(x.`Number_of__Filers__Reporting__No_Financial__Information3`) AS `Active__Filers__Reporting__No_Financial__Information3`, SUM(x.`Number_of__Filers__Reporting__Financial__Information3`) AS `Active__Filers__Reporting__Financial__Information3`, SUM(x.`Total__Revenue__Reported_by__Active__Filers`) AS `Total__Revenue__Reported_by__Active__Filers`, SUM(x.`Total__Assets__Reported_by__Active__Filers`) AS `Total__Assets__Reported_by__Active__Filers`, ROUND(SUM(x.`Total__Revenue__Reported_by__Active__Filers`)/SUM(x.`Number_of__Filers__Reporting__Financial__Information3`),0) AS `Average__Revenue__Reported_by__Active__Filers`, ROUND(SUM(x.`Total__Assets__Reported_by__Active__Filers`)/SUM(x.`Number_of__Filers__Reporting__Financial__Information3`),0) AS `Average__Assets__Reported_by__Active__Filers`, ROUND(SUM(y.POP2012est),0) as Estimated__2012__Population, ROUND(10000*SUM(x.`Number_of__Other__Nonprofit__Active__Filers2`)/SUM(y.POP2012est),1) as `Other__Nonprofit__Active__Filers__per_10,000__Persons`, ROUND(SUM(`Total__Revenue__Reported_by__Active__Filers`)/SUM(y.POP2012est),1) as `Total__Revenue__Reported__per_Person`, ROUND(SUM(`Total__Assets__Reported_by__Active__Filers`)/SUM(y.POP2012est),1) as `Total__Assets__Reported__per_Person` FROM (SELECT z.State, count(*) as `Total__Number_of__Registered__Other__Nonprofit__Organizations1`, count(IF(IFNULL(z.cFiler,'N')='Y',1,NULL)) as `Number_of__Other__Nonprofit__Active__Filers2`, count(IF(IFNULL(z.cZFiler,'N')='Y',1,NULL)) as `Number_of__Filers__Reporting__No_Financial__Information3`, count(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',1,NULL)) as `Number_of__Filers__Reporting__Financial__Information3`, SUM(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',cTotRev,0)) as `Total__Revenue__Reported_by__Active__Filers`, SUM(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',cAssets,0)) as `Total__Assets__Reported_by__Active__Filers` FROM bmf.bm1406 z WHERE IFNULL(z.SUBSECCD,'00')<>'03' GROUP BY z.State) x LEFT JOIN lookup.statepop2 y on x.State=y.State WHERE y.State IS NOT NULL GROUP BY State UNION SELECT x.State, SUM(x.`Total__Number_of__Registered__Other__Nonprofit__Organizations1`) AS `Total__Number_of__Registered__Other__Nonprofit__Organizations1`, SUM(x.`Number_of__Other__Nonprofit__Active__Filers2`) AS `Number_of__Other__Nonprofit__Active__Filers2`, SUM(x.`Number_of__Filers__Reporting__No_Financial__Information3`) AS `Active__Filers__Reporting__No_Financial__Information3`, SUM(x.`Number_of__Filers__Reporting__Financial__Information3`) AS `Active__Filers__Reporting__Financial__Information3`, SUM(x.`Total__Revenue__Reported_by__Active__Filers`) AS `Total__Revenue__Reported_by__Active__Filers`, SUM(x.`Total__Assets__Reported_by__Active__Filers`) AS `Total__Assets__Reported_by__Active__Filers`, ROUND(SUM(x.`Total__Revenue__Reported_by__Active__Filers`)/SUM(x.`Number_of__Filers__Reporting__Financial__Information3`),0) AS `Average__Revenue__Reported_by__Active__Filers`, ROUND(SUM(x.`Total__Assets__Reported_by__Active__Filers`)/SUM(x.`Number_of__Filers__Reporting__Financial__Information3`),0) AS `Average__Assets__Reported_by__Active__Filers`, ROUND(SUM(y.POP2012est),0) as Estimated__2012__Population, ROUND(10000*SUM(x.`Number_of__Other__Nonprofit__Active__Filers2`)/SUM(y.POP2012est),1) as `Other__Nonprofit__Active__Filers__per_10,000__Persons`, ROUND(SUM(`Total__Revenue__Reported_by__Active__Filers`)/SUM(y.POP2012est),1) as `Total__Revenue__Reported__per_Person`, ROUND(SUM(`Total__Assets__Reported_by__Active__Filers`)/SUM(y.POP2012est),1) as `Total__Assets__Reported__per_Person` FROM (SELECT z.State, count(*) as `Total__Number_of__Registered__Other__Nonprofit__Organizations1`, count(IF(IFNULL(z.cFiler,'N')='Y',1,NULL)) as `Number_of__Other__Nonprofit__Active__Filers2`, count(IF(IFNULL(z.cZFiler,'N')='Y',1,NULL)) as `Number_of__Filers__Reporting__No_Financial__Information3`, count(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',1,NULL)) as `Number_of__Filers__Reporting__Financial__Information3`, SUM(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',cTotRev,0)) as `Total__Revenue__Reported_by__Active__Filers`, SUM(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',cAssets,0)) as `Total__Assets__Reported_by__Active__Filers` FROM bmf.bm1406 z WHERE IFNULL(z.SUBSECCD,'00')<>'03' GROUP BY z.State) x LEFT JOIN lookup.statepop2 y on x.State=y.State WHERE y.State IS NOT NULL GROUP BY x.State
Notes:
1 Excludes 501(c)(3) public charities and private foundations.
2 'Active Filers' are defined as nonprofits that filed Form 990, 990EZ or 990N within the past two years ending December 2012.
3 Active 'Zero Filers' did not report income or assets on their latest return (almost all are small nonprofits filing 990N).