Categories
Election Data Analysis Election Forensics Election Integrity programming technical

Compiled per precinct data for VA 2020 and 2021

Below I’ve linked copies of newly compiled sets of VA 2020 President and 2021 Governor November General Election data for anybody who is interested. The data set is compiled from only official VA Dept of Elections data sources including the General Election CSV files, the turnout CSV files, and the Daily Absentee List for each election.

Columns common to all source data:

  • “LOCALITY” – Locality Name
  • “DISTRICT” – Congressional district ID number
  • “PRECINCT_ID” – Precinct ID number
  • “PRECINCT” – Precinct Name

Columns compiled from the General Election CSV file:

  • “Democratic” – Number of Democratic Party Votes
  • “Liberation” – Number of Liberation Party Votes
  • “Republican”- Number of Republican Party Votes
  • “UNDEFINED” – Number of Write in Votes
  • “TOTAL_VOTES” – Sum of [“Democratic”, “Liberation”, “Republican”, “UNDEFINED”]

Columns compiled from the Turnout CSV file:

  • “PROVISIONAL_BALLOTS” – Number of Provisional Ballots
  • “ABSENTEE_BALLOTS” – Number of Absentee Ballots
  • “CURBSIDE_BALLOTS” – Number of Curbside Ballots
  • “ABS_OR_CURB_BALLOTS” – Sum of [“ABSENTEE_BALLOTS”, “CURBSIDE_BALLOTS”]
  • “TOTAL_VOTE_TURNOUT” – Total number of ballots coollected
  • “ACTIVE_REGISTERED_VOTERS” – The number of active voters
  • “TOTAL_REGISTERED_VOTERS” – The total number of registered voters

Columns compiled from the DAL file:

  • “ABSENTEE_ISSUED” – Number of approved but outstanding “Issued” ballots listed in the DAL
  • “ABSENTEE_MARKED” – Number of approved ballots listed as “Marked” in the DAL
  • “ABSENTEE_PRE_PROCESSED” – Number of approved ballots listed as “Pre-Processed” in the DAL
  • “ABSENTEE_MRKORPRE” – Sum of [“ABSENTEE_MARKED”, “ABSENTEE_PRE_PROCESSED”]
  • “ABSENTEE_EARLY_IN_PERSON” – Number of approved ballots listed as “On Machine” in the DAL
  • “ABSENTEE_FWAB” – Number of approved ballots listed as “FWAB” in the DAL
  • “ABSENTEE_COUNTABLE” – Sum of [“ABSENTEE_MARKED”, “ABSENTEE_PRE_PROCESSED”, “ABSENTEE_EARLY_IN_PERSON”, “ABSENTEE_FWAB”]

Columns created by summing all entries in a locality:

  • “TOTAL_VOTES_IN_LOCALITY”
  • “ACTIVE_REGISTERED_VOTERS_IN_LOCALITY”
  • “TOTAL_REGISTERED_VOTERS_IN_LOCALITY”
  • “ABSENTEE_ISSUED_IN_LOCALITY”
  • “ABSENTEE_MARKED_IN_LOCALITY”
  • “ABSENTEE_PRE_PROCESSED_IN_LOCALITY”
  • “ABSENTEE_MARKED_OR_PRE_IN_LOCALITY”
  • “ABSENTEE_EARLY_IN_PERSON_IN_LOCALITY”
  • “ABSENTEE_FWAB_IN_LOCALITY”
  • “ABSENTEE_COUNTABLE_IN_LOCALITY”

Source Data Files (except DAL):

One reply on “Compiled per precinct data for VA 2020 and 2021”