Live data from Hacker News

The drama in trying to convert election PDFs to Spreadsheets

markessien.com

11–20 of 148 posts

Re: The drama in trying to convert election PDFs to Spreadsheets

#13
Checking one at random:

https://docs.google.com/spreadsheets/d/1HhV9iJxXTU9liAZPIDoM...

...shows 0s in the first row for all candidate parties. But the corresponding photo shows votes for all three:

https://inec-cvr-cache.s3.eu-west-1.amazonaws.com/cached/res...

I hope it's not a mistake and that there's some arcane law/technicality to explain it.

edit: another mistake on row 21, LP should get 25 but it was credited to NNPP:

https://docs.inecelectionresults.net/elections_prod/1292/sta...

Re: The drama in trying to convert election PDFs to Spreadsheets

#15

So the bug where the first voting sheet shown to a user was from the same 10% of the photos turned out to be a feature, serving as a CAPTCHA of sorts to weed out the bad actors from the good. If memory serves, some CAPTCHA techniques include showing two numbers to transcribe, where one’s value is already known. If that number is transcribed incorrectly, then the other number’s result isn’t used, and the CAPTCHA fails…

This approach was part of their strategy:

>Then we started showing some results we knew to the bots - if they entered wrong numbers, we would stop accepting the results.

Re: The drama in trying to convert election PDFs to Spreadsheets

#16

So the bug where the first voting sheet shown to a user was from the same 10% of the photos turned out to be a feature, serving as a CAPTCHA of sorts to weed out the bad actors from the good. If memory serves, some CAPTCHA techniques include showing two numbers to transcribe, where one’s value is already known. If that number is transcribed incorrectly, then the other number’s result isn’t used, and the CAPTCHA fails…

Can you explain that again differently? I didn’t understand that captcha point. It feels important though.

Re: The drama in trying to convert election PDFs to Spreadsheets

#19

So the bug where the first voting sheet shown to a user was from the same 10% of the photos turned out to be a feature, serving as a CAPTCHA of sorts to weed out the bad actors from the good. If memory serves, some CAPTCHA techniques include showing two numbers to transcribe, where one’s value is already known. If that number is transcribed incorrectly, then the other number’s result isn’t used, and the CAPTCHA fails…

Can you explain that again differently? I didn’t understand that captcha point. It feels important though.

Original captcha was built around transcribing text that ocr tools failed at

So I give you two words to transcribe to prove you are human. I know one of them and I want to know the other.

Re: The drama in trying to convert election PDFs to Spreadsheets

#20

Checking one at random: https://docs.google.com/spreadsheets/d/1HhV9iJxXTU9liAZPIDoM... ...shows 0s in the first row for all candidate parties. But the corresponding photo shows votes for all three: https://inec-cvr-cache.s3.eu-west-1.amazonaws.com/cached/res... I hope it's not a mistake and that there's some arcane law/technicality to explain it. edit: another mistake on row 21, LP should get 25 but it was credited…

Yeah looks weird. When I scrolled to a random part, the numbers seemed to line up. They didn’t say things were entirely correct though. Perhaps the data quality is sufficient for a challenge. Odd that the first rows seem more wrong though.
Post reply on HN