Virginia

[Arjayellis]

Overview

The database or data has some formatting or other issues that need to be resolved before it can be imported.

Action Items

• [x] Data Quality
  • [X] Review Secretary of State Website
  • [X] Call a County starting from the first until you reach one that can validate the data with you.
    • [X] Checking the data that we have is correct
    • [X] Gathering data for fields that are empty
    • [X] Asking if there is anything else we should know
  • [X] Update Location Validation Test Sheet
  • [X] Edit the issue Action Items to reflect findings
• [x] Data Scientist/Scrapers
• [x] Add the following columns to your data schema
  • [x] display_notes
  • [x] where
  • [x] start_date
  • [x] accessibility
• [x] Delete the following fields
  • [x] latitude
  • [x] longitude
  • [x] social
  • [x] state and counties and county reps copy
• [x] Rename the following fields
  • [x] Field 23 to location_name
  • [x] validate_url to source_data
• [x] Address fields needs to be broken up into individual components (address_1 and address_2)

  • address_1 = Street name and address #
  • address_2 = suite # or room #, etc
  • city = city name
  • state = state name spelled out
  • state_2 = two-letter abbreviation for the address (for some states the location is in a different state than the voting district (crazy I know. But this is why there is a state field separate which is supposed to be the state spelled out and that is the jurisdiction, not the physical location)

Resources/Instructions

Google sheet

[Arjayellis]

if you requested an absentee ballot, you may complete it and drop it off at any drop-off location in your county or city. There is a drop-off location at your local registrar's office, at every voter satellite office in your county or city, and on Election Day at each polling place in your county or city. (https://www.elections.virginia.gov/casting-a-ballot/)

[aNullValue]

Virginia is processed.