Reporter search: unusual surveillance technology

Custom SQL query returning more than 2,000 rows (hide)

SELECT city, state_norm AS state, spend_date, vendor, product,
       amount, amount_type, dup_rank, geo_suspect, anomaly,
       quote, source_document, ledger
FROM surveillance_spending
WHERE (lower(COALESCE(product, '')) LIKE '%' || lower(:term) || '%'
       OR lower(COALESCE(vendor, '')) LIKE '%' || lower(:term) || '%'
       OR lower(COALESCE(quote, '')) LIKE '%' || lower(:term) || '%')
  AND (:state = '' OR state_norm = upper(:state))
ORDER BY state_norm, city, spend_date, vendor

Query parameters

term

state

Edit SQL