Maryland

[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] 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] name to location_type
    • [x] validate_url to source_data
  • [x] To Do:
  • [x] fill out state_2 (more details below)
  • [ ] 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

[Arjayellis]

@javaprincess

• Address needs to be broken up into individual components (please see the last action item in the text above)
• What is the purpose of the two numbers per location? Do they both direct to the same place?
• Please add days of the week for the hours section

[aNullValue]

For what it's worth, Maryland's county locations only included their "Early Voting Locations". I found their elections offices in a separate spreadsheet, and then downloaded their "Election Day Vote Center" and "Drop box" lists from their website, and spent a while reformatting it all. So Maryland no longer looks anything like what it did.

[kcoronel]

Just noticed that @aNullValue, THANK YOU! I added the necessary columns, do you know if hours are Mon-Friday? I can add it

[aNullValue]

I'll take it from here. >_< I already downloaded it from the spreadsheet, and just forgot to comment. Sorry.