Time zones of the world
Every time zone in the IANA Time Zone Database (the tz database used by computers and phones worldwide), with the countries it covers, its standard UTC offset, whether it currently observes daylight saving time, and the coordinates of its principal city. One row per tz zone.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| zone | Zone | string | tz zone name, e.g. 'Europe/Paris'. |
| area | Area | string | Continent or ocean part of the zone name. |
| country | Country | country | Country of the zone's principal location (first listed). |
| countries | Countries | string | All countries and territories whose clocks follow this zone (ISO 3166 names as given in the tz database). |
| country_codes | Country codes | string | ISO 3166-1 alpha-2 codes as listed in zone1970.tab. |
| comment | Comment | string | The tz database's note on which part of the country the zone covers, where several zones exist. |
| utc_offset_hours | UTC offset | number · hours | Standard offset from UTC in hours (negative = west of Greenwich). |
| utc_offset | Offset | string | Standard offset written as UTC±hh:mm. |
| observes_dst | Daylight saving | boolean | Whether the zone currently has ongoing daylight-saving rules. |
| dst_save_hours | DST saving | number · hours | Clock change while daylight saving is in effect (usually +1). |
| dst_offset | DST offset | string | Offset from UTC while daylight saving is in effect. |
| rule_set | Rule set | string | Name of the tz rule set the zone follows ('-' = none). |
| abbreviation_format | Abbreviation format | string | The tz FORMAT field, e.g. 'CE%sT' (CET/CEST) or '%z' (numeric). |
| lat | Latitude | number | — |
| lon | Longitude | number | — |
More in Countries & Places
Operating power plants in the United States
Every operating U.S. power plant with at least 1 MW of generating capacity, from the EIA's monthly generator inventory (Form EIA-860M): location, operator, main technology, capacity and first year online. One row per plant, summed from its generators.
Major battles in history
Battles recorded in Wikidata that have articles in at least 10 language editions of Wikipedia, with date, the war each was part of, location, present-day country, coordinates, participants and deaths where recorded. One row per battle.
Tallest buildings in the world
Completed buildings and skyscrapers with an architectural height of at least 120 metres, as recorded in Wikidata. One row per building.
Countries of the world: key economic and social indicators
Every country with its region, income group and capital, plus the latest available value and year of 20 World Bank indicators from population and GDP to life expectancy, CO₂ per person and inequality. One row per country.
Countries of the world
Every present-day sovereign state with its ISO codes, capital, continent, area, population, official languages, currency, head of state and government, founding date, calling code, internet domain and flag. One row per country.
World population, 1960 to present
Total population of the world each year since 1960, with the annual growth rate. One row per year.