data/processs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import geocoder\n",
    "import re\n",
    "import os\n",
    "import time\n",
    "\n",
    "\n",
    "from tqdm import tnrange, tqdm_notebook, tqdm_pandas\n",
    "from tqdm import tqdm\n",
    "tqdm.pandas(desc=\"p\")\n",
    "\n",
    "import pickle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# this complains it's deprecated, but actually is the only thing that's worked and not outputted tons of lines for df.progress_apply \n",
    "# I think? I think this was the command that caused it, I deleted it because of the warning initially and didn't realize it hard worked\n",
    "# todo add version numbers to python packages in dockerifle\n",
    "tqdm_pandas(tqdm())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "providers = ['google', 'bing', 'mapbox']\n",
    "providers[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "provider_index = 0\n",
    "# not used currently\n",
    "def get_from_provider(x):\n",
    "    current = providers[provider_index]\n",
    "    if current is 'google':\n",
    "        return geocoder.google(x, key=os.environ['GOOGLE_API_KEY'])\n",
    "    if current is 'bing':\n",
    "        return geocoder.bing(x, key=os.environ['BING_API_KEY'])\n",
    "    if current is 'mapbox':\n",
    "        return geocoder.mapbox(x, key=os.environ['MAPBOX_ACCESS_TOKEN'])    \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# cache place queries  latlng \n",
    "# don't execute this unless you want to reset the cache, or the first time XXX\n",
    "geo_cache = {\"cache_hit_count\":0, \"cache_miss_count\":0}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 506,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "\n",
    "# take a string, get a latlng, with this simple cache\n",
    "def get_lat_lng(x):\n",
    "    debug = False\n",
    "    # debug = True\n",
    "    if debug: print('\\n'+x)\n",
    "    # do we have it and is it not from an over limit sitch\n",
    "    if x in geo_cache and geo_cache[x] != ['', ''] :\n",
    "        geo_cache[\"cache_hit_count\"]+=1\n",
    "        res = geo_cache[x]\n",
    "        return res\n",
    "    g = geocoder.google(x) # g= get_from_provider(x) \n",
    "    geo_cache[\"cache_miss_count\"]+=1    \n",
    "    if g.latlng:\n",
    "        geo_cache[x] = g.latlng\n",
    "        res = g.latlng\n",
    "    else:\n",
    "        if g.json['status'] == \"ZERO_RESULTS\": # if g.json['status_code'] is 200:\n",
    "            res = [pd.np.nan, pd.np.nan]\n",
    "            # cache this too!\n",
    "            geo_cache[x] = res\n",
    "        else:\n",
    "            # 'OVER_QUERY_LIMIT'\n",
    "            print('Problem!!!')\n",
    "            print(g.json)\n",
    "            if g.json['status'] == OVER_QUERY_LIMIT:\n",
    "                raise Exception('Over the query limit')\n",
    "            res = ['', '']\n",
    "            # let's stick with google for now, otherwise do\n",
    "            # provider_index+=1\n",
    "    if debug: print(res)\n",
    "    # this is silly but...\n",
    "    time.sleep(0.15)\n",
    "    return res"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[40.6781784, -73.9441579]"
      ]
     },
     "execution_count": 277,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# woof non-google ones are pretty far  off?\n",
    "# print(get_lat_lng('Brownstone Bagel, Brooklyn, NY'))\n",
    "# provider_index+=1\n",
    "# geo_cache = {}\n",
    "# print(get_lat_lng('Brownstone Bagel, Brooklyn, NY'))\n",
    "# provider_index+=1\n",
    "# geo_cache = {}\n",
    "# print(get_lat_lng('Brownstone Bagel, Brooklyn, NY'))\n",
    "# get_lat_lng('Brownstone Bagel, Brooklyn, NY')\n",
    "\n",
    "get_lat_lng('Brooklyn, NY')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 507,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# uses above, broadening search if it can't find a business or address\n",
    "def get_loc_for_row(row, key): \n",
    "    debug = False\n",
    "    place = row[key]\n",
    "    # place = row.employer\n",
    "    # try it with no processing first\n",
    "    if debug: print('Checking\\n'+place)\n",
    "    loc = get_lat_lng(place)\n",
    "    if loc[0] is not pd.np.NaN:\n",
    "        return loc\n",
    "    # then try it dropping a possible business name, or whatever is before the first comma\n",
    "    if place.find(',') is not -1:\n",
    "        no_b_name = ','.join(place.split(',')[1:]).strip()\n",
    "        if debug: print(no_b_name)\n",
    "        loc = get_lat_lng(no_b_name)\n",
    "        if loc[0] is not pd.np.NaN:\n",
    "            return loc        \n",
    "    m = re.search(\"\\d\", place)\n",
    "    # todo, could do same as above, with another drop. TODO make sure this is all working first XXX\n",
    "    # now drop everything before the first digit and try that\n",
    "    if m:\n",
    "        after_digit = place[m.start():]\n",
    "        if debug: print(after_digit)\n",
    "        loc = get_lat_lng(after_digit)\n",
    "        if loc[0] is not pd.np.NaN:\n",
    "            return loc  \n",
    "    # this should be NaN, NaN if we failed to find something, from the first one at least\n",
    "    return loc "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 464,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Checking\n",
      "Terry\"s Construction, Blackwell, OK 74631\n",
      "Blackwell, OK 74631\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[36.8044767, -97.2828207]"
      ]
     },
     "execution_count": 464,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# works\n",
    "# get_loc_for_row({'k':'Terry\"s Construction, Blackwell, OK 74631'}, 'k')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### OSHA Data Part 1: XML of recent fatalities and catastrophe\n",
    "The recent stuff is in xml, the older stuff is csv, don't worry, they don't have the same fields either"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 278,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# https://stackoverflow.com/a/10077069/83859\n",
    "from xml.etree import ElementTree\n",
    "from collections import defaultdict\n",
    "\n",
    "def etree_to_dict(t):\n",
    "    d = {t.tag: {} if t.attrib else None}\n",
    "    children = list(t)\n",
    "    if children:\n",
    "        dd = defaultdict(list)\n",
    "        for dc in map(etree_to_dict, children):\n",
    "            for k, v in dc.items():\n",
    "                dd[k].append(v)\n",
    "        d = {t.tag: {k:v[0] if len(v) == 1 else v for k, v in dd.items()}}\n",
    "    if t.attrib:\n",
    "        d[t.tag].update(('@' + k, v) for k, v in t.attrib.items())\n",
    "    if t.text:\n",
    "        text = t.text.strip()\n",
    "        if children or t.attrib:\n",
    "            if text:\n",
    "              d[t.tag]['#text'] = text\n",
    "        else:\n",
    "            d[t.tag] = text\n",
    "    return d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 279,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "response = requests.get('https://www.osha.gov/dep/fatcat/fatcats.xml')\n",
    "# print(response)\n",
    "\n",
    "tree = ElementTree.fromstring(response.content)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pd.set_option('max_colwidth', 800)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "# this has 2016 and 2017, in xml\n",
    "osha_current = pd.DataFrame.from_records( etree_to_dict(tree)['events']['incident'] )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# osha_current.drop(['fatcat', 'inspection', 'victim'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>description</th>\n",
       "      <th>employer</th>\n",
       "      <th>fatcat</th>\n",
       "      <th>inspection</th>\n",
       "      <th>victim</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>2016-06-27</td>\n",
       "      <td>Worker died from hantavirus after being exposed to mouse droppings while cleaning cabins.</td>\n",
       "      <td>Marzano Mountain Retreat, Torreon, NM 87061</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1154167</td>\n",
       "      <td>Shawnee Romero</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>2016-05-24</td>\n",
       "      <td>Worker struck and killed by falling tree.</td>\n",
       "      <td>Raymond Trent dba Raymond Trent, Morganfield, KY 42437</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1186003.015</td>\n",
       "      <td>James Finwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>571</th>\n",
       "      <td>None</td>\n",
       "      <td>Worker died after being struck by forklift.</td>\n",
       "      <td>Genuine Parts Company, 30-03 Review Ave LONG ISLAND CITY  NY 11101</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1209887</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572</th>\n",
       "      <td>None</td>\n",
       "      <td>Worker fatally crushed between tow truck and another vehicle.</td>\n",
       "      <td>Berkebile Auto Service 10 D Street JOHNSTOWN  PA 15906</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1197414</td>\n",
       "      <td>James Harr</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  \\\n",
       "569  2016-06-27   \n",
       "570  2016-05-24   \n",
       "571        None   \n",
       "572        None   \n",
       "\n",
       "                                                                                   description  \\\n",
       "569  Worker died from hantavirus after being exposed to mouse droppings while cleaning cabins.   \n",
       "570                                                  Worker struck and killed by falling tree.   \n",
       "571                                                Worker died after being struck by forklift.   \n",
       "572                              Worker fatally crushed between tow truck and another vehicle.   \n",
       "\n",
       "                                                               employer  \\\n",
       "569                         Marzano Mountain Retreat, Torreon, NM 87061   \n",
       "570              Raymond Trent dba Raymond Trent, Morganfield, KY 42437   \n",
       "571  Genuine Parts Company, 30-03 Review Ave LONG ISLAND CITY  NY 11101   \n",
       "572              Berkebile Auto Service 10 D Street JOHNSTOWN  PA 15906   \n",
       "\n",
       "       fatcat   inspection          victim  \n",
       "569  Fatality      1154167  Shawnee Romero  \n",
       "570  Fatality  1186003.015   James Finwick  \n",
       "571  Fatality      1209887            None  \n",
       "572  Fatality      1197414      James Harr  "
      ]
     },
     "execution_count": 282,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "osha_current[-4:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "    # this is the one from the ny map, needs to be broader now\n",
    "    # just try it straight?\n",
    "    # actually XXX for deathmap, should use the [1:] method!\n",
    "#     return get_lat_lng(row.employer.split(',')[-1].strip())\n",
    "#     \"MHP Real Estate Services, 180 Maiden Lane NEW YO\".split(',')[-1].strip()\n",
    "# osha_current[lat]\n",
    "\n",
    "# get_osha_current_loc(\"Genuine Parts Company 30-03 Review Ave LONG ISLAND CITY NY 11101\")\n",
    "# tqdm_notebook().pandas()\n",
    "osha_current_loc = osha_current.progress_apply (lambda row: get_loc_for_row(row, 'employer'),axis=1)\n",
    "#.apply(pd.Series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 294,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "osha_current_loc = osha_current_loc.apply(pd.Series) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# p bar working example blah\n",
    "# for i in tnrange(10, desc='1st loop'):\n",
    "#     for j in tqdm_notebook(range(100), desc='2nd loop'):\n",
    "#         time.sleep(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# tqdm_notebook().pandas(*args, **kwargs)\n",
    "# https://stackoverflow.com/questions/40476680/how-to-use-tqdm-with-pandas-in-a-jupyter-notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>description</th>\n",
       "      <th>employer</th>\n",
       "      <th>fatcat</th>\n",
       "      <th>inspection</th>\n",
       "      <th>victim</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>A worker died after being caught between two vehicles.</td>\n",
       "      <td>PROWLER RECOVERY, INC., 8100 W. Broward Blvd. PLANTATION  FL 33324</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1229035.015</td>\n",
       "      <td>Francisco Canjura</td>\n",
       "      <td>26.122348</td>\n",
       "      <td>-80.258951</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date                                             description  \\\n",
       "0  2017-04-28  A worker died after being caught between two vehicles.   \n",
       "\n",
       "                                                             employer  \\\n",
       "0  PROWLER RECOVERY, INC., 8100 W. Broward Blvd. PLANTATION  FL 33324   \n",
       "\n",
       "     fatcat   inspection             victim        lat        lng  \n",
       "0  Fatality  1229035.015  Francisco Canjura  26.122348 -80.258951  "
      ]
     },
     "execution_count": 295,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# osha_current_loc[osha_current_loc.duplicated(keep=False)]\n",
    "osha_current['lat'] = osha_current_loc[0]\n",
    "osha_current['lng'] = osha_current_loc[1]\n",
    "osha_current[:1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 573 entries, 0 to 572\n",
      "Data columns (total 8 columns):\n",
      "date           571 non-null object\n",
      "description    573 non-null object\n",
      "employer       573 non-null object\n",
      "fatcat         573 non-null object\n",
      "inspection     551 non-null object\n",
      "victim         537 non-null object\n",
      "lat            561 non-null float64\n",
      "lng            561 non-null float64\n",
      "dtypes: float64(2), object(6)\n",
      "memory usage: 35.9+ KB\n"
     ]
    }
   ],
   "source": [
    "osha_current.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# there's really no reason to use a date-index, and we'll lose some \"fy 06\" stuff from the archives\n",
    "# osha_current['date']= pd.to_datetime(osha_current['date'])\n",
    "# osha_current = osha_current.set_index((osha_current.select_dtypes(include=[np.datetime64]).columns).tolist())\n",
    "# osha_current.sort_index(inplace=True)\n",
    "osha_current[:3]\n",
    "# ok next combine that with the other osha stuff"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# osha_current[-3:]\n",
    "osha_current.to_csv('osha_current.csv')\n",
    "# todo, standardize before dropping stuff"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "osha_current.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### OSHA Part 2, Archive CSVs 2015 and Before"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "osha_archive_urls = [\n",
    "\"https://www.osha.gov/dep/fatcat/FatalitiesFY09.csv\",\n",
    "\"https://www.osha.gov/dep/fatcat/FatalitiesFY10.csv\",\n",
    "\"https://www.osha.gov/dep/fatcat/FatalitiesFY11.csv\",\n",
    "\"https://www.osha.gov/dep/fatcat/fy13_federal-state_summaries.csv\",\n",
    "\"https://www.osha.gov/dep/fatcat/fy14_federal-state_summaries.csv\",\n",
    "\"https://www.osha.gov/dep/fatcat/fy15_federal-state_summaries.csv\"]\n",
    "\n",
    "# \"https://www.osha.gov/dep/fatcat/FatalitiesFY12.csv\",\n",
    "\n",
    "# TODO START HERE AGAIN, fix them on the way in, not later\n",
    "\n",
    "osha_archive = pd.DataFrame()\n",
    "for url in tqdm(osha_archive_urls):\n",
    "    df = pd.DataFrame.from_csv(url)\n",
    "    print('\\nurl',url)\n",
    "    print(df.info())\n",
    "    osha_archive = pd.concat([osha_archive, df])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 474,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "osha_archive.dropna(axis=1, how='all', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 486,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# do 2012 by itself because it's broken a bit\n",
    "twelve = pd.DataFrame.from_csv(\"https://www.osha.gov/dep/fatcat/FatalitiesFY12.csv\")\n",
    "twelve.columns = ['Summary Report Date', 'Date of Incident', 'Company', 'Preliminary Description of Incident']\n",
    "# twelve[\"Unnamed: 4\"].name = \"Preliminary Description of Incident\"\n",
    "# twelve\n",
    "osha_archive = pd.concat([osha_archive, twelve])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 487,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Company, City, State, ZIP</th>\n",
       "      <th>Date of Incident</th>\n",
       "      <th>Fatality or Catastrophe</th>\n",
       "      <th>Inspection #</th>\n",
       "      <th>Preliminary Description of Incident</th>\n",
       "      <th>Summary Report Date</th>\n",
       "      <th>Victim(s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>L.B. Thompson Inc., Tampa, FL 33610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/23/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was inside a building bundling material and became ill, possible heat stroke.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Presiliana Zamora, Conroe, TX 77304</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/30/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was on a scaffold doing repairs on an archway and the scaffold collapsed.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Cesar Tapia, Miami, FL 33166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/6/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was conducting roofing work, and fell through a hole in the roof, 25 feet to the concrete floor below.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Knobel Refrigeration, Inc., North Platte, NE 69103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/9/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was climbing a ladder while servicing an air-conditioning unit and fell from the ladder.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Greensburg, PA 15601</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/11/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employees were throwing away old files. They had a dumpster on the forks in the raised position. In bringing the dumpster down on the forks, the load became unstable. Victim stood on the rear of the forklift to act as a counterbalance. The dumpster fell off the trucs, causing forktruck to lunge forward and the victim to strike his head on the overhead guard, falling to the ground.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Lighthouse Electric, Boulder, CO 80301</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/11/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality at a bookstore under construction.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Priority Energy Services, LLC, Raleigh, MS 39153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/15/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was pressure testing a new metering station at a new pipeline construction project, when an explosion occurred.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>KM Davis Contracting Co., Inc., Marietta, GA 30008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/16/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was standing on the side of the road and was struck by a car.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Jenkins Electric, Post, TX 79356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was working on a pole replacing a transformer, 14,400KV, and was electrocuted.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Lariat Communications, De Kalb, TX 75559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was installing coax cable hangers down the face of an existing tower and fell 60 to 100 feet.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Larry Walty Roofing and Guttering, Inc,, Wichita, KS 67208</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was on a roof preparing an estimate. He started to come down from the roof and the ladder became dislodged. Victim fell 12 feet to the concrete driveway.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Newohmer Brothers Feed Lot, Elgin, NE 68636</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was herding cattle for the feedlot from a horse. The horse stumbled and fell. Victim subsequently fell.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Art Iron Works, Inc., Onconta, AL 35121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/20/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was in the process of assembling a transition box, while removing the brace the box collapsed, crushing him.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Fort Smith Garage Doors, Kibler, AR 72921</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/21/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was installing an overhead garage door. He was using a truck-mounted generator/welder to generate power for his tools. He was found unresponsive in the bed of the truck. Victim was electrocuted.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>SES Welding, LLC, Holly Bill, FL 32117</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/21/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was working under a disabled truck, disconnecting the drive shaft. The vehicle fell, crushing him.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Allens Inc,, Siloam Springs, AR 72761</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was repairing a tote at the end of the line. The top tote fell over, crushing the victim.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Howie's Tree Services, Merrick, NY 11566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was working from the raised bucket of an aerial device. The boom and bucket fell to the ground.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Martin Product Sales, LLC, Beaumont, TX 77705</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/23/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was on top of a railcar carrying elemental sulfur and was found unresponsive.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Green Contractors of NY, Merrick NY 11566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was working from a raised forklift and fell to the ground.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Alvin Wynn Electric Company, Alapaha, GA�31622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5/15/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was replacing a breaker in a main panel at a saw mill and an arc blast occurred.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Lakeridge Winery, Clermont, FL�34711</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/1/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was putting away a piece of lawn equipment and was stung twice by insects.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Mandy Electric, Inc., Tampa, FL�33610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/10/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was found on the ground with hot work gloves lying next to him, apparently electrocuted.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Arthur Vincent &amp; Sons Construction Inc, Armonk, NY�10504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/17/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker fell from a roof.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>W.W. Transport, Inc., Harriman, TN� 37748</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/20/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was in the process of loosening straps on a load of pipe located on a flatbed trailer.� The load shifted, causing the pipe to fall and strike the worker.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Antonio Renteria Framing, Austin, TX� 78738</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was 12-feet high removing a roof truss and fell, striking his head on the front door concrete patio below.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>International Marble &amp; Granite Supply, Inc., Chicago, IL� 60622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was working with an overhead crane and a bundle of 7-8 slabs of granite.� The slabs tipped over on the worker.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>T.T.C.S., LLC, Sabine Pass, TX� 77655</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/23/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was on the roof of a modular home being placed on pilings.� Lightning struck the roof, electrocuting the worker.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Timberwolf Tree Service, Inc., East Windsor, NJ� 08520</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/23/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was crushed in a chip grinder.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Charles McCarten &amp; Son, Inc., Gibbstown, NJ� 08027</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was caught between the bucket of a backhoe and a wooden deck attached to a building.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2009</th>\n",
       "      <td>Wenday South dba Wendy's, Dayton, OH� 45459</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/25/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was working in the kitchen near the back sink.� She slipped and fell in a wet spot, striking her head on the floor.</td>\n",
       "      <td>7/31/2009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Archer Underbalanced Services, Boys Ranch, TX 79010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/23/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>KAYCO Erectors Inc, Sugar Hill, GA 30518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee died after falling through floor hole while installing metal decking.</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>SITI, Rayne, LA 70578</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Jet Import Inc, Chicago, IL 60608</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/25/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Advanced Recycling Center, Brewton, AL 36426</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Viking Drilling, Rankin, TX 79778</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/27/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Williams Warehouse Inc, Plains, GA 31780</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee died after falling from a roof through a skylight while removing metal panels.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Terrapin Construction Bowie, MD 20715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/19/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was trimming a tree limb from an extended tree belonging to a neighbor and fell off ladder. Worker was hospitalized but succumbed to injuries and died on 8/13/2012.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>New Jersey Transit Heavy Rail Kearny, NJ 07032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker performing maintanence underneath railroad equipment when hydraulic line disconnected and equipment lowered crushing worker.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Desert Rose Golf Course Las Vegas, NV 89142</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/11/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was operating a front end loader to spread dirt in the wash and was unexpectedly swept away by a wall of water flowing at approximately 65-70 MPH. Worker's body was found on 9/14/2012.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Mr Asphalt Inc., Corvallis, MT 59828</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/13/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died after falling approximately 13 ft while checking the level of an asphalt oil tank.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Bonneville Power Administration, Saint Regis, MT 59866</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/20/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died after falling approximately 80 feet while replacing insulators.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Ryan's Tree Service, Chaumont, NY 13622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/20/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died after being crushed by a chipper.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>G.R. Birdwell Construction LP, Channelview, TX 77530</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/21/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was killed after being pinned between the dirt compactor he was operating and a wall.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>United Drilling Inc, Fort Stockton, TX 79735</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/21/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was killed after being struck in the head by a cable that snapped during drilling operations.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Mark F. Taggert Company, Columbus, OH 43229</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died from fall from a ladder.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Olmar Salazar, Airmont, NY 10901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee died after being struck by a tree branch while working on a landscaping site.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Prime Flight Aviation Services San Francisco, CA 94128</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker drove service truck off road crashing into parked lear jet.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Archer Underbalanced Services, Boys Ranch, TX 79010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/23/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Indiana Women's Prison Indianapolis, IN 46214</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was issued a firearm, went outside, and committed suicide.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>KAYCO Erectors Inc, Sugar Hill, GA 30518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee died after falling through floor hole while installing metal decking.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>PennAKem, LLC Memphis, TN 38108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Two workers transferring Furfurlyamine and Methanol from a storage tank to a reactor when an explosion occurred. Both suffered second degree burns and were hospitalized. One of these workers who suffered burns over 92% of body died on 9/27/2012.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>SITI, Rayne, LA 70578</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Traffic Specialists, Inc. Calhoun, TN 37309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was installing reflectors when struck by a tractor trailer.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Jet Import Inc, Chicago, IL 60608</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/25/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Advanced Recycling Center, Brewton, AL 36426</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Recovery Home Improvement, Inc. Baltimore, MD 21222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was electrocuted when a 27-foot ladder hoist the worker was moving fell backwards and struck two 7.62 kV overheard distribution lines.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Russell Toll dba Toll Roofing and Repair Maysville, KY 41018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker installing a tarp on a roof of a hotel stepped on the eave which collapsed resulting in worker falling approximately 26 feet on to parking lot.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Steven Barkoff Hillsborough, CA 94010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker fell from attic to garage floor striking a flower base, hitting the right artery by armpit resulting in loss of blood. Worker was hospitalized but died in ER.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>Viking Drilling, Rankin, TX 79778</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/27/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.</td>\n",
       "      <td>9/29/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7385 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                 Company  \\\n",
       "FY 2009                              L.B. Thompson Inc., Tampa, FL 33610   \n",
       "FY 2009                              Presiliana Zamora, Conroe, TX 77304   \n",
       "FY 2009                                     Cesar Tapia, Miami, FL 33166   \n",
       "FY 2009               Knobel Refrigeration, Inc., North Platte, NE 69103   \n",
       "FY 2009                                             Greensburg, PA 15601   \n",
       "FY 2009                           Lighthouse Electric, Boulder, CO 80301   \n",
       "FY 2009                 Priority Energy Services, LLC, Raleigh, MS 39153   \n",
       "FY 2009               KM Davis Contracting Co., Inc., Marietta, GA 30008   \n",
       "FY 2009                                 Jenkins Electric, Post, TX 79356   \n",
       "FY 2009                         Lariat Communications, De Kalb, TX 75559   \n",
       "FY 2009       Larry Walty Roofing and Guttering, Inc,, Wichita, KS 67208   \n",
       "FY 2009                      Newohmer Brothers Feed Lot, Elgin, NE 68636   \n",
       "FY 2009                          Art Iron Works, Inc., Onconta, AL 35121   \n",
       "FY 2009                        Fort Smith Garage Doors, Kibler, AR 72921   \n",
       "FY 2009                           SES Welding, LLC, Holly Bill, FL 32117   \n",
       "FY 2009                            Allens Inc,, Siloam Springs, AR 72761   \n",
       "FY 2009                         Howie's Tree Services, Merrick, NY 11566   \n",
       "FY 2009                    Martin Product Sales, LLC, Beaumont, TX 77705   \n",
       "FY 2009                        Green Contractors of NY, Merrick NY 11566   \n",
       "FY 2009                   Alvin Wynn Electric Company, Alapaha, GA�31622   \n",
       "FY 2009                             Lakeridge Winery, Clermont, FL�34711   \n",
       "FY 2009                            Mandy Electric, Inc., Tampa, FL�33610   \n",
       "FY 2009         Arthur Vincent & Sons Construction Inc, Armonk, NY�10504   \n",
       "FY 2009                        W.W. Transport, Inc., Harriman, TN� 37748   \n",
       "FY 2009                      Antonio Renteria Framing, Austin, TX� 78738   \n",
       "FY 2009  International Marble & Granite Supply, Inc., Chicago, IL� 60622   \n",
       "FY 2009                            T.T.C.S., LLC, Sabine Pass, TX� 77655   \n",
       "FY 2009           Timberwolf Tree Service, Inc., East Windsor, NJ� 08520   \n",
       "FY 2009               Charles McCarten & Son, Inc., Gibbstown, NJ� 08027   \n",
       "FY 2009                      Wenday South dba Wendy's, Dayton, OH� 45459   \n",
       "...                                                                  ...   \n",
       "FY 2012              Archer Underbalanced Services, Boys Ranch, TX 79010   \n",
       "FY 2012                         KAYCO Erectors Inc, Sugar Hill, GA 30518   \n",
       "FY 2012                                            SITI, Rayne, LA 70578   \n",
       "FY 2012                                Jet Import Inc, Chicago, IL 60608   \n",
       "FY 2012                     Advanced Recycling Center, Brewton, AL 36426   \n",
       "FY 2012                                Viking Drilling, Rankin, TX 79778   \n",
       "FY 2012                         Williams Warehouse Inc, Plains, GA 31780   \n",
       "FY 2012                            Terrapin Construction Bowie, MD 20715   \n",
       "FY 2012                   New Jersey Transit Heavy Rail Kearny, NJ 07032   \n",
       "FY 2012                      Desert Rose Golf Course Las Vegas, NV 89142   \n",
       "FY 2012                             Mr Asphalt Inc., Corvallis, MT 59828   \n",
       "FY 2012           Bonneville Power Administration, Saint Regis, MT 59866   \n",
       "FY 2012                          Ryan's Tree Service, Chaumont, NY 13622   \n",
       "FY 2012             G.R. Birdwell Construction LP, Channelview, TX 77530   \n",
       "FY 2012                     United Drilling Inc, Fort Stockton, TX 79735   \n",
       "FY 2012                      Mark F. Taggert Company, Columbus, OH 43229   \n",
       "FY 2012                                 Olmar Salazar, Airmont, NY 10901   \n",
       "FY 2012           Prime Flight Aviation Services San Francisco, CA 94128   \n",
       "FY 2012              Archer Underbalanced Services, Boys Ranch, TX 79010   \n",
       "FY 2012                    Indiana Women's Prison Indianapolis, IN 46214   \n",
       "FY 2012                         KAYCO Erectors Inc, Sugar Hill, GA 30518   \n",
       "FY 2012                                  PennAKem, LLC Memphis, TN 38108   \n",
       "FY 2012                                            SITI, Rayne, LA 70578   \n",
       "FY 2012                      Traffic Specialists, Inc. Calhoun, TN 37309   \n",
       "FY 2012                                Jet Import Inc, Chicago, IL 60608   \n",
       "FY 2012                     Advanced Recycling Center, Brewton, AL 36426   \n",
       "FY 2012              Recovery Home Improvement, Inc. Baltimore, MD 21222   \n",
       "FY 2012     Russell Toll dba Toll Roofing and Repair Maysville, KY 41018   \n",
       "FY 2012                            Steven Barkoff Hillsborough, CA 94010   \n",
       "FY 2012                                Viking Drilling, Rankin, TX 79778   \n",
       "\n",
       "        Company, City, State, ZIP Date of Incident Fatality or Catastrophe  \\\n",
       "FY 2009                       NaN        6/23/2009                     NaN   \n",
       "FY 2009                       NaN        6/30/2009                     NaN   \n",
       "FY 2009                       NaN         7/6/2009                     NaN   \n",
       "FY 2009                       NaN         7/9/2009                     NaN   \n",
       "FY 2009                       NaN        7/11/2009                     NaN   \n",
       "FY 2009                       NaN        7/11/2009                     NaN   \n",
       "FY 2009                       NaN        7/15/2009                     NaN   \n",
       "FY 2009                       NaN        7/16/2009                     NaN   \n",
       "FY 2009                       NaN        7/18/2009                     NaN   \n",
       "FY 2009                       NaN        7/18/2009                     NaN   \n",
       "FY 2009                       NaN        7/18/2009                     NaN   \n",
       "FY 2009                       NaN        7/18/2009                     NaN   \n",
       "FY 2009                       NaN        7/20/2009                     NaN   \n",
       "FY 2009                       NaN        7/21/2009                     NaN   \n",
       "FY 2009                       NaN        7/21/2009                     NaN   \n",
       "FY 2009                       NaN        7/22/2009                     NaN   \n",
       "FY 2009                       NaN        7/22/2009                     NaN   \n",
       "FY 2009                       NaN        7/23/2009                     NaN   \n",
       "FY 2009                       NaN        7/24/2009                     NaN   \n",
       "FY 2009                       NaN        5/15/2009                     NaN   \n",
       "FY 2009                       NaN         7/1/2009                     NaN   \n",
       "FY 2009                       NaN        7/10/2009                     NaN   \n",
       "FY 2009                       NaN        7/17/2009                     NaN   \n",
       "FY 2009                       NaN        7/20/2009                     NaN   \n",
       "FY 2009                       NaN        7/22/2009                     NaN   \n",
       "FY 2009                       NaN        7/22/2009                     NaN   \n",
       "FY 2009                       NaN        7/23/2009                     NaN   \n",
       "FY 2009                       NaN        7/23/2009                     NaN   \n",
       "FY 2009                       NaN        7/24/2009                     NaN   \n",
       "FY 2009                       NaN        7/25/2009                     NaN   \n",
       "...                           ...              ...                     ...   \n",
       "FY 2012                       NaN        9/23/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/25/2012                     NaN   \n",
       "FY 2012                       NaN        9/26/2012                     NaN   \n",
       "FY 2012                       NaN        9/27/2012                     NaN   \n",
       "FY 2012                       NaN        6/29/2012                     NaN   \n",
       "FY 2012                       NaN        7/19/2012                     NaN   \n",
       "FY 2012                       NaN        8/22/2012                     NaN   \n",
       "FY 2012                       NaN        9/11/2012                     NaN   \n",
       "FY 2012                       NaN        9/13/2012                     NaN   \n",
       "FY 2012                       NaN        9/20/2012                     NaN   \n",
       "FY 2012                       NaN        9/20/2012                     NaN   \n",
       "FY 2012                       NaN        9/21/2012                     NaN   \n",
       "FY 2012                       NaN        9/21/2012                     NaN   \n",
       "FY 2012                       NaN        9/22/2012                     NaN   \n",
       "FY 2012                       NaN        9/22/2012                     NaN   \n",
       "FY 2012                       NaN        9/22/2012                     NaN   \n",
       "FY 2012                       NaN        9/23/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/24/2012                     NaN   \n",
       "FY 2012                       NaN        9/25/2012                     NaN   \n",
       "FY 2012                       NaN        9/26/2012                     NaN   \n",
       "FY 2012                       NaN        9/26/2012                     NaN   \n",
       "FY 2012                       NaN        9/26/2012                     NaN   \n",
       "FY 2012                       NaN        9/26/2012                     NaN   \n",
       "FY 2012                       NaN        9/27/2012                     NaN   \n",
       "\n",
       "        Inspection #  \\\n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "FY 2009          NaN   \n",
       "...              ...   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "FY 2012          NaN   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                     Preliminary Description of Incident  \\\n",
       "FY 2009                                                                                                                                                                                                                                                                                                             Victim was inside a building bundling material and became ill, possible heat stroke.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                 Victim was on a scaffold doing repairs on an archway and the scaffold collapsed.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                    Victim was conducting roofing work, and fell through a hole in the roof, 25 feet to the concrete floor below.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                  Victim was climbing a ladder while servicing an air-conditioning unit and fell from the ladder.   \n",
       "FY 2009  Employees were throwing away old files. They had a dumpster on the forks in the raised position. In bringing the dumpster down on the forks, the load became unstable. Victim stood on the rear of the forklift to act as a counterbalance. The dumpster fell off the trucs, causing forktruck to lunge forward and the victim to strike his head on the overhead guard, falling to the ground.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                                                      Fatality at a bookstore under construction.   \n",
       "FY 2009                                                                                                                                                                                                                                                                           Victim was pressure testing a new metering station at a new pipeline construction project, when an explosion occurred.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                             Victim was standing on the side of the road and was struck by a car.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                            Victim was working on a pole replacing a transformer, 14,400KV, and was electrocuted.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                             Victim was installing coax cable hangers down the face of an existing tower and fell 60 to 100 feet.   \n",
       "FY 2009                                                                                                                                                                                                                                 Victim was on a roof preparing an estimate. He started to come down from the roof and the ladder became dislodged. Victim fell 12 feet to the concrete driveway.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                   Victim was herding cattle for the feedlot from a horse. The horse stumbled and fell. Victim subsequently fell.   \n",
       "FY 2009                                                                                                                                                                                                                                                                              Victim was in the process of assembling a transition box, while removing the brace the box collapsed, crushing him.   \n",
       "FY 2009                                                                                                                                                                                        Victim was installing an overhead garage door. He was using a truck-mounted generator/welder to generate power for his tools. He was found unresponsive in the bed of the truck. Victim was electrocuted.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                        Victim was working under a disabled truck, disconnecting the drive shaft. The vehicle fell, crushing him.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                 Victim was repairing a tote at the end of the line. The top tote fell over, crushing the victim.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                           Victim was working from the raised bucket of an aerial device. The boom and bucket fell to the ground.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                             Victim was on top of a railcar carrying elemental sulfur and was found unresponsive.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                                Victim was working from a raised forklift and fell to the ground.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                          Worker was replacing a breaker in a main panel at a saw mill and an arc blast occurred.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                Worker was putting away a piece of lawn equipment and was stung twice by insects.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                  Worker was found on the ground with hot work gloves lying next to him, apparently electrocuted.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                                                                         Worker fell from a roof.   \n",
       "FY 2009                                                                                                                                                                                                                                 Worker was in the process of loosening straps on a load of pipe located on a flatbed trailer.� The load shifted, causing the pipe to fall and strike the worker.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                Worker was 12-feet high removing a roof truss and fell, striking his head on the front door concrete patio below.   \n",
       "FY 2009                                                                                                                                                                                                                                                                            Worker was working with an overhead crane and a bundle of 7-8 slabs of granite.� The slabs tipped over on the worker.   \n",
       "FY 2009                                                                                                                                                                                                                                                                          Worker was on the roof of a modular home being placed on pilings.� Lightning struck the roof, electrocuting the worker.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                                                                            Worker was crushed in a chip grinder.   \n",
       "FY 2009                                                                                                                                                                                                                                                                                                      Worker was caught between the bucket of a backhoe and a wooden deck attached to a building.   \n",
       "FY 2009                                                                                                                                                                                                                                                                       Worker was working in the kitchen near the back sink.� She slipped and fell in a wet spot, striking her head on the floor.   \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                                  ...   \n",
       "FY 2012                                                                                                                                                                                                                                                                              Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                   Employee died after falling through floor hole while installing metal decking.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                         Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.   \n",
       "FY 2012                                                                                                                                                                                                                                                                          Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.   \n",
       "FY 2012                                                                                                                                                                                                                                                                               Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                          Employee died after falling from a roof through a skylight while removing metal panels.   \n",
       "FY 2012                                                                                                                                                                                                                      Worker was trimming a tree limb from an extended tree belonging to a neighbor and fell off ladder. Worker was hospitalized but succumbed to injuries and died on 8/13/2012.   \n",
       "FY 2012                                                                                                                                                                                                                                                              Worker performing maintanence underneath railroad equipment when hydraulic line disconnected and equipment lowered crushing worker.   \n",
       "FY 2012                                                                                                                                                                                                  Worker was operating a front end loader to spread dirt in the wash and was unexpectedly swept away by a wall of water flowing at approximately 65-70 MPH. Worker's body was found on 9/14/2012.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                   Worker died after falling approximately 13 ft while checking the level of an asphalt oil tank.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                      Worker died after falling approximately 80 feet while replacing insulators.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                                                    Worker died after being crushed by a chipper.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                     Worker was killed after being pinned between the dirt compactor he was operating and a wall.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                             Worker was killed after being struck in the head by a cable that snapped during drilling operations.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                                                             Worker died from fall from a ladder.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                           Employee died after being struck by a tree branch while working on a landscaping site.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                               Worker drove service truck off road crashing into parked lear jet.   \n",
       "FY 2012                                                                                                                                                                                                                                                                              Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                                Worker was issued a firearm, went outside, and committed suicide.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                   Employee died after falling through floor hole while installing metal decking.   \n",
       "FY 2012                                                                                                                                            Two workers transferring Furfurlyamine and Methanol from a storage tank to a reactor when an explosion occurred. Both suffered second degree burns and were hospitalized. One of these workers who suffered burns over 92% of body died on 9/27/2012.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                         Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                                                               Worker was installing reflectors when struck by a tractor trailer.   \n",
       "FY 2012                                                                                                                                                                                                                                                                                Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.   \n",
       "FY 2012                                                                                                                                                                                                                                                                          Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.   \n",
       "FY 2012                                                                                                                                                                                                                                                    Worker was electrocuted when a 27-foot ladder hoist the worker was moving fell backwards and struck two 7.62 kV overheard distribution lines.   \n",
       "FY 2012                                                                                                                                                                                                                                           Worker installing a tarp on a roof of a hotel stepped on the eave which collapsed resulting in worker falling approximately 26 feet on to parking lot.   \n",
       "FY 2012                                                                                                                                                                                                                            Worker fell from attic to garage floor striking a flower base, hitting the right artery by armpit resulting in loss of blood. Worker was hospitalized but died in ER.   \n",
       "FY 2012                                                                                                                                                                                                                                                                               Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.   \n",
       "\n",
       "        Summary Report Date Victim(s)  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/24/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "FY 2009           7/31/2009       NaN  \n",
       "...                     ...       ...  \n",
       "FY 2012           9/22/2012       NaN  \n",
       "FY 2012           9/22/2012       NaN  \n",
       "FY 2012           9/22/2012       NaN  \n",
       "FY 2012           9/22/2012       NaN  \n",
       "FY 2012           9/22/2012       NaN  \n",
       "FY 2012           9/22/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "FY 2012           9/29/2012       NaN  \n",
       "\n",
       "[7385 rows x 8 columns]"
      ]
     },
     "execution_count": 487,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "osha_archive"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 488,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 7385 entries, FY 2009 to FY 2012\n",
      "Data columns (total 8 columns):\n",
      "Company                                3618 non-null object\n",
      "Company, City, State, ZIP              3734 non-null object\n",
      "Date of Incident                       3618 non-null object\n",
      "Fatality or Catastrophe                3734 non-null object\n",
      "Inspection #                           862 non-null object\n",
      "Preliminary Description of Incident    7352 non-null object\n",
      "Summary Report Date                    3618 non-null object\n",
      "Victim(s)                              520 non-null object\n",
      "dtypes: object(8)\n",
      "memory usage: 519.3+ KB\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Company, City, State, ZIP</th>\n",
       "      <th>Date of Incident</th>\n",
       "      <th>Fatality or Catastrophe</th>\n",
       "      <th>Inspection #</th>\n",
       "      <th>Preliminary Description of Incident</th>\n",
       "      <th>Summary Report Date</th>\n",
       "      <th>Victim(s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2014-05-02 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True Blue Inc., Orlando, FL 32805</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker struck and killed by dump truck.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-03-20 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Midwest Farmers Cooperative, Tecumseh, NE 68450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died from exposure to anhydrous ammonia released during transfer from tanker trailer to bulk storage tank.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-11 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Fred Carries Contracts Inc., Phoenix, AZ 85006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker fatally crushed when car fell off jack stand during repairs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2010</th>\n",
       "      <td>GE Transportation, Kansas City, MO� 64153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/17/10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was working on the wheel and axle line, using an overhead bridge crane to lift a 5,100-lb locomotive wheel set.� Worker lifted the locomotive wheel set, causing it to swing in a pendulum motion, pinning his leg against another stationary locomotive wheel set.</td>\n",
       "      <td>03/27/10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-04 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dalton Sealing and Paving, Columbus, OH 43207</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1082498</td>\n",
       "      <td>Worker struck and killed by dump truck tailgate.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Verna Riffle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-06-08 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Commercial Cool-Temp Corp., Homestead, FL 33030</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1071299</td>\n",
       "      <td>Worker killed in fall while welding.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2012</th>\n",
       "      <td>V &amp; M Tube Alloy, Houston, TX 77049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2/1/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker repairing a hydrotester in a pipe manufacturing facility was killed after being struck on the head by a pipe on a conveyor belt.</td>\n",
       "      <td>2/4/2012</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-03-24 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Reliance Well Service Inc., Fairfield, TX 75840</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>1048906</td>\n",
       "      <td>Worker struck and killed by machine parts when drill line broke.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-08-02 00:00:00</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Rebel Oil Co., Inc.  Las Vegas, NV 89115</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died from exposure to ethanol vapor in tanker rail car.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FY 2010</th>\n",
       "      <td>Main Street Feeds Inc., Monett, MO 65708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/01/09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker fell from atop of a feed truck.</td>\n",
       "      <td>12/04/09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                       Company  \\\n",
       "2014-05-02 00:00:00                                        NaN   \n",
       "2014-03-20 00:00:00                                        NaN   \n",
       "2014-11-11 00:00:00                                        NaN   \n",
       "FY 2010              GE Transportation, Kansas City, MO� 64153   \n",
       "2015-08-04 00:00:00                                        NaN   \n",
       "2015-06-08 00:00:00                                        NaN   \n",
       "FY 2012                    V & M Tube Alloy, Houston, TX 77049   \n",
       "2015-03-24 00:00:00                                        NaN   \n",
       "2014-08-02 00:00:00                                        NaN   \n",
       "FY 2010               Main Street Feeds Inc., Monett, MO 65708   \n",
       "\n",
       "                                           Company, City, State, ZIP  \\\n",
       "2014-05-02 00:00:00                True Blue Inc., Orlando, FL 32805   \n",
       "2014-03-20 00:00:00  Midwest Farmers Cooperative, Tecumseh, NE 68450   \n",
       "2014-11-11 00:00:00   Fred Carries Contracts Inc., Phoenix, AZ 85006   \n",
       "FY 2010                                                          NaN   \n",
       "2015-08-04 00:00:00    Dalton Sealing and Paving, Columbus, OH 43207   \n",
       "2015-06-08 00:00:00  Commercial Cool-Temp Corp., Homestead, FL 33030   \n",
       "FY 2012                                                          NaN   \n",
       "2015-03-24 00:00:00  Reliance Well Service Inc., Fairfield, TX 75840   \n",
       "2014-08-02 00:00:00         Rebel Oil Co., Inc.  Las Vegas, NV 89115   \n",
       "FY 2010                                                          NaN   \n",
       "\n",
       "                    Date of Incident Fatality or Catastrophe Inspection #  \\\n",
       "2014-05-02 00:00:00              NaN                Fatality          NaN   \n",
       "2014-03-20 00:00:00              NaN                Fatality          NaN   \n",
       "2014-11-11 00:00:00              NaN                Fatality          NaN   \n",
       "FY 2010                     03/17/10                     NaN          NaN   \n",
       "2015-08-04 00:00:00              NaN                Fatality      1082498   \n",
       "2015-06-08 00:00:00              NaN                Fatality      1071299   \n",
       "FY 2012                     2/1/2012                     NaN          NaN   \n",
       "2015-03-24 00:00:00              NaN                Fatality      1048906   \n",
       "2014-08-02 00:00:00              NaN                Fatality          NaN   \n",
       "FY 2010                     12/01/09                     NaN          NaN   \n",
       "\n",
       "                                                                                                                                                                                                                                                            Preliminary Description of Incident  \\\n",
       "2014-05-02 00:00:00                                                                                                                                                                                                                                     Worker struck and killed by dump truck.   \n",
       "2014-03-20 00:00:00                                                                                                                                                           Worker died from exposure to anhydrous ammonia released during transfer from tanker trailer to bulk storage tank.   \n",
       "2014-11-11 00:00:00                                                                                                                                                                                                         Worker fatally crushed when car fell off jack stand during repairs.   \n",
       "FY 2010              Worker was working on the wheel and axle line, using an overhead bridge crane to lift a 5,100-lb locomotive wheel set.� Worker lifted the locomotive wheel set, causing it to swing in a pendulum motion, pinning his leg against another stationary locomotive wheel set.   \n",
       "2015-08-04 00:00:00                                                                                                                                                                                                                            Worker struck and killed by dump truck tailgate.   \n",
       "2015-06-08 00:00:00                                                                                                                                                                                                                                        Worker killed in fall while welding.   \n",
       "FY 2012                                                                                                                                                 Worker repairing a hydrotester in a pipe manufacturing facility was killed after being struck on the head by a pipe on a conveyor belt.   \n",
       "2015-03-24 00:00:00                                                                                                                                                                                                            Worker struck and killed by machine parts when drill line broke.   \n",
       "2014-08-02 00:00:00                                                                                                                                                                                                             Worker died from exposure to ethanol vapor in tanker rail car.    \n",
       "FY 2010                                                                                                                                                                                                                                                  Worker fell from atop of a feed truck.   \n",
       "\n",
       "                    Summary Report Date     Victim(s)  \n",
       "2014-05-02 00:00:00                 NaN           NaN  \n",
       "2014-03-20 00:00:00                 NaN           NaN  \n",
       "2014-11-11 00:00:00                 NaN           NaN  \n",
       "FY 2010                        03/27/10           NaN  \n",
       "2015-08-04 00:00:00                 NaN  Verna Riffle  \n",
       "2015-06-08 00:00:00                 NaN           NaN  \n",
       "FY 2012                        2/4/2012           NaN  \n",
       "2015-03-24 00:00:00                 NaN           NaN  \n",
       "2014-08-02 00:00:00                 NaN           NaN  \n",
       "FY 2010                        12/04/09           NaN  "
      ]
     },
     "execution_count": 488,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "osha_archive.info()\n",
    "osha_archive.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 490,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# if a row is totally blank, drop it\n",
    "# osha_archive.dropna(axis=1, how=\"all\" ).info() # inplace=True\n",
    "# osha_archive[:1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 491,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 7385 entries, FY 2009 to FY 2012\n",
      "Data columns (total 8 columns):\n",
      "Company                                3618 non-null object\n",
      "Company, City, State, ZIP              3734 non-null object\n",
      "Date of Incident                       3618 non-null object\n",
      "Fatality or Catastrophe                3734 non-null object\n",
      "Inspection #                           862 non-null object\n",
      "Preliminary Description of Incident    7352 non-null object\n",
      "Summary Report Date                    3618 non-null object\n",
      "Victim(s)                              520 non-null object\n",
      "dtypes: object(8)\n",
      "memory usage: 519.3+ KB\n"
     ]
    }
   ],
   "source": [
    "osha_archive.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 492,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7385 entries, 0 to 7384\n",
      "Data columns (total 9 columns):\n",
      "Company                                3618 non-null object\n",
      "Company, City, State, ZIP              3734 non-null object\n",
      "Date of Incident                       3618 non-null object\n",
      "Fatality or Catastrophe                3734 non-null object\n",
      "Inspection #                           862 non-null object\n",
      "Preliminary Description of Incident    7352 non-null object\n",
      "Summary Report Date                    3618 non-null object\n",
      "Victim(s)                              520 non-null object\n",
      "date                                   7352 non-null object\n",
      "dtypes: object(9)\n",
      "memory usage: 519.3+ KB\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Company, City, State, ZIP</th>\n",
       "      <th>Fatality or Catastrophe</th>\n",
       "      <th>Inspection #</th>\n",
       "      <th>Preliminary Description of Incident</th>\n",
       "      <th>Summary Report Date</th>\n",
       "      <th>Victim(s)</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>L.B. Thompson Inc., Tampa, FL 33610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Victim was inside a building bundling material and became ill, possible heat stroke.</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/23/2009</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               Company Company, City, State, ZIP  \\\n",
       "0  L.B. Thompson Inc., Tampa, FL 33610                       NaN   \n",
       "\n",
       "  Fatality or Catastrophe Inspection #  \\\n",
       "0                     NaN          NaN   \n",
       "\n",
       "                                                    Preliminary Description of Incident  \\\n",
       "0  Victim was inside a building bundling material and became ill, possible heat stroke.   \n",
       "\n",
       "  Summary Report Date Victim(s)       date  \n",
       "0           7/24/2009       NaN  6/23/2009  "
      ]
     },
     "execution_count": 492,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# though we have a date of incident field, it's missing often, and the index sometimes has it\n",
    "# so make a date col it's own thing, but some are 'FY 09'\n",
    "osha_archive.reset_index(level=0,  inplace=True)\n",
    "osha_archive['date'] = osha_archive['index']\n",
    "osha_archive.drop('index', axis=1, inplace=True)\n",
    "osha_archive.info()\n",
    "\n",
    "# date of incident is better than date, it takes presidence \n",
    "osha_archive['date'] = osha_archive['Date of Incident'].fillna(osha_archive['date'])\n",
    "# and then drop the other,\n",
    "osha_archive.drop('Date of Incident', axis=1, inplace=True)\n",
    "\n",
    "osha_archive[:1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# osha_archive[\"Company\"].value_counts()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# HERE HERE HERE 💥\n",
    "- [ ] Fill and drop cols\n",
    "- [ ] Run geocoder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 503,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7385 entries, 0 to 7384\n",
      "Data columns (total 7 columns):\n",
      "Fatality or Catastrophe                3734 non-null object\n",
      "Inspection #                           862 non-null object\n",
      "Preliminary Description of Incident    7352 non-null object\n",
      "Summary Report Date                    3618 non-null object\n",
      "Victim(s)                              520 non-null object\n",
      "date                                   7352 non-null object\n",
      "place                                  7352 non-null object\n",
      "dtypes: object(7)\n",
      "memory usage: 403.9+ KB\n"
     ]
    }
   ],
   "source": [
    "osha_archive['place'] = osha_archive['Company'].fillna(osha_archive['Company, City, State, ZIP'])\n",
    "osha_archive.drop(['Company', 'Company, City, State, ZIP'], inplace=True, axis=1)\n",
    "osha_archive.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 505,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# osha_archive.place.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 373,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# this may not be the description, but it does seem to have something valid if there's anything\n",
    "# osha_archive.dropna(axis=0, how=\"any\", inplace=True, subset=['Preliminary Description of Incident'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# len(osha_archive[osha_archive['Unnamed: 4'].notnull()] )\n",
    "# osha_archive[osha_archive['Unnamed: 4'].notnull()][:1]\n",
    "#[:3]\n",
    "# todo, fix this or drop these,\n",
    "# drop for now, unamed 4 is prelim descrip, and prelim descrip is address for these 100 or so\n",
    "# osha_archive.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Geocoding the Archive"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 508,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "geo_cache['cache_hit_count'] = 0\n",
    "geo_cache['cache_miss_count'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 509,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "0it [00:00, ?it/s]\u001b[A\n",
      "TqdmDeprecationWarning: Please use `tqdm.pandas(...)` instead of `tqdm_pandas(tqdm(...))`.\n",
      "\n",
      "2125it [00:00, 21247.49it/s]\u001b[A\n",
      "4996it [00:00, 23043.28it/s]\u001b[A\n",
      "6304it [00:01, 3712.29it/s] \u001b[A\n",
      "7385it [00:01, 5786.34it/s]\u001b[A"
     ]
    }
   ],
   "source": [
    "\n",
    "# for some reason doing these together (apply, and then applying pd.Series) says it's the wrong shape, may be a progress apply issue? XXX\n",
    "# ok apply it\n",
    "# wait it gets that no matter what, it must be a problem with progress apply or the way i'm doing this or the latlng func\n",
    "tqdm_pandas(tqdm())\n",
    "osha_archive_loc = osha_archive.progress_apply (lambda row: get_loc_for_row(row, 'place'), axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "sometimes running above errors and says\n",
    "```\n",
    "ReadTimeout: (ReadTimeoutError(\"HTTPSConnectionPool(host='maps.googleapis.com', port=443): Read timed out. (read timeout=5.0)\",), 'occurred at index 5088')\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "and this is the weird shape error it gets, but not if I rerun it once everything is cached\n",
    "```\n",
    "ValueError: Shape of passed values is (7352, 2), indices imply (7352, 11)\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 510,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "osha_archive_loc = osha_archive_loc.apply(pd.Series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "osha_archive_loc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 511,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9703 1\n"
     ]
    }
   ],
   "source": [
    "print(geo_cache['cache_hit_count'], geo_cache['cache_miss_count'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 512,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# osha_archive_loc.apply(pd.Series)\n",
    "osha_archive['lat']=osha_archive_loc[0]\n",
    "osha_archive['lng']=osha_archive_loc[1]\n",
    "\n",
    "# could use date as index, meh\n",
    "# osha_archive['Date of Incident']= pd.to_datetime(osha_archive['Date of Incident'])\n",
    "# osha_archive = osha_archive.set_index((osha_archive.select_dtypes(include=[np.datetime64]).columns).tolist())\n",
    "# osha_archive.sort_index(inplace=True)\n",
    "# untried, Weds XXX\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 513,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fatality or Catastrophe</th>\n",
       "      <th>Inspection #</th>\n",
       "      <th>Preliminary Description of Incident</th>\n",
       "      <th>Summary Report Date</th>\n",
       "      <th>Victim(s)</th>\n",
       "      <th>date</th>\n",
       "      <th>place</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker was operating a propane cook stove and was severely burned after the propane gas system ignited causing a fire and/or explosion.</td>\n",
       "      <td>06/05/10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>06/01/10</td>\n",
       "      <td>Francois Lessard, T3R13, ME 04462</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2992</th>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker died from head injuries after vehicle he was repairing dropped, pinning him between cab and front bumper.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-05-29 00:00:00</td>\n",
       "      <td>US Army Reserve, 88th Regional Support Command, Fort McCoy, WI 54656</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3593</th>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employee died while conducting dive operations at 130 feet.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-10 00:00:00</td>\n",
       "      <td>Stryker Electrical Contracting Inc., Doral, FL 33178 (US Army - Aberdeen Test Center)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3614</th>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pilot found dead along freeway of apparent homicide.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-10-02 00:00:00</td>\n",
       "      <td>Alaska Airlines,Golden Scott Freeway I-5,Scott Exit Road, Burbank, CA 91502</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3698</th>\n",
       "      <td>Fatality</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker performing road construction struck and killed by vehicle.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-09-19 00:00:00</td>\n",
       "      <td>J.T. Russell &amp; Sons Inc., NC 18 &amp; I-40/ Exit 105, Westbound, Morganton, NC  28655</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5573</th>\n",
       "      <td>Fatality</td>\n",
       "      <td>1060481</td>\n",
       "      <td>Worker killed in fall from top of crane cab.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arthur Hilario Jr.</td>\n",
       "      <td>2015-05-02 00:00:00</td>\n",
       "      <td>414 Chaple Street NEW HAVEN O &amp; G Industries, Inc. / Tutor Perini Corporation, a Joint Venture, New Haven, CT 06511</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7343</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Worker making repairs to a tire compactor was crushed between the compactor and a drum roller.</td>\n",
       "      <td>9/15/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/13/2012</td>\n",
       "      <td>Fisher Industries, Interstate 80 East Bound, Mile Post 392, NV 89521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Fatality or Catastrophe Inspection #  \\\n",
       "948                      NaN          NaN   \n",
       "2992                Fatality          NaN   \n",
       "3593                Fatality          NaN   \n",
       "3614                Fatality          NaN   \n",
       "3698                Fatality          NaN   \n",
       "5573                Fatality      1060481   \n",
       "7343                     NaN          NaN   \n",
       "\n",
       "                                                                                                          Preliminary Description of Incident  \\\n",
       "948   Worker was operating a propane cook stove and was severely burned after the propane gas system ignited causing a fire and/or explosion.   \n",
       "2992                         Worker died from head injuries after vehicle he was repairing dropped, pinning him between cab and front bumper.   \n",
       "3593                                                                              Employee died while conducting dive operations at 130 feet.   \n",
       "3614                                                                                     Pilot found dead along freeway of apparent homicide.   \n",
       "3698                                                                        Worker performing road construction struck and killed by vehicle.   \n",
       "5573                                                                                             Worker killed in fall from top of crane cab.   \n",
       "7343                                           Worker making repairs to a tire compactor was crushed between the compactor and a drum roller.   \n",
       "\n",
       "     Summary Report Date           Victim(s)                 date  \\\n",
       "948             06/05/10                 NaN             06/01/10   \n",
       "2992                 NaN                 NaN  2013-05-29 00:00:00   \n",
       "3593                 NaN                 NaN  2012-10-10 00:00:00   \n",
       "3614                 NaN                 NaN  2012-10-02 00:00:00   \n",
       "3698                 NaN                 NaN  2014-09-19 00:00:00   \n",
       "5573                 NaN  Arthur Hilario Jr.  2015-05-02 00:00:00   \n",
       "7343           9/15/2012                 NaN            9/13/2012   \n",
       "\n",
       "                                                                                                                    place  \\\n",
       "948                                                                                     Francois Lessard, T3R13, ME 04462   \n",
       "2992                                                 US Army Reserve, 88th Regional Support Command, Fort McCoy, WI 54656   \n",
       "3593                                Stryker Electrical Contracting Inc., Doral, FL 33178 (US Army - Aberdeen Test Center)   \n",
       "3614                                          Alaska Airlines,Golden Scott Freeway I-5,Scott Exit Road, Burbank, CA 91502   \n",
       "3698                                    J.T. Russell & Sons Inc., NC 18 & I-40/ Exit 105, Westbound, Morganton, NC  28655   \n",
       "5573  414 Chaple Street NEW HAVEN O & G Industries, Inc. / Tutor Perini Corporation, a Joint Venture, New Haven, CT 06511   \n",
       "7343                                                 Fisher Industries, Interstate 80 East Bound, Mile Post 392, NV 89521   \n",
       "\n",
       "      lat  lng  \n",
       "948   NaN  NaN  \n",
       "2992  NaN  NaN  \n",
       "3593  NaN  NaN  \n",
       "3614  NaN  NaN  \n",
       "3698  NaN  NaN  \n",
       "5573  NaN  NaN  \n",
       "7343  NaN  NaN  "
      ]
     },
     "execution_count": 513,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "osha_archive[osha_archive.lat.isnull()]\n",
    "# get_lat_lng('Terry\"s Construction, Blackwell, OK 74631')\n",
    "# osha_archive[\n",
    "# osha_archive.dropna(axis=1, how='any').info()\n",
    "# osha_archive.lat.value_counts()\n",
    "# len(osha_archive[osha_archive.place.str.contains('worker')]) \n",
    "# osha_archive.place.str.contains('worker').value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 515,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7385 entries, 0 to 7384\n",
      "Data columns (total 9 columns):\n",
      "Fatality or Catastrophe                3734 non-null object\n",
      "Inspection #                           862 non-null object\n",
      "Preliminary Description of Incident    7352 non-null object\n",
      "Summary Report Date                    3618 non-null object\n",
      "Victim(s)                              520 non-null object\n",
      "date                                   7352 non-null object\n",
      "place                                  7352 non-null object\n",
      "lat                                    7378 non-null float64\n",
      "lng                                    7378 non-null float64\n",
      "dtypes: float64(2), object(7)\n",
      "memory usage: 519.3+ KB\n"
     ]
    }
   ],
   "source": [
    "# get_lat_lng(\" Mile Post 392, NV 89521\")\n",
    "# get_lat_lng(\"Blackwell, OK 74631'\")\n",
    "osha_archive.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# osha_archive['Preliminary Description of Incident'].fillna('', inplace=True)\n",
    "# osha_archive.info()\n",
    "# same for Company, and apply it, so no error below\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# osha_archive.to_csv('osha_archive_wll.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 516,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Fatality or Catastrophe</th>\n",
       "      <th>Inspection #</th>\n",
       "      <th>Summary Report Date</th>\n",
       "      <th>Victim(s)</th>\n",
       "      <th>date</th>\n",
       "      <th>place</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/23/2009</td>\n",
       "      <td>L.B. Thompson Inc., Tampa, FL 33610</td>\n",
       "      <td>27.994928</td>\n",
       "      <td>-82.400987</td>\n",
       "      <td>Victim was inside a building bundling material and became ill, possible heat stroke.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6/30/2009</td>\n",
       "      <td>Presiliana Zamora, Conroe, TX 77304</td>\n",
       "      <td>30.331525</td>\n",
       "      <td>-95.509247</td>\n",
       "      <td>Victim was on a scaffold doing repairs on an archway and the scaffold collapsed.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/6/2009</td>\n",
       "      <td>Cesar Tapia, Miami, FL 33166</td>\n",
       "      <td>25.823504</td>\n",
       "      <td>-80.310168</td>\n",
       "      <td>Victim was conducting roofing work, and fell through a hole in the roof, 25 feet to the concrete floor below.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/9/2009</td>\n",
       "      <td>Knobel Refrigeration, Inc., North Platte, NE 69103</td>\n",
       "      <td>41.142954</td>\n",
       "      <td>-100.790990</td>\n",
       "      <td>Victim was climbing a ladder while servicing an air-conditioning unit and fell from the ladder.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/11/2009</td>\n",
       "      <td>Greensburg, PA 15601</td>\n",
       "      <td>40.301458</td>\n",
       "      <td>-79.538929</td>\n",
       "      <td>Employees were throwing away old files. They had a dumpster on the forks in the raised position. In bringing the dumpster down on the forks, the load became unstable. Victim stood on the rear of the forklift to act as a counterbalance. The dumpster fell off the trucs, causing forktruck to lunge forward and the victim to strike his head on the overhead guard, falling to the ground.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Fatality or Catastrophe Inspection # Summary Report Date Victim(s)  \\\n",
       "0                     NaN          NaN           7/24/2009       NaN   \n",
       "1                     NaN          NaN           7/24/2009       NaN   \n",
       "2                     NaN          NaN           7/24/2009       NaN   \n",
       "3                     NaN          NaN           7/24/2009       NaN   \n",
       "4                     NaN          NaN           7/24/2009       NaN   \n",
       "\n",
       "        date                                               place        lat  \\\n",
       "0  6/23/2009                 L.B. Thompson Inc., Tampa, FL 33610  27.994928   \n",
       "1  6/30/2009                 Presiliana Zamora, Conroe, TX 77304  30.331525   \n",
       "2   7/6/2009                        Cesar Tapia, Miami, FL 33166  25.823504   \n",
       "3   7/9/2009  Knobel Refrigeration, Inc., North Platte, NE 69103  41.142954   \n",
       "4  7/11/2009                                Greensburg, PA 15601  40.301458   \n",
       "\n",
       "          lng  \\\n",
       "0  -82.400987   \n",
       "1  -95.509247   \n",
       "2  -80.310168   \n",
       "3 -100.790990   \n",
       "4  -79.538929   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                       description  \n",
       "0                                                                                                                                                                                                                                                                                                             Victim was inside a building bundling material and became ill, possible heat stroke.  \n",
       "1                                                                                                                                                                                                                                                                                                                 Victim was on a scaffold doing repairs on an archway and the scaffold collapsed.  \n",
       "2                                                                                                                                                                                                                                                                                    Victim was conducting roofing work, and fell through a hole in the roof, 25 feet to the concrete floor below.  \n",
       "3                                                                                                                                                                                                                                                                                                  Victim was climbing a ladder while servicing an air-conditioning unit and fell from the ladder.  \n",
       "4  Employees were throwing away old files. They had a dumpster on the forks in the raised position. In bringing the dumpster down on the forks, the load became unstable. Victim stood on the rear of the forklift to act as a counterbalance. The dumpster fell off the trucs, causing forktruck to lunge forward and the victim to strike his head on the overhead guard, falling to the ground.  "
      ]
     },
     "execution_count": 516,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# just change name to description\n",
    "osha_archive['description'] = osha_archive['Preliminary Description of Incident']\n",
    "osha_archive.drop(['Preliminary Description of Incident'], inplace=True, axis=1)\n",
    "osha_archive[:5]    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 518,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# OK THIS IS WHERE YOU STOPPED, now drop archive first, should deal with current up there\n",
    "\n",
    "osha_archive.drop(['Fatality or Catastrophe', 'Inspection #', 'Summary Report Date', 'Victim(s)'], inplace=True, axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 519,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>place</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6/23/2009</td>\n",
       "      <td>L.B. Thompson Inc., Tampa, FL 33610</td>\n",
       "      <td>27.994928</td>\n",
       "      <td>-82.400987</td>\n",
       "      <td>Victim was inside a building bundling material and became ill, possible heat stroke.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6/30/2009</td>\n",
       "      <td>Presiliana Zamora, Conroe, TX 77304</td>\n",
       "      <td>30.331525</td>\n",
       "      <td>-95.509247</td>\n",
       "      <td>Victim was on a scaffold doing repairs on an archway and the scaffold collapsed.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7/6/2009</td>\n",
       "      <td>Cesar Tapia, Miami, FL 33166</td>\n",
       "      <td>25.823504</td>\n",
       "      <td>-80.310168</td>\n",
       "      <td>Victim was conducting roofing work, and fell through a hole in the roof, 25 feet to the concrete floor below.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7/9/2009</td>\n",
       "      <td>Knobel Refrigeration, Inc., North Platte, NE 69103</td>\n",
       "      <td>41.142954</td>\n",
       "      <td>-100.790990</td>\n",
       "      <td>Victim was climbing a ladder while servicing an air-conditioning unit and fell from the ladder.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7/11/2009</td>\n",
       "      <td>Greensburg, PA 15601</td>\n",
       "      <td>40.301458</td>\n",
       "      <td>-79.538929</td>\n",
       "      <td>Employees were throwing away old files. They had a dumpster on the forks in the raised position. In bringing the dumpster down on the forks, the load became unstable. Victim stood on the rear of the forklift to act as a counterbalance. The dumpster fell off the trucs, causing forktruck to lunge forward and the victim to strike his head on the overhead guard, falling to the ground.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7/11/2009</td>\n",
       "      <td>Lighthouse Electric, Boulder, CO 80301</td>\n",
       "      <td>40.040651</td>\n",
       "      <td>-105.207780</td>\n",
       "      <td>Fatality at a bookstore under construction.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7/15/2009</td>\n",
       "      <td>Priority Energy Services, LLC, Raleigh, MS 39153</td>\n",
       "      <td>32.033488</td>\n",
       "      <td>-89.522291</td>\n",
       "      <td>Victim was pressure testing a new metering station at a new pipeline construction project, when an explosion occurred.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7/16/2009</td>\n",
       "      <td>KM Davis Contracting Co., Inc., Marietta, GA 30008</td>\n",
       "      <td>33.882159</td>\n",
       "      <td>-84.527742</td>\n",
       "      <td>Victim was standing on the side of the road and was struck by a car.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>Jenkins Electric, Post, TX 79356</td>\n",
       "      <td>33.191044</td>\n",
       "      <td>-101.375653</td>\n",
       "      <td>Victim was working on a pole replacing a transformer, 14,400KV, and was electrocuted.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>Lariat Communications, De Kalb, TX 75559</td>\n",
       "      <td>33.508726</td>\n",
       "      <td>-94.616319</td>\n",
       "      <td>Victim was installing coax cable hangers down the face of an existing tower and fell 60 to 100 feet.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>Larry Walty Roofing and Guttering, Inc,, Wichita, KS 67208</td>\n",
       "      <td>37.683359</td>\n",
       "      <td>-97.077559</td>\n",
       "      <td>Victim was on a roof preparing an estimate. He started to come down from the roof and the ladder became dislodged. Victim fell 12 feet to the concrete driveway.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>7/18/2009</td>\n",
       "      <td>Newohmer Brothers Feed Lot, Elgin, NE 68636</td>\n",
       "      <td>41.986614</td>\n",
       "      <td>-98.133090</td>\n",
       "      <td>Victim was herding cattle for the feedlot from a horse. The horse stumbled and fell. Victim subsequently fell.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7/20/2009</td>\n",
       "      <td>Art Iron Works, Inc., Onconta, AL 35121</td>\n",
       "      <td>33.928402</td>\n",
       "      <td>-86.484876</td>\n",
       "      <td>Victim was in the process of assembling a transition box, while removing the brace the box collapsed, crushing him.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7/21/2009</td>\n",
       "      <td>Fort Smith Garage Doors, Kibler, AR 72921</td>\n",
       "      <td>35.386612</td>\n",
       "      <td>-94.421720</td>\n",
       "      <td>Victim was installing an overhead garage door. He was using a truck-mounted generator/welder to generate power for his tools. He was found unresponsive in the bed of the truck. Victim was electrocuted.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>7/21/2009</td>\n",
       "      <td>SES Welding, LLC, Holly Bill, FL 32117</td>\n",
       "      <td>29.253303</td>\n",
       "      <td>-81.048410</td>\n",
       "      <td>Victim was working under a disabled truck, disconnecting the drive shaft. The vehicle fell, crushing him.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>Allens Inc,, Siloam Springs, AR 72761</td>\n",
       "      <td>36.205147</td>\n",
       "      <td>-94.428061</td>\n",
       "      <td>Victim was repairing a tote at the end of the line. The top tote fell over, crushing the victim.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>Howie's Tree Services, Merrick, NY 11566</td>\n",
       "      <td>40.663470</td>\n",
       "      <td>-73.563342</td>\n",
       "      <td>Victim was working from the raised bucket of an aerial device. The boom and bucket fell to the ground.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>7/23/2009</td>\n",
       "      <td>Martin Product Sales, LLC, Beaumont, TX 77705</td>\n",
       "      <td>30.044199</td>\n",
       "      <td>-94.115621</td>\n",
       "      <td>Victim was on top of a railcar carrying elemental sulfur and was found unresponsive.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>Green Contractors of NY, Merrick NY 11566</td>\n",
       "      <td>40.652384</td>\n",
       "      <td>-73.559344</td>\n",
       "      <td>Victim was working from a raised forklift and fell to the ground.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5/15/2009</td>\n",
       "      <td>Alvin Wynn Electric Company, Alapaha, GA�31622</td>\n",
       "      <td>31.701254</td>\n",
       "      <td>-83.246291</td>\n",
       "      <td>Worker was replacing a breaker in a main panel at a saw mill and an arc blast occurred.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>7/1/2009</td>\n",
       "      <td>Lakeridge Winery, Clermont, FL�34711</td>\n",
       "      <td>28.627331</td>\n",
       "      <td>-81.768766</td>\n",
       "      <td>Worker was putting away a piece of lawn equipment and was stung twice by insects.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>7/10/2009</td>\n",
       "      <td>Mandy Electric, Inc., Tampa, FL�33610</td>\n",
       "      <td>28.027703</td>\n",
       "      <td>-82.499846</td>\n",
       "      <td>Worker was found on the ground with hot work gloves lying next to him, apparently electrocuted.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>7/17/2009</td>\n",
       "      <td>Arthur Vincent &amp; Sons Construction Inc, Armonk, NY�10504</td>\n",
       "      <td>41.126485</td>\n",
       "      <td>-73.714019</td>\n",
       "      <td>Worker fell from a roof.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>7/20/2009</td>\n",
       "      <td>W.W. Transport, Inc., Harriman, TN� 37748</td>\n",
       "      <td>35.938443</td>\n",
       "      <td>-84.546261</td>\n",
       "      <td>Worker was in the process of loosening straps on a load of pipe located on a flatbed trailer.� The load shifted, causing the pipe to fall and strike the worker.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>Antonio Renteria Framing, Austin, TX� 78738</td>\n",
       "      <td>30.296603</td>\n",
       "      <td>-97.970185</td>\n",
       "      <td>Worker was 12-feet high removing a roof truss and fell, striking his head on the front door concrete patio below.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>7/22/2009</td>\n",
       "      <td>International Marble &amp; Granite Supply, Inc., Chicago, IL� 60622</td>\n",
       "      <td>41.896281</td>\n",
       "      <td>-87.701040</td>\n",
       "      <td>Worker was working with an overhead crane and a bundle of 7-8 slabs of granite.� The slabs tipped over on the worker.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>7/23/2009</td>\n",
       "      <td>T.T.C.S., LLC, Sabine Pass, TX� 77655</td>\n",
       "      <td>29.730441</td>\n",
       "      <td>-93.872509</td>\n",
       "      <td>Worker was on the roof of a modular home being placed on pilings.� Lightning struck the roof, electrocuting the worker.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>7/23/2009</td>\n",
       "      <td>Timberwolf Tree Service, Inc., East Windsor, NJ� 08520</td>\n",
       "      <td>40.251462</td>\n",
       "      <td>-74.491462</td>\n",
       "      <td>Worker was crushed in a chip grinder.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>7/24/2009</td>\n",
       "      <td>Charles McCarten &amp; Son, Inc., Gibbstown, NJ� 08027</td>\n",
       "      <td>39.824940</td>\n",
       "      <td>-75.292730</td>\n",
       "      <td>Worker was caught between the bucket of a backhoe and a wooden deck attached to a building.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>7/25/2009</td>\n",
       "      <td>Wenday South dba Wendy's, Dayton, OH� 45459</td>\n",
       "      <td>39.637144</td>\n",
       "      <td>-84.223967</td>\n",
       "      <td>Worker was working in the kitchen near the back sink.� She slipped and fell in a wet spot, striking her head on the floor.</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>7355</th>\n",
       "      <td>9/23/2012</td>\n",
       "      <td>Archer Underbalanced Services, Boys Ranch, TX 79010</td>\n",
       "      <td>35.531436</td>\n",
       "      <td>-102.254084</td>\n",
       "      <td>Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7356</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>KAYCO Erectors Inc, Sugar Hill, GA 30518</td>\n",
       "      <td>34.106490</td>\n",
       "      <td>-84.033520</td>\n",
       "      <td>Employee died after falling through floor hole while installing metal decking.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7357</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>SITI, Rayne, LA 70578</td>\n",
       "      <td>30.234925</td>\n",
       "      <td>-92.268462</td>\n",
       "      <td>Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7358</th>\n",
       "      <td>9/25/2012</td>\n",
       "      <td>Jet Import Inc, Chicago, IL 60608</td>\n",
       "      <td>41.849212</td>\n",
       "      <td>-87.671320</td>\n",
       "      <td>Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7359</th>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>Advanced Recycling Center, Brewton, AL 36426</td>\n",
       "      <td>31.040095</td>\n",
       "      <td>-87.183949</td>\n",
       "      <td>Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7360</th>\n",
       "      <td>9/27/2012</td>\n",
       "      <td>Viking Drilling, Rankin, TX 79778</td>\n",
       "      <td>31.222648</td>\n",
       "      <td>-101.937909</td>\n",
       "      <td>Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7361</th>\n",
       "      <td>6/29/2012</td>\n",
       "      <td>Williams Warehouse Inc, Plains, GA 31780</td>\n",
       "      <td>32.033288</td>\n",
       "      <td>-84.392466</td>\n",
       "      <td>Employee died after falling from a roof through a skylight while removing metal panels.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7362</th>\n",
       "      <td>7/19/2012</td>\n",
       "      <td>Terrapin Construction Bowie, MD 20715</td>\n",
       "      <td>39.005287</td>\n",
       "      <td>-76.780674</td>\n",
       "      <td>Worker was trimming a tree limb from an extended tree belonging to a neighbor and fell off ladder. Worker was hospitalized but succumbed to injuries and died on 8/13/2012.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7363</th>\n",
       "      <td>8/22/2012</td>\n",
       "      <td>New Jersey Transit Heavy Rail Kearny, NJ 07032</td>\n",
       "      <td>40.753268</td>\n",
       "      <td>-74.095882</td>\n",
       "      <td>Worker performing maintanence underneath railroad equipment when hydraulic line disconnected and equipment lowered crushing worker.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7364</th>\n",
       "      <td>9/11/2012</td>\n",
       "      <td>Desert Rose Golf Course Las Vegas, NV 89142</td>\n",
       "      <td>36.142445</td>\n",
       "      <td>-115.054754</td>\n",
       "      <td>Worker was operating a front end loader to spread dirt in the wash and was unexpectedly swept away by a wall of water flowing at approximately 65-70 MPH. Worker's body was found on 9/14/2012.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7365</th>\n",
       "      <td>9/13/2012</td>\n",
       "      <td>Mr Asphalt Inc., Corvallis, MT 59828</td>\n",
       "      <td>46.314088</td>\n",
       "      <td>-114.112873</td>\n",
       "      <td>Worker died after falling approximately 13 ft while checking the level of an asphalt oil tank.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7366</th>\n",
       "      <td>9/20/2012</td>\n",
       "      <td>Bonneville Power Administration, Saint Regis, MT 59866</td>\n",
       "      <td>47.302363</td>\n",
       "      <td>-115.099070</td>\n",
       "      <td>Worker died after falling approximately 80 feet while replacing insulators.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7367</th>\n",
       "      <td>9/20/2012</td>\n",
       "      <td>Ryan's Tree Service, Chaumont, NY 13622</td>\n",
       "      <td>44.066999</td>\n",
       "      <td>-76.130209</td>\n",
       "      <td>Worker died after being crushed by a chipper.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7368</th>\n",
       "      <td>9/21/2012</td>\n",
       "      <td>G.R. Birdwell Construction LP, Channelview, TX 77530</td>\n",
       "      <td>29.920763</td>\n",
       "      <td>-95.544673</td>\n",
       "      <td>Worker was killed after being pinned between the dirt compactor he was operating and a wall.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7369</th>\n",
       "      <td>9/21/2012</td>\n",
       "      <td>United Drilling Inc, Fort Stockton, TX 79735</td>\n",
       "      <td>30.893117</td>\n",
       "      <td>-102.911319</td>\n",
       "      <td>Worker was killed after being struck in the head by a cable that snapped during drilling operations.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7370</th>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>Mark F. Taggert Company, Columbus, OH 43229</td>\n",
       "      <td>40.070644</td>\n",
       "      <td>-82.993083</td>\n",
       "      <td>Worker died from fall from a ladder.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7371</th>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>Olmar Salazar, Airmont, NY 10901</td>\n",
       "      <td>41.100929</td>\n",
       "      <td>-74.116254</td>\n",
       "      <td>Employee died after being struck by a tree branch while working on a landscaping site.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7372</th>\n",
       "      <td>9/22/2012</td>\n",
       "      <td>Prime Flight Aviation Services San Francisco, CA 94128</td>\n",
       "      <td>37.620525</td>\n",
       "      <td>-122.398880</td>\n",
       "      <td>Worker drove service truck off road crashing into parked lear jet.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7373</th>\n",
       "      <td>9/23/2012</td>\n",
       "      <td>Archer Underbalanced Services, Boys Ranch, TX 79010</td>\n",
       "      <td>35.531436</td>\n",
       "      <td>-102.254084</td>\n",
       "      <td>Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7374</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>Indiana Women's Prison Indianapolis, IN 46214</td>\n",
       "      <td>39.800926</td>\n",
       "      <td>-86.290241</td>\n",
       "      <td>Worker was issued a firearm, went outside, and committed suicide.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7375</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>KAYCO Erectors Inc, Sugar Hill, GA 30518</td>\n",
       "      <td>34.106490</td>\n",
       "      <td>-84.033520</td>\n",
       "      <td>Employee died after falling through floor hole while installing metal decking.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7376</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>PennAKem, LLC Memphis, TN 38108</td>\n",
       "      <td>35.177280</td>\n",
       "      <td>-89.948650</td>\n",
       "      <td>Two workers transferring Furfurlyamine and Methanol from a storage tank to a reactor when an explosion occurred. Both suffered second degree burns and were hospitalized. One of these workers who suffered burns over 92% of body died on 9/27/2012.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7377</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>SITI, Rayne, LA 70578</td>\n",
       "      <td>30.234925</td>\n",
       "      <td>-92.268462</td>\n",
       "      <td>Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7378</th>\n",
       "      <td>9/24/2012</td>\n",
       "      <td>Traffic Specialists, Inc. Calhoun, TN 37309</td>\n",
       "      <td>35.258529</td>\n",
       "      <td>-84.734024</td>\n",
       "      <td>Worker was installing reflectors when struck by a tractor trailer.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7379</th>\n",
       "      <td>9/25/2012</td>\n",
       "      <td>Jet Import Inc, Chicago, IL 60608</td>\n",
       "      <td>41.849212</td>\n",
       "      <td>-87.671320</td>\n",
       "      <td>Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7380</th>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>Advanced Recycling Center, Brewton, AL 36426</td>\n",
       "      <td>31.040095</td>\n",
       "      <td>-87.183949</td>\n",
       "      <td>Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7381</th>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>Recovery Home Improvement, Inc. Baltimore, MD 21222</td>\n",
       "      <td>39.250802</td>\n",
       "      <td>-76.520480</td>\n",
       "      <td>Worker was electrocuted when a 27-foot ladder hoist the worker was moving fell backwards and struck two 7.62 kV overheard distribution lines.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7382</th>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>Russell Toll dba Toll Roofing and Repair Maysville, KY 41018</td>\n",
       "      <td>39.014087</td>\n",
       "      <td>-84.600809</td>\n",
       "      <td>Worker installing a tarp on a roof of a hotel stepped on the eave which collapsed resulting in worker falling approximately 26 feet on to parking lot.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7383</th>\n",
       "      <td>9/26/2012</td>\n",
       "      <td>Steven Barkoff Hillsborough, CA 94010</td>\n",
       "      <td>37.568525</td>\n",
       "      <td>-122.367428</td>\n",
       "      <td>Worker fell from attic to garage floor striking a flower base, hitting the right artery by armpit resulting in loss of blood. Worker was hospitalized but died in ER.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7384</th>\n",
       "      <td>9/27/2012</td>\n",
       "      <td>Viking Drilling, Rankin, TX 79778</td>\n",
       "      <td>31.222648</td>\n",
       "      <td>-101.937909</td>\n",
       "      <td>Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7385 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  \\\n",
       "0     6/23/2009   \n",
       "1     6/30/2009   \n",
       "2      7/6/2009   \n",
       "3      7/9/2009   \n",
       "4     7/11/2009   \n",
       "5     7/11/2009   \n",
       "6     7/15/2009   \n",
       "7     7/16/2009   \n",
       "8     7/18/2009   \n",
       "9     7/18/2009   \n",
       "10    7/18/2009   \n",
       "11    7/18/2009   \n",
       "12    7/20/2009   \n",
       "13    7/21/2009   \n",
       "14    7/21/2009   \n",
       "15    7/22/2009   \n",
       "16    7/22/2009   \n",
       "17    7/23/2009   \n",
       "18    7/24/2009   \n",
       "19    5/15/2009   \n",
       "20     7/1/2009   \n",
       "21    7/10/2009   \n",
       "22    7/17/2009   \n",
       "23    7/20/2009   \n",
       "24    7/22/2009   \n",
       "25    7/22/2009   \n",
       "26    7/23/2009   \n",
       "27    7/23/2009   \n",
       "28    7/24/2009   \n",
       "29    7/25/2009   \n",
       "...         ...   \n",
       "7355  9/23/2012   \n",
       "7356  9/24/2012   \n",
       "7357  9/24/2012   \n",
       "7358  9/25/2012   \n",
       "7359  9/26/2012   \n",
       "7360  9/27/2012   \n",
       "7361  6/29/2012   \n",
       "7362  7/19/2012   \n",
       "7363  8/22/2012   \n",
       "7364  9/11/2012   \n",
       "7365  9/13/2012   \n",
       "7366  9/20/2012   \n",
       "7367  9/20/2012   \n",
       "7368  9/21/2012   \n",
       "7369  9/21/2012   \n",
       "7370  9/22/2012   \n",
       "7371  9/22/2012   \n",
       "7372  9/22/2012   \n",
       "7373  9/23/2012   \n",
       "7374  9/24/2012   \n",
       "7375  9/24/2012   \n",
       "7376  9/24/2012   \n",
       "7377  9/24/2012   \n",
       "7378  9/24/2012   \n",
       "7379  9/25/2012   \n",
       "7380  9/26/2012   \n",
       "7381  9/26/2012   \n",
       "7382  9/26/2012   \n",
       "7383  9/26/2012   \n",
       "7384  9/27/2012   \n",
       "\n",
       "                                                                place  \\\n",
       "0                                 L.B. Thompson Inc., Tampa, FL 33610   \n",
       "1                                 Presiliana Zamora, Conroe, TX 77304   \n",
       "2                                        Cesar Tapia, Miami, FL 33166   \n",
       "3                  Knobel Refrigeration, Inc., North Platte, NE 69103   \n",
       "4                                                Greensburg, PA 15601   \n",
       "5                              Lighthouse Electric, Boulder, CO 80301   \n",
       "6                    Priority Energy Services, LLC, Raleigh, MS 39153   \n",
       "7                  KM Davis Contracting Co., Inc., Marietta, GA 30008   \n",
       "8                                    Jenkins Electric, Post, TX 79356   \n",
       "9                            Lariat Communications, De Kalb, TX 75559   \n",
       "10         Larry Walty Roofing and Guttering, Inc,, Wichita, KS 67208   \n",
       "11                        Newohmer Brothers Feed Lot, Elgin, NE 68636   \n",
       "12                            Art Iron Works, Inc., Onconta, AL 35121   \n",
       "13                          Fort Smith Garage Doors, Kibler, AR 72921   \n",
       "14                             SES Welding, LLC, Holly Bill, FL 32117   \n",
       "15                              Allens Inc,, Siloam Springs, AR 72761   \n",
       "16                           Howie's Tree Services, Merrick, NY 11566   \n",
       "17                      Martin Product Sales, LLC, Beaumont, TX 77705   \n",
       "18                          Green Contractors of NY, Merrick NY 11566   \n",
       "19                     Alvin Wynn Electric Company, Alapaha, GA�31622   \n",
       "20                               Lakeridge Winery, Clermont, FL�34711   \n",
       "21                              Mandy Electric, Inc., Tampa, FL�33610   \n",
       "22           Arthur Vincent & Sons Construction Inc, Armonk, NY�10504   \n",
       "23                          W.W. Transport, Inc., Harriman, TN� 37748   \n",
       "24                        Antonio Renteria Framing, Austin, TX� 78738   \n",
       "25    International Marble & Granite Supply, Inc., Chicago, IL� 60622   \n",
       "26                              T.T.C.S., LLC, Sabine Pass, TX� 77655   \n",
       "27             Timberwolf Tree Service, Inc., East Windsor, NJ� 08520   \n",
       "28                 Charles McCarten & Son, Inc., Gibbstown, NJ� 08027   \n",
       "29                        Wenday South dba Wendy's, Dayton, OH� 45459   \n",
       "...                                                               ...   \n",
       "7355              Archer Underbalanced Services, Boys Ranch, TX 79010   \n",
       "7356                         KAYCO Erectors Inc, Sugar Hill, GA 30518   \n",
       "7357                                            SITI, Rayne, LA 70578   \n",
       "7358                                Jet Import Inc, Chicago, IL 60608   \n",
       "7359                     Advanced Recycling Center, Brewton, AL 36426   \n",
       "7360                                Viking Drilling, Rankin, TX 79778   \n",
       "7361                         Williams Warehouse Inc, Plains, GA 31780   \n",
       "7362                            Terrapin Construction Bowie, MD 20715   \n",
       "7363                   New Jersey Transit Heavy Rail Kearny, NJ 07032   \n",
       "7364                      Desert Rose Golf Course Las Vegas, NV 89142   \n",
       "7365                             Mr Asphalt Inc., Corvallis, MT 59828   \n",
       "7366           Bonneville Power Administration, Saint Regis, MT 59866   \n",
       "7367                          Ryan's Tree Service, Chaumont, NY 13622   \n",
       "7368             G.R. Birdwell Construction LP, Channelview, TX 77530   \n",
       "7369                     United Drilling Inc, Fort Stockton, TX 79735   \n",
       "7370                      Mark F. Taggert Company, Columbus, OH 43229   \n",
       "7371                                 Olmar Salazar, Airmont, NY 10901   \n",
       "7372           Prime Flight Aviation Services San Francisco, CA 94128   \n",
       "7373              Archer Underbalanced Services, Boys Ranch, TX 79010   \n",
       "7374                    Indiana Women's Prison Indianapolis, IN 46214   \n",
       "7375                         KAYCO Erectors Inc, Sugar Hill, GA 30518   \n",
       "7376                                  PennAKem, LLC Memphis, TN 38108   \n",
       "7377                                            SITI, Rayne, LA 70578   \n",
       "7378                      Traffic Specialists, Inc. Calhoun, TN 37309   \n",
       "7379                                Jet Import Inc, Chicago, IL 60608   \n",
       "7380                     Advanced Recycling Center, Brewton, AL 36426   \n",
       "7381              Recovery Home Improvement, Inc. Baltimore, MD 21222   \n",
       "7382     Russell Toll dba Toll Roofing and Repair Maysville, KY 41018   \n",
       "7383                            Steven Barkoff Hillsborough, CA 94010   \n",
       "7384                                Viking Drilling, Rankin, TX 79778   \n",
       "\n",
       "            lat         lng  \\\n",
       "0     27.994928  -82.400987   \n",
       "1     30.331525  -95.509247   \n",
       "2     25.823504  -80.310168   \n",
       "3     41.142954 -100.790990   \n",
       "4     40.301458  -79.538929   \n",
       "5     40.040651 -105.207780   \n",
       "6     32.033488  -89.522291   \n",
       "7     33.882159  -84.527742   \n",
       "8     33.191044 -101.375653   \n",
       "9     33.508726  -94.616319   \n",
       "10    37.683359  -97.077559   \n",
       "11    41.986614  -98.133090   \n",
       "12    33.928402  -86.484876   \n",
       "13    35.386612  -94.421720   \n",
       "14    29.253303  -81.048410   \n",
       "15    36.205147  -94.428061   \n",
       "16    40.663470  -73.563342   \n",
       "17    30.044199  -94.115621   \n",
       "18    40.652384  -73.559344   \n",
       "19    31.701254  -83.246291   \n",
       "20    28.627331  -81.768766   \n",
       "21    28.027703  -82.499846   \n",
       "22    41.126485  -73.714019   \n",
       "23    35.938443  -84.546261   \n",
       "24    30.296603  -97.970185   \n",
       "25    41.896281  -87.701040   \n",
       "26    29.730441  -93.872509   \n",
       "27    40.251462  -74.491462   \n",
       "28    39.824940  -75.292730   \n",
       "29    39.637144  -84.223967   \n",
       "...         ...         ...   \n",
       "7355  35.531436 -102.254084   \n",
       "7356  34.106490  -84.033520   \n",
       "7357  30.234925  -92.268462   \n",
       "7358  41.849212  -87.671320   \n",
       "7359  31.040095  -87.183949   \n",
       "7360  31.222648 -101.937909   \n",
       "7361  32.033288  -84.392466   \n",
       "7362  39.005287  -76.780674   \n",
       "7363  40.753268  -74.095882   \n",
       "7364  36.142445 -115.054754   \n",
       "7365  46.314088 -114.112873   \n",
       "7366  47.302363 -115.099070   \n",
       "7367  44.066999  -76.130209   \n",
       "7368  29.920763  -95.544673   \n",
       "7369  30.893117 -102.911319   \n",
       "7370  40.070644  -82.993083   \n",
       "7371  41.100929  -74.116254   \n",
       "7372  37.620525 -122.398880   \n",
       "7373  35.531436 -102.254084   \n",
       "7374  39.800926  -86.290241   \n",
       "7375  34.106490  -84.033520   \n",
       "7376  35.177280  -89.948650   \n",
       "7377  30.234925  -92.268462   \n",
       "7378  35.258529  -84.734024   \n",
       "7379  41.849212  -87.671320   \n",
       "7380  31.040095  -87.183949   \n",
       "7381  39.250802  -76.520480   \n",
       "7382  39.014087  -84.600809   \n",
       "7383  37.568525 -122.367428   \n",
       "7384  31.222648 -101.937909   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                          description  \n",
       "0                                                                                                                                                                                                                                                                                                                Victim was inside a building bundling material and became ill, possible heat stroke.  \n",
       "1                                                                                                                                                                                                                                                                                                                    Victim was on a scaffold doing repairs on an archway and the scaffold collapsed.  \n",
       "2                                                                                                                                                                                                                                                                                       Victim was conducting roofing work, and fell through a hole in the roof, 25 feet to the concrete floor below.  \n",
       "3                                                                                                                                                                                                                                                                                                     Victim was climbing a ladder while servicing an air-conditioning unit and fell from the ladder.  \n",
       "4     Employees were throwing away old files. They had a dumpster on the forks in the raised position. In bringing the dumpster down on the forks, the load became unstable. Victim stood on the rear of the forklift to act as a counterbalance. The dumpster fell off the trucs, causing forktruck to lunge forward and the victim to strike his head on the overhead guard, falling to the ground.  \n",
       "5                                                                                                                                                                                                                                                                                                                                                         Fatality at a bookstore under construction.  \n",
       "6                                                                                                                                                                                                                                                                              Victim was pressure testing a new metering station at a new pipeline construction project, when an explosion occurred.  \n",
       "7                                                                                                                                                                                                                                                                                                                                Victim was standing on the side of the road and was struck by a car.  \n",
       "8                                                                                                                                                                                                                                                                                                               Victim was working on a pole replacing a transformer, 14,400KV, and was electrocuted.  \n",
       "9                                                                                                                                                                                                                                                                                                Victim was installing coax cable hangers down the face of an existing tower and fell 60 to 100 feet.  \n",
       "10                                                                                                                                                                                                                                   Victim was on a roof preparing an estimate. He started to come down from the roof and the ladder became dislodged. Victim fell 12 feet to the concrete driveway.  \n",
       "11                                                                                                                                                                                                                                                                                     Victim was herding cattle for the feedlot from a horse. The horse stumbled and fell. Victim subsequently fell.  \n",
       "12                                                                                                                                                                                                                                                                                Victim was in the process of assembling a transition box, while removing the brace the box collapsed, crushing him.  \n",
       "13                                                                                                                                                                                          Victim was installing an overhead garage door. He was using a truck-mounted generator/welder to generate power for his tools. He was found unresponsive in the bed of the truck. Victim was electrocuted.  \n",
       "14                                                                                                                                                                                                                                                                                          Victim was working under a disabled truck, disconnecting the drive shaft. The vehicle fell, crushing him.  \n",
       "15                                                                                                                                                                                                                                                                                                   Victim was repairing a tote at the end of the line. The top tote fell over, crushing the victim.  \n",
       "16                                                                                                                                                                                                                                                                                             Victim was working from the raised bucket of an aerial device. The boom and bucket fell to the ground.  \n",
       "17                                                                                                                                                                                                                                                                                                               Victim was on top of a railcar carrying elemental sulfur and was found unresponsive.  \n",
       "18                                                                                                                                                                                                                                                                                                                                  Victim was working from a raised forklift and fell to the ground.  \n",
       "19                                                                                                                                                                                                                                                                                                            Worker was replacing a breaker in a main panel at a saw mill and an arc blast occurred.  \n",
       "20                                                                                                                                                                                                                                                                                                                  Worker was putting away a piece of lawn equipment and was stung twice by insects.  \n",
       "21                                                                                                                                                                                                                                                                                                    Worker was found on the ground with hot work gloves lying next to him, apparently electrocuted.  \n",
       "22                                                                                                                                                                                                                                                                                                                                                                           Worker fell from a roof.  \n",
       "23                                                                                                                                                                                                                                   Worker was in the process of loosening straps on a load of pipe located on a flatbed trailer.� The load shifted, causing the pipe to fall and strike the worker.  \n",
       "24                                                                                                                                                                                                                                                                                  Worker was 12-feet high removing a roof truss and fell, striking his head on the front door concrete patio below.  \n",
       "25                                                                                                                                                                                                                                                                              Worker was working with an overhead crane and a bundle of 7-8 slabs of granite.� The slabs tipped over on the worker.  \n",
       "26                                                                                                                                                                                                                                                                            Worker was on the roof of a modular home being placed on pilings.� Lightning struck the roof, electrocuting the worker.  \n",
       "27                                                                                                                                                                                                                                                                                                                                                              Worker was crushed in a chip grinder.  \n",
       "28                                                                                                                                                                                                                                                                                                        Worker was caught between the bucket of a backhoe and a wooden deck attached to a building.  \n",
       "29                                                                                                                                                                                                                                                                         Worker was working in the kitchen near the back sink.� She slipped and fell in a wet spot, striking her head on the floor.  \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                               ...  \n",
       "7355                                                                                                                                                                                                                                                                              Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.  \n",
       "7356                                                                                                                                                                                                                                                                                                                   Employee died after falling through floor hole while installing metal decking.  \n",
       "7357                                                                                                                                                                                                                                                                                         Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.  \n",
       "7358                                                                                                                                                                                                                                                                                Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.  \n",
       "7359                                                                                                                                                                                                                                                                          Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.  \n",
       "7360                                                                                                                                                                                                                                                                               Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.  \n",
       "7361                                                                                                                                                                                                                                                                                                          Employee died after falling from a roof through a skylight while removing metal panels.  \n",
       "7362                                                                                                                                                                                                                      Worker was trimming a tree limb from an extended tree belonging to a neighbor and fell off ladder. Worker was hospitalized but succumbed to injuries and died on 8/13/2012.  \n",
       "7363                                                                                                                                                                                                                                                              Worker performing maintanence underneath railroad equipment when hydraulic line disconnected and equipment lowered crushing worker.  \n",
       "7364                                                                                                                                                                                                  Worker was operating a front end loader to spread dirt in the wash and was unexpectedly swept away by a wall of water flowing at approximately 65-70 MPH. Worker's body was found on 9/14/2012.  \n",
       "7365                                                                                                                                                                                                                                                                                                   Worker died after falling approximately 13 ft while checking the level of an asphalt oil tank.  \n",
       "7366                                                                                                                                                                                                                                                                                                                      Worker died after falling approximately 80 feet while replacing insulators.  \n",
       "7367                                                                                                                                                                                                                                                                                                                                                    Worker died after being crushed by a chipper.  \n",
       "7368                                                                                                                                                                                                                                                                                                     Worker was killed after being pinned between the dirt compactor he was operating and a wall.  \n",
       "7369                                                                                                                                                                                                                                                                                             Worker was killed after being struck in the head by a cable that snapped during drilling operations.  \n",
       "7370                                                                                                                                                                                                                                                                                                                                                             Worker died from fall from a ladder.  \n",
       "7371                                                                                                                                                                                                                                                                                                           Employee died after being struck by a tree branch while working on a landscaping site.  \n",
       "7372                                                                                                                                                                                                                                                                                                                               Worker drove service truck off road crashing into parked lear jet.  \n",
       "7373                                                                                                                                                                                                                                                                              Worker was killed while repairing an air compressor after a 2-inch line separated and struck employee in the chest.  \n",
       "7374                                                                                                                                                                                                                                                                                                                                Worker was issued a firearm, went outside, and committed suicide.  \n",
       "7375                                                                                                                                                                                                                                                                                                                   Employee died after falling through floor hole while installing metal decking.  \n",
       "7376                                                                                                                                            Two workers transferring Furfurlyamine and Methanol from a storage tank to a reactor when an explosion occurred. Both suffered second degree burns and were hospitalized. One of these workers who suffered burns over 92% of body died on 9/27/2012.  \n",
       "7377                                                                                                                                                                                                                                                                                         Worker was pouring concrete when he was struck and killed by a vehicle being driven by another employee.  \n",
       "7378                                                                                                                                                                                                                                                                                                                               Worker was installing reflectors when struck by a tractor trailer.  \n",
       "7379                                                                                                                                                                                                                                                                                Worker died after being struck on the head by a pallet that had fallen from a trailer he was preparing to unload.  \n",
       "7380                                                                                                                                                                                                                                                                          Worker was crushed when bucket of skid loader fell on him when he crawled under machine to disconnect a hydraulic line.  \n",
       "7381                                                                                                                                                                                                                                                    Worker was electrocuted when a 27-foot ladder hoist the worker was moving fell backwards and struck two 7.62 kV overheard distribution lines.  \n",
       "7382                                                                                                                                                                                                                                           Worker installing a tarp on a roof of a hotel stepped on the eave which collapsed resulting in worker falling approximately 26 feet on to parking lot.  \n",
       "7383                                                                                                                                                                                                                            Worker fell from attic to garage floor striking a flower base, hitting the right artery by armpit resulting in loss of blood. Worker was hospitalized but died in ER.  \n",
       "7384                                                                                                                                                                                                                                                                               Employee was electrocuted when the forklift he was operating became entangled with a 440-480 volt electrical line.  \n",
       "\n",
       "[7385 rows x 5 columns]"
      ]
     },
     "execution_count": 519,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "osha_archive"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 573 entries, 0 to 572\n",
      "Data columns (total 5 columns):\n",
      "date           571 non-null object\n",
      "description    573 non-null object\n",
      "employer       573 non-null object\n",
      "lat            561 non-null float64\n",
      "lng            561 non-null float64\n",
      "dtypes: float64(2), object(3)\n",
      "memory usage: 22.5+ KB\n"
     ]
    }
   ],
   "source": [
    "# ok, time to drop stuff from both\n",
    "\n",
    "# current first\n",
    "osha_current.drop([ 'fatcat', 'inspection', 'victim'], axis=1, inplace=True)\n",
    "osha_current.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 523,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 573 entries, 0 to 572\n",
      "Data columns (total 5 columns):\n",
      "date           571 non-null object\n",
      "description    573 non-null object\n",
      "place          573 non-null object\n",
      "lat            561 non-null float64\n",
      "lng            561 non-null float64\n",
      "dtypes: float64(2), object(3)\n",
      "memory usage: 22.5+ KB\n"
     ]
    }
   ],
   "source": [
    "# osha_archive.info()\n",
    "osha_current.columns = ['date', 'description', 'place', 'lat', 'lng']\n",
    "osha_current.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Now to combine the current and archive\n",
    "and spit out our result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 524,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "osha_all = pd.concat([osha_archive, osha_current], ignore_index=True)\n",
    "\n",
    "# osha_archive.dropna(how='any', inplace=True)\n",
    "# osha_archive.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 525,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7958 entries, 0 to 7957\n",
      "Data columns (total 5 columns):\n",
      "date           7923 non-null object\n",
      "description    7925 non-null object\n",
      "lat            7939 non-null float64\n",
      "lng            7939 non-null float64\n",
      "place          7925 non-null object\n",
      "dtypes: float64(2), object(3)\n",
      "memory usage: 310.9+ KB\n"
     ]
    }
   ],
   "source": [
    "osha_all.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 526,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "osha_all.to_csv('osha_all_all.csv')\n",
    "# combine all the osha records, before splitting by time below"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 527,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# there are some with problems\n",
    "# ?\n",
    "osha_all.dropna(axis=0, how='any', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 528,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 7904 entries, 0 to 7955\n",
      "Data columns (total 5 columns):\n",
      "date           7904 non-null object\n",
      "description    7904 non-null object\n",
      "lat            7904 non-null float64\n",
      "lng            7904 non-null float64\n",
      "place          7904 non-null object\n",
      "dtypes: float64(2), object(3)\n",
      "memory usage: 370.5+ KB\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>description</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>place</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7953</th>\n",
       "      <td>2016-07-19</td>\n",
       "      <td>Worker killed in fall through stair hole.</td>\n",
       "      <td>42.544013</td>\n",
       "      <td>-83.346878</td>\n",
       "      <td>Johni Semma DBA Johni Semma, West Bloomfield, MI 48322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7954</th>\n",
       "      <td>2016-06-27</td>\n",
       "      <td>Worker died from hantavirus after being exposed to mouse droppings while cleaning cabins.</td>\n",
       "      <td>34.687556</td>\n",
       "      <td>-106.351590</td>\n",
       "      <td>Marzano Mountain Retreat, Torreon, NM 87061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7955</th>\n",
       "      <td>2016-05-24</td>\n",
       "      <td>Worker struck and killed by falling tree.</td>\n",
       "      <td>37.683378</td>\n",
       "      <td>-87.916691</td>\n",
       "      <td>Raymond Trent dba Raymond Trent, Morganfield, KY 42437</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            date  \\\n",
       "7953  2016-07-19   \n",
       "7954  2016-06-27   \n",
       "7955  2016-05-24   \n",
       "\n",
       "                                                                                    description  \\\n",
       "7953                                                  Worker killed in fall through stair hole.   \n",
       "7954  Worker died from hantavirus after being exposed to mouse droppings while cleaning cabins.   \n",
       "7955                                                  Worker struck and killed by falling tree.   \n",
       "\n",
       "            lat         lng  \\\n",
       "7953  42.544013  -83.346878   \n",
       "7954  34.687556 -106.351590   \n",
       "7955  37.683378  -87.916691   \n",
       "\n",
       "                                                       place  \n",
       "7953  Johni Semma DBA Johni Semma, West Bloomfield, MI 48322  \n",
       "7954             Marzano Mountain Retreat, Torreon, NM 87061  \n",
       "7955  Raymond Trent dba Raymond Trent, Morganfield, KY 42437  "
      ]
     },
     "execution_count": 528,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "osha_all.info()\n",
    "osha_all[-3:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 529,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "osha_all.to_csv('osha.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 501,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def save_obj(obj, name ):\n",
    "    with open(name + '.pkl', 'wb') as f:\n",
    "        pickle.dump(obj, f, pickle.HIGHEST_PROTOCOL)\n",
    "\n",
    "def load_obj(name ):\n",
    "    with open('obj/' + name + '.pkl', 'rb') as f:\n",
    "        return pickle.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 502,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "save_obj(geo_cache, \"geo_cache\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 407,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>A</th>\n",
       "      <th>B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>aaa</td>\n",
       "      <td>aaa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>bbb</td>\n",
       "      <td>bbb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ccc</td>\n",
       "      <td>ccc</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     A    B\n",
       "0  aaa  aaa\n",
       "1  bbb  bbb\n",
       "2  ccc  ccc"
      ]
     },
     "execution_count": 407,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfc = pd.DataFrame({'A':['aaa','bbb','ccc'],'B':[1,2,3]})\n",
    "# dfc.loc[dfc.A.notnull(), 'B'] = dfc.loc[dfc.A.notnull(), 'A'] \n",
    "\n",
    "# dfc.loc[0,'A'] = 1188\n",
    "\n",
    "\n",
    "dfc"
   ]
  }
 ],
 "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.5.2"
  },
  "widgets": {
   "state": {
    "1d61541ded99498a9354fec3ea8dd7d7": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "421bbc39be0f4c9aad93d17744f19df8": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "435f436fea044f00a868a0a1a1829004": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "5864701029b74ce19be74375c394e97e": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "5bd30a4290e94d9bbefaef80e4c13352": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "5d9238e06e264b8b82690b4bf93ccbef": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "7c4c046b6189407e9073fbf3778cba22": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "853236f85e694de2b1625018f5f64f6b": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "861fdf391bdc4753912930a678574fbe": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "ab04b43284d847f28f8935609423dff4": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "bc563e209a3d4363af89f17d6a87c466": {
     "views": [
      {
       "cell_index": 17
      }
     ]
    },
    "d24857bf44924a9eb8043eedd0e9f60f": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "d50834129cb94ee6957be91a70702838": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    },
    "f4a680e67ef24612989ab4271ebadb0f": {
     "views": [
      {
       "cell_index": 16
      }
     ]
    }
   },
   "version": "1.2.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}