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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254624 | 3254624 | 2021-03-02 | US | Arkansas | Fulton | 5049 | 1081 | 46 | 0 | 1035 | 36.38177105 | -91.81729127 | 2021-03-03 05:23:28 | Fulton, Arkansas, US |
3254625 | 3254625 | 2021-03-02 | US | Arkansas | Garland | 5051 | 9736 | 231 | 0 | 9505 | 34.57692074 | -93.14921604 | 2021-03-03 05:23:28 | Garland, Arkansas, US |
3254626 | 3254626 | 2021-03-02 | US | Arkansas | Grant | 5053 | 1586 | 31 | 0 | 1555 | 34.29017991 | -92.42320562 | 2021-03-03 05:23:28 | Grant, Arkansas, US |
3254627 | 3254627 | 2021-03-02 | US | Arkansas | Greene | 5055 | 5900 | 72 | 0 | 5828 | 36.11735460000001 | -90.55832668 | 2021-03-03 05:23:28 | Greene, Arkansas, US |
3254628 | 3254628 | 2021-03-02 | US | Arkansas | Hempstead | 5057 | 1927 | 18 | 0 | 1909 | 33.73325583 | -93.66935133 | 2021-03-03 05:23:28 | Hempstead, Arkansas, US |
3254629 | 3254629 | 2021-03-02 | US | Arkansas | Hot Spring | 5059 | 4858 | 66 | 0 | 4792 | 34.31709259 | -92.95396325 | 2021-03-03 05:23:28 | Hot Spring, Arkansas, US |
3254630 | 3254630 | 2021-03-02 | US | Arkansas | Howard | 5061 | 1594 | 23 | 0 | 1571 | 34.09007427 | -93.9934871 | 2021-03-03 05:23:28 | Howard, Arkansas, US |
3254631 | 3254631 | 2021-03-02 | US | Arkansas | Independence | 5063 | 3677 | 116 | 0 | 3561 | 35.74242707 | -91.57001641 | 2021-03-03 05:23:28 | Independence, Arkansas, US |
3254632 | 3254632 | 2021-03-02 | US | Arkansas | Izard | 5065 | 1638 | 41 | 0 | 1597 | 36.09604046 | -91.90847954 | 2021-03-03 05:23:28 | Izard, Arkansas, US |
3254633 | 3254633 | 2021-03-02 | US | Arkansas | Jackson | 5067 | 3175 | 33 | 0 | 3142 | 35.59802983 | -91.21494602 | 2021-03-03 05:23:28 | Jackson, Arkansas, US |
3254634 | 3254634 | 2021-03-02 | US | Arkansas | Jefferson | 5069 | 8622 | 159 | 0 | 8463 | 34.26767081 | -91.92619839 | 2021-03-03 05:23:28 | Jefferson, Arkansas, US |
3254635 | 3254635 | 2021-03-02 | US | Arkansas | Johnson | 5071 | 2767 | 30 | 0 | 2737 | 35.56759135 | -93.46036368 | 2021-03-03 05:23:28 | Johnson, Arkansas, US |
3254636 | 3254636 | 2021-03-02 | US | Arkansas | Lafayette | 5073 | 535 | 8 | 0 | 527 | 33.24116713 | -93.60677071 | 2021-03-03 05:23:28 | Lafayette, Arkansas, US |
3254637 | 3254637 | 2021-03-02 | US | Arkansas | Lawrence | 5075 | 2048 | 41 | 0 | 2007 | 36.04188196 | -91.10867198 | 2021-03-03 05:23:28 | Lawrence, Arkansas, US |
3254638 | 3254638 | 2021-03-02 | US | Arkansas | Lee | 5077 | 1639 | 34 | 0 | 1605 | 34.78498904 | -90.78383866 | 2021-03-03 05:23:28 | Lee, Arkansas, US |
3254639 | 3254639 | 2021-03-02 | US | Arkansas | Lincoln | 5079 | 3152 | 44 | 0 | 3108 | 33.95317155 | -91.74002806 | 2021-03-03 05:23:28 | Lincoln, Arkansas, US |
3254640 | 3254640 | 2021-03-02 | US | Arkansas | Little River | 5081 | 1177 | 39 | 0 | 1138 | 33.70375665 | -94.23468591 | 2021-03-03 05:23:28 | Little River, Arkansas, US |
3254641 | 3254641 | 2021-03-02 | US | Arkansas | Logan | 5083 | 2167 | 18 | 0 | 2149 | 35.21413234 | -93.71951016 | 2021-03-03 05:23:28 | Logan, Arkansas, US |
3254642 | 3254642 | 2021-03-02 | US | Arkansas | Lonoke | 5085 | 6838 | 105 | 0 | 6733 | 34.75392199 | -91.88742357 | 2021-03-03 05:23:28 | Lonoke, Arkansas, US |
3254643 | 3254643 | 2021-03-02 | US | Arkansas | Madison | 5087 | 1407 | 21 | 0 | 1386 | 36.01038185 | -93.72524943 | 2021-03-03 05:23:28 | Madison, Arkansas, US |
3254644 | 3254644 | 2021-03-02 | US | Arkansas | Marion | 5089 | 973 | 29 | 0 | 944 | 36.26844485 | -92.68451899 | 2021-03-03 05:23:28 | Marion, Arkansas, US |
3254645 | 3254645 | 2021-03-02 | US | Arkansas | Miller | 5091 | 4043 | 31 | 0 | 4012 | 33.31403423 | -93.89285258 | 2021-03-03 05:23:28 | Miller, Arkansas, US |
3254646 | 3254646 | 2021-03-02 | US | Arkansas | Mississippi | 5093 | 5676 | 105 | 0 | 5571 | 35.76271485 | -90.05194370000002 | 2021-03-03 05:23:28 | Mississippi, Arkansas, US |
3254647 | 3254647 | 2021-03-02 | US | Arkansas | Monroe | 5095 | 828 | 15 | 0 | 813 | 34.6815935 | -91.20540287 | 2021-03-03 05:23:28 | Monroe, Arkansas, US |
3254648 | 3254648 | 2021-03-02 | US | Arkansas | Montgomery | 5097 | 730 | 29 | 0 | 701 | 34.53704874 | -93.65824478 | 2021-03-03 05:23:28 | Montgomery, Arkansas, US |
3254649 | 3254649 | 2021-03-02 | US | Arkansas | Nevada | 5099 | 793 | 23 | 0 | 770 | 33.66340119 | -93.30632432 | 2021-03-03 05:23:28 | Nevada, Arkansas, US |
3254650 | 3254650 | 2021-03-02 | US | Arkansas | Newton | 5101 | 691 | 26 | 0 | 665 | 35.91947491 | -93.21612969 | 2021-03-03 05:23:28 | Newton, Arkansas, US |
3254651 | 3254651 | 2021-03-02 | US | Arkansas | Ouachita | 5103 | 2220 | 51 | 0 | 2169 | 33.58839816 | -92.87795984 | 2021-03-03 05:23:28 | Ouachita, Arkansas, US |
3254652 | 3254652 | 2021-03-02 | US | Arkansas | Perry | 5105 | 801 | 9 | 0 | 792 | 34.9459153 | -92.94372564 | 2021-03-03 05:23:28 | Perry, Arkansas, US |
3254653 | 3254653 | 2021-03-02 | US | Arkansas | Phillips | 5107 | 1701 | 34 | 0 | 1667 | 34.43268455 | -90.84800154 | 2021-03-03 05:23:28 | Phillips, Arkansas, US |
3254654 | 3254654 | 2021-03-02 | US | Arkansas | Pike | 5109 | 975 | 22 | 0 | 953 | 34.16250414 | -93.65789349 | 2021-03-03 05:23:28 | Pike, Arkansas, US |
3254655 | 3254655 | 2021-03-02 | US | Arkansas | Poinsett | 5111 | 3080 | 73 | 0 | 3007 | 35.57433534 | -90.66268713 | 2021-03-03 05:23:28 | Poinsett, Arkansas, US |
3254656 | 3254656 | 2021-03-02 | US | Arkansas | Polk | 5113 | 1897 | 65 | 0 | 1832 | 34.48254879 | -94.22728802 | 2021-03-03 05:23:28 | Polk, Arkansas, US |
3254657 | 3254657 | 2021-03-02 | US | Arkansas | Pope | 5115 | 7747 | 98 | 0 | 7649 | 35.44871474 | -93.03212219 | 2021-03-03 05:23:28 | Pope, Arkansas, US |
3254658 | 3254658 | 2021-03-02 | US | Arkansas | Prairie | 5117 | 874 | 21 | 0 | 853 | 34.83624419 | -91.55162157 | 2021-03-03 05:23:28 | Prairie, Arkansas, US |
3254659 | 3254659 | 2021-03-02 | US | Arkansas | Pulaski | 5119 | 37462 | 564 | 0 | 36898 | 34.77054088 | -92.31355101 | 2021-03-03 05:23:28 | Pulaski, Arkansas, US |
3254660 | 3254660 | 2021-03-02 | US | Arkansas | Randolph | 5121 | 2010 | 44 | 0 | 1966 | 36.3415714 | -91.02455531 | 2021-03-03 05:23:28 | Randolph, Arkansas, US |
3254661 | 3254661 | 2021-03-02 | US | Arkansas | Saline | 5125 | 11441 | 154 | 0 | 11287 | 34.64916145 | -92.67583224 | 2021-03-03 05:23:28 | Saline, Arkansas, US |
3254662 | 3254662 | 2021-03-02 | US | Arkansas | Scott | 5127 | 921 | 14 | 0 | 907 | 34.85588887 | -94.0632176 | 2021-03-03 05:23:28 | Scott, Arkansas, US |
3254663 | 3254663 | 2021-03-02 | US | Arkansas | Searcy | 5129 | 662 | 15 | 0 | 647 | 35.9109364 | -92.69936482 | 2021-03-03 05:23:28 | Searcy, Arkansas, US |
3254664 | 3254664 | 2021-03-02 | US | Arkansas | Sebastian | 5131 | 14594 | 257 | 0 | 14337 | 35.19605503 | -94.27162713 | 2021-03-03 05:23:28 | Sebastian, Arkansas, US |
3254665 | 3254665 | 2021-03-02 | US | Arkansas | Sevier | 5133 | 2717 | 25 | 0 | 2692 | 33.99780401 | -94.2424869 | 2021-03-03 05:23:28 | Sevier, Arkansas, US |
3254666 | 3254666 | 2021-03-02 | US | Arkansas | Sharp | 5135 | 1524 | 45 | 0 | 1479 | 36.16258158 | -91.47819342 | 2021-03-03 05:23:28 | Sharp, Arkansas, US |
3254667 | 3254667 | 2021-03-02 | US | Arkansas | St. Francis | 5123 | 3446 | 36 | 0 | 3410 | 35.02201976 | -90.74828138 | 2021-03-03 05:23:28 | St. Francis, Arkansas, US |
3254668 | 3254668 | 2021-03-02 | US | Arkansas | Stone | 5137 | 967 | 28 | 0 | 939 | 35.86251946 | -92.15684085 | 2021-03-03 05:23:28 | Stone, Arkansas, US |
3254669 | 3254669 | 2021-03-02 | US | Arkansas | Unassigned | 90005 | 3296 | 0 | 0 | 3296 | 36.38177105 | 0.0 | 2021-03-03 05:23:28 | Unassigned, Arkansas, US |
3254670 | 3254670 | 2021-03-02 | US | Arkansas | Union | 5139 | 3729 | 100 | 0 | 3629 | 33.16887091 | -92.59746952 | 2021-03-03 05:23:28 | Union, Arkansas, US |
3254671 | 3254671 | 2021-03-02 | US | Arkansas | Van Buren | 5141 | 1198 | 19 | 0 | 1179 | 35.58095779 | -92.51295036 | 2021-03-03 05:23:28 | Van Buren, Arkansas, US |
3254672 | 3254672 | 2021-03-02 | US | Arkansas | Washington | 5143 | 29430 | 329 | 0 | 29101 | 35.976844 | -94.21800746 | 2021-03-03 05:23:28 | Washington, Arkansas, US |
3254673 | 3254673 | 2021-03-02 | US | Arkansas | White | 5145 | 7587 | 108 | 0 | 7479 | 35.25688493 | -91.74908296 | 2021-03-03 05:23:28 | White, Arkansas, US |
3254674 | 3254674 | 2021-03-02 | US | Arkansas | Woodruff | 5147 | 623 | 9 | 0 | 614 | 35.18902527 | -91.2439489 | 2021-03-03 05:23:28 | Woodruff, Arkansas, US |
3254675 | 3254675 | 2021-03-02 | US | Arkansas | Yell | 5149 | 3369 | 63 | 0 | 3306 | 35.00292371 | -93.41171338 | 2021-03-03 05:23:28 | Yell, Arkansas, US |
998892 | 998892 | 2021-03-01 | US | Arkansas | Arkansas | 5001 | 1993 | 33 | 0 | 1960 | 34.29145151 | -91.37277296 | 2021-03-02 05:23:30 | Arkansas, Arkansas, US |
998893 | 998893 | 2021-03-01 | US | Arkansas | Ashley | 5003 | 1826 | 29 | 0 | 1797 | 33.19153461 | -91.7698471 | 2021-03-02 05:23:30 | Ashley, Arkansas, US |
998894 | 998894 | 2021-03-01 | US | Arkansas | Baxter | 5005 | 2891 | 94 | 0 | 2797 | 36.28784385 | -92.33782872 | 2021-03-02 05:23:30 | Baxter, Arkansas, US |
998895 | 998895 | 2021-03-01 | US | Arkansas | Benton | 5007 | 27257 | 379 | 0 | 26878 | 36.33644656 | -94.25680817 | 2021-03-02 05:23:30 | Benton, Arkansas, US |
998896 | 998896 | 2021-03-01 | US | Arkansas | Boone | 5009 | 3641 | 73 | 0 | 3568 | 36.3084504 | -93.09374925 | 2021-03-02 05:23:30 | Boone, Arkansas, US |
998897 | 998897 | 2021-03-01 | US | Arkansas | Bradley | 5011 | 1321 | 30 | 0 | 1291 | 33.46755808 | -92.15980837 | 2021-03-02 05:23:30 | Bradley, Arkansas, US |
998898 | 998898 | 2021-03-01 | US | Arkansas | Calhoun | 5013 | 398 | 2 | 0 | 396 | 33.55598792 | -92.49974403 | 2021-03-02 05:23:30 | Calhoun, Arkansas, US |
998899 | 998899 | 2021-03-01 | US | Arkansas | Carroll | 5015 | 2713 | 42 | 0 | 2671 | 36.34038560000001 | -93.54270261 | 2021-03-02 05:23:30 | Carroll, Arkansas, US |
998900 | 998900 | 2021-03-01 | US | Arkansas | Chicot | 5017 | 1586 | 38 | 0 | 1548 | 33.26458973 | -91.29539209 | 2021-03-02 05:23:30 | Chicot, Arkansas, US |
998901 | 998901 | 2021-03-01 | US | Arkansas | Clark | 5019 | 2036 | 37 | 0 | 1999 | 34.04613432 | -93.17484713 | 2021-03-02 05:23:30 | Clark, Arkansas, US |
998902 | 998902 | 2021-03-01 | US | Arkansas | Clay | 5021 | 1693 | 48 | 0 | 1645 | 36.36826212 | -90.4148172 | 2021-03-02 05:23:30 | Clay, Arkansas, US |
998903 | 998903 | 2021-03-01 | US | Arkansas | Cleburne | 5023 | 1885 | 64 | 0 | 1821 | 35.53864922 | -92.02640019 | 2021-03-02 05:23:30 | Cleburne, Arkansas, US |
998904 | 998904 | 2021-03-01 | US | Arkansas | Cleveland | 5025 | 922 | 24 | 0 | 898 | 33.89723187 | -92.18537045 | 2021-03-02 05:23:30 | Cleveland, Arkansas, US |
998905 | 998905 | 2021-03-01 | US | Arkansas | Columbia | 5027 | 2259 | 53 | 0 | 2206 | 33.21230701 | -93.22642793 | 2021-03-02 05:23:30 | Columbia, Arkansas, US |
998906 | 998906 | 2021-03-01 | US | Arkansas | Conway | 5029 | 2150 | 30 | 0 | 2120 | 35.26205537 | -92.70506566 | 2021-03-02 05:23:30 | Conway, Arkansas, US |
998907 | 998907 | 2021-03-01 | US | Arkansas | Craighead | 5031 | 12847 | 168 | 0 | 12679 | 35.83018283 | -90.63235729 | 2021-03-02 05:23:30 | Craighead, Arkansas, US |
998908 | 998908 | 2021-03-01 | US | Arkansas | Crawford | 5033 | 6782 | 102 | 0 | 6680 | 35.58928601 | -94.2446814 | 2021-03-02 05:23:30 | Crawford, Arkansas, US |
998909 | 998909 | 2021-03-01 | US | Arkansas | Crittenden | 5035 | 5755 | 90 | 0 | 5665 | 35.21247318 | -90.30839406 | 2021-03-02 05:23:30 | Crittenden, Arkansas, US |
998910 | 998910 | 2021-03-01 | US | Arkansas | Cross | 5037 | 1891 | 47 | 0 | 1844 | 35.29631396 | -90.77185818 | 2021-03-02 05:23:30 | Cross, Arkansas, US |
998911 | 998911 | 2021-03-01 | US | Arkansas | Dallas | 5039 | 738 | 12 | 0 | 726 | 33.97042763 | -92.65167437 | 2021-03-02 05:23:30 | Dallas, Arkansas, US |
998912 | 998912 | 2021-03-01 | US | Arkansas | Desha | 5041 | 1334 | 21 | 0 | 1313 | 33.83011025 | -91.25500948 | 2021-03-02 05:23:30 | Desha, Arkansas, US |
998913 | 998913 | 2021-03-01 | US | Arkansas | Drew | 5043 | 1946 | 35 | 0 | 1911 | 33.59035001 | -91.71777921 | 2021-03-02 05:23:30 | Drew, Arkansas, US |
998914 | 998914 | 2021-03-01 | US | Arkansas | Faulkner | 5045 | 11781 | 149 | 0 | 11632 | 35.14719007 | -92.33717519 | 2021-03-02 05:23:30 | Faulkner, Arkansas, US |
998915 | 998915 | 2021-03-01 | US | Arkansas | Franklin | 5047 | 1632 | 37 | 0 | 1595 | 35.51202821 | -93.89299569 | 2021-03-02 05:23:30 | Franklin, Arkansas, US |
998916 | 998916 | 2021-03-01 | US | Arkansas | Fulton | 5049 | 1080 | 46 | 0 | 1034 | 36.38177105 | -91.81729127 | 2021-03-02 05:23:30 | Fulton, Arkansas, US |
998917 | 998917 | 2021-03-01 | US | Arkansas | Garland | 5051 | 9730 | 231 | 0 | 9499 | 34.57692074 | -93.14921604 | 2021-03-02 05:23:30 | Garland, Arkansas, US |
998918 | 998918 | 2021-03-01 | US | Arkansas | Grant | 5053 | 1582 | 31 | 0 | 1551 | 34.29017991 | -92.42320562 | 2021-03-02 05:23:30 | Grant, Arkansas, US |
998919 | 998919 | 2021-03-01 | US | Arkansas | Greene | 5055 | 5895 | 72 | 0 | 5823 | 36.11735460000001 | -90.55832668 | 2021-03-02 05:23:30 | Greene, Arkansas, US |
998920 | 998920 | 2021-03-01 | US | Arkansas | Hempstead | 5057 | 1924 | 18 | 0 | 1906 | 33.73325583 | -93.66935133 | 2021-03-02 05:23:30 | Hempstead, Arkansas, US |
998921 | 998921 | 2021-03-01 | US | Arkansas | Hot Spring | 5059 | 4856 | 66 | 0 | 4790 | 34.31709259 | -92.95396325 | 2021-03-02 05:23:30 | Hot Spring, Arkansas, US |
998922 | 998922 | 2021-03-01 | US | Arkansas | Howard | 5061 | 1590 | 23 | 0 | 1567 | 34.09007427 | -93.9934871 | 2021-03-02 05:23:30 | Howard, Arkansas, US |
998923 | 998923 | 2021-03-01 | US | Arkansas | Independence | 5063 | 3668 | 116 | 0 | 3552 | 35.74242707 | -91.57001641 | 2021-03-02 05:23:30 | Independence, Arkansas, US |
998924 | 998924 | 2021-03-01 | US | Arkansas | Izard | 5065 | 1635 | 41 | 0 | 1594 | 36.09604046 | -91.90847954 | 2021-03-02 05:23:30 | Izard, Arkansas, US |
998925 | 998925 | 2021-03-01 | US | Arkansas | Jackson | 5067 | 3175 | 33 | 0 | 3142 | 35.59802983 | -91.21494602 | 2021-03-02 05:23:30 | Jackson, Arkansas, US |
998926 | 998926 | 2021-03-01 | US | Arkansas | Jefferson | 5069 | 8606 | 159 | 0 | 8447 | 34.26767081 | -91.92619839 | 2021-03-02 05:23:30 | Jefferson, Arkansas, US |
998927 | 998927 | 2021-03-01 | US | Arkansas | Johnson | 5071 | 2758 | 30 | 0 | 2728 | 35.56759135 | -93.46036368 | 2021-03-02 05:23:30 | Johnson, Arkansas, US |
998928 | 998928 | 2021-03-01 | US | Arkansas | Lafayette | 5073 | 535 | 8 | 0 | 527 | 33.24116713 | -93.60677071 | 2021-03-02 05:23:30 | Lafayette, Arkansas, US |
998929 | 998929 | 2021-03-01 | US | Arkansas | Lawrence | 5075 | 2047 | 41 | 0 | 2006 | 36.04188196 | -91.10867198 | 2021-03-02 05:23:30 | Lawrence, Arkansas, US |
998930 | 998930 | 2021-03-01 | US | Arkansas | Lee | 5077 | 1639 | 34 | 0 | 1605 | 34.78498904 | -90.78383866 | 2021-03-02 05:23:30 | Lee, Arkansas, US |
998931 | 998931 | 2021-03-01 | US | Arkansas | Lincoln | 5079 | 3152 | 44 | 0 | 3108 | 33.95317155 | -91.74002806 | 2021-03-02 05:23:30 | Lincoln, Arkansas, US |
998932 | 998932 | 2021-03-01 | US | Arkansas | Little River | 5081 | 1174 | 39 | 0 | 1135 | 33.70375665 | -94.23468591 | 2021-03-02 05:23:30 | Little River, Arkansas, US |
998933 | 998933 | 2021-03-01 | US | Arkansas | Logan | 5083 | 2166 | 18 | 0 | 2148 | 35.21413234 | -93.71951016 | 2021-03-02 05:23:30 | Logan, Arkansas, US |
998934 | 998934 | 2021-03-01 | US | Arkansas | Lonoke | 5085 | 6811 | 105 | 0 | 6706 | 34.75392199 | -91.88742357 | 2021-03-02 05:23:30 | Lonoke, Arkansas, US |
998935 | 998935 | 2021-03-01 | US | Arkansas | Madison | 5087 | 1403 | 21 | 0 | 1382 | 36.01038185 | -93.72524943 | 2021-03-02 05:23:30 | Madison, Arkansas, US |
998936 | 998936 | 2021-03-01 | US | Arkansas | Marion | 5089 | 961 | 29 | 0 | 932 | 36.26844485 | -92.68451899 | 2021-03-02 05:23:30 | Marion, Arkansas, US |
998937 | 998937 | 2021-03-01 | US | Arkansas | Miller | 5091 | 4027 | 31 | 0 | 3996 | 33.31403423 | -93.89285258 | 2021-03-02 05:23:30 | Miller, Arkansas, US |
998938 | 998938 | 2021-03-01 | US | Arkansas | Mississippi | 5093 | 5673 | 105 | 0 | 5568 | 35.76271485 | -90.05194370000002 | 2021-03-02 05:23:30 | Mississippi, Arkansas, US |
998939 | 998939 | 2021-03-01 | US | Arkansas | Monroe | 5095 | 828 | 15 | 0 | 813 | 34.6815935 | -91.20540287 | 2021-03-02 05:23:30 | 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]);