Agora activity by canton (proposals about a canton or one of its communes)
votara-agora-activity
- Publisher
- Votara
- Access method
code- Endpoint
src/lib/server/agora/canton-activity.ts- Licence
- AGPL-3.0 (code), CC BY 4.0 (outputs)
- Coverage
- Geography 26 cantons (today's borders) · inputs Agora proposals (database), bfs-commune-population (latest year, canton sums of today's communes)
- Used on
- AGORA-20
- Known limits
- Opinion and activity of Votara users, not a representative survey. Only proposals are counted: Votara stores no canton for voters or note authors, so votes and context notes cannot be attributed to a canton. A canton's count depends on how many residents use Votara, which differs by language region and over time.
How current is this data?
- Freshness
- No regular updates
There is no source to check regularly: Votara computes this itself, or the publication does not change.
- Period covered
- Not a time series
- Last change of the data
- not pulled yet
- Last check of the source
- No check recorded yet
- Update rhythm
- Computed by Votara
Ledger note (in English): Computed on request from the Agora database while the agora feature flag is on.
The state is computed each time the site is built; this page shows it as of . Results of the accuracy checks
Transformations
- Count of published, not removed proposals (status published, deleted_at empty) with a cantonal scope (canton_code) or a communal scope (commune_bfs mapped to the canton of that commune in the current BFS register, old numbers resolved through bfs-commune-mutations). One grouped query; no proposal, author or date leaves the database. Script: src/lib/server/agora/canton-activity.ts
- Rate = count ÷ residents × 1000, residents = sum of the canton's communes in the latest STATPOP year (bfs-commune-population, today's borders). Script: src/lib/agora/canton-activity.ts
- Privacy rule 6: a canton with fewer than 50 proposals shows "fewer than 50" only (no count, rate, rank or colour). Only one total per canton is published and no national total, so a hidden count cannot be recovered by subtraction.