The CSV (comma-separated values) files below are meant for bulk processing in statistical softwares (like R and Stata) and databases.

These CSV files are encoded in UTF-8 and all of them have the following columns:

LocID (numeric): numeric code for the location; for countries and areas, it follows the ISO 3166-1 numeric standard
Location (string): name of the region, subregion, country or area
VarID (numeric): numeric code for the variant
Variant (string): projection variant name (Medium is the most used)
Time (string): label identifying the single year (e.g. 1950) or the period of the data (e.g. 1950-1955)
MidPeriod (numeric): numeric value identifying the mid period of the data, with the decimal representing the month (e.g. 1950.5 for July 1950)

Use the LocID, VarID and Time columns to link the data accross the different files, if necessary. Note that Time differs between single year (e.g. 1950) and period (e.g. 1950-1955) data.

For the files with data separated by age, the following columns are available:

AgeGrp (string): label identifying the single age (e.g. 15) or age group (e.g. 15-19)
AgeGrpStart (numeric): initial age of the age group
AgeGrpSpan (numeric): length of the age group, in years

Refer to each file listed below for a description of it's specific data columns.

Please note these files don't include footnotes, please refer to the Excel files for notes that apply to the regions, subregions, countries or areas listed in the CSV files.

World Population Prospects 2017

Leave feedback about this page