covid_states

In [1]:

import pandas as pd
import arrow
import cufflinks as cf
from scipy.optimize import curve_fit
import numpy as np
import plotly.express as px
from plotly.subplots import make_subplots
import plotly.graph_objs as go
import requests
import seaborn as sns

cf.go_offline()
pd.set_option('display.max_columns', None)  
pd.set_option('display.max_rows', None)

In [2]:

csv = requests.get('http://covidtracking.com/api/states/daily.csv').text
date = arrow.now().format('MM-DD')
filename = f"states-{date}.csv"
open(filename, 'w').write(csv)

Out[2]:

In [3]:

df = pd.read_csv(filename)

In [4]:

df['date'] = pd.to_datetime(df['date'], format="%Y%m%d").dt.date
df = df.sort_values('date')

State positive cases for the last 5 days¶

In [5]:

table_df = df[['date', 'state', 'positive']] \
    .sort_values(['state', 'date']) \
    .pivot(index='state', columns='date', values='positive')
table_df \
    .sort_values(table_df.columns[-1], ascending=False) \
    [:25].iloc[:, -5:].style.format('{:,.0f}')

Out[5]:

date	2020-04-18	2020-04-19	2020-04-20	2020-04-21	2020-04-22
state
NY	236,732	242,786	247,512	251,690	257,216
NJ	81,420	85,301	88,806	92,387	95,865
MA	36,372	38,077	38,077	41,199	42,944
CA	28,963	30,333	30,978	33,261	35,396
IL	29,160	30,357	31,508	33,059	35,108
PA	31,069	32,284	33,232	34,528	35,045
MI	30,791	31,424	32,000	32,967	33,966
FL	25,269	25,996	26,660	27,495	28,309
LA	23,580	23,928	24,523	24,854	25,258
CT	16,809	17,550	19,815	20,360	22,469
TX	18,260	18,923	19,458	20,196	21,069
GA	17,669	18,301	18,947	19,881	20,740
MD	12,308	12,830	13,684	14,193	14,775
OH	9,939	11,292	12,516	13,250	13,609
IN	10,641	11,210	11,686	12,097	12,438
WA	11,445	11,802	11,790	12,085	12,282
CO	9,047	9,433	9,730	10,106	10,447
VA	8,053	8,537	8,990	9,451	9,451
TN	6,762	7,070	7,238	7,394	7,842
NC	6,140	6,493	6,764	6,951	7,220
MO	5,517	5,667	5,807	5,941	6,137
RI	4,491	4,706	5,090	5,500	5,841
AL	4,655	4,837	5,025	5,231	5,465
AZ	4,719	4,929	5,064	5,251	5,459
MS	3,974	4,274	4,512	4,716	4,894

In [6]:

table_df = table_df \
    .sort_values(table_df.columns[-1], ascending=False) \
    .pct_change(axis=1) \
    .fillna(0)

In [7]:

cmap = sns.diverging_palette(5, 250, as_cmap=True)
def colors(val):
    if val == 0 or val == float('inf'):
        return 'background-color: white; color: black'
    text_color = 'white' if val > 0.4 else 'black'
    return f'background-color: hsl(0, 80%, {100 - (val * 100)}%); color: {text_color}'

In [8]:

%%html
<style>
/* css hacks */
.row_heading {
    position: sticky;
    left: 0;
    background: white;
}
tr:hover {
    border: 1px solid #2795ee;
}
</style>

percent growth day over day¶

In [9]:

s = table_df.style.applymap(colors) \
    .format("{:.1%}")
s

Out[9]:

