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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701962 | 2701962 | 2020-11-20 | US | Arkansas | Arkansas | 5001 | 894 | 20 | 0 | 874 | 34.29145151 | -91.37277296 | 2020-11-21 05:25:51 | Arkansas, Arkansas, US |
2701963 | 2701963 | 2020-11-20 | US | Arkansas | Ashley | 5003 | 724 | 13 | 0 | 711 | 33.19153461 | -91.7698471 | 2020-11-21 05:25:51 | Ashley, Arkansas, US |
2701964 | 2701964 | 2020-11-20 | US | Arkansas | Baxter | 5005 | 1216 | 26 | 0 | 1190 | 36.28784385 | -92.33782872 | 2020-11-21 05:25:51 | Baxter, Arkansas, US |
2701965 | 2701965 | 2020-11-20 | US | Arkansas | Benton | 5007 | 10906 | 141 | 0 | 10765 | 36.33644656 | -94.25680817 | 2020-11-21 05:25:51 | Benton, Arkansas, US |
2701966 | 2701966 | 2020-11-20 | US | Arkansas | Boone | 5009 | 1522 | 41 | 0 | 1481 | 36.3084504 | -93.09374925 | 2020-11-21 05:25:51 | Boone, Arkansas, US |
2701967 | 2701967 | 2020-11-20 | US | Arkansas | Bradley | 5011 | 420 | 8 | 0 | 412 | 33.46755808 | -92.15980837 | 2020-11-21 05:25:51 | Bradley, Arkansas, US |
2701968 | 2701968 | 2020-11-20 | US | Arkansas | Calhoun | 5013 | 125 | 0 | 0 | 125 | 33.55598792 | -92.49974403 | 2020-11-21 05:25:51 | Calhoun, Arkansas, US |
2701969 | 2701969 | 2020-11-20 | US | Arkansas | Carroll | 5015 | 1259 | 21 | 0 | 1238 | 36.34038560000001 | -93.54270261 | 2020-11-21 05:25:51 | Carroll, Arkansas, US |
2701970 | 2701970 | 2020-11-20 | US | Arkansas | Chicot | 5017 | 1119 | 25 | 0 | 1094 | 33.26458973 | -91.29539209 | 2020-11-21 05:25:51 | Chicot, Arkansas, US |
2701971 | 2701971 | 2020-11-20 | US | Arkansas | Clark | 5019 | 734 | 9 | 0 | 725 | 34.04613432 | -93.17484713 | 2020-11-21 05:25:51 | Clark, Arkansas, US |
2701972 | 2701972 | 2020-11-20 | US | Arkansas | Clay | 5021 | 755 | 18 | 0 | 737 | 36.36826212 | -90.4148172 | 2020-11-21 05:25:51 | Clay, Arkansas, US |
2701973 | 2701973 | 2020-11-20 | US | Arkansas | Cleburne | 5023 | 635 | 20 | 0 | 615 | 35.53864922 | -92.02640019 | 2020-11-21 05:25:51 | Cleburne, Arkansas, US |
2701974 | 2701974 | 2020-11-20 | US | Arkansas | Cleveland | 5025 | 324 | 14 | 0 | 310 | 33.89723187 | -92.18537045 | 2020-11-21 05:25:51 | Cleveland, Arkansas, US |
2701975 | 2701975 | 2020-11-20 | US | Arkansas | Columbia | 5027 | 952 | 24 | 0 | 928 | 33.21230701 | -93.22642793 | 2020-11-21 05:25:51 | Columbia, Arkansas, US |
2701976 | 2701976 | 2020-11-20 | US | Arkansas | Conway | 5029 | 582 | 6 | 0 | 576 | 35.26205537 | -92.70506566 | 2020-11-21 05:25:51 | Conway, Arkansas, US |
2701977 | 2701977 | 2020-11-20 | US | Arkansas | Craighead | 5031 | 6423 | 71 | 0 | 6352 | 35.83018283 | -90.63235729 | 2020-11-21 05:25:51 | Craighead, Arkansas, US |
2701978 | 2701978 | 2020-11-20 | US | Arkansas | Crawford | 5033 | 2818 | 35 | 0 | 2783 | 35.58928601 | -94.2446814 | 2020-11-21 05:25:51 | Crawford, Arkansas, US |
2701979 | 2701979 | 2020-11-20 | US | Arkansas | Crittenden | 5035 | 3043 | 55 | 0 | 2988 | 35.21247318 | -90.30839406 | 2020-11-21 05:25:51 | Crittenden, Arkansas, US |
2701980 | 2701980 | 2020-11-20 | US | Arkansas | Cross | 5037 | 740 | 25 | 0 | 715 | 35.29631396 | -90.77185818 | 2020-11-21 05:25:51 | Cross, Arkansas, US |
2701981 | 2701981 | 2020-11-20 | US | Arkansas | Dallas | 5039 | 255 | 6 | 0 | 249 | 33.97042763 | -92.65167437 | 2020-11-21 05:25:51 | Dallas, Arkansas, US |
2701982 | 2701982 | 2020-11-20 | US | Arkansas | Desha | 5041 | 505 | 8 | 0 | 497 | 33.83011025 | -91.25500948 | 2020-11-21 05:25:51 | Desha, Arkansas, US |
2701983 | 2701983 | 2020-11-20 | US | Arkansas | Drew | 5043 | 558 | 7 | 0 | 551 | 33.59035001 | -91.71777921 | 2020-11-21 05:25:51 | Drew, Arkansas, US |
2701984 | 2701984 | 2020-11-20 | US | Arkansas | Faulkner | 5045 | 4342 | 50 | 0 | 4292 | 35.14719007 | -92.33717519 | 2020-11-21 05:25:51 | Faulkner, Arkansas, US |
2701985 | 2701985 | 2020-11-20 | US | Arkansas | Franklin | 5047 | 698 | 8 | 0 | 690 | 35.51202821 | -93.89299569 | 2020-11-21 05:25:51 | Franklin, Arkansas, US |
2701986 | 2701986 | 2020-11-20 | US | Arkansas | Fulton | 5049 | 488 | 12 | 0 | 476 | 36.38177105 | -91.81729127 | 2020-11-21 05:25:51 | Fulton, Arkansas, US |
2701987 | 2701987 | 2020-11-20 | US | Arkansas | Garland | 5051 | 3416 | 99 | 0 | 3317 | 34.57692074 | -93.14921604 | 2020-11-21 05:25:51 | Garland, Arkansas, US |
2701988 | 2701988 | 2020-11-20 | US | Arkansas | Grant | 5053 | 519 | 5 | 0 | 514 | 34.29017991 | -92.42320562 | 2020-11-21 05:25:51 | Grant, Arkansas, US |
2701989 | 2701989 | 2020-11-20 | US | Arkansas | Greene | 5055 | 2482 | 26 | 0 | 2456 | 36.11735460000001 | -90.55832668 | 2020-11-21 05:25:51 | Greene, Arkansas, US |
2701990 | 2701990 | 2020-11-20 | US | Arkansas | Hempstead | 5057 | 790 | 6 | 0 | 784 | 33.73325583 | -93.66935133 | 2020-11-21 05:25:51 | Hempstead, Arkansas, US |
2701991 | 2701991 | 2020-11-20 | US | Arkansas | Hot Spring | 5059 | 2729 | 41 | 0 | 2688 | 34.31709259 | -92.95396325 | 2020-11-21 05:25:51 | Hot Spring, Arkansas, US |
2701992 | 2701992 | 2020-11-20 | US | Arkansas | Howard | 5061 | 759 | 15 | 0 | 744 | 34.09007427 | -93.9934871 | 2020-11-21 05:25:51 | Howard, Arkansas, US |
2701993 | 2701993 | 2020-11-20 | US | Arkansas | Independence | 5063 | 1923 | 71 | 0 | 1852 | 35.74242707 | -91.57001641 | 2020-11-21 05:25:51 | Independence, Arkansas, US |
2701994 | 2701994 | 2020-11-20 | US | Arkansas | Izard | 5065 | 940 | 5 | 0 | 935 | 36.09604046 | -91.90847954 | 2020-11-21 05:25:51 | Izard, Arkansas, US |
2701995 | 2701995 | 2020-11-20 | US | Arkansas | Jackson | 5067 | 1479 | 6 | 0 | 1473 | 35.59802983 | -91.21494602 | 2020-11-21 05:25:51 | Jackson, Arkansas, US |
2701996 | 2701996 | 2020-11-20 | US | Arkansas | Jefferson | 5069 | 4929 | 107 | 0 | 4822 | 34.26767081 | -91.92619839 | 2020-11-21 05:25:51 | Jefferson, Arkansas, US |
2701997 | 2701997 | 2020-11-20 | US | Arkansas | Johnson | 5071 | 1191 | 11 | 0 | 1180 | 35.56759135 | -93.46036368 | 2020-11-21 05:25:51 | Johnson, Arkansas, US |
2701998 | 2701998 | 2020-11-20 | US | Arkansas | Lafayette | 5073 | 248 | 3 | 0 | 245 | 33.24116713 | -93.60677071 | 2020-11-21 05:25:51 | Lafayette, Arkansas, US |
2701999 | 2701999 | 2020-11-20 | US | Arkansas | Lawrence | 5075 | 1070 | 28 | 0 | 1042 | 36.04188196 | -91.10867198 | 2020-11-21 05:25:51 | Lawrence, Arkansas, US |
2702000 | 2702000 | 2020-11-20 | US | Arkansas | Lee | 5077 | 1148 | 18 | 0 | 1130 | 34.78498904 | -90.78383866 | 2020-11-21 05:25:51 | Lee, Arkansas, US |
2702001 | 2702001 | 2020-11-20 | US | Arkansas | Lincoln | 5079 | 2382 | 18 | 0 | 2364 | 33.95317155 | -91.74002806 | 2020-11-21 05:25:51 | Lincoln, Arkansas, US |
2702002 | 2702002 | 2020-11-20 | US | Arkansas | Little River | 5081 | 601 | 39 | 0 | 562 | 33.70375665 | -94.23468591 | 2020-11-21 05:25:51 | Little River, Arkansas, US |
2702003 | 2702003 | 2020-11-20 | US | Arkansas | Logan | 5083 | 822 | 6 | 0 | 816 | 35.21413234 | -93.71951016 | 2020-11-21 05:25:51 | Logan, Arkansas, US |
2702004 | 2702004 | 2020-11-20 | US | Arkansas | Lonoke | 5085 | 2423 | 44 | 0 | 2379 | 34.75392199 | -91.88742357 | 2020-11-21 05:25:51 | Lonoke, Arkansas, US |
2702005 | 2702005 | 2020-11-20 | US | Arkansas | Madison | 5087 | 546 | 6 | 0 | 540 | 36.01038185 | -93.72524943 | 2020-11-21 05:25:51 | Madison, Arkansas, US |
2702006 | 2702006 | 2020-11-20 | US | Arkansas | Marion | 5089 | 365 | 5 | 0 | 360 | 36.26844485 | -92.68451899 | 2020-11-21 05:25:51 | Marion, Arkansas, US |
2702007 | 2702007 | 2020-11-20 | US | Arkansas | Miller | 5091 | 2017 | 22 | 0 | 1995 | 33.31403423 | -93.89285258 | 2020-11-21 05:25:51 | Miller, Arkansas, US |
2702008 | 2702008 | 2020-11-20 | US | Arkansas | Mississippi | 5093 | 2960 | 79 | 0 | 2881 | 35.76271485 | -90.05194370000002 | 2020-11-21 05:25:51 | Mississippi, Arkansas, US |
2702009 | 2702009 | 2020-11-20 | US | Arkansas | Monroe | 5095 | 283 | 4 | 0 | 279 | 34.6815935 | -91.20540287 | 2020-11-21 05:25:51 | Monroe, Arkansas, US |
2702010 | 2702010 | 2020-11-20 | US | Arkansas | Montgomery | 5097 | 235 | 10 | 0 | 225 | 34.53704874 | -93.65824478 | 2020-11-21 05:25:51 | Montgomery, Arkansas, US |
2702011 | 2702011 | 2020-11-20 | US | Arkansas | Nevada | 5099 | 416 | 14 | 0 | 402 | 33.66340119 | -93.30632432 | 2020-11-21 05:25:51 | Nevada, Arkansas, US |
2702012 | 2702012 | 2020-11-20 | US | Arkansas | Newton | 5101 | 397 | 22 | 0 | 375 | 35.91947491 | -93.21612969 | 2020-11-21 05:25:51 | Newton, Arkansas, US |
2702013 | 2702013 | 2020-11-20 | US | Arkansas | Ouachita | 5103 | 579 | 11 | 0 | 568 | 33.58839816 | -92.87795984 | 2020-11-21 05:25:51 | Ouachita, Arkansas, US |
2702014 | 2702014 | 2020-11-20 | US | Arkansas | Perry | 5105 | 222 | 3 | 0 | 219 | 34.9459153 | -92.94372564 | 2020-11-21 05:25:51 | Perry, Arkansas, US |
2702015 | 2702015 | 2020-11-20 | US | Arkansas | Phillips | 5107 | 874 | 16 | 0 | 858 | 34.43268455 | -90.84800154 | 2020-11-21 05:25:51 | Phillips, Arkansas, US |
2702016 | 2702016 | 2020-11-20 | US | Arkansas | Pike | 5109 | 344 | 1 | 0 | 343 | 34.16250414 | -93.65789349 | 2020-11-21 05:25:51 | Pike, Arkansas, US |
2702017 | 2702017 | 2020-11-20 | US | Arkansas | Poinsett | 5111 | 1557 | 38 | 0 | 1519 | 35.57433534 | -90.66268713 | 2020-11-21 05:25:51 | Poinsett, Arkansas, US |
2702018 | 2702018 | 2020-11-20 | US | Arkansas | Polk | 5113 | 673 | 7 | 0 | 666 | 34.48254879 | -94.22728802 | 2020-11-21 05:25:51 | Polk, Arkansas, US |
2702019 | 2702019 | 2020-11-20 | US | Arkansas | Pope | 5115 | 3413 | 41 | 0 | 3372 | 35.44871474 | -93.03212219 | 2020-11-21 05:25:51 | Pope, Arkansas, US |
2702020 | 2702020 | 2020-11-20 | US | Arkansas | Prairie | 5117 | 335 | 6 | 0 | 329 | 34.83624419 | -91.55162157 | 2020-11-21 05:25:51 | Prairie, Arkansas, US |
2702021 | 2702021 | 2020-11-20 | US | Arkansas | Pulaski | 5119 | 15255 | 251 | 0 | 15004 | 34.77054088 | -92.31355101 | 2020-11-21 05:25:51 | Pulaski, Arkansas, US |
2702022 | 2702022 | 2020-11-20 | US | Arkansas | Randolph | 5121 | 907 | 28 | 0 | 879 | 36.3415714 | -91.02455531 | 2020-11-21 05:25:51 | Randolph, Arkansas, US |
2702023 | 2702023 | 2020-11-20 | US | Arkansas | Saline | 5125 | 4170 | 51 | 0 | 4119 | 34.64916145 | -92.67583224 | 2020-11-21 05:25:51 | Saline, Arkansas, US |
2702024 | 2702024 | 2020-11-20 | US | Arkansas | Scott | 5127 | 323 | 2 | 0 | 321 | 34.85588887 | -94.0632176 | 2020-11-21 05:25:51 | Scott, Arkansas, US |
2702025 | 2702025 | 2020-11-20 | US | Arkansas | Searcy | 5129 | 268 | 1 | 0 | 267 | 35.9109364 | -92.69936482 | 2020-11-21 05:25:51 | Searcy, Arkansas, US |
2702026 | 2702026 | 2020-11-20 | US | Arkansas | Sebastian | 5131 | 6467 | 119 | 0 | 6348 | 35.19605503 | -94.27162713 | 2020-11-21 05:25:51 | Sebastian, Arkansas, US |
2702027 | 2702027 | 2020-11-20 | US | Arkansas | Sevier | 5133 | 1630 | 16 | 0 | 1614 | 33.99780401 | -94.2424869 | 2020-11-21 05:25:51 | Sevier, Arkansas, US |
2702028 | 2702028 | 2020-11-20 | US | Arkansas | Sharp | 5135 | 604 | 14 | 0 | 590 | 36.16258158 | -91.47819342 | 2020-11-21 05:25:51 | Sharp, Arkansas, US |
2702029 | 2702029 | 2020-11-20 | US | Arkansas | St. Francis | 5123 | 1959 | 13 | 0 | 1946 | 35.02201976 | -90.74828138 | 2020-11-21 05:25:51 | St. Francis, Arkansas, US |
2702030 | 2702030 | 2020-11-20 | US | Arkansas | Stone | 5137 | 439 | 22 | 0 | 417 | 35.86251946 | -92.15684085 | 2020-11-21 05:25:51 | Stone, Arkansas, US |
2702031 | 2702031 | 2020-11-20 | US | Arkansas | Unassigned | 90005 | 2404 | 0 | 0 | 2404 | 36.38177105 | 0.0 | 2020-11-21 05:25:51 | Unassigned, Arkansas, US |
2702032 | 2702032 | 2020-11-20 | US | Arkansas | Union | 5139 | 1420 | 56 | 0 | 1364 | 33.16887091 | -92.59746952 | 2020-11-21 05:25:51 | Union, Arkansas, US |
2702033 | 2702033 | 2020-11-20 | US | Arkansas | Van Buren | 5141 | 307 | 3 | 0 | 304 | 35.58095779 | -92.51295036 | 2020-11-21 05:25:51 | Van Buren, Arkansas, US |
2702034 | 2702034 | 2020-11-20 | US | Arkansas | Washington | 5143 | 14252 | 170 | 0 | 14082 | 35.976844 | -94.21800746 | 2020-11-21 05:25:51 | Washington, Arkansas, US |
2702035 | 2702035 | 2020-11-20 | US | Arkansas | White | 5145 | 2663 | 46 | 0 | 2617 | 35.25688493 | -91.74908296 | 2020-11-21 05:25:51 | White, Arkansas, US |
2702036 | 2702036 | 2020-11-20 | US | Arkansas | Woodruff | 5147 | 181 | 0 | 0 | 181 | 35.18902527 | -91.2439489 | 2020-11-21 05:25:51 | Woodruff, Arkansas, US |
2702037 | 2702037 | 2020-11-20 | US | Arkansas | Yell | 5149 | 1563 | 33 | 0 | 1530 | 35.00292371 | -93.41171338 | 2020-11-21 05:25:51 | Yell, Arkansas, US |
822022 | 822022 | 2020-11-19 | US | Arkansas | Arkansas | 5001 | 881 | 20 | 0 | 861 | 34.29145151 | -91.37277296 | 2020-11-20 05:26:28 | Arkansas, Arkansas, US |
822023 | 822023 | 2020-11-19 | US | Arkansas | Ashley | 5003 | 713 | 13 | 0 | 700 | 33.19153461 | -91.7698471 | 2020-11-20 05:26:28 | Ashley, Arkansas, US |
822024 | 822024 | 2020-11-19 | US | Arkansas | Baxter | 5005 | 1182 | 25 | 0 | 1157 | 36.28784385 | -92.33782872 | 2020-11-20 05:26:28 | Baxter, Arkansas, US |
822025 | 822025 | 2020-11-19 | US | Arkansas | Benton | 5007 | 10747 | 140 | 0 | 10607 | 36.33644656 | -94.25680817 | 2020-11-20 05:26:28 | Benton, Arkansas, US |
822026 | 822026 | 2020-11-19 | US | Arkansas | Boone | 5009 | 1489 | 41 | 0 | 1448 | 36.3084504 | -93.09374925 | 2020-11-20 05:26:28 | Boone, Arkansas, US |
822027 | 822027 | 2020-11-19 | US | Arkansas | Bradley | 5011 | 415 | 8 | 0 | 407 | 33.46755808 | -92.15980837 | 2020-11-20 05:26:28 | Bradley, Arkansas, US |
822028 | 822028 | 2020-11-19 | US | Arkansas | Calhoun | 5013 | 117 | 0 | 0 | 117 | 33.55598792 | -92.49974403 | 2020-11-20 05:26:28 | Calhoun, Arkansas, US |
822029 | 822029 | 2020-11-19 | US | Arkansas | Carroll | 5015 | 1223 | 21 | 0 | 1202 | 36.34038560000001 | -93.54270261 | 2020-11-20 05:26:28 | Carroll, Arkansas, US |
822030 | 822030 | 2020-11-19 | US | Arkansas | Chicot | 5017 | 1111 | 24 | 0 | 1087 | 33.26458973 | -91.29539209 | 2020-11-20 05:26:28 | Chicot, Arkansas, US |
822031 | 822031 | 2020-11-19 | US | Arkansas | Clark | 5019 | 716 | 8 | 0 | 708 | 34.04613432 | -93.17484713 | 2020-11-20 05:26:28 | Clark, Arkansas, US |
822032 | 822032 | 2020-11-19 | US | Arkansas | Clay | 5021 | 742 | 18 | 0 | 724 | 36.36826212 | -90.4148172 | 2020-11-20 05:26:28 | Clay, Arkansas, US |
822033 | 822033 | 2020-11-19 | US | Arkansas | Cleburne | 5023 | 624 | 20 | 0 | 604 | 35.53864922 | -92.02640019 | 2020-11-20 05:26:28 | Cleburne, Arkansas, US |
822034 | 822034 | 2020-11-19 | US | Arkansas | Cleveland | 5025 | 322 | 14 | 0 | 308 | 33.89723187 | -92.18537045 | 2020-11-20 05:26:28 | Cleveland, Arkansas, US |
822035 | 822035 | 2020-11-19 | US | Arkansas | Columbia | 5027 | 929 | 23 | 0 | 906 | 33.21230701 | -93.22642793 | 2020-11-20 05:26:28 | Columbia, Arkansas, US |
822036 | 822036 | 2020-11-19 | US | Arkansas | Conway | 5029 | 554 | 6 | 0 | 548 | 35.26205537 | -92.70506566 | 2020-11-20 05:26:28 | Conway, Arkansas, US |
822037 | 822037 | 2020-11-19 | US | Arkansas | Craighead | 5031 | 6319 | 70 | 0 | 6249 | 35.83018283 | -90.63235729 | 2020-11-20 05:26:28 | Craighead, Arkansas, US |
822038 | 822038 | 2020-11-19 | US | Arkansas | Crawford | 5033 | 2785 | 35 | 0 | 2750 | 35.58928601 | -94.2446814 | 2020-11-20 05:26:28 | Crawford, Arkansas, US |
822039 | 822039 | 2020-11-19 | US | Arkansas | Crittenden | 5035 | 3011 | 55 | 0 | 2956 | 35.21247318 | -90.30839406 | 2020-11-20 05:26:28 | Crittenden, Arkansas, US |
822040 | 822040 | 2020-11-19 | US | Arkansas | Cross | 5037 | 724 | 25 | 0 | 699 | 35.29631396 | -90.77185818 | 2020-11-20 05:26:28 | Cross, Arkansas, US |
822041 | 822041 | 2020-11-19 | US | Arkansas | Dallas | 5039 | 254 | 6 | 0 | 248 | 33.97042763 | -92.65167437 | 2020-11-20 05:26:28 | Dallas, Arkansas, US |
822042 | 822042 | 2020-11-19 | US | Arkansas | Desha | 5041 | 503 | 8 | 0 | 495 | 33.83011025 | -91.25500948 | 2020-11-20 05:26:28 | Desha, Arkansas, US |
822043 | 822043 | 2020-11-19 | US | Arkansas | Drew | 5043 | 545 | 7 | 0 | 538 | 33.59035001 | -91.71777921 | 2020-11-20 05:26:28 | Drew, Arkansas, US |
822044 | 822044 | 2020-11-19 | US | Arkansas | Faulkner | 5045 | 4292 | 49 | 0 | 4243 | 35.14719007 | -92.33717519 | 2020-11-20 05:26:28 | Faulkner, Arkansas, US |
822045 | 822045 | 2020-11-19 | US | Arkansas | Franklin | 5047 | 690 | 7 | 0 | 683 | 35.51202821 | -93.89299569 | 2020-11-20 05:26:28 | Franklin, 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]);