Ohio

[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 Collection Design
  • [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] field 23
    • [x] latitude
    • [x] longitude
    • [x] social
    • [x] state and counties and county reps copy
  • [x] Rename the following fields
    • [x] validate_url to source_data
  • [x] If Hours are available add them to the sheet by using the following convention (removing any info about days they are closed e.g. closed sat and sun, unless it refers to a specific date they are closed): MONDAY-FRIDAY:1:00 PM-4:30PM or Monday-Friday:7:00-12:00
• [ ] 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

Google Sheet

[Seymour100]

@aNullValue should I delete "Board of Elections" from location_type to make room for things like "Courthouse"?

[kcoronel]

Return your voted ballot. If you return your absentee ballot by mail, it must be postmarked no later than the day before Election Day and received by your county board of elections no later than 10 days after the election. By state law, a postmark does not include a date marked by a postage evidence system such as a postage meter. The U.S. Postal Service (USPS) estimates that it may take two to five days for your voted absentee ballot to be delivered to your board of elections by mail.

If you are returning your voted ballot by mail during the week before Election Day, you should take it to USPS no later than the day before Election Day and ensure it receives a postmark as follows:

If you use a postage label purchased at a USPS customer service window or vending machine, the date on the label is the postmark. This is the USPS-recommended way to postmark your ballot. If you use postage stamps, ask that it be postmarked. You should not use a postage meter or an online service (such as stamps.com) to affix postage.

It is your responsibility to make sure the ballot has enough postage.

If you return your ballot to the board in person, or if a near relative* delivers it for you, the board of elections must receive your ballot no later than 7:30 p.m. on Election Day. If you are a member of the uniformed services or a voter outside of the United States, the ballot must be mailed not later than 12:01 a.m. on Election Day at the place where you are located.

[kcoronel]

@Seymour100 I made the edits, thank you!

[aNullValue]

I have copied this state's data for review and import into the production database. Do not make any further changes to this state's data in Google Drive.

[aNullValue]

FWIW, I made extensive adjustments to this data prior to import, including address corrections, hour corrections, website URL normalization.