Search the staff-report text (find buried unit counts, dollar figures)

Custom SQL query returning 300 rows (hide)

SELECT ma.meeting_id, mu.name AS town, mu.state, ma.item_title,
       substr(ma.text,1,320) AS excerpt, ma.source_url
FROM meeting_attachments ma
LEFT JOIN meetings m ON m.id = ma.meeting_id
LEFT JOIN municipalities mu ON mu.id = m.muni_id
WHERE ma.source_url <> '__done__' AND ma.text LIKE '%' || :keyword || '%'
LIMIT 300

Query parameters

keyword

Edit SQL