Skip to content

Instantly share code, notes, and snippets.

@MarkBaggett

MarkBaggett/Corona data.ipynb

Last active April 3, 2020 21:14
Show Gist options
  • Save MarkBaggett/046b16bb6b128ee1fae5a66c4ebdfb49 to your computer and use it in GitHub Desktop.
Save MarkBaggett/046b16bb6b128ee1fae5a66c4ebdfb49 to your computer and use it in GitHub Desktop.
Download ZIP
Corona Virus Testing Statistics Jupyter notebook
Display the source blob
Display the rendered blob
Raw
Corona data.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"#Only run this cell ones to collect the data\n",
"\n",
"\n",
"import requests\n",
"import datetime\n",
"\n",
"\n",
"state_data = requests.get('https://covidtracking.com/api/states').json()\n",
"state_historical = requests.get('https://covidtracking.com/api/states/daily').json()\n",
"state_abbreviations = requests.get(\"https://worldpopulationreview.com/static/states/abbr-name.json\").json()\n",
"population_data_raw = requests.get('https://api.census.gov/data/2014/pep/natstprc?get=STNAME,POP&DATE_=7&for=state:*').json()\n",
"population_data = {}\n",
"for st,pop,_,_ in population_data_raw[1:]:\n",
" population_data[st] = pop\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" STATE %Pop Tested %Pop Infected %Positive Rate \n",
" Alaska 5500:0.75 147:0.02 2.67\n",
" Alabama 8773:0.18 1270:0.03 14.48\n",
" Arkansas 8992:0.30 683:0.02 7.60\n",
" Arizona 22709:0.34 1598:0.02 7.04\n",
" California 33000:0.09 9191:0.02 27.85\n",
" Colorado 20411:0.38 3728:0.07 18.26\n",
" Connecticut 18300:0.51 3824:0.11 20.90\n",
"No population data for District Of Columbia\n",
" Delaware 4959:0.53 393:0.04 7.92\n",
" Florida 80356:0.40 9008:0.05 11.21\n",
" Georgia 23053:0.23 5444:0.05 23.62\n",
" Hawaii 10491:0.74 285:0.02 2.72\n",
" Iowa 8668:0.28 614:0.02 7.08\n",
" Idaho 7945:0.49 891:0.05 11.21\n",
" Illinois 43656:0.34 7695:0.06 17.63\n",
" Indiana 16285:0.25 3039:0.05 18.66\n",
" Kansas 6611:0.23 552:0.02 8.35\n",
" Kentucky 12804:0.29 770:0.02 6.01\n",
" Louisiana 51086:1.10 9150:0.20 17.91\n",
" Massachusetts 56608:0.84 8966:0.13 15.84\n",
" Maryland 21221:0.36 2331:0.04 10.98\n",
" Maine 6464:0.49 376:0.03 5.82\n",
" Michigan 22684:0.23 10791:0.11 47.57\n",
" Minnesota 22394:0.41 742:0.01 3.31\n",
" Missouri 21191:0.35 1834:0.03 8.65\n",
" Mississippi 5930:0.20 1177:0.04 19.85\n",
" Montana 5576:0.54 243:0.02 4.36\n",
" North Carolina 28679:0.29 1857:0.02 6.48\n",
" North Dakota 4980:0.67 159:0.02 3.19\n",
" Nebraska 4549:0.24 255:0.01 5.61\n",
" New Hampshire 7054:0.53 479:0.04 6.79\n",
" New Jersey 59110:0.66 25590:0.29 43.29\n",
" New Mexico 14778:0.71 403:0.02 2.73\n",
" Nevada 14046:0.49 1458:0.05 10.38\n",
" New York 238965:1.21 92381:0.47 38.66\n",
" Ohio 34918:0.30 2902:0.03 8.31\n",
" Oklahoma 2144:0.06 879:0.02 41.00\n",
" Oregon 16085:0.41 826:0.02 5.14\n",
" Pennsylvania 54714:0.43 7016:0.05 12.82\n",
" Rhode Island 5069:0.48 657:0.06 12.96\n",
" South Carolina 6995:0.14 1554:0.03 22.22\n",
" South Dakota 4382:0.51 165:0.02 3.77\n",
" Tennessee 34611:0.53 2845:0.04 8.22\n",
" Texas 50679:0.19 4669:0.02 9.21\n",
" Utah 21065:0.72 1074:0.04 5.10\n",
" Virginia 19005:0.23 2012:0.02 10.59\n",
" Vermont 4711:0.75 338:0.05 7.17\n",
" Washington 79418:1.12 6585:0.09 8.29\n",
" Wisconsin 22047:0.38 1730:0.03 7.85\n",
" West Virginia 5493:0.30 217:0.01 3.95\n",
" Wyoming 2669:0.46 153:0.03 5.73\n",
"No population data for Puerto Rico\n",
"No population data for American Samoa\n",
"No population data for Guam\n",
"No population data for Northern Mariana Islands\n",
"No population data for Virgin Islands\n"
]
}
],
"source": [
"print(f\" STATE %Pop Tested %Pop Infected %Positive Rate \")\n",
"\n",
"for each_rec in state_data:\n",
" state = each_rec.get(\"state\")\n",
" state_name = state_abbreviations.get(state)\n",
" state_population = int(population_data.get(state_name,0))\n",
" if not state_population:\n",
" print(f\"No population data for {state_name}\")\n",
" continue\n",
" total= int(each_rec.get(\"totalTestResults\"))\n",
" total_percent = total/state_population*100\n",
" positive = int(each_rec.get(\"positive\"))\n",
" positive_percent = positive/state_population*100\n",
" \n",
" print(f\"{state_name: ^30} {total: 7}:{total/state_population*100: <6.2f} {positive:6}:{positive/state_population*100: <6.2f} {positive/total*100: >5.2f}\")\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Data for Alabama which has a population of 4849377\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Alabama 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 Alabama 0:0.00 0:0.00 0.00 %\n",
"03/09/2020 Alabama 0:0.00 0:0.00 0.00 %\n",
"03/10/2020 Alabama 0:0.00 0:0.00 0.00 %\n",
"03/11/2020 Alabama 10:0.00 0:0.00 0.00 %\n",
"03/12/2020 Alabama 10:0.00 0:0.00 0.00 %\n",
"03/13/2020 Alabama 12:0.00 1:0.00 8.33 %\n",
"03/14/2020 Alabama 74:0.00 6:0.00 8.11 %\n",
"03/15/2020 Alabama 86:0.00 12:0.00 13.95%\n",
"03/16/2020 Alabama 96:0.00 28:0.00 29.17%\n",
"03/17/2020 Alabama 64:0.00 36:0.00 56.25%\n",
"03/18/2020 Alabama 74:0.00 46:0.00 62.16%\n",
"03/19/2020 Alabama 96:0.00 68:0.00 70.83%\n",
"03/20/2020 Alabama 109:0.00 81:0.00 74.31%\n",
"03/21/2020 Alabama 152:0.00 124:0.00 81.58%\n",
"03/22/2020 Alabama 1602:0.03 138:0.00 8.61 %\n",
"03/23/2020 Alabama 1832:0.04 167:0.00 9.12 %\n",
"03/24/2020 Alabama 2321:0.05 215:0.00 9.26 %\n",
"03/25/2020 Alabama 2812:0.06 283:0.01 10.06%\n",
"03/26/2020 Alabama 4099:0.08 506:0.01 12.34%\n",
"03/27/2020 Alabama 4771:0.10 587:0.01 12.30%\n",
"03/28/2020 Alabama 4880:0.10 696:0.01 14.26%\n",
"03/29/2020 Alabama 4990:0.10 806:0.02 16.15%\n",
"03/30/2020 Alabama 6553:0.14 859:0.02 13.11%\n",
"03/31/2020 Alabama 7279:0.15 981:0.02 13.48%\n",
"04/01/2020 Alabama 7774:0.16 1077:0.02 13.85%\n",
"04/02/2020 Alabama 8736:0.18 1233:0.03 14.11%\n",
"\n",
"\n",
"\n",
"Data for Alaska which has a population of 736732\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Alaska 9:0.00 0:0.00 0.00 %\n",
"03/07/2020 Alaska 14:0.00 0:0.00 0.00 %\n",
"03/08/2020 Alaska 20:0.00 0:0.00 0.00 %\n",
"03/09/2020 Alaska 32:0.00 0:0.00 0.00 %\n",
"03/10/2020 Alaska 32:0.00 0:0.00 0.00 %\n",
"03/11/2020 Alaska 60:0.01 0:0.00 0.00 %\n",
"03/12/2020 Alaska 60:0.01 0:0.00 0.00 %\n",
"03/13/2020 Alaska 60:0.01 1:0.00 1.67 %\n",
"03/14/2020 Alaska 144:0.02 1:0.00 0.69 %\n",
"03/15/2020 Alaska 144:0.02 1:0.00 0.69 %\n",
"03/16/2020 Alaska 144:0.02 1:0.00 0.69 %\n",
"03/17/2020 Alaska 337:0.05 3:0.00 0.89 %\n",
"03/18/2020 Alaska 412:0.06 6:0.00 1.46 %\n",
"03/19/2020 Alaska 438:0.06 6:0.00 1.37 %\n",
"03/20/2020 Alaska 698:0.09 12:0.00 1.72 %\n",
"03/21/2020 Alaska 772:0.10 14:0.00 1.81 %\n",
"03/22/2020 Alaska 968:0.13 22:0.00 2.27 %\n",
"03/23/2020 Alaska 968:0.13 22:0.00 2.27 %\n",
"03/24/2020 Alaska 1022:0.14 36:0.00 3.52 %\n",
"03/25/2020 Alaska 1691:0.23 42:0.01 2.48 %\n",
"03/26/2020 Alaska 1860:0.25 59:0.01 3.17 %\n",
"03/27/2020 Alaska 2401:0.33 69:0.01 2.87 %\n",
"03/28/2020 Alaska 2921:0.40 85:0.01 2.91 %\n",
"03/29/2020 Alaska 3334:0.45 102:0.01 3.06 %\n",
"03/30/2020 Alaska 3654:0.50 114:0.02 3.12 %\n",
"03/31/2020 Alaska 3713:0.50 119:0.02 3.20 %\n",
"04/01/2020 Alaska 4603:0.62 133:0.02 2.89 %\n",
"04/02/2020 Alaska 5022:0.68 143:0.02 2.85 %\n",
"\n",
"\n",
"\n",
"Skipping unknown population American Samoa\n",
"Data for Arizona which has a population of 6731484\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Arizona 34:0.00 2:0.00 5.88 %\n",
"03/05/2020 Arizona 36:0.00 2:0.00 5.56 %\n",
"03/06/2020 Arizona 51:0.00 3:0.00 5.88 %\n",
"03/07/2020 Arizona 56:0.00 5:0.00 8.93 %\n",
"03/08/2020 Arizona 56:0.00 5:0.00 8.93 %\n",
"03/09/2020 Arizona 56:0.00 5:0.00 8.93 %\n",
"03/10/2020 Arizona 84:0.00 6:0.00 7.14 %\n",
"03/11/2020 Arizona 100:0.00 9:0.00 9.00 %\n",
"03/12/2020 Arizona 115:0.00 9:0.00 7.83 %\n",
"03/13/2020 Arizona 143:0.00 9:0.00 6.29 %\n",
"03/14/2020 Arizona 183:0.00 12:0.00 6.56 %\n",
"03/15/2020 Arizona 183:0.00 12:0.00 6.56 %\n",
"03/16/2020 Arizona 206:0.00 18:0.00 8.74 %\n",
"03/17/2020 Arizona 228:0.00 20:0.00 8.77 %\n",
"03/18/2020 Arizona 278:0.00 28:0.00 10.07%\n",
"03/19/2020 Arizona 349:0.01 44:0.00 12.61%\n",
"03/20/2020 Arizona 377:0.01 65:0.00 17.24%\n",
"03/21/2020 Arizona 466:0.01 104:0.00 22.32%\n",
"03/22/2020 Arizona 521:0.01 152:0.00 29.17%\n",
"03/23/2020 Arizona 580:0.01 265:0.00 45.69%\n",
"03/24/2020 Arizona 692:0.01 357:0.01 51.59%\n",
"03/25/2020 Arizona 826:0.01 450:0.01 54.48%\n",
"03/26/2020 Arizona 957:0.01 577:0.01 60.29%\n",
"03/27/2020 Arizona 8221:0.12 736:0.01 8.95 %\n",
"03/28/2020 Arizona 8349:0.12 873:0.01 10.46%\n",
"03/29/2020 Arizona 13872:0.21 919:0.01 6.62 %\n",
"03/30/2020 Arizona 16759:0.25 1157:0.02 6.90 %\n",
"03/31/2020 Arizona 19371:0.29 1289:0.02 6.65 %\n",
"04/01/2020 Arizona 21058:0.31 1413:0.02 6.71 %\n",
"04/02/2020 Arizona 22709:0.34 1598:0.02 7.04 %\n",
"\n",
"\n",
"\n",
"Data for Arkansas which has a population of 2966369\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Arkansas 6:0.00 0:0.00 0.00 %\n",
"03/07/2020 Arkansas 6:0.00 0:0.00 0.00 %\n",
"03/08/2020 Arkansas 6:0.00 0:0.00 0.00 %\n",
"03/09/2020 Arkansas 12:0.00 0:0.00 0.00 %\n",
"03/10/2020 Arkansas 15:0.00 0:0.00 0.00 %\n",
"03/11/2020 Arkansas 26:0.00 0:0.00 0.00 %\n",
"03/12/2020 Arkansas 50:0.00 6:0.00 12.00%\n",
"03/13/2020 Arkansas 61:0.00 9:0.00 14.75%\n",
"03/14/2020 Arkansas 103:0.00 12:0.00 11.65%\n",
"03/15/2020 Arkansas 149:0.01 16:0.00 10.74%\n",
"03/16/2020 Arkansas 168:0.01 22:0.00 13.10%\n",
"03/17/2020 Arkansas 260:0.01 22:0.00 8.46 %\n",
"03/18/2020 Arkansas 319:0.01 33:0.00 10.34%\n",
"03/19/2020 Arkansas 469:0.02 46:0.00 9.81 %\n",
"03/20/2020 Arkansas 650:0.02 96:0.00 14.77%\n",
"03/21/2020 Arkansas 839:0.03 118:0.00 14.06%\n",
"03/22/2020 Arkansas 995:0.03 165:0.01 16.58%\n",
"03/23/2020 Arkansas 1080:0.04 174:0.01 16.11%\n",
"03/24/2020 Arkansas 1165:0.04 218:0.01 18.71%\n",
"03/25/2020 Arkansas 1717:0.06 280:0.01 16.31%\n",
"03/26/2020 Arkansas 1839:0.06 335:0.01 18.22%\n",
"03/27/2020 Arkansas 1926:0.06 381:0.01 19.78%\n",
"03/28/2020 Arkansas 3342:0.11 404:0.01 12.09%\n",
"03/29/2020 Arkansas 3453:0.12 426:0.01 12.34%\n",
"03/30/2020 Arkansas 5735:0.19 473:0.02 8.25 %\n",
"03/31/2020 Arkansas 6482:0.22 523:0.02 8.07 %\n",
"04/01/2020 Arkansas 7938:0.27 584:0.02 7.36 %\n",
"04/02/2020 Arkansas 8523:0.29 643:0.02 7.54 %\n",
"\n",
"\n",
"\n",
"Data for California which has a population of 38802500\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 California 515:0.00 53:0.00 10.29%\n",
"03/05/2020 California 515:0.00 53:0.00 10.29%\n",
"03/06/2020 California 522:0.00 60:0.00 11.49%\n",
"03/07/2020 California 531:0.00 69:0.00 12.99%\n",
"03/08/2020 California 550:0.00 88:0.00 16.00%\n",
"03/09/2020 California 804:0.00 114:0.00 14.18%\n",
"03/10/2020 California 823:0.00 133:0.00 16.16%\n",
"03/11/2020 California 1073:0.00 157:0.00 14.63%\n",
"03/12/2020 California 1118:0.00 202:0.00 18.07%\n",
"03/13/2020 California 1118:0.00 202:0.00 18.07%\n",
"03/14/2020 California 1168:0.00 252:0.00 21.58%\n",
"03/15/2020 California 1209:0.00 293:0.00 24.23%\n",
"03/16/2020 California 8316:0.02 335:0.00 4.03 %\n",
"03/17/2020 California 8464:0.02 483:0.00 5.71 %\n",
"03/18/2020 California 8592:0.02 611:0.00 7.11 %\n",
"03/19/2020 California 9711:0.03 924:0.00 9.51 %\n",
"03/20/2020 California 11487:0.03 1063:0.00 9.25 %\n",
"03/21/2020 California 12528:0.03 1279:0.00 10.21%\n",
"03/22/2020 California 12840:0.03 1536:0.00 11.96%\n",
"03/23/2020 California 26400:0.07 1733:0.00 6.56 %\n",
"03/24/2020 California 27654:0.07 2102:0.01 7.60 %\n",
"03/25/2020 California 66876:0.17 2355:0.01 3.52 %\n",
"03/26/2020 California 77786:0.20 3006:0.01 3.86 %\n",
"03/27/2020 California 78659:0.20 3879:0.01 4.93 %\n",
"03/28/2020 California 89592:0.23 4643:0.01 5.18 %\n",
"03/29/2020 California 90657:0.23 5708:0.01 6.30 %\n",
"03/30/2020 California 91396:0.24 6447:0.02 7.05 %\n",
"03/31/2020 California 86654:0.22 7482:0.02 8.63 %\n",
"04/01/2020 California 87327:0.23 8155:0.02 9.34 %\n",
"04/02/2020 California 92500:0.24 9191:0.02 9.94 %\n",
"\n",
"\n",
"\n",
"Data for Colorado which has a population of 5355866\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Colorado 40:0.00 0:0.00 0.00 %\n",
"03/06/2020 Colorado 78:0.00 2:0.00 2.56 %\n",
"03/07/2020 Colorado 132:0.00 8:0.00 6.06 %\n",
"03/08/2020 Colorado 112:0.00 8:0.00 7.14 %\n",
"03/09/2020 Colorado 142:0.00 9:0.00 6.34 %\n",
"03/10/2020 Colorado 155:0.00 12:0.00 7.74 %\n",
"03/11/2020 Colorado 279:0.01 28:0.00 10.04%\n",
"03/12/2020 Colorado 343:0.01 45:0.00 13.12%\n",
"03/13/2020 Colorado 596:0.01 72:0.00 12.08%\n",
"03/14/2020 Colorado 711:0.01 101:0.00 14.21%\n",
"03/15/2020 Colorado 758:0.01 131:0.00 17.28%\n",
"03/16/2020 Colorado 758:0.01 131:0.00 17.28%\n",
"03/17/2020 Colorado 1216:0.02 160:0.00 13.16%\n",
"03/18/2020 Colorado 1800:0.03 183:0.00 10.17%\n",
"03/19/2020 Colorado 2328:0.04 216:0.00 9.28 %\n",
"03/20/2020 Colorado 2952:0.06 277:0.01 9.38 %\n",
"03/21/2020 Colorado 3680:0.07 363:0.01 9.86 %\n",
"03/22/2020 Colorado 4550:0.08 475:0.01 10.44%\n",
"03/23/2020 Colorado 5436:0.10 591:0.01 10.87%\n",
"03/24/2020 Colorado 6224:0.12 720:0.01 11.57%\n",
"03/25/2020 Colorado 7701:0.14 912:0.02 11.84%\n",
"03/26/2020 Colorado 8064:0.15 1086:0.02 13.47%\n",
"03/27/2020 Colorado 10122:0.19 1430:0.03 14.13%\n",
"03/28/2020 Colorado 11676:0.22 1734:0.03 14.85%\n",
"03/29/2020 Colorado 13276:0.25 2061:0.04 15.52%\n",
"03/30/2020 Colorado 15364:0.29 2627:0.05 17.10%\n",
"03/31/2020 Colorado 15364:0.29 2627:0.05 17.10%\n",
"04/01/2020 Colorado 16849:0.31 2966:0.06 17.60%\n",
"04/02/2020 Colorado 18645:0.35 3342:0.06 17.92%\n",
"\n",
"\n",
"\n",
"Data for Connecticut which has a population of 3596677\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Connecticut 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 Connecticut 38:0.00 1:0.00 2.63 %\n",
"03/09/2020 Connecticut 47:0.00 1:0.00 2.13 %\n",
"03/10/2020 Connecticut 56:0.00 2:0.00 3.57 %\n",
"03/11/2020 Connecticut 74:0.00 3:0.00 4.05 %\n",
"03/12/2020 Connecticut 95:0.00 6:0.00 6.32 %\n",
"03/13/2020 Connecticut 105:0.00 6:0.00 5.71 %\n",
"03/14/2020 Connecticut 136:0.00 11:0.00 8.09 %\n",
"03/15/2020 Connecticut 145:0.00 20:0.00 13.79%\n",
"03/16/2020 Connecticut 151:0.00 26:0.00 17.22%\n",
"03/17/2020 Connecticut 166:0.00 41:0.00 24.70%\n",
"03/18/2020 Connecticut 193:0.01 68:0.00 35.23%\n",
"03/19/2020 Connecticut 700:0.02 96:0.00 13.71%\n",
"03/20/2020 Connecticut 798:0.02 194:0.01 24.31%\n",
"03/21/2020 Connecticut 2300:0.06 194:0.01 8.43 %\n",
"03/22/2020 Connecticut 3100:0.09 223:0.01 7.19 %\n",
"03/23/2020 Connecticut 4500:0.13 415:0.01 9.22 %\n",
"03/24/2020 Connecticut 5300:0.15 618:0.02 11.66%\n",
"03/25/2020 Connecticut 5898:0.16 875:0.02 14.84%\n",
"03/26/2020 Connecticut 6637:0.18 1012:0.03 15.25%\n",
"03/27/2020 Connecticut 8400:0.23 1291:0.04 15.37%\n",
"03/28/2020 Connecticut 8400:0.23 1291:0.04 15.37%\n",
"03/29/2020 Connecticut 11900:0.33 1993:0.06 16.75%\n",
"03/30/2020 Connecticut 14600:0.41 2571:0.07 17.61%\n",
"03/31/2020 Connecticut 16157:0.45 3128:0.09 19.36%\n",
"04/01/2020 Connecticut 16600:0.46 3557:0.10 21.43%\n",
"04/02/2020 Connecticut 18300:0.51 3824:0.11 20.90%\n",
"\n",
"\n",
"\n",
"Data for Delaware which has a population of 935614\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Delaware 10:0.00 0:0.00 0.00 %\n",
"03/07/2020 Delaware 10:0.00 0:0.00 0.00 %\n",
"03/08/2020 Delaware 10:0.00 0:0.00 0.00 %\n",
"03/09/2020 Delaware 18:0.00 0:0.00 0.00 %\n",
"03/10/2020 Delaware 20:0.00 0:0.00 0.00 %\n",
"03/11/2020 Delaware 20:0.00 1:0.00 5.00 %\n",
"03/12/2020 Delaware 41:0.00 4:0.00 9.76 %\n",
"03/13/2020 Delaware 44:0.00 4:0.00 9.09 %\n",
"03/14/2020 Delaware 74:0.01 6:0.00 8.11 %\n",
"03/15/2020 Delaware 74:0.01 6:0.00 8.11 %\n",
"03/16/2020 Delaware 76:0.01 8:0.00 10.53%\n",
"03/17/2020 Delaware 52:0.01 16:0.00 30.77%\n",
"03/18/2020 Delaware 61:0.01 25:0.00 40.98%\n",
"03/19/2020 Delaware 66:0.01 30:0.00 45.45%\n",
"03/20/2020 Delaware 74:0.01 38:0.00 51.35%\n",
"03/21/2020 Delaware 81:0.01 45:0.00 55.56%\n",
"03/22/2020 Delaware 92:0.01 56:0.01 60.87%\n",
"03/23/2020 Delaware 104:0.01 68:0.01 65.38%\n",
"03/24/2020 Delaware 127:0.01 91:0.01 71.65%\n",
"03/25/2020 Delaware 151:0.02 115:0.01 76.16%\n",
"03/26/2020 Delaware 166:0.02 130:0.01 78.31%\n",
"03/27/2020 Delaware 199:0.02 163:0.02 81.91%\n",
"03/28/2020 Delaware 250:0.03 214:0.02 85.60%\n",
"03/29/2020 Delaware 268:0.03 232:0.02 86.57%\n",
"03/30/2020 Delaware 2480:0.27 264:0.03 10.65%\n",
"03/31/2020 Delaware 4015:0.43 319:0.03 7.95 %\n",
"04/01/2020 Delaware 4383:0.47 368:0.04 8.40 %\n",
"04/02/2020 Delaware 4959:0.53 393:0.04 7.92 %\n",
"\n",
"\n",
"\n",
"Skipping unknown population District Of Columbia\n",
"Skipping unknown population Federated States Of Micronesia\n",
"Data for Florida which has a population of 19893297\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Florida 42:0.00 2:0.00 4.76 %\n",
"03/05/2020 Florida 109:0.00 9:0.00 8.26 %\n",
"03/06/2020 Florida 115:0.00 9:0.00 7.83 %\n",
"03/07/2020 Florida 202:0.00 14:0.00 6.93 %\n",
"03/08/2020 Florida 243:0.00 17:0.00 7.00 %\n",
"03/09/2020 Florida 273:0.00 18:0.00 6.59 %\n",
"03/10/2020 Florida 396:0.00 19:0.00 4.80 %\n",
"03/11/2020 Florida 476:0.00 28:0.00 5.88 %\n",
"03/12/2020 Florida 480:0.00 32:0.00 6.67 %\n",
"03/13/2020 Florida 749:0.00 50:0.00 6.68 %\n",
"03/14/2020 Florida 776:0.00 77:0.00 9.92 %\n",
"03/15/2020 Florida 1248:0.01 116:0.00 9.29 %\n",
"03/16/2020 Florida 1339:0.01 141:0.00 10.53%\n",
"03/17/2020 Florida 1998:0.01 186:0.00 9.31 %\n",
"03/18/2020 Florida 2493:0.01 314:0.00 12.60%\n",
"03/19/2020 Florida 2942:0.01 390:0.00 13.26%\n",
"03/20/2020 Florida 3416:0.02 520:0.00 15.22%\n",
"03/21/2020 Florida 8239:0.04 658:0.00 7.99 %\n",
"03/22/2020 Florida 9783:0.05 830:0.00 8.48 %\n",
"03/23/2020 Florida 13094:0.07 1171:0.01 8.94 %\n",
"03/24/2020 Florida 15547:0.08 1412:0.01 9.08 %\n",
"03/25/2020 Florida 18289:0.09 1682:0.01 9.20 %\n",
"03/26/2020 Florida 27539:0.14 2355:0.01 8.55 %\n",
"03/27/2020 Florida 32468:0.16 2765:0.01 8.52 %\n",
"03/28/2020 Florida 39129:0.20 3763:0.02 9.62 %\n",
"03/29/2020 Florida 43316:0.22 4246:0.02 9.80 %\n",
"03/30/2020 Florida 53698:0.27 5473:0.03 10.19%\n",
"03/31/2020 Florida 61786:0.31 6338:0.03 10.26%\n",
"04/01/2020 Florida 67719:0.34 6955:0.03 10.27%\n",
"04/02/2020 Florida 78581:0.40 8010:0.04 10.19%\n",
"\n",
"\n",
"\n",
"Data for Georgia which has a population of 10097343\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Georgia 2:0.00 2:0.00 100.00%\n",
"03/05/2020 Georgia 2:0.00 2:0.00 100.00%\n",
"03/06/2020 Georgia 2:0.00 2:0.00 100.00%\n",
"03/07/2020 Georgia 6:0.00 6:0.00 100.00%\n",
"03/08/2020 Georgia 7:0.00 7:0.00 100.00%\n",
"03/09/2020 Georgia 12:0.00 12:0.00 100.00%\n",
"03/10/2020 Georgia 17:0.00 17:0.00 100.00%\n",
"03/11/2020 Georgia 22:0.00 22:0.00 100.00%\n",
"03/12/2020 Georgia 31:0.00 31:0.00 100.00%\n",
"03/13/2020 Georgia 42:0.00 42:0.00 100.00%\n",
"03/14/2020 Georgia 66:0.00 66:0.00 100.00%\n",
"03/15/2020 Georgia 99:0.00 99:0.00 100.00%\n",
"03/16/2020 Georgia 121:0.00 121:0.00 100.00%\n",
"03/17/2020 Georgia 146:0.00 146:0.00 100.00%\n",
"03/18/2020 Georgia 1508:0.01 197:0.00 13.06%\n",
"03/19/2020 Georgia 1831:0.02 287:0.00 15.67%\n",
"03/20/2020 Georgia 2386:0.02 420:0.00 17.60%\n",
"03/21/2020 Georgia 3064:0.03 507:0.01 16.55%\n",
"03/22/2020 Georgia 4020:0.04 600:0.01 14.93%\n",
"03/23/2020 Georgia 5069:0.05 772:0.01 15.23%\n",
"03/24/2020 Georgia 5484:0.05 1026:0.01 18.71%\n",
"03/25/2020 Georgia 6179:0.06 1247:0.01 20.18%\n",
"03/26/2020 Georgia 8926:0.09 1525:0.02 17.08%\n",
"03/27/2020 Georgia 9865:0.10 2001:0.02 20.28%\n",
"03/28/2020 Georgia 11051:0.11 2366:0.02 21.41%\n",
"03/29/2020 Georgia 12564:0.12 2651:0.03 21.10%\n",
"03/30/2020 Georgia 12724:0.13 2809:0.03 22.08%\n",
"03/31/2020 Georgia 16181:0.16 3929:0.04 24.28%\n",
"04/01/2020 Georgia 20326:0.20 4638:0.05 22.82%\n",
"04/02/2020 Georgia 22957:0.23 5348:0.05 23.30%\n",
"\n",
"\n",
"\n",
"Skipping unknown population Guam\n",
"Data for Hawaii which has a population of 1419561\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Hawaii 1:0.00 1:0.00 100.00%\n",
"03/08/2020 Hawaii 1:0.00 1:0.00 100.00%\n",
"03/09/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/10/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/11/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/12/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/13/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/14/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/15/2020 Hawaii 2:0.00 2:0.00 100.00%\n",
"03/16/2020 Hawaii 7:0.00 7:0.00 100.00%\n",
"03/17/2020 Hawaii 10:0.00 10:0.00 100.00%\n",
"03/18/2020 Hawaii 107:0.01 14:0.00 13.08%\n",
"03/19/2020 Hawaii 109:0.01 16:0.00 14.68%\n",
"03/20/2020 Hawaii 150:0.01 26:0.00 17.33%\n",
"03/21/2020 Hawaii 161:0.01 37:0.00 22.98%\n",
"03/22/2020 Hawaii 311:0.02 48:0.00 15.43%\n",
"03/23/2020 Hawaii 3011:0.21 56:0.00 1.86 %\n",
"03/24/2020 Hawaii 3666:0.26 77:0.01 2.10 %\n",
"03/25/2020 Hawaii 4447:0.31 90:0.01 2.02 %\n",
"03/26/2020 Hawaii 4452:0.31 95:0.01 2.13 %\n",
"03/27/2020 Hawaii 4463:0.31 106:0.01 2.38 %\n",
"03/28/2020 Hawaii 4477:0.32 120:0.01 2.68 %\n",
"03/29/2020 Hawaii 7000:0.49 151:0.01 2.16 %\n",
"03/30/2020 Hawaii 8000:0.56 175:0.01 2.19 %\n",
"03/31/2020 Hawaii 8675:0.61 204:0.01 2.35 %\n",
"04/01/2020 Hawaii 8929:0.63 208:0.01 2.33 %\n",
"04/02/2020 Hawaii 10464:0.74 258:0.02 2.47 %\n",
"\n",
"\n",
"\n",
"Data for Idaho which has a population of 1634464\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"03/07/2020 Idaho 27:0.00 0:0.00 0.00 %\n",
"03/08/2020 Idaho 27:0.00 0:0.00 0.00 %\n",
"03/09/2020 Idaho 41:0.00 0:0.00 0.00 %\n",
"03/10/2020 Idaho 41:0.00 0:0.00 0.00 %\n",
"03/11/2020 Idaho 67:0.00 0:0.00 0.00 %\n",
"03/12/2020 Idaho 93:0.01 0:0.00 0.00 %\n",
"03/13/2020 Idaho 131:0.01 0:0.00 0.00 %\n",
"03/14/2020 Idaho 176:0.01 2:0.00 1.14 %\n",
"03/15/2020 Idaho 179:0.01 5:0.00 2.79 %\n",
"03/16/2020 Idaho 270:0.02 5:0.00 1.85 %\n",
"03/17/2020 Idaho 353:0.02 7:0.00 1.98 %\n",
"03/18/2020 Idaho 468:0.03 9:0.00 1.92 %\n",
"03/19/2020 Idaho 470:0.03 11:0.00 2.34 %\n",
"03/20/2020 Idaho 613:0.04 23:0.00 3.75 %\n",
"03/21/2020 Idaho 911:0.06 31:0.00 3.40 %\n",
"03/22/2020 Idaho 1217:0.07 42:0.00 3.45 %\n",
"03/23/2020 Idaho 1356:0.08 47:0.00 3.47 %\n",
"03/24/2020 Idaho 1937:0.12 50:0.00 2.58 %\n",
"03/25/2020 Idaho 1960:0.12 73:0.00 3.72 %\n",
"03/26/2020 Idaho 2188:0.13 123:0.01 5.62 %\n",
"03/27/2020 Idaho 2857:0.17 189:0.01 6.62 %\n",
"03/28/2020 Idaho 3572:0.22 230:0.01 6.44 %\n",
"03/29/2020 Idaho 4282:0.26 261:0.02 6.10 %\n",
"03/30/2020 Idaho 4706:0.29 310:0.02 6.59 %\n",
"03/31/2020 Idaho 5712:0.35 415:0.03 7.27 %\n",
"04/01/2020 Idaho 6601:0.40 525:0.03 7.95 %\n",
"04/02/2020 Idaho 7282:0.45 669:0.04 9.19 %\n",
"\n",
"\n",
"\n",
"Data for Illinois which has a population of 12880580\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Illinois 155:0.00 4:0.00 2.58 %\n",
"03/05/2020 Illinois 197:0.00 5:0.00 2.54 %\n",
"03/06/2020 Illinois 220:0.00 5:0.00 2.27 %\n",
"03/07/2020 Illinois 241:0.00 6:0.00 2.49 %\n",
"03/08/2020 Illinois 241:0.00 6:0.00 2.49 %\n",
"03/09/2020 Illinois 242:0.00 7:0.00 2.89 %\n",
"03/10/2020 Illinois 326:0.00 19:0.00 5.83 %\n",
"03/11/2020 Illinois 326:0.00 19:0.00 5.83 %\n",
"03/12/2020 Illinois 367:0.00 25:0.00 6.81 %\n",
"03/13/2020 Illinois 418:0.00 32:0.00 7.66 %\n",
"03/14/2020 Illinois 444:0.00 46:0.00 10.36%\n",
"03/15/2020 Illinois 708:0.01 64:0.00 9.04 %\n",
"03/16/2020 Illinois 1025:0.01 93:0.00 9.07 %\n",
"03/17/2020 Illinois 1499:0.01 159:0.00 10.61%\n",
"03/18/2020 Illinois 2051:0.02 288:0.00 14.04%\n",
"03/19/2020 Illinois 3147:0.02 422:0.00 13.41%\n",
"03/20/2020 Illinois 4281:0.03 585:0.00 13.67%\n",
"03/21/2020 Illinois 6241:0.05 753:0.01 12.07%\n",
"03/22/2020 Illinois 8320:0.06 1049:0.01 12.61%\n",
"03/23/2020 Illinois 9856:0.08 1273:0.01 12.92%\n",
"03/24/2020 Illinois 11469:0.09 1535:0.01 13.38%\n",
"03/25/2020 Illinois 14209:0.11 1865:0.01 13.13%\n",
"03/26/2020 Illinois 16631:0.13 2538:0.02 15.26%\n",
"03/27/2020 Illinois 21542:0.17 3026:0.02 14.05%\n",
"03/28/2020 Illinois 25491:0.20 3491:0.03 13.70%\n",
"03/29/2020 Illinois 27762:0.22 4596:0.04 16.56%\n",
"03/30/2020 Illinois 30446:0.24 5057:0.04 16.61%\n",
"03/31/2020 Illinois 35225:0.27 5994:0.05 17.02%\n",
"04/01/2020 Illinois 40384:0.31 6980:0.05 17.28%\n",
"04/02/2020 Illinois 43656:0.34 7695:0.06 17.63%\n",
"\n",
"\n",
"\n",
"Data for Indiana which has a population of 6596855\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Indiana 1:0.00 1:0.00 100.00%\n",
"03/07/2020 Indiana 1:0.00 1:0.00 100.00%\n",
"03/08/2020 Indiana 2:0.00 2:0.00 100.00%\n",
"03/09/2020 Indiana 2:0.00 2:0.00 100.00%\n",
"03/10/2020 Indiana 36:0.00 6:0.00 16.67%\n",
"03/11/2020 Indiana 43:0.00 10:0.00 23.26%\n",
"03/12/2020 Indiana 64:0.00 12:0.00 18.75%\n",
"03/13/2020 Indiana 73:0.00 12:0.00 16.44%\n",
"03/14/2020 Indiana 89:0.00 15:0.00 16.85%\n",
"03/15/2020 Indiana 121:0.00 19:0.00 15.70%\n",
"03/16/2020 Indiana 139:0.00 24:0.00 17.27%\n",
"03/17/2020 Indiana 159:0.00 30:0.00 18.87%\n",
"03/18/2020 Indiana 193:0.00 39:0.00 20.21%\n",
"03/19/2020 Indiana 380:0.01 56:0.00 14.74%\n",
"03/20/2020 Indiana 554:0.01 79:0.00 14.26%\n",
"03/21/2020 Indiana 833:0.01 126:0.00 15.13%\n",
"03/22/2020 Indiana 1494:0.02 201:0.00 13.45%\n",
"03/23/2020 Indiana 1960:0.03 259:0.00 13.21%\n",
"03/24/2020 Indiana 2931:0.04 365:0.01 12.45%\n",
"03/25/2020 Indiana 3356:0.05 477:0.01 14.21%\n",
"03/26/2020 Indiana 4651:0.07 645:0.01 13.87%\n",
"03/27/2020 Indiana 6936:0.11 981:0.01 14.14%\n",
"03/28/2020 Indiana 8407:0.13 1232:0.02 14.65%\n",
"03/29/2020 Indiana 9830:0.15 1514:0.02 15.40%\n",
"03/30/2020 Indiana 11658:0.18 1786:0.03 15.32%\n",
"03/31/2020 Indiana 13373:0.20 2159:0.03 16.14%\n",
"04/01/2020 Indiana 14375:0.22 2565:0.04 17.84%\n",
"04/02/2020 Indiana 16285:0.25 3039:0.05 18.66%\n",
"\n",
"\n",
"\n",
"Data for Iowa which has a population of 3107126\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Iowa 17:0.00 0:0.00 0.00 %\n",
"03/07/2020 Iowa 17:0.00 0:0.00 0.00 %\n",
"03/08/2020 Iowa 17:0.00 0:0.00 0.00 %\n",
"03/09/2020 Iowa 37:0.00 3:0.00 8.11 %\n",
"03/10/2020 Iowa 51:0.00 8:0.00 15.69%\n",
"03/11/2020 Iowa 86:0.00 13:0.00 15.12%\n",
"03/12/2020 Iowa 105:0.00 14:0.00 13.33%\n",
"03/13/2020 Iowa 128:0.00 16:0.00 12.50%\n",
"03/14/2020 Iowa 100:0.00 17:0.00 17.00%\n",
"03/15/2020 Iowa 101:0.00 18:0.00 17.82%\n",
"03/16/2020 Iowa 105:0.00 22:0.00 20.95%\n",
"03/17/2020 Iowa 106:0.00 23:0.00 21.70%\n",
"03/18/2020 Iowa 112:0.00 29:0.00 25.89%\n",
"03/19/2020 Iowa 121:0.00 38:0.00 31.40%\n",
"03/20/2020 Iowa 687:0.02 45:0.00 6.55 %\n",
"03/21/2020 Iowa 1117:0.04 68:0.00 6.09 %\n",
"03/22/2020 Iowa 1305:0.04 90:0.00 6.90 %\n",
"03/23/2020 Iowa 2148:0.07 105:0.00 4.89 %\n",
"03/24/2020 Iowa 2439:0.08 124:0.00 5.08 %\n",
"03/25/2020 Iowa 2723:0.09 145:0.00 5.33 %\n",
"03/26/2020 Iowa 2757:0.09 179:0.01 6.49 %\n",
"03/27/2020 Iowa 3975:0.13 235:0.01 5.91 %\n",
"03/28/2020 Iowa 4673:0.15 298:0.01 6.38 %\n",
"03/29/2020 Iowa 5349:0.17 336:0.01 6.28 %\n",
"03/30/2020 Iowa 6586:0.21 424:0.01 6.44 %\n",
"03/31/2020 Iowa 7385:0.24 497:0.02 6.73 %\n",
"04/01/2020 Iowa 7853:0.25 549:0.02 6.99 %\n",
"04/02/2020 Iowa 8668:0.28 614:0.02 7.08 %\n",
"\n",
"\n",
"\n",
"Data for Kansas which has a population of 2904021\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Kansas 4:0.00 0:0.00 0.00 %\n",
"03/07/2020 Kansas 13:0.00 0:0.00 0.00 %\n",
"03/08/2020 Kansas 12:0.00 1:0.00 8.33 %\n",
"03/09/2020 Kansas 12:0.00 1:0.00 8.33 %\n",
"03/10/2020 Kansas 39:0.00 1:0.00 2.56 %\n",
"03/11/2020 Kansas 42:0.00 1:0.00 2.38 %\n",
"03/12/2020 Kansas 45:0.00 4:0.00 8.89 %\n",
"03/13/2020 Kansas 99:0.00 6:0.00 6.06 %\n",
"03/14/2020 Kansas 99:0.00 6:0.00 6.06 %\n",
"03/15/2020 Kansas 143:0.00 8:0.00 5.59 %\n",
"03/16/2020 Kansas 177:0.01 11:0.00 6.21 %\n",
"03/17/2020 Kansas 397:0.01 15:0.00 3.78 %\n",
"03/18/2020 Kansas 433:0.01 16:0.00 3.70 %\n",
"03/19/2020 Kansas 451:0.02 34:0.00 7.54 %\n",
"03/20/2020 Kansas 461:0.02 44:0.00 9.54 %\n",
"03/21/2020 Kansas 472:0.02 55:0.00 11.65%\n",
"03/22/2020 Kansas 481:0.02 64:0.00 13.31%\n",
"03/23/2020 Kansas 499:0.02 82:0.00 16.43%\n",
"03/24/2020 Kansas 2184:0.08 98:0.00 4.49 %\n",
"03/25/2020 Kansas 2486:0.09 126:0.00 5.07 %\n",
"03/26/2020 Kansas 3037:0.10 168:0.01 5.53 %\n",
"03/27/2020 Kansas 3431:0.12 202:0.01 5.89 %\n",
"03/28/2020 Kansas 3932:0.14 261:0.01 6.64 %\n",
"03/29/2020 Kansas 4513:0.16 319:0.01 7.07 %\n",
"03/30/2020 Kansas 4922:0.17 368:0.01 7.48 %\n",
"03/31/2020 Kansas 5424:0.19 428:0.01 7.89 %\n",
"04/01/2020 Kansas 5893:0.20 482:0.02 8.18 %\n",
"04/02/2020 Kansas 6611:0.23 552:0.02 8.35 %\n",
"\n",
"\n",
"\n",
"Data for Kentucky which has a population of 4413457\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Kentucky 10:0.00 0:0.00 0.00 %\n",
"03/07/2020 Kentucky 10:0.00 1:0.00 10.00%\n",
"03/08/2020 Kentucky 14:0.00 1:0.00 7.14 %\n",
"03/09/2020 Kentucky 21:0.00 4:0.00 19.05%\n",
"03/10/2020 Kentucky 34:0.00 6:0.00 17.65%\n",
"03/11/2020 Kentucky 54:0.00 8:0.00 14.81%\n",
"03/12/2020 Kentucky 64:0.00 8:0.00 12.50%\n",
"03/13/2020 Kentucky 118:0.00 11:0.00 9.32 %\n",
"03/14/2020 Kentucky 153:0.00 14:0.00 9.15 %\n",
"03/15/2020 Kentucky 155:0.00 16:0.00 10.32%\n",
"03/16/2020 Kentucky 255:0.01 21:0.00 8.24 %\n",
"03/17/2020 Kentucky 317:0.01 22:0.00 6.94 %\n",
"03/18/2020 Kentucky 380:0.01 26:0.00 6.84 %\n",
"03/19/2020 Kentucky 489:0.01 35:0.00 7.16 %\n",
"03/20/2020 Kentucky 639:0.01 47:0.00 7.36 %\n",
"03/21/2020 Kentucky 768:0.02 54:0.00 7.03 %\n",
"03/22/2020 Kentucky 1571:0.04 99:0.00 6.30 %\n",
"03/23/2020 Kentucky 1866:0.04 104:0.00 5.57 %\n",
"03/24/2020 Kentucky 1886:0.04 124:0.00 6.57 %\n",
"03/25/2020 Kentucky 3022:0.07 157:0.00 5.20 %\n",
"03/26/2020 Kentucky 3300:0.07 198:0.00 6.00 %\n",
"03/27/2020 Kentucky 4016:0.09 248:0.01 6.18 %\n",
"03/28/2020 Kentucky 5123:0.12 302:0.01 5.89 %\n",
"03/29/2020 Kentucky 5541:0.13 394:0.01 7.11 %\n",
"03/30/2020 Kentucky 6018:0.14 439:0.01 7.29 %\n",
"03/31/2020 Kentucky 6810:0.15 480:0.01 7.05 %\n",
"04/01/2020 Kentucky 7556:0.17 591:0.01 7.82 %\n",
"04/02/2020 Kentucky 7900:0.18 680:0.02 8.61 %\n",
"\n",
"\n",
"\n",
"Data for Louisiana which has a population of 4649676\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Louisiana 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 Louisiana 5:0.00 0:0.00 0.00 %\n",
"03/09/2020 Louisiana 6:0.00 1:0.00 16.67%\n",
"03/10/2020 Louisiana 12:0.00 1:0.00 8.33 %\n",
"03/11/2020 Louisiana 43:0.00 6:0.00 13.95%\n",
"03/12/2020 Louisiana 51:0.00 14:0.00 27.45%\n",
"03/13/2020 Louisiana 73:0.00 36:0.00 49.32%\n",
"03/14/2020 Louisiana 178:0.00 69:0.00 38.76%\n",
"03/15/2020 Louisiana 247:0.01 91:0.00 36.84%\n",
"03/16/2020 Louisiana 302:0.01 114:0.00 37.75%\n",
"03/17/2020 Louisiana 457:0.01 171:0.00 37.42%\n",
"03/18/2020 Louisiana 575:0.01 240:0.01 41.74%\n",
"03/19/2020 Louisiana 805:0.02 347:0.01 43.11%\n",
"03/20/2020 Louisiana 1047:0.02 479:0.01 45.75%\n",
"03/21/2020 Louisiana 2765:0.06 585:0.01 21.16%\n",
"03/22/2020 Louisiana 3498:0.08 837:0.02 23.93%\n",
"03/23/2020 Louisiana 5948:0.13 1172:0.03 19.70%\n",
"03/24/2020 Louisiana 8603:0.19 1388:0.03 16.13%\n",
"03/25/2020 Louisiana 11451:0.25 1795:0.04 15.68%\n",
"03/26/2020 Louisiana 18029:0.39 2305:0.05 12.78%\n",
"03/27/2020 Louisiana 21359:0.46 2746:0.06 12.86%\n",
"03/28/2020 Louisiana 25161:0.54 3315:0.07 13.18%\n",
"03/29/2020 Louisiana 27871:0.60 3540:0.08 12.70%\n",
"03/30/2020 Louisiana 34033:0.73 4025:0.09 11.83%\n",
"03/31/2020 Louisiana 38967:0.84 5237:0.11 13.44%\n",
"04/01/2020 Louisiana 45776:0.98 6424:0.14 14.03%\n",
"04/02/2020 Louisiana 51086:1.10 9150:0.20 17.91%\n",
"\n",
"\n",
"\n",
"Data for Maine which has a population of 1330089\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Maine 1:0.00 0:0.00 0.00 %\n",
"03/08/2020 Maine 1:0.00 0:0.00 0.00 %\n",
"03/09/2020 Maine 1:0.00 0:0.00 0.00 %\n",
"03/10/2020 Maine 25:0.00 0:0.00 0.00 %\n",
"03/11/2020 Maine 47:0.00 0:0.00 0.00 %\n",
"03/12/2020 Maine 86:0.01 1:0.00 1.16 %\n",
"03/13/2020 Maine 111:0.01 3:0.00 2.70 %\n",
"03/14/2020 Maine 111:0.01 3:0.00 2.70 %\n",
"03/15/2020 Maine 111:0.01 3:0.00 2.70 %\n",
"03/16/2020 Maine 781:0.06 17:0.00 2.18 %\n",
"03/17/2020 Maine 1335:0.10 32:0.00 2.40 %\n",
"03/18/2020 Maine 1713:0.13 43:0.00 2.51 %\n",
"03/19/2020 Maine 2057:0.15 53:0.00 2.58 %\n",
"03/20/2020 Maine 2321:0.17 57:0.00 2.46 %\n",
"03/21/2020 Maine 2337:0.18 73:0.01 3.12 %\n",
"03/22/2020 Maine 2353:0.18 89:0.01 3.78 %\n",
"03/23/2020 Maine 2898:0.22 107:0.01 3.69 %\n",
"03/24/2020 Maine 3139:0.24 125:0.01 3.98 %\n",
"03/25/2020 Maine 3326:0.25 149:0.01 4.48 %\n",
"03/26/2020 Maine 3549:0.27 155:0.01 4.37 %\n",
"03/27/2020 Maine 3562:0.27 168:0.01 4.72 %\n",
"03/28/2020 Maine 3605:0.27 211:0.02 5.85 %\n",
"03/29/2020 Maine 3647:0.27 253:0.02 6.94 %\n",
"03/30/2020 Maine 3669:0.28 275:0.02 7.50 %\n",
"03/31/2020 Maine 6391:0.48 303:0.02 4.74 %\n",
"04/01/2020 Maine 6432:0.48 344:0.03 5.35 %\n",
"04/02/2020 Maine 6464:0.49 376:0.03 5.82 %\n",
"\n",
"\n",
"\n",
"Skipping unknown population Marshall Islands\n",
"Data for Maryland which has a population of 5976407\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Maryland 31:0.00 0:0.00 0.00 %\n",
"03/06/2020 Maryland 41:0.00 3:0.00 7.32 %\n",
"03/07/2020 Maryland 44:0.00 3:0.00 6.82 %\n",
"03/08/2020 Maryland 55:0.00 3:0.00 5.45 %\n",
"03/09/2020 Maryland 78:0.00 5:0.00 6.41 %\n",
"03/10/2020 Maryland 95:0.00 6:0.00 6.32 %\n",
"03/11/2020 Maryland 103:0.00 9:0.00 8.74 %\n",
"03/12/2020 Maryland 106:0.00 12:0.00 11.32%\n",
"03/13/2020 Maryland 111:0.00 17:0.00 15.32%\n",
"03/14/2020 Maryland 120:0.00 26:0.00 21.67%\n",
"03/15/2020 Maryland 125:0.00 31:0.00 24.80%\n",
"03/16/2020 Maryland 131:0.00 37:0.00 28.24%\n",
"03/17/2020 Maryland 151:0.00 57:0.00 37.75%\n",
"03/18/2020 Maryland 179:0.00 85:0.00 47.49%\n",
"03/19/2020 Maryland 201:0.00 107:0.00 53.23%\n",
"03/20/2020 Maryland 243:0.00 149:0.00 61.32%\n",
"03/21/2020 Maryland 284:0.00 190:0.00 66.90%\n",
"03/22/2020 Maryland 338:0.01 244:0.00 72.19%\n",
"03/23/2020 Maryland 382:0.01 288:0.00 75.39%\n",
"03/24/2020 Maryland 443:0.01 349:0.01 78.78%\n",
"03/25/2020 Maryland 517:0.01 423:0.01 81.82%\n",
"03/26/2020 Maryland 674:0.01 580:0.01 86.05%\n",
"03/27/2020 Maryland 868:0.01 774:0.01 89.17%\n",
"03/28/2020 Maryland 12508:0.21 992:0.02 7.93 %\n",
"03/29/2020 Maryland 13593:0.23 1239:0.02 9.11 %\n",
"03/30/2020 Maryland 14729:0.25 1413:0.02 9.59 %\n",
"03/31/2020 Maryland 16528:0.28 1660:0.03 10.04%\n",
"04/01/2020 Maryland 19218:0.32 1985:0.03 10.33%\n",
"04/02/2020 Maryland 21221:0.36 2331:0.04 10.98%\n",
"\n",
"\n",
"\n",
"Data for Massachusetts which has a population of 6745408\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Massachusetts 2:0.00 2:0.00 100.00%\n",
"03/05/2020 Massachusetts 2:0.00 2:0.00 100.00%\n",
"03/06/2020 Massachusetts 8:0.00 8:0.00 100.00%\n",
"03/07/2020 Massachusetts 13:0.00 13:0.00 100.00%\n",
"03/08/2020 Massachusetts 13:0.00 13:0.00 100.00%\n",
"03/09/2020 Massachusetts 41:0.00 41:0.00 100.00%\n",
"03/10/2020 Massachusetts 92:0.00 92:0.00 100.00%\n",
"03/11/2020 Massachusetts 92:0.00 92:0.00 100.00%\n",
"03/12/2020 Massachusetts 95:0.00 95:0.00 100.00%\n",
"03/13/2020 Massachusetts 215:0.00 123:0.00 57.21%\n",
"03/14/2020 Massachusetts 490:0.01 138:0.00 28.16%\n",
"03/15/2020 Massachusetts 490:0.01 138:0.00 28.16%\n",
"03/16/2020 Massachusetts 516:0.01 164:0.00 31.78%\n",
"03/17/2020 Massachusetts 1759:0.03 218:0.00 12.39%\n",
"03/18/2020 Massachusetts 2271:0.03 256:0.00 11.27%\n",
"03/19/2020 Massachusetts 3132:0.05 328:0.00 10.47%\n",
"03/20/2020 Massachusetts 4091:0.06 413:0.01 10.10%\n",
"03/21/2020 Massachusetts 5277:0.08 525:0.01 9.95 %\n",
"03/22/2020 Massachusetts 6105:0.09 646:0.01 10.58%\n",
"03/23/2020 Massachusetts 8922:0.13 777:0.01 8.71 %\n",
"03/24/2020 Massachusetts 13749:0.20 1159:0.02 8.43 %\n",
"03/25/2020 Massachusetts 19794:0.29 1838:0.03 9.29 %\n",
"03/26/2020 Massachusetts 23621:0.35 2417:0.04 10.23%\n",
"03/27/2020 Massachusetts 29371:0.44 3240:0.05 11.03%\n",
"03/28/2020 Massachusetts 35049:0.52 4257:0.06 12.15%\n",
"03/29/2020 Massachusetts 39066:0.58 4955:0.07 12.68%\n",
"03/30/2020 Massachusetts 42793:0.63 5752:0.09 13.44%\n",
"03/31/2020 Massachusetts 46935:0.70 6620:0.10 14.10%\n",
"04/01/2020 Massachusetts 51738:0.77 7738:0.11 14.96%\n",
"04/02/2020 Massachusetts 56608:0.84 8966:0.13 15.84%\n",
"\n",
"\n",
"\n",
"Data for Michigan which has a population of 9909877\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Michigan 8:0.00 0:0.00 0.00 %\n",
"03/06/2020 Michigan 16:0.00 0:0.00 0.00 %\n",
"03/07/2020 Michigan 27:0.00 0:0.00 0.00 %\n",
"03/08/2020 Michigan 36:0.00 0:0.00 0.00 %\n",
"03/09/2020 Michigan 47:0.00 0:0.00 0.00 %\n",
"03/10/2020 Michigan 63:0.00 0:0.00 0.00 %\n",
"03/11/2020 Michigan 77:0.00 2:0.00 2.60 %\n",
"03/12/2020 Michigan 120:0.00 2:0.00 1.67 %\n",
"03/13/2020 Michigan 175:0.00 16:0.00 9.14 %\n",
"03/14/2020 Michigan 256:0.00 25:0.00 9.77 %\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"03/15/2020 Michigan 264:0.00 33:0.00 12.50%\n",
"03/16/2020 Michigan 355:0.00 53:0.00 14.93%\n",
"03/17/2020 Michigan 337:0.00 65:0.00 19.29%\n",
"03/18/2020 Michigan 352:0.00 80:0.00 22.73%\n",
"03/19/2020 Michigan 2449:0.02 336:0.00 13.72%\n",
"03/20/2020 Michigan 2618:0.03 549:0.01 20.97%\n",
"03/21/2020 Michigan 2856:0.03 787:0.01 27.56%\n",
"03/22/2020 Michigan 3104:0.03 1035:0.01 33.34%\n",
"03/23/2020 Michigan 3397:0.03 1328:0.01 39.09%\n",
"03/24/2020 Michigan 3860:0.04 1791:0.02 46.40%\n",
"03/25/2020 Michigan 4363:0.04 2294:0.02 52.58%\n",
"03/26/2020 Michigan 9406:0.09 2856:0.03 30.36%\n",
"03/27/2020 Michigan 10207:0.10 3657:0.04 35.83%\n",
"03/28/2020 Michigan 12766:0.13 3657:0.04 28.65%\n",
"03/29/2020 Michigan 17379:0.18 5486:0.06 31.57%\n",
"03/30/2020 Michigan 18391:0.19 6498:0.07 35.33%\n",
"03/31/2020 Michigan 19508:0.20 7615:0.08 39.04%\n",
"04/01/2020 Michigan 21227:0.21 9334:0.09 43.97%\n",
"04/02/2020 Michigan 22684:0.23 10791:0.11 47.57%\n",
"\n",
"\n",
"\n",
"Data for Minnesota which has a population of 5457173\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Minnesota 36:0.00 0:0.00 0.00 %\n",
"03/07/2020 Minnesota 49:0.00 1:0.00 2.04 %\n",
"03/08/2020 Minnesota 49:0.00 1:0.00 2.04 %\n",
"03/09/2020 Minnesota 82:0.00 2:0.00 2.44 %\n",
"03/10/2020 Minnesota 135:0.00 3:0.00 2.22 %\n",
"03/11/2020 Minnesota 222:0.00 5:0.00 2.25 %\n",
"03/12/2020 Minnesota 316:0.01 9:0.00 2.85 %\n",
"03/13/2020 Minnesota 555:0.01 14:0.00 2.52 %\n",
"03/14/2020 Minnesota 868:0.02 21:0.00 2.42 %\n",
"03/15/2020 Minnesota 1422:0.03 35:0.00 2.46 %\n",
"03/16/2020 Minnesota 1893:0.03 54:0.00 2.85 %\n",
"03/17/2020 Minnesota 2336:0.04 60:0.00 2.57 %\n",
"03/18/2020 Minnesota 2762:0.05 77:0.00 2.79 %\n",
"03/19/2020 Minnesota 3038:0.06 89:0.00 2.93 %\n",
"03/20/2020 Minnesota 3856:0.07 115:0.00 2.98 %\n",
"03/21/2020 Minnesota 4090:0.07 138:0.00 3.37 %\n",
"03/22/2020 Minnesota 4680:0.09 169:0.00 3.61 %\n",
"03/23/2020 Minnesota 4746:0.09 235:0.00 4.95 %\n",
"03/24/2020 Minnesota 5812:0.11 262:0.00 4.51 %\n",
"03/25/2020 Minnesota 11475:0.21 287:0.01 2.50 %\n",
"03/26/2020 Minnesota 12950:0.24 346:0.01 2.67 %\n",
"03/27/2020 Minnesota 14003:0.26 398:0.01 2.84 %\n",
"03/28/2020 Minnesota 16129:0.30 441:0.01 2.73 %\n",
"03/29/2020 Minnesota 17657:0.32 503:0.01 2.85 %\n",
"03/30/2020 Minnesota 18822:0.34 576:0.01 3.06 %\n",
"03/31/2020 Minnesota 19780:0.36 629:0.01 3.18 %\n",
"04/01/2020 Minnesota 21191:0.39 689:0.01 3.25 %\n",
"04/02/2020 Minnesota 22394:0.41 742:0.01 3.31 %\n",
"\n",
"\n",
"\n",
"Data for Mississippi which has a population of 2994079\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Mississippi 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 Mississippi 0:0.00 0:0.00 0.00 %\n",
"03/09/2020 Mississippi 0:0.00 0:0.00 0.00 %\n",
"03/10/2020 Mississippi 0:0.00 0:0.00 0.00 %\n",
"03/11/2020 Mississippi 20:0.00 0:0.00 0.00 %\n",
"03/12/2020 Mississippi 42:0.00 1:0.00 2.38 %\n",
"03/13/2020 Mississippi 45:0.00 4:0.00 8.89 %\n",
"03/14/2020 Mississippi 90:0.00 6:0.00 6.67 %\n",
"03/15/2020 Mississippi 94:0.00 10:0.00 10.64%\n",
"03/16/2020 Mississippi 289:0.01 12:0.00 4.15 %\n",
"03/17/2020 Mississippi 389:0.01 21:0.00 5.40 %\n",
"03/18/2020 Mississippi 513:0.02 34:0.00 6.63 %\n",
"03/19/2020 Mississippi 602:0.02 50:0.00 8.31 %\n",
"03/20/2020 Mississippi 775:0.03 80:0.00 10.32%\n",
"03/21/2020 Mississippi 835:0.03 140:0.00 16.77%\n",
"03/22/2020 Mississippi 1321:0.04 207:0.01 15.67%\n",
"03/23/2020 Mississippi 1392:0.05 249:0.01 17.89%\n",
"03/24/2020 Mississippi 1872:0.06 320:0.01 17.09%\n",
"03/25/2020 Mississippi 1943:0.06 377:0.01 19.40%\n",
"03/26/2020 Mississippi 2776:0.09 485:0.02 17.47%\n",
"03/27/2020 Mississippi 3139:0.10 579:0.02 18.45%\n",
"03/28/2020 Mississippi 3223:0.11 663:0.02 20.57%\n",
"03/29/2020 Mississippi 3318:0.11 758:0.03 22.85%\n",
"03/30/2020 Mississippi 3836:0.13 847:0.03 22.08%\n",
"03/31/2020 Mississippi 4474:0.15 937:0.03 20.94%\n",
"04/01/2020 Mississippi 4785:0.16 1073:0.04 22.42%\n",
"04/02/2020 Mississippi 5930:0.20 1177:0.04 19.85%\n",
"\n",
"\n",
"\n",
"Data for Missouri which has a population of 6063589\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Missouri 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 Missouri 1:0.00 1:0.00 100.00%\n",
"03/09/2020 Missouri 1:0.00 1:0.00 100.00%\n",
"03/10/2020 Missouri 1:0.00 1:0.00 100.00%\n",
"03/11/2020 Missouri 1:0.00 1:0.00 100.00%\n",
"03/12/2020 Missouri 65:0.00 1:0.00 1.54 %\n",
"03/13/2020 Missouri 73:0.00 2:0.00 2.74 %\n",
"03/14/2020 Missouri 94:0.00 4:0.00 4.26 %\n",
"03/15/2020 Missouri 127:0.00 5:0.00 3.94 %\n",
"03/16/2020 Missouri 170:0.00 6:0.00 3.53 %\n",
"03/17/2020 Missouri 215:0.00 8:0.00 3.72 %\n",
"03/18/2020 Missouri 266:0.00 13:0.00 4.89 %\n",
"03/19/2020 Missouri 332:0.01 24:0.00 7.23 %\n",
"03/20/2020 Missouri 416:0.01 47:0.00 11.30%\n",
"03/21/2020 Missouri 442:0.01 73:0.00 16.52%\n",
"03/22/2020 Missouri 459:0.01 90:0.00 19.61%\n",
"03/23/2020 Missouri 552:0.01 183:0.00 33.15%\n",
"03/24/2020 Missouri 552:0.01 183:0.00 33.15%\n",
"03/25/2020 Missouri 725:0.01 356:0.01 49.10%\n",
"03/26/2020 Missouri 871:0.01 502:0.01 57.63%\n",
"03/27/2020 Missouri 1038:0.02 669:0.01 64.45%\n",
"03/28/2020 Missouri 10920:0.18 838:0.01 7.67 %\n",
"03/29/2020 Missouri 12385:0.20 838:0.01 6.77 %\n",
"03/30/2020 Missouri 14235:0.23 1031:0.02 7.24 %\n",
"03/31/2020 Missouri 15941:0.26 1327:0.02 8.32 %\n",
"04/01/2020 Missouri 17427:0.29 1581:0.03 9.07 %\n",
"04/02/2020 Missouri 19683:0.32 1834:0.03 9.32 %\n",
"\n",
"\n",
"\n",
"Data for Montana which has a population of 1023579\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Montana 11:0.00 0:0.00 0.00 %\n",
"03/08/2020 Montana 11:0.00 0:0.00 0.00 %\n",
"03/09/2020 Montana 11:0.00 0:0.00 0.00 %\n",
"03/10/2020 Montana 15:0.00 0:0.00 0.00 %\n",
"03/11/2020 Montana 21:0.00 0:0.00 0.00 %\n",
"03/12/2020 Montana 35:0.00 1:0.00 2.86 %\n",
"03/13/2020 Montana 56:0.01 1:0.00 1.79 %\n",
"03/14/2020 Montana 108:0.01 5:0.00 4.63 %\n",
"03/15/2020 Montana 167:0.02 7:0.00 4.19 %\n",
"03/16/2020 Montana 205:0.02 7:0.00 3.41 %\n",
"03/17/2020 Montana 311:0.03 8:0.00 2.57 %\n",
"03/18/2020 Montana 509:0.05 10:0.00 1.96 %\n",
"03/19/2020 Montana 773:0.08 12:0.00 1.55 %\n",
"03/20/2020 Montana 947:0.09 16:0.00 1.69 %\n",
"03/21/2020 Montana 1166:0.11 20:0.00 1.72 %\n",
"03/22/2020 Montana 1177:0.11 31:0.00 2.63 %\n",
"03/23/2020 Montana 1180:0.12 34:0.00 2.88 %\n",
"03/24/2020 Montana 1689:0.17 46:0.00 2.72 %\n",
"03/25/2020 Montana 2001:0.20 53:0.01 2.65 %\n",
"03/26/2020 Montana 2199:0.21 71:0.01 3.23 %\n",
"03/27/2020 Montana 2698:0.26 108:0.01 4.00 %\n",
"03/28/2020 Montana 3385:0.33 129:0.01 3.81 %\n",
"03/29/2020 Montana 4297:0.42 154:0.02 3.58 %\n",
"03/30/2020 Montana 4132:0.40 171:0.02 4.14 %\n",
"03/31/2020 Montana 4418:0.43 184:0.02 4.16 %\n",
"04/01/2020 Montana 4918:0.48 208:0.02 4.23 %\n",
"04/02/2020 Montana 5320:0.52 227:0.02 4.27 %\n",
"\n",
"\n",
"\n",
"Data for Nebraska which has a population of 1881503\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Nebraska 22:0.00 0:0.00 0.00 %\n",
"03/06/2020 Nebraska 22:0.00 0:0.00 0.00 %\n",
"03/07/2020 Nebraska 23:0.00 1:0.00 4.35 %\n",
"03/08/2020 Nebraska 23:0.00 1:0.00 4.35 %\n",
"03/09/2020 Nebraska 48:0.00 3:0.00 6.25 %\n",
"03/10/2020 Nebraska 66:0.00 3:0.00 4.55 %\n",
"03/11/2020 Nebraska 68:0.00 5:0.00 7.35 %\n",
"03/12/2020 Nebraska 123:0.01 10:0.00 8.13 %\n",
"03/13/2020 Nebraska 126:0.01 13:0.00 10.32%\n",
"03/14/2020 Nebraska 127:0.01 14:0.00 11.02%\n",
"03/15/2020 Nebraska 130:0.01 17:0.00 13.08%\n",
"03/16/2020 Nebraska 188:0.01 18:0.00 9.57 %\n",
"03/17/2020 Nebraska 227:0.01 21:0.00 9.25 %\n",
"03/18/2020 Nebraska 230:0.01 24:0.00 10.43%\n",
"03/19/2020 Nebraska 267:0.01 27:0.00 10.11%\n",
"03/20/2020 Nebraska 272:0.01 32:0.00 11.76%\n",
"03/21/2020 Nebraska 394:0.02 38:0.00 9.64 %\n",
"03/22/2020 Nebraska 404:0.02 48:0.00 11.88%\n",
"03/23/2020 Nebraska 406:0.02 50:0.00 12.32%\n",
"03/24/2020 Nebraska 1027:0.05 52:0.00 5.06 %\n",
"03/25/2020 Nebraska 1365:0.07 61:0.00 4.47 %\n",
"03/26/2020 Nebraska 1657:0.09 73:0.00 4.41 %\n",
"03/27/2020 Nebraska 1846:0.10 85:0.00 4.60 %\n",
"03/28/2020 Nebraska 2000:0.11 96:0.01 4.80 %\n",
"03/29/2020 Nebraska 2080:0.11 108:0.01 5.19 %\n",
"03/30/2020 Nebraska 2734:0.15 145:0.01 5.30 %\n",
"03/31/2020 Nebraska 3111:0.17 172:0.01 5.53 %\n",
"04/01/2020 Nebraska 3693:0.20 210:0.01 5.69 %\n",
"04/02/2020 Nebraska 4235:0.23 246:0.01 5.81 %\n",
"\n",
"\n",
"\n",
"Data for Nevada which has a population of 2839099\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Nevada 15:0.00 1:0.00 6.67 %\n",
"03/06/2020 Nevada 15:0.00 1:0.00 6.67 %\n",
"03/07/2020 Nevada 15:0.00 1:0.00 6.67 %\n",
"03/08/2020 Nevada 15:0.00 1:0.00 6.67 %\n",
"03/09/2020 Nevada 15:0.00 1:0.00 6.67 %\n",
"03/10/2020 Nevada 14:0.00 0:0.00 0.00 %\n",
"03/11/2020 Nevada 173:0.01 5:0.00 2.89 %\n",
"03/12/2020 Nevada 175:0.01 7:0.00 4.00 %\n",
"03/13/2020 Nevada 179:0.01 11:0.00 6.15 %\n",
"03/14/2020 Nevada 188:0.01 20:0.00 10.64%\n",
"03/15/2020 Nevada 353:0.01 21:0.00 5.95 %\n",
"03/16/2020 Nevada 213:0.01 45:0.00 21.13%\n",
"03/17/2020 Nevada 223:0.01 55:0.00 24.66%\n",
"03/18/2020 Nevada 223:0.01 55:0.00 24.66%\n",
"03/19/2020 Nevada 1721:0.06 95:0.00 5.52 %\n",
"03/20/2020 Nevada 2098:0.07 109:0.00 5.20 %\n",
"03/21/2020 Nevada 2508:0.09 124:0.00 4.94 %\n",
"03/22/2020 Nevada 2638:0.09 190:0.01 7.20 %\n",
"03/23/2020 Nevada 3735:0.13 245:0.01 6.56 %\n",
"03/24/2020 Nevada 4232:0.15 278:0.01 6.57 %\n",
"03/25/2020 Nevada 4572:0.16 321:0.01 7.02 %\n",
"03/26/2020 Nevada 5117:0.18 420:0.01 8.21 %\n",
"03/27/2020 Nevada 6696:0.24 535:0.02 7.99 %\n",
"03/28/2020 Nevada 8522:0.30 621:0.02 7.29 %\n",
"03/29/2020 Nevada 9150:0.32 738:0.03 8.07 %\n",
"03/30/2020 Nevada 11215:0.40 1008:0.04 8.99 %\n",
"03/31/2020 Nevada 11794:0.42 1113:0.04 9.44 %\n",
"04/01/2020 Nevada 12798:0.45 1279:0.05 9.99 %\n",
"04/02/2020 Nevada 14046:0.49 1458:0.05 10.38%\n",
"\n",
"\n",
"\n",
"Data for New Hampshire which has a population of 1326813\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 New Hampshire 19:0.00 2:0.00 10.53%\n",
"03/05/2020 New Hampshire 22:0.00 2:0.00 9.09 %\n",
"03/06/2020 New Hampshire 25:0.00 2:0.00 8.00 %\n",
"03/07/2020 New Hampshire 25:0.00 2:0.00 8.00 %\n",
"03/08/2020 New Hampshire 47:0.00 4:0.00 8.51 %\n",
"03/09/2020 New Hampshire 47:0.00 4:0.00 8.51 %\n",
"03/10/2020 New Hampshire 47:0.00 4:0.00 8.51 %\n",
"03/11/2020 New Hampshire 47:0.00 4:0.00 8.51 %\n",
"03/12/2020 New Hampshire 121:0.01 6:0.00 4.96 %\n",
"03/13/2020 New Hampshire 121:0.01 6:0.00 4.96 %\n",
"03/14/2020 New Hampshire 250:0.02 7:0.00 2.80 %\n",
"03/15/2020 New Hampshire 379:0.03 13:0.00 3.43 %\n",
"03/16/2020 New Hampshire 379:0.03 13:0.00 3.43 %\n",
"03/17/2020 New Hampshire 567:0.04 17:0.00 3.00 %\n",
"03/18/2020 New Hampshire 747:0.06 26:0.00 3.48 %\n",
"03/19/2020 New Hampshire 891:0.07 39:0.00 4.38 %\n",
"03/20/2020 New Hampshire 1420:0.11 44:0.00 3.10 %\n",
"03/21/2020 New Hampshire 1970:0.15 55:0.00 2.79 %\n",
"03/22/2020 New Hampshire 2212:0.17 65:0.00 2.94 %\n",
"03/23/2020 New Hampshire 2341:0.18 78:0.01 3.33 %\n",
"03/24/2020 New Hampshire 2417:0.18 101:0.01 4.18 %\n",
"03/25/2020 New Hampshire 3268:0.25 108:0.01 3.30 %\n",
"03/26/2020 New Hampshire 3850:0.29 137:0.01 3.56 %\n",
"03/27/2020 New Hampshire 4145:0.31 158:0.01 3.81 %\n",
"03/28/2020 New Hampshire 4139:0.31 187:0.01 4.52 %\n",
"03/29/2020 New Hampshire 5023:0.38 214:0.02 4.26 %\n",
"03/30/2020 New Hampshire 5844:0.44 314:0.02 5.37 %\n",
"03/31/2020 New Hampshire 5792:0.44 314:0.02 5.42 %\n",
"04/01/2020 New Hampshire 6497:0.49 415:0.03 6.39 %\n",
"04/02/2020 New Hampshire 6619:0.50 415:0.03 6.27 %\n",
"\n",
"\n",
"\n",
"Data for New Jersey which has a population of 8938175\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 New Jersey 1:0.00 1:0.00 100.00%\n",
"03/06/2020 New Jersey 1:0.00 1:0.00 100.00%\n",
"03/07/2020 New Jersey 5:0.00 4:0.00 80.00%\n",
"03/08/2020 New Jersey 37:0.00 6:0.00 16.22%\n",
"03/09/2020 New Jersey 60:0.00 11:0.00 18.33%\n",
"03/10/2020 New Jersey 79:0.00 15:0.00 18.99%\n",
"03/11/2020 New Jersey 101:0.00 24:0.00 23.76%\n",
"03/12/2020 New Jersey 124:0.00 30:0.00 24.19%\n",
"03/13/2020 New Jersey 227:0.00 50:0.00 22.03%\n",
"03/14/2020 New Jersey 227:0.00 50:0.00 22.03%\n",
"03/15/2020 New Jersey 252:0.00 98:0.00 38.89%\n",
"03/16/2020 New Jersey 318:0.00 178:0.00 55.97%\n",
"03/17/2020 New Jersey 485:0.01 267:0.00 55.05%\n",
"03/18/2020 New Jersey 638:0.01 427:0.00 66.93%\n",
"03/19/2020 New Jersey 1026:0.01 742:0.01 72.32%\n",
"03/20/2020 New Jersey 1240:0.01 890:0.01 71.77%\n",
"03/21/2020 New Jersey 1661:0.02 1327:0.01 79.89%\n",
"03/22/2020 New Jersey 2290:0.03 1914:0.02 83.58%\n",
"03/23/2020 New Jersey 3297:0.04 2844:0.03 86.26%\n",
"03/24/2020 New Jersey 12045:0.13 3675:0.04 30.51%\n",
"03/25/2020 New Jersey 14854:0.17 4402:0.05 29.64%\n",
"03/26/2020 New Jersey 20537:0.23 6876:0.08 33.48%\n",
"03/27/2020 New Jersey 25372:0.28 8825:0.10 34.78%\n",
"03/28/2020 New Jersey 30510:0.34 11124:0.12 36.46%\n",
"03/29/2020 New Jersey 35602:0.40 13386:0.15 37.60%\n",
"03/30/2020 New Jersey 41860:0.47 16636:0.19 39.74%\n",
"03/31/2020 New Jersey 45773:0.51 18696:0.21 40.85%\n",
"04/01/2020 New Jersey 52642:0.59 22255:0.25 42.28%\n",
"04/02/2020 New Jersey 59110:0.66 25590:0.29 43.29%\n",
"\n",
"\n",
"\n",
"Data for New Mexico which has a population of 2085572\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 New Mexico 16:0.00 0:0.00 0.00 %\n",
"03/07/2020 New Mexico 48:0.00 0:0.00 0.00 %\n",
"03/08/2020 New Mexico 48:0.00 0:0.00 0.00 %\n",
"03/09/2020 New Mexico 57:0.00 0:0.00 0.00 %\n",
"03/10/2020 New Mexico 69:0.00 0:0.00 0.00 %\n",
"03/11/2020 New Mexico 90:0.00 3:0.00 3.33 %\n",
"03/12/2020 New Mexico 160:0.01 5:0.00 3.12 %\n",
"03/13/2020 New Mexico 200:0.01 10:0.00 5.00 %\n",
"03/14/2020 New Mexico 247:0.01 10:0.00 4.05 %\n",
"03/15/2020 New Mexico 495:0.02 13:0.00 2.63 %\n",
"03/16/2020 New Mexico 583:0.03 17:0.00 2.92 %\n",
"03/17/2020 New Mexico 1272:0.06 23:0.00 1.81 %\n",
"03/18/2020 New Mexico 2354:0.11 28:0.00 1.19 %\n",
"03/19/2020 New Mexico 2797:0.13 35:0.00 1.25 %\n",
"03/20/2020 New Mexico 3814:0.18 43:0.00 1.13 %\n",
"03/21/2020 New Mexico 3828:0.18 57:0.00 1.49 %\n",
"03/22/2020 New Mexico 4779:0.23 57:0.00 1.19 %\n",
"03/23/2020 New Mexico 5386:0.26 65:0.00 1.21 %\n",
"03/24/2020 New Mexico 5973:0.29 83:0.00 1.39 %\n",
"03/25/2020 New Mexico 6842:0.33 100:0.00 1.46 %\n",
"03/26/2020 New Mexico 7793:0.37 112:0.01 1.44 %\n",
"03/27/2020 New Mexico 8513:0.41 136:0.01 1.60 %\n",
"03/28/2020 New Mexico 9387:0.45 191:0.01 2.03 %\n",
"03/29/2020 New Mexico 11006:0.53 237:0.01 2.15 %\n",
"03/30/2020 New Mexico 11179:0.54 237:0.01 2.12 %\n",
"03/31/2020 New Mexico 12527:0.60 281:0.01 2.24 %\n",
"04/01/2020 New Mexico 13240:0.63 315:0.02 2.38 %\n",
"04/02/2020 New Mexico 14011:0.67 363:0.02 2.59 %\n",
"\n",
"\n",
"\n",
"Data for New York which has a population of 19746227\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 New York 78:0.00 6:0.00 7.69 %\n",
"03/05/2020 New York 122:0.00 22:0.00 18.03%\n",
"03/06/2020 New York 361:0.00 33:0.00 9.14 %\n",
"03/07/2020 New York 404:0.00 76:0.00 18.81%\n",
"03/08/2020 New York 197:0.00 105:0.00 53.30%\n",
"03/09/2020 New York 234:0.00 142:0.00 60.68%\n",
"03/10/2020 New York 265:0.00 173:0.00 65.28%\n",
"03/11/2020 New York 308:0.00 216:0.00 70.13%\n",
"03/12/2020 New York 308:0.00 216:0.00 70.13%\n",
"03/13/2020 New York 3200:0.02 421:0.00 13.16%\n",
"03/14/2020 New York 3303:0.02 524:0.00 15.86%\n",
"03/15/2020 New York 5272:0.03 729:0.00 13.83%\n",
"03/16/2020 New York 5493:0.03 950:0.00 17.29%\n",
"03/17/2020 New York 7206:0.04 1700:0.01 23.59%\n",
"03/18/2020 New York 14597:0.07 2382:0.01 16.32%\n",
"03/19/2020 New York 22284:0.11 4152:0.02 18.63%\n",
"03/20/2020 New York 32427:0.16 7102:0.04 21.90%\n",
"03/21/2020 New York 45437:0.23 10356:0.05 22.79%\n",
"03/22/2020 New York 61401:0.31 15168:0.08 24.70%\n",
"03/23/2020 New York 78289:0.40 20875:0.11 26.66%\n",
"03/24/2020 New York 91270:0.46 25665:0.13 28.12%\n",
"03/25/2020 New York 103479:0.52 30811:0.16 29.78%\n",
"03/26/2020 New York 122104:0.62 37258:0.19 30.51%\n",
"03/27/2020 New York 145753:0.74 44635:0.23 30.62%\n",
"03/28/2020 New York 155934:0.79 52318:0.26 33.55%\n",
"03/29/2020 New York 172360:0.87 59513:0.30 34.53%\n",
"03/30/2020 New York 186468:0.94 66497:0.34 35.66%\n",
"03/31/2020 New York 205186:1.04 75795:0.38 36.94%\n",
"04/01/2020 New York 220880:1.12 83712:0.42 37.90%\n",
"04/02/2020 New York 238965:1.21 92381:0.47 38.66%\n",
"\n",
"\n",
"\n",
"Data for North Carolina which has a population of 9943964\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 North Carolina 1:0.00 1:0.00 100.00%\n",
"03/05/2020 North Carolina 1:0.00 1:0.00 100.00%\n",
"03/06/2020 North Carolina 2:0.00 2:0.00 100.00%\n",
"03/07/2020 North Carolina 2:0.00 2:0.00 100.00%\n",
"03/08/2020 North Carolina 2:0.00 2:0.00 100.00%\n",
"03/09/2020 North Carolina 2:0.00 2:0.00 100.00%\n",
"03/10/2020 North Carolina 7:0.00 7:0.00 100.00%\n",
"03/11/2020 North Carolina 7:0.00 7:0.00 100.00%\n",
"03/12/2020 North Carolina 72:0.00 12:0.00 16.67%\n",
"03/13/2020 North Carolina 101:0.00 15:0.00 14.85%\n",
"03/14/2020 North Carolina 160:0.00 23:0.00 14.37%\n",
"03/15/2020 North Carolina 410:0.00 32:0.00 7.80 %\n",
"03/16/2020 North Carolina 480:0.00 33:0.00 6.88 %\n",
"03/17/2020 North Carolina 514:0.01 40:0.00 7.78 %\n",
"03/18/2020 North Carolina 1850:0.02 63:0.00 3.41 %\n",
"03/19/2020 North Carolina 2505:0.03 97:0.00 3.87 %\n",
"03/20/2020 North Carolina 3233:0.03 137:0.00 4.24 %\n",
"03/21/2020 North Carolina 5276:0.05 184:0.00 3.49 %\n",
"03/22/2020 North Carolina 6438:0.06 255:0.00 3.96 %\n",
"03/23/2020 North Carolina 8438:0.08 297:0.00 3.52 %\n",
"03/24/2020 North Carolina 8539:0.09 398:0.00 4.66 %\n",
"03/25/2020 North Carolina 10489:0.11 504:0.01 4.81 %\n",
"03/26/2020 North Carolina 12910:0.13 636:0.01 4.93 %\n",
"03/27/2020 North Carolina 15136:0.15 763:0.01 5.04 %\n",
"03/28/2020 North Carolina 17527:0.18 935:0.01 5.33 %\n",
"03/29/2020 North Carolina 18945:0.19 1040:0.01 5.49 %\n",
"03/30/2020 North Carolina 20864:0.21 1307:0.01 6.26 %\n",
"03/31/2020 North Carolina 23106:0.23 1498:0.02 6.48 %\n",
"04/01/2020 North Carolina 26243:0.26 1584:0.02 6.04 %\n",
"04/02/2020 North Carolina 28679:0.29 1857:0.02 6.48 %\n",
"\n",
"\n",
"\n",
"Data for North Dakota which has a population of 739482\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 North Dakota 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 North Dakota 0:0.00 0:0.00 0.00 %\n",
"03/09/2020 North Dakota 0:0.00 0:0.00 0.00 %\n",
"03/10/2020 North Dakota 8:0.00 0:0.00 0.00 %\n",
"03/11/2020 North Dakota 13:0.00 0:0.00 0.00 %\n",
"03/12/2020 North Dakota 27:0.00 1:0.00 3.70 %\n",
"03/13/2020 North Dakota 52:0.01 1:0.00 1.92 %\n",
"03/14/2020 North Dakota 69:0.01 1:0.00 1.45 %\n",
"03/15/2020 North Dakota 100:0.01 1:0.00 1.00 %\n",
"03/16/2020 North Dakota 124:0.02 1:0.00 0.81 %\n",
"03/17/2020 North Dakota 223:0.03 3:0.00 1.35 %\n",
"03/18/2020 North Dakota 274:0.04 6:0.00 2.19 %\n",
"03/19/2020 North Dakota 508:0.07 15:0.00 2.95 %\n",
"03/20/2020 North Dakota 820:0.11 20:0.00 2.44 %\n",
"03/21/2020 North Dakota 1169:0.16 28:0.00 2.40 %\n",
"03/22/2020 North Dakota 1288:0.17 28:0.00 2.17 %\n",
"03/23/2020 North Dakota 1383:0.19 30:0.00 2.17 %\n",
"03/24/2020 North Dakota 1488:0.20 34:0.00 2.28 %\n",
"03/25/2020 North Dakota 1773:0.24 39:0.01 2.20 %\n",
"03/26/2020 North Dakota 2091:0.28 52:0.01 2.49 %\n",
"03/27/2020 North Dakota 2492:0.34 65:0.01 2.61 %\n",
"03/28/2020 North Dakota 2892:0.39 83:0.01 2.87 %\n",
"03/29/2020 North Dakota 3453:0.47 98:0.01 2.84 %\n",
"03/30/2020 North Dakota 3837:0.52 109:0.01 2.84 %\n",
"03/31/2020 North Dakota 4257:0.58 126:0.02 2.96 %\n",
"04/01/2020 North Dakota 4493:0.61 142:0.02 3.16 %\n",
"04/02/2020 North Dakota 4980:0.67 159:0.02 3.19 %\n",
"\n",
"\n",
"\n",
"Skipping unknown population Northern Mariana Islands\n",
"Data for Ohio which has a population of 11594163\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"03/05/2020 Ohio 10:0.00 0:0.00 0.00 %\n",
"03/06/2020 Ohio 10:0.00 0:0.00 0.00 %\n",
"03/07/2020 Ohio 14:0.00 0:0.00 0.00 %\n",
"03/08/2020 Ohio 14:0.00 0:0.00 0.00 %\n",
"03/09/2020 Ohio 19:0.00 3:0.00 15.79%\n",
"03/10/2020 Ohio 32:0.00 3:0.00 9.38 %\n",
"03/11/2020 Ohio 49:0.00 4:0.00 8.16 %\n",
"03/12/2020 Ohio 87:0.00 5:0.00 5.75 %\n",
"03/13/2020 Ohio 222:0.00 13:0.00 5.86 %\n",
"03/14/2020 Ohio 222:0.00 13:0.00 5.86 %\n",
"03/15/2020 Ohio 525:0.00 36:0.00 6.86 %\n",
"03/16/2020 Ohio 551:0.00 50:0.00 9.07 %\n",
"03/17/2020 Ohio 207:0.00 67:0.00 32.37%\n",
"03/18/2020 Ohio 228:0.00 88:0.00 38.60%\n",
"03/19/2020 Ohio 259:0.00 119:0.00 45.95%\n",
"03/20/2020 Ohio 309:0.00 169:0.00 54.69%\n",
"03/21/2020 Ohio 387:0.00 247:0.00 63.82%\n",
"03/22/2020 Ohio 491:0.00 351:0.00 71.49%\n",
"03/23/2020 Ohio 582:0.01 442:0.00 75.95%\n",
"03/24/2020 Ohio 704:0.01 564:0.00 80.11%\n",
"03/25/2020 Ohio 14764:0.13 704:0.01 4.77 %\n",
"03/26/2020 Ohio 17316:0.15 867:0.01 5.01 %\n",
"03/27/2020 Ohio 20149:0.17 1137:0.01 5.64 %\n",
"03/28/2020 Ohio 20418:0.18 1406:0.01 6.89 %\n",
"03/29/2020 Ohio 20665:0.18 1653:0.01 8.00 %\n",
"03/30/2020 Ohio 27275:0.24 1933:0.02 7.09 %\n",
"03/31/2020 Ohio 29191:0.25 2199:0.02 7.53 %\n",
"04/01/2020 Ohio 29539:0.25 2547:0.02 8.62 %\n",
"04/02/2020 Ohio 34918:0.30 2902:0.03 8.31 %\n",
"\n",
"\n",
"\n",
"Data for Oklahoma which has a population of 3878051\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Oklahoma 1:0.00 1:0.00 100.00%\n",
"03/08/2020 Oklahoma 11:0.00 1:0.00 9.09 %\n",
"03/09/2020 Oklahoma 19:0.00 1:0.00 5.26 %\n",
"03/10/2020 Oklahoma 28:0.00 2:0.00 7.14 %\n",
"03/11/2020 Oklahoma 28:0.00 2:0.00 7.14 %\n",
"03/12/2020 Oklahoma 43:0.00 3:0.00 6.98 %\n",
"03/13/2020 Oklahoma 76:0.00 3:0.00 3.95 %\n",
"03/14/2020 Oklahoma 77:0.00 4:0.00 5.19 %\n",
"03/15/2020 Oklahoma 139:0.00 9:0.00 6.47 %\n",
"03/16/2020 Oklahoma 213:0.01 10:0.00 4.69 %\n",
"03/17/2020 Oklahoma 346:0.01 17:0.00 4.91 %\n",
"03/18/2020 Oklahoma 517:0.01 29:0.00 5.61 %\n",
"03/19/2020 Oklahoma 760:0.02 44:0.00 5.79 %\n",
"03/20/2020 Oklahoma 961:0.02 49:0.00 5.10 %\n",
"03/21/2020 Oklahoma 757:0.02 53:0.00 7.00 %\n",
"03/22/2020 Oklahoma 838:0.02 67:0.00 8.00 %\n",
"03/23/2020 Oklahoma 877:0.02 81:0.00 9.24 %\n",
"03/24/2020 Oklahoma 841:0.02 106:0.00 12.60%\n",
"03/25/2020 Oklahoma 969:0.02 164:0.00 16.92%\n",
"03/26/2020 Oklahoma 1206:0.03 248:0.01 20.56%\n",
"03/27/2020 Oklahoma 1406:0.04 322:0.01 22.90%\n",
"03/28/2020 Oklahoma 1557:0.04 377:0.01 24.21%\n",
"03/29/2020 Oklahoma 1634:0.04 429:0.01 26.25%\n",
"03/30/2020 Oklahoma 1688:0.04 481:0.01 28.50%\n",
"03/31/2020 Oklahoma 1794:0.05 565:0.01 31.49%\n",
"04/01/2020 Oklahoma 1967:0.05 719:0.02 36.55%\n",
"04/02/2020 Oklahoma 2144:0.06 879:0.02 41.00%\n",
"\n",
"\n",
"\n",
"Data for Oregon which has a population of 3970239\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Oregon 50:0.00 3:0.00 6.00 %\n",
"03/05/2020 Oregon 61:0.00 3:0.00 4.92 %\n",
"03/06/2020 Oregon 95:0.00 3:0.00 3.16 %\n",
"03/07/2020 Oregon 124:0.00 7:0.00 5.65 %\n",
"03/08/2020 Oregon 167:0.00 14:0.00 8.38 %\n",
"03/09/2020 Oregon 231:0.01 14:0.00 6.06 %\n",
"03/10/2020 Oregon 295:0.01 15:0.00 5.08 %\n",
"03/11/2020 Oregon 367:0.01 19:0.00 5.18 %\n",
"03/12/2020 Oregon 367:0.01 19:0.00 5.18 %\n",
"03/13/2020 Oregon 524:0.01 30:0.00 5.73 %\n",
"03/14/2020 Oregon 524:0.01 30:0.00 5.73 %\n",
"03/15/2020 Oregon 681:0.02 36:0.00 5.29 %\n",
"03/16/2020 Oregon 800:0.02 39:0.00 4.88 %\n",
"03/17/2020 Oregon 920:0.02 47:0.00 5.11 %\n",
"03/18/2020 Oregon 1554:0.04 75:0.00 4.83 %\n",
"03/19/2020 Oregon 1854:0.05 88:0.00 4.75 %\n",
"03/20/2020 Oregon 2550:0.06 114:0.00 4.47 %\n",
"03/21/2020 Oregon 2550:0.06 114:0.00 4.47 %\n",
"03/22/2020 Oregon 3025:0.08 161:0.00 5.32 %\n",
"03/23/2020 Oregon 3840:0.10 191:0.00 4.97 %\n",
"03/24/2020 Oregon 4559:0.11 209:0.01 4.58 %\n",
"03/25/2020 Oregon 4559:0.11 209:0.01 4.58 %\n",
"03/26/2020 Oregon 7280:0.18 327:0.01 4.49 %\n",
"03/27/2020 Oregon 8924:0.22 414:0.01 4.64 %\n",
"03/28/2020 Oregon 10172:0.26 479:0.01 4.71 %\n",
"03/29/2020 Oregon 11426:0.29 548:0.01 4.80 %\n",
"03/30/2020 Oregon 12883:0.32 606:0.02 4.70 %\n",
"03/31/2020 Oregon 13826:0.35 690:0.02 4.99 %\n",
"04/01/2020 Oregon 13826:0.35 690:0.02 4.99 %\n",
"04/02/2020 Oregon 14868:0.37 736:0.02 4.95 %\n",
"\n",
"\n",
"\n",
"Skipping unknown population Palau\n",
"Data for Pennsylvania which has a population of 12787209\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Pennsylvania 2:0.00 2:0.00 100.00%\n",
"03/07/2020 Pennsylvania 2:0.00 2:0.00 100.00%\n",
"03/08/2020 Pennsylvania 4:0.00 4:0.00 100.00%\n",
"03/09/2020 Pennsylvania 7:0.00 7:0.00 100.00%\n",
"03/10/2020 Pennsylvania 12:0.00 12:0.00 100.00%\n",
"03/11/2020 Pennsylvania 157:0.00 15:0.00 9.55 %\n",
"03/12/2020 Pennsylvania 219:0.00 22:0.00 10.05%\n",
"03/13/2020 Pennsylvania 303:0.00 33:0.00 10.89%\n",
"03/14/2020 Pennsylvania 402:0.00 47:0.00 11.69%\n",
"03/15/2020 Pennsylvania 451:0.00 63:0.00 13.97%\n",
"03/16/2020 Pennsylvania 746:0.01 76:0.00 10.19%\n",
"03/17/2020 Pennsylvania 975:0.01 96:0.00 9.85 %\n",
"03/18/2020 Pennsylvania 1320:0.01 133:0.00 10.08%\n",
"03/19/2020 Pennsylvania 1793:0.01 185:0.00 10.32%\n",
"03/20/2020 Pennsylvania 2842:0.02 268:0.00 9.43 %\n",
"03/21/2020 Pennsylvania 4137:0.03 371:0.00 8.97 %\n",
"03/22/2020 Pennsylvania 5443:0.04 479:0.00 8.80 %\n",
"03/23/2020 Pennsylvania 7239:0.06 644:0.01 8.90 %\n",
"03/24/2020 Pennsylvania 9494:0.07 851:0.01 8.96 %\n",
"03/25/2020 Pennsylvania 12320:0.10 1127:0.01 9.15 %\n",
"03/26/2020 Pennsylvania 18128:0.14 1687:0.01 9.31 %\n",
"03/27/2020 Pennsylvania 23234:0.18 2218:0.02 9.55 %\n",
"03/28/2020 Pennsylvania 28005:0.22 2751:0.02 9.82 %\n",
"03/29/2020 Pennsylvania 33455:0.26 3394:0.03 10.14%\n",
"03/30/2020 Pennsylvania 37864:0.30 4087:0.03 10.79%\n",
"03/31/2020 Pennsylvania 42488:0.33 4843:0.04 11.40%\n",
"04/01/2020 Pennsylvania 48232:0.38 5805:0.05 12.04%\n",
"04/02/2020 Pennsylvania 54714:0.43 7016:0.05 12.82%\n",
"\n",
"\n",
"\n",
"Skipping unknown population Puerto Rico\n",
"Data for Rhode Island which has a population of 1055173\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Rhode Island 2:0.00 2:0.00 100.00%\n",
"03/08/2020 Rhode Island 45:0.00 3:0.00 6.67 %\n",
"03/09/2020 Rhode Island 62:0.01 3:0.00 4.84 %\n",
"03/10/2020 Rhode Island 62:0.01 3:0.00 4.84 %\n",
"03/11/2020 Rhode Island 87:0.01 5:0.00 5.75 %\n",
"03/12/2020 Rhode Island 107:0.01 5:0.00 4.67 %\n",
"03/13/2020 Rhode Island 185:0.02 14:0.00 7.57 %\n",
"03/14/2020 Rhode Island 275:0.03 20:0.00 7.27 %\n",
"03/15/2020 Rhode Island 275:0.03 20:0.00 7.27 %\n",
"03/16/2020 Rhode Island 478:0.05 21:0.00 4.39 %\n",
"03/17/2020 Rhode Island 478:0.05 21:0.00 4.39 %\n",
"03/18/2020 Rhode Island 907:0.09 33:0.00 3.64 %\n",
"03/19/2020 Rhode Island 907:0.09 33:0.00 3.64 %\n",
"03/20/2020 Rhode Island 848:0.08 54:0.01 6.37 %\n",
"03/21/2020 Rhode Island 1218:0.12 66:0.01 5.42 %\n",
"03/22/2020 Rhode Island 1231:0.12 83:0.01 6.74 %\n",
"03/23/2020 Rhode Island 1254:0.12 106:0.01 8.45 %\n",
"03/24/2020 Rhode Island 1303:0.12 106:0.01 8.14 %\n",
"03/25/2020 Rhode Island 1463:0.14 124:0.01 8.48 %\n",
"03/26/2020 Rhode Island 1685:0.16 165:0.02 9.79 %\n",
"03/27/2020 Rhode Island 1669:0.16 165:0.02 9.89 %\n",
"03/28/2020 Rhode Island 2647:0.25 203:0.02 7.67 %\n",
"03/29/2020 Rhode Island 2835:0.27 294:0.03 10.37%\n",
"03/30/2020 Rhode Island 3595:0.34 408:0.04 11.35%\n",
"03/31/2020 Rhode Island 3964:0.38 488:0.05 12.31%\n",
"04/01/2020 Rhode Island 4397:0.42 566:0.05 12.87%\n",
"04/02/2020 Rhode Island 5069:0.48 657:0.06 12.96%\n",
"\n",
"\n",
"\n",
"Data for South Carolina which has a population of 4832482\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 South Carolina 5:0.00 0:0.00 0.00 %\n",
"03/05/2020 South Carolina 5:0.00 0:0.00 0.00 %\n",
"03/06/2020 South Carolina 5:0.00 0:0.00 0.00 %\n",
"03/07/2020 South Carolina 10:0.00 2:0.00 20.00%\n",
"03/08/2020 South Carolina 10:0.00 2:0.00 20.00%\n",
"03/09/2020 South Carolina 31:0.00 7:0.00 22.58%\n",
"03/10/2020 South Carolina 31:0.00 7:0.00 22.58%\n",
"03/11/2020 South Carolina 41:0.00 9:0.00 21.95%\n",
"03/12/2020 South Carolina 58:0.00 10:0.00 17.24%\n",
"03/13/2020 South Carolina 87:0.00 12:0.00 13.79%\n",
"03/14/2020 South Carolina 123:0.00 13:0.00 10.57%\n",
"03/15/2020 South Carolina 173:0.00 19:0.00 10.98%\n",
"03/16/2020 South Carolina 263:0.01 28:0.00 10.65%\n",
"03/17/2020 South Carolina 344:0.01 33:0.00 9.59 %\n",
"03/18/2020 South Carolina 643:0.01 60:0.00 9.33 %\n",
"03/19/2020 South Carolina 643:0.01 60:0.00 9.33 %\n",
"03/20/2020 South Carolina 914:0.02 81:0.00 8.86 %\n",
"03/21/2020 South Carolina 1407:0.03 152:0.00 10.80%\n",
"03/22/2020 South Carolina 1661:0.03 195:0.00 11.74%\n",
"03/23/2020 South Carolina 1765:0.04 299:0.01 16.94%\n",
"03/24/2020 South Carolina 2310:0.05 298:0.01 12.90%\n",
"03/25/2020 South Carolina 2727:0.06 424:0.01 15.55%\n",
"03/26/2020 South Carolina 2763:0.06 456:0.01 16.50%\n",
"03/27/2020 South Carolina 2763:0.06 456:0.01 16.50%\n",
"03/28/2020 South Carolina 2947:0.06 539:0.01 18.29%\n",
"03/29/2020 South Carolina 3789:0.08 774:0.02 20.43%\n",
"03/30/2020 South Carolina 5085:0.11 925:0.02 18.19%\n",
"03/31/2020 South Carolina 5699:0.12 1083:0.02 19.00%\n",
"04/01/2020 South Carolina 6326:0.13 1293:0.03 20.44%\n",
"04/02/2020 South Carolina 6995:0.14 1554:0.03 22.22%\n",
"\n",
"\n",
"\n",
"Data for South Dakota which has a population of 853175\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 South Dakota 5:0.00 0:0.00 0.00 %\n",
"03/08/2020 South Dakota 5:0.00 0:0.00 0.00 %\n",
"03/09/2020 South Dakota 5:0.00 0:0.00 0.00 %\n",
"03/10/2020 South Dakota 11:0.00 0:0.00 0.00 %\n",
"03/11/2020 South Dakota 20:0.00 5:0.00 25.00%\n",
"03/12/2020 South Dakota 46:0.01 8:0.00 17.39%\n",
"03/13/2020 South Dakota 93:0.01 9:0.00 9.68 %\n",
"03/14/2020 South Dakota 194:0.02 9:0.00 4.64 %\n",
"03/15/2020 South Dakota 342:0.04 9:0.00 2.63 %\n",
"03/16/2020 South Dakota 504:0.06 10:0.00 1.98 %\n",
"03/17/2020 South Dakota 597:0.07 11:0.00 1.84 %\n",
"03/18/2020 South Dakota 912:0.11 11:0.00 1.21 %\n",
"03/19/2020 South Dakota 947:0.11 11:0.00 1.16 %\n",
"03/20/2020 South Dakota 947:0.11 14:0.00 1.48 %\n",
"03/21/2020 South Dakota 973:0.11 14:0.00 1.44 %\n",
"03/22/2020 South Dakota 1038:0.12 21:0.00 2.02 %\n",
"03/23/2020 South Dakota 1055:0.12 28:0.00 2.65 %\n",
"03/24/2020 South Dakota 1088:0.13 30:0.00 2.76 %\n",
"03/25/2020 South Dakota 1128:0.13 41:0.00 3.63 %\n",
"03/26/2020 South Dakota 2144:0.25 46:0.01 2.15 %\n",
"03/27/2020 South Dakota 2465:0.29 58:0.01 2.35 %\n",
"03/28/2020 South Dakota 2660:0.31 68:0.01 2.56 %\n",
"03/29/2020 South Dakota 3218:0.38 90:0.01 2.80 %\n",
"03/30/2020 South Dakota 3579:0.42 101:0.01 2.82 %\n",
"03/31/2020 South Dakota 3717:0.44 108:0.01 2.91 %\n",
"04/01/2020 South Dakota 4032:0.47 129:0.02 3.20 %\n",
"04/02/2020 South Dakota 4382:0.51 165:0.02 3.77 %\n",
"\n",
"\n",
"\n",
"Data for Tennessee which has a population of 6549352\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Tennessee 1:0.00 1:0.00 100.00%\n",
"03/06/2020 Tennessee 1:0.00 1:0.00 100.00%\n",
"03/07/2020 Tennessee 1:0.00 1:0.00 100.00%\n",
"03/08/2020 Tennessee 3:0.00 3:0.00 100.00%\n",
"03/09/2020 Tennessee 3:0.00 3:0.00 100.00%\n",
"03/10/2020 Tennessee 7:0.00 7:0.00 100.00%\n",
"03/11/2020 Tennessee 57:0.00 7:0.00 12.28%\n",
"03/12/2020 Tennessee 97:0.00 18:0.00 18.56%\n",
"03/13/2020 Tennessee 142:0.00 26:0.00 18.31%\n",
"03/14/2020 Tennessee 162:0.00 32:0.00 19.75%\n",
"03/15/2020 Tennessee 196:0.00 39:0.00 19.90%\n",
"03/16/2020 Tennessee 322:0.00 52:0.00 16.15%\n",
"03/17/2020 Tennessee 403:0.01 73:0.00 18.11%\n",
"03/18/2020 Tennessee 447:0.01 98:0.00 21.92%\n",
"03/19/2020 Tennessee 503:0.01 154:0.00 30.62%\n",
"03/20/2020 Tennessee 791:0.01 228:0.00 28.82%\n",
"03/21/2020 Tennessee 3643:0.06 371:0.01 10.18%\n",
"03/22/2020 Tennessee 3777:0.06 505:0.01 13.37%\n",
"03/23/2020 Tennessee 3887:0.06 615:0.01 15.82%\n",
"03/24/2020 Tennessee 11184:0.17 667:0.01 5.96 %\n",
"03/25/2020 Tennessee 11796:0.18 784:0.01 6.65 %\n",
"03/26/2020 Tennessee 14909:0.23 957:0.01 6.42 %\n",
"03/27/2020 Tennessee 16091:0.25 1203:0.02 7.48 %\n",
"03/28/2020 Tennessee 18338:0.28 1373:0.02 7.49 %\n",
"03/29/2020 Tennessee 20574:0.31 1537:0.02 7.47 %\n",
"03/30/2020 Tennessee 23304:0.36 1834:0.03 7.87 %\n",
"03/31/2020 Tennessee 27360:0.42 2239:0.03 8.18 %\n",
"04/01/2020 Tennessee 32452:0.50 2683:0.04 8.27 %\n",
"04/02/2020 Tennessee 34611:0.53 2845:0.04 8.22 %\n",
"\n",
"\n",
"\n",
"Data for Texas which has a population of 26956958\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Texas 1:0.00 1:0.00 100.00%\n",
"03/05/2020 Texas 1:0.00 1:0.00 100.00%\n",
"03/06/2020 Texas 5:0.00 5:0.00 100.00%\n",
"03/07/2020 Texas 8:0.00 8:0.00 100.00%\n",
"03/08/2020 Texas 8:0.00 8:0.00 100.00%\n",
"03/09/2020 Texas 12:0.00 12:0.00 100.00%\n",
"03/10/2020 Texas 13:0.00 13:0.00 100.00%\n",
"03/11/2020 Texas 21:0.00 21:0.00 100.00%\n",
"03/12/2020 Texas 23:0.00 23:0.00 100.00%\n",
"03/13/2020 Texas 39:0.00 39:0.00 100.00%\n",
"03/14/2020 Texas 51:0.00 51:0.00 100.00%\n",
"03/15/2020 Texas 56:0.00 56:0.00 100.00%\n",
"03/16/2020 Texas 57:0.00 57:0.00 100.00%\n",
"03/17/2020 Texas 1268:0.00 64:0.00 5.05 %\n",
"03/18/2020 Texas 1907:0.01 83:0.00 4.35 %\n",
"03/19/2020 Texas 2355:0.01 143:0.00 6.07 %\n",
"03/20/2020 Texas 5277:0.02 194:0.00 3.68 %\n",
"03/21/2020 Texas 6522:0.02 304:0.00 4.66 %\n",
"03/22/2020 Texas 8756:0.03 334:0.00 3.81 %\n",
"03/23/2020 Texas 10055:0.04 352:0.00 3.50 %\n",
"03/24/2020 Texas 11167:0.04 410:0.00 3.67 %\n",
"03/25/2020 Texas 13494:0.05 974:0.00 7.22 %\n",
"03/26/2020 Texas 21424:0.08 1396:0.01 6.52 %\n",
"03/27/2020 Texas 23666:0.09 1731:0.01 7.31 %\n",
"03/28/2020 Texas 25260:0.09 2052:0.01 8.12 %\n",
"03/29/2020 Texas 25760:0.10 2552:0.01 9.91 %\n",
"03/30/2020 Texas 35880:0.13 2877:0.01 8.02 %\n",
"03/31/2020 Texas 42992:0.16 3266:0.01 7.60 %\n",
"04/01/2020 Texas 47857:0.18 3997:0.01 8.35 %\n",
"04/02/2020 Texas 50679:0.19 4669:0.02 9.21 %\n",
"\n",
"\n",
"\n",
"Data for Utah which has a population of 2942902\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Utah 1:0.00 1:0.00 100.00%\n",
"03/08/2020 Utah 1:0.00 1:0.00 100.00%\n",
"03/09/2020 Utah 1:0.00 1:0.00 100.00%\n",
"03/10/2020 Utah 2:0.00 2:0.00 100.00%\n",
"03/11/2020 Utah 2:0.00 2:0.00 100.00%\n",
"03/12/2020 Utah 135:0.00 4:0.00 2.96 %\n",
"03/13/2020 Utah 137:0.00 6:0.00 4.38 %\n",
"03/14/2020 Utah 137:0.00 6:0.00 4.38 %\n",
"03/15/2020 Utah 159:0.01 28:0.00 17.61%\n",
"03/16/2020 Utah 170:0.01 39:0.00 22.94%\n",
"03/17/2020 Utah 182:0.01 51:0.00 28.02%\n",
"03/18/2020 Utah 194:0.01 63:0.00 32.47%\n",
"03/19/2020 Utah 1526:0.05 78:0.00 5.11 %\n",
"03/20/2020 Utah 2147:0.07 112:0.00 5.22 %\n",
"03/21/2020 Utah 2560:0.09 136:0.00 5.31 %\n",
"03/22/2020 Utah 3689:0.13 181:0.01 4.91 %\n",
"03/23/2020 Utah 5047:0.17 257:0.01 5.09 %\n",
"03/24/2020 Utah 5823:0.20 299:0.01 5.13 %\n",
"03/25/2020 Utah 6837:0.23 346:0.01 5.06 %\n",
"03/26/2020 Utah 7710:0.26 402:0.01 5.21 %\n",
"03/27/2020 Utah 9244:0.31 480:0.02 5.19 %\n",
"03/28/2020 Utah 11312:0.38 602:0.02 5.32 %\n",
"03/29/2020 Utah 13993:0.48 719:0.02 5.14 %\n",
"03/30/2020 Utah 16003:0.54 806:0.03 5.04 %\n",
"03/31/2020 Utah 18513:0.63 887:0.03 4.79 %\n",
"04/01/2020 Utah 21167:0.72 1012:0.03 4.78 %\n",
"04/02/2020 Utah 21065:0.72 1074:0.04 5.10 %\n",
"\n",
"\n",
"\n",
"Data for Vermont which has a population of 626562\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/06/2020 Vermont 8:0.00 0:0.00 0.00 %\n",
"03/07/2020 Vermont 16:0.00 0:0.00 0.00 %\n",
"03/08/2020 Vermont 29:0.00 1:0.00 3.45 %\n",
"03/09/2020 Vermont 35:0.01 1:0.00 2.86 %\n",
"03/10/2020 Vermont 41:0.01 1:0.00 2.44 %\n",
"03/11/2020 Vermont 63:0.01 1:0.00 1.59 %\n",
"03/12/2020 Vermont 99:0.02 2:0.00 2.02 %\n",
"03/13/2020 Vermont 144:0.02 2:0.00 1.39 %\n",
"03/14/2020 Vermont 231:0.04 4:0.00 1.73 %\n",
"03/15/2020 Vermont 352:0.06 4:0.00 1.14 %\n",
"03/16/2020 Vermont 429:0.07 8:0.00 1.86 %\n",
"03/17/2020 Vermont 505:0.08 10:0.00 1.98 %\n",
"03/18/2020 Vermont 611:0.10 19:0.00 3.11 %\n",
"03/19/2020 Vermont 667:0.11 22:0.00 3.30 %\n",
"03/20/2020 Vermont 808:0.13 29:0.00 3.59 %\n",
"03/21/2020 Vermont 808:0.13 29:0.00 3.59 %\n",
"03/22/2020 Vermont 1158:0.18 52:0.01 4.49 %\n",
"03/23/2020 Vermont 1181:0.19 75:0.01 6.35 %\n",
"03/24/2020 Vermont 1535:0.24 95:0.02 6.19 %\n",
"03/25/2020 Vermont 1712:0.27 123:0.02 7.18 %\n",
"03/26/2020 Vermont 2008:0.32 158:0.03 7.87 %\n",
"03/27/2020 Vermont 2261:0.36 184:0.03 8.14 %\n",
"03/28/2020 Vermont 2374:0.38 211:0.03 8.89 %\n",
"03/29/2020 Vermont 3701:0.59 235:0.04 6.35 %\n",
"03/30/2020 Vermont 3930:0.63 256:0.04 6.51 %\n",
"03/31/2020 Vermont 4250:0.68 293:0.05 6.89 %\n",
"04/01/2020 Vermont 4495:0.72 321:0.05 7.14 %\n",
"04/02/2020 Vermont 5049:0.81 338:0.05 6.69 %\n",
"\n",
"\n",
"\n",
"Skipping unknown population Virgin Islands\n",
"Data for Virginia which has a population of 8326289\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/05/2020 Virginia 21:0.00 0:0.00 0.00 %\n",
"03/06/2020 Virginia 31:0.00 0:0.00 0.00 %\n",
"03/07/2020 Virginia 38:0.00 0:0.00 0.00 %\n",
"03/08/2020 Virginia 44:0.00 2:0.00 4.55 %\n",
"03/09/2020 Virginia 50:0.00 3:0.00 6.00 %\n",
"03/10/2020 Virginia 61:0.00 8:0.00 13.11%\n",
"03/11/2020 Virginia 69:0.00 9:0.00 13.04%\n",
"03/12/2020 Virginia 134:0.00 17:0.00 12.69%\n",
"03/13/2020 Virginia 147:0.00 30:0.00 20.41%\n",
"03/14/2020 Virginia 147:0.00 30:0.00 20.41%\n",
"03/15/2020 Virginia 408:0.00 45:0.00 11.03%\n",
"03/16/2020 Virginia 489:0.01 51:0.00 10.43%\n",
"03/17/2020 Virginia 1028:0.01 67:0.00 6.52 %\n",
"03/18/2020 Virginia 1278:0.02 77:0.00 6.03 %\n",
"03/19/2020 Virginia 1923:0.02 94:0.00 4.89 %\n",
"03/20/2020 Virginia 2325:0.03 114:0.00 4.90 %\n",
"03/21/2020 Virginia 2790:0.03 152:0.00 5.45 %\n",
"03/22/2020 Virginia 3337:0.04 219:0.00 6.56 %\n",
"03/23/2020 Virginia 3697:0.04 254:0.00 6.87 %\n",
"03/24/2020 Virginia 4470:0.05 290:0.00 6.49 %\n",
"03/25/2020 Virginia 5370:0.06 391:0.00 7.28 %\n",
"03/26/2020 Virginia 6189:0.07 460:0.01 7.43 %\n",
"03/27/2020 Virginia 7337:0.09 604:0.01 8.23 %\n",
"03/28/2020 Virginia 9166:0.11 739:0.01 8.06 %\n",
"03/29/2020 Virginia 10609:0.13 890:0.01 8.39 %\n",
"03/30/2020 Virginia 12038:0.14 1020:0.01 8.47 %\n",
"03/31/2020 Virginia 13401:0.16 1250:0.02 9.33 %\n",
"04/01/2020 Virginia 15344:0.18 1484:0.02 9.67 %\n",
"04/02/2020 Virginia 17589:0.21 1706:0.02 9.70 %\n",
"\n",
"\n",
"\n",
"Data for Washington which has a population of 7061530\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Washington 39:0.00 39:0.00 100.00%\n",
"03/05/2020 Washington 70:0.00 70:0.00 100.00%\n",
"03/06/2020 Washington 449:0.01 79:0.00 17.59%\n",
"03/07/2020 Washington 538:0.01 102:0.00 18.96%\n",
"03/08/2020 Washington 802:0.01 102:0.00 12.72%\n",
"03/09/2020 Washington 1246:0.02 136:0.00 10.91%\n",
"03/10/2020 Washington 1272:0.02 162:0.00 12.74%\n",
"03/11/2020 Washington 2442:0.03 267:0.00 10.93%\n",
"03/12/2020 Washington 3374:0.05 337:0.00 9.99 %\n",
"03/13/2020 Washington 4807:0.07 457:0.01 9.51 %\n",
"03/14/2020 Washington 6569:0.09 568:0.01 8.65 %\n",
"03/15/2020 Washington 7764:0.11 642:0.01 8.27 %\n",
"03/16/2020 Washington 10220:0.14 769:0.01 7.52 %\n",
"03/17/2020 Washington 12486:0.18 904:0.01 7.24 %\n",
"03/18/2020 Washington 14129:0.20 1012:0.01 7.16 %\n",
"03/19/2020 Washington 17105:0.24 1187:0.02 6.94 %\n",
"03/20/2020 Washington 20712:0.29 1376:0.02 6.64 %\n",
"03/21/2020 Washington 23243:0.33 1524:0.02 6.56 %\n",
"03/22/2020 Washington 27121:0.38 1793:0.03 6.61 %\n",
"03/23/2020 Washington 30875:0.44 1996:0.03 6.46 %\n",
"03/24/2020 Washington 33933:0.48 2221:0.03 6.55 %\n",
"03/25/2020 Washington 34181:0.48 2469:0.03 7.22 %\n",
"03/26/2020 Washington 34292:0.49 2580:0.04 7.52 %\n",
"03/27/2020 Washington 46380:0.66 3207:0.05 6.91 %\n",
"03/28/2020 Washington 52738:0.75 3723:0.05 7.06 %\n",
"03/29/2020 Washington 59206:0.84 4310:0.06 7.28 %\n",
"03/30/2020 Washington 65462:0.93 4896:0.07 7.48 %\n",
"03/31/2020 Washington 65462:0.93 4896:0.07 7.48 %\n",
"04/01/2020 Washington 66200:0.94 5634:0.08 8.51 %\n",
"04/02/2020 Washington 74798:1.06 5984:0.08 8.00 %\n",
"\n",
"\n",
"\n",
"Data for West Virginia which has a population of 1850326\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"03/06/2020 West Virginia 5:0.00 0:0.00 0.00 %\n",
"03/07/2020 West Virginia 5:0.00 0:0.00 0.00 %\n",
"03/08/2020 West Virginia 5:0.00 0:0.00 0.00 %\n",
"03/09/2020 West Virginia 5:0.00 0:0.00 0.00 %\n",
"03/10/2020 West Virginia 5:0.00 0:0.00 0.00 %\n",
"03/11/2020 West Virginia 5:0.00 0:0.00 0.00 %\n",
"03/12/2020 West Virginia 8:0.00 0:0.00 0.00 %\n",
"03/13/2020 West Virginia 21:0.00 0:0.00 0.00 %\n",
"03/14/2020 West Virginia 31:0.00 0:0.00 0.00 %\n",
"03/15/2020 West Virginia 39:0.00 0:0.00 0.00 %\n",
"03/16/2020 West Virginia 84:0.00 0:0.00 0.00 %\n",
"03/17/2020 West Virginia 84:0.00 0:0.00 0.00 %\n",
"03/18/2020 West Virginia 137:0.01 1:0.00 0.73 %\n",
"03/19/2020 West Virginia 148:0.01 2:0.00 1.35 %\n",
"03/20/2020 West Virginia 239:0.01 7:0.00 2.93 %\n",
"03/21/2020 West Virginia 343:0.02 11:0.00 3.21 %\n",
"03/22/2020 West Virginia 398:0.02 12:0.00 3.02 %\n",
"03/23/2020 West Virginia 464:0.03 16:0.00 3.45 %\n",
"03/24/2020 West Virginia 630:0.03 20:0.00 3.17 %\n",
"03/25/2020 West Virginia 804:0.04 39:0.00 4.85 %\n",
"03/26/2020 West Virginia 1101:0.06 51:0.00 4.63 %\n",
"03/27/2020 West Virginia 1898:0.10 76:0.00 4.00 %\n",
"03/28/2020 West Virginia 2433:0.13 96:0.01 3.95 %\n",
"03/29/2020 West Virginia 2818:0.15 113:0.01 4.01 %\n",
"03/30/2020 West Virginia 3110:0.17 126:0.01 4.05 %\n",
"03/31/2020 West Virginia 4143:0.22 162:0.01 3.91 %\n",
"04/01/2020 West Virginia 4575:0.25 191:0.01 4.17 %\n",
"04/02/2020 West Virginia 5493:0.30 217:0.01 3.95 %\n",
"\n",
"\n",
"\n",
"Data for Wisconsin which has a population of 5757564\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/04/2020 Wisconsin 26:0.00 1:0.00 3.85 %\n",
"03/05/2020 Wisconsin 26:0.00 1:0.00 3.85 %\n",
"03/06/2020 Wisconsin 44:0.00 1:0.00 2.27 %\n",
"03/07/2020 Wisconsin 44:0.00 1:0.00 2.27 %\n",
"03/08/2020 Wisconsin 44:0.00 1:0.00 2.27 %\n",
"03/09/2020 Wisconsin 37:0.00 1:0.00 2.70 %\n",
"03/10/2020 Wisconsin 38:0.00 2:0.00 5.26 %\n",
"03/11/2020 Wisconsin 46:0.00 3:0.00 6.52 %\n",
"03/12/2020 Wisconsin 92:0.00 8:0.00 8.70 %\n",
"03/13/2020 Wisconsin 188:0.00 19:0.00 10.11%\n",
"03/14/2020 Wisconsin 188:0.00 19:0.00 10.11%\n",
"03/15/2020 Wisconsin 346:0.01 33:0.00 9.54 %\n",
"03/16/2020 Wisconsin 551:0.01 47:0.00 8.53 %\n",
"03/17/2020 Wisconsin 1110:0.02 72:0.00 6.49 %\n",
"03/18/2020 Wisconsin 1683:0.03 106:0.00 6.30 %\n",
"03/19/2020 Wisconsin 2347:0.04 155:0.00 6.60 %\n",
"03/20/2020 Wisconsin 3661:0.06 206:0.00 5.63 %\n",
"03/21/2020 Wisconsin 4909:0.09 281:0.00 5.72 %\n",
"03/22/2020 Wisconsin 6615:0.11 385:0.01 5.82 %\n",
"03/23/2020 Wisconsin 7466:0.13 416:0.01 5.57 %\n",
"03/24/2020 Wisconsin 8694:0.15 457:0.01 5.26 %\n",
"03/25/2020 Wisconsin 10674:0.19 585:0.01 5.48 %\n",
"03/26/2020 Wisconsin 12290:0.21 707:0.01 5.75 %\n",
"03/27/2020 Wisconsin 13982:0.24 842:0.01 6.02 %\n",
"03/28/2020 Wisconsin 16221:0.28 989:0.02 6.10 %\n",
"03/29/2020 Wisconsin 17662:0.31 1112:0.02 6.30 %\n",
"03/30/2020 Wisconsin 17077:0.30 1221:0.02 7.15 %\n",
"03/31/2020 Wisconsin 18726:0.33 1351:0.02 7.21 %\n",
"04/01/2020 Wisconsin 20369:0.35 1550:0.03 7.61 %\n",
"04/02/2020 Wisconsin 22047:0.38 1730:0.03 7.85 %\n",
"\n",
"\n",
"\n",
"Data for Wyoming which has a population of 584153\n",
"Date State #test:% POP Positive:% Pop %test that were positive\n",
"03/07/2020 Wyoming 0:0.00 0:0.00 0.00 %\n",
"03/08/2020 Wyoming 0:0.00 0:0.00 0.00 %\n",
"03/09/2020 Wyoming 0:0.00 0:0.00 0.00 %\n",
"03/10/2020 Wyoming 0:0.00 0:0.00 0.00 %\n",
"03/11/2020 Wyoming 0:0.00 0:0.00 0.00 %\n",
"03/12/2020 Wyoming 1:0.00 1:0.00 100.00%\n",
"03/13/2020 Wyoming 1:0.00 1:0.00 100.00%\n",
"03/14/2020 Wyoming 2:0.00 2:0.00 100.00%\n",
"03/15/2020 Wyoming 3:0.00 3:0.00 100.00%\n",
"03/16/2020 Wyoming 3:0.00 3:0.00 100.00%\n",
"03/17/2020 Wyoming 105:0.02 10:0.00 9.52 %\n",
"03/18/2020 Wyoming 193:0.03 15:0.00 7.77 %\n",
"03/19/2020 Wyoming 289:0.05 18:0.00 6.23 %\n",
"03/20/2020 Wyoming 350:0.06 19:0.00 5.43 %\n",
"03/21/2020 Wyoming 461:0.08 23:0.00 4.99 %\n",
"03/22/2020 Wyoming 462:0.08 24:0.00 5.19 %\n",
"03/23/2020 Wyoming 618:0.11 26:0.00 4.21 %\n",
"03/24/2020 Wyoming 739:0.13 29:0.00 3.92 %\n",
"03/25/2020 Wyoming 998:0.17 44:0.01 4.41 %\n",
"03/26/2020 Wyoming 1105:0.19 53:0.01 4.80 %\n",
"03/27/2020 Wyoming 1281:0.22 70:0.01 5.46 %\n",
"03/28/2020 Wyoming 1557:0.27 82:0.01 5.27 %\n",
"03/29/2020 Wyoming 1640:0.28 86:0.01 5.24 %\n",
"03/30/2020 Wyoming 1934:0.33 94:0.02 4.86 %\n",
"03/31/2020 Wyoming 2108:0.36 109:0.02 5.17 %\n",
"04/01/2020 Wyoming 2348:0.40 130:0.02 5.54 %\n",
"04/02/2020 Wyoming 2589:0.44 150:0.03 5.79 %\n",
"\n",
"\n",
"\n"
]
}
],
"source": [
"for tgt_state in state_abbreviations.keys(): \n",
" state_name = state_abbreviations.get(tgt_state)\n",
" state_population = int(population_data.get(state_name,0))\n",
" if state_population==0:\n",
" print(f'Skipping unknown population {state_name}')\n",
" continue\n",
" print(f\"Data for {state_name} which has a population of {state_population}\")\n",
" print(\"Date State #test:% POP Positive:% Pop %test that were positive\")\n",
" state_recs = {}\n",
" for each_rec in state_historical:\n",
" dstr = f'{str(each_rec.get(\"date\"))[4:6]}/{str(each_rec.get(\"date\"))[6:]}/{str(each_rec.get(\"date\"))[:4]}' \n",
" date = datetime.datetime.strptime(dstr, \"%m/%d/%Y\")\n",
" if each_rec.get(\"state\") == tgt_state:\n",
" positive = each_rec.get(\"positive\",0)\n",
" total = each_rec.get(\"total\",0)\n",
" state_recs[date] = (positive, total)\n",
" for dt in sorted(state_recs.keys()):\n",
" pos,tot = state_recs.get(dt)\n",
" dstring = dt.strftime('%m/%d/%Y')\n",
" pp = pos/state_population*100 if pos else 0.00\n",
" tp = tot/state_population*100 if tot else 0.00\n",
" posrate = pos/tot*100 if pos else 0.00\n",
" \n",
" print(f\"{dstring} {state_name: ^30} {tot:7}:{tp: <6.2f} {pos:7}:{pp: <6.2f} {posrate: <5.2f}%\")\n",
" #print(dt, pos,tot, f\"{tot/state_population:1.7f}\")\n",
" print(\"\\n\\n\")\n"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.9"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment