Georgia counties report precinct-level election results using a standard format. Provided in both Excel and text format. The data dictionary for presidential elections only:
COUNTY: CountyPRECINCT: PrecinctPRES16D: Number of votes for 2016 Democratic presidential candidatePRES16D_AB: Number of absentee votes for 2016 Democratic presidential candidatePRES16D_AD: Number of advance in person votes for 2016 Democratic presidential candidatePRES16D_ED: Number of election day votes for 2016 Democratic presidential candidatePRES16D_PR: Number of provisional votes for 2016 Democratic presidential candidatePRES16L: Number of votes for 2016 Libertarian presidential candidatePRES16L_AB: Number of absentee votes for 2016 Libertarian presidential candidatePRES16L_AD: Number of advance in person votes for 2016 Libertarian presidential candidatePRES16L_ED: Number of election day votes for 2016 Libertarian presidential candidatePRES16L_PR: Number of provisional votes for 2016 Libertarian presidential candidatePRES16R: Number of votes for 2016 Republican presidential candidatePRES16R_AB: Number of absentee votes for 2016 Republican presidential candidatePRES16R_AD: Number of advance in person votes for 2016 Republican presidential candidatePRES16R_ED: Number of elecetion day votes for 2016 Republican presidential candidatePRES16R_PR: Number of provisional votes for 2016 Republican presidential candidateREG_VOTE: Number of registered voters
Reads in each of county text files with 2016 presidential data (stored in data folder). Parses data, creates data frames, concatenates, outputs GA_precincts_with_absentee.csv.
Currently problem in that format is fixed-width except if the precinct name is long it is crushed against the second (numeric) column, and the extra spaces shift all subsequent columns to the right.
Purpose: Match voting data from tabular concatenated precinct file to precinct shapefile for all Georgia.
Currently exploratory. Some precinct sums don't match county-level total votes.
Purpose: Resolve overlap between neighboring geographies in a shapefile. Assumes shapefile should be a lattice (?).