Skip to main content
Skip to main content

IANA Time Zone Database — Every Tz Zone With Countries, Coordinates, UTC Offsets And Comments

DatasetCSV.GZOpenTime ZonesIanaTzReferenceGeographyCalendarFree

419 time zones from the IANA tz database with the ISO 3166 codes of every country each zone covers, the primary country, decimal latitude and longitude of the principal location, the UTC offsets in force in January and July 2026, whether the zone has kept distinct clocks since 1970 (zone1970.tab) and the maintainers' comments, from the tz project's zone.tab and zone1970.tab as of 2026-09-06.

Use Cases

  • Time-zone pickers and validation
  • Country to zone mapping
  • Scheduling and offset lookups
  • Zone-centroid geocoding fallbacks

Methodology

zone.tab and zone1970.tab merged on zone name; ISO 6709 ±DDMM±DDDMM / ±DDMMSS±DDDMMSS coordinates converted to decimal degrees; January and July UTC offsets computed with the tz data bundled in Node.js ICU (tzdata 2025c); sorted by zone name.

Update Schedule

Static snapshot. IANA releases tz updates a few times a year; refresh monthly.

Attribution

Source: IANA Time Zone Database (tz project, github.com/eggert/tz), zone.tab and zone1970.tab; public domain.

Schema

nametype
tz_namestring
country_codesstring
primary_countrystring
latitudenumber
longitudenumber
utc_offset_januarystring
utc_offset_julystring
distinct_since_1970boolean
commentsstring

Sample Data

tz_namecommentslatitudelongitudecountry_codesprimary_countryutc_offset_julyutc_offset_januarydistinct_since_1970
Africa/Abidjan5.3167-4.0333CI;BF;GH;GM;GN;IS;ML;MR;SH;SL;SN;TGCI+00:00+00:00true
Africa/Accra5.55-0.2167GHGH+00:00+00:00false
Africa/Addis_Ababa9.033338.7ETET+03:00+03:00false
Africa/Algiers36.78333.05DZDZ+01:00+01:00true
Africa/Asmara15.333338.8833ERER+03:00+03:00false

Get this via API

# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
#    Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
#    Cursor / Claude Code / others: mcp.json
{
  "mcpServers": {
    "dagentbase": {
      "url": "https://dagentbase.com/api/mcp",
      "headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
    }
  }
}

# 2. Then ask your agent, in plain language:
#    "Preview 'IANA Time Zone Database — Every tz Zone with Countries, Coordinates, UTC Offsets and Comments' and, if it fits, claim it and download the files."
#    Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls

# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
#    Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
#    Cursor / Claude Code / others: mcp.json
{
  "mcpServers": {
    "dagentbase": {
      "url": "https://dagentbase.com/api/mcp",
      "headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
    }
  }
}

# 2. Then ask your agent, in plain language:
#    "Preview 'IANA Time Zone Database — Every tz Zone with Countries, Coordinates, UTC Offsets and Comments' and, if it fits, claim it and download the files."
#    Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls
Free

one time · open license

Details

Rows419
Size10.2 KB
Files1
FormatCSV.GZ

Available formats

CSV.GZ10.2 KB
Freeopen