yournextrepresentative icon indicating copy to clipboard operation
yournextrepresentative copied to clipboard

the page of results CSV files should indicate which are incomplete

Open mhl opened this issue 8 years ago • 1 comments

The combination of:

  • The number of posts in an election
  • The people_elected_per_post attribute of Election
  • The winner_count on PostExtraElection, which can override people_elected_per_post

... 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.

mhl avatar May 11 '16 13:05 mhl

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.

jf1 avatar May 11 '16 17:05 jf1