Find recipient UEIs by name

Custom SQL query (hide)

Catalog Error: Table with name recipients does not exist! Did you mean "recipient_year"? LINE 4: from recipients ^

select recipient_uei, recipient_name, doing_business_as, city, state, first_fiscal_year, last_fiscal_year, obligations, top_naics from recipients where recipient_name ilike '%' || :name || '%' or doing_business_as ilike '%' || :name || '%' order by obligations desc limit 200

Query parameters

name

Edit SQL