Virginia Election Integrity Audit: Datasets

« Virginia Election Integrity Audit main index

Virginia Datasets

2020 November General Election Change Log

This file is the official record of changes to vote totals at the Virginia Department of Elections.

The original source contains candidate nicknames in quotes (e.g. Robert E. "Bob" Good), which can cause problems in parsers - as the same character is also a field delimiter. The following datasets, other than the original source files, fix this problem by using the carat (^) character instead (e.g. Robert E. ^Bob^ Good). Empty values have been converted to NULL.

• Virginia Department of Elections source (CSV) (external) | Local copy (with blank final line removed): CSV
• Local copy of original source, with nickname-quotes correction: CSV
• Full database, imported from corrected source (includes local): SQL

• Changelog Subsets

  • All federal races (President, Senate, Congress) CSV | SQL
  • President of the United States CSV | SQL
  • United States Senator CSV | SQL
  • VA-1 US Representative CSV | SQL
  • VA-2 US Representative CSV | SQL
  • VA-3 US Representative CSV | SQL
  • VA-4 US Representative CSV | SQL
  • VA-5 US Representative CSV | SQL
  • VA-6 US Representative CSV | SQL
  • VA-7 US Representative CSV | SQL
  • VA-8 US Representative CSV | SQL
  • VA-9 US Representative CSV | SQL
  • VA-10 US Representative CSV | SQL
  • VA-11 US Representative CSV | SQL

New York Times Election Ticker

• New York Times election ticker for Virginia source file: JSON

Other Datasets

• MARYLAND 2020 Election Change Log (original): CSV