World_Population.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "VHUkNTDYw9ZF"
      },
      "outputs": [],
      "source": [
        "import requests, sqlite3\n",
        "from bs4 import BeautifulSoup\n",
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def extract_site(web_link):  \n",
        "  website = web_link\n",
        "  result = requests.get(website)\n",
        "  content = result.text\n",
        "  soup = BeautifulSoup(content, 'lxml')\n",
        "  return soup"
      ],
      "metadata": {
        "id": "tCEqYU8gxEHm"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def extract(web_link, tag_1, tag_2, class_1, class_2, idx_1=None, fnd=True):\n",
        "  soup = extract_site(web_link)\n",
        "  if idx_1 == None:\n",
        "    box = soup.find_all(tag_1, class_=class_1)\n",
        "  else:\n",
        "    box = soup.find_all(tag_1, class_=class_1)[idx_1]\n",
        "  if fnd:\n",
        "    items = box.find(tag_2, class_=class_2)\n",
        "    return items\n",
        "  return box"
      ],
      "metadata": {
        "id": "C1Qa2cF7xGfx"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def get_items(items, tag_1, tag_2, link_head, idx_1=None, idx_2=None):\n",
        "  item_dict = {}\n",
        "  for item in items.find(tag_1).find_all(tag_2)[idx_1:idx_2]:\n",
        "    item_dict[item.get_text()] = link_head+item.find('a').get('href')\n",
        "  return item_dict"
      ],
      "metadata": {
        "id": "J2HpOL-sxI8n"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def extract_regions(web_link):\n",
        "  regions = extract(web_link, 'div', 'div', 'content-card-teaser', 'border-left-black', 1)\n",
        "  region_dict = get_items(regions, 'div', 'strong', 'https://www.cia.gov', idx_1=1)\n",
        "  return region_dict"
      ],
      "metadata": {
        "id": "-fJdyAZCxOB1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def extract_countries(regions):\n",
        "  country_dict = {}\n",
        "  for region in regions:\n",
        "    countries_grp = extract(regions[region], 'div', '', 'col-md-4', '', fnd=False)\n",
        "    for countries in countries_grp:\n",
        "      country_dict.update(get_items(countries, 'ul', 'li', 'https://www.cia.gov'))\n",
        "  return country_dict"
      ],
      "metadata": {
        "id": "ixTXhEIrxP-c"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def get_area(box):\n",
        "  try:\n",
        "    box[0].find_all('div')[3]\n",
        "  except IndexError:\n",
        "    return {'area': None, 'area_land' : None, 'area_water': None}\n",
        "  area = box[0].find_all('div')[3]\n",
        "  data_raw = area.find('p').get_text().split(' ')\n",
        "  data_clean = []\n",
        "  for data in data_raw:\n",
        "    data = data.replace(',', '')\n",
        "    if can_convert(data):\n",
        "      data_clean.append(float(data))\n",
        "  if len(data_clean) < 3:\n",
        "    for i in range(3-len(data_clean)):\n",
        "      data_clean.append(None)\n",
        "  area_dict = {'area': data_clean[0], 'area_land' : data_clean[1], 'area_water': data_clean[2]}\n",
        "  return area_dict"
      ],
      "metadata": {
        "id": "Bdhu9BKjxTFq"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def get_population(box):\n",
        "  try:\n",
        "    box[1].find_all('div')\n",
        "  except IndexError:\n",
        "    return {'population': None,\t'population_growth': None, 'birth_rate': None, 'death_rate': None, 'migration_rate': None}\n",
        "  all_pop = box[1].find_all('div')\n",
        "  data = all_pop[0].find('p').get_text().split()[0].replace(',', '')\n",
        "  if can_convert(data):\n",
        "    pop_lst = [float(data)]\n",
        "  else:\n",
        "    pop_lst = [None]\n",
        "  pop_details = box[1].find_all('div', class_='')\n",
        "  slice_pop = pop_details[5:20]\n",
        "  i = get_index(slice_pop)\n",
        "  if i == None:\n",
        "    for details in range(4):\n",
        "      pop_lst.append(None)\n",
        "  else:\n",
        "    for details in pop_details[5+i:i+9]:\n",
        "      data = details.find('p').get_text().split()[0].replace('%', '')\n",
        "      if can_convert(data):\n",
        "        pop_lst.append(float(data))\n",
        "      else:\n",
        "        pop_lst.append(None)\n",
        "  pop_dict = {'population': pop_lst[0],\t'population_growth': pop_lst[1], 'birth_rate': pop_lst[2], 'death_rate': pop_lst[3], 'migration_rate': pop_lst[4]}\n",
        "  return pop_dict"
      ],
      "metadata": {
        "id": "P4v3hC_ExYdi"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def get_index(lst):\n",
        "  for i in range(len(lst)):\n",
        "    item = lst[i].find('h3', class_='mt30')\n",
        "    if item is not None and item.get_text() == 'Population growth rate':\n",
        "      return i"
      ],
      "metadata": {
        "id": "nrJTzz_LxZe_"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def can_convert(data):\n",
        "  try:\n",
        "    float(data)\n",
        "  except ValueError:\n",
        "    return False\n",
        "  return True"
      ],
      "metadata": {
        "id": "QQiuCH7ExcDj"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def extract_data(countries_dict):\n",
        "  data = []\n",
        "  for country in countries_dict:\n",
        "    temp_dict = {}\n",
        "    temp_dict['name'] = country\n",
        "    soup = extract_site(countries_dict[country])\n",
        "    box = soup.find_all('div', class_='free-form-content__content')[1:3]\n",
        "    temp_dict.update(get_area(box))\n",
        "    temp_dict.update(get_population(box))\n",
        "    data.append(temp_dict)\n",
        "    df = pd.DataFrame(data)\n",
        "  return df"
      ],
      "metadata": {
        "id": "VR6GKu5Fxeys"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "if __name__ == \"__main__\" :\n",
        "  url = \"https://www.cia.gov/the-world-factbook/\"\n",
        "  df = extract_data(extract_countries(extract_regions(url)))"
      ],
      "metadata": {
        "id": "djUgWSyzxku1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "71gSJ38iyAOU",
        "outputId": "4959a65d-e531-4df6-8df3-3534e3ae7290"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           name       area  area_land  area_water  population  \\\n",
              "0       Algeria  2381740.0  2381740.0         0.0  44178884.0   \n",
              "1        Angola  1246700.0  1246700.0         0.0  34795287.0   \n",
              "2         Benin   112622.0   110622.0      2000.0  13754688.0   \n",
              "3      Botswana   581730.0   566730.0     15000.0   2384246.0   \n",
              "4  Burkina Faso   274200.0   273800.0       400.0  21935389.0   \n",
              "\n",
              "   population_growth  birth_rate  death_rate  migration_rate  \n",
              "0               1.34       18.52        4.32           -0.82  \n",
              "1               3.36       41.80        8.01           -0.19  \n",
              "2               3.34       41.15        8.01            0.24  \n",
              "3               1.40       20.28        9.05            2.81  \n",
              "4               2.53       33.57        7.71           -0.61  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-25a21b4d-ca95-4602-96ce-0c8088dc537c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>name</th>\n",
              "      <th>area</th>\n",
              "      <th>area_land</th>\n",
              "      <th>area_water</th>\n",
              "      <th>population</th>\n",
              "      <th>population_growth</th>\n",
              "      <th>birth_rate</th>\n",
              "      <th>death_rate</th>\n",
              "      <th>migration_rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>2381740.0</td>\n",
              "      <td>2381740.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>44178884.0</td>\n",
              "      <td>1.34</td>\n",
              "      <td>18.52</td>\n",
              "      <td>4.32</td>\n",
              "      <td>-0.82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Angola</td>\n",
              "      <td>1246700.0</td>\n",
              "      <td>1246700.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>34795287.0</td>\n",
              "      <td>3.36</td>\n",
              "      <td>41.80</td>\n",
              "      <td>8.01</td>\n",
              "      <td>-0.19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Benin</td>\n",
              "      <td>112622.0</td>\n",
              "      <td>110622.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>13754688.0</td>\n",
              "      <td>3.34</td>\n",
              "      <td>41.15</td>\n",
              "      <td>8.01</td>\n",
              "      <td>0.24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Botswana</td>\n",
              "      <td>581730.0</td>\n",
              "      <td>566730.0</td>\n",
              "      <td>15000.0</td>\n",
              "      <td>2384246.0</td>\n",
              "      <td>1.40</td>\n",
              "      <td>20.28</td>\n",
              "      <td>9.05</td>\n",
              "      <td>2.81</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Burkina Faso</td>\n",
              "      <td>274200.0</td>\n",
              "      <td>273800.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>21935389.0</td>\n",
              "      <td>2.53</td>\n",
              "      <td>33.57</td>\n",
              "      <td>7.71</td>\n",
              "      <td>-0.61</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-25a21b4d-ca95-4602-96ce-0c8088dc537c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-25a21b4d-ca95-4602-96ce-0c8088dc537c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-25a21b4d-ca95-4602-96ce-0c8088dc537c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DXXeDMNLyJ71",
        "outputId": "0b89271f-c954-4ab9-9d30-d02712bda814"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 261 entries, 0 to 260\n",
            "Data columns (total 9 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   name               261 non-null    object \n",
            " 1   area               253 non-null    float64\n",
            " 2   area_land          250 non-null    float64\n",
            " 3   area_water         247 non-null    float64\n",
            " 4   population         237 non-null    float64\n",
            " 5   population_growth  235 non-null    float64\n",
            " 6   birth_rate         228 non-null    float64\n",
            " 7   death_rate         230 non-null    float64\n",
            " 8   migration_rate     229 non-null    float64\n",
            "dtypes: float64(8), object(1)\n",
            "memory usage: 18.5+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.isnull().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "95hpK5jIyV8x",
        "outputId": "c8051bc8-96e7-43ff-91b1-d8d83259aed2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "name                  0\n",
              "area                  8\n",
              "area_land            11\n",
              "area_water           14\n",
              "population           24\n",
              "population_growth    26\n",
              "birth_rate           33\n",
              "death_rate           31\n",
              "migration_rate       32\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_new = df"
      ],
      "metadata": {
        "id": "Bcz_9OZW3yXv"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_new.loc[df_new['area_land']/df_new['area'] > 100000, 'area'] = df_new.loc[df_new['area_land']/df_new['area'] > 100000]['area']*1000000"
      ],
      "metadata": {
        "id": "bTPDwTEM3Lbj"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_new"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "ZKo2mQg85Kjk",
        "outputId": "fea99193-5288-4b0f-9e22-016be0532176"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             name       area  area_land  area_water    population  \\\n",
              "0         Algeria  2381740.0  2381740.0         0.0  4.417888e+07   \n",
              "1          Angola  1246700.0  1246700.0         0.0  3.479529e+07   \n",
              "2           Benin   112622.0   110622.0      2000.0  1.375469e+07   \n",
              "3        Botswana   581730.0   566730.0     15000.0  2.384246e+06   \n",
              "4    Burkina Faso   274200.0   273800.0       400.0  2.193539e+07   \n",
              "..            ...        ...        ...         ...           ...   \n",
              "256         India  3287263.0  2973193.0    314070.0  1.389637e+09   \n",
              "257      Maldives      298.0      298.0         0.0  3.901640e+05   \n",
              "258         Nepal   147181.0   143351.0      3830.0  3.066660e+07   \n",
              "259      Pakistan   796095.0   770875.0     25220.0  2.429238e+08   \n",
              "260     Sri Lanka    65610.0    64630.0       980.0  2.318752e+07   \n",
              "\n",
              "     population_growth  birth_rate  death_rate  migration_rate  \n",
              "0                 1.34       18.52        4.32           -0.82  \n",
              "1                 3.36       41.80        8.01           -0.19  \n",
              "2                 3.34       41.15        8.01            0.24  \n",
              "3                 1.40       20.28        9.05            2.81  \n",
              "4                 2.53       33.57        7.71           -0.61  \n",
              "..                 ...         ...         ...             ...  \n",
              "256               0.67       16.82       10.30            0.16  \n",
              "257              -0.14       15.54        4.15          -12.78  \n",
              "258               0.78       17.53        5.58           -4.21  \n",
              "259               1.95       26.48        6.02           -0.96  \n",
              "260               0.61       13.80        6.49           -1.22  \n",
              "\n",
              "[261 rows x 9 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fcc961fd-fb71-4a12-b1c3-da8a48e596cb\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>name</th>\n",
              "      <th>area</th>\n",
              "      <th>area_land</th>\n",
              "      <th>area_water</th>\n",
              "      <th>population</th>\n",
              "      <th>population_growth</th>\n",
              "      <th>birth_rate</th>\n",
              "      <th>death_rate</th>\n",
              "      <th>migration_rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>2381740.0</td>\n",
              "      <td>2381740.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.417888e+07</td>\n",
              "      <td>1.34</td>\n",
              "      <td>18.52</td>\n",
              "      <td>4.32</td>\n",
              "      <td>-0.82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Angola</td>\n",
              "      <td>1246700.0</td>\n",
              "      <td>1246700.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.479529e+07</td>\n",
              "      <td>3.36</td>\n",
              "      <td>41.80</td>\n",
              "      <td>8.01</td>\n",
              "      <td>-0.19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Benin</td>\n",
              "      <td>112622.0</td>\n",
              "      <td>110622.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>1.375469e+07</td>\n",
              "      <td>3.34</td>\n",
              "      <td>41.15</td>\n",
              "      <td>8.01</td>\n",
              "      <td>0.24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Botswana</td>\n",
              "      <td>581730.0</td>\n",
              "      <td>566730.0</td>\n",
              "      <td>15000.0</td>\n",
              "      <td>2.384246e+06</td>\n",
              "      <td>1.40</td>\n",
              "      <td>20.28</td>\n",
              "      <td>9.05</td>\n",
              "      <td>2.81</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Burkina Faso</td>\n",
              "      <td>274200.0</td>\n",
              "      <td>273800.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>2.193539e+07</td>\n",
              "      <td>2.53</td>\n",
              "      <td>33.57</td>\n",
              "      <td>7.71</td>\n",
              "      <td>-0.61</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>256</th>\n",
              "      <td>India</td>\n",
              "      <td>3287263.0</td>\n",
              "      <td>2973193.0</td>\n",
              "      <td>314070.0</td>\n",
              "      <td>1.389637e+09</td>\n",
              "      <td>0.67</td>\n",
              "      <td>16.82</td>\n",
              "      <td>10.30</td>\n",
              "      <td>0.16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>Maldives</td>\n",
              "      <td>298.0</td>\n",
              "      <td>298.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3.901640e+05</td>\n",
              "      <td>-0.14</td>\n",
              "      <td>15.54</td>\n",
              "      <td>4.15</td>\n",
              "      <td>-12.78</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258</th>\n",
              "      <td>Nepal</td>\n",
              "      <td>147181.0</td>\n",
              "      <td>143351.0</td>\n",
              "      <td>3830.0</td>\n",
              "      <td>3.066660e+07</td>\n",
              "      <td>0.78</td>\n",
              "      <td>17.53</td>\n",
              "      <td>5.58</td>\n",
              "      <td>-4.21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>259</th>\n",
              "      <td>Pakistan</td>\n",
              "      <td>796095.0</td>\n",
              "      <td>770875.0</td>\n",
              "      <td>25220.0</td>\n",
              "      <td>2.429238e+08</td>\n",
              "      <td>1.95</td>\n",
              "      <td>26.48</td>\n",
              "      <td>6.02</td>\n",
              "      <td>-0.96</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>260</th>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>65610.0</td>\n",
              "      <td>64630.0</td>\n",
              "      <td>980.0</td>\n",
              "      <td>2.318752e+07</td>\n",
              "      <td>0.61</td>\n",
              "      <td>13.80</td>\n",
              "      <td>6.49</td>\n",
              "      <td>-1.22</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>261 rows × 9 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fcc961fd-fb71-4a12-b1c3-da8a48e596cb')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-fcc961fd-fb71-4a12-b1c3-da8a48e596cb button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-fcc961fd-fb71-4a12-b1c3-da8a48e596cb');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 61
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_new.to_csv('Factbook.csv')"
      ],
      "metadata": {
        "id": "Ua2ZDyww_5J1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "conn = sqlite3.connect('factbook.db')\n",
        "c = conn.cursor()"
      ],
      "metadata": {
        "id": "j0DX6YBmHwLk"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "c.execute('CREATE TABLE IF NOT EXISTS factbook (name text, area number,\tarea_land\tnumber, area_water\tnumber,\tpopulation\tnumber,\tpopulation_growth\tnumber,\tbirth_rate\tnumber,\tdeath_rate\tnumber,\tmigration_rate\tnumber)')\n",
        "conn.commit()"
      ],
      "metadata": {
        "id": "QhVozBY8JKqr"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_new.to_sql('factbook', conn, if_exists='replace', index = False)"
      ],
      "metadata": {
        "id": "w_Fnzxw6Jz71"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "%%capture\n",
        "%load_ext sql\n",
        "%sql sqlite:///factbook.db "
      ],
      "metadata": {
        "id": "nijF9fDzKOrb"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "\n",
        "SELECT *\n",
        "  FROM sqlite_master\n",
        " WHERE type='table';"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "kI5n1d5sKSa_",
        "outputId": "9f56bda0-6b51-4275-c11f-3897b8d554fa"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('table', 'factbook', 'factbook', 2, 'CREATE TABLE \"factbook\" (\\n\"name\" TEXT,\\n  \"area\" REAL,\\n  \"area_land\" REAL,\\n  \"area_water\" REAL,\\n  \"population\" REAL,\\n  \"population_growth\" REAL,\\n  \"birth_rate\" REAL,\\n  \"death_rate\" REAL,\\n  \"migration_rate\" REAL\\n)')]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>type</th>\n",
              "            <th>name</th>\n",
              "            <th>tbl_name</th>\n",
              "            <th>rootpage</th>\n",
              "            <th>sql</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>table</td>\n",
              "            <td>factbook</td>\n",
              "            <td>factbook</td>\n",
              "            <td>2</td>\n",
              "            <td>CREATE TABLE &quot;factbook&quot; (<br>&quot;name&quot; TEXT,<br>  &quot;area&quot; REAL,<br>  &quot;area_land&quot; REAL,<br>  &quot;area_water&quot; REAL,<br>  &quot;population&quot; REAL,<br>  &quot;population_growth&quot; REAL,<br>  &quot;birth_rate&quot; REAL,<br>  &quot;death_rate&quot; REAL,<br>  &quot;migration_rate&quot; REAL<br>)</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT *\n",
        "FROM factbook"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "LEbaQAyCKfoa",
        "outputId": "8b7a4b4a-350d-4cd8-f889-dec6af115a91"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Algeria', 2381740.0, 2381740.0, 0.0, 44178884.0, 1.34, 18.52, 4.32, -0.82),\n",
              " ('Angola', 1246700.0, 1246700.0, 0.0, 34795287.0, 3.36, 41.8, 8.01, -0.19),\n",
              " ('Benin', 112622.0, 110622.0, 2000.0, 13754688.0, 3.34, 41.15, 8.01, 0.24),\n",
              " ('Botswana', 581730.0, 566730.0, 15000.0, 2384246.0, 1.4, 20.28, 9.05, 2.81),\n",
              " ('Burkina Faso', 274200.0, 273800.0, 400.0, 21935389.0, 2.53, 33.57, 7.71, -0.61),\n",
              " ('Burundi', 27830.0, 25680.0, 2150.0, 12696478.0, 3.63, 35.17, 5.96, 7.09),\n",
              " ('Cabo Verde', 4033.0, 4033.0, 0.0, 596707.0, 1.21, 18.49, 5.8, -0.57),\n",
              " ('Cameroon', 475440.0, 472710.0, 2730.0, 29321637.0, 2.75, 35.53, 7.73, -0.31),\n",
              " ('Central African Republic', 622984.0, 622984.0, 0.0, 5454533.0, 1.78, 32.79, 11.76, -3.22),\n",
              " ('Chad', 1284000.0, 1259200.0, 24800.0, 17963211.0, 3.09, 40.45, 9.45, -0.13),\n",
              " ('Comoros', 2235.0, 2235.0, 0.0, 876437.0, 1.37, 22.52, 6.55, -2.25),\n",
              " ('Congo, Democratic Republic of the', 2344858.0, 2267048.0, 77810.0, 108407721.0, 3.14, 40.08, 7.94, -0.71),\n",
              " ('Congo, Republic of the', 342000.0, 341500.0, 500.0, 5546307.0, 2.34, 31.82, 8.38, 0.0),\n",
              " ('Cote dâ\\x80\\x99Ivoire', 322463.0, 318003.0, 4460.0, 28713423.0, 2.19, 28.3, 7.6, 1.18),\n",
              " ('Djibouti', 23200.0, 23180.0, 20.0, 957273.0, 1.97, 22.25, 7.12, 4.59),\n",
              " ('Egypt', 1001450.0, 995450.0, 6000.0, 107770524.0, 1.68, 21.46, 4.32, -0.31),\n",
              " ('Equatorial Guinea', 28051.0, 28051.0, 0.0, 1679172.0, 3.5, 29.95, 8.95, 13.96),\n",
              " ('Eritrea', 117600.0, 101000.0, 16600.0, 6209262.0, 1.03, 27.04, 6.69, -10.11),\n",
              " ('Eswatini', 17364.0, 17204.0, 160.0, 1121761.0, 0.75, 23.35, 9.71, -6.16),\n",
              " ('Ethiopia', 1104300.0, 1096570.0, 7730.0, 113656596.0, 2.46, 30.49, 5.7, -0.19),\n",
              " ('Gabon', 267667.0, 257667.0, 10000.0, 2340613.0, 2.4, 26.03, 5.67, 3.67),\n",
              " ('Gambia, The', 11300.0, 10120.0, 1180.0, 2413403.0, 2.29, 28.78, 5.81, -0.04),\n",
              " ('Ghana', 238533.0, 227533.0, 11000.0, 33107275.0, 2.23, 28.55, 6.14, -0.16),\n",
              " ('Guinea', 245857.0, 245717.0, 140.0, 13237832.0, 2.76, 35.67, 8.12, 0.0),\n",
              " ('Guinea-Bissau', 36125.0, 28120.0, 8005.0, 2026778.0, 2.53, 36.45, 7.5, -3.63),\n",
              " ('Kenya', 580367.0, 569140.0, 11227.0, 55864655.0, 2.12, 26.39, 5.01, -0.19),\n",
              " ('Lesotho', 30355.0, 30355.0, 0.0, 2193970.0, 0.76, 23.15, 11.05, -4.55),\n",
              " ('Liberia', 111369.0, 96320.0, 15049.0, 5358483.0, 2.73, 36.64, 6.62, -2.74),\n",
              " ('Libya', 1759540.0, 1759540.0, 0.0, 7137931.0, 1.65, 21.56, 3.45, -1.61),\n",
              " ('Madagascar', 587041.0, 581540.0, 5501.0, 28172462.0, 2.27, 28.68, 6.0, 0.0),\n",
              " ('Malawi', 118484.0, 94080.0, 24404.0, 20794353.0, 2.34, 27.94, 4.58, 0.0),\n",
              " ('Mali', 1240192.0, 1220190.0, 20002.0, 20741769.0, 2.95, 41.07, 8.53, -3.08),\n",
              " ('Mauritania', 1030700.0, 1030700.0, 0.0, 4161925.0, 1.99, 28.06, 7.43, -0.72),\n",
              " ('Mauritius', 2040.0, 2030.0, 10.0, 1308222.0, 0.1, 9.86, 8.86, 0.0),\n",
              " ('Morocco', 716550.0, 716300.0, 250.0, 36738229.0, 0.91, 17.42, 6.6, -1.74),\n",
              " ('Mozambique', 799380.0, 786380.0, 13000.0, 31693239.0, 2.56, 37.47, 10.25, -1.58),\n",
              " ('Namibia', 824292.0, 823290.0, 1002.0, 2727409.0, 1.82, 25.01, 6.85, 0.0),\n",
              " ('Niger', 1267000.0, 1266700.0, 300.0, 24484587.0, 3.66, 47.08, 9.87, -0.64),\n",
              " ('Nigeria', 923768.0, 910768.0, 13000.0, 225082083.0, 2.53, 34.19, 8.7, -0.21),\n",
              " ('Rwanda', 26338.0, 24668.0, 1670.0, 13173730.0, 1.74, 26.44, 5.86, -3.21),\n",
              " ('Saint Helena, Ascension, and Tristan da Cunha', 394.0, 122.0, 0.0, 7925.0, 0.13, 9.34, 8.08, 0.0),\n",
              " ('Sao Tome and Principe', 964.0, 964.0, 0.0, 217164.0, 1.48, 28.19, 6.2, -7.19),\n",
              " ('Senegal', 196722.0, 192530.0, 4192.0, 17923036.0, 2.57, 31.51, 5.08, -0.71),\n",
              " ('Seychelles', 455.0, 455.0, 0.0, 97017.0, 0.64, 12.37, 6.88, 0.86),\n",
              " ('Sierra Leone', 71740.0, 71620.0, 120.0, 8692606.0, 2.49, 32.2, 9.32, 2.03),\n",
              " ('Somalia', 637657.0, 627337.0, 10320.0, 12386248.0, 2.42, 37.98, 11.62, -2.18),\n",
              " ('South Africa', 1219090.0, 1214470.0, 4620.0, 57516665.0, 0.93, 18.56, 9.26, 0.0),\n",
              " ('South Sudan', 644329.0, None, None, 11544905.0, 4.91, 37.69, 9.52, 20.97),\n",
              " ('Sudan', 1861484.0, 1731671.0, 129813.0, 47958856.0, 2.55, 33.47, 6.3, -1.67),\n",
              " ('Tanzania', 947300.0, 885800.0, 61500.0, 63852892.0, 2.78, 33.3, 5.09, -0.41),\n",
              " ('Togo', 56785.0, 54385.0, 2400.0, 8492333.0, 2.48, 31.86, 5.27, -1.81),\n",
              " ('Tunisia', 163610.0, 155360.0, 8250.0, 11896972.0, 0.69, 14.62, 6.36, -1.33),\n",
              " ('Uganda', 241038.0, 197100.0, 43938.0, 46205893.0, 3.27, 40.94, 5.02, -3.26),\n",
              " ('Zambia', 752618.0, 743398.0, 9220.0, 19642123.0, 2.9, 34.86, 6.12, 0.24),\n",
              " ('Zimbabwe', 390757.0, 386847.0, 3910.0, 15121004.0, 1.95, 33.07, 8.76, -4.83),\n",
              " ('Antarctica', 14.2, 14.2, 13.915, None, None, None, None, None),\n",
              " ('Bouvet Island', 49.0, 49.0, 0.0, None, None, None, None, None),\n",
              " ('French Southern and Antarctic Lands', 55.0, 55.0, 0.0, None, None, None, None, None),\n",
              " ('Heard Island and McDonald Islands', 412.0, 412.0, 0.0, None, None, None, None, None),\n",
              " ('American Samoa', 224.0, 224.0, 0.0, 45443.0, -1.92, 16.7, 6.1, -29.8),\n",
              " ('Ashmore and Cartier Islands', 5.0, 5.0, 0.0, None, None, None, None, None),\n",
              " ('Australia', 7741220.0, 7682300.0, 58920.0, 26141369.0, 1.25, 12.3, 6.77, 6.93),\n",
              " ('Baker Island', None, None, None, None, None, None, None, None),\n",
              " ('Christmas Island', 135.0, 135.0, 0.0, 2205.0, 1.11, None, None, None),\n",
              " ('Cocos (Keeling) Islands', 14.0, 14.0, 0.0, 596.0, None, None, 8.89, None),\n",
              " ('Cook Islands', 236.0, 236.0, 0.0, 8128.0, -2.39, 12.55, 9.1, -27.31),\n",
              " ('Coral Sea Islands', 3.0, 3.0, 0.0, None, None, None, None, None),\n",
              " ('Fiji', 18274.0, 18274.0, 0.0, 943737.0, 0.44, 16.56, 6.37, -5.84),\n",
              " ('French Polynesia', 4167.0, 67.0, 3827.0, 299356.0, 0.73, 13.47, 5.59, -0.63),\n",
              " ('Guam', 544.0, 544.0, 0.0, 169086.0, 0.16, 18.56, 6.03, -10.96),\n",
              " ('Howland Island', None, None, None, None, None, None, None, None),\n",
              " ('Jarvis Island', None, None, None, None, None, None, None, None),\n",
              " ('Johnston Atoll', None, None, None, None, None, None, None, None),\n",
              " ('Kingman Reef', None, None, None, None, None, None, None, None),\n",
              " ('Kiribati', 811.0, 811.0, 0.0, 114189.0, 1.04, 20.12, 6.92, -2.8),\n",
              " ('Marshall Islands', 181.0, 181.0, 0.0, 79906.0, 1.34, 22.0, 4.28, -4.37),\n",
              " ('Micronesia, Federated States of', 702.0, 702.0, 0.0, 101009.0, -0.67, 18.39, 4.19, -20.91),\n",
              " ('Midway Islands', None, None, None, None, None, None, None, None),\n",
              " ('Nauru', 21.0, 21.0, 0.0, 9811.0, 0.42, 21.1, 6.32, -10.6),\n",
              " ('New Caledonia', 18575.0, 18275.0, 300.0, 297160.0, 1.19, 14.13, 5.88, 3.66),\n",
              " ('New Zealand', 268838.0, 264537.0, 4301.0, 5053004.0, 1.17, 12.78, 6.89, 5.83),\n",
              " ('Niue', 260.0, 260.0, 0.0, 2000.0, -0.03, None, None, None),\n",
              " ('Norfolk Island', 36.0, 36.0, 0.0, 1748.0, 0.01, None, None, None),\n",
              " ('Northern Mariana Islands', 464.0, 464.0, 0.0, 51475.0, -0.35, 15.5, 5.44, -13.6),\n",
              " ('Palau', 459.0, 459.0, 0.0, 21695.0, 0.39, 11.52, 8.25, 0.6),\n",
              " ('Palmyra Atoll', None, None, None, None, None, None, None, None),\n",
              " ('Pitcairn Islands', 47.0, 47.0, 0.0, 50.0, 0.0, None, None, None),\n",
              " ('Samoa', 2831.0, 2821.0, 10.0, 206179.0, 0.63, 19.21, 5.37, -7.51),\n",
              " ('Solomon Islands', 28896.0, 27986.0, 910.0, 702694.0, 1.72, 22.71, 3.96, -1.55),\n",
              " ('Tokelau', 12.0, 12.0, 0.0, 1647.0, -0.01, None, -3.84, None),\n",
              " ('Tonga', 747.0, 717.0, 30.0, 105517.0, -0.26, 20.31, 4.95, -18.01),\n",
              " ('Tuvalu', 26.0, 26.0, 0.0, 11544.0, 0.83, 22.7, 7.97, -6.41),\n",
              " ('United States Pacific Island Wildlife Refuges', 6959.41, 22.41, 6937.0, None, None, None, None, None),\n",
              " ('Vanuatu', 12189.0, 12189.0, 0.0, 308043.0, 1.63, 21.57, 3.98, -1.3),\n",
              " ('Wake Island', 7.0, 6.5, 0.0, None, None, None, None, None),\n",
              " ('Wallis and Futuna', 142.0, 142.0, 0.0, 15891.0, 0.25, 12.27, 5.79, -3.96),\n",
              " ('Anguilla', 91.0, 91.0, 0.0, 18741.0, 1.8, 12.01, 4.64, 10.67),\n",
              " ('Antigua and Barbuda', 443.0, 280.0, 161.0, 100335.0, 1.15, 15.16, 5.65, 2.03),\n",
              " ('Aruba', 180.0, 180.0, 0.0, 122320.0, 1.14, 11.82, 8.62, 8.18),\n",
              " ('Bahamas, The', 13880.0, 10010.0, 3870.0, 355608.0, 0.82, 14.64, 6.41, 0.0),\n",
              " ('Barbados', 430.0, 430.0, 0.0, 302674.0, 0.26, 10.83, 7.96, -0.29),\n",
              " ('Belize', 22966.0, 22806.0, 160.0, 412387.0, 1.64, 21.28, 3.94, -0.96),\n",
              " ('British Virgin Islands', 151.0, 151.0, 0.0, 38632.0, 1.91, 10.95, 5.38, 13.56),\n",
              " ('Cayman Islands', 264.0, 264.0, 0.0, 64309.0, 1.83, 11.69, 5.97, 12.56),\n",
              " ('Costa Rica', 51100.0, 51060.0, 40.0, 5204411.0, 1.01, 14.28, 4.91, 0.77),\n",
              " ('Cuba', 110860.0, 109820.0, 1040.0, 11008112.0, -0.21, 10.11, 9.29, -2.92),\n",
              " ('Curacao', 444.0, 444.0, 0.0, 152379.0, 0.32, 13.2, 8.71, -1.31),\n",
              " ('Dominica', 751.0, 751.0, None, 74629.0, 0.05, 13.91, 8.11, -5.31),\n",
              " ('Dominican Republic', 48670.0, 48320.0, 350.0, 10694700.0, 0.91, 18.03, 6.29, -2.68),\n",
              " ('El Salvador', 21041.0, 20721.0, 320.0, 6568745.0, 0.57, 17.87, 5.91, -6.29),\n",
              " ('Grenada', 344.0, 344.0, 0.0, 113949.0, 0.32, 13.94, 8.31, -2.43),\n",
              " ('Guatemala', 108889.0, 107159.0, 1730.0, 17703190.0, 1.58, 22.34, 4.91, -1.66),\n",
              " ('Haiti', 27750.0, 27560.0, 190.0, 11334637.0, 1.2, 21.12, 7.23, -1.88),\n",
              " ('Honduras', 112090.0, 111890.0, 200.0, 9459440.0, 1.19, 17.92, 4.68, -1.34),\n",
              " ('Jamaica', 10991.0, 10831.0, 160.0, 2818596.0, 0.08, 15.91, 7.43, -7.7),\n",
              " ('Montserrat', 102.0, 102.0, 0.0, 5414.0, 0.5, 10.9, 5.91, 0.0),\n",
              " ('Navassa Island', 5.0, 5.4, 0.0, None, None, None, None, None),\n",
              " ('Nicaragua', 130370.0, 119990.0, 10380.0, 6301880.0, 0.92, 16.52, 5.17, -2.15),\n",
              " ('Panama', 75420.0, 74340.0, 1080.0, 4337768.0, 1.53, 17.99, 6.11, 3.42),\n",
              " ('Puerto Rico', 9104.0, 8959.0, 145.0, 3098423.0, -1.38, 7.87, 9.76, -11.9),\n",
              " ('Saint Barthelemy', 25.0, 25.0, None, 7103.0, -0.16, 9.29, 9.01, -1.83),\n",
              " ('Saint Kitts and Nevis', 261.0, 168.0, 93.0, 54488.0, 0.61, 12.24, 7.27, 1.16),\n",
              " ('Saint Lucia', 616.0, 606.0, 10.0, 167122.0, 0.29, 12.02, 8.07, -1.09),\n",
              " ('Saint Martin', 50.0, 50.0, None, 32792.0, 0.33, 14.09, 4.64, -6.13),\n",
              " ('Saint Vincent and the Grenadines', 389.0, 344.0, 389.0, 100969.0, -0.17, 12.27, 7.49, -6.47),\n",
              " ('Sint Maarten', 34.0, 34.0, 0.0, 45126.0, 1.23, 12.56, 6.07, 5.83),\n",
              " ('Trinidad and Tobago', 5128.0, 5128.0, 0.0, 1405646.0, 0.14, 10.79, 8.38, -1.01),\n",
              " ('Turks and Caicos Islands', 948.0, 948.0, 0.0, 58286.0, 1.86, 13.54, 3.5, 8.58),\n",
              " ('Virgin Islands', 1910.0, 346.0, 1564.0, 105413.0, -0.45, 11.63, 8.78, -7.35),\n",
              " ('Kazakhstan', 2724900.0, 2699700.0, 25200.0, 19398331.0, 0.77, 15.38, 8.11, 0.39),\n",
              " ('Kyrgyzstan', 199951.0, 191801.0, 8150.0, 6071750.0, 0.86, 19.54, 6.12, -4.87),\n",
              " ('Russia', 17098242.0, 16377742.0, 720500.0, 142021981.0, -0.22, 9.45, 13.36, 1.7),\n",
              " ('Tajikistan', 144100.0, 141510.0, 2590.0, 9119347.0, 1.4, 20.73, 5.72, -1.03),\n",
              " ('Turkmenistan', 488100.0, 469930.0, 18170.0, 5636011.0, 0.99, 17.51, 5.95, -1.71),\n",
              " ('Uzbekistan', 447400.0, 425400.0, 22000.0, 31104937.0, 0.83, 15.53, 5.41, -1.78),\n",
              " ('Brunei', 5765.0, 5265.0, 500.0, 478054.0, 1.45, 16.14, 3.79, 2.18),\n",
              " ('Burma', 676578.0, 653508.0, 23070.0, 57526449.0, 0.78, 16.34, 7.13, -1.37),\n",
              " ('Cambodia', 181035.0, 176515.0, 4520.0, 16713015.0, 1.08, 19.29, 5.76, -2.7),\n",
              " ('China', 9596960.0, 9326410.0, 270550.0, 1410539758.0, 0.19, 9.93, 7.9, -0.11),\n",
              " ('Hong Kong', 1108.0, 1073.0, 35.0, 7276588.0, 0.17, 8.04, 7.98, 1.65),\n",
              " ('Indonesia', 1904569.0, 1811569.0, 93000.0, 277329163.0, 0.79, 15.32, 6.75, -0.71),\n",
              " ('Japan', 377915.0, 364485.0, 13430.0, 124214766.0, -0.39, 6.95, 11.59, 0.74),\n",
              " ('Korea, North', 120538.0, 120408.0, 130.0, 25955138.0, 0.46, 14.21, 9.53, -0.04),\n",
              " ('Korea, South', 99720.0, 96920.0, 2800.0, 51844834.0, 0.24, 6.92, 7.12, 2.63),\n",
              " ('Laos', 236800.0, 230800.0, 6000.0, 7749595.0, 1.34, 20.9, 6.37, -1.17),\n",
              " ('Macau', 28.0, 28.2, 0.0, 635293.0, 0.75, 9.11, 4.72, 3.15),\n",
              " ('Malaysia', 329847.0, 328657.0, 1190.0, 33871431.0, 1.03, 14.55, 5.69, 1.48),\n",
              " ('Mongolia', 1564116.0, 1553556.0, 10560.0, 3227863.0, 0.88, 15.84, 6.3, -0.77),\n",
              " ('Papua New Guinea', 462840.0, 452860.0, 9980.0, 9593498.0, 2.35, 29.03, 5.54, 0.0),\n",
              " ('Paracel Islands', 8.0, 7.75, 0.0, 1440.0, None, None, None, None),\n",
              " ('Philippines', 300000.0, 298170.0, 1830.0, 114597229.0, 1.6, 22.28, 6.41, 0.13),\n",
              " ('Singapore', 719.0, 709.2, 10.0, 5921231.0, 0.92, 9.05, 4.04, 4.22),\n",
              " ('Spratly Islands', 5.0, 5.0, 0.0, None, None, None, None, None),\n",
              " ('Taiwan', 35980.0, 32260.0, 3720.0, 23580712.0, 0.04, 7.39, 7.89, 0.85),\n",
              " ('Thailand', 513120.0, 510890.0, 2230.0, 69648117.0, 0.23, 10.14, 7.76, -0.13),\n",
              " ('Timor-Leste', 14874.0, 14874.0, 0.0, 1445006.0, 2.15, 30.94, 5.61, -3.82),\n",
              " ('Vietnam', 331210.0, 310070.0, 21140.0, 103808319.0, 0.97, 15.69, 5.77, -0.22),\n",
              " ('Akrotiri', 123.0, None, None, None, None, None, None, None),\n",
              " ('Albania', 28748.0, 27398.0, 1350.0, 3095344.0, 0.22, 12.69, 7.31, -3.23),\n",
              " ('Andorra', 468.0, 468.0, 0.0, 85560.0, -0.1, 6.88, 7.92, 0.0),\n",
              " ('Austria', 83871.0, 82445.0, 1426.0, 8913088.0, 0.32, 9.45, 9.85, 3.55),\n",
              " ('Belarus', 207600.0, 202900.0, 4700.0, 9413505.0, -0.31, 9.08, 12.88, 0.72),\n",
              " ('Belgium', 30528.0, 30278.0, 250.0, 11847338.0, 0.57, 10.95, 9.64, 4.38),\n",
              " ('Bosnia and Herzegovina', 51197.0, 51187.0, 10.0, 3816459.0, -0.22, 8.41, 10.26, -0.38),\n",
              " ('Bulgaria', 110879.0, 108489.0, 2390.0, 6873253.0, -0.67, 8.05, 14.41, -0.29),\n",
              " ('Croatia', 56594.0, 55974.0, 620.0, 4188853.0, -0.47, 8.65, 12.88, -0.5),\n",
              " ('Cyprus', 9251.0, 3355.0, 9241.0, 1295102.0, 1.06, 10.57, 6.94, 6.96),\n",
              " ('Czechia', 78867.0, 77247.0, 1620.0, 10705384.0, 0.02, 8.59, 10.74, 2.32),\n",
              " ('Denmark', 43094.0, 42434.0, 660.0, 5920767.0, 0.44, 11.22, 9.52, 2.73),\n",
              " ('Dhekelia', 131.0, None, None, None, None, None, None, None),\n",
              " ('Estonia', 45228.0, 42388.0, 2840.0, 1211524.0, -0.71, 8.75, 13.1, -2.79),\n",
              " ('European Union', None, None, None, None, None, None, None, -2.85),\n",
              " ('Faroe Islands', 1393.0, 1393.0, 0.0, 52269.0, 0.63, 14.94, 8.63, 0.0),\n",
              " ('Finland', 338145.0, 303815.0, 34330.0, 5601547.0, 0.24, 10.42, 10.35, 2.35),\n",
              " ('France', 643801.0, 551500.0, 640427.0, 68305148.0, 0.32, 11.66, 9.54, 1.06),\n",
              " ('Germany', 357022.0, 348672.0, 8350.0, 84316622.0, -0.11, 9.08, 11.98, 1.78),\n",
              " ('Gibraltar', 7.0, 6.5, 0.0, 29573.0, 0.19, 13.93, 8.76, -3.25),\n",
              " ('Greece', 131957.0, 130647.0, 1310.0, 10533871.0, -0.34, 7.61, 12.04, 1.0),\n",
              " ('Guernsey', 78.0, 78.0, 0.0, 67491.0, 0.23, 9.75, 9.17, 1.7),\n",
              " ('Holy See (Vatican City)', 0.0, 0.44, 0.0, 1000.0, 0.0, None, None, None),\n",
              " ('Hungary', 93028.0, 89608.0, 3420.0, 9699577.0, -0.3, 8.65, 12.88, 1.23),\n",
              " ('Iceland', 103000.0, 100250.0, 2750.0, 357603.0, 0.93, 12.96, 6.56, 2.89),\n",
              " ('Ireland', 70273.0, 68883.0, 1390.0, 5275004.0, 0.94, 12.32, 6.73, 3.79),\n",
              " ('Isle of Man', 572.0, 572.0, 0.0, 91382.0, 0.52, 10.58, 10.18, 4.76),\n",
              " ('Italy', 301340.0, 294140.0, 7200.0, 61095551.0, -0.13, 6.95, 11.31, 3.02),\n",
              " ('Jan Mayen', 377.0, 377.0, 0.0, None, None, None, None, None),\n",
              " ('Jersey', 116.0, 116.0, 0.0, 102146.0, 0.64, 12.41, 7.75, 1.76),\n",
              " ('Kosovo', 10887.0, 10887.0, 0.0, 1952701.0, 0.57, 14.85, 8.12, -1.07),\n",
              " ('Latvia', 64589.0, 62249.0, 2340.0, 1842226.0, -1.11, 8.73, 14.65, -5.19),\n",
              " ('Liechtenstein', 160.0, 160.0, 0.0, 39711.0, 0.72, 10.32, 7.98, 4.81),\n",
              " ('Lithuania', 65300.0, 62680.0, 2620.0, 2683546.0, -1.04, 9.26, 15.12, -4.54),\n",
              " ('Luxembourg', 2586.0, 2586.0, 0.0, 650364.0, 1.64, 11.61, 7.21, 12.01),\n",
              " ('Malta', 316.0, 316.0, 0.0, 464186.0, 0.67, 9.73, 8.48, 5.49),\n",
              " ('Moldova', 33851.0, 32891.0, 960.0, 3287326.0, -1.12, 10.19, 12.47, -8.87),\n",
              " ('Monaco', 2.0, 2.0, 0.0, 31400.0, 0.6, 6.66, 10.7, 10.03),\n",
              " ('Montenegro', 13812.0, 13452.0, 360.0, 604966.0, -0.41, 11.19, 10.33, -4.97),\n",
              " ('Netherlands', 41543.0, 33893.0, 7650.0, 17400824.0, 0.36, 10.99, 9.24, 1.9),\n",
              " ('North Macedonia', 25713.0, 25433.0, 280.0, 2130936.0, 0.12, 10.45, 9.61, 0.38),\n",
              " ('Norway', 323802.0, 304282.0, 19520.0, 5553840.0, 0.8, 12.0, 7.96, 3.92),\n",
              " ('Poland', 312685.0, 304255.0, 8430.0, 38093101.0, -0.26, 8.5, 10.71, -0.33),\n",
              " ('Portugal', 92090.0, 91470.0, 620.0, 10242081.0, -0.2, 8.0, 10.9, 0.91),\n",
              " ('Romania', 238391.0, 229891.0, 8500.0, 18519899.0, -1.09, 8.76, 15.26, -4.36),\n",
              " ('San Marino', 61.0, 61.0, 0.0, 34682.0, 0.61, 8.85, 8.82, 6.11),\n",
              " ('Serbia', 77474.0, 77474.0, 0.0, 6739471.0, -0.75, 8.92, 16.39, 0.0),\n",
              " ('Slovakia', 49035.0, 48105.0, 930.0, 5431252.0, -0.1, 8.94, 10.13, 0.2),\n",
              " ('Slovenia', 20273.0, 20151.0, 122.0, 2101208.0, -0.06, 8.3, 10.4, 1.54),\n",
              " ('Spain', 505370.0, 498980.0, 6390.0, 47163418.0, 0.13, 7.13, 10.22, 4.35),\n",
              " ('Svalbard', 62045.0, 62045.0, 0.0, 2926.0, -0.03, None, None, -5.57),\n",
              " ('Sweden', 450295.0, 410335.0, 39960.0, 10483647.0, 0.5, 10.83, 9.46, 3.6),\n",
              " ('Switzerland', 41277.0, 39997.0, 1280.0, 8508698.0, 0.65, 10.36, 8.4, 4.52),\n",
              " ('Ukraine', 603550.0, 579330.0, 24220.0, 43528136.0, -0.5, 9.0, 13.77, -0.26),\n",
              " ('United Kingdom', 243610.0, 241930.0, 1680.0, 67791400.0, 0.53, 10.79, 9.07, 3.59),\n",
              " ('Armenia', 29743.0, 28203.0, 1540.0, 3000756.0, -0.38, 11.1, 9.51, -5.36),\n",
              " ('Azerbaijan', 86600.0, 82629.0, 3971.0, 10353296.0, 0.67, 13.59, 6.92, 0.0),\n",
              " ('Bahrain', 760.0, 760.0, 0.0, 1540558.0, 0.88, 12.4, 2.82, -0.82),\n",
              " ('Gaza Strip', 360.0, 360.0, 0.0, 1997328.0, 2.02, 27.67, 2.91, -4.55),\n",
              " ('Georgia', 69700.0, 69700.0, 0.0, 4935518.0, 0.03, 11.0, 10.8, 0.06),\n",
              " ('Iran', 1648195.0, 1531595.0, 116600.0, 86758304.0, 0.98, 15.27, 5.17, -0.3),\n",
              " ('Iraq', 438317.0, 437367.0, 950.0, 40462701.0, 2.0, 24.7, 3.9, -0.83),\n",
              " ('Israel', 21937.0, 21497.0, 440.0, 8914885.0, 1.44, 17.41, 5.05, 2.02),\n",
              " ('Jordan', 89342.0, 88802.0, 540.0, 10998531.0, 0.81, 22.58, 3.45, -11.08),\n",
              " ('Kuwait', 17818.0, 17818.0, 0.0, 3068155.0, 1.17, 17.78, 2.25, -3.87),\n",
              " ('Lebanon', 10400.0, 10230.0, 170.0, 5296814.0, 0.66, 13.1, 5.57, -0.94),\n",
              " ('Oman', 309500.0, 309500.0, 0.0, 3764348.0, 1.84, 22.11, 3.23, -0.45),\n",
              " ('Qatar', 11586.0, 11586.0, 0.0, 2508182.0, 1.04, 9.33, 1.42, 2.45),\n",
              " ('Saudi Arabia', 2149690.0, 2149690.0, 0.0, 35354380.0, 1.63, 14.22, 3.42, 5.52),\n",
              " ('Syria', 187437.0, 185887.0, 1550.0, 21563800.0, 5.91, 22.72, 4.22, 40.58),\n",
              " ('Turkey (Turkiye)', 783562.0, 769632.0, 13930.0, 83047706.0, 0.67, 14.28, 6.05, -1.54),\n",
              " ('United Arab Emirates', 83600.0, 83600.0, 0.0, 9915803.0, 0.58, 10.81, 1.56, -3.45),\n",
              " ('West Bank', 5860.0, 5640.0, 220.0, 3000021.0, 1.69, 24.42, 3.4, -4.09),\n",
              " ('Yemen', 527968.0, 527968.0, 0.0, 30984689.0, 1.88, 24.64, 5.62, -0.19),\n",
              " ('Bermuda', 54.0, 54.0, 0.0, 72337.0, 0.34, 11.03, 9.11, 1.49),\n",
              " ('Canada', 9984670.0, 9093507.0, 891163.0, 38232593.0, 0.75, 10.17, 8.12, 5.46),\n",
              " ('Clipperton Island', 6.0, 6.0, 0.0, None, None, None, None, None),\n",
              " ('Greenland', 2166086.0, 2166086.0, 1710000.0, 57792.0, -0.02, 13.79, 8.96, -5.0),\n",
              " ('Mexico', 1964375.0, 1943945.0, 20430.0, 129150971.0, 0.51, 13.55, 7.71, -0.76),\n",
              " ('Saint Pierre and Miquelon', 242.0, 242.0, 0.0, 5257.0, -1.2, 6.47, 11.22, -7.23),\n",
              " ('United States', 9833517.0, 9147593.0, 685924.0, 337341954.0, 0.69, 12.28, 8.38, 3.02),\n",
              " ('Argentina', 2780400.0, 2736690.0, 43710.0, 46245668.0, 0.82, 15.58, 7.32, -0.08),\n",
              " ('Bolivia', 1098581.0, 1083301.0, 15280.0, 12054379.0, 1.12, 18.61, 6.48, -0.98),\n",
              " ('Brazil', 8515770.0, 8358140.0, 157630.0, 217240060.0, 0.7, 13.96, 6.81, -0.19),\n",
              " ('Chile', 756102.0, 743812.0, 12290.0, 18430408.0, 0.66, 12.75, 6.52, 0.33),\n",
              " ('Colombia', 1138910.0, 1038700.0, 100210.0, 49059221.0, 0.59, 15.21, 7.73, -1.58),\n",
              " ('Ecuador', 283561.0, 276841.0, 6720.0, 17289554.0, 1.13, 16.45, 5.17, 0.0),\n",
              " ('Falkland Islands (Islas Malvinas)', 12173.0, 12173.0, 0.0, 3198.0, 0.01, 10.9, 4.9, None),\n",
              " ('Guyana', 214969.0, 196849.0, 18120.0, 789683.0, 0.24, 16.72, 6.91, -7.42),\n",
              " ('Paraguay', 406752.0, 397302.0, 9450.0, 7356409.0, 1.14, 16.32, 4.87, -0.07),\n",
              " ('Peru', 1285216.0, 1279996.0, 5220.0, 32275736.0, 0.51, 17.21, 11.32, -0.75),\n",
              " ('South Georgia and South Sandwich Islands', 3903.0, 3903.0, 0.0, None, None, None, None, None),\n",
              " ('Suriname', 163820.0, 156000.0, 7820.0, 632638.0, 1.13, 15.38, 6.59, 2.54),\n",
              " ('Uruguay', 176215.0, 175015.0, 1200.0, 3407213.0, 0.27, 12.71, 9.18, -0.88),\n",
              " ('Venezuela', 912050.0, 882050.0, 30000.0, 29789730.0, 2.43, 17.27, 6.81, 13.88),\n",
              " ('Afghanistan', 652230.0, 652230.0, 0.0, 38346720.0, 2.3, 35.46, 12.33, -0.1),\n",
              " ('Bangladesh', 148460.0, 130170.0, 18290.0, 165650475.0, 0.93, 17.69, 5.47, -2.9),\n",
              " ('Bhutan', 38394.0, 38394.0, 0.0, 867775.0, 0.97, 15.94, 6.22, 0.0),\n",
              " ('British Indian Ocean Territory', 60.0, 60.0, 54340.0, None, None, None, None, None),\n",
              " ('India', 3287263.0, 2973193.0, 314070.0, 1389637446.0, 0.67, 16.82, 10.3, 0.16),\n",
              " ('Maldives', 298.0, 298.0, 0.0, 390164.0, -0.14, 15.54, 4.15, -12.78),\n",
              " ('Nepal', 147181.0, 143351.0, 3830.0, 30666598.0, 0.78, 17.53, 5.58, -4.21),\n",
              " ('Pakistan', 796095.0, 770875.0, 25220.0, 242923845.0, 1.95, 26.48, 6.02, -0.96),\n",
              " ('Sri Lanka', 65610.0, 64630.0, 980.0, 23187516.0, 0.61, 13.8, 6.49, -1.22)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>area</th>\n",
              "            <th>area_land</th>\n",
              "            <th>area_water</th>\n",
              "            <th>population</th>\n",
              "            <th>population_growth</th>\n",
              "            <th>birth_rate</th>\n",
              "            <th>death_rate</th>\n",
              "            <th>migration_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Algeria</td>\n",
              "            <td>2381740.0</td>\n",
              "            <td>2381740.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>44178884.0</td>\n",
              "            <td>1.34</td>\n",
              "            <td>18.52</td>\n",
              "            <td>4.32</td>\n",
              "            <td>-0.82</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Angola</td>\n",
              "            <td>1246700.0</td>\n",
              "            <td>1246700.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>34795287.0</td>\n",
              "            <td>3.36</td>\n",
              "            <td>41.8</td>\n",
              "            <td>8.01</td>\n",
              "            <td>-0.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Benin</td>\n",
              "            <td>112622.0</td>\n",
              "            <td>110622.0</td>\n",
              "            <td>2000.0</td>\n",
              "            <td>13754688.0</td>\n",
              "            <td>3.34</td>\n",
              "            <td>41.15</td>\n",
              "            <td>8.01</td>\n",
              "            <td>0.24</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Botswana</td>\n",
              "            <td>581730.0</td>\n",
              "            <td>566730.0</td>\n",
              "            <td>15000.0</td>\n",
              "            <td>2384246.0</td>\n",
              "            <td>1.4</td>\n",
              "            <td>20.28</td>\n",
              "            <td>9.05</td>\n",
              "            <td>2.81</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Burkina Faso</td>\n",
              "            <td>274200.0</td>\n",
              "            <td>273800.0</td>\n",
              "            <td>400.0</td>\n",
              "            <td>21935389.0</td>\n",
              "            <td>2.53</td>\n",
              "            <td>33.57</td>\n",
              "            <td>7.71</td>\n",
              "            <td>-0.61</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Burundi</td>\n",
              "            <td>27830.0</td>\n",
              "            <td>25680.0</td>\n",
              "            <td>2150.0</td>\n",
              "            <td>12696478.0</td>\n",
              "            <td>3.63</td>\n",
              "            <td>35.17</td>\n",
              "            <td>5.96</td>\n",
              "            <td>7.09</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cabo Verde</td>\n",
              "            <td>4033.0</td>\n",
              "            <td>4033.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>596707.0</td>\n",
              "            <td>1.21</td>\n",
              "            <td>18.49</td>\n",
              "            <td>5.8</td>\n",
              "            <td>-0.57</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cameroon</td>\n",
              "            <td>475440.0</td>\n",
              "            <td>472710.0</td>\n",
              "            <td>2730.0</td>\n",
              "            <td>29321637.0</td>\n",
              "            <td>2.75</td>\n",
              "            <td>35.53</td>\n",
              "            <td>7.73</td>\n",
              "            <td>-0.31</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Central African Republic</td>\n",
              "            <td>622984.0</td>\n",
              "            <td>622984.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>5454533.0</td>\n",
              "            <td>1.78</td>\n",
              "            <td>32.79</td>\n",
              "            <td>11.76</td>\n",
              "            <td>-3.22</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Chad</td>\n",
              "            <td>1284000.0</td>\n",
              "            <td>1259200.0</td>\n",
              "            <td>24800.0</td>\n",
              "            <td>17963211.0</td>\n",
              "            <td>3.09</td>\n",
              "            <td>40.45</td>\n",
              "            <td>9.45</td>\n",
              "            <td>-0.13</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Comoros</td>\n",
              "            <td>2235.0</td>\n",
              "            <td>2235.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>876437.0</td>\n",
              "            <td>1.37</td>\n",
              "            <td>22.52</td>\n",
              "            <td>6.55</td>\n",
              "            <td>-2.25</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Congo, Democratic Republic of the</td>\n",
              "            <td>2344858.0</td>\n",
              "            <td>2267048.0</td>\n",
              "            <td>77810.0</td>\n",
              "            <td>108407721.0</td>\n",
              "            <td>3.14</td>\n",
              "            <td>40.08</td>\n",
              "            <td>7.94</td>\n",
              "            <td>-0.71</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Congo, Republic of the</td>\n",
              "            <td>342000.0</td>\n",
              "            <td>341500.0</td>\n",
              "            <td>500.0</td>\n",
              "            <td>5546307.0</td>\n",
              "            <td>2.34</td>\n",
              "            <td>31.82</td>\n",
              "            <td>8.38</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cote dâIvoire</td>\n",
              "            <td>322463.0</td>\n",
              "            <td>318003.0</td>\n",
              "            <td>4460.0</td>\n",
              "            <td>28713423.0</td>\n",
              "            <td>2.19</td>\n",
              "            <td>28.3</td>\n",
              "            <td>7.6</td>\n",
              "            <td>1.18</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Djibouti</td>\n",
              "            <td>23200.0</td>\n",
              "            <td>23180.0</td>\n",
              "            <td>20.0</td>\n",
              "            <td>957273.0</td>\n",
              "            <td>1.97</td>\n",
              "            <td>22.25</td>\n",
              "            <td>7.12</td>\n",
              "            <td>4.59</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Egypt</td>\n",
              "            <td>1001450.0</td>\n",
              "            <td>995450.0</td>\n",
              "            <td>6000.0</td>\n",
              "            <td>107770524.0</td>\n",
              "            <td>1.68</td>\n",
              "            <td>21.46</td>\n",
              "            <td>4.32</td>\n",
              "            <td>-0.31</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Equatorial Guinea</td>\n",
              "            <td>28051.0</td>\n",
              "            <td>28051.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1679172.0</td>\n",
              "            <td>3.5</td>\n",
              "            <td>29.95</td>\n",
              "            <td>8.95</td>\n",
              "            <td>13.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Eritrea</td>\n",
              "            <td>117600.0</td>\n",
              "            <td>101000.0</td>\n",
              "            <td>16600.0</td>\n",
              "            <td>6209262.0</td>\n",
              "            <td>1.03</td>\n",
              "            <td>27.04</td>\n",
              "            <td>6.69</td>\n",
              "            <td>-10.11</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Eswatini</td>\n",
              "            <td>17364.0</td>\n",
              "            <td>17204.0</td>\n",
              "            <td>160.0</td>\n",
              "            <td>1121761.0</td>\n",
              "            <td>0.75</td>\n",
              "            <td>23.35</td>\n",
              "            <td>9.71</td>\n",
              "            <td>-6.16</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ethiopia</td>\n",
              "            <td>1104300.0</td>\n",
              "            <td>1096570.0</td>\n",
              "            <td>7730.0</td>\n",
              "            <td>113656596.0</td>\n",
              "            <td>2.46</td>\n",
              "            <td>30.49</td>\n",
              "            <td>5.7</td>\n",
              "            <td>-0.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gabon</td>\n",
              "            <td>267667.0</td>\n",
              "            <td>257667.0</td>\n",
              "            <td>10000.0</td>\n",
              "            <td>2340613.0</td>\n",
              "            <td>2.4</td>\n",
              "            <td>26.03</td>\n",
              "            <td>5.67</td>\n",
              "            <td>3.67</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gambia, The</td>\n",
              "            <td>11300.0</td>\n",
              "            <td>10120.0</td>\n",
              "            <td>1180.0</td>\n",
              "            <td>2413403.0</td>\n",
              "            <td>2.29</td>\n",
              "            <td>28.78</td>\n",
              "            <td>5.81</td>\n",
              "            <td>-0.04</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ghana</td>\n",
              "            <td>238533.0</td>\n",
              "            <td>227533.0</td>\n",
              "            <td>11000.0</td>\n",
              "            <td>33107275.0</td>\n",
              "            <td>2.23</td>\n",
              "            <td>28.55</td>\n",
              "            <td>6.14</td>\n",
              "            <td>-0.16</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guinea</td>\n",
              "            <td>245857.0</td>\n",
              "            <td>245717.0</td>\n",
              "            <td>140.0</td>\n",
              "            <td>13237832.0</td>\n",
              "            <td>2.76</td>\n",
              "            <td>35.67</td>\n",
              "            <td>8.12</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guinea-Bissau</td>\n",
              "            <td>36125.0</td>\n",
              "            <td>28120.0</td>\n",
              "            <td>8005.0</td>\n",
              "            <td>2026778.0</td>\n",
              "            <td>2.53</td>\n",
              "            <td>36.45</td>\n",
              "            <td>7.5</td>\n",
              "            <td>-3.63</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kenya</td>\n",
              "            <td>580367.0</td>\n",
              "            <td>569140.0</td>\n",
              "            <td>11227.0</td>\n",
              "            <td>55864655.0</td>\n",
              "            <td>2.12</td>\n",
              "            <td>26.39</td>\n",
              "            <td>5.01</td>\n",
              "            <td>-0.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Lesotho</td>\n",
              "            <td>30355.0</td>\n",
              "            <td>30355.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>2193970.0</td>\n",
              "            <td>0.76</td>\n",
              "            <td>23.15</td>\n",
              "            <td>11.05</td>\n",
              "            <td>-4.55</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Liberia</td>\n",
              "            <td>111369.0</td>\n",
              "            <td>96320.0</td>\n",
              "            <td>15049.0</td>\n",
              "            <td>5358483.0</td>\n",
              "            <td>2.73</td>\n",
              "            <td>36.64</td>\n",
              "            <td>6.62</td>\n",
              "            <td>-2.74</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Libya</td>\n",
              "            <td>1759540.0</td>\n",
              "            <td>1759540.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>7137931.0</td>\n",
              "            <td>1.65</td>\n",
              "            <td>21.56</td>\n",
              "            <td>3.45</td>\n",
              "            <td>-1.61</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Madagascar</td>\n",
              "            <td>587041.0</td>\n",
              "            <td>581540.0</td>\n",
              "            <td>5501.0</td>\n",
              "            <td>28172462.0</td>\n",
              "            <td>2.27</td>\n",
              "            <td>28.68</td>\n",
              "            <td>6.0</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Malawi</td>\n",
              "            <td>118484.0</td>\n",
              "            <td>94080.0</td>\n",
              "            <td>24404.0</td>\n",
              "            <td>20794353.0</td>\n",
              "            <td>2.34</td>\n",
              "            <td>27.94</td>\n",
              "            <td>4.58</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mali</td>\n",
              "            <td>1240192.0</td>\n",
              "            <td>1220190.0</td>\n",
              "            <td>20002.0</td>\n",
              "            <td>20741769.0</td>\n",
              "            <td>2.95</td>\n",
              "            <td>41.07</td>\n",
              "            <td>8.53</td>\n",
              "            <td>-3.08</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mauritania</td>\n",
              "            <td>1030700.0</td>\n",
              "            <td>1030700.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>4161925.0</td>\n",
              "            <td>1.99</td>\n",
              "            <td>28.06</td>\n",
              "            <td>7.43</td>\n",
              "            <td>-0.72</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mauritius</td>\n",
              "            <td>2040.0</td>\n",
              "            <td>2030.0</td>\n",
              "            <td>10.0</td>\n",
              "            <td>1308222.0</td>\n",
              "            <td>0.1</td>\n",
              "            <td>9.86</td>\n",
              "            <td>8.86</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Morocco</td>\n",
              "            <td>716550.0</td>\n",
              "            <td>716300.0</td>\n",
              "            <td>250.0</td>\n",
              "            <td>36738229.0</td>\n",
              "            <td>0.91</td>\n",
              "            <td>17.42</td>\n",
              "            <td>6.6</td>\n",
              "            <td>-1.74</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mozambique</td>\n",
              "            <td>799380.0</td>\n",
              "            <td>786380.0</td>\n",
              "            <td>13000.0</td>\n",
              "            <td>31693239.0</td>\n",
              "            <td>2.56</td>\n",
              "            <td>37.47</td>\n",
              "            <td>10.25</td>\n",
              "            <td>-1.58</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Namibia</td>\n",
              "            <td>824292.0</td>\n",
              "            <td>823290.0</td>\n",
              "            <td>1002.0</td>\n",
              "            <td>2727409.0</td>\n",
              "            <td>1.82</td>\n",
              "            <td>25.01</td>\n",
              "            <td>6.85</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Niger</td>\n",
              "            <td>1267000.0</td>\n",
              "            <td>1266700.0</td>\n",
              "            <td>300.0</td>\n",
              "            <td>24484587.0</td>\n",
              "            <td>3.66</td>\n",
              "            <td>47.08</td>\n",
              "            <td>9.87</td>\n",
              "            <td>-0.64</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Nigeria</td>\n",
              "            <td>923768.0</td>\n",
              "            <td>910768.0</td>\n",
              "            <td>13000.0</td>\n",
              "            <td>225082083.0</td>\n",
              "            <td>2.53</td>\n",
              "            <td>34.19</td>\n",
              "            <td>8.7</td>\n",
              "            <td>-0.21</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Rwanda</td>\n",
              "            <td>26338.0</td>\n",
              "            <td>24668.0</td>\n",
              "            <td>1670.0</td>\n",
              "            <td>13173730.0</td>\n",
              "            <td>1.74</td>\n",
              "            <td>26.44</td>\n",
              "            <td>5.86</td>\n",
              "            <td>-3.21</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Helena, Ascension, and Tristan da Cunha</td>\n",
              "            <td>394.0</td>\n",
              "            <td>122.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>7925.0</td>\n",
              "            <td>0.13</td>\n",
              "            <td>9.34</td>\n",
              "            <td>8.08</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sao Tome and Principe</td>\n",
              "            <td>964.0</td>\n",
              "            <td>964.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>217164.0</td>\n",
              "            <td>1.48</td>\n",
              "            <td>28.19</td>\n",
              "            <td>6.2</td>\n",
              "            <td>-7.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Senegal</td>\n",
              "            <td>196722.0</td>\n",
              "            <td>192530.0</td>\n",
              "            <td>4192.0</td>\n",
              "            <td>17923036.0</td>\n",
              "            <td>2.57</td>\n",
              "            <td>31.51</td>\n",
              "            <td>5.08</td>\n",
              "            <td>-0.71</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Seychelles</td>\n",
              "            <td>455.0</td>\n",
              "            <td>455.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>97017.0</td>\n",
              "            <td>0.64</td>\n",
              "            <td>12.37</td>\n",
              "            <td>6.88</td>\n",
              "            <td>0.86</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sierra Leone</td>\n",
              "            <td>71740.0</td>\n",
              "            <td>71620.0</td>\n",
              "            <td>120.0</td>\n",
              "            <td>8692606.0</td>\n",
              "            <td>2.49</td>\n",
              "            <td>32.2</td>\n",
              "            <td>9.32</td>\n",
              "            <td>2.03</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Somalia</td>\n",
              "            <td>637657.0</td>\n",
              "            <td>627337.0</td>\n",
              "            <td>10320.0</td>\n",
              "            <td>12386248.0</td>\n",
              "            <td>2.42</td>\n",
              "            <td>37.98</td>\n",
              "            <td>11.62</td>\n",
              "            <td>-2.18</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>South Africa</td>\n",
              "            <td>1219090.0</td>\n",
              "            <td>1214470.0</td>\n",
              "            <td>4620.0</td>\n",
              "            <td>57516665.0</td>\n",
              "            <td>0.93</td>\n",
              "            <td>18.56</td>\n",
              "            <td>9.26</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>South Sudan</td>\n",
              "            <td>644329.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>11544905.0</td>\n",
              "            <td>4.91</td>\n",
              "            <td>37.69</td>\n",
              "            <td>9.52</td>\n",
              "            <td>20.97</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sudan</td>\n",
              "            <td>1861484.0</td>\n",
              "            <td>1731671.0</td>\n",
              "            <td>129813.0</td>\n",
              "            <td>47958856.0</td>\n",
              "            <td>2.55</td>\n",
              "            <td>33.47</td>\n",
              "            <td>6.3</td>\n",
              "            <td>-1.67</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tanzania</td>\n",
              "            <td>947300.0</td>\n",
              "            <td>885800.0</td>\n",
              "            <td>61500.0</td>\n",
              "            <td>63852892.0</td>\n",
              "            <td>2.78</td>\n",
              "            <td>33.3</td>\n",
              "            <td>5.09</td>\n",
              "            <td>-0.41</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Togo</td>\n",
              "            <td>56785.0</td>\n",
              "            <td>54385.0</td>\n",
              "            <td>2400.0</td>\n",
              "            <td>8492333.0</td>\n",
              "            <td>2.48</td>\n",
              "            <td>31.86</td>\n",
              "            <td>5.27</td>\n",
              "            <td>-1.81</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tunisia</td>\n",
              "            <td>163610.0</td>\n",
              "            <td>155360.0</td>\n",
              "            <td>8250.0</td>\n",
              "            <td>11896972.0</td>\n",
              "            <td>0.69</td>\n",
              "            <td>14.62</td>\n",
              "            <td>6.36</td>\n",
              "            <td>-1.33</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Uganda</td>\n",
              "            <td>241038.0</td>\n",
              "            <td>197100.0</td>\n",
              "            <td>43938.0</td>\n",
              "            <td>46205893.0</td>\n",
              "            <td>3.27</td>\n",
              "            <td>40.94</td>\n",
              "            <td>5.02</td>\n",
              "            <td>-3.26</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Zambia</td>\n",
              "            <td>752618.0</td>\n",
              "            <td>743398.0</td>\n",
              "            <td>9220.0</td>\n",
              "            <td>19642123.0</td>\n",
              "            <td>2.9</td>\n",
              "            <td>34.86</td>\n",
              "            <td>6.12</td>\n",
              "            <td>0.24</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Zimbabwe</td>\n",
              "            <td>390757.0</td>\n",
              "            <td>386847.0</td>\n",
              "            <td>3910.0</td>\n",
              "            <td>15121004.0</td>\n",
              "            <td>1.95</td>\n",
              "            <td>33.07</td>\n",
              "            <td>8.76</td>\n",
              "            <td>-4.83</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Antarctica</td>\n",
              "            <td>14.2</td>\n",
              "            <td>14.2</td>\n",
              "            <td>13.915</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bouvet Island</td>\n",
              "            <td>49.0</td>\n",
              "            <td>49.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>French Southern and Antarctic Lands</td>\n",
              "            <td>55.0</td>\n",
              "            <td>55.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Heard Island and McDonald Islands</td>\n",
              "            <td>412.0</td>\n",
              "            <td>412.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>American Samoa</td>\n",
              "            <td>224.0</td>\n",
              "            <td>224.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>45443.0</td>\n",
              "            <td>-1.92</td>\n",
              "            <td>16.7</td>\n",
              "            <td>6.1</td>\n",
              "            <td>-29.8</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ashmore and Cartier Islands</td>\n",
              "            <td>5.0</td>\n",
              "            <td>5.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Australia</td>\n",
              "            <td>7741220.0</td>\n",
              "            <td>7682300.0</td>\n",
              "            <td>58920.0</td>\n",
              "            <td>26141369.0</td>\n",
              "            <td>1.25</td>\n",
              "            <td>12.3</td>\n",
              "            <td>6.77</td>\n",
              "            <td>6.93</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Baker Island</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Christmas Island</td>\n",
              "            <td>135.0</td>\n",
              "            <td>135.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>2205.0</td>\n",
              "            <td>1.11</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cocos (Keeling) Islands</td>\n",
              "            <td>14.0</td>\n",
              "            <td>14.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>596.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>8.89</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cook Islands</td>\n",
              "            <td>236.0</td>\n",
              "            <td>236.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>8128.0</td>\n",
              "            <td>-2.39</td>\n",
              "            <td>12.55</td>\n",
              "            <td>9.1</td>\n",
              "            <td>-27.31</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Coral Sea Islands</td>\n",
              "            <td>3.0</td>\n",
              "            <td>3.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Fiji</td>\n",
              "            <td>18274.0</td>\n",
              "            <td>18274.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>943737.0</td>\n",
              "            <td>0.44</td>\n",
              "            <td>16.56</td>\n",
              "            <td>6.37</td>\n",
              "            <td>-5.84</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>French Polynesia</td>\n",
              "            <td>4167.0</td>\n",
              "            <td>67.0</td>\n",
              "            <td>3827.0</td>\n",
              "            <td>299356.0</td>\n",
              "            <td>0.73</td>\n",
              "            <td>13.47</td>\n",
              "            <td>5.59</td>\n",
              "            <td>-0.63</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guam</td>\n",
              "            <td>544.0</td>\n",
              "            <td>544.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>169086.0</td>\n",
              "            <td>0.16</td>\n",
              "            <td>18.56</td>\n",
              "            <td>6.03</td>\n",
              "            <td>-10.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Howland Island</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Jarvis Island</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Johnston Atoll</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kingman Reef</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kiribati</td>\n",
              "            <td>811.0</td>\n",
              "            <td>811.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>114189.0</td>\n",
              "            <td>1.04</td>\n",
              "            <td>20.12</td>\n",
              "            <td>6.92</td>\n",
              "            <td>-2.8</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Marshall Islands</td>\n",
              "            <td>181.0</td>\n",
              "            <td>181.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>79906.0</td>\n",
              "            <td>1.34</td>\n",
              "            <td>22.0</td>\n",
              "            <td>4.28</td>\n",
              "            <td>-4.37</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Micronesia, Federated States of</td>\n",
              "            <td>702.0</td>\n",
              "            <td>702.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>101009.0</td>\n",
              "            <td>-0.67</td>\n",
              "            <td>18.39</td>\n",
              "            <td>4.19</td>\n",
              "            <td>-20.91</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Midway Islands</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Nauru</td>\n",
              "            <td>21.0</td>\n",
              "            <td>21.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>9811.0</td>\n",
              "            <td>0.42</td>\n",
              "            <td>21.1</td>\n",
              "            <td>6.32</td>\n",
              "            <td>-10.6</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>New Caledonia</td>\n",
              "            <td>18575.0</td>\n",
              "            <td>18275.0</td>\n",
              "            <td>300.0</td>\n",
              "            <td>297160.0</td>\n",
              "            <td>1.19</td>\n",
              "            <td>14.13</td>\n",
              "            <td>5.88</td>\n",
              "            <td>3.66</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>New Zealand</td>\n",
              "            <td>268838.0</td>\n",
              "            <td>264537.0</td>\n",
              "            <td>4301.0</td>\n",
              "            <td>5053004.0</td>\n",
              "            <td>1.17</td>\n",
              "            <td>12.78</td>\n",
              "            <td>6.89</td>\n",
              "            <td>5.83</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Niue</td>\n",
              "            <td>260.0</td>\n",
              "            <td>260.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>2000.0</td>\n",
              "            <td>-0.03</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Norfolk Island</td>\n",
              "            <td>36.0</td>\n",
              "            <td>36.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1748.0</td>\n",
              "            <td>0.01</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Northern Mariana Islands</td>\n",
              "            <td>464.0</td>\n",
              "            <td>464.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>51475.0</td>\n",
              "            <td>-0.35</td>\n",
              "            <td>15.5</td>\n",
              "            <td>5.44</td>\n",
              "            <td>-13.6</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Palau</td>\n",
              "            <td>459.0</td>\n",
              "            <td>459.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>21695.0</td>\n",
              "            <td>0.39</td>\n",
              "            <td>11.52</td>\n",
              "            <td>8.25</td>\n",
              "            <td>0.6</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Palmyra Atoll</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Pitcairn Islands</td>\n",
              "            <td>47.0</td>\n",
              "            <td>47.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>50.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Samoa</td>\n",
              "            <td>2831.0</td>\n",
              "            <td>2821.0</td>\n",
              "            <td>10.0</td>\n",
              "            <td>206179.0</td>\n",
              "            <td>0.63</td>\n",
              "            <td>19.21</td>\n",
              "            <td>5.37</td>\n",
              "            <td>-7.51</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Solomon Islands</td>\n",
              "            <td>28896.0</td>\n",
              "            <td>27986.0</td>\n",
              "            <td>910.0</td>\n",
              "            <td>702694.0</td>\n",
              "            <td>1.72</td>\n",
              "            <td>22.71</td>\n",
              "            <td>3.96</td>\n",
              "            <td>-1.55</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tokelau</td>\n",
              "            <td>12.0</td>\n",
              "            <td>12.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1647.0</td>\n",
              "            <td>-0.01</td>\n",
              "            <td>None</td>\n",
              "            <td>-3.84</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tonga</td>\n",
              "            <td>747.0</td>\n",
              "            <td>717.0</td>\n",
              "            <td>30.0</td>\n",
              "            <td>105517.0</td>\n",
              "            <td>-0.26</td>\n",
              "            <td>20.31</td>\n",
              "            <td>4.95</td>\n",
              "            <td>-18.01</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tuvalu</td>\n",
              "            <td>26.0</td>\n",
              "            <td>26.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>11544.0</td>\n",
              "            <td>0.83</td>\n",
              "            <td>22.7</td>\n",
              "            <td>7.97</td>\n",
              "            <td>-6.41</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>United States Pacific Island Wildlife Refuges</td>\n",
              "            <td>6959.41</td>\n",
              "            <td>22.41</td>\n",
              "            <td>6937.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Vanuatu</td>\n",
              "            <td>12189.0</td>\n",
              "            <td>12189.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>308043.0</td>\n",
              "            <td>1.63</td>\n",
              "            <td>21.57</td>\n",
              "            <td>3.98</td>\n",
              "            <td>-1.3</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Wake Island</td>\n",
              "            <td>7.0</td>\n",
              "            <td>6.5</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Wallis and Futuna</td>\n",
              "            <td>142.0</td>\n",
              "            <td>142.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>15891.0</td>\n",
              "            <td>0.25</td>\n",
              "            <td>12.27</td>\n",
              "            <td>5.79</td>\n",
              "            <td>-3.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Anguilla</td>\n",
              "            <td>91.0</td>\n",
              "            <td>91.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>18741.0</td>\n",
              "            <td>1.8</td>\n",
              "            <td>12.01</td>\n",
              "            <td>4.64</td>\n",
              "            <td>10.67</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Antigua and Barbuda</td>\n",
              "            <td>443.0</td>\n",
              "            <td>280.0</td>\n",
              "            <td>161.0</td>\n",
              "            <td>100335.0</td>\n",
              "            <td>1.15</td>\n",
              "            <td>15.16</td>\n",
              "            <td>5.65</td>\n",
              "            <td>2.03</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Aruba</td>\n",
              "            <td>180.0</td>\n",
              "            <td>180.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>122320.0</td>\n",
              "            <td>1.14</td>\n",
              "            <td>11.82</td>\n",
              "            <td>8.62</td>\n",
              "            <td>8.18</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bahamas, The</td>\n",
              "            <td>13880.0</td>\n",
              "            <td>10010.0</td>\n",
              "            <td>3870.0</td>\n",
              "            <td>355608.0</td>\n",
              "            <td>0.82</td>\n",
              "            <td>14.64</td>\n",
              "            <td>6.41</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Barbados</td>\n",
              "            <td>430.0</td>\n",
              "            <td>430.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>302674.0</td>\n",
              "            <td>0.26</td>\n",
              "            <td>10.83</td>\n",
              "            <td>7.96</td>\n",
              "            <td>-0.29</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Belize</td>\n",
              "            <td>22966.0</td>\n",
              "            <td>22806.0</td>\n",
              "            <td>160.0</td>\n",
              "            <td>412387.0</td>\n",
              "            <td>1.64</td>\n",
              "            <td>21.28</td>\n",
              "            <td>3.94</td>\n",
              "            <td>-0.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>British Virgin Islands</td>\n",
              "            <td>151.0</td>\n",
              "            <td>151.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>38632.0</td>\n",
              "            <td>1.91</td>\n",
              "            <td>10.95</td>\n",
              "            <td>5.38</td>\n",
              "            <td>13.56</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cayman Islands</td>\n",
              "            <td>264.0</td>\n",
              "            <td>264.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>64309.0</td>\n",
              "            <td>1.83</td>\n",
              "            <td>11.69</td>\n",
              "            <td>5.97</td>\n",
              "            <td>12.56</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Costa Rica</td>\n",
              "            <td>51100.0</td>\n",
              "            <td>51060.0</td>\n",
              "            <td>40.0</td>\n",
              "            <td>5204411.0</td>\n",
              "            <td>1.01</td>\n",
              "            <td>14.28</td>\n",
              "            <td>4.91</td>\n",
              "            <td>0.77</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cuba</td>\n",
              "            <td>110860.0</td>\n",
              "            <td>109820.0</td>\n",
              "            <td>1040.0</td>\n",
              "            <td>11008112.0</td>\n",
              "            <td>-0.21</td>\n",
              "            <td>10.11</td>\n",
              "            <td>9.29</td>\n",
              "            <td>-2.92</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Curacao</td>\n",
              "            <td>444.0</td>\n",
              "            <td>444.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>152379.0</td>\n",
              "            <td>0.32</td>\n",
              "            <td>13.2</td>\n",
              "            <td>8.71</td>\n",
              "            <td>-1.31</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Dominica</td>\n",
              "            <td>751.0</td>\n",
              "            <td>751.0</td>\n",
              "            <td>None</td>\n",
              "            <td>74629.0</td>\n",
              "            <td>0.05</td>\n",
              "            <td>13.91</td>\n",
              "            <td>8.11</td>\n",
              "            <td>-5.31</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Dominican Republic</td>\n",
              "            <td>48670.0</td>\n",
              "            <td>48320.0</td>\n",
              "            <td>350.0</td>\n",
              "            <td>10694700.0</td>\n",
              "            <td>0.91</td>\n",
              "            <td>18.03</td>\n",
              "            <td>6.29</td>\n",
              "            <td>-2.68</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>El Salvador</td>\n",
              "            <td>21041.0</td>\n",
              "            <td>20721.0</td>\n",
              "            <td>320.0</td>\n",
              "            <td>6568745.0</td>\n",
              "            <td>0.57</td>\n",
              "            <td>17.87</td>\n",
              "            <td>5.91</td>\n",
              "            <td>-6.29</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Grenada</td>\n",
              "            <td>344.0</td>\n",
              "            <td>344.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>113949.0</td>\n",
              "            <td>0.32</td>\n",
              "            <td>13.94</td>\n",
              "            <td>8.31</td>\n",
              "            <td>-2.43</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guatemala</td>\n",
              "            <td>108889.0</td>\n",
              "            <td>107159.0</td>\n",
              "            <td>1730.0</td>\n",
              "            <td>17703190.0</td>\n",
              "            <td>1.58</td>\n",
              "            <td>22.34</td>\n",
              "            <td>4.91</td>\n",
              "            <td>-1.66</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Haiti</td>\n",
              "            <td>27750.0</td>\n",
              "            <td>27560.0</td>\n",
              "            <td>190.0</td>\n",
              "            <td>11334637.0</td>\n",
              "            <td>1.2</td>\n",
              "            <td>21.12</td>\n",
              "            <td>7.23</td>\n",
              "            <td>-1.88</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Honduras</td>\n",
              "            <td>112090.0</td>\n",
              "            <td>111890.0</td>\n",
              "            <td>200.0</td>\n",
              "            <td>9459440.0</td>\n",
              "            <td>1.19</td>\n",
              "            <td>17.92</td>\n",
              "            <td>4.68</td>\n",
              "            <td>-1.34</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Jamaica</td>\n",
              "            <td>10991.0</td>\n",
              "            <td>10831.0</td>\n",
              "            <td>160.0</td>\n",
              "            <td>2818596.0</td>\n",
              "            <td>0.08</td>\n",
              "            <td>15.91</td>\n",
              "            <td>7.43</td>\n",
              "            <td>-7.7</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Montserrat</td>\n",
              "            <td>102.0</td>\n",
              "            <td>102.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>5414.0</td>\n",
              "            <td>0.5</td>\n",
              "            <td>10.9</td>\n",
              "            <td>5.91</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Navassa Island</td>\n",
              "            <td>5.0</td>\n",
              "            <td>5.4</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Nicaragua</td>\n",
              "            <td>130370.0</td>\n",
              "            <td>119990.0</td>\n",
              "            <td>10380.0</td>\n",
              "            <td>6301880.0</td>\n",
              "            <td>0.92</td>\n",
              "            <td>16.52</td>\n",
              "            <td>5.17</td>\n",
              "            <td>-2.15</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Panama</td>\n",
              "            <td>75420.0</td>\n",
              "            <td>74340.0</td>\n",
              "            <td>1080.0</td>\n",
              "            <td>4337768.0</td>\n",
              "            <td>1.53</td>\n",
              "            <td>17.99</td>\n",
              "            <td>6.11</td>\n",
              "            <td>3.42</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Puerto Rico</td>\n",
              "            <td>9104.0</td>\n",
              "            <td>8959.0</td>\n",
              "            <td>145.0</td>\n",
              "            <td>3098423.0</td>\n",
              "            <td>-1.38</td>\n",
              "            <td>7.87</td>\n",
              "            <td>9.76</td>\n",
              "            <td>-11.9</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Barthelemy</td>\n",
              "            <td>25.0</td>\n",
              "            <td>25.0</td>\n",
              "            <td>None</td>\n",
              "            <td>7103.0</td>\n",
              "            <td>-0.16</td>\n",
              "            <td>9.29</td>\n",
              "            <td>9.01</td>\n",
              "            <td>-1.83</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Kitts and Nevis</td>\n",
              "            <td>261.0</td>\n",
              "            <td>168.0</td>\n",
              "            <td>93.0</td>\n",
              "            <td>54488.0</td>\n",
              "            <td>0.61</td>\n",
              "            <td>12.24</td>\n",
              "            <td>7.27</td>\n",
              "            <td>1.16</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Lucia</td>\n",
              "            <td>616.0</td>\n",
              "            <td>606.0</td>\n",
              "            <td>10.0</td>\n",
              "            <td>167122.0</td>\n",
              "            <td>0.29</td>\n",
              "            <td>12.02</td>\n",
              "            <td>8.07</td>\n",
              "            <td>-1.09</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Martin</td>\n",
              "            <td>50.0</td>\n",
              "            <td>50.0</td>\n",
              "            <td>None</td>\n",
              "            <td>32792.0</td>\n",
              "            <td>0.33</td>\n",
              "            <td>14.09</td>\n",
              "            <td>4.64</td>\n",
              "            <td>-6.13</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Vincent and the Grenadines</td>\n",
              "            <td>389.0</td>\n",
              "            <td>344.0</td>\n",
              "            <td>389.0</td>\n",
              "            <td>100969.0</td>\n",
              "            <td>-0.17</td>\n",
              "            <td>12.27</td>\n",
              "            <td>7.49</td>\n",
              "            <td>-6.47</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sint Maarten</td>\n",
              "            <td>34.0</td>\n",
              "            <td>34.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>45126.0</td>\n",
              "            <td>1.23</td>\n",
              "            <td>12.56</td>\n",
              "            <td>6.07</td>\n",
              "            <td>5.83</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Trinidad and Tobago</td>\n",
              "            <td>5128.0</td>\n",
              "            <td>5128.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1405646.0</td>\n",
              "            <td>0.14</td>\n",
              "            <td>10.79</td>\n",
              "            <td>8.38</td>\n",
              "            <td>-1.01</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Turks and Caicos Islands</td>\n",
              "            <td>948.0</td>\n",
              "            <td>948.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>58286.0</td>\n",
              "            <td>1.86</td>\n",
              "            <td>13.54</td>\n",
              "            <td>3.5</td>\n",
              "            <td>8.58</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Virgin Islands</td>\n",
              "            <td>1910.0</td>\n",
              "            <td>346.0</td>\n",
              "            <td>1564.0</td>\n",
              "            <td>105413.0</td>\n",
              "            <td>-0.45</td>\n",
              "            <td>11.63</td>\n",
              "            <td>8.78</td>\n",
              "            <td>-7.35</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kazakhstan</td>\n",
              "            <td>2724900.0</td>\n",
              "            <td>2699700.0</td>\n",
              "            <td>25200.0</td>\n",
              "            <td>19398331.0</td>\n",
              "            <td>0.77</td>\n",
              "            <td>15.38</td>\n",
              "            <td>8.11</td>\n",
              "            <td>0.39</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kyrgyzstan</td>\n",
              "            <td>199951.0</td>\n",
              "            <td>191801.0</td>\n",
              "            <td>8150.0</td>\n",
              "            <td>6071750.0</td>\n",
              "            <td>0.86</td>\n",
              "            <td>19.54</td>\n",
              "            <td>6.12</td>\n",
              "            <td>-4.87</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Russia</td>\n",
              "            <td>17098242.0</td>\n",
              "            <td>16377742.0</td>\n",
              "            <td>720500.0</td>\n",
              "            <td>142021981.0</td>\n",
              "            <td>-0.22</td>\n",
              "            <td>9.45</td>\n",
              "            <td>13.36</td>\n",
              "            <td>1.7</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tajikistan</td>\n",
              "            <td>144100.0</td>\n",
              "            <td>141510.0</td>\n",
              "            <td>2590.0</td>\n",
              "            <td>9119347.0</td>\n",
              "            <td>1.4</td>\n",
              "            <td>20.73</td>\n",
              "            <td>5.72</td>\n",
              "            <td>-1.03</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Turkmenistan</td>\n",
              "            <td>488100.0</td>\n",
              "            <td>469930.0</td>\n",
              "            <td>18170.0</td>\n",
              "            <td>5636011.0</td>\n",
              "            <td>0.99</td>\n",
              "            <td>17.51</td>\n",
              "            <td>5.95</td>\n",
              "            <td>-1.71</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Uzbekistan</td>\n",
              "            <td>447400.0</td>\n",
              "            <td>425400.0</td>\n",
              "            <td>22000.0</td>\n",
              "            <td>31104937.0</td>\n",
              "            <td>0.83</td>\n",
              "            <td>15.53</td>\n",
              "            <td>5.41</td>\n",
              "            <td>-1.78</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Brunei</td>\n",
              "            <td>5765.0</td>\n",
              "            <td>5265.0</td>\n",
              "            <td>500.0</td>\n",
              "            <td>478054.0</td>\n",
              "            <td>1.45</td>\n",
              "            <td>16.14</td>\n",
              "            <td>3.79</td>\n",
              "            <td>2.18</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Burma</td>\n",
              "            <td>676578.0</td>\n",
              "            <td>653508.0</td>\n",
              "            <td>23070.0</td>\n",
              "            <td>57526449.0</td>\n",
              "            <td>0.78</td>\n",
              "            <td>16.34</td>\n",
              "            <td>7.13</td>\n",
              "            <td>-1.37</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cambodia</td>\n",
              "            <td>181035.0</td>\n",
              "            <td>176515.0</td>\n",
              "            <td>4520.0</td>\n",
              "            <td>16713015.0</td>\n",
              "            <td>1.08</td>\n",
              "            <td>19.29</td>\n",
              "            <td>5.76</td>\n",
              "            <td>-2.7</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>China</td>\n",
              "            <td>9596960.0</td>\n",
              "            <td>9326410.0</td>\n",
              "            <td>270550.0</td>\n",
              "            <td>1410539758.0</td>\n",
              "            <td>0.19</td>\n",
              "            <td>9.93</td>\n",
              "            <td>7.9</td>\n",
              "            <td>-0.11</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Hong Kong</td>\n",
              "            <td>1108.0</td>\n",
              "            <td>1073.0</td>\n",
              "            <td>35.0</td>\n",
              "            <td>7276588.0</td>\n",
              "            <td>0.17</td>\n",
              "            <td>8.04</td>\n",
              "            <td>7.98</td>\n",
              "            <td>1.65</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Indonesia</td>\n",
              "            <td>1904569.0</td>\n",
              "            <td>1811569.0</td>\n",
              "            <td>93000.0</td>\n",
              "            <td>277329163.0</td>\n",
              "            <td>0.79</td>\n",
              "            <td>15.32</td>\n",
              "            <td>6.75</td>\n",
              "            <td>-0.71</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Japan</td>\n",
              "            <td>377915.0</td>\n",
              "            <td>364485.0</td>\n",
              "            <td>13430.0</td>\n",
              "            <td>124214766.0</td>\n",
              "            <td>-0.39</td>\n",
              "            <td>6.95</td>\n",
              "            <td>11.59</td>\n",
              "            <td>0.74</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Korea, North</td>\n",
              "            <td>120538.0</td>\n",
              "            <td>120408.0</td>\n",
              "            <td>130.0</td>\n",
              "            <td>25955138.0</td>\n",
              "            <td>0.46</td>\n",
              "            <td>14.21</td>\n",
              "            <td>9.53</td>\n",
              "            <td>-0.04</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Korea, South</td>\n",
              "            <td>99720.0</td>\n",
              "            <td>96920.0</td>\n",
              "            <td>2800.0</td>\n",
              "            <td>51844834.0</td>\n",
              "            <td>0.24</td>\n",
              "            <td>6.92</td>\n",
              "            <td>7.12</td>\n",
              "            <td>2.63</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Laos</td>\n",
              "            <td>236800.0</td>\n",
              "            <td>230800.0</td>\n",
              "            <td>6000.0</td>\n",
              "            <td>7749595.0</td>\n",
              "            <td>1.34</td>\n",
              "            <td>20.9</td>\n",
              "            <td>6.37</td>\n",
              "            <td>-1.17</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Macau</td>\n",
              "            <td>28.0</td>\n",
              "            <td>28.2</td>\n",
              "            <td>0.0</td>\n",
              "            <td>635293.0</td>\n",
              "            <td>0.75</td>\n",
              "            <td>9.11</td>\n",
              "            <td>4.72</td>\n",
              "            <td>3.15</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Malaysia</td>\n",
              "            <td>329847.0</td>\n",
              "            <td>328657.0</td>\n",
              "            <td>1190.0</td>\n",
              "            <td>33871431.0</td>\n",
              "            <td>1.03</td>\n",
              "            <td>14.55</td>\n",
              "            <td>5.69</td>\n",
              "            <td>1.48</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mongolia</td>\n",
              "            <td>1564116.0</td>\n",
              "            <td>1553556.0</td>\n",
              "            <td>10560.0</td>\n",
              "            <td>3227863.0</td>\n",
              "            <td>0.88</td>\n",
              "            <td>15.84</td>\n",
              "            <td>6.3</td>\n",
              "            <td>-0.77</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Papua New Guinea</td>\n",
              "            <td>462840.0</td>\n",
              "            <td>452860.0</td>\n",
              "            <td>9980.0</td>\n",
              "            <td>9593498.0</td>\n",
              "            <td>2.35</td>\n",
              "            <td>29.03</td>\n",
              "            <td>5.54</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Paracel Islands</td>\n",
              "            <td>8.0</td>\n",
              "            <td>7.75</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1440.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Philippines</td>\n",
              "            <td>300000.0</td>\n",
              "            <td>298170.0</td>\n",
              "            <td>1830.0</td>\n",
              "            <td>114597229.0</td>\n",
              "            <td>1.6</td>\n",
              "            <td>22.28</td>\n",
              "            <td>6.41</td>\n",
              "            <td>0.13</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Singapore</td>\n",
              "            <td>719.0</td>\n",
              "            <td>709.2</td>\n",
              "            <td>10.0</td>\n",
              "            <td>5921231.0</td>\n",
              "            <td>0.92</td>\n",
              "            <td>9.05</td>\n",
              "            <td>4.04</td>\n",
              "            <td>4.22</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Spratly Islands</td>\n",
              "            <td>5.0</td>\n",
              "            <td>5.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Taiwan</td>\n",
              "            <td>35980.0</td>\n",
              "            <td>32260.0</td>\n",
              "            <td>3720.0</td>\n",
              "            <td>23580712.0</td>\n",
              "            <td>0.04</td>\n",
              "            <td>7.39</td>\n",
              "            <td>7.89</td>\n",
              "            <td>0.85</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Thailand</td>\n",
              "            <td>513120.0</td>\n",
              "            <td>510890.0</td>\n",
              "            <td>2230.0</td>\n",
              "            <td>69648117.0</td>\n",
              "            <td>0.23</td>\n",
              "            <td>10.14</td>\n",
              "            <td>7.76</td>\n",
              "            <td>-0.13</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Timor-Leste</td>\n",
              "            <td>14874.0</td>\n",
              "            <td>14874.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1445006.0</td>\n",
              "            <td>2.15</td>\n",
              "            <td>30.94</td>\n",
              "            <td>5.61</td>\n",
              "            <td>-3.82</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Vietnam</td>\n",
              "            <td>331210.0</td>\n",
              "            <td>310070.0</td>\n",
              "            <td>21140.0</td>\n",
              "            <td>103808319.0</td>\n",
              "            <td>0.97</td>\n",
              "            <td>15.69</td>\n",
              "            <td>5.77</td>\n",
              "            <td>-0.22</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Akrotiri</td>\n",
              "            <td>123.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Albania</td>\n",
              "            <td>28748.0</td>\n",
              "            <td>27398.0</td>\n",
              "            <td>1350.0</td>\n",
              "            <td>3095344.0</td>\n",
              "            <td>0.22</td>\n",
              "            <td>12.69</td>\n",
              "            <td>7.31</td>\n",
              "            <td>-3.23</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Andorra</td>\n",
              "            <td>468.0</td>\n",
              "            <td>468.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>85560.0</td>\n",
              "            <td>-0.1</td>\n",
              "            <td>6.88</td>\n",
              "            <td>7.92</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Austria</td>\n",
              "            <td>83871.0</td>\n",
              "            <td>82445.0</td>\n",
              "            <td>1426.0</td>\n",
              "            <td>8913088.0</td>\n",
              "            <td>0.32</td>\n",
              "            <td>9.45</td>\n",
              "            <td>9.85</td>\n",
              "            <td>3.55</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Belarus</td>\n",
              "            <td>207600.0</td>\n",
              "            <td>202900.0</td>\n",
              "            <td>4700.0</td>\n",
              "            <td>9413505.0</td>\n",
              "            <td>-0.31</td>\n",
              "            <td>9.08</td>\n",
              "            <td>12.88</td>\n",
              "            <td>0.72</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Belgium</td>\n",
              "            <td>30528.0</td>\n",
              "            <td>30278.0</td>\n",
              "            <td>250.0</td>\n",
              "            <td>11847338.0</td>\n",
              "            <td>0.57</td>\n",
              "            <td>10.95</td>\n",
              "            <td>9.64</td>\n",
              "            <td>4.38</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bosnia and Herzegovina</td>\n",
              "            <td>51197.0</td>\n",
              "            <td>51187.0</td>\n",
              "            <td>10.0</td>\n",
              "            <td>3816459.0</td>\n",
              "            <td>-0.22</td>\n",
              "            <td>8.41</td>\n",
              "            <td>10.26</td>\n",
              "            <td>-0.38</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bulgaria</td>\n",
              "            <td>110879.0</td>\n",
              "            <td>108489.0</td>\n",
              "            <td>2390.0</td>\n",
              "            <td>6873253.0</td>\n",
              "            <td>-0.67</td>\n",
              "            <td>8.05</td>\n",
              "            <td>14.41</td>\n",
              "            <td>-0.29</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Croatia</td>\n",
              "            <td>56594.0</td>\n",
              "            <td>55974.0</td>\n",
              "            <td>620.0</td>\n",
              "            <td>4188853.0</td>\n",
              "            <td>-0.47</td>\n",
              "            <td>8.65</td>\n",
              "            <td>12.88</td>\n",
              "            <td>-0.5</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cyprus</td>\n",
              "            <td>9251.0</td>\n",
              "            <td>3355.0</td>\n",
              "            <td>9241.0</td>\n",
              "            <td>1295102.0</td>\n",
              "            <td>1.06</td>\n",
              "            <td>10.57</td>\n",
              "            <td>6.94</td>\n",
              "            <td>6.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Czechia</td>\n",
              "            <td>78867.0</td>\n",
              "            <td>77247.0</td>\n",
              "            <td>1620.0</td>\n",
              "            <td>10705384.0</td>\n",
              "            <td>0.02</td>\n",
              "            <td>8.59</td>\n",
              "            <td>10.74</td>\n",
              "            <td>2.32</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Denmark</td>\n",
              "            <td>43094.0</td>\n",
              "            <td>42434.0</td>\n",
              "            <td>660.0</td>\n",
              "            <td>5920767.0</td>\n",
              "            <td>0.44</td>\n",
              "            <td>11.22</td>\n",
              "            <td>9.52</td>\n",
              "            <td>2.73</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Dhekelia</td>\n",
              "            <td>131.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Estonia</td>\n",
              "            <td>45228.0</td>\n",
              "            <td>42388.0</td>\n",
              "            <td>2840.0</td>\n",
              "            <td>1211524.0</td>\n",
              "            <td>-0.71</td>\n",
              "            <td>8.75</td>\n",
              "            <td>13.1</td>\n",
              "            <td>-2.79</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>European Union</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>-2.85</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Faroe Islands</td>\n",
              "            <td>1393.0</td>\n",
              "            <td>1393.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>52269.0</td>\n",
              "            <td>0.63</td>\n",
              "            <td>14.94</td>\n",
              "            <td>8.63</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Finland</td>\n",
              "            <td>338145.0</td>\n",
              "            <td>303815.0</td>\n",
              "            <td>34330.0</td>\n",
              "            <td>5601547.0</td>\n",
              "            <td>0.24</td>\n",
              "            <td>10.42</td>\n",
              "            <td>10.35</td>\n",
              "            <td>2.35</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>France</td>\n",
              "            <td>643801.0</td>\n",
              "            <td>551500.0</td>\n",
              "            <td>640427.0</td>\n",
              "            <td>68305148.0</td>\n",
              "            <td>0.32</td>\n",
              "            <td>11.66</td>\n",
              "            <td>9.54</td>\n",
              "            <td>1.06</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Germany</td>\n",
              "            <td>357022.0</td>\n",
              "            <td>348672.0</td>\n",
              "            <td>8350.0</td>\n",
              "            <td>84316622.0</td>\n",
              "            <td>-0.11</td>\n",
              "            <td>9.08</td>\n",
              "            <td>11.98</td>\n",
              "            <td>1.78</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gibraltar</td>\n",
              "            <td>7.0</td>\n",
              "            <td>6.5</td>\n",
              "            <td>0.0</td>\n",
              "            <td>29573.0</td>\n",
              "            <td>0.19</td>\n",
              "            <td>13.93</td>\n",
              "            <td>8.76</td>\n",
              "            <td>-3.25</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Greece</td>\n",
              "            <td>131957.0</td>\n",
              "            <td>130647.0</td>\n",
              "            <td>1310.0</td>\n",
              "            <td>10533871.0</td>\n",
              "            <td>-0.34</td>\n",
              "            <td>7.61</td>\n",
              "            <td>12.04</td>\n",
              "            <td>1.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guernsey</td>\n",
              "            <td>78.0</td>\n",
              "            <td>78.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>67491.0</td>\n",
              "            <td>0.23</td>\n",
              "            <td>9.75</td>\n",
              "            <td>9.17</td>\n",
              "            <td>1.7</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Holy See (Vatican City)</td>\n",
              "            <td>0.0</td>\n",
              "            <td>0.44</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1000.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Hungary</td>\n",
              "            <td>93028.0</td>\n",
              "            <td>89608.0</td>\n",
              "            <td>3420.0</td>\n",
              "            <td>9699577.0</td>\n",
              "            <td>-0.3</td>\n",
              "            <td>8.65</td>\n",
              "            <td>12.88</td>\n",
              "            <td>1.23</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Iceland</td>\n",
              "            <td>103000.0</td>\n",
              "            <td>100250.0</td>\n",
              "            <td>2750.0</td>\n",
              "            <td>357603.0</td>\n",
              "            <td>0.93</td>\n",
              "            <td>12.96</td>\n",
              "            <td>6.56</td>\n",
              "            <td>2.89</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ireland</td>\n",
              "            <td>70273.0</td>\n",
              "            <td>68883.0</td>\n",
              "            <td>1390.0</td>\n",
              "            <td>5275004.0</td>\n",
              "            <td>0.94</td>\n",
              "            <td>12.32</td>\n",
              "            <td>6.73</td>\n",
              "            <td>3.79</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Isle of Man</td>\n",
              "            <td>572.0</td>\n",
              "            <td>572.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>91382.0</td>\n",
              "            <td>0.52</td>\n",
              "            <td>10.58</td>\n",
              "            <td>10.18</td>\n",
              "            <td>4.76</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Italy</td>\n",
              "            <td>301340.0</td>\n",
              "            <td>294140.0</td>\n",
              "            <td>7200.0</td>\n",
              "            <td>61095551.0</td>\n",
              "            <td>-0.13</td>\n",
              "            <td>6.95</td>\n",
              "            <td>11.31</td>\n",
              "            <td>3.02</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Jan Mayen</td>\n",
              "            <td>377.0</td>\n",
              "            <td>377.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Jersey</td>\n",
              "            <td>116.0</td>\n",
              "            <td>116.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>102146.0</td>\n",
              "            <td>0.64</td>\n",
              "            <td>12.41</td>\n",
              "            <td>7.75</td>\n",
              "            <td>1.76</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kosovo</td>\n",
              "            <td>10887.0</td>\n",
              "            <td>10887.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1952701.0</td>\n",
              "            <td>0.57</td>\n",
              "            <td>14.85</td>\n",
              "            <td>8.12</td>\n",
              "            <td>-1.07</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Latvia</td>\n",
              "            <td>64589.0</td>\n",
              "            <td>62249.0</td>\n",
              "            <td>2340.0</td>\n",
              "            <td>1842226.0</td>\n",
              "            <td>-1.11</td>\n",
              "            <td>8.73</td>\n",
              "            <td>14.65</td>\n",
              "            <td>-5.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Liechtenstein</td>\n",
              "            <td>160.0</td>\n",
              "            <td>160.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>39711.0</td>\n",
              "            <td>0.72</td>\n",
              "            <td>10.32</td>\n",
              "            <td>7.98</td>\n",
              "            <td>4.81</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Lithuania</td>\n",
              "            <td>65300.0</td>\n",
              "            <td>62680.0</td>\n",
              "            <td>2620.0</td>\n",
              "            <td>2683546.0</td>\n",
              "            <td>-1.04</td>\n",
              "            <td>9.26</td>\n",
              "            <td>15.12</td>\n",
              "            <td>-4.54</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Luxembourg</td>\n",
              "            <td>2586.0</td>\n",
              "            <td>2586.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>650364.0</td>\n",
              "            <td>1.64</td>\n",
              "            <td>11.61</td>\n",
              "            <td>7.21</td>\n",
              "            <td>12.01</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Malta</td>\n",
              "            <td>316.0</td>\n",
              "            <td>316.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>464186.0</td>\n",
              "            <td>0.67</td>\n",
              "            <td>9.73</td>\n",
              "            <td>8.48</td>\n",
              "            <td>5.49</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Moldova</td>\n",
              "            <td>33851.0</td>\n",
              "            <td>32891.0</td>\n",
              "            <td>960.0</td>\n",
              "            <td>3287326.0</td>\n",
              "            <td>-1.12</td>\n",
              "            <td>10.19</td>\n",
              "            <td>12.47</td>\n",
              "            <td>-8.87</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Monaco</td>\n",
              "            <td>2.0</td>\n",
              "            <td>2.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>31400.0</td>\n",
              "            <td>0.6</td>\n",
              "            <td>6.66</td>\n",
              "            <td>10.7</td>\n",
              "            <td>10.03</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Montenegro</td>\n",
              "            <td>13812.0</td>\n",
              "            <td>13452.0</td>\n",
              "            <td>360.0</td>\n",
              "            <td>604966.0</td>\n",
              "            <td>-0.41</td>\n",
              "            <td>11.19</td>\n",
              "            <td>10.33</td>\n",
              "            <td>-4.97</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Netherlands</td>\n",
              "            <td>41543.0</td>\n",
              "            <td>33893.0</td>\n",
              "            <td>7650.0</td>\n",
              "            <td>17400824.0</td>\n",
              "            <td>0.36</td>\n",
              "            <td>10.99</td>\n",
              "            <td>9.24</td>\n",
              "            <td>1.9</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>North Macedonia</td>\n",
              "            <td>25713.0</td>\n",
              "            <td>25433.0</td>\n",
              "            <td>280.0</td>\n",
              "            <td>2130936.0</td>\n",
              "            <td>0.12</td>\n",
              "            <td>10.45</td>\n",
              "            <td>9.61</td>\n",
              "            <td>0.38</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Norway</td>\n",
              "            <td>323802.0</td>\n",
              "            <td>304282.0</td>\n",
              "            <td>19520.0</td>\n",
              "            <td>5553840.0</td>\n",
              "            <td>0.8</td>\n",
              "            <td>12.0</td>\n",
              "            <td>7.96</td>\n",
              "            <td>3.92</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Poland</td>\n",
              "            <td>312685.0</td>\n",
              "            <td>304255.0</td>\n",
              "            <td>8430.0</td>\n",
              "            <td>38093101.0</td>\n",
              "            <td>-0.26</td>\n",
              "            <td>8.5</td>\n",
              "            <td>10.71</td>\n",
              "            <td>-0.33</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Portugal</td>\n",
              "            <td>92090.0</td>\n",
              "            <td>91470.0</td>\n",
              "            <td>620.0</td>\n",
              "            <td>10242081.0</td>\n",
              "            <td>-0.2</td>\n",
              "            <td>8.0</td>\n",
              "            <td>10.9</td>\n",
              "            <td>0.91</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Romania</td>\n",
              "            <td>238391.0</td>\n",
              "            <td>229891.0</td>\n",
              "            <td>8500.0</td>\n",
              "            <td>18519899.0</td>\n",
              "            <td>-1.09</td>\n",
              "            <td>8.76</td>\n",
              "            <td>15.26</td>\n",
              "            <td>-4.36</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>San Marino</td>\n",
              "            <td>61.0</td>\n",
              "            <td>61.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>34682.0</td>\n",
              "            <td>0.61</td>\n",
              "            <td>8.85</td>\n",
              "            <td>8.82</td>\n",
              "            <td>6.11</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Serbia</td>\n",
              "            <td>77474.0</td>\n",
              "            <td>77474.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>6739471.0</td>\n",
              "            <td>-0.75</td>\n",
              "            <td>8.92</td>\n",
              "            <td>16.39</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Slovakia</td>\n",
              "            <td>49035.0</td>\n",
              "            <td>48105.0</td>\n",
              "            <td>930.0</td>\n",
              "            <td>5431252.0</td>\n",
              "            <td>-0.1</td>\n",
              "            <td>8.94</td>\n",
              "            <td>10.13</td>\n",
              "            <td>0.2</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Slovenia</td>\n",
              "            <td>20273.0</td>\n",
              "            <td>20151.0</td>\n",
              "            <td>122.0</td>\n",
              "            <td>2101208.0</td>\n",
              "            <td>-0.06</td>\n",
              "            <td>8.3</td>\n",
              "            <td>10.4</td>\n",
              "            <td>1.54</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Spain</td>\n",
              "            <td>505370.0</td>\n",
              "            <td>498980.0</td>\n",
              "            <td>6390.0</td>\n",
              "            <td>47163418.0</td>\n",
              "            <td>0.13</td>\n",
              "            <td>7.13</td>\n",
              "            <td>10.22</td>\n",
              "            <td>4.35</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Svalbard</td>\n",
              "            <td>62045.0</td>\n",
              "            <td>62045.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>2926.0</td>\n",
              "            <td>-0.03</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>-5.57</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sweden</td>\n",
              "            <td>450295.0</td>\n",
              "            <td>410335.0</td>\n",
              "            <td>39960.0</td>\n",
              "            <td>10483647.0</td>\n",
              "            <td>0.5</td>\n",
              "            <td>10.83</td>\n",
              "            <td>9.46</td>\n",
              "            <td>3.6</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Switzerland</td>\n",
              "            <td>41277.0</td>\n",
              "            <td>39997.0</td>\n",
              "            <td>1280.0</td>\n",
              "            <td>8508698.0</td>\n",
              "            <td>0.65</td>\n",
              "            <td>10.36</td>\n",
              "            <td>8.4</td>\n",
              "            <td>4.52</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ukraine</td>\n",
              "            <td>603550.0</td>\n",
              "            <td>579330.0</td>\n",
              "            <td>24220.0</td>\n",
              "            <td>43528136.0</td>\n",
              "            <td>-0.5</td>\n",
              "            <td>9.0</td>\n",
              "            <td>13.77</td>\n",
              "            <td>-0.26</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>United Kingdom</td>\n",
              "            <td>243610.0</td>\n",
              "            <td>241930.0</td>\n",
              "            <td>1680.0</td>\n",
              "            <td>67791400.0</td>\n",
              "            <td>0.53</td>\n",
              "            <td>10.79</td>\n",
              "            <td>9.07</td>\n",
              "            <td>3.59</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Armenia</td>\n",
              "            <td>29743.0</td>\n",
              "            <td>28203.0</td>\n",
              "            <td>1540.0</td>\n",
              "            <td>3000756.0</td>\n",
              "            <td>-0.38</td>\n",
              "            <td>11.1</td>\n",
              "            <td>9.51</td>\n",
              "            <td>-5.36</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Azerbaijan</td>\n",
              "            <td>86600.0</td>\n",
              "            <td>82629.0</td>\n",
              "            <td>3971.0</td>\n",
              "            <td>10353296.0</td>\n",
              "            <td>0.67</td>\n",
              "            <td>13.59</td>\n",
              "            <td>6.92</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bahrain</td>\n",
              "            <td>760.0</td>\n",
              "            <td>760.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1540558.0</td>\n",
              "            <td>0.88</td>\n",
              "            <td>12.4</td>\n",
              "            <td>2.82</td>\n",
              "            <td>-0.82</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gaza Strip</td>\n",
              "            <td>360.0</td>\n",
              "            <td>360.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>1997328.0</td>\n",
              "            <td>2.02</td>\n",
              "            <td>27.67</td>\n",
              "            <td>2.91</td>\n",
              "            <td>-4.55</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Georgia</td>\n",
              "            <td>69700.0</td>\n",
              "            <td>69700.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>4935518.0</td>\n",
              "            <td>0.03</td>\n",
              "            <td>11.0</td>\n",
              "            <td>10.8</td>\n",
              "            <td>0.06</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Iran</td>\n",
              "            <td>1648195.0</td>\n",
              "            <td>1531595.0</td>\n",
              "            <td>116600.0</td>\n",
              "            <td>86758304.0</td>\n",
              "            <td>0.98</td>\n",
              "            <td>15.27</td>\n",
              "            <td>5.17</td>\n",
              "            <td>-0.3</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Iraq</td>\n",
              "            <td>438317.0</td>\n",
              "            <td>437367.0</td>\n",
              "            <td>950.0</td>\n",
              "            <td>40462701.0</td>\n",
              "            <td>2.0</td>\n",
              "            <td>24.7</td>\n",
              "            <td>3.9</td>\n",
              "            <td>-0.83</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Israel</td>\n",
              "            <td>21937.0</td>\n",
              "            <td>21497.0</td>\n",
              "            <td>440.0</td>\n",
              "            <td>8914885.0</td>\n",
              "            <td>1.44</td>\n",
              "            <td>17.41</td>\n",
              "            <td>5.05</td>\n",
              "            <td>2.02</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Jordan</td>\n",
              "            <td>89342.0</td>\n",
              "            <td>88802.0</td>\n",
              "            <td>540.0</td>\n",
              "            <td>10998531.0</td>\n",
              "            <td>0.81</td>\n",
              "            <td>22.58</td>\n",
              "            <td>3.45</td>\n",
              "            <td>-11.08</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kuwait</td>\n",
              "            <td>17818.0</td>\n",
              "            <td>17818.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>3068155.0</td>\n",
              "            <td>1.17</td>\n",
              "            <td>17.78</td>\n",
              "            <td>2.25</td>\n",
              "            <td>-3.87</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Lebanon</td>\n",
              "            <td>10400.0</td>\n",
              "            <td>10230.0</td>\n",
              "            <td>170.0</td>\n",
              "            <td>5296814.0</td>\n",
              "            <td>0.66</td>\n",
              "            <td>13.1</td>\n",
              "            <td>5.57</td>\n",
              "            <td>-0.94</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Oman</td>\n",
              "            <td>309500.0</td>\n",
              "            <td>309500.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>3764348.0</td>\n",
              "            <td>1.84</td>\n",
              "            <td>22.11</td>\n",
              "            <td>3.23</td>\n",
              "            <td>-0.45</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Qatar</td>\n",
              "            <td>11586.0</td>\n",
              "            <td>11586.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>2508182.0</td>\n",
              "            <td>1.04</td>\n",
              "            <td>9.33</td>\n",
              "            <td>1.42</td>\n",
              "            <td>2.45</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saudi Arabia</td>\n",
              "            <td>2149690.0</td>\n",
              "            <td>2149690.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>35354380.0</td>\n",
              "            <td>1.63</td>\n",
              "            <td>14.22</td>\n",
              "            <td>3.42</td>\n",
              "            <td>5.52</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Syria</td>\n",
              "            <td>187437.0</td>\n",
              "            <td>185887.0</td>\n",
              "            <td>1550.0</td>\n",
              "            <td>21563800.0</td>\n",
              "            <td>5.91</td>\n",
              "            <td>22.72</td>\n",
              "            <td>4.22</td>\n",
              "            <td>40.58</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Turkey (Turkiye)</td>\n",
              "            <td>783562.0</td>\n",
              "            <td>769632.0</td>\n",
              "            <td>13930.0</td>\n",
              "            <td>83047706.0</td>\n",
              "            <td>0.67</td>\n",
              "            <td>14.28</td>\n",
              "            <td>6.05</td>\n",
              "            <td>-1.54</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>United Arab Emirates</td>\n",
              "            <td>83600.0</td>\n",
              "            <td>83600.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>9915803.0</td>\n",
              "            <td>0.58</td>\n",
              "            <td>10.81</td>\n",
              "            <td>1.56</td>\n",
              "            <td>-3.45</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>West Bank</td>\n",
              "            <td>5860.0</td>\n",
              "            <td>5640.0</td>\n",
              "            <td>220.0</td>\n",
              "            <td>3000021.0</td>\n",
              "            <td>1.69</td>\n",
              "            <td>24.42</td>\n",
              "            <td>3.4</td>\n",
              "            <td>-4.09</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Yemen</td>\n",
              "            <td>527968.0</td>\n",
              "            <td>527968.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>30984689.0</td>\n",
              "            <td>1.88</td>\n",
              "            <td>24.64</td>\n",
              "            <td>5.62</td>\n",
              "            <td>-0.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bermuda</td>\n",
              "            <td>54.0</td>\n",
              "            <td>54.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>72337.0</td>\n",
              "            <td>0.34</td>\n",
              "            <td>11.03</td>\n",
              "            <td>9.11</td>\n",
              "            <td>1.49</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Canada</td>\n",
              "            <td>9984670.0</td>\n",
              "            <td>9093507.0</td>\n",
              "            <td>891163.0</td>\n",
              "            <td>38232593.0</td>\n",
              "            <td>0.75</td>\n",
              "            <td>10.17</td>\n",
              "            <td>8.12</td>\n",
              "            <td>5.46</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Clipperton Island</td>\n",
              "            <td>6.0</td>\n",
              "            <td>6.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Greenland</td>\n",
              "            <td>2166086.0</td>\n",
              "            <td>2166086.0</td>\n",
              "            <td>1710000.0</td>\n",
              "            <td>57792.0</td>\n",
              "            <td>-0.02</td>\n",
              "            <td>13.79</td>\n",
              "            <td>8.96</td>\n",
              "            <td>-5.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mexico</td>\n",
              "            <td>1964375.0</td>\n",
              "            <td>1943945.0</td>\n",
              "            <td>20430.0</td>\n",
              "            <td>129150971.0</td>\n",
              "            <td>0.51</td>\n",
              "            <td>13.55</td>\n",
              "            <td>7.71</td>\n",
              "            <td>-0.76</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saint Pierre and Miquelon</td>\n",
              "            <td>242.0</td>\n",
              "            <td>242.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>5257.0</td>\n",
              "            <td>-1.2</td>\n",
              "            <td>6.47</td>\n",
              "            <td>11.22</td>\n",
              "            <td>-7.23</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>United States</td>\n",
              "            <td>9833517.0</td>\n",
              "            <td>9147593.0</td>\n",
              "            <td>685924.0</td>\n",
              "            <td>337341954.0</td>\n",
              "            <td>0.69</td>\n",
              "            <td>12.28</td>\n",
              "            <td>8.38</td>\n",
              "            <td>3.02</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Argentina</td>\n",
              "            <td>2780400.0</td>\n",
              "            <td>2736690.0</td>\n",
              "            <td>43710.0</td>\n",
              "            <td>46245668.0</td>\n",
              "            <td>0.82</td>\n",
              "            <td>15.58</td>\n",
              "            <td>7.32</td>\n",
              "            <td>-0.08</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bolivia</td>\n",
              "            <td>1098581.0</td>\n",
              "            <td>1083301.0</td>\n",
              "            <td>15280.0</td>\n",
              "            <td>12054379.0</td>\n",
              "            <td>1.12</td>\n",
              "            <td>18.61</td>\n",
              "            <td>6.48</td>\n",
              "            <td>-0.98</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Brazil</td>\n",
              "            <td>8515770.0</td>\n",
              "            <td>8358140.0</td>\n",
              "            <td>157630.0</td>\n",
              "            <td>217240060.0</td>\n",
              "            <td>0.7</td>\n",
              "            <td>13.96</td>\n",
              "            <td>6.81</td>\n",
              "            <td>-0.19</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Chile</td>\n",
              "            <td>756102.0</td>\n",
              "            <td>743812.0</td>\n",
              "            <td>12290.0</td>\n",
              "            <td>18430408.0</td>\n",
              "            <td>0.66</td>\n",
              "            <td>12.75</td>\n",
              "            <td>6.52</td>\n",
              "            <td>0.33</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Colombia</td>\n",
              "            <td>1138910.0</td>\n",
              "            <td>1038700.0</td>\n",
              "            <td>100210.0</td>\n",
              "            <td>49059221.0</td>\n",
              "            <td>0.59</td>\n",
              "            <td>15.21</td>\n",
              "            <td>7.73</td>\n",
              "            <td>-1.58</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ecuador</td>\n",
              "            <td>283561.0</td>\n",
              "            <td>276841.0</td>\n",
              "            <td>6720.0</td>\n",
              "            <td>17289554.0</td>\n",
              "            <td>1.13</td>\n",
              "            <td>16.45</td>\n",
              "            <td>5.17</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Falkland Islands (Islas Malvinas)</td>\n",
              "            <td>12173.0</td>\n",
              "            <td>12173.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>3198.0</td>\n",
              "            <td>0.01</td>\n",
              "            <td>10.9</td>\n",
              "            <td>4.9</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guyana</td>\n",
              "            <td>214969.0</td>\n",
              "            <td>196849.0</td>\n",
              "            <td>18120.0</td>\n",
              "            <td>789683.0</td>\n",
              "            <td>0.24</td>\n",
              "            <td>16.72</td>\n",
              "            <td>6.91</td>\n",
              "            <td>-7.42</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Paraguay</td>\n",
              "            <td>406752.0</td>\n",
              "            <td>397302.0</td>\n",
              "            <td>9450.0</td>\n",
              "            <td>7356409.0</td>\n",
              "            <td>1.14</td>\n",
              "            <td>16.32</td>\n",
              "            <td>4.87</td>\n",
              "            <td>-0.07</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Peru</td>\n",
              "            <td>1285216.0</td>\n",
              "            <td>1279996.0</td>\n",
              "            <td>5220.0</td>\n",
              "            <td>32275736.0</td>\n",
              "            <td>0.51</td>\n",
              "            <td>17.21</td>\n",
              "            <td>11.32</td>\n",
              "            <td>-0.75</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>South Georgia and South Sandwich Islands</td>\n",
              "            <td>3903.0</td>\n",
              "            <td>3903.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Suriname</td>\n",
              "            <td>163820.0</td>\n",
              "            <td>156000.0</td>\n",
              "            <td>7820.0</td>\n",
              "            <td>632638.0</td>\n",
              "            <td>1.13</td>\n",
              "            <td>15.38</td>\n",
              "            <td>6.59</td>\n",
              "            <td>2.54</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Uruguay</td>\n",
              "            <td>176215.0</td>\n",
              "            <td>175015.0</td>\n",
              "            <td>1200.0</td>\n",
              "            <td>3407213.0</td>\n",
              "            <td>0.27</td>\n",
              "            <td>12.71</td>\n",
              "            <td>9.18</td>\n",
              "            <td>-0.88</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Venezuela</td>\n",
              "            <td>912050.0</td>\n",
              "            <td>882050.0</td>\n",
              "            <td>30000.0</td>\n",
              "            <td>29789730.0</td>\n",
              "            <td>2.43</td>\n",
              "            <td>17.27</td>\n",
              "            <td>6.81</td>\n",
              "            <td>13.88</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Afghanistan</td>\n",
              "            <td>652230.0</td>\n",
              "            <td>652230.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>38346720.0</td>\n",
              "            <td>2.3</td>\n",
              "            <td>35.46</td>\n",
              "            <td>12.33</td>\n",
              "            <td>-0.1</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bangladesh</td>\n",
              "            <td>148460.0</td>\n",
              "            <td>130170.0</td>\n",
              "            <td>18290.0</td>\n",
              "            <td>165650475.0</td>\n",
              "            <td>0.93</td>\n",
              "            <td>17.69</td>\n",
              "            <td>5.47</td>\n",
              "            <td>-2.9</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bhutan</td>\n",
              "            <td>38394.0</td>\n",
              "            <td>38394.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>867775.0</td>\n",
              "            <td>0.97</td>\n",
              "            <td>15.94</td>\n",
              "            <td>6.22</td>\n",
              "            <td>0.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>British Indian Ocean Territory</td>\n",
              "            <td>60.0</td>\n",
              "            <td>60.0</td>\n",
              "            <td>54340.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>India</td>\n",
              "            <td>3287263.0</td>\n",
              "            <td>2973193.0</td>\n",
              "            <td>314070.0</td>\n",
              "            <td>1389637446.0</td>\n",
              "            <td>0.67</td>\n",
              "            <td>16.82</td>\n",
              "            <td>10.3</td>\n",
              "            <td>0.16</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Maldives</td>\n",
              "            <td>298.0</td>\n",
              "            <td>298.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>390164.0</td>\n",
              "            <td>-0.14</td>\n",
              "            <td>15.54</td>\n",
              "            <td>4.15</td>\n",
              "            <td>-12.78</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Nepal</td>\n",
              "            <td>147181.0</td>\n",
              "            <td>143351.0</td>\n",
              "            <td>3830.0</td>\n",
              "            <td>30666598.0</td>\n",
              "            <td>0.78</td>\n",
              "            <td>17.53</td>\n",
              "            <td>5.58</td>\n",
              "            <td>-4.21</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Pakistan</td>\n",
              "            <td>796095.0</td>\n",
              "            <td>770875.0</td>\n",
              "            <td>25220.0</td>\n",
              "            <td>242923845.0</td>\n",
              "            <td>1.95</td>\n",
              "            <td>26.48</td>\n",
              "            <td>6.02</td>\n",
              "            <td>-0.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sri Lanka</td>\n",
              "            <td>65610.0</td>\n",
              "            <td>64630.0</td>\n",
              "            <td>980.0</td>\n",
              "            <td>23187516.0</td>\n",
              "            <td>0.61</td>\n",
              "            <td>13.8</td>\n",
              "            <td>6.49</td>\n",
              "            <td>-1.22</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 68
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT MIN(population) AS min_pop,\n",
        "       MAX(population) AS max_pop,\n",
        "       MIN(population_growth) AS min_pop_growth,\n",
        "       MAX(population_growth) max_pop_growth \n",
        "  FROM factbook;"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 97
        },
        "id": "xVETsubLLMas",
        "outputId": "5608d0c5-0d62-4a23-9a57-31273b2e110c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[(50.0, 1410539758.0, -2.39, 5.91)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>min_pop</th>\n",
              "            <th>max_pop</th>\n",
              "            <th>min_pop_growth</th>\n",
              "            <th>max_pop_growth</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>50.0</td>\n",
              "            <td>1410539758.0</td>\n",
              "            <td>-2.39</td>\n",
              "            <td>5.91</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 69
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT *\n",
        "  FROM factbook\n",
        " WHERE population == (SELECT MIN(population)\n",
        "                        FROM factbook\n",
        "                     );"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 97
        },
        "id": "5E12C7G4MhYf",
        "outputId": "10a61a82-11c6-4865-8bb4-20e98608a3cd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Pitcairn Islands', 47.0, 47.0, 0.0, 50.0, 0.0, None, None, None)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>area</th>\n",
              "            <th>area_land</th>\n",
              "            <th>area_water</th>\n",
              "            <th>population</th>\n",
              "            <th>population_growth</th>\n",
              "            <th>birth_rate</th>\n",
              "            <th>death_rate</th>\n",
              "            <th>migration_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Pitcairn Islands</td>\n",
              "            <td>47.0</td>\n",
              "            <td>47.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>50.0</td>\n",
              "            <td>0.0</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "            <td>None</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 70
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT *\n",
        "  FROM factbook\n",
        " WHERE population == (SELECT MAX(population)\n",
        "                        FROM factbook\n",
        "                     );"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 97
        },
        "id": "Bv_TtQGHNJY6",
        "outputId": "e4a5a989-b1d9-4d54-b850-e99b6d4203e0"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('China', 9596960.0, 9326410.0, 270550.0, 1410539758.0, 0.19, 9.93, 7.9, -0.11)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>area</th>\n",
              "            <th>area_land</th>\n",
              "            <th>area_water</th>\n",
              "            <th>population</th>\n",
              "            <th>population_growth</th>\n",
              "            <th>birth_rate</th>\n",
              "            <th>death_rate</th>\n",
              "            <th>migration_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>China</td>\n",
              "            <td>9596960.0</td>\n",
              "            <td>9326410.0</td>\n",
              "            <td>270550.0</td>\n",
              "            <td>1410539758.0</td>\n",
              "            <td>0.19</td>\n",
              "            <td>9.93</td>\n",
              "            <td>7.9</td>\n",
              "            <td>-0.11</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, area, population\n",
        "  FROM factbook ORDER BY population/area DESC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "-JG8v34vSEqQ",
        "outputId": "7584da62-d040-4d12-f6c1-4cfb8dfb5130"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Macau', 28.0, 635293.0),\n",
              " ('Monaco', 2.0, 31400.0),\n",
              " ('Singapore', 719.0, 5921231.0),\n",
              " ('Hong Kong', 1108.0, 7276588.0),\n",
              " ('Gaza Strip', 360.0, 1997328.0),\n",
              " ('Gibraltar', 7.0, 29573.0),\n",
              " ('Bahrain', 760.0, 1540558.0),\n",
              " ('Malta', 316.0, 464186.0),\n",
              " ('Bermuda', 54.0, 72337.0),\n",
              " ('Sint Maarten', 34.0, 45126.0)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>area</th>\n",
              "            <th>population</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Macau</td>\n",
              "            <td>28.0</td>\n",
              "            <td>635293.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Monaco</td>\n",
              "            <td>2.0</td>\n",
              "            <td>31400.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Singapore</td>\n",
              "            <td>719.0</td>\n",
              "            <td>5921231.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Hong Kong</td>\n",
              "            <td>1108.0</td>\n",
              "            <td>7276588.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gaza Strip</td>\n",
              "            <td>360.0</td>\n",
              "            <td>1997328.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gibraltar</td>\n",
              "            <td>7.0</td>\n",
              "            <td>29573.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bahrain</td>\n",
              "            <td>760.0</td>\n",
              "            <td>1540558.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Malta</td>\n",
              "            <td>316.0</td>\n",
              "            <td>464186.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bermuda</td>\n",
              "            <td>54.0</td>\n",
              "            <td>72337.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Sint Maarten</td>\n",
              "            <td>34.0</td>\n",
              "            <td>45126.0</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 72
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, population\n",
        "  FROM factbook ORDER BY population DESC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "ArMIcTjjWAzC",
        "outputId": "d54a8e96-91c6-4ad4-d3f8-e9af16a3ffbc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('China', 1410539758.0),\n",
              " ('India', 1389637446.0),\n",
              " ('United States', 337341954.0),\n",
              " ('Indonesia', 277329163.0),\n",
              " ('Pakistan', 242923845.0),\n",
              " ('Nigeria', 225082083.0),\n",
              " ('Brazil', 217240060.0),\n",
              " ('Bangladesh', 165650475.0),\n",
              " ('Russia', 142021981.0),\n",
              " ('Mexico', 129150971.0)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>population</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>China</td>\n",
              "            <td>1410539758.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>India</td>\n",
              "            <td>1389637446.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>United States</td>\n",
              "            <td>337341954.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Indonesia</td>\n",
              "            <td>277329163.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Pakistan</td>\n",
              "            <td>242923845.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Nigeria</td>\n",
              "            <td>225082083.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Brazil</td>\n",
              "            <td>217240060.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bangladesh</td>\n",
              "            <td>165650475.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Russia</td>\n",
              "            <td>142021981.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mexico</td>\n",
              "            <td>129150971.0</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 73
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, population\n",
        " FROM factbook WHERE population IS NOT NULL ORDER BY population ASC\n",
        " LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "XtujlI-FWXiy",
        "outputId": "e4b119d5-656b-4d0f-e631-1d3eeef7ef1e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Pitcairn Islands', 50.0),\n",
              " ('Cocos (Keeling) Islands', 596.0),\n",
              " ('Holy See (Vatican City)', 1000.0),\n",
              " ('Paracel Islands', 1440.0),\n",
              " ('Tokelau', 1647.0),\n",
              " ('Norfolk Island', 1748.0),\n",
              " ('Niue', 2000.0),\n",
              " ('Christmas Island', 2205.0),\n",
              " ('Svalbard', 2926.0),\n",
              " ('Falkland Islands (Islas Malvinas)', 3198.0)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>population</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Pitcairn Islands</td>\n",
              "            <td>50.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cocos (Keeling) Islands</td>\n",
              "            <td>596.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Holy See (Vatican City)</td>\n",
              "            <td>1000.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Paracel Islands</td>\n",
              "            <td>1440.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tokelau</td>\n",
              "            <td>1647.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Norfolk Island</td>\n",
              "            <td>1748.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Niue</td>\n",
              "            <td>2000.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Christmas Island</td>\n",
              "            <td>2205.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Svalbard</td>\n",
              "            <td>2926.0</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Falkland Islands (Islas Malvinas)</td>\n",
              "            <td>3198.0</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 74
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, population/area as people_per_sq_km\n",
        "  FROM factbook WHERE population IS NOT NULL AND area > 0 ORDER BY population/area ASC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "1gKsWPOHYDfq",
        "outputId": "19860c18-0fbb-47fa-dda8-d3932367b9c5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Greenland', 0.026680381111368615),\n",
              " ('Svalbard', 0.047159319848497055),\n",
              " ('Falkland Islands (Islas Malvinas)', 0.262712560584901),\n",
              " ('Pitcairn Islands', 1.0638297872340425),\n",
              " ('Mongolia', 2.063697961020794),\n",
              " ('Namibia', 3.3087898463165963),\n",
              " ('Australia', 3.376905578190518),\n",
              " ('Iceland', 3.471873786407767),\n",
              " ('Guyana', 3.6734738497178663),\n",
              " ('Canada', 3.8291293553016774)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>people_per_sq_km</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Greenland</td>\n",
              "            <td>0.026680381111368615</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Svalbard</td>\n",
              "            <td>0.047159319848497055</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Falkland Islands (Islas Malvinas)</td>\n",
              "            <td>0.262712560584901</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Pitcairn Islands</td>\n",
              "            <td>1.0638297872340425</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mongolia</td>\n",
              "            <td>2.063697961020794</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Namibia</td>\n",
              "            <td>3.3087898463165963</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Australia</td>\n",
              "            <td>3.376905578190518</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Iceland</td>\n",
              "            <td>3.471873786407767</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guyana</td>\n",
              "            <td>3.6734738497178663</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Canada</td>\n",
              "            <td>3.8291293553016774</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 75
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, migration_rate\n",
        "  FROM factbook WHERE migration_rate IS NOT NULL\n",
        "  ORDER BY migration_rate ASC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "SOWY8BaEZiLh",
        "outputId": "86b7ce82-e6cb-4bd6-b715-1b07072af831"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('American Samoa', -29.8),\n",
              " ('Cook Islands', -27.31),\n",
              " ('Micronesia, Federated States of', -20.91),\n",
              " ('Tonga', -18.01),\n",
              " ('Northern Mariana Islands', -13.6),\n",
              " ('Maldives', -12.78),\n",
              " ('Puerto Rico', -11.9),\n",
              " ('Jordan', -11.08),\n",
              " ('Guam', -10.96),\n",
              " ('Nauru', -10.6)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>migration_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>American Samoa</td>\n",
              "            <td>-29.8</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cook Islands</td>\n",
              "            <td>-27.31</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Micronesia, Federated States of</td>\n",
              "            <td>-20.91</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Tonga</td>\n",
              "            <td>-18.01</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Northern Mariana Islands</td>\n",
              "            <td>-13.6</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Maldives</td>\n",
              "            <td>-12.78</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Puerto Rico</td>\n",
              "            <td>-11.9</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Jordan</td>\n",
              "            <td>-11.08</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Guam</td>\n",
              "            <td>-10.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Nauru</td>\n",
              "            <td>-10.6</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 76
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, migration_rate\n",
        "  FROM factbook WHERE migration_rate IS NOT NULL\n",
        "  ORDER BY migration_rate DESC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "pvgpQjkkZ83C",
        "outputId": "09d4cdbd-d4a1-4831-a7a1-0e12a505248b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Syria', 40.58),\n",
              " ('South Sudan', 20.97),\n",
              " ('Equatorial Guinea', 13.96),\n",
              " ('Venezuela', 13.88),\n",
              " ('British Virgin Islands', 13.56),\n",
              " ('Cayman Islands', 12.56),\n",
              " ('Luxembourg', 12.01),\n",
              " ('Anguilla', 10.67),\n",
              " ('Monaco', 10.03),\n",
              " ('Turks and Caicos Islands', 8.58)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>migration_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Syria</td>\n",
              "            <td>40.58</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>South Sudan</td>\n",
              "            <td>20.97</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Equatorial Guinea</td>\n",
              "            <td>13.96</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Venezuela</td>\n",
              "            <td>13.88</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>British Virgin Islands</td>\n",
              "            <td>13.56</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Cayman Islands</td>\n",
              "            <td>12.56</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Luxembourg</td>\n",
              "            <td>12.01</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Anguilla</td>\n",
              "            <td>10.67</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Monaco</td>\n",
              "            <td>10.03</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Turks and Caicos Islands</td>\n",
              "            <td>8.58</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 77
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, birth_rate\n",
        "  FROM factbook WHERE birth_rate IS NOT NULL\n",
        "  ORDER BY birth_rate DESC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "ssOCTQ_9a7-L",
        "outputId": "6d939e1a-9991-4e03-a289-c8f6b48db69b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Niger', 47.08),\n",
              " ('Angola', 41.8),\n",
              " ('Benin', 41.15),\n",
              " ('Mali', 41.07),\n",
              " ('Uganda', 40.94),\n",
              " ('Chad', 40.45),\n",
              " ('Congo, Democratic Republic of the', 40.08),\n",
              " ('Somalia', 37.98),\n",
              " ('South Sudan', 37.69),\n",
              " ('Mozambique', 37.47)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>birth_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Niger</td>\n",
              "            <td>47.08</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Angola</td>\n",
              "            <td>41.8</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Benin</td>\n",
              "            <td>41.15</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mali</td>\n",
              "            <td>41.07</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Uganda</td>\n",
              "            <td>40.94</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Chad</td>\n",
              "            <td>40.45</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Congo, Democratic Republic of the</td>\n",
              "            <td>40.08</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Somalia</td>\n",
              "            <td>37.98</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>South Sudan</td>\n",
              "            <td>37.69</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Mozambique</td>\n",
              "            <td>37.47</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 78
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, birth_rate\n",
        "  FROM factbook WHERE birth_rate IS NOT NULL\n",
        "  ORDER BY birth_rate ASC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "3D_4-UOnbFmc",
        "outputId": "2364df61-b2d6-463a-dd06-d79d62af1288"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Saint Pierre and Miquelon', 6.47),\n",
              " ('Monaco', 6.66),\n",
              " ('Andorra', 6.88),\n",
              " ('Korea, South', 6.92),\n",
              " ('Japan', 6.95),\n",
              " ('Italy', 6.95),\n",
              " ('Spain', 7.13),\n",
              " ('Taiwan', 7.39),\n",
              " ('Greece', 7.61),\n",
              " ('Puerto Rico', 7.87)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>birth_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Saint Pierre and Miquelon</td>\n",
              "            <td>6.47</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Monaco</td>\n",
              "            <td>6.66</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Andorra</td>\n",
              "            <td>6.88</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Korea, South</td>\n",
              "            <td>6.92</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Japan</td>\n",
              "            <td>6.95</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Italy</td>\n",
              "            <td>6.95</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Spain</td>\n",
              "            <td>7.13</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Taiwan</td>\n",
              "            <td>7.39</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Greece</td>\n",
              "            <td>7.61</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Puerto Rico</td>\n",
              "            <td>7.87</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 79
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, death_rate\n",
        "  FROM factbook WHERE death_rate IS NOT NULL\n",
        "  ORDER BY death_rate DESC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "q4ipUi7zbNtz",
        "outputId": "cdf9de28-12a4-468a-923c-85ff83ab691a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Serbia', 16.39),\n",
              " ('Romania', 15.26),\n",
              " ('Lithuania', 15.12),\n",
              " ('Latvia', 14.65),\n",
              " ('Bulgaria', 14.41),\n",
              " ('Ukraine', 13.77),\n",
              " ('Russia', 13.36),\n",
              " ('Estonia', 13.1),\n",
              " ('Belarus', 12.88),\n",
              " ('Croatia', 12.88)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>death_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Serbia</td>\n",
              "            <td>16.39</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Romania</td>\n",
              "            <td>15.26</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Lithuania</td>\n",
              "            <td>15.12</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Latvia</td>\n",
              "            <td>14.65</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bulgaria</td>\n",
              "            <td>14.41</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Ukraine</td>\n",
              "            <td>13.77</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Russia</td>\n",
              "            <td>13.36</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Estonia</td>\n",
              "            <td>13.1</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Belarus</td>\n",
              "            <td>12.88</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Croatia</td>\n",
              "            <td>12.88</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 80
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "%%sql\n",
        "SELECT name, death_rate\n",
        "  FROM factbook WHERE death_rate IS NOT NULL\n",
        "  ORDER BY death_rate ASC\n",
        "  LIMIT 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 285
        },
        "id": "i6vCUd7FbSeF",
        "outputId": "c6b1f6da-0f44-4a3a-f524-54bf772b0555"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            " * sqlite:///factbook.db\n",
            "Done.\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('Tokelau', -3.84),\n",
              " ('Qatar', 1.42),\n",
              " ('United Arab Emirates', 1.56),\n",
              " ('Kuwait', 2.25),\n",
              " ('Bahrain', 2.82),\n",
              " ('Gaza Strip', 2.91),\n",
              " ('Oman', 3.23),\n",
              " ('West Bank', 3.4),\n",
              " ('Saudi Arabia', 3.42),\n",
              " ('Libya', 3.45)]"
            ],
            "text/html": [
              "<table>\n",
              "    <thead>\n",
              "        <tr>\n",
              "            <th>name</th>\n",
              "            <th>death_rate</th>\n",
              "        </tr>\n",
              "    </thead>\n",
              "    <tbody>\n",
              "        <tr>\n",
              "            <td>Tokelau</td>\n",
              "            <td>-3.84</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Qatar</td>\n",
              "            <td>1.42</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>United Arab Emirates</td>\n",
              "            <td>1.56</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Kuwait</td>\n",
              "            <td>2.25</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Bahrain</td>\n",
              "            <td>2.82</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Gaza Strip</td>\n",
              "            <td>2.91</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Oman</td>\n",
              "            <td>3.23</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>West Bank</td>\n",
              "            <td>3.4</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Saudi Arabia</td>\n",
              "            <td>3.42</td>\n",
              "        </tr>\n",
              "        <tr>\n",
              "            <td>Libya</td>\n",
              "            <td>3.45</td>\n",
              "        </tr>\n",
              "    </tbody>\n",
              "</table>"
            ]
          },
          "metadata": {},
          "execution_count": 81
        }
      ]
    }
  ]
}