countries-states-cities-database
countries-states-cities-database copied to clipboard
Typographic mistakes & missing gmt in Timezone data
1/ GmtOffset & GmtOffsetName wrong TimeZone (UTC+13:45) There is no country currently using UTC+13:45. In your project, this UTC Timezone is related to New Zealand which uses UTC+12:45 which also happens to be missing from the list of timezones.
2/ GmtOffset & GmtOffsetName missing TimeZone (UTC−12:00) This is a timezone for United States Minor Outlying Islands which are currently listed in your project as UTC+12:00 with a "+" instead of "-". There are 37 unique gmtOffsetNames and there should be a total of 38, that's what led me to search for inconsistencies.
3/ Timezone Names typographic errors While i was trying to normalize timezone data i decided to check for inconsistencies to sanitize. This is no big deal (mostly missing parenthesis) but it sits in the way of anyone trying to manipulate this data.
- "Pacific Standard Time (North America" (missing closing parenthesis)
- "Mountain Standard Time (North America" (missing closing parenthesis)
- "Eastern Standard Time (North America" (missing closing parenthesis)
- "Central Standard Time (North America" (missing closing parenthesis)
- Two different spellings for Brazilia time "Brasilia Time" vs "Brasília Time" (the difference is in the letter "i")
- "Bougainville Standard Time[6" (remove unneccessary "[6" sequence from the string)
- Two different spellings for Amazon Time in "Amazon Time (Brazil)" and "Amazon Time (Brazil)[3" (remove unnecessary "[3" sequence from the string)
- "Alma-Ata Time[1" (Remove unnecessary "[1" sequence from the string)