Connecticut

[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
• [x] Remove Names of locations from address_1 field
• [x] Remove PO box addresses from address_1 field (text only from those cells, not the row itself)
• [x] Add zip code to zip_code column (if available) and remove city name
• [x] Add hours (if available) in below format Monday-Friday:7:00AM-12:00PM 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):

Resources

Google Sheet

[Arjayellis]

Additional list of secured drop boxes posted. Looks mostly the same as our scrape https://www.acluct.org/sites/default/files/field_documents/connecticut_secure_absentee_ballot_drop_box_locations_for_nov._3_2020_election_-_sheet1_2.pdf

[aNullValue]

Connecticut has been processed.