{"action":"created","issue":{"url":"https://api.github.com/repos/openelections/openelections-data-or/issues/130","repository_url":"https://api.github.com/repos/openelections/openelections-data-or","labels_url":"https://api.github.com/repos/openelections/openelections-data-or/issues/130/labels{/name}","comments_url":"https://api.github.com/repos/openelections/openelections-data-or/issues/130/comments","events_url":"https://api.github.com/repos/openelections/openelections-data-or/issues/130/events","html_url":"https://github.com/openelections/openelections-data-or/issues/130","id":191860375,"number":130,"title":"Verification script","user":{"login":"nk9","id":3646730,"avatar_url":"https://avatars.githubusercontent.com/u/3646730?v=3","gravatar_id":"","url":"https://api.github.com/users/nk9","html_url":"https://github.com/nk9","followers_url":"https://api.github.com/users/nk9/followers","following_url":"https://api.github.com/users/nk9/following{/other_user}","gists_url":"https://api.github.com/users/nk9/gists{/gist_id}","starred_url":"https://api.github.com/users/nk9/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nk9/subscriptions","organizations_url":"https://api.github.com/users/nk9/orgs","repos_url":"https://api.github.com/users/nk9/repos","events_url":"https://api.github.com/users/nk9/events{/privacy}","received_events_url":"https://api.github.com/users/nk9/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-11-27T13:04:11Z","updated_at":"2016-11-28T01:07:45Z","closed_at":null,"body":"We're generating lots of CSV files, but there are some common inconsistencies/mistakes. I'm thinking it would be useful to have a script people could run on newly completed CSV files to make sure it's following the OE format.\r\n\r\nThings I thought could be verified:\r\n\r\n1. Right number of columns, in the right order\r\n2. Votes don't contain commas\r\n3. All numbers are integers (no decimals)\r\n4. No \"X\" for zero votes\r\n5. Consistent capitalization/spelling of \"Write-in\", \"Under Votes\", \"Over Votes\", \"Total\"\r\n6. County matches file name, is consistent on every line\r\n7. Party included for \"Write-in,\" etc lines in primaries, not for generals/specials\r\n8. Office names properly normalised\r\n9. Only appropriate fields empty (i.e. only party [if a general] or district)\r\n\r\nHas something like this already been created? Other ideas for sanity checks which could be run?"},"comment":{"url":"https://api.github.com/repos/openelections/openelections-data-or/issues/comments/263162240","html_url":"https://github.com/openelections/openelections-data-or/issues/130#issuecomment-263162240","issue_url":"https://api.github.com/repos/openelections/openelections-data-or/issues/130","id":263162240,"user":{"login":"dwillis","id":2214,"avatar_url":"https://avatars.githubusercontent.com/u/2214?v=3","gravatar_id":"","url":"https://api.github.com/users/dwillis","html_url":"https://github.com/dwillis","followers_url":"https://api.github.com/users/dwillis/followers","following_url":"https://api.github.com/users/dwillis/following{/other_user}","gists_url":"https://api.github.com/users/dwillis/gists{/gist_id}","starred_url":"https://api.github.com/users/dwillis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwillis/subscriptions","organizations_url":"https://api.github.com/users/dwillis/orgs","repos_url":"https://api.github.com/users/dwillis/repos","events_url":"https://api.github.com/users/dwillis/events{/privacy}","received_events_url":"https://api.github.com/users/dwillis/received_events","type":"User","site_admin":false},"created_at":"2016-11-28T01:07:45Z","updated_at":"2016-11-28T01:07:45Z","body":"Ran the verifier script (thanks!) and yeah, the pseudo-candidate names are definitely an issue in this repo (and likely others). We have a couple of options:\r\n\r\n1. Clean these up in this repo.\r\n2. Clean them up as we load them into our [processing pipeline](http://docs.openelections.net/guide/), which we've done for other states.\r\n\r\nI'd kinda prefer 1."}}
{"actor":{"display_login":"dwillis"}}