Skip to content

Download results of an Election on an open format (Open Data) #5968

@carolromero

Description

@carolromero

ref: S-V.02

As a visitor I want to download the results of an election in an open format (CSV). As Decidim has already a "Download Open Data" link in the footer, we would need to implement in a file there. On Decidim Barcelona that'd be called www.decidim-barcelona-open-data-elections.csv.

The format for this file would be based on what we already have for consistency, with these columns:

id;election/id;election/title/es;election/title/ca;question/id;question/title/es;question/title/ca;answer/id;answer/title/es;answer/title/ca;answer/votes

Where:

Column Description
id Answer ID
election/id Election ID that belongs this Answer to
election/title/es Election on spanish (* depends on the instance, one for every i18n lang)
election/title/ca Election on catalan (* depends on the instance, one for every i18n lang)
question/id Question ID that belongs this Answer to
question/title/es Question on spanish (* depends on the instance, one for every i18n lang)
question/title/ca Question on catalan (* depends on the instance, one for every i18n lang)
answer/id Answer ID
answer/title/es Answer on spanish (* depends on the instance, one for every i18n lang)
answer/title/ca Answer on catalan (* depends on the instance, one for every i18n lang)
answer/votes Total votes that this Answer has

(Please note that this needs a review and could change with whatever makes sense at the technical level)

Acceptance criteria

  • As a visitor I can download the Elections/Answers results on the Open Data file after the Election has finished and the results are published

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions