Florida

[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] Add the following columns to you spreadsheet
  • [x] display_notes
  • [x] where
  • [x] start_date
  • [x] accessibility
• [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
• [ ] Remove all PO box locations (addresses only in each individual cell - not the row itself)
• [x] Combine "UPSzip" column with "zip_code" column (keep only necessary zip numbers)
• [ ] Add hours in below format to 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:7:00AM-12:00PM
• [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

[bartleyn]

1) do we have to get rid of PO box if this is info for county officials? 2) does the hours column need to be populated since this is county officials?

[Arjayellis]

@bartleyn we decided that officials are not relevant for the purpose of this project. Hours are necessary for validation. For PO boxes, we only care about physical locations, so they do not matter any longer.

[bartleyn]

I've gone through and tried to put in a ton of early voting sites with their dropboxes, but in the interest of time I didn't do all the early voting sites for all the counties. I have verified each address however in the spreadsheet