Oregon

[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 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] state_2 (instructions to follow below)
  • [x] Delete the following fields
    • [x] record_number
    • [x] county_state
    • [x] name
    • [x] social
    • [x] scraper
    • [x] locations_copy
    • [x] volunteers_scraper_copy
  • [x] Rename the following fields
    • [x] ballot_dropoff_location to has_dropoff_location
    • [x] validate_url to source_data
  • [x] Remove all PO box locations (addresses only - not the row)
  • [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
• [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 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

[Arjayellis]

New ballot drop locations just posted https://sos.oregon.gov/voting/Documents/Oregon-Dropsites-Public.pdf @scaress21 Would you be able to scrape this?

[scaress21]

I can scrape this today!

[Arjayellis]

Thank you! @scaress21

[kcoronel]

@scaress21 not seeing the scrape for the new locations in the sheet titled officials, let me know if it is somewhere else

[Seymour100]

I added another tab in this file that representing the URL above. I put column in it that compares address_1 to the old address_1. It doesn't look to me like there have been any changes, just a couple of edits. I also tried to format the hours for this one.

[aNullValue]

@kcoronel you were probably looking at Oregon County Officials: https://docs.google.com/spreadsheets/d/1o8bb-JvmzVRLKb47B4cWRZanTGb7bq5wDDB_rD94aO4/edit#gid=874271103

Whereas @Seymour100 was working in Oregon County Locations: https://docs.google.com/spreadsheets/d/1FB4mRNkcXbUhLRoIT8bY-SA8XJaCp-uvmc8OJpfbEro/edit#gid=1681823373

It appears to me as though I should use the locations that Seymour put in "County Locations" and the phone/fax/email from "County Officials". If that makes sense to you, go ahead and move this to ready-to-import, and I'll do it this evening.

[scaress21]

Since this looked to be locations rather than officials I saved it in a new sheet “Oregon County Location”

[aNullValue]

Oregon has been processed.