UNlocations: United Nations Table of Locations

Description Usage Format Source Examples

Description

United Nations table of locations, including regions, for statistical purposes as available in 2017.

Usage

1
2

Format

A data frame with one observations per country or region. It contains the following variables:

name

Name of country or region (following ISO 3166 official short names in English - see
https://www.iso.org/obp/ui/#search/code/ and United Nations Multilingual Terminology Database - see https://unterm.un.org/unterm).

country_code

Numerical Location Code (3-digit codes following ISO 3166-1 numeric standard) - see http://en.wikipedia.org/wiki/ISO_3166-1_numeric.

reg_code

Code of the regions.

reg_name

Name of the regions.

area_code

Area code.

area_name

Area names, such as Africa, Asia, Europe Latin America and the Caribbean, Northern America, Oceania, World.

location_type

Code giving the type of the observation: 0=World, 2=Major Area, 3=Region, 4=Country/Area, 5=Development group, 12=Special groupings. Other numbers are allowed and they can be used for aggregation, see below.

agcode_1500, agcode_1501, agcode_1502, agcode_1503, agcode_1517, agcode_901, agcode_902, agcode_921, agcode_934, agcode_941, agcode_947, agcode_948

Optional columns that can be used for aggregations. To aggregate a region with country_code=x, get the value of its location_type, say y. Then look for the column agcode_y and locate all records with agcode_y=x that have location_type=4, see Example below.

Source

Data provided by the United Nations Population Division.

The designations employed in this dataset do not imply the expression of any opinion whatsoever on the part of the Secretariat of the United Nations concerning the legal status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries.

Examples

1
2
3
4
5
6
data(UNlocations)
# Find high income countries in Africa (based on World Bank groups)
grouprec <- subset(UNlocations, name == "High-income countries")
# grouprec$location_type is 1503, thus look for column agcode_1503 
subset(UNlocations, agcode_1503 == grouprec$country_code & 
                            location_type == 4 & area_name == "Africa")

Example output

                name country_code reg_code       reg_name area_code area_name
29        Seychelles          690      910 Eastern Africa       903    Africa
43 Equatorial Guinea          226      911  Middle Africa       903    Africa
   location_type agcode_1500 agcode_1501 agcode_1502 agcode_1503 agcode_1517
29             4          -1          -1          -1        1503          -1
43             4          -1          -1          -1        1503          -1
   agcode_901 agcode_902 agcode_921 agcode_934 agcode_941 agcode_947 agcode_948
29         -1        902         -1        934         -1        947        948
43         -1        902         -1         -1        941        947        948

wpp2017 documentation built on Feb. 10, 2020, 9:07 a.m.