Provenance for every figure on this page. Click any vote, dollar amount, or meeting card to view the underlying source — agenda PDF, official minutes, or the city's CMS.

Platform Granicus Public meeting publisher

Adapter GranicusAdapter src/docket/adapters/

Records 0 meetings indexed

By the numbers

Meetings (lifetime)

1,003

Since 2008

show SQL

SELECT count(*) FROM meetings WHERE municipality_id = 1

Agenda items YTD

1,267

show SQL

SELECT count(*) FROM agenda_items ai
JOIN meetings m ON m.id = ai.meeting_id
WHERE m.municipality_id = 1
AND m.meeting_date >= date_trunc('year', now())

Votes YTD

115

show SQL

SELECT count(*) FROM votes v
JOIN meetings m ON m.id = v.meeting_id
WHERE m.municipality_id = 1
AND m.meeting_date >= date_trunc('year', now())

Dollars (pending / settled)

$5298.4M / $766.2M

show SQL

SELECT sum(dollars_amount) FILTER (WHERE minutes_adopted_at IS NULL),
       sum(dollars_amount) FILTER (WHERE minutes_adopted_at IS NOT NULL)
FROM agenda_items ai
JOIN meetings m ON m.id = ai.meeting_id
WHERE m.municipality_id = 1