Community Platform

Finances of Reporting Nonprofits, By Type: 2005, 2010, 2015

Elapsed time: 08:49:52 - fin: 08:49:52

SELECT '2005' 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.core2005pc WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND GRREC>=25000 AND fips='12009' UNION SELECT '2005' 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.core2005pf A WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2005' 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.core2005co WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND GRREC >=25000 AND fips='12009' UNION SELECT '2010' 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.core2010pc WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND GRREC >=25000 AND fips='12009' UNION SELECT '2010' 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.core2010pf A WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2010' 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.core2010co WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND GRREC >=25000 AND fips='12009' UNION SELECT '2015' 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.CoreEfile2015_pc WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND FNDNCD NOT IN ('02','03','04') AND GRREC >=50000 AND fips='12009' UNION SELECT '2015' 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.core2015pf A WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND fips='12009' UNION SELECT '2015' 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.core2015co WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND GRREC >=50000 AND fips='12009'