One recipient's obligations by fiscal year and agency

Custom SQL query (hide)

select action_date_fiscal_year as fiscal_year, awarding_agency_name, count(*) as transactions, count(distinct award_id_piid) as awards, sum(federal_action_obligation) as obligations, sum(federal_action_obligation) filter (where labor_standards_code = 'Y' or labor_standards = 'Y') as service_contract_act_obligations, sum(federal_action_obligation) filter (where construction_wage_rate_requirements_code = 'Y') as davis_bacon_obligations from contracts where recipient_uei = :uei group by 1, 2 order by 1 desc, obligations desc

Query parameters

uei

Edit SQL