ex05-Filtering a Query with WHERE.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ex05-Filtering a Query with WHERE\n",
    "\n",
    "Sometimes, you’ll want to only check the rows returned by a query, where one or more columns meet certain criteria. This can be done with a WHERE statement. The WHERE clause is an optional clause of the SELECT statement. It appears after the FROM clause as the following statement:\n",
    ">SELECT column_list FROM table_name WHERE search_condition;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext sql"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Connet to the given database of demo.db3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'Connected: @data/demo.db3'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql sqlite:///data/demo.db3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If you do not remember the tables in the demo data, you can always use the follow command to query. Here we select the table of watershed_yearly as an example."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>rch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>watershed_monthly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>watershed_yearly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>rch_info</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>ave_monthly_basin</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(u'rch',),\n",
       " (u'watershed_monthly',),\n",
       " (u'watershed_yearly',),\n",
       " (u'rch_info',),\n",
       " (u'ave_monthly_basin',)]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT name FROM sqlite_master WHERE type='table'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2. Retrieving data with WHERE\n",
    "\n",
    "Take the table of ***rch*** as an example.\n",
    "\n",
    "#### 2.1 Check the table colums firstly."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "        <th>EVAPcms</th>\n",
       "        <th>TLOSScms</th>\n",
       "        <th>SED_INtons</th>\n",
       "        <th>SED_OUTtons</th>\n",
       "        <th>SEDCONCmg_kg</th>\n",
       "        <th>ORGN_INkg</th>\n",
       "        <th>ORGN_OUTkg</th>\n",
       "        <th>ORGP_INkg</th>\n",
       "        <th>ORGP_OUTkg</th>\n",
       "        <th>NO3_INkg</th>\n",
       "        <th>NO3_OUTkg</th>\n",
       "        <th>NH4_INkg</th>\n",
       "        <th>NH4_OUTkg</th>\n",
       "        <th>NO2_INkg</th>\n",
       "        <th>NO2_OUTkg</th>\n",
       "        <th>MINP_INkg</th>\n",
       "        <th>MINP_OUTkg</th>\n",
       "        <th>CHLA_INkg</th>\n",
       "        <th>CHLA_OUTkg</th>\n",
       "        <th>CBOD_INkg</th>\n",
       "        <th>CBOD_OUTkg</th>\n",
       "        <th>DISOX_INkg</th>\n",
       "        <th>DISOX_OUTkg</th>\n",
       "        <th>SOLPST_INmg</th>\n",
       "        <th>SOLPST_OUTmg</th>\n",
       "        <th>SORPST_INmg</th>\n",
       "        <th>SORPST_OUTmg</th>\n",
       "        <th>REACTPSTmg</th>\n",
       "        <th>VOLPSTmg</th>\n",
       "        <th>SETTLPSTmg</th>\n",
       "        <th>RESUSP_PSTmg</th>\n",
       "        <th>DIFFUSEPSTmg</th>\n",
       "        <th>REACBEDPSTmg</th>\n",
       "        <th>BURYPSTmg</th>\n",
       "        <th>BED_PSTmg</th>\n",
       "        <th>BACTP_OUTct</th>\n",
       "        <th>BACTLP_OUTct</th>\n",
       "        <th>CMETAL_1kg</th>\n",
       "        <th>CMETAL_2kg</th>\n",
       "        <th>CMETAL_3kg</th>\n",
       "        <th>TOT_Nkg</th>\n",
       "        <th>TOT_Pkg</th>\n",
       "        <th>NO3ConcMg_l</th>\n",
       "        <th>WTMPdegc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>146.343765259</td>\n",
       "        <td>146.252487183</td>\n",
       "        <td>0.0912808850408</td>\n",
       "        <td>0.0</td>\n",
       "        <td>2.33204616507e-07</td>\n",
       "        <td>61619.4648438</td>\n",
       "        <td>155.371902466</td>\n",
       "        <td>0.0160862877965</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0482588782907</td>\n",
       "        <td>0.0</td>\n",
       "        <td>362.048675537</td>\n",
       "        <td>361.81350708</td>\n",
       "        <td>203.620849609</td>\n",
       "        <td>421.183776855</td>\n",
       "        <td>0.0</td>\n",
       "        <td>23.0184326172</td>\n",
       "        <td>0.0161072444171</td>\n",
       "        <td>0.0</td>\n",
       "        <td>1.18390523079e-11</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>5627225.0</td>\n",
       "        <td>5623486.5</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>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>806.01574707</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>96.225692749</td>\n",
       "        <td>96.1828536987</td>\n",
       "        <td>0.0428212843835</td>\n",
       "        <td>0.0</td>\n",
       "        <td>1.64267646596e-07</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0136315366253</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0408946201205</td>\n",
       "        <td>0.0</td>\n",
       "        <td>315.600524902</td>\n",
       "        <td>315.457977295</td>\n",
       "        <td>0.0</td>\n",
       "        <td>127.005020142</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0136560499668</td>\n",
       "        <td>0.0</td>\n",
       "        <td>4.13697217716e-16</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>3757606.5</td>\n",
       "        <td>3698301.5</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>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>442.463012695</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>11.9527187347</td>\n",
       "        <td>11.8613681793</td>\n",
       "        <td>0.0913518294692</td>\n",
       "        <td>0.0</td>\n",
       "        <td>2.03258238685e-07</td>\n",
       "        <td>2.03258238685e-07</td>\n",
       "        <td>6.59506094181e-09</td>\n",
       "        <td>0.0114662880078</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0343988612294</td>\n",
       "        <td>0.00911803822964</td>\n",
       "        <td>48.2963752747</td>\n",
       "        <td>47.9315032959</td>\n",
       "        <td>0.0</td>\n",
       "        <td>62.4676208496</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0114851053804</td>\n",
       "        <td>0.0</td>\n",
       "        <td>5.9410287833e-14</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>360979.90625</td>\n",
       "        <td>456115.90625</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>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>110.399124146</td>\n",
       "        <td>0.00911803822964</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>49.486492157</td>\n",
       "        <td>49.4065132141</td>\n",
       "        <td>0.0799834057689</td>\n",
       "        <td>0.0</td>\n",
       "        <td>3.91322672044e-08</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.00722243869677</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.021667316556</td>\n",
       "        <td>0.0</td>\n",
       "        <td>46.5427055359</td>\n",
       "        <td>46.468952179</td>\n",
       "        <td>0.0</td>\n",
       "        <td>76.615852356</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.00724229309708</td>\n",
       "        <td>0.0</td>\n",
       "        <td>1.16327894498e-15</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>1160040.75</td>\n",
       "        <td>1899717.625</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>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>123.08480835</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>274.066802979</td>\n",
       "        <td>272.106018066</td>\n",
       "        <td>1.96080648899</td>\n",
       "        <td>0.0</td>\n",
       "        <td>2257869.75</td>\n",
       "        <td>116675.171875</td>\n",
       "        <td>157.492767334</td>\n",
       "        <td>1408498.0</td>\n",
       "        <td>1259125.625</td>\n",
       "        <td>501261.6875</td>\n",
       "        <td>416320.25</td>\n",
       "        <td>46281.1640625</td>\n",
       "        <td>44271.0898438</td>\n",
       "        <td>483.651428223</td>\n",
       "        <td>1362.45043945</td>\n",
       "        <td>23.0184326172</td>\n",
       "        <td>66.7630310059</td>\n",
       "        <td>1289.98339844</td>\n",
       "        <td>3866.02416992</td>\n",
       "        <td>26296.953125</td>\n",
       "        <td>0.0</td>\n",
       "        <td>54013716.0</td>\n",
       "        <td>21046212.0</td>\n",
       "        <td>9425129.0</td>\n",
       "        <td>9136200.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>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>1304826.0</td>\n",
       "        <td>420186.28125</td>\n",
       "        <td>0.0</td>\n",
       "        <td>0.0</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(1, 1981, 1, 146.34376525878906, 146.2524871826172, 0.09128088504076004, 0.0, 2.3320461650655488e-07, 61619.46484375, 155.3719024658203, 0.016086287796497345, 0.0, 0.04825887829065323, 0.0, 362.0486755371094, 361.8135070800781, 203.620849609375, 421.18377685546875, 0.0, 23.0184326171875, 0.016107244417071342, 0.0, 1.1839052307949238e-11, 0.0, 0.0, 0.0, 5627225.0, 5623486.5, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 806.0157470703125, 0.0, 0.0, 0.0),\n",
       " (2, 1981, 1, 96.22569274902344, 96.18285369873047, 0.042821284383535385, 0.0, 1.6426764659627224e-07, 0.0, 0.0, 0.01363153662532568, 0.0, 0.04089462012052536, 0.0, 315.60052490234375, 315.4579772949219, 0.0, 127.00502014160156, 0.0, 0.0, 0.013656049966812134, 0.0, 4.136972177163251e-16, 0.0, 0.0, 0.0, 3757606.5, 3698301.5, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 442.4630126953125, 0.0, 0.0, 0.0),\n",
       " (3, 1981, 1, 11.952718734741211, 11.861368179321289, 0.09135182946920395, 0.0, 2.0325823868461157e-07, 2.0325823868461157e-07, 6.595060941805286e-09, 0.01146628800779581, 0.0, 0.03439886122941971, 0.009118038229644299, 48.2963752746582, 47.93150329589844, 0.0, 62.467620849609375, 0.0, 0.0, 0.011485105380415916, 0.0, 5.941028783295818e-14, 0.0, 0.0, 0.0, 360979.90625, 456115.90625, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 110.39912414550781, 0.009118038229644299, 0.0, 0.0),\n",
       " (4, 1981, 1, 49.48649215698242, 49.40651321411133, 0.07998340576887131, 0.0, 3.913226720442253e-08, 0.0, 0.0, 0.00722243869677186, 0.0, 0.021667316555976868, 0.0, 46.54270553588867, 46.46895217895508, 0.0, 76.61585235595703, 0.0, 0.0, 0.0072422930970788, 0.0, 1.1632789449796794e-15, 0.0, 0.0, 0.0, 1160040.75, 1899717.625, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 123.08480834960938, 0.0, 0.0, 0.0),\n",
       " (5, 1981, 1, 274.0668029785156, 272.10601806640625, 1.9608064889907837, 0.0, 2257869.75, 116675.171875, 157.49276733398438, 1408498.0, 1259125.625, 501261.6875, 416320.25, 46281.1640625, 44271.08984375, 483.65142822265625, 1362.450439453125, 23.0184326171875, 66.76303100585938, 1289.9833984375, 3866.024169921875, 26296.953125, 0.0, 54013716.0, 21046212.0, 9425129.0, 9136200.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1304826.0, 420186.28125, 0.0, 0.0)]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT * From rch LIMIT 5"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 2.2 Check the number of rows\n",
    "\n",
    "There should be 8280 rows. This can be done with the SQLite ***COUNT*** function. We will touch other SQLite function over the next few notebooks."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>nrow</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8280</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(8280,)]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT COUNT(*) as nrow From rch"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 2.3 Use WHERE to retrieve data\n",
    "\n",
    "Let’s say we are interested in records for only the year 1981. Using a WHERE is pretty straightforward for a simple criterion like this. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>146.343765259</td>\n",
       "        <td>146.252487183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>96.225692749</td>\n",
       "        <td>96.1828536987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>11.9527187347</td>\n",
       "        <td>11.8613681793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>49.486492157</td>\n",
       "        <td>49.4065132141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>274.066802979</td>\n",
       "        <td>272.106018066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>486.710632324</td>\n",
       "        <td>486.318572998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>23.5754947662</td>\n",
       "        <td>23.2890262604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>215.618057251</td>\n",
       "        <td>214.281433105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>193.727722168</td>\n",
       "        <td>193.491210938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>53.9464225769</td>\n",
       "        <td>53.8569450378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>169.814758301</td>\n",
       "        <td>169.150192261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>92.6244430542</td>\n",
       "        <td>92.4601135254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>26.3339881897</td>\n",
       "        <td>26.210729599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>14.9631795883</td>\n",
       "        <td>14.9530191422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>20.5692977905</td>\n",
       "        <td>19.8981304169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>31.9277248383</td>\n",
       "        <td>31.7866764069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>1.93742740154</td>\n",
       "        <td>1.93515872955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>9.37765789032</td>\n",
       "        <td>9.31258201599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>5.65413570404</td>\n",
       "        <td>5.64094257355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>24.2975311279</td>\n",
       "        <td>24.2327251434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>4.31685018539</td>\n",
       "        <td>4.3096075058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>11.2497816086</td>\n",
       "        <td>10.7964601517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>4.44616699219</td>\n",
       "        <td>4.4037604332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>84.8559188843</td>\n",
       "        <td>84.7803344727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>56.372833252</td>\n",
       "        <td>56.3133583069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>6.14550495148</td>\n",
       "        <td>6.04766273499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>28.1459884644</td>\n",
       "        <td>28.0324840546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>469.555541992</td>\n",
       "        <td>466.405151367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>848.658935547</td>\n",
       "        <td>847.933898926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>127.242324829</td>\n",
       "        <td>126.868263245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>381.5965271</td>\n",
       "        <td>379.125030518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>226.332107544</td>\n",
       "        <td>225.986114502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>29.2481822968</td>\n",
       "        <td>29.1108722687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>83.9979095459</td>\n",
       "        <td>83.5008392334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>43.8488578796</td>\n",
       "        <td>43.6200675964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>15.8314399719</td>\n",
       "        <td>15.7355585098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>8.46049690247</td>\n",
       "        <td>8.45271015167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>129.933425903</td>\n",
       "        <td>128.899002075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>11.6704034805</td>\n",
       "        <td>11.452507019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>1.14988315105</td>\n",
       "        <td>1.14373576641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>5.57378292084</td>\n",
       "        <td>5.49425601959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>2.97059011459</td>\n",
       "        <td>2.95781540871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>7.20315742493</td>\n",
       "        <td>7.10391664505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>2.59041404724</td>\n",
       "        <td>2.58157086372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>7.27246904373</td>\n",
       "        <td>6.88177394867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>2.66581130028</td>\n",
       "        <td>2.61045885086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>76.3945007324</td>\n",
       "        <td>76.1017379761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>31.0499000549</td>\n",
       "        <td>31.0034885406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>4.25944375992</td>\n",
       "        <td>4.09177446365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>13.8743829727</td>\n",
       "        <td>13.7061252594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>709.757446289</td>\n",
       "        <td>706.848388672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>1314.44055176</td>\n",
       "        <td>1313.29589844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>253.102981567</td>\n",
       "        <td>252.573577881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>602.877685547</td>\n",
       "        <td>598.978515625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>320.066375732</td>\n",
       "        <td>319.558410645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>8.96465682983</td>\n",
       "        <td>8.77624034882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>43.8917312622</td>\n",
       "        <td>43.2532043457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>16.2481708527</td>\n",
       "        <td>15.9578199387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>11.9861106873</td>\n",
       "        <td>11.751502037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>4.6827454567</td>\n",
       "        <td>4.66399478912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>216.408355713</td>\n",
       "        <td>215.00881958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>5.82788181305</td>\n",
       "        <td>5.56380796432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>0.586232721806</td>\n",
       "        <td>0.569605469704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>3.11817646027</td>\n",
       "        <td>3.05032992363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>1.6415528059</td>\n",
       "        <td>1.62772107124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>3.44133806229</td>\n",
       "        <td>3.27661037445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>1.44381320477</td>\n",
       "        <td>1.43628358841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>7.94436407089</td>\n",
       "        <td>7.03369760513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>1.48587191105</td>\n",
       "        <td>1.41091322899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>113.286216736</td>\n",
       "        <td>112.345336914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>10.9826068878</td>\n",
       "        <td>10.8901309967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>33.0489387512</td>\n",
       "        <td>32.8456306458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>4.77364969254</td>\n",
       "        <td>4.45995903015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>888.422180176</td>\n",
       "        <td>882.70300293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>1953.39245605</td>\n",
       "        <td>1952.21643066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>322.497253418</td>\n",
       "        <td>321.794342041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>1063.93408203</td>\n",
       "        <td>1059.92712402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>705.585876465</td>\n",
       "        <td>705.022583008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>14.4726667404</td>\n",
       "        <td>14.11287117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>353.946960449</td>\n",
       "        <td>352.994750977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>25.6617107391</td>\n",
       "        <td>24.7613449097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>246.525604248</td>\n",
       "        <td>246.180664062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>31.783952713</td>\n",
       "        <td>31.7566719055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>266.310211182</td>\n",
       "        <td>264.731109619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>8.94605731964</td>\n",
       "        <td>8.07646751404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>0.318325519562</td>\n",
       "        <td>0.28104352951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>1.3510197401</td>\n",
       "        <td>0.987899184227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>29.6419563293</td>\n",
       "        <td>29.5858097076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>1.64862215519</td>\n",
       "        <td>1.45889079571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>0.907574236393</td>\n",
       "        <td>0.867261230946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>162.147506714</td>\n",
       "        <td>160.701919556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>1.16513335705</td>\n",
       "        <td>0.974480986595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>100.620010376</td>\n",
       "        <td>97.2832946777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>8.11182689667</td>\n",
       "        <td>8.04068851471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>871.117736816</td>\n",
       "        <td>870.296020508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>11.686167717</td>\n",
       "        <td>11.3040266037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>1665.54931641</td>\n",
       "        <td>1652.77099609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>8009.71044922</td>\n",
       "        <td>8006.85400391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>259.010009766</td>\n",
       "        <td>257.656829834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>6357.578125</td>\n",
       "        <td>6347.859375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>6059.88818359</td>\n",
       "        <td>6058.60839844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>283.817962646</td>\n",
       "        <td>283.138671875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>5789.78857422</td>\n",
       "        <td>5779.33251953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>1181.43054199</td>\n",
       "        <td>1180.09863281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>1112.36889648</td>\n",
       "        <td>1111.72009277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>380.402282715</td>\n",
       "        <td>380.355041504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>222.105041504</td>\n",
       "        <td>218.811080933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>705.462158203</td>\n",
       "        <td>703.922485352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>112.314666748</td>\n",
       "        <td>112.084083557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>352.789520264</td>\n",
       "        <td>351.627655029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>27.5865345001</td>\n",
       "        <td>27.5305900574</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>251.14074707</td>\n",
       "        <td>250.665527344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>181.302871704</td>\n",
       "        <td>181.173355103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>672.062316895</td>\n",
       "        <td>670.913879395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>196.246917725</td>\n",
       "        <td>195.824981689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>262.693634033</td>\n",
       "        <td>258.316619873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>69.129737854</td>\n",
       "        <td>69.0005950928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>440.312591553</td>\n",
       "        <td>438.843811035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>135.955551147</td>\n",
       "        <td>135.477462769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>1231.21154785</td>\n",
       "        <td>1211.47802734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>4850.93652344</td>\n",
       "        <td>4847.08398438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>173.676940918</td>\n",
       "        <td>171.778427124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>3646.69848633</td>\n",
       "        <td>3633.58837891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>3447.75244141</td>\n",
       "        <td>3445.91455078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>295.130584717</td>\n",
       "        <td>294.550354004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>3284.65380859</td>\n",
       "        <td>3261.92504883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>981.057189941</td>\n",
       "        <td>979.632385254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>843.386779785</td>\n",
       "        <td>842.566223145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>328.031829834</td>\n",
       "        <td>327.972259521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>151.173675537</td>\n",
       "        <td>146.489593506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>506.210144043</td>\n",
       "        <td>504.175811768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>62.0020294189</td>\n",
       "        <td>61.8061943054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>288.220428467</td>\n",
       "        <td>286.923187256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>40.1543998718</td>\n",
       "        <td>40.1100692749</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>260.237915039</td>\n",
       "        <td>259.854095459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>134.338470459</td>\n",
       "        <td>134.192825317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>465.631561279</td>\n",
       "        <td>463.379211426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>142.71295166</td>\n",
       "        <td>142.245803833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>3227.13110352</td>\n",
       "        <td>3221.74072266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>1406.19689941</td>\n",
       "        <td>1405.60766602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>348.385925293</td>\n",
       "        <td>346.489868164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>1793.20861816</td>\n",
       "        <td>1792.43225098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>3911.8918457</td>\n",
       "        <td>3892.29125977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>7727.92773438</td>\n",
       "        <td>7723.72216797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>103.775985718</td>\n",
       "        <td>101.718132019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>3846.44506836</td>\n",
       "        <td>3832.15966797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>3743.96606445</td>\n",
       "        <td>3742.0390625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>914.50769043</td>\n",
       "        <td>913.317687988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>3664.94726562</td>\n",
       "        <td>3633.75805664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>1543.27722168</td>\n",
       "        <td>1539.48791504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>963.818481445</td>\n",
       "        <td>962.119995117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>572.214782715</td>\n",
       "        <td>572.089233398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>76.3998718262</td>\n",
       "        <td>71.2975234985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>471.632415771</td>\n",
       "        <td>467.839996338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>46.4576568604</td>\n",
       "        <td>46.1260566711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>234.257980347</td>\n",
       "        <td>231.629562378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>340.188690186</td>\n",
       "        <td>339.892578125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>266.391021729</td>\n",
       "        <td>265.833435059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>111.280227661</td>\n",
       "        <td>110.98563385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>359.211456299</td>\n",
       "        <td>354.975006104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>114.013412476</td>\n",
       "        <td>113.253257751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>1313.55480957</td>\n",
       "        <td>1308.91967773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>831.656799316</td>\n",
       "        <td>830.847351074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>223.178634644</td>\n",
       "        <td>221.528198242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>481.635467529</td>\n",
       "        <td>480.853515625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>1730.9362793</td>\n",
       "        <td>1713.8548584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>3883.90576172</td>\n",
       "        <td>3880.37548828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>19.0379142761</td>\n",
       "        <td>17.0796871185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>2181.50463867</td>\n",
       "        <td>2169.49682617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>2173.20507812</td>\n",
       "        <td>2171.4440918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>484.746643066</td>\n",
       "        <td>483.543670654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>2180.65014648</td>\n",
       "        <td>2153.10107422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>915.499389648</td>\n",
       "        <td>912.757324219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>526.147766113</td>\n",
       "        <td>525.076965332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>281.400360107</td>\n",
       "        <td>281.322509766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>7.93916559219</td>\n",
       "        <td>3.25166416168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>316.220733643</td>\n",
       "        <td>313.24105835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>28.7409934998</td>\n",
       "        <td>28.4617805481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>149.419464111</td>\n",
       "        <td>147.249893188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>134.035598755</td>\n",
       "        <td>133.730377197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>185.15713501</td>\n",
       "        <td>184.929550171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>71.2013549805</td>\n",
       "        <td>70.9576873779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>225.526535034</td>\n",
       "        <td>222.421295166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>72.1358795166</td>\n",
       "        <td>71.501739502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>1124.60803223</td>\n",
       "        <td>1120.95153809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>725.462768555</td>\n",
       "        <td>724.831420898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>130.81338501</td>\n",
       "        <td>129.493408203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>399.005157471</td>\n",
       "        <td>398.382293701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>1336.86206055</td>\n",
       "        <td>1322.87695312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>2703.62719727</td>\n",
       "        <td>2700.82128906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>5.52178621292</td>\n",
       "        <td>3.94140219688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>1390.12976074</td>\n",
       "        <td>1380.58618164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>1389.17919922</td>\n",
       "        <td>1387.77734375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>395.668182373</td>\n",
       "        <td>395.08782959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>1406.95239258</td>\n",
       "        <td>1384.63500977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>646.476196289</td>\n",
       "        <td>644.031677246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>328.936157227</td>\n",
       "        <td>327.860748291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>186.761032104</td>\n",
       "        <td>186.68107605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>4.17485046387</td>\n",
       "        <td>0.529776334763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>179.726348877</td>\n",
       "        <td>177.129776001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>7.19845867157</td>\n",
       "        <td>7.00188159943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>87.6135177612</td>\n",
       "        <td>85.9346237183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>100.64956665</td>\n",
       "        <td>100.584403992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>112.391197205</td>\n",
       "        <td>111.944114685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>41.7743606567</td>\n",
       "        <td>41.5863838196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>131.207977295</td>\n",
       "        <td>129.378860474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>42.1702346802</td>\n",
       "        <td>41.6853141785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>754.760192871</td>\n",
       "        <td>753.44934082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>497.297912598</td>\n",
       "        <td>497.260192871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>81.5684280396</td>\n",
       "        <td>81.1704025269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>255.234786987</td>\n",
       "        <td>255.066543579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>862.908874512</td>\n",
       "        <td>855.082824707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>1715.89404297</td>\n",
       "        <td>1714.40759277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>4.32509946823</td>\n",
       "        <td>3.60364627838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>865.744445801</td>\n",
       "        <td>860.685119629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>863.424316406</td>\n",
       "        <td>862.75378418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>283.008361816</td>\n",
       "        <td>282.70489502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>864.735107422</td>\n",
       "        <td>859.371704102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>426.672546387</td>\n",
       "        <td>426.194671631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>176.96333313</td>\n",
       "        <td>176.595901489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>106.038627625</td>\n",
       "        <td>106.010162354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>3.52883219719</td>\n",
       "        <td>1.72224628925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>101.484710693</td>\n",
       "        <td>100.963508606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>3.64370536804</td>\n",
       "        <td>3.58154320717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>43.4761047363</td>\n",
       "        <td>43.174697876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>62.8055992126</td>\n",
       "        <td>62.7594680786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>64.4624099731</td>\n",
       "        <td>64.2518234253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>20.3864765167</td>\n",
       "        <td>20.3530693054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>66.0229187012</td>\n",
       "        <td>65.0599899292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>20.0234184265</td>\n",
       "        <td>19.8870067596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>455.798980713</td>\n",
       "        <td>454.80657959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>301.043029785</td>\n",
       "        <td>300.988983154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>43.5503807068</td>\n",
       "        <td>43.2350959778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>154.065231323</td>\n",
       "        <td>153.936553955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>515.991333008</td>\n",
       "        <td>508.71194458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>967.751953125</td>\n",
       "        <td>966.512390137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>4.03683662415</td>\n",
       "        <td>3.35418486595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>463.151824951</td>\n",
       "        <td>458.930145264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>460.815063477</td>\n",
       "        <td>460.203826904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>180.46812439</td>\n",
       "        <td>180.268310547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>461.68069458</td>\n",
       "        <td>457.148864746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>253.930847168</td>\n",
       "        <td>253.545471191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>71.3385238647</td>\n",
       "        <td>71.1140518188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>49.3078613281</td>\n",
       "        <td>49.2894363403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>3.69170331955</td>\n",
       "        <td>2.06985735893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>50.1137466431</td>\n",
       "        <td>49.755443573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>2.44720673561</td>\n",
       "        <td>2.42971539497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>13.137421608</td>\n",
       "        <td>12.9440460205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>36.3612442017</td>\n",
       "        <td>36.3305587769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>36.0437965393</td>\n",
       "        <td>35.867023468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>6.2915520668</td>\n",
       "        <td>6.27008199692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>20.99700737</td>\n",
       "        <td>20.2312011719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>6.26511049271</td>\n",
       "        <td>6.17907094955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>261.241729736</td>\n",
       "        <td>261.120635986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>172.48664856</td>\n",
       "        <td>172.449890137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>19.7595901489</td>\n",
       "        <td>19.6683082581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>88.2897491455</td>\n",
       "        <td>88.2150650024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>310.223052979</td>\n",
       "        <td>305.40322876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>575.504089355</td>\n",
       "        <td>574.71081543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>5.73949337006</td>\n",
       "        <td>5.26210021973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>272.611206055</td>\n",
       "        <td>269.9090271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>268.85256958</td>\n",
       "        <td>268.440734863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>105.923088074</td>\n",
       "        <td>105.824157715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>263.594146729</td>\n",
       "        <td>262.973236084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>134.264450073</td>\n",
       "        <td>134.111526489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>40.1124572754</td>\n",
       "        <td>39.9801177979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>14</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>28.0906429291</td>\n",
       "        <td>28.0796718597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>15</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>4.38283967972</td>\n",
       "        <td>3.29067325592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>16</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>18.3146381378</td>\n",
       "        <td>18.1811637878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>17</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>1.49579250813</td>\n",
       "        <td>1.48985922337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>18</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>7.75301837921</td>\n",
       "        <td>7.68781137466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>19</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>20.3954563141</td>\n",
       "        <td>20.3830814362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>20</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>11.4546957016</td>\n",
       "        <td>11.3411521912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>21</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>3.70645093918</td>\n",
       "        <td>3.69918608665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>11.3842573166</td>\n",
       "        <td>10.9625101089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>23</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>3.68763184547</td>\n",
       "        <td>3.64218473434</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(1, 1981, 1, 146.34376525878906, 146.2524871826172),\n",
       " (2, 1981, 1, 96.22569274902344, 96.18285369873047),\n",
       " (3, 1981, 1, 11.952718734741211, 11.861368179321289),\n",
       " (4, 1981, 1, 49.48649215698242, 49.40651321411133),\n",
       " (5, 1981, 1, 274.0668029785156, 272.10601806640625),\n",
       " (6, 1981, 1, 486.71063232421875, 486.3185729980469),\n",
       " (7, 1981, 1, 23.57549476623535, 23.289026260375977),\n",
       " (8, 1981, 1, 215.61805725097656, 214.28143310546875),\n",
       " (9, 1981, 1, 193.72772216796875, 193.4912109375),\n",
       " (10, 1981, 1, 53.9464225769043, 53.8569450378418),\n",
       " (11, 1981, 1, 169.81475830078125, 169.1501922607422),\n",
       " (12, 1981, 1, 92.62444305419922, 92.46011352539062),\n",
       " (13, 1981, 1, 26.333988189697266, 26.210729598999023),\n",
       " (14, 1981, 1, 14.963179588317871, 14.953019142150879),\n",
       " (15, 1981, 1, 20.569297790527344, 19.898130416870117),\n",
       " (16, 1981, 1, 31.927724838256836, 31.78667640686035),\n",
       " (17, 1981, 1, 1.9374274015426636, 1.9351587295532227),\n",
       " (18, 1981, 1, 9.377657890319824, 9.312582015991211),\n",
       " (19, 1981, 1, 5.654135704040527, 5.640942573547363),\n",
       " (20, 1981, 1, 24.297531127929688, 24.232725143432617),\n",
       " (21, 1981, 1, 4.316850185394287, 4.30960750579834),\n",
       " (22, 1981, 1, 11.249781608581543, 10.796460151672363),\n",
       " (23, 1981, 1, 4.4461669921875, 4.4037604331970215),\n",
       " (1, 1981, 2, 84.85591888427734, 84.78033447265625),\n",
       " (2, 1981, 2, 56.372833251953125, 56.313358306884766),\n",
       " (3, 1981, 2, 6.145504951477051, 6.047662734985352),\n",
       " (4, 1981, 2, 28.14598846435547, 28.03248405456543),\n",
       " (5, 1981, 2, 469.5555419921875, 466.4051513671875),\n",
       " (6, 1981, 2, 848.658935546875, 847.9338989257812),\n",
       " (7, 1981, 2, 127.24232482910156, 126.8682632446289),\n",
       " (8, 1981, 2, 381.5965270996094, 379.1250305175781),\n",
       " (9, 1981, 2, 226.3321075439453, 225.98611450195312),\n",
       " (10, 1981, 2, 29.24818229675293, 29.110872268676758),\n",
       " (11, 1981, 2, 83.99790954589844, 83.50083923339844),\n",
       " (12, 1981, 2, 43.84885787963867, 43.62006759643555),\n",
       " (13, 1981, 2, 15.831439971923828, 15.73555850982666),\n",
       " (14, 1981, 2, 8.46049690246582, 8.452710151672363),\n",
       " (15, 1981, 2, 129.9334259033203, 128.8990020751953),\n",
       " (16, 1981, 2, 11.670403480529785, 11.452507019042969),\n",
       " (17, 1981, 2, 1.1498831510543823, 1.1437357664108276),\n",
       " (18, 1981, 2, 5.573782920837402, 5.494256019592285),\n",
       " (19, 1981, 2, 2.970590114593506, 2.957815408706665),\n",
       " (20, 1981, 2, 7.203157424926758, 7.103916645050049),\n",
       " (21, 1981, 2, 2.590414047241211, 2.581570863723755),\n",
       " (22, 1981, 2, 7.2724690437316895, 6.881773948669434),\n",
       " (23, 1981, 2, 2.66581130027771, 2.6104588508605957),\n",
       " (1, 1981, 3, 76.39450073242188, 76.10173797607422),\n",
       " (2, 1981, 3, 31.04990005493164, 31.003488540649414),\n",
       " (3, 1981, 3, 4.259443759918213, 4.0917744636535645),\n",
       " (4, 1981, 3, 13.874382972717285, 13.706125259399414),\n",
       " (5, 1981, 3, 709.7574462890625, 706.848388671875),\n",
       " (6, 1981, 3, 1314.4405517578125, 1313.2958984375),\n",
       " (7, 1981, 3, 253.1029815673828, 252.57357788085938),\n",
       " (8, 1981, 3, 602.877685546875, 598.978515625),\n",
       " (9, 1981, 3, 320.0663757324219, 319.55841064453125),\n",
       " (10, 1981, 3, 8.964656829833984, 8.776240348815918),\n",
       " (11, 1981, 3, 43.89173126220703, 43.253204345703125),\n",
       " (12, 1981, 3, 16.248170852661133, 15.957819938659668),\n",
       " (13, 1981, 3, 11.98611068725586, 11.75150203704834),\n",
       " (14, 1981, 3, 4.682745456695557, 4.663994789123535),\n",
       " (15, 1981, 3, 216.40835571289062, 215.00881958007812),\n",
       " (16, 1981, 3, 5.827881813049316, 5.563807964324951),\n",
       " (17, 1981, 3, 0.5862327218055725, 0.5696054697036743),\n",
       " (18, 1981, 3, 3.1181764602661133, 3.0503299236297607),\n",
       " (19, 1981, 3, 1.6415528059005737, 1.6277210712432861),\n",
       " (20, 1981, 3, 3.441338062286377, 3.2766103744506836),\n",
       " (21, 1981, 3, 1.4438132047653198, 1.4362835884094238),\n",
       " (22, 1981, 3, 7.944364070892334, 7.033697605133057),\n",
       " (23, 1981, 3, 1.4858719110488892, 1.4109132289886475),\n",
       " (1, 1981, 4, 113.28621673583984, 112.3453369140625),\n",
       " (2, 1981, 4, 10.982606887817383, 10.890130996704102),\n",
       " (3, 1981, 4, 33.0489387512207, 32.84563064575195),\n",
       " (4, 1981, 4, 4.7736496925354, 4.459959030151367),\n",
       " (5, 1981, 4, 888.4221801757812, 882.7030029296875),\n",
       " (6, 1981, 4, 1953.3924560546875, 1952.2164306640625),\n",
       " (7, 1981, 4, 322.49725341796875, 321.7943420410156),\n",
       " (8, 1981, 4, 1063.93408203125, 1059.9271240234375),\n",
       " (9, 1981, 4, 705.5858764648438, 705.0225830078125),\n",
       " (10, 1981, 4, 14.47266674041748, 14.112871170043945),\n",
       " (11, 1981, 4, 353.94696044921875, 352.9947509765625),\n",
       " (12, 1981, 4, 25.661710739135742, 24.76134490966797),\n",
       " (13, 1981, 4, 246.52560424804688, 246.1806640625),\n",
       " (14, 1981, 4, 31.783952713012695, 31.756671905517578),\n",
       " (15, 1981, 4, 266.3102111816406, 264.7311096191406),\n",
       " (16, 1981, 4, 8.946057319641113, 8.076467514038086),\n",
       " (17, 1981, 4, 0.3183255195617676, 0.28104352951049805),\n",
       " (18, 1981, 4, 1.3510197401046753, 0.9878991842269897),\n",
       " (19, 1981, 4, 29.641956329345703, 29.5858097076416),\n",
       " (20, 1981, 4, 1.6486221551895142, 1.4588907957077026),\n",
       " (21, 1981, 4, 0.9075742363929749, 0.8672612309455872),\n",
       " (22, 1981, 4, 162.1475067138672, 160.70191955566406),\n",
       " (23, 1981, 4, 1.1651333570480347, 0.9744809865951538),\n",
       " (1, 1981, 5, 100.62001037597656, 97.28329467773438),\n",
       " (2, 1981, 5, 8.11182689666748, 8.040688514709473),\n",
       " (3, 1981, 5, 871.1177368164062, 870.2960205078125),\n",
       " (4, 1981, 5, 11.68616771697998, 11.30402660369873),\n",
       " (5, 1981, 5, 1665.54931640625, 1652.77099609375),\n",
       " (6, 1981, 5, 8009.71044921875, 8006.85400390625),\n",
       " (7, 1981, 5, 259.010009765625, 257.6568298339844),\n",
       " (8, 1981, 5, 6357.578125, 6347.859375),\n",
       " (9, 1981, 5, 6059.88818359375, 6058.6083984375),\n",
       " (10, 1981, 5, 283.8179626464844, 283.138671875),\n",
       " (11, 1981, 5, 5789.78857421875, 5779.33251953125),\n",
       " (12, 1981, 5, 1181.4305419921875, 1180.0986328125),\n",
       " (13, 1981, 5, 1112.368896484375, 1111.7200927734375),\n",
       " (14, 1981, 5, 380.40228271484375, 380.35504150390625),\n",
       " (15, 1981, 5, 222.10504150390625, 218.8110809326172),\n",
       " (16, 1981, 5, 705.462158203125, 703.9224853515625),\n",
       " (17, 1981, 5, 112.31466674804688, 112.0840835571289),\n",
       " (18, 1981, 5, 352.7895202636719, 351.6276550292969),\n",
       " (19, 1981, 5, 27.58653450012207, 27.530590057373047),\n",
       " (20, 1981, 5, 251.1407470703125, 250.66552734375),\n",
       " (21, 1981, 5, 181.30287170410156, 181.17335510253906),\n",
       " (22, 1981, 5, 672.0623168945312, 670.9138793945312),\n",
       " (23, 1981, 5, 196.24691772460938, 195.82498168945312),\n",
       " (1, 1981, 6, 262.6936340332031, 258.3166198730469),\n",
       " (2, 1981, 6, 69.1297378540039, 69.00059509277344),\n",
       " (3, 1981, 6, 440.3125915527344, 438.84381103515625),\n",
       " (4, 1981, 6, 135.95555114746094, 135.4774627685547),\n",
       " (5, 1981, 6, 1231.2115478515625, 1211.47802734375),\n",
       " (6, 1981, 6, 4850.9365234375, 4847.083984375),\n",
       " (7, 1981, 6, 173.67694091796875, 171.77842712402344),\n",
       " (8, 1981, 6, 3646.698486328125, 3633.58837890625),\n",
       " (9, 1981, 6, 3447.75244140625, 3445.91455078125),\n",
       " (10, 1981, 6, 295.1305847167969, 294.55035400390625),\n",
       " (11, 1981, 6, 3284.65380859375, 3261.925048828125),\n",
       " (12, 1981, 6, 981.0571899414062, 979.6323852539062),\n",
       " (13, 1981, 6, 843.3867797851562, 842.5662231445312),\n",
       " (14, 1981, 6, 328.0318298339844, 327.9722595214844),\n",
       " (15, 1981, 6, 151.17367553710938, 146.48959350585938),\n",
       " (16, 1981, 6, 506.21014404296875, 504.1758117675781),\n",
       " (17, 1981, 6, 62.00202941894531, 61.80619430541992),\n",
       " (18, 1981, 6, 288.2204284667969, 286.9231872558594),\n",
       " (19, 1981, 6, 40.15439987182617, 40.110069274902344),\n",
       " (20, 1981, 6, 260.2379150390625, 259.8540954589844),\n",
       " (21, 1981, 6, 134.33847045898438, 134.1928253173828),\n",
       " (22, 1981, 6, 465.6315612792969, 463.37921142578125),\n",
       " (23, 1981, 6, 142.71295166015625, 142.2458038330078),\n",
       " (1, 1981, 7, 3227.131103515625, 3221.74072265625),\n",
       " (2, 1981, 7, 1406.1968994140625, 1405.607666015625),\n",
       " (3, 1981, 7, 348.38592529296875, 346.4898681640625),\n",
       " (4, 1981, 7, 1793.2086181640625, 1792.4322509765625),\n",
       " (5, 1981, 7, 3911.891845703125, 3892.291259765625),\n",
       " (6, 1981, 7, 7727.927734375, 7723.72216796875),\n",
       " (7, 1981, 7, 103.77598571777344, 101.71813201904297),\n",
       " (8, 1981, 7, 3846.445068359375, 3832.15966796875),\n",
       " (9, 1981, 7, 3743.966064453125, 3742.0390625),\n",
       " (10, 1981, 7, 914.5076904296875, 913.3176879882812),\n",
       " (11, 1981, 7, 3664.947265625, 3633.758056640625),\n",
       " (12, 1981, 7, 1543.2772216796875, 1539.4879150390625),\n",
       " (13, 1981, 7, 963.8184814453125, 962.1199951171875),\n",
       " (14, 1981, 7, 572.2147827148438, 572.0892333984375),\n",
       " (15, 1981, 7, 76.39987182617188, 71.29752349853516),\n",
       " (16, 1981, 7, 471.6324157714844, 467.8399963378906),\n",
       " (17, 1981, 7, 46.45765686035156, 46.12605667114258),\n",
       " (18, 1981, 7, 234.2579803466797, 231.6295623779297),\n",
       " (19, 1981, 7, 340.1886901855469, 339.892578125),\n",
       " (20, 1981, 7, 266.3910217285156, 265.83343505859375),\n",
       " (21, 1981, 7, 111.28022766113281, 110.98563385009766),\n",
       " (22, 1981, 7, 359.2114562988281, 354.9750061035156),\n",
       " (23, 1981, 7, 114.01341247558594, 113.25325775146484),\n",
       " (1, 1981, 8, 1313.5548095703125, 1308.919677734375),\n",
       " (2, 1981, 8, 831.6567993164062, 830.8473510742188),\n",
       " (3, 1981, 8, 223.1786346435547, 221.5281982421875),\n",
       " (4, 1981, 8, 481.6354675292969, 480.853515625),\n",
       " (5, 1981, 8, 1730.936279296875, 1713.8548583984375),\n",
       " (6, 1981, 8, 3883.90576171875, 3880.37548828125),\n",
       " (7, 1981, 8, 19.037914276123047, 17.079687118530273),\n",
       " (8, 1981, 8, 2181.504638671875, 2169.496826171875),\n",
       " (9, 1981, 8, 2173.205078125, 2171.444091796875),\n",
       " (10, 1981, 8, 484.74664306640625, 483.5436706542969),\n",
       " (11, 1981, 8, 2180.650146484375, 2153.10107421875),\n",
       " (12, 1981, 8, 915.4993896484375, 912.75732421875),\n",
       " (13, 1981, 8, 526.1477661132812, 525.0769653320312),\n",
       " (14, 1981, 8, 281.4003601074219, 281.322509765625),\n",
       " (15, 1981, 8, 7.9391655921936035, 3.251664161682129),\n",
       " (16, 1981, 8, 316.2207336425781, 313.2410583496094),\n",
       " (17, 1981, 8, 28.74099349975586, 28.461780548095703),\n",
       " (18, 1981, 8, 149.41946411132812, 147.24989318847656),\n",
       " (19, 1981, 8, 134.0355987548828, 133.73037719726562),\n",
       " (20, 1981, 8, 185.15713500976562, 184.92955017089844),\n",
       " (21, 1981, 8, 71.20135498046875, 70.95768737792969),\n",
       " (22, 1981, 8, 225.5265350341797, 222.42129516601562),\n",
       " (23, 1981, 8, 72.13587951660156, 71.50173950195312),\n",
       " (1, 1981, 9, 1124.6080322265625, 1120.9515380859375),\n",
       " (2, 1981, 9, 725.4627685546875, 724.8314208984375),\n",
       " (3, 1981, 9, 130.81338500976562, 129.493408203125),\n",
       " (4, 1981, 9, 399.0051574707031, 398.3822937011719),\n",
       " (5, 1981, 9, 1336.862060546875, 1322.876953125),\n",
       " (6, 1981, 9, 2703.627197265625, 2700.8212890625),\n",
       " (7, 1981, 9, 5.521786212921143, 3.9414021968841553),\n",
       " (8, 1981, 9, 1390.1297607421875, 1380.586181640625),\n",
       " (9, 1981, 9, 1389.17919921875, 1387.77734375),\n",
       " (10, 1981, 9, 395.6681823730469, 395.08782958984375),\n",
       " (11, 1981, 9, 1406.952392578125, 1384.635009765625),\n",
       " (12, 1981, 9, 646.4761962890625, 644.0316772460938),\n",
       " (13, 1981, 9, 328.9361572265625, 327.8607482910156),\n",
       " (14, 1981, 9, 186.7610321044922, 186.6810760498047),\n",
       " (15, 1981, 9, 4.1748504638671875, 0.5297763347625732),\n",
       " (16, 1981, 9, 179.72634887695312, 177.12977600097656),\n",
       " (17, 1981, 9, 7.198458671569824, 7.0018815994262695),\n",
       " (18, 1981, 9, 87.61351776123047, 85.93462371826172),\n",
       " (19, 1981, 9, 100.64956665039062, 100.58440399169922),\n",
       " (20, 1981, 9, 112.39119720458984, 111.9441146850586),\n",
       " (21, 1981, 9, 41.77436065673828, 41.58638381958008),\n",
       " (22, 1981, 9, 131.20797729492188, 129.3788604736328),\n",
       " (23, 1981, 9, 42.17023468017578, 41.6853141784668),\n",
       " (1, 1981, 10, 754.7601928710938, 753.4493408203125),\n",
       " (2, 1981, 10, 497.29791259765625, 497.26019287109375),\n",
       " (3, 1981, 10, 81.56842803955078, 81.17040252685547),\n",
       " (4, 1981, 10, 255.2347869873047, 255.06654357910156),\n",
       " (5, 1981, 10, 862.9088745117188, 855.0828247070312),\n",
       " (6, 1981, 10, 1715.89404296875, 1714.4075927734375),\n",
       " (7, 1981, 10, 4.325099468231201, 3.6036462783813477),\n",
       " (8, 1981, 10, 865.7444458007812, 860.6851196289062),\n",
       " (9, 1981, 10, 863.42431640625, 862.7537841796875),\n",
       " (10, 1981, 10, 283.00836181640625, 282.70489501953125),\n",
       " (11, 1981, 10, 864.735107421875, 859.3717041015625),\n",
       " (12, 1981, 10, 426.67254638671875, 426.1946716308594),\n",
       " (13, 1981, 10, 176.9633331298828, 176.5959014892578),\n",
       " (14, 1981, 10, 106.03862762451172, 106.01016235351562),\n",
       " (15, 1981, 10, 3.528832197189331, 1.7222462892532349),\n",
       " (16, 1981, 10, 101.48471069335938, 100.96350860595703),\n",
       " (17, 1981, 10, 3.643705368041992, 3.581543207168579),\n",
       " (18, 1981, 10, 43.476104736328125, 43.17469787597656),\n",
       " (19, 1981, 10, 62.805599212646484, 62.75946807861328),\n",
       " (20, 1981, 10, 64.46240997314453, 64.25182342529297),\n",
       " (21, 1981, 10, 20.386476516723633, 20.353069305419922),\n",
       " (22, 1981, 10, 66.02291870117188, 65.05998992919922),\n",
       " (23, 1981, 10, 20.023418426513672, 19.887006759643555),\n",
       " (1, 1981, 11, 455.7989807128906, 454.80657958984375),\n",
       " (2, 1981, 11, 301.04302978515625, 300.9889831542969),\n",
       " (3, 1981, 11, 43.55038070678711, 43.2350959777832),\n",
       " (4, 1981, 11, 154.0652313232422, 153.93655395507812),\n",
       " (5, 1981, 11, 515.9913330078125, 508.7119445800781),\n",
       " (6, 1981, 11, 967.751953125, 966.5123901367188),\n",
       " (7, 1981, 11, 4.036836624145508, 3.354184865951538),\n",
       " (8, 1981, 11, 463.1518249511719, 458.9301452636719),\n",
       " (9, 1981, 11, 460.8150634765625, 460.2038269042969),\n",
       " (10, 1981, 11, 180.46812438964844, 180.268310546875),\n",
       " (11, 1981, 11, 461.6806945800781, 457.14886474609375),\n",
       " (12, 1981, 11, 253.93084716796875, 253.54547119140625),\n",
       " (13, 1981, 11, 71.3385238647461, 71.11405181884766),\n",
       " (14, 1981, 11, 49.307861328125, 49.28943634033203),\n",
       " (15, 1981, 11, 3.6917033195495605, 2.069857358932495),\n",
       " (16, 1981, 11, 50.113746643066406, 49.75544357299805),\n",
       " (17, 1981, 11, 2.447206735610962, 2.429715394973755),\n",
       " (18, 1981, 11, 13.137421607971191, 12.944046020507812),\n",
       " (19, 1981, 11, 36.361244201660156, 36.33055877685547),\n",
       " (20, 1981, 11, 36.04379653930664, 35.86702346801758),\n",
       " (21, 1981, 11, 6.2915520668029785, 6.270081996917725),\n",
       " (22, 1981, 11, 20.997007369995117, 20.231201171875),\n",
       " (23, 1981, 11, 6.265110492706299, 6.179070949554443),\n",
       " (1, 1981, 12, 261.2417297363281, 261.1206359863281),\n",
       " (2, 1981, 12, 172.4866485595703, 172.44989013671875),\n",
       " (3, 1981, 12, 19.75959014892578, 19.66830825805664),\n",
       " (4, 1981, 12, 88.28974914550781, 88.2150650024414),\n",
       " (5, 1981, 12, 310.2230529785156, 305.4032287597656),\n",
       " (6, 1981, 12, 575.5040893554688, 574.7108154296875),\n",
       " (7, 1981, 12, 5.739493370056152, 5.2621002197265625),\n",
       " (8, 1981, 12, 272.6112060546875, 269.9090270996094),\n",
       " (9, 1981, 12, 268.8525695800781, 268.44073486328125),\n",
       " (10, 1981, 12, 105.92308807373047, 105.82415771484375),\n",
       " (11, 1981, 12, 263.5941467285156, 262.9732360839844),\n",
       " (12, 1981, 12, 134.2644500732422, 134.1115264892578),\n",
       " (13, 1981, 12, 40.112457275390625, 39.98011779785156),\n",
       " (14, 1981, 12, 28.09064292907715, 28.07967185974121),\n",
       " (15, 1981, 12, 4.382839679718018, 3.29067325592041),\n",
       " (16, 1981, 12, 18.314638137817383, 18.181163787841797),\n",
       " (17, 1981, 12, 1.4957925081253052, 1.4898592233657837),\n",
       " (18, 1981, 12, 7.753018379211426, 7.687811374664307),\n",
       " (19, 1981, 12, 20.395456314086914, 20.383081436157227),\n",
       " (20, 1981, 12, 11.454695701599121, 11.34115219116211),\n",
       " (21, 1981, 12, 3.706450939178467, 3.699186086654663),\n",
       " (22, 1981, 12, 11.384257316589355, 10.962510108947754),\n",
       " (23, 1981, 12, 3.687631845474243, 3.6421847343444824)]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR=1981"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 2.4 use *AND* to further filter data\n",
    "\n",
    "There are 23 RCHs. We are only intersted in the 10th RCH. We can add another filter condition with an ***AND*** statement."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>1</td>\n",
       "        <td>53.9464225769</td>\n",
       "        <td>53.8569450378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>2</td>\n",
       "        <td>29.2481822968</td>\n",
       "        <td>29.1108722687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>3</td>\n",
       "        <td>8.96465682983</td>\n",
       "        <td>8.77624034882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>4</td>\n",
       "        <td>14.4726667404</td>\n",
       "        <td>14.11287117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>5</td>\n",
       "        <td>283.817962646</td>\n",
       "        <td>283.138671875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>6</td>\n",
       "        <td>295.130584717</td>\n",
       "        <td>294.550354004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>7</td>\n",
       "        <td>914.50769043</td>\n",
       "        <td>913.317687988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>8</td>\n",
       "        <td>484.746643066</td>\n",
       "        <td>483.543670654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>9</td>\n",
       "        <td>395.668182373</td>\n",
       "        <td>395.08782959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>10</td>\n",
       "        <td>283.008361816</td>\n",
       "        <td>282.70489502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>11</td>\n",
       "        <td>180.46812439</td>\n",
       "        <td>180.268310547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1981</td>\n",
       "        <td>12</td>\n",
       "        <td>105.923088074</td>\n",
       "        <td>105.824157715</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(10, 1981, 1, 53.9464225769043, 53.8569450378418),\n",
       " (10, 1981, 2, 29.24818229675293, 29.110872268676758),\n",
       " (10, 1981, 3, 8.964656829833984, 8.776240348815918),\n",
       " (10, 1981, 4, 14.47266674041748, 14.112871170043945),\n",
       " (10, 1981, 5, 283.8179626464844, 283.138671875),\n",
       " (10, 1981, 6, 295.1305847167969, 294.55035400390625),\n",
       " (10, 1981, 7, 914.5076904296875, 913.3176879882812),\n",
       " (10, 1981, 8, 484.74664306640625, 483.5436706542969),\n",
       " (10, 1981, 9, 395.6681823730469, 395.08782958984375),\n",
       " (10, 1981, 10, 283.00836181640625, 282.70489501953125),\n",
       " (10, 1981, 11, 180.46812438964844, 180.268310546875),\n",
       " (10, 1981, 12, 105.92308807373047, 105.82415771484375)]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR=1981 AND RCH=10"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 2.5 More combinations of filters"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We also can further filter data with the operators of ***!=*** or ***<>*** to get data except 1981."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1982</td>\n",
       "        <td>6</td>\n",
       "        <td>302.102752686</td>\n",
       "        <td>301.51776123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1983</td>\n",
       "        <td>6</td>\n",
       "        <td>365.016448975</td>\n",
       "        <td>364.40713501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1984</td>\n",
       "        <td>6</td>\n",
       "        <td>449.145935059</td>\n",
       "        <td>447.812042236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1985</td>\n",
       "        <td>6</td>\n",
       "        <td>758.143554688</td>\n",
       "        <td>756.645263672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1986</td>\n",
       "        <td>6</td>\n",
       "        <td>870.412658691</td>\n",
       "        <td>869.057739258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1987</td>\n",
       "        <td>6</td>\n",
       "        <td>1056.38342285</td>\n",
       "        <td>1055.84851074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1988</td>\n",
       "        <td>6</td>\n",
       "        <td>1113.93493652</td>\n",
       "        <td>1112.7064209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1989</td>\n",
       "        <td>6</td>\n",
       "        <td>987.139953613</td>\n",
       "        <td>986.576782227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1990</td>\n",
       "        <td>6</td>\n",
       "        <td>545.149536133</td>\n",
       "        <td>543.622314453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1991</td>\n",
       "        <td>6</td>\n",
       "        <td>773.328369141</td>\n",
       "        <td>772.104614258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1992</td>\n",
       "        <td>6</td>\n",
       "        <td>1428.33520508</td>\n",
       "        <td>1427.29016113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1993</td>\n",
       "        <td>6</td>\n",
       "        <td>885.836853027</td>\n",
       "        <td>884.772827148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1994</td>\n",
       "        <td>6</td>\n",
       "        <td>471.225097656</td>\n",
       "        <td>469.340789795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1995</td>\n",
       "        <td>6</td>\n",
       "        <td>804.130493164</td>\n",
       "        <td>803.692321777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1996</td>\n",
       "        <td>6</td>\n",
       "        <td>204.254928589</td>\n",
       "        <td>203.751907349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1997</td>\n",
       "        <td>6</td>\n",
       "        <td>956.59185791</td>\n",
       "        <td>955.36340332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1998</td>\n",
       "        <td>6</td>\n",
       "        <td>644.835632324</td>\n",
       "        <td>644.262268066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>1999</td>\n",
       "        <td>6</td>\n",
       "        <td>627.244873047</td>\n",
       "        <td>626.639770508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2000</td>\n",
       "        <td>6</td>\n",
       "        <td>366.443786621</td>\n",
       "        <td>364.90145874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2001</td>\n",
       "        <td>6</td>\n",
       "        <td>302.400482178</td>\n",
       "        <td>301.082336426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2002</td>\n",
       "        <td>6</td>\n",
       "        <td>334.627410889</td>\n",
       "        <td>333.064086914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2003</td>\n",
       "        <td>6</td>\n",
       "        <td>442.136871338</td>\n",
       "        <td>440.744934082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2004</td>\n",
       "        <td>6</td>\n",
       "        <td>509.455718994</td>\n",
       "        <td>508.104125977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2005</td>\n",
       "        <td>6</td>\n",
       "        <td>645.054748535</td>\n",
       "        <td>643.606262207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2006</td>\n",
       "        <td>6</td>\n",
       "        <td>406.526245117</td>\n",
       "        <td>405.030456543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2007</td>\n",
       "        <td>6</td>\n",
       "        <td>553.62902832</td>\n",
       "        <td>552.262817383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2008</td>\n",
       "        <td>6</td>\n",
       "        <td>365.640289307</td>\n",
       "        <td>364.384613037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2009</td>\n",
       "        <td>6</td>\n",
       "        <td>600.470275879</td>\n",
       "        <td>599.02142334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>6</td>\n",
       "        <td>736.301635742</td>\n",
       "        <td>734.99206543</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(10, 1982, 6, 302.1027526855469, 301.51776123046875),\n",
       " (10, 1983, 6, 365.0164489746094, 364.4071350097656),\n",
       " (10, 1984, 6, 449.14593505859375, 447.8120422363281),\n",
       " (10, 1985, 6, 758.1435546875, 756.645263671875),\n",
       " (10, 1986, 6, 870.4126586914062, 869.0577392578125),\n",
       " (10, 1987, 6, 1056.3834228515625, 1055.8485107421875),\n",
       " (10, 1988, 6, 1113.9349365234375, 1112.7064208984375),\n",
       " (10, 1989, 6, 987.1399536132812, 986.5767822265625),\n",
       " (10, 1990, 6, 545.1495361328125, 543.622314453125),\n",
       " (10, 1991, 6, 773.328369140625, 772.1046142578125),\n",
       " (10, 1992, 6, 1428.335205078125, 1427.2901611328125),\n",
       " (10, 1993, 6, 885.8368530273438, 884.7728271484375),\n",
       " (10, 1994, 6, 471.22509765625, 469.3407897949219),\n",
       " (10, 1995, 6, 804.1304931640625, 803.6923217773438),\n",
       " (10, 1996, 6, 204.2549285888672, 203.7519073486328),\n",
       " (10, 1997, 6, 956.5918579101562, 955.3634033203125),\n",
       " (10, 1998, 6, 644.8356323242188, 644.2622680664062),\n",
       " (10, 1999, 6, 627.244873046875, 626.6397705078125),\n",
       " (10, 2000, 6, 366.44378662109375, 364.9014587402344),\n",
       " (10, 2001, 6, 302.4004821777344, 301.08233642578125),\n",
       " (10, 2002, 6, 334.6274108886719, 333.0640869140625),\n",
       " (10, 2003, 6, 442.1368713378906, 440.74493408203125),\n",
       " (10, 2004, 6, 509.4557189941406, 508.1041259765625),\n",
       " (10, 2005, 6, 645.0547485351562, 643.6062622070312),\n",
       " (10, 2006, 6, 406.5262451171875, 405.03045654296875),\n",
       " (10, 2007, 6, 553.6290283203125, 552.2628173828125),\n",
       " (10, 2008, 6, 365.6402893066406, 364.3846130371094),\n",
       " (10, 2009, 6, 600.4702758789062, 599.0214233398438),\n",
       " (10, 2010, 6, 736.3016357421875, 734.9920654296875)]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR<>1981 and RCH=10 and MO=6"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can further filter the data to spefic months using ***OR*** statement. For example, we'd like check the data in the months of 3, 6 and 9. However, we have to use ***()*** to make them as one condition.:) It is a trick. You can try!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>3</td>\n",
       "        <td>3.42989563942</td>\n",
       "        <td>3.08460569382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>6</td>\n",
       "        <td>736.301635742</td>\n",
       "        <td>734.99206543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>9</td>\n",
       "        <td>218.407974243</td>\n",
       "        <td>218.244567871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>12</td>\n",
       "        <td>36.955821991</td>\n",
       "        <td>36.8774642944</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(10, 2010, 3, 3.4298956394195557, 3.0846056938171387),\n",
       " (10, 2010, 6, 736.3016357421875, 734.9920654296875),\n",
       " (10, 2010, 9, 218.40797424316406, 218.24456787109375),\n",
       " (10, 2010, 12, 36.9558219909668, 36.877464294433594)]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR>2009 and RCH=10 and (MO=3 or MO=6 or MO=9 or MO=12)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Or we can simplify the above filter using the ***IN*** statement."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>3</td>\n",
       "        <td>3.42989563942</td>\n",
       "        <td>3.08460569382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>6</td>\n",
       "        <td>736.301635742</td>\n",
       "        <td>734.99206543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>9</td>\n",
       "        <td>218.407974243</td>\n",
       "        <td>218.244567871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>12</td>\n",
       "        <td>36.955821991</td>\n",
       "        <td>36.8774642944</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(10, 2010, 3, 3.4298956394195557, 3.0846056938171387),\n",
       " (10, 2010, 6, 736.3016357421875, 734.9920654296875),\n",
       " (10, 2010, 9, 218.40797424316406, 218.24456787109375),\n",
       " (10, 2010, 12, 36.9558219909668, 36.877464294433594)]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR>2009 and RCH=10 and MO in (3, 6, 9, 12)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Or the months are ***NOT*** in 3, 6, 9, 12"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>1</td>\n",
       "        <td>9.61946868896</td>\n",
       "        <td>9.42282390594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>2</td>\n",
       "        <td>6.12970209122</td>\n",
       "        <td>5.86469078064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>4</td>\n",
       "        <td>258.67010498</td>\n",
       "        <td>258.120391846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>5</td>\n",
       "        <td>1513.65100098</td>\n",
       "        <td>1512.54797363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>7</td>\n",
       "        <td>583.045654297</td>\n",
       "        <td>582.321472168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>8</td>\n",
       "        <td>371.084136963</td>\n",
       "        <td>370.764801025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>10</td>\n",
       "        <td>123.484092712</td>\n",
       "        <td>123.366226196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>11</td>\n",
       "        <td>68.6158676147</td>\n",
       "        <td>68.5250473022</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(10, 2010, 1, 9.619468688964844, 9.422823905944824),\n",
       " (10, 2010, 2, 6.129702091217041, 5.864690780639648),\n",
       " (10, 2010, 4, 258.67010498046875, 258.1203918457031),\n",
       " (10, 2010, 5, 1513.6510009765625, 1512.5479736328125),\n",
       " (10, 2010, 7, 583.045654296875, 582.3214721679688),\n",
       " (10, 2010, 8, 371.0841369628906, 370.7648010253906),\n",
       " (10, 2010, 10, 123.48409271240234, 123.36622619628906),\n",
       " (10, 2010, 11, 68.6158676147461, 68.5250473022461)]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR>2009 and RCH=10 and MO NOT IN (3,6,9,12)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 2.6 Filter with math operators\n",
    "\n",
    "For example,  we could use the modulus operator (%) to filter the MOs."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///data/demo.db3\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>RCH</th>\n",
       "        <th>YR</th>\n",
       "        <th>MO</th>\n",
       "        <th>FLOW_INcms</th>\n",
       "        <th>FLOW_OUTcms</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>3</td>\n",
       "        <td>3.42989563942</td>\n",
       "        <td>3.08460569382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>6</td>\n",
       "        <td>736.301635742</td>\n",
       "        <td>734.99206543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>9</td>\n",
       "        <td>218.407974243</td>\n",
       "        <td>218.244567871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>2010</td>\n",
       "        <td>12</td>\n",
       "        <td>36.955821991</td>\n",
       "        <td>36.8774642944</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(10, 2010, 3, 3.4298956394195557, 3.0846056938171387),\n",
       " (10, 2010, 6, 736.3016357421875, 734.9920654296875),\n",
       " (10, 2010, 9, 218.40797424316406, 218.24456787109375),\n",
       " (10, 2010, 12, 36.9558219909668, 36.877464294433594)]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%sql SELECT RCH, YR, MO, FLOW_INcms, FLOW_OUTcms From rch WHERE YR>2009 and RCH=10 and MO % 3 = 0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Summary\n",
    "\n",
    "In the WHERE statement, we can the combinations of ***NOT, IN, <>, !=, >=, >, <, <=, AND, OR, ()*** and even some of math operators (such as %, *, /, +, -)to retrieve the data we want easily and efficiently. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}