Total Registered Nonprofits: 2005, 2010, 2015, Latest Year (10/2020)

SELECT '2005' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm0507 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2010' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm1007 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2015' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm1507 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2020 (October)' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm2010 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009'