How to export a filtered country list — examples & tool tips
Every tab has an Export CSV button. It downloads exactly the rows currently shown in the table — all filters, dropdowns, and search terms are applied before export. The file is UTF-8 CSV, compatible with Excel, R (readr/read.csv), Python (pandas), Stata, SPSS, and Power BI. The filename includes the classification system and row count so you always know what you downloaded.
UN M49 / Geoscheme — examples
Set Special group → LDC only → Export → columns:
country_name_en, iso3, iso2, m49, region, sub_region, intermediate_region, is_ldc, is_lldc, is_sids.
Useful as a master list for any analysis that requires UN M49 codes alongside LDC/LLDC/SIDS flags.
Set UN Sub-region → Eastern Africa → Export → precise 20-country list with full geographic hierarchy. Combine with the search box to further narrow by name.
World Bank — examples
Set Income level → Low income + WB Region → Sub-Saharan Africa → Export → the exact list used in World Bank operational and poverty targeting work.
Set Lending type → IDA → Export → countries eligible for concessional IDA financing (
wb_income_name, wb_lending_name, capital_city included per row).
Set Income level → Upper middle income → Export → used to identify countries approaching high-income status or recently graduated from ODA eligibility.
OECD DAC — examples
Set DAC group → LDCs + UN Region → Africa → Export → columns include
dac_group, wb_income_hint, reporting_year.
Use directly for ODA targeting, donor reporting, or OECD peer-review submissions.
No filter needed — the
reporting_year column in the export shows the year each country
was added to or last confirmed on the DAC list.
World Bank FCS — examples
Set Category → Conflict → Export → 21-country list with
wb_region, wb_income_name, wb_fcs_category, wb_fcs_fy.
Useful for humanitarian programming, risk analysis, and IDA conflict windows.
Set WB Region → Sub-Saharan Africa (or any region) → Export → fragile and conflict-affected states within that region only. Combine with Category filter to separate Conflict from Institutional Fragility.
UN SDG Regions — examples
Select e.g. Sub-Saharan Africa in the SDG group dropdown → Export → 53-country list. The
sdg_groups column lists all groups each country belongs to,
separated by ; — so one row per country, all memberships visible at once.
Excel: select the column → Data → Text to Columns → delimiter
;R:
tidyr::separate_rows(df, sdg_groups, sep = ";")Python:
df["sdg_groups"].str.split(";").explode().reset_index(drop=True)Stata:
split sdg_groups, parse(";")Power BI: Split Column → By Delimiter
; → Into Rows
General tips
The Showing box and the Export CSV note both display the exact row count. If the count looks wrong, check your active filters — each dropdown narrows the list independently.
Clear all filters (reload the page) then export — or go to the Downloads page to get pre-built full CSVs and JSON files with permanent raw GitHub URLs for scripting.
UN M49 Standard Country or Area Codes
The foundational UN classification system published by the UN Statistics Division (UNSD). Covers all 248 UN statistical countries and areas — including territories and dependencies that may not be members of the UN or classified by the World Bank or OECD. Provides the global geoscheme (global → region → sub-region → intermediate region), plus three special designations: LDC (Least Developed Countries), LLDC (Landlocked Developing Countries), and SIDS (Small Island Developing States).
Countries by UN Region
Special Designations
| Country / Area | ISO3 | ISO2 | M49 | UN Region | UN Sub-region | Intermediate Region | LDC | LLDC | SIDS |
|---|