Kansas

[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
  • [ ] Add the following columns to your data schema
  • [x] address_2
  • [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
  • [ ] Delete the following fields
  • [x] name
  • [x] address_3
  • [x] record_number
  • [x] county_state
  • [x] social
  • [x] scraper
  • [x] locations_copy_4
  • [x] ballot_drop_off_location
  • [x] volunteers_validation_copy
  • [x] volunteers_scraper_copy
• [ ] Rename the following fields
  • [x] county(EAJ) to county
  • [x] address_2 to address_1
  • [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

[bartleyn]

Hi just to clarify, the link to the Google Sheet goes to the Washington State County Location, but we're talking about Kansas County Officials, yes?

[Arjayellis]

@bartleyn correct

[kcoronel]

Advance voting by mail has been allowed to all Kansas voters since 1996. You do not need an excuse to advance vote by mail ballot. However, you do need to apply to have an advanced by mail ballot mailed to you for each election as they are NOT mandatory and are sent to voters by county election offices at the request of the voter.

Each of the 105 counties in Kansas has a county election officer responsible for conducting all official elections held in the county. In the four largest counties - Johnson, Sedgwick, Shawnee and Wyandotte - the election officer is the election commissioner, appointed by the secretary of state. For the other 101 counties it is the county clerk, elected by the voters in the county. View a list of what voting system each county uses.

[aNullValue]

Kansas has been processed.