States, provinces and regions of every country (ISO 3166-2)
The states, provinces, regions, departments and other subdivisions of every country that have an ISO 3166-2 code, with their type, parent subdivision, capital, population, area and coordinates. One row per ISO 3166-2 code.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| code | ISO 3166-2 | string | ISO 3166-2 subdivision code (country alpha-2 code, hyphen, subdivision code). |
| name | Name | string | — |
| entity | Wikidata | entity | — |
| country | Country | country | ISO 3166-1 alpha-3 code of the country (Wikidata P17). |
| country_name | Country name | string | — |
| type | Type | string | Kind of subdivision (Wikidata P31), e.g. state, province, region. |
| parent | Part of | string | The subdivision or country it lies in (Wikidata P131). |
| parent_code | Parent code | string | ISO 3166-2 code of the parent subdivision, when it has one. |
| capital | Capital | string | Capital or administrative seat (Wikidata P36). |
| population | Population | integer | Most recent population figure in Wikidata. |
| population_year | Population year | year | — |
| area_km2 | Area | number · km² | — |
| lat | Latitude | number | — |
| lon | Longitude | number | — |
More in Countries & Places
Central bank policy interest rates by country, monthly since 1945
The main policy interest rate set by about 40 central banks — the Federal Reserve, the European Central Bank, the Bank of England, the Bank of Japan and others — at the end of every month, as collected by the Bank for International Settlements. One row is one central bank's rate in one month.
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.
U.S. colleges and universities: enrollment, admission rate, graduation rate and tuition
Every active degree-granting college and university in the United States and its territories, from the federal IPEDS survey: location, sector, Carnegie classification, total, undergraduate and graduate enrollment, admission rate, retention and graduation rates, student-to-faculty ratio and published tuition. One row is one institution.
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 100 metres, as recorded in Wikidata. One row per building.
Orbital launches by country and year
Number of orbital and deep-space launch attempts per country per year since 1957, split into successes and failures, with the payload mass delivered to orbit. One row per country per year.