I am looking for a simple CSV with the list of country names, country ISO codes, city, time zone UTC and DST... It seems simple, but I am struggling to find it. Any advice/help would be very much appreciated.

  • 1
    Many countries have more than one time zone (Russia has 11) – how would you want the data to handle this? You could use a single time zone for the national capital, or have multiple rows for each country, but this complexity might be one reason you're struggling to find all the information in a single dataset.
    – Matt Ashby
    Sep 23, 2021 at 13:57
  • Thanks @MattAshby for your comment... You are right indeed. Actually my request concerns any type of structured data related to time zones. I will update my question to reflect that: country code and city.
    – Pitouille
    Sep 23, 2021 at 14:00

2 Answers 2


There is IANA tzdb with a list of all timezones. It's quite complex and changing since timezones change too, for example in Russia timezones changed several times during the last 20 years.


geonames offers this both through their API and bulk dumps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.