date	2020-02-28	2020-02-29	2020-03-01	2020-03-02	2020-03-03	2020-03-04	2020-03-05	2020-03-06	2020-03-07	2020-03-08	2020-03-09	2020-03-10	2020-03-11	2020-03-12	2020-03-13	2020-03-14	2020-03-15	2020-03-16	2020-03-17	2020-03-18	2020-03-19	2020-03-20	2020-03-21	2020-03-22	2020-03-23	2020-03-24	2020-03-25	2020-03-26	2020-03-27	2020-03-28	2020-03-29	2020-03-30	2020-03-31	2020-04-01	2020-04-02	2020-04-03	2020-04-04	2020-04-05	2020-04-06	2020-04-07	2020-04-08	2020-04-09	2020-04-10	2020-04-11	2020-04-12	2020-04-13	2020-04-14	2020-04-15	2020-04-16	2020-04-17	2020-04-18	2020-04-19	2020-04-20	2020-04-21	2020-04-22
state
NY	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	266.7%	50.0%	130.3%	38.2%	35.2%	21.8%	24.9%	0.0%	94.9%	24.5%	39.1%	30.3%	78.9%	40.1%	74.3%	71.1%	45.8%	46.5%	37.6%	22.9%	20.1%	20.9%	19.8%	17.2%	13.8%	11.7%	14.0%	10.4%	10.4%	11.3%	10.5%	7.3%	7.1%	6.3%	7.5%	7.1%	6.6%	5.8%	4.6%	3.4%	3.7%	5.7%	4.0%	3.3%	3.1%	2.6%	1.9%	1.7%	2.2%
NJ	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	300.0%	50.0%	83.3%	36.4%	60.0%	25.0%	66.7%	0.0%	96.0%	81.6%	50.0%	59.9%	73.8%	19.9%	49.1%	44.2%	48.6%	29.2%	19.8%	56.2%	28.3%	26.1%	20.3%	24.3%	12.4%	19.0%	15.0%	16.8%	14.1%	9.9%	9.6%	8.1%	6.8%	7.6%	7.0%	6.5%	6.4%	4.4%	6.6%	3.2%	6.0%	4.2%	3.8%	4.8%	4.1%	4.0%	3.8%
MA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	300.0%	62.5%	0.0%	215.4%	124.4%	0.0%	3.3%	29.5%	12.2%	0.0%	18.8%	32.9%	17.4%	28.1%	25.9%	27.1%	23.0%	20.3%	49.2%	58.6%	31.5%	34.1%	31.4%	16.4%	16.1%	15.1%	16.9%	15.9%	16.0%	12.8%	6.5%	10.7%	9.9%	10.4%	12.8%	10.7%	9.0%	11.4%	5.5%	4.8%	6.2%	7.6%	6.9%	5.7%	4.7%	0.0%	8.2%	4.2%
CA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	13.2%	15.0%	27.5%	29.5%	16.7%	18.0%	28.7%	0.0%	24.8%	16.3%	14.3%	44.2%	26.5%	51.2%	15.0%	20.3%	20.1%	12.8%	21.3%	12.0%	27.6%	29.0%	19.7%	22.9%	12.9%	16.1%	9.0%	12.7%	16.4%	12.4%	11.7%	6.7%	10.7%	6.9%	8.0%	6.4%	0.0%	11.9%	2.5%	4.4%	4.7%	7.2%	5.1%	5.2%	4.7%	2.1%	7.4%	6.4%
IL	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	25.0%	0.0%	20.0%	0.0%	16.7%	171.4%	0.0%	31.6%	28.0%	43.8%	39.1%	45.3%	71.0%	81.1%	46.5%	38.6%	28.7%	39.3%	21.4%	20.6%	21.5%	36.1%	19.2%	15.4%	31.7%	10.0%	18.5%	16.4%	10.2%	15.7%	16.3%	8.7%	8.9%	10.5%	11.3%	8.9%	8.9%	7.2%	8.7%	5.6%	5.5%	5.8%	4.6%	7.2%	5.7%	4.1%	3.8%	4.9%	6.2%
PA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	50.0%	66.7%	20.0%	33.3%	37.5%	86.4%	14.6%	34.0%	20.6%	26.3%	38.5%	39.1%	44.9%	38.4%	29.1%	34.4%	32.1%	32.4%	49.7%	31.5%	24.0%	23.4%	20.4%	18.5%	19.9%	20.9%	20.0%	19.0%	14.9%	12.8%	12.2%	11.5%	12.2%	9.6%	8.4%	5.4%	6.0%	4.7%	4.5%	4.7%	6.2%	5.5%	3.9%	2.9%	3.9%	1.5%
MI	0.0%	0.0%	0.0%	100.0%	88.9%	52.9%	38.5%	36.1%	30.6%	31.2%	51.2%	40.9%	38.8%	41.2%	34.6%	26.6%	23.7%	30.6%	23.8%	21.7%	16.4%	18.7%	12.8%	12.2%	13.6%	11.3%	9.6%	10.0%	11.5%	7.3%	7.8%	8.9%	8.9%	8.5%	9.5%	8.0%	7.5%	7.1%	7.3%	5.2%	3.9%	4.4%	5.9%	5.3%	2.7%	4.0%	5.3%	3.9%	4.3%	2.6%	2.6%	2.1%	1.8%	3.0%	3.0%
FL	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	350.0%	0.0%	55.6%	21.4%	5.9%	5.6%	47.4%	14.3%	56.2%	54.0%	50.6%	21.6%	31.9%	68.8%	24.2%	33.3%	26.5%	26.1%	41.1%	20.6%	19.1%	40.0%	17.4%	36.1%	12.8%	28.9%	15.8%	9.7%	15.2%	19.7%	15.9%	9.4%	9.7%	10.7%	4.8%	5.9%	7.1%	5.5%	4.7%	6.4%	3.7%	5.4%	1.7%	5.3%	4.8%	2.9%	2.6%	3.1%	3.0%
LA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	500.0%	133.3%	157.1%	91.7%	31.9%	25.3%	50.0%	40.4%	44.6%	38.0%	22.1%	43.1%	40.0%	18.4%	29.3%	28.4%	19.1%	20.7%	6.8%	13.7%	30.1%	22.7%	42.4%	12.5%	21.4%	4.1%	14.3%	9.5%	4.6%	7.4%	5.3%	4.0%	2.9%	2.0%	2.4%	2.0%	2.6%	2.6%	2.0%	1.5%	2.5%	1.3%	1.6%
CT	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	100.0%	50.0%	100.0%	0.0%	83.3%	81.8%	30.0%	57.7%	65.9%	41.2%	102.1%	0.0%	14.9%	86.1%	48.9%	41.6%	15.7%	27.6%	0.0%	54.4%	29.0%	21.7%	13.7%	7.5%	28.5%	7.4%	7.6%	21.7%	12.7%	0.0%	25.7%	7.7%	9.2%	4.6%	11.2%	4.5%	5.5%	7.7%	5.8%	0.0%	4.4%	12.9%	2.8%	10.4%
TX	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	400.0%	60.0%	0.0%	50.0%	8.3%	61.5%	9.5%	69.6%	30.8%	9.8%	1.8%	12.3%	29.7%	72.3%	35.7%	56.7%	9.9%	5.4%	16.5%	137.6%	43.3%	24.0%	18.5%	24.4%	12.7%	13.5%	22.4%	16.8%	14.2%	14.6%	11.5%	6.8%	13.6%	13.2%	9.4%	14.1%	7.6%	7.3%	3.1%	5.2%	5.9%	6.2%	5.6%	5.1%	3.6%	2.8%	3.8%	4.3%
GA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	200.0%	16.7%	71.4%	41.7%	29.4%	40.9%	35.5%	57.1%	50.0%	22.2%	20.7%	34.9%	45.7%	46.3%	20.7%	18.3%	28.7%	32.9%	21.5%	22.3%	31.2%	18.2%	12.0%	6.0%	39.9%	18.0%	15.3%	9.0%	5.6%	7.9%	10.0%	20.6%	12.3%	6.7%	8.7%	5.9%	2.4%	6.9%	6.8%	5.4%	4.6%	9.7%	2.8%	3.6%	3.5%	4.9%	4.3%
MD	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	0.0%	66.7%	20.0%	50.0%	33.3%	41.7%	52.9%	19.2%	19.4%	54.1%	49.1%	25.9%	39.3%	27.5%	28.4%	18.0%	21.2%	21.2%	37.1%	33.4%	28.2%	24.9%	14.0%	17.5%	19.6%	17.4%	18.3%	13.3%	15.5%	12.1%	8.1%	26.5%	11.9%	12.7%	10.4%	6.9%	8.6%	6.0%	5.9%	7.5%	7.3%	6.4%	4.2%	6.7%	3.7%	4.1%
OH	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	33.3%	25.0%	160.0%	0.0%	176.9%	38.9%	34.0%	31.3%	35.2%	42.0%	46.2%	42.1%	25.9%	27.6%	24.8%	23.2%	31.1%	23.7%	17.6%	16.9%	13.8%	15.8%	13.9%	14.1%	12.9%	8.1%	10.1%	7.5%	7.7%	7.1%	5.9%	6.0%	6.7%	5.6%	2.6%	8.9%	8.0%	5.3%	12.2%	13.6%	10.8%	5.9%	2.7%
IN	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	200.0%	66.7%	20.0%	0.0%	25.0%	26.7%	26.3%	25.0%	30.0%	43.6%	41.1%	59.5%	59.5%	28.9%	40.9%	30.7%	35.2%	52.1%	25.6%	22.9%	18.0%	20.9%	18.8%	18.5%	13.1%	15.0%	11.6%	12.1%	11.4%	7.9%	6.9%	8.8%	7.6%	6.6%	3.9%	3.5%	5.0%	6.6%	6.4%	4.8%	5.3%	4.2%	3.5%	2.8%
WA	0.0%	100.0%	66.7%	13.3%	70.6%	31.0%	26.3%	55.2%	21.5%	35.9%	39.4%	13.7%	21.5%	14.6%	27.6%	14.4%	16.5%	13.9%	15.8%	14.0%	10.6%	15.5%	13.1%	11.8%	9.3%	15.2%	16.0%	14.4%	13.2%	11.1%	8.4%	9.1%	8.3%	9.3%	5.6%	8.4%	5.1%	5.0%	4.2%	4.2%	5.1%	2.8%	4.7%	0.0%	0.0%	1.8%	1.2%	1.5%	0.8%	3.4%	2.6%	3.1%	-0.1%	2.5%	1.6%
CO	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	300.0%	0.0%	12.5%	33.3%	133.3%	60.7%	60.0%	40.3%	29.7%	0.0%	22.1%	14.4%	18.0%	28.2%	31.0%	30.9%	24.4%	21.8%	26.7%	19.1%	31.7%	21.3%	18.9%	27.5%	0.0%	12.9%	12.7%	11.5%	11.9%	9.4%	8.4%	4.5%	5.0%	4.2%	15.1%	0.0%	5.9%	11.5%	0.1%	3.3%	4.3%	4.8%	4.3%	4.3%	3.1%	3.9%	3.4%
VA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	50.0%	166.7%	12.5%	88.9%	76.5%	0.0%	50.0%	13.3%	31.4%	14.9%	22.1%	21.3%	33.3%	44.1%	16.0%	14.2%	34.8%	17.6%	31.3%	22.4%	20.4%	14.6%	22.5%	18.7%	15.0%	17.9%	19.6%	9.6%	9.1%	15.8%	9.4%	10.9%	11.6%	12.6%	3.9%	9.0%	7.4%	5.3%	6.0%	8.7%	7.5%	6.0%	5.3%	5.1%	0.0%
TN	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	200.0%	0.0%	133.3%	0.0%	157.1%	44.4%	23.1%	21.9%	33.3%	40.4%	34.2%	57.1%	48.1%	62.7%	36.1%	21.8%	8.5%	17.5%	22.1%	25.7%	14.1%	11.9%	19.3%	22.1%	19.8%	6.0%	7.8%	8.3%	9.4%	4.7%	8.8%	5.4%	6.2%	4.9%	5.2%	3.8%	5.7%	3.8%	4.4%	3.0%	5.2%	2.6%	4.6%	2.4%	2.2%	6.1%
NC	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	0.0%	0.0%	250.0%	0.0%	71.4%	25.0%	53.3%	39.1%	3.1%	21.2%	57.5%	54.0%	41.2%	34.3%	38.6%	16.5%	34.0%	26.6%	26.2%	20.0%	22.5%	11.2%	25.7%	14.6%	5.7%	17.2%	12.7%	14.8%	7.6%	11.0%	12.2%	6.4%	6.6%	7.0%	10.3%	4.8%	6.5%	4.3%	2.0%	6.7%	7.2%	4.8%	5.7%	4.2%	2.8%	3.9%
MO	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	0.0%	0.0%	0.0%	100.0%	100.0%	25.0%	20.0%	33.3%	62.5%	84.6%	95.8%	55.3%	23.3%	103.3%	0.0%	94.5%	41.0%	33.3%	25.3%	0.0%	23.0%	28.7%	19.1%	16.0%	15.2%	8.4%	3.3%	15.0%	11.6%	9.5%	6.4%	7.3%	5.9%	3.4%	5.5%	6.8%	4.5%	4.4%	3.4%	4.4%	2.7%	2.5%	2.3%	3.3%
RI	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	0.0%	50.0%	-33.3%	50.0%	0.0%	0.0%	66.7%	0.0%	180.0%	42.9%	0.0%	5.0%	9.5%	43.5%	33.3%	22.7%	22.2%	25.8%	27.7%	17.0%	6.5%	25.0%	23.0%	17.7%	23.0%	36.7%	21.6%	15.7%	16.1%	7.9%	13.7%	14.4%	17.4%	13.7%	17.9%	19.1%	16.7%	16.6%	13.5%	11.7%	9.2%	8.6%	8.8%	8.8%	7.5%	4.8%	8.2%	8.1%	6.2%
AL	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	500.0%	100.0%	133.3%	28.6%	27.8%	47.8%	19.1%	53.1%	11.3%	21.0%	28.7%	31.6%	78.8%	16.0%	18.6%	15.8%	6.6%	14.2%	9.8%	14.5%	16.1%	10.3%	13.7%	9.6%	7.7%	11.8%	16.9%	7.2%	7.5%	10.5%	5.9%	3.8%	6.1%	5.6%	4.3%	2.8%	3.9%	3.9%	4.1%	4.5%
AZ	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	50.0%	66.7%	0.0%	0.0%	20.0%	50.0%	0.0%	0.0%	33.3%	0.0%	50.0%	11.1%	40.0%	57.1%	47.7%	60.0%	46.2%	74.3%	34.7%	26.1%	28.2%	27.6%	18.6%	5.3%	25.9%	11.4%	9.6%	13.1%	10.7%	14.1%	12.4%	8.2%	4.8%	5.9%	10.7%	3.1%	9.0%	4.3%	4.6%	2.8%	4.1%	6.9%	6.4%	4.7%	4.5%	2.7%	3.7%	4.0%
MS	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	300.0%	50.0%	66.7%	20.0%	75.0%	61.9%	47.1%	60.0%	75.0%	47.9%	20.3%	28.5%	17.8%	28.6%	19.4%	14.5%	14.3%	11.7%	10.6%	14.5%	9.7%	15.4%	7.1%	12.6%	6.1%	10.2%	4.6%	12.8%	9.2%	7.0%	5.3%	5.8%	4.9%	8.8%	7.9%	4.7%	4.8%	7.5%	5.6%	4.5%	3.8%
WI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	50.0%	166.7%	137.5%	0.0%	73.7%	42.4%	53.2%	47.2%	46.2%	32.9%	36.4%	37.0%	8.1%	9.9%	28.0%	20.9%	19.1%	17.5%	12.4%	9.8%	10.6%	14.7%	11.6%	10.5%	10.5%	7.3%	7.6%	5.7%	6.9%	4.7%	6.3%	4.7%	4.0%	2.6%	3.7%	4.7%	4.1%	4.4%	3.8%	3.5%	3.5%	2.7%	4.9%
SC	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	250.0%	0.0%	28.6%	11.1%	20.0%	8.3%	46.2%	47.4%	17.9%	81.8%	0.0%	35.0%	87.7%	28.3%	52.8%	0.0%	42.3%	7.5%	0.0%	18.2%	43.6%	19.5%	17.1%	19.4%	20.2%	0.0%	23.4%	6.9%	0.0%	18.0%	5.6%	9.4%	9.8%	4.6%	3.5%	0.0%	7.1%	2.9%	0.0%	7.5%	8.0%	3.1%	0.0%	1.4%	7.3%
NV	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	400.0%	40.0%	57.1%	81.8%	5.0%	114.3%	22.2%	0.0%	72.7%	14.7%	13.8%	53.2%	28.9%	13.5%	15.5%	30.8%	27.4%	16.1%	18.8%	36.6%	10.4%	14.9%	14.0%	3.8%	15.1%	5.4%	6.4%	6.9%	11.1%	6.0%	5.2%	4.5%	5.0%	4.8%	3.9%	4.0%	3.4%	6.1%	2.9%	2.8%	2.7%	2.8%	3.7%
IA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	166.7%	62.5%	7.7%	14.3%	6.2%	5.9%	22.2%	4.5%	26.1%	31.0%	18.4%	51.1%	32.4%	16.7%	18.1%	16.9%	23.4%	31.3%	26.8%	12.8%	26.2%	17.2%	10.5%	11.8%	13.8%	12.4%	10.4%	9.0%	10.8%	9.3%	10.9%	9.3%	8.8%	5.1%	7.8%	11.1%	5.1%	7.3%	8.9%	7.8%	15.5%	8.9%	15.3%	2.9%
UT	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	100.0%	50.0%	0.0%	366.7%	39.3%	30.8%	23.5%	23.8%	43.6%	21.4%	33.1%	42.0%	16.3%	15.7%	16.2%	19.4%	25.4%	19.4%	12.1%	10.0%	14.1%	6.1%	16.0%	14.6%	12.4%	4.4%	3.8%	6.2%	7.0%	6.4%	4.9%	4.4%	2.6%	2.1%	5.4%	5.5%	4.5%	4.5%	4.7%	4.7%	2.6%	4.5%
DC	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	400.0%	0.0%	100.0%	0.0%	0.0%	60.0%	6.2%	29.4%	40.9%	25.8%	82.1%	8.5%	27.3%	18.4%	18.1%	33.6%	26.2%	15.6%	13.9%	12.5%	17.3%	23.4%	18.4%	11.4%	15.9%	19.2%	10.6%	9.9%	10.4%	18.9%	5.8%	9.0%	7.1%	5.5%	4.3%	5.3%	6.8%	7.0%	5.4%	7.7%	4.8%	4.8%	5.8%	3.5%
DE	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	300.0%	0.0%	50.0%	0.0%	33.3%	100.0%	56.2%	20.0%	26.7%	18.4%	24.4%	21.4%	33.8%	26.4%	13.0%	25.4%	31.3%	8.4%	13.8%	20.8%	15.4%	6.8%	14.5%	31.8%	13.5%	0.0%	37.9%	0.0%	30.1%	9.9%	11.5%	0.0%	9.9%	8.4%	14.4%	3.0%	12.0%	0.0%	9.3%	8.2%	6.8%	9.2%
KY	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	300.0%	50.0%	33.3%	0.0%	37.5%	27.3%	14.3%	31.2%	4.8%	18.2%	34.6%	34.3%	14.9%	83.3%	5.1%	19.2%	26.6%	26.1%	25.3%	21.8%	30.5%	11.4%	9.3%	23.1%	15.1%	13.2%	7.9%	10.3%	4.1%	5.5%	14.0%	17.1%	25.8%	0.0%	8.7%	6.7%	4.3%	7.9%	3.7%	6.0%	3.8%	7.3%	9.3%	3.0%	4.7%
OK	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	50.0%	0.0%	33.3%	125.0%	11.1%	70.0%	70.6%	51.7%	11.4%	8.2%	26.4%	20.9%	30.9%	54.7%	51.2%	29.8%	17.1%	13.8%	12.1%	17.5%	27.3%	22.3%	12.4%	17.3%	8.0%	6.0%	10.9%	3.5%	10.5%	6.5%	4.1%	5.5%	5.0%	5.6%	3.6%	4.2%	4.6%	4.3%	1.1%	3.1%	4.7%	3.1%
MN	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	100.0%	50.0%	66.7%	80.0%	55.6%	50.0%	66.7%	54.3%	11.1%	28.3%	15.6%	29.2%	20.0%	22.5%	39.1%	11.5%	9.5%	20.6%	15.0%	10.8%	14.1%	14.5%	9.2%	9.5%	7.7%	6.3%	9.6%	8.1%	5.5%	8.4%	8.0%	7.6%	7.6%	6.8%	13.6%	1.8%	2.7%	6.7%	5.7%	8.3%	6.9%	6.5%	4.8%	3.9%	6.0%
AR	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	50.0%	33.3%	33.3%	37.5%	0.0%	50.0%	39.4%	108.7%	22.9%	39.8%	5.5%	25.3%	28.4%	19.6%	13.7%	6.0%	5.4%	11.0%	10.6%	11.7%	10.1%	9.5%	5.5%	11.7%	5.4%	8.1%	5.7%	11.9%	4.6%	4.7%	4.4%	10.2%	5.0%	6.0%	3.3%	4.6%	2.6%	2.4%	8.0%	15.8%	2.2%
KS	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	0.0%	0.0%	300.0%	50.0%	0.0%	33.3%	37.5%	36.4%	6.7%	112.5%	29.4%	25.0%	16.4%	28.1%	19.5%	28.6%	33.3%	20.2%	29.2%	22.2%	15.4%	16.3%	12.6%	14.5%	12.3%	12.6%	7.0%	13.1%	6.5%	16.2%	5.7%	5.4%	8.7%	5.4%	2.9%	3.6%	4.8%	6.3%	7.4%	5.0%	3.3%	7.4%	2.0%	9.2%
NM	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	66.7%	100.0%	0.0%	30.0%	30.8%	35.3%	21.7%	25.0%	22.9%	32.6%	0.0%	14.0%	27.7%	20.5%	12.0%	21.4%	40.4%	24.1%	0.0%	18.6%	12.1%	15.2%	11.0%	22.8%	9.7%	14.9%	9.9%	15.7%	8.9%	26.1%	0.0%	7.6%	6.0%	8.0%	4.6%	5.5%	7.6%	7.1%	5.1%	2.6%	6.8%	5.1%
OR	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	133.3%	100.0%	0.0%	7.1%	26.7%	0.0%	57.9%	0.0%	20.0%	8.3%	20.5%	59.6%	17.3%	29.5%	0.0%	41.2%	18.6%	9.4%	0.0%	56.5%	26.6%	15.7%	14.4%	10.6%	13.9%	6.7%	12.2%	8.8%	11.1%	6.9%	6.0%	4.3%	4.9%	6.6%	0.0%	3.8%	11.4%	3.7%	3.1%	1.8%	4.4%	2.8%	3.3%	3.6%	2.4%	2.4%	2.8%
SD	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	60.0%	12.5%	0.0%	0.0%	11.1%	10.0%	0.0%	0.0%	27.3%	0.0%	50.0%	33.3%	7.1%	36.7%	12.2%	26.1%	17.2%	32.4%	12.2%	6.9%	19.4%	27.9%	13.3%	13.4%	13.2%	20.0%	11.1%	22.8%	13.7%	19.9%	16.8%	16.6%	18.9%	13.8%	18.2%	12.2%	7.6%	9.3%	6.0%	3.1%	4.2%	5.9%
ID	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	150.0%	0.0%	40.0%	28.6%	22.2%	109.1%	34.8%	35.5%	11.9%	6.4%	46.0%	68.5%	53.7%	21.7%	13.5%	18.8%	33.9%	26.5%	27.4%	33.2%	13.7%	6.3%	2.2%	6.3%	3.4%	1.8%	9.8%	3.2%	0.8%	1.4%	1.9%	0.8%	8.4%	1.4%	2.9%	0.8%	0.2%	3.8%	1.7%
NE	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	200.0%	0.0%	66.7%	100.0%	30.0%	7.7%	21.4%	5.9%	16.7%	14.3%	12.5%	18.5%	18.8%	26.3%	4.2%	4.0%	17.3%	19.7%	16.4%	12.9%	12.5%	34.3%	18.6%	22.1%	17.1%	13.4%	15.1%	13.1%	12.7%	9.3%	16.1%	9.2%	12.0%	10.2%	13.0%	2.9%	7.0%	3.4%	5.7%	12.0%	6.8%	13.1%	14.5%	11.8%	4.5%
NH	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	0.0%	0.0%	50.0%	0.0%	16.7%	85.7%	0.0%	30.8%	52.9%	50.0%	12.8%	25.0%	18.2%	20.0%	29.5%	6.9%	26.9%	15.3%	18.4%	14.4%	46.7%	0.0%	32.2%	0.0%	15.4%	12.7%	15.0%	7.7%	6.9%	10.2%	0.0%	3.9%	8.1%	5.0%	6.0%	3.6%	11.7%	0.0%	13.0%	0.0%	4.3%	3.7%	7.1%	0.0%
WV	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	100.0%	250.0%	57.1%	9.1%	33.3%	25.0%	95.0%	30.8%	49.0%	26.3%	17.7%	11.5%	28.6%	17.9%	13.6%	9.2%	19.0%	14.9%	6.5%	19.4%	12.1%	13.2%	5.9%	4.2%	5.9%	2.5%	2.2%	9.7%	5.3%	2.0%	4.1%	9.9%	4.5%	1.3%	2.7%
PR	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	180.0%	50.0%	9.5%	34.8%	25.8%	30.8%	25.5%	23.4%	26.6%	27.0%	37.0%	37.4%	19.7%	10.5%	19.6%	19.6%	5.1%	8.0%	11.7%	8.2%	10.2%	6.1%	8.7%	13.8%	0.7%	2.2%	5.5%	7.1%	2.4%	4.7%	8.5%	3.2%	3.7%	-29.5%
ME	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	200.0%	0.0%	0.0%	466.7%	88.2%	34.4%	23.3%	7.5%	28.1%	21.9%	20.2%	16.8%	19.2%	4.0%	8.4%	25.6%	19.9%	8.7%	10.2%	13.5%	9.3%	14.9%	5.6%	3.1%	6.2%	4.0%	3.5%	4.3%	4.6%	5.1%	2.8%	10.3%	5.2%	4.9%	3.4%	3.9%	2.4%	2.4%	0.9%	1.5%	2.1%
VT	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	0.0%	0.0%	100.0%	0.0%	100.0%	0.0%	100.0%	25.0%	90.0%	15.8%	31.8%	0.0%	79.3%	44.2%	26.7%	29.5%	28.5%	16.5%	14.7%	11.4%	8.9%	14.5%	9.6%	5.3%	15.1%	18.5%	11.1%	6.1%	5.9%	5.2%	3.8%	8.1%	4.7%	2.3%	2.9%	0.5%	0.9%	1.2%	1.4%	3.1%	1.1%	0.5%	0.2%	0.6%
ND	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	0.0%	0.0%	0.0%	200.0%	100.0%	150.0%	33.3%	40.0%	0.0%	7.1%	13.3%	14.7%	33.3%	25.0%	27.7%	18.1%	11.2%	15.6%	12.7%	12.0%	8.8%	7.5%	11.3%	8.7%	5.3%	5.9%	7.2%	3.3%	5.4%	5.1%	7.5%	3.0%	7.0%	7.7%	11.7%	20.3%	10.8%	7.2%	2.7%	5.4%
HI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	250.0%	42.9%	40.0%	14.3%	62.5%	42.3%	29.7%	16.7%	37.5%	16.9%	5.6%	11.6%	13.2%	25.8%	15.9%	16.6%	2.0%	24.0%	10.5%	11.9%	10.0%	5.7%	4.3%	5.9%	6.1%	1.6%	5.2%	4.5%	2.7%	1.0%	2.6%	2.5%	2.1%	2.2%	3.8%	1.0%	0.7%	-0.3%
MT	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	400.0%	40.0%	0.0%	14.3%	25.0%	20.0%	33.3%	25.0%	55.0%	9.7%	35.3%	15.2%	34.0%	52.1%	19.4%	19.4%	11.0%	7.6%	13.0%	9.1%	7.0%	9.1%	7.9%	4.5%	6.7%	4.1%	6.6%	3.1%	3.3%	2.7%	1.8%	1.3%	1.3%	2.7%	1.7%	0.9%	1.6%	0.0%	0.9%	0.5%
AK	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	0.0%	0.0%	200.0%	100.0%	0.0%	100.0%	16.7%	57.1%	0.0%	63.6%	16.7%	40.5%	16.9%	23.2%	20.0%	11.8%	4.4%	11.8%	7.5%	9.8%	8.9%	8.2%	3.2%	11.5%	6.1%	4.0%	4.7%	4.5%	5.8%	1.8%	2.9%	2.8%	2.4%	3.0%	1.6%	1.6%	0.6%	2.5%	1.8%
WY	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	inf%	0.0%	100.0%	50.0%	0.0%	233.3%	50.0%	20.0%	5.6%	21.1%	4.3%	8.3%	11.5%	51.7%	20.5%	32.1%	17.1%	4.9%	9.3%	16.0%	19.3%	15.4%	8.0%	15.4%	5.3%	6.6%	2.9%	2.3%	4.1%	10.0%	3.2%	0.0%	5.4%	0.0%	4.4%	3.1%	0.0%	3.0%	1.3%	1.3%	2.2%	0.6%
GU	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	66.7%	60.0%	50.0%	16.7%	7.1%	80.0%	7.4%	10.3%	15.6%	21.6%	13.3%	7.8%	1.8%	3.6%	19.0%	11.6%	6.5%	2.4%	10.7%	20.4%	0.9%	7.1%	3.3%	2.4%	1.6%	2.3%	0.0%	1.5%	0.0%	0.0%	0.0%	0.7%	0.0%	0.0%	-2.2%	0.0%	0.8%
VI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	100.0%	0.0%	50.0%	0.0%	100.0%	0.0%	183.3%	0.0%	0.0%	0.0%	11.8%	15.8%	4.5%	30.4%	0.0%	0.0%	10.0%