Illinois

[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] latitude
  • [x] longitude
  • [x] social
  • [x] state and counties and county reps copy
• [x] Rename the following fields
  • [x] Field 23 to location_name
  • [x] validate_url to source_data
• [ ] Change the hour format from MON - FRI: 7:30 AM - 12:00 PM, 1:00 PM - 4:30 PM 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;MONDAY-FRIDAY:1:00 PM-4:30PM or Monday-Friday:7:00-12:00;MONDAY-FRIDAY:13:00-16:3

Resources/Instructions

Google sheet

[Seymour100]

How do you want to represent 24/7?

[Arjayellis]

I would just do:

Monday-Sunday: 12AM-11PM

Just so we stay consistent.

@aNullValue What do you think?

[aNullValue]

"Monday-Sunday:00:00-23:59" would work. 12h times are fine too, but just saying 11pm would indicate that it's closed for an hour.

[Arjayellis]

Sorry, I meant to say 12AM to 12AM.

[Seymour100]

I changed the syntax to 12AM-12PM.

A few notes about this state:

1. there are many dates in the "hours" field. I see we have added a start date column, but there are numerous instances of "ends at 7PM on election day". I've left those as is. Some don't even list the day of the week, but the calendar date.

2. Where there are "except holidays" notes I left them (although I'm thinking that there is only Columbus day in Oct.)

3. Some counties uploaded a table of their hours. So one Monday is a separate entry from another Monday. In these instances there are multiple records for the same address.

If you want specific changes to these scenarios LMK.

[kcoronel]

@aNullValue @Seymour100 I changed the format for hours, to be recognized in one location, ping me if you need more info

[aNullValue]

Illinois must be revisited. The majority of their jurisdictions are missing from the provided file, and no jurisdictions had contact info.

I processed the file anyway, but... I'd rather just delete it all and begin again. :-\

[Seymour100]

I'll try to take a look at it this weekend. I'm guessing because I scraped the dropbox page, which is separate from the jurisdictions page, that not every jurisdiction had a dropbox.

[Seymour100]

@aNullValue , I added a second sheet "Jurisdiction Offices" to the Illinois Google Sheet with the details of their offices and contacts. Note the last 6 records aren't counties but cities.