openelections / openelections-data-ia Goto Github PK

Available here. Using Tabula, create CSV files that look like this one. For races that have both county and precinct-level results, create separate files for both.

• State Representative District 4, Jan. 4, 2015 (filename would be 20150104__ia__special__general__precinct.csv for precinct results)
• State Representative District 23, Feb. 10, 2015 (filename would be 20150210__ia__special__general__precinct.csv for precinct results)
• State Representative District 5, Nov. 3, 2015 (filename would be 20151103__ia__special__general__precinct.csv for precinct results)
• State Representative District 21, Dec. 8, 2015 (filename would be 20151208__ia__special__general__precinct.csv for precinct results)

It appears that many of Iowa's 99 counties are missing from the presidential results in this 2012 results file. You can search for one like "Clinton" to see for yourself. The full extent of missing data is shown in this pivot table.

2014/20141104__ia__general__county.csv contains faulty data and needs to be regenerated.

2012/20121106__ia__general__allamakee__precinct.csv has some incorrect entries in the office column:

"Mitt RomneyPaul RyanRepublican" should be "President/Vice President".

The state of Iowa has 99 counties, but not all 99 have results for the President and Senate races when I run a pivot table on the file here.

Searching for one of those counties, Poweshiek, here on Github confirms the bug.

General Precinct File does not have Monona county results.

• 20100608__ia__primary__county.pdf - Candidate names are in annoying diagonal orientation. We could manually data enter these, or try to convert to image, rotate, and OCR.

Many of the 2020 files have some suspect district values. For example, 2020/20201103__ia__general__adair__precinct.csv has column headers:

However, there are rows like the following:

• June 12, 2001 state house
• Nov. 6, 2001 state house

For the 2018 general election precinct data, there are some weird values in the party column: "Kevin," "illegible last name," "blank," and "Bob Rasmussen." Just wanted to flag this -- not sure if this was a result of the coding process or the form that the raw IA data came in?

Here is a screenshot of the file published here, which I downloaded and filtered to the presidential race and Adair County (The first alphabetical). You can see that the TOTAL and other candidates appear more than once.

There appear to be 18 records in the raw Iowa precinct file with negative vote values for election day, nearly all involving write-ins.

2000/20001107__ia__general__precinct.csv appears to be missing a candidate column.

Also, there are rows pertaining to YES/NO questions where the vote (YES or NO) appears under the party column, which is strange. There are other files that seem to contain the YES/NO vote in the candidate column, so it might make sense to reorganize the data once the candidate column is added.

Though it has been manually fixed in the presidential results by pull request #9