openelections / openelections-data-ia Goto Github PK
View Code? Open in Web Editor NEWElection results for Iowa
Election results for Iowa
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.
20150104__ia__special__general__precinct.csv
for precinct results)20150210__ia__special__general__precinct.csv
for precinct results)20151103__ia__special__general__precinct.csv
for precinct results)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.
openelections-data-ia/2014/20141104__ia__general__county.csv
Lines 1 to 3 in cc355b4
2012/20121106__ia__general__allamakee__precinct.csv has some incorrect entries in the office
column:
openelections-data-ia/2012/20121106__ia__general__allamakee__precinct.csv
Lines 110 to 114 in 21ec239
"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.
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:
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.