World Country Reference Table (join
A clean join-key table that ties together every country-keyed dataset in the catalog: one row per country with ISO-2 / ISO-3 codes, a canonical name, continent, UN region and subregion, population and GDP estimates, and a map centroid (lat/lon). Drop it next to any country-coded table and you have instant region rollups, map labels and human-readable names - assembled from Natural Earth (public domain, no restrictions).
- Source
- Natural Earth
- Licence
- Redistributable open data
- Quality
- QC clean · 0 failures
- Format
- Apache Parquet + dictionary
Safe to train on
Built only from a named, redistributable official source under a documented open licence - not scraped web data. No copyright grey zone, no personal data. Ships machine-readable Croissant metadata (ML Commons - loads in Hugging Face / Kaggle / Google), an AI training-licence manifest documenting source, licence and provenance for your model's data governance, and a machine-readable data dictionary (drop it into an agent / RAG prompt so the model knows every column) - all inspectable before you buy.
What's included
- One row per country - the universal join key for every country-keyed dataset
- ISO 3166-1 alpha-2 and alpha-3 codes, canonical name
- Continent, UN region and subregion for instant geographic rollups
- Population and GDP (million USD) estimates + map centroid (lat/lon)
- Source: Natural Earth - public domain, free for any use
Schema
| Column | Type | Description | Filled | Distinct |
|---|---|---|---|---|
| iso_a3 | str | ISO 3166-1 alpha-3 code (primary key) | 100.0% | 172 |
| iso_a2 | str | ISO 3166-1 alpha-2 code | 100.0% | 172 |
| name | str | Country name (long form where available) | 100.0% | 172 |
| continent | str | Continent | 100.0% | 8 |
| region | str | UN region (REGION_UN) | 100.0% | 6 |
| subregion | str | UN subregion | 100.0% | 22 |
| pop_est | int | Population estimate | 100.0% | 172 |
| gdp_musd | int | GDP estimate, million USD | 100.0% | 172 |
| lat | float | Centroid latitude (LABEL_Y / bbox center) | 100.0% | 172 |
| lon | float | Centroid longitude (LABEL_X / bbox center) | 100.0% | 172 |
Sample & preview
Every purchase ships as Apache Parquet with a data dictionary and the full QC report. A free sample (first rows + schema) is downloadable here - confirm fit before you buy. Source: Natural Earth (redistributable open data; attribution passes through - see our Licence).
Don't trust screenshots - drop the sample into your notebook right now.
import pandas as pd df = pd.read_parquet("world-country-reference_sample.parquet") df.info() # typed columns, gap-aware, ready to join⬇ Download free Parquet sample or CSV for Excel
Related datasets
EU Business Formation Dynamics
Net business creation across Europe: enterprise births, deaths, active-population, birth/death/churn rates, net population growth, jobs created & lost, and 1/3/5-year survival rates - by country x NACE sector x year, 2009-2023. Sourced from Eurostat Business Demography (bd_size), cleaned to one tidy Parquet panel. Aggregate flows only, no company-level data.
European Power Plant Registry
Every conventional power plant in Europe in one clean table: name, operator, country, net capacity, fuel/technology, commissioning year and location - assembled and de-duplicated from Open Power System Data. The asset reference table that joins to generation, capacity and carbon analytics by country and fuel.
Global Cities Gazetteer (GeoNames, pop ≥ 1,000)
Every populated place on Earth with population ≥ 1,000 - ~150k cities and towns - in one clean, geocoded table. GeoNames ships it as a header-less tab-delimited dump; we parse it to a tidy row per place: name (+ ASCII), country, admin-1/2 codes, population, elevation, timezone and lat/lon. The universal populated-place join key (name ⋈ country ⋈ coordinates) that geocodes or enriches any geo dataset. CC-BY 4.0.