Geoname Timezones

DataHerb Metadata

DataHerb ID: geonames_timezone
DataHerb Name: Geoname Timezones
Contributors: Datumorphism
Description: IANA Timezone IDs in different countries from Geonames
GitHub Repository: datumorphism/geonames-timezones

DataHerb Leaves: Files in Dataset

Name: timezones in csv format
File:
Format: csv
Size: 14K

Fields

country_code: Alpha 2 country code
timezone_id: IANA timezone id, www.iana.org
gmt_offset: GMT offset in January 1st
dst_offset: Day light saving offset in July 1st
raw_offset: Raw offset, independant of DST

Preview

Import Data

Copy the following code and paste into a Google Spreadsheet cell.

=IMPORTDATA("https://raw.githubusercontent.com/datumorphism/geonames-timezones/master/dataset/geonames_timezone.csv")

Load data into a Pandas DataFrame:

import pandas as pd
url = "https://raw.githubusercontent.com/datumorphism/geonames-timezones/master/dataset/geonames_timezone.csv"
df = pd.read_csv(url)

File:
Format: json
Size: 58K

Fields

country_code: Alpha 2 country code
timezone_id: IANA timezone id, www.iana.org
gmt_offset: GMT offset in January 1st
dst_offset: Day light saving offset in July 1st
raw_offset: Raw offset, independant of DST

Import Data

Load data into a Pandas DataFrame:

import pandas as pd
url = "https://raw.githubusercontent.com/datumorphism/geonames-timezones/master/dataset/geonames_timezone.json"
df = pd.read_json(url)

References:

Geonames Download Server