Combine_Csvs-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Notebook to combine .csv datasets into one sqlite database for Project 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dependencies and Setup\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import sqlite3\n",
    "import os\n",
    "\n",
    "pd.set_option('display.max_rows', 500)\n",
    "pd.set_option('display.max_columns', 500)\n",
    "pd.set_option('display.width', 1000)\n",
    "\n",
    "# File to Load (Remember to Change These)\n",
    "ebola_data_to_load = \"Data/ebola_data.csv\"\n",
    "swineflu_data_to_load = \"Data/swineflu_data.csv\"\n",
    "covid19_data_to_load = \"Data/merged_covid_19_data.csv\"\n",
    "lookup_countries_to_load = \"Data/country_lookup_table.csv\"\n",
    "centroid_data_to_load = \"Data/clean_country_centroids_az8.csv\"\n",
    "\n",
    "# Read Population Data from \"Estimates\" sheet\n",
    "ebola_data = pd.read_csv(ebola_data_to_load)\n",
    "swineflu_data = pd.read_csv(swineflu_data_to_load)\n",
    "covid19_data = pd.read_csv(covid19_data_to_load)\n",
    "lookup_data = pd.read_csv(lookup_countries_to_load, encoding=\"ISO-8859-1\")\n",
    "centroid_data = pd.read_csv(centroid_data_to_load)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pandemic</th>\n",
       "      <th>Country</th>\n",
       "      <th>Year</th>\n",
       "      <th>Cases</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ebola</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>2014</td>\n",
       "      <td>2397.0</td>\n",
       "      <td>1433.0</td>\n",
       "      <td>-10.940666</td>\n",
       "      <td>10.436216</td>\n",
       "      <td>1.115097e+13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ebola</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>2015</td>\n",
       "      <td>3351.0</td>\n",
       "      <td>2083.0</td>\n",
       "      <td>-10.940666</td>\n",
       "      <td>10.436216</td>\n",
       "      <td>1.143210e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ebola</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>2016</td>\n",
       "      <td>3351.0</td>\n",
       "      <td>2083.0</td>\n",
       "      <td>-10.940666</td>\n",
       "      <td>10.436216</td>\n",
       "      <td>1.173843e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ebola</td>\n",
       "      <td>Italy</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.070013</td>\n",
       "      <td>42.796626</td>\n",
       "      <td>6.057849e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ebola</td>\n",
       "      <td>Italy</td>\n",
       "      <td>2016</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.070013</td>\n",
       "      <td>42.796626</td>\n",
       "      <td>6.066307e+04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Pandemic Country  Year   Cases  Deaths        Lon        Lat    population\n",
       "0    Ebola  Guinea  2014  2397.0  1433.0 -10.940666  10.436216  1.115097e+13\n",
       "1    Ebola  Guinea  2015  3351.0  2083.0 -10.940666  10.436216  1.143210e+07\n",
       "2    Ebola  Guinea  2016  3351.0  2083.0 -10.940666  10.436216  1.173843e+04\n",
       "3    Ebola   Italy  2015     1.0     0.0  12.070013  42.796626  6.057849e+07\n",
       "4    Ebola   Italy  2016     1.0     0.0  12.070013  42.796626  6.066307e+04"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ebola_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pandemic</th>\n",
       "      <th>Country</th>\n",
       "      <th>Year</th>\n",
       "      <th>Cases</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2020</td>\n",
       "      <td>39268</td>\n",
       "      <td>1458</td>\n",
       "      <td>66.004734</td>\n",
       "      <td>33.835231</td>\n",
       "      <td>35383028.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Albania</td>\n",
       "      <td>2020</td>\n",
       "      <td>13518</td>\n",
       "      <td>384</td>\n",
       "      <td>20.049834</td>\n",
       "      <td>41.142450</td>\n",
       "      <td>2886427.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>2020</td>\n",
       "      <td>51368</td>\n",
       "      <td>1726</td>\n",
       "      <td>2.617323</td>\n",
       "      <td>28.158938</td>\n",
       "      <td>40551398.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>American Samoa</td>\n",
       "      <td>2020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>55739.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Andorra</td>\n",
       "      <td>2020</td>\n",
       "      <td>1966</td>\n",
       "      <td>53</td>\n",
       "      <td>1.560544</td>\n",
       "      <td>42.542291</td>\n",
       "      <td>77295.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Pandemic         Country  Year  Cases  Deaths        Lon        Lat  population\n",
       "0  Covid19     Afghanistan  2020  39268    1458  66.004734  33.835231  35383028.0\n",
       "1  Covid19         Albania  2020  13518     384  20.049834  41.142450   2886427.0\n",
       "2  Covid19         Algeria  2020  51368    1726   2.617323  28.158938  40551398.0\n",
       "3  Covid19  American Samoa  2020      0       0        NaN        NaN     55739.0\n",
       "4  Covid19         Andorra  2020   1966      53   1.560544  42.542291     77295.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "covid19_data1 = covid19_data[['Pandemic', 'Country', 'Year', 'Cases', 'Deaths', 'Lon', 'Lat', 'population']]\n",
    "covid19_data1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pandemic</th>\n",
       "      <th>Country</th>\n",
       "      <th>Year</th>\n",
       "      <th>Cases</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Swineflu-W</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>2009</td>\n",
       "      <td>113690</td>\n",
       "      <td>3433</td>\n",
       "      <td>-112.461674</td>\n",
       "      <td>45.679547</td>\n",
       "      <td>3.063076e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Swineflu-W</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>2009</td>\n",
       "      <td>58178</td>\n",
       "      <td>2135</td>\n",
       "      <td>-53.097831</td>\n",
       "      <td>-10.787777</td>\n",
       "      <td>1.938865e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Swineflu-W</td>\n",
       "      <td>India</td>\n",
       "      <td>2009</td>\n",
       "      <td>33783</td>\n",
       "      <td>2024</td>\n",
       "      <td>79.611976</td>\n",
       "      <td>22.885782</td>\n",
       "      <td>1.217726e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Swineflu-W</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>2009</td>\n",
       "      <td>70715</td>\n",
       "      <td>1316</td>\n",
       "      <td>-102.523452</td>\n",
       "      <td>23.947537</td>\n",
       "      <td>1.124639e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Swineflu-W</td>\n",
       "      <td>China</td>\n",
       "      <td>2009</td>\n",
       "      <td>120940</td>\n",
       "      <td>800</td>\n",
       "      <td>103.819073</td>\n",
       "      <td>36.561765</td>\n",
       "      <td>1.361169e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Pandemic                   Country  Year   Cases  Deaths         Lon        Lat    population\n",
       "0  Swineflu-W  United States of America  2009  113690    3433 -112.461674  45.679547  3.063076e+08\n",
       "1  Swineflu-W                    Brazil  2009   58178    2135  -53.097831 -10.787777  1.938865e+08\n",
       "2  Swineflu-W                     India  2009   33783    2024   79.611976  22.885782  1.217726e+09\n",
       "3  Swineflu-W                    Mexico  2009   70715    1316 -102.523452  23.947537  1.124639e+08\n",
       "4  Swineflu-W                     China  2009  120940     800  103.819073  36.561765  1.361169e+09"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "swineflu_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = sqlite3.connect('Data/Pandemic_data.db')\n",
    "c = conn.cursor()\n",
    "# Delete all rows from db\n",
    "# c.execute('DELETE FROM PANDEMICS;',);\n",
    "\n",
    "# Add data \n",
    "covid19_data1.to_sql('PANDEMICS', conn, if_exists='append', index=False)\n",
    "ebola_data.to_sql('PANDEMICS', conn, if_exists='append', index=False)\n",
    "swineflu_data.to_sql('PANDEMICS', conn, if_exists='append', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('Covid19', 'Afghanistan', 2020, 39268, 1458, 66.00473366, 33.83523073, 35383028.0)\n",
      "('Covid19', 'Albania', 2020, 13518, 384, 20.04983396, 41.14244989, 2886427.0)\n",
      "('Covid19', 'Algeria', 2020, 51368, 1726, 2.61732301, 28.15893849, 40551398.0)\n",
      "('Covid19', 'American Samoa', 2020, 0, 0, None, None, 55739.0)\n",
      "('Covid19', 'Andorra', 2020, 1966, 53, 1.56054378, 42.54229102, 77295.0)\n",
      "('Covid19', 'Angola', 2020, 4905, 179, 17.53736768, -12.29336054, 28842482.000000004)\n",
      "('Covid19', 'Anguilla', 2020, 3, 0, -63.06498927, 18.2239595, 14435.0)\n",
      "('Covid19', 'Antigua and Barbuda', 2020, 101, 3, -61.79469343, 17.277499600000002, 94520.0)\n",
      "('Covid19', 'Argentina', 2020, 723132, 16113, -65.17980692, -35.3813488, 43508459.0)\n",
      "('Covid19', 'Armenia', 2020, 50359, 959, 44.92993276, 40.28952569, 2936147.0)\n",
      "('Covid19', 'Aruba', 2020, 3872, 25, -69.98267711, 12.52088038, 104865.0)\n",
      "('Covid19', 'Australia', 2020, 27063, 882, 134.49100009999998, -25.73288704, 24262710.0)\n",
      "('Covid19', 'Austria', 2020, 44607, 796, 14.1264761, 47.58549439, 8747306.0)\n",
      "('Covid19', 'Azerbaijan', 2020, 40119, 590, 47.54599879, 40.28827235, 9736041.0)\n",
      "('Covid19', 'Bahamas', 2020, 3903, 91, -76.62843038, 24.29036702, 377923.0)\n",
      "('Covid19', 'Bahrain', 2020, 70422, 246, 50.54196932, 26.04205135, 1425793.0)\n",
      "('Covid19', 'Bangladesh', 2020, 362043, 5219, 90.23812743, 23.86731158, 157977150.99999997)\n",
      "('Covid19', 'Barbados', 2020, 190, 7, -59.559797, 13.18145428, 285798.0)\n",
      "('Covid19', 'Belarus', 2020, 78260, 828, 28.03209307, 53.53131377, 9445638.0)\n",
      "('Covid19', 'Belgium', 2020, 117021, 10001, 4.64065114, 50.63981576, 11354407.0)\n",
      "('Covid19', 'Belize', 2020, 1891, 24, -88.71010486, 17.20027509, 368399.0)\n",
      "('Covid19', 'Benin', 2020, 2357, 41, 2.32785254, 9.6417597, 10872072.0)\n",
      "('Covid19', 'Bermuda', 2020, 181, 9, -64.7545589, 32.31367802, 63360.0)\n",
      "('Covid19', 'Bhutan', 2020, 281, 0, 90.40188155, 27.41106589, 736706.0)\n",
      "('Covid19', 'Bolivia (Plurinational State of)', 2020, 134223, 7900, -64.68538645, -16.70814787, 11031822.0)\n",
      "('Covid19', 'Bonaire, Sint Eustatius and Saba', 2020, 115, 1, None, None, 25017.0)\n",
      "('Covid19', 'Bosnia and Herzegovina', 2020, 27222, 836, None, None, 3386263.0)\n",
      "('Covid19', 'Botswana', 2020, 3172, 16, 23.79853368, -22.18403213, 2159925.0)\n",
      "('Covid19', 'Brazil', 2020, 4745464, 142058, -53.09783113, -10.78777702, 206163056.0)\n",
      "('Covid19', 'British Virgin Islands', 2020, 71, 1, -64.47146992, 18.52585755, 29355.0)\n",
      "('Covid19', 'Brunei Darussalam', 2020, 146, 3, None, None, 419791.0)\n",
      "('Covid19', 'Bulgaria', 2020, 20547, 814, 25.21552909, 42.76890318, 7151948.0)\n",
      "('Covid19', 'Burkina Faso', 2020, 2028, 57, -1.75456601, 12.26953846, 18646350.0)\n",
      "('Covid19', 'Burundi', 2020, 508, 1, 29.87512156, -3.35939666, 10488002.0)\n",
      "('Covid19', 'Cabo Verde', 2020, 5900, 59, None, None, 531140.0)\n",
      "('Covid19', 'Cambodia', 2020, 277, 0, 104.9069433, 12.72004786, 15766290.0)\n",
      "('Covid19', 'Cameroon', 2020, 20838, 418, 12.73964156, 5.69109849, 23926549.0)\n",
      "('Covid19', 'Canada', 2020, 155301, 9278, -98.30777028, 61.36206324, 36382942.0)\n",
      "('Covid19', 'Cayman Islands', 2020, 211, 1, -80.91213321, 19.42896497, 62563.99999999999)\n",
      "('Covid19', 'Central African Republic', 2020, 4829, 62, 20.46826831, 6.56823297, 4537683.0)\n",
      "('Covid19', 'Chad', 2020, 1193, 85, 18.64492513, 15.33333758, 14561658.000000002)\n",
      "('Covid19', 'Chile', 2020, 461300, 12725, -71.38256213, -37.73070989, 18209072.0)\n",
      "('Covid19', 'China', 2020, 91041, 4746, 103.8190735, 36.56176546, 1414049353.0)\n",
      "('Covid19', 'Colombia', 2020, 818203, 25641, -73.08114582, 3.91383431, 48175047.99999999)\n",
      "('Covid19', 'Comoros', 2020, 478, 7, 43.68253968, -11.87783444, 795597.0)\n",
      "('Covid19', 'Congo', 2020, 5089, 89, 15.21965762, -0.83787463, 4980996.0)\n",
      "('Covid19', 'Cook Islands', 2020, 0, 0, -159.78724219999995, -21.21927288, 17521.0)\n",
      "('Covid19', 'Costa Rica', 2020, 73714, 861, -84.19208768, 9.97634464, 4899335.999999999)\n",
      "('Covid19', 'Croatia', 2020, 16380, 275, 16.40412899, 45.08047631, 4208611.0)\n",
      "('Covid19', 'Cuba', 2020, 5531, 122, -79.01605384, 21.62289528, 11335108.0)\n",
      "('Covid19', 'Cyprus', 2020, 1713, 22, 33.0060022, 34.91667211, 1170188.9999999998)\n",
      "('Covid19', 'Czechia', 2020, 67843, 636, 15.31240163, 49.73341233, 10618868.0)\n",
      "('Covid19', \"Dem. People's Republic of Korea\", 2020, 0, 0, 127.1924797, 40.15350311, 25307665.0)\n",
      "('Covid19', 'Democratic Republic of the Congo', 2020, 10630, 272, 23.64396107, -2.87746289, 78789130.0)\n",
      "('Covid19', 'Denmark', 2020, 27464, 650, 10.02800992, 55.98125296, 5711346.0)\n",
      "('Covid19', 'Djibouti', 2020, 5416, 61, 42.5606754, 11.74871806, 929117.0)\n",
      "('Covid19', 'Dominica', 2020, 30, 0, -61.357726, 15.4394702, 71307.0)\n",
      "('Covid19', 'Dominican Republic', 2020, 111900, 2101, -70.50568896, 18.89433082, 10397738.000000002)\n",
      "('Covid19', 'Ecuador', 2020, 135749, 11312, -78.75201922, -1.42381612, 16491116.000000002)\n",
      "('Covid19', 'Egypt', 2020, 103079, 5914, 29.86190099, 26.49593311, 94447071.0)\n",
      "('Covid19', 'El Salvador', 2020, 28981, 839, -88.87164469, 13.73943744, 6356137.0)\n",
      "('Covid19', 'Equatorial Guinea', 2020, 5028, 83, None, None, 1215181.0)\n",
      "('Covid19', 'Eritrea', 2020, 375, 0, 38.84617011, 15.36186618, 3376558.0)\n",
      "('Covid19', 'Estonia', 2020, 3315, 64, 25.54248537, 58.67192972, 1316507.0)\n",
      "('Covid19', 'Eswatini', 2020, 5462, 108, None, None, 1113994.0)\n",
      "('Covid19', 'Ethiopia', 2020, 74584, 1191, 39.60080098, 8.62278679, 103603461.0)\n",
      "('Covid19', 'Falkland Islands (Malvinas)', 2020, 13, 0, -59.35238956, -51.74483954, 2926.0)\n",
      "('Covid19', 'Faroe Islands', 2020, 463, 0, -6.88095423, 62.05385403, 48173.0)\n",
      "('Covid19', 'Fiji', 2020, 32, 2, 165.4519543, -17.42858032, 872406.0000000001)\n",
      "('Covid19', 'Finland', 2020, 9892, 345, 26.2746656, 64.49884603, 5497714.0)\n",
      "('Covid19', 'France', 2020, 526435, 31691, -2.76172945, 42.17344011, 64667590.0)\n",
      "('Covid19', 'French Guiana', 2020, 9895, 65, None, None, 267824.0)\n",
      "('Covid19', 'French Polynesia', 2020, 1728, 7, -144.9049439, -14.72227409, 274575.99999999994)\n",
      "('Covid19', 'Gabon', 2020, 8752, 54, 11.7886287, -0.58660025, 2007882.0)\n",
      "('Covid19', 'Gambia', 2020, 3579, 112, -15.39601295, 13.44965244, 2149134.0)\n",
      "('Covid19', 'Georgia', 2020, 6192, 36, 43.50780252, 42.16855755, 4015457.0000000005)\n",
      "('Covid19', 'Germany', 2020, 289219, 9488, 10.38578051, 51.10698181, 82193770.0)\n",
      "('Covid19', 'Ghana', 2020, 46482, 301, -1.21676566, 7.95345644, 28481947.0)\n",
      "('Covid19', 'Gibraltar', 2020, 382, 0, None, None, 33738.0)\n",
      "('Covid19', 'Greece', 2020, 18123, 388, 22.95555794, 39.07469623, 10615183.0)\n",
      "('Covid19', 'Greenland', 2020, 14, 0, -41.34191127, 74.71051289, 56408.0)\n",
      "('Covid19', 'Grenada', 2020, 24, 0, -61.68220189, 12.11725044, 110263.0)\n",
      "('Covid19', 'Guadeloupe', 2020, 4954, 53, None, None, 399760.0)\n",
      "('Covid19', 'Guam', 2020, 2443, 47, 144.7679102, 13.44165626, 162947.99999999994)\n",
      "('Covid19', 'Guatemala', 2020, 90968, 3238, -90.36482009, 15.69403664, 16583078.999999998)\n",
      "('Covid19', 'Guinea', 2020, 10634, 66, -10.94066612, 10.43621593, 11738434.0)\n",
      "('Covid19', 'Guinea-Bissau', 2020, 2324, 39, -14.94972445, 12.04744948, 1782434.0)\n",
      "('Covid19', 'Guyana', 2020, 2787, 78, -58.98202459, 4.79378034, 771363.0)\n",
      "('Covid19', 'Haiti', 2020, 8740, 227, -72.68527509, 18.93502563, 10839976.0)\n",
      "('Covid19', 'Holy See', 2020, 12, 0, None, None, 790.9999999999999)\n",
      "('Covid19', 'Honduras', 2020, 75537, 2301, -86.6151661, 14.82688165, 9270794.0)\n",
      "('Covid19', 'Hungary', 2020, 26461, 765, 19.39559116, 47.16277506, 9752970.0)\n",
      "('Covid19', 'Iceland', 2020, 2695, 10, -18.57396167, 64.99575386, 332209.0)\n",
      "('Covid19', 'India', 2020, 6225763, 97497, 79.61197609999998, 22.88578212, 1324517250.0)\n",
      "('Covid19', 'Indonesia', 2020, 282724, 10601, 117.2401137, -2.21505456, 261556386.00000003)\n",
      "('Covid19', 'Iran (Islamic Republic of)', 2020, 453637, 25986, 54.27407004, 32.57503292, 79563991.0)\n",
      "('Covid19', 'Iraq', 2020, 358290, 9122, 43.74353149, 33.03970582, 36610632.00000001)\n",
      "('Covid19', 'Ireland', 2020, 35740, 1803, -8.13793569, 53.17544870000001, 4695790.0)\n",
      "('Covid19', 'Isle of Man', 2020, 340, 24, -4.53873952, 54.22418911, 83296.0)\n",
      "('Covid19', 'Israel', 2020, 233456, 1511, 35.00444693, 31.46110101, 8108984.0)\n",
      "('Covid19', 'Italy', 2020, 313011, 35875, 12.07001339, 42.79662641, 60663068.0)\n",
      "('Covid19', 'Jamaica', 2020, 6408, 101, -77.31482593, 18.15694878, 2906242.0)\n",
      "('Covid19', 'Japan', 2020, 83010, 1564, 138.0308956, 37.59230135, 127763267.0)\n",
      "('Covid19', 'Jordan', 2020, 10049, 57, 36.77136104, 31.24579091, 9554286.0)\n",
      "('Covid19', 'Kazakhstan', 2020, 140707, 2075, 67.29149357, 48.15688067, 17830902.0)\n",
      "('Covid19', 'Kenya', 2020, 38378, 707, 37.79593973, 0.59988022, 49051530.99999999)\n",
      "('Covid19', 'Kiribati', 2020, 0, 0, -45.61110513, 0.86001503, 112529.0)\n",
      "('Covid19', 'Kuwait', 2020, 104568, 607, 47.58700459, 29.33431262, 3956862.0)\n",
      "('Covid19', 'Kyrgyzstan', 2020, 46669, 1064, 74.54165513, 41.46221943, 6074326.999999999)\n",
      "('Covid19', \"Lao People's Democratic Republic\", 2020, 23, 0, 103.7377241, 18.50217433, 6845848.000000001)\n",
      "('Covid19', 'Latvia', 2020, 1729, 37, 24.91235983, 56.85085163, 1974265.0)\n",
      "('Covid19', 'Lebanon', 2020, 38363, 361, 35.88016072, 33.92306631, 6714281.0)\n",
      "('Covid19', 'Lesotho', 2020, 1565, 35, 28.22723131, -29.58003188, 2075041.0)\n",
      "('Covid19', 'Liberia', 2020, 1339, 82, -9.32207573, 6.45278492, 4586788.0)\n",
      "('Covid19', 'Libya', 2020, 34014, 540, 18.00866169, 27.03094495, 6492160.0)\n",
      "('Covid19', 'Liechtenstein', 2020, 120, 1, 9.53574312, 47.13665835, 37655.0)\n",
      "('Covid19', 'Lithuania', 2020, 4578, 92, 23.88719355, 55.32610984, 2889555.0)\n",
      "('Covid19', 'Luxembourg', 2020, 8431, 124, 6.07182201, 49.76725361, 579266.0)\n",
      "('Covid19', 'Madagascar', 2020, 16377, 229, 46.70473674, -19.37189587, 24894370.0)\n",
      "('Covid19', 'Malawi', 2020, 5772, 179, 34.28935599, -13.21808088, 17205253.0)\n",
      "('Covid19', 'Malaysia', 2020, 11135, 134, 109.6976228, 3.78986846, 30684652.0)\n",
      "('Covid19', 'Maldives', 2020, 10194, 34, 73.45713004, 3.7287092, 475505.0)\n",
      "('Covid19', 'Mali', 2020, 3101, 131, -3.54269065, 17.34581581, 17965448.0)\n",
      "('Covid19', 'Malta', 2020, 3035, 34, 14.40523316, 35.92149632, 436099.0)\n",
      "('Covid19', 'Marshall Islands', 2020, 0, 0, 170.3397612, 7.00376358, 57723.0)\n",
      "('Covid19', 'Martinique', 2020, 1298, 20, None, None, 376789.0)\n",
      "('Covid19', 'Mauritania', 2020, 7488, 161, -10.34779815, 20.25736706, 4163532.0)\n",
      "('Covid19', 'Mauritius', 2020, 381, 10, 57.57120551, -20.27768704, 1261870.0)\n",
      "('Covid19', 'Mayotte', 2020, 3779, 42, None, None, 246460.0)\n",
      "('Covid19', 'Mexico', 2020, 733717, 76603, -102.5234517, 23.94753724, 123333379.0)\n",
      "('Covid19', 'Micronesia (Fed. States of)', 2020, 0, 0, None, None, 110215.0)\n",
      "('Covid19', 'Monaco', 2020, 214, 1, 7.40627677, 43.75274627, 38070.0)\n",
      "('Covid19', 'Mongolia', 2020, 313, 0, 103.0529977, 46.82681544, 3056357.9999999995)\n",
      "('Covid19', 'Montenegro', 2020, 10633, 164, 19.23883939, 42.78890259, 627271.0)\n",
      "('Covid19', 'Montserrat', 2020, 13, 1, -62.18518546, 16.73941406, 4978.0)\n",
      "('Covid19', 'Morocco', 2020, 121183, 2152, -8.45615795, 29.83762955, 35126274.0)\n",
      "('Covid19', 'Mozambique', 2020, 8556, 59, 35.53367543, -17.27381643, 27829930.0)\n",
      "('Covid19', 'Myanmar', 2020, 12425, 284, 96.48843321, 21.18566599, 53045199.0)\n",
      "('Covid19', 'Namibia', 2020, 11140, 121, 17.20963567, -22.13032568, 2358044.0)\n",
      "('Covid19', 'Nauru', 2020, 0, 0, 166.9325682, -0.51912639, 10474.0)\n",
      "('Covid19', 'Nepal', 2020, 76258, 491, 83.91582640000001, 28.24891365, 27263430.0)\n",
      "('Covid19', 'Netherlands', 2020, 117420, 6384, 5.28144793, 52.1007899, 16981285.0)\n",
      "('Covid19', 'New Caledonia', 2020, 27, 0, 165.68492369999996, -21.29991806, 274190.0)\n",
      "('Covid19', 'New Zealand', 2020, 1480, 25, 171.4849235, -41.81113557, 4659265.0)\n",
      "('Covid19', 'Nicaragua', 2020, 4146, 151, -85.0305297, 12.84709429, 6303970.0)\n",
      "('Covid19', 'Niger', 2020, 1196, 69, 9.38545882, 17.41912493, 20788789.0)\n",
      "('Covid19', 'Nigeria', 2020, 58647, 1111, 8.08943895, 9.59411452, 185960244.0)\n",
      "('Covid19', 'Niue', 2020, 0, 0, -169.8699468, -19.04945708, 1611.0)\n",
      "('Covid19', 'North Macedonia', 2020, 17786, 737, None, None, 2080746.0)\n",
      "('Covid19', 'Northern Mariana Islands', 2020, 70, 2, 145.6196965, 15.82927563, 56187.0)\n",
      "('Covid19', 'Norway', 2020, 13788, 274, 15.34834656, 68.75015572, 5250950.0)\n",
      "('Covid19', 'Oman', 2020, 98585, 935, 56.09166155, 20.60515333, 4479217.000000001)\n",
      "('Covid19', 'Pakistan', 2020, 312263, 6479, 69.33957937, 29.9497515, 203631356.00000003)\n",
      "('Covid19', 'Palau', 2020, 0, 0, 134.40807969999997, 7.28742784, 17718.0)\n",
      "('Covid19', 'Panama', 2020, 111277, 2348, -80.11915156, 8.51750797, 4037073.0)\n",
      "('Covid19', 'Papua New Guinea', 2020, 534, 7, 145.2074475, -6.46416646, 8271766.0)\n",
      "('Covid19', 'Paraguay', 2020, 39432, 818, -58.40013703, -23.22823913, 6777878.000000001)\n",
      "('Covid19', 'Peru', 2020, 808714, 32324, -74.38242685, -9.15280381, 30926036.0)\n",
      "('Covid19', 'Philippines', 2020, 309303, 5448, 122.8839325, 11.77536778, 103663812.0)\n",
      "('Covid19', 'Poland', 2020, 89962, 2483, 19.39012835, 52.12759564, 37989218.0)\n",
      "('Covid19', 'Portugal', 2020, 74717, 1963, -8.50104361, 39.59550671, 10325540.0)\n",
      "('Covid19', 'Puerto Rico', 2020, 48467, 654, -66.47307604, 18.22813055, 3283120.9999999995)\n",
      "('Covid19', 'Qatar', 2020, 125533, 214, 51.18479632, 25.30601188, 2654379.0000000005)\n",
      "('Covid19', 'Republic of Korea', 2020, 23812, 413, 127.8391609, 36.38523983, 50983446.0)\n",
      "('Covid19', 'Republic of Moldova', 2020, 52029, 1310, None, None, 4066013.0)\n",
      "('Covid19', 'Romania', 2020, 125414, 4792, 24.97293039, 45.85243127, 19796280.0)\n",
      "('Covid19', 'Russian Federation', 2020, 1176286, 20722, None, None, 145275374.0)\n",
      "('Covid19', 'Rwanda', 2020, 4836, 29, 29.91988515, -1.99033832, 11668829.0)\n",
      "('Covid19', 'Saint Helena', 2020, 0, 0, -9.54779416, -12.40355951, 5957.999999999999)\n",
      "('Covid19', 'Saint Kitts and Nevis', 2020, 19, 0, -62.68755265, 17.2645995, 51629.0)\n",
      "('Covid19', 'Saint Lucia', 2020, 27, 0, -60.96969923, 13.89479481, 180028.0)\n",
      "('Covid19', 'Saint Martin (French part)', 2020, 383, 8, -63.05972851, 18.08888611, 36061.0)\n",
      "('Covid19', 'Saint Martin (French part)', 2020, 383, 8, -63.05713363, 18.05081728, 36061.0)\n",
      "('Covid19', 'Saint Pierre and Miquelon', 2020, 16, 0, -56.30319779, 46.91918789, 5933.0)\n",
      "('Covid19', 'Saint Vincent and the Grenadines', 2020, 64, 0, -61.20129695, 13.22472269, 109467.0)\n",
      "('Covid19', 'Samoa', 2020, 0, 0, -170.71802580000005, -14.30445997, 194540.0)\n",
      "('Covid19', 'Samoa', 2020, 0, 0, -172.1648506, -13.75324346, 194540.0)\n",
      "('Covid19', 'San Marino', 2020, 749, 42, 12.45922334, 43.94186747, 33503.0)\n",
      "('Covid19', 'Sao Tome and Principe', 2020, 911, 15, 6.72429658, 0.44391445, 203221.0)\n",
      "('Covid19', 'Saudi Arabia', 2020, 334187, 4739, 44.53686271, 24.12245841, 32443443.0)\n",
      "('Covid19', 'Senegal', 2020, 14919, 309, -14.4734924, 14.36624173, 14993514.0)\n",
      "('Covid19', 'Serbia', 2020, 33479, 749, 20.78958334, 44.2215032, 8853963.0)\n",
      "('Covid19', 'Seychelles', 2020, 141, 0, 55.47603279, -4.66099094, 95711.0)\n",
      "('Covid19', 'Sierra Leone', 2020, 2222, 72, -11.79271247, 8.56329593, 7328846.0)\n",
      "('Covid19', 'Singapore', 2020, 57742, 27, 103.8172559, 1.35876087, 5653625.0)\n",
      "('Covid19', 'Sint Maarten (Dutch part)', 2020, 645, 22, None, None, 40812.0)\n",
      "('Covid19', 'Slovakia', 2020, 9574, 45, 19.47905218, 48.70547528, 5442001.0)\n",
      "('Covid19', 'Slovenia', 2020, 5487, 138, 14.80444238, 46.11554772, 2074205.0)\n",
      "('Covid19', 'Solomon Islands', 2020, 0, 0, 159.6328767, -8.92178022, 619438.0)\n",
      "('Covid19', 'Somalia', 2020, 3588, 99, 45.70714487, 4.75062876, 14185635.0)\n",
      "('Covid19', 'South Africa', 2020, 672572, 16667, 25.08390093, -29.00034095, 56207649.00000001)\n",
      "('Covid19', 'South Sudan', 2020, 2704, 49, 30.24790002, 7.30877945, 10832520.0)\n",
      "('Covid19', 'Spain', 2020, 716481, 31232, -3.64755047, 40.24448698, 46634130.99999999)\n",
      "('Covid19', 'Sri Lanka', 2020, 3374, 13, 80.70108238, 7.61266509, 21021177.000000004)\n",
      "('Covid19', 'State of Palestine', 2020, 50115, 360, None, None, 4635644.0)\n",
      "('Covid19', 'Sudan', 2020, 13640, 836, 29.94046812, 15.99035669, 39847433.0)\n",
      "('Covid19', 'Suriname', 2020, 4836, 102, -55.9123457, 4.13055413, 564883.0)\n",
      "('Covid19', 'Sweden', 2020, 92466, 5890, 16.74558049, 62.77966519, 9836003.0)\n",
      "('Covid19', 'Switzerland', 2020, 52751, 1781, 8.20867471, 46.79785878, 8379915.000000001)\n",
      "('Covid19', 'Syrian Arab Republic', 2020, 4148, 197, None, None, 17465567.0)\n",
      "('Covid19', 'Tajikistan', 2020, 9726, 75, 71.01362631, 38.5304539, 8663575.0)\n",
      "('Covid19', 'Thailand', 2020, 3564, 59, 101.0028813, 15.11815794, 68971313.0)\n",
      "('Covid19', 'Timor-Leste', 2020, 28, 0, 125.8443898, -8.82889162, 1219289.0)\n",
      "('Covid19', 'Togo', 2020, 1759, 48, 0.96232845, 8.52531356, 7509951.999999999)\n",
      "('Covid19', 'Tokelau', 2020, 0, 0, None, None, 1276.0)\n",
      "('Covid19', 'Tonga', 2020, 0, 0, -174.8098734, -20.42843174, 101143.0)\n",
      "('Covid19', 'Trinidad and Tobago', 2020, 4441, 74, -61.26567923, 10.45733408, 1377562.9999999998)\n",
      "('Covid19', 'Tunisia', 2020, 17405, 246, 9.55288359, 34.11956246, 11303942.0)\n",
      "('Covid19', 'Turkey', 2020, 317272, 8130, 35.16895346, 39.0616029, 79827868.0)\n",
      "('Covid19', 'Turkmenistan', 2020, 0, 0, 59.37100021, 39.11554137, 5662371.0)\n",
      "('Covid19', 'Turks and Caicos Islands', 2020, 682, 5, -71.97387881, 21.83047572, 36558.0)\n",
      "('Covid19', 'Tuvalu', 2020, 0, 0, None, None, 11232.000000000002)\n",
      "('Covid19', 'Uganda', 2020, 8017, 75, 32.36907971, 1.27469299, 39649172.99999999)\n",
      "('Covid19', 'Ukraine', 2020, 208959, 4129, 31.38326469, 48.99656673, 44713708.0)\n",
      "('Covid19', 'United Arab Emirates', 2020, 93090, 416, 54.3001671, 23.90528188, 9360975.0)\n",
      "('Covid19', 'United Kingdom', 2020, 446160, 42072, -2.86563164, 54.12387156, 66297944.0)\n",
      "('Covid19', 'United Republic of Tanzania', 2020, 509, 21, None, None, 53049231.0)\n",
      "('Covid19', 'United States Virgin Islands', 2020, 1318, 20, -64.80301538, 17.95500624, 104829.0)\n",
      "('Covid19', 'United States of America', 2020, 7077015, 203875, -112.4616737, 45.6795472, 323015991.99999994)\n",
      "('Covid19', 'Uruguay', 2020, 2010, 47, -56.01807053, -32.79951534, 3424139.0)\n",
      "('Covid19', 'Uzbekistan', 2020, 56519, 468, 63.14001528, 41.75554225, 31441753.0)\n",
      "('Covid19', 'Vanuatu', 2020, 0, 0, 167.68644640000005, -16.22640909, 278325.99999999994)\n",
      "('Covid19', 'Venezuela (Bolivarian Republic of)', 2020, 73528, 614, None, None, 29851249.0)\n",
      "('Covid19', 'Viet Nam', 2020, 1094, 35, None, None, 93640435.0)\n",
      "('Covid19', 'Wallis and Futuna Islands', 2020, 0, 0, -177.3483483, -13.88737039, 12097.999999999998)\n",
      "('Covid19', 'Yemen', 2020, 2035, 588, 47.58676189, 15.90928005, 27168210.0)\n",
      "('Covid19', 'Zambia', 2020, 14715, 332, 27.77475946, -13.45824152, 16363448.999999998)\n",
      "('Covid19', 'Zimbabwe', 2020, 7837, 228, 29.8514412, -19.00420419, 14030338.0)\n",
      "('Ebola', 'Guinea', 2014, 2397, 1433, -10.94066612, 10.43621593, 11150970000000.0)\n",
      "('Ebola', 'Guinea', 2015, 3351, 2083, -10.94066612, 10.43621593, 11432096.000000002)\n",
      "('Ebola', 'Guinea', 2016, 3351, 2083, -10.94066612, 10.43621593, 11738.434)\n",
      "('Ebola', 'Italy', 2015, 1, 0, 12.07001339, 42.79662641, 60578489.0)\n",
      "('Ebola', 'Italy', 2016, 1, 0, 12.07001339, 42.79662641, 60663.068)\n",
      "('Ebola', 'Liberia', 2014, 3110, 1241, -9.32207573, 6.45278492, 4359508000000.0)\n",
      "('Ebola', 'Liberia', 2015, 3153, 3858, -9.32207573, 6.45278492, 4472229.0)\n",
      "('Ebola', 'Liberia', 2016, 3151, 3, -9.32207573, 6.45278492, 4586.788)\n",
      "('Ebola', 'Mali', 2014, 7, 5, -3.54269065, 17.34581581, 16934213000000.0)\n",
      "('Ebola', 'Mali', 2015, 7, 0, -3.54269065, 17.34581581, 17438772.0)\n",
      "('Ebola', 'Mali', 2016, 7, 0, -3.54269065, 17.34581581, 17965.448)\n",
      "('Ebola', 'Nigeria', 2014, 19, 7, 8.08943895, 9.59411452, 176404931000000.0)\n",
      "('Ebola', 'Nigeria', 2015, 19, 7, 8.08943895, 9.59411452, 181137454.0)\n",
      "('Ebola', 'Nigeria', 2016, 19, 7, 8.08943895, 9.59411452, 185960.244)\n",
      "('Ebola', 'Senegal', 2014, 1, 0, -14.4734924, 14.36624173, 14174740000000.0)\n",
      "('Ebola', 'Senegal', 2015, 1, 0, -14.4734924, 14.36624173, 14578450.0)\n",
      "('Ebola', 'Senegal', 2016, 1, 0, -14.4734924, 14.36624173, 14993.514)\n",
      "('Ebola', 'Sierra Leone', 2014, 7354, 2392, -11.79271247, 8.56329593, 7017153000000.0)\n",
      "('Ebola', 'Sierra Leone', 2015, 8704, 3589, -11.79271247, 8.56329593, 7171909.000000001)\n",
      "('Ebola', 'Sierra Leone', 2016, 8704, 3589, -11.79271247, 8.56329593, 7328.846)\n",
      "('Ebola', 'Spain', 2014, 1, 0, -3.64755047, 40.24448698, 46777927000000.0)\n",
      "('Ebola', 'Spain', 2015, 1, 0, -3.64755047, 40.24448698, 46671919.0)\n",
      "('Ebola', 'Spain', 2016, 1, 0, -3.64755047, 40.24448698, 46634.131)\n",
      "('Ebola', 'United Kingdom', 2015, 1, 0, -2.86563164, 54.12387156, 65860149.00000001)\n",
      "('Ebola', 'United Kingdom', 2016, 1, 0, -2.86563164, 54.12387156, 66297.944)\n",
      "('Ebola', 'United States of America', 2014, 4, 1, -112.4616737, 45.6795472, 318673422000000.0)\n",
      "('Ebola', 'United States of America', 2015, 4, 1, -112.4616737, 45.6795472, 320878312.0)\n",
      "('Ebola', 'United States of America', 2016, 4, 1, -112.4616737, 45.6795472, 323015.992)\n",
      "('Swineflu-W', 'United States of America', 2009, 113690, 3433, -112.4616737, 45.6795472, 306307565.0)\n",
      "('Swineflu-W', 'Brazil', 2009, 58178, 2135, -53.09783113, -10.78777702, 193886505.0)\n",
      "('Swineflu-W', 'India', 2009, 33783, 2024, 79.61197609999998, 22.88578212, 1217726217.0)\n",
      "('Swineflu-W', 'Mexico', 2009, 70715, 1316, -102.52345169, 23.94753724, 112463886.0)\n",
      "('Swineflu-W', 'China', 2009, 120940, 800, 103.81907349, 36.56176546, 1361169410.0)\n",
      "('Swineflu-W', 'Turkey', 2009, 12316, 656, 35.16895346, 39.0616029, 71321406.0)\n",
      "('Swineflu-W', 'Argentina', 2009, 11458, 626, -65.17980692, -35.3813488, 40482786.0)\n",
      "('Swineflu-W', 'Russian Federation', 2009, 25339, 604, 96.68656112, 61.98052209, 143326904.0)\n",
      "('Swineflu-W', 'United Kingdom', 2009, 28456, 0, -2.86563164, 54.12387156, 62828620.0)\n",
      "('Swineflu-W', 'Canada', 2009, 25828, 429, -98.30777028, 61.36206324, 33746093.0)\n",
      "('Swineflu-W', 'France', 2009, 1980000, 344, -2.76172945, 42.17344011, 62542883.0)\n",
      "('Swineflu-W', 'Spain', 2009, 1538, 300, -3.64755047, 40.24448698, 46583566.0)\n",
      "('Swineflu-W', 'Egypt', 2009, 15812, 278, 29.86190099, 26.49593311, 81134789.0)\n",
      "('Swineflu-W', 'Germany', 2009, 222360, 258, 10.38578051, 51.10698181, 80899961.0)\n",
      "('Swineflu-W', 'Republic of Korea', 2009, 107939, 250, 127.83916086, 36.38523983, 49347450.0)\n",
      "('Swineflu-W', 'Thailand', 2009, 31902, 249, 101.0028813, 15.11815794, 66866834.0)\n",
      "('Swineflu-W', 'Italy', 2009, 3064933, 244, 12.07001339, 42.79662641, 59105622.0)\n",
      "('Swineflu-W', 'Colombia', 2009, 4310, 272, -73.08114582, 3.91383431, 44750054.0)\n",
      "('Swineflu-W', 'Peru', 2009, 9165, 223, -74.38242685, -9.15280381, 28792663.0)\n",
      "('Swineflu-W', 'Ukraine', 2009, 494, 213, 31.38326469, 48.99656673, 45970942.0)\n",
      "('Swineflu-W', 'Ecuador', 2009, 2251, 200, -78.75201922, -1.42381612, 14774412.0)\n",
      "('Swineflu-W', 'Japan', 2009, 11636, 198, 138.03089558, 37.59230135, 128555196.0)\n",
      "('Swineflu-W', 'Australia', 2009, 37484, 187, 134.49100008, -25.73288704, 21750852.000000004)\n",
      "('Swineflu-W', 'Poland', 2009, 2024, 181, 19.39012835, 52.12759564, 38351924.0)\n",
      "('Swineflu-W', 'Chile', 2009, 12258, 156, -71.38256213, -37.73070989, 16886183.999999996)\n",
      "('Swineflu-W', 'Syrian Arab Republic', 2009, 452, 152, 38.50788204, 35.02547389, 21205873.0)\n",
      "('Swineflu-W', 'Greece', 2009, 17977, 149, 22.95555794, 39.07469623, 10959268.0)\n",
      "('Swineflu-W', 'Iran (Islamic Republic of)', 2009, 3672, 147, 54.27407004, 32.57503292, 72924833.0)\n",
      "('Swineflu-W', 'Venezuela (Bolivarian Republic of)', 2009, 2187, 135, -66.18184123, 7.12422421, 28031010.0)\n",
      "('Swineflu-W', 'Hungary', 2009, 283, 134, 19.39559116, 47.16277506, 9959439.0)\n",
      "('Swineflu-W', 'Saudi Arabia', 2009, 14500, 128, 44.53686271, 24.12245841, 26630303.0)\n",
      "('Swineflu-W', 'Portugal', 2009, 166922, 122, -8.50104361, 39.59550671, 10604066.0)\n",
      "('Swineflu-W', 'Romania', 2009, 7006, 122, 24.97293039, 45.85243127, 20637995.0)\n",
      "('Swineflu-W', 'Czechia', 2009, 2445, 102, 15.31240163, 49.73341233, 10488155.0)\n",
      "('Swineflu-W', 'Israel', 2009, 4330, 94, 35.00444693, 31.46110101, 7190036.999999999)\n",
      "('Swineflu-W', 'South Africa', 2009, 12640, 93, 25.08390093, -29.00034095, 50477013.0)\n",
      "('Swineflu-W', 'Malaysia', 2009, 12210, 92, 109.69762284, 3.78986846, 27735038.0)\n",
      "('Swineflu-W', 'Belarus', 2009, 102, 88, 28.03209307, 53.53131377, 9433159.0)\n",
      "('Swineflu-W', 'Serbia', 2009, 695, 83, 20.78958334, 44.2215032, 9023354.0)\n",
      "('Swineflu-W', 'Cuba', 2009, 973, 69, -79.01605384, 21.62289528, 11226711.000000002)\n",
      "('Swineflu-W', 'Costa Rica', 2009, 1867, 67, -84.19208768, 9.97634464, 4520739.000000001)\n",
      "('Swineflu-W', 'Morocco', 2009, 2890, 64, -8.45615795, 29.83762955, 31929087.000000004)\n",
      "('Swineflu-W', 'Netherlands', 2009, 1473, 62, 5.28144793, 52.1007899, 16626379.0)\n",
      "('Swineflu-W', 'Bolivia (Plurinational State of)', 2009, 2310, 59, -64.68538645, -16.70814787, 9884790.0)\n",
      "('Swineflu-W', 'Viet Nam', 2009, 11186, 58, 106.29914698, 16.646016699999997, 87092250.0)\n",
      "('Swineflu-W', 'Algeria', 2009, 916, 57, 2.61732301, 28.15893849, 35333882.00000001)\n",
      "('Swineflu-W', 'Finland', 2009, 6122, 56, 26.2746656, 64.49884603, 5342266.0)\n",
      "('Swineflu-W', 'Slovakia', 2009, 955, 56, 19.47905218, 48.70547528, 5401149.0)\n",
      "('Swineflu-W', 'Paraguay', 2009, 855, 54, -58.40013703, -23.22823913, 6163970.0)\n",
      "('Swineflu-W', 'New Zealand', 2009, 3199, 50, 171.48492347, -41.81113557, 4323338.0)\n",
      "('Swineflu-W', 'China, Taiwan Province of China', 2009, 5474, 48, 120.95427281, 23.7539928, 23104542.0)\n",
      "('Swineflu-W', 'Sri Lanka', 2009, 642, 48, 80.70108238, 7.61266509, 20123508.0)\n",
      "('Swineflu-W', 'Iraq', 2009, 2880, 42, 43.74353149, 33.03970582, 28973157.000000004)\n",
      "('Swineflu-W', 'Austria', 2009, 964, 40, 14.1264761, 47.58549439, 8372658.000000001)\n",
      "('Swineflu-W', 'Bulgaria', 2009, 766, 40, 25.21552909, 42.76890318, 7473509.0)\n",
      "('Swineflu-W', 'Latvia', 2009, 1253, 34, 24.91235983, 56.85085163, 2144784.0)\n",
      "('Swineflu-W', 'Oman', 2009, 6349, 33, 56.09166155, 20.60515333, 2876185.9999999995)\n",
      "('Swineflu-W', 'Georgia', 2009, 1300, 33, 43.50780252, 42.16855755, 4119490.0)\n",
      "('Swineflu-W', 'El Salvador', 2009, 834, 33, -88.87164469, 13.73943744, 6157678.000000001)\n",
      "('Swineflu-W', 'Denmark', 2009, 651, 33, 10.02800992, 55.98125296, 5526389.0)\n",
      "('Swineflu-W', 'Uruguay', 2009, 550, 33, -56.01807053, -32.79951534, 3349676.0)\n",
      "('Swineflu-W', 'Philippines', 2009, 5212, 32, 122.88393253, 11.77536778, 92414161.0)\n",
      "('Swineflu-W', 'Yemen', 2009, 5038, 31, 47.58676189, 15.90928005, 22516464.0)\n",
      "('Swineflu-W', 'Kuwait', 2009, 8669, 30, 47.58700459, 29.33431262, 2821040.9999999995)\n",
      "('Swineflu-W', 'Mongolia', 2009, 1259, 30, 103.05299765, 46.82681544, 2673794.0000000005)\n",
      "('Swineflu-W', 'Norway', 2009, 12654, 29, 15.34834656, 68.75015572, 4826847.0)\n",
      "('Swineflu-W', 'Sweden', 2009, 10985, 29, 16.74558049, 62.77966519, 9313085.0)\n",
      "('Swineflu-W', 'Ireland', 2009, 3189, 26, -8.13793569, 53.17544870000001, 4494572.0)\n",
      "('Swineflu-W', 'Croatia', 2009, 50255, 26, 16.40412899, 45.08047631, 4341260.999999999)\n",
      "('Swineflu-W', 'Pakistan', 2009, 253, 25, 69.33957937, 29.9497515, 175525610.0)\n",
      "('Swineflu-W', 'Tunisia', 2009, 1200, 24, 9.55288359, 34.11956246, 10525691.0)\n",
      "('Swineflu-W', 'Dominican Republic', 2009, 491, 23, -70.50568896, 18.89433082, 9576735.999999998)\n",
      "('Swineflu-W', 'Lithuania', 2009, 68, 23, 23.88719355, 55.32610984, 3167270.0)\n",
      "('Swineflu-W', 'Singapore', 2009, 1217, 21, 103.81725592, 1.35876087, 4966614.000000001)\n",
      "('Swineflu-W', 'Estonia', 2009, 738, 21, 25.54248537, 58.67192972, 1336140.0)\n",
      "('Swineflu-W', 'Belgium', 2009, '76973\\xa0', 19, 4.64065114, 50.63981576, 10859934.0)\n",
      "('Swineflu-W', 'Jordan', 2009, 3033, 19, 36.77136104, 31.24579091, 6893258.000000001)\n",
      "('Swineflu-W', 'Slovenia', 2009, 990, 19, 14.80444238, 46.11554772, 2033807.0)\n",
      "('Swineflu-W', 'Switzerland', 2009, 11221, 18, 8.20867471, 46.79785878, 7713901.999999999)\n",
      "('Swineflu-W', 'Honduras', 2009, 560, 18, -86.6151661, 14.82688165, 8150780.0)\n",
      "('Swineflu-W', 'Afghanistan', 2009, 853, 17, 66.00473366, 33.83523073, 28394806.0)\n",
      "('Swineflu-W', 'Bosnia and Herzegovina', 2009, 714, 13, 17.76876733, 44.17450125, 3735945.0)\n",
      "('Swineflu-W', 'Panama', 2009, 813, 12, -80.11915156, 8.51750797, 3579215.0)\n",
      "('Swineflu-W', 'Albania', 2009, 426, 12, 20.04983396, 41.14244989, 2973044.0000000005)\n",
      "('Swineflu-W', 'Nicaragua', 2009, 2172, 11, -85.0305297, 12.84709429, 5745538.0)\n",
      "('Swineflu-W', 'Indonesia', 2009, 1098, 10, 117.24011366, -2.21505456, 238620554.0)\n",
      "('Swineflu-W', 'Qatar', 2009, 550, 10, 51.18479632, 25.30601188, 1654944.0)\n",
      "('Swineflu-W', 'Cyprus', 2009, 297, 10, 33.0060022, 34.91667211, 1098089.0)\n",
      "('Swineflu-W', \"Dem. People's Republic of Korea\", 2009, 28, 10, 127.19247973, 40.15350311, 24428340.0)\n",
      "('Swineflu-W', 'Bahrain', 2009, 1325, 8, 50.54196932, 26.04205135, 1185075.0)\n",
      "('Swineflu-W', 'Mauritius', 2009, 69, 8, 57.57120551, -20.27768704, 1243996.0)\n",
      "('Swineflu-W', 'Bangladesh', 2009, 1015, 7, 90.23812743, 23.86731158, 145924795.0)\n",
      "('Swineflu-W', 'Jamaica', 2009, 191, 7, -77.31482593, 18.15694878, 2795839.0000000005)\n",
      "('Swineflu-W', 'Montenegro', 2009, 119, 7, 19.23883939, 42.78890259, 622933.0)\n",
      "('Swineflu-W', 'Cambodia', 2009, 531, 6, 104.90694325, 12.72004786, 14093605.0)\n",
      "('Swineflu-W', 'United Arab Emirates', 2009, 125, 6, 54.3001671, 23.90528188, 7917368.0)\n",
      "('Swineflu-W', 'Lebanon', 2009, 1838, 5, 35.88016072, 33.92306631, 4813026.0)\n",
      "('Swineflu-W', 'Malta', 2009, 718, 5, 14.40523316, 35.92149632, 411559.0)\n",
      "('Swineflu-W', 'Trinidad and Tobago', 2009, 211, 5, -61.26567923, 10.45733408, 1320921.0)\n",
      "('Swineflu-W', 'Sudan', 2009, 145, 5, 29.94046812, 15.99035669, 33783779.0)\n",
      "('Swineflu-W', 'Bahamas', 2009, 29, 4, -76.62843038, 24.29036702, 349600.0)\n",
      "('Swineflu-W', 'Madagascar', 2009, 877, 3, 46.70473674, -19.37189587, 20569115.0)\n",
      "('Swineflu-W', 'Ghana', 2009, 676, 3, -1.21676566, 7.95345644, 24170943.0)\n",
      "('Swineflu-W', 'Luxembourg', 2009, 333, 3, 6.07182201, 49.76725361, 496536.0)\n",
      "('Swineflu-W', 'Nepal', 2009, 172, 3, 83.91582640000001, 28.24891365, 26883531.000000004)\n",
      "('Swineflu-W', 'Barbados', 2009, 154, 3, -59.559797, 13.18145428, 281107.0)\n",
      "('Swineflu-W', 'Armenia', 2009, 119, 3, 44.92993276, 40.28952569, 2888094.0)\n",
      "('Swineflu-W', 'Iceland', 2009, '676\\xa0', 2, -18.57396167, 64.99575386, 316057.0)\n",
      "('Swineflu-W', 'Brunei Darussalam', 2009, 971, 2, 114.72203035, 4.51968958, 383902.0)\n",
      "('Swineflu-W', 'Samoa', 2009, 138, 2, -172.16485064, -13.75324346, 184553.0)\n",
      "('Swineflu-W', 'Suriname', 2009, 110, 2, -55.9123457, 4.13055413, 523113.00000000006)\n",
      "('Swineflu-W', 'Mozambique', 2009, 57, 2, 35.53367543, -17.27381643, 22894718.0)\n",
      "('Swineflu-W', 'Nigeria', 2009, 11, 2, 8.08943895, 9.59411452, 154324939.0)\n",
      "('Swineflu-W', 'United Republic of Tanzania', 2009, 770, 1, 34.81309981, -6.27565408, 43073830.0)\n",
      "('Swineflu-W', 'Libya', 2009, 764, 1, 18.00866169, 27.03094495, 6133986.999999999)\n",
      "('Swineflu-W', \"Lao People's Democratic Republic\", 2009, 242, 1, 103.73772412, 18.50217433, 6148621.0)\n",
      "('Swineflu-W', 'Cayman Islands', 2009, 121, 1, -80.91213321, 19.42896497, 55321.00000000001)\n",
      "('Swineflu-W', 'Marshall Islands', 2009, 115, 1, 170.33976122, 7.00376358, 56255.0)\n",
      "('Swineflu-W', 'Cook Islands', 2009, 106, 1, -159.78724218, -21.21927288, 18602.0)\n",
      "('Swineflu-W', 'Namibia', 2009, 75, 1, 17.20963567, -22.13032568, 2081039.0)\n",
      "('Swineflu-W', 'Maldives', 2009, 35, 1, 73.45713004, 3.7287092, 353390.99999999994)\n",
      "('Swineflu-W', 'Bermuda', 2009, 25, 1, -64.7545589, 32.31367802, 65675.0)\n",
      "('Swineflu-W', 'Tonga', 2009, 20, 1, -174.80987341, -20.42843174, 103897.0)\n",
      "('Swineflu-W', 'Falkland Islands (Malvinas)', 2009, 7, 1, -59.35238956, -51.74483954, 2921.0000000000005)\n",
      "('Swineflu-W', 'Solomon Islands', 2009, 4, 1, 159.63287668, -8.92178022, 515182.0)\n",
      "('Swineflu-W', 'Zimbabwe', 2009, 1318, 0, 29.8514412, -19.00420419, 12526964.0)\n",
      "('Swineflu-W', 'Zambia', 2009, 726, 0, 27.77475946, -13.45824152, 13215142.0)\n",
      "('Swineflu-W', 'Rwanda', 2009, 482, 0, 29.91988515, -1.99033832, 9782770.0)\n",
      "('Swineflu-W', 'Kenya', 2009, 417, 0, 37.79593973, 0.59988022, 40901797.99999999)\n",
      "('Swineflu-W', 'Senegal', 2009, 325, 0, -14.4734924, 14.36624173, 12335091.999999998)\n",
      "('Swineflu-W', 'Uganda', 2009, 263, 0, 32.36907971, 1.27469299, 31411096.0)\n",
      "('Swineflu-W', 'Fiji', 2009, 234, 0, 165.45195432, -17.42858032, 853636.0000000001)\n",
      "('Swineflu-W', 'Democratic Republic of the Congo', 2009, 222, 0, 23.64396107, -2.87746289, 62448572.0)\n",
      "('Swineflu-W', 'Myanmar', 2009, 137, 0, 96.48843321, 21.18566599, 50250365.99999999)\n",
      "('Swineflu-W', 'Cabo Verde', 2009, 118, 0, -23.9598882, 15.95523324, 486667.0)\n",
      "('Swineflu-W', 'Bhutan', 2009, 91, 0, 90.40188155, 27.41106589, 678329.0)\n",
      "('Swineflu-W', 'Haiti', 2009, 91, 0, -72.68527509, 18.93502563, 9798046.0)\n",
      "('Swineflu-W', 'Micronesia (Fed. States of)', 2009, 82, 0, 153.23943792, 7.45246814, 102971.0)\n",
      "('Swineflu-W', 'Antigua and Barbuda', 2009, 75, 0, -61.79469343, 17.277499600000002, 86743.0)\n",
      "('Swineflu-W', 'Isle of Man', 2009, 75, 0, -4.53873952, 54.22418911, 84378.99999999999)\n",
      "('Swineflu-W', 'Lesotho', 2009, 65, 0, 28.22723131, -29.58003188, 1990135.0)\n",
      "('Swineflu-W', 'Kyrgyzstan', 2009, 61, 0, 74.54165513, 41.46221943, 5334708.000000001)\n",
      "('Swineflu-W', 'Belize', 2009, 49, 0, -88.71010486, 17.20027509, 314655.0)\n",
      "('Swineflu-W', 'Niger', 2009, 49, 0, 9.38545882, 17.41912493, 15843131.000000002)\n",
      "('Swineflu-W', 'Palau', 2009, 47, 0, 134.40807966, 7.28742784, 18290.0)\n",
      "('Swineflu-W', 'Faroe Islands', 2009, 44, 0, -6.88095423, 62.05385403, 47813.99999999999)\n",
      "('Swineflu-W', 'Turks and Caicos Islands', 2009, 44, 0, -71.97387881, 21.83047572, 31933.000000000004)\n",
      "('Swineflu-W', 'Angola', 2009, 37, 0, 17.53736768, -12.29336054, 22514275.0)\n",
      "('Swineflu-W', 'Dominica', 2009, 36, 0, -61.357726, 15.4394702, 70848.0)\n",
      "('Swineflu-W', 'Monaco', 2009, 36, 0, 7.40627677, 43.75274627, 35223.0)\n",
      "('Swineflu-W', 'Seychelles', 2009, 33, 0, 55.47603279, -4.66099094, 90788.0)\n",
      "('Swineflu-W', 'Botswana', 2009, 31, 0, 23.79853368, -22.18403213, 1953495.0)\n",
      "('Swineflu-W', 'Mali', 2009, 29, 0, -3.54269065, 17.34581581, 14581427.0)\n",
      "('Swineflu-W', 'Guyana', 2009, 27, 0, -58.98202459, 4.79378034, 747718.0000000001)\n",
      "('Swineflu-W', 'British Virgin Islands', 2009, 25, 0, -64.47146992, 18.52585755, 27035.0)\n",
      "('Swineflu-W', 'Montserrat', 2009, 21, 0, -62.18518546, 16.73941406, 4891.0)\n",
      "('Swineflu-W', 'Congo', 2009, 21, 0, 15.21965762, -0.83787463, 4145400.0)\n",
      "('Swineflu-W', 'Grenada', 2009, 20, 0, -61.68220189, 12.11725044, 105787.0)\n",
      "('Swineflu-W', 'Ethiopia', 2009, 19, 0, 39.60080098, 8.62278679, 85233923.00000001)\n",
      "('Swineflu-W', 'Kazakhstan', 2009, 17, 0, 67.29149357, 48.15688067, 16043015.0)\n",
      "('Swineflu-W', 'Tajikistan', 2009, 16, 0, 71.01362631, 38.5304539, 7364751.999999999)\n",
      "('Swineflu-W', 'Mauritania', 2009, 15, 0, -10.34779815, 20.25736706, 3393408.0)\n",
      "('Swineflu-W', 'Anguilla', 2009, 14, 0, -63.06498927, 18.2239595, 13248.0)\n",
      "('Swineflu-W', 'Azerbaijan', 2009, 14, 0, 47.54599879, 40.28827235, 8924383.0)\n",
      "('Swineflu-W', 'Papua New Guinea', 2009, 12, 0, 145.20744752, -6.46416646, 7144774.0)\n",
      "('Swineflu-W', 'Djibouti', 2009, 9, 0, 42.5606754, 11.74871806, 827820.0)\n",
      "('Swineflu-W', 'Nauru', 2009, 8, 0, 166.93256823, -0.51912639, 9945.0)\n",
      "('Swineflu-W', 'Burundi', 2009, 7, 0, 29.87512156, -3.35939666, 8397661.0)\n",
      "('Swineflu-W', 'Timor-Leste', 2009, 7, 0, 125.84438982, -8.82889162, 1074286.0)\n",
      "('Swineflu-W', 'Liechtenstein', 2009, 5, 0, 9.53574312, 47.13665835, 35723.0)\n",
      "('Swineflu-W', 'San Marino', 2009, 5, 0, 12.45922334, 43.94186747, 30825.0)\n",
      "('Swineflu-W', 'Cameroon', 2009, 4, 0, 12.73964156, 5.69109849, 19789922.0)\n",
      "('Swineflu-W', 'Gabon', 2009, 4, 0, 11.7886287, -0.58660025, 1568925.0)\n",
      "('Swineflu-W', 'Kiribati', 2009, 4, 0, -45.61110513, 0.86001503, 100928.0)\n",
      "('Swineflu-W', 'Guinea', 2009, 3, 0, -10.94066612, 10.43621593, 9964470.0)\n",
      "('Swineflu-W', 'Vanuatu', 2009, 3, 0, 167.68644636, -16.22640909, 230244.00000000003)\n",
      "('Swineflu-W', 'Somalia', 2009, 2, 0, 45.70714487, 4.75062876, 11717691.0)\n",
      "('Swineflu-W', 'Andorra', 2009, 1, 0, 1.56054378, 42.54229102, 84461.0)\n",
      "('Swineflu-W', 'Chad', 2009, 1, 0, 18.64492513, 15.33333758, 11560142.0)\n",
      "('Swineflu-W', 'Greenland', 2009, 1, 0, -41.34191127, 74.71051289, 56729.0)\n"
     ]
    }
   ],
   "source": [
    "for row in c.execute('SELECT * FROM PANDEMICS;'):\n",
    "    print(row)\n",
    "\n",
    "# Be sure to close the connection\n",
    "c.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}