READER COMMENTS ON
"Database Geek Wanted: Programmer Needed to Help Pima County, AZ, Election Advocates Sort Through Largest Stash of Diebold Data Ever!"
(14 Responses so far...)
COMMENT #1 [Permalink]
said on 5/30/2008 @ 7:08 am PT...
Why don't those Fair light guys help out? Aren't they are really good with election data?
COMMENT #2 [Permalink]
said on 5/30/2008 @ 9:08 am PT...
Submitted to Slashdot...lets wait and see.
COMMENT #3 [Permalink]
John R Brakey
said on 5/30/2008 @ 9:22 am PT...
We’ve worked hard getting these databases. There are some 1,300 databases going back as far as May of 1998. Most are backups that are time dated snapshot before and after election to closing called .GBF (Global Backup Files.) At least one per election is in .MDB (Microsoft DataBase) Files that open in MS-Access. We will have all passwords to open all the .GBF files and convert them to MDB.
The largest public release before these backup files that we know of was from the state of Alaska and that was 3 files from Election Day of November of 2006 only.
Any questions, feel free to contact me.
John R Brakey
Subject: Pima County, the RTA and the 2 billion dollar heist.
4/21/08 Pima Co: KOLD TV Tucson: “Who Checks The Vote Counters?” Facts learned in the Pima Co Democratic Party’s Election integrity lawsuit against Pima County: From deposition of State Election Director Joseph Kanefield: “Who Checks the Vote Counters?” NOT the Secretary of State! Not the Attorney General! Not the County!
Must see TV! By Bud Foster KOLD TV TUCSON:
2 minutes long:
COMMENT #4 [Permalink]
said on 5/30/2008 @ 10:04 am PT...
COMMENT #5 [Permalink]
said on 5/30/2008 @ 11:38 am PT...
Where is Clint Curtus of Florida on this?
COMMENT #6 [Permalink]
said on 5/30/2008 @ 12:13 pm PT...
Curtis is currently busy running for Congress, trying to win the Democratic nomination in order to run against Tom Feeney in the fall.
COMMENT #7 [Permalink]
said on 5/30/2008 @ 12:33 pm PT...
I don't understand the problem. It is in a database --- a MS Access db as I understand it. If what is needed exceeds MS Access's query and report writing then import it to MySQL. Use SQL and stored procedures.
You will most likely get a lot more 'sourceforge' help if it is in a MySQL database.
COMMENT #8 [Permalink]
Robert 'Groby' Blum
said on 5/30/2008 @ 1:55 pm PT...
Why not just put the data up for download?
You'll find a ton of people who're interested in digging through that kind of data, but don't want to commit to a contract.
COMMENT #9 [Permalink]
said on 5/30/2008 @ 2:37 pm PT...
Hey John 3#, now that's what I call local home town news reporting! Thanks!!!!!
COMMENT #10 [Permalink]
said on 5/30/2008 @ 9:14 pm PT...
We need the automated review tool for a number of reasons:
1) Judge Miller has ordered these files be made public in future elections on the day of the official canvass. This isn't a bad choice, if a bit conservative - I would have argued for "late on election night" but it's not something worth squabbling over further in court. Problem is, ALL official challenges in AZ have to be filed within 5 days of the canvass. Without an automated review tool, challenges within 5 days of the canvass based on findings of database problems will be forever impossible.
2) We also want to export this whole data analysis concept nationwide - or even worldwide, wherever Diebold lurks. We could get enough volunteers together to check out PIMA elections, yeah (not in five days), but nationwide? Impossible in any timescale.
COMMENT #11 [Permalink]
said on 5/31/2008 @ 6:04 pm PT...
I agree all the databases should be converted to MySQL. This would take time but getting them into one or multiple database files (depending if all the files have similiar structure) that can be cross referrenced would be crutial.
Access can be slow and is not the best interface for a large number of records.
I have used MySQL for large country wide voter registration records without a problem.
The program analysis tools and reports could be written in PHP (open source) or JSP and provide web or local computer based access.
Let me know if you need help - I am very experience in all the above.
COMMENT #12 [Permalink]
Robert 'Groby' Blum
said on 6/1/2008 @ 10:19 am PT...
For all those "they should be in MySQL" - that's more or less not possible. The goal of this is to analyze the *original* Diebold databases. Any analysis on a converted format will allow them to throw up a smoke screen, implicating the conversion in any errors found.
The less you need to modify the original data before evaluating it, the less of an attack opportunity you offer to criticize the results.
COMMENT #13 [Permalink]
Martin from Germany
said on 6/2/2008 @ 5:46 am PT...
You are right of cause, but they will try to obfuscate and belittle the results _anyway_. And the public can't verify anything because they don't know Access or MySQL.
What should be done is: 1) analyse the raw data with the best tools available (that is MySQL in my optinion) 2) if mischief is found get the FBI, Congress, whoever involved and have _them_ re-analyse the data (using _their_ methods and tools) and verify the results found by the party.
And then hit Diebold like a ton of bricks...
COMMENT #14 [Permalink]
said on 6/2/2008 @ 2:07 pm PT...
As long as the conversion is correct, any problem can then be tracked back to a corresponding issue in the Access (or whatever) Database.
For example, the scenario in the PDF can be detected by putting all of the precinct totals into a spreadsheet, and taking sums for the county.
Unless the data is very large the best approach may be to build a tool that dumps all of the data (including timestamps) into an easily read format and then generic tools can be applied to it.