Total Registered Nonprofits: 2002, 2007, 2012, Latest Year (10/2020)

SELECT '2002' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm0301 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2007' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm0801 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2012' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm1302 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'