Reporter search: a surveillance vendor across towns and time

Custom SQL query returning 892 rows (hide)

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

Query parameters

vendor

city

state

from_date

Edit SQL