Community Platform

Number of Registered Nonprofit Organizations 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:27:07 - fin: 01:27:07

SELECT 'United States' AS State, SUM(x.`Total__Number_of__Registered__Nonprofit__Organizations`) AS `Total__Number_of__Registered__Nonprofit__Organizations`, SUM(x.`Number_of__Registered__Nonprofit__Active__Filers1`) AS `Number_of__Registered__Nonprofit__Active__Filers1`, SUM(x.`Number_of__Filers__Reporting__No_Financial__Information2`) AS `Active__Filers__Reporting__No_Financial__Information2`, SUM(x.`Number_of__Filers__Reporting__Financial__Information2`) AS `Active__Filers__Reporting__Financial__Information2`, 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__Information2`),0) AS `Average__Revenue__Reported_by__Active__Filers`, ROUND(SUM(x.`Total__Assets__Reported_by__Active__Filers`)/SUM(x.`Number_of__Filers__Reporting__Financial__Information2`),0) AS `Average__Assets__Reported_by__Active__Filers`, SUM(y.POP2012est) as Estimated__2012__Population, ROUND(10000*SUM(x.`Number_of__Registered__Nonprofit__Active__Filers1`)/SUM(y.POP2012est),1) as `Total__Active__Nonprofits__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__Nonprofit__Organizations`, count(IF(IFNULL(z.cFiler,'N')='Y',1,NULL)) as `Number_of__Registered__Nonprofit__Active__Filers1`, count(IF(IFNULL(z.cZFiler,'N')='Y',1,NULL)) as `Number_of__Filers__Reporting__No_Financial__Information2`, count(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',1,NULL)) as `Number_of__Filers__Reporting__Financial__Information2`, 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`, count(IF(IFNULL(z.SUBSECCD,'00')<>'03',1,NULL)) as Number_of__Other__Nonprofit__Organizations 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__Nonprofit__Organizations`) AS `Total__Number_of__Registered__Nonprofit__Organizations`, SUM(x.`Number_of__Registered__Nonprofit__Active__Filers1`) AS `Number_of__Registered__Nonprofit__Active__Filers1`, SUM(x.`Number_of__Filers__Reporting__No_Financial__Information2`) AS `Active__Filers__Reporting__No_Financial__Information2`, SUM(x.`Number_of__Filers__Reporting__Financial__Information2`) AS `Active__Filers__Reporting__Financial__Information2`, 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__Information2`),0) AS `Average__Revenue__Reported_by__Active__Filers`, ROUND(SUM(x.`Total__Assets__Reported_by__Active__Filers`)/SUM(x.`Number_of__Filers__Reporting__Financial__Information2`),0) AS `Average__Assets__Reported_by__Active__Filers`, SUM(y.POP2012est) as Estimated__2012__Population, ROUND(10000*SUM(x.`Number_of__Registered__Nonprofit__Active__Filers1`)/SUM(y.POP2012est),1) as `Total__Active__Nonprofits__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__Nonprofit__Organizations`, count(IF(IFNULL(z.cFiler,'N')='Y',1,NULL)) as `Number_of__Registered__Nonprofit__Active__Filers1`, count(IF(IFNULL(z.cZFiler,'N')='Y',1,NULL)) as `Number_of__Filers__Reporting__No_Financial__Information2`, count(IF(IFNULL(z.cFiler,'N')='Y' AND IFNULL(z.cZFiler,'N')='N',1,NULL)) as `Number_of__Filers__Reporting__Financial__Information2`, 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`, count(IF(IFNULL(z.SUBSECCD,'00')<>'03',1,NULL)) as Number_of__Other__Nonprofit__Organizations 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 'Active Filers' are defined as nonprofits that filed Form 990, 990EZ, 990N or 990PF within the two years ending December 2012.
2 Active 'Zero Filers' did not report income or assets on their latest return (almost all are small public charities and other nonprofits filing 990N).