Finances of Reporting Nonprofits, By Type: 2002, 2007, 2012

SELECT '2002' AS YEAR, 'Public charities' as Type, COUNT(EIN) AS Number, SUM(TOTREV) AS Revenue, SUM(EXPS) as Expenses, SUM(ASS_EOY) as Assets_EOY FROM nccs.core2002pc WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND GRREC>=25000 AND fips='12009' UNION SELECT '2002' AS YEAR, 'Private foundations' as Type, COUNT(EIN) AS Number, SUM(p1totrev) AS Revenue, SUM(p1totexp) as Expenses, SUM(p2totast) as Assets_EOY FROM nccs.core2002pf A WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2002' AS YEAR, '501c others' as Type, COUNT(EIN) AS Number, SUM(totrev2) AS Revenue, SUM(EXPS) as Expenses, SUM(ASS_EOY) as Assets_EOY FROM coreco.core2002co WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND GRREC >=25000 AND fips='12009' UNION SELECT '2007' AS YEAR, 'Public charities' as Type, COUNT(EIN) AS Number, SUM(TOTREV) AS Revenue, SUM(EXPS) as Expenses, SUM(ASS_EOY) as Assets_EOY FROM nccs.core2007pc WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND GRREC >=25000 AND fips='12009' UNION SELECT '2007' AS YEAR, 'Private foundations' as Type, COUNT(EIN) AS Number, SUM(p1totrev) AS Revenue, SUM(p1totexp) as Expenses, SUM(p2totast) as Assets_EOY FROM nccs.core2007pf A WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2007' AS YEAR, '501c others' as Type, COUNT(EIN) AS Number, SUM(TOTREV) AS Revenue, SUM(EXPS) as Expenses, SUM(ASS_EOY) as Assets_EOY FROM coreco.core2007co WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND GRREC >=25000 AND fips='12009' UNION SELECT '2012' AS YEAR, 'Public charities' as Type, COUNT(EIN) AS Number, SUM(TOTREV) AS Revenue, SUM(EXPS) as Expenses, SUM(ASS_EOY) as Assets_EOY FROM nccs.core2012pc WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND GRREC >=50000 AND fips='12009' UNION SELECT '2012' AS YEAR, 'Private foundations' as Type, COUNT(EIN) AS Number, SUM(p1totrev) AS Revenue, SUM(p1totexp) as Expenses, SUM(p2totast) as Assets_EOY FROM nccs.core2012pf A WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2012' AS YEAR, '501c others' as Type, COUNT(EIN) AS Number, SUM(TOTREV) AS Revenue, SUM(EXPS) as Expenses, SUM(ASS_EOY) as Assets_EOY FROM coreco.core2012co WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND GRREC >=50000 AND fips='12009'