Process-NYT-File.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Process New York Times Data for USA by Counties\n",
    "https://github.com/nytimes/covid-19-data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Configurations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "datafile = './data/us-counties.csv'\n",
    "cases_save_file = 'COVID-19-Cases-USA-By-County.csv'\n",
    "deaths_save_file = 'COVID-19-Deaths-USA-By-County.csv'\n",
    "df = pd.read_csv(datafile, encoding='utf-8', index_col=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Process Case File"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>cases</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>fips</th>\n",
       "      <th>state</th>\n",
       "      <th>county</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-01-21</th>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-22</th>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-23</th>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2020-01-24</th>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2020-01-25</th>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-26</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-27</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-28</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-29</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2020-01-30</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">2020-04-02</th>\n",
       "      <th>55103.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Richland</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55105.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Rock</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55109.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>St. Croix</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55111.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sauk</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55117.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sheboygan</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55121.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Trempealeau</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55125.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Vilas</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55127.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Walworth</th>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55131.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Washington</th>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55133.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waukesha</th>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55135.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waupaca</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55139.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Winnebago</th>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55141.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Wood</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56001.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Albany</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56005.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Campbell</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56007.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Carbon</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56009.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Converse</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56013.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Fremont</th>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56015.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Goshen</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56017.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Hot Springs</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56019.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Johnson</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56021.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Laramie</th>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56025.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Natrona</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56029.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Park</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56033.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sheridan</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56035.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sublette</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56037.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sweetwater</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56039.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Teton</th>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56041.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Uinta</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56043.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Washakie</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28063 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           cases\n",
       "date       fips    state      county            \n",
       "2020-01-21 53061.0 Washington Snohomish        1\n",
       "2020-01-22 53061.0 Washington Snohomish        1\n",
       "2020-01-23 53061.0 Washington Snohomish        1\n",
       "2020-01-24 17031.0 Illinois   Cook             1\n",
       "           53061.0 Washington Snohomish        1\n",
       "2020-01-25 6059.0  California Orange           1\n",
       "           17031.0 Illinois   Cook             1\n",
       "           53061.0 Washington Snohomish        1\n",
       "2020-01-26 4013.0  Arizona    Maricopa         1\n",
       "           6037.0  California Los Angeles      1\n",
       "           6059.0  California Orange           1\n",
       "           17031.0 Illinois   Cook             1\n",
       "           53061.0 Washington Snohomish        1\n",
       "2020-01-27 4013.0  Arizona    Maricopa         1\n",
       "           6037.0  California Los Angeles      1\n",
       "           6059.0  California Orange           1\n",
       "           17031.0 Illinois   Cook             1\n",
       "           53061.0 Washington Snohomish        1\n",
       "2020-01-28 4013.0  Arizona    Maricopa         1\n",
       "           6037.0  California Los Angeles      1\n",
       "           6059.0  California Orange           1\n",
       "           17031.0 Illinois   Cook             1\n",
       "           53061.0 Washington Snohomish        1\n",
       "2020-01-29 4013.0  Arizona    Maricopa         1\n",
       "           6037.0  California Los Angeles      1\n",
       "           6059.0  California Orange           1\n",
       "           17031.0 Illinois   Cook             1\n",
       "           53061.0 Washington Snohomish        1\n",
       "2020-01-30 4013.0  Arizona    Maricopa         1\n",
       "           6037.0  California Los Angeles      1\n",
       "...                                          ...\n",
       "2020-04-02 55103.0 Wisconsin  Richland         2\n",
       "           55105.0 Wisconsin  Rock            19\n",
       "           55109.0 Wisconsin  St. Croix        6\n",
       "           55111.0 Wisconsin  Sauk            16\n",
       "           55117.0 Wisconsin  Sheboygan       16\n",
       "           55121.0 Wisconsin  Trempealeau      1\n",
       "           55125.0 Wisconsin  Vilas            3\n",
       "           55127.0 Wisconsin  Walworth        15\n",
       "           55131.0 Wisconsin  Washington      46\n",
       "           55133.0 Wisconsin  Waukesha       120\n",
       "           55135.0 Wisconsin  Waupaca          2\n",
       "           55139.0 Wisconsin  Winnebago       17\n",
       "           55141.0 Wisconsin  Wood             2\n",
       "           56001.0 Wyoming    Albany           3\n",
       "           56005.0 Wyoming    Campbell         6\n",
       "           56007.0 Wyoming    Carbon           3\n",
       "           56009.0 Wyoming    Converse         3\n",
       "           56013.0 Wyoming    Fremont         26\n",
       "           56015.0 Wyoming    Goshen           1\n",
       "           56017.0 Wyoming    Hot Springs      1\n",
       "           56019.0 Wyoming    Johnson          8\n",
       "           56021.0 Wyoming    Laramie         37\n",
       "           56025.0 Wyoming    Natrona         19\n",
       "           56029.0 Wyoming    Park             1\n",
       "           56033.0 Wyoming    Sheridan        10\n",
       "           56035.0 Wyoming    Sublette         1\n",
       "           56037.0 Wyoming    Sweetwater       3\n",
       "           56039.0 Wyoming    Teton           29\n",
       "           56041.0 Wyoming    Uinta            1\n",
       "           56043.0 Wyoming    Washakie         2\n",
       "\n",
       "[28063 rows x 1 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cases = df.groupby(['date', 'fips', 'state', 'county']).agg({'cases':'sum'})\n",
    "df_cases"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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></th>\n",
       "      <th>date</th>\n",
       "      <th>2020-01-21</th>\n",
       "      <th>2020-01-22</th>\n",
       "      <th>2020-01-23</th>\n",
       "      <th>2020-01-24</th>\n",
       "      <th>2020-01-25</th>\n",
       "      <th>2020-01-26</th>\n",
       "      <th>2020-01-27</th>\n",
       "      <th>2020-01-28</th>\n",
       "      <th>2020-01-29</th>\n",
       "      <th>2020-01-30</th>\n",
       "      <th>...</th>\n",
       "      <th>2020-03-25</th>\n",
       "      <th>2020-03-26</th>\n",
       "      <th>2020-03-27</th>\n",
       "      <th>2020-03-28</th>\n",
       "      <th>2020-03-29</th>\n",
       "      <th>2020-03-30</th>\n",
       "      <th>2020-03-31</th>\n",
       "      <th>2020-04-01</th>\n",
       "      <th>2020-04-02</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fips</th>\n",
       "      <th>state</th>\n",
       "      <th>county</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1001.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Autauga</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Baldwin</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1007.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Bibb</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Blount</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Bullock</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Butler</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Calhoun</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Chambers</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>15</td>\n",
       "      <td>17</td>\n",
       "      <td>27</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>45</td>\n",
       "      <td>67</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Cherokee</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Chilton</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Choctaw</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1025.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Clarke</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1027.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Clay</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Cleburne</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Coffee</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Colbert</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Conecuh</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1037.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Coosa</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1039.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Covington</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Crenshaw</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Cullman</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Dale</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Dallas</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>DeKalb</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Elmore</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>17</td>\n",
       "      <td>161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Escambia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Etowah</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Fayette</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Franklin</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Greene</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55105.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Rock</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55109.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>St. Croix</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55111.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sauk</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55117.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sheboygan</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55121.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Trempealeau</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55125.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Vilas</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55127.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Walworth</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55131.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Washington</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21</td>\n",
       "      <td>25</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>34</td>\n",
       "      <td>40</td>\n",
       "      <td>44</td>\n",
       "      <td>46</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55133.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waukesha</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>56</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>83</td>\n",
       "      <td>93</td>\n",
       "      <td>101</td>\n",
       "      <td>107</td>\n",
       "      <td>120</td>\n",
       "      <td>895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55135.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waupaca</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55139.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Winnebago</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55141.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Wood</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56001.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Albany</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56005.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Campbell</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56007.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Carbon</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56009.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Converse</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56013.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Fremont</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>21</td>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56015.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Goshen</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56017.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Hot Springs</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56019.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Johnson</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56021.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Laramie</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>27</td>\n",
       "      <td>35</td>\n",
       "      <td>37</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56025.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Natrona</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>19</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56029.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Park</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56033.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sheridan</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56035.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sublette</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56037.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sweetwater</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56039.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Teton</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>26</td>\n",
       "      <td>29</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56041.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Uinta</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56043.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Washakie</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>46831</td>\n",
       "      <td>59719</td>\n",
       "      <td>73982</td>\n",
       "      <td>88829</td>\n",
       "      <td>103316</td>\n",
       "      <td>119749</td>\n",
       "      <td>139169</td>\n",
       "      <td>159939</td>\n",
       "      <td>184476</td>\n",
       "      <td>1139790</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2285 rows × 74 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "date                           2020-01-21  2020-01-22  2020-01-23  2020-01-24  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               0           0           0           0   \n",
       "1003.0  Alabama   Baldwin               0           0           0           0   \n",
       "1007.0  Alabama   Bibb                  0           0           0           0   \n",
       "1009.0  Alabama   Blount                0           0           0           0   \n",
       "1011.0  Alabama   Bullock               0           0           0           0   \n",
       "1013.0  Alabama   Butler                0           0           0           0   \n",
       "1015.0  Alabama   Calhoun               0           0           0           0   \n",
       "1017.0  Alabama   Chambers              0           0           0           0   \n",
       "1019.0  Alabama   Cherokee              0           0           0           0   \n",
       "1021.0  Alabama   Chilton               0           0           0           0   \n",
       "1023.0  Alabama   Choctaw               0           0           0           0   \n",
       "1025.0  Alabama   Clarke                0           0           0           0   \n",
       "1027.0  Alabama   Clay                  0           0           0           0   \n",
       "1029.0  Alabama   Cleburne              0           0           0           0   \n",
       "1031.0  Alabama   Coffee                0           0           0           0   \n",
       "1033.0  Alabama   Colbert               0           0           0           0   \n",
       "1035.0  Alabama   Conecuh               0           0           0           0   \n",
       "1037.0  Alabama   Coosa                 0           0           0           0   \n",
       "1039.0  Alabama   Covington             0           0           0           0   \n",
       "1041.0  Alabama   Crenshaw              0           0           0           0   \n",
       "1043.0  Alabama   Cullman               0           0           0           0   \n",
       "1045.0  Alabama   Dale                  0           0           0           0   \n",
       "1047.0  Alabama   Dallas                0           0           0           0   \n",
       "1049.0  Alabama   DeKalb                0           0           0           0   \n",
       "1051.0  Alabama   Elmore                0           0           0           0   \n",
       "1053.0  Alabama   Escambia              0           0           0           0   \n",
       "1055.0  Alabama   Etowah                0           0           0           0   \n",
       "1057.0  Alabama   Fayette               0           0           0           0   \n",
       "1059.0  Alabama   Franklin              0           0           0           0   \n",
       "1063.0  Alabama   Greene                0           0           0           0   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                  0           0           0           0   \n",
       "55109.0 Wisconsin St. Croix             0           0           0           0   \n",
       "55111.0 Wisconsin Sauk                  0           0           0           0   \n",
       "55117.0 Wisconsin Sheboygan             0           0           0           0   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           0   \n",
       "55125.0 Wisconsin Vilas                 0           0           0           0   \n",
       "55127.0 Wisconsin Walworth              0           0           0           0   \n",
       "55131.0 Wisconsin Washington            0           0           0           0   \n",
       "55133.0 Wisconsin Waukesha              0           0           0           0   \n",
       "55135.0 Wisconsin Waupaca               0           0           0           0   \n",
       "55139.0 Wisconsin Winnebago             0           0           0           0   \n",
       "55141.0 Wisconsin Wood                  0           0           0           0   \n",
       "56001.0 Wyoming   Albany                0           0           0           0   \n",
       "56005.0 Wyoming   Campbell              0           0           0           0   \n",
       "56007.0 Wyoming   Carbon                0           0           0           0   \n",
       "56009.0 Wyoming   Converse              0           0           0           0   \n",
       "56013.0 Wyoming   Fremont               0           0           0           0   \n",
       "56015.0 Wyoming   Goshen                0           0           0           0   \n",
       "56017.0 Wyoming   Hot Springs           0           0           0           0   \n",
       "56019.0 Wyoming   Johnson               0           0           0           0   \n",
       "56021.0 Wyoming   Laramie               0           0           0           0   \n",
       "56025.0 Wyoming   Natrona               0           0           0           0   \n",
       "56029.0 Wyoming   Park                  0           0           0           0   \n",
       "56033.0 Wyoming   Sheridan              0           0           0           0   \n",
       "56035.0 Wyoming   Sublette              0           0           0           0   \n",
       "56037.0 Wyoming   Sweetwater            0           0           0           0   \n",
       "56039.0 Wyoming   Teton                 0           0           0           0   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           0   \n",
       "56043.0 Wyoming   Washakie              0           0           0           0   \n",
       "All                                     1           1           1           2   \n",
       "\n",
       "date                           2020-01-25  2020-01-26  2020-01-27  2020-01-28  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               0           0           0           0   \n",
       "1003.0  Alabama   Baldwin               0           0           0           0   \n",
       "1007.0  Alabama   Bibb                  0           0           0           0   \n",
       "1009.0  Alabama   Blount                0           0           0           0   \n",
       "1011.0  Alabama   Bullock               0           0           0           0   \n",
       "1013.0  Alabama   Butler                0           0           0           0   \n",
       "1015.0  Alabama   Calhoun               0           0           0           0   \n",
       "1017.0  Alabama   Chambers              0           0           0           0   \n",
       "1019.0  Alabama   Cherokee              0           0           0           0   \n",
       "1021.0  Alabama   Chilton               0           0           0           0   \n",
       "1023.0  Alabama   Choctaw               0           0           0           0   \n",
       "1025.0  Alabama   Clarke                0           0           0           0   \n",
       "1027.0  Alabama   Clay                  0           0           0           0   \n",
       "1029.0  Alabama   Cleburne              0           0           0           0   \n",
       "1031.0  Alabama   Coffee                0           0           0           0   \n",
       "1033.0  Alabama   Colbert               0           0           0           0   \n",
       "1035.0  Alabama   Conecuh               0           0           0           0   \n",
       "1037.0  Alabama   Coosa                 0           0           0           0   \n",
       "1039.0  Alabama   Covington             0           0           0           0   \n",
       "1041.0  Alabama   Crenshaw              0           0           0           0   \n",
       "1043.0  Alabama   Cullman               0           0           0           0   \n",
       "1045.0  Alabama   Dale                  0           0           0           0   \n",
       "1047.0  Alabama   Dallas                0           0           0           0   \n",
       "1049.0  Alabama   DeKalb                0           0           0           0   \n",
       "1051.0  Alabama   Elmore                0           0           0           0   \n",
       "1053.0  Alabama   Escambia              0           0           0           0   \n",
       "1055.0  Alabama   Etowah                0           0           0           0   \n",
       "1057.0  Alabama   Fayette               0           0           0           0   \n",
       "1059.0  Alabama   Franklin              0           0           0           0   \n",
       "1063.0  Alabama   Greene                0           0           0           0   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                  0           0           0           0   \n",
       "55109.0 Wisconsin St. Croix             0           0           0           0   \n",
       "55111.0 Wisconsin Sauk                  0           0           0           0   \n",
       "55117.0 Wisconsin Sheboygan             0           0           0           0   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           0   \n",
       "55125.0 Wisconsin Vilas                 0           0           0           0   \n",
       "55127.0 Wisconsin Walworth              0           0           0           0   \n",
       "55131.0 Wisconsin Washington            0           0           0           0   \n",
       "55133.0 Wisconsin Waukesha              0           0           0           0   \n",
       "55135.0 Wisconsin Waupaca               0           0           0           0   \n",
       "55139.0 Wisconsin Winnebago             0           0           0           0   \n",
       "55141.0 Wisconsin Wood                  0           0           0           0   \n",
       "56001.0 Wyoming   Albany                0           0           0           0   \n",
       "56005.0 Wyoming   Campbell              0           0           0           0   \n",
       "56007.0 Wyoming   Carbon                0           0           0           0   \n",
       "56009.0 Wyoming   Converse              0           0           0           0   \n",
       "56013.0 Wyoming   Fremont               0           0           0           0   \n",
       "56015.0 Wyoming   Goshen                0           0           0           0   \n",
       "56017.0 Wyoming   Hot Springs           0           0           0           0   \n",
       "56019.0 Wyoming   Johnson               0           0           0           0   \n",
       "56021.0 Wyoming   Laramie               0           0           0           0   \n",
       "56025.0 Wyoming   Natrona               0           0           0           0   \n",
       "56029.0 Wyoming   Park                  0           0           0           0   \n",
       "56033.0 Wyoming   Sheridan              0           0           0           0   \n",
       "56035.0 Wyoming   Sublette              0           0           0           0   \n",
       "56037.0 Wyoming   Sweetwater            0           0           0           0   \n",
       "56039.0 Wyoming   Teton                 0           0           0           0   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           0   \n",
       "56043.0 Wyoming   Washakie              0           0           0           0   \n",
       "All                                     3           5           5           5   \n",
       "\n",
       "date                           2020-01-29  2020-01-30   ...     2020-03-25  \\\n",
       "fips    state     county                                ...                  \n",
       "1001.0  Alabama   Autauga               0           0   ...              4   \n",
       "1003.0  Alabama   Baldwin               0           0   ...              4   \n",
       "1007.0  Alabama   Bibb                  0           0   ...              0   \n",
       "1009.0  Alabama   Blount                0           0   ...              1   \n",
       "1011.0  Alabama   Bullock               0           0   ...              0   \n",
       "1013.0  Alabama   Butler                0           0   ...              1   \n",
       "1015.0  Alabama   Calhoun               0           0   ...              2   \n",
       "1017.0  Alabama   Chambers              0           0   ...             10   \n",
       "1019.0  Alabama   Cherokee              0           0   ...              1   \n",
       "1021.0  Alabama   Chilton               0           0   ...              1   \n",
       "1023.0  Alabama   Choctaw               0           0   ...              0   \n",
       "1025.0  Alabama   Clarke                0           0   ...              0   \n",
       "1027.0  Alabama   Clay                  0           0   ...              1   \n",
       "1029.0  Alabama   Cleburne              0           0   ...              1   \n",
       "1031.0  Alabama   Coffee                0           0   ...              0   \n",
       "1033.0  Alabama   Colbert               0           0   ...              1   \n",
       "1035.0  Alabama   Conecuh               0           0   ...              0   \n",
       "1037.0  Alabama   Coosa                 0           0   ...              0   \n",
       "1039.0  Alabama   Covington             0           0   ...              0   \n",
       "1041.0  Alabama   Crenshaw              0           0   ...              0   \n",
       "1043.0  Alabama   Cullman               0           0   ...              4   \n",
       "1045.0  Alabama   Dale                  0           0   ...              0   \n",
       "1047.0  Alabama   Dallas                0           0   ...              2   \n",
       "1049.0  Alabama   DeKalb                0           0   ...              0   \n",
       "1051.0  Alabama   Elmore                0           0   ...              9   \n",
       "1053.0  Alabama   Escambia              0           0   ...              0   \n",
       "1055.0  Alabama   Etowah                0           0   ...              3   \n",
       "1057.0  Alabama   Fayette               0           0   ...              0   \n",
       "1059.0  Alabama   Franklin              0           0   ...              2   \n",
       "1063.0  Alabama   Greene                0           0   ...              0   \n",
       "...                                   ...         ...   ...            ...   \n",
       "55105.0 Wisconsin Rock                  0           0   ...              4   \n",
       "55109.0 Wisconsin St. Croix             0           0   ...              4   \n",
       "55111.0 Wisconsin Sauk                  0           0   ...              6   \n",
       "55117.0 Wisconsin Sheboygan             0           0   ...              7   \n",
       "55121.0 Wisconsin Trempealeau           0           0   ...              0   \n",
       "55125.0 Wisconsin Vilas                 0           0   ...              0   \n",
       "55127.0 Wisconsin Walworth              0           0   ...              5   \n",
       "55131.0 Wisconsin Washington            0           0   ...             21   \n",
       "55133.0 Wisconsin Waukesha              0           0   ...             42   \n",
       "55135.0 Wisconsin Waupaca               0           0   ...              0   \n",
       "55139.0 Wisconsin Winnebago             0           0   ...              5   \n",
       "55141.0 Wisconsin Wood                  0           0   ...              1   \n",
       "56001.0 Wyoming   Albany                0           0   ...              1   \n",
       "56005.0 Wyoming   Campbell              0           0   ...              1   \n",
       "56007.0 Wyoming   Carbon                0           0   ...              3   \n",
       "56009.0 Wyoming   Converse              0           0   ...              0   \n",
       "56013.0 Wyoming   Fremont               0           0   ...             14   \n",
       "56015.0 Wyoming   Goshen                0           0   ...              0   \n",
       "56017.0 Wyoming   Hot Springs           0           0   ...              0   \n",
       "56019.0 Wyoming   Johnson               0           0   ...              0   \n",
       "56021.0 Wyoming   Laramie               0           0   ...             12   \n",
       "56025.0 Wyoming   Natrona               0           0   ...              6   \n",
       "56029.0 Wyoming   Park                  0           0   ...              1   \n",
       "56033.0 Wyoming   Sheridan              0           0   ...              4   \n",
       "56035.0 Wyoming   Sublette              0           0   ...              0   \n",
       "56037.0 Wyoming   Sweetwater            0           0   ...              1   \n",
       "56039.0 Wyoming   Teton                 0           0   ...              6   \n",
       "56041.0 Wyoming   Uinta                 0           0   ...              0   \n",
       "56043.0 Wyoming   Washakie              0           0   ...              0   \n",
       "All                                     5           6   ...          46831   \n",
       "\n",
       "date                           2020-03-26  2020-03-27  2020-03-28  2020-03-29  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               6           6           6           6   \n",
       "1003.0  Alabama   Baldwin               5           5          10          15   \n",
       "1007.0  Alabama   Bibb                  0           0           0           0   \n",
       "1009.0  Alabama   Blount                3           5           5           5   \n",
       "1011.0  Alabama   Bullock               2           2           3           3   \n",
       "1013.0  Alabama   Butler                1           1           1           1   \n",
       "1015.0  Alabama   Calhoun               2           3           3           3   \n",
       "1017.0  Alabama   Chambers             13          15          17          27   \n",
       "1019.0  Alabama   Cherokee              1           1           1           2   \n",
       "1021.0  Alabama   Chilton               4           7           7           8   \n",
       "1023.0  Alabama   Choctaw               1           1           1           1   \n",
       "1025.0  Alabama   Clarke                0           0           0           0   \n",
       "1027.0  Alabama   Clay                  1           1           2           2   \n",
       "1029.0  Alabama   Cleburne              1           3           4           5   \n",
       "1031.0  Alabama   Coffee                0           0           0           0   \n",
       "1033.0  Alabama   Colbert               1           1           1           2   \n",
       "1035.0  Alabama   Conecuh               0           0           0           0   \n",
       "1037.0  Alabama   Coosa                 2           2           2           3   \n",
       "1039.0  Alabama   Covington             0           2           2           2   \n",
       "1041.0  Alabama   Crenshaw              1           1           1           1   \n",
       "1043.0  Alabama   Cullman               6           7           7           7   \n",
       "1045.0  Alabama   Dale                  0           0           0           0   \n",
       "1047.0  Alabama   Dallas                2           2           2           2   \n",
       "1049.0  Alabama   DeKalb                1           4           4           4   \n",
       "1051.0  Alabama   Elmore               10          12          13          13   \n",
       "1053.0  Alabama   Escambia              0           1           1           1   \n",
       "1055.0  Alabama   Etowah                4           5           6           6   \n",
       "1057.0  Alabama   Fayette               0           0           0           0   \n",
       "1059.0  Alabama   Franklin              3           3           3           3   \n",
       "1063.0  Alabama   Greene                0           1           3           3   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                  8          12          12          14   \n",
       "55109.0 Wisconsin St. Croix             4           4           4           4   \n",
       "55111.0 Wisconsin Sauk                  7           8          11          12   \n",
       "55117.0 Wisconsin Sheboygan             7           7           8           8   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           0   \n",
       "55125.0 Wisconsin Vilas                 1           2           2           2   \n",
       "55127.0 Wisconsin Walworth              5           5           6           6   \n",
       "55131.0 Wisconsin Washington           25          27          31          31   \n",
       "55133.0 Wisconsin Waukesha             56          61          72          83   \n",
       "55135.0 Wisconsin Waupaca               0           1           1           1   \n",
       "55139.0 Wisconsin Winnebago             6           6           7           8   \n",
       "55141.0 Wisconsin Wood                  2           2           2           2   \n",
       "56001.0 Wyoming   Albany                1           1           1           1   \n",
       "56005.0 Wyoming   Campbell              1           1           1           1   \n",
       "56007.0 Wyoming   Carbon                3           3           3           3   \n",
       "56009.0 Wyoming   Converse              0           0           1           1   \n",
       "56013.0 Wyoming   Fremont              14          17          21          23   \n",
       "56015.0 Wyoming   Goshen                0           1           1           1   \n",
       "56017.0 Wyoming   Hot Springs           1           1           1           1   \n",
       "56019.0 Wyoming   Johnson               1           4           5           5   \n",
       "56021.0 Wyoming   Laramie              15          18          19          19   \n",
       "56025.0 Wyoming   Natrona               6           8           8           9   \n",
       "56029.0 Wyoming   Park                  1           1           1           1   \n",
       "56033.0 Wyoming   Sheridan              4           5           6           6   \n",
       "56035.0 Wyoming   Sublette              0           0           1           1   \n",
       "56037.0 Wyoming   Sweetwater            1           1           1           1   \n",
       "56039.0 Wyoming   Teton                 8          12          14          14   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           0   \n",
       "56043.0 Wyoming   Washakie              0           1           1           1   \n",
       "All                                 59719       73982       88829      103316   \n",
       "\n",
       "date                           2020-03-30  2020-03-31  2020-04-01  2020-04-02  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               7           7          10          10   \n",
       "1003.0  Alabama   Baldwin              18          19          23          25   \n",
       "1007.0  Alabama   Bibb                  2           3           3           4   \n",
       "1009.0  Alabama   Blount                5           5           5           6   \n",
       "1011.0  Alabama   Bullock               3           3           3           2   \n",
       "1013.0  Alabama   Butler                1           1           1           1   \n",
       "1015.0  Alabama   Calhoun               9           9          11          12   \n",
       "1017.0  Alabama   Chambers             36          36          45          67   \n",
       "1019.0  Alabama   Cherokee              2           2           2           4   \n",
       "1021.0  Alabama   Chilton              10          11          13          14   \n",
       "1023.0  Alabama   Choctaw               2           3           4           4   \n",
       "1025.0  Alabama   Clarke                0           0           2           2   \n",
       "1027.0  Alabama   Clay                  2           2           3           7   \n",
       "1029.0  Alabama   Cleburne              5           5           6           6   \n",
       "1031.0  Alabama   Coffee                0           0           0           3   \n",
       "1033.0  Alabama   Colbert               4           4           4           5   \n",
       "1035.0  Alabama   Conecuh               0           0           1           1   \n",
       "1037.0  Alabama   Coosa                 4           4           4           6   \n",
       "1039.0  Alabama   Covington             2           2           3           3   \n",
       "1041.0  Alabama   Crenshaw              1           1           1           1   \n",
       "1043.0  Alabama   Cullman               8           8           9           9   \n",
       "1045.0  Alabama   Dale                  0           0           1           1   \n",
       "1047.0  Alabama   Dallas                2           2           3           4   \n",
       "1049.0  Alabama   DeKalb                4           4           6           8   \n",
       "1051.0  Alabama   Elmore               13          12          15          17   \n",
       "1053.0  Alabama   Escambia              1           1           1           2   \n",
       "1055.0  Alabama   Etowah                6           8          10          13   \n",
       "1057.0  Alabama   Fayette               1           1           1           1   \n",
       "1059.0  Alabama   Franklin              3           3           3           4   \n",
       "1063.0  Alabama   Greene                3           3           4           4   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                 15          16          17          19   \n",
       "55109.0 Wisconsin St. Croix             4           5           6           6   \n",
       "55111.0 Wisconsin Sauk                 13          13          14          16   \n",
       "55117.0 Wisconsin Sheboygan             8          11          14          16   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           1   \n",
       "55125.0 Wisconsin Vilas                 3           3           3           3   \n",
       "55127.0 Wisconsin Walworth              6           6          12          15   \n",
       "55131.0 Wisconsin Washington           34          40          44          46   \n",
       "55133.0 Wisconsin Waukesha             93         101         107         120   \n",
       "55135.0 Wisconsin Waupaca               1           1           2           2   \n",
       "55139.0 Wisconsin Winnebago            10          11          13          17   \n",
       "55141.0 Wisconsin Wood                  2           2           2           2   \n",
       "56001.0 Wyoming   Albany                1           3           3           3   \n",
       "56005.0 Wyoming   Campbell              1           3           5           6   \n",
       "56007.0 Wyoming   Carbon                3           3           3           3   \n",
       "56009.0 Wyoming   Converse              1           1           2           3   \n",
       "56013.0 Wyoming   Fremont              24          25          25          26   \n",
       "56015.0 Wyoming   Goshen                1           1           1           1   \n",
       "56017.0 Wyoming   Hot Springs           1           1           1           1   \n",
       "56019.0 Wyoming   Johnson               5           7           7           8   \n",
       "56021.0 Wyoming   Laramie              20          27          35          37   \n",
       "56025.0 Wyoming   Natrona               9          12          14          19   \n",
       "56029.0 Wyoming   Park                  1           1           1           1   \n",
       "56033.0 Wyoming   Sheridan              8          10          10          10   \n",
       "56035.0 Wyoming   Sublette              1           1           1           1   \n",
       "56037.0 Wyoming   Sweetwater            2           2           3           3   \n",
       "56039.0 Wyoming   Teton                17          23          26          29   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           1   \n",
       "56043.0 Wyoming   Washakie              1           1           1           2   \n",
       "All                                119749      139169      159939      184476   \n",
       "\n",
       "date                               All  \n",
       "fips    state     county                \n",
       "1001.0  Alabama   Autauga           63  \n",
       "1003.0  Alabama   Baldwin          143  \n",
       "1007.0  Alabama   Bibb              12  \n",
       "1009.0  Alabama   Blount            40  \n",
       "1011.0  Alabama   Bullock           21  \n",
       "1013.0  Alabama   Butler             9  \n",
       "1015.0  Alabama   Calhoun           63  \n",
       "1017.0  Alabama   Chambers         278  \n",
       "1019.0  Alabama   Cherokee          16  \n",
       "1021.0  Alabama   Chilton           75  \n",
       "1023.0  Alabama   Choctaw           17  \n",
       "1025.0  Alabama   Clarke             4  \n",
       "1027.0  Alabama   Clay              21  \n",
       "1029.0  Alabama   Cleburne          36  \n",
       "1031.0  Alabama   Coffee             3  \n",
       "1033.0  Alabama   Colbert           23  \n",
       "1035.0  Alabama   Conecuh            2  \n",
       "1037.0  Alabama   Coosa             27  \n",
       "1039.0  Alabama   Covington         16  \n",
       "1041.0  Alabama   Crenshaw           8  \n",
       "1043.0  Alabama   Cullman           75  \n",
       "1045.0  Alabama   Dale               2  \n",
       "1047.0  Alabama   Dallas            21  \n",
       "1049.0  Alabama   DeKalb            35  \n",
       "1051.0  Alabama   Elmore           161  \n",
       "1053.0  Alabama   Escambia           8  \n",
       "1055.0  Alabama   Etowah            61  \n",
       "1057.0  Alabama   Fayette            4  \n",
       "1059.0  Alabama   Franklin          29  \n",
       "1063.0  Alabama   Greene            21  \n",
       "...                                ...  \n",
       "55105.0 Wisconsin Rock             130  \n",
       "55109.0 Wisconsin St. Croix         54  \n",
       "55111.0 Wisconsin Sauk             114  \n",
       "55117.0 Wisconsin Sheboygan        141  \n",
       "55121.0 Wisconsin Trempealeau        1  \n",
       "55125.0 Wisconsin Vilas             19  \n",
       "55127.0 Wisconsin Walworth          84  \n",
       "55131.0 Wisconsin Washington       355  \n",
       "55133.0 Wisconsin Waukesha         895  \n",
       "55135.0 Wisconsin Waupaca            9  \n",
       "55139.0 Wisconsin Winnebago        124  \n",
       "55141.0 Wisconsin Wood              26  \n",
       "56001.0 Wyoming   Albany            15  \n",
       "56005.0 Wyoming   Campbell          25  \n",
       "56007.0 Wyoming   Carbon            34  \n",
       "56009.0 Wyoming   Converse           9  \n",
       "56013.0 Wyoming   Fremont          274  \n",
       "56015.0 Wyoming   Goshen             7  \n",
       "56017.0 Wyoming   Hot Springs        8  \n",
       "56019.0 Wyoming   Johnson           42  \n",
       "56021.0 Wyoming   Laramie          241  \n",
       "56025.0 Wyoming   Natrona           99  \n",
       "56029.0 Wyoming   Park              17  \n",
       "56033.0 Wyoming   Sheridan         104  \n",
       "56035.0 Wyoming   Sublette           6  \n",
       "56037.0 Wyoming   Sweetwater        16  \n",
       "56039.0 Wyoming   Teton            162  \n",
       "56041.0 Wyoming   Uinta              1  \n",
       "56043.0 Wyoming   Washakie           8  \n",
       "All                            1139790  \n",
       "\n",
       "[2285 rows x 74 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_cases = df_cases.reset_index().pivot_table(index=['fips','state', 'county'], columns='date', values='cases',  aggfunc=sum,  margins=True, fill_value=0)\n",
    "df_cases"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Process Deaths File"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>deaths</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>fips</th>\n",
       "      <th>state</th>\n",
       "      <th>county</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-01-21</th>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-22</th>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-01-23</th>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2020-01-24</th>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2020-01-25</th>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-26</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-27</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-28</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2020-01-29</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6059.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Orange</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17031.0</th>\n",
       "      <th>Illinois</th>\n",
       "      <th>Cook</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53061.0</th>\n",
       "      <th>Washington</th>\n",
       "      <th>Snohomish</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2020-01-30</th>\n",
       "      <th>4013.0</th>\n",
       "      <th>Arizona</th>\n",
       "      <th>Maricopa</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6037.0</th>\n",
       "      <th>California</th>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">2020-04-02</th>\n",
       "      <th>55103.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Richland</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55105.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Rock</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55109.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>St. Croix</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55111.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sauk</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55117.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sheboygan</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55121.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Trempealeau</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55125.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Vilas</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55127.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Walworth</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55131.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Washington</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55133.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waukesha</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55135.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waupaca</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55139.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Winnebago</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55141.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Wood</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56001.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Albany</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56005.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Campbell</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56007.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Carbon</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56009.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Converse</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56013.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Fremont</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56015.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Goshen</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56017.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Hot Springs</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56019.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Johnson</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56021.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Laramie</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56025.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Natrona</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56029.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Park</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56033.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sheridan</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56035.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sublette</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56037.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sweetwater</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56039.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Teton</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56041.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Uinta</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56043.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Washakie</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28063 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           deaths\n",
       "date       fips    state      county             \n",
       "2020-01-21 53061.0 Washington Snohomish         0\n",
       "2020-01-22 53061.0 Washington Snohomish         0\n",
       "2020-01-23 53061.0 Washington Snohomish         0\n",
       "2020-01-24 17031.0 Illinois   Cook              0\n",
       "           53061.0 Washington Snohomish         0\n",
       "2020-01-25 6059.0  California Orange            0\n",
       "           17031.0 Illinois   Cook              0\n",
       "           53061.0 Washington Snohomish         0\n",
       "2020-01-26 4013.0  Arizona    Maricopa          0\n",
       "           6037.0  California Los Angeles       0\n",
       "           6059.0  California Orange            0\n",
       "           17031.0 Illinois   Cook              0\n",
       "           53061.0 Washington Snohomish         0\n",
       "2020-01-27 4013.0  Arizona    Maricopa          0\n",
       "           6037.0  California Los Angeles       0\n",
       "           6059.0  California Orange            0\n",
       "           17031.0 Illinois   Cook              0\n",
       "           53061.0 Washington Snohomish         0\n",
       "2020-01-28 4013.0  Arizona    Maricopa          0\n",
       "           6037.0  California Los Angeles       0\n",
       "           6059.0  California Orange            0\n",
       "           17031.0 Illinois   Cook              0\n",
       "           53061.0 Washington Snohomish         0\n",
       "2020-01-29 4013.0  Arizona    Maricopa          0\n",
       "           6037.0  California Los Angeles       0\n",
       "           6059.0  California Orange            0\n",
       "           17031.0 Illinois   Cook              0\n",
       "           53061.0 Washington Snohomish         0\n",
       "2020-01-30 4013.0  Arizona    Maricopa          0\n",
       "           6037.0  California Los Angeles       0\n",
       "...                                           ...\n",
       "2020-04-02 55103.0 Wisconsin  Richland          0\n",
       "           55105.0 Wisconsin  Rock              1\n",
       "           55109.0 Wisconsin  St. Croix         0\n",
       "           55111.0 Wisconsin  Sauk              2\n",
       "           55117.0 Wisconsin  Sheboygan         1\n",
       "           55121.0 Wisconsin  Trempealeau       0\n",
       "           55125.0 Wisconsin  Vilas             0\n",
       "           55127.0 Wisconsin  Walworth          0\n",
       "           55131.0 Wisconsin  Washington        2\n",
       "           55133.0 Wisconsin  Waukesha          1\n",
       "           55135.0 Wisconsin  Waupaca           1\n",
       "           55139.0 Wisconsin  Winnebago         0\n",
       "           55141.0 Wisconsin  Wood              0\n",
       "           56001.0 Wyoming    Albany            0\n",
       "           56005.0 Wyoming    Campbell          0\n",
       "           56007.0 Wyoming    Carbon            0\n",
       "           56009.0 Wyoming    Converse          0\n",
       "           56013.0 Wyoming    Fremont           0\n",
       "           56015.0 Wyoming    Goshen            0\n",
       "           56017.0 Wyoming    Hot Springs       0\n",
       "           56019.0 Wyoming    Johnson           0\n",
       "           56021.0 Wyoming    Laramie           0\n",
       "           56025.0 Wyoming    Natrona           0\n",
       "           56029.0 Wyoming    Park              0\n",
       "           56033.0 Wyoming    Sheridan          0\n",
       "           56035.0 Wyoming    Sublette          0\n",
       "           56037.0 Wyoming    Sweetwater        0\n",
       "           56039.0 Wyoming    Teton             0\n",
       "           56041.0 Wyoming    Uinta             0\n",
       "           56043.0 Wyoming    Washakie          0\n",
       "\n",
       "[28063 rows x 1 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_deaths = df.groupby(['date', 'fips', 'state', 'county']).agg({'deaths':'sum'})\n",
    "df_deaths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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></th>\n",
       "      <th>date</th>\n",
       "      <th>2020-01-21</th>\n",
       "      <th>2020-01-22</th>\n",
       "      <th>2020-01-23</th>\n",
       "      <th>2020-01-24</th>\n",
       "      <th>2020-01-25</th>\n",
       "      <th>2020-01-26</th>\n",
       "      <th>2020-01-27</th>\n",
       "      <th>2020-01-28</th>\n",
       "      <th>2020-01-29</th>\n",
       "      <th>2020-01-30</th>\n",
       "      <th>...</th>\n",
       "      <th>2020-03-25</th>\n",
       "      <th>2020-03-26</th>\n",
       "      <th>2020-03-27</th>\n",
       "      <th>2020-03-28</th>\n",
       "      <th>2020-03-29</th>\n",
       "      <th>2020-03-30</th>\n",
       "      <th>2020-03-31</th>\n",
       "      <th>2020-04-01</th>\n",
       "      <th>2020-04-02</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fips</th>\n",
       "      <th>state</th>\n",
       "      <th>county</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1001.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Autauga</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Baldwin</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1007.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Bibb</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Blount</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Bullock</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Butler</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Calhoun</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Chambers</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>15</td>\n",
       "      <td>17</td>\n",
       "      <td>27</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "      <td>45</td>\n",
       "      <td>67</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Cherokee</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Chilton</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Choctaw</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1025.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Clarke</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1027.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Clay</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Cleburne</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Coffee</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Colbert</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Conecuh</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1037.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Coosa</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1039.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Covington</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Crenshaw</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Cullman</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Dale</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Dallas</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>DeKalb</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Elmore</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>17</td>\n",
       "      <td>161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Escambia</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Etowah</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Fayette</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Franklin</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063.0</th>\n",
       "      <th>Alabama</th>\n",
       "      <th>Greene</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55105.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Rock</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55109.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>St. Croix</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55111.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sauk</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55117.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Sheboygan</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55121.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Trempealeau</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55125.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Vilas</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55127.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Walworth</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55131.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Washington</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21</td>\n",
       "      <td>25</td>\n",
       "      <td>27</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>34</td>\n",
       "      <td>40</td>\n",
       "      <td>44</td>\n",
       "      <td>46</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55133.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waukesha</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>42</td>\n",
       "      <td>56</td>\n",
       "      <td>61</td>\n",
       "      <td>72</td>\n",
       "      <td>83</td>\n",
       "      <td>93</td>\n",
       "      <td>101</td>\n",
       "      <td>107</td>\n",
       "      <td>120</td>\n",
       "      <td>895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55135.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Waupaca</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55139.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Winnebago</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55141.0</th>\n",
       "      <th>Wisconsin</th>\n",
       "      <th>Wood</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56001.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Albany</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56005.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Campbell</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56007.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Carbon</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56009.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Converse</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56013.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Fremont</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>21</td>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56015.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Goshen</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56017.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Hot Springs</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56019.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Johnson</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56021.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Laramie</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>27</td>\n",
       "      <td>35</td>\n",
       "      <td>37</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56025.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Natrona</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>19</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56029.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Park</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56033.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sheridan</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56035.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sublette</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56037.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Sweetwater</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56039.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Teton</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>26</td>\n",
       "      <td>29</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56041.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Uinta</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56043.0</th>\n",
       "      <th>Wyoming</th>\n",
       "      <th>Washakie</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>46831</td>\n",
       "      <td>59719</td>\n",
       "      <td>73982</td>\n",
       "      <td>88829</td>\n",
       "      <td>103316</td>\n",
       "      <td>119749</td>\n",
       "      <td>139169</td>\n",
       "      <td>159939</td>\n",
       "      <td>184476</td>\n",
       "      <td>1139790</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2285 rows × 74 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "date                           2020-01-21  2020-01-22  2020-01-23  2020-01-24  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               0           0           0           0   \n",
       "1003.0  Alabama   Baldwin               0           0           0           0   \n",
       "1007.0  Alabama   Bibb                  0           0           0           0   \n",
       "1009.0  Alabama   Blount                0           0           0           0   \n",
       "1011.0  Alabama   Bullock               0           0           0           0   \n",
       "1013.0  Alabama   Butler                0           0           0           0   \n",
       "1015.0  Alabama   Calhoun               0           0           0           0   \n",
       "1017.0  Alabama   Chambers              0           0           0           0   \n",
       "1019.0  Alabama   Cherokee              0           0           0           0   \n",
       "1021.0  Alabama   Chilton               0           0           0           0   \n",
       "1023.0  Alabama   Choctaw               0           0           0           0   \n",
       "1025.0  Alabama   Clarke                0           0           0           0   \n",
       "1027.0  Alabama   Clay                  0           0           0           0   \n",
       "1029.0  Alabama   Cleburne              0           0           0           0   \n",
       "1031.0  Alabama   Coffee                0           0           0           0   \n",
       "1033.0  Alabama   Colbert               0           0           0           0   \n",
       "1035.0  Alabama   Conecuh               0           0           0           0   \n",
       "1037.0  Alabama   Coosa                 0           0           0           0   \n",
       "1039.0  Alabama   Covington             0           0           0           0   \n",
       "1041.0  Alabama   Crenshaw              0           0           0           0   \n",
       "1043.0  Alabama   Cullman               0           0           0           0   \n",
       "1045.0  Alabama   Dale                  0           0           0           0   \n",
       "1047.0  Alabama   Dallas                0           0           0           0   \n",
       "1049.0  Alabama   DeKalb                0           0           0           0   \n",
       "1051.0  Alabama   Elmore                0           0           0           0   \n",
       "1053.0  Alabama   Escambia              0           0           0           0   \n",
       "1055.0  Alabama   Etowah                0           0           0           0   \n",
       "1057.0  Alabama   Fayette               0           0           0           0   \n",
       "1059.0  Alabama   Franklin              0           0           0           0   \n",
       "1063.0  Alabama   Greene                0           0           0           0   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                  0           0           0           0   \n",
       "55109.0 Wisconsin St. Croix             0           0           0           0   \n",
       "55111.0 Wisconsin Sauk                  0           0           0           0   \n",
       "55117.0 Wisconsin Sheboygan             0           0           0           0   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           0   \n",
       "55125.0 Wisconsin Vilas                 0           0           0           0   \n",
       "55127.0 Wisconsin Walworth              0           0           0           0   \n",
       "55131.0 Wisconsin Washington            0           0           0           0   \n",
       "55133.0 Wisconsin Waukesha              0           0           0           0   \n",
       "55135.0 Wisconsin Waupaca               0           0           0           0   \n",
       "55139.0 Wisconsin Winnebago             0           0           0           0   \n",
       "55141.0 Wisconsin Wood                  0           0           0           0   \n",
       "56001.0 Wyoming   Albany                0           0           0           0   \n",
       "56005.0 Wyoming   Campbell              0           0           0           0   \n",
       "56007.0 Wyoming   Carbon                0           0           0           0   \n",
       "56009.0 Wyoming   Converse              0           0           0           0   \n",
       "56013.0 Wyoming   Fremont               0           0           0           0   \n",
       "56015.0 Wyoming   Goshen                0           0           0           0   \n",
       "56017.0 Wyoming   Hot Springs           0           0           0           0   \n",
       "56019.0 Wyoming   Johnson               0           0           0           0   \n",
       "56021.0 Wyoming   Laramie               0           0           0           0   \n",
       "56025.0 Wyoming   Natrona               0           0           0           0   \n",
       "56029.0 Wyoming   Park                  0           0           0           0   \n",
       "56033.0 Wyoming   Sheridan              0           0           0           0   \n",
       "56035.0 Wyoming   Sublette              0           0           0           0   \n",
       "56037.0 Wyoming   Sweetwater            0           0           0           0   \n",
       "56039.0 Wyoming   Teton                 0           0           0           0   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           0   \n",
       "56043.0 Wyoming   Washakie              0           0           0           0   \n",
       "All                                     1           1           1           2   \n",
       "\n",
       "date                           2020-01-25  2020-01-26  2020-01-27  2020-01-28  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               0           0           0           0   \n",
       "1003.0  Alabama   Baldwin               0           0           0           0   \n",
       "1007.0  Alabama   Bibb                  0           0           0           0   \n",
       "1009.0  Alabama   Blount                0           0           0           0   \n",
       "1011.0  Alabama   Bullock               0           0           0           0   \n",
       "1013.0  Alabama   Butler                0           0           0           0   \n",
       "1015.0  Alabama   Calhoun               0           0           0           0   \n",
       "1017.0  Alabama   Chambers              0           0           0           0   \n",
       "1019.0  Alabama   Cherokee              0           0           0           0   \n",
       "1021.0  Alabama   Chilton               0           0           0           0   \n",
       "1023.0  Alabama   Choctaw               0           0           0           0   \n",
       "1025.0  Alabama   Clarke                0           0           0           0   \n",
       "1027.0  Alabama   Clay                  0           0           0           0   \n",
       "1029.0  Alabama   Cleburne              0           0           0           0   \n",
       "1031.0  Alabama   Coffee                0           0           0           0   \n",
       "1033.0  Alabama   Colbert               0           0           0           0   \n",
       "1035.0  Alabama   Conecuh               0           0           0           0   \n",
       "1037.0  Alabama   Coosa                 0           0           0           0   \n",
       "1039.0  Alabama   Covington             0           0           0           0   \n",
       "1041.0  Alabama   Crenshaw              0           0           0           0   \n",
       "1043.0  Alabama   Cullman               0           0           0           0   \n",
       "1045.0  Alabama   Dale                  0           0           0           0   \n",
       "1047.0  Alabama   Dallas                0           0           0           0   \n",
       "1049.0  Alabama   DeKalb                0           0           0           0   \n",
       "1051.0  Alabama   Elmore                0           0           0           0   \n",
       "1053.0  Alabama   Escambia              0           0           0           0   \n",
       "1055.0  Alabama   Etowah                0           0           0           0   \n",
       "1057.0  Alabama   Fayette               0           0           0           0   \n",
       "1059.0  Alabama   Franklin              0           0           0           0   \n",
       "1063.0  Alabama   Greene                0           0           0           0   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                  0           0           0           0   \n",
       "55109.0 Wisconsin St. Croix             0           0           0           0   \n",
       "55111.0 Wisconsin Sauk                  0           0           0           0   \n",
       "55117.0 Wisconsin Sheboygan             0           0           0           0   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           0   \n",
       "55125.0 Wisconsin Vilas                 0           0           0           0   \n",
       "55127.0 Wisconsin Walworth              0           0           0           0   \n",
       "55131.0 Wisconsin Washington            0           0           0           0   \n",
       "55133.0 Wisconsin Waukesha              0           0           0           0   \n",
       "55135.0 Wisconsin Waupaca               0           0           0           0   \n",
       "55139.0 Wisconsin Winnebago             0           0           0           0   \n",
       "55141.0 Wisconsin Wood                  0           0           0           0   \n",
       "56001.0 Wyoming   Albany                0           0           0           0   \n",
       "56005.0 Wyoming   Campbell              0           0           0           0   \n",
       "56007.0 Wyoming   Carbon                0           0           0           0   \n",
       "56009.0 Wyoming   Converse              0           0           0           0   \n",
       "56013.0 Wyoming   Fremont               0           0           0           0   \n",
       "56015.0 Wyoming   Goshen                0           0           0           0   \n",
       "56017.0 Wyoming   Hot Springs           0           0           0           0   \n",
       "56019.0 Wyoming   Johnson               0           0           0           0   \n",
       "56021.0 Wyoming   Laramie               0           0           0           0   \n",
       "56025.0 Wyoming   Natrona               0           0           0           0   \n",
       "56029.0 Wyoming   Park                  0           0           0           0   \n",
       "56033.0 Wyoming   Sheridan              0           0           0           0   \n",
       "56035.0 Wyoming   Sublette              0           0           0           0   \n",
       "56037.0 Wyoming   Sweetwater            0           0           0           0   \n",
       "56039.0 Wyoming   Teton                 0           0           0           0   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           0   \n",
       "56043.0 Wyoming   Washakie              0           0           0           0   \n",
       "All                                     3           5           5           5   \n",
       "\n",
       "date                           2020-01-29  2020-01-30   ...     2020-03-25  \\\n",
       "fips    state     county                                ...                  \n",
       "1001.0  Alabama   Autauga               0           0   ...              4   \n",
       "1003.0  Alabama   Baldwin               0           0   ...              4   \n",
       "1007.0  Alabama   Bibb                  0           0   ...              0   \n",
       "1009.0  Alabama   Blount                0           0   ...              1   \n",
       "1011.0  Alabama   Bullock               0           0   ...              0   \n",
       "1013.0  Alabama   Butler                0           0   ...              1   \n",
       "1015.0  Alabama   Calhoun               0           0   ...              2   \n",
       "1017.0  Alabama   Chambers              0           0   ...             10   \n",
       "1019.0  Alabama   Cherokee              0           0   ...              1   \n",
       "1021.0  Alabama   Chilton               0           0   ...              1   \n",
       "1023.0  Alabama   Choctaw               0           0   ...              0   \n",
       "1025.0  Alabama   Clarke                0           0   ...              0   \n",
       "1027.0  Alabama   Clay                  0           0   ...              1   \n",
       "1029.0  Alabama   Cleburne              0           0   ...              1   \n",
       "1031.0  Alabama   Coffee                0           0   ...              0   \n",
       "1033.0  Alabama   Colbert               0           0   ...              1   \n",
       "1035.0  Alabama   Conecuh               0           0   ...              0   \n",
       "1037.0  Alabama   Coosa                 0           0   ...              0   \n",
       "1039.0  Alabama   Covington             0           0   ...              0   \n",
       "1041.0  Alabama   Crenshaw              0           0   ...              0   \n",
       "1043.0  Alabama   Cullman               0           0   ...              4   \n",
       "1045.0  Alabama   Dale                  0           0   ...              0   \n",
       "1047.0  Alabama   Dallas                0           0   ...              2   \n",
       "1049.0  Alabama   DeKalb                0           0   ...              0   \n",
       "1051.0  Alabama   Elmore                0           0   ...              9   \n",
       "1053.0  Alabama   Escambia              0           0   ...              0   \n",
       "1055.0  Alabama   Etowah                0           0   ...              3   \n",
       "1057.0  Alabama   Fayette               0           0   ...              0   \n",
       "1059.0  Alabama   Franklin              0           0   ...              2   \n",
       "1063.0  Alabama   Greene                0           0   ...              0   \n",
       "...                                   ...         ...   ...            ...   \n",
       "55105.0 Wisconsin Rock                  0           0   ...              4   \n",
       "55109.0 Wisconsin St. Croix             0           0   ...              4   \n",
       "55111.0 Wisconsin Sauk                  0           0   ...              6   \n",
       "55117.0 Wisconsin Sheboygan             0           0   ...              7   \n",
       "55121.0 Wisconsin Trempealeau           0           0   ...              0   \n",
       "55125.0 Wisconsin Vilas                 0           0   ...              0   \n",
       "55127.0 Wisconsin Walworth              0           0   ...              5   \n",
       "55131.0 Wisconsin Washington            0           0   ...             21   \n",
       "55133.0 Wisconsin Waukesha              0           0   ...             42   \n",
       "55135.0 Wisconsin Waupaca               0           0   ...              0   \n",
       "55139.0 Wisconsin Winnebago             0           0   ...              5   \n",
       "55141.0 Wisconsin Wood                  0           0   ...              1   \n",
       "56001.0 Wyoming   Albany                0           0   ...              1   \n",
       "56005.0 Wyoming   Campbell              0           0   ...              1   \n",
       "56007.0 Wyoming   Carbon                0           0   ...              3   \n",
       "56009.0 Wyoming   Converse              0           0   ...              0   \n",
       "56013.0 Wyoming   Fremont               0           0   ...             14   \n",
       "56015.0 Wyoming   Goshen                0           0   ...              0   \n",
       "56017.0 Wyoming   Hot Springs           0           0   ...              0   \n",
       "56019.0 Wyoming   Johnson               0           0   ...              0   \n",
       "56021.0 Wyoming   Laramie               0           0   ...             12   \n",
       "56025.0 Wyoming   Natrona               0           0   ...              6   \n",
       "56029.0 Wyoming   Park                  0           0   ...              1   \n",
       "56033.0 Wyoming   Sheridan              0           0   ...              4   \n",
       "56035.0 Wyoming   Sublette              0           0   ...              0   \n",
       "56037.0 Wyoming   Sweetwater            0           0   ...              1   \n",
       "56039.0 Wyoming   Teton                 0           0   ...              6   \n",
       "56041.0 Wyoming   Uinta                 0           0   ...              0   \n",
       "56043.0 Wyoming   Washakie              0           0   ...              0   \n",
       "All                                     5           6   ...          46831   \n",
       "\n",
       "date                           2020-03-26  2020-03-27  2020-03-28  2020-03-29  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               6           6           6           6   \n",
       "1003.0  Alabama   Baldwin               5           5          10          15   \n",
       "1007.0  Alabama   Bibb                  0           0           0           0   \n",
       "1009.0  Alabama   Blount                3           5           5           5   \n",
       "1011.0  Alabama   Bullock               2           2           3           3   \n",
       "1013.0  Alabama   Butler                1           1           1           1   \n",
       "1015.0  Alabama   Calhoun               2           3           3           3   \n",
       "1017.0  Alabama   Chambers             13          15          17          27   \n",
       "1019.0  Alabama   Cherokee              1           1           1           2   \n",
       "1021.0  Alabama   Chilton               4           7           7           8   \n",
       "1023.0  Alabama   Choctaw               1           1           1           1   \n",
       "1025.0  Alabama   Clarke                0           0           0           0   \n",
       "1027.0  Alabama   Clay                  1           1           2           2   \n",
       "1029.0  Alabama   Cleburne              1           3           4           5   \n",
       "1031.0  Alabama   Coffee                0           0           0           0   \n",
       "1033.0  Alabama   Colbert               1           1           1           2   \n",
       "1035.0  Alabama   Conecuh               0           0           0           0   \n",
       "1037.0  Alabama   Coosa                 2           2           2           3   \n",
       "1039.0  Alabama   Covington             0           2           2           2   \n",
       "1041.0  Alabama   Crenshaw              1           1           1           1   \n",
       "1043.0  Alabama   Cullman               6           7           7           7   \n",
       "1045.0  Alabama   Dale                  0           0           0           0   \n",
       "1047.0  Alabama   Dallas                2           2           2           2   \n",
       "1049.0  Alabama   DeKalb                1           4           4           4   \n",
       "1051.0  Alabama   Elmore               10          12          13          13   \n",
       "1053.0  Alabama   Escambia              0           1           1           1   \n",
       "1055.0  Alabama   Etowah                4           5           6           6   \n",
       "1057.0  Alabama   Fayette               0           0           0           0   \n",
       "1059.0  Alabama   Franklin              3           3           3           3   \n",
       "1063.0  Alabama   Greene                0           1           3           3   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                  8          12          12          14   \n",
       "55109.0 Wisconsin St. Croix             4           4           4           4   \n",
       "55111.0 Wisconsin Sauk                  7           8          11          12   \n",
       "55117.0 Wisconsin Sheboygan             7           7           8           8   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           0   \n",
       "55125.0 Wisconsin Vilas                 1           2           2           2   \n",
       "55127.0 Wisconsin Walworth              5           5           6           6   \n",
       "55131.0 Wisconsin Washington           25          27          31          31   \n",
       "55133.0 Wisconsin Waukesha             56          61          72          83   \n",
       "55135.0 Wisconsin Waupaca               0           1           1           1   \n",
       "55139.0 Wisconsin Winnebago             6           6           7           8   \n",
       "55141.0 Wisconsin Wood                  2           2           2           2   \n",
       "56001.0 Wyoming   Albany                1           1           1           1   \n",
       "56005.0 Wyoming   Campbell              1           1           1           1   \n",
       "56007.0 Wyoming   Carbon                3           3           3           3   \n",
       "56009.0 Wyoming   Converse              0           0           1           1   \n",
       "56013.0 Wyoming   Fremont              14          17          21          23   \n",
       "56015.0 Wyoming   Goshen                0           1           1           1   \n",
       "56017.0 Wyoming   Hot Springs           1           1           1           1   \n",
       "56019.0 Wyoming   Johnson               1           4           5           5   \n",
       "56021.0 Wyoming   Laramie              15          18          19          19   \n",
       "56025.0 Wyoming   Natrona               6           8           8           9   \n",
       "56029.0 Wyoming   Park                  1           1           1           1   \n",
       "56033.0 Wyoming   Sheridan              4           5           6           6   \n",
       "56035.0 Wyoming   Sublette              0           0           1           1   \n",
       "56037.0 Wyoming   Sweetwater            1           1           1           1   \n",
       "56039.0 Wyoming   Teton                 8          12          14          14   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           0   \n",
       "56043.0 Wyoming   Washakie              0           1           1           1   \n",
       "All                                 59719       73982       88829      103316   \n",
       "\n",
       "date                           2020-03-30  2020-03-31  2020-04-01  2020-04-02  \\\n",
       "fips    state     county                                                        \n",
       "1001.0  Alabama   Autauga               7           7          10          10   \n",
       "1003.0  Alabama   Baldwin              18          19          23          25   \n",
       "1007.0  Alabama   Bibb                  2           3           3           4   \n",
       "1009.0  Alabama   Blount                5           5           5           6   \n",
       "1011.0  Alabama   Bullock               3           3           3           2   \n",
       "1013.0  Alabama   Butler                1           1           1           1   \n",
       "1015.0  Alabama   Calhoun               9           9          11          12   \n",
       "1017.0  Alabama   Chambers             36          36          45          67   \n",
       "1019.0  Alabama   Cherokee              2           2           2           4   \n",
       "1021.0  Alabama   Chilton              10          11          13          14   \n",
       "1023.0  Alabama   Choctaw               2           3           4           4   \n",
       "1025.0  Alabama   Clarke                0           0           2           2   \n",
       "1027.0  Alabama   Clay                  2           2           3           7   \n",
       "1029.0  Alabama   Cleburne              5           5           6           6   \n",
       "1031.0  Alabama   Coffee                0           0           0           3   \n",
       "1033.0  Alabama   Colbert               4           4           4           5   \n",
       "1035.0  Alabama   Conecuh               0           0           1           1   \n",
       "1037.0  Alabama   Coosa                 4           4           4           6   \n",
       "1039.0  Alabama   Covington             2           2           3           3   \n",
       "1041.0  Alabama   Crenshaw              1           1           1           1   \n",
       "1043.0  Alabama   Cullman               8           8           9           9   \n",
       "1045.0  Alabama   Dale                  0           0           1           1   \n",
       "1047.0  Alabama   Dallas                2           2           3           4   \n",
       "1049.0  Alabama   DeKalb                4           4           6           8   \n",
       "1051.0  Alabama   Elmore               13          12          15          17   \n",
       "1053.0  Alabama   Escambia              1           1           1           2   \n",
       "1055.0  Alabama   Etowah                6           8          10          13   \n",
       "1057.0  Alabama   Fayette               1           1           1           1   \n",
       "1059.0  Alabama   Franklin              3           3           3           4   \n",
       "1063.0  Alabama   Greene                3           3           4           4   \n",
       "...                                   ...         ...         ...         ...   \n",
       "55105.0 Wisconsin Rock                 15          16          17          19   \n",
       "55109.0 Wisconsin St. Croix             4           5           6           6   \n",
       "55111.0 Wisconsin Sauk                 13          13          14          16   \n",
       "55117.0 Wisconsin Sheboygan             8          11          14          16   \n",
       "55121.0 Wisconsin Trempealeau           0           0           0           1   \n",
       "55125.0 Wisconsin Vilas                 3           3           3           3   \n",
       "55127.0 Wisconsin Walworth              6           6          12          15   \n",
       "55131.0 Wisconsin Washington           34          40          44          46   \n",
       "55133.0 Wisconsin Waukesha             93         101         107         120   \n",
       "55135.0 Wisconsin Waupaca               1           1           2           2   \n",
       "55139.0 Wisconsin Winnebago            10          11          13          17   \n",
       "55141.0 Wisconsin Wood                  2           2           2           2   \n",
       "56001.0 Wyoming   Albany                1           3           3           3   \n",
       "56005.0 Wyoming   Campbell              1           3           5           6   \n",
       "56007.0 Wyoming   Carbon                3           3           3           3   \n",
       "56009.0 Wyoming   Converse              1           1           2           3   \n",
       "56013.0 Wyoming   Fremont              24          25          25          26   \n",
       "56015.0 Wyoming   Goshen                1           1           1           1   \n",
       "56017.0 Wyoming   Hot Springs           1           1           1           1   \n",
       "56019.0 Wyoming   Johnson               5           7           7           8   \n",
       "56021.0 Wyoming   Laramie              20          27          35          37   \n",
       "56025.0 Wyoming   Natrona               9          12          14          19   \n",
       "56029.0 Wyoming   Park                  1           1           1           1   \n",
       "56033.0 Wyoming   Sheridan              8          10          10          10   \n",
       "56035.0 Wyoming   Sublette              1           1           1           1   \n",
       "56037.0 Wyoming   Sweetwater            2           2           3           3   \n",
       "56039.0 Wyoming   Teton                17          23          26          29   \n",
       "56041.0 Wyoming   Uinta                 0           0           0           1   \n",
       "56043.0 Wyoming   Washakie              1           1           1           2   \n",
       "All                                119749      139169      159939      184476   \n",
       "\n",
       "date                               All  \n",
       "fips    state     county                \n",
       "1001.0  Alabama   Autauga           63  \n",
       "1003.0  Alabama   Baldwin          143  \n",
       "1007.0  Alabama   Bibb              12  \n",
       "1009.0  Alabama   Blount            40  \n",
       "1011.0  Alabama   Bullock           21  \n",
       "1013.0  Alabama   Butler             9  \n",
       "1015.0  Alabama   Calhoun           63  \n",
       "1017.0  Alabama   Chambers         278  \n",
       "1019.0  Alabama   Cherokee          16  \n",
       "1021.0  Alabama   Chilton           75  \n",
       "1023.0  Alabama   Choctaw           17  \n",
       "1025.0  Alabama   Clarke             4  \n",
       "1027.0  Alabama   Clay              21  \n",
       "1029.0  Alabama   Cleburne          36  \n",
       "1031.0  Alabama   Coffee             3  \n",
       "1033.0  Alabama   Colbert           23  \n",
       "1035.0  Alabama   Conecuh            2  \n",
       "1037.0  Alabama   Coosa             27  \n",
       "1039.0  Alabama   Covington         16  \n",
       "1041.0  Alabama   Crenshaw           8  \n",
       "1043.0  Alabama   Cullman           75  \n",
       "1045.0  Alabama   Dale               2  \n",
       "1047.0  Alabama   Dallas            21  \n",
       "1049.0  Alabama   DeKalb            35  \n",
       "1051.0  Alabama   Elmore           161  \n",
       "1053.0  Alabama   Escambia           8  \n",
       "1055.0  Alabama   Etowah            61  \n",
       "1057.0  Alabama   Fayette            4  \n",
       "1059.0  Alabama   Franklin          29  \n",
       "1063.0  Alabama   Greene            21  \n",
       "...                                ...  \n",
       "55105.0 Wisconsin Rock             130  \n",
       "55109.0 Wisconsin St. Croix         54  \n",
       "55111.0 Wisconsin Sauk             114  \n",
       "55117.0 Wisconsin Sheboygan        141  \n",
       "55121.0 Wisconsin Trempealeau        1  \n",
       "55125.0 Wisconsin Vilas             19  \n",
       "55127.0 Wisconsin Walworth          84  \n",
       "55131.0 Wisconsin Washington       355  \n",
       "55133.0 Wisconsin Waukesha         895  \n",
       "55135.0 Wisconsin Waupaca            9  \n",
       "55139.0 Wisconsin Winnebago        124  \n",
       "55141.0 Wisconsin Wood              26  \n",
       "56001.0 Wyoming   Albany            15  \n",
       "56005.0 Wyoming   Campbell          25  \n",
       "56007.0 Wyoming   Carbon            34  \n",
       "56009.0 Wyoming   Converse           9  \n",
       "56013.0 Wyoming   Fremont          274  \n",
       "56015.0 Wyoming   Goshen             7  \n",
       "56017.0 Wyoming   Hot Springs        8  \n",
       "56019.0 Wyoming   Johnson           42  \n",
       "56021.0 Wyoming   Laramie          241  \n",
       "56025.0 Wyoming   Natrona           99  \n",
       "56029.0 Wyoming   Park              17  \n",
       "56033.0 Wyoming   Sheridan         104  \n",
       "56035.0 Wyoming   Sublette           6  \n",
       "56037.0 Wyoming   Sweetwater        16  \n",
       "56039.0 Wyoming   Teton            162  \n",
       "56041.0 Wyoming   Uinta              1  \n",
       "56043.0 Wyoming   Washakie           8  \n",
       "All                            1139790  \n",
       "\n",
       "[2285 rows x 74 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_deaths = df_deaths.reset_index().pivot_table(index=['fips','state', 'county'], columns='date', values='deaths',  aggfunc=sum,  margins=True, fill_value=0)\n",
    "df_cases"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Save Files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_cases.to_csv(cases_save_file, encoding='utf-8')\n",
    "df_deaths.to_csv(deaths_save_file, encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.7.5 64-bit ('p37': conda)",
   "language": "python",
   "name": "python37564bitp37conda2b1eeea87ee044609be89b011a3e6682"
  },
  "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}