prepare_flood_events_table.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Prepare Flood Events data for DB"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "module_path = os.path.abspath(os.path.join('..'))\n",
    "if module_path not in sys.path:\n",
    "    sys.path.append(module_path)\n",
    "#from db_scripts.main_db_script import data_dir, db_filename\n",
    "import pandas as pd\n",
    "import sqlite3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Read in the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#cds = pd.read_csv('STORM_data_flooded_streets_2010-2016_no_duplicates_clean_lat_lon.csv')\n",
    "cds = pd.read_csv('STORM_data_flooded_streets_2010-2016.csv')\n",
    "#os.getcwd()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Index by location name and subset to just columns we want"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "cds = cds[['location', 'event', 'eventType', 'dt']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>location</th>\n",
       "      <th>event</th>\n",
       "      <th>eventType</th>\n",
       "      <th>dt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>300 BLOCK OF SHIRLEY AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:32:47.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; SHIRLEY AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:19.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:48.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>900 BLOCK OF TIDEWATER DRIVE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:00.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CAMPOSTELLA ROAD &amp; E BRAMBLETON AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:38.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2800 BLOCK OF E VIRGINIA BEACH BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:30:29.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:16.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; GALVESTON BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:41.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4TH VIEW STREET &amp; W OCEAN VIEW AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:02.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>300 BLOCK OF E LITTLE CREEK ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:30.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:33:08.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ALEXANDER STREET &amp; STRAND STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:34:21.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>300 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:35:57.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>400 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:09.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1100 BLOCK OF GEORGETOWN ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:28.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; SAINT PAULS BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:37:22.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BOUSH STREET &amp; W OLNEY ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:38:08.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; I-264W HIGHWAY</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:10.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BALDWIN AVENUE &amp; STOCKLEY GARDENS</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:33.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CHURCH STREET &amp; GOFF STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:26.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CHURCH STREET &amp; E PRINCESS ANNE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:45.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; MONTICELLO AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:01:50.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>DEBREE AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:11:32.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; INGLESIDE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:12:59.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>E VIRGINIA BEACH BOULEVARD &amp; TIDEWATER DRIVE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:14:08.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GOSNOLD AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:22.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MUNSON STREET &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:39.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NEWPORT AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:53.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>COLONIAL AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:10.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ARGONNE AVENUE &amp; KITCHENER AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:50.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8100 BLOCK OF GLEN MYRTLE AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:00:01.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>300 BLOCK OF ROGERS AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:01:49.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>533 BEECHWOOD AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:04:40.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045</th>\n",
       "      <td>BOUSH CREEK AVENUE &amp; GLENDALE AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:06:06.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1046</th>\n",
       "      <td>PACE ROAD &amp; RIDGEFIELD DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:20:26.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>REDMON ROAD &amp; SIMMS ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:37:23.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>1400 BLOCK OF GODFREY AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:52:59.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>FORREST AVENUE &amp; EVERGREEN AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:03:12.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>GLEN MYRTLE AVENUE &amp; BEECHWOOD AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:08:17.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>600 BLOCK OF W 23RD STREET</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:34:44.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>8014 WOODALL ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:45:46.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>5300 BLOCK OF WYNGATE DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:02:42.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>5300 BLOCK OF GREENPLAIN ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:03:37.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055</th>\n",
       "      <td>1100 BLOCK OF EASTOVER ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:04:42.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>3507 POMROY AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:13:49.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>5512 JANET DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:16:06.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>5531 KILMER LANE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:18:32.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>ROLFE AVENUE &amp; WALNUT HILL STREET</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:35:30.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>SURREY CRESCENT &amp; UPPER BRANDON PLACE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:38:21.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>916 LITTLE BAY AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:51:13.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>9500 BLOCK OF 10TH BAY STREET</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:56:45.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>4245 HEUTTE DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:07:24.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>7945 RANSOM ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:18:12.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>1510 CRANE AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:26:59.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>2538 WEST AZALEA POINT ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:31:41.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>2460 RANKIN COURT</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:38:26.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>3829 WEDGEFIELD AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 15:03:38.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>5371 WYNGATE DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:27:16.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>2733 AYLIFF ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:30:43.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-13 08:39:02.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1072 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          location  \\\n",
       "0                      300 BLOCK OF SHIRLEY AVENUE   \n",
       "1                LLEWELLYN AVENUE & SHIRLEY AVENUE   \n",
       "2          LLEWELLYN AVENUE & W PRINCESS ANNE ROAD   \n",
       "3                     900 BLOCK OF TIDEWATER DRIVE   \n",
       "4           CAMPOSTELLA ROAD & E BRAMBLETON AVENUE   \n",
       "5         2800 BLOCK OF E VIRGINIA BEACH BOULEVARD   \n",
       "6                 3500 BLOCK OF SEWELLS POINT ROAD   \n",
       "7        E LITTLE CREEK ROAD & GALVESTON BOULEVARD   \n",
       "8            4TH VIEW STREET & W OCEAN VIEW AVENUE   \n",
       "9                 300 BLOCK OF E LITTLE CREEK ROAD   \n",
       "10     E LITTLE CREEK ROAD & SAN ANTONIO BOULEVARD   \n",
       "11                ALEXANDER STREET & STRAND STREET   \n",
       "12              300 BLOCK OF SAN ANTONIO BOULEVARD   \n",
       "13              400 BLOCK OF SAN ANTONIO BOULEVARD   \n",
       "14                   1100 BLOCK OF GEORGETOWN ROAD   \n",
       "15     E BRAMBLETON AVENUE & SAINT PAULS BOULEVARD   \n",
       "16                     BOUSH STREET & W OLNEY ROAD   \n",
       "17            E BRAMBLETON AVENUE & I-264W HIGHWAY   \n",
       "18               BALDWIN AVENUE & STOCKLEY GARDENS   \n",
       "19                     CHURCH STREET & GOFF STREET   \n",
       "20            CHURCH STREET & E PRINCESS ANNE ROAD   \n",
       "21        E PRINCESS ANNE ROAD & MONTICELLO AVENUE   \n",
       "22            DEBREE AVENUE & W PRINCESS ANNE ROAD   \n",
       "23           E PRINCESS ANNE ROAD & INGLESIDE ROAD   \n",
       "24    E VIRGINIA BEACH BOULEVARD & TIDEWATER DRIVE   \n",
       "25                  GOSNOLD AVENUE & W 26TH STREET   \n",
       "26                   MUNSON STREET & W 26TH STREET   \n",
       "27                  NEWPORT AVENUE & W 26TH STREET   \n",
       "28                 COLONIAL AVENUE & W 26TH STREET   \n",
       "29               ARGONNE AVENUE & KITCHENER AVENUE   \n",
       "...                                            ...   \n",
       "1042              8100 BLOCK OF GLEN MYRTLE AVENUE   \n",
       "1043                    300 BLOCK OF ROGERS AVENUE   \n",
       "1044                          533 BEECHWOOD AVENUE   \n",
       "1045          BOUSH CREEK AVENUE & GLENDALE AVENUE   \n",
       "1046                  PACE ROAD & RIDGEFIELD DRIVE   \n",
       "1047                      REDMON ROAD & SIMMS ROAD   \n",
       "1048                  1400 BLOCK OF GODFREY AVENUE   \n",
       "1049             FORREST AVENUE & EVERGREEN AVENUE   \n",
       "1050         GLEN MYRTLE AVENUE & BEECHWOOD AVENUE   \n",
       "1051                    600 BLOCK OF W 23RD STREET   \n",
       "1052                             8014 WOODALL ROAD   \n",
       "1053                   5300 BLOCK OF WYNGATE DRIVE   \n",
       "1054                 5300 BLOCK OF GREENPLAIN ROAD   \n",
       "1055                   1100 BLOCK OF EASTOVER ROAD   \n",
       "1056                            3507 POMROY AVENUE   \n",
       "1057                              5512 JANET DRIVE   \n",
       "1058                              5531 KILMER LANE   \n",
       "1059             ROLFE AVENUE & WALNUT HILL STREET   \n",
       "1060         SURREY CRESCENT & UPPER BRANDON PLACE   \n",
       "1061                         916 LITTLE BAY AVENUE   \n",
       "1062                 9500 BLOCK OF 10TH BAY STREET   \n",
       "1063                             4245 HEUTTE DRIVE   \n",
       "1064                              7945 RANSOM ROAD   \n",
       "1065                             1510 CRANE AVENUE   \n",
       "1066                   2538 WEST AZALEA POINT ROAD   \n",
       "1067                             2460 RANKIN COURT   \n",
       "1068                        3829 WEDGEFIELD AVENUE   \n",
       "1069                            5371 WYNGATE DRIVE   \n",
       "1070                              2733 AYLIFF ROAD   \n",
       "1071              3500 BLOCK OF SEWELLS POINT ROAD   \n",
       "\n",
       "                              event       eventType                       dt  \n",
       "0                Nicole (9/30/2010)  Flooded street  2010-09-30 07:32:47.000  \n",
       "1                Nicole (9/30/2010)  Flooded street  2010-09-30 07:33:19.000  \n",
       "2                Nicole (9/30/2010)  Flooded street  2010-09-30 07:33:48.000  \n",
       "3                Nicole (9/30/2010)  Flooded street  2010-09-30 08:29:00.000  \n",
       "4                Nicole (9/30/2010)  Flooded street  2010-09-30 08:29:38.000  \n",
       "5                Nicole (9/30/2010)  Flooded street  2010-09-30 08:30:29.000  \n",
       "6                Nicole (9/30/2010)  Flooded street  2010-09-30 08:31:16.000  \n",
       "7                Nicole (9/30/2010)  Flooded street  2010-09-30 08:31:41.000  \n",
       "8                Nicole (9/30/2010)  Flooded street  2010-09-30 08:32:02.000  \n",
       "9                Nicole (9/30/2010)  Flooded street  2010-09-30 08:32:30.000  \n",
       "10               Nicole (9/30/2010)  Flooded street  2010-09-30 08:33:08.000  \n",
       "11               Nicole (9/30/2010)  Flooded street  2010-09-30 08:34:21.000  \n",
       "12               Nicole (9/30/2010)  Flooded street  2010-09-30 08:35:57.000  \n",
       "13               Nicole (9/30/2010)  Flooded street  2010-09-30 08:36:09.000  \n",
       "14               Nicole (9/30/2010)  Flooded street  2010-09-30 08:36:28.000  \n",
       "15               Nicole (9/30/2010)  Flooded street  2010-09-30 08:37:22.000  \n",
       "16               Nicole (9/30/2010)  Flooded street  2010-09-30 08:38:08.000  \n",
       "17               Nicole (9/30/2010)  Flooded street  2010-09-30 08:39:10.000  \n",
       "18               Nicole (9/30/2010)  Flooded street  2010-09-30 08:39:33.000  \n",
       "19               Nicole (9/30/2010)  Flooded street  2010-09-30 09:00:26.000  \n",
       "20               Nicole (9/30/2010)  Flooded street  2010-09-30 09:00:45.000  \n",
       "21               Nicole (9/30/2010)  Flooded street  2010-09-30 09:01:50.000  \n",
       "22               Nicole (9/30/2010)  Flooded street  2010-09-30 09:11:32.000  \n",
       "23               Nicole (9/30/2010)  Flooded street  2010-09-30 09:12:59.000  \n",
       "24               Nicole (9/30/2010)  Flooded street  2010-09-30 09:14:08.000  \n",
       "25               Nicole (9/30/2010)  Flooded street  2010-09-30 09:17:22.000  \n",
       "26               Nicole (9/30/2010)  Flooded street  2010-09-30 09:17:39.000  \n",
       "27               Nicole (9/30/2010)  Flooded street  2010-09-30 09:17:53.000  \n",
       "28               Nicole (9/30/2010)  Flooded street  2010-09-30 09:18:10.000  \n",
       "29               Nicole (9/30/2010)  Flooded street  2010-09-30 09:18:50.000  \n",
       "...                             ...             ...                      ...  \n",
       "1042  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:00:01.000  \n",
       "1043  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:01:49.000  \n",
       "1044  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:04:40.000  \n",
       "1045  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:06:06.000  \n",
       "1046  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:20:26.000  \n",
       "1047  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:37:23.000  \n",
       "1048  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:52:59.000  \n",
       "1049  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:03:12.000  \n",
       "1050  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:08:17.000  \n",
       "1051  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:34:44.000  \n",
       "1052  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:45:46.000  \n",
       "1053  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:02:42.000  \n",
       "1054  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:03:37.000  \n",
       "1055  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:04:42.000  \n",
       "1056  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:13:49.000  \n",
       "1057  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:16:06.000  \n",
       "1058  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:18:32.000  \n",
       "1059  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:35:30.000  \n",
       "1060  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:38:21.000  \n",
       "1061  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:51:13.000  \n",
       "1062  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:56:45.000  \n",
       "1063  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:07:24.000  \n",
       "1064  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:18:12.000  \n",
       "1065  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:26:59.000  \n",
       "1066  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:31:41.000  \n",
       "1067  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:38:26.000  \n",
       "1068  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 15:03:38.000  \n",
       "1069  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-12 14:27:16.000  \n",
       "1070  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-12 14:30:43.000  \n",
       "1071  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-13 08:39:02.000  \n",
       "\n",
       "[1072 rows x 4 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "event_dates = cds.event.str.extract(r'(\\d*/\\d*/\\d*)', expand=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "event_names = cds.event.str.replace(r'(\\(\\d*/\\d*/\\d*)\\)', '')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "cds['event_name'] = event_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>location</th>\n",
       "      <th>event</th>\n",
       "      <th>eventType</th>\n",
       "      <th>dt</th>\n",
       "      <th>event_name</th>\n",
       "      <th>event_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>300 BLOCK OF SHIRLEY AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:32:47.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; SHIRLEY AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:19.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:48.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>900 BLOCK OF TIDEWATER DRIVE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:00.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CAMPOSTELLA ROAD &amp; E BRAMBLETON AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:38.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2800 BLOCK OF E VIRGINIA BEACH BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:30:29.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:16.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; GALVESTON BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:41.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4TH VIEW STREET &amp; W OCEAN VIEW AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:02.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>300 BLOCK OF E LITTLE CREEK ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:30.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:33:08.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ALEXANDER STREET &amp; STRAND STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:34:21.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>300 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:35:57.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>400 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:09.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1100 BLOCK OF GEORGETOWN ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:28.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; SAINT PAULS BOULEVARD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:37:22.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BOUSH STREET &amp; W OLNEY ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:38:08.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; I-264W HIGHWAY</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:10.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BALDWIN AVENUE &amp; STOCKLEY GARDENS</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:33.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CHURCH STREET &amp; GOFF STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:26.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CHURCH STREET &amp; E PRINCESS ANNE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:45.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; MONTICELLO AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:01:50.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>DEBREE AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:11:32.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; INGLESIDE ROAD</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:12:59.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>E VIRGINIA BEACH BOULEVARD &amp; TIDEWATER DRIVE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:14:08.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GOSNOLD AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:22.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MUNSON STREET &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:39.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NEWPORT AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:53.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>COLONIAL AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:10.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ARGONNE AVENUE &amp; KITCHENER AVENUE</td>\n",
       "      <td>Nicole (9/30/2010)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:50.000</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>2010-09-30</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8100 BLOCK OF GLEN MYRTLE AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:00:01.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>300 BLOCK OF ROGERS AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:01:49.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>533 BEECHWOOD AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:04:40.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045</th>\n",
       "      <td>BOUSH CREEK AVENUE &amp; GLENDALE AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:06:06.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1046</th>\n",
       "      <td>PACE ROAD &amp; RIDGEFIELD DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:20:26.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>REDMON ROAD &amp; SIMMS ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:37:23.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>1400 BLOCK OF GODFREY AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:52:59.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>FORREST AVENUE &amp; EVERGREEN AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:03:12.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>GLEN MYRTLE AVENUE &amp; BEECHWOOD AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:08:17.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>600 BLOCK OF W 23RD STREET</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:34:44.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>8014 WOODALL ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:45:46.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>5300 BLOCK OF WYNGATE DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:02:42.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>5300 BLOCK OF GREENPLAIN ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:03:37.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055</th>\n",
       "      <td>1100 BLOCK OF EASTOVER ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:04:42.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>3507 POMROY AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:13:49.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>5512 JANET DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:16:06.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>5531 KILMER LANE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:18:32.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>ROLFE AVENUE &amp; WALNUT HILL STREET</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:35:30.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>SURREY CRESCENT &amp; UPPER BRANDON PLACE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:38:21.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>916 LITTLE BAY AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:51:13.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>9500 BLOCK OF 10TH BAY STREET</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:56:45.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>4245 HEUTTE DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:07:24.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>7945 RANSOM ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:18:12.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>1510 CRANE AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:26:59.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>2538 WEST AZALEA POINT ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:31:41.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>2460 RANKIN COURT</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:38:26.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>3829 WEDGEFIELD AVENUE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 15:03:38.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>5371 WYNGATE DRIVE</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:27:16.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>2733 AYLIFF ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:30:43.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Hurricane Matthew (10/5/2016)</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-13 08:39:02.000</td>\n",
       "      <td>Hurricane Matthew</td>\n",
       "      <td>2016-10-05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1072 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          location  \\\n",
       "0                      300 BLOCK OF SHIRLEY AVENUE   \n",
       "1                LLEWELLYN AVENUE & SHIRLEY AVENUE   \n",
       "2          LLEWELLYN AVENUE & W PRINCESS ANNE ROAD   \n",
       "3                     900 BLOCK OF TIDEWATER DRIVE   \n",
       "4           CAMPOSTELLA ROAD & E BRAMBLETON AVENUE   \n",
       "5         2800 BLOCK OF E VIRGINIA BEACH BOULEVARD   \n",
       "6                 3500 BLOCK OF SEWELLS POINT ROAD   \n",
       "7        E LITTLE CREEK ROAD & GALVESTON BOULEVARD   \n",
       "8            4TH VIEW STREET & W OCEAN VIEW AVENUE   \n",
       "9                 300 BLOCK OF E LITTLE CREEK ROAD   \n",
       "10     E LITTLE CREEK ROAD & SAN ANTONIO BOULEVARD   \n",
       "11                ALEXANDER STREET & STRAND STREET   \n",
       "12              300 BLOCK OF SAN ANTONIO BOULEVARD   \n",
       "13              400 BLOCK OF SAN ANTONIO BOULEVARD   \n",
       "14                   1100 BLOCK OF GEORGETOWN ROAD   \n",
       "15     E BRAMBLETON AVENUE & SAINT PAULS BOULEVARD   \n",
       "16                     BOUSH STREET & W OLNEY ROAD   \n",
       "17            E BRAMBLETON AVENUE & I-264W HIGHWAY   \n",
       "18               BALDWIN AVENUE & STOCKLEY GARDENS   \n",
       "19                     CHURCH STREET & GOFF STREET   \n",
       "20            CHURCH STREET & E PRINCESS ANNE ROAD   \n",
       "21        E PRINCESS ANNE ROAD & MONTICELLO AVENUE   \n",
       "22            DEBREE AVENUE & W PRINCESS ANNE ROAD   \n",
       "23           E PRINCESS ANNE ROAD & INGLESIDE ROAD   \n",
       "24    E VIRGINIA BEACH BOULEVARD & TIDEWATER DRIVE   \n",
       "25                  GOSNOLD AVENUE & W 26TH STREET   \n",
       "26                   MUNSON STREET & W 26TH STREET   \n",
       "27                  NEWPORT AVENUE & W 26TH STREET   \n",
       "28                 COLONIAL AVENUE & W 26TH STREET   \n",
       "29               ARGONNE AVENUE & KITCHENER AVENUE   \n",
       "...                                            ...   \n",
       "1042              8100 BLOCK OF GLEN MYRTLE AVENUE   \n",
       "1043                    300 BLOCK OF ROGERS AVENUE   \n",
       "1044                          533 BEECHWOOD AVENUE   \n",
       "1045          BOUSH CREEK AVENUE & GLENDALE AVENUE   \n",
       "1046                  PACE ROAD & RIDGEFIELD DRIVE   \n",
       "1047                      REDMON ROAD & SIMMS ROAD   \n",
       "1048                  1400 BLOCK OF GODFREY AVENUE   \n",
       "1049             FORREST AVENUE & EVERGREEN AVENUE   \n",
       "1050         GLEN MYRTLE AVENUE & BEECHWOOD AVENUE   \n",
       "1051                    600 BLOCK OF W 23RD STREET   \n",
       "1052                             8014 WOODALL ROAD   \n",
       "1053                   5300 BLOCK OF WYNGATE DRIVE   \n",
       "1054                 5300 BLOCK OF GREENPLAIN ROAD   \n",
       "1055                   1100 BLOCK OF EASTOVER ROAD   \n",
       "1056                            3507 POMROY AVENUE   \n",
       "1057                              5512 JANET DRIVE   \n",
       "1058                              5531 KILMER LANE   \n",
       "1059             ROLFE AVENUE & WALNUT HILL STREET   \n",
       "1060         SURREY CRESCENT & UPPER BRANDON PLACE   \n",
       "1061                         916 LITTLE BAY AVENUE   \n",
       "1062                 9500 BLOCK OF 10TH BAY STREET   \n",
       "1063                             4245 HEUTTE DRIVE   \n",
       "1064                              7945 RANSOM ROAD   \n",
       "1065                             1510 CRANE AVENUE   \n",
       "1066                   2538 WEST AZALEA POINT ROAD   \n",
       "1067                             2460 RANKIN COURT   \n",
       "1068                        3829 WEDGEFIELD AVENUE   \n",
       "1069                            5371 WYNGATE DRIVE   \n",
       "1070                              2733 AYLIFF ROAD   \n",
       "1071              3500 BLOCK OF SEWELLS POINT ROAD   \n",
       "\n",
       "                              event       eventType                       dt  \\\n",
       "0                Nicole (9/30/2010)  Flooded street  2010-09-30 07:32:47.000   \n",
       "1                Nicole (9/30/2010)  Flooded street  2010-09-30 07:33:19.000   \n",
       "2                Nicole (9/30/2010)  Flooded street  2010-09-30 07:33:48.000   \n",
       "3                Nicole (9/30/2010)  Flooded street  2010-09-30 08:29:00.000   \n",
       "4                Nicole (9/30/2010)  Flooded street  2010-09-30 08:29:38.000   \n",
       "5                Nicole (9/30/2010)  Flooded street  2010-09-30 08:30:29.000   \n",
       "6                Nicole (9/30/2010)  Flooded street  2010-09-30 08:31:16.000   \n",
       "7                Nicole (9/30/2010)  Flooded street  2010-09-30 08:31:41.000   \n",
       "8                Nicole (9/30/2010)  Flooded street  2010-09-30 08:32:02.000   \n",
       "9                Nicole (9/30/2010)  Flooded street  2010-09-30 08:32:30.000   \n",
       "10               Nicole (9/30/2010)  Flooded street  2010-09-30 08:33:08.000   \n",
       "11               Nicole (9/30/2010)  Flooded street  2010-09-30 08:34:21.000   \n",
       "12               Nicole (9/30/2010)  Flooded street  2010-09-30 08:35:57.000   \n",
       "13               Nicole (9/30/2010)  Flooded street  2010-09-30 08:36:09.000   \n",
       "14               Nicole (9/30/2010)  Flooded street  2010-09-30 08:36:28.000   \n",
       "15               Nicole (9/30/2010)  Flooded street  2010-09-30 08:37:22.000   \n",
       "16               Nicole (9/30/2010)  Flooded street  2010-09-30 08:38:08.000   \n",
       "17               Nicole (9/30/2010)  Flooded street  2010-09-30 08:39:10.000   \n",
       "18               Nicole (9/30/2010)  Flooded street  2010-09-30 08:39:33.000   \n",
       "19               Nicole (9/30/2010)  Flooded street  2010-09-30 09:00:26.000   \n",
       "20               Nicole (9/30/2010)  Flooded street  2010-09-30 09:00:45.000   \n",
       "21               Nicole (9/30/2010)  Flooded street  2010-09-30 09:01:50.000   \n",
       "22               Nicole (9/30/2010)  Flooded street  2010-09-30 09:11:32.000   \n",
       "23               Nicole (9/30/2010)  Flooded street  2010-09-30 09:12:59.000   \n",
       "24               Nicole (9/30/2010)  Flooded street  2010-09-30 09:14:08.000   \n",
       "25               Nicole (9/30/2010)  Flooded street  2010-09-30 09:17:22.000   \n",
       "26               Nicole (9/30/2010)  Flooded street  2010-09-30 09:17:39.000   \n",
       "27               Nicole (9/30/2010)  Flooded street  2010-09-30 09:17:53.000   \n",
       "28               Nicole (9/30/2010)  Flooded street  2010-09-30 09:18:10.000   \n",
       "29               Nicole (9/30/2010)  Flooded street  2010-09-30 09:18:50.000   \n",
       "...                             ...             ...                      ...   \n",
       "1042  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:00:01.000   \n",
       "1043  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:01:49.000   \n",
       "1044  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:04:40.000   \n",
       "1045  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:06:06.000   \n",
       "1046  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:20:26.000   \n",
       "1047  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:37:23.000   \n",
       "1048  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 09:52:59.000   \n",
       "1049  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:03:12.000   \n",
       "1050  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:08:17.000   \n",
       "1051  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:34:44.000   \n",
       "1052  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 10:45:46.000   \n",
       "1053  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:02:42.000   \n",
       "1054  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:03:37.000   \n",
       "1055  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:04:42.000   \n",
       "1056  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:13:49.000   \n",
       "1057  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:16:06.000   \n",
       "1058  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:18:32.000   \n",
       "1059  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:35:30.000   \n",
       "1060  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:38:21.000   \n",
       "1061  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:51:13.000   \n",
       "1062  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 11:56:45.000   \n",
       "1063  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:07:24.000   \n",
       "1064  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:18:12.000   \n",
       "1065  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:26:59.000   \n",
       "1066  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:31:41.000   \n",
       "1067  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 12:38:26.000   \n",
       "1068  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-11 15:03:38.000   \n",
       "1069  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-12 14:27:16.000   \n",
       "1070  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-12 14:30:43.000   \n",
       "1071  Hurricane Matthew (10/5/2016)  Flooded street  2016-10-13 08:39:02.000   \n",
       "\n",
       "              event_name event_date  \n",
       "0                Nicole  2010-09-30  \n",
       "1                Nicole  2010-09-30  \n",
       "2                Nicole  2010-09-30  \n",
       "3                Nicole  2010-09-30  \n",
       "4                Nicole  2010-09-30  \n",
       "5                Nicole  2010-09-30  \n",
       "6                Nicole  2010-09-30  \n",
       "7                Nicole  2010-09-30  \n",
       "8                Nicole  2010-09-30  \n",
       "9                Nicole  2010-09-30  \n",
       "10               Nicole  2010-09-30  \n",
       "11               Nicole  2010-09-30  \n",
       "12               Nicole  2010-09-30  \n",
       "13               Nicole  2010-09-30  \n",
       "14               Nicole  2010-09-30  \n",
       "15               Nicole  2010-09-30  \n",
       "16               Nicole  2010-09-30  \n",
       "17               Nicole  2010-09-30  \n",
       "18               Nicole  2010-09-30  \n",
       "19               Nicole  2010-09-30  \n",
       "20               Nicole  2010-09-30  \n",
       "21               Nicole  2010-09-30  \n",
       "22               Nicole  2010-09-30  \n",
       "23               Nicole  2010-09-30  \n",
       "24               Nicole  2010-09-30  \n",
       "25               Nicole  2010-09-30  \n",
       "26               Nicole  2010-09-30  \n",
       "27               Nicole  2010-09-30  \n",
       "28               Nicole  2010-09-30  \n",
       "29               Nicole  2010-09-30  \n",
       "...                  ...        ...  \n",
       "1042  Hurricane Matthew  2016-10-05  \n",
       "1043  Hurricane Matthew  2016-10-05  \n",
       "1044  Hurricane Matthew  2016-10-05  \n",
       "1045  Hurricane Matthew  2016-10-05  \n",
       "1046  Hurricane Matthew  2016-10-05  \n",
       "1047  Hurricane Matthew  2016-10-05  \n",
       "1048  Hurricane Matthew  2016-10-05  \n",
       "1049  Hurricane Matthew  2016-10-05  \n",
       "1050  Hurricane Matthew  2016-10-05  \n",
       "1051  Hurricane Matthew  2016-10-05  \n",
       "1052  Hurricane Matthew  2016-10-05  \n",
       "1053  Hurricane Matthew  2016-10-05  \n",
       "1054  Hurricane Matthew  2016-10-05  \n",
       "1055  Hurricane Matthew  2016-10-05  \n",
       "1056  Hurricane Matthew  2016-10-05  \n",
       "1057  Hurricane Matthew  2016-10-05  \n",
       "1058  Hurricane Matthew  2016-10-05  \n",
       "1059  Hurricane Matthew  2016-10-05  \n",
       "1060  Hurricane Matthew  2016-10-05  \n",
       "1061  Hurricane Matthew  2016-10-05  \n",
       "1062  Hurricane Matthew  2016-10-05  \n",
       "1063  Hurricane Matthew  2016-10-05  \n",
       "1064  Hurricane Matthew  2016-10-05  \n",
       "1065  Hurricane Matthew  2016-10-05  \n",
       "1066  Hurricane Matthew  2016-10-05  \n",
       "1067  Hurricane Matthew  2016-10-05  \n",
       "1068  Hurricane Matthew  2016-10-05  \n",
       "1069  Hurricane Matthew  2016-10-05  \n",
       "1070  Hurricane Matthew  2016-10-05  \n",
       "1071  Hurricane Matthew  2016-10-05  \n",
       "\n",
       "[1072 rows x 6 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cds['event_date'] = pd.to_datetime(event_dates)\n",
    "event_date_str = cds['event_date'].dt.strftime('%Y-%m-%d').str.replace('/', '-')\n",
    "cds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "cds['dt'] = pd.to_datetime(cds['dt'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "cds['dates'] = cds['dt'].dt.strftime('%Y-%m-%d')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "cds['event_name'] = event_names.str.strip()+ '-' + event_date_str"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "del cds['event']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>location</th>\n",
       "      <th>eventType</th>\n",
       "      <th>dt</th>\n",
       "      <th>event_name</th>\n",
       "      <th>event_date</th>\n",
       "      <th>dates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>300 BLOCK OF SHIRLEY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:32:47</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; SHIRLEY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:19</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:48</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>900 BLOCK OF TIDEWATER DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:00</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CAMPOSTELLA ROAD &amp; E BRAMBLETON AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:38</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2800 BLOCK OF E VIRGINIA BEACH BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:30:29</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:16</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; GALVESTON BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:41</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4TH VIEW STREET &amp; W OCEAN VIEW AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:02</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>300 BLOCK OF E LITTLE CREEK ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:30</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:33:08</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ALEXANDER STREET &amp; STRAND STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:34:21</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>300 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:35:57</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>400 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:09</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1100 BLOCK OF GEORGETOWN ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:28</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; SAINT PAULS BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:37:22</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BOUSH STREET &amp; W OLNEY ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:38:08</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; I-264W HIGHWAY</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:10</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BALDWIN AVENUE &amp; STOCKLEY GARDENS</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:33</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CHURCH STREET &amp; GOFF STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:26</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CHURCH STREET &amp; E PRINCESS ANNE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:45</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; MONTICELLO AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:01:50</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>DEBREE AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:11:32</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; INGLESIDE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:12:59</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>E VIRGINIA BEACH BOULEVARD &amp; TIDEWATER DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:14:08</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>GOSNOLD AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:22</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MUNSON STREET &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:39</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NEWPORT AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:53</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>COLONIAL AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:10</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ARGONNE AVENUE &amp; KITCHENER AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:50</td>\n",
       "      <td>Nicole-2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8100 BLOCK OF GLEN MYRTLE AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:00:01</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>300 BLOCK OF ROGERS AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:01:49</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>533 BEECHWOOD AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:04:40</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045</th>\n",
       "      <td>BOUSH CREEK AVENUE &amp; GLENDALE AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:06:06</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1046</th>\n",
       "      <td>PACE ROAD &amp; RIDGEFIELD DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:20:26</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>REDMON ROAD &amp; SIMMS ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:37:23</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>1400 BLOCK OF GODFREY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:52:59</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>FORREST AVENUE &amp; EVERGREEN AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:03:12</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>GLEN MYRTLE AVENUE &amp; BEECHWOOD AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:08:17</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>600 BLOCK OF W 23RD STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:34:44</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>8014 WOODALL ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:45:46</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>5300 BLOCK OF WYNGATE DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:02:42</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>5300 BLOCK OF GREENPLAIN ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:03:37</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055</th>\n",
       "      <td>1100 BLOCK OF EASTOVER ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:04:42</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>3507 POMROY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:13:49</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>5512 JANET DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:16:06</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>5531 KILMER LANE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:18:32</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>ROLFE AVENUE &amp; WALNUT HILL STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:35:30</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>SURREY CRESCENT &amp; UPPER BRANDON PLACE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:38:21</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>916 LITTLE BAY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:51:13</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>9500 BLOCK OF 10TH BAY STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:56:45</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>4245 HEUTTE DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:07:24</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>7945 RANSOM ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:18:12</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>1510 CRANE AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:26:59</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>2538 WEST AZALEA POINT ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:31:41</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>2460 RANKIN COURT</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:38:26</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>3829 WEDGEFIELD AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 15:03:38</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>5371 WYNGATE DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:27:16</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>2733 AYLIFF ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:30:43</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-13 08:39:02</td>\n",
       "      <td>Hurricane Matthew-2016-10-05</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1072 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          location       eventType  \\\n",
       "0                      300 BLOCK OF SHIRLEY AVENUE  Flooded street   \n",
       "1                LLEWELLYN AVENUE & SHIRLEY AVENUE  Flooded street   \n",
       "2          LLEWELLYN AVENUE & W PRINCESS ANNE ROAD  Flooded street   \n",
       "3                     900 BLOCK OF TIDEWATER DRIVE  Flooded street   \n",
       "4           CAMPOSTELLA ROAD & E BRAMBLETON AVENUE  Flooded street   \n",
       "5         2800 BLOCK OF E VIRGINIA BEACH BOULEVARD  Flooded street   \n",
       "6                 3500 BLOCK OF SEWELLS POINT ROAD  Flooded street   \n",
       "7        E LITTLE CREEK ROAD & GALVESTON BOULEVARD  Flooded street   \n",
       "8            4TH VIEW STREET & W OCEAN VIEW AVENUE  Flooded street   \n",
       "9                 300 BLOCK OF E LITTLE CREEK ROAD  Flooded street   \n",
       "10     E LITTLE CREEK ROAD & SAN ANTONIO BOULEVARD  Flooded street   \n",
       "11                ALEXANDER STREET & STRAND STREET  Flooded street   \n",
       "12              300 BLOCK OF SAN ANTONIO BOULEVARD  Flooded street   \n",
       "13              400 BLOCK OF SAN ANTONIO BOULEVARD  Flooded street   \n",
       "14                   1100 BLOCK OF GEORGETOWN ROAD  Flooded street   \n",
       "15     E BRAMBLETON AVENUE & SAINT PAULS BOULEVARD  Flooded street   \n",
       "16                     BOUSH STREET & W OLNEY ROAD  Flooded street   \n",
       "17            E BRAMBLETON AVENUE & I-264W HIGHWAY  Flooded street   \n",
       "18               BALDWIN AVENUE & STOCKLEY GARDENS  Flooded street   \n",
       "19                     CHURCH STREET & GOFF STREET  Flooded street   \n",
       "20            CHURCH STREET & E PRINCESS ANNE ROAD  Flooded street   \n",
       "21        E PRINCESS ANNE ROAD & MONTICELLO AVENUE  Flooded street   \n",
       "22            DEBREE AVENUE & W PRINCESS ANNE ROAD  Flooded street   \n",
       "23           E PRINCESS ANNE ROAD & INGLESIDE ROAD  Flooded street   \n",
       "24    E VIRGINIA BEACH BOULEVARD & TIDEWATER DRIVE  Flooded street   \n",
       "25                  GOSNOLD AVENUE & W 26TH STREET  Flooded street   \n",
       "26                   MUNSON STREET & W 26TH STREET  Flooded street   \n",
       "27                  NEWPORT AVENUE & W 26TH STREET  Flooded street   \n",
       "28                 COLONIAL AVENUE & W 26TH STREET  Flooded street   \n",
       "29               ARGONNE AVENUE & KITCHENER AVENUE  Flooded street   \n",
       "...                                            ...             ...   \n",
       "1042              8100 BLOCK OF GLEN MYRTLE AVENUE  Flooded street   \n",
       "1043                    300 BLOCK OF ROGERS AVENUE  Flooded street   \n",
       "1044                          533 BEECHWOOD AVENUE  Flooded street   \n",
       "1045          BOUSH CREEK AVENUE & GLENDALE AVENUE  Flooded street   \n",
       "1046                  PACE ROAD & RIDGEFIELD DRIVE  Flooded street   \n",
       "1047                      REDMON ROAD & SIMMS ROAD  Flooded street   \n",
       "1048                  1400 BLOCK OF GODFREY AVENUE  Flooded street   \n",
       "1049             FORREST AVENUE & EVERGREEN AVENUE  Flooded street   \n",
       "1050         GLEN MYRTLE AVENUE & BEECHWOOD AVENUE  Flooded street   \n",
       "1051                    600 BLOCK OF W 23RD STREET  Flooded street   \n",
       "1052                             8014 WOODALL ROAD  Flooded street   \n",
       "1053                   5300 BLOCK OF WYNGATE DRIVE  Flooded street   \n",
       "1054                 5300 BLOCK OF GREENPLAIN ROAD  Flooded street   \n",
       "1055                   1100 BLOCK OF EASTOVER ROAD  Flooded street   \n",
       "1056                            3507 POMROY AVENUE  Flooded street   \n",
       "1057                              5512 JANET DRIVE  Flooded street   \n",
       "1058                              5531 KILMER LANE  Flooded street   \n",
       "1059             ROLFE AVENUE & WALNUT HILL STREET  Flooded street   \n",
       "1060         SURREY CRESCENT & UPPER BRANDON PLACE  Flooded street   \n",
       "1061                         916 LITTLE BAY AVENUE  Flooded street   \n",
       "1062                 9500 BLOCK OF 10TH BAY STREET  Flooded street   \n",
       "1063                             4245 HEUTTE DRIVE  Flooded street   \n",
       "1064                              7945 RANSOM ROAD  Flooded street   \n",
       "1065                             1510 CRANE AVENUE  Flooded street   \n",
       "1066                   2538 WEST AZALEA POINT ROAD  Flooded street   \n",
       "1067                             2460 RANKIN COURT  Flooded street   \n",
       "1068                        3829 WEDGEFIELD AVENUE  Flooded street   \n",
       "1069                            5371 WYNGATE DRIVE  Flooded street   \n",
       "1070                              2733 AYLIFF ROAD  Flooded street   \n",
       "1071              3500 BLOCK OF SEWELLS POINT ROAD  Flooded street   \n",
       "\n",
       "                      dt                    event_name event_date       dates  \n",
       "0    2010-09-30 07:32:47             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "1    2010-09-30 07:33:19             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "2    2010-09-30 07:33:48             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "3    2010-09-30 08:29:00             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "4    2010-09-30 08:29:38             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "5    2010-09-30 08:30:29             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "6    2010-09-30 08:31:16             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "7    2010-09-30 08:31:41             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "8    2010-09-30 08:32:02             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "9    2010-09-30 08:32:30             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "10   2010-09-30 08:33:08             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "11   2010-09-30 08:34:21             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "12   2010-09-30 08:35:57             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "13   2010-09-30 08:36:09             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "14   2010-09-30 08:36:28             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "15   2010-09-30 08:37:22             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "16   2010-09-30 08:38:08             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "17   2010-09-30 08:39:10             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "18   2010-09-30 08:39:33             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "19   2010-09-30 09:00:26             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "20   2010-09-30 09:00:45             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "21   2010-09-30 09:01:50             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "22   2010-09-30 09:11:32             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "23   2010-09-30 09:12:59             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "24   2010-09-30 09:14:08             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "25   2010-09-30 09:17:22             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "26   2010-09-30 09:17:39             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "27   2010-09-30 09:17:53             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "28   2010-09-30 09:18:10             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "29   2010-09-30 09:18:50             Nicole-2010-09-30 2010-09-30  2010-09-30  \n",
       "...                  ...                           ...        ...         ...  \n",
       "1042 2016-10-11 09:00:01  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1043 2016-10-11 09:01:49  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1044 2016-10-11 09:04:40  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1045 2016-10-11 09:06:06  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1046 2016-10-11 09:20:26  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1047 2016-10-11 09:37:23  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1048 2016-10-11 09:52:59  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1049 2016-10-11 10:03:12  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1050 2016-10-11 10:08:17  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1051 2016-10-11 10:34:44  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1052 2016-10-11 10:45:46  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1053 2016-10-11 11:02:42  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1054 2016-10-11 11:03:37  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1055 2016-10-11 11:04:42  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1056 2016-10-11 11:13:49  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1057 2016-10-11 11:16:06  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1058 2016-10-11 11:18:32  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1059 2016-10-11 11:35:30  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1060 2016-10-11 11:38:21  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1061 2016-10-11 11:51:13  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1062 2016-10-11 11:56:45  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1063 2016-10-11 12:07:24  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1064 2016-10-11 12:18:12  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1065 2016-10-11 12:26:59  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1066 2016-10-11 12:31:41  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1067 2016-10-11 12:38:26  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1068 2016-10-11 15:03:38  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-11  \n",
       "1069 2016-10-12 14:27:16  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-12  \n",
       "1070 2016-10-12 14:30:43  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-12  \n",
       "1071 2016-10-13 08:39:02  Hurricane Matthew-2016-10-05 2016-10-05  2016-10-13  \n",
       "\n",
       "[1072 rows x 6 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "#con = sqlite3.connect(db_filename)\n",
    "#cds.to_sql(con=con, name=\"flood_events\", if_exists=\"replace\")\n",
    "cds.to_csv('flood_events.csv')"
   ]
  },
  {
   "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>location</th>\n",
       "      <th>eventType</th>\n",
       "      <th>dt</th>\n",
       "      <th>event_date</th>\n",
       "      <th>dates</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>event_name</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>Nicole-2010-09-30</th>\n",
       "      <td>300 BLOCK OF SHIRLEY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:32:47</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; SHIRLEY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:19</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>LLEWELLYN AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 07:33:48</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>900 BLOCK OF TIDEWATER DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:00</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>CAMPOSTELLA ROAD &amp; E BRAMBLETON AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:29:38</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>2800 BLOCK OF E VIRGINIA BEACH BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:30:29</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:16</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; GALVESTON BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:31:41</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>4TH VIEW STREET &amp; W OCEAN VIEW AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:02</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>300 BLOCK OF E LITTLE CREEK ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:32:30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E LITTLE CREEK ROAD &amp; SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:33:08</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>ALEXANDER STREET &amp; STRAND STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:34:21</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>300 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:35:57</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>400 BLOCK OF SAN ANTONIO BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:09</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>1100 BLOCK OF GEORGETOWN ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:36:28</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; SAINT PAULS BOULEVARD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:37:22</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>BOUSH STREET &amp; W OLNEY ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:38:08</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E BRAMBLETON AVENUE &amp; I-264W HIGHWAY</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:10</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>BALDWIN AVENUE &amp; STOCKLEY GARDENS</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 08:39:33</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>CHURCH STREET &amp; GOFF STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:26</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>CHURCH STREET &amp; E PRINCESS ANNE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:00:45</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; MONTICELLO AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:01:50</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>DEBREE AVENUE &amp; W PRINCESS ANNE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:11:32</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E PRINCESS ANNE ROAD &amp; INGLESIDE ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:12:59</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>E VIRGINIA BEACH BOULEVARD &amp; TIDEWATER DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:14:08</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>GOSNOLD AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:22</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>MUNSON STREET &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:39</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>NEWPORT AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:17:53</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>COLONIAL AVENUE &amp; W 26TH STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:10</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicole-2010-09-30</th>\n",
       "      <td>ARGONNE AVENUE &amp; KITCHENER AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2010-09-30 09:18:50</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>8100 BLOCK OF GLEN MYRTLE AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:00:01</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>300 BLOCK OF ROGERS AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:01:49</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>533 BEECHWOOD AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:04:40</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>BOUSH CREEK AVENUE &amp; GLENDALE AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:06:06</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>PACE ROAD &amp; RIDGEFIELD DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:20:26</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>REDMON ROAD &amp; SIMMS ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:37:23</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>1400 BLOCK OF GODFREY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 09:52:59</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>FORREST AVENUE &amp; EVERGREEN AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:03:12</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>GLEN MYRTLE AVENUE &amp; BEECHWOOD AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:08:17</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>600 BLOCK OF W 23RD STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:34:44</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>8014 WOODALL ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 10:45:46</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>5300 BLOCK OF WYNGATE DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:02:42</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>5300 BLOCK OF GREENPLAIN ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:03:37</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>1100 BLOCK OF EASTOVER ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:04:42</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>3507 POMROY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:13:49</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>5512 JANET DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:16:06</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>5531 KILMER LANE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:18:32</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>ROLFE AVENUE &amp; WALNUT HILL STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:35:30</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>SURREY CRESCENT &amp; UPPER BRANDON PLACE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:38:21</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>916 LITTLE BAY AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:51:13</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>9500 BLOCK OF 10TH BAY STREET</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 11:56:45</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>4245 HEUTTE DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:07:24</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>7945 RANSOM ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:18:12</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>1510 CRANE AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:26:59</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>2538 WEST AZALEA POINT ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:31:41</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>2460 RANKIN COURT</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 12:38:26</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>3829 WEDGEFIELD AVENUE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-11 15:03:38</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>5371 WYNGATE DRIVE</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:27:16</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>2733 AYLIFF ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-12 14:30:43</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hurricane Matthew-2016-10-05</th>\n",
       "      <td>3500 BLOCK OF SEWELLS POINT ROAD</td>\n",
       "      <td>Flooded street</td>\n",
       "      <td>2016-10-13 08:39:02</td>\n",
       "      <td>2016-10-05</td>\n",
       "      <td>2016-10-13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1072 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                  location  \\\n",
       "event_name                                                                   \n",
       "Nicole-2010-09-30                              300 BLOCK OF SHIRLEY AVENUE   \n",
       "Nicole-2010-09-30                        LLEWELLYN AVENUE & SHIRLEY AVENUE   \n",
       "Nicole-2010-09-30                  LLEWELLYN AVENUE & W PRINCESS ANNE ROAD   \n",
       "Nicole-2010-09-30                             900 BLOCK OF TIDEWATER DRIVE   \n",
       "Nicole-2010-09-30                   CAMPOSTELLA ROAD & E BRAMBLETON AVENUE   \n",
       "Nicole-2010-09-30                 2800 BLOCK OF E VIRGINIA BEACH BOULEVARD   \n",
       "Nicole-2010-09-30                         3500 BLOCK OF SEWELLS POINT ROAD   \n",
       "Nicole-2010-09-30                E LITTLE CREEK ROAD & GALVESTON BOULEVARD   \n",
       "Nicole-2010-09-30                    4TH VIEW STREET & W OCEAN VIEW AVENUE   \n",
       "Nicole-2010-09-30                         300 BLOCK OF E LITTLE CREEK ROAD   \n",
       "Nicole-2010-09-30              E LITTLE CREEK ROAD & SAN ANTONIO BOULEVARD   \n",
       "Nicole-2010-09-30                         ALEXANDER STREET & STRAND STREET   \n",
       "Nicole-2010-09-30                       300 BLOCK OF SAN ANTONIO BOULEVARD   \n",
       "Nicole-2010-09-30                       400 BLOCK OF SAN ANTONIO BOULEVARD   \n",
       "Nicole-2010-09-30                            1100 BLOCK OF GEORGETOWN ROAD   \n",
       "Nicole-2010-09-30              E BRAMBLETON AVENUE & SAINT PAULS BOULEVARD   \n",
       "Nicole-2010-09-30                              BOUSH STREET & W OLNEY ROAD   \n",
       "Nicole-2010-09-30                     E BRAMBLETON AVENUE & I-264W HIGHWAY   \n",
       "Nicole-2010-09-30                        BALDWIN AVENUE & STOCKLEY GARDENS   \n",
       "Nicole-2010-09-30                              CHURCH STREET & GOFF STREET   \n",
       "Nicole-2010-09-30                     CHURCH STREET & E PRINCESS ANNE ROAD   \n",
       "Nicole-2010-09-30                 E PRINCESS ANNE ROAD & MONTICELLO AVENUE   \n",
       "Nicole-2010-09-30                     DEBREE AVENUE & W PRINCESS ANNE ROAD   \n",
       "Nicole-2010-09-30                    E PRINCESS ANNE ROAD & INGLESIDE ROAD   \n",
       "Nicole-2010-09-30             E VIRGINIA BEACH BOULEVARD & TIDEWATER DRIVE   \n",
       "Nicole-2010-09-30                           GOSNOLD AVENUE & W 26TH STREET   \n",
       "Nicole-2010-09-30                            MUNSON STREET & W 26TH STREET   \n",
       "Nicole-2010-09-30                           NEWPORT AVENUE & W 26TH STREET   \n",
       "Nicole-2010-09-30                          COLONIAL AVENUE & W 26TH STREET   \n",
       "Nicole-2010-09-30                        ARGONNE AVENUE & KITCHENER AVENUE   \n",
       "...                                                                    ...   \n",
       "Hurricane Matthew-2016-10-05              8100 BLOCK OF GLEN MYRTLE AVENUE   \n",
       "Hurricane Matthew-2016-10-05                    300 BLOCK OF ROGERS AVENUE   \n",
       "Hurricane Matthew-2016-10-05                          533 BEECHWOOD AVENUE   \n",
       "Hurricane Matthew-2016-10-05          BOUSH CREEK AVENUE & GLENDALE AVENUE   \n",
       "Hurricane Matthew-2016-10-05                  PACE ROAD & RIDGEFIELD DRIVE   \n",
       "Hurricane Matthew-2016-10-05                      REDMON ROAD & SIMMS ROAD   \n",
       "Hurricane Matthew-2016-10-05                  1400 BLOCK OF GODFREY AVENUE   \n",
       "Hurricane Matthew-2016-10-05             FORREST AVENUE & EVERGREEN AVENUE   \n",
       "Hurricane Matthew-2016-10-05         GLEN MYRTLE AVENUE & BEECHWOOD AVENUE   \n",
       "Hurricane Matthew-2016-10-05                    600 BLOCK OF W 23RD STREET   \n",
       "Hurricane Matthew-2016-10-05                             8014 WOODALL ROAD   \n",
       "Hurricane Matthew-2016-10-05                   5300 BLOCK OF WYNGATE DRIVE   \n",
       "Hurricane Matthew-2016-10-05                 5300 BLOCK OF GREENPLAIN ROAD   \n",
       "Hurricane Matthew-2016-10-05                   1100 BLOCK OF EASTOVER ROAD   \n",
       "Hurricane Matthew-2016-10-05                            3507 POMROY AVENUE   \n",
       "Hurricane Matthew-2016-10-05                              5512 JANET DRIVE   \n",
       "Hurricane Matthew-2016-10-05                              5531 KILMER LANE   \n",
       "Hurricane Matthew-2016-10-05             ROLFE AVENUE & WALNUT HILL STREET   \n",
       "Hurricane Matthew-2016-10-05         SURREY CRESCENT & UPPER BRANDON PLACE   \n",
       "Hurricane Matthew-2016-10-05                         916 LITTLE BAY AVENUE   \n",
       "Hurricane Matthew-2016-10-05                 9500 BLOCK OF 10TH BAY STREET   \n",
       "Hurricane Matthew-2016-10-05                             4245 HEUTTE DRIVE   \n",
       "Hurricane Matthew-2016-10-05                              7945 RANSOM ROAD   \n",
       "Hurricane Matthew-2016-10-05                             1510 CRANE AVENUE   \n",
       "Hurricane Matthew-2016-10-05                   2538 WEST AZALEA POINT ROAD   \n",
       "Hurricane Matthew-2016-10-05                             2460 RANKIN COURT   \n",
       "Hurricane Matthew-2016-10-05                        3829 WEDGEFIELD AVENUE   \n",
       "Hurricane Matthew-2016-10-05                            5371 WYNGATE DRIVE   \n",
       "Hurricane Matthew-2016-10-05                              2733 AYLIFF ROAD   \n",
       "Hurricane Matthew-2016-10-05              3500 BLOCK OF SEWELLS POINT ROAD   \n",
       "\n",
       "                                   eventType                  dt event_date  \\\n",
       "event_name                                                                    \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 07:32:47 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 07:33:19 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 07:33:48 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:29:00 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:29:38 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:30:29 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:31:16 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:31:41 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:32:02 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:32:30 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:33:08 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:34:21 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:35:57 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:36:09 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:36:28 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:37:22 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:38:08 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:39:10 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 08:39:33 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:00:26 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:00:45 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:01:50 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:11:32 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:12:59 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:14:08 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:17:22 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:17:39 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:17:53 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:18:10 2010-09-30   \n",
       "Nicole-2010-09-30             Flooded street 2010-09-30 09:18:50 2010-09-30   \n",
       "...                                      ...                 ...        ...   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:00:01 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:01:49 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:04:40 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:06:06 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:20:26 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:37:23 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 09:52:59 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 10:03:12 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 10:08:17 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 10:34:44 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 10:45:46 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:02:42 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:03:37 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:04:42 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:13:49 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:16:06 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:18:32 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:35:30 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:38:21 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:51:13 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 11:56:45 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 12:07:24 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 12:18:12 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 12:26:59 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 12:31:41 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 12:38:26 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-11 15:03:38 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-12 14:27:16 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-12 14:30:43 2016-10-05   \n",
       "Hurricane Matthew-2016-10-05  Flooded street 2016-10-13 08:39:02 2016-10-05   \n",
       "\n",
       "                                   dates  \n",
       "event_name                                \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "Nicole-2010-09-30             2010-09-30  \n",
       "...                                  ...  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-11  \n",
       "Hurricane Matthew-2016-10-05  2016-10-12  \n",
       "Hurricane Matthew-2016-10-05  2016-10-12  \n",
       "Hurricane Matthew-2016-10-05  2016-10-13  \n",
       "\n",
       "[1072 rows x 5 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cds.set_index('event_name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}