EMDAT.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/nicholasjones/anaconda3/envs/GPD/lib/python3.7/site-packages/IPython/core/magics/pylab.py:160: UserWarning: pylab import has clobbered these variables: ['plt']\n",
      "`%matplotlib` prevents importing * from pylab and numpy\n",
      "  \"\\n`%matplotlib` prevents importing * from pylab and numpy\"\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import geopandas as gpd\n",
    "import os\n",
    "import pylab as plt\n",
    "%pylab inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = '/Users/nicholasjones/Desktop/code/data'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/Users/nicholasjones/Desktop/code/data'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['SP5',\n",
       " 'gadm36_COL_shp',\n",
       " 'statistical-gis-boundaries-london',\n",
       " '.DS_Store',\n",
       " 'cuebiq',\n",
       " 'OSM_completeness',\n",
       " 'FB',\n",
       " 'HRSL',\n",
       " 'GHSL',\n",
       " 'mobility',\n",
       " '.Global_Mobility_Report.csv.icloud',\n",
       " 'emdat1.xlsx',\n",
       " 'bulgaria',\n",
       " '~$emdat1.xlsx',\n",
       " 'hospital_candidate_locations_top_10_countries.tsv.gz',\n",
       " 'SL_buildings',\n",
       " 'gadm36_VNM_shp',\n",
       " 'Italy-Coronavirus-Disease-Prevention-Map-Feb-24-2020-Id']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.listdir(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel(data+'/emdat1.xlsx', header=6, index_col = 'Country')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['country'] = df.index.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Dis No', 'Year', 'Seq', 'Disaster Group', 'Disaster Subgroup',\n",
       "       'Disaster Type', 'Disaster Subtype', 'Disaster Subsubtype',\n",
       "       'Event Name', 'Entry Criteria', 'ISO', 'Region', 'Continent',\n",
       "       'Location', 'Origin', 'Associated Dis', 'Associated Dis2',\n",
       "       'OFDA Response', 'Appeal', 'Declaration', 'Aid Contribution',\n",
       "       'Dis Mag Value', 'Dis Mag Scale', 'Latitude', 'Longitude', 'Local Time',\n",
       "       'River Basin', 'Start Year', 'Start Month', 'Start Day', 'End Year',\n",
       "       'End Month', 'End Day', 'Total Deaths', 'No Injured', 'No Affected',\n",
       "       'No Homeless', 'Total Affected', 'Reconstruction Costs ('000 US$)',\n",
       "       'Insured Damages ('000 US$)', 'Total Damages ('000 US$)', 'CPI',\n",
       "       'country'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "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>Dis No</th>\n",
       "      <th>Year</th>\n",
       "      <th>Seq</th>\n",
       "      <th>Disaster Group</th>\n",
       "      <th>Disaster Subgroup</th>\n",
       "      <th>Disaster Type</th>\n",
       "      <th>Disaster Subtype</th>\n",
       "      <th>Disaster Subsubtype</th>\n",
       "      <th>Event Name</th>\n",
       "      <th>Entry Criteria</th>\n",
       "      <th>...</th>\n",
       "      <th>Total Deaths</th>\n",
       "      <th>No Injured</th>\n",
       "      <th>No Affected</th>\n",
       "      <th>No Homeless</th>\n",
       "      <th>Total Affected</th>\n",
       "      <th>Reconstruction Costs ('000 US$)</th>\n",
       "      <th>Insured Damages ('000 US$)</th>\n",
       "      <th>Total Damages ('000 US$)</th>\n",
       "      <th>CPI</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>1981-0091-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>91</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Geophysical</td>\n",
       "      <td>Earthquake</td>\n",
       "      <td>Ground movement</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>1981-0068-CAN</td>\n",
       "      <td>1981</td>\n",
       "      <td>68</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Meteorological</td>\n",
       "      <td>Storm</td>\n",
       "      <td>Convective storm</td>\n",
       "      <td>Hail</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OFDA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>1981-0039-ARG</td>\n",
       "      <td>1981</td>\n",
       "      <td>39</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Rail</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>45.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>240.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Argentina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brazil</th>\n",
       "      <td>1981-0023-BRA</td>\n",
       "      <td>1981</td>\n",
       "      <td>23</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Water</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>230.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Brazil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brazil</th>\n",
       "      <td>1981-0082-BRA</td>\n",
       "      <td>1981</td>\n",
       "      <td>82</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Water</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>300.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Brazil</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Dis No  Year  Seq Disaster Group Disaster Subgroup  \\\n",
       "Country                                                                \n",
       "Colombia   1981-0091-COL  1981   91        Natural       Geophysical   \n",
       "Canada     1981-0068-CAN  1981   68        Natural    Meteorological   \n",
       "Argentina  1981-0039-ARG  1981   39  Technological     Technological   \n",
       "Brazil     1981-0023-BRA  1981   23  Technological     Technological   \n",
       "Brazil     1981-0082-BRA  1981   82  Technological     Technological   \n",
       "\n",
       "                Disaster Type  Disaster Subtype Disaster Subsubtype  \\\n",
       "Country                                                               \n",
       "Colombia           Earthquake   Ground movement                 NaN   \n",
       "Canada                  Storm  Convective storm                Hail   \n",
       "Argentina  Transport accident              Rail                 NaN   \n",
       "Brazil     Transport accident             Water                 NaN   \n",
       "Brazil     Transport accident             Water                 NaN   \n",
       "\n",
       "          Event Name Entry Criteria  ... Total Deaths No Injured No Affected  \\\n",
       "Country                              ...                                       \n",
       "Colombia         NaN           Kill  ...         10.0        NaN         NaN   \n",
       "Canada           NaN           OFDA  ...          NaN        NaN         NaN   \n",
       "Argentina        NaN           Kill  ...         45.0      120.0       120.0   \n",
       "Brazil           NaN           Kill  ...        230.0        NaN         NaN   \n",
       "Brazil           NaN           Kill  ...        300.0        NaN         NaN   \n",
       "\n",
       "          No Homeless Total Affected Reconstruction Costs ('000 US$)  \\\n",
       "Country                                                                \n",
       "Colombia          NaN            NaN                             NaN   \n",
       "Canada            NaN            NaN                             NaN   \n",
       "Argentina         NaN          240.0                             NaN   \n",
       "Brazil            NaN            NaN                             NaN   \n",
       "Brazil            NaN            NaN                             NaN   \n",
       "\n",
       "          Insured Damages ('000 US$) Total Damages ('000 US$)        CPI  \\\n",
       "Country                                                                    \n",
       "Colombia                         NaN                   5000.0  35.565172   \n",
       "Canada                           NaN                  79000.0  35.565172   \n",
       "Argentina                        NaN                      NaN  35.565172   \n",
       "Brazil                           NaN                      NaN  35.565172   \n",
       "Brazil                           NaN                      NaN  35.565172   \n",
       "\n",
       "             country  \n",
       "Country               \n",
       "Colombia    Colombia  \n",
       "Canada        Canada  \n",
       "Argentina  Argentina  \n",
       "Brazil        Brazil  \n",
       "Brazil        Brazil  \n",
       "\n",
       "[5 rows x 43 columns]"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Colombia', 'Canada', 'Argentina', 'Brazil', 'Cuba',\n",
       "       'Dominican Republic (the)', 'Honduras', 'Belize',\n",
       "       'Bolivia (Plurinational State of)', 'Chile', 'Ecuador', 'Guatemala',\n",
       "       'Costa Rica', 'Anguilla', 'Antigua and Barbuda', 'Barbados', 'Dominica',\n",
       "       'Bahamas (the)', 'Bermuda', 'Haiti', 'Guadeloupe', 'Guyana', 'Jamaica',\n",
       "       'Mexico', 'Peru', 'Puerto Rico', 'El Salvador', 'Nicaragua', 'Panama',\n",
       "       'Paraguay', 'Saint Lucia', 'Saint Kitts and Nevis',\n",
       "       'United States of America (the)', 'Venezuela (Bolivarian Republic of)',\n",
       "       'Turks and Caicos Islands (the)', 'Uruguay',\n",
       "       'Saint Vincent and the Grenadines', 'Trinidad and Tobago',\n",
       "       'Netherlands Antilles', 'Montserrat', 'Martinique', 'Grenada',\n",
       "       'Suriname', 'Virgin Island (U.S.)', 'French Guiana',\n",
       "       'Virgin Island (British)', 'Cayman Islands (the)', 'Saint Barthélemy',\n",
       "       'Saint Martin (French Part)', 'Sint Maarten (Dutch part)', 'Curaçao'],\n",
       "      dtype='object', name='Country')"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [],
   "source": [
    "world = gpd.read_file(gpd.datasets.get_path('naturalearth_lowres'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x12af5e7f0>"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXwAAADECAYAAACcCZpmAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzsnXd4VNe1t98zvTeVUe8IIYqootlgjHHvcY9jJ45benx9E8fpcZL7JTc917ETx+m2496TuNvYgOm9I9R7GU3v55zvj5EGhAoSCBAw7/PwoJk5bWbOrL33Kr8lyLJMihQpUqQ481Gc6gtIkSJFihQnh5TBT5EiRYqzhJTBT5EiRYqzhJTBT5EiRYqzhJTBT5EiRYqzhJTBT5EiRYqzhJTBT5EiRYqzhJTBT5EiRYqzhJTBT5EiRYqzBNWpvoDDSU9Pl4uKik71ZaRIkSLFacWmTZu6ZVnOONp2E8rgFxUVsXHjxlN9GSlSpEhxWiEIQsNotku5dFKkSJHiLCFl8FOkSJHiLCFl8FOkSJHiLCFl8FOkSJHiLCFl8FOkSJHiLGFCZemkSDEUbZ4Qe9t9xOISUVFCkkGlEFAqhMP+V6BUCGSYteTZ9ejUylN92SlSTDhSBv8sJRqXCEVFeoNRGlxBtje50WuUWHRqXtzSTKcvgi8cJxqXkCQZrVoJyInnRAmNUoFGpUCrUqJVKdCqFMn9ZxXYuGV+Abk2PZG4RCASJxQT6W+ulmnRIiCwt92LJxSjNMNElkXHHz+qZVVNN3vbfXT7IyiFhDGPxKUh34MgQIHDAIAoyejUSowaJUqFQJZVR3G6kYumZjE914ogCCfpk02RYuKSMvhnCZ3eMFua3KgUAmqlgr+sruP9fV2j3t8XiQ94HIlLROISPuJkmLXcNC+fxZPS8IfjdHgj3Pbn9bS6Q4Rjg421QaMkLspExUOvCQJYdGoicTG5T1yWiUvDt+CUZWh0BTm8S6fdoMZp0bG+rpfm3hA2vYYXNjXTE4jSG4zS448SiMZJM2qZV2Tnc+eV4TBqRv05THSkvs9LoZg4A1w4JnKwy0+nL0K+3UBphjE1AJ8ihInU03bu3LlyqvBqfJFlmfuf3caLW1qSz5l1KsoyTWSYtGSatWjVSvZ3+NCrlUTiEuvqeoY01P0oFQI5Nh23LSjikulZeEIx/rK6njd3teMLx4fd71Ri0qpYOjmDc8vSqS52UJhmRDnORlGSZLr8EZp7Q0zNseALx9nW5EajUrCjxcO+dh/BaBytSkmzO0SGKeF+uqIqhzmF9mM+Z3cgwvObmglFRUozTNgMahaVpqNRndoQnSTJfHigi68/v51OXyT5fK5Nzy3zC7ilugD7GTTYnkoEQdgky/Lco253vAZfEITJwDOHPVUCfBewAXcB/dPIb8qy/O+RjpUy+CMTjMbZ2uQmy5JwV/TPkg52+XlxczOynHBxTMu1Mi3Xys4WD+5gjElOI42uEP/4uIFXt7UOOObcQjvVxQ72tHlHnPFfWOnks+cUk2XV4TRrafGEae4N0eQKJv71BllzsAd3MHZCP4Nj5cFLKrjr3JITOvNt84S46+8b2dniRRAYtPK4siqHpZMzyTBpiYoierUKs05Fnl1/Rs94m1xB3t/Xyb52Hx3eCO5gFINWxe0LC3lzVzv+SJypOVYWl6UzM992qi/3tOSkGfwjTqoEWoD5wGcAvyzLPx/t/imDnyAUFWlxB4mJMha9mlybnmhc4om19TS4QqyozOScskOyGZIk0+ELE4lJ1Hb7qe8OctmMbLyhGK9vb8OgUTIt10q504Q/IuIORpGBDJOW17a3srPFw9ZGN62e8IDrEASYV+Tgmlm5VBc7KM0w4Q5GefyjOva2e+n2R/GGYnT7I3gn6My+n3fvX0pphumEn0eWZdbVuXhmQxMv9a2qitIMfO2iCi6bkc3K/V387r0aLpzq5Lo5edgMZ+cMNy5KvLa9FVEClQLcoRg5Vj1LyjNSAfdj4FQZ/AuB78myvFgQhO+TMvijRpZlVtV088TaBlYd6KYo3UhRupGb5+WjUirIserJsurQqBRsanDxwb4u7lpSgkWnHnCcmk4/Le4QDT0BTFoV80sc/HlVPcE+v3VUlMix6rhtYSGPfHCQ7c0eGnqCyMgYtSrUSgXdvgg9gSiXTs/i8hk5LC5LH3S9Hd4wf/ywlmc2NiXdOAoBVAoF0lF87yeTNKOGzywuYk6hgwUljpM2kw7HRDbW97K33csFU5wUpRtPynlHgyzLdPujeEJRvOE4nd4w25s9dHgjzC2yc3N1wQk7ryAIuINR9rT5kGSZX7+znw31vQBYdComZ5lZPsVJpM+lqFIKTHaamV1oP6NiLePNqTL4fwY2y7L8cJ/B/zTgBTYC98uy3DvS/me7wW/1hAnHRLKtOgwaFR8d6OIbL+xAlGTUqkTqYbnTRGmGiac3NKFXK9GqFfz+1jmUO80APP5RLSv3d/HRgW7sBjUrv7aMd/Z0cLDLz9Uzc/nuK7tYV9fD5CwL84sdGLVKDBoV3f4IXb4I4ZiISqGgLNPE55eVYtCMHNePiRJxUUajUgzwicdFiQZXkC2Nbn751r5Bq4eTSYHDwH++ci5G7dmZoxCOiXxc28PGehfbmz3savWSZtQwI89GaaaRkr7JRYHDcNTv+2i0e8K0e8NsqHNR0+nHH42zr91HkytITJTItuppcYfGfNxpuRaevHMBVr366BuPgj1tXm7783q6fBFUCgGDRklhmpGyTBPfumwKDT1Barv8pJu0ZFl1THaaJ1Qg/EhOusEXBEEDtAJTZVnuEATBCXQDMvBDIFuW5TuG2O9u4G6AgoKCOQ0NoxJ9O6NYU9PN2toeAlERk1ZFllWHWqkgzahhYWkaOrWSfe0+PjrQhdOio9xpJsuqw6BRolYODsyJkkw0LqJTK5FlqOnys/pAN2a9CpNWRSwugwC9wSj+SBwB0KkUmPUa1EqBQESkwGFgfoljyOOPlUhc5Mm1jfzwX7s52TkCRo2Sm6oLuP/C8uM2Zqcju1u9PL2hkb9/3EC6Scu9S0tYUemkMO34VxySJOOPxlEKAjKwrraHu/6+kfFa3JWkG7mpOp9LpmVjM6gx68bH2PfTG4hyoNNPjk1HXJLQqZSolArSTVoAXIEo7Z4wNoOaHJt+XM893pwKg38V8AVZli8c4rUi4HVZlqeNdIyzcYYvSjLfeWUnT61rHPC806ylKt+Gw6jBpFPxidl59PijzCyw0dIbIt2k4a3dHTR0B+jwRfju5ZXYjRr2tnv58b/2sKmhF61KwbcvqyQuSjzw4g40SgUzC2zcuqCQZZMz+OHru1lX58Jm0PDARZN5dOVBDnb6ybMbuHiak9e2t5Fu1CaW+fMLBrmPxspbu9r57+e2nRR/vyDAtbPyOL8ik4WlaWelO+C1ba386u391HYHuH5OHt+8dMqosmJW13TjC8fIMOuYnmtF7qu/6DeEkEgUuPjXHxITT84Inu9IxLF6gzF0KgUmrYrLq3LIt+vRqhNpvj99Yy9pRg0qpUCBw8gd5xSxqHSwO/JwRFHinxuaaHQFybXpuGFuPvrTcGIwWoM/nu/sZuCfh11AtizLbX0PrwF2juO5BuENx4jEJNJNmtMq4+HNXe28t6cz+VivVvLLG6p4bmMTb+3uSD7/+Ed1AGiUCqKiRLpJy+KyNF7Z2kqaUYOi7z3H4jIz823UdgVocYf4+Vv7ePLOai6dlsWFU51cNTMXQRD46+o6nt3YDEBDT5BbHl+XPFerJ0wgmsivX1/v4oP9nfxnZzsrKp3cvaQEfzh+TOl0FVkW7EYNoZh4Qg2FSiGwuCydHJuOS6dnnVb3w3jx94/r+eHru4mJMudXZPK/18046ucQFyWeWt/Id1/ZBSTSJ/92RzUfH+ymptOPQatiZ4unz+2oJ9OsOyb3zLHQ5Dp0nmhcwhuO89iHtYO284QSWWL7O/woFbCwJA1BENje7MZp0aFSCHT7oxQ4DPQEIry9u4MfvLY7uf/3Xt2NWafCbtBgM6ixGTSsqHRyw9w8tKoTF0yOixKqcVhNH41xmeELgmAAmoASWZY9fc/9A5hJwqVTD9xz2AAwJMczw9/c2Mu2JjfLK5wUpBnGtG8kLlLbFWBbk5va7gBNriDr61wUpRtZWJJGTJQ4Z1I6Zp0aASjOMB73bLe5N0iWRYdKqUCWZdbWuohLElOyLaSbtPT4I/zu/YPUdvtRCALhmMiOZs+gAqh+lpRncOPcfBaXpWEzaIiLEr5wHJtBzSceXcPmRjcAF0/N4pc3ViHL8Nv3DiSLkkZ7GygVAqIkc9mMbOYU2JmaY6G6ePTB0C2Nvby0pYUNfQHN8Xbx2AxqfnDlVFYd6KbTF+HH10wjzz62++FEIkkyMokZ8mMf1hKKioRiiYrnKdkWzp+cyfkVmcftL5YkmVZPiL+uricQFZmUaeKm6vwR3Vq3/3k9K/cfSs216tU8d+9C/uffe9jc0JsstjudqMhKBHyf3dA0IJHgyLTZo2HQKFlclk5RmoFAVCQYSVScW/VqFpamc2VVzjFfYzgm8uLmFm6Zf+zB8lMStD1eTrZLR5ZlNjf2cs8/NtPtjxx9h8PQqBRYdGosOhXBqEh5lpnZ+TaMWhXTcq3MK7ITiUu8s6eDFncIAYE1B7vZ0+ajJMPIzhYPWVYdl03Pps0TZlKmiW3NbkrSTcwvcTAp04xCgAdf3EFdd4BGV3DIzJc0o4Zon3EHuGpmDvevmIwoy3ztuW0YtSqWlKezpdHN69vbMGqUfPbcEu5YXIQgCFj1asIxkYffq2FjgwuDRklRmpHKHAt5dgOyDOvrXDzyQc2wP/aLpjp59JNzRmWk3tzVzt/W1JNvNyDKMs9vah7T5z4aKrLMXFGVw5VVOeQ7Tr2x94ZjPLWukXd2t+MOxajtCiT93BVZZqJxibgkAQILSx0IQIZZx7KKTJwWHWlGzbimKh7o8PHYh7Wk9+kOzcq3MyXbzEtbWvjpG3vp8B76Lbx93xJu+/N62k5h0H2ik27S8pXlZYRjEr3BKAohoemkVioQJYkrqnLY2+7j2y/vxGHUYDeoESVQKwXKMk2UO80sLks/LrfjWWfwn1rXyPq6Hi6amsWyiswRfyDBaJyHXtvN+/s6B9zcx8v8Ygfr6lwAaFUKFIJAKCYe8/EMGiUZZi3Tcqzcs7SEXa1eTFoVWpUCm0HNC5taaHAFyLbouGJmDtG4xIKStGRu9xs721hb52LJpHTioszd/9iUPHZltoWaLj9vfXUJ6WYtV/9uNTWdfgCq8m28cO/C5BKz3RPiuY3NqJQC7+3tTKbRQSIo+unFRVxYmUVppgnTKDJh2jwh/rCylte3t9Ltjx7z55Nh1pJv15Nm0pJr01OWaWJpecaEMPIALe4Qf1tTz7raHnRqJaGYSENPgMrsRBWuKMvUdPqJiTLpJg1KQaDDN/h+VCoE5hTauWBKJsunOJP1BG2eEM9vbCbPoeeKGTmolAriosSeNh/r6npYW9vD/OI0dBolXd5E9kxdd4CFJWn8ZXX9gNVirk3PikonU3MsfOulnUnZiwsrnXzn8kqW/Oz9kx5wP1MwaRPFdXvbfcNuk2HWsuFbFxzzOc46g/+HlQf5f//ZCySWoncsLqa62IGMTK5NP2RWQkNPgJ++sZf39naOKCUwWg43+OOJICSKpAQBglERXzierI49UsrAoktk4rhDsaReTZpRQ09gaMO6tDyDpt4gtV2B5HOLStN48s75STfN27s7WF3TzZeXT0KlFLjgFysHlMofzs3V+dxcXUCBwzBsUdHXn9+WjB8cC0qFwP0XlnP3uSUnxe95LDy5roEfvLqLyhwrW5vcg16fU2BnU+PALOXZBbak6w0Sq8joEKuqX95QxbWz82jzhLjkNx/x6UVFXDcnjz+srOWFzc0Eo8c+yTicPLue39w0i431Ln725r4JU1txJpJu0rLx2ymDP2qe3djEK1tbWF3TAySCm1qVAl8kjkKAe5eW8rWLJuMNx3lpczMb6nvZ1uymushBTJJ57QjJgWPhRBn8E01JupGvXTwZlUJBRZZ52BmyKMlc/OsPOdC3Eujn25dNwaRV8fO39tPtj1CSYeRvn6ke9jj/XN/Igy/uGPX1GTRKJmWaKM00MTPfxkVTs3BadCPu88rWFp7b2ExZpolFpWl8dKCbNJOGHc0earr8fL2v8nW8icRFvv/qbv65vpG5hXY2NgwuPSlJN7KkPIPdbV7WH3a/ZJi1ROMinlDinr18Rg73Li2l0xdmf4cPXzgRSO/0Rnh/XydlmSbe3dOJf5i4zvFywZRMtjd7hh3cU4wfJ8vgn375R8OwqDSNT8zOQ5RkOrxhHvmghnf2dOK06njzq0uSRUEWnYqCNAP/2tGGSiGwvcWTNChHGrKzgYosMz+5djo3PraWimwLF0/NYkWlk7LMhNvgla0t/Ort/QDYDBoaXMFBx/j9ylpurs7n6bsXUN8d4JxJ6SO61G6uLqDbF+EXfccdibvOLebBS6aMOYh5wRQn/kicH7y6m7+uqR/0+gubm1k+ZWTX31hp6Anwxae2sKPFQ3WxY4Ax72dGnpUXP7eISFzimQ1N7G71Jg22KCWK2AAkGV7d1sqN8/KpzLbw5q525hU5qO8O8PD7NQDsavWO27UPxTuHZY+lODGoFAKVORYWlqadlPOdMTP8oZCkRIl/U2+Qhp4AZp2aOQX2pPGIiRKilAjcvr27g7+srj+u851OM/yfX19FRZaZyU4THx7o5qHXdzM918qKSiebG3qZXWjnqpm5yLJMKCaiVysRBAFPKMZzG5v48b/3IMuJwFNxupH9HX7KMk289dUlozLOXb4INz728QBX0pHk2fU8c89Cco+x6MUViPLvHW20ukO0ecJY9WrmFtmZV+Q46gphLDT0BPjL6nqeWteIJEtUZlup6w4M8JEbNUpunFfA3UuKeX17Gw+/XzOk0NycQjubDlsVKASYkWdjV6vnpOW8pzi5XFjp5NFb5xyXeutZ59I5GrIs44vEk+mU7Z4wd/9jIztaPOMWjDodDP5tCwu5YW4+03KtA56XJBlPKMbvVx7klvkFZJp17G7zkmPT8fKWVgrTDNgNGtzBKMsqMnEFory/r5M1B3vwhmJcMSOHXLt+SN2d4QhG4zzwwo4h3WkLShz847Pzx6XS90QgyzJPrW/kHx83DAjG5Tv0A3LGIfFe/vCpuVj1at7a1T4geH4kNoMarVIxZPA2xcSnIstMnl0/qtXRZKeZ+SUOYqLEFTNyWDSG386RnHUunaMhCMKA3PmV+zvZ3uwZ9f4Oowa9WpksNNGpFeMS6D2ZPHTVVG5bWDTkawqFgN2o4cFLpwCJQpBsq45oXOKnb+wdsG26ScN9K8opzTDxyfmFwCFhrLFg0Kj42XUziIsS6+pcRGIigb6AY4HDMGGNPSRcLt9/ddegWXebOzTIPXj1zNykBsykPs2jIxGEhFT13nYfHcGUsZ/o5Nn13Lu0lJJ0IzVdfn76n71cNyePG+bl88AL24fdb3FZGrcvLGJmgY1M8/itMkfLWTPDP5zNjb10eMK0esK8uaudSFxi2xCZFP1cWOmkwGHg8VV1lDtNfP68Mi6dns2ag91sqHfR5YsQjUu4glGiMYlWT4hGVwilAGqlgvAEKFapyrPyyhfPGfN+sixz4a8GB2ohEWja8K3lSUO/rclNIBo/ajn7cMTEhF97X7uPz51XOuH1S5b9/APquge6pCx6FTqVckCgU6tS8MgnZ7N8ipOYKPHGznZe2NxMYV/vglybHl8kzv3PbjthAdgUx05/dXs/18/J4/tXTk2K8cmyTHNviN+vPMhLW1ooTjeSZdEhyjLzi9Ooyrfy1q4ObplfkBQ5HG9SM/wRmF1wqLvQZ88pZnerl/977wB6tZI97T60KkUylW5qjoVHb53DvnYfty8qGpB5ct7kTM6bnDng2F2+CI9/VMvOFg87W71Y9WoMGuWIObgng1BM5PlNzVw7K3dMAdD/7GwfNpjd7Y/wx49quWV+ITtbPNz9942Ikszf7qhmbpFjzNeoViq4dUHhmPc7EbR5QgQicQrTjMOuNJaWZyQN/mXTs7l+bh7/+8Y+drcdCqaqFALXzclLBuXUSgVXVOUgCPCj1/fw97UNZJi02AzqlLE/hZw7KZ2Lp2WRbtKSZtQQl2T84TgGrZIFxWmsrevh5S0tZJp1nDspfYDy6mvb2/jOyzvxhmM8eEkFdy8pHXT8Y50EjTdn5Qx/JGKixP3PbmNDvYtrZuWiVSmIiTL/taJ8TIYyGpdo6k1Iwr6wqZltTW7W14+oDn1SePiWWVxYmYVaKYzKBSPLMr99t4ZfvTN8Ro2+r6ioH4NGyZN3zmdWwbG17TvV1Hb5uey3q6jINnPdnDxunlcw5HcvyzL7O/yYdCrSjBr2tvtYXdPNz97cl9xmdoGNFz+/OPk4Jkq8tauDZZMz+N6ru2h0BfGEYjS5AgSip34leLaRY9Xx3SsquWjq2DWX/ryqjrd3d/BxbSIVPM+u50dXTxs0CTwZpGb4Y0SWZV7d1sqfVtWxYoqTb146hSyrjg/2dTLrsMye0aJRKZIVkQ9cXMHjq+oAgd2tHvzjVBhzLPzXM9uIS1uwGTQsLEnj04uLmDfCbFwQBD65oGBEg39kNXEwmpBqePz2uaelcFmLO0QoJrKl0U15pplPzh/6PQiCwOQsM2/uaucrT2/hqqpcfnj1VN7c2cb2Fi9Oi5ZPzMkbsM9zG5v465p6nlhbjycU50Cnj5goM6/IPqCCOcWJRaUQ+Oy5xXxl+aRjks3+y+o6Hnp994Dn2j1hPtzffUoM/mg5qw2+JMmsre1h5f6uvt6iBh6+efYA8bXx+PJUSgX3Li2lxx8hKkpDVl6eLPp9ka5AlH/taONfO9ooSTdy4dQsJmWaMGpVLC3PQK9RIkoy6+p6+OHre8Z8nnf3dnLpb1fxleWTmJFnnfD+eEgM+lua3FRkWbhqZg6vbG3lPzvbuGxGNkvKM4bdTykkmtPct2IS9z6xmatn5XHlTJnPnlOMIAjJgHY4JhKIxAlERPZ3JLK5nBYtWRYdG+p7ybMnupptPEWGXxCgOM1ImklDbzCWlNo405hbaOfH10xnctax+9Nf7mtfeTjXzcnju1dUHs+lnXDGUw+/HvABIhCXZXmuIAgOEg3Oi0goZt4wUterk+3S2dfuIyZKVGZbTng3mzd2tjEz385bu9p46PU9E7pMff23lpNp1vHvHW18/snN43LMH109jU/OL5iwM/667gAPvridmChTmmHkoaumsbvNy2f/uoG4KPPty6dw47zBaoaiJOMLx5j343dYUJLGxVOz2Nvu44qqHA50+nh3Tycb6lyUOU1YdWqC0TiCIBCXJMIxiUhMpOawWgS9WklphpGdJ7ioKt+RkDdWKRIDUoc3Qqs7RKzvvswwaSnOMCJKMpsaeqnIMmPSqoasHD7dyLPruXxGDpdNz+bDA11cMSOHfIeePW0+KnMsozrG/c9u44XNh+RB/vvCcm6qLhjQM+BkcqpcOstkWe4+7PE3gHdlWf6JIAjf6Hv8wDif85g5nhF+rLiDMdo8IW5bVEwkLvM//9kzYcWo/r29jU8vLuaSaVnk2o6tJd2RfPvlnTS6gnyzL+1zohGKiqytTcy6L5jipL4nwDdf3EEgIhIVJX70rz0YtSoumOJEp1by8cEefvn2PgwaJR8d6EaS4aMD3Xx0IHH7f1zbM2CGvKVx4Kpuao5lyErZUExEq1biMGhwBY9dWO5oZFv1Q1YC99Plj9Dlj6BSJGoD+pMOpuVY2NvumzATlslOc6JLWzSORqXEqlezv8M3ZFFbP/0ZNb9feRCA3688yGcWF7OpwcWTdy4Y1XkXlabxwuZm8ux6bplfwB2Li0+L5usn2qVzFXBe399/Az5gAhn8k8lN1QV0+hISs3ctKUGlFAY0XphI/OzNfdiNGuYU2nGPk9EpzTCSZ5+4bp0Wd4hrZ+eytDyDy2fk8MG+TryhWNIF5gvH+d839rGi0kmXL8z3X9tFpzeM06IbsqVfTacfp1k7bAGVSaeiusiBICQC/L5IDF8ooZUDifTOSU7TMRXylTsTqqXuYIza7sGVzHl2PU1DSGQMRVxigPHc2eplTqGNLY3uY25laFArmJZnwx+O0eoJj2icj4ZVrxqUDDEjz4o7OPoaG02fymhz7+gnNksnZ2DWqnjg4gquOA4t/JPNeBp8GXhLEAQZ+IMsy48Bzv6mJ7IstwmCMHGjGSeBwwst1EoFV1ZlU9MVYPcJXr6PlUBU5CtPbx1TkwijRkmmRYcsy7hDMdzBGGadipurC/jMoiIefGkHOdaJa/BXVDpZUekEEkVnBzr9WPRqzp2Ugd2oId2koSzTxCf/uA5BSLgDp+VYhnS9VGZb0KgEJCkxk+72R2g+YpXU7gnT0DPY6B4+QDS6gswqsNHjj+CPiLiGUTwF0GuUmLQqMs0adrUeSgF2mrUUphmJxEX8kTg2vRqlQkEwGj9mjftNDW6cZi1GrQqzXoUCgYNd/kGtK0vSjWSYtcREiW5/hMa+CuSpudYBq4vpuRb2d/hwWnRoVAoaeoJDykjo1QpChxU7Ts2xDJn5tr3Zw8x826hjZVdU5XD7oiIe+eAgW5vczMy3HXWfdJOWVd84f9yaqp8sxtPgL5ZlubXPqL8tCMLeo+7BoCbm43g5E5uLp2URjonsa/fxhWVlfLC3Y0gDMF5YDZoxu2ZGY+y1KgWXTs/m5uoCVEoBpSCwt93LotL0ZM3C4x/Vsqamhy5fhKbeIOeUpQ9bcToRUCoEbl9YxL1LE/nUT61rpKbTz+Mf1dHuTRjJTLMWi17FZKeJFnd4QA69Wadifb0LlUIgJspoVAqWlmfgD8cQBAFJltk3iroMST7kCtKpFZT2dVrbMoQhm55rYVuTm64jVhQdvsgJkWno8EXgsOPq1Qpm5FkxaRVE44keuPs6/MkVhkJIqIGmGTXsaRv43ne0JAbN/gEhzaihKN1IOBZHlBKfZ1SU2NbkoTzThEWvBgH2tg3/GbZ7w8wvdtATiFDTObxeE0C504wvHCfNqOGZDY0WxgvQAAAgAElEQVRU5VlHFWs63Yw9nKA8fEEQvg/4gbuA8/pm99nAB7IsTx5uv4mQh3+y6fZH+MPKgywsSeOBF3cM+sGOF3q1kpIMI0atCkmSiUkSyBCX5GNWXbQb1Ny6oJAP9nWxo8VDjlXH03cvHJDltLmxl2sfWTNgv5n5Np4/rMHKRKQ3EOWaR1YTiomEouKIjdfLMo0DjEpRmgEBaHaH+gYGNcGoiLNvtmvVa2jzhOkNRrHq1WRZtYRjEnvavPgjw6fs6tVKyp0mtg0hCTLcauNkUl3sYHuzm6o8GzWd/mF7MBzXOYocbGnqJcuio9kdGtWkZFqOhYNdfiqyLCgEYUAfAqdFy2tfOoeaTj/72n18ZnHxuF/zyeCkBm0FQTACClmWfX1/Xwg8BLwK3A78pO//V8bjfGcSiWbk6Xzuic3YDSduxhCKicMadqclsewfKYh3JHq1kkunZfPxwR4i8YSRiktyX6u+BO5glEmZJj782jIAdrd5UCsVfO/VXXjD8eNq6XaisRs1vP1fS3l9eysPvDC0dr9GKTA910Zdt58Ch4FChx4J6PCEqekKoFcrKEozsvpgojCnoSeIUaPEZtTQ0ucv7vRFqO8JUJphZHKWhU0NvYMK2TLNWhaUpNHsCrJ5GDfFzlYv03It7GzxMjPfhlmnoqEnSOMoffXHilGjpDLHgoDAnjYv4ZiUjDsM1w/geFhf70IhJO61uYWjq13oHwi3NLkpdBxyK6abNDx3zyIyzToOdPh5Y2c7ty4onNAaTsfLeLl0nMBLfcsgFfCULMtvCIKwAXhWEITPAo3A9eN0vjOK6bnWxEzSc2oKsjq8ETq8EQrTDCgEYZA+zFCEYiJbm93savVS3Ve41emL8ON/7yHfYSDDpGFDfS+P3zYXc1piIOuf+S+f4jxxb2YcUSsVXDMrj0BE5Nsv7xxyG6NWyaQ+l8D2Fi+eUIzidCPLKzJpdCUM7rwiO0pBICbJRGMiO44YeGOijMOopdMb5uFbZjG30MFLW5p5b28n18zK5drZeWyod/GpP60f9lqVCoEcq57HPjWHHJsBWZZ5fXsbX/rnluQ2GqWARqkY18K/4fzowLinOisEmJRpIhgTaXKFxhyDmJ5rSbqP9GolP7u+KnlPlqQb+dWNM8f1eici42LwZVmuBaqGeL4HWD4e5ziTGa45+MmmoSeIQkjM2gJHGIVCh4E0kwZRlgGBTm84uWJQKQVe/Nwi/ry6ji2NbsoyTFTl2bnr3NIJ7bYZLWrl0IYrKsqEYxIbGlzo1cpka8FHb51NNC7x51V1NPeGcAWiWHRqdrZ6MGlVQ7pfPq7t4eGbZ3HZjETGx8XTslm5vwtRkmlyBXlrVwdmrWqAxv7hfP2iydzTF3PY1NDL557YhDt0KPul3GmitiuAKCfcIrXd/uPqJzy7wEaXLzKiXMiOZg+lGUbMOjVxSWJ3q3fMmT3Kvn4AKqXAgU4/+zrGXgxWlWeluTdEXV+9g9Oi5U+3zxsgEf7ilhZiosTnzislGpfQqE7/+3YoUlo6E4D39nZwx18nzvsuTjdS1x1AqxKYmW9HRmZLo3tQ5sSXl0/i+jl55DsMdHrDvLK1lU8tLDwt8pGPJC5KvLSlhQOdfmwGNSatCotOjYzMf3a089bujuS2doOaablWeoNRbHo1X7mgnOm5Vr750g5e3NxCWaaJ3986hzSjhp+/vY+Ndb34wlHsfR3D7AYNDqMGtUpBXJRpdAW4bHo2P7x6+ojX6ApE+flbe9nZ7MEVjA1IIyzNMPLu/ecB0NwbZMUvPxzgFlIphAG58+kmDSUZpkRunQAHR/C559n1g1IWs61a2r2RMdWSHIt8RGmGkZ5A9LhSN2fm22joCdAbjDG7wMbDt8weUPm9tcnND17bxZZGN3aDmiurcvjBVdOO+XyngpSWzmnEiczOGSsz86209IaZW2gnJkrD5oFnmLXcu7QkqUOSadFx15KSk3mp44ooyzyxtoHdbd5BA5taKVCRZUarUqBVK/ny+WWcM+mQ1IIkyXznlZ1845IKGnqCbGro5d4nNvGL66v47uWVdHjDvLCpmU31vaiUCiwGFav299B/lqI0A5dMG9hfNxiN09IbQq9RkmdPuB0cRg3/c80MNjX08olH11CYZsBmUBONSext9/Gv7QkZiDy7gU3fuYB7/r6JUExkc2MvgpBwv2hVClyBKPU9Qbr9h77bOYX2AQZ/bqEdVzCKRadia5MHvVqJKMtolArSTRpybHraPGNLMNhQ38ukTBMalQKdWokkyygFgWhcorbbjz8iUpFlwqLXgJxwG+5u8yIeY8L/tBwLaSYtV1Vlc+XMXJp6Q4mA+mEZODFR4vrfr+HTi4qw6dU8eOmUEyZhPBFIGfwJQMEwzb5PBfva/cREiS7/0D9mvVrJeZMTxUk9/igGx5lxC2lVShRCQhfHbtYM0LOPiTJ7233MKrBxYaWT+SUD+4+6QzGq8hMNLZ65ewEvbG7m+U3NXPW71ayodPKV5ZO4b8VkFv/kPdJNGkIRifklDtKMmj7pAjfv7+uk0xfGFxHZ2ezhhc3NyRl5dZGDS6ZnkWc3EIzGWVvbQ0WWiTSjFkkGvVpmWq6F36+swapXc86kdAwaFQ9eWsGmRjeRuIROrUjOrsudJub3ZdT057VvauhlfrGDTl8Eo0YJQiKhoD+eE4qJZFm0FDgMHOwKsKYvED1WRuobbdGp2Ns+dpeN06Klw5v4vrQqBVX5NjzBKHvbvfzyxllc2VcYVZxuHLSvWqngjnOKWV7h5FuXjV3S+3TjzPi1nubYDBMnW+VI5cvDUSoEVj2wjLRTpBdyIomJEp2+KEXphiGNzpRsC0/eOX9IZcU2T4hvv7yT6+fkoVIquHFeATfOK+Dp9Y088sFB2j1hzDoVy6dk8taudtyhGJ8/r4xPLShEEOAn/9nLyv1d/GV1/ZCSBevrXayvH7zSyrbGybRo0CiU7GjxolYK/GlVLTMLbJi0Kt7f1zVAqrmf/X1+8HlFdrY09tIfQlpX5yLLosWqU2FUK3GHYnT5IlQXO2jsCRKKiSdU4nuk1NehyLbq+MUNVXT7ozz02i6qixzUuwKsr3NR7jTxu0/O4aKpWSMeQ5ZlnlzbSLsnTHXxmW/wz8zIxGnGnEL7hL/Zcqy6hF/6DDT2ABvqXbS4Q5h1Q6fGVuVZh5XRLUoz8vhtg6Wgb6ouYHqulRn5VgrTjHzjkgoyLTrCMQmjVoXdqMGsU7Ol0c3+Dv+Y9WnaPGECYRGDVsmMXAuzCux8ZfkkTH3NOW6clz/krPbQe+4lz25gap9gmEmjxGbQsLXZw4Z6V3KgCkXjtHvDeELH7kcfb757eSWvfemcRIGfXc/Kry3jkVvncGVVLpBYqU0dhRBakytEOCYOaIp0JpMy+BOEP942l9wJKiGsVAjceW4JS0eQCD7dWVSaztLyDAQGZ+RU5Vn5/HllQ+4nSjJGrYpypzlZbfvkugauengVD764nW9eNiUpqWHQJLRXABp6AkTjEgoBzp8ydsWRfveKUati5f5utrd4WV/nYvXBHjx9Ac50k5ZCh4HqIgdlmSZmF9iYnjvQCNb3BKnp9LOg2IHDpMGsUzEj14pRm6hm7Xc72U5gjcix8KdVdWxvdvPkugZ2tXqJ98VdJjvN3H1uMQc6/XzhqS1Iwwyi4ZjItiY3n/nremwGNbcvKjqJV3/qSGXpTCBe2drCV57eeqovY0juWVKSbHB+ptLcG0SrUvDwezW0uENcPC0bhQCXTs9GluHpDY1sb/bQ6QsnVDTjErvbvCwpz+DD/V2cNzmDP942F7UyoVXT6ApSkTXQwMqyzJ9W1XFFVQ5OS2IgiIsSr25r5eODPZh1apwWLa9ua6U0w8SS8gyeXNdAvE/ELRgViYkJaeVOX4Q8m452b2TA6iDNqGFarpVgNM62Zg/RI9J+p+ZYiMRFajoDaFUKJmWahqzSXTIpHU8oSk8gBrJMhy8ypMbNqSTbquP7V05lcVl6cmXzj7UNfKevbuKt+5YMCsI29wa55pE1uAJRRElmaXkGf7uj+qRf+3iSytI5DblqZi47mj193bEmFof38DxT6c+GybMbkjPfPLueLz61mdU1PcPGN7r7Ary7W73JKk2DRjXI2EOiS9ad55bQ5gnx3t4OtColi8vSuXZ2HtfOTnTHkmUZu1FDcZqRecUOfvf+Aeq6D2VyHV7B2uwOD6po7QlEWbm/a9j3uavVy5JJaaQZtWxt6h3S2AsCHOwKDNBfclq0THaa+fBA96DtTwXzix385TPzBrnazH336qwCG5l96qMf7OvkyXWNtHlCBKNiUsLEqldz2YyBGVJnMmf+r/g046sryplTaOfpDU0j/mhPFudOSud7V1RSlnnmpqr1I8syq2q6+flb+4jEpeTnX5FlHjGY3c/Vs3JHfa5sq57sYdRDBUHgoqlZWPVqajp9ZFp0SYNflWel/YgKU294bL51hQDbmj14QkMHSZUKgbmF9mRKbkWWGW84Rigq8uGBbmYX2NjceOq6tvWzsaGX17e1ccO8/AHPLyhJ4937l1KaYUKUZH79zn4Odvqx6FTMyMviHx838OgnZ1Nd7MCiV5/RUgpHkjL4EwyTVsUl07O5ZHo2//fuAV7c0oKib7Z1MtGqFNx/YTl3Lyk9qec9VYSiInf9fSOragbPXi3DBHL76XclPPZhLZIsU5hmpNBhYEFJ2oCKTVmW+WB/F5GYlGwjORz9SoxPb2ikrivAjDwrFr2aVcPMrvuL5UaDIAjD+rYhUai0+bAVg1GjYl+7L1k3MFEMpCjJ/Oqd/Vw8PWvAd5RlPSRD/v1Xd/HEugb+76ZZ6NRKZhbY+Px5ZShPcIe7iUrK4E9gbltYxGMf1pJr13PRVCe9wRje0KGqwzyHAQUJRcrxVGdQCPDknfOZO0Jz8zONN3a1DTL2uXY96SYN+ztHljJeX+9iXpEdUUqk+PWvBiqyzDxzz8LDjHcTD76YEGLLd+hZMimDxWXpZJi1zMq3IQgCHx/sIcemozjdiCsQpaE7mPDV2/UEInFm5luRJNjeckgxc3+HH7VCwKpXjyqTRpRkyp2WAaqRkBhkJmWa6PCGk60OAdyhKEatMqnkGRxHLZ7jpc0T5jsv7+Q3N80a8vUvL5/Ex7U9XDo9+4S3MT0dSBn8CYzVoOZLy8v46EA3f/jUXM7/+QcDOhi19xWbFKcb6PCECcbGZvUXlqQhCIkZ27q6HqJxCUlOVNGeTcYeSKpX9jMl20wsntBgHw2xuESLJzzA9bO33cfMh96iKs/G9XPzWLnvkIuuyRVia5ObJ9c1AomiI7NOTYs7hEapwKJX4TBqsPUNFiqFYkAufmW2hQ5vOFkdG5dlyjKNNLlCdPsjR9WsCUQHunMyzVpcgcggdUuFAGatmoORQ/fdnjYP1UUO/JEYja7QgF4Ap4KitOFTTzPMWv715XNSxr6PlMGf4Hx6UTH72v08u7GJr188mXufGNxUvK470RlJlGRCURGdWpFUBeznhrl5XDMrD3cwSm13gM0NvfzommlJP3Jdd4A0k4bvvryTl7e2srPFM0Bc6kzGHUwEOR1GDZMyTbiDMfa2HXJhjIbdbUMLg8lyQqtlqO5Lh2fPeMPxZOFRVJQwaFTs7/BzUaWTeUX2QbPx3W1erHo1cwvtBKMidoOaZZMz+Oy5Jfzgtd38dU39iNebbtIwv9iBTMLV1O2PDqgu7mdekWOQvEZcgogosrvNh92gZm6RnY1HKcjql6Zo7g2Nu07+y1tbuG9F+bCva1Wnn7bTieK40zIFQcgH/g5kARLwmCzLv+lrgnIX0D+t+aYsy/8e6Vhne1rmcHiCMS7+zYf8382z+HB/F3/8qG7EIKJJq8KoUdLhS0ge//QTM1hwhBzAcKyr7eHGx9ZyzazcM14u1huO8fq2Nn7z7n46vJFRGa7h0KoEIvGx/ZZyrDpah5H4nZ5rJc+uxx2M8XHt6GQMLpiSyR9vm4svEue6R9ckK2qHQhASxny4HgilGUYcRg0b63uHHPgs+kQW0r52H55QjFybnlybHn8kTjQuYtarUQgC3f4IdoMmOeDNKrChFIRx08lXKgR+fPU0bqo+e7rlDcVo0zLHI/oSB+6XZXkKsAD4giAIlX2v/UqW5Zl9/0Y09imGJxCNM7vAzv3PbeOGefk8cPFkVCMsUf2ROOl96Wh3nlM8amMPUJFtId2k4Z3dHURjIiv3d9I6xtaIpwOiJHPf01v55ks7yLcbmFdkx6pT4bQcWyWxcZgq3GNlR4uHLywr4/e3zhl1Qd47ezr5wlOb0SgVvPnVJfzqxiqK040sKk3ji8sGFo7JcqLRetoQTWjKMk0c7AqwYRhjD+ANxVlf5yIYjVOZbSbXrqexN8juNi8mjRJJkhAliXSTNmnsp+VYkCSZjQ295I9TQ/t7l5ac9cZ+LBy3wZdluU2W5c19f/uAPcDo89NSHJUcm57ffXI2P7hyKr96+wCfXlx81NzhXa1eKrMtY1YatOrV/O91M0AAlVLBkkkZIw4upytfe24b7+7tZGFpGgqFgEIQONgVwBuKUV3kYBQtTQdg1qkY74/pp2/sxaJX8f+unT7q6/n3jnbe2NnGtmYP18zK4/3/Po8fXT2N+SUO7jynmJn5NrQqBVa9mkhMpCcQRRAY0G2tptNPyQiSDIcTE2V2t/lYX5eQYlArBDRqJVq1kq1NHjb1zeR1agUt7hDbmj04jJox6+YMRUm6kS+dP4mJVDw60RnXaYkgCEXALGAdsBj4oiAItwEbSawCBq3jztYm5sfCnEI7v3rnALtaPfz6xpnYDZoRfbW727xU5dvGfJ7zK5ys/NoyFAqBFzc3c37F2Ev/JzLNvUHe2dNBtlWHAvj4CLeGIEBVrhVXMDbqFoENrhDVxY6ki2M8+OhAN89saOKm6gKWlmfwwb7R1WX8fmUtD1wyGU8oRm2Xn889sYlPzMnn25cnFt6iJNPmDqFVKzFpVaiVAkqFwLde3smLm5spdBiwGjQDEgRGS0ySEQSBdXUuHEYNZZkm1te5mJZjTbpxChyGIWMaYyHdpOWRW2fT3BvkDytr+dn1g/ovpRiCcUuoFQTBBLwAfFWWZS/wKFAKzATagF8MtZ8sy4/JsjxXluW5GRlnrlbLeGDWqXnh3oU8sbYBVyDK966o5L8vHD5YBZA/RullVyDK9mY3vnAMWZa5dHr2GZWzHBclbvvTemQZBCAiDs5sEmWZrc0eWt1B5hc7Rr3CWV/nYmq2hao8KxqVgkyzlslZx1ew9tT6RBbPn26fx4WVo2sNubfdxx8+qKXqB29xzSNryLMb+N37NVz58Cpe3tKCUiGQ5zCQYdai1yhRKRUIgsC3Lp3CNy+ZQl13cEz9jY8k3BdfisREwlGROYV29rQdSiKo7fZTlTc4IaAozTCqTlOfmJ3H2/ctoSLLwm/frWHWWSJ8Nh6MVxNzNQlj/6Qsyy8CyLLccdjrfwReH49znUhcgSh2g3qQ6uFEQqVU8NBV05LFL19YVsamhl7eH2b2N9pWbZIk89c19Zh0KnoDUd7d2wkyTM218NXlIw8qpxNrDvZQ2x1gTqGduCgNGaRV9n3/cSkhGVzo0KNWKakZQcu9wGHAolexpi/AmmvT4zRr2dzkZrLTjEalYEfL4BTPyUdpthGJSfzq7f3ct6KcW+YXDOi8NRJr61yYtCpybDp06sQ9sL3Zw38/t42Z+TaKhnDZGLUqbltUxL4OXzJd9Fio7fIzNcfC1y6azN/W1OMKRAe0zPSG4vgjcVQKgTx7Ithb2+2nvieIw6AhpBAJHba9UiFw+YxszpucwYKStAEVypfNyGZxWfoxX+vZxnEbfCFhHf8E7JFl+ZeHPZ8ty3Jb38NrgKG7QE8gHH3KgC29AURRpjjDdKovaUgOr3QUBIErZ+YMa/Cf29jMZ88pHvT8q9taeW5jE55QjO9fOZXZBXbuOGy7e5aW0huI8ou393HNI6u5ZX4B183Jm1Da/cfChroeZhfYkGSZ2BCze2CQTHGDKxG0ru5rGhI+rN5Bo1IwM9/KhrqBAc4Wdyip47KvI1G4VZxuxKpXs63ZnWwN2P/aSOzr8HHnucVUZFkwaJSjLnzyR+Ls7/AP+M5uri4Y0tgfzpfOn0Rzb4jidCPv7u2gyTX6oP0vrq/ishnZyTaXoajIF58anEp8sCtAudOEXq2kxR1Cp1YhCBHcoShfXFbGbQsL+cXb+ylJN3Ht7NxhZbmPpnefYiDj4dJZDHwKOF8QhK19/y4F/lcQhB2CIGwHlgH3jcO5TjhKhUCBw4hBq+JPE1DEbCj8IwTAHn7vAB3ewal/v3lnPx8d6EaWYdYwfn67UcMPr5rGF5aV0eWP8PymZlz+CM9ubOKJtQ3sbR8sujXRuWVBIZsb3WxpdLO7bWhjGxrGoK6vc1GWYSK7r3S/IsuM06Jlfd3Q2Sw7Wz1oVYdWi3XdAbY2ucm16Zlf7BjQV/VoBKMiWVYdT921gHTT6AZdtVJgRq6Vlt5EHOKW+QV894rKo+yVkCb42x3VfP/KqZSOctJj1au574JyrpqZM6Cn8UVTs7jtCOlhq16d0LHRqdjT7utrtxghx6rne1dM5b8unIxEQt6jKN1wxvZgOBUc9wxfluVVMISIOJzWaZhWvXrUPtNTza0LCkkzaXnghe34jjD+vcEYX3l6C19YVka2Vc+uVg9v7ergYFcAnUrBkvL0EV1Yzb0hyjITsyxvKM7auh5e3tJMoyuE8CFcNzufe88r4eODPcwrckx4Vc0Mk3ZQQ+8jGUmMbGerl2yrblQNufvbAR5Jc2+IaFwastBpOF7e0sI9S0uZmW/jC8vK+MFruwdtY9apqMgyoxASWUfbm3qTEgzTci3cPK9gzDo46aMwtmlGDc/cs5CyzMGDg0Ih8I1LKlhT05NczUzqC+T2/32g049RoyTbqqMkI7H6WFfrYs3BHr58FHdibyBKqydEaYZpwECTYmgm9q/zFKJTK8cc8DxVCILApdOzOb8ik9U13fzPv/cMMDRra12srV2ffFyaYWRGnhWjRskNc/OHOmQSi07N7jYvxREjVoOapeUZLJucSU2nn8q+jkIxUSLbqkelnLixj8M5Woim6yiGuM0TJsuiG3EbOCSANhTSGFMJ/72zDadFx9Wzcvnk/ELe29uJKxBFq1IQjIr0BqOolYoBg9CUbDN72nzcMr+ALy4rG9OKop/ZBXae39Q87OtV+TZ+e9NMCkeQN9CqlNxcnc/3+wapw5MAtCoFOTYd3mCMVneIRz84yPRcK1dU5XBFXy/akXhmYxM/+c9e3rt/KSUT1AU7kZgYsncpxgWdWsnyKU7evm8pz96zkNsXFuIwatCoFJw7KR2LLjG+q5WJEnerXk2aSUNMlGh1h4jEB7syrAY1F009pEaoUyvRqBRJY99/vMlZ5tOihH17s4dZBXaqixxkmIeevUbi0pAFSf0YNUqaekdO19SqFCPmh4+lPqI0w8i2Jg9//KgWWZbRqBR874pKWt0hNje62dvuo8MbofkwPSCdWsEXl5Wx7bsX8uOrpx2TsYdEZexQaFWKvsreOSMa+35cgSgOo4Zf3ziT5t4QRWmJydTOVi+t7jD+qEie3UBNp5+vP799kAT0cGxvdpNu0qBNze5HRWqGfwaiUAhUFzuoLnbwncsrCcVEzDo1rkCUrz+/jXf2dAKJRhmzHnobWQaZxPL6FzdUMTXnzNTQiYkSf1lTn3QnZFu1VGZbMOtUxCWpLxgrI8uwr/2Qfz/XpifNqEGpAIVCgS8cG1G2AGBGnnVYl0+aUYNeraQ3OLp8/XSTlg5PmH3tXr7+/Ha+d+VU9BrVkPvr1UrOnZTODXPzuWAcXJIVWWYunprFG7vaBzx/34py7l06euns+1aU84Xzy9CqlKw52M3r21oHbbOtuZdIXMYVjPJfz27lqbsWHPW4Le4wN1cXTNj2oBONlME/w1EpFZj7/LYOo4bf3DSTRz+opbbbT6c3obUjywn3w+ZGN95hmmKcCagUAiaNkkmZJiRZ5mBXgDy7YZA42OFUFzlY39fgPNemo8WdmHmWZhjRqRXsbh0ssqZWjqw3X5xuHJOWjFohkG7W0uIOsaqmm689t40fXT2NcqcpOfBY9WqunZ3LZ88pTnbuGg8EQeDe80oHGfyxFpcJgpBcAU7NsbC/3c/W5kTx1Yw8K5GYiEalQK1UoFcrWXOwB184NmxT+X5+9onp/PrdA3z16S3ccU4xM/LGXmh4NpEy+GcZRq2a/75oMgDtnjB72z1848WdSZ9/YdrRjYUkyQRjYrLxx+mCIAhMy7VS3+MnJsJkpzBkBhMkjLZJqxogSWzSqinNUNLhCdPuCROIihSnG1AqFDiMGto9YeKihCjL6LUqLDol3vBgN9lYCtnUSoG6nmCy1WCbJ0y7tx2dSsEFlU5m5du597xS8u16VCeoMcmUbDNGjXJALv3xyG1cPzefV7e18dubZ/Gv7a10+yNsbz60Yprdp/zqDh7d4AeiIpfPyGFOoZ01B7vRq5VMOkptw9lMyod/FpNl1XHeZCc/umoaRq0Si06VTDkcirgosavVwzde3M6qA1387v0ath1nifzJ5tLp2cSlhHhYbXeARleIAoeBHKuOuYWHKjar8m2DXCbNvUHMWhXTci1J41fXneh9u77ORaMrSKsnTIc3Qn1XgNKMoQ1Pc29wyLS2fhQCyWuZnmsd0FcWEte+cn8XSydl8NPrZlCcbkQhCOxt9/Lq1ha+/vy2Y/hkhkerUvLl5ZMGPLewdPSCfEeiUSrQKAUWFDv4w6fm8plFh+o/qovs7Gn3ke/QDxtj6Scal5hVYGdekZ3VNd1cUOHkodd3j7i6Ots5vaZoKU4IF1Q6mZJlod0bZnOjmzmFg0vVO7xhLvjFSnyROOVOE95QnDd2tfPzt/Zx+8aaezgAACAASURBVMIiREnmypk5vLO7A284zqLSNCpzLKPO4z5Z2I0anrl7AV/651Y2NcoY1Ir/3955xzd2Vnn/+6gX27Jcx92eGU/JNE9Pm5BJL4QhBRIISSAsWVhYlg4h7Lu8C7v0tm8g+STZsCEQQk3ZEELqkGSS6b14ZuwZ915ky1aXnvcPyR7ZllzGRbL9fD8ffSzde3Xv0fXV0XPPc87v0NbrwRMIkZ0abtKdYtQN5uKvLrSFewVYDSxIM7HzbBeFYyg9CsJzIvoYVc4pESmDiqJ0TrU6Kc2ycKwpPF9gNWgxG7QU2S2c6ehjc1lG3NCP1aTjy388zPvXFnC0sYdjTT209nrJtBoonIbssnsuLuXB16twegPkphnJHUeWUjw0QrAoO4WcyD5uXJ1Hj9vPy8db2V/bze0bivjCNUtGTbOUUvK/h5q4dX0hOo2Gmo5+Xjzawn2XLZyw8N18Qjl8BQCP3bOBV0+08Z0XT/D5q5egEYLtp9pIMei495JS/t/rp3F6A6SadDg9ASzG8JdRSgYF3J7cWTu4v+cONvKrezdBEsojaTQafnpHBTqt4NXjrSxbkMrBegfNPZ7B3HiTTkOqSYdRp8HpCeD0BHC4/Vj0YY2chu741aerCm14/SGORUkpZFgMFNhNhGRYyTQ71ciKAht7a7pYkZ+GSaelo99Lm9PL0aYe/EGJEPGzeeq73GwstfObnbWDDUXsFj393sC01I+Y9FquXpHL/x5q4kvXLOW5g018aFNR3Ebso9Hc66GyxUlzj5s8mxkhBHdeWEJdt4vLlmTHrAyPRkrJ3461cvWK8Oe0Ww3k2kzcuDqPHVUdbD/ZztY5Jvg3VUy6AcpUohqgJBYpJa8cb+Wd6k62n2zj2U9fwi+2V7P7bNcQdcNNZfEbZ0SzIj+Ny5dm84WrlyalANvLx1q478l9LM9LJcWgo98XGFF9u6nMzu6z4VH20txUul0+nJ5A3AY0Rp0g1aSno8/HhohoWHaqEYNOMySzRwAbS+3sjpPJk28zgYAmx+jpiYLwebYYdfS4fJztcPH2V7cOjp6nkh6Xn+2n2thWUcDWH26noij9vJrkVLf38a/PHqWiKJ2vXLdscHkwJMd1nfiDIQQMzlmEQpJ/fe4orb1e3jjZxm3rCvnebasnbNdsZiYboCjmCEIIrlmxgG++bwVP3LsJm1nPfZctHNEApaHbxcZSe8zQTzRmvZafv1HNg69XJaVm+dUX5PLDD6xBqxEcbHAM1hpEU9MRnW8vERBTgyfFqGVzWQZrCu109IVH3FqNwBMIUdPpGpHGKYHdNd1sKovdO7ipxxOpCh79M0jC6pgeX5CTrX18cGPhtDh7CNdkbKsIt7rIs5mobh89NTUei7JTeOgj69l9touXjp7L/hnvoOBvx1qGVEr3evx8aFMx16zIJTfVyMqCtFHePb9RI3zFmNz52E52VMVus1eYbiY/3TwkmwXCI12b2TAYIrljUxGBoCQkJRcvyuK9UQJbiaa+y8UXfn+QE81OctOMQ6qUSzMt1HS6WFOUzl2bi1lbnI7dauRUq5O7/nsX/mD4+7NsQSqVUbn7GkGkX+zox9ZrBRVF6XFz9rcszuKtqo647xcCKgrTOVDvIM2k440vXT4j2jP1XS7MBu24pBcGONXqRKcRFGdY0Gk1fP+lSnaf7WJdsZ2v37h8zPdLKXl6Tx33//kot6wt4LNXlg8Rgutx+/nD3no+fmlZUiveTgfjHeErh68Yk4/9cndcNU5giK5MqlGH2x9kcSTX3eHyYzXqIpW8IVbmp3G0qZc1hTb+595N2JNEfdMXCPH4jrN09HnZUp7NhhI7ISk53ebEH5BsKssY4UQe2l7Nnpou1hTZeOytsyN0jArt5sFY/5oiG/5ACL1WQ583QLrFQGuvh4ZuNxpgQ2kGISSH6h2DPyKrCmycbOmloshOZUsvvZ6wpLDZoMVuMZBp1dPk8NAa+VF9+CPruG7l6J3QEslfjzTz6af2c+PqfH7ywTXsOtvFnY/tAuCtr2wdVcokFJJ896+V7DzbSSAosRq1PHbPxlHlK+YT43X40z5pK4S4DvgZoAUek1J+d7qPqZg6giE5wpENJ/r2uiTTQk1n/+Bot8BuprPfS06qkfpuNzUd/QgRvn3/zosn+P5tydGpyKDTxKwcXVccO+QC8KnLF/Epwu/ZUp7NLb94Z8j6NJOOhdlWUo06BAybHzh3FxGCwTuktUU2/EFJnzdAu9ODLyjZXdNFhsXA+hI7HU4PKSY9x5t6qYu6qfri1UuS2tkDXL8qj0fv3sB9T+7D6fHzk9srWFuczoE6R0xZjwGaHG4ef/ssj719lo2ldo42dvPu/VcqZ38eTKvDF0JogZ8DVwMNwB4hxPNSypFSf4qkQ0rJp369L25qoF4rsBh0+AMhNAJCMuw4PVETmma9lsZuN6sLbOSnm8OdpgTUdPRzpqOfr/R5JxQWSFbSzXo2l2Wg1wpA4A+GcPuDWDSCU219Y8d2IjjcAc5GtRYcUJPscvnoqg3PDawvMQ5W9xq0Gu6/YRkfHSZBnKxcuTyX79y8igeePcJnntrPe1fnYdBqeGj7GX70waE//qfbnDR0u/nYL/cA4bqRgTvJl462cE+MzyxluMXiQAaQYijTPcLfBFRJKc8ACCGeBrYByuHPAv7rtdP0uP2Y9Rrc/pETlSWZVpodbo4397KpNIMQcLrVSSBq064+L7mpRt6OMwew/WQ7t60vnKZPMHNUt/chgdOtYee8ttjO4YZwWubinJRRu2UN5dwPQ26acVDLPhZLclN48MPrWDLLKks/uLGIvbVd/H5vAzuqOrl9YxHvrxiqjNnu9HLfr/aRaQ3f2fS4fHiiLqy3Tndw6/pCXjnewvGmXsqyUujz+llZYOPiRVn8dlcdBp2Gz1xRPvzw85rpdvgFQH3U6wZgc/QGqol5clLZ0stPXzuNlGGd9SUZFlKMOvbXnUvPTDPpqIoUKO2Mk6bZNYpAmE4jONXq5PXKVjaXZSa9lv5o7DrTNSRVNbrac7wSFNkpRs5GZQUVZ1jiTOYKVhak8dtPXDim9ECy8qnLF/P3U+209nr53Z56Ll8ytGBDI8INY87GaaT+vVtX4QuE0AjBF69ZitcfwhsIDmYorS2xsyKi6Cql5ESzkwyrgQWjVJLPB6Y7LTPWVPmQe1vVxDw5efLd2sEohNMTwOHyc7jBwYbSc6mYByYpqxAISR558wxf+eMRVn3zb7z/5zv47e66pEzhHIuazqGOaUA+uSjDTH3X6FLKA5RmWrh8STZLc1NZlG3F4wsONgSJxqDV8NCd62ets4ewgNx/3rxq8PUP/nYSl+/cXFFmijGuGuc/vmchdouB1yvb+PkbVfzTb/bz+snWIemoly/JJt0cTgh44p0aPvzYTi78zmuDqaR93gAnW5zzToZhuodUDUB0h41CYKQuqiLp2FKexRuVbbT0eliRb6Ojz0MgBEcbelhXnE4gKNFpxZAR//nS0RfOMjlY7+BgvYMz7X2kmvRctCgTs17LkkgT8GTmX997AXtqusmzmTBGbA1LHRip7xrfOTIbtIAc0ed2fUk6tZ0uOvp8FGWY+cEHVk+pImaiuGJZDlctz+XVE62c6ejnE7/ay7ffv4qySKrlXReV8Ie99Tjc/iEVx9euWIBGI3j5WAv+oKSlx8P1MSasD9R1k5li4J6LS8lKNfL/Xqvi3epOet1+7v2fPXS7/CzKtvLe1flsXZbDmkJb3HTOQ/UOLshPm3DHsGRjuh3+HqBcCFEGNAJ3AB+e5mMqpoBGh5umHg+byzKGyAd7AqFBJ39Zeda0HPvRtyK9hF8J/ynJtPD9W1ezeeH5C3ZNNyWZVp78+Ca+91LlYM1CqklHS8/4G4B7A6GYc7v7ah0szknB7QvyD5cunBPOHsKFfj+9o4Jbf/EOJ1ud7KjqpLK5d9DhF6Sb2fevV1PV5sSo0/LcwUZqO12DoZobV+dR3d7PX480s6OqgyuXh6UWXj7WwvK8NCRQ2+nCZjawdWkOr51o4ze76qjr7B8Uv6tu7+fxt8/ys9dOU56TwrUrFvCxS0pH1DIsyU3hz/sbeN+agsgP8+xk2vPwIw3Nf0o4LfNxKeV/xNtW5eEnB95AkI3ffpWiDAv13a4RGvkbSu00drtpHmdXoqnAoNXwz1cs5qJFmWwojZ8qmWheOtrM03vq6ezz4vQEqOkcXzgHwkqR8aQWAC5amMEvP7YpaQrWpooel59v/u8xnjnQyLOfvoSKovFp2u+r7eLVE21ct2IBT7xTw4/HIfPgCwQ50ezk2YON/G5PPS5fcIT0c0G6mVe+cBkWg45QKNyQZeeZTuq7XNx1USkhKWNWZScSVXilmBTxiq3sFj0Ol39E04+ZQgjY942ryRilBWEiCYUkn3hyL50ReQW9VozZ7HyANUU2DtX3xF1/32UL+foNY1ekzkaklLx6vJUd1R1YjTo+tKmYQruFHrc/br79QOprmkmPNxAcV4vN5w42DspDPHOggc//7hAWgxaXb2gdQEG6mX+5qhyTXssrx1u5fuUCrl+5ACEEr51oJd2iZ12xPWkqepOm8EoxO3n4rvV89PE9vHtmaDrlouyUCXVrmmqkDMdmB27fkw2NRnDRwky+/ZcTQLjyeOBHcl2JHa1GcLjeMSTFcIBD9T2DlcixePLdWr5w9eiywbMVIQTvWZqDOxDi1+/W8srxVjRCUNPZT1aKkZ/eXsGyvLQhGU96rWYwpj7efso3rDoX689JDU/yRg9eDDoNRp2GRoebRdkprC+x875hzdSvXJ5Ld7+Pk61O0kx60sz6WdMMaHZYqZhxjDot/3HzSq796ZuDpf5AUmiNL0wyjf3hRAuiOb0BMqx6LAYt+yI/lAuzrJwZlm6o1wrWFtvRCFicY6WqbWQ6okmvmfWThqNh0Gl435r8QQfr8gXYdbaLuk4X+2q7eXJnLV+6Zimd/T7eqGzjlnUF7KjqxGbWk59uYm2xnd1nOzna2Mv71xbEvAuMPn9NDjcPf2Q9fzvWwjMHGkkx6nj7q1uxGHR87U+H+fCjO/nLZ7ewOGfk9Wa3GrBbDUgpOVjvwKDTcEFeWtKM+OOhHL4iLguzU7h1XSFP7zlXSnG4oYf1JXZ6PX5aHG6c3vCt8OIcKx5/aFSd+Kngzs3FlI6jDWMi8Q0bvXf1D61FiBX/tZn1Q/L41xXbkFIMSX3tdvn569Fm3rs6f8T75yIWg46tS0fq2hekm6koSqeypReNCE/eAnzj2SOsLbZz54XF4xrxf2BDOIHwmgty+Op1y/D4g6RHtJ2+ffNKej0B3v/zHfzk9gquWp4T05kLIchJM3G2vZ8mh5uCJJ9Qn7vDBcWU8E+XL47IBYTxBkLsq+3mdGsf5bmpVBSmsbrARlVbP/nTXMp+2/pCvrVtZdKPotaXjC4drdGEWxiWZJgHC1WGhwRqOt04XL7B1watYFG2ld/vqWe+o4nIKC9bkDakSvvrNyzn1nWFMZ19Q7crbjMZjUaDzazHEdWY3WLQ8dg9G9j19SuxGrT0eePrSRWkm7m0PIs2pzfpa0iUw1eMSnGmhTs3l8Rct7/OgV6n5XCks1O3y0f2NOniLEgz8c33rRj8siczUjKqGNj+OgcH6h3Ud7spz01hQ4mdNLOeZQvOSSTYLXok4ZH/omwrZoOO6vZ+9tV2j+pUqtqccdfNRaIbt1sMsQMWRxt7eO5gE7f8Ygc/f6OKJ96p4UDd0Hmo7SfbeOTN6hHvtRp1XLw4a1xFbmuTaBI3HiqkoxiTz1+9hOcPNdHV7xuxThN1gZ+O6MUsyU3BotdR3dE3ptLmeLAYtDz58U2zZmLs529UcbQx9sQrhGP8Lm+Ao029g41RjDoNa6LSETNTjNR29OMPhobo8/f7gviCoZij2PouF3f9927e+srWIY5wPnOiuZebHnx7sL7hUEMPuWlGfv+PFw3Z7khjDy8eaaFjjoj5xUNdFYoxsZn1bIlTZBWI0f3pVGsfBxscLJ6iydWSTCvls0QgLBSSPPb22VG3cbr9IzJxvIEQu892UZxhZnNZBm5fgKIMCyUx5iscMfSJXL4A9zy+m+Yez7TPoyQzVW193P34bu55fDcdfV6+9cLxEcVs915SRknmUMmKgZaVP/zbyfPu5DUcp8efdCGe2TFkGgfj7YepOD9+cNsaSjIsPPz3M/iinPxAR6tYBKfoYo/1o5KsHKjvpscdXzAOIBTnvCzPSyXDauBIQw+9ngCLc1Lo6ht6foszLGRGZZ+EQpL9dd1849mjnOnoJ99moqHbPaQT1Hyhs8/LHY/sHJTq2PDtV2Nu9+KRZtYUpXNhVOX2wP/s6T31SMmU9MQ93dZHWaYV+zhqRgZknaebOTPCH54ZoZhaDDoNX7hmKS9//jJuXlvAwG/raLHNY029LEgzsa54fJWT8Yg1yk1WTrf2cUFeGumW+OfFbNCNUBXcWGqnqq0vLMsgoKIondrOfjKiwgubyzJ49O4Ng+EaKSU3/2IHtz387mDDmbzIBOJ844/7GvjSHw4NOvvRONTQwx2P7OTrzxyhuceNxx/ktRNtg+vfOdMxRMjtfFlXbI/b7D6ajj4vLxxunvTxxsOcGeHPZn2L2URplpWf3F7BxYsy+cPeempHkQ4IhiQtvR76fQEMWoEveH4j/s1lyauhM5wCu5njzb3oNKDXCEJSEpRQnpuC3WzAoBPoNBouXpRJSEp0Wg1ef3CIpEKvO4BBp8EflFS19ZGVYuSxezaMkBzodQc41DC0Mjde6G0u4w+G+M8XT8ScYxqNp3bV8dcjzSywmYfcldV3uTlU38NFiyZ/3eWnj565dqjewWuVbXzh6iWTPtZ4mDMOXzGzfGBDEa8cbwUY7KkajUErKMqwoNdqcLh8k5q8fc/S2SObfeniLG5cncdfDjcTXcN5OjI5u7HUzts156qXl+elUtk8MrNm4I51RX4aj92zIWb3JptFz5LclMGJX4CrkrQCebqQUvKNZ45O2NkP0O3y0x1jTuSxt85QaDeP2md3KlhTlD5ksn66mTMhHcXMk5tmiikRAOGJ1ur2cG/b4RNkE+GGVQsoj1HpmKwIIfjEloVx1w8P359odrK60IZFP/SrGAiFz+vDH1kft1WfNxAcEjJYmG0dVJKcyzQ53Lx8rIVPPrmPS7/3Br/bO/W1Ca9VtnH1T/7O3461TPi9u850crIlOdNjJ+XwhRA/EEJUCiEOCyGeEUKkR5aXCiHcQoiDkcfDU2OuIpnQaQWnW51YDFqsBi1GnQYhwp2woqUDHGNMYo7Gv1y5JOlzm4dTUZTO9SsXjFhuM+uHTHgPcKihhxUFtsHJ2FUFaYNpnX/c1xD3OP/99lnqu85l5Lx3Vd6sO1cTodHh5st/OMTF332d+57cx0vHWmh0TF9Gkscf4mt/Okz/KEVXsVhfYufPBxp44XDytf6Y7Aj/FWCllHI1cAq4P2pdtZSyIvL45CSPo0hCGrvduP0hVuankZViICQlS3JS0GoExRnnRqVVbX3k20xsGqessUmvYVWBjZ/cvoalC2ZHOuZwvnzt0hHLli1IHexzO5xgSGLSCfJsRrxRd007qjriHqN6mN7O1ReM/JGZKzg9fq7/6Zv8YZQfwOmg2+Xnll+8Q02cVoux0Gk13H/9cpYtSJtbaZlSypejXu4EbpucOYrZxMCEbY8nQG1kpHkyEk/2+oNsLLVzssVJrydAU4+HoJSjSgBvKs3glnUF3LKuMOk7XI2F3TJ++eaNpfYhEspF9nMhsNFS+rYuy+ZP+8MOMCfVOKfDOYcjqaqJ4GSrkx+/cooffGD1uFU5gZiia4lmKidt7wV+F/W6TAhxAOgFviGlfGsKj6VIMMGQ5GxnP1kphpjxSpc/xJ6abtLMusGuWQMt/2LxrW0r+MiFJXMmJGG3Gsi3mWiKahKj0wo0AkIynE9f1+VifYmdg8N6AwdCIQrSzXxiSxm3bSgavutBLlyYycWLMuns8/HZK8tnhezE+VJkt6DXiiHKrTPJ84ea6PX4+eVHN87qa3RMhy+EeBWIda/4gJTyucg2DwAB4DeRdc1AsZSyUwixHnhWCLFCSjmi3lwIcR9wH0BxcfH5fQrFjNPm9OALhMYcife6A3iiJhZTTTpWFdg40nhulH/lshzuuqh0ukxNGO9Zms1vd5+bUAwEJUtyU0mLKGPazLpByeQByrKsCOCT71k45jnJSjHy1CcunLGinUTS6vSQYTXQ2jt2nv10sf1kO6da+2ZtmBHG4fCllFeNtl4IcQ/wXuBKGQlYSSm9gDfyfJ8QohpYAoxoZyWlfAR4BMIdryb6ARSJoSUyci20W2hyjN3qcEOpHa0Q+AIhGh1Dc/fnaoX0tSsWDHH4wGCBFECPe2SIotnhxmrUkp06fj2Xue7sAVYX2oboNiWKjj4vS5m9Dn+yWTrXAV8F3ieldEUtzxZCaCPPFwLlwJnJHEuRXDx7oJHSTAt7ojTc43GooYe9Nd3hblX1jhH68HM1d/zypTl89bqlbCy1s8BmwjOKgmZ5TgopRi2eQIhmhyep+/YmAqNOyz0XlybaDN46HX8SfTYw2ZmxB4FU4JVh6ZeXAYeFEIeAPwKflFKO7RkUs4bOfh85qaZx97a9ZFEmu2tGXgL/eNlCPrgxfpx6tvPRi8to7HbT0uOJO1m9OCeFRoeb4gwrWSlGXvjspXNasfF8+ciFsWW6Z5INo/Q5mA1MyuFLKRdLKYuGp19KKf8kpVwhpVwjpVwnpfzfqTFXkSyc7egft35RSYaZd890sqk0Y0ioYmluKp+7amZKyhOF2aDl3963YtRtqtr6SDHqONnq5Pu3rYpbaDXfSTHqRm0sMxMsy5u94RxQ0gqK8yTDaqB9FKXMaLLTTNR2udld04XVoGVlfhp2q4EHP7RuXmggXbU8l9w046gTjk5PgEfvXs8Vy+ZmeGuqeN+a/BET3dFYDFquXJ5LVoqBy5Zks7YoHbNBy6vH23i7qp0/7ms470yfVQU2CsbQxkl2lMNXTBgpJdVtfRTYx3fxR8/J9vuCZKca+fdtK7GNoig51xjeXU+rEQRDkgyrgcuXZvPprYtZlOTN2RONlHJIdtcAQoQlK25clcf3blsds1HOjavzuHF1HsUZVr73UiULs60YtJohk+ijUZBu5tcf3zzrJ8iVw1dMmL213TT1eCgcp7DUwqwUVuTZ2FvbjVYj+OI1S6ddlCqZ0GoE371lFb/cUcPVF+RyxbIc8tPNePxBTHrtnM1SmmqkhHybCatBi06r4R8uLePui0ox6jV4AyFSjboxaxE+dfkiqtv7uO+yhfzzUwfGfex/uap8SgYobb0evIFQwq5/kUylvxs2bJB7947I3FQkGZ95aj8vHG5mcY6VqrbxlZz/8qMb2bosZ5otU8wXJlt74PT4qety8X+fPx4zmSCa0kwLL33uMkz6yYcfpZR86Q+HuefiElYXTp1KphBin5Ryw1jbze76dcWMU9PRz8vHWqkoSh+3swd49mDjNFqlmG9MNrSSatKzIt/Go3dvYKwbrCuX506Js4ew3d+9dRV/3NfAO9Uzn+KpQjqKCfF6ZRu+YIjg8KD0KKwutPH1G5ZPo1UKxflhs+j5ye0VPLWrjiONPeSnm9GIcF/mW9YVcNXyXDaUTm1mkD7SseyLvz/E5UtzWJRt5R9GkdSeSpTDV0yI0qxw7FE7xgjrvz60loJ0MwXpZhbYTDNhmkJxXmyrKGBbRQEef5CQlOi1Go439U5bY5K6Thd/PdpCu9NLd7+PrVvKpuU4sVAhHcWEeOFQMzqN4FjzyGwJjQCdRqDVCC5ZlMn6Erty9opZg0mvxWLQ0ezwsLrQRmefd0J3suOhqs1JUYaZ/7x5FRaDlq9dv2xGs7PUCF8xIY439yKBUIwvwuayTB788Fq0GkH6BOSBFYpk4t9fOMaemm563H7e+srWKcuoaXS4+cDD75KZYuRb21bw3/dspDTr/LvBnQ9qhK8YN25fkPcsyWZjiX1EXjnA7poufr2zjjTT/MmvV8w9/mHLQnrcfi5ZnEnhOGtNxqKjz8tnntpPryfAZ7Yu5qJFWVPSJH2iqBG+Ytz4QyGuviCXR986Q0mGebDpyQB3bi7mX64qT5B1CsXUcOHCTF787BaW5KZMOhuox+Xnf96p4fEdZzHpNdx//TK2VeRPkaUTRzl8xbjZWd3JfU/uAyDFpAfCDt+g0/DxS8sSeiErFFPJBVPQPazJ4eZDj+4c7Az379sq2FZRMOn9TobJyiN/UwjRGNWs/IaodfcLIaqEECeFENdO3lRFIvH4gzz21lkgXMpe13VO035Ffhqfv2oJyxbM3RZ7CsVE6ezzce2KBawptPH1G5Zx0+rED4imYoT/EynlD6MXCCEuAO4AVgD5wKtCiCVSyviC4IqkxqTXsq7Ezu6aLtYWpbO/7lxbvgN1Drb+cDsv/POlo/ZgVSjmE6sKbawqtCXajCFM16TtNuBpKaVXSnkWqAI2TdOxFDNAXaeLh/9ejVYjRmjgZ1oNfPfWVcrZzwH6vQFeOtpCj9s/9saKWcdUOPzPCCEOCyEeF0IMlKQVANG93RoiyxSzlIG5qxX5aRyIGt1npRj4j5tXsaU8O0GWKaYSXyBEa68Ht0/djM9FxnT4QohXhRBHYzy2AQ8Bi4AKwo3LfzTwthi7ilnBIIS4TwixVwixt729/Tw/hmK6KbSbWZqbyonmXjZFtd/78rVLuW5lrB734UbnRxt72HWmc6bMVEwSu9XAPReXqoK5Ocqkm5gPIIR4FHgh8rIBiO5bVwg0xdm/amI+CxBCcMXyHM681ceJll7Wl9jJTTXS5PAQCskRsrRSSrafbEdKqXTeFYokYVKTtkKIPCllc+TlzcDRyPPngaeEED8mPGlbDuyezLEUieczWxej1wr21zow6DScaOmlscfN79tfNQAAEC9JREFU1mU5VAzTHRFC8MENc7dXrUIxG5lsDP/7QogjQojDwFbg8wBSymPA74HjwEvAp1WGzuzHatTx2SvKef/aAtqdXs52uHD7gnzjmSPc/+fDvH165uVeFQrF+FENUBTnTa/Hz47THWSlGllVYEOrEYPSrwqFYuYYbwMUVWmrOG/STHquX5WXaDMUCsU4UcMxhUKhmCcoh69QKBTzBOXwFQqFYp6gHL5CoVDME5TDV0w7Xf2+mB2yFArFzKKydBRTjpSS2k4Xnf1eDjf00NXv495LypS4mkKRYJTDV0wZ/mCIX7xRzYtHmnni3k2sL8lgfUnG2G9UzGvanV5STTpMeu20H8vlC9Du9FKSObO9ZJMF5fAVk8YXCPHkzloe2l5NfrqJ61YuIEON5hNGTUc/D22vZn9dNw3dbnRaQVmWlR9/sILFOdOra9TS42F/XTc3jKM+o7PPy8N/r+aJd2sxaDXcfVEJH724FJtFj9sXpNHh5t3qTv5+qp3GbjdlWVbuvLCYrBQjK/Ntg/pNbU4P2yvbsRi1ZFgMtPd5Mem1ZKUYqO9y09DtwheUuH0BKluctDu9PHLXBuxWPd5ACI8/iD8oCUmJTiOwmfWkW+bm9asqbRWT5lfv1vB/njvG564q57NXlI8QUlNMHz0uP29XddDm9HCw3sG71Z109HljNpkH2FhqZ3leGtevzCPDauD1yjbcvgClWVbybGZSjDouyE9DO8b/sM3p4fmDTbxyvBVJeJ6mzxOg2+XDGwiRZzORatLh8YewGLT0eQMUZ1jwB0P0e4N4/EHanF76vIHz+typRh3FmRY0QlDZ0os/OLV+7N9uuoBb1hZis+indL/TxXgrbZXDV5wXJ5p76fMGWFds5yt/PMyf9jewOCeFj15cyraKfFJNs+OLkqxUt/fxs1dPc8niTC5ZnEW6xUCKUUd9l4s3TrbxTlUn1e19VLf3xXXu58uXr13Kp7cujrmu0eHmn36zn0P1jpjr5xqLsq2UZaVQaDdTlGFBK6Ch281Na/JZVWBLmsGNcviKaWX9t16hx+3ne7eu4ot/ODxk3ZpCG7//5EUYddMfk00kwZCksqWXXWe6sBq1XLtiATaznleOt3K2o5/leWmcbHHS0eclGJKkmvRkphi4aXU+aWYd3kCIYEgSCEqaetycae9n55lOajr72VvTjdt/Tm8w1ahjfamdfTXdOM9zVDwebl1XyMcuKWVlQbg1X2eflx+9coquPh+tTg+nWpz0q+YoAJj0GrJSjGwuy+S9a/LYsjgLXYK0pGbE4QshfgcsjbxMBxxSygohRClwAjgZWbdTSvnJsfanHH5y09Dt4o3KNjr7ffz01dMALMy2ctPqfH722ukh226ryOdnd6xNhJkT5lSrk2NNPWwuy+Rkq5NXj7dy05p8vIEQjd1u+r0B1pWk0+jwcLKll4busHMeHkrIsIZH4dEN3mNh1msJSYk3EJrujzZhrlqey0MfWYdeq+HNU+382/PHONvRn2izZgWpRh05aUY0QmDUa9AKQYbVQHluKqsLbbxnSfa03fnOiHialPL2qAP+COiJWl0tpayYzP4VE6O2s58D9Q52VXeSk2YiN82ETiu49oIFI2KRUkoaHW4K7ZZx7/90Wx9d/X5Mei03rcmnOMPM2qL0mKOa1yvb6HH7sZmTM7QTCklOtTl54VAzj7x5Bl9wqPP9za66Ce+zq99HV79vzO2iR+7JRme/l//4ywna+7y8dLSFoKqfGDdObwBn+8i7rzdOtpOTauSJezexPC+x34cpydIRQgjgg8AVU7G/+UJlSy8Ol5+luanYrQaeOdBAV7+fhdlWLlqYiU4j0Gk1OD1+ajtdg7fZ8Xh6Tz0Pba8efL0iP41b1xXy7MFGmns81He56Hb5KLJbaO718NbpdspzUtBrNSxbkEZppoV0q4GyTCtvnm7HFwhh0mspsJu5rDwLu8WA3arnaGMPPW4/b1T28euddTEbXjs9AY409HBpedaUn7fJ4A0E+eLvD7H9ZPt5TxjOZQ7UOYb0LFZMjtw0I2uL7Hz1+mWUZSU+FXRKYvhCiMuAHw/cUkRCOseAU0Av8A0p5Vtj7We2hXSklIQkaDUCp8dPa68Hjz9Eu9PLyVYnx5p6qevsJ82sp88bwKzXYjPrcfmC9HrCo980k55Q5H+g1Qg0QtDr8XOgzkG3y0em1Uhnvxcpw2ESjRAsyU2lNNPCsrw0LAYt7U4vvW4/ZoOWFKOO3TVdPPDM0TGsnx4K7WY++Z5FVBSlj/kDNdO4fAFeO9HGE+/UsLe2O9HmKOYwW8qz+PK1S1m6IHVG5rKmLKQjhHgViNWl+gEp5XOR5x8Cfhu1rhkollJ2CiHWA88KIVZIKXtj7P8+4D6A4uLiscxJGvzBEJf/YDuBUAi9VkOjw810zH939HkHnz93MGZb4ISRlWJkbXE6S3JTKMm0smxBKhfkpSVs4kpKSa87QJfLh9sXpKPPS21nPydanByqd1DZ4lQhCsW088hd67lmRSyXmXgm3cRcCKEDbgHWR73HC3gjz/cJIaqBJcCI4XuyNTHv8wZ4alctpZlWej0Betx+LlmcSSgE9d0ujjb28E51J1VtfTFDGXORhVlWtpRnUVGczop8G/5gCJ1GQ0mmZUaqI+PhC4Q40uhgR1UnLx5ppqazH48/+SZCFfMHQyQ8mqxMRQz/KqBSStkwsEAIkQ10SSmDQoiFhJuYn5mCY005+2q7OVDXTaHdwpbyLFKMOly+ID9+5RSVLc5Em5dw0kw6bliVR7pFT2uvl0sXG8hONU7Z/ntcfn6xvYoTLU56XD4WZadw2/pCLl4cO/b/RmUbv9lVx5mOPuq7XFNecKNQTAZfMMSHH9vJresKWZ6XynUrk6sj3FQ4/DsYGs4BuAz4dyFEAAgCn5RSdk3Bsaac1YU2Klt6+cuRZvbVdvHV65bxuauW8LmrlnCiuZeOPi+97nMVhA6Xj2NNvRysd4wrI2O2o9UI7FYDH724dMzqy+GcaO6lPCclZognEAyx/WQ733j2KC29nsHlhxp6eOFIM4f/7ZqYdw++YIiyLAvluSnYLXqsRh3Vbf08vuPsxD+cQjFFpFv0PHDDcnLTTNjMeooyLKQnYYaaKryKg9sXRAiQEnrc/vCEq0VPr8fP0YYe/nKk+bxS92YrGVYDS3JTyLAaKLJbKM9NpaLIRmmmFZ1WgzcQ5MUjzVS19ZFm0tPt8vP3U+08ctd6ijLOpX6GQpLvvlTJm6fa8fiDGHTh4pX8dDNFdguLcqysyLdRmmkhnPx1jmBI0tHnpbnHQ3e/jx63n67+cEHQ8webaO7xDDdboZh2NAIe/PC6cekHTReq0naSePxB9td28/LxVnZUdXC6rY9Mq4HOeTCqnwgGnYY8W3hUY7cYyLOZKMqwsCQ3lWULUim0m4c4bikl7U4v9d0u6rpcnO1w4fEHCYUkZoOWVJOOnFQTRp2GPx9opLqtj6CU+ALh7KeAmnRVJCE6jeDeS8v40KbimIOV6UY5/CkiFJLc/fhu3q7qSLQps5KSTAuf2LKQmo5+jjb1UNnixOGaH5PdivlJns3E2uJwWvLCrPAda/Rd7nQw7xx+r8fPM/sbKUg30+hwY9RpKM6w8FZVx2CeemaKkU1ldlYXppNnM2ExjD2FEQiGqG7vp7Pfy4E6B4fqHThcfnrcfvyhEKFQePTZpMIJCoUiBia9ho2lGdgtBkoyLawpTKez30uP209umomSTGu46HESkswzIq2QTPx2Vx3f+Wvl2NvtPhd3N0eqSEsyLGSmGEgz6Uk16ZGEww7dLh8GrQaLUYdFr8VuNXDTmnzMei0tvR5aejy0OT2cae9XDl+hUMTE4w/x1unRIwRZKUb2fmPUDPgpYc44/PPB7Q9S1dZHVVtfok1RKBSKaUc1MVcoFIp5gnL4CoVCMU+YMyGdzQsz+dr1yxJthkKhUEwYi2FmJErmjMOvKEqnoig90WYoFApF0qJCOgqFQjFPUA5foVAo5gnK4SsUCsU8QTl8hUKhmCcoh69QKBTzBOXwFQqFYp6QVOJpQoh2oDbRdoxBFjAbpDOVnVPPbLFV2Tn1JLutJVLK7LE2SiqHPxsQQuwdjypdolF2Tj2zxVZl59Qzm2wdDRXSUSgUinmCcvgKhUIxT1AOf+I8kmgDxomyc+qZLbYqO6ee2WRrXFQMX6FQKOYJaoSvUCgU8wTl8OMghPiAEOKYECIkhNgQtbxUCOEWQhyMPB6OWrdeCHFECFElhPgvMUOt6+PZGll3f8Sek0KIa6OWXxdZViWE+NpM2DnMrm8KIRqjzuMNY9mcKBJ9rkZDCFETueYOCiH2RpZlCCFeEUKcjvy1J8i2x4UQbUKIo1HLYtomwvxX5BwfFkKsS7Cds+b6nBBSSvWI8QCWA0uB7cCGqOWlwNE479kNXAQI4K/A9Qm29QLgEGAEyoBqQBt5VAMLAUNkmwtm+Px+E/hSjOUxbU7gdZDwczWGfTVA1rBl3we+Fnn+NeB7CbLtMmBd9Pclnm3ADZHvjAAuBHYl2M5ZcX1O9KFG+HGQUp6QUp4c7/ZCiDwgTUr5rgxfGb8C3j9tBkYxiq3bgKellF4p5VmgCtgUeVRJKc9IKX3A05Ftk4F4NieKZD5X8dgGPBF5/gQzdB0OR0r5JtA1bHE827YBv5JhdgLpke9UouyMR7JdnxNCOfzzo0wIcUAI8XchxJbIsgKgIWqbhsiyRFIA1Ee9HrAp3vKZ5jOR2/fHo8IOyWLbAMlmz3Ak8LIQYp8Q4r7IslwpZTNA5G9OwqwbSTzbkvE8z4brc0LMmY5X54MQ4lVgQYxVD0gpn4vztmagWErZKYRYDzwrhFhB+FZ0OFOWAnWetsazKdYP/ZSna41mM/AQ8K3Icb8F/Ai4l2k+j+dBstkznEuklE1CiBzgFSFEZaINOk+S7TzPlutzQsxrhy+lvOo83uMFvJHn+4QQ1cASwr/0hVGbFgJNU2Fn5FgTtpWwTUVRr6Ntird8yhivzUKIR4EXIi9HszkRJJs9Q5BSNkX+tgkhniEcXmgVQuRJKZsjYZG2hBo5lHi2JdV5llK2DjxP8utzQqiQzgQRQmQLIbSR5wuBcuBM5PbUKYS4MJKdczcQb+Q9UzwP3CGEMAohygjbuhvYA5QLIcqEEAbgjsi2M8aw+OzNwECGRDybE0XCz1U8hBBWIUTqwHPgGsLn8Xngnshm95D46zCaeLY9D9wdyda5EOgZCP0kgll0fU6MRM8aJ+uD8D+5gfBovhX4W2T5rcAxwjP1+4Gbot6zgfCFUQ08SKSwLVG2RtY9ELHnJFFZQ4SzIk5F1j2QgPP7JHAEOEz4S5Q3ls0JvBYSeq5GsWth5Do8FLkmH4gszwReA05H/mYkyL7fEg6B+iPX58fj2UY4VPLzyDk+QlS2WYLsnDXX50QeqtJWoVAo5gkqpKNQKBTzBOXwFQqFYp6gHL5CoVDME5TDVygUinmCcvgKhUIxT1AOX6FQKOYJyuErFArFPEE5fIVCoZgn/H+0WhvEp9EnWwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "world.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "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>pop_est</th>\n",
       "      <th>continent</th>\n",
       "      <th>name</th>\n",
       "      <th>iso_a3</th>\n",
       "      <th>gdp_md_est</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>920938</td>\n",
       "      <td>Oceania</td>\n",
       "      <td>Fiji</td>\n",
       "      <td>FJI</td>\n",
       "      <td>8374.0</td>\n",
       "      <td>MULTIPOLYGON (((180.00000 -16.06713, 180.00000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>53950935</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Tanzania</td>\n",
       "      <td>TZA</td>\n",
       "      <td>150600.0</td>\n",
       "      <td>POLYGON ((33.90371 -0.95000, 34.07262 -1.05982...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>603253</td>\n",
       "      <td>Africa</td>\n",
       "      <td>W. Sahara</td>\n",
       "      <td>ESH</td>\n",
       "      <td>906.5</td>\n",
       "      <td>POLYGON ((-8.66559 27.65643, -8.66512 27.58948...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>35623680</td>\n",
       "      <td>North America</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CAN</td>\n",
       "      <td>1674000.0</td>\n",
       "      <td>MULTIPOLYGON (((-122.84000 49.00000, -122.9742...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>326625791</td>\n",
       "      <td>North America</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>USA</td>\n",
       "      <td>18560000.0</td>\n",
       "      <td>MULTIPOLYGON (((-122.84000 49.00000, -120.0000...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     pop_est      continent                      name iso_a3  gdp_md_est  \\\n",
       "0     920938        Oceania                      Fiji    FJI      8374.0   \n",
       "1   53950935         Africa                  Tanzania    TZA    150600.0   \n",
       "2     603253         Africa                 W. Sahara    ESH       906.5   \n",
       "3   35623680  North America                    Canada    CAN   1674000.0   \n",
       "4  326625791  North America  United States of America    USA  18560000.0   \n",
       "\n",
       "                                            geometry  \n",
       "0  MULTIPOLYGON (((180.00000 -16.06713, 180.00000...  \n",
       "1  POLYGON ((33.90371 -0.95000, 34.07262 -1.05982...  \n",
       "2  POLYGON ((-8.66559 27.65643, -8.66512 27.58948...  \n",
       "3  MULTIPOLYGON (((-122.84000 49.00000, -122.9742...  \n",
       "4  MULTIPOLYGON (((-122.84000 49.00000, -120.0000...  "
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "world.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4383"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "51"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[df.index.isin(world.name)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2816"
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "24"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Colombia', 'Canada', 'Argentina', 'Brazil', 'Cuba', 'Honduras',\n",
       "       'Belize', 'Chile', 'Ecuador', 'Guatemala', 'Costa Rica', 'Haiti',\n",
       "       'Guyana', 'Jamaica', 'Mexico', 'Peru', 'Puerto Rico', 'El Salvador',\n",
       "       'Nicaragua', 'Panama', 'Paraguay', 'Uruguay', 'Trinidad and Tobago',\n",
       "       'Suriname'],\n",
       "      dtype='object', name='Country')"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "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>Dis No</th>\n",
       "      <th>Year</th>\n",
       "      <th>Seq</th>\n",
       "      <th>Disaster Group</th>\n",
       "      <th>Disaster Subgroup</th>\n",
       "      <th>Disaster Type</th>\n",
       "      <th>Disaster Subtype</th>\n",
       "      <th>Disaster Subsubtype</th>\n",
       "      <th>Event Name</th>\n",
       "      <th>Entry Criteria</th>\n",
       "      <th>...</th>\n",
       "      <th>Insured Damages ('000 US$)</th>\n",
       "      <th>Total Damages ('000 US$)</th>\n",
       "      <th>CPI</th>\n",
       "      <th>country</th>\n",
       "      <th>pop_est</th>\n",
       "      <th>continent</th>\n",
       "      <th>name</th>\n",
       "      <th>iso_a3</th>\n",
       "      <th>gdp_md_est</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>1981-0091-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>91</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Geophysical</td>\n",
       "      <td>Earthquake</td>\n",
       "      <td>Ground movement</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>1981-0074-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>74</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>1981-0043-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>43</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>1981-0305-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>305</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Miscellaneous accident</td>\n",
       "      <td>Collapse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stadium</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>1982-0383-COL</td>\n",
       "      <td>1982</td>\n",
       "      <td>383</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.745822</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Suriname</th>\n",
       "      <td>1989-0275-SUR</td>\n",
       "      <td>1989</td>\n",
       "      <td>275</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Air</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dc-8 Jetliner</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.489365</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Suriname</th>\n",
       "      <td>2001-0089-SUR</td>\n",
       "      <td>2001</td>\n",
       "      <td>89</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Air</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nomad aircraft</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.259340</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Suriname</th>\n",
       "      <td>2006-0247-SUR</td>\n",
       "      <td>2006</td>\n",
       "      <td>247</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Affected</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78.852256</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Suriname</th>\n",
       "      <td>2008-0257-SUR</td>\n",
       "      <td>2008</td>\n",
       "      <td>257</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Affected</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.215229</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Suriname</th>\n",
       "      <td>2008-0136-SUR</td>\n",
       "      <td>2008</td>\n",
       "      <td>136</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Air</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bi Moteur Antonov 28</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.215229</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2816 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Dis No  Year  Seq Disaster Group Disaster Subgroup  \\\n",
       "Country                                                               \n",
       "Colombia  1981-0091-COL  1981   91        Natural       Geophysical   \n",
       "Colombia  1981-0074-COL  1981   74        Natural      Hydrological   \n",
       "Colombia  1981-0043-COL  1981   43        Natural      Hydrological   \n",
       "Colombia  1981-0305-COL  1981  305  Technological     Technological   \n",
       "Colombia  1982-0383-COL  1982  383        Natural      Hydrological   \n",
       "...                 ...   ...  ...            ...               ...   \n",
       "Suriname  1989-0275-SUR  1989  275  Technological     Technological   \n",
       "Suriname  2001-0089-SUR  2001   89  Technological     Technological   \n",
       "Suriname  2006-0247-SUR  2006  247        Natural      Hydrological   \n",
       "Suriname  2008-0257-SUR  2008  257        Natural      Hydrological   \n",
       "Suriname  2008-0136-SUR  2008  136  Technological     Technological   \n",
       "\n",
       "                   Disaster Type Disaster Subtype Disaster Subsubtype  \\\n",
       "Country                                                                 \n",
       "Colombia              Earthquake  Ground movement                 NaN   \n",
       "Colombia                   Flood   Riverine flood                 NaN   \n",
       "Colombia               Landslide        Landslide                 NaN   \n",
       "Colombia  Miscellaneous accident         Collapse                 NaN   \n",
       "Colombia               Landslide        Landslide                 NaN   \n",
       "...                          ...              ...                 ...   \n",
       "Suriname      Transport accident              Air                 NaN   \n",
       "Suriname      Transport accident              Air                 NaN   \n",
       "Suriname                   Flood   Riverine flood                 NaN   \n",
       "Suriname                   Flood   Riverine flood                 NaN   \n",
       "Suriname      Transport accident              Air                 NaN   \n",
       "\n",
       "                    Event Name Entry Criteria  ... Insured Damages ('000 US$)  \\\n",
       "Country                                        ...                              \n",
       "Colombia                   NaN           Kill  ...                        NaN   \n",
       "Colombia                   NaN           Kill  ...                        NaN   \n",
       "Colombia                   NaN           Kill  ...                        NaN   \n",
       "Colombia               Stadium           Kill  ...                        NaN   \n",
       "Colombia                   NaN           Kill  ...                        NaN   \n",
       "...                        ...            ...  ...                        ...   \n",
       "Suriname         Dc-8 Jetliner           Kill  ...                        NaN   \n",
       "Suriname        Nomad aircraft           Kill  ...                        NaN   \n",
       "Suriname                   NaN       Affected  ...                        NaN   \n",
       "Suriname                   NaN       Affected  ...                        NaN   \n",
       "Suriname  Bi Moteur Antonov 28           Kill  ...                        NaN   \n",
       "\n",
       "         Total Damages ('000 US$)        CPI   country   pop_est  \\\n",
       "Country                                                            \n",
       "Colombia                   5000.0  35.565172  Colombia  47698524   \n",
       "Colombia                   5000.0  35.565172  Colombia  47698524   \n",
       "Colombia                      NaN  35.565172  Colombia  47698524   \n",
       "Colombia                      NaN  35.565172  Colombia  47698524   \n",
       "Colombia                      NaN  37.745822  Colombia  47698524   \n",
       "...                           ...        ...       ...       ...   \n",
       "Suriname                      NaN  48.489365  Suriname    591919   \n",
       "Suriname                      NaN  69.259340  Suriname    591919   \n",
       "Suriname                      NaN  78.852256  Suriname    591919   \n",
       "Suriname                      NaN  84.215229  Suriname    591919   \n",
       "Suriname                      NaN  84.215229  Suriname    591919   \n",
       "\n",
       "              continent      name iso_a3 gdp_md_est  \\\n",
       "Country                                               \n",
       "Colombia  South America  Colombia    COL   688000.0   \n",
       "Colombia  South America  Colombia    COL   688000.0   \n",
       "Colombia  South America  Colombia    COL   688000.0   \n",
       "Colombia  South America  Colombia    COL   688000.0   \n",
       "Colombia  South America  Colombia    COL   688000.0   \n",
       "...                 ...       ...    ...        ...   \n",
       "Suriname  South America  Suriname    SUR     8547.0   \n",
       "Suriname  South America  Suriname    SUR     8547.0   \n",
       "Suriname  South America  Suriname    SUR     8547.0   \n",
       "Suriname  South America  Suriname    SUR     8547.0   \n",
       "Suriname  South America  Suriname    SUR     8547.0   \n",
       "\n",
       "                                                   geometry  \n",
       "Country                                                      \n",
       "Colombia  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "Colombia  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "Colombia  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "Colombia  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "Colombia  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "...                                                     ...  \n",
       "Suriname  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "Suriname  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "Suriname  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "Suriname  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "Suriname  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "\n",
       "[2816 rows x 49 columns]"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index().merge(world,left_on='Country',right_on='name').set_index('Country')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "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>Dis No</th>\n",
       "      <th>Year</th>\n",
       "      <th>Seq</th>\n",
       "      <th>Disaster Group</th>\n",
       "      <th>Disaster Subgroup</th>\n",
       "      <th>Disaster Type</th>\n",
       "      <th>Disaster Subtype</th>\n",
       "      <th>Disaster Subsubtype</th>\n",
       "      <th>Event Name</th>\n",
       "      <th>Entry Criteria</th>\n",
       "      <th>...</th>\n",
       "      <th>Insured Damages ('000 US$)</th>\n",
       "      <th>Total Damages ('000 US$)</th>\n",
       "      <th>CPI</th>\n",
       "      <th>country</th>\n",
       "      <th>pop_est</th>\n",
       "      <th>continent</th>\n",
       "      <th>name</th>\n",
       "      <th>iso_a3</th>\n",
       "      <th>gdp_md_est</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1981-0091-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>91</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Geophysical</td>\n",
       "      <td>Earthquake</td>\n",
       "      <td>Ground movement</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1981-0074-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>74</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1981-0043-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>43</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1981-0305-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>305</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Miscellaneous accident</td>\n",
       "      <td>Collapse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stadium</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1982-0383-COL</td>\n",
       "      <td>1982</td>\n",
       "      <td>383</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.745822</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Dis No  Year  Seq Disaster Group Disaster Subgroup  \\\n",
       "0  1981-0091-COL  1981   91        Natural       Geophysical   \n",
       "1  1981-0074-COL  1981   74        Natural      Hydrological   \n",
       "2  1981-0043-COL  1981   43        Natural      Hydrological   \n",
       "3  1981-0305-COL  1981  305  Technological     Technological   \n",
       "4  1982-0383-COL  1982  383        Natural      Hydrological   \n",
       "\n",
       "            Disaster Type Disaster Subtype Disaster Subsubtype Event Name  \\\n",
       "0              Earthquake  Ground movement                 NaN        NaN   \n",
       "1                   Flood   Riverine flood                 NaN        NaN   \n",
       "2               Landslide        Landslide                 NaN        NaN   \n",
       "3  Miscellaneous accident         Collapse                 NaN    Stadium   \n",
       "4               Landslide        Landslide                 NaN        NaN   \n",
       "\n",
       "  Entry Criteria  ... Insured Damages ('000 US$) Total Damages ('000 US$)  \\\n",
       "0           Kill  ...                        NaN                   5000.0   \n",
       "1           Kill  ...                        NaN                   5000.0   \n",
       "2           Kill  ...                        NaN                      NaN   \n",
       "3           Kill  ...                        NaN                      NaN   \n",
       "4           Kill  ...                        NaN                      NaN   \n",
       "\n",
       "         CPI   country   pop_est      continent      name iso_a3 gdp_md_est  \\\n",
       "0  35.565172  Colombia  47698524  South America  Colombia    COL   688000.0   \n",
       "1  35.565172  Colombia  47698524  South America  Colombia    COL   688000.0   \n",
       "2  35.565172  Colombia  47698524  South America  Colombia    COL   688000.0   \n",
       "3  35.565172  Colombia  47698524  South America  Colombia    COL   688000.0   \n",
       "4  37.745822  Colombia  47698524  South America  Colombia    COL   688000.0   \n",
       "\n",
       "                                            geometry  \n",
       "0  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "1  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "2  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "3  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "4  POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "\n",
       "[5 rows x 49 columns]"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [],
   "source": [
    "def query_EMDAT(gdf, country, disaster_type, year_min = 1900, year_max = 2021):\n",
    "    return(gdf[(gdf.Year > year_min) & (gdf.Year < year_max) & (gdf.country == country)])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [],
   "source": [
    "columbia_since_1990 = query_EMDAT(gdf, 'Colombia', 1950)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "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>Seq</th>\n",
       "      <th>Aid Contribution</th>\n",
       "      <th>Dis Mag Value</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Start Month</th>\n",
       "      <th>Start Day</th>\n",
       "      <th>End Year</th>\n",
       "      <th>End Month</th>\n",
       "      <th>End Day</th>\n",
       "      <th>Total Deaths</th>\n",
       "      <th>No Injured</th>\n",
       "      <th>No Affected</th>\n",
       "      <th>No Homeless</th>\n",
       "      <th>Total Affected</th>\n",
       "      <th>Reconstruction Costs ('000 US$)</th>\n",
       "      <th>Insured Damages ('000 US$)</th>\n",
       "      <th>Total Damages ('000 US$)</th>\n",
       "      <th>CPI</th>\n",
       "      <th>pop_est</th>\n",
       "      <th>gdp_md_est</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1981</th>\n",
       "      <td>513</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7924</td>\n",
       "      <td>33.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>7924</td>\n",
       "      <td>33.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>142.260686</td>\n",
       "      <td>190794096</td>\n",
       "      <td>2752000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1982</th>\n",
       "      <td>752</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5946</td>\n",
       "      <td>13.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>5946</td>\n",
       "      <td>13.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>113.237466</td>\n",
       "      <td>143095572</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1983</th>\n",
       "      <td>796</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7932</td>\n",
       "      <td>28.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>7932</td>\n",
       "      <td>28.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>427.0</td>\n",
       "      <td>1240.0</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>36740.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>410900.0</td>\n",
       "      <td>155.833517</td>\n",
       "      <td>190794096</td>\n",
       "      <td>2752000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1984</th>\n",
       "      <td>99</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1680.0</td>\n",
       "      <td>1984</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1984</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.633804</td>\n",
       "      <td>47698524</td>\n",
       "      <td>688000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1985</th>\n",
       "      <td>362</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3970</td>\n",
       "      <td>14.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3970</td>\n",
       "      <td>14.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>21839.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>7700.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12700.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>84.149054</td>\n",
       "      <td>95397048</td>\n",
       "      <td>1376000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1986</th>\n",
       "      <td>1667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13902</td>\n",
       "      <td>44.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>13902</td>\n",
       "      <td>44.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>322.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>278000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>278000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>300.111909</td>\n",
       "      <td>333889668</td>\n",
       "      <td>4816000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987</th>\n",
       "      <td>845</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5961</td>\n",
       "      <td>19.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>5961</td>\n",
       "      <td>19.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>674.0</td>\n",
       "      <td>2486.0</td>\n",
       "      <td>4800.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7286.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>133.332715</td>\n",
       "      <td>143095572</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1988</th>\n",
       "      <td>1648</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9940</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>9940</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>308.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>231900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>232700.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>231.282784</td>\n",
       "      <td>238492620</td>\n",
       "      <td>3440000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1989</th>\n",
       "      <td>1067</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7956</td>\n",
       "      <td>32.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>7956</td>\n",
       "      <td>32.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1307.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4307.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23000.0</td>\n",
       "      <td>193.957461</td>\n",
       "      <td>190794096</td>\n",
       "      <td>2752000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1990</th>\n",
       "      <td>3563</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11940</td>\n",
       "      <td>37.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>11940</td>\n",
       "      <td>37.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20625.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20645.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>306.640770</td>\n",
       "      <td>286191144</td>\n",
       "      <td>4128000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1991</th>\n",
       "      <td>3888</td>\n",
       "      <td>0.0</td>\n",
       "      <td>807.0</td>\n",
       "      <td>21901</td>\n",
       "      <td>75.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>21901</td>\n",
       "      <td>75.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>558.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14824.0</td>\n",
       "      <td>295.0</td>\n",
       "      <td>15131.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>585.982723</td>\n",
       "      <td>524683764</td>\n",
       "      <td>7568000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1992</th>\n",
       "      <td>617</td>\n",
       "      <td>150.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5976</td>\n",
       "      <td>21.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>5976</td>\n",
       "      <td>21.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1646.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>164.653927</td>\n",
       "      <td>143095572</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1993</th>\n",
       "      <td>2309</td>\n",
       "      <td>200.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>15944</td>\n",
       "      <td>55.0</td>\n",
       "      <td>152.0</td>\n",
       "      <td>15944</td>\n",
       "      <td>56.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>322.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>86339.0</td>\n",
       "      <td>375.0</td>\n",
       "      <td>86876.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>452.037165</td>\n",
       "      <td>381588192</td>\n",
       "      <td>5504000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994</th>\n",
       "      <td>1175</td>\n",
       "      <td>5577.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9970</td>\n",
       "      <td>13.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>9970</td>\n",
       "      <td>14.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>608.0</td>\n",
       "      <td>21980.0</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>55785.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>289.889871</td>\n",
       "      <td>238492620</td>\n",
       "      <td>3440000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>983</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1118.0</td>\n",
       "      <td>17955</td>\n",
       "      <td>46.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>17955</td>\n",
       "      <td>46.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>14682.0</td>\n",
       "      <td>89250.0</td>\n",
       "      <td>104204.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>104000.0</td>\n",
       "      <td>536.440454</td>\n",
       "      <td>429286716</td>\n",
       "      <td>6192000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>954</td>\n",
       "      <td>0.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>9980</td>\n",
       "      <td>28.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>9980</td>\n",
       "      <td>28.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>183000.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>183310.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>306.758149</td>\n",
       "      <td>238492620</td>\n",
       "      <td>3440000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>1229</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5120.0</td>\n",
       "      <td>5991</td>\n",
       "      <td>21.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>5991</td>\n",
       "      <td>21.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15003.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>188.357506</td>\n",
       "      <td>143095572</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>10057</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7992</td>\n",
       "      <td>28.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>7992</td>\n",
       "      <td>27.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100028.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.041821</td>\n",
       "      <td>190794096</td>\n",
       "      <td>2752000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>2344</td>\n",
       "      <td>32129.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>15992</td>\n",
       "      <td>55.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>15992</td>\n",
       "      <td>55.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>1286.0</td>\n",
       "      <td>8643.0</td>\n",
       "      <td>845200.0</td>\n",
       "      <td>506920.0</td>\n",
       "      <td>1360763.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1857869.0</td>\n",
       "      <td>521.244375</td>\n",
       "      <td>381588192</td>\n",
       "      <td>5504000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>2151</td>\n",
       "      <td>9.0</td>\n",
       "      <td>200007.0</td>\n",
       "      <td>12000</td>\n",
       "      <td>44.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>12000</td>\n",
       "      <td>44.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>40430.0</td>\n",
       "      <td>39000.0</td>\n",
       "      <td>79457.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>404.134554</td>\n",
       "      <td>286191144</td>\n",
       "      <td>4128000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>4498</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>20010</td>\n",
       "      <td>79.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>20010</td>\n",
       "      <td>79.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>247.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>13747.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>692.593400</td>\n",
       "      <td>476985240</td>\n",
       "      <td>6880000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>3327</td>\n",
       "      <td>0.0</td>\n",
       "      <td>852950.0</td>\n",
       "      <td>14014</td>\n",
       "      <td>43.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>14014</td>\n",
       "      <td>44.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>124525.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>126538.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>492.504733</td>\n",
       "      <td>333889668</td>\n",
       "      <td>4816000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>2106</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3350.0</td>\n",
       "      <td>10015</td>\n",
       "      <td>28.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>10015</td>\n",
       "      <td>32.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>40395.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>40579.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>359.775033</td>\n",
       "      <td>238492620</td>\n",
       "      <td>3440000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>2803</td>\n",
       "      <td>0.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>12024</td>\n",
       "      <td>50.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>12024</td>\n",
       "      <td>55.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>539378.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>540049.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>443.288475</td>\n",
       "      <td>286191144</td>\n",
       "      <td>4128000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>3629</td>\n",
       "      <td>154.0</td>\n",
       "      <td>115375.0</td>\n",
       "      <td>22055</td>\n",
       "      <td>63.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>22055</td>\n",
       "      <td>66.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>395.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>604688.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>605028.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>840.268299</td>\n",
       "      <td>524683764</td>\n",
       "      <td>7568000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>674</td>\n",
       "      <td>663.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6018</td>\n",
       "      <td>11.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>6018</td>\n",
       "      <td>18.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>238238.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>238465.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>236.556767</td>\n",
       "      <td>143095572</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>3264</td>\n",
       "      <td>5700.0</td>\n",
       "      <td>291407.0</td>\n",
       "      <td>24084</td>\n",
       "      <td>61.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>24084</td>\n",
       "      <td>69.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>375.0</td>\n",
       "      <td>353.0</td>\n",
       "      <td>2672397.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2674750.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>973.219907</td>\n",
       "      <td>572382288</td>\n",
       "      <td>8256000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>3119</td>\n",
       "      <td>3590.0</td>\n",
       "      <td>195406.0</td>\n",
       "      <td>18072</td>\n",
       "      <td>56.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>18073</td>\n",
       "      <td>48.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>1222351.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>1224240.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>757.937062</td>\n",
       "      <td>429286716</td>\n",
       "      <td>6192000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>833</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72650.0</td>\n",
       "      <td>8036</td>\n",
       "      <td>13.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>8036</td>\n",
       "      <td>13.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>31250.0</td>\n",
       "      <td>593.0</td>\n",
       "      <td>31850.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>335.663230</td>\n",
       "      <td>190794096</td>\n",
       "      <td>2752000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>3844</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1140146.0</td>\n",
       "      <td>22110</td>\n",
       "      <td>71.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>22111</td>\n",
       "      <td>73.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>755.0</td>\n",
       "      <td>636.0</td>\n",
       "      <td>2796300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2796936.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>938.212667</td>\n",
       "      <td>524683764</td>\n",
       "      <td>7568000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>1631</td>\n",
       "      <td>0.0</td>\n",
       "      <td>293280.0</td>\n",
       "      <td>12066</td>\n",
       "      <td>40.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>12066</td>\n",
       "      <td>46.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>368.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>1487436.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>1487880.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>41000.0</td>\n",
       "      <td>2320000.0</td>\n",
       "      <td>527.907618</td>\n",
       "      <td>286191144</td>\n",
       "      <td>4128000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>1750</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74036.0</td>\n",
       "      <td>12072</td>\n",
       "      <td>37.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>12072</td>\n",
       "      <td>41.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>96735.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>104768.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>538.831758</td>\n",
       "      <td>286191144</td>\n",
       "      <td>4128000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>1071</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6039</td>\n",
       "      <td>18.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>6039</td>\n",
       "      <td>24.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>62452.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>62967.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>273.362382</td>\n",
       "      <td>143095572</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>3400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>406009.0</td>\n",
       "      <td>22154</td>\n",
       "      <td>72.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>22154</td>\n",
       "      <td>75.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>72214.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72292.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1018.588786</td>\n",
       "      <td>524683764</td>\n",
       "      <td>7568000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>10786</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14105</td>\n",
       "      <td>41.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14106</td>\n",
       "      <td>34.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>48940.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>49703.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>648.961754</td>\n",
       "      <td>333889668</td>\n",
       "      <td>4816000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>2295</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14112</td>\n",
       "      <td>41.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>14113</td>\n",
       "      <td>43.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2272.0</td>\n",
       "      <td>2290.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>657.149055</td>\n",
       "      <td>333889668</td>\n",
       "      <td>4816000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>3053</td>\n",
       "      <td>0.0</td>\n",
       "      <td>245918.0</td>\n",
       "      <td>22187</td>\n",
       "      <td>66.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>22187</td>\n",
       "      <td>69.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>441.0</td>\n",
       "      <td>469.0</td>\n",
       "      <td>76186.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>76781.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>104000.0</td>\n",
       "      <td>1054.659824</td>\n",
       "      <td>524683764</td>\n",
       "      <td>7568000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>559</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8072</td>\n",
       "      <td>15.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>8072</td>\n",
       "      <td>16.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>392.879962</td>\n",
       "      <td>190794096</td>\n",
       "      <td>2752000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>2974</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20190</td>\n",
       "      <td>52.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>20190</td>\n",
       "      <td>60.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>79644.0</td>\n",
       "      <td>39682.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>119541.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>476985240</td>\n",
       "      <td>6880000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020</th>\n",
       "      <td>2667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16160</td>\n",
       "      <td>60.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>16160</td>\n",
       "      <td>60.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>152.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>352417.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>352446.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>381588192</td>\n",
       "      <td>5504000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Seq  Aid Contribution  Dis Mag Value  Start Year  Start Month  \\\n",
       "Year                                                                    \n",
       "1981    513               0.0            5.0        7924         33.0   \n",
       "1982    752               0.0            0.0        5946         13.0   \n",
       "1983    796               0.0            5.0        7932         28.0   \n",
       "1984     99               0.0         1680.0        1984         11.0   \n",
       "1985    362               0.0            0.0        3970         14.0   \n",
       "1986   1667               0.0            0.0       13902         44.0   \n",
       "1987    845               0.0            0.0        5961         19.0   \n",
       "1988   1648               0.0            0.0        9940         34.0   \n",
       "1989   1067               0.0            0.0        7956         32.0   \n",
       "1990   3563               0.0            0.0       11940         37.0   \n",
       "1991   3888               0.0          807.0       21901         75.0   \n",
       "1992    617             150.0            7.0        5976         21.0   \n",
       "1993   2309             200.0           26.0       15944         55.0   \n",
       "1994   1175            5577.0            6.0        9970         13.0   \n",
       "1995    983              20.0         1118.0       17955         46.0   \n",
       "1996    954               0.0          700.0        9980         28.0   \n",
       "1997   1229               0.0         5120.0        5991         21.0   \n",
       "1998  10057               0.0            0.0        7992         28.0   \n",
       "1999   2344           32129.0            6.0       15992         55.0   \n",
       "2000   2151               9.0       200007.0       12000         44.0   \n",
       "2001   4498               0.0          170.0       20010         79.0   \n",
       "2002   3327               0.0       852950.0       14014         43.0   \n",
       "2003   2106               0.0         3350.0       10015         28.0   \n",
       "2004   2803               0.0          120.0       12024         50.0   \n",
       "2005   3629             154.0       115375.0       22055         63.0   \n",
       "2006    674             663.0            0.0        6018         11.0   \n",
       "2007   3264            5700.0       291407.0       24084         61.0   \n",
       "2008   3119            3590.0       195406.0       18072         56.0   \n",
       "2009    833               0.0        72650.0        8036         13.0   \n",
       "2010   3844               0.0      1140146.0       22110         71.0   \n",
       "2011   1631               0.0       293280.0       12066         40.0   \n",
       "2012   1750               0.0        74036.0       12072         37.0   \n",
       "2013   1071               0.0            7.0        6039         18.0   \n",
       "2014   3400               0.0       406009.0       22154         72.0   \n",
       "2015  10786               0.0            6.0       14105         41.0   \n",
       "2016   2295               0.0            0.0       14112         41.0   \n",
       "2017   3053               0.0       245918.0       22187         66.0   \n",
       "2018    559               0.0            0.0        8072         15.0   \n",
       "2019   2974               0.0            0.0       20190         52.0   \n",
       "2020   2667               0.0            0.0       16160         60.0   \n",
       "\n",
       "      Start Day  End Year  End Month  End Day  Total Deaths  No Injured  \\\n",
       "Year                                                                      \n",
       "1981       53.0      7924       33.0     53.0         242.0         0.0   \n",
       "1982       22.0      5946       13.0     22.0         144.0       250.0   \n",
       "1983       76.0      7932       28.0     76.0         427.0      1240.0   \n",
       "1984        0.0      1984       11.0      0.0           0.0         0.0   \n",
       "1985       13.0      3970       14.0     13.0       21839.0      5000.0   \n",
       "1986       56.0     13902       44.0     56.0         322.0         0.0   \n",
       "1987       47.0      5961       19.0     47.0         674.0      2486.0   \n",
       "1988       79.0      9940       34.0     79.0         308.0       800.0   \n",
       "1989       83.0      7956       32.0     83.0         200.0      1307.0   \n",
       "1990      150.0     11940       37.0    150.0          95.0        20.0   \n",
       "1991       84.0     21901       75.0     88.0         558.0        12.0   \n",
       "1992       46.0      5976       21.0     46.0          66.0       146.0   \n",
       "1993      152.0     15944       56.0    127.0         322.0       162.0   \n",
       "1994       65.0      9970       14.0     36.0         311.0       608.0   \n",
       "1995      130.0     17955       46.0    130.0         373.0       272.0   \n",
       "1996       50.0      9980       28.0     50.0          93.0         0.0   \n",
       "1997       38.0      5991       21.0     40.0          55.0         3.0   \n",
       "1998       69.0      7992       27.0     69.0         172.0        28.0   \n",
       "1999       87.0     15992       55.0    102.0        1286.0      8643.0   \n",
       "2000       70.0     12000       44.0     76.0         153.0        27.0   \n",
       "2001      113.0     20010       79.0    113.0         163.0       247.0   \n",
       "2002      101.0     14014       44.0    120.0         252.0        13.0   \n",
       "2003       76.0     10015       32.0     92.0         127.0       124.0   \n",
       "2004       86.0     12024       55.0    129.0         143.0       171.0   \n",
       "2005      192.0     22055       66.0    204.0         395.0       340.0   \n",
       "2006       41.0      6018       18.0     51.0         150.0       227.0   \n",
       "2007      165.0     24084       69.0    163.0         375.0       353.0   \n",
       "2008      170.0     18073       48.0    170.0         176.0       189.0   \n",
       "2009       48.0      8036       13.0     50.0          83.0         7.0   \n",
       "2010      122.0     22111       73.0    146.0         755.0       636.0   \n",
       "2011       73.0     12066       46.0    103.0         368.0       378.0   \n",
       "2012       87.0     12072       41.0    106.0         106.0        33.0   \n",
       "2013       24.0      6039       24.0     10.0          98.0        15.0   \n",
       "2014      157.0     22154       75.0    177.0         181.0        78.0   \n",
       "2015       94.0     14106       34.0     79.0         129.0        63.0   \n",
       "2016      108.0     14113       43.0    101.0         150.0        18.0   \n",
       "2017      196.0     22187       69.0    162.0         441.0       469.0   \n",
       "2018       45.0      8072       16.0     68.0          46.0         8.0   \n",
       "2019      165.0     20190       60.0    205.0         305.0     79644.0   \n",
       "2020      105.0     16160       60.0    123.0         152.0        29.0   \n",
       "\n",
       "      No Affected  No Homeless  Total Affected  \\\n",
       "Year                                             \n",
       "1981      14000.0          0.0         14000.0   \n",
       "1982          0.0          0.0           250.0   \n",
       "1983      35000.0        500.0         36740.0   \n",
       "1984          0.0          0.0             0.0   \n",
       "1985       7700.0          0.0         12700.0   \n",
       "1986     278000.0          0.0        278000.0   \n",
       "1987       4800.0          0.0          7286.0   \n",
       "1988     231900.0          0.0        232700.0   \n",
       "1989       3000.0          0.0          4307.0   \n",
       "1990      20625.0          0.0         20645.0   \n",
       "1991      14824.0        295.0         15131.0   \n",
       "1992          0.0       1500.0          1646.0   \n",
       "1993      86339.0        375.0         86876.0   \n",
       "1994      21980.0      33197.0         55785.0   \n",
       "1995      14682.0      89250.0        104204.0   \n",
       "1996     183000.0        310.0        183310.0   \n",
       "1997      15000.0          0.0         15003.0   \n",
       "1998     100000.0          0.0        100028.0   \n",
       "1999     845200.0     506920.0       1360763.0   \n",
       "2000      40430.0      39000.0         79457.0   \n",
       "2001       6000.0       7500.0         13747.0   \n",
       "2002     124525.0       2000.0        126538.0   \n",
       "2003      40395.0         60.0         40579.0   \n",
       "2004     539378.0        500.0        540049.0   \n",
       "2005     604688.0          0.0        605028.0   \n",
       "2006     238238.0          0.0        238465.0   \n",
       "2007    2672397.0       2000.0       2674750.0   \n",
       "2008    1222351.0       1700.0       1224240.0   \n",
       "2009      31250.0        593.0         31850.0   \n",
       "2010    2796300.0          0.0       2796936.0   \n",
       "2011    1487436.0         66.0       1487880.0   \n",
       "2012      96735.0       8000.0        104768.0   \n",
       "2013      62452.0        500.0         62967.0   \n",
       "2014      72214.0          0.0         72292.0   \n",
       "2015      48940.0        700.0         49703.0   \n",
       "2016          0.0       2272.0          2290.0   \n",
       "2017      76186.0        126.0         76781.0   \n",
       "2018      60000.0          0.0         60008.0   \n",
       "2019      39682.0        215.0        119541.0   \n",
       "2020     352417.0          0.0        352446.0   \n",
       "\n",
       "      Reconstruction Costs ('000 US$)  Insured Damages ('000 US$)  \\\n",
       "Year                                                                \n",
       "1981                              0.0                         0.0   \n",
       "1982                              0.0                         0.0   \n",
       "1983                              0.0                         0.0   \n",
       "1984                              0.0                         0.0   \n",
       "1985                              0.0                         0.0   \n",
       "1986                              0.0                         0.0   \n",
       "1987                              0.0                         0.0   \n",
       "1988                              0.0                         0.0   \n",
       "1989                              0.0                         0.0   \n",
       "1990                              0.0                         0.0   \n",
       "1991                              0.0                         0.0   \n",
       "1992                              0.0                         0.0   \n",
       "1993                              0.0                         0.0   \n",
       "1994                              0.0                         0.0   \n",
       "1995                              0.0                         0.0   \n",
       "1996                              0.0                         0.0   \n",
       "1997                              0.0                         0.0   \n",
       "1998                              0.0                         0.0   \n",
       "1999                              0.0                    100000.0   \n",
       "2000                              0.0                         0.0   \n",
       "2001                              0.0                         0.0   \n",
       "2002                              0.0                         0.0   \n",
       "2003                              0.0                         0.0   \n",
       "2004                              0.0                         0.0   \n",
       "2005                              0.0                         0.0   \n",
       "2006                              0.0                         0.0   \n",
       "2007                              0.0                         0.0   \n",
       "2008                              0.0                         0.0   \n",
       "2009                              0.0                         0.0   \n",
       "2010                              0.0                     14000.0   \n",
       "2011                              0.0                     41000.0   \n",
       "2012                              0.0                         0.0   \n",
       "2013                              0.0                         0.0   \n",
       "2014                              0.0                         0.0   \n",
       "2015                              0.0                         0.0   \n",
       "2016                              0.0                         0.0   \n",
       "2017                              0.0                         0.0   \n",
       "2018                              0.0                         0.0   \n",
       "2019                              0.0                         0.0   \n",
       "2020                              0.0                         0.0   \n",
       "\n",
       "      Total Damages ('000 US$)          CPI    pop_est  gdp_md_est  \n",
       "Year                                                                \n",
       "1981                   10000.0   142.260686  190794096   2752000.0  \n",
       "1982                       0.0   113.237466  143095572   2064000.0  \n",
       "1983                  410900.0   155.833517  190794096   2752000.0  \n",
       "1984                       0.0    40.633804   47698524    688000.0  \n",
       "1985                 1000000.0    84.149054   95397048   1376000.0  \n",
       "1986                    2500.0   300.111909  333889668   4816000.0  \n",
       "1987                       0.0   133.332715  143095572   2064000.0  \n",
       "1988                   50000.0   231.282784  238492620   3440000.0  \n",
       "1989                   23000.0   193.957461  190794096   2752000.0  \n",
       "1990                       0.0   306.640770  286191144   4128000.0  \n",
       "1991                     400.0   585.982723  524683764   7568000.0  \n",
       "1992                       0.0   164.653927  143095572   2064000.0  \n",
       "1993                       0.0   452.037165  381588192   5504000.0  \n",
       "1994                    2400.0   289.889871  238492620   3440000.0  \n",
       "1995                  104000.0   536.440454  429286716   6192000.0  \n",
       "1996                       0.0   306.758149  238492620   3440000.0  \n",
       "1997                    3000.0   188.357506  143095572   2064000.0  \n",
       "1998                       0.0   255.041821  190794096   2752000.0  \n",
       "1999                 1857869.0   521.244375  381588192   5504000.0  \n",
       "2000                       0.0   404.134554  286191144   4128000.0  \n",
       "2001                       0.0   692.593400  476985240   6880000.0  \n",
       "2002                       0.0   492.504733  333889668   4816000.0  \n",
       "2003                       0.0   359.775033  238492620   3440000.0  \n",
       "2004                       0.0   443.288475  286191144   4128000.0  \n",
       "2005                   10000.0   840.268299  524683764   7568000.0  \n",
       "2006                       0.0   236.556767  143095572   2064000.0  \n",
       "2007                       0.0   973.219907  572382288   8256000.0  \n",
       "2008                   10000.0   757.937062  429286716   6192000.0  \n",
       "2009                       0.0   335.663230  190794096   2752000.0  \n",
       "2010                 1000000.0   938.212667  524683764   7568000.0  \n",
       "2011                 2320000.0   527.907618  286191144   4128000.0  \n",
       "2012                  102000.0   538.831758  286191144   4128000.0  \n",
       "2013                    6000.0   273.362382  143095572   2064000.0  \n",
       "2014                    8000.0  1018.588786  524683764   7568000.0  \n",
       "2015                       0.0   648.961754  333889668   4816000.0  \n",
       "2016                       0.0   657.149055  333889668   4816000.0  \n",
       "2017                  104000.0  1054.659824  524683764   7568000.0  \n",
       "2018                       0.0   392.879962  190794096   2752000.0  \n",
       "2019                       0.0  1000.000000  476985240   6880000.0  \n",
       "2020                       0.0     0.000000  381588192   5504000.0  "
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columbia_since_1990.groupby(\"Year\").sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                              Colombia/Venezuela border\n",
       "1                                         East, Calimina\n",
       "2                                     Northern provinces\n",
       "3                                                 Ibague\n",
       "4                                                    NaN\n",
       "                             ...                        \n",
       "247                        Magdalena, Bolivar, Atlantico\n",
       "248                          Between Guaviare and Vaupès\n",
       "249                                             Cucunuba\n",
       "250                                 Magdalena department\n",
       "251    Antioquia, Meta, Putumayo, Tolima, Choco, Cald...\n",
       "Name: Location, Length: 252, dtype: object"
      ]
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columbia_since_1990.Location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "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>Dis No</th>\n",
       "      <th>Year</th>\n",
       "      <th>Seq</th>\n",
       "      <th>Disaster Group</th>\n",
       "      <th>Disaster Subgroup</th>\n",
       "      <th>Disaster Type</th>\n",
       "      <th>Disaster Subtype</th>\n",
       "      <th>Disaster Subsubtype</th>\n",
       "      <th>Event Name</th>\n",
       "      <th>Entry Criteria</th>\n",
       "      <th>...</th>\n",
       "      <th>Insured Damages ('000 US$)</th>\n",
       "      <th>Total Damages ('000 US$)</th>\n",
       "      <th>CPI</th>\n",
       "      <th>country</th>\n",
       "      <th>pop_est</th>\n",
       "      <th>continent</th>\n",
       "      <th>name</th>\n",
       "      <th>iso_a3</th>\n",
       "      <th>gdp_md_est</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1981-0091-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>91</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Geophysical</td>\n",
       "      <td>Earthquake</td>\n",
       "      <td>Ground movement</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1981-0074-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>74</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1981-0043-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>43</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1981-0305-COL</td>\n",
       "      <td>1981</td>\n",
       "      <td>305</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Miscellaneous accident</td>\n",
       "      <td>Collapse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stadium</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.565172</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1982-0383-COL</td>\n",
       "      <td>1982</td>\n",
       "      <td>383</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.745822</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>47698524</td>\n",
       "      <td>South America</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>688000.0</td>\n",
       "      <td>POLYGON ((-66.87633 1.25336, -67.06505 1.13011...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>1989-0275-SUR</td>\n",
       "      <td>1989</td>\n",
       "      <td>275</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Air</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dc-8 Jetliner</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.489365</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2812</th>\n",
       "      <td>2001-0089-SUR</td>\n",
       "      <td>2001</td>\n",
       "      <td>89</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Air</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nomad aircraft</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.259340</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>2006-0247-SUR</td>\n",
       "      <td>2006</td>\n",
       "      <td>247</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Affected</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78.852256</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814</th>\n",
       "      <td>2008-0257-SUR</td>\n",
       "      <td>2008</td>\n",
       "      <td>257</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Flood</td>\n",
       "      <td>Riverine flood</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Affected</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.215229</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2815</th>\n",
       "      <td>2008-0136-SUR</td>\n",
       "      <td>2008</td>\n",
       "      <td>136</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Technological</td>\n",
       "      <td>Transport accident</td>\n",
       "      <td>Air</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bi Moteur Antonov 28</td>\n",
       "      <td>Kill</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.215229</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>591919</td>\n",
       "      <td>South America</td>\n",
       "      <td>Suriname</td>\n",
       "      <td>SUR</td>\n",
       "      <td>8547.0</td>\n",
       "      <td>POLYGON ((-54.52475 2.31185, -55.09759 2.52375...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2816 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Dis No  Year  Seq Disaster Group Disaster Subgroup  \\\n",
       "0     1981-0091-COL  1981   91        Natural       Geophysical   \n",
       "1     1981-0074-COL  1981   74        Natural      Hydrological   \n",
       "2     1981-0043-COL  1981   43        Natural      Hydrological   \n",
       "3     1981-0305-COL  1981  305  Technological     Technological   \n",
       "4     1982-0383-COL  1982  383        Natural      Hydrological   \n",
       "...             ...   ...  ...            ...               ...   \n",
       "2811  1989-0275-SUR  1989  275  Technological     Technological   \n",
       "2812  2001-0089-SUR  2001   89  Technological     Technological   \n",
       "2813  2006-0247-SUR  2006  247        Natural      Hydrological   \n",
       "2814  2008-0257-SUR  2008  257        Natural      Hydrological   \n",
       "2815  2008-0136-SUR  2008  136  Technological     Technological   \n",
       "\n",
       "               Disaster Type Disaster Subtype Disaster Subsubtype  \\\n",
       "0                 Earthquake  Ground movement                 NaN   \n",
       "1                      Flood   Riverine flood                 NaN   \n",
       "2                  Landslide        Landslide                 NaN   \n",
       "3     Miscellaneous accident         Collapse                 NaN   \n",
       "4                  Landslide        Landslide                 NaN   \n",
       "...                      ...              ...                 ...   \n",
       "2811      Transport accident              Air                 NaN   \n",
       "2812      Transport accident              Air                 NaN   \n",
       "2813                   Flood   Riverine flood                 NaN   \n",
       "2814                   Flood   Riverine flood                 NaN   \n",
       "2815      Transport accident              Air                 NaN   \n",
       "\n",
       "                Event Name Entry Criteria  ... Insured Damages ('000 US$)  \\\n",
       "0                      NaN           Kill  ...                        NaN   \n",
       "1                      NaN           Kill  ...                        NaN   \n",
       "2                      NaN           Kill  ...                        NaN   \n",
       "3                  Stadium           Kill  ...                        NaN   \n",
       "4                      NaN           Kill  ...                        NaN   \n",
       "...                    ...            ...  ...                        ...   \n",
       "2811         Dc-8 Jetliner           Kill  ...                        NaN   \n",
       "2812        Nomad aircraft           Kill  ...                        NaN   \n",
       "2813                   NaN       Affected  ...                        NaN   \n",
       "2814                   NaN       Affected  ...                        NaN   \n",
       "2815  Bi Moteur Antonov 28           Kill  ...                        NaN   \n",
       "\n",
       "     Total Damages ('000 US$)        CPI   country   pop_est      continent  \\\n",
       "0                      5000.0  35.565172  Colombia  47698524  South America   \n",
       "1                      5000.0  35.565172  Colombia  47698524  South America   \n",
       "2                         NaN  35.565172  Colombia  47698524  South America   \n",
       "3                         NaN  35.565172  Colombia  47698524  South America   \n",
       "4                         NaN  37.745822  Colombia  47698524  South America   \n",
       "...                       ...        ...       ...       ...            ...   \n",
       "2811                      NaN  48.489365  Suriname    591919  South America   \n",
       "2812                      NaN  69.259340  Suriname    591919  South America   \n",
       "2813                      NaN  78.852256  Suriname    591919  South America   \n",
       "2814                      NaN  84.215229  Suriname    591919  South America   \n",
       "2815                      NaN  84.215229  Suriname    591919  South America   \n",
       "\n",
       "          name iso_a3 gdp_md_est  \\\n",
       "0     Colombia    COL   688000.0   \n",
       "1     Colombia    COL   688000.0   \n",
       "2     Colombia    COL   688000.0   \n",
       "3     Colombia    COL   688000.0   \n",
       "4     Colombia    COL   688000.0   \n",
       "...        ...    ...        ...   \n",
       "2811  Suriname    SUR     8547.0   \n",
       "2812  Suriname    SUR     8547.0   \n",
       "2813  Suriname    SUR     8547.0   \n",
       "2814  Suriname    SUR     8547.0   \n",
       "2815  Suriname    SUR     8547.0   \n",
       "\n",
       "                                               geometry  \n",
       "0     POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "1     POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "2     POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "3     POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "4     POLYGON ((-66.87633 1.25336, -67.06505 1.13011...  \n",
       "...                                                 ...  \n",
       "2811  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "2812  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "2813  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "2814  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "2815  POLYGON ((-54.52475 2.31185, -55.09759 2.52375...  \n",
       "\n",
       "[2816 rows x 49 columns]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "GPD3",
   "language": "python",
   "name": "gpd3"
  },
  "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}