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%	15.2%	5.3%	5.0%	2.4%	0.0%	4.7%	2.2%	8.7%	2.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	3.9%	0.0%	0.0%	1.9%	0.0%
MP	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%	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%	33.3%	0.0%	0.0%	0.0%	0.0%	0.0%	37.5%	0.0%	0.0%	0.0%	0.0%	0.0%	18.2%	0.0%	0.0%	0.0%	7.7%	0.0%	0.0%	0.0%	0.0%
AS	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%	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%	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%

Percent growth avg over past 7 days¶

In [10]:

table_df.rolling(7, axis=1).mean().fillna(0).style.applymap(colors) \
    .format("{:.1%}")

Out[10]:

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%	38.1%	45.2%	63.9%	69.3%	74.3%	77.5%	81.0%	42.9%	49.3%	34.2%	34.3%	33.6%	41.8%	44.0%	54.6%	51.2%	54.2%	55.3%	56.3%	48.3%	45.5%	37.8%	30.5%	26.4%	21.8%	18.1%	16.8%	15.4%	13.9%	12.7%	11.7%	10.8%	10.2%	9.1%	8.6%	8.2%	7.5%	6.8%	6.4%	5.9%	5.5%	5.3%	4.8%	4.3%	4.0%	3.7%	3.5%	3.2%	2.7%
NJ	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	42.9%	50.0%	61.9%	67.1%	75.7%	79.2%	88.8%	45.9%	52.5%	52.2%	54.2%	54.2%	61.1%	54.5%	61.5%	54.1%	49.4%	46.4%	40.7%	38.2%	39.4%	36.1%	32.6%	29.2%	26.8%	26.7%	20.8%	19.1%	17.4%	15.9%	13.8%	13.2%	11.5%	10.4%	9.0%	7.9%	7.4%	6.7%	6.5%	5.9%	5.7%	5.3%	4.9%	4.7%	4.7%	4.3%	4.4%
MA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	42.9%	51.8%	51.8%	82.6%	100.3%	100.3%	100.8%	62.1%	55.0%	55.0%	26.9%	13.8%	16.3%	19.9%	19.3%	21.5%	24.8%	25.0%	27.3%	33.2%	33.7%	34.8%	35.4%	34.5%	33.9%	29.0%	23.1%	20.8%	18.2%	15.6%	14.2%	13.4%	12.7%	11.7%	11.3%	10.6%	10.0%	10.7%	10.0%	9.2%	8.6%	7.9%	7.3%	6.9%	5.9%	5.1%	5.6%	5.3%
CA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	1.9%	4.0%	8.0%	12.2%	14.6%	17.1%	21.2%	19.4%	20.7%	19.1%	17.0%	20.9%	22.1%	25.3%	27.5%	26.8%	27.4%	27.2%	23.9%	21.8%	18.5%	20.5%	20.4%	20.8%	20.8%	20.1%	19.6%	17.5%	15.7%	14.6%	13.0%	12.1%	11.4%	11.1%	10.4%	9.0%	7.2%	7.2%	6.6%	5.7%	5.4%	5.3%	5.1%	5.9%	4.8%	4.8%	5.2%	5.5%
IL	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	3.6%	3.6%	6.4%	6.4%	8.8%	33.3%	33.3%	34.2%	38.2%	41.6%	47.2%	51.3%	37.0%	48.6%	50.7%	52.2%	50.1%	50.1%	46.7%	39.5%	30.9%	29.5%	26.7%	24.8%	23.7%	22.1%	21.8%	21.0%	17.4%	16.9%	17.0%	13.7%	13.6%	12.4%	11.7%	11.5%	10.5%	9.2%	9.2%	8.7%	8.0%	7.2%	6.6%	6.4%	6.2%	5.5%	5.3%	5.2%	5.2%
PA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	21.4%	31.0%	33.8%	38.6%	43.9%	56.3%	44.1%	41.8%	35.2%	36.1%	36.9%	37.1%	31.2%	34.6%	33.9%	35.8%	36.7%	35.8%	37.3%	35.4%	33.3%	32.5%	30.5%	28.6%	26.8%	22.6%	21.0%	20.3%	19.1%	18.0%	17.1%	15.9%	14.7%	13.2%	11.7%	10.3%	9.3%	8.3%	7.3%	6.2%	5.7%	5.3%	5.1%	4.6%	4.5%	4.1%
MI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	40.0%	45.2%	49.6%	54.0%	47.1%	40.2%	38.2%	38.6%	38.4%	37.8%	36.7%	33.8%	31.3%	28.9%	25.4%	23.1%	21.1%	19.5%	17.0%	15.2%	13.5%	12.6%	11.6%	10.8%	10.1%	9.5%	9.1%	9.0%	8.9%	8.4%	8.5%	8.4%	8.1%	7.6%	6.9%	6.2%	5.9%	5.6%	5.0%	4.5%	4.5%	4.5%	4.5%	4.0%	3.6%	3.5%	3.2%	2.9%	2.8%
FL	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	50.0%	50.0%	57.9%	61.0%	61.8%	62.6%	69.4%	21.4%	29.5%	29.3%	33.4%	35.7%	39.4%	42.5%	43.9%	40.6%	36.7%	33.2%	36.0%	34.4%	27.3%	29.5%	27.3%	28.6%	26.7%	25.0%	24.3%	23.0%	19.4%	19.7%	16.9%	16.4%	13.6%	12.9%	12.2%	10.9%	9.1%	7.6%	6.9%	6.4%	5.4%	5.5%	4.9%	4.7%	4.6%	4.3%	3.8%	3.7%	3.3%
LA	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%	134.2%	141.3%	75.7%	63.0%	46.0%	36.0%	37.6%	39.7%	35.2%	33.7%	31.3%	28.6%	28.4%	23.3%	19.5%	21.2%	20.2%	22.2%	21.3%	21.4%	21.0%	21.1%	18.1%	15.5%	10.5%	9.5%	7.0%	6.8%	5.1%	4.1%	3.7%	3.0%	2.6%	2.4%	2.2%	2.2%	2.1%	2.0%
CT	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%	59.3%	63.6%	57.5%	59.8%	51.4%	66.0%	54.1%	44.5%	52.6%	51.3%	47.8%	44.2%	33.5%	33.5%	39.2%	31.0%	27.1%	23.1%	22.0%	22.1%	23.2%	16.5%	15.4%	14.1%	12.2%	14.8%	11.8%	12.1%	11.7%	10.2%	9.0%	9.8%	7.2%	6.9%	5.6%	5.6%	5.8%	5.6%	6.3%
TX	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	57.1%	65.7%	65.7%	72.9%	74.0%	82.8%	84.2%	37.0%	32.8%	34.2%	27.3%	27.9%	23.3%	32.3%	27.5%	31.2%	31.2%	31.7%	32.3%	47.7%	43.6%	41.9%	36.5%	38.5%	39.6%	39.2%	22.7%	18.9%	17.5%	16.9%	15.1%	14.3%	14.3%	13.0%	11.9%	11.9%	10.9%	10.3%	9.8%	8.6%	7.5%	7.1%	5.9%	5.5%	5.0%	4.9%	4.7%	4.5%
GA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	28.6%	31.0%	41.2%	47.1%	51.3%	57.2%	62.2%	41.8%	46.6%	39.5%	36.5%	37.3%	38.0%	39.6%	34.4%	29.8%	30.8%	32.5%	30.6%	27.3%	25.1%	24.7%	23.8%	20.6%	21.6%	21.1%	20.1%	16.9%	15.1%	14.5%	15.1%	12.4%	11.5%	10.3%	10.3%	10.3%	9.5%	9.1%	7.1%	6.1%	5.8%	6.0%	5.5%	5.7%	5.2%	4.9%	4.8%
MD	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%	30.2%	37.8%	40.5%	33.8%	38.7%	38.5%	37.5%	37.1%	33.5%	34.8%	34.6%	29.9%	25.9%	27.5%	26.7%	26.8%	26.3%	25.7%	25.2%	25.0%	22.1%	20.0%	17.9%	16.5%	16.2%	14.9%	15.9%	15.1%	14.3%	13.9%	12.6%	12.1%	11.9%	8.9%	8.3%	7.5%	6.9%	6.6%	6.3%	6.0%	5.7%
OH	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%	62.0%	66.9%	66.6%	68.1%	51.2%	57.8%	38.5%	36.7%	35.8%	34.8%	33.1%	31.6%	28.3%	24.8%	23.6%	21.6%	20.3%	19.0%	16.5%	15.0%	13.7%	12.7%	11.8%	10.6%	9.6%	8.5%	7.5%	7.3%	6.6%	5.9%	6.1%	6.2%	6.2%	7.0%	8.0%	8.8%	9.2%	8.4%
IN	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	14.3%	42.9%	52.4%	55.2%	55.2%	58.8%	48.3%	52.1%	27.1%	21.9%	25.2%	31.1%	36.0%	40.7%	41.1%	43.4%	43.4%	42.3%	43.8%	39.0%	33.8%	32.2%	29.3%	27.6%	25.2%	19.7%	18.2%	16.5%	15.7%	14.4%	12.8%	11.1%	10.5%	9.5%	8.8%	7.6%	6.5%	6.0%	6.0%	5.7%	5.3%	5.1%	5.1%	5.1%	4.8%
WA	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	44.0%	51.9%	40.7%	36.3%	40.0%	31.9%	30.5%	28.8%	24.9%	23.9%	21.1%	17.5%	17.8%	16.7%	16.1%	14.4%	14.2%	13.5%	12.9%	12.8%	13.1%	13.6%	13.3%	13.0%	12.5%	12.5%	11.5%	10.5%	9.3%	8.6%	7.8%	7.3%	6.6%	6.0%	5.4%	5.0%	4.4%	3.7%	3.0%	2.7%	2.2%	1.7%	1.4%	1.3%	1.6%	2.1%	1.8%	2.0%	2.0%
CO	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%	85.7%	48.6%	52.8%	51.1%	49.5%	32.5%	26.4%	21.8%	20.5%	20.7%	24.2%	24.1%	25.9%	26.0%	26.5%	25.1%	23.4%	23.8%	20.7%	18.7%	17.8%	15.0%	13.6%	12.3%	9.6%	10.2%	9.1%	7.8%	8.4%	6.7%	6.2%	6.6%	6.0%	5.7%	5.7%	4.2%	4.9%	4.6%	3.4%	4.0%	4.0%
VA	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%	63.5%	58.3%	38.9%	39.3%	29.7%	21.9%	26.6%	25.8%	26.1%	23.7%	26.5%	25.9%	27.3%	25.8%	22.4%	22.2%	23.4%	21.1%	20.7%	18.8%	18.4%	16.9%	16.1%	15.1%	13.8%	13.2%	12.3%	11.3%	10.5%	10.4%	9.2%	8.7%	8.0%	7.6%	6.8%	7.1%	6.6%	6.3%	5.5%
TN	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	28.6%	28.6%	47.6%	47.6%	70.1%	76.4%	79.7%	54.3%	59.0%	45.8%	50.6%	36.4%	36.9%	42.5%	44.6%	42.9%	38.4%	36.0%	31.0%	27.8%	20.8%	17.4%	17.0%	19.0%	19.3%	17.0%	14.5%	13.6%	13.3%	11.2%	9.3%	7.2%	7.2%	6.8%	6.4%	5.6%	5.7%	5.0%	4.9%	4.4%	4.4%	4.1%	4.2%	3.7%	3.5%	3.7%
NC	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	14.3%	14.3%	14.3%	50.0%	50.0%	60.2%	49.5%	57.1%	62.7%	63.1%	30.5%	38.7%	36.2%	38.5%	35.8%	35.7%	37.6%	39.4%	35.0%	31.1%	28.0%	26.3%	22.4%	23.7%	21.0%	18.0%	16.7%	15.7%	14.6%	14.1%	12.0%	11.6%	11.7%	10.2%	9.4%	8.7%	8.3%	7.7%	6.6%	5.9%	6.0%	6.0%	5.2%	5.3%	5.0%	4.8%	5.0%
MO	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%	32.1%	35.0%	39.8%	48.7%	60.8%	60.2%	53.8%	53.6%	65.5%	60.7%	65.3%	59.0%	50.1%	45.8%	42.5%	31.0%	35.1%	24.3%	20.8%	18.2%	15.8%	16.3%	15.1%	12.7%	11.3%	9.9%	8.8%	8.4%	8.4%	7.1%	6.4%	5.7%	5.4%	4.8%	4.6%	4.5%	4.1%	3.5%	3.3%
RI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	21.4%	16.7%	23.8%	23.8%	9.5%	19.0%	19.0%	37.6%	48.5%	41.4%	42.1%	43.4%	40.1%	44.9%	22.4%	19.5%	23.1%	26.4%	27.5%	22.2%	21.0%	21.0%	20.4%	20.0%	21.3%	21.9%	23.3%	22.0%	19.8%	19.3%	18.0%	15.3%	14.1%	14.4%	14.9%	16.1%	16.5%	16.4%	15.6%	14.9%	13.6%	12.1%	11.0%	9.7%	8.5%	8.0%	7.8%	7.5%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	122.4%	58.5%	45.9%	29.8%	29.8%	30.4%	34.8%	34.4%	29.4%	30.1%	28.0%	25.9%	22.8%	13.6%	13.7%	12.5%	12.2%	12.6%	11.7%	12.0%	12.3%	11.0%	10.6%	10.2%	9.6%	9.1%	8.3%	6.7%	6.2%	5.6%	4.6%	4.3%	4.4%	4.1%
AZ	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	7.1%	16.7%	16.7%	16.7%	19.5%	26.7%	26.7%	19.5%	14.8%	14.8%	21.9%	20.6%	19.2%	27.4%	34.2%	38.0%	44.6%	48.1%	51.4%	49.4%	45.3%	42.4%	36.5%	30.7%	23.8%	20.4%	18.1%	15.9%	13.5%	12.9%	13.9%	11.4%	10.4%	9.9%	9.6%	8.5%	7.7%	6.6%	6.1%	5.8%	5.5%	5.0%	5.5%	4.8%	4.9%	4.6%	4.7%	4.7%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	88.7%	54.4%	57.9%	55.3%	55.3%	48.7%	42.4%	39.7%	33.9%	25.3%	20.5%	19.3%	16.7%	16.2%	13.5%	13.0%	11.9%	11.7%	10.9%	10.8%	9.4%	9.8%	9.0%	8.9%	7.9%	7.8%	7.1%	7.7%	7.0%	6.3%	6.0%	6.3%	6.3%	6.3%	5.5%
WI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	21.4%	45.2%	64.9%	64.9%	75.4%	81.5%	74.8%	74.4%	57.2%	42.2%	47.4%	42.2%	37.3%	31.1%	28.4%	24.7%	22.8%	20.0%	16.5%	16.8%	16.9%	15.0%	13.7%	12.5%	11.5%	10.7%	10.4%	9.7%	8.6%	7.6%	7.0%	6.2%	5.7%	5.0%	4.7%	4.4%	4.3%	4.0%	3.9%	3.8%	4.0%	3.8%	3.8%
SC	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%	45.4%	52.0%	23.1%	25.6%	33.2%	31.6%	33.8%	45.1%	42.6%	43.3%	40.8%	35.1%	36.2%	31.2%	21.3%	23.5%	18.7%	21.2%	17.9%	19.7%	19.7%	20.4%	15.2%	12.4%	12.5%	10.6%	9.0%	10.4%	7.7%	7.3%	7.3%	5.7%	5.3%	4.0%	3.7%	4.1%	4.1%	4.1%	3.3%	3.9%
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%	57.1%	62.9%	71.0%	82.7%	83.4%	99.7%	102.9%	45.8%	50.5%	44.4%	34.7%	41.6%	29.4%	28.1%	30.3%	24.3%	26.2%	26.5%	21.6%	22.7%	22.2%	22.2%	19.7%	16.4%	16.2%	14.3%	10.0%	9.5%	8.9%	7.8%	8.0%	6.5%	6.4%	6.2%	5.8%	4.8%	4.4%	4.5%	4.3%	4.0%	3.7%	3.5%	3.5%
IA	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%	40.8%	17.6%	12.4%	15.8%	16.3%	22.8%	26.5%	25.7%	27.7%	26.4%	25.3%	27.1%	23.7%	20.9%	22.2%	22.1%	21.2%	19.5%	17.0%	15.0%	14.6%	12.2%	11.3%	11.1%	11.0%	10.3%	9.8%	9.0%	8.8%	8.9%	8.3%	7.8%	7.7%	7.6%	9.0%	9.2%	9.8%	9.5%
UT	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	14.3%	28.6%	35.7%	35.7%	88.1%	93.7%	83.8%	87.2%	76.3%	75.4%	78.4%	30.8%	31.2%	29.1%	28.0%	26.9%	23.5%	24.0%	22.1%	17.8%	16.9%	16.7%	15.2%	14.7%	13.2%	12.2%	11.1%	10.2%	9.1%	9.2%	7.8%	6.4%	5.3%	5.0%	4.8%	4.7%	4.5%	4.2%	4.2%	4.2%	4.5%	4.6%	4.4%
DC	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%	80.0%	80.9%	28.0%	33.8%	23.2%	34.9%	36.1%	31.5%	33.2%	31.6%	30.5%	30.6%	21.1%	21.9%	19.7%	19.6%	20.3%	18.2%	16.1%	16.1%	16.9%	16.6%	15.6%	13.7%	13.8%	13.0%	12.0%	10.2%	9.5%	8.7%	8.0%	6.2%	6.4%	5.9%	6.0%	5.9%	5.9%	6.0%	5.6%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	77.1%	37.1%	40.9%	36.4%	39.9%	38.2%	28.7%	24.5%	23.5%	23.3%	25.1%	22.8%	21.7%	19.9%	18.3%	17.4%	15.9%	15.9%	16.7%	14.7%	17.1%	14.9%	18.2%	17.6%	14.7%	12.8%	14.2%	10.0%	12.0%	8.1%	8.4%	6.8%	8.1%	7.9%	7.6%	6.9%
KY	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%	64.0%	66.1%	27.7%	21.2%	19.0%	24.0%	23.5%	21.8%	31.6%	27.9%	29.9%	31.1%	29.9%	28.6%	29.6%	22.1%	23.0%	21.6%	21.1%	19.5%	17.8%	15.8%	12.9%	11.9%	11.3%	10.0%	10.3%	12.1%	11.0%	10.8%	11.1%	10.9%	10.1%	8.2%	5.3%	5.9%	5.7%	6.1%	5.9%	5.4%
OK	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	14.3%	21.4%	21.4%	26.2%	44.0%	45.6%	41.3%	51.4%	51.7%	53.3%	49.7%	35.6%	37.0%	31.4%	29.2%	29.1%	31.7%	33.0%	31.2%	29.9%	28.0%	24.1%	20.0%	17.5%	17.5%	16.7%	15.8%	14.9%	11.5%	9.8%	9.0%	7.1%	6.7%	6.6%	5.8%	5.8%	4.9%	4.6%	4.7%	4.0%	3.8%	3.7%	3.6%
MN	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%	57.5%	67.0%	60.5%	54.9%	49.4%	40.2%	36.5%	32.2%	25.9%	23.7%	23.7%	21.0%	21.8%	19.7%	18.4%	17.2%	13.7%	13.4%	13.4%	11.5%	10.3%	10.1%	9.3%	8.0%	7.9%	7.7%	7.6%	7.8%	7.4%	8.2%	7.7%	6.9%	6.7%	6.4%	6.5%	6.5%	5.5%	5.9%	6.1%	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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	34.8%	43.2%	41.7%	42.6%	38.0%	41.7%	38.6%	35.8%	22.2%	19.8%	14.9%	15.7%	13.6%	11.2%	9.8%	9.2%	9.1%	10.0%	9.2%	8.9%	8.0%	8.3%	7.6%	7.5%	6.4%	7.1%	6.6%	6.7%	5.4%	5.4%	5.1%	4.9%	4.5%	6.1%	5.6%
KS	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%	54.8%	60.1%	65.3%	66.3%	39.5%	36.5%	40.1%	37.7%	36.3%	33.9%	37.1%	25.8%	24.4%	25.1%	25.9%	24.1%	23.6%	21.3%	18.6%	17.5%	15.1%	13.0%	12.6%	11.2%	11.8%	10.5%	9.5%	9.0%	8.7%	7.3%	6.9%	5.2%	5.3%	5.6%	5.1%	4.8%	5.4%	5.2%	5.8%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	40.6%	34.7%	23.7%	28.3%	24.0%	21.6%	20.6%	20.4%	18.5%	18.3%	19.4%	22.9%	20.9%	19.6%	18.4%	18.8%	17.3%	14.8%	12.8%	14.9%	13.7%	14.2%	13.3%	15.5%	12.2%	11.9%	10.6%	10.4%	8.8%	8.3%	5.6%	6.6%	6.3%	5.8%	5.6%	5.7%
OR	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	19.0%	33.3%	33.3%	34.4%	38.2%	38.2%	46.4%	27.4%	16.0%	17.1%	19.1%	23.8%	26.2%	22.2%	22.2%	25.2%	26.7%	25.1%	16.6%	22.2%	21.8%	24.0%	20.2%	19.0%	19.7%	20.6%	14.3%	11.8%	11.1%	10.0%	9.4%	8.0%	7.8%	7.0%	5.7%	4.6%	5.3%	5.0%	4.8%	4.3%	4.0%	4.4%	4.4%	3.3%	3.1%	3.0%	3.1%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	13.4%	4.8%	6.9%	6.9%	14.1%	17.2%	16.8%	22.1%	23.8%	23.6%	26.1%	23.6%	20.6%	20.5%	18.1%	20.3%	18.5%	17.9%	15.2%	16.3%	16.9%	17.4%	15.4%	16.3%	16.8%	17.3%	17.1%	17.5%	16.9%	16.6%	14.9%	13.8%	12.3%	10.0%	8.7%	6.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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	55.0%	38.6%	40.3%	35.5%	38.0%	44.6%	36.7%	34.8%	31.7%	32.6%	36.6%	33.8%	27.9%	25.0%	23.8%	22.8%	20.5%	16.5%	13.2%	9.6%	6.2%	4.7%	3.9%	3.8%	3.2%	2.8%	3.7%	2.5%	2.5%	2.5%	2.3%	2.6%	2.7%
NE	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%	57.8%	60.8%	33.1%	35.5%	28.0%	15.5%	13.9%	15.4%	16.1%	15.9%	14.1%	14.5%	15.5%	15.2%	14.4%	12.4%	16.7%	18.8%	19.5%	19.1%	18.7%	19.0%	19.1%	16.0%	14.7%	13.8%	12.7%	12.5%	11.8%	11.8%	10.4%	10.1%	8.3%	7.7%	7.7%	7.2%	7.3%	8.9%	9.6%	9.8%
NH	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	14.3%	14.3%	14.3%	21.4%	21.4%	23.8%	21.8%	21.8%	26.2%	33.7%	33.7%	35.6%	36.7%	27.1%	30.0%	29.8%	23.2%	19.9%	20.3%	19.3%	18.8%	22.6%	18.4%	22.0%	18.1%	18.2%	17.4%	17.4%	11.9%	12.8%	9.7%	9.7%	8.1%	7.4%	6.0%	5.7%	5.3%	5.5%	5.5%	6.8%	5.6%	5.5%	5.2%	5.7%	4.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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	81.4%	71.5%	42.8%	38.4%	39.6%	36.5%	37.0%	26.0%	23.5%	17.8%	16.8%	16.4%	15.7%	14.4%	13.5%	13.5%	13.0%	10.9%	9.6%	9.0%	6.6%	6.2%	5.1%	4.5%	4.5%	5.1%	5.4%	5.3%	4.3%
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%	25.7%	32.9%	34.2%	39.2%	42.9%	47.3%	50.9%	28.5%	25.2%	27.7%	28.0%	29.7%	28.1%	25.9%	25.4%	24.4%	21.3%	17.1%	13.4%	11.8%	11.8%	9.8%	8.3%	9.5%	8.5%	7.1%	6.7%	6.3%	5.8%	5.2%	4.4%	4.8%	5.0%	0.0%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	116.1%	88.6%	92.6%	95.7%	31.9%	21.7%	19.6%	16.8%	16.9%	16.6%	16.3%	14.7%	13.7%	12.9%	13.7%	14.6%	11.7%	9.3%	9.0%	8.1%	6.6%	5.9%	4.5%	4.4%	4.4%	4.9%	5.1%	5.3%	5.2%	5.1%	4.7%	4.6%	3.3%	2.8%	2.4%
VT	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%	28.6%	42.9%	46.4%	59.3%	47.3%	51.8%	37.5%	48.8%	40.9%	41.1%	32.5%	34.3%	32.1%	34.2%	24.5%	19.4%	17.7%	14.8%	11.5%	11.3%	11.9%	11.8%	11.4%	10.2%	9.6%	9.4%	8.4%	6.4%	5.2%	4.7%	3.9%	3.3%	2.9%	2.0%	1.8%	1.6%	1.3%	1.2%	1.2%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	64.3%	69.0%	74.8%	74.8%	75.8%	49.1%	36.9%	20.3%	19.1%	17.3%	19.9%	20.5%	20.8%	20.5%	17.5%	15.2%	12.3%	11.3%	10.9%	9.5%	8.5%	7.8%	7.0%	6.7%	5.9%	5.7%	5.3%	5.5%	5.6%	6.8%	8.9%	9.7%	9.7%	9.6%	9.4%
HI	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	14.3%	14.3%	14.3%	14.3%	14.3%	14.3%	14.3%	35.7%	41.8%	47.6%	49.6%	58.5%	64.6%	68.8%	35.5%	34.7%	31.4%	30.2%	22.9%	18.7%	18.2%	18.1%	15.1%	12.9%	15.6%	15.4%	15.2%	13.0%	11.5%	9.8%	10.3%	7.8%	6.5%	5.6%	4.8%	4.3%	3.9%	3.4%	2.9%	2.9%	2.5%	2.4%	2.2%	2.1%	1.7%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	71.3%	76.1%	22.5%	24.7%	26.0%	29.0%	27.6%	29.6%	32.3%	31.5%	26.4%	26.6%	22.7%	22.4%	18.8%	12.4%	10.9%	9.3%	8.3%	8.2%	6.9%	6.6%	6.0%	5.2%	4.4%	4.0%	3.3%	2.9%	2.3%	2.1%	1.8%	1.6%	1.4%	1.3%	1.2%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	57.1%	59.5%	67.7%	67.7%	48.2%	36.3%	42.1%	30.2%	31.2%	25.8%	27.5%	19.1%	18.4%	13.7%	12.6%	10.6%	8.9%	7.7%	8.7%	7.9%	7.4%	6.7%	6.0%	5.7%	5.5%	4.3%	3.8%	3.6%	3.3%	2.9%	2.3%	2.1%	2.1%	1.9%
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%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	64.8%	65.6%	54.3%	47.8%	48.9%	17.3%	17.5%	17.6%	21.4%	20.8%	20.9%	21.0%	21.6%	17.0%	16.3%	12.8%	12.6%	12.7%	12.3%	10.4%	8.0%	6.4%	6.7%	4.9%	4.1%	4.0%	3.6%	3.9%	3.7%	2.3%	2.3%	2.5%	1.9%	2.2%	1.7%
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%	9.5%	18.1%	25.2%	27.6%	28.6%	40.1%	41.1%	33.1%	26.7%	22.7%	22.2%	22.3%	11.1%	10.6%	11.8%	11.2%	9.1%	7.5%	7.9%	10.6%	10.2%	8.5%	7.3%	6.8%	6.6%	5.4%	2.5%	2.6%	1.6%	1.1%	0.8%	0.7%	0.3%	0.3%	-0.2%	-0.2%	-0.1%
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%	14.3%	14.3%	21.4%	21.4%	35.7%	35.7%	61.9%	47.6%	47.6%	40.5%	42.2%	30.1%	30.8%	8.9%	8.9%	8.9%	10.4%	10.8%	9.3%	9.4%	5.4%	5.4%	6.1%	5.0%	4.0%	3.6%	2.8%	2.5%	2.5%	1.8%	1.5%	0.3%	0.6%	0.6%	0.6%	0.8%	0.8%
MP	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%	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%	33.3%	33.3%	33.3%	33.3%	10.1%	5.4%	5.4%	5.4%	5.4%	5.4%	8.0%	2.6%	2.6%	2.6%	3.7%	3.7%	3.7%	1.1%	1.1%
AS	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%	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%	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%

Testing ratio and growth¶

Testing ratio = positive ratio / total tests done per day

Growth = new infections per day

In [11]:

for state in df.sort_values('total', ascending=False)['state'].unique():
    state_df = df.loc[df.state == state]
    state_df = state_df.sort_values('date')

    total_tests = state_df.iloc[-1].total
    if total_tests < 500: continue
    state_df['pos ratio'] = state_df['positiveIncrease']/state_df['totalTestResultsIncrease']
    state_df = state_df.fillna(0)
    
    fig = make_subplots(specs=[[{"secondary_y": True}]])
    fig.add_trace(
        go.Scatter(x=state_df['date'], y=state_df['pos ratio'], name="pos ratio"),
        secondary_y=False,
    )
    fig.add_trace(
        go.Scatter(x=state_df['date'], y=state_df['positiveIncrease'], name="new cases"),
        secondary_y=True,
    )
    fig.update_layout(title_text=f"{state} - total: {total_tests:,} mean tests: {state_df['pos ratio'].mean():.2f}")
    fig.update_yaxes(range=[-0.10, 1.10], secondary_y=False)
    fig.update_yaxes(type="log", secondary_y=True)
    fig.show()

In [ ]: