Data Information

Country and Area Name Normalization

Since the names are formatted differently in each organzation we decided to store the original name string on the record so there would be no confusion on the area the record is referring to. In order for the relationships to work between the different datasets we made a connonical list of country names. The original name on the record is stored under the area_name attribute on each record.

Country Name in Database Countries Retrieved with Name
Bahamas Bahamas, The
Bolivia (Plurinational State of) Bolivia
Central African Republic Central African Rep.
China China, People's Republic of
Christmas Island Christmas Is.(Aust)
Congo Congo, Rep.
C├┤te d'Ivoire Cote d'Ivoire
Democratic People's Republic of Korea Dem. People's Rep. of Korea
Korea, Dem. Rep.
Korea,Dem.Ppl's.Rep.
Democratic Republic of the Congo Congo, Dem. Rep.
Dem. Rep. of Congo
Congo (Democratic Republic of the)
Dominican Republic Dominican Rep.
Egypt Egypt, Arab Rep.
Falkland Islands Falkland Is. (Malvinas)
Gambia Gambia, The
Hong Kong SAR, China Hong Kong SAR
Hong Kong, China
China, Hong Kong SAR
China: Hong Kong SAR
Iran (Islamic Republic of) Iran (Islamic Rep. of)
Iran, Islamic Rep.
Iran, Islamic Republic of
Iran(Islamic Rep. of)
Kyrgyzstan Kyrgyz Republic
Lao People's Democratic Republic Lao P.D.R. Lao PDR Lao People's Dem. Rep.
Libya Libya Republic of Jamahiriya
Macao SAR, China Macao, China
Macau (SAR)
China, Macao SAR
China: Macao SAR
Micronesia (Federated States of) Micronesia (Fed. States of)
Micronesia, Fed. Sts.
Micronesia, Fed.States of
Northern Mariana Islands Northern Marianas Islands
Republic of Korea Korea (Rep. of) Korea, Rep. Korea, Republic of
Republic of Moldova
Russian Federation Russia
Saint Helena and Dependencies St. Helena and Depend.
Saint Kitts and Nevis St. Kitts and Nevis
St. Kitts-Nevis
Saint Lucia St. Lucia
Saint Pierre and Miquelon St. Pierre-Miquelon
Saint Vincent and the Grenadines St. Vincent and the Grenadines
St. Vincent-Grenadines
Switzerland and Liechtenstein Switzrld,Liechtenstein
Syrian Arab Republic Syria
The former Yugoslav Republic of Macedonia T.F.Y.R. Macedonia
The Former Yugoslav Rep. of Macedonia
Macedonia, FYR
T.F.Yug.Rep. Macedonia
Timor-Leste East Timor
United Kingdom United Kingdom of Great Britain and Northern Ireland
United Republic of Tanzania Tanzania
United Rep.Tanzania
United States of America United States
Venezuela (Bolivarian Republic of) Venezuela
Venezuela, RB
Viet Nam Vietnam
Virgin Islands (U.S.) United States Virgin Is.
Yemen Yemen, Rep.
Former Democratic Yemen Yemen: Former Democratic Yemen
Former Yemen Arab Republic Yemen: Former Yemen Arab Republic
Wallis and Futuna Island Wallis & Futuna Islands