johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
76,709 rows where province_or_state = "Arkansas" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2626348 | 2626348 | 2021-01-10 | US | Arkansas | Fulton | 5049 | 973 | 37 | 0 | 936 | 36.38177105 | -91.81729127 | 2021-01-11 05:21:50 | Fulton, Arkansas, US |
2626349 | 2626349 | 2021-01-10 | US | Arkansas | Garland | 5051 | 6876 | 168 | 0 | 6708 | 34.57692074 | -93.14921604 | 2021-01-11 05:21:50 | Garland, Arkansas, US |
2626350 | 2626350 | 2021-01-10 | US | Arkansas | Grant | 5053 | 1195 | 16 | 0 | 1179 | 34.29017991 | -92.42320562 | 2021-01-11 05:21:50 | Grant, Arkansas, US |
2626351 | 2626351 | 2021-01-10 | US | Arkansas | Greene | 5055 | 4870 | 59 | 0 | 4811 | 36.11735460000001 | -90.55832668 | 2021-01-11 05:21:50 | Greene, Arkansas, US |
2626352 | 2626352 | 2021-01-10 | US | Arkansas | Hempstead | 5057 | 1374 | 11 | 0 | 1363 | 33.73325583 | -93.66935133 | 2021-01-11 05:21:50 | Hempstead, Arkansas, US |
2626353 | 2626353 | 2021-01-10 | US | Arkansas | Hot Spring | 5059 | 3925 | 59 | 0 | 3866 | 34.31709259 | -92.95396325 | 2021-01-11 05:21:50 | Hot Spring, Arkansas, US |
2626354 | 2626354 | 2021-01-10 | US | Arkansas | Howard | 5061 | 1194 | 18 | 0 | 1176 | 34.09007427 | -93.9934871 | 2021-01-11 05:21:50 | Howard, Arkansas, US |
2626355 | 2626355 | 2021-01-10 | US | Arkansas | Independence | 5063 | 3090 | 99 | 0 | 2991 | 35.74242707 | -91.57001641 | 2021-01-11 05:21:50 | Independence, Arkansas, US |
2626356 | 2626356 | 2021-01-10 | US | Arkansas | Izard | 5065 | 1432 | 23 | 0 | 1409 | 36.09604046 | -91.90847954 | 2021-01-11 05:21:50 | Izard, Arkansas, US |
2626357 | 2626357 | 2021-01-10 | US | Arkansas | Jackson | 5067 | 2934 | 26 | 0 | 2908 | 35.59802983 | -91.21494602 | 2021-01-11 05:21:50 | Jackson, Arkansas, US |
2626358 | 2626358 | 2021-01-10 | US | Arkansas | Jefferson | 5069 | 7173 | 134 | 0 | 7039 | 34.26767081 | -91.92619839 | 2021-01-11 05:21:50 | Jefferson, Arkansas, US |
2626359 | 2626359 | 2021-01-10 | US | Arkansas | Johnson | 5071 | 2155 | 21 | 0 | 2134 | 35.56759135 | -93.46036368 | 2021-01-11 05:21:50 | Johnson, Arkansas, US |
2626360 | 2626360 | 2021-01-10 | US | Arkansas | Lafayette | 5073 | 370 | 5 | 0 | 365 | 33.24116713 | -93.60677071 | 2021-01-11 05:21:50 | Lafayette, Arkansas, US |
2626361 | 2626361 | 2021-01-10 | US | Arkansas | Lawrence | 5075 | 1723 | 38 | 0 | 1685 | 36.04188196 | -91.10867198 | 2021-01-11 05:21:50 | Lawrence, Arkansas, US |
2626362 | 2626362 | 2021-01-10 | US | Arkansas | Lee | 5077 | 1515 | 28 | 0 | 1487 | 34.78498904 | -90.78383866 | 2021-01-11 05:21:50 | Lee, Arkansas, US |
2626363 | 2626363 | 2021-01-10 | US | Arkansas | Lincoln | 5079 | 2905 | 28 | 0 | 2877 | 33.95317155 | -91.74002806 | 2021-01-11 05:21:50 | Lincoln, Arkansas, US |
2626364 | 2626364 | 2021-01-10 | US | Arkansas | Little River | 5081 | 899 | 39 | 0 | 860 | 33.70375665 | -94.23468591 | 2021-01-11 05:21:50 | Little River, Arkansas, US |
2626365 | 2626365 | 2021-01-10 | US | Arkansas | Logan | 5083 | 1674 | 13 | 0 | 1661 | 35.21413234 | -93.71951016 | 2021-01-11 05:21:50 | Logan, Arkansas, US |
2626366 | 2626366 | 2021-01-10 | US | Arkansas | Lonoke | 5085 | 4878 | 89 | 0 | 4789 | 34.75392199 | -91.88742357 | 2021-01-11 05:21:50 | Lonoke, Arkansas, US |
2626367 | 2626367 | 2021-01-10 | US | Arkansas | Madison | 5087 | 1144 | 14 | 0 | 1130 | 36.01038185 | -93.72524943 | 2021-01-11 05:21:50 | Madison, Arkansas, US |
2626368 | 2626368 | 2021-01-10 | US | Arkansas | Marion | 5089 | 738 | 24 | 0 | 714 | 36.26844485 | -92.68451899 | 2021-01-11 05:21:50 | Marion, Arkansas, US |
2626369 | 2626369 | 2021-01-10 | US | Arkansas | Miller | 5091 | 2981 | 25 | 0 | 2956 | 33.31403423 | -93.89285258 | 2021-01-11 05:21:50 | Miller, Arkansas, US |
2626370 | 2626370 | 2021-01-10 | US | Arkansas | Mississippi | 5093 | 4719 | 99 | 0 | 4620 | 35.76271485 | -90.05194370000002 | 2021-01-11 05:21:50 | Mississippi, Arkansas, US |
2626371 | 2626371 | 2021-01-10 | US | Arkansas | Monroe | 5095 | 557 | 9 | 0 | 548 | 34.6815935 | -91.20540287 | 2021-01-11 05:21:50 | Monroe, Arkansas, US |
2626372 | 2626372 | 2021-01-10 | US | Arkansas | Montgomery | 5097 | 580 | 21 | 0 | 559 | 34.53704874 | -93.65824478 | 2021-01-11 05:21:50 | Montgomery, Arkansas, US |
2626373 | 2626373 | 2021-01-10 | US | Arkansas | Nevada | 5099 | 626 | 22 | 0 | 604 | 33.66340119 | -93.30632432 | 2021-01-11 05:21:50 | Nevada, Arkansas, US |
2626374 | 2626374 | 2021-01-10 | US | Arkansas | Newton | 5101 | 597 | 24 | 0 | 573 | 35.91947491 | -93.21612969 | 2021-01-11 05:21:50 | Newton, Arkansas, US |
2626375 | 2626375 | 2021-01-10 | US | Arkansas | Ouachita | 5103 | 1602 | 35 | 0 | 1567 | 33.58839816 | -92.87795984 | 2021-01-11 05:21:50 | Ouachita, Arkansas, US |
2626376 | 2626376 | 2021-01-10 | US | Arkansas | Perry | 5105 | 546 | 5 | 0 | 541 | 34.9459153 | -92.94372564 | 2021-01-11 05:21:50 | Perry, Arkansas, US |
2626377 | 2626377 | 2021-01-10 | US | Arkansas | Phillips | 5107 | 1396 | 26 | 0 | 1370 | 34.43268455 | -90.84800154 | 2021-01-11 05:21:50 | Phillips, Arkansas, US |
2626378 | 2626378 | 2021-01-10 | US | Arkansas | Pike | 5109 | 778 | 14 | 0 | 764 | 34.16250414 | -93.65789349 | 2021-01-11 05:21:50 | Pike, Arkansas, US |
2626379 | 2626379 | 2021-01-10 | US | Arkansas | Poinsett | 5111 | 2618 | 64 | 0 | 2554 | 35.57433534 | -90.66268713 | 2021-01-11 05:21:50 | Poinsett, Arkansas, US |
2626380 | 2626380 | 2021-01-10 | US | Arkansas | Polk | 5113 | 1439 | 49 | 0 | 1390 | 34.48254879 | -94.22728802 | 2021-01-11 05:21:50 | Polk, Arkansas, US |
2626381 | 2626381 | 2021-01-10 | US | Arkansas | Pope | 5115 | 6240 | 65 | 0 | 6175 | 35.44871474 | -93.03212219 | 2021-01-11 05:21:50 | Pope, Arkansas, US |
2626382 | 2626382 | 2021-01-10 | US | Arkansas | Prairie | 5117 | 605 | 17 | 0 | 588 | 34.83624419 | -91.55162157 | 2021-01-11 05:21:50 | Prairie, Arkansas, US |
2626383 | 2626383 | 2021-01-10 | US | Arkansas | Pulaski | 5119 | 28248 | 428 | 0 | 27820 | 34.77054088 | -92.31355101 | 2021-01-11 05:21:50 | Pulaski, Arkansas, US |
2626384 | 2626384 | 2021-01-10 | US | Arkansas | Randolph | 5121 | 1623 | 43 | 0 | 1580 | 36.3415714 | -91.02455531 | 2021-01-11 05:21:50 | Randolph, Arkansas, US |
2626385 | 2626385 | 2021-01-10 | US | Arkansas | Saline | 5125 | 8749 | 119 | 0 | 8630 | 34.64916145 | -92.67583224 | 2021-01-11 05:21:50 | Saline, Arkansas, US |
2626386 | 2626386 | 2021-01-10 | US | Arkansas | Scott | 5127 | 718 | 13 | 0 | 705 | 34.85588887 | -94.0632176 | 2021-01-11 05:21:50 | Scott, Arkansas, US |
2626387 | 2626387 | 2021-01-10 | US | Arkansas | Searcy | 5129 | 544 | 13 | 0 | 531 | 35.9109364 | -92.69936482 | 2021-01-11 05:21:50 | Searcy, Arkansas, US |
2626388 | 2626388 | 2021-01-10 | US | Arkansas | Sebastian | 5131 | 11245 | 166 | 0 | 11079 | 35.19605503 | -94.27162713 | 2021-01-11 05:21:50 | Sebastian, Arkansas, US |
2626389 | 2626389 | 2021-01-10 | US | Arkansas | Sevier | 5133 | 2179 | 23 | 0 | 2156 | 33.99780401 | -94.2424869 | 2021-01-11 05:21:50 | Sevier, Arkansas, US |
2626390 | 2626390 | 2021-01-10 | US | Arkansas | Sharp | 5135 | 1305 | 36 | 0 | 1269 | 36.16258158 | -91.47819342 | 2021-01-11 05:21:50 | Sharp, Arkansas, US |
2626391 | 2626391 | 2021-01-10 | US | Arkansas | St. Francis | 5123 | 2994 | 23 | 0 | 2971 | 35.02201976 | -90.74828138 | 2021-01-11 05:21:50 | St. Francis, Arkansas, US |
2626392 | 2626392 | 2021-01-10 | US | Arkansas | Stone | 5137 | 825 | 27 | 0 | 798 | 35.86251946 | -92.15684085 | 2021-01-11 05:21:50 | Stone, Arkansas, US |
2626393 | 2626393 | 2021-01-10 | US | Arkansas | Unassigned | 90005 | 2766 | 0 | 0 | 2766 | 36.38177105 | 0.0 | 2021-01-11 05:21:50 | Unassigned, Arkansas, US |
2626394 | 2626394 | 2021-01-10 | US | Arkansas | Union | 5139 | 2785 | 76 | 0 | 2709 | 33.16887091 | -92.59746952 | 2021-01-11 05:21:50 | Union, Arkansas, US |
2626395 | 2626395 | 2021-01-10 | US | Arkansas | Van Buren | 5141 | 876 | 9 | 0 | 867 | 35.58095779 | -92.51295036 | 2021-01-11 05:21:50 | Van Buren, Arkansas, US |
2626396 | 2626396 | 2021-01-10 | US | Arkansas | Washington | 5143 | 24231 | 235 | 0 | 23996 | 35.976844 | -94.21800746 | 2021-01-11 05:21:50 | Washington, Arkansas, US |
2626397 | 2626397 | 2021-01-10 | US | Arkansas | White | 5145 | 5572 | 75 | 0 | 5497 | 35.25688493 | -91.74908296 | 2021-01-11 05:21:50 | White, Arkansas, US |
2626398 | 2626398 | 2021-01-10 | US | Arkansas | Woodruff | 5147 | 440 | 2 | 0 | 438 | 35.18902527 | -91.2439489 | 2021-01-11 05:21:50 | Woodruff, Arkansas, US |
2626399 | 2626399 | 2021-01-10 | US | Arkansas | Yell | 5149 | 2715 | 51 | 0 | 2664 | 35.00292371 | -93.41171338 | 2021-01-11 05:21:50 | Yell, Arkansas, US |
3900412 | 3900412 | 2021-01-09 | US | Arkansas | Arkansas | 5001 | 1457 | 33 | 0 | 1424 | 34.29145151 | -91.37277296 | 2021-01-10 05:22:12 | Arkansas, Arkansas, US |
3900413 | 3900413 | 2021-01-09 | US | Arkansas | Ashley | 5003 | 1394 | 21 | 0 | 1373 | 33.19153461 | -91.7698471 | 2021-01-10 05:22:12 | Ashley, Arkansas, US |
3900414 | 3900414 | 2021-01-09 | US | Arkansas | Baxter | 5005 | 2330 | 78 | 0 | 2252 | 36.28784385 | -92.33782872 | 2021-01-10 05:22:12 | Baxter, Arkansas, US |
3900415 | 3900415 | 2021-01-09 | US | Arkansas | Benton | 5007 | 20498 | 292 | 0 | 20206 | 36.33644656 | -94.25680817 | 2021-01-10 05:22:12 | Benton, Arkansas, US |
3900416 | 3900416 | 2021-01-09 | US | Arkansas | Boone | 5009 | 2816 | 71 | 0 | 2745 | 36.3084504 | -93.09374925 | 2021-01-10 05:22:12 | Boone, Arkansas, US |
3900417 | 3900417 | 2021-01-09 | US | Arkansas | Bradley | 5011 | 1075 | 19 | 0 | 1056 | 33.46755808 | -92.15980837 | 2021-01-10 05:22:12 | Bradley, Arkansas, US |
3900418 | 3900418 | 2021-01-09 | US | Arkansas | Calhoun | 5013 | 267 | 1 | 0 | 266 | 33.55598792 | -92.49974403 | 2021-01-10 05:22:12 | Calhoun, Arkansas, US |
3900419 | 3900419 | 2021-01-09 | US | Arkansas | Carroll | 5015 | 2255 | 31 | 0 | 2224 | 36.34038560000001 | -93.54270261 | 2021-01-10 05:22:12 | Carroll, Arkansas, US |
3900420 | 3900420 | 2021-01-09 | US | Arkansas | Chicot | 5017 | 1467 | 33 | 0 | 1434 | 33.26458973 | -91.29539209 | 2021-01-10 05:22:12 | Chicot, Arkansas, US |
3900421 | 3900421 | 2021-01-09 | US | Arkansas | Clark | 5019 | 1516 | 24 | 0 | 1492 | 34.04613432 | -93.17484713 | 2021-01-10 05:22:12 | Clark, Arkansas, US |
3900422 | 3900422 | 2021-01-09 | US | Arkansas | Clay | 5021 | 1411 | 35 | 0 | 1376 | 36.36826212 | -90.4148172 | 2021-01-10 05:22:12 | Clay, Arkansas, US |
3900423 | 3900423 | 2021-01-09 | US | Arkansas | Cleburne | 5023 | 1491 | 42 | 0 | 1449 | 35.53864922 | -92.02640019 | 2021-01-10 05:22:12 | Cleburne, Arkansas, US |
3900424 | 3900424 | 2021-01-09 | US | Arkansas | Cleveland | 5025 | 627 | 21 | 0 | 606 | 33.89723187 | -92.18537045 | 2021-01-10 05:22:12 | Cleveland, Arkansas, US |
3900425 | 3900425 | 2021-01-09 | US | Arkansas | Columbia | 5027 | 1698 | 44 | 0 | 1654 | 33.21230701 | -93.22642793 | 2021-01-10 05:22:12 | Columbia, Arkansas, US |
3900426 | 3900426 | 2021-01-09 | US | Arkansas | Conway | 5029 | 1613 | 19 | 0 | 1594 | 35.26205537 | -92.70506566 | 2021-01-10 05:22:12 | Conway, Arkansas, US |
3900427 | 3900427 | 2021-01-09 | US | Arkansas | Craighead | 5031 | 10941 | 146 | 0 | 10795 | 35.83018283 | -90.63235729 | 2021-01-10 05:22:12 | Craighead, Arkansas, US |
3900428 | 3900428 | 2021-01-09 | US | Arkansas | Crawford | 5033 | 5033 | 66 | 0 | 4967 | 35.58928601 | -94.2446814 | 2021-01-10 05:22:12 | Crawford, Arkansas, US |
3900429 | 3900429 | 2021-01-09 | US | Arkansas | Crittenden | 5035 | 4712 | 77 | 0 | 4635 | 35.21247318 | -90.30839406 | 2021-01-10 05:22:12 | Crittenden, Arkansas, US |
3900430 | 3900430 | 2021-01-09 | US | Arkansas | Cross | 5037 | 1590 | 37 | 0 | 1553 | 35.29631396 | -90.77185818 | 2021-01-10 05:22:12 | Cross, Arkansas, US |
3900431 | 3900431 | 2021-01-09 | US | Arkansas | Dallas | 5039 | 545 | 12 | 0 | 533 | 33.97042763 | -92.65167437 | 2021-01-10 05:22:12 | Dallas, Arkansas, US |
3900432 | 3900432 | 2021-01-09 | US | Arkansas | Desha | 5041 | 1032 | 14 | 0 | 1018 | 33.83011025 | -91.25500948 | 2021-01-10 05:22:12 | Desha, Arkansas, US |
3900433 | 3900433 | 2021-01-09 | US | Arkansas | Drew | 5043 | 1603 | 23 | 0 | 1580 | 33.59035001 | -91.71777921 | 2021-01-10 05:22:12 | Drew, Arkansas, US |
3900434 | 3900434 | 2021-01-09 | US | Arkansas | Faulkner | 5045 | 8861 | 103 | 0 | 8758 | 35.14719007 | -92.33717519 | 2021-01-10 05:22:12 | Faulkner, Arkansas, US |
3900435 | 3900435 | 2021-01-09 | US | Arkansas | Franklin | 5047 | 1220 | 26 | 0 | 1194 | 35.51202821 | -93.89299569 | 2021-01-10 05:22:12 | Franklin, Arkansas, US |
3900436 | 3900436 | 2021-01-09 | US | Arkansas | Fulton | 5049 | 970 | 37 | 0 | 933 | 36.38177105 | -91.81729127 | 2021-01-10 05:22:12 | Fulton, Arkansas, US |
3900437 | 3900437 | 2021-01-09 | US | Arkansas | Garland | 5051 | 6677 | 167 | 0 | 6510 | 34.57692074 | -93.14921604 | 2021-01-10 05:22:12 | Garland, Arkansas, US |
3900438 | 3900438 | 2021-01-09 | US | Arkansas | Grant | 5053 | 1189 | 15 | 0 | 1174 | 34.29017991 | -92.42320562 | 2021-01-10 05:22:12 | Grant, Arkansas, US |
3900439 | 3900439 | 2021-01-09 | US | Arkansas | Greene | 5055 | 4836 | 58 | 0 | 4778 | 36.11735460000001 | -90.55832668 | 2021-01-10 05:22:12 | Greene, Arkansas, US |
3900440 | 3900440 | 2021-01-09 | US | Arkansas | Hempstead | 5057 | 1366 | 11 | 0 | 1355 | 33.73325583 | -93.66935133 | 2021-01-10 05:22:12 | Hempstead, Arkansas, US |
3900441 | 3900441 | 2021-01-09 | US | Arkansas | Hot Spring | 5059 | 3900 | 59 | 0 | 3841 | 34.31709259 | -92.95396325 | 2021-01-10 05:22:12 | Hot Spring, Arkansas, US |
3900442 | 3900442 | 2021-01-09 | US | Arkansas | Howard | 5061 | 1194 | 18 | 0 | 1176 | 34.09007427 | -93.9934871 | 2021-01-10 05:22:12 | Howard, Arkansas, US |
3900443 | 3900443 | 2021-01-09 | US | Arkansas | Independence | 5063 | 3073 | 97 | 0 | 2976 | 35.74242707 | -91.57001641 | 2021-01-10 05:22:12 | Independence, Arkansas, US |
3900444 | 3900444 | 2021-01-09 | US | Arkansas | Izard | 5065 | 1429 | 21 | 0 | 1408 | 36.09604046 | -91.90847954 | 2021-01-10 05:22:12 | Izard, Arkansas, US |
3900445 | 3900445 | 2021-01-09 | US | Arkansas | Jackson | 5067 | 2932 | 26 | 0 | 2906 | 35.59802983 | -91.21494602 | 2021-01-10 05:22:12 | Jackson, Arkansas, US |
3900446 | 3900446 | 2021-01-09 | US | Arkansas | Jefferson | 5069 | 7144 | 133 | 0 | 7011 | 34.26767081 | -91.92619839 | 2021-01-10 05:22:12 | Jefferson, Arkansas, US |
3900447 | 3900447 | 2021-01-09 | US | Arkansas | Johnson | 5071 | 2128 | 21 | 0 | 2107 | 35.56759135 | -93.46036368 | 2021-01-10 05:22:12 | Johnson, Arkansas, US |
3900448 | 3900448 | 2021-01-09 | US | Arkansas | Lafayette | 5073 | 370 | 4 | 0 | 366 | 33.24116713 | -93.60677071 | 2021-01-10 05:22:12 | Lafayette, Arkansas, US |
3900449 | 3900449 | 2021-01-09 | US | Arkansas | Lawrence | 5075 | 1717 | 37 | 0 | 1680 | 36.04188196 | -91.10867198 | 2021-01-10 05:22:12 | Lawrence, Arkansas, US |
3900450 | 3900450 | 2021-01-09 | US | Arkansas | Lee | 5077 | 1511 | 28 | 0 | 1483 | 34.78498904 | -90.78383866 | 2021-01-10 05:22:12 | Lee, Arkansas, US |
3900451 | 3900451 | 2021-01-09 | US | Arkansas | Lincoln | 5079 | 2900 | 28 | 0 | 2872 | 33.95317155 | -91.74002806 | 2021-01-10 05:22:12 | Lincoln, Arkansas, US |
3900452 | 3900452 | 2021-01-09 | US | Arkansas | Little River | 5081 | 897 | 39 | 0 | 858 | 33.70375665 | -94.23468591 | 2021-01-10 05:22:12 | Little River, Arkansas, US |
3900453 | 3900453 | 2021-01-09 | US | Arkansas | Logan | 5083 | 1638 | 13 | 0 | 1625 | 35.21413234 | -93.71951016 | 2021-01-10 05:22:12 | Logan, Arkansas, US |
3900454 | 3900454 | 2021-01-09 | US | Arkansas | Lonoke | 5085 | 4845 | 88 | 0 | 4757 | 34.75392199 | -91.88742357 | 2021-01-10 05:22:12 | Lonoke, Arkansas, US |
3900455 | 3900455 | 2021-01-09 | US | Arkansas | Madison | 5087 | 1136 | 14 | 0 | 1122 | 36.01038185 | -93.72524943 | 2021-01-10 05:22:12 | Madison, Arkansas, US |
3900456 | 3900456 | 2021-01-09 | US | Arkansas | Marion | 5089 | 727 | 24 | 0 | 703 | 36.26844485 | -92.68451899 | 2021-01-10 05:22:12 | Marion, Arkansas, US |
3900457 | 3900457 | 2021-01-09 | US | Arkansas | Miller | 5091 | 2982 | 25 | 0 | 2957 | 33.31403423 | -93.89285258 | 2021-01-10 05:22:12 | Miller, Arkansas, US |
3900458 | 3900458 | 2021-01-09 | US | Arkansas | Mississippi | 5093 | 4698 | 99 | 0 | 4599 | 35.76271485 | -90.05194370000002 | 2021-01-10 05:22:12 | Mississippi, Arkansas, US |
3900459 | 3900459 | 2021-01-09 | US | Arkansas | Monroe | 5095 | 550 | 9 | 0 | 541 | 34.6815935 | -91.20540287 | 2021-01-10 05:22:12 | Monroe, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);