01. EDA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#### PACKAGE AND DATA IMPORTS\n",
    "##########################\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.preprocessing import Imputer\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "train_df = pd.read_csv('./kaggle_data/train.csv')\n",
    "weather_df = pd.read_csv('./kaggle_data/weather.csv')\n",
    "spray_df = pd.read_csv('./kaggle_data/spray.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Address</th>\n",
       "      <th>Species</th>\n",
       "      <th>Block</th>\n",
       "      <th>Street</th>\n",
       "      <th>Trap</th>\n",
       "      <th>AddressNumberAndStreet</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>AddressAccuracy</th>\n",
       "      <th>NumMosquitos</th>\n",
       "      <th>WnvPresent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2007-05-29</td>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2007-05-29</td>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2007-05-29</td>\n",
       "      <td>6200 North Mandell Avenue, Chicago, IL 60646, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>62</td>\n",
       "      <td>N MANDELL AVE</td>\n",
       "      <td>T007</td>\n",
       "      <td>6200  N MANDELL AVE, Chicago, IL</td>\n",
       "      <td>41.994991</td>\n",
       "      <td>-87.769279</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2007-05-29</td>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2007-05-29</td>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date                                            Address  \\\n",
       "0  2007-05-29  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "1  2007-05-29  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2  2007-05-29  6200 North Mandell Avenue, Chicago, IL 60646, USA   \n",
       "3  2007-05-29    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "4  2007-05-29    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "\n",
       "                  Species  Block           Street  Trap  \\\n",
       "0  CULEX PIPIENS/RESTUANS     41   N OAK PARK AVE  T002   \n",
       "1          CULEX RESTUANS     41   N OAK PARK AVE  T002   \n",
       "2          CULEX RESTUANS     62    N MANDELL AVE  T007   \n",
       "3  CULEX PIPIENS/RESTUANS     79     W FOSTER AVE  T015   \n",
       "4          CULEX RESTUANS     79     W FOSTER AVE  T015   \n",
       "\n",
       "              AddressNumberAndStreet   Latitude  Longitude  AddressAccuracy  \\\n",
       "0  4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991                9   \n",
       "1  4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991                9   \n",
       "2   6200  N MANDELL AVE, Chicago, IL  41.994991 -87.769279                9   \n",
       "3    7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812                8   \n",
       "4    7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812                8   \n",
       "\n",
       "   NumMosquitos  WnvPresent  \n",
       "0             1           0  \n",
       "1             1           0  \n",
       "2             1           0  \n",
       "3             1           0  \n",
       "4             4           0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "###  EDA\n",
    "##########################\n",
    "train_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Station</th>\n",
       "      <th>Date</th>\n",
       "      <th>Tmax</th>\n",
       "      <th>Tmin</th>\n",
       "      <th>Tavg</th>\n",
       "      <th>Depart</th>\n",
       "      <th>DewPoint</th>\n",
       "      <th>WetBulb</th>\n",
       "      <th>Heat</th>\n",
       "      <th>Cool</th>\n",
       "      <th>...</th>\n",
       "      <th>CodeSum</th>\n",
       "      <th>Depth</th>\n",
       "      <th>Water1</th>\n",
       "      <th>SnowFall</th>\n",
       "      <th>PrecipTotal</th>\n",
       "      <th>StnPressure</th>\n",
       "      <th>SeaLevel</th>\n",
       "      <th>ResultSpeed</th>\n",
       "      <th>ResultDir</th>\n",
       "      <th>AvgSpeed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2007-05-01</td>\n",
       "      <td>83</td>\n",
       "      <td>50</td>\n",
       "      <td>67</td>\n",
       "      <td>14</td>\n",
       "      <td>51</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>M</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.82</td>\n",
       "      <td>1.7</td>\n",
       "      <td>27</td>\n",
       "      <td>9.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2007-05-01</td>\n",
       "      <td>84</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>M</td>\n",
       "      <td>51</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>M</td>\n",
       "      <td>M</td>\n",
       "      <td>M</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.18</td>\n",
       "      <td>29.82</td>\n",
       "      <td>2.7</td>\n",
       "      <td>25</td>\n",
       "      <td>9.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>2007-05-02</td>\n",
       "      <td>59</td>\n",
       "      <td>42</td>\n",
       "      <td>51</td>\n",
       "      <td>-3</td>\n",
       "      <td>42</td>\n",
       "      <td>47</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>M</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.38</td>\n",
       "      <td>30.09</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4</td>\n",
       "      <td>13.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>2007-05-02</td>\n",
       "      <td>60</td>\n",
       "      <td>43</td>\n",
       "      <td>52</td>\n",
       "      <td>M</td>\n",
       "      <td>42</td>\n",
       "      <td>47</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>M</td>\n",
       "      <td>M</td>\n",
       "      <td>M</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.44</td>\n",
       "      <td>30.08</td>\n",
       "      <td>13.3</td>\n",
       "      <td>2</td>\n",
       "      <td>13.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>2007-05-03</td>\n",
       "      <td>66</td>\n",
       "      <td>46</td>\n",
       "      <td>56</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>48</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>M</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.12</td>\n",
       "      <td>11.7</td>\n",
       "      <td>7</td>\n",
       "      <td>11.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Station        Date  Tmax  Tmin Tavg Depart  DewPoint WetBulb Heat Cool  \\\n",
       "0        1  2007-05-01    83    50   67     14        51      56    0    2   \n",
       "1        2  2007-05-01    84    52   68      M        51      57    0    3   \n",
       "2        1  2007-05-02    59    42   51     -3        42      47   14    0   \n",
       "3        2  2007-05-02    60    43   52      M        42      47   13    0   \n",
       "4        1  2007-05-03    66    46   56      2        40      48    9    0   \n",
       "\n",
       "     ...    CodeSum Depth Water1 SnowFall PrecipTotal StnPressure SeaLevel  \\\n",
       "0    ...                0      M      0.0        0.00       29.10    29.82   \n",
       "1    ...                M      M        M        0.00       29.18    29.82   \n",
       "2    ...         BR     0      M      0.0        0.00       29.38    30.09   \n",
       "3    ...      BR HZ     M      M        M        0.00       29.44    30.08   \n",
       "4    ...                0      M      0.0        0.00       29.39    30.12   \n",
       "\n",
       "  ResultSpeed ResultDir  AvgSpeed  \n",
       "0         1.7        27       9.2  \n",
       "1         2.7        25       9.6  \n",
       "2        13.0         4      13.4  \n",
       "3        13.3         2      13.4  \n",
       "4        11.7         7      11.9  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#sns.heatmap(train_df.corr(), annot=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Unsurprisingly, the likelihood of WNV increases as the number of mosquitos increase, but NumMosquitos is not a feature in the test set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# print(train_df.shape)\n",
    "# train_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# print(spray_df.shape)\n",
    "# spray_df.isnull().sum()\n",
    "                 ## We will need to deal with these time nulls, but it may make sense to drop the time column\n",
    "                  # since the other dfs dont have time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# print(spray_df.shape)\n",
    "# weather_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    " # dropping time from spray data because it is not in any other dfs\n",
    "spray_df.drop('Time', axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# creating weather data df using only one station\n",
    "daily_weather = weather_df[weather_df['Station'] == 1] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ryan/anaconda3/lib/python3.6/site-packages/pandas/core/frame.py:3694: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  errors=errors)\n"
     ]
    }
   ],
   "source": [
    "# dropping station label since all are station 1\n",
    "daily_weather.drop('Station', axis= 1, inplace=True) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ryan/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    " # datetime index on weather data\n",
    "daily_weather.reset_index(inplace=True, drop=True) \n",
    "\n",
    "daily_weather['Date'] = pd.to_datetime(daily_weather['Date']) \n",
    "\n",
    "daily_weather.set_index('Date',inplace=True, drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "#datetime index on training data\n",
    "train_df['Date'] = pd.to_datetime(train_df['Date'])\n",
    "\n",
    "train_df.set_index('Date', inplace=True, drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# new_df = combined weather and train data\n",
    "new_df = pd.merge(train_df, \n",
    "                  daily_weather, \n",
    "                  left_on = train_df.index, right_on = daily_weather.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "#assiging date as index of new_df \n",
    "new_df['key_0'] = pd.to_datetime(new_df['key_0'])\n",
    "\n",
    "new_df.set_index('key_0', inplace=True, drop=True)\n",
    "\n",
    "new_df.index.rename('Date', inplace=True) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# dropping these columns since they provided no info\n",
    "new_df.drop(['Water1','SnowFall'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# storing mode precip value for replacement in next step\n",
    "mode_precip = float(new_df[new_df['PrecipTotal'] != '  T'].StnPressure.mode()[0]) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# replacing '  T' in PrecipTotal column with mode precip value\n",
    "precip_totals = []\n",
    "for total in new_df.PrecipTotal:\n",
    "    if total == '  T':\n",
    "        precip_totals.append(mode_precip)\n",
    "    else:\n",
    "        precip_totals.append(total)\n",
    "\n",
    "new_df.PrecipTotal = pd.to_numeric(precip_totals) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# storing mode pressure for replacement in next step\n",
    "mode_pressure = new_df[new_df['StnPressure'] != 'M'].StnPressure.mode() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# replacing 'M' in StnPressure column with mode pressure value\n",
    "pressures = []\n",
    "for pressure in new_df.StnPressure:\n",
    "    if pressure == 'M':\n",
    "        pressures.append(mode_pressure)\n",
    "    else:\n",
    "        pressures.append(pressure)\n",
    "pressures = [float(pressure) for pressure in pressures]\n",
    "\n",
    "new_df.StnPressure = pd.to_numeric(pressures) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "pressures = [float(pressure) for pressure in pressures] # converting strings to floats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "#new_df.dtypes\n",
    "cols_to_change = ['Tavg',\n",
    "                 'Depart',\n",
    "                 'Cool',\n",
    "                 'Sunrise',\n",
    "                 'Sunset',\n",
    "                 'Depth',\n",
    "                 'PrecipTotal',\n",
    "                 'StnPressure',\n",
    "                 'SeaLevel',\n",
    "                 'AvgSpeed'\n",
    "                 ] # columns of type object that can be coerced to numeric values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "for col in cols_to_change:\n",
    "    new_df[col] = pd.to_numeric(new_df[col])#changing columns above to numeric"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Species</th>\n",
       "      <th>Block</th>\n",
       "      <th>Street</th>\n",
       "      <th>Trap</th>\n",
       "      <th>AddressNumberAndStreet</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>AddressAccuracy</th>\n",
       "      <th>NumMosquitos</th>\n",
       "      <th>...</th>\n",
       "      <th>Sunrise</th>\n",
       "      <th>Sunset</th>\n",
       "      <th>CodeSum</th>\n",
       "      <th>Depth</th>\n",
       "      <th>PrecipTotal</th>\n",
       "      <th>StnPressure</th>\n",
       "      <th>SeaLevel</th>\n",
       "      <th>ResultSpeed</th>\n",
       "      <th>ResultDir</th>\n",
       "      <th>AvgSpeed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>6200 North Mandell Avenue, Chicago, IL 60646, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>62</td>\n",
       "      <td>N MANDELL AVE</td>\n",
       "      <td>T007</td>\n",
       "      <td>6200  N MANDELL AVE, Chicago, IL</td>\n",
       "      <td>41.994991</td>\n",
       "      <td>-87.769279</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1500 West Webster Avenue, Chicago, IL 60614, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>15</td>\n",
       "      <td>W WEBSTER AVE</td>\n",
       "      <td>T045</td>\n",
       "      <td>1500  W WEBSTER AVE, Chicago, IL</td>\n",
       "      <td>41.921600</td>\n",
       "      <td>-87.666455</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2500 West Grand Avenue, Chicago, IL 60654, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>25</td>\n",
       "      <td>W GRAND AVE</td>\n",
       "      <td>T046</td>\n",
       "      <td>2500  W GRAND AVE, Chicago, IL</td>\n",
       "      <td>41.891118</td>\n",
       "      <td>-87.654491</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 Roosevelt Road, Chicago, IL 60608, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>W ROOSEVELT</td>\n",
       "      <td>T048</td>\n",
       "      <td>1100  W ROOSEVELT, Chicago, IL</td>\n",
       "      <td>41.867108</td>\n",
       "      <td>-87.654224</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 Roosevelt Road, Chicago, IL 60608, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>W ROOSEVELT</td>\n",
       "      <td>T048</td>\n",
       "      <td>1100  W ROOSEVELT, Chicago, IL</td>\n",
       "      <td>41.867108</td>\n",
       "      <td>-87.654224</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 West Chicago Avenue, Chicago, IL 60642, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>W CHICAGO</td>\n",
       "      <td>T049</td>\n",
       "      <td>1100  W CHICAGO, Chicago, IL</td>\n",
       "      <td>41.896282</td>\n",
       "      <td>-87.655232</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2100 North Stave Street, Chicago, IL 60647, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>21</td>\n",
       "      <td>N STAVE ST</td>\n",
       "      <td>T050</td>\n",
       "      <td>2100  N STAVE ST, Chicago, IL</td>\n",
       "      <td>41.919343</td>\n",
       "      <td>-87.694259</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 North Cannon Drive, Chicago, IL 60614, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>N CANNON DR</td>\n",
       "      <td>T054</td>\n",
       "      <td>2200  N CANNON DR, Chicago, IL</td>\n",
       "      <td>41.921965</td>\n",
       "      <td>-87.632085</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 North Cannon Drive, Chicago, IL 60614, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>N CANNON DR</td>\n",
       "      <td>T054</td>\n",
       "      <td>2200  N CANNON DR, Chicago, IL</td>\n",
       "      <td>41.921965</td>\n",
       "      <td>-87.632085</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 113th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 113TH ST</td>\n",
       "      <td>T086</td>\n",
       "      <td>2200  W 113TH ST, Chicago, IL</td>\n",
       "      <td>41.688324</td>\n",
       "      <td>-87.676709</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 113th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 113TH ST</td>\n",
       "      <td>T086</td>\n",
       "      <td>2200  W 113TH ST, Chicago, IL</td>\n",
       "      <td>41.688324</td>\n",
       "      <td>-87.676709</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 South Peoria Street, Chicago, IL 60608, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>S PEORIA ST</td>\n",
       "      <td>T091</td>\n",
       "      <td>1100  S PEORIA ST, Chicago, IL</td>\n",
       "      <td>41.862292</td>\n",
       "      <td>-87.648860</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1700 West 95th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>17</td>\n",
       "      <td>W 95TH ST</td>\n",
       "      <td>T094</td>\n",
       "      <td>1700  W 95TH ST, Chicago, IL</td>\n",
       "      <td>41.720848</td>\n",
       "      <td>-87.666014</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 89th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 89TH ST</td>\n",
       "      <td>T096</td>\n",
       "      <td>2200  W 89TH ST, Chicago, IL</td>\n",
       "      <td>41.731922</td>\n",
       "      <td>-87.677512</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 89th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 89TH ST</td>\n",
       "      <td>T096</td>\n",
       "      <td>2200  W 89TH ST, Chicago, IL</td>\n",
       "      <td>41.731922</td>\n",
       "      <td>-87.677512</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>North Streeter Drive, Chicago, IL 60611, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>53</td>\n",
       "      <td>N STREETER DR</td>\n",
       "      <td>T129</td>\n",
       "      <td>5300  N STREETER DR, Chicago, IL</td>\n",
       "      <td>41.891126</td>\n",
       "      <td>-87.611560</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>North Streeter Drive, Chicago, IL 60611, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>53</td>\n",
       "      <td>N STREETER DR</td>\n",
       "      <td>T129</td>\n",
       "      <td>5300  N STREETER DR, Chicago, IL</td>\n",
       "      <td>41.891126</td>\n",
       "      <td>-87.611560</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>6500 North Oak Park Avenue, Chicago, IL 60631,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>65</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T143</td>\n",
       "      <td>6500  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.999129</td>\n",
       "      <td>-87.795585</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>7500 North Oakley Avenue, Chicago, IL 60645, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>75</td>\n",
       "      <td>N OAKLEY AVE</td>\n",
       "      <td>T148</td>\n",
       "      <td>7500  N OAKLEY AVE, Chicago, IL</td>\n",
       "      <td>42.017430</td>\n",
       "      <td>-87.687769</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1500 North Long Avenue, Chicago, IL 60651, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>15</td>\n",
       "      <td>N LONG AVE</td>\n",
       "      <td>T153</td>\n",
       "      <td>1500  N LONG AVE, Chicago, IL</td>\n",
       "      <td>41.907645</td>\n",
       "      <td>-87.760886</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>8900 South Carpenter Street, Chicago, IL 60620...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>89</td>\n",
       "      <td>S CARPENTER ST</td>\n",
       "      <td>T159</td>\n",
       "      <td>8900  S CARPENTER ST, Chicago, IL</td>\n",
       "      <td>41.732984</td>\n",
       "      <td>-87.649642</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>South Cottage Grove Avenue, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>S COTTAGE GROVE</td>\n",
       "      <td>T102</td>\n",
       "      <td>1000  S COTTAGE GROVE, Chicago, IL</td>\n",
       "      <td>41.750498</td>\n",
       "      <td>-87.605294</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>South Cottage Grove Avenue, Chicago, IL, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>S COTTAGE GROVE</td>\n",
       "      <td>T102</td>\n",
       "      <td>1000  S COTTAGE GROVE, Chicago, IL</td>\n",
       "      <td>41.750498</td>\n",
       "      <td>-87.605294</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>South Cottage Grove Avenue, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>S COTTAGE GROVE</td>\n",
       "      <td>T102</td>\n",
       "      <td>1000  S COTTAGE GROVE, Chicago, IL</td>\n",
       "      <td>41.750498</td>\n",
       "      <td>-87.605294</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5800 North Pulaski Road, Chicago, IL 60646, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>58</td>\n",
       "      <td>N PULASKI RD</td>\n",
       "      <td>T027</td>\n",
       "      <td>5800  N PULASKI RD, Chicago, IL</td>\n",
       "      <td>41.984809</td>\n",
       "      <td>-87.728492</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4000 East 130th Street, Chicago, IL 60633, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>40</td>\n",
       "      <td>E 130TH ST</td>\n",
       "      <td>T221</td>\n",
       "      <td>4000  E 130TH ST, Chicago, IL</td>\n",
       "      <td>41.659112</td>\n",
       "      <td>-87.538693</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4000 East 130th Street, Chicago, IL 60633, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>40</td>\n",
       "      <td>E 130TH ST</td>\n",
       "      <td>T221</td>\n",
       "      <td>4000  E 130TH ST, Chicago, IL</td>\n",
       "      <td>41.659112</td>\n",
       "      <td>-87.538693</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4000 East 130th Street, Chicago, IL 60633, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>40</td>\n",
       "      <td>E 130TH ST</td>\n",
       "      <td>T221</td>\n",
       "      <td>4000  E 130TH ST, Chicago, IL</td>\n",
       "      <td>41.659112</td>\n",
       "      <td>-87.538693</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>9100 West Higgins Road, Rosemont, IL 60018, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>91</td>\n",
       "      <td>W HIGGINS RD</td>\n",
       "      <td>T009</td>\n",
       "      <td>9100  W HIGGINS RD, Chicago, IL</td>\n",
       "      <td>41.992478</td>\n",
       "      <td>-87.862995</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4800 West Montana Street, Chicago, IL 60639, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>48</td>\n",
       "      <td>W MONTANA ST</td>\n",
       "      <td>T222</td>\n",
       "      <td>4800  W MONTANA ST, Chicago, IL</td>\n",
       "      <td>41.925198</td>\n",
       "      <td>-87.746381</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5100 North Mont Clare Avenue, Chicago, IL 6065...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>51</td>\n",
       "      <td>N MONT CLARE AVE</td>\n",
       "      <td>T223</td>\n",
       "      <td>5100  N MONT CLARE AVE, Chicago, IL</td>\n",
       "      <td>41.973845</td>\n",
       "      <td>-87.805059</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5100 North Mont Clare Avenue, Chicago, IL 6065...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>51</td>\n",
       "      <td>N MONT CLARE AVE</td>\n",
       "      <td>T223</td>\n",
       "      <td>5100  N MONT CLARE AVE, Chicago, IL</td>\n",
       "      <td>41.973845</td>\n",
       "      <td>-87.805059</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>8200 South Kostner Avenue, Chicago, IL 60652, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>82</td>\n",
       "      <td>S KOSTNER AVE</td>\n",
       "      <td>T225</td>\n",
       "      <td>8200  S KOSTNER AVE, Chicago, IL</td>\n",
       "      <td>41.743402</td>\n",
       "      <td>-87.731435</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>East 91st Place, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>65</td>\n",
       "      <td>E 91ST PL</td>\n",
       "      <td>T227</td>\n",
       "      <td>6500  E 91ST PL, Chicago, IL</td>\n",
       "      <td>41.728495</td>\n",
       "      <td>-87.600963</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>East 91st Place, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>65</td>\n",
       "      <td>E 91ST PL</td>\n",
       "      <td>T227</td>\n",
       "      <td>6500  E 91ST PL, Chicago, IL</td>\n",
       "      <td>41.728495</td>\n",
       "      <td>-87.600963</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1700 West Addison Street, Chicago, IL 60613, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>17</td>\n",
       "      <td>W ADDISON ST</td>\n",
       "      <td>T224</td>\n",
       "      <td>1700  W ADDISON ST, Chicago, IL</td>\n",
       "      <td>41.947227</td>\n",
       "      <td>-87.671457</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>West Garfield Boulevard, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>90</td>\n",
       "      <td>W GARFIELD BLVD</td>\n",
       "      <td>T226</td>\n",
       "      <td>9000  W GARFIELD BLVD, Chicago, IL</td>\n",
       "      <td>41.793818</td>\n",
       "      <td>-87.654234</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1300 North Laramie Avenue, Chicago, IL 60651, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>13</td>\n",
       "      <td>N LARAMIE AVE</td>\n",
       "      <td>T230</td>\n",
       "      <td>1300  N LARAMIE AVE, Chicago, IL</td>\n",
       "      <td>41.904194</td>\n",
       "      <td>-87.756155</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1300 North Laramie Avenue, Chicago, IL 60651, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>13</td>\n",
       "      <td>N LARAMIE AVE</td>\n",
       "      <td>T230</td>\n",
       "      <td>1300  N LARAMIE AVE, Chicago, IL</td>\n",
       "      <td>41.904194</td>\n",
       "      <td>-87.756155</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>3900 North Springfield Avenue, Chicago, IL 606...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>39</td>\n",
       "      <td>N SPRINGFIELD AVE</td>\n",
       "      <td>T228</td>\n",
       "      <td>3900  N SPRINGFIELD AVE, Chicago, IL</td>\n",
       "      <td>41.951866</td>\n",
       "      <td>-87.725057</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5100 West 72nd Street, Chicago, IL 60638, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>51</td>\n",
       "      <td>W 72ND ST</td>\n",
       "      <td>T035</td>\n",
       "      <td>5100  W 72ND ST, Chicago, IL</td>\n",
       "      <td>41.763733</td>\n",
       "      <td>-87.742302</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5800 North Ridge Avenue, Chicago, IL 60660, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>58</td>\n",
       "      <td>N RIDGE AVE</td>\n",
       "      <td>T231</td>\n",
       "      <td>5800  N RIDGE AVE, Chicago, IL</td>\n",
       "      <td>41.987280</td>\n",
       "      <td>-87.666066</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1700 North Ashland Avenue, Chicago, IL 60622, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>17</td>\n",
       "      <td>N ASHLAND AVE</td>\n",
       "      <td>T232</td>\n",
       "      <td>1700  N ASHLAND AVE, Chicago, IL</td>\n",
       "      <td>41.912563</td>\n",
       "      <td>-87.668055</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>7100 North Harlem Avenue, Chicago, IL 60631, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>71</td>\n",
       "      <td>N HARLEM AVE</td>\n",
       "      <td>T233</td>\n",
       "      <td>7100  N HARLEM AVE, Chicago, IL</td>\n",
       "      <td>42.009876</td>\n",
       "      <td>-87.807277</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4200 West 65th Street, Chicago, IL 60621, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>42</td>\n",
       "      <td>W 65TH ST</td>\n",
       "      <td>T235</td>\n",
       "      <td>4200  W 65TH ST, Chicago, IL</td>\n",
       "      <td>41.776428</td>\n",
       "      <td>-87.627096</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10506 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      Address  \\\n",
       "Date                                                            \n",
       "2007-05-29  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-05-29  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-05-29  6200 North Mandell Avenue, Chicago, IL 60646, USA   \n",
       "2007-05-29    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "2007-05-29    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "2007-05-29   1500 West Webster Avenue, Chicago, IL 60614, USA   \n",
       "2007-05-29     2500 West Grand Avenue, Chicago, IL 60654, USA   \n",
       "2007-05-29        1100 Roosevelt Road, Chicago, IL 60608, USA   \n",
       "2007-05-29        1100 Roosevelt Road, Chicago, IL 60608, USA   \n",
       "2007-05-29   1100 West Chicago Avenue, Chicago, IL 60642, USA   \n",
       "2007-05-29    2100 North Stave Street, Chicago, IL 60647, USA   \n",
       "2007-05-29    2200 North Cannon Drive, Chicago, IL 60614, USA   \n",
       "2007-05-29    2200 North Cannon Drive, Chicago, IL 60614, USA   \n",
       "2007-05-29     2200 West 113th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29     2200 West 113th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29   1100 South Peoria Street, Chicago, IL 60608, USA   \n",
       "2007-05-29      1700 West 95th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29      2200 West 89th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29      2200 West 89th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29       North Streeter Drive, Chicago, IL 60611, USA   \n",
       "2007-05-29       North Streeter Drive, Chicago, IL 60611, USA   \n",
       "2007-05-29  6500 North Oak Park Avenue, Chicago, IL 60631,...   \n",
       "2007-05-29   7500 North Oakley Avenue, Chicago, IL 60645, USA   \n",
       "2007-05-29     1500 North Long Avenue, Chicago, IL 60651, USA   \n",
       "2007-05-29  8900 South Carpenter Street, Chicago, IL 60620...   \n",
       "2007-06-05  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-06-05  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-06-05  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-06-05    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "2007-06-05    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "...                                                       ...   \n",
       "2013-09-26       South Cottage Grove Avenue, Chicago, IL, USA   \n",
       "2013-09-26       South Cottage Grove Avenue, Chicago, IL, USA   \n",
       "2013-09-26       South Cottage Grove Avenue, Chicago, IL, USA   \n",
       "2013-09-26    5800 North Pulaski Road, Chicago, IL 60646, USA   \n",
       "2013-09-26     4000 East 130th Street, Chicago, IL 60633, USA   \n",
       "2013-09-26     4000 East 130th Street, Chicago, IL 60633, USA   \n",
       "2013-09-26     4000 East 130th Street, Chicago, IL 60633, USA   \n",
       "2013-09-26    9100 West Higgins Road, Rosemont, IL 60018, USA   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26   4800 West Montana Street, Chicago, IL 60639, USA   \n",
       "2013-09-26  5100 North Mont Clare Avenue, Chicago, IL 6065...   \n",
       "2013-09-26  5100 North Mont Clare Avenue, Chicago, IL 6065...   \n",
       "2013-09-26  8200 South Kostner Avenue, Chicago, IL 60652, USA   \n",
       "2013-09-26                  East 91st Place, Chicago, IL, USA   \n",
       "2013-09-26                  East 91st Place, Chicago, IL, USA   \n",
       "2013-09-26   1700 West Addison Street, Chicago, IL 60613, USA   \n",
       "2013-09-26          West Garfield Boulevard, Chicago, IL, USA   \n",
       "2013-09-26  1300 North Laramie Avenue, Chicago, IL 60651, USA   \n",
       "2013-09-26  1300 North Laramie Avenue, Chicago, IL 60651, USA   \n",
       "2013-09-26  3900 North Springfield Avenue, Chicago, IL 606...   \n",
       "2013-09-26      5100 West 72nd Street, Chicago, IL 60638, USA   \n",
       "2013-09-26    5800 North Ridge Avenue, Chicago, IL 60660, USA   \n",
       "2013-09-26  1700 North Ashland Avenue, Chicago, IL 60622, USA   \n",
       "2013-09-26   7100 North Harlem Avenue, Chicago, IL 60631, USA   \n",
       "2013-09-26      4200 West 65th Street, Chicago, IL 60621, USA   \n",
       "\n",
       "                           Species  Block              Street  Trap  \\\n",
       "Date                                                                  \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-05-29          CULEX RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-05-29          CULEX RESTUANS     62       N MANDELL AVE  T007   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     79        W FOSTER AVE  T015   \n",
       "2007-05-29          CULEX RESTUANS     79        W FOSTER AVE  T015   \n",
       "2007-05-29          CULEX RESTUANS     15       W WEBSTER AVE  T045   \n",
       "2007-05-29          CULEX RESTUANS     25         W GRAND AVE  T046   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     11         W ROOSEVELT  T048   \n",
       "2007-05-29          CULEX RESTUANS     11         W ROOSEVELT  T048   \n",
       "2007-05-29          CULEX RESTUANS     11           W CHICAGO  T049   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     21          N STAVE ST  T050   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     22         N CANNON DR  T054   \n",
       "2007-05-29          CULEX RESTUANS     22         N CANNON DR  T054   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     22          W 113TH ST  T086   \n",
       "2007-05-29          CULEX RESTUANS     22          W 113TH ST  T086   \n",
       "2007-05-29          CULEX RESTUANS     11         S PEORIA ST  T091   \n",
       "2007-05-29          CULEX RESTUANS     17           W 95TH ST  T094   \n",
       "2007-05-29          CULEX RESTUANS     22           W 89TH ST  T096   \n",
       "2007-05-29           CULEX PIPIENS     22           W 89TH ST  T096   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     53       N STREETER DR  T129   \n",
       "2007-05-29          CULEX RESTUANS     53       N STREETER DR  T129   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     65      N OAK PARK AVE  T143   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     75        N OAKLEY AVE  T148   \n",
       "2007-05-29          CULEX RESTUANS     15          N LONG AVE  T153   \n",
       "2007-05-29          CULEX RESTUANS     89      S CARPENTER ST  T159   \n",
       "2007-06-05  CULEX PIPIENS/RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-06-05          CULEX RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-06-05           CULEX PIPIENS     41      N OAK PARK AVE  T002   \n",
       "2007-06-05  CULEX PIPIENS/RESTUANS     79        W FOSTER AVE  T015   \n",
       "2007-06-05          CULEX RESTUANS     79        W FOSTER AVE  T015   \n",
       "...                            ...    ...                 ...   ...   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     10     S COTTAGE GROVE  T102   \n",
       "2013-09-26          CULEX RESTUANS     10     S COTTAGE GROVE  T102   \n",
       "2013-09-26           CULEX PIPIENS     10     S COTTAGE GROVE  T102   \n",
       "2013-09-26           CULEX PIPIENS     58        N PULASKI RD  T027   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     40          E 130TH ST  T221   \n",
       "2013-09-26          CULEX RESTUANS     40          E 130TH ST  T221   \n",
       "2013-09-26           CULEX PIPIENS     40          E 130TH ST  T221   \n",
       "2013-09-26          CULEX RESTUANS     91        W HIGGINS RD  T009   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     48        W MONTANA ST  T222   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     51    N MONT CLARE AVE  T223   \n",
       "2013-09-26           CULEX PIPIENS     51    N MONT CLARE AVE  T223   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     82       S KOSTNER AVE  T225   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     65           E 91ST PL  T227   \n",
       "2013-09-26           CULEX PIPIENS     65           E 91ST PL  T227   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     17        W ADDISON ST  T224   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     90     W GARFIELD BLVD  T226   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     13       N LARAMIE AVE  T230   \n",
       "2013-09-26           CULEX PIPIENS     13       N LARAMIE AVE  T230   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     39   N SPRINGFIELD AVE  T228   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     51           W 72ND ST  T035   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     58         N RIDGE AVE  T231   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     17       N ASHLAND AVE  T232   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     71        N HARLEM AVE  T233   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     42           W 65TH ST  T235   \n",
       "\n",
       "                          AddressNumberAndStreet   Latitude  Longitude  \\\n",
       "Date                                                                     \n",
       "2007-05-29     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-05-29     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-05-29      6200  N MANDELL AVE, Chicago, IL  41.994991 -87.769279   \n",
       "2007-05-29       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "2007-05-29       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "2007-05-29      1500  W WEBSTER AVE, Chicago, IL  41.921600 -87.666455   \n",
       "2007-05-29        2500  W GRAND AVE, Chicago, IL  41.891118 -87.654491   \n",
       "2007-05-29        1100  W ROOSEVELT, Chicago, IL  41.867108 -87.654224   \n",
       "2007-05-29        1100  W ROOSEVELT, Chicago, IL  41.867108 -87.654224   \n",
       "2007-05-29          1100  W CHICAGO, Chicago, IL  41.896282 -87.655232   \n",
       "2007-05-29         2100  N STAVE ST, Chicago, IL  41.919343 -87.694259   \n",
       "2007-05-29        2200  N CANNON DR, Chicago, IL  41.921965 -87.632085   \n",
       "2007-05-29        2200  N CANNON DR, Chicago, IL  41.921965 -87.632085   \n",
       "2007-05-29         2200  W 113TH ST, Chicago, IL  41.688324 -87.676709   \n",
       "2007-05-29         2200  W 113TH ST, Chicago, IL  41.688324 -87.676709   \n",
       "2007-05-29        1100  S PEORIA ST, Chicago, IL  41.862292 -87.648860   \n",
       "2007-05-29          1700  W 95TH ST, Chicago, IL  41.720848 -87.666014   \n",
       "2007-05-29          2200  W 89TH ST, Chicago, IL  41.731922 -87.677512   \n",
       "2007-05-29          2200  W 89TH ST, Chicago, IL  41.731922 -87.677512   \n",
       "2007-05-29      5300  N STREETER DR, Chicago, IL  41.891126 -87.611560   \n",
       "2007-05-29      5300  N STREETER DR, Chicago, IL  41.891126 -87.611560   \n",
       "2007-05-29     6500  N OAK PARK AVE, Chicago, IL  41.999129 -87.795585   \n",
       "2007-05-29       7500  N OAKLEY AVE, Chicago, IL  42.017430 -87.687769   \n",
       "2007-05-29         1500  N LONG AVE, Chicago, IL  41.907645 -87.760886   \n",
       "2007-05-29     8900  S CARPENTER ST, Chicago, IL  41.732984 -87.649642   \n",
       "2007-06-05     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-06-05     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-06-05     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-06-05       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "2007-06-05       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "...                                          ...        ...        ...   \n",
       "2013-09-26    1000  S COTTAGE GROVE, Chicago, IL  41.750498 -87.605294   \n",
       "2013-09-26    1000  S COTTAGE GROVE, Chicago, IL  41.750498 -87.605294   \n",
       "2013-09-26    1000  S COTTAGE GROVE, Chicago, IL  41.750498 -87.605294   \n",
       "2013-09-26       5800  N PULASKI RD, Chicago, IL  41.984809 -87.728492   \n",
       "2013-09-26         4000  E 130TH ST, Chicago, IL  41.659112 -87.538693   \n",
       "2013-09-26         4000  E 130TH ST, Chicago, IL  41.659112 -87.538693   \n",
       "2013-09-26         4000  E 130TH ST, Chicago, IL  41.659112 -87.538693   \n",
       "2013-09-26       9100  W HIGGINS RD, Chicago, IL  41.992478 -87.862995   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26       4800  W MONTANA ST, Chicago, IL  41.925198 -87.746381   \n",
       "2013-09-26   5100  N MONT CLARE AVE, Chicago, IL  41.973845 -87.805059   \n",
       "2013-09-26   5100  N MONT CLARE AVE, Chicago, IL  41.973845 -87.805059   \n",
       "2013-09-26      8200  S KOSTNER AVE, Chicago, IL  41.743402 -87.731435   \n",
       "2013-09-26          6500  E 91ST PL, Chicago, IL  41.728495 -87.600963   \n",
       "2013-09-26          6500  E 91ST PL, Chicago, IL  41.728495 -87.600963   \n",
       "2013-09-26       1700  W ADDISON ST, Chicago, IL  41.947227 -87.671457   \n",
       "2013-09-26    9000  W GARFIELD BLVD, Chicago, IL  41.793818 -87.654234   \n",
       "2013-09-26      1300  N LARAMIE AVE, Chicago, IL  41.904194 -87.756155   \n",
       "2013-09-26      1300  N LARAMIE AVE, Chicago, IL  41.904194 -87.756155   \n",
       "2013-09-26  3900  N SPRINGFIELD AVE, Chicago, IL  41.951866 -87.725057   \n",
       "2013-09-26          5100  W 72ND ST, Chicago, IL  41.763733 -87.742302   \n",
       "2013-09-26        5800  N RIDGE AVE, Chicago, IL  41.987280 -87.666066   \n",
       "2013-09-26      1700  N ASHLAND AVE, Chicago, IL  41.912563 -87.668055   \n",
       "2013-09-26       7100  N HARLEM AVE, Chicago, IL  42.009876 -87.807277   \n",
       "2013-09-26          4200  W 65TH ST, Chicago, IL  41.776428 -87.627096   \n",
       "\n",
       "            AddressAccuracy  NumMosquitos    ...     Sunrise  Sunset  CodeSum  \\\n",
       "Date                                         ...                                \n",
       "2007-05-29                9             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                9             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                9             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             4    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             3    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                9             3    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             5    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                5             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                5             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-06-05                9             3    ...         417    1923    RA BR   \n",
       "2007-06-05                9             5    ...         417    1923    RA BR   \n",
       "2007-06-05                9             1    ...         417    1923    RA BR   \n",
       "2007-06-05                8             1    ...         417    1923    RA BR   \n",
       "2007-06-05                8             2    ...         417    1923    RA BR   \n",
       "...                     ...           ...    ...         ...     ...      ...   \n",
       "2013-09-26                5             2    ...         543    1742       BR   \n",
       "2013-09-26                5             1    ...         543    1742       BR   \n",
       "2013-09-26                5             1    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                8             4    ...         543    1742       BR   \n",
       "2013-09-26                8             1    ...         543    1742       BR   \n",
       "2013-09-26                9            39    ...         543    1742       BR   \n",
       "2013-09-26                9             4    ...         543    1742       BR   \n",
       "2013-09-26                9            16    ...         543    1742       BR   \n",
       "2013-09-26                9             9    ...         543    1742       BR   \n",
       "2013-09-26                9            11    ...         543    1742       BR   \n",
       "2013-09-26                9             1    ...         543    1742       BR   \n",
       "2013-09-26                8             1    ...         543    1742       BR   \n",
       "2013-09-26                9            11    ...         543    1742       BR   \n",
       "2013-09-26                9             1    ...         543    1742       BR   \n",
       "2013-09-26                8             3    ...         543    1742       BR   \n",
       "2013-09-26                5             7    ...         543    1742       BR   \n",
       "2013-09-26                5             1    ...         543    1742       BR   \n",
       "2013-09-26                9             3    ...         543    1742       BR   \n",
       "2013-09-26                5             8    ...         543    1742       BR   \n",
       "2013-09-26                9            13    ...         543    1742       BR   \n",
       "2013-09-26                9             5    ...         543    1742       BR   \n",
       "2013-09-26                8             3    ...         543    1742       BR   \n",
       "2013-09-26                8             6    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                9             1    ...         543    1742       BR   \n",
       "2013-09-26                9             5    ...         543    1742       BR   \n",
       "2013-09-26                8             1    ...         543    1742       BR   \n",
       "\n",
       "            Depth  PrecipTotal  StnPressure SeaLevel ResultSpeed  ResultDir  \\\n",
       "Date                                                                          \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "...           ...          ...          ...      ...         ...        ...   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "\n",
       "            AvgSpeed  \n",
       "Date                  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "...              ...  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "\n",
       "[10506 rows x 29 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Species</th>\n",
       "      <th>Block</th>\n",
       "      <th>Street</th>\n",
       "      <th>Trap</th>\n",
       "      <th>AddressNumberAndStreet</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>AddressAccuracy</th>\n",
       "      <th>NumMosquitos</th>\n",
       "      <th>...</th>\n",
       "      <th>Sunrise</th>\n",
       "      <th>Sunset</th>\n",
       "      <th>CodeSum</th>\n",
       "      <th>Depth</th>\n",
       "      <th>PrecipTotal</th>\n",
       "      <th>StnPressure</th>\n",
       "      <th>SeaLevel</th>\n",
       "      <th>ResultSpeed</th>\n",
       "      <th>ResultDir</th>\n",
       "      <th>AvgSpeed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>6200 North Mandell Avenue, Chicago, IL 60646, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>62</td>\n",
       "      <td>N MANDELL AVE</td>\n",
       "      <td>T007</td>\n",
       "      <td>6200  N MANDELL AVE, Chicago, IL</td>\n",
       "      <td>41.994991</td>\n",
       "      <td>-87.769279</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1500 West Webster Avenue, Chicago, IL 60614, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>15</td>\n",
       "      <td>W WEBSTER AVE</td>\n",
       "      <td>T045</td>\n",
       "      <td>1500  W WEBSTER AVE, Chicago, IL</td>\n",
       "      <td>41.921600</td>\n",
       "      <td>-87.666455</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2500 West Grand Avenue, Chicago, IL 60654, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>25</td>\n",
       "      <td>W GRAND AVE</td>\n",
       "      <td>T046</td>\n",
       "      <td>2500  W GRAND AVE, Chicago, IL</td>\n",
       "      <td>41.891118</td>\n",
       "      <td>-87.654491</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 Roosevelt Road, Chicago, IL 60608, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>W ROOSEVELT</td>\n",
       "      <td>T048</td>\n",
       "      <td>1100  W ROOSEVELT, Chicago, IL</td>\n",
       "      <td>41.867108</td>\n",
       "      <td>-87.654224</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 Roosevelt Road, Chicago, IL 60608, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>W ROOSEVELT</td>\n",
       "      <td>T048</td>\n",
       "      <td>1100  W ROOSEVELT, Chicago, IL</td>\n",
       "      <td>41.867108</td>\n",
       "      <td>-87.654224</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 West Chicago Avenue, Chicago, IL 60642, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>W CHICAGO</td>\n",
       "      <td>T049</td>\n",
       "      <td>1100  W CHICAGO, Chicago, IL</td>\n",
       "      <td>41.896282</td>\n",
       "      <td>-87.655232</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2100 North Stave Street, Chicago, IL 60647, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>21</td>\n",
       "      <td>N STAVE ST</td>\n",
       "      <td>T050</td>\n",
       "      <td>2100  N STAVE ST, Chicago, IL</td>\n",
       "      <td>41.919343</td>\n",
       "      <td>-87.694259</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 North Cannon Drive, Chicago, IL 60614, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>N CANNON DR</td>\n",
       "      <td>T054</td>\n",
       "      <td>2200  N CANNON DR, Chicago, IL</td>\n",
       "      <td>41.921965</td>\n",
       "      <td>-87.632085</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 North Cannon Drive, Chicago, IL 60614, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>N CANNON DR</td>\n",
       "      <td>T054</td>\n",
       "      <td>2200  N CANNON DR, Chicago, IL</td>\n",
       "      <td>41.921965</td>\n",
       "      <td>-87.632085</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 113th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 113TH ST</td>\n",
       "      <td>T086</td>\n",
       "      <td>2200  W 113TH ST, Chicago, IL</td>\n",
       "      <td>41.688324</td>\n",
       "      <td>-87.676709</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 113th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 113TH ST</td>\n",
       "      <td>T086</td>\n",
       "      <td>2200  W 113TH ST, Chicago, IL</td>\n",
       "      <td>41.688324</td>\n",
       "      <td>-87.676709</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1100 South Peoria Street, Chicago, IL 60608, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>11</td>\n",
       "      <td>S PEORIA ST</td>\n",
       "      <td>T091</td>\n",
       "      <td>1100  S PEORIA ST, Chicago, IL</td>\n",
       "      <td>41.862292</td>\n",
       "      <td>-87.648860</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1700 West 95th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>17</td>\n",
       "      <td>W 95TH ST</td>\n",
       "      <td>T094</td>\n",
       "      <td>1700  W 95TH ST, Chicago, IL</td>\n",
       "      <td>41.720848</td>\n",
       "      <td>-87.666014</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 89th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 89TH ST</td>\n",
       "      <td>T096</td>\n",
       "      <td>2200  W 89TH ST, Chicago, IL</td>\n",
       "      <td>41.731922</td>\n",
       "      <td>-87.677512</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>2200 West 89th Street, Chicago, IL 60643, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>22</td>\n",
       "      <td>W 89TH ST</td>\n",
       "      <td>T096</td>\n",
       "      <td>2200  W 89TH ST, Chicago, IL</td>\n",
       "      <td>41.731922</td>\n",
       "      <td>-87.677512</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>North Streeter Drive, Chicago, IL 60611, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>53</td>\n",
       "      <td>N STREETER DR</td>\n",
       "      <td>T129</td>\n",
       "      <td>5300  N STREETER DR, Chicago, IL</td>\n",
       "      <td>41.891126</td>\n",
       "      <td>-87.611560</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>North Streeter Drive, Chicago, IL 60611, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>53</td>\n",
       "      <td>N STREETER DR</td>\n",
       "      <td>T129</td>\n",
       "      <td>5300  N STREETER DR, Chicago, IL</td>\n",
       "      <td>41.891126</td>\n",
       "      <td>-87.611560</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>6500 North Oak Park Avenue, Chicago, IL 60631,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>65</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T143</td>\n",
       "      <td>6500  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.999129</td>\n",
       "      <td>-87.795585</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>7500 North Oakley Avenue, Chicago, IL 60645, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>75</td>\n",
       "      <td>N OAKLEY AVE</td>\n",
       "      <td>T148</td>\n",
       "      <td>7500  N OAKLEY AVE, Chicago, IL</td>\n",
       "      <td>42.017430</td>\n",
       "      <td>-87.687769</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>1500 North Long Avenue, Chicago, IL 60651, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>15</td>\n",
       "      <td>N LONG AVE</td>\n",
       "      <td>T153</td>\n",
       "      <td>1500  N LONG AVE, Chicago, IL</td>\n",
       "      <td>41.907645</td>\n",
       "      <td>-87.760886</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-05-29</th>\n",
       "      <td>8900 South Carpenter Street, Chicago, IL 60620...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>89</td>\n",
       "      <td>S CARPENTER ST</td>\n",
       "      <td>T159</td>\n",
       "      <td>8900  S CARPENTER ST, Chicago, IL</td>\n",
       "      <td>41.732984</td>\n",
       "      <td>-87.649642</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>421</td>\n",
       "      <td>1917</td>\n",
       "      <td>BR HZ</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.39</td>\n",
       "      <td>30.11</td>\n",
       "      <td>5.8</td>\n",
       "      <td>18</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>4100 North Oak Park Avenue, Chicago, IL 60634,...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>41</td>\n",
       "      <td>N OAK PARK AVE</td>\n",
       "      <td>T002</td>\n",
       "      <td>4100  N OAK PARK AVE, Chicago, IL</td>\n",
       "      <td>41.954690</td>\n",
       "      <td>-87.800991</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-06-05</th>\n",
       "      <td>7900 West Foster Avenue, Chicago, IL 60656, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>79</td>\n",
       "      <td>W FOSTER AVE</td>\n",
       "      <td>T015</td>\n",
       "      <td>7900  W FOSTER AVE, Chicago, IL</td>\n",
       "      <td>41.974089</td>\n",
       "      <td>-87.824812</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>417</td>\n",
       "      <td>1923</td>\n",
       "      <td>RA BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42</td>\n",
       "      <td>29.10</td>\n",
       "      <td>29.79</td>\n",
       "      <td>5.2</td>\n",
       "      <td>5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>South Cottage Grove Avenue, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>S COTTAGE GROVE</td>\n",
       "      <td>T102</td>\n",
       "      <td>1000  S COTTAGE GROVE, Chicago, IL</td>\n",
       "      <td>41.750498</td>\n",
       "      <td>-87.605294</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>South Cottage Grove Avenue, Chicago, IL, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>S COTTAGE GROVE</td>\n",
       "      <td>T102</td>\n",
       "      <td>1000  S COTTAGE GROVE, Chicago, IL</td>\n",
       "      <td>41.750498</td>\n",
       "      <td>-87.605294</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>South Cottage Grove Avenue, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>S COTTAGE GROVE</td>\n",
       "      <td>T102</td>\n",
       "      <td>1000  S COTTAGE GROVE, Chicago, IL</td>\n",
       "      <td>41.750498</td>\n",
       "      <td>-87.605294</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5800 North Pulaski Road, Chicago, IL 60646, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>58</td>\n",
       "      <td>N PULASKI RD</td>\n",
       "      <td>T027</td>\n",
       "      <td>5800  N PULASKI RD, Chicago, IL</td>\n",
       "      <td>41.984809</td>\n",
       "      <td>-87.728492</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4000 East 130th Street, Chicago, IL 60633, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>40</td>\n",
       "      <td>E 130TH ST</td>\n",
       "      <td>T221</td>\n",
       "      <td>4000  E 130TH ST, Chicago, IL</td>\n",
       "      <td>41.659112</td>\n",
       "      <td>-87.538693</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4000 East 130th Street, Chicago, IL 60633, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>40</td>\n",
       "      <td>E 130TH ST</td>\n",
       "      <td>T221</td>\n",
       "      <td>4000  E 130TH ST, Chicago, IL</td>\n",
       "      <td>41.659112</td>\n",
       "      <td>-87.538693</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4000 East 130th Street, Chicago, IL 60633, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>40</td>\n",
       "      <td>E 130TH ST</td>\n",
       "      <td>T221</td>\n",
       "      <td>4000  E 130TH ST, Chicago, IL</td>\n",
       "      <td>41.659112</td>\n",
       "      <td>-87.538693</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>9100 West Higgins Road, Rosemont, IL 60018, USA</td>\n",
       "      <td>CULEX RESTUANS</td>\n",
       "      <td>91</td>\n",
       "      <td>W HIGGINS RD</td>\n",
       "      <td>T009</td>\n",
       "      <td>9100  W HIGGINS RD, Chicago, IL</td>\n",
       "      <td>41.992478</td>\n",
       "      <td>-87.862995</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>39</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>ORD Terminal 5, O'Hare International Airport, ...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>10</td>\n",
       "      <td>W OHARE AIRPORT</td>\n",
       "      <td>T900</td>\n",
       "      <td>1000  W OHARE AIRPORT, Chicago, IL</td>\n",
       "      <td>41.974689</td>\n",
       "      <td>-87.890615</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4800 West Montana Street, Chicago, IL 60639, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>48</td>\n",
       "      <td>W MONTANA ST</td>\n",
       "      <td>T222</td>\n",
       "      <td>4800  W MONTANA ST, Chicago, IL</td>\n",
       "      <td>41.925198</td>\n",
       "      <td>-87.746381</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5100 North Mont Clare Avenue, Chicago, IL 6065...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>51</td>\n",
       "      <td>N MONT CLARE AVE</td>\n",
       "      <td>T223</td>\n",
       "      <td>5100  N MONT CLARE AVE, Chicago, IL</td>\n",
       "      <td>41.973845</td>\n",
       "      <td>-87.805059</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5100 North Mont Clare Avenue, Chicago, IL 6065...</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>51</td>\n",
       "      <td>N MONT CLARE AVE</td>\n",
       "      <td>T223</td>\n",
       "      <td>5100  N MONT CLARE AVE, Chicago, IL</td>\n",
       "      <td>41.973845</td>\n",
       "      <td>-87.805059</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>8200 South Kostner Avenue, Chicago, IL 60652, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>82</td>\n",
       "      <td>S KOSTNER AVE</td>\n",
       "      <td>T225</td>\n",
       "      <td>8200  S KOSTNER AVE, Chicago, IL</td>\n",
       "      <td>41.743402</td>\n",
       "      <td>-87.731435</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>East 91st Place, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>65</td>\n",
       "      <td>E 91ST PL</td>\n",
       "      <td>T227</td>\n",
       "      <td>6500  E 91ST PL, Chicago, IL</td>\n",
       "      <td>41.728495</td>\n",
       "      <td>-87.600963</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>East 91st Place, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>65</td>\n",
       "      <td>E 91ST PL</td>\n",
       "      <td>T227</td>\n",
       "      <td>6500  E 91ST PL, Chicago, IL</td>\n",
       "      <td>41.728495</td>\n",
       "      <td>-87.600963</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1700 West Addison Street, Chicago, IL 60613, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>17</td>\n",
       "      <td>W ADDISON ST</td>\n",
       "      <td>T224</td>\n",
       "      <td>1700  W ADDISON ST, Chicago, IL</td>\n",
       "      <td>41.947227</td>\n",
       "      <td>-87.671457</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>West Garfield Boulevard, Chicago, IL, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>90</td>\n",
       "      <td>W GARFIELD BLVD</td>\n",
       "      <td>T226</td>\n",
       "      <td>9000  W GARFIELD BLVD, Chicago, IL</td>\n",
       "      <td>41.793818</td>\n",
       "      <td>-87.654234</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1300 North Laramie Avenue, Chicago, IL 60651, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>13</td>\n",
       "      <td>N LARAMIE AVE</td>\n",
       "      <td>T230</td>\n",
       "      <td>1300  N LARAMIE AVE, Chicago, IL</td>\n",
       "      <td>41.904194</td>\n",
       "      <td>-87.756155</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1300 North Laramie Avenue, Chicago, IL 60651, USA</td>\n",
       "      <td>CULEX PIPIENS</td>\n",
       "      <td>13</td>\n",
       "      <td>N LARAMIE AVE</td>\n",
       "      <td>T230</td>\n",
       "      <td>1300  N LARAMIE AVE, Chicago, IL</td>\n",
       "      <td>41.904194</td>\n",
       "      <td>-87.756155</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>3900 North Springfield Avenue, Chicago, IL 606...</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>39</td>\n",
       "      <td>N SPRINGFIELD AVE</td>\n",
       "      <td>T228</td>\n",
       "      <td>3900  N SPRINGFIELD AVE, Chicago, IL</td>\n",
       "      <td>41.951866</td>\n",
       "      <td>-87.725057</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5100 West 72nd Street, Chicago, IL 60638, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>51</td>\n",
       "      <td>W 72ND ST</td>\n",
       "      <td>T035</td>\n",
       "      <td>5100  W 72ND ST, Chicago, IL</td>\n",
       "      <td>41.763733</td>\n",
       "      <td>-87.742302</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>5800 North Ridge Avenue, Chicago, IL 60660, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>58</td>\n",
       "      <td>N RIDGE AVE</td>\n",
       "      <td>T231</td>\n",
       "      <td>5800  N RIDGE AVE, Chicago, IL</td>\n",
       "      <td>41.987280</td>\n",
       "      <td>-87.666066</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>1700 North Ashland Avenue, Chicago, IL 60622, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>17</td>\n",
       "      <td>N ASHLAND AVE</td>\n",
       "      <td>T232</td>\n",
       "      <td>1700  N ASHLAND AVE, Chicago, IL</td>\n",
       "      <td>41.912563</td>\n",
       "      <td>-87.668055</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>7100 North Harlem Avenue, Chicago, IL 60631, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>71</td>\n",
       "      <td>N HARLEM AVE</td>\n",
       "      <td>T233</td>\n",
       "      <td>7100  N HARLEM AVE, Chicago, IL</td>\n",
       "      <td>42.009876</td>\n",
       "      <td>-87.807277</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-09-26</th>\n",
       "      <td>4200 West 65th Street, Chicago, IL 60621, USA</td>\n",
       "      <td>CULEX PIPIENS/RESTUANS</td>\n",
       "      <td>42</td>\n",
       "      <td>W 65TH ST</td>\n",
       "      <td>T235</td>\n",
       "      <td>4200  W 65TH ST, Chicago, IL</td>\n",
       "      <td>41.776428</td>\n",
       "      <td>-87.627096</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>543</td>\n",
       "      <td>1742</td>\n",
       "      <td>BR</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.34</td>\n",
       "      <td>30.04</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10506 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      Address  \\\n",
       "Date                                                            \n",
       "2007-05-29  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-05-29  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-05-29  6200 North Mandell Avenue, Chicago, IL 60646, USA   \n",
       "2007-05-29    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "2007-05-29    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "2007-05-29   1500 West Webster Avenue, Chicago, IL 60614, USA   \n",
       "2007-05-29     2500 West Grand Avenue, Chicago, IL 60654, USA   \n",
       "2007-05-29        1100 Roosevelt Road, Chicago, IL 60608, USA   \n",
       "2007-05-29        1100 Roosevelt Road, Chicago, IL 60608, USA   \n",
       "2007-05-29   1100 West Chicago Avenue, Chicago, IL 60642, USA   \n",
       "2007-05-29    2100 North Stave Street, Chicago, IL 60647, USA   \n",
       "2007-05-29    2200 North Cannon Drive, Chicago, IL 60614, USA   \n",
       "2007-05-29    2200 North Cannon Drive, Chicago, IL 60614, USA   \n",
       "2007-05-29     2200 West 113th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29     2200 West 113th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29   1100 South Peoria Street, Chicago, IL 60608, USA   \n",
       "2007-05-29      1700 West 95th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29      2200 West 89th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29      2200 West 89th Street, Chicago, IL 60643, USA   \n",
       "2007-05-29       North Streeter Drive, Chicago, IL 60611, USA   \n",
       "2007-05-29       North Streeter Drive, Chicago, IL 60611, USA   \n",
       "2007-05-29  6500 North Oak Park Avenue, Chicago, IL 60631,...   \n",
       "2007-05-29   7500 North Oakley Avenue, Chicago, IL 60645, USA   \n",
       "2007-05-29     1500 North Long Avenue, Chicago, IL 60651, USA   \n",
       "2007-05-29  8900 South Carpenter Street, Chicago, IL 60620...   \n",
       "2007-06-05  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-06-05  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-06-05  4100 North Oak Park Avenue, Chicago, IL 60634,...   \n",
       "2007-06-05    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "2007-06-05    7900 West Foster Avenue, Chicago, IL 60656, USA   \n",
       "...                                                       ...   \n",
       "2013-09-26       South Cottage Grove Avenue, Chicago, IL, USA   \n",
       "2013-09-26       South Cottage Grove Avenue, Chicago, IL, USA   \n",
       "2013-09-26       South Cottage Grove Avenue, Chicago, IL, USA   \n",
       "2013-09-26    5800 North Pulaski Road, Chicago, IL 60646, USA   \n",
       "2013-09-26     4000 East 130th Street, Chicago, IL 60633, USA   \n",
       "2013-09-26     4000 East 130th Street, Chicago, IL 60633, USA   \n",
       "2013-09-26     4000 East 130th Street, Chicago, IL 60633, USA   \n",
       "2013-09-26    9100 West Higgins Road, Rosemont, IL 60018, USA   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26  ORD Terminal 5, O'Hare International Airport, ...   \n",
       "2013-09-26   4800 West Montana Street, Chicago, IL 60639, USA   \n",
       "2013-09-26  5100 North Mont Clare Avenue, Chicago, IL 6065...   \n",
       "2013-09-26  5100 North Mont Clare Avenue, Chicago, IL 6065...   \n",
       "2013-09-26  8200 South Kostner Avenue, Chicago, IL 60652, USA   \n",
       "2013-09-26                  East 91st Place, Chicago, IL, USA   \n",
       "2013-09-26                  East 91st Place, Chicago, IL, USA   \n",
       "2013-09-26   1700 West Addison Street, Chicago, IL 60613, USA   \n",
       "2013-09-26          West Garfield Boulevard, Chicago, IL, USA   \n",
       "2013-09-26  1300 North Laramie Avenue, Chicago, IL 60651, USA   \n",
       "2013-09-26  1300 North Laramie Avenue, Chicago, IL 60651, USA   \n",
       "2013-09-26  3900 North Springfield Avenue, Chicago, IL 606...   \n",
       "2013-09-26      5100 West 72nd Street, Chicago, IL 60638, USA   \n",
       "2013-09-26    5800 North Ridge Avenue, Chicago, IL 60660, USA   \n",
       "2013-09-26  1700 North Ashland Avenue, Chicago, IL 60622, USA   \n",
       "2013-09-26   7100 North Harlem Avenue, Chicago, IL 60631, USA   \n",
       "2013-09-26      4200 West 65th Street, Chicago, IL 60621, USA   \n",
       "\n",
       "                           Species  Block              Street  Trap  \\\n",
       "Date                                                                  \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-05-29          CULEX RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-05-29          CULEX RESTUANS     62       N MANDELL AVE  T007   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     79        W FOSTER AVE  T015   \n",
       "2007-05-29          CULEX RESTUANS     79        W FOSTER AVE  T015   \n",
       "2007-05-29          CULEX RESTUANS     15       W WEBSTER AVE  T045   \n",
       "2007-05-29          CULEX RESTUANS     25         W GRAND AVE  T046   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     11         W ROOSEVELT  T048   \n",
       "2007-05-29          CULEX RESTUANS     11         W ROOSEVELT  T048   \n",
       "2007-05-29          CULEX RESTUANS     11           W CHICAGO  T049   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     21          N STAVE ST  T050   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     22         N CANNON DR  T054   \n",
       "2007-05-29          CULEX RESTUANS     22         N CANNON DR  T054   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     22          W 113TH ST  T086   \n",
       "2007-05-29          CULEX RESTUANS     22          W 113TH ST  T086   \n",
       "2007-05-29          CULEX RESTUANS     11         S PEORIA ST  T091   \n",
       "2007-05-29          CULEX RESTUANS     17           W 95TH ST  T094   \n",
       "2007-05-29          CULEX RESTUANS     22           W 89TH ST  T096   \n",
       "2007-05-29           CULEX PIPIENS     22           W 89TH ST  T096   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     53       N STREETER DR  T129   \n",
       "2007-05-29          CULEX RESTUANS     53       N STREETER DR  T129   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     65      N OAK PARK AVE  T143   \n",
       "2007-05-29  CULEX PIPIENS/RESTUANS     75        N OAKLEY AVE  T148   \n",
       "2007-05-29          CULEX RESTUANS     15          N LONG AVE  T153   \n",
       "2007-05-29          CULEX RESTUANS     89      S CARPENTER ST  T159   \n",
       "2007-06-05  CULEX PIPIENS/RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-06-05          CULEX RESTUANS     41      N OAK PARK AVE  T002   \n",
       "2007-06-05           CULEX PIPIENS     41      N OAK PARK AVE  T002   \n",
       "2007-06-05  CULEX PIPIENS/RESTUANS     79        W FOSTER AVE  T015   \n",
       "2007-06-05          CULEX RESTUANS     79        W FOSTER AVE  T015   \n",
       "...                            ...    ...                 ...   ...   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     10     S COTTAGE GROVE  T102   \n",
       "2013-09-26          CULEX RESTUANS     10     S COTTAGE GROVE  T102   \n",
       "2013-09-26           CULEX PIPIENS     10     S COTTAGE GROVE  T102   \n",
       "2013-09-26           CULEX PIPIENS     58        N PULASKI RD  T027   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     40          E 130TH ST  T221   \n",
       "2013-09-26          CULEX RESTUANS     40          E 130TH ST  T221   \n",
       "2013-09-26           CULEX PIPIENS     40          E 130TH ST  T221   \n",
       "2013-09-26          CULEX RESTUANS     91        W HIGGINS RD  T009   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26           CULEX PIPIENS     10     W OHARE AIRPORT  T900   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     48        W MONTANA ST  T222   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     51    N MONT CLARE AVE  T223   \n",
       "2013-09-26           CULEX PIPIENS     51    N MONT CLARE AVE  T223   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     82       S KOSTNER AVE  T225   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     65           E 91ST PL  T227   \n",
       "2013-09-26           CULEX PIPIENS     65           E 91ST PL  T227   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     17        W ADDISON ST  T224   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     90     W GARFIELD BLVD  T226   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     13       N LARAMIE AVE  T230   \n",
       "2013-09-26           CULEX PIPIENS     13       N LARAMIE AVE  T230   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     39   N SPRINGFIELD AVE  T228   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     51           W 72ND ST  T035   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     58         N RIDGE AVE  T231   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     17       N ASHLAND AVE  T232   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     71        N HARLEM AVE  T233   \n",
       "2013-09-26  CULEX PIPIENS/RESTUANS     42           W 65TH ST  T235   \n",
       "\n",
       "                          AddressNumberAndStreet   Latitude  Longitude  \\\n",
       "Date                                                                     \n",
       "2007-05-29     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-05-29     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-05-29      6200  N MANDELL AVE, Chicago, IL  41.994991 -87.769279   \n",
       "2007-05-29       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "2007-05-29       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "2007-05-29      1500  W WEBSTER AVE, Chicago, IL  41.921600 -87.666455   \n",
       "2007-05-29        2500  W GRAND AVE, Chicago, IL  41.891118 -87.654491   \n",
       "2007-05-29        1100  W ROOSEVELT, Chicago, IL  41.867108 -87.654224   \n",
       "2007-05-29        1100  W ROOSEVELT, Chicago, IL  41.867108 -87.654224   \n",
       "2007-05-29          1100  W CHICAGO, Chicago, IL  41.896282 -87.655232   \n",
       "2007-05-29         2100  N STAVE ST, Chicago, IL  41.919343 -87.694259   \n",
       "2007-05-29        2200  N CANNON DR, Chicago, IL  41.921965 -87.632085   \n",
       "2007-05-29        2200  N CANNON DR, Chicago, IL  41.921965 -87.632085   \n",
       "2007-05-29         2200  W 113TH ST, Chicago, IL  41.688324 -87.676709   \n",
       "2007-05-29         2200  W 113TH ST, Chicago, IL  41.688324 -87.676709   \n",
       "2007-05-29        1100  S PEORIA ST, Chicago, IL  41.862292 -87.648860   \n",
       "2007-05-29          1700  W 95TH ST, Chicago, IL  41.720848 -87.666014   \n",
       "2007-05-29          2200  W 89TH ST, Chicago, IL  41.731922 -87.677512   \n",
       "2007-05-29          2200  W 89TH ST, Chicago, IL  41.731922 -87.677512   \n",
       "2007-05-29      5300  N STREETER DR, Chicago, IL  41.891126 -87.611560   \n",
       "2007-05-29      5300  N STREETER DR, Chicago, IL  41.891126 -87.611560   \n",
       "2007-05-29     6500  N OAK PARK AVE, Chicago, IL  41.999129 -87.795585   \n",
       "2007-05-29       7500  N OAKLEY AVE, Chicago, IL  42.017430 -87.687769   \n",
       "2007-05-29         1500  N LONG AVE, Chicago, IL  41.907645 -87.760886   \n",
       "2007-05-29     8900  S CARPENTER ST, Chicago, IL  41.732984 -87.649642   \n",
       "2007-06-05     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-06-05     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-06-05     4100  N OAK PARK AVE, Chicago, IL  41.954690 -87.800991   \n",
       "2007-06-05       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "2007-06-05       7900  W FOSTER AVE, Chicago, IL  41.974089 -87.824812   \n",
       "...                                          ...        ...        ...   \n",
       "2013-09-26    1000  S COTTAGE GROVE, Chicago, IL  41.750498 -87.605294   \n",
       "2013-09-26    1000  S COTTAGE GROVE, Chicago, IL  41.750498 -87.605294   \n",
       "2013-09-26    1000  S COTTAGE GROVE, Chicago, IL  41.750498 -87.605294   \n",
       "2013-09-26       5800  N PULASKI RD, Chicago, IL  41.984809 -87.728492   \n",
       "2013-09-26         4000  E 130TH ST, Chicago, IL  41.659112 -87.538693   \n",
       "2013-09-26         4000  E 130TH ST, Chicago, IL  41.659112 -87.538693   \n",
       "2013-09-26         4000  E 130TH ST, Chicago, IL  41.659112 -87.538693   \n",
       "2013-09-26       9100  W HIGGINS RD, Chicago, IL  41.992478 -87.862995   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26    1000  W OHARE AIRPORT, Chicago, IL  41.974689 -87.890615   \n",
       "2013-09-26       4800  W MONTANA ST, Chicago, IL  41.925198 -87.746381   \n",
       "2013-09-26   5100  N MONT CLARE AVE, Chicago, IL  41.973845 -87.805059   \n",
       "2013-09-26   5100  N MONT CLARE AVE, Chicago, IL  41.973845 -87.805059   \n",
       "2013-09-26      8200  S KOSTNER AVE, Chicago, IL  41.743402 -87.731435   \n",
       "2013-09-26          6500  E 91ST PL, Chicago, IL  41.728495 -87.600963   \n",
       "2013-09-26          6500  E 91ST PL, Chicago, IL  41.728495 -87.600963   \n",
       "2013-09-26       1700  W ADDISON ST, Chicago, IL  41.947227 -87.671457   \n",
       "2013-09-26    9000  W GARFIELD BLVD, Chicago, IL  41.793818 -87.654234   \n",
       "2013-09-26      1300  N LARAMIE AVE, Chicago, IL  41.904194 -87.756155   \n",
       "2013-09-26      1300  N LARAMIE AVE, Chicago, IL  41.904194 -87.756155   \n",
       "2013-09-26  3900  N SPRINGFIELD AVE, Chicago, IL  41.951866 -87.725057   \n",
       "2013-09-26          5100  W 72ND ST, Chicago, IL  41.763733 -87.742302   \n",
       "2013-09-26        5800  N RIDGE AVE, Chicago, IL  41.987280 -87.666066   \n",
       "2013-09-26      1700  N ASHLAND AVE, Chicago, IL  41.912563 -87.668055   \n",
       "2013-09-26       7100  N HARLEM AVE, Chicago, IL  42.009876 -87.807277   \n",
       "2013-09-26          4200  W 65TH ST, Chicago, IL  41.776428 -87.627096   \n",
       "\n",
       "            AddressAccuracy  NumMosquitos    ...     Sunrise  Sunset  CodeSum  \\\n",
       "Date                                         ...                                \n",
       "2007-05-29                9             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                9             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                9             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             4    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             3    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                9             3    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             5    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                5             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                5             2    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-05-29                8             1    ...         421    1917    BR HZ   \n",
       "2007-06-05                9             3    ...         417    1923    RA BR   \n",
       "2007-06-05                9             5    ...         417    1923    RA BR   \n",
       "2007-06-05                9             1    ...         417    1923    RA BR   \n",
       "2007-06-05                8             1    ...         417    1923    RA BR   \n",
       "2007-06-05                8             2    ...         417    1923    RA BR   \n",
       "...                     ...           ...    ...         ...     ...      ...   \n",
       "2013-09-26                5             2    ...         543    1742       BR   \n",
       "2013-09-26                5             1    ...         543    1742       BR   \n",
       "2013-09-26                5             1    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                8             4    ...         543    1742       BR   \n",
       "2013-09-26                8             1    ...         543    1742       BR   \n",
       "2013-09-26                9            39    ...         543    1742       BR   \n",
       "2013-09-26                9             4    ...         543    1742       BR   \n",
       "2013-09-26                9            16    ...         543    1742       BR   \n",
       "2013-09-26                9             9    ...         543    1742       BR   \n",
       "2013-09-26                9            11    ...         543    1742       BR   \n",
       "2013-09-26                9             1    ...         543    1742       BR   \n",
       "2013-09-26                8             1    ...         543    1742       BR   \n",
       "2013-09-26                9            11    ...         543    1742       BR   \n",
       "2013-09-26                9             1    ...         543    1742       BR   \n",
       "2013-09-26                8             3    ...         543    1742       BR   \n",
       "2013-09-26                5             7    ...         543    1742       BR   \n",
       "2013-09-26                5             1    ...         543    1742       BR   \n",
       "2013-09-26                9             3    ...         543    1742       BR   \n",
       "2013-09-26                5             8    ...         543    1742       BR   \n",
       "2013-09-26                9            13    ...         543    1742       BR   \n",
       "2013-09-26                9             5    ...         543    1742       BR   \n",
       "2013-09-26                8             3    ...         543    1742       BR   \n",
       "2013-09-26                8             6    ...         543    1742       BR   \n",
       "2013-09-26                8             5    ...         543    1742       BR   \n",
       "2013-09-26                9             1    ...         543    1742       BR   \n",
       "2013-09-26                9             5    ...         543    1742       BR   \n",
       "2013-09-26                8             1    ...         543    1742       BR   \n",
       "\n",
       "            Depth  PrecipTotal  StnPressure SeaLevel ResultSpeed  ResultDir  \\\n",
       "Date                                                                          \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-05-29      0         0.00        29.39    30.11         5.8         18   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "2007-06-05      0         0.42        29.10    29.79         5.2          5   \n",
       "...           ...          ...          ...      ...         ...        ...   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "2013-09-26      0         0.00        29.34    30.04         3.8          8   \n",
       "\n",
       "            AvgSpeed  \n",
       "Date                  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-05-29       6.5  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "2007-06-05       7.6  \n",
       "...              ...  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "2013-09-26       4.2  \n",
       "\n",
       "[10506 rows x 29 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# make new_df lat / long a Point obj\n",
    "# drop lat/long\n",
    "#make spray_df lat/long a Point obj\n",
    "#drop lat/long\n",
    "#combine spray_df with new_df\n",
    "new_df.to_csv('./train-weather_df')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}