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

SELECT '2002' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm0301c3 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND fips='12009' UNION SELECT '2007' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm0801c3 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND fips='12009' UNION SELECT '2012' AS YEAR, COUNT(EIN) AS 'All Registered Public Charities' FROM bmf.bm1302c3 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'