Number of Registered Nonprofit Organizations 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.SELECT 'United States' AS State, SUM(x.Total__Number_of__Nonprofit__Organizations) AS Total__Number_of__Nonprofit__Organizations, SUM(x.`Number_of__501(c)(3)1__Nonprofit__Organizations`) AS `Number_of__501(c)(3)1__Nonprofit__Organizations`, SUM(x.Number_of__Other__Nonprofit__Organizations) AS Number_of__Other__Nonprofit__Organizations, round(SUM(y.POP2012est)/1,0) as Estimated__2012__Population, round(10000*SUM(x.Total__Number_of__Nonprofit__Organizations)/SUM(y.POP2012est),1) as `Total__Nonprofits__per_10,000__Persons`, round(10000*SUM(x.`Number_of__501(c)(3)1__Nonprofit__Organizations`)/SUM(y.POP2012est),1) as `501(c)(3)1__Nonprofits__per_10,000__Persons`, round(10000*SUM(x.Number_of__Other__Nonprofit__Organizations)/SUM(y.POP2012est),1) as `Other__Nonprofits__per_10,000__Persons` FROM (SELECT z.State, count(*) as Total__Number_of__Nonprofit__Organizations, count(IF(IFNULL(z.SUBSECCD,'00')='03',1,NULL)) as `Number_of__501(c)(3)1__Nonprofit__Organizations`, count(IF(IFNULL(z.SUBSECCD,'00')<>'03',1,NULL)) as Number_of__Other__Nonprofit__Organizations FROM bmf.bm1406 z 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, x.Total__Number_of__Nonprofit__Organizations, x.`Number_of__501(c)(3)1__Nonprofit__Organizations`, x.Number_of__Other__Nonprofit__Organizations, round(y.POP2012est/1,0) as Estimated__2012__Population, round(10000*x.Total__Number_of__Nonprofit__Organizations/y.POP2012est,1) as `Total__Nonprofits__per_10,000__Persons`, round(10000*x.`Number_of__501(c)(3)1__Nonprofit__Organizations`/y.POP2012est,1) as `501(c)(3)1__Nonprofits__per_10,000__Persons`, round(10000*x.Number_of__Other__Nonprofit__Organizations/y.POP2012est,1) as `Other__Nonprofits__per_10,000__Persons` FROM (SELECT z.State, count(*) as Total__Number_of__Nonprofit__Organizations, count(IF(IFNULL(z.SUBSECCD,'00')='03',1,NULL)) as `Number_of__501(c)(3)1__Nonprofit__Organizations`, count(IF(IFNULL(z.SUBSECCD,'00')<>'03',1,NULL)) as Number_of__Other__Nonprofit__Organizations FROM bmf.bm1406 z 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 501(c)(3) includes both public charities and private foundations.