Spending Trends Over Time

Custom SQL query returning 668 rows (hide)

SELECT fiscal_year, COALESCE(sub_agency, agency) AS agency_name, COUNT(*) AS award_count, CAST(SUM(award_amount) AS INTEGER) AS total_amount, SUM(CASE WHEN award_category = 'grants' THEN 1 ELSE 0 END) AS grants, SUM(CASE WHEN award_category = 'contracts' THEN 1 ELSE 0 END) AS contracts, CAST(SUM(CASE WHEN award_category = 'grants' THEN award_amount ELSE 0 END) AS INTEGER) AS grant_total, CAST(SUM(CASE WHEN award_category = 'contracts' THEN award_amount ELSE 0 END) AS INTEGER) AS contract_total FROM spending_awards WHERE fiscal_year IS NOT NULL GROUP BY fiscal_year, agency_name ORDER BY fiscal_year DESC, total_amount DESC

Edit SQL