One recipient's contracts, one row per award

Custom SQL query (hide)

select award_id_piid, parent_award_id_piid, arg_max(awarding_sub_agency_name, action_date) as awarding_sub_agency, arg_max(prime_award_base_transaction_description, action_date) as description, arg_max(naics_description, action_date) as naics, arg_max(labor_standards, action_date) as service_contract_act, arg_max(construction_wage_rate_requirements, action_date) as davis_bacon, arg_max(primary_place_of_performance_state_code, action_date) as state, min(period_of_performance_start_date) as start_date, max(period_of_performance_current_end_date) as end_date, count(*) as transactions, sum(federal_action_obligation) as obligations from contracts where recipient_uei = :uei group by 1, 2 order by obligations desc

Query parameters

uei

Edit SQL