Where one recipient performs its federal contracts

Custom SQL query (hide)

select primary_place_of_performance_state_code as state, primary_place_of_performance_county_name as county, primary_place_of_performance_city_name as city, count(distinct award_id_piid) as awards, sum(federal_action_obligation) as obligations, min(action_date) as first_action, max(action_date) as last_action from contracts where recipient_uei = :uei group by 1, 2, 3 order by obligations desc

Query parameters

uei

Edit SQL