Open data
All data on this site can be downloaded in machine-readable form.
Download all tables (CSV, zip) 30.3 MB
The same data is also available table by table as Parquet. The CSV files are UTF-8, comma-separated, with a header row.
| Table | Contents | Rows | Parquet |
|---|---|---|---|
attendance | Meeting attendance meeting_id, name, person_id, role, present, note | 25,864 | 85 kB |
ballots | Each member’s ballot in each vote vote_id, name, person_id, choice, group | 33,805 | 63 kB |
bodies | Decision-making bodies id, city, name_fi, kind, included | 132 | 5 kB |
items | Agenda items and their decisions id, city, body_id, meeting_id, date, ordinal, pykala, title, case_number, decision, vote_count, status, source_url | 18,696 | 3 MB |
meetings | Meetings id, city, body_id, date, start_time, end_time, location, stage, item_count, source_url, minutes_pdf_url | 1,440 | 54 kB |
memberships | Memberships of bodies person_id, body_id, role, group, start, end, source | 2,345 | 23 kB |
motions | Motions and their outcome item_id, ordinal, kind, proposer, seconders, outcome, text | 2,002 | 277 kB |
persons | People and their 2025 election result id, city, name, sort_name, party, election_result, election_votes | 1,134 | 40 kB |
sections | Text sections of items (proposal, deliberation, decision, earlier handling) item_id, ordinal, type, heading, text | 62,858 | 24.4 MB |
votes | Votes id, city, body_id, item_id, date, ordinal, jaa_label, ei_label, jaa, ei, tyhja, poissa, result_text, source, needs_review, review_reason, source_url | 862 | 60 kB |
Tables join on ids: items.meeting_id → meetings.id, votes.item_id → items.id, ballots.vote_id → votes.id, memberships.person_id → persons.id. Names are as printed in the minutes.
The data is licensed under CC BY 4.0. Credit Kotihiiri and the city in question as the source.