notebooks/dataprep/00e-GeoNamesCountry.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Countries"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**[Work in progress]**\n",
    "\n",
    "This notebook creates a .csv file with country information for ingestion into the Knowledge Graph.\n",
    "\n",
    "Data source: [GeoNames.org](https://download.geonames.org/export/dump/)\n",
    "\n",
    "Author: Peter Rose (pwrose@ucsd.edu)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "from pathlib import Path\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.options.display.max_rows = None  # display all rows\n",
    "pd.options.display.max_columns = None  # display all columsns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/Users/peter/Library/Application Support/Neo4j Desktop/Application/neo4jDatabases/database-19636412-9e74-4bac-8a4c-c6c8b49bb9d3/installation-4.1.0/import\n"
     ]
    }
   ],
   "source": [
    "NEO4J_IMPORT = Path(os.getenv('NEO4J_IMPORT'))\n",
    "print(NEO4J_IMPORT)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Create countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "country_url = 'https://download.geonames.org/export/dump/countryInfo.txt'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "names = ['ISO','ISO3','ISO-Numeric','fips','Country','Capital','Area(in sq km)','Population',\n",
    "         'Continent','tld','CurrencyCode','CurrencyName','Phone','Postal Code Format',\n",
    "         'Postal Code Regex','Languages','geonameid','neighbours','EquivalentFipsCode'\n",
    "        ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = pd.read_csv(country_url, sep='\\t',comment='#', dtype='str', names=names)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Add missing data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Add missing iso code for Namibia"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ISO</th>\n",
       "      <th>ISO3</th>\n",
       "      <th>ISO-Numeric</th>\n",
       "      <th>fips</th>\n",
       "      <th>Country</th>\n",
       "      <th>Capital</th>\n",
       "      <th>Area(in sq km)</th>\n",
       "      <th>Population</th>\n",
       "      <th>Continent</th>\n",
       "      <th>tld</th>\n",
       "      <th>CurrencyCode</th>\n",
       "      <th>CurrencyName</th>\n",
       "      <th>Phone</th>\n",
       "      <th>Postal Code Format</th>\n",
       "      <th>Postal Code Regex</th>\n",
       "      <th>Languages</th>\n",
       "      <th>geonameid</th>\n",
       "      <th>neighbours</th>\n",
       "      <th>EquivalentFipsCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AD</td>\n",
       "      <td>AND</td>\n",
       "      <td>020</td>\n",
       "      <td>AN</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>Andorra la Vella</td>\n",
       "      <td>468</td>\n",
       "      <td>77006</td>\n",
       "      <td>EU</td>\n",
       "      <td>.ad</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Euro</td>\n",
       "      <td>376</td>\n",
       "      <td>AD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AE</td>\n",
       "      <td>ARE</td>\n",
       "      <td>784</td>\n",
       "      <td>AE</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>82880</td>\n",
       "      <td>9630959</td>\n",
       "      <td>AS</td>\n",
       "      <td>.ae</td>\n",
       "      <td>AED</td>\n",
       "      <td>Dirham</td>\n",
       "      <td>971</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ar-AE,fa,en,hi,ur</td>\n",
       "      <td>290557</td>\n",
       "      <td>SA,OM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AF</td>\n",
       "      <td>AFG</td>\n",
       "      <td>004</td>\n",
       "      <td>AF</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Kabul</td>\n",
       "      <td>647500</td>\n",
       "      <td>37172386</td>\n",
       "      <td>AS</td>\n",
       "      <td>.af</td>\n",
       "      <td>AFN</td>\n",
       "      <td>Afghani</td>\n",
       "      <td>93</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>fa-AF,ps,uz-AF,tk</td>\n",
       "      <td>1149361</td>\n",
       "      <td>TM,CN,IR,TJ,PK,UZ</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AG</td>\n",
       "      <td>ATG</td>\n",
       "      <td>028</td>\n",
       "      <td>AC</td>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>St. John's</td>\n",
       "      <td>443</td>\n",
       "      <td>96286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.ag</td>\n",
       "      <td>XCD</td>\n",
       "      <td>Dollar</td>\n",
       "      <td>+1-268</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>en-AG</td>\n",
       "      <td>3576396</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AI</td>\n",
       "      <td>AIA</td>\n",
       "      <td>660</td>\n",
       "      <td>AV</td>\n",
       "      <td>Anguilla</td>\n",
       "      <td>The Valley</td>\n",
       "      <td>102</td>\n",
       "      <td>13254</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.ai</td>\n",
       "      <td>XCD</td>\n",
       "      <td>Dollar</td>\n",
       "      <td>+1-264</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>en-AI</td>\n",
       "      <td>3573511</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ISO ISO3 ISO-Numeric fips               Country           Capital  \\\n",
       "0  AD  AND         020   AN               Andorra  Andorra la Vella   \n",
       "1  AE  ARE         784   AE  United Arab Emirates         Abu Dhabi   \n",
       "2  AF  AFG         004   AF           Afghanistan             Kabul   \n",
       "3  AG  ATG         028   AC   Antigua and Barbuda        St. John's   \n",
       "4  AI  AIA         660   AV              Anguilla        The Valley   \n",
       "\n",
       "  Area(in sq km) Population Continent  tld CurrencyCode CurrencyName   Phone  \\\n",
       "0            468      77006        EU  .ad          EUR         Euro     376   \n",
       "1          82880    9630959        AS  .ae          AED       Dirham     971   \n",
       "2         647500   37172386        AS  .af          AFN      Afghani      93   \n",
       "3            443      96286       NaN  .ag          XCD       Dollar  +1-268   \n",
       "4            102      13254       NaN  .ai          XCD       Dollar  +1-264   \n",
       "\n",
       "  Postal Code Format Postal Code Regex          Languages geonameid  \\\n",
       "0                 AD               NaN                NaN       NaN   \n",
       "1                NaN               NaN  ar-AE,fa,en,hi,ur    290557   \n",
       "2                NaN               NaN  fa-AF,ps,uz-AF,tk   1149361   \n",
       "3                NaN               NaN              en-AG   3576396   \n",
       "4                NaN               NaN              en-AI   3573511   \n",
       "\n",
       "          neighbours EquivalentFipsCode  \n",
       "0                NaN                NaN  \n",
       "1              SA,OM                NaN  \n",
       "2  TM,CN,IR,TJ,PK,UZ                NaN  \n",
       "3                NaN                NaN  \n",
       "4                NaN                NaN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "index = countries.query(\"ISO3 == 'NAM'\").index\n",
    "countries.at[index, 'ISO'] = 'NA'\n",
    "countries.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Standardize column names for Knowlege Graph\n",
    "* id: unique identifier for country\n",
    "* name: name of node\n",
    "* parentId: unique identifier for continent\n",
    "* properties: camelCase"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# https://www.iso.org/obp/ui/#iso:code:3166:BQ"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries['id'] = countries['ISO'] # standard id column to link nodes\n",
    "countries.rename(columns={'ISO': 'iso'}, inplace=True)\n",
    "countries.rename(columns={'ISO3': 'iso3'}, inplace=True)\n",
    "countries.rename(columns={'ISO-Numeric': 'isoNumeric'}, inplace=True)\n",
    "countries.rename(columns={'Country': 'name'}, inplace=True)\n",
    "countries.rename(columns={'Population': 'population'}, inplace=True)\n",
    "countries.rename(columns={'Area(in sq km)': 'areaSqKm'}, inplace=True)\n",
    "countries.rename(columns={'geonameid': 'geonameId'}, inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Export a minimum subset for now"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = countries[['id','name','iso','iso3','isoNumeric','areaSqKm','geonameId']].copy()\n",
    "countries.fillna('', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>iso</th>\n",
       "      <th>iso3</th>\n",
       "      <th>isoNumeric</th>\n",
       "      <th>areaSqKm</th>\n",
       "      <th>geonameId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AD</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>AD</td>\n",
       "      <td>AND</td>\n",
       "      <td>020</td>\n",
       "      <td>468</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AE</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>AE</td>\n",
       "      <td>ARE</td>\n",
       "      <td>784</td>\n",
       "      <td>82880</td>\n",
       "      <td>290557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AF</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AF</td>\n",
       "      <td>AFG</td>\n",
       "      <td>004</td>\n",
       "      <td>647500</td>\n",
       "      <td>1149361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AG</td>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>AG</td>\n",
       "      <td>ATG</td>\n",
       "      <td>028</td>\n",
       "      <td>443</td>\n",
       "      <td>3576396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AI</td>\n",
       "      <td>Anguilla</td>\n",
       "      <td>AI</td>\n",
       "      <td>AIA</td>\n",
       "      <td>660</td>\n",
       "      <td>102</td>\n",
       "      <td>3573511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AL</td>\n",
       "      <td>Albania</td>\n",
       "      <td>AL</td>\n",
       "      <td>ALB</td>\n",
       "      <td>008</td>\n",
       "      <td>28748</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AM</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>AM</td>\n",
       "      <td>ARM</td>\n",
       "      <td>051</td>\n",
       "      <td>29800</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AO</td>\n",
       "      <td>Angola</td>\n",
       "      <td>AO</td>\n",
       "      <td>AGO</td>\n",
       "      <td>024</td>\n",
       "      <td>1246700</td>\n",
       "      <td>3351879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AQ</td>\n",
       "      <td>Antarctica</td>\n",
       "      <td>AQ</td>\n",
       "      <td>ATA</td>\n",
       "      <td>010</td>\n",
       "      <td>14000000</td>\n",
       "      <td>6697173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AR</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>AR</td>\n",
       "      <td>ARG</td>\n",
       "      <td>032</td>\n",
       "      <td>2766890</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AS</td>\n",
       "      <td>American Samoa</td>\n",
       "      <td>AS</td>\n",
       "      <td>ASM</td>\n",
       "      <td>016</td>\n",
       "      <td>199</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AT</td>\n",
       "      <td>Austria</td>\n",
       "      <td>AT</td>\n",
       "      <td>AUT</td>\n",
       "      <td>040</td>\n",
       "      <td>83858</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AU</td>\n",
       "      <td>Australia</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUS</td>\n",
       "      <td>036</td>\n",
       "      <td>7686850</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AW</td>\n",
       "      <td>Aruba</td>\n",
       "      <td>AW</td>\n",
       "      <td>ABW</td>\n",
       "      <td>533</td>\n",
       "      <td>193</td>\n",
       "      <td>3577279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AX</td>\n",
       "      <td>Aland Islands</td>\n",
       "      <td>AX</td>\n",
       "      <td>ALA</td>\n",
       "      <td>248</td>\n",
       "      <td>1580</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AZ</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>AZ</td>\n",
       "      <td>AZE</td>\n",
       "      <td>031</td>\n",
       "      <td>86600</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BA</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>BA</td>\n",
       "      <td>BIH</td>\n",
       "      <td>070</td>\n",
       "      <td>51129</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BB</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>BB</td>\n",
       "      <td>BRB</td>\n",
       "      <td>052</td>\n",
       "      <td>431</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BD</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>BD</td>\n",
       "      <td>BGD</td>\n",
       "      <td>050</td>\n",
       "      <td>144000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BE</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>BE</td>\n",
       "      <td>BEL</td>\n",
       "      <td>056</td>\n",
       "      <td>30510</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BF</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>BF</td>\n",
       "      <td>BFA</td>\n",
       "      <td>854</td>\n",
       "      <td>274200</td>\n",
       "      <td>2361809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BG</td>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>BG</td>\n",
       "      <td>BGR</td>\n",
       "      <td>100</td>\n",
       "      <td>110910</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BH</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>BH</td>\n",
       "      <td>BHR</td>\n",
       "      <td>048</td>\n",
       "      <td>665</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BI</td>\n",
       "      <td>Burundi</td>\n",
       "      <td>BI</td>\n",
       "      <td>BDI</td>\n",
       "      <td>108</td>\n",
       "      <td>27830</td>\n",
       "      <td>433561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BJ</td>\n",
       "      <td>Benin</td>\n",
       "      <td>BJ</td>\n",
       "      <td>BEN</td>\n",
       "      <td>204</td>\n",
       "      <td>112620</td>\n",
       "      <td>2395170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BL</td>\n",
       "      <td>Saint Barthelemy</td>\n",
       "      <td>BL</td>\n",
       "      <td>BLM</td>\n",
       "      <td>652</td>\n",
       "      <td>21</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BM</td>\n",
       "      <td>Bermuda</td>\n",
       "      <td>BM</td>\n",
       "      <td>BMU</td>\n",
       "      <td>060</td>\n",
       "      <td>53</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BN</td>\n",
       "      <td>Brunei</td>\n",
       "      <td>BN</td>\n",
       "      <td>BRN</td>\n",
       "      <td>096</td>\n",
       "      <td>5770</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BO</td>\n",
       "      <td>Bolivia</td>\n",
       "      <td>BO</td>\n",
       "      <td>BOL</td>\n",
       "      <td>068</td>\n",
       "      <td>1098580</td>\n",
       "      <td>3923057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BQ</td>\n",
       "      <td>Bonaire, Saint Eustatius and Saba</td>\n",
       "      <td>BQ</td>\n",
       "      <td>BES</td>\n",
       "      <td>535</td>\n",
       "      <td>328</td>\n",
       "      <td>7626844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>BR</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>BR</td>\n",
       "      <td>BRA</td>\n",
       "      <td>076</td>\n",
       "      <td>8511965</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>BS</td>\n",
       "      <td>Bahamas</td>\n",
       "      <td>BS</td>\n",
       "      <td>BHS</td>\n",
       "      <td>044</td>\n",
       "      <td>13940</td>\n",
       "      <td>3572887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>BT</td>\n",
       "      <td>Bhutan</td>\n",
       "      <td>BT</td>\n",
       "      <td>BTN</td>\n",
       "      <td>064</td>\n",
       "      <td>47000</td>\n",
       "      <td>1252634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>BV</td>\n",
       "      <td>Bouvet Island</td>\n",
       "      <td>BV</td>\n",
       "      <td>BVT</td>\n",
       "      <td>074</td>\n",
       "      <td>49</td>\n",
       "      <td>3371123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>BW</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>BW</td>\n",
       "      <td>BWA</td>\n",
       "      <td>072</td>\n",
       "      <td>600370</td>\n",
       "      <td>933860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>BY</td>\n",
       "      <td>Belarus</td>\n",
       "      <td>BY</td>\n",
       "      <td>BLR</td>\n",
       "      <td>112</td>\n",
       "      <td>207600</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>BZ</td>\n",
       "      <td>Belize</td>\n",
       "      <td>BZ</td>\n",
       "      <td>BLZ</td>\n",
       "      <td>084</td>\n",
       "      <td>22966</td>\n",
       "      <td>3582678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>CA</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAN</td>\n",
       "      <td>124</td>\n",
       "      <td>9984670</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>CC</td>\n",
       "      <td>Cocos Islands</td>\n",
       "      <td>CC</td>\n",
       "      <td>CCK</td>\n",
       "      <td>166</td>\n",
       "      <td>14</td>\n",
       "      <td>1547376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>CD</td>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>CD</td>\n",
       "      <td>COD</td>\n",
       "      <td>180</td>\n",
       "      <td>2345410</td>\n",
       "      <td>203312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>CF</td>\n",
       "      <td>Central African Republic</td>\n",
       "      <td>CF</td>\n",
       "      <td>CAF</td>\n",
       "      <td>140</td>\n",
       "      <td>622984</td>\n",
       "      <td>239880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>CG</td>\n",
       "      <td>Republic of the Congo</td>\n",
       "      <td>CG</td>\n",
       "      <td>COG</td>\n",
       "      <td>178</td>\n",
       "      <td>342000</td>\n",
       "      <td>2260494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>CH</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>CH</td>\n",
       "      <td>CHE</td>\n",
       "      <td>756</td>\n",
       "      <td>41290</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>CI</td>\n",
       "      <td>Ivory Coast</td>\n",
       "      <td>CI</td>\n",
       "      <td>CIV</td>\n",
       "      <td>384</td>\n",
       "      <td>322460</td>\n",
       "      <td>2287781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>CK</td>\n",
       "      <td>Cook Islands</td>\n",
       "      <td>CK</td>\n",
       "      <td>COK</td>\n",
       "      <td>184</td>\n",
       "      <td>240</td>\n",
       "      <td>1899402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>CL</td>\n",
       "      <td>Chile</td>\n",
       "      <td>CL</td>\n",
       "      <td>CHL</td>\n",
       "      <td>152</td>\n",
       "      <td>756950</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>CM</td>\n",
       "      <td>Cameroon</td>\n",
       "      <td>CM</td>\n",
       "      <td>CMR</td>\n",
       "      <td>120</td>\n",
       "      <td>475440</td>\n",
       "      <td>2233387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>CN</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>CHN</td>\n",
       "      <td>156</td>\n",
       "      <td>9596960</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>CO</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>CO</td>\n",
       "      <td>COL</td>\n",
       "      <td>170</td>\n",
       "      <td>1138910</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>CR</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>CR</td>\n",
       "      <td>CRI</td>\n",
       "      <td>188</td>\n",
       "      <td>51100</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>CU</td>\n",
       "      <td>Cuba</td>\n",
       "      <td>CU</td>\n",
       "      <td>CUB</td>\n",
       "      <td>192</td>\n",
       "      <td>110860</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>CV</td>\n",
       "      <td>Cabo Verde</td>\n",
       "      <td>CV</td>\n",
       "      <td>CPV</td>\n",
       "      <td>132</td>\n",
       "      <td>4033</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>CW</td>\n",
       "      <td>Curacao</td>\n",
       "      <td>CW</td>\n",
       "      <td>CUW</td>\n",
       "      <td>531</td>\n",
       "      <td>444</td>\n",
       "      <td>7626836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>CX</td>\n",
       "      <td>Christmas Island</td>\n",
       "      <td>CX</td>\n",
       "      <td>CXR</td>\n",
       "      <td>162</td>\n",
       "      <td>135</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>CY</td>\n",
       "      <td>Cyprus</td>\n",
       "      <td>CY</td>\n",
       "      <td>CYP</td>\n",
       "      <td>196</td>\n",
       "      <td>9250</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>CZ</td>\n",
       "      <td>Czechia</td>\n",
       "      <td>CZ</td>\n",
       "      <td>CZE</td>\n",
       "      <td>203</td>\n",
       "      <td>78866</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>DE</td>\n",
       "      <td>Germany</td>\n",
       "      <td>DE</td>\n",
       "      <td>DEU</td>\n",
       "      <td>276</td>\n",
       "      <td>357021</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>DJ</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>DJ</td>\n",
       "      <td>DJI</td>\n",
       "      <td>262</td>\n",
       "      <td>23000</td>\n",
       "      <td>223816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>DK</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>DK</td>\n",
       "      <td>DNK</td>\n",
       "      <td>208</td>\n",
       "      <td>43094</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>DM</td>\n",
       "      <td>Dominica</td>\n",
       "      <td>DM</td>\n",
       "      <td>DMA</td>\n",
       "      <td>212</td>\n",
       "      <td>754</td>\n",
       "      <td>3575830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>DO</td>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>DO</td>\n",
       "      <td>DOM</td>\n",
       "      <td>214</td>\n",
       "      <td>48730</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>DZ</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>DZ</td>\n",
       "      <td>DZA</td>\n",
       "      <td>012</td>\n",
       "      <td>2381740</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>EC</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>EC</td>\n",
       "      <td>ECU</td>\n",
       "      <td>218</td>\n",
       "      <td>283560</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>EE</td>\n",
       "      <td>Estonia</td>\n",
       "      <td>EE</td>\n",
       "      <td>EST</td>\n",
       "      <td>233</td>\n",
       "      <td>45226</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>EG</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>EG</td>\n",
       "      <td>EGY</td>\n",
       "      <td>818</td>\n",
       "      <td>1001450</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>EH</td>\n",
       "      <td>Western Sahara</td>\n",
       "      <td>EH</td>\n",
       "      <td>ESH</td>\n",
       "      <td>732</td>\n",
       "      <td>266000</td>\n",
       "      <td>2461445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>ER</td>\n",
       "      <td>Eritrea</td>\n",
       "      <td>ER</td>\n",
       "      <td>ERI</td>\n",
       "      <td>232</td>\n",
       "      <td>121320</td>\n",
       "      <td>338010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>ES</td>\n",
       "      <td>Spain</td>\n",
       "      <td>ES</td>\n",
       "      <td>ESP</td>\n",
       "      <td>724</td>\n",
       "      <td>504782</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>ET</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>ET</td>\n",
       "      <td>ETH</td>\n",
       "      <td>231</td>\n",
       "      <td>1127127</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>FI</td>\n",
       "      <td>Finland</td>\n",
       "      <td>FI</td>\n",
       "      <td>FIN</td>\n",
       "      <td>246</td>\n",
       "      <td>337030</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>FJ</td>\n",
       "      <td>Fiji</td>\n",
       "      <td>FJ</td>\n",
       "      <td>FJI</td>\n",
       "      <td>242</td>\n",
       "      <td>18270</td>\n",
       "      <td>2205218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>FK</td>\n",
       "      <td>Falkland Islands</td>\n",
       "      <td>FK</td>\n",
       "      <td>FLK</td>\n",
       "      <td>238</td>\n",
       "      <td>12173</td>\n",
       "      <td>3474414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>FM</td>\n",
       "      <td>Micronesia</td>\n",
       "      <td>FM</td>\n",
       "      <td>FSM</td>\n",
       "      <td>583</td>\n",
       "      <td>702</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>FO</td>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>FO</td>\n",
       "      <td>FRO</td>\n",
       "      <td>234</td>\n",
       "      <td>1399</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "      <td>FR</td>\n",
       "      <td>FRA</td>\n",
       "      <td>250</td>\n",
       "      <td>547030</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>GA</td>\n",
       "      <td>Gabon</td>\n",
       "      <td>GA</td>\n",
       "      <td>GAB</td>\n",
       "      <td>266</td>\n",
       "      <td>267667</td>\n",
       "      <td>2400553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>GB</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>GB</td>\n",
       "      <td>GBR</td>\n",
       "      <td>826</td>\n",
       "      <td>244820</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>GD</td>\n",
       "      <td>Grenada</td>\n",
       "      <td>GD</td>\n",
       "      <td>GRD</td>\n",
       "      <td>308</td>\n",
       "      <td>344</td>\n",
       "      <td>3580239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>GE</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>GE</td>\n",
       "      <td>GEO</td>\n",
       "      <td>268</td>\n",
       "      <td>69700</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>GF</td>\n",
       "      <td>French Guiana</td>\n",
       "      <td>GF</td>\n",
       "      <td>GUF</td>\n",
       "      <td>254</td>\n",
       "      <td>91000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>GG</td>\n",
       "      <td>Guernsey</td>\n",
       "      <td>GG</td>\n",
       "      <td>GGY</td>\n",
       "      <td>831</td>\n",
       "      <td>78</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>GH</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>GH</td>\n",
       "      <td>GHA</td>\n",
       "      <td>288</td>\n",
       "      <td>239460</td>\n",
       "      <td>2300660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>GI</td>\n",
       "      <td>Gibraltar</td>\n",
       "      <td>GI</td>\n",
       "      <td>GIB</td>\n",
       "      <td>292</td>\n",
       "      <td>6.5</td>\n",
       "      <td>2411586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>GL</td>\n",
       "      <td>Greenland</td>\n",
       "      <td>GL</td>\n",
       "      <td>GRL</td>\n",
       "      <td>304</td>\n",
       "      <td>2166086</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>GM</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>GM</td>\n",
       "      <td>GMB</td>\n",
       "      <td>270</td>\n",
       "      <td>11300</td>\n",
       "      <td>2413451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>GN</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>GN</td>\n",
       "      <td>GIN</td>\n",
       "      <td>324</td>\n",
       "      <td>245857</td>\n",
       "      <td>2420477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>GP</td>\n",
       "      <td>Guadeloupe</td>\n",
       "      <td>GP</td>\n",
       "      <td>GLP</td>\n",
       "      <td>312</td>\n",
       "      <td>1780</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>GQ</td>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>GQ</td>\n",
       "      <td>GNQ</td>\n",
       "      <td>226</td>\n",
       "      <td>28051</td>\n",
       "      <td>2309096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>GR</td>\n",
       "      <td>Greece</td>\n",
       "      <td>GR</td>\n",
       "      <td>GRC</td>\n",
       "      <td>300</td>\n",
       "      <td>131940</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>GS</td>\n",
       "      <td>South Georgia and the South Sandwich Islands</td>\n",
       "      <td>GS</td>\n",
       "      <td>SGS</td>\n",
       "      <td>239</td>\n",
       "      <td>3903</td>\n",
       "      <td>3474415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>GT</td>\n",
       "      <td>Guatemala</td>\n",
       "      <td>GT</td>\n",
       "      <td>GTM</td>\n",
       "      <td>320</td>\n",
       "      <td>108890</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>GU</td>\n",
       "      <td>Guam</td>\n",
       "      <td>GU</td>\n",
       "      <td>GUM</td>\n",
       "      <td>316</td>\n",
       "      <td>549</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>GW</td>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>GW</td>\n",
       "      <td>GNB</td>\n",
       "      <td>624</td>\n",
       "      <td>36120</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>GY</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>GY</td>\n",
       "      <td>GUY</td>\n",
       "      <td>328</td>\n",
       "      <td>214970</td>\n",
       "      <td>3378535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>HK</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>HK</td>\n",
       "      <td>HKG</td>\n",
       "      <td>344</td>\n",
       "      <td>1092</td>\n",
       "      <td>1819730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>HM</td>\n",
       "      <td>Heard Island and McDonald Islands</td>\n",
       "      <td>HM</td>\n",
       "      <td>HMD</td>\n",
       "      <td>334</td>\n",
       "      <td>412</td>\n",
       "      <td>1547314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>HN</td>\n",
       "      <td>Honduras</td>\n",
       "      <td>HN</td>\n",
       "      <td>HND</td>\n",
       "      <td>340</td>\n",
       "      <td>112090</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>HR</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>HR</td>\n",
       "      <td>HRV</td>\n",
       "      <td>191</td>\n",
       "      <td>56542</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>HT</td>\n",
       "      <td>Haiti</td>\n",
       "      <td>HT</td>\n",
       "      <td>HTI</td>\n",
       "      <td>332</td>\n",
       "      <td>27750</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>HU</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>HU</td>\n",
       "      <td>HUN</td>\n",
       "      <td>348</td>\n",
       "      <td>93030</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>ID</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>ID</td>\n",
       "      <td>IDN</td>\n",
       "      <td>360</td>\n",
       "      <td>1919440</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>IE</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>IE</td>\n",
       "      <td>IRL</td>\n",
       "      <td>372</td>\n",
       "      <td>70280</td>\n",
       "      <td>2963597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>IL</td>\n",
       "      <td>Israel</td>\n",
       "      <td>IL</td>\n",
       "      <td>ISR</td>\n",
       "      <td>376</td>\n",
       "      <td>20770</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>IM</td>\n",
       "      <td>Isle of Man</td>\n",
       "      <td>IM</td>\n",
       "      <td>IMN</td>\n",
       "      <td>833</td>\n",
       "      <td>572</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>IN</td>\n",
       "      <td>India</td>\n",
       "      <td>IN</td>\n",
       "      <td>IND</td>\n",
       "      <td>356</td>\n",
       "      <td>3287590</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>IO</td>\n",
       "      <td>British Indian Ocean Territory</td>\n",
       "      <td>IO</td>\n",
       "      <td>IOT</td>\n",
       "      <td>086</td>\n",
       "      <td>60</td>\n",
       "      <td>1282588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>IQ</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>IQ</td>\n",
       "      <td>IRQ</td>\n",
       "      <td>368</td>\n",
       "      <td>437072</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>IR</td>\n",
       "      <td>Iran</td>\n",
       "      <td>IR</td>\n",
       "      <td>IRN</td>\n",
       "      <td>364</td>\n",
       "      <td>1648000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>IS</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>IS</td>\n",
       "      <td>ISL</td>\n",
       "      <td>352</td>\n",
       "      <td>103000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>IT</td>\n",
       "      <td>Italy</td>\n",
       "      <td>IT</td>\n",
       "      <td>ITA</td>\n",
       "      <td>380</td>\n",
       "      <td>301230</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>JE</td>\n",
       "      <td>Jersey</td>\n",
       "      <td>JE</td>\n",
       "      <td>JEY</td>\n",
       "      <td>832</td>\n",
       "      <td>116</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>JM</td>\n",
       "      <td>Jamaica</td>\n",
       "      <td>JM</td>\n",
       "      <td>JAM</td>\n",
       "      <td>388</td>\n",
       "      <td>10991</td>\n",
       "      <td>3489940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>JO</td>\n",
       "      <td>Jordan</td>\n",
       "      <td>JO</td>\n",
       "      <td>JOR</td>\n",
       "      <td>400</td>\n",
       "      <td>92300</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>JP</td>\n",
       "      <td>Japan</td>\n",
       "      <td>JP</td>\n",
       "      <td>JPN</td>\n",
       "      <td>392</td>\n",
       "      <td>377835</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>KE</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>KE</td>\n",
       "      <td>KEN</td>\n",
       "      <td>404</td>\n",
       "      <td>582650</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>KG</td>\n",
       "      <td>Kyrgyzstan</td>\n",
       "      <td>KG</td>\n",
       "      <td>KGZ</td>\n",
       "      <td>417</td>\n",
       "      <td>198500</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>KH</td>\n",
       "      <td>Cambodia</td>\n",
       "      <td>KH</td>\n",
       "      <td>KHM</td>\n",
       "      <td>116</td>\n",
       "      <td>181040</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>KI</td>\n",
       "      <td>Kiribati</td>\n",
       "      <td>KI</td>\n",
       "      <td>KIR</td>\n",
       "      <td>296</td>\n",
       "      <td>811</td>\n",
       "      <td>4030945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>KM</td>\n",
       "      <td>Comoros</td>\n",
       "      <td>KM</td>\n",
       "      <td>COM</td>\n",
       "      <td>174</td>\n",
       "      <td>2170</td>\n",
       "      <td>921929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>KN</td>\n",
       "      <td>Saint Kitts and Nevis</td>\n",
       "      <td>KN</td>\n",
       "      <td>KNA</td>\n",
       "      <td>659</td>\n",
       "      <td>261</td>\n",
       "      <td>3575174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>KP</td>\n",
       "      <td>North Korea</td>\n",
       "      <td>KP</td>\n",
       "      <td>PRK</td>\n",
       "      <td>408</td>\n",
       "      <td>120540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>KR</td>\n",
       "      <td>South Korea</td>\n",
       "      <td>KR</td>\n",
       "      <td>KOR</td>\n",
       "      <td>410</td>\n",
       "      <td>98480</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>XK</td>\n",
       "      <td>Kosovo</td>\n",
       "      <td>XK</td>\n",
       "      <td>XKX</td>\n",
       "      <td>0</td>\n",
       "      <td>10908</td>\n",
       "      <td>831053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>KW</td>\n",
       "      <td>Kuwait</td>\n",
       "      <td>KW</td>\n",
       "      <td>KWT</td>\n",
       "      <td>414</td>\n",
       "      <td>17820</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>KY</td>\n",
       "      <td>Cayman Islands</td>\n",
       "      <td>KY</td>\n",
       "      <td>CYM</td>\n",
       "      <td>136</td>\n",
       "      <td>262</td>\n",
       "      <td>3580718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>KZ</td>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>KZ</td>\n",
       "      <td>KAZ</td>\n",
       "      <td>398</td>\n",
       "      <td>2717300</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>LA</td>\n",
       "      <td>Laos</td>\n",
       "      <td>LA</td>\n",
       "      <td>LAO</td>\n",
       "      <td>418</td>\n",
       "      <td>236800</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>LB</td>\n",
       "      <td>Lebanon</td>\n",
       "      <td>LB</td>\n",
       "      <td>LBN</td>\n",
       "      <td>422</td>\n",
       "      <td>10400</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>LC</td>\n",
       "      <td>Saint Lucia</td>\n",
       "      <td>LC</td>\n",
       "      <td>LCA</td>\n",
       "      <td>662</td>\n",
       "      <td>616</td>\n",
       "      <td>3576468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>LI</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>LI</td>\n",
       "      <td>LIE</td>\n",
       "      <td>438</td>\n",
       "      <td>160</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>LK</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>LK</td>\n",
       "      <td>LKA</td>\n",
       "      <td>144</td>\n",
       "      <td>65610</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>LR</td>\n",
       "      <td>Liberia</td>\n",
       "      <td>LR</td>\n",
       "      <td>LBR</td>\n",
       "      <td>430</td>\n",
       "      <td>111370</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>LS</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>LS</td>\n",
       "      <td>LSO</td>\n",
       "      <td>426</td>\n",
       "      <td>30355</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>LT</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>LT</td>\n",
       "      <td>LTU</td>\n",
       "      <td>440</td>\n",
       "      <td>65200</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>LU</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>LU</td>\n",
       "      <td>LUX</td>\n",
       "      <td>442</td>\n",
       "      <td>2586</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>LV</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>LV</td>\n",
       "      <td>LVA</td>\n",
       "      <td>428</td>\n",
       "      <td>64589</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>LY</td>\n",
       "      <td>Libya</td>\n",
       "      <td>LY</td>\n",
       "      <td>LBY</td>\n",
       "      <td>434</td>\n",
       "      <td>1759540</td>\n",
       "      <td>2215636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>MA</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>MA</td>\n",
       "      <td>MAR</td>\n",
       "      <td>504</td>\n",
       "      <td>446550</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>MC</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>MC</td>\n",
       "      <td>MCO</td>\n",
       "      <td>492</td>\n",
       "      <td>1.95</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>MD</td>\n",
       "      <td>Moldova</td>\n",
       "      <td>MD</td>\n",
       "      <td>MDA</td>\n",
       "      <td>498</td>\n",
       "      <td>33843</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>ME</td>\n",
       "      <td>Montenegro</td>\n",
       "      <td>ME</td>\n",
       "      <td>MNE</td>\n",
       "      <td>499</td>\n",
       "      <td>14026</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>MF</td>\n",
       "      <td>Saint Martin</td>\n",
       "      <td>MF</td>\n",
       "      <td>MAF</td>\n",
       "      <td>663</td>\n",
       "      <td>53</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>MG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>MG</td>\n",
       "      <td>MDG</td>\n",
       "      <td>450</td>\n",
       "      <td>587040</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>MH</td>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>MH</td>\n",
       "      <td>MHL</td>\n",
       "      <td>584</td>\n",
       "      <td>181.3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>MK</td>\n",
       "      <td>North Macedonia</td>\n",
       "      <td>MK</td>\n",
       "      <td>MKD</td>\n",
       "      <td>807</td>\n",
       "      <td>25333</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>ML</td>\n",
       "      <td>Mali</td>\n",
       "      <td>ML</td>\n",
       "      <td>MLI</td>\n",
       "      <td>466</td>\n",
       "      <td>1240000</td>\n",
       "      <td>2453866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>MM</td>\n",
       "      <td>Myanmar</td>\n",
       "      <td>MM</td>\n",
       "      <td>MMR</td>\n",
       "      <td>104</td>\n",
       "      <td>678500</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>MN</td>\n",
       "      <td>Mongolia</td>\n",
       "      <td>MN</td>\n",
       "      <td>MNG</td>\n",
       "      <td>496</td>\n",
       "      <td>1565000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>MO</td>\n",
       "      <td>Macao</td>\n",
       "      <td>MO</td>\n",
       "      <td>MAC</td>\n",
       "      <td>446</td>\n",
       "      <td>254</td>\n",
       "      <td>1821275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>MP</td>\n",
       "      <td>Northern Mariana Islands</td>\n",
       "      <td>MP</td>\n",
       "      <td>MNP</td>\n",
       "      <td>580</td>\n",
       "      <td>477</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>MQ</td>\n",
       "      <td>Martinique</td>\n",
       "      <td>MQ</td>\n",
       "      <td>MTQ</td>\n",
       "      <td>474</td>\n",
       "      <td>1100</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>MR</td>\n",
       "      <td>Mauritania</td>\n",
       "      <td>MR</td>\n",
       "      <td>MRT</td>\n",
       "      <td>478</td>\n",
       "      <td>1030700</td>\n",
       "      <td>2378080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>MS</td>\n",
       "      <td>Montserrat</td>\n",
       "      <td>MS</td>\n",
       "      <td>MSR</td>\n",
       "      <td>500</td>\n",
       "      <td>102</td>\n",
       "      <td>3578097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>MT</td>\n",
       "      <td>Malta</td>\n",
       "      <td>MT</td>\n",
       "      <td>MLT</td>\n",
       "      <td>470</td>\n",
       "      <td>316</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>MU</td>\n",
       "      <td>Mauritius</td>\n",
       "      <td>MU</td>\n",
       "      <td>MUS</td>\n",
       "      <td>480</td>\n",
       "      <td>2040</td>\n",
       "      <td>934292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>MV</td>\n",
       "      <td>Maldives</td>\n",
       "      <td>MV</td>\n",
       "      <td>MDV</td>\n",
       "      <td>462</td>\n",
       "      <td>300</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>MW</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>MW</td>\n",
       "      <td>MWI</td>\n",
       "      <td>454</td>\n",
       "      <td>118480</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>MX</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEX</td>\n",
       "      <td>484</td>\n",
       "      <td>1972550</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>MY</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>MY</td>\n",
       "      <td>MYS</td>\n",
       "      <td>458</td>\n",
       "      <td>329750</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>MZ</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>MZ</td>\n",
       "      <td>MOZ</td>\n",
       "      <td>508</td>\n",
       "      <td>801590</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>NA</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>NA</td>\n",
       "      <td>NAM</td>\n",
       "      <td>516</td>\n",
       "      <td>825418</td>\n",
       "      <td>3355338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>NC</td>\n",
       "      <td>New Caledonia</td>\n",
       "      <td>NC</td>\n",
       "      <td>NCL</td>\n",
       "      <td>540</td>\n",
       "      <td>19060</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>NE</td>\n",
       "      <td>Niger</td>\n",
       "      <td>NE</td>\n",
       "      <td>NER</td>\n",
       "      <td>562</td>\n",
       "      <td>1267000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>NF</td>\n",
       "      <td>Norfolk Island</td>\n",
       "      <td>NF</td>\n",
       "      <td>NFK</td>\n",
       "      <td>574</td>\n",
       "      <td>34.6</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>NG</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>NG</td>\n",
       "      <td>NGA</td>\n",
       "      <td>566</td>\n",
       "      <td>923768</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>NI</td>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>NI</td>\n",
       "      <td>NIC</td>\n",
       "      <td>558</td>\n",
       "      <td>129494</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>NL</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>NL</td>\n",
       "      <td>NLD</td>\n",
       "      <td>528</td>\n",
       "      <td>41526</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>NO</td>\n",
       "      <td>Norway</td>\n",
       "      <td>NO</td>\n",
       "      <td>NOR</td>\n",
       "      <td>578</td>\n",
       "      <td>324220</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>NP</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>NPL</td>\n",
       "      <td>524</td>\n",
       "      <td>140800</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>NR</td>\n",
       "      <td>Nauru</td>\n",
       "      <td>NR</td>\n",
       "      <td>NRU</td>\n",
       "      <td>520</td>\n",
       "      <td>21</td>\n",
       "      <td>2110425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>NU</td>\n",
       "      <td>Niue</td>\n",
       "      <td>NU</td>\n",
       "      <td>NIU</td>\n",
       "      <td>570</td>\n",
       "      <td>260</td>\n",
       "      <td>4036232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>NZ</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>NZ</td>\n",
       "      <td>NZL</td>\n",
       "      <td>554</td>\n",
       "      <td>268680</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>OM</td>\n",
       "      <td>Oman</td>\n",
       "      <td>OM</td>\n",
       "      <td>OMN</td>\n",
       "      <td>512</td>\n",
       "      <td>212460</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>PA</td>\n",
       "      <td>Panama</td>\n",
       "      <td>PA</td>\n",
       "      <td>PAN</td>\n",
       "      <td>591</td>\n",
       "      <td>78200</td>\n",
       "      <td>3703430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>PE</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>PER</td>\n",
       "      <td>604</td>\n",
       "      <td>1285220</td>\n",
       "      <td>3932488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>PF</td>\n",
       "      <td>French Polynesia</td>\n",
       "      <td>PF</td>\n",
       "      <td>PYF</td>\n",
       "      <td>258</td>\n",
       "      <td>4167</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>PG</td>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>PG</td>\n",
       "      <td>PNG</td>\n",
       "      <td>598</td>\n",
       "      <td>462840</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>PH</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>PHL</td>\n",
       "      <td>608</td>\n",
       "      <td>300000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>PK</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>PK</td>\n",
       "      <td>PAK</td>\n",
       "      <td>586</td>\n",
       "      <td>803940</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>PL</td>\n",
       "      <td>Poland</td>\n",
       "      <td>PL</td>\n",
       "      <td>POL</td>\n",
       "      <td>616</td>\n",
       "      <td>312685</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>PM</td>\n",
       "      <td>Saint Pierre and Miquelon</td>\n",
       "      <td>PM</td>\n",
       "      <td>SPM</td>\n",
       "      <td>666</td>\n",
       "      <td>242</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>PN</td>\n",
       "      <td>Pitcairn</td>\n",
       "      <td>PN</td>\n",
       "      <td>PCN</td>\n",
       "      <td>612</td>\n",
       "      <td>47</td>\n",
       "      <td>4030699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>PR</td>\n",
       "      <td>Puerto Rico</td>\n",
       "      <td>PR</td>\n",
       "      <td>PRI</td>\n",
       "      <td>630</td>\n",
       "      <td>9104</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>PS</td>\n",
       "      <td>Palestinian Territory</td>\n",
       "      <td>PS</td>\n",
       "      <td>PSE</td>\n",
       "      <td>275</td>\n",
       "      <td>5970</td>\n",
       "      <td>6254930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>PT</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>PT</td>\n",
       "      <td>PRT</td>\n",
       "      <td>620</td>\n",
       "      <td>92391</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>PW</td>\n",
       "      <td>Palau</td>\n",
       "      <td>PW</td>\n",
       "      <td>PLW</td>\n",
       "      <td>585</td>\n",
       "      <td>458</td>\n",
       "      <td>1559582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>PY</td>\n",
       "      <td>Paraguay</td>\n",
       "      <td>PY</td>\n",
       "      <td>PRY</td>\n",
       "      <td>600</td>\n",
       "      <td>406750</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>QA</td>\n",
       "      <td>Qatar</td>\n",
       "      <td>QA</td>\n",
       "      <td>QAT</td>\n",
       "      <td>634</td>\n",
       "      <td>11437</td>\n",
       "      <td>289688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>RE</td>\n",
       "      <td>Reunion</td>\n",
       "      <td>RE</td>\n",
       "      <td>REU</td>\n",
       "      <td>638</td>\n",
       "      <td>2517</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>RO</td>\n",
       "      <td>Romania</td>\n",
       "      <td>RO</td>\n",
       "      <td>ROU</td>\n",
       "      <td>642</td>\n",
       "      <td>237500</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>RS</td>\n",
       "      <td>Serbia</td>\n",
       "      <td>RS</td>\n",
       "      <td>SRB</td>\n",
       "      <td>688</td>\n",
       "      <td>88361</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>RU</td>\n",
       "      <td>Russia</td>\n",
       "      <td>RU</td>\n",
       "      <td>RUS</td>\n",
       "      <td>643</td>\n",
       "      <td>17100000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>RW</td>\n",
       "      <td>Rwanda</td>\n",
       "      <td>RW</td>\n",
       "      <td>RWA</td>\n",
       "      <td>646</td>\n",
       "      <td>26338</td>\n",
       "      <td>49518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>SA</td>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>SA</td>\n",
       "      <td>SAU</td>\n",
       "      <td>682</td>\n",
       "      <td>1960582</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>SB</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>SB</td>\n",
       "      <td>SLB</td>\n",
       "      <td>090</td>\n",
       "      <td>28450</td>\n",
       "      <td>2103350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>SC</td>\n",
       "      <td>Seychelles</td>\n",
       "      <td>SC</td>\n",
       "      <td>SYC</td>\n",
       "      <td>690</td>\n",
       "      <td>455</td>\n",
       "      <td>241170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>SD</td>\n",
       "      <td>Sudan</td>\n",
       "      <td>SD</td>\n",
       "      <td>SDN</td>\n",
       "      <td>729</td>\n",
       "      <td>1861484</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>SS</td>\n",
       "      <td>South Sudan</td>\n",
       "      <td>SS</td>\n",
       "      <td>SSD</td>\n",
       "      <td>728</td>\n",
       "      <td>644329</td>\n",
       "      <td>7909807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>SE</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>SE</td>\n",
       "      <td>SWE</td>\n",
       "      <td>752</td>\n",
       "      <td>449964</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>SG</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>SG</td>\n",
       "      <td>SGP</td>\n",
       "      <td>702</td>\n",
       "      <td>692.7</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>SH</td>\n",
       "      <td>Saint Helena</td>\n",
       "      <td>SH</td>\n",
       "      <td>SHN</td>\n",
       "      <td>654</td>\n",
       "      <td>410</td>\n",
       "      <td>3370751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>SI</td>\n",
       "      <td>Slovenia</td>\n",
       "      <td>SI</td>\n",
       "      <td>SVN</td>\n",
       "      <td>705</td>\n",
       "      <td>20273</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>SJ</td>\n",
       "      <td>Svalbard and Jan Mayen</td>\n",
       "      <td>SJ</td>\n",
       "      <td>SJM</td>\n",
       "      <td>744</td>\n",
       "      <td>62049</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>SK</td>\n",
       "      <td>Slovakia</td>\n",
       "      <td>SK</td>\n",
       "      <td>SVK</td>\n",
       "      <td>703</td>\n",
       "      <td>48845</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>SL</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>SL</td>\n",
       "      <td>SLE</td>\n",
       "      <td>694</td>\n",
       "      <td>71740</td>\n",
       "      <td>2403846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>SM</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>SM</td>\n",
       "      <td>SMR</td>\n",
       "      <td>674</td>\n",
       "      <td>61.2</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>SN</td>\n",
       "      <td>Senegal</td>\n",
       "      <td>SN</td>\n",
       "      <td>SEN</td>\n",
       "      <td>686</td>\n",
       "      <td>196190</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>SO</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>SO</td>\n",
       "      <td>SOM</td>\n",
       "      <td>706</td>\n",
       "      <td>637657</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>SR</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SR</td>\n",
       "      <td>SUR</td>\n",
       "      <td>740</td>\n",
       "      <td>163270</td>\n",
       "      <td>3382998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>ST</td>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "      <td>ST</td>\n",
       "      <td>STP</td>\n",
       "      <td>678</td>\n",
       "      <td>1001</td>\n",
       "      <td>2410758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>SV</td>\n",
       "      <td>El Salvador</td>\n",
       "      <td>SV</td>\n",
       "      <td>SLV</td>\n",
       "      <td>222</td>\n",
       "      <td>21040</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>SX</td>\n",
       "      <td>Sint Maarten</td>\n",
       "      <td>SX</td>\n",
       "      <td>SXM</td>\n",
       "      <td>534</td>\n",
       "      <td>21</td>\n",
       "      <td>7609695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>SY</td>\n",
       "      <td>Syria</td>\n",
       "      <td>SY</td>\n",
       "      <td>SYR</td>\n",
       "      <td>760</td>\n",
       "      <td>185180</td>\n",
       "      <td>163843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>SZ</td>\n",
       "      <td>Eswatini</td>\n",
       "      <td>SZ</td>\n",
       "      <td>SWZ</td>\n",
       "      <td>748</td>\n",
       "      <td>17363</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>TC</td>\n",
       "      <td>Turks and Caicos Islands</td>\n",
       "      <td>TC</td>\n",
       "      <td>TCA</td>\n",
       "      <td>796</td>\n",
       "      <td>430</td>\n",
       "      <td>3576916</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>TD</td>\n",
       "      <td>Chad</td>\n",
       "      <td>TD</td>\n",
       "      <td>TCD</td>\n",
       "      <td>148</td>\n",
       "      <td>1284000</td>\n",
       "      <td>2434508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>TF</td>\n",
       "      <td>French Southern Territories</td>\n",
       "      <td>TF</td>\n",
       "      <td>ATF</td>\n",
       "      <td>260</td>\n",
       "      <td>7829</td>\n",
       "      <td>1546748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>TG</td>\n",
       "      <td>Togo</td>\n",
       "      <td>TG</td>\n",
       "      <td>TGO</td>\n",
       "      <td>768</td>\n",
       "      <td>56785</td>\n",
       "      <td>2363686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>TH</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>TH</td>\n",
       "      <td>THA</td>\n",
       "      <td>764</td>\n",
       "      <td>514000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>TJ</td>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>TJ</td>\n",
       "      <td>TJK</td>\n",
       "      <td>762</td>\n",
       "      <td>143100</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>TK</td>\n",
       "      <td>Tokelau</td>\n",
       "      <td>TK</td>\n",
       "      <td>TKL</td>\n",
       "      <td>772</td>\n",
       "      <td>10</td>\n",
       "      <td>4031074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>TL</td>\n",
       "      <td>Timor Leste</td>\n",
       "      <td>TL</td>\n",
       "      <td>TLS</td>\n",
       "      <td>626</td>\n",
       "      <td>15007</td>\n",
       "      <td>1966436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>TM</td>\n",
       "      <td>Turkmenistan</td>\n",
       "      <td>TM</td>\n",
       "      <td>TKM</td>\n",
       "      <td>795</td>\n",
       "      <td>488100</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>TN</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>TN</td>\n",
       "      <td>TUN</td>\n",
       "      <td>788</td>\n",
       "      <td>163610</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>TO</td>\n",
       "      <td>Tonga</td>\n",
       "      <td>TO</td>\n",
       "      <td>TON</td>\n",
       "      <td>776</td>\n",
       "      <td>748</td>\n",
       "      <td>4032283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>TR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>TR</td>\n",
       "      <td>TUR</td>\n",
       "      <td>792</td>\n",
       "      <td>780580</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>TT</td>\n",
       "      <td>Trinidad and Tobago</td>\n",
       "      <td>TT</td>\n",
       "      <td>TTO</td>\n",
       "      <td>780</td>\n",
       "      <td>5128</td>\n",
       "      <td>3573591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>TV</td>\n",
       "      <td>Tuvalu</td>\n",
       "      <td>TV</td>\n",
       "      <td>TUV</td>\n",
       "      <td>798</td>\n",
       "      <td>26</td>\n",
       "      <td>2110297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>TW</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>TW</td>\n",
       "      <td>TWN</td>\n",
       "      <td>158</td>\n",
       "      <td>35980</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>TZ</td>\n",
       "      <td>Tanzania</td>\n",
       "      <td>TZ</td>\n",
       "      <td>TZA</td>\n",
       "      <td>834</td>\n",
       "      <td>945087</td>\n",
       "      <td>149590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>UA</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>UA</td>\n",
       "      <td>UKR</td>\n",
       "      <td>804</td>\n",
       "      <td>603700</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>UG</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>UG</td>\n",
       "      <td>UGA</td>\n",
       "      <td>800</td>\n",
       "      <td>236040</td>\n",
       "      <td>226074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>UM</td>\n",
       "      <td>United States Minor Outlying Islands</td>\n",
       "      <td>UM</td>\n",
       "      <td>UMI</td>\n",
       "      <td>581</td>\n",
       "      <td>0</td>\n",
       "      <td>5854968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>US</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>USA</td>\n",
       "      <td>840</td>\n",
       "      <td>9629091</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>UY</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>UY</td>\n",
       "      <td>URY</td>\n",
       "      <td>858</td>\n",
       "      <td>176220</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>UZ</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>UZ</td>\n",
       "      <td>UZB</td>\n",
       "      <td>860</td>\n",
       "      <td>447400</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>VA</td>\n",
       "      <td>Vatican</td>\n",
       "      <td>VA</td>\n",
       "      <td>VAT</td>\n",
       "      <td>336</td>\n",
       "      <td>0.44</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>VC</td>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>VC</td>\n",
       "      <td>VCT</td>\n",
       "      <td>670</td>\n",
       "      <td>389</td>\n",
       "      <td>3577815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>VE</td>\n",
       "      <td>Venezuela</td>\n",
       "      <td>VE</td>\n",
       "      <td>VEN</td>\n",
       "      <td>862</td>\n",
       "      <td>912050</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>VG</td>\n",
       "      <td>British Virgin Islands</td>\n",
       "      <td>VG</td>\n",
       "      <td>VGB</td>\n",
       "      <td>092</td>\n",
       "      <td>153</td>\n",
       "      <td>3577718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>VI</td>\n",
       "      <td>U.S. Virgin Islands</td>\n",
       "      <td>VI</td>\n",
       "      <td>VIR</td>\n",
       "      <td>850</td>\n",
       "      <td>352</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>VN</td>\n",
       "      <td>Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>VNM</td>\n",
       "      <td>704</td>\n",
       "      <td>329560</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>VU</td>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>VU</td>\n",
       "      <td>VUT</td>\n",
       "      <td>548</td>\n",
       "      <td>12200</td>\n",
       "      <td>2134431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>WF</td>\n",
       "      <td>Wallis and Futuna</td>\n",
       "      <td>WF</td>\n",
       "      <td>WLF</td>\n",
       "      <td>876</td>\n",
       "      <td>274</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>WS</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>WS</td>\n",
       "      <td>WSM</td>\n",
       "      <td>882</td>\n",
       "      <td>2944</td>\n",
       "      <td>4034894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>YE</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>YE</td>\n",
       "      <td>YEM</td>\n",
       "      <td>887</td>\n",
       "      <td>527970</td>\n",
       "      <td>69543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>YT</td>\n",
       "      <td>Mayotte</td>\n",
       "      <td>YT</td>\n",
       "      <td>MYT</td>\n",
       "      <td>175</td>\n",
       "      <td>374</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>ZA</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>ZA</td>\n",
       "      <td>ZAF</td>\n",
       "      <td>710</td>\n",
       "      <td>1219912</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>ZM</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>ZM</td>\n",
       "      <td>ZMB</td>\n",
       "      <td>894</td>\n",
       "      <td>752614</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>ZW</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZW</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>716</td>\n",
       "      <td>390580</td>\n",
       "      <td>878675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>CS</td>\n",
       "      <td>Serbia and Montenegro</td>\n",
       "      <td>CS</td>\n",
       "      <td>SCG</td>\n",
       "      <td>891</td>\n",
       "      <td>102350</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>AN</td>\n",
       "      <td>Netherlands Antilles</td>\n",
       "      <td>AN</td>\n",
       "      <td>ANT</td>\n",
       "      <td>530</td>\n",
       "      <td>960</td>\n",
       "      <td>8505032</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                                          name iso iso3 isoNumeric  \\\n",
       "0    AD                                       Andorra  AD  AND        020   \n",
       "1    AE                          United Arab Emirates  AE  ARE        784   \n",
       "2    AF                                   Afghanistan  AF  AFG        004   \n",
       "3    AG                           Antigua and Barbuda  AG  ATG        028   \n",
       "4    AI                                      Anguilla  AI  AIA        660   \n",
       "5    AL                                       Albania  AL  ALB        008   \n",
       "6    AM                                       Armenia  AM  ARM        051   \n",
       "7    AO                                        Angola  AO  AGO        024   \n",
       "8    AQ                                    Antarctica  AQ  ATA        010   \n",
       "9    AR                                     Argentina  AR  ARG        032   \n",
       "10   AS                                American Samoa  AS  ASM        016   \n",
       "11   AT                                       Austria  AT  AUT        040   \n",
       "12   AU                                     Australia  AU  AUS        036   \n",
       "13   AW                                         Aruba  AW  ABW        533   \n",
       "14   AX                                 Aland Islands  AX  ALA        248   \n",
       "15   AZ                                    Azerbaijan  AZ  AZE        031   \n",
       "16   BA                        Bosnia and Herzegovina  BA  BIH        070   \n",
       "17   BB                                      Barbados  BB  BRB        052   \n",
       "18   BD                                    Bangladesh  BD  BGD        050   \n",
       "19   BE                                       Belgium  BE  BEL        056   \n",
       "20   BF                                  Burkina Faso  BF  BFA        854   \n",
       "21   BG                                      Bulgaria  BG  BGR        100   \n",
       "22   BH                                       Bahrain  BH  BHR        048   \n",
       "23   BI                                       Burundi  BI  BDI        108   \n",
       "24   BJ                                         Benin  BJ  BEN        204   \n",
       "25   BL                              Saint Barthelemy  BL  BLM        652   \n",
       "26   BM                                       Bermuda  BM  BMU        060   \n",
       "27   BN                                        Brunei  BN  BRN        096   \n",
       "28   BO                                       Bolivia  BO  BOL        068   \n",
       "29   BQ            Bonaire, Saint Eustatius and Saba   BQ  BES        535   \n",
       "30   BR                                        Brazil  BR  BRA        076   \n",
       "31   BS                                       Bahamas  BS  BHS        044   \n",
       "32   BT                                        Bhutan  BT  BTN        064   \n",
       "33   BV                                 Bouvet Island  BV  BVT        074   \n",
       "34   BW                                      Botswana  BW  BWA        072   \n",
       "35   BY                                       Belarus  BY  BLR        112   \n",
       "36   BZ                                        Belize  BZ  BLZ        084   \n",
       "37   CA                                        Canada  CA  CAN        124   \n",
       "38   CC                                 Cocos Islands  CC  CCK        166   \n",
       "39   CD              Democratic Republic of the Congo  CD  COD        180   \n",
       "40   CF                      Central African Republic  CF  CAF        140   \n",
       "41   CG                         Republic of the Congo  CG  COG        178   \n",
       "42   CH                                   Switzerland  CH  CHE        756   \n",
       "43   CI                                   Ivory Coast  CI  CIV        384   \n",
       "44   CK                                  Cook Islands  CK  COK        184   \n",
       "45   CL                                         Chile  CL  CHL        152   \n",
       "46   CM                                      Cameroon  CM  CMR        120   \n",
       "47   CN                                         China  CN  CHN        156   \n",
       "48   CO                                      Colombia  CO  COL        170   \n",
       "49   CR                                    Costa Rica  CR  CRI        188   \n",
       "50   CU                                          Cuba  CU  CUB        192   \n",
       "51   CV                                    Cabo Verde  CV  CPV        132   \n",
       "52   CW                                       Curacao  CW  CUW        531   \n",
       "53   CX                              Christmas Island  CX  CXR        162   \n",
       "54   CY                                        Cyprus  CY  CYP        196   \n",
       "55   CZ                                       Czechia  CZ  CZE        203   \n",
       "56   DE                                       Germany  DE  DEU        276   \n",
       "57   DJ                                      Djibouti  DJ  DJI        262   \n",
       "58   DK                                       Denmark  DK  DNK        208   \n",
       "59   DM                                      Dominica  DM  DMA        212   \n",
       "60   DO                            Dominican Republic  DO  DOM        214   \n",
       "61   DZ                                       Algeria  DZ  DZA        012   \n",
       "62   EC                                       Ecuador  EC  ECU        218   \n",
       "63   EE                                       Estonia  EE  EST        233   \n",
       "64   EG                                         Egypt  EG  EGY        818   \n",
       "65   EH                                Western Sahara  EH  ESH        732   \n",
       "66   ER                                       Eritrea  ER  ERI        232   \n",
       "67   ES                                         Spain  ES  ESP        724   \n",
       "68   ET                                      Ethiopia  ET  ETH        231   \n",
       "69   FI                                       Finland  FI  FIN        246   \n",
       "70   FJ                                          Fiji  FJ  FJI        242   \n",
       "71   FK                              Falkland Islands  FK  FLK        238   \n",
       "72   FM                                    Micronesia  FM  FSM        583   \n",
       "73   FO                                 Faroe Islands  FO  FRO        234   \n",
       "74   FR                                        France  FR  FRA        250   \n",
       "75   GA                                         Gabon  GA  GAB        266   \n",
       "76   GB                                United Kingdom  GB  GBR        826   \n",
       "77   GD                                       Grenada  GD  GRD        308   \n",
       "78   GE                                       Georgia  GE  GEO        268   \n",
       "79   GF                                 French Guiana  GF  GUF        254   \n",
       "80   GG                                      Guernsey  GG  GGY        831   \n",
       "81   GH                                         Ghana  GH  GHA        288   \n",
       "82   GI                                     Gibraltar  GI  GIB        292   \n",
       "83   GL                                     Greenland  GL  GRL        304   \n",
       "84   GM                                        Gambia  GM  GMB        270   \n",
       "85   GN                                        Guinea  GN  GIN        324   \n",
       "86   GP                                    Guadeloupe  GP  GLP        312   \n",
       "87   GQ                             Equatorial Guinea  GQ  GNQ        226   \n",
       "88   GR                                        Greece  GR  GRC        300   \n",
       "89   GS  South Georgia and the South Sandwich Islands  GS  SGS        239   \n",
       "90   GT                                     Guatemala  GT  GTM        320   \n",
       "91   GU                                          Guam  GU  GUM        316   \n",
       "92   GW                                 Guinea-Bissau  GW  GNB        624   \n",
       "93   GY                                        Guyana  GY  GUY        328   \n",
       "94   HK                                     Hong Kong  HK  HKG        344   \n",
       "95   HM             Heard Island and McDonald Islands  HM  HMD        334   \n",
       "96   HN                                      Honduras  HN  HND        340   \n",
       "97   HR                                       Croatia  HR  HRV        191   \n",
       "98   HT                                         Haiti  HT  HTI        332   \n",
       "99   HU                                       Hungary  HU  HUN        348   \n",
       "100  ID                                     Indonesia  ID  IDN        360   \n",
       "101  IE                                       Ireland  IE  IRL        372   \n",
       "102  IL                                        Israel  IL  ISR        376   \n",
       "103  IM                                   Isle of Man  IM  IMN        833   \n",
       "104  IN                                         India  IN  IND        356   \n",
       "105  IO                British Indian Ocean Territory  IO  IOT        086   \n",
       "106  IQ                                          Iraq  IQ  IRQ        368   \n",
       "107  IR                                          Iran  IR  IRN        364   \n",
       "108  IS                                       Iceland  IS  ISL        352   \n",
       "109  IT                                         Italy  IT  ITA        380   \n",
       "110  JE                                        Jersey  JE  JEY        832   \n",
       "111  JM                                       Jamaica  JM  JAM        388   \n",
       "112  JO                                        Jordan  JO  JOR        400   \n",
       "113  JP                                         Japan  JP  JPN        392   \n",
       "114  KE                                         Kenya  KE  KEN        404   \n",
       "115  KG                                    Kyrgyzstan  KG  KGZ        417   \n",
       "116  KH                                      Cambodia  KH  KHM        116   \n",
       "117  KI                                      Kiribati  KI  KIR        296   \n",
       "118  KM                                       Comoros  KM  COM        174   \n",
       "119  KN                         Saint Kitts and Nevis  KN  KNA        659   \n",
       "120  KP                                   North Korea  KP  PRK        408   \n",
       "121  KR                                   South Korea  KR  KOR        410   \n",
       "122  XK                                        Kosovo  XK  XKX          0   \n",
       "123  KW                                        Kuwait  KW  KWT        414   \n",
       "124  KY                                Cayman Islands  KY  CYM        136   \n",
       "125  KZ                                    Kazakhstan  KZ  KAZ        398   \n",
       "126  LA                                          Laos  LA  LAO        418   \n",
       "127  LB                                       Lebanon  LB  LBN        422   \n",
       "128  LC                                   Saint Lucia  LC  LCA        662   \n",
       "129  LI                                 Liechtenstein  LI  LIE        438   \n",
       "130  LK                                     Sri Lanka  LK  LKA        144   \n",
       "131  LR                                       Liberia  LR  LBR        430   \n",
       "132  LS                                       Lesotho  LS  LSO        426   \n",
       "133  LT                                     Lithuania  LT  LTU        440   \n",
       "134  LU                                    Luxembourg  LU  LUX        442   \n",
       "135  LV                                        Latvia  LV  LVA        428   \n",
       "136  LY                                         Libya  LY  LBY        434   \n",
       "137  MA                                       Morocco  MA  MAR        504   \n",
       "138  MC                                        Monaco  MC  MCO        492   \n",
       "139  MD                                       Moldova  MD  MDA        498   \n",
       "140  ME                                    Montenegro  ME  MNE        499   \n",
       "141  MF                                  Saint Martin  MF  MAF        663   \n",
       "142  MG                                    Madagascar  MG  MDG        450   \n",
       "143  MH                              Marshall Islands  MH  MHL        584   \n",
       "144  MK                               North Macedonia  MK  MKD        807   \n",
       "145  ML                                          Mali  ML  MLI        466   \n",
       "146  MM                                       Myanmar  MM  MMR        104   \n",
       "147  MN                                      Mongolia  MN  MNG        496   \n",
       "148  MO                                         Macao  MO  MAC        446   \n",
       "149  MP                      Northern Mariana Islands  MP  MNP        580   \n",
       "150  MQ                                    Martinique  MQ  MTQ        474   \n",
       "151  MR                                    Mauritania  MR  MRT        478   \n",
       "152  MS                                    Montserrat  MS  MSR        500   \n",
       "153  MT                                         Malta  MT  MLT        470   \n",
       "154  MU                                     Mauritius  MU  MUS        480   \n",
       "155  MV                                      Maldives  MV  MDV        462   \n",
       "156  MW                                        Malawi  MW  MWI        454   \n",
       "157  MX                                        Mexico  MX  MEX        484   \n",
       "158  MY                                      Malaysia  MY  MYS        458   \n",
       "159  MZ                                    Mozambique  MZ  MOZ        508   \n",
       "160  NA                                       Namibia  NA  NAM        516   \n",
       "161  NC                                 New Caledonia  NC  NCL        540   \n",
       "162  NE                                         Niger  NE  NER        562   \n",
       "163  NF                                Norfolk Island  NF  NFK        574   \n",
       "164  NG                                       Nigeria  NG  NGA        566   \n",
       "165  NI                                     Nicaragua  NI  NIC        558   \n",
       "166  NL                                   Netherlands  NL  NLD        528   \n",
       "167  NO                                        Norway  NO  NOR        578   \n",
       "168  NP                                         Nepal  NP  NPL        524   \n",
       "169  NR                                         Nauru  NR  NRU        520   \n",
       "170  NU                                          Niue  NU  NIU        570   \n",
       "171  NZ                                   New Zealand  NZ  NZL        554   \n",
       "172  OM                                          Oman  OM  OMN        512   \n",
       "173  PA                                        Panama  PA  PAN        591   \n",
       "174  PE                                          Peru  PE  PER        604   \n",
       "175  PF                              French Polynesia  PF  PYF        258   \n",
       "176  PG                              Papua New Guinea  PG  PNG        598   \n",
       "177  PH                                   Philippines  PH  PHL        608   \n",
       "178  PK                                      Pakistan  PK  PAK        586   \n",
       "179  PL                                        Poland  PL  POL        616   \n",
       "180  PM                     Saint Pierre and Miquelon  PM  SPM        666   \n",
       "181  PN                                      Pitcairn  PN  PCN        612   \n",
       "182  PR                                   Puerto Rico  PR  PRI        630   \n",
       "183  PS                         Palestinian Territory  PS  PSE        275   \n",
       "184  PT                                      Portugal  PT  PRT        620   \n",
       "185  PW                                         Palau  PW  PLW        585   \n",
       "186  PY                                      Paraguay  PY  PRY        600   \n",
       "187  QA                                         Qatar  QA  QAT        634   \n",
       "188  RE                                       Reunion  RE  REU        638   \n",
       "189  RO                                       Romania  RO  ROU        642   \n",
       "190  RS                                        Serbia  RS  SRB        688   \n",
       "191  RU                                        Russia  RU  RUS        643   \n",
       "192  RW                                        Rwanda  RW  RWA        646   \n",
       "193  SA                                  Saudi Arabia  SA  SAU        682   \n",
       "194  SB                               Solomon Islands  SB  SLB        090   \n",
       "195  SC                                    Seychelles  SC  SYC        690   \n",
       "196  SD                                         Sudan  SD  SDN        729   \n",
       "197  SS                                   South Sudan  SS  SSD        728   \n",
       "198  SE                                        Sweden  SE  SWE        752   \n",
       "199  SG                                     Singapore  SG  SGP        702   \n",
       "200  SH                                  Saint Helena  SH  SHN        654   \n",
       "201  SI                                      Slovenia  SI  SVN        705   \n",
       "202  SJ                        Svalbard and Jan Mayen  SJ  SJM        744   \n",
       "203  SK                                      Slovakia  SK  SVK        703   \n",
       "204  SL                                  Sierra Leone  SL  SLE        694   \n",
       "205  SM                                    San Marino  SM  SMR        674   \n",
       "206  SN                                       Senegal  SN  SEN        686   \n",
       "207  SO                                       Somalia  SO  SOM        706   \n",
       "208  SR                                      Suriname  SR  SUR        740   \n",
       "209  ST                         Sao Tome and Principe  ST  STP        678   \n",
       "210  SV                                   El Salvador  SV  SLV        222   \n",
       "211  SX                                  Sint Maarten  SX  SXM        534   \n",
       "212  SY                                         Syria  SY  SYR        760   \n",
       "213  SZ                                      Eswatini  SZ  SWZ        748   \n",
       "214  TC                      Turks and Caicos Islands  TC  TCA        796   \n",
       "215  TD                                          Chad  TD  TCD        148   \n",
       "216  TF                   French Southern Territories  TF  ATF        260   \n",
       "217  TG                                          Togo  TG  TGO        768   \n",
       "218  TH                                      Thailand  TH  THA        764   \n",
       "219  TJ                                    Tajikistan  TJ  TJK        762   \n",
       "220  TK                                       Tokelau  TK  TKL        772   \n",
       "221  TL                                   Timor Leste  TL  TLS        626   \n",
       "222  TM                                  Turkmenistan  TM  TKM        795   \n",
       "223  TN                                       Tunisia  TN  TUN        788   \n",
       "224  TO                                         Tonga  TO  TON        776   \n",
       "225  TR                                        Turkey  TR  TUR        792   \n",
       "226  TT                           Trinidad and Tobago  TT  TTO        780   \n",
       "227  TV                                        Tuvalu  TV  TUV        798   \n",
       "228  TW                                        Taiwan  TW  TWN        158   \n",
       "229  TZ                                      Tanzania  TZ  TZA        834   \n",
       "230  UA                                       Ukraine  UA  UKR        804   \n",
       "231  UG                                        Uganda  UG  UGA        800   \n",
       "232  UM          United States Minor Outlying Islands  UM  UMI        581   \n",
       "233  US                                 United States  US  USA        840   \n",
       "234  UY                                       Uruguay  UY  URY        858   \n",
       "235  UZ                                    Uzbekistan  UZ  UZB        860   \n",
       "236  VA                                       Vatican  VA  VAT        336   \n",
       "237  VC              Saint Vincent and the Grenadines  VC  VCT        670   \n",
       "238  VE                                     Venezuela  VE  VEN        862   \n",
       "239  VG                        British Virgin Islands  VG  VGB        092   \n",
       "240  VI                           U.S. Virgin Islands  VI  VIR        850   \n",
       "241  VN                                       Vietnam  VN  VNM        704   \n",
       "242  VU                                       Vanuatu  VU  VUT        548   \n",
       "243  WF                             Wallis and Futuna  WF  WLF        876   \n",
       "244  WS                                         Samoa  WS  WSM        882   \n",
       "245  YE                                         Yemen  YE  YEM        887   \n",
       "246  YT                                       Mayotte  YT  MYT        175   \n",
       "247  ZA                                  South Africa  ZA  ZAF        710   \n",
       "248  ZM                                        Zambia  ZM  ZMB        894   \n",
       "249  ZW                                      Zimbabwe  ZW  ZWE        716   \n",
       "250  CS                         Serbia and Montenegro  CS  SCG        891   \n",
       "251  AN                          Netherlands Antilles  AN  ANT        530   \n",
       "\n",
       "     areaSqKm geonameId  \n",
       "0         468            \n",
       "1       82880    290557  \n",
       "2      647500   1149361  \n",
       "3         443   3576396  \n",
       "4         102   3573511  \n",
       "5       28748            \n",
       "6       29800            \n",
       "7     1246700   3351879  \n",
       "8    14000000   6697173  \n",
       "9     2766890            \n",
       "10        199            \n",
       "11      83858            \n",
       "12    7686850            \n",
       "13        193   3577279  \n",
       "14       1580            \n",
       "15      86600            \n",
       "16      51129            \n",
       "17        431            \n",
       "18     144000            \n",
       "19      30510            \n",
       "20     274200   2361809  \n",
       "21     110910            \n",
       "22        665            \n",
       "23      27830    433561  \n",
       "24     112620   2395170  \n",
       "25         21            \n",
       "26         53            \n",
       "27       5770            \n",
       "28    1098580   3923057  \n",
       "29        328   7626844  \n",
       "30    8511965            \n",
       "31      13940   3572887  \n",
       "32      47000   1252634  \n",
       "33         49   3371123  \n",
       "34     600370    933860  \n",
       "35     207600            \n",
       "36      22966   3582678  \n",
       "37    9984670            \n",
       "38         14   1547376  \n",
       "39    2345410    203312  \n",
       "40     622984    239880  \n",
       "41     342000   2260494  \n",
       "42      41290            \n",
       "43     322460   2287781  \n",
       "44        240   1899402  \n",
       "45     756950            \n",
       "46     475440   2233387  \n",
       "47    9596960            \n",
       "48    1138910            \n",
       "49      51100            \n",
       "50     110860            \n",
       "51       4033            \n",
       "52        444   7626836  \n",
       "53        135            \n",
       "54       9250            \n",
       "55      78866            \n",
       "56     357021            \n",
       "57      23000    223816  \n",
       "58      43094            \n",
       "59        754   3575830  \n",
       "60      48730            \n",
       "61    2381740            \n",
       "62     283560            \n",
       "63      45226            \n",
       "64    1001450            \n",
       "65     266000   2461445  \n",
       "66     121320    338010  \n",
       "67     504782            \n",
       "68    1127127            \n",
       "69     337030            \n",
       "70      18270   2205218  \n",
       "71      12173   3474414  \n",
       "72        702            \n",
       "73       1399            \n",
       "74     547030            \n",
       "75     267667   2400553  \n",
       "76     244820            \n",
       "77        344   3580239  \n",
       "78      69700            \n",
       "79      91000            \n",
       "80         78            \n",
       "81     239460   2300660  \n",
       "82        6.5   2411586  \n",
       "83    2166086            \n",
       "84      11300   2413451  \n",
       "85     245857   2420477  \n",
       "86       1780            \n",
       "87      28051   2309096  \n",
       "88     131940            \n",
       "89       3903   3474415  \n",
       "90     108890            \n",
       "91        549            \n",
       "92      36120            \n",
       "93     214970   3378535  \n",
       "94       1092   1819730  \n",
       "95        412   1547314  \n",
       "96     112090            \n",
       "97      56542            \n",
       "98      27750            \n",
       "99      93030            \n",
       "100   1919440            \n",
       "101     70280   2963597  \n",
       "102     20770            \n",
       "103       572            \n",
       "104   3287590            \n",
       "105        60   1282588  \n",
       "106    437072            \n",
       "107   1648000            \n",
       "108    103000            \n",
       "109    301230            \n",
       "110       116            \n",
       "111     10991   3489940  \n",
       "112     92300            \n",
       "113    377835            \n",
       "114    582650            \n",
       "115    198500            \n",
       "116    181040            \n",
       "117       811   4030945  \n",
       "118      2170    921929  \n",
       "119       261   3575174  \n",
       "120    120540            \n",
       "121     98480            \n",
       "122     10908    831053  \n",
       "123     17820            \n",
       "124       262   3580718  \n",
       "125   2717300            \n",
       "126    236800            \n",
       "127     10400            \n",
       "128       616   3576468  \n",
       "129       160            \n",
       "130     65610            \n",
       "131    111370            \n",
       "132     30355            \n",
       "133     65200            \n",
       "134      2586            \n",
       "135     64589            \n",
       "136   1759540   2215636  \n",
       "137    446550            \n",
       "138      1.95            \n",
       "139     33843            \n",
       "140     14026            \n",
       "141        53            \n",
       "142    587040            \n",
       "143     181.3            \n",
       "144     25333            \n",
       "145   1240000   2453866  \n",
       "146    678500            \n",
       "147   1565000            \n",
       "148       254   1821275  \n",
       "149       477            \n",
       "150      1100            \n",
       "151   1030700   2378080  \n",
       "152       102   3578097  \n",
       "153       316            \n",
       "154      2040    934292  \n",
       "155       300            \n",
       "156    118480            \n",
       "157   1972550            \n",
       "158    329750            \n",
       "159    801590            \n",
       "160    825418   3355338  \n",
       "161     19060            \n",
       "162   1267000            \n",
       "163      34.6            \n",
       "164    923768            \n",
       "165    129494            \n",
       "166     41526            \n",
       "167    324220            \n",
       "168    140800            \n",
       "169        21   2110425  \n",
       "170       260   4036232  \n",
       "171    268680            \n",
       "172    212460            \n",
       "173     78200   3703430  \n",
       "174   1285220   3932488  \n",
       "175      4167            \n",
       "176    462840            \n",
       "177    300000            \n",
       "178    803940            \n",
       "179    312685            \n",
       "180       242            \n",
       "181        47   4030699  \n",
       "182      9104            \n",
       "183      5970   6254930  \n",
       "184     92391            \n",
       "185       458   1559582  \n",
       "186    406750            \n",
       "187     11437    289688  \n",
       "188      2517            \n",
       "189    237500            \n",
       "190     88361            \n",
       "191  17100000            \n",
       "192     26338     49518  \n",
       "193   1960582            \n",
       "194     28450   2103350  \n",
       "195       455    241170  \n",
       "196   1861484            \n",
       "197    644329   7909807  \n",
       "198    449964            \n",
       "199     692.7            \n",
       "200       410   3370751  \n",
       "201     20273            \n",
       "202     62049            \n",
       "203     48845            \n",
       "204     71740   2403846  \n",
       "205      61.2            \n",
       "206    196190            \n",
       "207    637657            \n",
       "208    163270   3382998  \n",
       "209      1001   2410758  \n",
       "210     21040            \n",
       "211        21   7609695  \n",
       "212    185180    163843  \n",
       "213     17363            \n",
       "214       430   3576916  \n",
       "215   1284000   2434508  \n",
       "216      7829   1546748  \n",
       "217     56785   2363686  \n",
       "218    514000            \n",
       "219    143100            \n",
       "220        10   4031074  \n",
       "221     15007   1966436  \n",
       "222    488100            \n",
       "223    163610            \n",
       "224       748   4032283  \n",
       "225    780580            \n",
       "226      5128   3573591  \n",
       "227        26   2110297  \n",
       "228     35980            \n",
       "229    945087    149590  \n",
       "230    603700            \n",
       "231    236040    226074  \n",
       "232         0   5854968  \n",
       "233   9629091            \n",
       "234    176220            \n",
       "235    447400            \n",
       "236      0.44            \n",
       "237       389   3577815  \n",
       "238    912050            \n",
       "239       153   3577718  \n",
       "240       352            \n",
       "241    329560            \n",
       "242     12200   2134431  \n",
       "243       274            \n",
       "244      2944   4034894  \n",
       "245    527970     69543  \n",
       "246       374            \n",
       "247   1219912            \n",
       "248    752614            \n",
       "249    390580    878675  \n",
       "250    102350            \n",
       "251       960   8505032  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries.head(300)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "countries.to_csv(NEO4J_IMPORT / \"00e-GeoNamesCountry.csv\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}