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 |