DemocracyClub / yournextrepresentative

đź‘Ą A website for crowd-sourcing structured election candidate data
https://candidates.democracyclub.org.uk
GNU Affero General Public License v3.0
21 stars 27 forks source link

CSV creator issues #2202

Open pmk01 opened 10 months ago

pmk01 commented 10 months ago
### Ready
- [x] Filter on field value (When selecting an individual value (eg. Wikipedia), allow to download ONLY those candidates with/out that field entered.)
- [x] Not all fields are in the csv builder - no demographic options, for example.
- [x] gender
- [x] birth_date
- [x] image_url
- [x] favourite_biscuits
- [x] statement_to_voters
- [ ] Ideally It could have a simply dropdown for election type. Or, at any rate, we should explain our ID system on the page.
- [ ] Filter on NUTS
- [ ] Add an uncontested filter
- [ ] Organisation type (county, unitary, etc)
### Later
- [ ] Request: add cancellation reason.

https://candidates.democracyclub.org.uk/data/

~Can't add elected column to csv, can only filter by it.~ ~Ability to filter on cancelled would be appreciated.~

pmk01 commented 9 months ago

~I got a 500 when selecting 'all election fields'~

pmk01 commented 9 months ago

~Request: add cancellation reason.~

sjorford commented 8 months ago

~The paging buttons don't include the search criteria, so they just go back to paging through the full dataset e.g. https://candidates.democracyclub.org.uk/data/?election_date=&ballot_paper_id=batley&election_id=&party_id= image "next" links to https://candidates.democracyclub.org.uk/data/?page=2~

pmk01 commented 8 months ago

~Not all fields are in the csv builder - no demographic options, for example.~

symroe commented 5 months ago

I got a 500 when selecting 'all election fields'

@pmk01 Is this still a bug? I can't re-produce it

pmk01 commented 5 months ago

Looks like it's fixed now! I can't replicate it anyway.

pmk01 commented 5 months ago

Can't get council gss codes out of this, only wards

pmk01 commented 5 months ago

Observations from others:

~UX glitch: The “additional fields” checkboxes don’t remain ticked after submission (and the accordion is collapsed, making it non-obvious that they’re not ticked). So when I adjusted the filters and resubmitted, I lost my additional fields.~

~Feature: it would be handy to have a field output that tells me whether it’s a by-election or not (rather than having to export two separate files)~

~a copy of the pagination above the (often long) list of results, as well as a copy of the Download CSV button nearer the top - having to scroll all the way to the bottom for this (the thing you're here for!) is a pain that seems strange.~

pmk01 commented 5 months ago

Ideally It could have a simply dropdown for election type. Or, at any rate, we should explain our ID system on the page.

pmk01 commented 4 months ago

currently missing gender birth_date image_url favourite_biscuits statement_to_voters

symroe commented 4 months ago

Cancellation reason: I'll keep this on the list, but we don't currently import / store this in YNR so I'll mark it as out of scope for now

pmk01 commented 2 months ago

If you select a nation, it auto-filters. But then you select and filter additional fields, and it reverts to 'all'.

pmk01 commented 1 week ago

Can get uncontested by filtering elected & cancelled, but this isn't obvious. A single filter would be useful.

pmk01 commented 1 week ago

Ability to filter by council type - county, unitary, metropolitan borough, etc - would be very useful