Combine_Csvs.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>1051</td>\n",
       "      <td>25</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>1989</td>\n",
       "      <td>76</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>4112</td>\n",
       "      <td>280</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>Andorra</td>\n",
       "      <td>2020</td>\n",
       "      <td>2411</td>\n",
       "      <td>27</td>\n",
       "      <td>1.560544</td>\n",
       "      <td>42.542291</td>\n",
       "      <td>77295.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Angola</td>\n",
       "      <td>2020</td>\n",
       "      <td>41</td>\n",
       "      <td>4</td>\n",
       "      <td>17.537368</td>\n",
       "      <td>-12.293361</td>\n",
       "      <td>28842482.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   1051      25  66.004734  33.835231  35383028.0\n",
       "1  Covid19      Albania  2020   1989      76  20.049834  41.142450   2886427.0\n",
       "2  Covid19      Algeria  2020   4112     280   2.617323  28.158938  40551398.0\n",
       "3  Covid19      Andorra  2020   2411      27   1.560544  42.542291     77295.0\n",
       "4  Covid19       Angola  2020     41       4  17.537368 -12.293361  28842482.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": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "swineflu_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('Covid19', 'Afghanistan', 2020, '1051', 25, 66.00473366, 33.83523073, 35383028.0)\n",
      "('Covid19', 'Albania', 2020, '1989', 76, 20.04983396, 41.14244989, 2886427.0)\n",
      "('Covid19', 'Algeria', 2020, '4112', 280, 2.61732301, 28.15893849, 40551398.0)\n",
      "('Covid19', 'Andorra', 2020, '2411', 27, 1.56054378, 42.54229102, 77295.0)\n",
      "('Covid19', 'Angola', 2020, '41', 4, 17.53736768, -12.29336054, 28842482.000000004)\n",
      "('Covid19', 'Antigua and Barb.', 2020, '54', 0, -61.79469343, 17.277499600000002, 1000.0)\n",
      "('Covid19', 'Argentina', 2020, '5440', 131, -65.17980692, -35.3813488, 43508459.0)\n",
      "('Covid19', 'Armenia', 2020, '3567', 9, 44.92993276, 40.28952569, 2936147.0)\n",
      "('Covid19', 'Aruba', 2020, '19', 0, -69.98267711, 12.52088038, 104865.0)\n",
      "('Covid19', 'Australia', 2020, '31588', 174, 134.49100008, -25.73288704, 24262710.0)\n",
      "('Covid19', 'Austria', 2020, '74639', 498, 14.1264761, 47.58549439, 8747306.0)\n",
      "('Covid19', 'Azerbaijan', 2020, '1618', 32, 47.54599879, 40.28827235, 9736041.0)\n",
      "('Covid19', 'Bahamas', 2020, '85', 0, -76.62843038, 24.29036702, 377923.0)\n",
      "('Covid19', 'Bahrain', 2020, '7359', 37, 50.54196932, 26.04205135, 1425793.0)\n",
      "('Covid19', 'Bangladesh', 2020, '495', 44, 90.23812743, 23.86731158, 157977150.99999997)\n",
      "('Covid19', 'Barbados', 2020, '221', 0, -59.559797, 13.18145428, 285798.0)\n",
      "('Covid19', 'Belarus', 2020, '1315', 0, 28.03209307, 53.53131377, 9445638.0)\n",
      "('Covid19', 'Belgium', 2020, '76260', 2440, 4.64065114, 50.63981576, 11354407.0)\n",
      "('Covid19', 'Belize', 2020, '15', 0, -88.71010486, 17.20027509, 368399.0)\n",
      "('Covid19', 'Benin', 2020, '59', 0, 2.32785254, 9.6417597, 10872072.0)\n",
      "('Covid19', 'Bhutan', 2020, '42', 0, 90.40188155, 27.41106589, 736706.0)\n",
      "('Covid19', 'Bolivia', 2020, '575', 5, -64.68538645, -16.70814787, 1000.0)\n",
      "('Covid19', 'Bosnia and Herz.', 2020, '2402', 37, 17.76876733, 44.17450125, 1000.0)\n",
      "('Covid19', 'Botswana', 2020, '3', 0, 23.79853368, -22.18403213, 2159925.0)\n",
      "('Covid19', 'Brazil', 2020, '31415', 775, -53.09783113, -10.78777702, 206163056.0)\n",
      "('Covid19', 'Brunei', 2020, '1559', 3, 114.72203035, 4.51968958, 1000.0)\n",
      "('Covid19', 'Bulgaria', 2020, '3177', 63, 25.21552909, 42.76890318, 7151948.0)\n",
      "('Covid19', 'Burkina Faso', 2020, '1640', 72, -1.75456601, 12.26953846, 18646350.0)\n",
      "('Covid19', 'Cambodia', 2020, '1150', 0, 104.90694325, 12.72004786, 15766290.0)\n",
      "('Covid19', 'Cameroon', 2020, '874', 18, 12.73964156, 5.69109849, 23926549.0)\n",
      "('Covid19', 'Canada', 2020, '43731', 463, -98.30777028, 61.36206324, 36382942.0)\n",
      "('Covid19', 'Cape Verde', 2020, '44', 7, -23.9598882, 15.95523324, 1000.0)\n",
      "('Covid19', 'Cayman Is.', 2020, '3', 0, -80.91213321, 19.42896497, 1000.0)\n",
      "('Covid19', 'Central African Rep.', 2020, '38', 0, 20.46826831, 6.56823297, 1000.0)\n",
      "('Covid19', 'Chad', 2020, '28', 0, 18.64492513, 15.33333758, 14561658.000000002)\n",
      "('Covid19', 'Chile', 2020, '14925', 38, -71.38256213, -37.73070989, 18209072.0)\n",
      "('Covid19', 'China', 2020, '4125226', 142587, 103.81907349, 36.56176546, 1414049353.0)\n",
      "('Covid19', 'Colombia', 2020, '5226', 52, -73.08114582, 3.91383431, 48175047.99999999)\n",
      "('Covid19', 'Congo', 2020, '623', 33, 15.21965762, -0.83787463, 4980996.0)\n",
      "('Covid19', 'Costa Rica', 2020, '2640', 22, -84.19208768, 9.97634464, 4899335.999999999)\n",
      "('Covid19', 'Croatia', 2020, '5555', 30, 16.40412899, 45.08047631, 4208611.0)\n",
      "('Covid19', 'Cuba', 2020, '834', 22, -79.01605384, 21.62289528, 11335108.0)\n",
      "('Covid19', 'CuraÃ§ao', 2020, '2', 0, -68.97119369, 12.19551675, 1000.0)\n",
      "('Covid19', 'Cyprus', 2020, '1827', 33, 33.0060022, 34.91667211, 1170188.9999999998)\n",
      "('Covid19', 'Czech Rep.', 2020, '22676', 79, 15.31240163, 49.73341233, 1000.0)\n",
      "('Covid19', \"CÃ´te d'Ivoire\", 2020, '873', 2, -5.5692157, 7.6284262, 1000.0)\n",
      "('Covid19', 'Denmark', 2020, '29675', 452, 10.02800992, 55.98125296, 5711346.0)\n",
      "('Covid19', 'Djibouti', 2020, '95', 0, 42.5606754, 11.74871806, 929117.0)\n",
      "('Covid19', 'Dominica', 2020, '67', 0, -61.357726, 15.4394702, 71307.0)\n",
      "('Covid19', 'Dominican Rep.', 2020, '5031', 169, -70.50568896, 18.89433082, 1000.0)\n",
      "('Covid19', 'Ecuador', 2020, '14229', 348, -78.75201922, -1.42381612, 16491116.000000002)\n",
      "('Covid19', 'Egypt', 2020, '6446', 292, 29.86190099, 26.49593311, 94447071.0)\n",
      "('Covid19', 'El Salvador', 2020, '124', 0, -88.87164469, 13.73943744, 6356137.0)\n",
      "('Covid19', 'Eq. Guinea', 2020, '118', 0, 10.34137924, 1.70555135, 1000.0)\n",
      "('Covid19', 'Eritrea', 2020, '50', 0, 38.84617011, 15.36186618, 3376558.0)\n",
      "('Covid19', 'Estonia', 2020, '6608', 10, 25.54248537, 58.67192972, 1316507.0)\n",
      "('Covid19', 'Ethiopia', 2020, '177', 0, 39.60080098, 8.62278679, 103603461.0)\n",
      "('Covid19', 'Faeroe Is.', 2020, '10', 0, -6.88095423, 62.05385403, 1000.0)\n",
      "('Covid19', 'Fiji', 2020, '42', 0, 165.45195432, -17.42858032, 872406.0000000001)\n",
      "('Covid19', 'Finland', 2020, '12001', 52, 26.2746656, 64.49884603, 5497714.0)\n",
      "('Covid19', 'France', 2020, '357338', 17811, -2.76172945, 42.17344011, 64667590.0)\n",
      "('Covid19', 'Gabon', 2020, '70', 11, 11.7886287, -0.58660025, 2007882.0)\n",
      "('Covid19', 'Gambia', 2020, '31', 8, -15.39601295, 13.44965244, 2149134.0)\n",
      "('Covid19', 'Georgia', 2020, '1150', 0, 43.50780252, 42.16855755, 4015457.0000000005)\n",
      "('Covid19', 'Germany', 2020, '516949', 3101, 10.38578051, 51.10698181, 82193770.0)\n",
      "('Covid19', 'Ghana', 2020, '985', 33, -1.21676566, 7.95345644, 28481947.0)\n",
      "('Covid19', 'Greece', 2020, '12095', 290, 22.95555794, 39.07469623, 10615183.0)\n",
      "('Covid19', 'Greenland', 2020, '3', 0, -41.34191127, 74.71051289, 56408.0)\n",
      "('Covid19', 'Grenada', 2020, '43', 0, -61.68220189, 12.11725044, 110263.0)\n",
      "('Covid19', 'Guam', 2020, '6', 0, 144.76791022, 13.44165626, 162947.99999999994)\n",
      "('Covid19', 'Guatemala', 2020, '295', 15, -90.36482009, 15.69403664, 16583078.999999998)\n",
      "('Covid19', 'Guernsey', 2020, '3', 0, -2.57239064, 49.46809761, 1000.0)\n",
      "('Covid19', 'Guinea', 2020, '82', 0, -10.94066612, 10.43621593, 11738434.0)\n",
      "('Covid19', 'Guinea-Bissau', 2020, '18', 0, -14.94972445, 12.04744948, 1782434.0)\n",
      "('Covid19', 'Guyana', 2020, '245', 19, -58.98202459, 4.79378034, 771363.0)\n",
      "('Covid19', 'Haiti', 2020, '102', 0, -72.68527509, 18.93502563, 10839976.0)\n",
      "('Covid19', 'Honduras', 2020, '677', 13, -86.6151661, 14.82688165, 9270794.0)\n",
      "('Covid19', 'Hong Kong', 2020, '8912', 138, 114.11380454, 22.39827737, 1000.0)\n",
      "('Covid19', 'Hungary', 2020, '3020', 103, 19.39559116, 47.16277506, 9752970.0)\n",
      "('Covid19', 'Iceland', 2020, '10165', 25, -18.57396167, 64.99575386, 332209.0)\n",
      "('Covid19', 'India', 2020, '8941', 191, 79.61197609999998, 22.88578212, 1324517250.0)\n",
      "('Covid19', 'Indonesia', 2020, '10443', 853, 117.24011366, -2.21505456, 261556386.00000003)\n",
      "('Covid19', 'Iran', 2020, '482959', 31473, 54.27407004, 32.57503292, 1000.0)\n",
      "('Covid19', 'Iraq', 2020, '5675', 459, 43.74353149, 33.03970582, 36610632.00000001)\n",
      "('Covid19', 'Ireland', 2020, '20096', 225, -8.13793569, 53.17544870000001, 4695790.0)\n",
      "('Covid19', 'Israel', 2020, '29996', 79, 35.00444693, 31.46110101, 8108984.0)\n",
      "('Covid19', 'Italy', 2020, '1105297', 104101, 12.07001339, 42.79662641, 60663068.0)\n",
      "('Covid19', 'Jamaica', 2020, '346', 12, -77.31482593, 18.15694878, 2906242.0)\n",
      "('Covid19', 'Japan', 2020, '28472', 801, 138.03089558, 37.59230135, 127763267.0)\n",
      "('Covid19', 'Jersey', 2020, '6', 0, -2.12689938, 49.21837377, 1000.0)\n",
      "('Covid19', 'Jordan', 2020, '2147', 10, 36.77136104, 31.24579091, 9554286.0)\n",
      "('Covid19', 'Kazakhstan', 2020, '1592', 8, 67.29149357, 48.15688067, 17830902.0)\n",
      "('Covid19', 'Kenya', 2020, '311', 5, 37.79593973, 0.59988022, 49051530.99999999)\n",
      "('Covid19', 'Korea', 2020, '247232', 2520, 127.83916086, 36.38523983, 1000.0)\n",
      "('Covid19', 'Kosovo', 2020, '450', 5, 20.87249811, 42.57078707, 1000.0)\n",
      "('Covid19', 'Kuwait', 2020, '4036', 0, 47.58700459, 29.33431262, 3956862.0)\n",
      "('Covid19', 'Kyrgyzstan', 2020, '480', 0, 74.54165513, 41.46221943, 6074326.999999999)\n",
      "('Covid19', 'Lao PDR', 2020, '41', 0, 103.73772412, 18.50217433, 1000.0)\n",
      "('Covid19', 'Latvia', 2020, '2879', 0, 24.91235983, 56.85085163, 1974265.0)\n",
      "('Covid19', 'Lebanon', 2020, '4711', 98, 35.88016072, 33.92306631, 6714281.0)\n",
      "('Covid19', 'Liberia', 2020, '38', 0, -9.32207573, 6.45278492, 4586788.0)\n",
      "('Covid19', 'Libya', 2020, '23', 0, 18.00866169, 27.03094495, 6492160.0)\n",
      "('Covid19', 'Liechtenstein', 2020, '626', 0, 9.53574312, 47.13665835, 37655.0)\n",
      "('Covid19', 'Lithuania', 2020, '3074', 39, 23.88719355, 55.32610984, 2889555.0)\n",
      "('Covid19', 'Luxembourg', 2020, '15032', 139, 6.07182201, 49.76725361, 579266.0)\n",
      "('Covid19', 'Macao', 2020, '844', 0, 113.50932116, 22.22311688, 1000.0)\n",
      "('Covid19', 'Macedonia', 2020, '2144', 31, 21.68211346, 41.59530893, 1000.0)\n",
      "('Covid19', 'Madagascar', 2020, '351', 0, 46.70473674, -19.37189587, 24894370.0)\n",
      "('Covid19', 'Malaysia', 2020, '25437', 221, 109.69762284, 3.78986846, 30684652.0)\n",
      "('Covid19', 'Maldives', 2020, '271', 0, 73.45713004, 3.7287092, 475505.0)\n",
      "('Covid19', 'Mali', 2020, '78', 3, -3.54269065, 17.34581581, 17965448.0)\n",
      "('Covid19', 'Malta', 2020, '1538', 0, 14.40523316, 35.92149632, 436099.0)\n",
      "('Covid19', 'Mauritania', 2020, '40', 1, -10.34779815, 20.25736706, 4163532.0)\n",
      "('Covid19', 'Mauritius', 2020, '698', 21, 57.57120551, -20.27768704, 1261870.0)\n",
      "('Covid19', 'Mexico', 2020, '5832', 80, -102.52345169, 23.94753724, 123333379.0)\n",
      "('Covid19', 'Moldova', 2020, '1975', 17, 28.45673372, 47.19498804, 1000.0)\n",
      "('Covid19', 'Monaco', 2020, '382', 2, 7.40627677, 43.75274627, 38070.0)\n",
      "('Covid19', 'Mongolia', 2020, '138', 0, 103.05299765, 46.82681544, 3056357.9999999995)\n",
      "('Covid19', 'Montenegro', 2020, '592', 8, 19.23883939, 42.78890259, 627271.0)\n",
      "('Covid19', 'Morocco', 2020, '3141', 156, -8.45615795, 29.83762955, 35126274.0)\n",
      "('Covid19', 'Mozambique', 2020, '48', 0, 35.53367543, -17.27381643, 27829930.0)\n",
      "('Covid19', 'Myanmar', 2020, '40', 0, 96.48843321, 21.18566599, 53045199.0)\n",
      "('Covid19', 'Namibia', 2020, '86', 0, 17.20963567, -22.13032568, 2358044.0)\n",
      "('Covid19', 'Nepal', 2020, '87', 0, 83.91582640000001, 28.24891365, 27263430.0)\n",
      "('Covid19', 'Netherlands', 2020, '89334', 4797, 5.28144793, 52.1007899, 16981285.0)\n",
      "('Covid19', 'New Zealand', 2020, '2992', 2, 171.48492347, -41.81113557, 4659265.0)\n",
      "('Covid19', 'Nicaragua', 2020, '28', 4, -85.0305297, 12.84709429, 6303970.0)\n",
      "('Covid19', 'Niger', 2020, '92', 8, 9.38545882, 17.41912493, 20788789.0)\n",
      "('Covid19', 'Nigeria', 2020, '710', 9, 8.08943895, 9.59411452, 185960244.0)\n",
      "('Covid19', 'Norway', 2020, '46708', 195, 15.34834656, 68.75015572, 5250950.0)\n",
      "('Covid19', 'Oman', 2020, '1530', 0, 56.09166155, 20.60515333, 4479217.000000001)\n",
      "('Covid19', 'Pakistan', 2020, '13649', 100, 69.33957937, 29.9497515, 203631356.00000003)\n",
      "('Covid19', 'Palestine', 2020, '111', 0, 35.19628705, 31.91613893, 1000.0)\n",
      "('Covid19', 'Panama', 2020, '6104', 103, -80.11915156, 8.51750797, 4037073.0)\n",
      "('Covid19', 'Papua New Guinea', 2020, '11', 0, 145.20744752, -6.46416646, 8271766.0)\n",
      "('Covid19', 'Paraguay', 2020, '481', 23, -58.40013703, -23.22823913, 6777878.000000001)\n",
      "('Covid19', 'Peru', 2020, '6637', 112, -74.38242685, -9.15280381, 30926036.0)\n",
      "('Covid19', 'Philippines', 2020, '9451', 609, 122.88393253, 11.77536778, 103663812.0)\n",
      "('Covid19', 'Poland', 2020, '13913', 180, 19.39012835, 52.12759564, 37989218.0)\n",
      "('Covid19', 'Portugal', 2020, '39476', 632, -8.50104361, 39.59550671, 10325540.0)\n",
      "('Covid19', 'Puerto Rico', 2020, '3', 0, -66.47307604, 18.22813055, 3283120.9999999995)\n",
      "('Covid19', 'Qatar', 2020, '9512', 3, 51.18479632, 25.30601188, 2654379.0000000005)\n",
      "('Covid19', 'Romania', 2020, '12497', 232, 24.97293039, 45.85243127, 19796280.0)\n",
      "('Covid19', 'Russia', 2020, '9937', 37, 96.68656112, 61.98052209, 1000.0)\n",
      "('Covid19', 'Rwanda', 2020, '504', 0, 29.91988515, -1.99033832, 11668829.0)\n",
      "('Covid19', 'Saint Lucia', 2020, '225', 6, -60.96969923, 13.89479481, 180028.0)\n",
      "('Covid19', 'San Marino', 2020, '3228', 292, 12.45922334, 43.94186747, 33503.0)\n",
      "('Covid19', 'Saudi Arabia', 2020, '10703', 29, 44.53686271, 24.12245841, 32443443.0)\n",
      "('Covid19', 'Senegal', 2020, '1269', 0, -14.4734924, 14.36624173, 14993514.0)\n",
      "('Covid19', 'Serbia', 2020, '4965', 55, 20.78958334, 44.2215032, 8853963.0)\n",
      "('Covid19', 'Seychelles', 2020, '101', 0, 55.47603279, -4.66099094, 95711.0)\n",
      "('Covid19', 'Singapore', 2020, '12198', 22, 103.81725592, 1.35876087, 5653625.0)\n",
      "('Covid19', 'Slovakia', 2020, '3077', 4, 19.47905218, 48.70547528, 5442001.0)\n",
      "('Covid19', 'Slovenia', 2020, '7807', 68, 14.80444238, 46.11554772, 2074205.0)\n",
      "('Covid19', 'Somalia', 2020, '24', 0, 45.70714487, 4.75062876, 14185635.0)\n",
      "('Covid19', 'South Africa', 2020, '8820', 7, 25.08390093, -29.00034095, 56207649.00000001)\n",
      "('Covid19', 'Spain', 2020, '646803', 46099, -3.64755047, 40.24448698, 46634130.99999999)\n",
      "('Covid19', 'Sri Lanka', 2020, '1362', 4, 80.70108238, 7.61266509, 21021177.000000004)\n",
      "('Covid19', 'St-BarthÃ©lemy', 2020, '17', 0, -62.84067779, 17.89880451, 1000.0)\n",
      "('Covid19', 'St-Martin', 2020, '4', 0, -63.05972851, 18.08888611, 1000.0)\n",
      "('Covid19', 'St. Kitts and Nevis', 2020, '17', 0, -62.68755265, 17.2645995, 1000.0)\n",
      "('Covid19', 'St. Vin. and Gren.', 2020, '17', 0, -61.20129695, 13.22472269, 1000.0)\n",
      "('Covid19', 'Sudan', 2020, '46', 19, 29.94046812, 15.99035669, 39847433.0)\n",
      "('Covid19', 'Suriname', 2020, '79', 0, -55.9123457, 4.13055413, 564883.0)\n",
      "('Covid19', 'Swaziland', 2020, '66', 0, 31.4819369, -26.55843045, 1000.0)\n",
      "('Covid19', 'Sweden', 2020, '39483', 765, 16.74558049, 62.77966519, 9836003.0)\n",
      "('Covid19', 'Switzerland', 2020, '138532', 2133, 8.20867471, 46.79785878, 8379915.000000001)\n",
      "('Covid19', 'Syria', 2020, '42', 3, 38.50788204, 35.02547389, 1000.0)\n",
      "('Covid19', 'Taiwan', 2020, '4223', 58, 120.95427281, 23.7539928, 1000.0)\n",
      "('Covid19', 'Tanzania', 2020, '144', 0, 34.81309981, -6.27565408, 1000.0)\n",
      "('Covid19', 'Thailand', 2020, '12855', 62, 101.0028813, 15.11815794, 68971313.0)\n",
      "('Covid19', 'Timor-Leste', 2020, '10', 0, 125.84438982, -8.82889162, 1219289.0)\n",
      "('Covid19', 'Togo', 2020, '244', 4, 0.96232845, 8.52531356, 7509951.999999999)\n",
      "('Covid19', 'Trinidad and Tobago', 2020, '670', 13, -61.26567923, 10.45733408, 1377562.9999999998)\n",
      "('Covid19', 'Tunisia', 2020, '2082', 54, 9.55288359, 34.11956246, 11303942.0)\n",
      "('Covid19', 'Turkey', 2020, '45245', 762, 35.16895346, 39.0616029, 79827868.0)\n",
      "('Covid19', 'Uganda', 2020, '167', 0, 32.36907971, 1.27469299, 39649172.99999999)\n",
      "('Covid19', 'Ukraine', 2020, '2419', 72, 31.38326469, 48.99656673, 44713708.0)\n",
      "('Covid19', 'United Arab Emirates', 2020, '5131', 26, 54.3001671, 23.90528188, 9360975.0)\n",
      "('Covid19', 'United Kingdom', 2020, '140246', 7329, -2.86563164, 54.12387156, 66297944.0)\n",
      "('Covid19', 'United States', 2020, '899280', 14330, -112.4616737, 45.6795472, 1000.0)\n",
      "('Covid19', 'Uruguay', 2020, '2365', 2, -56.01807053, -32.79951534, 3424139.0)\n",
      "('Covid19', 'Uzbekistan', 2020, '890', 7, 63.14001528, 41.75554225, 31441753.0)\n",
      "('Covid19', 'Vatican', 2020, '52', 0, 12.43387177, 41.90174985, 1000.0)\n",
      "('Covid19', 'Venezuela', 2020, '1161', 8, -66.18184123, 7.12422421, 1000.0)\n",
      "('Covid19', 'Vietnam', 2020, '2718', 0, 106.29914698, 16.646016699999997, 1000.0)\n",
      "('Covid19', 'Zambia', 2020, '159', 0, 27.77475946, -13.45824152, 16363448.999999998)\n",
      "('Covid19', 'Zimbabwe', 2020, '45', 8, 29.8514412, -19.00420419, 14030338.0)\n",
      "('Ebola', 'Guinea', 2014, '2397.0', 1433, -10.94066612, 10.43621593, 11150970000000.0)\n",
      "('Ebola', 'Guinea', 2015, '3351.0', 2083, -10.94066612, 10.43621593, 11432096.000000002)\n",
      "('Ebola', 'Guinea', 2016, '3351.0', 2083, -10.94066612, 10.43621593, 11738.434)\n",
      "('Ebola', 'Italy', 2015, '1.0', 0, 12.07001339, 42.79662641, 60578489.0)\n",
      "('Ebola', 'Italy', 2016, '1.0', 0, 12.07001339, 42.79662641, 60663.068)\n",
      "('Ebola', 'Liberia', 2014, '3110.0', 1241, -9.32207573, 6.45278492, 4359508000000.0)\n",
      "('Ebola', 'Liberia', 2015, '3153.0', 3858, -9.32207573, 6.45278492, 4472229.0)\n",
      "('Ebola', 'Liberia', 2016, '3151.0', 3, -9.32207573, 6.45278492, 4586.788)\n",
      "('Ebola', 'Mali', 2014, '7.0', 5, -3.54269065, 17.34581581, 16934213000000.0)\n",
      "('Ebola', 'Mali', 2015, '7.0', 0, -3.54269065, 17.34581581, 17438772.0)\n",
      "('Ebola', 'Mali', 2016, '7.0', 0, -3.54269065, 17.34581581, 17965.448)\n",
      "('Ebola', 'Nigeria', 2014, '19.0', 7, 8.08943895, 9.59411452, 176404931000000.0)\n",
      "('Ebola', 'Nigeria', 2015, '19.0', 7, 8.08943895, 9.59411452, 181137454.0)\n",
      "('Ebola', 'Nigeria', 2016, '19.0', 7, 8.08943895, 9.59411452, 185960.244)\n",
      "('Ebola', 'Senegal', 2014, '1.0', 0, -14.4734924, 14.36624173, 14174740000000.0)\n",
      "('Ebola', 'Senegal', 2015, '1.0', 0, -14.4734924, 14.36624173, 14578450.0)\n",
      "('Ebola', 'Senegal', 2016, '1.0', 0, -14.4734924, 14.36624173, 14993.514)\n",
      "('Ebola', 'Sierra Leone', 2014, '7354.0', 2392, -11.79271247, 8.56329593, 7017153000000.0)\n",
      "('Ebola', 'Sierra Leone', 2015, '8704.0', 3589, -11.79271247, 8.56329593, 7171909.000000001)\n",
      "('Ebola', 'Sierra Leone', 2016, '8704.0', 3589, -11.79271247, 8.56329593, 7328.846)\n",
      "('Ebola', 'Spain', 2014, '1.0', 0, -3.64755047, 40.24448698, 46777927000000.0)\n",
      "('Ebola', 'Spain', 2015, '1.0', 0, -3.64755047, 40.24448698, 46671919.0)\n",
      "('Ebola', 'Spain', 2016, '1.0', 0, -3.64755047, 40.24448698, 46634.131)\n",
      "('Ebola', 'United Kingdom', 2015, '1.0', 0, -2.86563164, 54.12387156, 65860149.00000001)\n",
      "('Ebola', 'United Kingdom', 2016, '1.0', 0, -2.86563164, 54.12387156, 66297.944)\n",
      "('Ebola', 'United States of America', 2014, '4.0', 1, -112.4616737, 45.6795472, 318673422000000.0)\n",
      "('Ebola', 'United States of America', 2015, '4.0', 1, -112.4616737, 45.6795472, 320878312.0)\n",
      "('Ebola', 'United States of America', 2016, '4.0', 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
}