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

SELECT '2005' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm0507c3 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND fips='12009' UNION SELECT '2010' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm1007c3 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND fips='12009' UNION SELECT '2015' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm1507c3 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND fips='12009' UNION SELECT '2020 (October)' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm2010c3 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND fips='12009'