Indiana

[kcoronel]

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] state_2
  • [x] display_notes
  • [x] where
  • [x] start_date
  • [x] accessibility
  • [x] has_dropoff_location
  • [x] has_phone_number
  • [x] inactive
  • [x] hours
  • [x] rules
  • [x] Delete the following fields
  • [x] record_number
  • [x] county_state
  • [x] Helper Field
  • [x] social
  • [x] scraper
  • [x] locations_copy_4
  • [x] ballot_drop_off_location
  • [x] volunteers_validation_copy
  • [x] volunteers_scraper_copy
• [x] Rename the following fields
  • [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
  • state = state name spelled out
  • city = city name
  • state_2 = two-letter abbreviation. For the address, need two-letter abbreviations. 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]

only the voter, the voter’s attorney-in-fact, a bonded courier, or a member of the voter’s immediate household may hand-deliver a completed absentee ballot to the county election board. Any person other than the voter doing so is to complete the ABS-19 affidavit.

[aNullValue]

Could someone take another look at Indiana? The following counties seem to be absent from the file, without explanation:

Crawford County, Daviess County, DeKalb County, Fountain County, Greene County, Jennings County, Montgomery County, Newton County, Starke County, Brown County, Pike County

See also https://indianavoters.in.gov/CountyContact/Index (Election board contact (left side), not necessarily voter registration)

[allysmatrix]

Adding back the following 12 counties (Source: https://indianavoters.in.gov/CountyContact/Index): Brown Crawford Daviess DeKalb Fountain Greene Jennings LaPorte (name edited) Montgomery Newton Pike Starke

Cross-referenced county list against: https://ballotpedia.org/Counties_in_Indiana

[aNullValue]

Indiana has been processed.