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)
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)
352286
df = pd.read_csv(filename)
df['date'] = pd.to_datetime(df['date'], format="%Y%m%d").dt.date
df = df.sort_values('date')
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}')
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 |
table_df = table_df \
.sort_values(table_df.columns[-1], ascending=False) \
.pct_change(axis=1) \
.fillna(0)
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}'
%%html
<style>
/* css hacks */
.row_heading {
position: sticky;
left: 0;
background: white;
}
tr:hover {
border: 1px solid #2795ee;
}
</style>
s = table_df.style.applymap(colors) \
.format("{:.1%}")
s
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% |