search

dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.32k stars 2.55k forks source link

Wrong column mapping in countries.csv file #177

Closed miststudent2011 closed 3 years ago

miststudent2011 commented 3 years ago
id name iso3 iso2 phone_code capital currency currency_symbol native region subregion translations latitude longitude emoji emojiU
1 Afghanistan AFG AF 93 Kabul AFN ؋ افغانستان Asia Southern Asia [{zoneName:'Asia\/Kabul',gmtOffset:16200,gmtOffsetName:'UTC+04:30',abbreviation:'AFT',tzName:'Afghanistan Time'}] 33.00000000 65.00000000 🇦🇫 U+1F1E6 U+1F1EB
2 Aland Islands ALA AX +358-18 Mariehamn EUR € Åland Europe Northern Europe [{zoneName:'Europe\/Mariehamn',gmtOffset:7200,gmtOffsetName:'UTC+02:00',abbreviation:'EET',tzName:'Eastern European Time'}] 60.11666700 19.90000000 🇦🇽 U+1F1E6 U+1F1FD

Wrong column mapping in countries.csv file , timezone values are mapped to translations and translations data is not present in the csv file where as it is present in json file.

dr5hn commented 3 years ago

@miststudent2011 Thanks for reporting. 👍🏼

Will fix it soon. 🎉