02_scrape_fema.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "start_url = \"https://www.fema.gov/disaster-reporter-data\"\n",
    "page_source = requests.get(start_url).text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(page_source, 'lxml')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/disaster-reporter-data?page=1'"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "next_link = soup.findChild(attrs={'class':'next'}).find('a').attrs['href']\n",
    "next_link"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<td><img alt=\"Photo: 1615 hwy 9\" src=\"https://www.fema.gov/media-library-data/20180924-2005-19716-1696/disaster_reporter_20180924160539_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180924-2005-19716-1696/disaster_reporter_20180924160539.jpg\" title=\"View full size of - 1615 hwy 9\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170920\" title=\"Report this image - 1615 hwy 9\">Report this Image</a></td>, <td>1615 hwy 9</td>, <td>Longs</td>, <td>SC</td>, <td>Floods</td>, <td>Sat, 09/22/2018 - 13:54</td>, <td class=\"active\">Mon, 09/24/2018 - 16:05</td>]\n",
      "[<td><img alt=\"Photo: Southport bc\" src=\"https://www.fema.gov/media-library-data/20180924-1838-18167-5375/disaster_reporter_20180924143810_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180924-1838-18167-5375/disaster_reporter_20180924143810.jpg\" title=\"View full size of - Southport bc\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170906\" title=\"Report this image - Southport bc\">Report this Image</a></td>, <td>Southport bc</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Wed, 09/19/2018 - 16:19</td>, <td class=\"active\">Mon, 09/24/2018 - 14:38</td>]\n",
      "[<td><img alt=\"Photo: Kathy Tripp's crushed barn\" src=\"https://www.fema.gov/media-library-data/20180924-1617-12436-7396/disaster_reporter_20180924121713_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180924-1617-12436-7396/disaster_reporter_20180924121713.jpg\" title=\"View full size of - Kathy Tripp&amp;#039;s crushed barn\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170894\" title=\"Report this image - Kathy Tripp's crushed barn\">Report this Image</a></td>, <td>Kathy Tripp's crushed barn</td>, <td>Newport</td>, <td>NC</td>, <td>Hurricanes</td>, <td>Sat, 09/15/2018 - 05:14</td>, <td class=\"active\">Mon, 09/24/2018 - 12:17</td>]\n",
      "[<td><img alt=\"Photo: Conway sc\" src=\"https://www.fema.gov/media-library-data/20180923-1240-13399-6034/disaster_reporter_20180923084053_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180923-1240-13399-6034/disaster_reporter_20180923084053.jpg\" title=\"View full size of - Conway sc\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170843\" title=\"Report this image - Conway sc\">Report this Image</a></td>, <td>Conway sc</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Sat, 09/15/2018 - 10:34</td>, <td class=\"active\">Sun, 09/23/2018 - 08:40</td>]\n",
      "[<td><img alt=\"Photo: My yard\" src=\"https://www.fema.gov/media-library-data/20180922-2138-18164-6651/disaster_reporter_20180922173843_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180922-2138-18164-6651/disaster_reporter_20180922173843.jpg\" title=\"View full size of - My yard\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170842\" title=\"Report this image - My yard\">Report this Image</a></td>, <td>My yard</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Thu, 09/20/2018 - 04:53</td>, <td class=\"active\">Sat, 09/22/2018 - 17:38</td>]\n",
      "[<td><img alt=\"Photo: CAP PHOTO HMW 8’\" src=\"https://www.fema.gov/media-library-data/20180922-2047-18173-0028/disaster_reporter_20180922164723_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180922-2047-18173-0028/disaster_reporter_20180922164723.jpg\" title=\"View full size of - CAP PHOTO HMW 8’\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170841\" title=\"Report this image - CAP PHOTO HMW 8’\">Report this Image</a></td>, <td>CAP PHOTO HMW 8’</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Sat, 09/22/2018 - 16:32</td>, <td class=\"active\">Sat, 09/22/2018 - 16:47</td>]\n",
      "[<td><img alt=\"Photo: Target 14, Odell ventures landing, Johnsonville, S\" src=\"https://www.fema.gov/media-library-data/20180922-1944-13390-2248/disaster_reporter_20180922154411_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180922-1944-13390-2248/disaster_reporter_20180922154411.jpg\" title=\"View full size of - Target 14, Odell ventures landing, Johnsonville, S\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170840\" title=\"Report this image - Target 14, Odell ventures landing, Johnsonville, S\">Report this Image</a></td>, <td>Target 14, Odell ventures landing, Johnsonville, S</td>, <td></td>, <td></td>, <td>Floods</td>, <td>Sat, 09/22/2018 - 15:43</td>, <td class=\"active\">Sat, 09/22/2018 - 15:44</td>]\n",
      "[<td><img alt=\"Photo: Our house\" src=\"https://www.fema.gov/media-library-data/20180922-1941-1129-6747/disaster_reporter_20180922154101_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180922-1941-1129-6747/disaster_reporter_20180922154101.jpg\" title=\"View full size of - Our house\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170839\" title=\"Report this image - Our house\">Report this Image</a></td>, <td>Our house</td>, <td></td>, <td></td>, <td>Floods</td>, <td>Mon, 09/17/2018 - 05:47</td>, <td class=\"active\">Sat, 09/22/2018 - 15:41</td>]\n",
      "[<td><img alt=\"Photo: Drive way\" src=\"https://www.fema.gov/media-library-data/20180922-1939-13399-0117/disaster_reporter_20180922153948_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180922-1939-13399-0117/disaster_reporter_20180922153948.jpg\" title=\"View full size of - Drive way\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170838\" title=\"Report this image - Drive way\">Report this Image</a></td>, <td>Drive way</td>, <td></td>, <td></td>, <td>Floods</td>, <td>Thu, 09/20/2018 - 09:00</td>, <td class=\"active\">Sat, 09/22/2018 - 15:39</td>]\n",
      "[<td><img alt=\"Photo: Shelter\" src=\"https://www.fema.gov/media-library-data/20180918-2341-19716-5277/disaster_reporter_20180918194146_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-2341-19716-5277/disaster_reporter_20180918194146.jpg\" title=\"View full size of - Shelter\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170488\" title=\"Report this image - Shelter\">Report this Image</a></td>, <td>Shelter</td>, <td>Lumberton</td>, <td>NC</td>, <td>Hurricanes</td>, <td>Sun, 09/16/2018 - 15:51</td>, <td class=\"active\">Tue, 09/18/2018 - 19:41</td>]\n",
      "[<td><img alt=\"Photo: Neighbor\" src=\"https://www.fema.gov/media-library-data/20180918-2306-12439-3238/disaster_reporter_20180918190604_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-2306-12439-3238/disaster_reporter_20180918190604.jpg\" title=\"View full size of - Neighbor\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170481\" title=\"Report this image - Neighbor\">Report this Image</a></td>, <td>Neighbor</td>, <td>Havelock</td>, <td>NC</td>, <td>Hurricanes</td>, <td>Sat, 09/15/2018 - 11:10</td>, <td class=\"active\">Tue, 09/18/2018 - 19:06</td>]\n",
      "[<td><img alt=\"Photo: Flooded for hurricane Florence at rocky Point, NC\" src=\"https://www.fema.gov/media-library-data/20180918-2024-18164-0196/disaster_reporter_20180918162406_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-2024-18164-0196/disaster_reporter_20180918162406.jpg\" title=\"View full size of - Flooded for hurricane Florence at rocky Point, NC\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170470\" title=\"Report this image - Flooded for hurricane Florence at rocky Point, NC\">Report this Image</a></td>, <td>Flooded for hurricane Florence at rocky Point, NC</td>, <td>Rocky Point</td>, <td>NC</td>, <td>Floods</td>, <td>Sun, 09/16/2018 - 07:01</td>, <td class=\"active\">Tue, 09/18/2018 - 16:24</td>]\n",
      "[<td><img alt=\"Photo: Flooded road\" src=\"https://www.fema.gov/media-library-data/20180918-2007-7498-1410/disaster_reporter_20180918160656_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-2007-7498-1410/disaster_reporter_20180918160656.jpg\" title=\"View full size of - Flooded road\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170468\" title=\"Report this image - Flooded road\">Report this Image</a></td>, <td>Flooded road</td>, <td>Wallace</td>, <td>NC</td>, <td>Hurricanes</td>, <td>Tue, 09/18/2018 - 15:53</td>, <td class=\"active\">Tue, 09/18/2018 - 16:07</td>]\n",
      "[<td><img alt=\"Photo: Flooded\" src=\"https://www.fema.gov/media-library-data/20180918-1935-18164-1991/disaster_reporter_20180918153437_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-1935-18164-1991/disaster_reporter_20180918153437.jpg\" title=\"View full size of - Flooded\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170460\" title=\"Report this image - Flooded\">Report this Image</a></td>, <td>Flooded</td>, <td>Currie</td>, <td>NC</td>, <td>Floods</td>, <td>Sun, 09/16/2018 - 06:58</td>, <td class=\"active\">Tue, 09/18/2018 - 15:35</td>]\n",
      "[<td><img alt=\"Photo: My sisters house Mmray road\" src=\"https://www.fema.gov/media-library-data/20180918-1844-19716-6409/disaster_reporter_20180918144438_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-1844-19716-6409/disaster_reporter_20180918144438.jpg\" title=\"View full size of - My sisters house Mmray road\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170450\" title=\"Report this image - My sisters house Mmray road\">Report this Image</a></td>, <td>My sisters house Mmray road</td>, <td></td>, <td></td>, <td>Floods</td>, <td>Mon, 09/17/2018 - 12:24</td>, <td class=\"active\">Tue, 09/18/2018 - 14:44</td>]\n",
      "[<td><img alt=\"Photo: Downtown New Bern\" src=\"https://www.fema.gov/media-library-data/20180918-1813-12433-8443/disaster_reporter_20180918141338_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-1813-12433-8443/disaster_reporter_20180918141338.jpg\" title=\"View full size of - Downtown New Bern\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170447\" title=\"Report this image - Downtown New Bern\">Report this Image</a></td>, <td>Downtown New Bern</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Sun, 09/16/2018 - 15:20</td>, <td class=\"active\">Tue, 09/18/2018 - 14:13</td>]\n",
      "[<td><img alt=\"Photo: My hometown, Lumberton, N.C. highway 41 south\" src=\"https://www.fema.gov/media-library-data/20180918-1808-1123-6650/disaster_reporter_20180918140829_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180918-1808-1123-6650/disaster_reporter_20180918140829.jpg\" title=\"View full size of - My hometown, Lumberton, N.C. highway 41 south\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170446\" title=\"Report this image - My hometown, Lumberton, N.C. highway 41 south\">Report this Image</a></td>, <td>My hometown, Lumberton, N.C. highway 41 south</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Mon, 09/17/2018 - 05:02</td>, <td class=\"active\">Tue, 09/18/2018 - 14:08</td>]\n",
      "[<td><img alt=\"Photo: Flooding\" src=\"https://www.fema.gov/media-library-data/20180915-2350-12439-8666/disaster_reporter_20180915195044_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180915-2350-12439-8666/disaster_reporter_20180915195044.jpg\" title=\"View full size of - Flooding\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170149\" title=\"Report this image - Flooding\">Report this Image</a></td>, <td>Flooding</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Sat, 09/15/2018 - 09:44</td>, <td class=\"active\">Sat, 09/15/2018 - 19:50</td>]\n",
      "[<td><img alt=\"Photo: Wind damages\" src=\"https://www.fema.gov/media-library-data/20180915-2344-18173-1047/disaster_reporter_20180915194428_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180915-2344-18173-1047/disaster_reporter_20180915194428.jpg\" title=\"View full size of - Wind damages\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170148\" title=\"Report this image - Wind damages\">Report this Image</a></td>, <td>Wind damages</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Sat, 09/15/2018 - 09:40</td>, <td class=\"active\">Sat, 09/15/2018 - 19:44</td>]\n",
      "[<td><img alt=\"Photo: Tree down\" src=\"https://www.fema.gov/media-library-data/20180915-2341-13393-7105/disaster_reporter_20180915194046_search_preview.jpg\"/><br/><a href=\"https://www.fema.gov/media-library-data/20180915-2341-13393-7105/disaster_reporter_20180915194046.jpg\" title=\"View full size of - Tree down\">View Full Size</a><br/><a href=\"mailto:FEMA-New-Media@fema.dhs.gov?subject=Disaster%20Reporter:%20Review%20Image%20170147\" title=\"Report this image - Tree down\">Report this Image</a></td>, <td>Tree down</td>, <td></td>, <td></td>, <td>Hurricanes</td>, <td>Sat, 09/15/2018 - 09:42</td>, <td class=\"active\">Sat, 09/15/2018 - 19:41</td>]\n"
     ]
    }
   ],
   "source": [
    "header = ['Disaster Reports', 'Headlines', 'City', 'State',\n",
    "          'Disaster Type', 'Photo Date', 'Report Date']\n",
    "\n",
    "rows = soup.find('table').find('tbody').findAll('tr')\n",
    "\n",
    "for row in rows:\n",
    "    print(row.findAll('td'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def parse_page(source):\n",
    "    \n",
    "    soup = BeautifulSoup(source, \"lxml\")\n",
    "    \n",
    "    ### Scrape the table\n",
    "    rows = soup.find(\"table\").find(\"tbody\").findAll(\"tr\")\n",
    "\n",
    "    data = []\n",
    "\n",
    "    for row in rows:\n",
    "\n",
    "        data_row = []\n",
    "\n",
    "        for value in row.findAll(\"td\"):\n",
    "            data_row.append(value.text)\n",
    "\n",
    "        data.append(data_row)\n",
    "\n",
    "    return data\n",
    "\n",
    "def fetch_page(url):\n",
    "    start_url = url\n",
    "    return requests.get(start_url).text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fetching next page...0\n",
      "Fetching next page...1\n",
      "Fetching next page...2\n",
      "Fetching next page...3\n",
      "Fetching next page...4\n",
      "Fetching next page...5\n",
      "Fetching next page...6\n",
      "Fetching next page...7\n",
      "Fetching next page...8\n",
      "Fetching next page...9\n",
      "Fetching next page...10\n",
      "Fetching next page...11\n",
      "Fetching next page...12\n",
      "Fetching next page...13\n",
      "Fetching next page...14\n",
      "Fetching next page...15\n",
      "Fetching next page...16\n",
      "Fetching next page...17\n",
      "Fetching next page...18\n",
      "Fetching next page...19\n",
      "Fetching next page...20\n",
      "Fetching next page...21\n",
      "Fetching next page...22\n",
      "Fetching next page...23\n",
      "Fetching next page...24\n",
      "Fetching next page...25\n",
      "Fetching next page...26\n",
      "Fetching next page...27\n",
      "Fetching next page...28\n",
      "Fetching next page...29\n",
      "Fetching next page...30\n",
      "Fetching next page...31\n",
      "Fetching next page...32\n",
      "Fetching next page...33\n",
      "Fetching next page...34\n",
      "Fetching next page...35\n",
      "Fetching next page...36\n",
      "Fetching next page...37\n",
      "Fetching next page...38\n",
      "Fetching next page...39\n",
      "Fetching next page...40\n",
      "Fetching next page...41\n",
      "Fetching next page...42\n",
      "Fetching next page...43\n",
      "Fetching next page...44\n",
      "Fetching next page...45\n",
      "Fetching next page...46\n",
      "Fetching next page...47\n",
      "Fetching next page...48\n",
      "Fetching next page...49\n"
     ]
    }
   ],
   "source": [
    "start_url = \"https://www.fema.gov/disaster-reporter-data\"\n",
    "page_source = fetch_page(start_url)\n",
    "\n",
    "#is there a next link?\n",
    "next_link = soup.findChild(attrs={'class':'next'}).find('a').attrs['href']\n",
    "next_link\n",
    "\n",
    "all_data = parse_page(page_source)\n",
    "\n",
    "max_fetches = 50\n",
    "current_page = 0\n",
    "\n",
    "while True:\n",
    "    \n",
    "    if current_page >= max_fetches:\n",
    "        break\n",
    "    \n",
    "    if next_link:\n",
    "        print(\"Fetching next page...{}\".format(current_page))\n",
    "        next_url = 'https://www.fema.gov{}'.format(next_link)\n",
    "        next_page_source = fetch_page(next_url)\n",
    "        page_data = parse_page(next_page_source)\n",
    "        all_data.extend(page_data)\n",
    "    \n",
    "    current_page += 1\n",
    "\n",
    "#parse_page(page_source)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Disaster Reports</th>\n",
       "      <th>Headlines</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Disaster Type</th>\n",
       "      <th>Photo Date</th>\n",
       "      <th>Report Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>1615 hwy 9</td>\n",
       "      <td>Longs</td>\n",
       "      <td>SC</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sat, 09/22/2018 - 13:54</td>\n",
       "      <td>Mon, 09/24/2018 - 16:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Southport bc</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Wed, 09/19/2018 - 16:19</td>\n",
       "      <td>Mon, 09/24/2018 - 14:38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Kathy Tripp's crushed barn</td>\n",
       "      <td>Newport</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 05:14</td>\n",
       "      <td>Mon, 09/24/2018 - 12:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Conway sc</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 10:34</td>\n",
       "      <td>Sun, 09/23/2018 - 08:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>My yard</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Thu, 09/20/2018 - 04:53</td>\n",
       "      <td>Sat, 09/22/2018 - 17:38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>CAP PHOTO HMW 8’</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/22/2018 - 16:32</td>\n",
       "      <td>Sat, 09/22/2018 - 16:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Target 14, Odell ventures landing, Johnsonvill...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sat, 09/22/2018 - 15:43</td>\n",
       "      <td>Sat, 09/22/2018 - 15:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Our house</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Floods</td>\n",
       "      <td>Mon, 09/17/2018 - 05:47</td>\n",
       "      <td>Sat, 09/22/2018 - 15:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Drive way</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Floods</td>\n",
       "      <td>Thu, 09/20/2018 - 09:00</td>\n",
       "      <td>Sat, 09/22/2018 - 15:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Shelter</td>\n",
       "      <td>Lumberton</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sun, 09/16/2018 - 15:51</td>\n",
       "      <td>Tue, 09/18/2018 - 19:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Neighbor</td>\n",
       "      <td>Havelock</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 11:10</td>\n",
       "      <td>Tue, 09/18/2018 - 19:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Flooded for hurricane Florence at rocky Point, NC</td>\n",
       "      <td>Rocky Point</td>\n",
       "      <td>NC</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sun, 09/16/2018 - 07:01</td>\n",
       "      <td>Tue, 09/18/2018 - 16:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Flooded road</td>\n",
       "      <td>Wallace</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Tue, 09/18/2018 - 15:53</td>\n",
       "      <td>Tue, 09/18/2018 - 16:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Flooded</td>\n",
       "      <td>Currie</td>\n",
       "      <td>NC</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sun, 09/16/2018 - 06:58</td>\n",
       "      <td>Tue, 09/18/2018 - 15:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>My sisters house Mmray road</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Floods</td>\n",
       "      <td>Mon, 09/17/2018 - 12:24</td>\n",
       "      <td>Tue, 09/18/2018 - 14:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Downtown New Bern</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sun, 09/16/2018 - 15:20</td>\n",
       "      <td>Tue, 09/18/2018 - 14:13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>My hometown, Lumberton, N.C. highway 41 south</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Mon, 09/17/2018 - 05:02</td>\n",
       "      <td>Tue, 09/18/2018 - 14:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Flooding</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:44</td>\n",
       "      <td>Sat, 09/15/2018 - 19:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Wind damages</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:40</td>\n",
       "      <td>Sat, 09/15/2018 - 19:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Tree down</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:42</td>\n",
       "      <td>Sat, 09/15/2018 - 19:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Flooded roads</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:59</td>\n",
       "      <td>Sat, 09/15/2018 - 19:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Trees down on Power lines</td>\n",
       "      <td>Wallace</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:01</td>\n",
       "      <td>Sat, 09/15/2018 - 19:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Hurricane Florence in Havelock NC</td>\n",
       "      <td>Havelock</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 13:43</td>\n",
       "      <td>Sat, 09/15/2018 - 18:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Green Hanes rd Kinston</td>\n",
       "      <td>Kinston</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 10:00</td>\n",
       "      <td>Sat, 09/15/2018 - 17:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Bluestone Dam</td>\n",
       "      <td>Hinton</td>\n",
       "      <td>WV</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sat, 09/15/2018 - 15:32</td>\n",
       "      <td>Sat, 09/15/2018 - 15:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Wilmington NC 42nd St and Park ave</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 08:42</td>\n",
       "      <td>Sat, 09/15/2018 - 15:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Fayetteville NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 18:06</td>\n",
       "      <td>Sat, 09/15/2018 - 15:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Bluestone Dam -WV</td>\n",
       "      <td>Hinton</td>\n",
       "      <td>WV</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sat, 09/15/2018 - 14:19</td>\n",
       "      <td>Sat, 09/15/2018 - 14:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Top coming off</td>\n",
       "      <td>Saint Pauls</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 14:24</td>\n",
       "      <td>Sat, 09/15/2018 - 14:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>in my neighborhood in The Holiday Pines Develo...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:08</td>\n",
       "      <td>Sat, 09/15/2018 - 13:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Made it!</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 13:43</td>\n",
       "      <td>Sat, 09/15/2018 - 11:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Jacksonville NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 08:25</td>\n",
       "      <td>Sat, 09/15/2018 - 10:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Jacksonville NC</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 07:25</td>\n",
       "      <td>Sat, 09/15/2018 - 10:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Hurricane Florence</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 15:03</td>\n",
       "      <td>Sat, 09/15/2018 - 02:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>I don’t think that belongs there</td>\n",
       "      <td>Wilmington</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 17:22</td>\n",
       "      <td>Fri, 09/14/2018 - 22:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Storm surge on John Court, Havelock, NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Floods</td>\n",
       "      <td>Fri, 09/14/2018 - 17:45</td>\n",
       "      <td>Fri, 09/14/2018 - 18:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Tree uprooted in Northwest Leland Hoods Creek ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 14:10</td>\n",
       "      <td>Fri, 09/14/2018 - 15:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Trees down - Brunswick Forest Leland NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:40</td>\n",
       "      <td>Fri, 09/14/2018 - 11:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Broken Tree</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:39</td>\n",
       "      <td>Fri, 09/14/2018 - 11:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Shrub bent over - Brunswick Forest</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:38</td>\n",
       "      <td>Fri, 09/14/2018 - 11:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Flooded roads</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:59</td>\n",
       "      <td>Sat, 09/15/2018 - 19:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Trees down on Power lines</td>\n",
       "      <td>Wallace</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 09:01</td>\n",
       "      <td>Sat, 09/15/2018 - 19:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Hurricane Florence in Havelock NC</td>\n",
       "      <td>Havelock</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 13:43</td>\n",
       "      <td>Sat, 09/15/2018 - 18:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Green Hanes rd Kinston</td>\n",
       "      <td>Kinston</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 10:00</td>\n",
       "      <td>Sat, 09/15/2018 - 17:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Bluestone Dam</td>\n",
       "      <td>Hinton</td>\n",
       "      <td>WV</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sat, 09/15/2018 - 15:32</td>\n",
       "      <td>Sat, 09/15/2018 - 15:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Wilmington NC 42nd St and Park ave</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 08:42</td>\n",
       "      <td>Sat, 09/15/2018 - 15:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Fayetteville NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 18:06</td>\n",
       "      <td>Sat, 09/15/2018 - 15:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Bluestone Dam -WV</td>\n",
       "      <td>Hinton</td>\n",
       "      <td>WV</td>\n",
       "      <td>Floods</td>\n",
       "      <td>Sat, 09/15/2018 - 14:19</td>\n",
       "      <td>Sat, 09/15/2018 - 14:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Top coming off</td>\n",
       "      <td>Saint Pauls</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Sat, 09/15/2018 - 14:24</td>\n",
       "      <td>Sat, 09/15/2018 - 14:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>in my neighborhood in The Holiday Pines Develo...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:08</td>\n",
       "      <td>Sat, 09/15/2018 - 13:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Made it!</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 13:43</td>\n",
       "      <td>Sat, 09/15/2018 - 11:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Jacksonville NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 08:25</td>\n",
       "      <td>Sat, 09/15/2018 - 10:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Jacksonville NC</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 07:25</td>\n",
       "      <td>Sat, 09/15/2018 - 10:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Hurricane Florence</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 15:03</td>\n",
       "      <td>Sat, 09/15/2018 - 02:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>I don’t think that belongs there</td>\n",
       "      <td>Wilmington</td>\n",
       "      <td>NC</td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 17:22</td>\n",
       "      <td>Fri, 09/14/2018 - 22:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Storm surge on John Court, Havelock, NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Floods</td>\n",
       "      <td>Fri, 09/14/2018 - 17:45</td>\n",
       "      <td>Fri, 09/14/2018 - 18:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Tree uprooted in Northwest Leland Hoods Creek ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 14:10</td>\n",
       "      <td>Fri, 09/14/2018 - 15:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Trees down - Brunswick Forest Leland NC</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:40</td>\n",
       "      <td>Fri, 09/14/2018 - 11:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Broken Tree</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:39</td>\n",
       "      <td>Fri, 09/14/2018 - 11:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>View Full SizeReport this Image</td>\n",
       "      <td>Shrub bent over - Brunswick Forest</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Hurricanes</td>\n",
       "      <td>Fri, 09/14/2018 - 09:38</td>\n",
       "      <td>Fri, 09/14/2018 - 11:08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Disaster Reports  \\\n",
       "0    View Full SizeReport this Image   \n",
       "1    View Full SizeReport this Image   \n",
       "2    View Full SizeReport this Image   \n",
       "3    View Full SizeReport this Image   \n",
       "4    View Full SizeReport this Image   \n",
       "5    View Full SizeReport this Image   \n",
       "6    View Full SizeReport this Image   \n",
       "7    View Full SizeReport this Image   \n",
       "8    View Full SizeReport this Image   \n",
       "9    View Full SizeReport this Image   \n",
       "10   View Full SizeReport this Image   \n",
       "11   View Full SizeReport this Image   \n",
       "12   View Full SizeReport this Image   \n",
       "13   View Full SizeReport this Image   \n",
       "14   View Full SizeReport this Image   \n",
       "15   View Full SizeReport this Image   \n",
       "16   View Full SizeReport this Image   \n",
       "17   View Full SizeReport this Image   \n",
       "18   View Full SizeReport this Image   \n",
       "19   View Full SizeReport this Image   \n",
       "20   View Full SizeReport this Image   \n",
       "21   View Full SizeReport this Image   \n",
       "22   View Full SizeReport this Image   \n",
       "23   View Full SizeReport this Image   \n",
       "24   View Full SizeReport this Image   \n",
       "25   View Full SizeReport this Image   \n",
       "26   View Full SizeReport this Image   \n",
       "27   View Full SizeReport this Image   \n",
       "28   View Full SizeReport this Image   \n",
       "29   View Full SizeReport this Image   \n",
       "..                               ...   \n",
       "270  View Full SizeReport this Image   \n",
       "271  View Full SizeReport this Image   \n",
       "272  View Full SizeReport this Image   \n",
       "273  View Full SizeReport this Image   \n",
       "274  View Full SizeReport this Image   \n",
       "275  View Full SizeReport this Image   \n",
       "276  View Full SizeReport this Image   \n",
       "277  View Full SizeReport this Image   \n",
       "278  View Full SizeReport this Image   \n",
       "279  View Full SizeReport this Image   \n",
       "280  View Full SizeReport this Image   \n",
       "281  View Full SizeReport this Image   \n",
       "282  View Full SizeReport this Image   \n",
       "283  View Full SizeReport this Image   \n",
       "284  View Full SizeReport this Image   \n",
       "285  View Full SizeReport this Image   \n",
       "286  View Full SizeReport this Image   \n",
       "287  View Full SizeReport this Image   \n",
       "288  View Full SizeReport this Image   \n",
       "289  View Full SizeReport this Image   \n",
       "290  View Full SizeReport this Image   \n",
       "291  View Full SizeReport this Image   \n",
       "292  View Full SizeReport this Image   \n",
       "293  View Full SizeReport this Image   \n",
       "294  View Full SizeReport this Image   \n",
       "295  View Full SizeReport this Image   \n",
       "296  View Full SizeReport this Image   \n",
       "297  View Full SizeReport this Image   \n",
       "298  View Full SizeReport this Image   \n",
       "299  View Full SizeReport this Image   \n",
       "\n",
       "                                             Headlines          City State  \\\n",
       "0                                           1615 hwy 9         Longs    SC   \n",
       "1                                         Southport bc                       \n",
       "2                           Kathy Tripp's crushed barn       Newport    NC   \n",
       "3                                            Conway sc                       \n",
       "4                                              My yard                       \n",
       "5                                     CAP PHOTO HMW 8’                       \n",
       "6    Target 14, Odell ventures landing, Johnsonvill...                       \n",
       "7                                            Our house                       \n",
       "8                                            Drive way                       \n",
       "9                                              Shelter     Lumberton    NC   \n",
       "10                                            Neighbor      Havelock    NC   \n",
       "11   Flooded for hurricane Florence at rocky Point, NC   Rocky Point    NC   \n",
       "12                                        Flooded road       Wallace    NC   \n",
       "13                                             Flooded        Currie    NC   \n",
       "14                         My sisters house Mmray road                       \n",
       "15                                   Downtown New Bern                       \n",
       "16       My hometown, Lumberton, N.C. highway 41 south                       \n",
       "17                                            Flooding                       \n",
       "18                                        Wind damages                       \n",
       "19                                           Tree down                       \n",
       "20                                       Flooded roads                       \n",
       "21                           Trees down on Power lines       Wallace    NC   \n",
       "22                   Hurricane Florence in Havelock NC      Havelock    NC   \n",
       "23                              Green Hanes rd Kinston       Kinston    NC   \n",
       "24                                       Bluestone Dam        Hinton    WV   \n",
       "25                  Wilmington NC 42nd St and Park ave                       \n",
       "26                                     Fayetteville NC                       \n",
       "27                                   Bluestone Dam -WV        Hinton    WV   \n",
       "28                                      Top coming off   Saint Pauls    NC   \n",
       "29   in my neighborhood in The Holiday Pines Develo...                       \n",
       "..                                                 ...           ...   ...   \n",
       "270                                           Made it!  Jacksonville    NC   \n",
       "271                                    Jacksonville NC                       \n",
       "272                                    Jacksonville NC  Jacksonville    NC   \n",
       "273                                 Hurricane Florence  Jacksonville    NC   \n",
       "274                   I don’t think that belongs there    Wilmington    NC   \n",
       "275            Storm surge on John Court, Havelock, NC                       \n",
       "276  Tree uprooted in Northwest Leland Hoods Creek ...                       \n",
       "277            Trees down - Brunswick Forest Leland NC                       \n",
       "278                                        Broken Tree                       \n",
       "279                 Shrub bent over - Brunswick Forest                       \n",
       "280                                      Flooded roads                       \n",
       "281                          Trees down on Power lines       Wallace    NC   \n",
       "282                  Hurricane Florence in Havelock NC      Havelock    NC   \n",
       "283                             Green Hanes rd Kinston       Kinston    NC   \n",
       "284                                      Bluestone Dam        Hinton    WV   \n",
       "285                 Wilmington NC 42nd St and Park ave                       \n",
       "286                                    Fayetteville NC                       \n",
       "287                                  Bluestone Dam -WV        Hinton    WV   \n",
       "288                                     Top coming off   Saint Pauls    NC   \n",
       "289  in my neighborhood in The Holiday Pines Develo...                       \n",
       "290                                           Made it!  Jacksonville    NC   \n",
       "291                                    Jacksonville NC                       \n",
       "292                                    Jacksonville NC  Jacksonville    NC   \n",
       "293                                 Hurricane Florence  Jacksonville    NC   \n",
       "294                   I don’t think that belongs there    Wilmington    NC   \n",
       "295            Storm surge on John Court, Havelock, NC                       \n",
       "296  Tree uprooted in Northwest Leland Hoods Creek ...                       \n",
       "297            Trees down - Brunswick Forest Leland NC                       \n",
       "298                                        Broken Tree                       \n",
       "299                 Shrub bent over - Brunswick Forest                       \n",
       "\n",
       "    Disaster Type               Photo Date              Report Date  \n",
       "0          Floods  Sat, 09/22/2018 - 13:54  Mon, 09/24/2018 - 16:05  \n",
       "1      Hurricanes  Wed, 09/19/2018 - 16:19  Mon, 09/24/2018 - 14:38  \n",
       "2      Hurricanes  Sat, 09/15/2018 - 05:14  Mon, 09/24/2018 - 12:17  \n",
       "3      Hurricanes  Sat, 09/15/2018 - 10:34  Sun, 09/23/2018 - 08:40  \n",
       "4      Hurricanes  Thu, 09/20/2018 - 04:53  Sat, 09/22/2018 - 17:38  \n",
       "5      Hurricanes  Sat, 09/22/2018 - 16:32  Sat, 09/22/2018 - 16:47  \n",
       "6          Floods  Sat, 09/22/2018 - 15:43  Sat, 09/22/2018 - 15:44  \n",
       "7          Floods  Mon, 09/17/2018 - 05:47  Sat, 09/22/2018 - 15:41  \n",
       "8          Floods  Thu, 09/20/2018 - 09:00  Sat, 09/22/2018 - 15:39  \n",
       "9      Hurricanes  Sun, 09/16/2018 - 15:51  Tue, 09/18/2018 - 19:41  \n",
       "10     Hurricanes  Sat, 09/15/2018 - 11:10  Tue, 09/18/2018 - 19:06  \n",
       "11         Floods  Sun, 09/16/2018 - 07:01  Tue, 09/18/2018 - 16:24  \n",
       "12     Hurricanes  Tue, 09/18/2018 - 15:53  Tue, 09/18/2018 - 16:07  \n",
       "13         Floods  Sun, 09/16/2018 - 06:58  Tue, 09/18/2018 - 15:35  \n",
       "14         Floods  Mon, 09/17/2018 - 12:24  Tue, 09/18/2018 - 14:44  \n",
       "15     Hurricanes  Sun, 09/16/2018 - 15:20  Tue, 09/18/2018 - 14:13  \n",
       "16     Hurricanes  Mon, 09/17/2018 - 05:02  Tue, 09/18/2018 - 14:08  \n",
       "17     Hurricanes  Sat, 09/15/2018 - 09:44  Sat, 09/15/2018 - 19:50  \n",
       "18     Hurricanes  Sat, 09/15/2018 - 09:40  Sat, 09/15/2018 - 19:44  \n",
       "19     Hurricanes  Sat, 09/15/2018 - 09:42  Sat, 09/15/2018 - 19:41  \n",
       "20     Hurricanes  Sat, 09/15/2018 - 09:59  Sat, 09/15/2018 - 19:37  \n",
       "21     Hurricanes  Sat, 09/15/2018 - 09:01  Sat, 09/15/2018 - 19:34  \n",
       "22     Hurricanes  Fri, 09/14/2018 - 13:43  Sat, 09/15/2018 - 18:54  \n",
       "23     Hurricanes  Sat, 09/15/2018 - 10:00  Sat, 09/15/2018 - 17:36  \n",
       "24         Floods  Sat, 09/15/2018 - 15:32  Sat, 09/15/2018 - 15:58  \n",
       "25     Hurricanes  Fri, 09/14/2018 - 08:42  Sat, 09/15/2018 - 15:15  \n",
       "26     Hurricanes  Fri, 09/14/2018 - 18:06  Sat, 09/15/2018 - 15:07  \n",
       "27         Floods  Sat, 09/15/2018 - 14:19  Sat, 09/15/2018 - 14:45  \n",
       "28     Hurricanes  Sat, 09/15/2018 - 14:24  Sat, 09/15/2018 - 14:25  \n",
       "29     Hurricanes  Fri, 09/14/2018 - 09:08  Sat, 09/15/2018 - 13:35  \n",
       "..            ...                      ...                      ...  \n",
       "270    Hurricanes  Fri, 09/14/2018 - 13:43  Sat, 09/15/2018 - 11:50  \n",
       "271    Hurricanes  Fri, 09/14/2018 - 08:25  Sat, 09/15/2018 - 10:24  \n",
       "272    Hurricanes  Fri, 09/14/2018 - 07:25  Sat, 09/15/2018 - 10:23  \n",
       "273    Hurricanes  Fri, 09/14/2018 - 15:03  Sat, 09/15/2018 - 02:58  \n",
       "274    Hurricanes  Fri, 09/14/2018 - 17:22  Fri, 09/14/2018 - 22:58  \n",
       "275        Floods  Fri, 09/14/2018 - 17:45  Fri, 09/14/2018 - 18:27  \n",
       "276    Hurricanes  Fri, 09/14/2018 - 14:10  Fri, 09/14/2018 - 15:06  \n",
       "277    Hurricanes  Fri, 09/14/2018 - 09:40  Fri, 09/14/2018 - 11:11  \n",
       "278    Hurricanes  Fri, 09/14/2018 - 09:39  Fri, 09/14/2018 - 11:10  \n",
       "279    Hurricanes  Fri, 09/14/2018 - 09:38  Fri, 09/14/2018 - 11:08  \n",
       "280    Hurricanes  Sat, 09/15/2018 - 09:59  Sat, 09/15/2018 - 19:37  \n",
       "281    Hurricanes  Sat, 09/15/2018 - 09:01  Sat, 09/15/2018 - 19:34  \n",
       "282    Hurricanes  Fri, 09/14/2018 - 13:43  Sat, 09/15/2018 - 18:54  \n",
       "283    Hurricanes  Sat, 09/15/2018 - 10:00  Sat, 09/15/2018 - 17:36  \n",
       "284        Floods  Sat, 09/15/2018 - 15:32  Sat, 09/15/2018 - 15:58  \n",
       "285    Hurricanes  Fri, 09/14/2018 - 08:42  Sat, 09/15/2018 - 15:15  \n",
       "286    Hurricanes  Fri, 09/14/2018 - 18:06  Sat, 09/15/2018 - 15:07  \n",
       "287        Floods  Sat, 09/15/2018 - 14:19  Sat, 09/15/2018 - 14:45  \n",
       "288    Hurricanes  Sat, 09/15/2018 - 14:24  Sat, 09/15/2018 - 14:25  \n",
       "289    Hurricanes  Fri, 09/14/2018 - 09:08  Sat, 09/15/2018 - 13:35  \n",
       "290    Hurricanes  Fri, 09/14/2018 - 13:43  Sat, 09/15/2018 - 11:50  \n",
       "291    Hurricanes  Fri, 09/14/2018 - 08:25  Sat, 09/15/2018 - 10:24  \n",
       "292    Hurricanes  Fri, 09/14/2018 - 07:25  Sat, 09/15/2018 - 10:23  \n",
       "293    Hurricanes  Fri, 09/14/2018 - 15:03  Sat, 09/15/2018 - 02:58  \n",
       "294    Hurricanes  Fri, 09/14/2018 - 17:22  Fri, 09/14/2018 - 22:58  \n",
       "295        Floods  Fri, 09/14/2018 - 17:45  Fri, 09/14/2018 - 18:27  \n",
       "296    Hurricanes  Fri, 09/14/2018 - 14:10  Fri, 09/14/2018 - 15:06  \n",
       "297    Hurricanes  Fri, 09/14/2018 - 09:40  Fri, 09/14/2018 - 11:11  \n",
       "298    Hurricanes  Fri, 09/14/2018 - 09:39  Fri, 09/14/2018 - 11:10  \n",
       "299    Hurricanes  Fri, 09/14/2018 - 09:38  Fri, 09/14/2018 - 11:08  \n",
       "\n",
       "[300 rows x 7 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(all_data, columns = header)\n",
    "df.head(300)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('fema.csv', encoding = 'UTF8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1020, 7)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}