How a town's council voted (search by town name)

Custom SQL query returning 1,000 rows (hide)

SELECT mu.name AS town, mu.state, mv.body_name, mv.motion, mv.member_name, mv.vote
FROM member_votes mv JOIN municipalities mu ON mu.id = mv.muni_id
WHERE lower(mu.name) LIKE '%' || lower(:town) || '%'
ORDER BY mv.meeting_id DESC LIMIT 1000

Query parameters

town

Edit SQL