Skip to content

Instantly share code, notes, and snippets.

@elbertwang3

elbertwang3/epmg.ipynb

Last active March 8, 2019 21:11
Show Gist options
  • Save elbertwang3/bba02c281342cee4870093a063537588 to your computer and use it in GitHub Desktop.
Save elbertwang3/bba02c281342cee4870093a063537588 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
epmg.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
fema.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
public-assistance.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Populating the interactive namespace from numpy and matplotlib\n"
]
}
],
"source": [
"%pylab inline\n",
"import pandas as pd\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"pa = pd.read_csv('../data/PublicAssistanceFundedProjectsSummaries.csv', dtype={'federalObligatedAmount':float})\n",
"declarations = pd.read_csv('../data/DisasterDeclarationsSummaries.csv')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Spending by disaster type"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"incidentType\n",
"Hurricane 5.615329e+10\n",
"Severe Storm(s) 1.325039e+10\n",
"Fire 6.513506e+09\n",
"Flood 3.724621e+09\n",
"Severe Ice Storm 1.909078e+09\n",
"Snow 1.271285e+09\n",
"Coastal Storm 4.892853e+08\n",
"Earthquake 3.457287e+08\n",
"Tornado 3.117015e+08\n",
"Typhoon 2.440775e+08\n",
"Mud/Landslide 7.681029e+07\n",
"Other 7.374283e+07\n",
"Tsunami 4.990680e+07\n",
"Dam/Levee Break 2.060070e+07\n",
"Volcano 1.605275e+07\n",
"Terrorist 1.100534e+07\n",
"Human Cause 3.907407e+06\n",
"Freezing 3.252444e+06\n",
"Toxic Substances 3.112077e+06\n",
"Chemical 1.639099e+06\n",
"Drought 7.399165e+04\n",
"Name: federalObligatedAmount, dtype: float64"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.groupby(['incidentType'])['federalObligatedAmount'].sum().sort_values(ascending=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Spending by state"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"state\n",
"New York 2.103926e+10\n",
"Louisiana 1.624979e+10\n",
"Florida 6.114932e+09\n",
"Puerto Rico 6.042834e+09\n",
"Texas 5.750877e+09\n",
"Mississippi 3.507806e+09\n",
"New Jersey 2.597493e+09\n",
"California 2.537341e+09\n",
"Iowa 1.647710e+09\n",
"Virgin Islands of the U.S. 1.647521e+09\n",
"Oklahoma 1.278685e+09\n",
"North Carolina 1.150331e+09\n",
"Kansas 9.961694e+08\n",
"Missouri 9.260201e+08\n",
"Alabama 8.449450e+08\n",
"Arkansas 7.259558e+08\n",
"South Carolina 6.910456e+08\n",
"Massachusetts 6.363378e+08\n",
"Tennessee 6.298160e+08\n",
"Virginia 6.194976e+08\n",
"Pennsylvania 6.070026e+08\n",
"Georgia 6.041673e+08\n",
"North Dakota 6.004860e+08\n",
"Kentucky 5.866145e+08\n",
"Washington 4.634780e+08\n",
"West Virginia 4.443562e+08\n",
"Colorado 4.171642e+08\n",
"Nebraska 4.169256e+08\n",
"Minnesota 3.860194e+08\n",
"Ohio 3.737679e+08\n",
"Maryland 3.525351e+08\n",
"Illinois 3.342536e+08\n",
"Connecticut 3.081567e+08\n",
"New Mexico 3.060946e+08\n",
"Vermont 2.943965e+08\n",
"South Dakota 2.749097e+08\n",
"Indiana 2.493180e+08\n",
"Alaska 2.268509e+08\n",
"Wisconsin 1.903417e+08\n",
"Oregon 1.726290e+08\n",
"New Hampshire 1.511413e+08\n",
"Northern Mariana Islands 1.338175e+08\n",
"American Samoa 1.171661e+08\n",
"Maine 1.062757e+08\n",
"Hawaii 9.097346e+07\n",
"Guam 7.805351e+07\n",
"Montana 7.636651e+07\n",
"Rhode Island 7.082056e+07\n",
"Michigan 6.594040e+07\n",
"Arizona 6.402378e+07\n",
"District of Columbia 6.191734e+07\n",
"Nevada 5.468984e+07\n",
"Idaho 4.242819e+07\n",
"Delaware 3.968295e+07\n",
"Utah 3.505969e+07\n",
"Federated States of Micronesia 2.089643e+07\n",
"Wyoming 1.997110e+07\n",
"Name: federalObligatedAmount, dtype: float64"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.groupby(['state'])['federalObligatedAmount'].sum().sort_values(ascending=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Spending by year"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"year\n",
"1980 2.005087e+06\n",
"1992 1.804217e+06\n",
"1993 1.109493e+08\n",
"1994 2.593377e+06\n",
"1995 7.938175e+06\n",
"1996 1.585547e+07\n",
"1998 6.414991e+08\n",
"1999 9.068780e+08\n",
"2000 7.637606e+08\n",
"2001 5.843745e+09\n",
"2002 7.062085e+08\n",
"2003 1.062561e+09\n",
"2004 3.390457e+09\n",
"2005 2.109177e+10\n",
"2006 1.085944e+09\n",
"2007 1.712631e+09\n",
"2008 5.971835e+09\n",
"2009 1.614428e+09\n",
"2010 1.526997e+09\n",
"2011 3.818250e+09\n",
"2012 1.715694e+10\n",
"2013 1.205882e+09\n",
"2014 1.075254e+09\n",
"2015 1.161499e+09\n",
"2016 2.675067e+09\n",
"2017 1.031906e+10\n",
"2018 6.012402e+08\n",
"Name: federalObligatedAmount, dtype: float64"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa['year'] = pd.to_datetime(pa['declarationDate']).dt.year\n",
"pa.groupby(['year'])['federalObligatedAmount'].sum()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Spending by category by year"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"year incidentType \n",
"1980 Coastal Storm 6.972270e+05\n",
" Toxic Substances 1.307860e+06\n",
"1992 Toxic Substances 1.804217e+06\n",
"1993 Snow 1.109493e+08\n",
"1994 Flood 2.593377e+06\n",
"1995 Human Cause 3.907407e+06\n",
" Hurricane 4.030768e+06\n",
"1996 Fire 1.443194e+07\n",
" Other 1.423530e+06\n",
"1998 Fire 3.324279e+07\n",
" Flood 3.223680e+07\n",
" Hurricane 5.059927e+08\n",
" Mud/Landslide 4.274532e+06\n",
" Other 2.828690e+05\n",
" Severe Storm(s) 6.546951e+07\n",
"1999 Fire 6.058504e+07\n",
" Flood 5.091599e+07\n",
" Hurricane 5.894148e+08\n",
" Severe Ice Storm 1.486299e+07\n",
" Severe Storm(s) 9.558494e+07\n",
" Snow 5.002538e+07\n",
" Tornado 4.548886e+07\n",
"2000 Fire 9.752329e+06\n",
" Flood 7.410028e+06\n",
" Other 6.912292e+06\n",
" Severe Ice Storm 1.815456e+08\n",
" Severe Storm(s) 5.419540e+08\n",
" Snow 7.275594e+06\n",
" Tornado 8.910801e+06\n",
"2001 Coastal Storm 4.587869e+08\n",
" ... \n",
"2015 Flood 2.027618e+08\n",
" Severe Ice Storm 7.662601e+07\n",
" Severe Storm(s) 5.671139e+08\n",
" Snow 7.081511e+06\n",
" Tornado 2.967657e+06\n",
" Typhoon 4.372996e+07\n",
"2016 Fire 3.961245e+06\n",
" Flood 1.122549e+09\n",
" Hurricane 1.035200e+09\n",
" Mud/Landslide 3.372504e+06\n",
" Severe Storm(s) 3.253020e+08\n",
" Snow 1.814456e+08\n",
" Tornado 3.236436e+06\n",
"2017 Fire 3.436517e+08\n",
" Flood 4.247316e+08\n",
" Hurricane 8.948885e+09\n",
" Severe Ice Storm 9.124132e+06\n",
" Severe Storm(s) 5.164732e+08\n",
" Snow 4.075266e+07\n",
" Tornado 3.544554e+07\n",
"2018 Coastal Storm 2.076343e+06\n",
" Fire 2.246123e+08\n",
" Flood 7.759338e+07\n",
" Hurricane 8.721792e+07\n",
" Mud/Landslide 3.696286e+07\n",
" Severe Storm(s) 7.284114e+07\n",
" Snow 1.568178e+07\n",
" Tornado 4.814095e+05\n",
" Typhoon 7.907932e+07\n",
" Volcano 4.693787e+06\n",
"Name: federalObligatedAmount, Length: 172, dtype: float64"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.groupby(['year', 'incidentType'])['federalObligatedAmount'].sum()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# What are the costliest disasters?"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>title</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>4085</td>\n",
" <td>1.421109e+10</td>\n",
" <td>HURRICANE SANDY</td>\n",
" <td>2012-10-30T04:34:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>NY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>1603</td>\n",
" <td>1.337269e+10</td>\n",
" <td>HURRICANE KATRINA</td>\n",
" <td>2005-08-29T16:28:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>LA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>4339</td>\n",
" <td>5.403489e+09</td>\n",
" <td>HURRICANE MARIA</td>\n",
" <td>2017-09-20T21:00:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>PR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>156</th>\n",
" <td>1391</td>\n",
" <td>4.708614e+09</td>\n",
" <td>FIRES AND EXPLOSIONS</td>\n",
" <td>2001-09-11T19:30:00.000Z</td>\n",
" <td>Fire</td>\n",
" <td>NY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>218</th>\n",
" <td>1604</td>\n",
" <td>3.165230e+09</td>\n",
" <td>HURRICANE KATRINA</td>\n",
" <td>2005-08-29T14:32:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>MS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>300</th>\n",
" <td>1791</td>\n",
" <td>2.237904e+09</td>\n",
" <td>HURRICANE IKE</td>\n",
" <td>2008-09-13T13:30:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>TX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>351</th>\n",
" <td>4086</td>\n",
" <td>1.998818e+09</td>\n",
" <td>HURRICANE SANDY</td>\n",
" <td>2012-10-30T04:34:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>NJ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>372</th>\n",
" <td>4340</td>\n",
" <td>1.560988e+09</td>\n",
" <td>HURRICANE MARIA</td>\n",
" <td>2017-09-20T22:30:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>VI</td>\n",
" </tr>\n",
" <tr>\n",
" <th>375</th>\n",
" <td>1609</td>\n",
" <td>1.470563e+09</td>\n",
" <td>HURRICANE WILMA</td>\n",
" <td>2005-10-24T10:39:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>395</th>\n",
" <td>4332</td>\n",
" <td>1.276638e+09</td>\n",
" <td>HURRICANE HARVEY</td>\n",
" <td>2017-08-25T21:35:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>TX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>448</th>\n",
" <td>1763</td>\n",
" <td>1.155439e+09</td>\n",
" <td>SEVERE STORMS, TORNADOES, AND FLOODING</td>\n",
" <td>2008-05-27T10:30:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>IA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>533</th>\n",
" <td>1786</td>\n",
" <td>7.158877e+08</td>\n",
" <td>HURRICANE GUSTAV</td>\n",
" <td>2008-09-02T20:00:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>LA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>597</th>\n",
" <td>1551</td>\n",
" <td>6.861587e+08</td>\n",
" <td>HURRICANE IVAN</td>\n",
" <td>2004-09-16T15:00:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>642</th>\n",
" <td>1607</td>\n",
" <td>6.731933e+08</td>\n",
" <td>HURRICANE RITA</td>\n",
" <td>2005-09-24T19:49:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>LA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>706</th>\n",
" <td>1545</td>\n",
" <td>6.703622e+08</td>\n",
" <td>HURRICANE FRANCES</td>\n",
" <td>2004-09-04T19:00:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>773</th>\n",
" <td>4277</td>\n",
" <td>6.579002e+08</td>\n",
" <td>SEVERE STORMS AND FLOODING</td>\n",
" <td>2016-08-14T18:45:00.000Z</td>\n",
" <td>Flood</td>\n",
" <td>LA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>799</th>\n",
" <td>1539</td>\n",
" <td>6.023289e+08</td>\n",
" <td>TROPICAL STORM BONNIE AND HURRICANE CHARLEY</td>\n",
" <td>2004-08-13T17:30:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>866</th>\n",
" <td>4020</td>\n",
" <td>5.496055e+08</td>\n",
" <td>HURRICANE IRENE</td>\n",
" <td>2011-08-31T04:30:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>NY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>898</th>\n",
" <td>3216</td>\n",
" <td>5.128452e+08</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-02T12:51:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>TX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1152</th>\n",
" <td>1561</td>\n",
" <td>5.116918e+08</td>\n",
" <td>HURRICANE JEANNE</td>\n",
" <td>2004-09-26T00:00:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1205</th>\n",
" <td>4337</td>\n",
" <td>4.498723e+08</td>\n",
" <td>HURRICANE IRMA</td>\n",
" <td>2017-09-10T14:45:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1272</th>\n",
" <td>1379</td>\n",
" <td>4.277281e+08</td>\n",
" <td>TX-TROPICAL STORM ALLISON-06-06-2001</td>\n",
" <td>2001-06-09T11:00:00.000Z</td>\n",
" <td>Coastal Storm</td>\n",
" <td>TX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1303</th>\n",
" <td>1247</td>\n",
" <td>4.012971e+08</td>\n",
" <td>HURRICANE GEORGES - 18 SEP 98</td>\n",
" <td>1998-09-24T16:00:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>PR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1382</th>\n",
" <td>1606</td>\n",
" <td>3.632519e+08</td>\n",
" <td>HURRICANE RITA</td>\n",
" <td>2005-09-24T19:58:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>TX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1636</th>\n",
" <td>4344</td>\n",
" <td>3.436517e+08</td>\n",
" <td>WILDFIRES</td>\n",
" <td>2017-10-10T12:40:00.000Z</td>\n",
" <td>Fire</td>\n",
" <td>CA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1645</th>\n",
" <td>4145</td>\n",
" <td>3.426799e+08</td>\n",
" <td>SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSL...</td>\n",
" <td>2013-09-14T22:55:00.000Z</td>\n",
" <td>Flood</td>\n",
" <td>CO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1663</th>\n",
" <td>4283</td>\n",
" <td>3.333026e+08</td>\n",
" <td>HURRICANE MATTHEW</td>\n",
" <td>2016-10-08T20:53:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>FL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1681</th>\n",
" <td>4080</td>\n",
" <td>3.302547e+08</td>\n",
" <td>HURRICANE ISAAC</td>\n",
" <td>2012-08-29T22:50:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>LA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1736</th>\n",
" <td>4031</td>\n",
" <td>3.221933e+08</td>\n",
" <td>REMNANTS OF TROPICAL STORM LEE</td>\n",
" <td>2011-09-13T17:00:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>NY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1751</th>\n",
" <td>1292</td>\n",
" <td>2.927356e+08</td>\n",
" <td>HURRICANE FLOYD MAJOR DISASTER DECLARATIONS</td>\n",
" <td>1999-09-16T15:15:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>NC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25764</th>\n",
" <td>3291</td>\n",
" <td>3.565304e+05</td>\n",
" <td>HURRICANE GUSTAV</td>\n",
" <td>2008-08-30T15:30:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>MS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25846</th>\n",
" <td>3257</td>\n",
" <td>3.449433e+05</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-19T20:14:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>NJ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25867</th>\n",
" <td>4392</td>\n",
" <td>3.113375e+05</td>\n",
" <td>SEVERE STORM AND TORNADOES</td>\n",
" <td>2018-09-12T12:55:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>IA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25871</th>\n",
" <td>4383</td>\n",
" <td>3.046779e+05</td>\n",
" <td>SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING</td>\n",
" <td>2018-08-10T16:30:00.000Z</td>\n",
" <td>Flood</td>\n",
" <td>WI</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25877</th>\n",
" <td>3196</td>\n",
" <td>3.004999e+05</td>\n",
" <td>SNOW</td>\n",
" <td>2004-04-02T15:20:00.000Z</td>\n",
" <td>Snow</td>\n",
" <td>ND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25887</th>\n",
" <td>3126</td>\n",
" <td>2.828690e+05</td>\n",
" <td>DEBRUCE GRAIN ELEVATOR EXPLOSION (SEDGWICK CTY)</td>\n",
" <td>1998-06-09T00:00:00.000Z</td>\n",
" <td>Other</td>\n",
" <td>KS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25889</th>\n",
" <td>1338</td>\n",
" <td>2.816553e+05</td>\n",
" <td>SEVERE THUNDERSTORMS</td>\n",
" <td>2000-08-17T13:55:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>DC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25890</th>\n",
" <td>4312</td>\n",
" <td>2.699348e+05</td>\n",
" <td>FLOODING</td>\n",
" <td>2017-05-02T18:00:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>CA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25891</th>\n",
" <td>3240</td>\n",
" <td>2.641134e+05</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-12T15:34:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>VA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26025</th>\n",
" <td>4123</td>\n",
" <td>2.399206e+05</td>\n",
" <td>SEVERE STORMS AND FLOODING</td>\n",
" <td>2013-06-25T14:17:00.000Z</td>\n",
" <td>Flood</td>\n",
" <td>ND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26026</th>\n",
" <td>3239</td>\n",
" <td>2.323832e+05</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-10T20:20:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>IA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26125</th>\n",
" <td>3234</td>\n",
" <td>2.089972e+05</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-10T20:20:00.000Z</td>\n",
" <td>Coastal Storm</td>\n",
" <td>SD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26191</th>\n",
" <td>3244</td>\n",
" <td>2.047991e+05</td>\n",
" <td>HURRICANE KATRINA</td>\n",
" <td>2005-09-13T13:34:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>ID</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26235</th>\n",
" <td>4133</td>\n",
" <td>1.733584e+05</td>\n",
" <td>ROYAL GORGE FIRE</td>\n",
" <td>2013-07-26T11:11:00.000Z</td>\n",
" <td>Fire</td>\n",
" <td>CO</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26236</th>\n",
" <td>3102</td>\n",
" <td>1.572907e+05</td>\n",
" <td>BLIZZARDS, HIGH WINDS &amp; RECORD SNOWFALL</td>\n",
" <td>1993-03-16T00:00:00.000Z</td>\n",
" <td>Snow</td>\n",
" <td>RI</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26241</th>\n",
" <td>3236</td>\n",
" <td>1.549888e+05</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-10T20:13:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>KS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26346</th>\n",
" <td>3253</td>\n",
" <td>1.146934e+05</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-13T13:32:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>MT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26402</th>\n",
" <td>4369</td>\n",
" <td>9.582334e+04</td>\n",
" <td>SEVERE STORM</td>\n",
" <td>2018-06-08T19:05:00.000Z</td>\n",
" <td>Coastal Storm</td>\n",
" <td>AK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26403</th>\n",
" <td>3263</td>\n",
" <td>8.966181e+04</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-30T17:04:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>DE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26406</th>\n",
" <td>3329</td>\n",
" <td>7.424171e+04</td>\n",
" <td>HURRICANE IRENE</td>\n",
" <td>2011-08-26T23:07:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>VA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26436</th>\n",
" <td>3276</td>\n",
" <td>7.399165e+04</td>\n",
" <td>DROUGHT</td>\n",
" <td>2007-07-31T00:00:00.000Z</td>\n",
" <td>Drought</td>\n",
" <td>FM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26437</th>\n",
" <td>4147</td>\n",
" <td>7.256860e+04</td>\n",
" <td>SEVERE STORMS AND FLOODING</td>\n",
" <td>2013-09-27T18:55:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>NM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26438</th>\n",
" <td>3256</td>\n",
" <td>4.833297e+04</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-19T20:14:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>ME</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26453</th>\n",
" <td>3342</td>\n",
" <td>2.825780e+04</td>\n",
" <td>SEVERE STORM</td>\n",
" <td>2011-10-31T16:30:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>CT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26461</th>\n",
" <td>3247</td>\n",
" <td>2.284218e+04</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-13T13:34:00.000Z</td>\n",
" <td>Coastal Storm</td>\n",
" <td>ND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26514</th>\n",
" <td>3358</td>\n",
" <td>1.964554e+04</td>\n",
" <td>HURRICANE SANDY</td>\n",
" <td>2012-10-29T23:43:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>WV</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26569</th>\n",
" <td>3320</td>\n",
" <td>1.625069e+04</td>\n",
" <td>FLOODING</td>\n",
" <td>2011-05-04T20:00:00.000Z</td>\n",
" <td>Flood</td>\n",
" <td>MS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26583</th>\n",
" <td>3258</td>\n",
" <td>9.319830e+03</td>\n",
" <td>HURRICANE KATRINA EVACUATION</td>\n",
" <td>2005-09-19T20:14:00.000Z</td>\n",
" <td>Hurricane</td>\n",
" <td>NH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26593</th>\n",
" <td>4403</td>\n",
" <td>5.786420e+03</td>\n",
" <td>SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODI...</td>\n",
" <td>2018-10-19T09:55:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>KS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26601</th>\n",
" <td>3341</td>\n",
" <td>3.194360e+03</td>\n",
" <td>REMNANTS OF TROPICAL STORM LEE</td>\n",
" <td>2011-09-08T23:00:00.000Z</td>\n",
" <td>Severe Storm(s)</td>\n",
" <td>NY</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1290 rows × 6 columns</p>\n",
"</div>"
],
"text/plain": [
" disasterNumber federalObligatedAmount \\\n",
"0 4085 1.421109e+10 \n",
"14 1603 1.337269e+10 \n",
"78 4339 5.403489e+09 \n",
"156 1391 4.708614e+09 \n",
"218 1604 3.165230e+09 \n",
"300 1791 2.237904e+09 \n",
"351 4086 1.998818e+09 \n",
"372 4340 1.560988e+09 \n",
"375 1609 1.470563e+09 \n",
"395 4332 1.276638e+09 \n",
"448 1763 1.155439e+09 \n",
"533 1786 7.158877e+08 \n",
"597 1551 6.861587e+08 \n",
"642 1607 6.731933e+08 \n",
"706 1545 6.703622e+08 \n",
"773 4277 6.579002e+08 \n",
"799 1539 6.023289e+08 \n",
"866 4020 5.496055e+08 \n",
"898 3216 5.128452e+08 \n",
"1152 1561 5.116918e+08 \n",
"1205 4337 4.498723e+08 \n",
"1272 1379 4.277281e+08 \n",
"1303 1247 4.012971e+08 \n",
"1382 1606 3.632519e+08 \n",
"1636 4344 3.436517e+08 \n",
"1645 4145 3.426799e+08 \n",
"1663 4283 3.333026e+08 \n",
"1681 4080 3.302547e+08 \n",
"1736 4031 3.221933e+08 \n",
"1751 1292 2.927356e+08 \n",
"... ... ... \n",
"25764 3291 3.565304e+05 \n",
"25846 3257 3.449433e+05 \n",
"25867 4392 3.113375e+05 \n",
"25871 4383 3.046779e+05 \n",
"25877 3196 3.004999e+05 \n",
"25887 3126 2.828690e+05 \n",
"25889 1338 2.816553e+05 \n",
"25890 4312 2.699348e+05 \n",
"25891 3240 2.641134e+05 \n",
"26025 4123 2.399206e+05 \n",
"26026 3239 2.323832e+05 \n",
"26125 3234 2.089972e+05 \n",
"26191 3244 2.047991e+05 \n",
"26235 4133 1.733584e+05 \n",
"26236 3102 1.572907e+05 \n",
"26241 3236 1.549888e+05 \n",
"26346 3253 1.146934e+05 \n",
"26402 4369 9.582334e+04 \n",
"26403 3263 8.966181e+04 \n",
"26406 3329 7.424171e+04 \n",
"26436 3276 7.399165e+04 \n",
"26437 4147 7.256860e+04 \n",
"26438 3256 4.833297e+04 \n",
"26453 3342 2.825780e+04 \n",
"26461 3247 2.284218e+04 \n",
"26514 3358 1.964554e+04 \n",
"26569 3320 1.625069e+04 \n",
"26583 3258 9.319830e+03 \n",
"26593 4403 5.786420e+03 \n",
"26601 3341 3.194360e+03 \n",
"\n",
" title \\\n",
"0 HURRICANE SANDY \n",
"14 HURRICANE KATRINA \n",
"78 HURRICANE MARIA \n",
"156 FIRES AND EXPLOSIONS \n",
"218 HURRICANE KATRINA \n",
"300 HURRICANE IKE \n",
"351 HURRICANE SANDY \n",
"372 HURRICANE MARIA \n",
"375 HURRICANE WILMA \n",
"395 HURRICANE HARVEY \n",
"448 SEVERE STORMS, TORNADOES, AND FLOODING \n",
"533 HURRICANE GUSTAV \n",
"597 HURRICANE IVAN \n",
"642 HURRICANE RITA \n",
"706 HURRICANE FRANCES \n",
"773 SEVERE STORMS AND FLOODING \n",
"799 TROPICAL STORM BONNIE AND HURRICANE CHARLEY \n",
"866 HURRICANE IRENE \n",
"898 HURRICANE KATRINA EVACUATION \n",
"1152 HURRICANE JEANNE \n",
"1205 HURRICANE IRMA \n",
"1272 TX-TROPICAL STORM ALLISON-06-06-2001 \n",
"1303 HURRICANE GEORGES - 18 SEP 98 \n",
"1382 HURRICANE RITA \n",
"1636 WILDFIRES \n",
"1645 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSL... \n",
"1663 HURRICANE MATTHEW \n",
"1681 HURRICANE ISAAC \n",
"1736 REMNANTS OF TROPICAL STORM LEE \n",
"1751 HURRICANE FLOYD MAJOR DISASTER DECLARATIONS \n",
"... ... \n",
"25764 HURRICANE GUSTAV \n",
"25846 HURRICANE KATRINA EVACUATION \n",
"25867 SEVERE STORM AND TORNADOES \n",
"25871 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING \n",
"25877 SNOW \n",
"25887 DEBRUCE GRAIN ELEVATOR EXPLOSION (SEDGWICK CTY) \n",
"25889 SEVERE THUNDERSTORMS \n",
"25890 FLOODING \n",
"25891 HURRICANE KATRINA EVACUATION \n",
"26025 SEVERE STORMS AND FLOODING \n",
"26026 HURRICANE KATRINA EVACUATION \n",
"26125 HURRICANE KATRINA EVACUATION \n",
"26191 HURRICANE KATRINA \n",
"26235 ROYAL GORGE FIRE \n",
"26236 BLIZZARDS, HIGH WINDS & RECORD SNOWFALL \n",
"26241 HURRICANE KATRINA EVACUATION \n",
"26346 HURRICANE KATRINA EVACUATION \n",
"26402 SEVERE STORM \n",
"26403 HURRICANE KATRINA EVACUATION \n",
"26406 HURRICANE IRENE \n",
"26436 DROUGHT \n",
"26437 SEVERE STORMS AND FLOODING \n",
"26438 HURRICANE KATRINA EVACUATION \n",
"26453 SEVERE STORM \n",
"26461 HURRICANE KATRINA EVACUATION \n",
"26514 HURRICANE SANDY \n",
"26569 FLOODING \n",
"26583 HURRICANE KATRINA EVACUATION \n",
"26593 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODI... \n",
"26601 REMNANTS OF TROPICAL STORM LEE \n",
"\n",
" declarationDate incidentType state \n",
"0 2012-10-30T04:34:00.000Z Hurricane NY \n",
"14 2005-08-29T16:28:00.000Z Hurricane LA \n",
"78 2017-09-20T21:00:00.000Z Hurricane PR \n",
"156 2001-09-11T19:30:00.000Z Fire NY \n",
"218 2005-08-29T14:32:00.000Z Hurricane MS \n",
"300 2008-09-13T13:30:00.000Z Hurricane TX \n",
"351 2012-10-30T04:34:00.000Z Hurricane NJ \n",
"372 2017-09-20T22:30:00.000Z Hurricane VI \n",
"375 2005-10-24T10:39:00.000Z Hurricane FL \n",
"395 2017-08-25T21:35:00.000Z Hurricane TX \n",
"448 2008-05-27T10:30:00.000Z Severe Storm(s) IA \n",
"533 2008-09-02T20:00:00.000Z Hurricane LA \n",
"597 2004-09-16T15:00:00.000Z Hurricane FL \n",
"642 2005-09-24T19:49:00.000Z Hurricane LA \n",
"706 2004-09-04T19:00:00.000Z Hurricane FL \n",
"773 2016-08-14T18:45:00.000Z Flood LA \n",
"799 2004-08-13T17:30:00.000Z Hurricane FL \n",
"866 2011-08-31T04:30:00.000Z Hurricane NY \n",
"898 2005-09-02T12:51:00.000Z Hurricane TX \n",
"1152 2004-09-26T00:00:00.000Z Hurricane FL \n",
"1205 2017-09-10T14:45:00.000Z Hurricane FL \n",
"1272 2001-06-09T11:00:00.000Z Coastal Storm TX \n",
"1303 1998-09-24T16:00:00.000Z Hurricane PR \n",
"1382 2005-09-24T19:58:00.000Z Hurricane TX \n",
"1636 2017-10-10T12:40:00.000Z Fire CA \n",
"1645 2013-09-14T22:55:00.000Z Flood CO \n",
"1663 2016-10-08T20:53:00.000Z Hurricane FL \n",
"1681 2012-08-29T22:50:00.000Z Hurricane LA \n",
"1736 2011-09-13T17:00:00.000Z Severe Storm(s) NY \n",
"1751 1999-09-16T15:15:00.000Z Hurricane NC \n",
"... ... ... ... \n",
"25764 2008-08-30T15:30:00.000Z Hurricane MS \n",
"25846 2005-09-19T20:14:00.000Z Hurricane NJ \n",
"25867 2018-09-12T12:55:00.000Z Severe Storm(s) IA \n",
"25871 2018-08-10T16:30:00.000Z Flood WI \n",
"25877 2004-04-02T15:20:00.000Z Snow ND \n",
"25887 1998-06-09T00:00:00.000Z Other KS \n",
"25889 2000-08-17T13:55:00.000Z Severe Storm(s) DC \n",
"25890 2017-05-02T18:00:00.000Z Severe Storm(s) CA \n",
"25891 2005-09-12T15:34:00.000Z Hurricane VA \n",
"26025 2013-06-25T14:17:00.000Z Flood ND \n",
"26026 2005-09-10T20:20:00.000Z Hurricane IA \n",
"26125 2005-09-10T20:20:00.000Z Coastal Storm SD \n",
"26191 2005-09-13T13:34:00.000Z Hurricane ID \n",
"26235 2013-07-26T11:11:00.000Z Fire CO \n",
"26236 1993-03-16T00:00:00.000Z Snow RI \n",
"26241 2005-09-10T20:13:00.000Z Hurricane KS \n",
"26346 2005-09-13T13:32:00.000Z Hurricane MT \n",
"26402 2018-06-08T19:05:00.000Z Coastal Storm AK \n",
"26403 2005-09-30T17:04:00.000Z Hurricane DE \n",
"26406 2011-08-26T23:07:00.000Z Hurricane VA \n",
"26436 2007-07-31T00:00:00.000Z Drought FM \n",
"26437 2013-09-27T18:55:00.000Z Severe Storm(s) NM \n",
"26438 2005-09-19T20:14:00.000Z Hurricane ME \n",
"26453 2011-10-31T16:30:00.000Z Severe Storm(s) CT \n",
"26461 2005-09-13T13:34:00.000Z Coastal Storm ND \n",
"26514 2012-10-29T23:43:00.000Z Hurricane WV \n",
"26569 2011-05-04T20:00:00.000Z Flood MS \n",
"26583 2005-09-19T20:14:00.000Z Hurricane NH \n",
"26593 2018-10-19T09:55:00.000Z Severe Storm(s) KS \n",
"26601 2011-09-08T23:00:00.000Z Severe Storm(s) NY \n",
"\n",
"[1290 rows x 6 columns]"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"costliest = pd.DataFrame(pa.groupby(['disasterNumber'])['federalObligatedAmount'].sum().sort_values(ascending=False)).reset_index()\n",
"pd.merge(costliest,declarations[['disasterNumber', 'title', 'declarationDate', 'incidentType', 'state']],on='disasterNumber', how='inner').drop_duplicates(['disasterNumber'])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# FEMA funds used for terrorist attacks include 9/11 and the Boston bombings"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>13847</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>VIRGINIA DEPARTMENT OF STATE POLICE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>341725.42</td>\n",
" <td>5b8d3a93189b575c7de4b0967d5306a0</td>\n",
" <td>2018-02-07T18:48:58.740Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13849</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>VIRGINIA DEPT. OF EMERGENCY MANAGEMENT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>33097.45</td>\n",
" <td>60d7e7a10a20b0bf8a91f39adb4f4d67</td>\n",
" <td>2018-02-07T18:48:58.783Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13884</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>VIRGINIA DEPARTMENT OF ALCOHOLIC BEVERAGE CONTROL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>29650.94</td>\n",
" <td>de4bf6615d47cad2ba6471f431c4d733</td>\n",
" <td>2018-02-07T18:48:58.783Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13898</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Arlington</td>\n",
" <td>ARLINGTON (COUNTY)</td>\n",
" <td>0</td>\n",
" <td>47</td>\n",
" <td>4102358.35</td>\n",
" <td>362e006433b90870fadc298a6ccf7dd7</td>\n",
" <td>2018-02-07T18:48:58.745Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13910</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>VIRGINIA DEPARTMENT OF TRANSPORTATION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>103912.19</td>\n",
" <td>ae215926d5907cb6636f963942774844</td>\n",
" <td>2018-02-07T18:48:58.745Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13912</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>VIRGINIA DEPARTMENT OF HEALTH</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>20739.18</td>\n",
" <td>135726f9d47cddeb0cf0265852b18ae0</td>\n",
" <td>2018-02-07T18:48:58.748Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13915</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>VIRGINIA DEPT OF ENVIRONMENTAL QUALITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1309.72</td>\n",
" <td>abef0576d105337301795dad5dacef21</td>\n",
" <td>2018-02-07T18:48:58.719Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13924</th>\n",
" <td>1392</td>\n",
" <td>2001-09-21T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>METROPOLITAN WASHINGTON AIRPORT AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>177339.08</td>\n",
" <td>595cf360151d4bcaa326cdafed6c176a</td>\n",
" <td>2018-02-07T18:48:58.719Z</td>\n",
" <td>2001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121502</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>HOPKINTON (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1323.16</td>\n",
" <td>12ebc352ec1adf48ed15a334ee4c4646</td>\n",
" <td>2018-02-07T18:52:10.296Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121505</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MA DEPT. OF PUBLIC HEALTH</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3385.55</td>\n",
" <td>fd325dcd722677408896050088558887</td>\n",
" <td>2018-02-07T18:52:10.460Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121509</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Norfolk</td>\n",
" <td>BROOKLINE (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>25016.44</td>\n",
" <td>045c8d4112623a324d7d9a304f600576</td>\n",
" <td>2018-02-07T18:52:10.460Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121512</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>MOUNT AUBURN HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6032.54</td>\n",
" <td>cdab4936300dd31bd5413e5c184dc016</td>\n",
" <td>2018-02-07T18:52:10.461Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121514</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>GROTON (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1258.24</td>\n",
" <td>7160a56fe17ec01cf711a02811cbe7c1</td>\n",
" <td>2018-02-07T18:52:10.461Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121519</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>WATERTOWN (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>76101.95</td>\n",
" <td>f98bfe459e1c5b5b402a9c31fac1c2df</td>\n",
" <td>2018-02-07T18:52:10.462Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121521</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>HARVARD UNIVERSITY</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>50400.38</td>\n",
" <td>fe862b419b53fb4c1e22538e083449b7</td>\n",
" <td>2018-02-07T18:52:10.289Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121524</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>ARLINGTON (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>4632.36</td>\n",
" <td>f17507cc5eabf61f7f9eed2ef0ddee4d</td>\n",
" <td>2018-02-07T18:52:10.289Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121527</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Bristol</td>\n",
" <td>DARTMOUTH (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6164.76</td>\n",
" <td>5ec77d47f8ad48e6bfcb7a6b1ae29e27</td>\n",
" <td>2018-02-07T18:52:10.285Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121530</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>BELMONT (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>10552.66</td>\n",
" <td>47a3b989c395f22d55ecdff38c42caf8</td>\n",
" <td>2018-02-07T18:52:10.295Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121535</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Norfolk</td>\n",
" <td>WELLESLEY (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>5042.55</td>\n",
" <td>e77535429e0d1a6dd7ee2338fa8f2f6e</td>\n",
" <td>2018-02-07T18:52:10.462Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121537</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>TRUSTEES OF BOSTON COLLEGE</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>20098.60</td>\n",
" <td>6b8740844ba334c5635d931827baca26</td>\n",
" <td>2018-02-07T18:52:10.459Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121540</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>BOSTON PUBLIC HEALTH COMMISSION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>54785.05</td>\n",
" <td>bd97c53ec5ff3cb5145745ab5da38dfe</td>\n",
" <td>2018-02-07T18:52:10.290Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121541</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Bristol</td>\n",
" <td>NEW BEDFORD</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>4339.10</td>\n",
" <td>8651190efb001e2a506fb562bd9d727a</td>\n",
" <td>2018-02-07T18:52:10.461Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121542</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>MASSACHUSETTS INSTITUTE-TECH</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>57553.18</td>\n",
" <td>96e9866083b1b415b86dc318267a2bb1</td>\n",
" <td>2018-02-07T18:52:10.286Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121543</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MA DEPT. OF FIRE SERVICES</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3657.80</td>\n",
" <td>36bac01c60980c911eded32452db64d2</td>\n",
" <td>2018-02-07T18:52:10.296Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121548</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>CAMBRIDGE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>133437.51</td>\n",
" <td>04a9fb49e018b35cadbf07be44d15a8c</td>\n",
" <td>2018-02-07T18:52:10.285Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121555</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Bristol</td>\n",
" <td>DARTMOUTH FIRE DISTRICT NO. 3</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2050.27</td>\n",
" <td>a0220d53d82faa9648ba9cd755d350e6</td>\n",
" <td>2018-02-07T18:52:10.287Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121556</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Norfolk</td>\n",
" <td>BETH ISRAEL DEACONESS HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3748.74</td>\n",
" <td>e017aa5cece9e15722e426e7723a3002</td>\n",
" <td>2018-02-07T18:52:10.296Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121559</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>MCLEAN HOSPITAL CORPORATION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3302.71</td>\n",
" <td>1c6cb933a5240f31ad305fa5ef9ee9c7</td>\n",
" <td>2018-02-07T18:52:10.287Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121560</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>NORTH READING (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1008.18</td>\n",
" <td>fa9b77a847611e3f7a4cdc2700344473</td>\n",
" <td>2018-02-07T18:52:10.296Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121561</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>CAMBRIDGE HEALTH DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1926.08</td>\n",
" <td>4037b5f15128b5eba26837fc792b92ea</td>\n",
" <td>2018-02-07T18:52:10.287Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121563</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Norfolk</td>\n",
" <td>SOUTH SHORE HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>5989.01</td>\n",
" <td>c164de58da9d2b590a93c03e2cdcde2e</td>\n",
" <td>2018-02-07T18:52:10.288Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121564</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>NEWTON-WELLESLEY HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1861.55</td>\n",
" <td>fd1e769ceae2c8c78689f16d8d14ccf3</td>\n",
" <td>2018-02-07T18:52:10.290Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121567</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>WALTHAM</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>17289.56</td>\n",
" <td>3f3de3ee93e9d9dfd50d09ccdcd366b6</td>\n",
" <td>2018-02-07T18:52:10.288Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121568</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Middlesex</td>\n",
" <td>WOBURN</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>18014.57</td>\n",
" <td>8561ca3a94d083da307b08dc19aa1e04</td>\n",
" <td>2018-02-07T18:52:10.290Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121571</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MA DEPT. OF STATE POLICE</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>1152041.13</td>\n",
" <td>80155fca0b2bf70dc522abc68148805f</td>\n",
" <td>2018-02-07T18:52:10.477Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121572</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>BOSTON MEDICAL CENTER</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>7458.49</td>\n",
" <td>c6e3686c0f0ac10301ba7deb3b639129</td>\n",
" <td>2018-02-07T18:52:10.502Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121573</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>TUFTS MEDICAL CENTER</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>11447.96</td>\n",
" <td>add49aae699fefe745ef803937b866e2</td>\n",
" <td>2018-02-07T18:52:10.478Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121574</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MASS PORT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>311817.26</td>\n",
" <td>77bb6e4da8fe22bf39b210ede589094c</td>\n",
" <td>2018-02-07T18:52:10.497Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121575</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>BETH ISRAEL DEACONESS MEDICAL CENTER</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>26687.39</td>\n",
" <td>c85957944d2cc0e87e7f5bfcd2acecc4</td>\n",
" <td>2018-02-07T18:52:10.528Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121577</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MASSACHUSETTS NATIONAL GUARD</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>599976.82</td>\n",
" <td>f846c51830b55953eec9f3384e39325d</td>\n",
" <td>2018-02-07T18:52:10.502Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121580</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>BOSTON HOUSING AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>7897.23</td>\n",
" <td>3ca98ffa80945c456cfe6bc870556cc8</td>\n",
" <td>2018-02-07T18:52:10.477Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121582</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MA DEPT. OF TRANSPORTATION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>10341.98</td>\n",
" <td>3d07cca44320232716d961ef78482490</td>\n",
" <td>2018-02-07T18:52:10.501Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121583</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>MASS GENERAL HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>24856.76</td>\n",
" <td>5e6bf6af8d1e2d9345d7875d84c16cd5</td>\n",
" <td>2018-02-07T18:52:10.494Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121585</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>BOSTON</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>2990874.86</td>\n",
" <td>028112f4da29179e4724f8d9cb91eb00</td>\n",
" <td>2018-02-07T18:52:10.497Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121586</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>BRIGHAM &amp; WOMENS HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1186.91</td>\n",
" <td>e8b5d1a443f4e413169a3ea9b71e7714</td>\n",
" <td>2018-02-07T18:52:10.493Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121590</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>FRANCISCAN CHILDREN'S HOSP/REHAB CTR.</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0.00</td>\n",
" <td>df3747a5655c0f9433f13924d57bec29</td>\n",
" <td>2018-02-07T18:52:10.502Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121591</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MA DEPT. OF CONSERVATION &amp; RECREATION- STATE PKS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>4387.37</td>\n",
" <td>80620f10928f701eb4fe048365e79b32</td>\n",
" <td>2018-02-07T18:52:10.493Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121592</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>BRIGHAM AND WOMEN'S FAULKNER HOSPITAL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3149.53</td>\n",
" <td>29b69ede7bd0f5199d71f827611672b5</td>\n",
" <td>2018-02-07T18:52:10.529Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121594</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>MASSACHUSETTS BAY TRANSPORTATION AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>386285.15</td>\n",
" <td>67940211b10c92068748068ff64c8f51</td>\n",
" <td>2018-02-07T18:52:10.498Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121596</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MA DEPT. OF ENVIRONMENTAL LAW ENFORCEMENT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>43144.79</td>\n",
" <td>0fcec00931ea6b24779e564c35c0d309</td>\n",
" <td>2018-02-07T18:52:10.528Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121608</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>CHILDRENS HOSPITAL BOSTON</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>14756.31</td>\n",
" <td>65d057d08867b9eb8bdd47775ecbf2e1</td>\n",
" <td>2018-02-07T18:52:10.478Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121609</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>MASSACHUSETTS EMERGENCY MANAGEMENT AGENCY</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>62738.70</td>\n",
" <td>a13b8de0617e806e56f56ab094a76b7b</td>\n",
" <td>2018-02-07T18:52:10.477Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121610</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Statewide</td>\n",
" <td>UNIVERSITY OF MASSACHUSETTS</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>12682.34</td>\n",
" <td>a4c8a3d8c99044d7bb511947f6879d4f</td>\n",
" <td>2018-02-07T18:52:10.493Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121620</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>CHELSEA</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1780.94</td>\n",
" <td>ac93ffdab54fd049da98854aaccf0a81</td>\n",
" <td>2018-02-07T18:52:10.497Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121631</th>\n",
" <td>3362</td>\n",
" <td>2013-04-17T00:00:00.000Z</td>\n",
" <td>Terrorist</td>\n",
" <td>Massachusetts</td>\n",
" <td>Suffolk</td>\n",
" <td>MASS. EYE &amp; EAR INFIRMARY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2721.38</td>\n",
" <td>7e50df325d3ee8a522c93e88de252e4e</td>\n",
" <td>2018-02-07T18:52:10.529Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType state \\\n",
"13847 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13849 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13884 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13898 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13910 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13912 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13915 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"13924 1392 2001-09-21T00:00:00.000Z Terrorist Virginia \n",
"121502 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121505 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121509 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121512 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121514 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121519 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121521 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121524 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121527 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121530 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121535 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121537 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121540 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121541 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121542 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121543 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121548 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121555 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121556 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121559 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121560 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121561 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121563 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121564 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121567 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121568 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121571 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121572 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121573 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121574 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121575 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121577 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121580 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121582 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121583 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121585 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121586 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121590 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121591 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121592 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121594 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121596 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121608 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121609 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121610 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121620 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"121631 3362 2013-04-17T00:00:00.000Z Terrorist Massachusetts \n",
"\n",
" county applicantName \\\n",
"13847 Statewide VIRGINIA DEPARTMENT OF STATE POLICE \n",
"13849 Statewide VIRGINIA DEPT. OF EMERGENCY MANAGEMENT \n",
"13884 Statewide VIRGINIA DEPARTMENT OF ALCOHOLIC BEVERAGE CONTROL \n",
"13898 Arlington ARLINGTON (COUNTY) \n",
"13910 Statewide VIRGINIA DEPARTMENT OF TRANSPORTATION \n",
"13912 Statewide VIRGINIA DEPARTMENT OF HEALTH \n",
"13915 Statewide VIRGINIA DEPT OF ENVIRONMENTAL QUALITY \n",
"13924 Statewide METROPOLITAN WASHINGTON AIRPORT AUTHORITY \n",
"121502 Middlesex HOPKINTON (TOWN OF) \n",
"121505 Statewide MA DEPT. OF PUBLIC HEALTH \n",
"121509 Norfolk BROOKLINE (TOWN OF) \n",
"121512 Middlesex MOUNT AUBURN HOSPITAL \n",
"121514 Middlesex GROTON (TOWN OF) \n",
"121519 Middlesex WATERTOWN (TOWN OF) \n",
"121521 Middlesex HARVARD UNIVERSITY \n",
"121524 Middlesex ARLINGTON (TOWN OF) \n",
"121527 Bristol DARTMOUTH (TOWN OF) \n",
"121530 Middlesex BELMONT (TOWN OF) \n",
"121535 Norfolk WELLESLEY (TOWN OF) \n",
"121537 Middlesex TRUSTEES OF BOSTON COLLEGE \n",
"121540 Statewide BOSTON PUBLIC HEALTH COMMISSION \n",
"121541 Bristol NEW BEDFORD \n",
"121542 Middlesex MASSACHUSETTS INSTITUTE-TECH \n",
"121543 Statewide MA DEPT. OF FIRE SERVICES \n",
"121548 Middlesex CAMBRIDGE \n",
"121555 Bristol DARTMOUTH FIRE DISTRICT NO. 3 \n",
"121556 Norfolk BETH ISRAEL DEACONESS HOSPITAL \n",
"121559 Middlesex MCLEAN HOSPITAL CORPORATION \n",
"121560 Middlesex NORTH READING (TOWN OF) \n",
"121561 Middlesex CAMBRIDGE HEALTH DEPT \n",
"121563 Norfolk SOUTH SHORE HOSPITAL \n",
"121564 Middlesex NEWTON-WELLESLEY HOSPITAL \n",
"121567 Middlesex WALTHAM \n",
"121568 Middlesex WOBURN \n",
"121571 Statewide MA DEPT. OF STATE POLICE \n",
"121572 Suffolk BOSTON MEDICAL CENTER \n",
"121573 Suffolk TUFTS MEDICAL CENTER \n",
"121574 Statewide MASS PORT \n",
"121575 Suffolk BETH ISRAEL DEACONESS MEDICAL CENTER \n",
"121577 Statewide MASSACHUSETTS NATIONAL GUARD \n",
"121580 Suffolk BOSTON HOUSING AUTHORITY \n",
"121582 Statewide MA DEPT. OF TRANSPORTATION \n",
"121583 Suffolk MASS GENERAL HOSPITAL \n",
"121585 Suffolk BOSTON \n",
"121586 Suffolk BRIGHAM & WOMENS HOSPITAL \n",
"121590 Suffolk FRANCISCAN CHILDREN'S HOSP/REHAB CTR. \n",
"121591 Statewide MA DEPT. OF CONSERVATION & RECREATION- STATE PKS \n",
"121592 Suffolk BRIGHAM AND WOMEN'S FAULKNER HOSPITAL \n",
"121594 Suffolk MASSACHUSETTS BAY TRANSPORTATION AUTHORITY \n",
"121596 Statewide MA DEPT. OF ENVIRONMENTAL LAW ENFORCEMENT \n",
"121608 Suffolk CHILDRENS HOSPITAL BOSTON \n",
"121609 Statewide MASSACHUSETTS EMERGENCY MANAGEMENT AGENCY \n",
"121610 Statewide UNIVERSITY OF MASSACHUSETTS \n",
"121620 Suffolk CHELSEA \n",
"121631 Suffolk MASS. EYE & EAR INFIRMARY \n",
"\n",
" educationApplicant numberOfProjects federalObligatedAmount \\\n",
"13847 0 1 341725.42 \n",
"13849 0 2 33097.45 \n",
"13884 0 1 29650.94 \n",
"13898 0 47 4102358.35 \n",
"13910 0 1 103912.19 \n",
"13912 0 1 20739.18 \n",
"13915 0 1 1309.72 \n",
"13924 0 2 177339.08 \n",
"121502 0 1 1323.16 \n",
"121505 0 1 3385.55 \n",
"121509 0 1 25016.44 \n",
"121512 0 1 6032.54 \n",
"121514 0 1 1258.24 \n",
"121519 0 1 76101.95 \n",
"121521 1 1 50400.38 \n",
"121524 0 1 4632.36 \n",
"121527 0 1 6164.76 \n",
"121530 0 1 10552.66 \n",
"121535 0 1 5042.55 \n",
"121537 1 1 20098.60 \n",
"121540 0 1 54785.05 \n",
"121541 0 1 4339.10 \n",
"121542 1 1 57553.18 \n",
"121543 0 1 3657.80 \n",
"121548 0 1 133437.51 \n",
"121555 0 1 2050.27 \n",
"121556 0 1 3748.74 \n",
"121559 0 1 3302.71 \n",
"121560 0 1 1008.18 \n",
"121561 0 1 1926.08 \n",
"121563 0 1 5989.01 \n",
"121564 0 1 1861.55 \n",
"121567 0 1 17289.56 \n",
"121568 0 1 18014.57 \n",
"121571 0 2 1152041.13 \n",
"121572 0 1 7458.49 \n",
"121573 0 1 11447.96 \n",
"121574 0 1 311817.26 \n",
"121575 0 1 26687.39 \n",
"121577 0 1 599976.82 \n",
"121580 0 1 7897.23 \n",
"121582 0 1 10341.98 \n",
"121583 0 1 24856.76 \n",
"121585 0 3 2990874.86 \n",
"121586 0 1 1186.91 \n",
"121590 0 1 0.00 \n",
"121591 0 1 4387.37 \n",
"121592 0 1 3149.53 \n",
"121594 0 1 386285.15 \n",
"121596 0 1 43144.79 \n",
"121608 0 1 14756.31 \n",
"121609 0 2 62738.70 \n",
"121610 1 1 12682.34 \n",
"121620 0 1 1780.94 \n",
"121631 0 1 2721.38 \n",
"\n",
" hash lastRefresh year \n",
"13847 5b8d3a93189b575c7de4b0967d5306a0 2018-02-07T18:48:58.740Z 2001 \n",
"13849 60d7e7a10a20b0bf8a91f39adb4f4d67 2018-02-07T18:48:58.783Z 2001 \n",
"13884 de4bf6615d47cad2ba6471f431c4d733 2018-02-07T18:48:58.783Z 2001 \n",
"13898 362e006433b90870fadc298a6ccf7dd7 2018-02-07T18:48:58.745Z 2001 \n",
"13910 ae215926d5907cb6636f963942774844 2018-02-07T18:48:58.745Z 2001 \n",
"13912 135726f9d47cddeb0cf0265852b18ae0 2018-02-07T18:48:58.748Z 2001 \n",
"13915 abef0576d105337301795dad5dacef21 2018-02-07T18:48:58.719Z 2001 \n",
"13924 595cf360151d4bcaa326cdafed6c176a 2018-02-07T18:48:58.719Z 2001 \n",
"121502 12ebc352ec1adf48ed15a334ee4c4646 2018-02-07T18:52:10.296Z 2013 \n",
"121505 fd325dcd722677408896050088558887 2018-02-07T18:52:10.460Z 2013 \n",
"121509 045c8d4112623a324d7d9a304f600576 2018-02-07T18:52:10.460Z 2013 \n",
"121512 cdab4936300dd31bd5413e5c184dc016 2018-02-07T18:52:10.461Z 2013 \n",
"121514 7160a56fe17ec01cf711a02811cbe7c1 2018-02-07T18:52:10.461Z 2013 \n",
"121519 f98bfe459e1c5b5b402a9c31fac1c2df 2018-02-07T18:52:10.462Z 2013 \n",
"121521 fe862b419b53fb4c1e22538e083449b7 2018-02-07T18:52:10.289Z 2013 \n",
"121524 f17507cc5eabf61f7f9eed2ef0ddee4d 2018-02-07T18:52:10.289Z 2013 \n",
"121527 5ec77d47f8ad48e6bfcb7a6b1ae29e27 2018-02-07T18:52:10.285Z 2013 \n",
"121530 47a3b989c395f22d55ecdff38c42caf8 2018-02-07T18:52:10.295Z 2013 \n",
"121535 e77535429e0d1a6dd7ee2338fa8f2f6e 2018-02-07T18:52:10.462Z 2013 \n",
"121537 6b8740844ba334c5635d931827baca26 2018-02-07T18:52:10.459Z 2013 \n",
"121540 bd97c53ec5ff3cb5145745ab5da38dfe 2018-02-07T18:52:10.290Z 2013 \n",
"121541 8651190efb001e2a506fb562bd9d727a 2018-02-07T18:52:10.461Z 2013 \n",
"121542 96e9866083b1b415b86dc318267a2bb1 2018-02-07T18:52:10.286Z 2013 \n",
"121543 36bac01c60980c911eded32452db64d2 2018-02-07T18:52:10.296Z 2013 \n",
"121548 04a9fb49e018b35cadbf07be44d15a8c 2018-02-07T18:52:10.285Z 2013 \n",
"121555 a0220d53d82faa9648ba9cd755d350e6 2018-02-07T18:52:10.287Z 2013 \n",
"121556 e017aa5cece9e15722e426e7723a3002 2018-02-07T18:52:10.296Z 2013 \n",
"121559 1c6cb933a5240f31ad305fa5ef9ee9c7 2018-02-07T18:52:10.287Z 2013 \n",
"121560 fa9b77a847611e3f7a4cdc2700344473 2018-02-07T18:52:10.296Z 2013 \n",
"121561 4037b5f15128b5eba26837fc792b92ea 2018-02-07T18:52:10.287Z 2013 \n",
"121563 c164de58da9d2b590a93c03e2cdcde2e 2018-02-07T18:52:10.288Z 2013 \n",
"121564 fd1e769ceae2c8c78689f16d8d14ccf3 2018-02-07T18:52:10.290Z 2013 \n",
"121567 3f3de3ee93e9d9dfd50d09ccdcd366b6 2018-02-07T18:52:10.288Z 2013 \n",
"121568 8561ca3a94d083da307b08dc19aa1e04 2018-02-07T18:52:10.290Z 2013 \n",
"121571 80155fca0b2bf70dc522abc68148805f 2018-02-07T18:52:10.477Z 2013 \n",
"121572 c6e3686c0f0ac10301ba7deb3b639129 2018-02-07T18:52:10.502Z 2013 \n",
"121573 add49aae699fefe745ef803937b866e2 2018-02-07T18:52:10.478Z 2013 \n",
"121574 77bb6e4da8fe22bf39b210ede589094c 2018-02-07T18:52:10.497Z 2013 \n",
"121575 c85957944d2cc0e87e7f5bfcd2acecc4 2018-02-07T18:52:10.528Z 2013 \n",
"121577 f846c51830b55953eec9f3384e39325d 2018-02-07T18:52:10.502Z 2013 \n",
"121580 3ca98ffa80945c456cfe6bc870556cc8 2018-02-07T18:52:10.477Z 2013 \n",
"121582 3d07cca44320232716d961ef78482490 2018-02-07T18:52:10.501Z 2013 \n",
"121583 5e6bf6af8d1e2d9345d7875d84c16cd5 2018-02-07T18:52:10.494Z 2013 \n",
"121585 028112f4da29179e4724f8d9cb91eb00 2018-02-07T18:52:10.497Z 2013 \n",
"121586 e8b5d1a443f4e413169a3ea9b71e7714 2018-02-07T18:52:10.493Z 2013 \n",
"121590 df3747a5655c0f9433f13924d57bec29 2018-02-07T18:52:10.502Z 2013 \n",
"121591 80620f10928f701eb4fe048365e79b32 2018-02-07T18:52:10.493Z 2013 \n",
"121592 29b69ede7bd0f5199d71f827611672b5 2018-02-07T18:52:10.529Z 2013 \n",
"121594 67940211b10c92068748068ff64c8f51 2018-02-07T18:52:10.498Z 2013 \n",
"121596 0fcec00931ea6b24779e564c35c0d309 2018-02-07T18:52:10.528Z 2013 \n",
"121608 65d057d08867b9eb8bdd47775ecbf2e1 2018-02-07T18:52:10.478Z 2013 \n",
"121609 a13b8de0617e806e56f56ab094a76b7b 2018-02-07T18:52:10.477Z 2013 \n",
"121610 a4c8a3d8c99044d7bb511947f6879d4f 2018-02-07T18:52:10.493Z 2013 \n",
"121620 ac93ffdab54fd049da98854aaccf0a81 2018-02-07T18:52:10.497Z 2013 \n",
"121631 7e50df325d3ee8a522c93e88de252e4e 2018-02-07T18:52:10.529Z 2013 "
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Terrorist']"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 1992 Pawtucket contaminated water \n",
"https://www.nytimes.com/1992/08/16/us/tainted-water-forces-hardship-on-pawtucket-ri.html"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>92566</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>RHODE ISLAND EMERGENCY MGMT. AGENCY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1159.50</td>\n",
" <td>4bdde76777b63a3945f523fd0220dadd</td>\n",
" <td>2018-02-07T18:51:19.103Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92576</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>CENTRAL FALLS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>13526.84</td>\n",
" <td>4c312dabb03165e130373f8c30f2a535</td>\n",
" <td>2018-02-07T18:51:19.102Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92590</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>R.I. NATIONAL GUARD</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>25460.30</td>\n",
" <td>7b0a67d49f8af45213128605d7608ab4</td>\n",
" <td>2018-02-07T18:51:19.130Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92617</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>RI DEPT OF HEALTH</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>49718.36</td>\n",
" <td>c0dd0d16717288db82d51e0535725cb9</td>\n",
" <td>2018-02-07T18:51:19.137Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92626</th>\n",
" <td>3080</td>\n",
" <td>1980-05-21T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>New York</td>\n",
" <td>NaN</td>\n",
" <td>NYSDOT-RELOCATION PROGRAM</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>1307860.00</td>\n",
" <td>4af42216babf89dd7bdf8d0bca45b350</td>\n",
" <td>2018-02-07T18:51:19.129Z</td>\n",
" <td>1980</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92639</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>CUMBERLAND (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>96988.79</td>\n",
" <td>af8a75e0b65734961f1f4048b8d5d5f4</td>\n",
" <td>2018-02-07T18:51:19.136Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92652</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>NORTH KINGSTOWN (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>594162.14</td>\n",
" <td>dad7c6a10c04dd283ab624838ee7bfe8</td>\n",
" <td>2018-02-07T18:51:19.140Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92704</th>\n",
" <td>3094</td>\n",
" <td>1992-09-16T00:00:00.000Z</td>\n",
" <td>Toxic Substances</td>\n",
" <td>Rhode Island</td>\n",
" <td>NaN</td>\n",
" <td>PAWTUCKET</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>1023200.88</td>\n",
" <td>2624dca55c616772d5ad30c3a7ea7554</td>\n",
" <td>2018-02-07T18:51:19.089Z</td>\n",
" <td>1992</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType \\\n",
"92566 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"92576 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"92590 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"92617 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"92626 3080 1980-05-21T00:00:00.000Z Toxic Substances \n",
"92639 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"92652 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"92704 3094 1992-09-16T00:00:00.000Z Toxic Substances \n",
"\n",
" state county applicantName \\\n",
"92566 Rhode Island NaN RHODE ISLAND EMERGENCY MGMT. AGENCY \n",
"92576 Rhode Island NaN CENTRAL FALLS \n",
"92590 Rhode Island NaN R.I. NATIONAL GUARD \n",
"92617 Rhode Island NaN RI DEPT OF HEALTH \n",
"92626 New York NaN NYSDOT-RELOCATION PROGRAM \n",
"92639 Rhode Island NaN CUMBERLAND (TOWN OF) \n",
"92652 Rhode Island NaN NORTH KINGSTOWN (TOWN OF) \n",
"92704 Rhode Island NaN PAWTUCKET \n",
"\n",
" educationApplicant numberOfProjects federalObligatedAmount \\\n",
"92566 0 1 1159.50 \n",
"92576 0 1 13526.84 \n",
"92590 0 1 25460.30 \n",
"92617 0 2 49718.36 \n",
"92626 0 6 1307860.00 \n",
"92639 0 4 96988.79 \n",
"92652 0 3 594162.14 \n",
"92704 0 4 1023200.88 \n",
"\n",
" hash lastRefresh year \n",
"92566 4bdde76777b63a3945f523fd0220dadd 2018-02-07T18:51:19.103Z 1992 \n",
"92576 4c312dabb03165e130373f8c30f2a535 2018-02-07T18:51:19.102Z 1992 \n",
"92590 7b0a67d49f8af45213128605d7608ab4 2018-02-07T18:51:19.130Z 1992 \n",
"92617 c0dd0d16717288db82d51e0535725cb9 2018-02-07T18:51:19.137Z 1992 \n",
"92626 4af42216babf89dd7bdf8d0bca45b350 2018-02-07T18:51:19.129Z 1980 \n",
"92639 af8a75e0b65734961f1f4048b8d5d5f4 2018-02-07T18:51:19.136Z 1992 \n",
"92652 dad7c6a10c04dd283ab624838ee7bfe8 2018-02-07T18:51:19.140Z 1992 \n",
"92704 2624dca55c616772d5ad30c3a7ea7554 2018-02-07T18:51:19.089Z 1992 "
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Toxic Substances']"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 2014 West Virginia Elk River chemical spill"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>121593</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>CHARLESTON</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>34894.70</td>\n",
" <td>dc2b0c35d301e1c3228649153143e1ad</td>\n",
" <td>2018-02-07T18:52:10.480Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121598</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>HURRICANE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>12448.49</td>\n",
" <td>400fc2150c2dfc0d8d90a60c45dda30a</td>\n",
" <td>2018-02-07T18:52:10.481Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121601</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>LINCOLN COUNTY BOARD-EDUCATION</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>12197.86</td>\n",
" <td>d15928669df8cc2633e8b374003d887d</td>\n",
" <td>2018-02-07T18:52:10.481Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121603</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>SOUTH CHARLESTON</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>57224.63</td>\n",
" <td>a298dbaf862571f71d61f3258d45a412</td>\n",
" <td>2018-02-07T18:52:10.527Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121605</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>WEST HAMLIN VOL FIRE DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2598.17</td>\n",
" <td>ff1dd9f24e041cccc943996c743ab234</td>\n",
" <td>2018-02-07T18:52:10.481Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121606</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>WEST HAMLIN</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3806.42</td>\n",
" <td>1648840f50c2eae38c2a9be48f0db975</td>\n",
" <td>2018-02-07T18:52:10.500Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121607</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>KANAWHA COUNTY METRO 911</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>10945.39</td>\n",
" <td>6593b6fd3f6c834da4cbab8425fa727b</td>\n",
" <td>2018-02-07T18:52:10.531Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121611</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Boone</td>\n",
" <td>BOONE COUNTY BOARD OF EDUCATION</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>12525.01</td>\n",
" <td>d9495ed8dba60c8c600b3db555c7fcda</td>\n",
" <td>2018-02-07T18:52:10.499Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121612</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>DUNBAR</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2135.93</td>\n",
" <td>7adbd0961ced60adf68582c29a5dd6b9</td>\n",
" <td>2018-02-07T18:52:10.531Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121614</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>CHARLESTON AREA MEDICAL CTR</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>109241.51</td>\n",
" <td>2a8361058350699d271ff5c6d633f795</td>\n",
" <td>2018-02-07T18:52:10.526Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121615</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>NITRO</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>16176.38</td>\n",
" <td>d47390f83cc650761916abfc82152698</td>\n",
" <td>2018-02-07T18:52:10.480Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121617</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>HERBERT J. THOMAS MEMORIAL HOSPITAL ASSOCIATION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>34989.05</td>\n",
" <td>660e4bb01dc6cc713e1682f61b47dfb4</td>\n",
" <td>2018-02-07T18:52:10.500Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121619</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>LINCOLN (COUNTY)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>14497.75</td>\n",
" <td>49f6947a92bf2786bc4cf81da404a506</td>\n",
" <td>2018-02-07T18:52:10.500Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121621</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>LINCOLN COUNTY HEALTH DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1863.91</td>\n",
" <td>4bee4e601549be6105df4658485c465b</td>\n",
" <td>2018-02-07T18:52:10.527Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121622</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Boone</td>\n",
" <td>DANVILLE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3167.01</td>\n",
" <td>57451d7c7ba0ee5698e12ae15e3d3c46</td>\n",
" <td>2018-02-07T18:52:10.480Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121623</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>HAMLIN VOLUNTEER FIRE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6217.25</td>\n",
" <td>0773364fa174589dd7a8d74737d9688e</td>\n",
" <td>2018-02-07T18:52:10.566Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121625</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>BANCROFT VOLUNTEER FIRE DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3372.60</td>\n",
" <td>4d935d7d10b115aac48a00cd0156506a</td>\n",
" <td>2018-02-07T18:52:10.527Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121626</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>LINCOLN PUBLIC SERVICE DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>19642.31</td>\n",
" <td>13564d6f09a093132a53770cea44e116</td>\n",
" <td>2018-02-07T18:52:10.566Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121628</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>PUTNAM PUBLIC SERVICE DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1070.63</td>\n",
" <td>c468d614bd53b912e279ebd966f3415a</td>\n",
" <td>2018-02-07T18:52:10.528Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121629</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>HURRICANE VOLUNTEER FIRE DEPARTMENT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2958.34</td>\n",
" <td>ec1e63e9a68f500640653ff5c3e00a66</td>\n",
" <td>2018-02-07T18:52:10.527Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121630</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Boone</td>\n",
" <td>BOONE COUNTY AMBULANCE AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3210.70</td>\n",
" <td>490e4025c8bef92923f0b9d51c4a10ae</td>\n",
" <td>2018-02-07T18:52:10.530Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121633</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>KANAWHA COUNTY AMBULANCE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>27318.78</td>\n",
" <td>94a16aa8754dce0c0689a5d00e6c279b</td>\n",
" <td>2018-02-07T18:52:10.526Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121634</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Cabell</td>\n",
" <td>FACING HUNGER FOOD BANK (HUNTINGTON AREA FOOD B)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>914.26</td>\n",
" <td>b0331bbf45230aa0b559d6732be1ff98</td>\n",
" <td>2018-02-07T18:52:10.499Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121635</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WEST VIRGINIA BUREAU FOR PUBLIC HEALTH</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>25744.51</td>\n",
" <td>44d3e61d818d4af613aa3cdb9a74b49f</td>\n",
" <td>2018-02-07T18:52:10.532Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121636</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>KANAWHA (COUNTY)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>180647.37</td>\n",
" <td>576188a73d7a9eca21997720442e26fc</td>\n",
" <td>2018-02-07T18:52:10.480Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121637</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>PUTNAM COUNTY EMERGENCY MEDICAL SERVICES</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>5970.12</td>\n",
" <td>0e00c3c5936269061173457fae3469d6</td>\n",
" <td>2018-02-07T18:52:10.532Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121640</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>ELEANOR VOLUNTEER FIRE DEPARTMENT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2075.50</td>\n",
" <td>e628cf2bccdf71e4a43d99ea2dca5b8a</td>\n",
" <td>2018-02-07T18:52:10.501Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121641</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV DIVISION OF HOMELAND SECURITY</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>283084.22</td>\n",
" <td>859a676a23252b26e97fbff69b64b50e</td>\n",
" <td>2018-02-07T18:52:10.532Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121642</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Cabell</td>\n",
" <td>CABELL COUNTY EMERGENCY SERVICES</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6739.48</td>\n",
" <td>70bbfe171035b9e40520d0f5d19c2742</td>\n",
" <td>2018-02-07T18:52:10.531Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121643</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Boone</td>\n",
" <td>MADISON</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3304.22</td>\n",
" <td>8d1da9a42bfc303a90165cc68ff49177</td>\n",
" <td>2018-02-07T18:52:10.526Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121644</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>KANAWHA-CHARLESTON HEALTH DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>20731.28</td>\n",
" <td>f7a3b6a57279163e1f8baaf2139f325f</td>\n",
" <td>2018-02-07T18:52:10.500Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121645</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV DIVISION OF HIGHWAYS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>178178.18</td>\n",
" <td>4247a19db366d54dd5ad914ab55da554</td>\n",
" <td>2018-02-07T18:52:10.521Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121646</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>POCA VOLUNTEER FIRE DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>9787.44</td>\n",
" <td>a4ed87ce0624b338fc27deaffabe599d</td>\n",
" <td>2018-02-07T18:52:10.520Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121647</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Boone</td>\n",
" <td>RACINE VOLUNTEER FIRE DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>4590.84</td>\n",
" <td>3dcbc41552b23a0fd89856183ce9bd35</td>\n",
" <td>2018-02-07T18:52:10.495Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121648</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>BUFFALO</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3683.37</td>\n",
" <td>76f6780ab2ec473137b94871f290e035</td>\n",
" <td>2018-02-07T18:52:10.519Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121650</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>CHARLESTON HOSPITAL, INC. DBA ST. FRANCIS HOSP...</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>12654.08</td>\n",
" <td>83120e0460122e19184b05ff4616f0be</td>\n",
" <td>2018-02-07T18:52:10.496Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121651</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>OFFICE OF THE ADJUTANT GENERAL, STATE OF WV</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>288601.22</td>\n",
" <td>4b7e21fa34c39941dc35f16475d129a3</td>\n",
" <td>2018-02-07T18:52:10.521Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121660</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Boone</td>\n",
" <td>BOONE (COUNTY)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>45281.58</td>\n",
" <td>a5a76921a275bb4530a070098e811e37</td>\n",
" <td>2018-02-07T18:52:10.495Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121662</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV REGIONAL JAIL &amp; CORRECTIONAL FACILITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8361.28</td>\n",
" <td>4601c6659fc2f9e3fabcbff7c35d85dc</td>\n",
" <td>2018-02-07T18:52:10.563Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121663</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV STATE POLICE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>9428.43</td>\n",
" <td>a1f8509a5a3b8112b102992e48bfb3ba</td>\n",
" <td>2018-02-07T18:52:10.559Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121666</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Kanawha</td>\n",
" <td>KANAWHA COUNTY BOARD OF ED</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>104877.12</td>\n",
" <td>964dfa6b7d7120978e7c79b9a9e75da8</td>\n",
" <td>2018-02-07T18:52:10.496Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121668</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>ROUTE 34 VOLUNTEER FIRE DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1012.77</td>\n",
" <td>9f5c61fcc0c61de787360ce8de0151ce</td>\n",
" <td>2018-02-07T18:52:10.520Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121674</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV DIVISION OF CORRECTIONS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1174.80</td>\n",
" <td>58b097088a6629ca96c343499c6cf34a</td>\n",
" <td>2018-02-07T18:52:10.568Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121675</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>PUTNAM COUNTY BOARD-EDUCATION</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>20217.07</td>\n",
" <td>7bd7cf5fc68a515d9a2ea677dab08fe9</td>\n",
" <td>2018-02-07T18:52:10.501Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121676</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>ELEANOR</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>4080.44</td>\n",
" <td>509e6451985595d945eddfa4d72c2ab4</td>\n",
" <td>2018-02-07T18:52:10.567Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121678</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>LINCOLN COUNTY OFC. EMERG. SERV.</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>5110.40</td>\n",
" <td>599f98255ae002163ad3edde20ed15a2</td>\n",
" <td>2018-02-07T18:52:10.519Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121681</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV DEPARTMENT OF AGRICULTURE</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3595.21</td>\n",
" <td>3220bd3fc2d08e8bd86184735f949089</td>\n",
" <td>2018-02-07T18:52:10.562Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121684</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>WINFIELD VOLUNTEER FIRE DEPARTMENT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1770.52</td>\n",
" <td>fdd8c68a3d737c6cb12d6fc9ed68061f</td>\n",
" <td>2018-02-07T18:52:10.567Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121685</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Putnam</td>\n",
" <td>PUTNAM (COUNTY)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3304.76</td>\n",
" <td>7f08c3c6137ebe5699e8eded9ea15a97</td>\n",
" <td>2018-02-07T18:52:10.567Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121694</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Statewide</td>\n",
" <td>WV DEPT. OF ENVIRONMENTAL PROTECTION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>10716.34</td>\n",
" <td>5b1d78736121016a6c27b3da55a1a763</td>\n",
" <td>2018-02-07T18:52:10.520Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121695</th>\n",
" <td>3366</td>\n",
" <td>2014-01-10T00:00:00.000Z</td>\n",
" <td>Chemical</td>\n",
" <td>West Virginia</td>\n",
" <td>Lincoln</td>\n",
" <td>DUVAL VFD</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>959.76</td>\n",
" <td>9f7d307a571646aa0aec138d4d0343c9</td>\n",
" <td>2018-02-07T18:52:10.496Z</td>\n",
" <td>2014</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType state \\\n",
"121593 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121598 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121601 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121603 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121605 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121606 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121607 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121611 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121612 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121614 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121615 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121617 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121619 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121621 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121622 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121623 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121625 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121626 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121628 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121629 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121630 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121633 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121634 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121635 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121636 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121637 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121640 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121641 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121642 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121643 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121644 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121645 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121646 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121647 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121648 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121650 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121651 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121660 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121662 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121663 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121666 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121668 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121674 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121675 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121676 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121678 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121681 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121684 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121685 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121694 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"121695 3366 2014-01-10T00:00:00.000Z Chemical West Virginia \n",
"\n",
" county applicantName \\\n",
"121593 Kanawha CHARLESTON \n",
"121598 Putnam HURRICANE \n",
"121601 Lincoln LINCOLN COUNTY BOARD-EDUCATION \n",
"121603 Kanawha SOUTH CHARLESTON \n",
"121605 Lincoln WEST HAMLIN VOL FIRE DEPT \n",
"121606 Lincoln WEST HAMLIN \n",
"121607 Kanawha KANAWHA COUNTY METRO 911 \n",
"121611 Boone BOONE COUNTY BOARD OF EDUCATION \n",
"121612 Kanawha DUNBAR \n",
"121614 Kanawha CHARLESTON AREA MEDICAL CTR \n",
"121615 Kanawha NITRO \n",
"121617 Kanawha HERBERT J. THOMAS MEMORIAL HOSPITAL ASSOCIATION \n",
"121619 Lincoln LINCOLN (COUNTY) \n",
"121621 Lincoln LINCOLN COUNTY HEALTH DEPT \n",
"121622 Boone DANVILLE \n",
"121623 Lincoln HAMLIN VOLUNTEER FIRE \n",
"121625 Putnam BANCROFT VOLUNTEER FIRE DEPT \n",
"121626 Lincoln LINCOLN PUBLIC SERVICE DISTRICT \n",
"121628 Putnam PUTNAM PUBLIC SERVICE DISTRICT \n",
"121629 Putnam HURRICANE VOLUNTEER FIRE DEPARTMENT \n",
"121630 Boone BOONE COUNTY AMBULANCE AUTHORITY \n",
"121633 Kanawha KANAWHA COUNTY AMBULANCE \n",
"121634 Cabell FACING HUNGER FOOD BANK (HUNTINGTON AREA FOOD B) \n",
"121635 Statewide WEST VIRGINIA BUREAU FOR PUBLIC HEALTH \n",
"121636 Kanawha KANAWHA (COUNTY) \n",
"121637 Putnam PUTNAM COUNTY EMERGENCY MEDICAL SERVICES \n",
"121640 Putnam ELEANOR VOLUNTEER FIRE DEPARTMENT \n",
"121641 Statewide WV DIVISION OF HOMELAND SECURITY \n",
"121642 Cabell CABELL COUNTY EMERGENCY SERVICES \n",
"121643 Boone MADISON \n",
"121644 Kanawha KANAWHA-CHARLESTON HEALTH DEPT \n",
"121645 Statewide WV DIVISION OF HIGHWAYS \n",
"121646 Putnam POCA VOLUNTEER FIRE DEPT \n",
"121647 Boone RACINE VOLUNTEER FIRE DEPT \n",
"121648 Putnam BUFFALO \n",
"121650 Kanawha CHARLESTON HOSPITAL, INC. DBA ST. FRANCIS HOSP... \n",
"121651 Statewide OFFICE OF THE ADJUTANT GENERAL, STATE OF WV \n",
"121660 Boone BOONE (COUNTY) \n",
"121662 Statewide WV REGIONAL JAIL & CORRECTIONAL FACILITY \n",
"121663 Statewide WV STATE POLICE \n",
"121666 Kanawha KANAWHA COUNTY BOARD OF ED \n",
"121668 Putnam ROUTE 34 VOLUNTEER FIRE DEPT \n",
"121674 Statewide WV DIVISION OF CORRECTIONS \n",
"121675 Putnam PUTNAM COUNTY BOARD-EDUCATION \n",
"121676 Putnam ELEANOR \n",
"121678 Lincoln LINCOLN COUNTY OFC. EMERG. SERV. \n",
"121681 Statewide WV DEPARTMENT OF AGRICULTURE \n",
"121684 Putnam WINFIELD VOLUNTEER FIRE DEPARTMENT \n",
"121685 Putnam PUTNAM (COUNTY) \n",
"121694 Statewide WV DEPT. OF ENVIRONMENTAL PROTECTION \n",
"121695 Lincoln DUVAL VFD \n",
"\n",
" educationApplicant numberOfProjects federalObligatedAmount \\\n",
"121593 0 1 34894.70 \n",
"121598 0 1 12448.49 \n",
"121601 1 1 12197.86 \n",
"121603 0 1 57224.63 \n",
"121605 0 1 2598.17 \n",
"121606 0 1 3806.42 \n",
"121607 0 1 10945.39 \n",
"121611 1 1 12525.01 \n",
"121612 0 1 2135.93 \n",
"121614 0 1 109241.51 \n",
"121615 0 1 16176.38 \n",
"121617 0 1 34989.05 \n",
"121619 0 1 14497.75 \n",
"121621 0 1 1863.91 \n",
"121622 0 1 3167.01 \n",
"121623 0 1 6217.25 \n",
"121625 0 1 3372.60 \n",
"121626 0 1 19642.31 \n",
"121628 0 1 1070.63 \n",
"121629 0 1 2958.34 \n",
"121630 0 1 3210.70 \n",
"121633 0 1 27318.78 \n",
"121634 0 1 914.26 \n",
"121635 0 1 25744.51 \n",
"121636 0 1 180647.37 \n",
"121637 0 1 5970.12 \n",
"121640 0 1 2075.50 \n",
"121641 0 4 283084.22 \n",
"121642 0 1 6739.48 \n",
"121643 0 1 3304.22 \n",
"121644 0 1 20731.28 \n",
"121645 0 1 178178.18 \n",
"121646 0 1 9787.44 \n",
"121647 0 1 4590.84 \n",
"121648 0 1 3683.37 \n",
"121650 0 1 12654.08 \n",
"121651 0 1 288601.22 \n",
"121660 0 1 45281.58 \n",
"121662 0 1 8361.28 \n",
"121663 0 1 9428.43 \n",
"121666 1 1 104877.12 \n",
"121668 0 1 1012.77 \n",
"121674 0 1 1174.80 \n",
"121675 1 1 20217.07 \n",
"121676 0 1 4080.44 \n",
"121678 0 1 5110.40 \n",
"121681 0 1 3595.21 \n",
"121684 0 1 1770.52 \n",
"121685 0 1 3304.76 \n",
"121694 0 1 10716.34 \n",
"121695 0 1 959.76 \n",
"\n",
" hash lastRefresh year \n",
"121593 dc2b0c35d301e1c3228649153143e1ad 2018-02-07T18:52:10.480Z 2014 \n",
"121598 400fc2150c2dfc0d8d90a60c45dda30a 2018-02-07T18:52:10.481Z 2014 \n",
"121601 d15928669df8cc2633e8b374003d887d 2018-02-07T18:52:10.481Z 2014 \n",
"121603 a298dbaf862571f71d61f3258d45a412 2018-02-07T18:52:10.527Z 2014 \n",
"121605 ff1dd9f24e041cccc943996c743ab234 2018-02-07T18:52:10.481Z 2014 \n",
"121606 1648840f50c2eae38c2a9be48f0db975 2018-02-07T18:52:10.500Z 2014 \n",
"121607 6593b6fd3f6c834da4cbab8425fa727b 2018-02-07T18:52:10.531Z 2014 \n",
"121611 d9495ed8dba60c8c600b3db555c7fcda 2018-02-07T18:52:10.499Z 2014 \n",
"121612 7adbd0961ced60adf68582c29a5dd6b9 2018-02-07T18:52:10.531Z 2014 \n",
"121614 2a8361058350699d271ff5c6d633f795 2018-02-07T18:52:10.526Z 2014 \n",
"121615 d47390f83cc650761916abfc82152698 2018-02-07T18:52:10.480Z 2014 \n",
"121617 660e4bb01dc6cc713e1682f61b47dfb4 2018-02-07T18:52:10.500Z 2014 \n",
"121619 49f6947a92bf2786bc4cf81da404a506 2018-02-07T18:52:10.500Z 2014 \n",
"121621 4bee4e601549be6105df4658485c465b 2018-02-07T18:52:10.527Z 2014 \n",
"121622 57451d7c7ba0ee5698e12ae15e3d3c46 2018-02-07T18:52:10.480Z 2014 \n",
"121623 0773364fa174589dd7a8d74737d9688e 2018-02-07T18:52:10.566Z 2014 \n",
"121625 4d935d7d10b115aac48a00cd0156506a 2018-02-07T18:52:10.527Z 2014 \n",
"121626 13564d6f09a093132a53770cea44e116 2018-02-07T18:52:10.566Z 2014 \n",
"121628 c468d614bd53b912e279ebd966f3415a 2018-02-07T18:52:10.528Z 2014 \n",
"121629 ec1e63e9a68f500640653ff5c3e00a66 2018-02-07T18:52:10.527Z 2014 \n",
"121630 490e4025c8bef92923f0b9d51c4a10ae 2018-02-07T18:52:10.530Z 2014 \n",
"121633 94a16aa8754dce0c0689a5d00e6c279b 2018-02-07T18:52:10.526Z 2014 \n",
"121634 b0331bbf45230aa0b559d6732be1ff98 2018-02-07T18:52:10.499Z 2014 \n",
"121635 44d3e61d818d4af613aa3cdb9a74b49f 2018-02-07T18:52:10.532Z 2014 \n",
"121636 576188a73d7a9eca21997720442e26fc 2018-02-07T18:52:10.480Z 2014 \n",
"121637 0e00c3c5936269061173457fae3469d6 2018-02-07T18:52:10.532Z 2014 \n",
"121640 e628cf2bccdf71e4a43d99ea2dca5b8a 2018-02-07T18:52:10.501Z 2014 \n",
"121641 859a676a23252b26e97fbff69b64b50e 2018-02-07T18:52:10.532Z 2014 \n",
"121642 70bbfe171035b9e40520d0f5d19c2742 2018-02-07T18:52:10.531Z 2014 \n",
"121643 8d1da9a42bfc303a90165cc68ff49177 2018-02-07T18:52:10.526Z 2014 \n",
"121644 f7a3b6a57279163e1f8baaf2139f325f 2018-02-07T18:52:10.500Z 2014 \n",
"121645 4247a19db366d54dd5ad914ab55da554 2018-02-07T18:52:10.521Z 2014 \n",
"121646 a4ed87ce0624b338fc27deaffabe599d 2018-02-07T18:52:10.520Z 2014 \n",
"121647 3dcbc41552b23a0fd89856183ce9bd35 2018-02-07T18:52:10.495Z 2014 \n",
"121648 76f6780ab2ec473137b94871f290e035 2018-02-07T18:52:10.519Z 2014 \n",
"121650 83120e0460122e19184b05ff4616f0be 2018-02-07T18:52:10.496Z 2014 \n",
"121651 4b7e21fa34c39941dc35f16475d129a3 2018-02-07T18:52:10.521Z 2014 \n",
"121660 a5a76921a275bb4530a070098e811e37 2018-02-07T18:52:10.495Z 2014 \n",
"121662 4601c6659fc2f9e3fabcbff7c35d85dc 2018-02-07T18:52:10.563Z 2014 \n",
"121663 a1f8509a5a3b8112b102992e48bfb3ba 2018-02-07T18:52:10.559Z 2014 \n",
"121666 964dfa6b7d7120978e7c79b9a9e75da8 2018-02-07T18:52:10.496Z 2014 \n",
"121668 9f5c61fcc0c61de787360ce8de0151ce 2018-02-07T18:52:10.520Z 2014 \n",
"121674 58b097088a6629ca96c343499c6cf34a 2018-02-07T18:52:10.568Z 2014 \n",
"121675 7bd7cf5fc68a515d9a2ea677dab08fe9 2018-02-07T18:52:10.501Z 2014 \n",
"121676 509e6451985595d945eddfa4d72c2ab4 2018-02-07T18:52:10.567Z 2014 \n",
"121678 599f98255ae002163ad3edde20ed15a2 2018-02-07T18:52:10.519Z 2014 \n",
"121681 3220bd3fc2d08e8bd86184735f949089 2018-02-07T18:52:10.562Z 2014 \n",
"121684 fdd8c68a3d737c6cb12d6fc9ed68061f 2018-02-07T18:52:10.567Z 2014 \n",
"121685 7f08c3c6137ebe5699e8eded9ea15a97 2018-02-07T18:52:10.567Z 2014 \n",
"121694 5b1d78736121016a6c27b3da55a1a763 2018-02-07T18:52:10.520Z 2014 \n",
"121695 9f7d307a571646aa0aec138d4d0343c9 2018-02-07T18:52:10.496Z 2014 "
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Chemical']"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>119056</th>\n",
" <td>3276</td>\n",
" <td>2007-07-31T00:00:00.000Z</td>\n",
" <td>Drought</td>\n",
" <td>Federated States of Micronesia</td>\n",
" <td>Statewide</td>\n",
" <td>FEDERATED STATES OF MICRONESIA</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>73991.65</td>\n",
" <td>bcf1ef3cfc4990aee594428f994ac531</td>\n",
" <td>2018-02-07T18:52:06.023Z</td>\n",
" <td>2007</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType \\\n",
"119056 3276 2007-07-31T00:00:00.000Z Drought \n",
"\n",
" state county \\\n",
"119056 Federated States of Micronesia Statewide \n",
"\n",
" applicantName educationApplicant numberOfProjects \\\n",
"119056 FEDERATED STATES OF MICRONESIA 0 1 \n",
"\n",
" federalObligatedAmount hash \\\n",
"119056 73991.65 bcf1ef3cfc4990aee594428f994ac531 \n",
"\n",
" lastRefresh year \n",
"119056 2018-02-07T18:52:06.023Z 2007 "
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Drought']"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Oklahoma City Bombings"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>96801</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA DEPARTMENT OF PUBLIC SAFETY</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>484066.77</td>\n",
" <td>f38333a7bc1127c571d8e57fa5f00c2d</td>\n",
" <td>2018-02-07T18:51:26.297Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96804</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA DEPT OF LABOR</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>14031.66</td>\n",
" <td>b916b6f7fd665d796622a5b78a761d9f</td>\n",
" <td>2018-02-07T18:51:26.291Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96805</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OK DEPT OF ENVIRONMENTAL QUALITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1353.00</td>\n",
" <td>d048be8ae2c6e5fb4d62b7d43b7bdd3a</td>\n",
" <td>2018-02-07T18:51:26.296Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96810</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA TOURISM AND RECREATION DEPT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>16333.00</td>\n",
" <td>89284528d12bb0e28ff4905e924b5eb9</td>\n",
" <td>2018-02-07T18:51:26.297Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96828</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA CITY</td>\n",
" <td>0</td>\n",
" <td>83</td>\n",
" <td>2493076.35</td>\n",
" <td>53126705911163557acd4b6af267f590</td>\n",
" <td>2018-02-07T18:51:26.290Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96841</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>THE UNIVERSITY HOSPITALS</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>21587.00</td>\n",
" <td>e90d1b24e821398774d7e3bb1516d5aa</td>\n",
" <td>2018-02-07T18:51:26.291Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96850</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA DEPT OF CORRECTIONS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>60419.00</td>\n",
" <td>4c8f4b772f3030368e1c88bd9331403e</td>\n",
" <td>2018-02-07T18:51:26.303Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96853</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA BOARD OF MEDICO/LEGAL INVESTIGATIONS</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>207102.09</td>\n",
" <td>eb139a45970055dd6889f73b308d3b0d</td>\n",
" <td>2018-02-07T18:51:26.303Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96857</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA DEPARTMENT OF HUMAN SERVICES</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>9744.00</td>\n",
" <td>84b18a8733004c73b55c1b6f3f70b55d</td>\n",
" <td>2018-02-07T18:51:26.264Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96867</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>UNIVERSITY OF OK HEALTH SCIENCES CENTER</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>13960.00</td>\n",
" <td>85c23aa647129c43f0f40ce13b8acbff</td>\n",
" <td>2018-02-07T18:51:26.249Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96872</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA COUNTY</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>99546.69</td>\n",
" <td>80adcb645b2b3b54d35e287e9f7834fe</td>\n",
" <td>2018-02-07T18:51:26.248Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96876</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>EMERGENCY MEDICAL SERVICES AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>75227.33</td>\n",
" <td>07b5913a9ea94c41f7092838b4ffdf66</td>\n",
" <td>2018-02-07T18:51:26.263Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96893</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA STATE DEPT OF HEALTH</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>9446.00</td>\n",
" <td>8a31f5eded296a128b33a8728e6d32b3</td>\n",
" <td>2018-02-07T18:51:26.264Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96899</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>OKLAHOMA MILITARY DEPARTMENT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>314411.14</td>\n",
" <td>6a940223738ebea3b83aca567e2b1c4c</td>\n",
" <td>2018-02-07T18:51:26.248Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96901</th>\n",
" <td>3115</td>\n",
" <td>1995-04-19T00:00:00.000Z</td>\n",
" <td>Human Cause</td>\n",
" <td>Oklahoma</td>\n",
" <td>NaN</td>\n",
" <td>STATE OF OKLAHOMA</td>\n",
" <td>0</td>\n",
" <td>11</td>\n",
" <td>87102.60</td>\n",
" <td>0a4f15dd558efdf6f370e0cecfbcfc73</td>\n",
" <td>2018-02-07T18:51:26.304Z</td>\n",
" <td>1995</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType state county \\\n",
"96801 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96804 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96805 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96810 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96828 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96841 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96850 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96853 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96857 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96867 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96872 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96876 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96893 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96899 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"96901 3115 1995-04-19T00:00:00.000Z Human Cause Oklahoma NaN \n",
"\n",
" applicantName educationApplicant \\\n",
"96801 OKLAHOMA DEPARTMENT OF PUBLIC SAFETY 0 \n",
"96804 OKLAHOMA DEPT OF LABOR 0 \n",
"96805 OK DEPT OF ENVIRONMENTAL QUALITY 0 \n",
"96810 OKLAHOMA TOURISM AND RECREATION DEPT 0 \n",
"96828 OKLAHOMA CITY 0 \n",
"96841 THE UNIVERSITY HOSPITALS 1 \n",
"96850 OKLAHOMA DEPT OF CORRECTIONS 0 \n",
"96853 OKLAHOMA BOARD OF MEDICO/LEGAL INVESTIGATIONS 0 \n",
"96857 OKLAHOMA DEPARTMENT OF HUMAN SERVICES 0 \n",
"96867 UNIVERSITY OF OK HEALTH SCIENCES CENTER 1 \n",
"96872 OKLAHOMA COUNTY 0 \n",
"96876 EMERGENCY MEDICAL SERVICES AUTHORITY 0 \n",
"96893 OKLAHOMA STATE DEPT OF HEALTH 0 \n",
"96899 OKLAHOMA MILITARY DEPARTMENT 0 \n",
"96901 STATE OF OKLAHOMA 0 \n",
"\n",
" numberOfProjects federalObligatedAmount \\\n",
"96801 2 484066.77 \n",
"96804 1 14031.66 \n",
"96805 1 1353.00 \n",
"96810 1 16333.00 \n",
"96828 83 2493076.35 \n",
"96841 1 21587.00 \n",
"96850 1 60419.00 \n",
"96853 4 207102.09 \n",
"96857 1 9744.00 \n",
"96867 1 13960.00 \n",
"96872 7 99546.69 \n",
"96876 3 75227.33 \n",
"96893 1 9446.00 \n",
"96899 1 314411.14 \n",
"96901 11 87102.60 \n",
"\n",
" hash lastRefresh year \n",
"96801 f38333a7bc1127c571d8e57fa5f00c2d 2018-02-07T18:51:26.297Z 1995 \n",
"96804 b916b6f7fd665d796622a5b78a761d9f 2018-02-07T18:51:26.291Z 1995 \n",
"96805 d048be8ae2c6e5fb4d62b7d43b7bdd3a 2018-02-07T18:51:26.296Z 1995 \n",
"96810 89284528d12bb0e28ff4905e924b5eb9 2018-02-07T18:51:26.297Z 1995 \n",
"96828 53126705911163557acd4b6af267f590 2018-02-07T18:51:26.290Z 1995 \n",
"96841 e90d1b24e821398774d7e3bb1516d5aa 2018-02-07T18:51:26.291Z 1995 \n",
"96850 4c8f4b772f3030368e1c88bd9331403e 2018-02-07T18:51:26.303Z 1995 \n",
"96853 eb139a45970055dd6889f73b308d3b0d 2018-02-07T18:51:26.303Z 1995 \n",
"96857 84b18a8733004c73b55c1b6f3f70b55d 2018-02-07T18:51:26.264Z 1995 \n",
"96867 85c23aa647129c43f0f40ce13b8acbff 2018-02-07T18:51:26.249Z 1995 \n",
"96872 80adcb645b2b3b54d35e287e9f7834fe 2018-02-07T18:51:26.248Z 1995 \n",
"96876 07b5913a9ea94c41f7092838b4ffdf66 2018-02-07T18:51:26.263Z 1995 \n",
"96893 8a31f5eded296a128b33a8728e6d32b3 2018-02-07T18:51:26.264Z 1995 \n",
"96899 6a940223738ebea3b83aca567e2b1c4c 2018-02-07T18:51:26.248Z 1995 \n",
"96901 0a4f15dd558efdf6f370e0cecfbcfc73 2018-02-07T18:51:26.304Z 1995 "
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Human Cause']"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Maine winter 2002-03 freeze"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>21018</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>FORT KENT (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>13477.15</td>\n",
" <td>a171179bb93afbf062584c930c02896f</td>\n",
" <td>2018-02-07T18:49:11.400Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21020</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Franklin</td>\n",
" <td>KINGFIELD WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2249.13</td>\n",
" <td>389ac931c47188dde9dead76287324dc</td>\n",
" <td>2018-02-07T18:49:11.402Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21033</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Androscoggin</td>\n",
" <td>SABATTUS SANITARY DISTRICT &amp; WATER DIVISION</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6435.00</td>\n",
" <td>5469e759be30f3c4bf138d34ccdf9aa5</td>\n",
" <td>2018-02-07T18:49:11.400Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21034</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>SINCLAIR TOWN SANITARY DIST</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1820.11</td>\n",
" <td>40d81191ec5ee075992e340d5e2c4b73</td>\n",
" <td>2018-02-07T18:49:11.401Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21038</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Cumberland</td>\n",
" <td>PORTLAND WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>8</td>\n",
" <td>232813.96</td>\n",
" <td>4893f53e6b8d960b796b21dfe7bba209</td>\n",
" <td>2018-02-07T18:49:11.402Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21041</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>WOODLAND (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>2101.82</td>\n",
" <td>d316231f483294f3e5d5e573b897ec36</td>\n",
" <td>2018-02-07T18:49:11.401Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21042</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Androscoggin</td>\n",
" <td>LEWISTON</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>106262.38</td>\n",
" <td>a3e9cb83e5654075cd6a0bb207c8d91c</td>\n",
" <td>2018-02-07T18:49:11.400Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21044</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>LIMESTONE WATER &amp; SEWER DIST</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>7851.04</td>\n",
" <td>c10ab163733491204c2b504b67a374fc</td>\n",
" <td>2018-02-07T18:49:11.401Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21049</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Hancock</td>\n",
" <td>BLUE HILL (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>820.01</td>\n",
" <td>51e998bab0a7c981463aeffb1a46f2b6</td>\n",
" <td>2018-02-07T18:49:11.341Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21051</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Franklin</td>\n",
" <td>FARMINGTON (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1166.32</td>\n",
" <td>f1f5be9ad7d8ff964a8371e899edd2b0</td>\n",
" <td>2018-02-07T18:49:11.367Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21052</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Franklin</td>\n",
" <td>RANGELEY WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>51392.07</td>\n",
" <td>df957699585a51f9e82e84ce475d64df</td>\n",
" <td>2018-02-07T18:49:11.367Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21056</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Androscoggin</td>\n",
" <td>LIVERMORE (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>819.44</td>\n",
" <td>91cf52f2029e433260a4110cbfc6d5d3</td>\n",
" <td>2018-02-07T18:49:11.330Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21059</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>VAN BUREN WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>7159.94</td>\n",
" <td>dc9bcc6d12e0a2ae79cbcebbe14cb459</td>\n",
" <td>2018-02-07T18:49:11.366Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21061</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Androscoggin</td>\n",
" <td>LIVERMORE FALLS WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>11007.52</td>\n",
" <td>50ed17eda7abd7ad5a62f3b8c715312b</td>\n",
" <td>2018-02-07T18:49:11.365Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21062</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Franklin</td>\n",
" <td>NORTH JAY WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>8095.07</td>\n",
" <td>2d39c6a031471d6446144b651ca0ab43</td>\n",
" <td>2018-02-07T18:49:11.341Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21064</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>CARIBOU UTILITES DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>36879.89</td>\n",
" <td>da9ba72132af235880a4567ec76b1c6e</td>\n",
" <td>2018-02-07T18:49:11.365Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21065</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>VAN BUREN (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>14076.89</td>\n",
" <td>53cff47b69f782e4052a712fb58aeeae</td>\n",
" <td>2018-02-07T18:49:11.340Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21070</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>HOULTON BAND OF MALISEET HOUSING AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>16626.00</td>\n",
" <td>792d4972f57327d53cb91752bed86383</td>\n",
" <td>2018-02-07T18:49:11.330Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21072</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Cumberland</td>\n",
" <td>YARMOUTH WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>22377.75</td>\n",
" <td>5b519116befe6b9a9434ec6f8b961c1e</td>\n",
" <td>2018-02-07T18:49:11.341Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21073</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Cumberland</td>\n",
" <td>FALMOUTH (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6206.27</td>\n",
" <td>405dfbba37eafc0dbee24e803f432c1e</td>\n",
" <td>2018-02-07T18:49:11.340Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21075</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Cumberland</td>\n",
" <td>GRAY WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6594.00</td>\n",
" <td>f0b3976765f10d6b4b8dbae74d78fd41</td>\n",
" <td>2018-02-07T18:49:11.367Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21077</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>MADAWASKA WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>28871.98</td>\n",
" <td>9c3cf7b622c33b140db68ca56347dfc3</td>\n",
" <td>2018-02-07T18:49:11.331Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21081</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>HOULTON WATER DIS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1088.93</td>\n",
" <td>42d324ddb1ce69d7301bd76ebccfaeb8</td>\n",
" <td>2018-02-07T18:49:11.366Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21082</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>ASHLAND WATER &amp; SEWER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>11064.95</td>\n",
" <td>42edf24be99fc2377f580d36338a0837</td>\n",
" <td>2018-02-07T18:49:11.330Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21089</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Aroostook</td>\n",
" <td>MARS HILL UTILITY DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>14008.88</td>\n",
" <td>fdc0a50a75a37ff4a17d269836d8291d</td>\n",
" <td>2018-02-07T18:49:11.366Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21090</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Androscoggin</td>\n",
" <td>LISBON (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>13033.61</td>\n",
" <td>f97809f89ca1666ed6913ef7db17d15d</td>\n",
" <td>2018-02-07T18:49:11.407Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21091</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Oxford</td>\n",
" <td>RUMFORD (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2340.64</td>\n",
" <td>ec4127333310a4bdba9f39449f0f1a25</td>\n",
" <td>2018-02-07T18:49:11.414Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21092</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Kennebec</td>\n",
" <td>HALLOWELL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>975.61</td>\n",
" <td>00570e4d7d53f9aae150d0af524216f0</td>\n",
" <td>2018-02-07T18:49:11.411Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21093</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Hancock</td>\n",
" <td>CASTINE (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6183.90</td>\n",
" <td>11a1f4927279c3a77ab00fba416662a1</td>\n",
" <td>2018-02-07T18:49:11.403Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21094</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Lincoln</td>\n",
" <td>WISCASSET WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>7068.39</td>\n",
" <td>5728b1b644940ba7c2f4e5722a41e32c</td>\n",
" <td>2018-02-07T18:49:11.411Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21164</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Piscataquis</td>\n",
" <td>GUILFORD-SANGERVILLE SANITARY DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1350.00</td>\n",
" <td>f424845b40b21934dedcfe45014f1971</td>\n",
" <td>2018-02-07T18:49:11.603Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21165</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Statewide</td>\n",
" <td>MAINE DEPARTMENT OF CORRECTIONS</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1143.75</td>\n",
" <td>c177832fd68d97c66b213dd4f8e34476</td>\n",
" <td>2018-02-07T18:49:11.655Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21166</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>BANGOR WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>104775.21</td>\n",
" <td>49daf55099f41ba751ee581835834560</td>\n",
" <td>2018-02-07T18:49:11.602Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21167</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>DEXTER UTILITY DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>11484.44</td>\n",
" <td>db6ff283a8d8623dc4d6f9918969be5d</td>\n",
" <td>2018-02-07T18:49:11.654Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21168</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>HOWLAND (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>10627.76</td>\n",
" <td>1acad2ee50d8cdc57f4ae348b82ddc88</td>\n",
" <td>2018-02-07T18:49:11.603Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21169</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>ORONO-VEAZIE WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>29058.22</td>\n",
" <td>a539dfef6817ad8d9ca8f6dca59c2a45</td>\n",
" <td>2018-02-07T18:49:11.582Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21171</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>OLD TOWN WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>28936.67</td>\n",
" <td>eee50f3054856dee8be4cdb7061d5745</td>\n",
" <td>2018-02-07T18:49:11.603Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21172</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>M. S. A. D # 63</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>569.88</td>\n",
" <td>8c1b787d0b600fa7232b4a2f6d5349d9</td>\n",
" <td>2018-02-07T18:49:11.654Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21174</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Statewide</td>\n",
" <td>MAINE DEPARTMENT OF FINANCE</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>10125.00</td>\n",
" <td>2479b9f57b22734242fc8d0fe0cd1127</td>\n",
" <td>2018-02-07T18:49:11.606Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21175</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Piscataquis</td>\n",
" <td>GUILFORD-SANGERVILLE WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>4299.30</td>\n",
" <td>411427bd56e4da67523c18aad7c4eccf</td>\n",
" <td>2018-02-07T18:49:11.583Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21176</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Washington</td>\n",
" <td>EASTPORT (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>13504.91</td>\n",
" <td>18c590180edfb001921b392210197c68</td>\n",
" <td>2018-02-07T18:49:11.656Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21178</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>MATTAWAMKEAG (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0.00</td>\n",
" <td>77b66996ad975056434934f4425fc784</td>\n",
" <td>2018-02-07T18:49:11.601Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21181</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Statewide</td>\n",
" <td>DEPARTMENT OF CONSERVATION</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>14706.00</td>\n",
" <td>41ccb156b7e3c54d7212b4ce5bfe8b9b</td>\n",
" <td>2018-02-07T18:49:11.601Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21188</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Washington</td>\n",
" <td>QUANTABACOOK WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3690.00</td>\n",
" <td>85a3488fcc3dac88686dde35abc5027a</td>\n",
" <td>2018-02-07T18:49:11.583Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21190</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>EAST MILLINOCKET (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2492.27</td>\n",
" <td>334c2b5c0824384dae9b0bb68b0421c4</td>\n",
" <td>2018-02-07T18:49:11.605Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21193</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Statewide</td>\n",
" <td>LORING DEVELOPMENT AUTHORITY OF MAINE</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>18522.86</td>\n",
" <td>015b168709890debacc3d314162b0954</td>\n",
" <td>2018-02-07T18:49:11.583Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21198</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>HAMPDEN WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>5008.95</td>\n",
" <td>f6fffa38273bec6022c965bb35a57eb5</td>\n",
" <td>2018-02-07T18:49:11.600Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21199</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>M.S.A.D. #22</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>11949.93</td>\n",
" <td>e9f713579329b9fd368a1b98af005cff</td>\n",
" <td>2018-02-07T18:49:11.605Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21200</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Penobscot</td>\n",
" <td>BREWER</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>28870.14</td>\n",
" <td>b9c09618619bd263fa7029ded64d1e52</td>\n",
" <td>2018-02-07T18:49:11.574Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21202</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Oxford</td>\n",
" <td>WEST PARIS WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>9364.91</td>\n",
" <td>637dfaa13784cabda5725cde23557c2d</td>\n",
" <td>2018-02-07T18:49:11.600Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21204</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Piscataquis</td>\n",
" <td>BROWNVILLE (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>6635.02</td>\n",
" <td>fa041b9bcf27f2a71f5c2f710c9f7e9d</td>\n",
" <td>2018-02-07T18:49:11.655Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21205</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Piscataquis</td>\n",
" <td>GREENVILLE (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>4903.75</td>\n",
" <td>4aabd5319aa53798710b82a8f1157a22</td>\n",
" <td>2018-02-07T18:49:11.601Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21211</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Washington</td>\n",
" <td>PASSAMAQUODDY WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>27817.63</td>\n",
" <td>06de9fa254c661d86bb75aaf8e54e6d4</td>\n",
" <td>2018-02-07T18:49:11.604Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21218</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Washington</td>\n",
" <td>MILBRIDGE WATER DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3910.50</td>\n",
" <td>0496c4e78d305be76626362eff55b753</td>\n",
" <td>2018-02-07T18:49:11.602Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21234</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Statewide</td>\n",
" <td>UNIVERSITY OF MAINE, (PARENT)</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>21207.55</td>\n",
" <td>7873f57b7721d340e9645c1200b50655</td>\n",
" <td>2018-02-07T18:49:11.602Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21244</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Statewide</td>\n",
" <td>DEPARTMENT OF INLAND FISHERIES AND WILDLIFE</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>4036.46</td>\n",
" <td>cb55fd156ba40fa96154ee9247aa56a1</td>\n",
" <td>2018-02-07T18:49:11.604Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21245</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Washington</td>\n",
" <td>CALAIS (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>5242.11</td>\n",
" <td>f9d44c4880e2b487191b90e5a02d0fe4</td>\n",
" <td>2018-02-07T18:49:11.604Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21246</th>\n",
" <td>1468</td>\n",
" <td>2003-05-14T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Maine</td>\n",
" <td>Washington</td>\n",
" <td>MILBRIDGE (TOWN OF)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>750.00</td>\n",
" <td>25a11e315e795a89c52aa0699230efb6</td>\n",
" <td>2018-02-07T18:49:11.627Z</td>\n",
" <td>2003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136502</th>\n",
" <td>4104</td>\n",
" <td>2013-03-05T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Arizona</td>\n",
" <td>Statewide</td>\n",
" <td>NAVAJO TRIBAL UTILITY AUTHORITY</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>1384339.56</td>\n",
" <td>6eb506e568f1dcda3ff527d50412fd7f</td>\n",
" <td>2018-02-07T18:52:37.082Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136597</th>\n",
" <td>4104</td>\n",
" <td>2013-03-05T00:00:00.000Z</td>\n",
" <td>Freezing</td>\n",
" <td>Arizona</td>\n",
" <td>Statewide</td>\n",
" <td>NAVAJO NATION RESERVATION (ALSO NM AND UT)</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>218259.48</td>\n",
" <td>d44637f7c28c22b3febc28108a3d5a4c</td>\n",
" <td>2018-02-07T18:52:37.088Z</td>\n",
" <td>2013</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>121 rows × 12 columns</p>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType state \\\n",
"21018 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21020 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21033 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21034 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21038 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21041 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21042 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21044 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21049 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21051 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21052 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21056 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21059 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21061 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21062 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21064 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21065 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21070 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21072 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21073 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21075 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21077 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21081 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21082 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21089 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21090 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21091 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21092 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21093 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21094 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"... ... ... ... ... \n",
"21164 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21165 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21166 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21167 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21168 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21169 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21171 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21172 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21174 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21175 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21176 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21178 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21181 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21188 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21190 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21193 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21198 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21199 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21200 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21202 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21204 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21205 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21211 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21218 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21234 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21244 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21245 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"21246 1468 2003-05-14T00:00:00.000Z Freezing Maine \n",
"136502 4104 2013-03-05T00:00:00.000Z Freezing Arizona \n",
"136597 4104 2013-03-05T00:00:00.000Z Freezing Arizona \n",
"\n",
" county applicantName \\\n",
"21018 Aroostook FORT KENT (TOWN OF) \n",
"21020 Franklin KINGFIELD WATER DISTRICT \n",
"21033 Androscoggin SABATTUS SANITARY DISTRICT & WATER DIVISION \n",
"21034 Aroostook SINCLAIR TOWN SANITARY DIST \n",
"21038 Cumberland PORTLAND WATER DISTRICT \n",
"21041 Aroostook WOODLAND (TOWN OF) \n",
"21042 Androscoggin LEWISTON \n",
"21044 Aroostook LIMESTONE WATER & SEWER DIST \n",
"21049 Hancock BLUE HILL (TOWN OF) \n",
"21051 Franklin FARMINGTON (TOWN OF) \n",
"21052 Franklin RANGELEY WATER DISTRICT \n",
"21056 Androscoggin LIVERMORE (TOWN OF) \n",
"21059 Aroostook VAN BUREN WATER DISTRICT \n",
"21061 Androscoggin LIVERMORE FALLS WATER DISTRICT \n",
"21062 Franklin NORTH JAY WATER DISTRICT \n",
"21064 Aroostook CARIBOU UTILITES DISTRICT \n",
"21065 Aroostook VAN BUREN (TOWN OF) \n",
"21070 Aroostook HOULTON BAND OF MALISEET HOUSING AUTHORITY \n",
"21072 Cumberland YARMOUTH WATER DISTRICT \n",
"21073 Cumberland FALMOUTH (TOWN OF) \n",
"21075 Cumberland GRAY WATER DISTRICT \n",
"21077 Aroostook MADAWASKA WATER DISTRICT \n",
"21081 Aroostook HOULTON WATER DIS \n",
"21082 Aroostook ASHLAND WATER & SEWER DISTRICT \n",
"21089 Aroostook MARS HILL UTILITY DISTRICT \n",
"21090 Androscoggin LISBON (TOWN OF) \n",
"21091 Oxford RUMFORD (TOWN OF) \n",
"21092 Kennebec HALLOWELL \n",
"21093 Hancock CASTINE (TOWN OF) \n",
"21094 Lincoln WISCASSET WATER DISTRICT \n",
"... ... ... \n",
"21164 Piscataquis GUILFORD-SANGERVILLE SANITARY DISTRICT \n",
"21165 Statewide MAINE DEPARTMENT OF CORRECTIONS \n",
"21166 Penobscot BANGOR WATER DISTRICT \n",
"21167 Penobscot DEXTER UTILITY DISTRICT \n",
"21168 Penobscot HOWLAND (TOWN OF) \n",
"21169 Penobscot ORONO-VEAZIE WATER DISTRICT \n",
"21171 Penobscot OLD TOWN WATER DISTRICT \n",
"21172 Penobscot M. S. A. D # 63 \n",
"21174 Statewide MAINE DEPARTMENT OF FINANCE \n",
"21175 Piscataquis GUILFORD-SANGERVILLE WATER DISTRICT \n",
"21176 Washington EASTPORT (TOWN OF) \n",
"21178 Penobscot MATTAWAMKEAG (TOWN OF) \n",
"21181 Statewide DEPARTMENT OF CONSERVATION \n",
"21188 Washington QUANTABACOOK WATER DISTRICT \n",
"21190 Penobscot EAST MILLINOCKET (TOWN OF) \n",
"21193 Statewide LORING DEVELOPMENT AUTHORITY OF MAINE \n",
"21198 Penobscot HAMPDEN WATER DISTRICT \n",
"21199 Penobscot M.S.A.D. #22 \n",
"21200 Penobscot BREWER \n",
"21202 Oxford WEST PARIS WATER DISTRICT \n",
"21204 Piscataquis BROWNVILLE (TOWN OF) \n",
"21205 Piscataquis GREENVILLE (TOWN OF) \n",
"21211 Washington PASSAMAQUODDY WATER DISTRICT \n",
"21218 Washington MILBRIDGE WATER DISTRICT \n",
"21234 Statewide UNIVERSITY OF MAINE, (PARENT) \n",
"21244 Statewide DEPARTMENT OF INLAND FISHERIES AND WILDLIFE \n",
"21245 Washington CALAIS (TOWN OF) \n",
"21246 Washington MILBRIDGE (TOWN OF) \n",
"136502 Statewide NAVAJO TRIBAL UTILITY AUTHORITY \n",
"136597 Statewide NAVAJO NATION RESERVATION (ALSO NM AND UT) \n",
"\n",
" educationApplicant numberOfProjects federalObligatedAmount \\\n",
"21018 0 1 13477.15 \n",
"21020 0 1 2249.13 \n",
"21033 0 1 6435.00 \n",
"21034 0 1 1820.11 \n",
"21038 0 8 232813.96 \n",
"21041 0 2 2101.82 \n",
"21042 0 7 106262.38 \n",
"21044 0 1 7851.04 \n",
"21049 0 1 820.01 \n",
"21051 0 1 1166.32 \n",
"21052 0 1 51392.07 \n",
"21056 0 1 819.44 \n",
"21059 0 2 7159.94 \n",
"21061 0 2 11007.52 \n",
"21062 0 3 8095.07 \n",
"21064 0 1 36879.89 \n",
"21065 0 2 14076.89 \n",
"21070 0 1 16626.00 \n",
"21072 0 1 22377.75 \n",
"21073 0 1 6206.27 \n",
"21075 0 1 6594.00 \n",
"21077 0 1 28871.98 \n",
"21081 0 1 1088.93 \n",
"21082 0 1 11064.95 \n",
"21089 0 1 14008.88 \n",
"21090 0 1 13033.61 \n",
"21091 0 1 2340.64 \n",
"21092 0 1 975.61 \n",
"21093 0 1 6183.90 \n",
"21094 0 3 7068.39 \n",
"... ... ... ... \n",
"21164 0 1 1350.00 \n",
"21165 0 1 1143.75 \n",
"21166 0 2 104775.21 \n",
"21167 0 2 11484.44 \n",
"21168 0 1 10627.76 \n",
"21169 0 1 29058.22 \n",
"21171 0 2 28936.67 \n",
"21172 0 1 569.88 \n",
"21174 0 7 10125.00 \n",
"21175 0 2 4299.30 \n",
"21176 0 2 13504.91 \n",
"21178 0 1 0.00 \n",
"21181 0 2 14706.00 \n",
"21188 0 1 3690.00 \n",
"21190 0 1 2492.27 \n",
"21193 0 2 18522.86 \n",
"21198 0 2 5008.95 \n",
"21199 0 2 11949.93 \n",
"21200 0 4 28870.14 \n",
"21202 0 1 9364.91 \n",
"21204 0 1 6635.02 \n",
"21205 0 1 4903.75 \n",
"21211 0 3 27817.63 \n",
"21218 0 1 3910.50 \n",
"21234 1 6 21207.55 \n",
"21244 0 2 4036.46 \n",
"21245 0 2 5242.11 \n",
"21246 0 1 750.00 \n",
"136502 0 3 1384339.56 \n",
"136597 0 4 218259.48 \n",
"\n",
" hash lastRefresh year \n",
"21018 a171179bb93afbf062584c930c02896f 2018-02-07T18:49:11.400Z 2003 \n",
"21020 389ac931c47188dde9dead76287324dc 2018-02-07T18:49:11.402Z 2003 \n",
"21033 5469e759be30f3c4bf138d34ccdf9aa5 2018-02-07T18:49:11.400Z 2003 \n",
"21034 40d81191ec5ee075992e340d5e2c4b73 2018-02-07T18:49:11.401Z 2003 \n",
"21038 4893f53e6b8d960b796b21dfe7bba209 2018-02-07T18:49:11.402Z 2003 \n",
"21041 d316231f483294f3e5d5e573b897ec36 2018-02-07T18:49:11.401Z 2003 \n",
"21042 a3e9cb83e5654075cd6a0bb207c8d91c 2018-02-07T18:49:11.400Z 2003 \n",
"21044 c10ab163733491204c2b504b67a374fc 2018-02-07T18:49:11.401Z 2003 \n",
"21049 51e998bab0a7c981463aeffb1a46f2b6 2018-02-07T18:49:11.341Z 2003 \n",
"21051 f1f5be9ad7d8ff964a8371e899edd2b0 2018-02-07T18:49:11.367Z 2003 \n",
"21052 df957699585a51f9e82e84ce475d64df 2018-02-07T18:49:11.367Z 2003 \n",
"21056 91cf52f2029e433260a4110cbfc6d5d3 2018-02-07T18:49:11.330Z 2003 \n",
"21059 dc9bcc6d12e0a2ae79cbcebbe14cb459 2018-02-07T18:49:11.366Z 2003 \n",
"21061 50ed17eda7abd7ad5a62f3b8c715312b 2018-02-07T18:49:11.365Z 2003 \n",
"21062 2d39c6a031471d6446144b651ca0ab43 2018-02-07T18:49:11.341Z 2003 \n",
"21064 da9ba72132af235880a4567ec76b1c6e 2018-02-07T18:49:11.365Z 2003 \n",
"21065 53cff47b69f782e4052a712fb58aeeae 2018-02-07T18:49:11.340Z 2003 \n",
"21070 792d4972f57327d53cb91752bed86383 2018-02-07T18:49:11.330Z 2003 \n",
"21072 5b519116befe6b9a9434ec6f8b961c1e 2018-02-07T18:49:11.341Z 2003 \n",
"21073 405dfbba37eafc0dbee24e803f432c1e 2018-02-07T18:49:11.340Z 2003 \n",
"21075 f0b3976765f10d6b4b8dbae74d78fd41 2018-02-07T18:49:11.367Z 2003 \n",
"21077 9c3cf7b622c33b140db68ca56347dfc3 2018-02-07T18:49:11.331Z 2003 \n",
"21081 42d324ddb1ce69d7301bd76ebccfaeb8 2018-02-07T18:49:11.366Z 2003 \n",
"21082 42edf24be99fc2377f580d36338a0837 2018-02-07T18:49:11.330Z 2003 \n",
"21089 fdc0a50a75a37ff4a17d269836d8291d 2018-02-07T18:49:11.366Z 2003 \n",
"21090 f97809f89ca1666ed6913ef7db17d15d 2018-02-07T18:49:11.407Z 2003 \n",
"21091 ec4127333310a4bdba9f39449f0f1a25 2018-02-07T18:49:11.414Z 2003 \n",
"21092 00570e4d7d53f9aae150d0af524216f0 2018-02-07T18:49:11.411Z 2003 \n",
"21093 11a1f4927279c3a77ab00fba416662a1 2018-02-07T18:49:11.403Z 2003 \n",
"21094 5728b1b644940ba7c2f4e5722a41e32c 2018-02-07T18:49:11.411Z 2003 \n",
"... ... ... ... \n",
"21164 f424845b40b21934dedcfe45014f1971 2018-02-07T18:49:11.603Z 2003 \n",
"21165 c177832fd68d97c66b213dd4f8e34476 2018-02-07T18:49:11.655Z 2003 \n",
"21166 49daf55099f41ba751ee581835834560 2018-02-07T18:49:11.602Z 2003 \n",
"21167 db6ff283a8d8623dc4d6f9918969be5d 2018-02-07T18:49:11.654Z 2003 \n",
"21168 1acad2ee50d8cdc57f4ae348b82ddc88 2018-02-07T18:49:11.603Z 2003 \n",
"21169 a539dfef6817ad8d9ca8f6dca59c2a45 2018-02-07T18:49:11.582Z 2003 \n",
"21171 eee50f3054856dee8be4cdb7061d5745 2018-02-07T18:49:11.603Z 2003 \n",
"21172 8c1b787d0b600fa7232b4a2f6d5349d9 2018-02-07T18:49:11.654Z 2003 \n",
"21174 2479b9f57b22734242fc8d0fe0cd1127 2018-02-07T18:49:11.606Z 2003 \n",
"21175 411427bd56e4da67523c18aad7c4eccf 2018-02-07T18:49:11.583Z 2003 \n",
"21176 18c590180edfb001921b392210197c68 2018-02-07T18:49:11.656Z 2003 \n",
"21178 77b66996ad975056434934f4425fc784 2018-02-07T18:49:11.601Z 2003 \n",
"21181 41ccb156b7e3c54d7212b4ce5bfe8b9b 2018-02-07T18:49:11.601Z 2003 \n",
"21188 85a3488fcc3dac88686dde35abc5027a 2018-02-07T18:49:11.583Z 2003 \n",
"21190 334c2b5c0824384dae9b0bb68b0421c4 2018-02-07T18:49:11.605Z 2003 \n",
"21193 015b168709890debacc3d314162b0954 2018-02-07T18:49:11.583Z 2003 \n",
"21198 f6fffa38273bec6022c965bb35a57eb5 2018-02-07T18:49:11.600Z 2003 \n",
"21199 e9f713579329b9fd368a1b98af005cff 2018-02-07T18:49:11.605Z 2003 \n",
"21200 b9c09618619bd263fa7029ded64d1e52 2018-02-07T18:49:11.574Z 2003 \n",
"21202 637dfaa13784cabda5725cde23557c2d 2018-02-07T18:49:11.600Z 2003 \n",
"21204 fa041b9bcf27f2a71f5c2f710c9f7e9d 2018-02-07T18:49:11.655Z 2003 \n",
"21205 4aabd5319aa53798710b82a8f1157a22 2018-02-07T18:49:11.601Z 2003 \n",
"21211 06de9fa254c661d86bb75aaf8e54e6d4 2018-02-07T18:49:11.604Z 2003 \n",
"21218 0496c4e78d305be76626362eff55b753 2018-02-07T18:49:11.602Z 2003 \n",
"21234 7873f57b7721d340e9645c1200b50655 2018-02-07T18:49:11.602Z 2003 \n",
"21244 cb55fd156ba40fa96154ee9247aa56a1 2018-02-07T18:49:11.604Z 2003 \n",
"21245 f9d44c4880e2b487191b90e5a02d0fe4 2018-02-07T18:49:11.604Z 2003 \n",
"21246 25a11e315e795a89c52aa0699230efb6 2018-02-07T18:49:11.627Z 2003 \n",
"136502 6eb506e568f1dcda3ff527d50412fd7f 2018-02-07T18:52:37.082Z 2013 \n",
"136597 d44637f7c28c22b3febc28108a3d5a4c 2018-02-07T18:52:37.088Z 2013 \n",
"\n",
"[121 rows x 12 columns]"
]
},
"execution_count": 28,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Freezing']"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 2004 Jones Tract dam/levee failure \n",
"https://en.wikipedia.org/wiki/Jones_Tract"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>disasterNumber</th>\n",
" <th>declarationDate</th>\n",
" <th>incidentType</th>\n",
" <th>state</th>\n",
" <th>county</th>\n",
" <th>applicantName</th>\n",
" <th>educationApplicant</th>\n",
" <th>numberOfProjects</th>\n",
" <th>federalObligatedAmount</th>\n",
" <th>hash</th>\n",
" <th>lastRefresh</th>\n",
" <th>year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>26304</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>CALIFORNIA DEPARTMENT OF FORESTRY &amp; FIRE PROTE...</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0.00</td>\n",
" <td>7eb8d438fb0bd53206ca127d94cf8e8a</td>\n",
" <td>2018-02-07T18:49:20.589Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26306</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>RECLAMATION DISTRICT #0684, LOWER ROBERTS ISLAND</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0.00</td>\n",
" <td>b05a733eb63a0dbdaa21f7ee63c39d40</td>\n",
" <td>2018-02-07T18:49:20.588Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26307</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>RECLAMATION DISTRICT #2039, UPPER JONES TRACT</td>\n",
" <td>0</td>\n",
" <td>25</td>\n",
" <td>395683.90</td>\n",
" <td>5bb7dbed6118ed3ab94c865b018600bd</td>\n",
" <td>2018-02-07T18:49:20.548Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26309</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>DEPARTMENT OF TRANSPORTATION</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>891553.40</td>\n",
" <td>179961745b541fac38e509619d5143aa</td>\n",
" <td>2018-02-07T18:49:20.567Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26313</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>SAN JOAQUIN COUNTY MOSQUITO AND VECTOR CONTROL...</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>80675.80</td>\n",
" <td>fc18ff222e7a0fa1df5d6ff547468b21</td>\n",
" <td>2018-02-07T18:49:20.583Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26314</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>RECLAMATION DISTRICT #2072, WOODWARD ISLAND</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>74195.06</td>\n",
" <td>84d62253d80b364f82206c0e04799eac</td>\n",
" <td>2018-02-07T18:49:20.588Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26315</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>EAST BAY MUNICPAL UTILITES DISTRICT</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2044158.00</td>\n",
" <td>5dc8d2ada2701792abdb9039552badb2</td>\n",
" <td>2018-02-07T18:49:20.589Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26317</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>CALIFORNIA HIGHWAY PATROL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>151540.10</td>\n",
" <td>4d4f9997cc56dee0411a14985c121e0a</td>\n",
" <td>2018-02-07T18:49:20.583Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26319</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>STOCKTON, CITY OF</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>23024.96</td>\n",
" <td>05051ecdc86d749e0da316d73e9de0b6</td>\n",
" <td>2018-02-07T18:49:20.551Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26321</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>DEPARTMENT OF TOXIC SUBSTANCE CONTROL</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>7684.75</td>\n",
" <td>48e8836ed988386fe8281e0f80944694</td>\n",
" <td>2018-02-07T18:49:20.557Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26323</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>RECLAMATION DISTRICT #2038, LOWER JONES TRACT</td>\n",
" <td>0</td>\n",
" <td>20</td>\n",
" <td>2481583.32</td>\n",
" <td>b3462d89c6754058d1dec100395e529c</td>\n",
" <td>2018-02-07T18:49:20.582Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26328</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>CALIFORNIA CONSERVATION CORPS (CCC)</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>24149.27</td>\n",
" <td>9619539227c33847925869b97d007465</td>\n",
" <td>2018-02-07T18:49:20.567Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26330</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>RECLAMATION DISTRICT #2040, VICTORIA ISLAND</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>102869.25</td>\n",
" <td>d483bb8e30040f6a476258585acc9587</td>\n",
" <td>2018-02-07T18:49:20.567Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26354</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>CALIFORNIA DEPARTMENT OF WATER RESOURCES</td>\n",
" <td>0</td>\n",
" <td>8</td>\n",
" <td>13089511.74</td>\n",
" <td>ad7f29c8fe030592993a5e48902edc13</td>\n",
" <td>2018-02-07T18:49:20.542Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26357</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>SAN JOAQUIN (COUNTY)</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>1040387.68</td>\n",
" <td>093f542f616bc781108fd8f8418cbee1</td>\n",
" <td>2018-02-07T18:49:20.541Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26361</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>San Joaquin</td>\n",
" <td>RECLAMATION DISTRICT #2030, MCDONALD ISLAND</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>44077.96</td>\n",
" <td>fdb75f3f98dca57cae88643e0c48ab39</td>\n",
" <td>2018-02-07T18:49:20.541Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26373</th>\n",
" <td>1529</td>\n",
" <td>2004-06-30T00:00:00.000Z</td>\n",
" <td>Dam/Levee Break</td>\n",
" <td>California</td>\n",
" <td>Statewide</td>\n",
" <td>GOVERNOR'S OFFICE OF EMERGENCY SERVICES</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>149602.59</td>\n",
" <td>c30524e1b2de73bf02893cefabb8a887</td>\n",
" <td>2018-02-07T18:49:20.542Z</td>\n",
" <td>2004</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" disasterNumber declarationDate incidentType state \\\n",
"26304 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26306 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26307 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26309 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26313 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26314 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26315 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26317 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26319 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26321 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26323 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26328 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26330 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26354 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26357 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26361 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"26373 1529 2004-06-30T00:00:00.000Z Dam/Levee Break California \n",
"\n",
" county applicantName \\\n",
"26304 Statewide CALIFORNIA DEPARTMENT OF FORESTRY & FIRE PROTE... \n",
"26306 San Joaquin RECLAMATION DISTRICT #0684, LOWER ROBERTS ISLAND \n",
"26307 San Joaquin RECLAMATION DISTRICT #2039, UPPER JONES TRACT \n",
"26309 Statewide DEPARTMENT OF TRANSPORTATION \n",
"26313 San Joaquin SAN JOAQUIN COUNTY MOSQUITO AND VECTOR CONTROL... \n",
"26314 San Joaquin RECLAMATION DISTRICT #2072, WOODWARD ISLAND \n",
"26315 Statewide EAST BAY MUNICPAL UTILITES DISTRICT \n",
"26317 Statewide CALIFORNIA HIGHWAY PATROL \n",
"26319 San Joaquin STOCKTON, CITY OF \n",
"26321 Statewide DEPARTMENT OF TOXIC SUBSTANCE CONTROL \n",
"26323 San Joaquin RECLAMATION DISTRICT #2038, LOWER JONES TRACT \n",
"26328 Statewide CALIFORNIA CONSERVATION CORPS (CCC) \n",
"26330 San Joaquin RECLAMATION DISTRICT #2040, VICTORIA ISLAND \n",
"26354 Statewide CALIFORNIA DEPARTMENT OF WATER RESOURCES \n",
"26357 San Joaquin SAN JOAQUIN (COUNTY) \n",
"26361 San Joaquin RECLAMATION DISTRICT #2030, MCDONALD ISLAND \n",
"26373 Statewide GOVERNOR'S OFFICE OF EMERGENCY SERVICES \n",
"\n",
" educationApplicant numberOfProjects federalObligatedAmount \\\n",
"26304 0 1 0.00 \n",
"26306 0 1 0.00 \n",
"26307 0 25 395683.90 \n",
"26309 0 2 891553.40 \n",
"26313 0 1 80675.80 \n",
"26314 0 1 74195.06 \n",
"26315 0 1 2044158.00 \n",
"26317 0 1 151540.10 \n",
"26319 0 1 23024.96 \n",
"26321 0 1 7684.75 \n",
"26323 0 20 2481583.32 \n",
"26328 0 1 24149.27 \n",
"26330 0 2 102869.25 \n",
"26354 0 8 13089511.74 \n",
"26357 0 10 1040387.68 \n",
"26361 0 1 44077.96 \n",
"26373 0 3 149602.59 \n",
"\n",
" hash lastRefresh year \n",
"26304 7eb8d438fb0bd53206ca127d94cf8e8a 2018-02-07T18:49:20.589Z 2004 \n",
"26306 b05a733eb63a0dbdaa21f7ee63c39d40 2018-02-07T18:49:20.588Z 2004 \n",
"26307 5bb7dbed6118ed3ab94c865b018600bd 2018-02-07T18:49:20.548Z 2004 \n",
"26309 179961745b541fac38e509619d5143aa 2018-02-07T18:49:20.567Z 2004 \n",
"26313 fc18ff222e7a0fa1df5d6ff547468b21 2018-02-07T18:49:20.583Z 2004 \n",
"26314 84d62253d80b364f82206c0e04799eac 2018-02-07T18:49:20.588Z 2004 \n",
"26315 5dc8d2ada2701792abdb9039552badb2 2018-02-07T18:49:20.589Z 2004 \n",
"26317 4d4f9997cc56dee0411a14985c121e0a 2018-02-07T18:49:20.583Z 2004 \n",
"26319 05051ecdc86d749e0da316d73e9de0b6 2018-02-07T18:49:20.551Z 2004 \n",
"26321 48e8836ed988386fe8281e0f80944694 2018-02-07T18:49:20.557Z 2004 \n",
"26323 b3462d89c6754058d1dec100395e529c 2018-02-07T18:49:20.582Z 2004 \n",
"26328 9619539227c33847925869b97d007465 2018-02-07T18:49:20.567Z 2004 \n",
"26330 d483bb8e30040f6a476258585acc9587 2018-02-07T18:49:20.567Z 2004 \n",
"26354 ad7f29c8fe030592993a5e48902edc13 2018-02-07T18:49:20.542Z 2004 \n",
"26357 093f542f616bc781108fd8f8418cbee1 2018-02-07T18:49:20.541Z 2004 \n",
"26361 fdb75f3f98dca57cae88643e0c48ab39 2018-02-07T18:49:20.541Z 2004 \n",
"26373 c30524e1b2de73bf02893cefabb8a887 2018-02-07T18:49:20.542Z 2004 "
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pa.loc[pa['incidentType'] == 'Dam/Levee Break']"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Display the source blob
Display the rendered blob
Raw
still-open.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment