New Orleans: what a public body paid a vendor (try: amazon, meta, entergy)

Every payment line New Orleans bodies filed, searchable by vendor. Source is each body's own transparency file, and `source_url` on every row links back to it. CAUTION ON NAME SEARCH: card-processor descriptors do not look like company names. Meta's charges appear as `FACEBK *W6U9B45J52` with the purpose "BOOSTED FACEBOOK ADS", so a payee search for "meta" MISSES them and instead returns scrap METAL companies and businesses in METAIRIE. Search `purpose` as well as `payee`.

SELECT mu.name AS body, g.payee, g.purpose, g.amount, g.txn_date, g.source_url
FROM gov_payments g JOIN municipalities mu ON mu.id = g.muni_id
WHERE mu.state = 'LA'
  AND (lower(g.payee) LIKE '%' || lower(:vendor) || '%'
       OR lower(g.purpose) LIKE '%' || lower(:vendor) || '%')
ORDER BY g.amount DESC NULLS LAST
LIMIT 500