Community Platform

Number of Registered Nonprofit Organizations Other Than Public Charities and Private Foundations
Filing Forms 990 in the Past 2 Years by State, 2012

Please note: Nonprofit measures per capita should be interpreted with caution since some nonprofits conduct activities outside of the area in which they register and file. For example: Washington D.C. has a high concentration of registered nonprofits with a national or global focus but that provide little if any direct program service in the District; in Missoula Montana, the Rocky Mountain Elk Foundation registered more than 600 affiliate organizations, such as its Jacksonville (FL) chapter, active in locations across the U.S.
Elapsed time: 01:59:57 - fin: 01:59:57

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).