mysociety / yournextrepresentative

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

the page of results CSV files should indicate which are incomplete #919

Open mhl opened 8 years ago

mhl commented 8 years ago

The combination of:

... can tell us how many rows are expected in each per-election CSV results. It would be nice to indicate on the results page, which CSV files are still incomplete.

This isn't trivial, because the CSV-generation lags behind live data. I suppose the CSV generation could record completeness in the database when it runs.

jf1 commented 8 years ago

This information would be useful in other places too, as would information on posts that still need their result reporting (not confirming).

Now that candidates standing in multiple elections are listed multiple times in the all candidates csv, similar information can be gleaned from there. If election_current=TRUE and elected=NULL then the result for this candidate is outstanding (with elected=TRUE/FALSE once their result is in).

Current status: 13068 candidates 12624 with results 186 posts contain 444 candidates whose results are not known.

Some of these posts only have one candidate whose result is unknown, so while there'll be some issue with that candidate's data in dc their post will have a winner and the results csv you're interested in will be complete.