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 active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2785460 | 2785460 | 2020-11-13 | US | Arkansas | Benton | 5007 | 10127 | 133 | 0 | 9994 | 36.33644656 | -94.25680817 | 2020-11-14 05:25:37 | Benton, Arkansas, US |
325004 | 325004 | 2020-07-20 | US | Arkansas | Jefferson | 5069 | 1029 | 30 | 0 | 999 | 34.26767081 | -91.92619839 | 2020-07-21 04:38:46 | Jefferson, Arkansas, US |
814060 | 814060 | 2020-09-05 | US | Arkansas | Lee | 5077 | 1010 | 11 | 0 | 999 | 34.78498904 | -90.78383866 | 2020-09-06 04:28:33 | Lee, Arkansas, US |
1173645 | 1173645 | 2020-09-10 | US | Arkansas | Crawford | 5033 | 1009 | 10 | 0 | 999 | 35.58928601 | -94.2446814 | 2020-09-11 04:46:23 | Crawford, Arkansas, US |
2347929 | 2347929 | 2020-12-07 | US | Arkansas | Phillips | 5107 | 1016 | 17 | 0 | 999 | 34.43268455 | -90.84800154 | 2020-12-08 05:27:42 | Phillips, Arkansas, US |
2455248 | 2455248 | 2020-09-19 | US | Arkansas | Independence | 5063 | 1013 | 14 | 0 | 999 | 35.74242707 | -91.57001641 | 2020-09-20 04:22:00 | Independence, Arkansas, US |
2562616 | 2562616 | 2020-07-24 | US | Arkansas | Pope | 5115 | 1004 | 5 | 0 | 999 | 35.44871474 | -93.03212219 | 2020-07-25 04:47:39 | Pope, Arkansas, US |
2931703 | 2931703 | 2020-12-19 | US | Arkansas | Howard | 5061 | 1016 | 17 | 0 | 999 | 34.09007427 | -93.9934871 | 2020-12-20 05:27:32 | Howard, Arkansas, US |
3531961 | 3531961 | 2020-08-12 | US | Arkansas | Sevier | 5133 | 1009 | 10 | 0 | 999 | 33.99780401 | -94.2424869 | 2020-08-13 04:29:15 | Sevier, Arkansas, US |
3652073 | 3652073 | 2020-10-24 | US | Arkansas | Poinsett | 5111 | 1017 | 18 | 0 | 999 | 35.57433534 | -90.66268713 | 2020-10-25 04:24:36 | Poinsett, Arkansas, US |
340752 | 340752 | 2021-02-03 | US | Arkansas | Fulton | 5049 | 1041 | 43 | 0 | 998 | 36.38177105 | -91.81729127 | 2021-02-04 05:22:26 | Fulton, Arkansas, US |
753256 | 753256 | 2020-08-01 | US | Arkansas | Yell | 5149 | 1012 | 14 | 0 | 998 | 35.00292371 | -93.41171338 | 2020-08-02 04:34:47 | Yell, Arkansas, US |
2662260 | 2662260 | 2020-09-04 | US | Arkansas | Lee | 5077 | 1009 | 11 | 0 | 998 | 34.78498904 | -90.78383866 | 2020-09-05 04:28:19 | Lee, Arkansas, US |
3170126 | 3170126 | 2020-11-16 | US | Arkansas | Lawrence | 5075 | 1025 | 27 | 0 | 998 | 36.04188196 | -91.10867198 | 2020-11-17 05:25:54 | Lawrence, Arkansas, US |
2427378 | 2427378 | 2021-01-23 | US | Arkansas | Faulkner | 5045 | 10100 | 124 | 0 | 9976 | 35.14719007 | -92.33717519 | 2021-01-24 05:22:35 | Faulkner, Arkansas, US |
210697 | 210697 | 2020-10-29 | US | Arkansas | Carroll | 5015 | 1014 | 17 | 0 | 997 | 36.34038560000001 | -93.54270261 | 2020-10-30 04:24:49 | Carroll, Arkansas, US |
1460252 | 1460252 | 2021-01-31 | US | Arkansas | Little River | 5081 | 1036 | 39 | 0 | 997 | 33.70375665 | -94.23468591 | 2021-02-01 05:22:53 | Little River, Arkansas, US |
2541879 | 2541879 | 2021-01-07 | US | Arkansas | Desha | 5041 | 1008 | 11 | 0 | 997 | 33.83011025 | -91.25500948 | 2021-01-08 05:22:42 | Desha, Arkansas, US |
3652053 | 3652053 | 2020-10-24 | US | Arkansas | Johnson | 5071 | 1004 | 7 | 0 | 997 | 35.56759135 | -93.46036368 | 2020-10-25 04:24:36 | Johnson, Arkansas, US |
3154119 | 3154119 | 2021-01-27 | US | Arkansas | Saline | 5125 | 10112 | 145 | 0 | 9967 | 34.64916145 | -92.67583224 | 2021-01-28 05:22:24 | Saline, Arkansas, US |
2690187 | 2690187 | 2020-10-08 | US | Arkansas | Pulaski | 5119 | 10130 | 169 | 0 | 9961 | 34.77054088 | -92.31355101 | 2020-10-09 04:23:59 | Pulaski, Arkansas, US |
1006799 | 1006799 | 2020-12-06 | US | Arkansas | Phillips | 5107 | 1013 | 17 | 0 | 996 | 34.43268455 | -90.84800154 | 2020-12-07 05:26:14 | Phillips, Arkansas, US |
1094611 | 1094611 | 2021-01-20 | US | Arkansas | Van Buren | 5141 | 1007 | 11 | 0 | 996 | 35.58095779 | -92.51295036 | 2021-01-21 05:22:01 | Van Buren, Arkansas, US |
1354800 | 1354800 | 2020-09-03 | US | Arkansas | Lee | 5077 | 1007 | 11 | 0 | 996 | 34.78498904 | -90.78383866 | 2020-09-04 04:28:26 | Lee, Arkansas, US |
2291898 | 2291898 | 2020-10-12 | US | Arkansas | Chicot | 5017 | 1018 | 22 | 0 | 996 | 33.26458973 | -91.29539209 | 2020-10-13 04:24:02 | Chicot, Arkansas, US |
2602488 | 2602488 | 2020-10-10 | US | Arkansas | Chicot | 5017 | 1018 | 22 | 0 | 996 | 33.26458973 | -91.29539209 | 2020-10-11 04:23:46 | Chicot, Arkansas, US |
3782358 | 3782358 | 2020-10-13 | US | Arkansas | Chicot | 5017 | 1018 | 22 | 0 | 996 | 33.26458973 | -91.29539209 | 2020-10-14 04:24:05 | Chicot, Arkansas, US |
3786350 | 3786350 | 2020-10-11 | US | Arkansas | Chicot | 5017 | 1018 | 22 | 0 | 996 | 33.26458973 | -91.29539209 | 2020-10-12 04:23:45 | Chicot, Arkansas, US |
1042342 | 1042342 | 2020-10-07 | US | Arkansas | Washington | 5143 | 10072 | 121 | 0 | 9951 | 35.976844 | -94.21800746 | 2020-10-08 04:23:56 | Washington, Arkansas, US |
818021 | 818021 | 2020-10-09 | US | Arkansas | Chicot | 5017 | 1017 | 22 | 0 | 995 | 33.26458973 | -91.29539209 | 2020-10-10 04:23:57 | Chicot, Arkansas, US |
1106037 | 1106037 | 2020-09-02 | US | Arkansas | Lee | 5077 | 1006 | 11 | 0 | 995 | 34.78498904 | -90.78383866 | 2020-09-03 04:28:22 | Lee, Arkansas, US |
2407306 | 2407306 | 2020-12-23 | US | Arkansas | Franklin | 5047 | 1019 | 24 | 0 | 995 | 35.51202821 | -93.89299569 | 2020-12-24 05:23:04 | Franklin, Arkansas, US |
2562964 | 2562964 | 2020-07-24 | US | Arkansas | St. Francis | 5123 | 998 | 3 | 0 | 995 | 35.02201976 | -90.74828138 | 2020-07-25 04:47:39 | St. Francis, Arkansas, US |
3182363 | 3182363 | 2020-07-28 | US | Arkansas | Craighead | 5031 | 1006 | 11 | 0 | 995 | 35.83018283 | -90.63235729 | 2020-07-29 04:35:11 | Craighead, Arkansas, US |
3695957 | 3695957 | 2020-12-31 | US | Arkansas | Craighead | 5031 | 10077 | 136 | 0 | 9941 | 35.83018283 | -90.63235729 | 2021-01-01 05:23:07 | Craighead, Arkansas, US |
8785 | 8785 | 2020-10-25 | US | Arkansas | Boone | 5009 | 1025 | 31 | 0 | 994 | 36.3084504 | -93.09374925 | 2020-10-26 04:25:02 | Boone, Arkansas, US |
1632765 | 1632765 | 2020-12-05 | US | Arkansas | Clay | 5021 | 1017 | 23 | 0 | 994 | 36.36826212 | -90.4148172 | 2020-12-06 05:26:18 | Clay, Arkansas, US |
2120177 | 2120177 | 2020-12-20 | US | Arkansas | Cleburne | 5023 | 1025 | 31 | 0 | 994 | 35.53864922 | -92.02640019 | 2020-12-21 05:27:58 | Cleburne, Arkansas, US |
2690136 | 2690136 | 2020-10-08 | US | Arkansas | Chicot | 5017 | 1016 | 22 | 0 | 994 | 33.26458973 | -91.29539209 | 2020-10-09 04:23:59 | Chicot, Arkansas, US |
2690173 | 2690173 | 2020-10-08 | US | Arkansas | Miller | 5091 | 1005 | 11 | 0 | 994 | 33.31403423 | -93.89285258 | 2020-10-09 04:23:59 | Miller, Arkansas, US |
3920758 | 3920758 | 2020-08-09 | US | Arkansas | Garland | 5051 | 1008 | 14 | 0 | 994 | 34.57692074 | -93.14921604 | 2020-08-10 04:34:55 | Garland, Arkansas, US |
119854 | 119854 | 2020-07-19 | US | Arkansas | Jefferson | 5069 | 1023 | 30 | 0 | 993 | 34.26767081 | -91.92619839 | 2020-07-20 05:34:40 | Jefferson, Arkansas, US |
457609 | 457609 | 2020-08-07 | US | Arkansas | Saline | 5125 | 999 | 6 | 0 | 993 | 34.64916145 | -92.67583224 | 2020-08-08 04:34:53 | Saline, Arkansas, US |
1042278 | 1042278 | 2020-10-07 | US | Arkansas | Chicot | 5017 | 1015 | 22 | 0 | 993 | 33.26458973 | -91.29539209 | 2020-10-08 04:23:56 | Chicot, Arkansas, US |
1350783 | 1350783 | 2020-11-24 | US | Arkansas | Columbia | 5027 | 1017 | 24 | 0 | 993 | 33.21230701 | -93.22642793 | 2020-11-25 05:27:20 | Columbia, Arkansas, US |
2060366 | 2060366 | 2020-09-01 | US | Arkansas | Lee | 5077 | 1004 | 11 | 0 | 993 | 34.78498904 | -90.78383866 | 2020-09-02 04:28:25 | Lee, Arkansas, US |
3770352 | 3770352 | 2020-12-22 | US | Arkansas | Franklin | 5047 | 1017 | 24 | 0 | 993 | 35.51202821 | -93.89299569 | 2020-12-23 05:22:03 | Franklin, Arkansas, US |
59430 | 59430 | 2020-07-23 | US | Arkansas | Faulkner | 5045 | 996 | 4 | 0 | 992 | 35.14719007 | -92.33717519 | 2020-07-24 05:30:40 | Faulkner, Arkansas, US |
194551 | 194551 | 2020-08-31 | US | Arkansas | Lee | 5077 | 1003 | 11 | 0 | 992 | 34.78498904 | -90.78383866 | 2020-09-01 04:28:31 | Lee, Arkansas, US |
1584648 | 1584648 | 2020-11-30 | US | Arkansas | Izard | 5065 | 998 | 6 | 0 | 992 | 36.09604046 | -91.90847954 | 2020-12-01 05:26:18 | Izard, Arkansas, US |
2172010 | 2172010 | 2020-09-09 | US | Arkansas | Crawford | 5033 | 1002 | 10 | 0 | 992 | 35.58928601 | -94.2446814 | 2020-09-10 04:29:01 | Crawford, Arkansas, US |
2212160 | 2212160 | 2021-01-30 | US | Arkansas | Little River | 5081 | 1031 | 39 | 0 | 992 | 33.70375665 | -94.23468591 | 2021-01-31 05:22:42 | Little River, Arkansas, US |
2849328 | 2849328 | 2020-09-18 | US | Arkansas | Lonoke | 5085 | 1001 | 9 | 0 | 992 | 34.75392199 | -91.88742357 | 2020-09-19 04:22:00 | Lonoke, Arkansas, US |
2880694 | 2880694 | 2020-11-15 | US | Arkansas | Lawrence | 5075 | 1018 | 26 | 0 | 992 | 36.04188196 | -91.10867198 | 2020-11-16 05:25:57 | Lawrence, Arkansas, US |
3117939 | 3117939 | 2020-10-06 | US | Arkansas | Chicot | 5017 | 1014 | 22 | 0 | 992 | 33.26458973 | -91.29539209 | 2020-10-07 04:23:40 | Chicot, Arkansas, US |
2467280 | 2467280 | 2021-01-22 | US | Arkansas | Faulkner | 5045 | 10033 | 123 | 0 | 9910 | 35.14719007 | -92.33717519 | 2021-01-23 05:22:03 | Faulkner, Arkansas, US |
3118003 | 3118003 | 2020-10-06 | US | Arkansas | Washington | 5143 | 10030 | 120 | 0 | 9910 | 35.976844 | -94.21800746 | 2020-10-07 04:23:40 | Washington, Arkansas, US |
754759 | 754759 | 2020-10-28 | US | Arkansas | Carroll | 5015 | 1007 | 16 | 0 | 991 | 36.34038560000001 | -93.54270261 | 2020-10-29 04:24:49 | Carroll, Arkansas, US |
1600722 | 1600722 | 2020-12-10 | US | Arkansas | Ouachita | 5103 | 1005 | 14 | 0 | 991 | 33.58839816 | -92.87795984 | 2020-12-11 05:26:59 | Ouachita, Arkansas, US |
1823241 | 1823241 | 2020-10-04 | US | Arkansas | Chicot | 5017 | 1013 | 22 | 0 | 991 | 33.26458973 | -91.29539209 | 2020-10-05 04:23:33 | Chicot, Arkansas, US |
2514625 | 2514625 | 2020-10-03 | US | Arkansas | Chicot | 5017 | 1013 | 22 | 0 | 991 | 33.26458973 | -91.29539209 | 2020-10-04 04:23:44 | Chicot, Arkansas, US |
3389843 | 3389843 | 2020-10-02 | US | Arkansas | Chicot | 5017 | 1013 | 22 | 0 | 991 | 33.26458973 | -91.29539209 | 2020-10-03 04:23:40 | Chicot, Arkansas, US |
3802351 | 3802351 | 2020-10-05 | US | Arkansas | Chicot | 5017 | 1013 | 22 | 0 | 991 | 33.26458973 | -91.29539209 | 2020-10-06 04:23:33 | Chicot, Arkansas, US |
3932510 | 3932510 | 2020-08-30 | US | Arkansas | Lee | 5077 | 1002 | 11 | 0 | 991 | 34.78498904 | -90.78383866 | 2020-08-31 04:28:27 | Lee, Arkansas, US |
610172 | 610172 | 2020-08-29 | US | Arkansas | Lee | 5077 | 1001 | 11 | 0 | 990 | 34.78498904 | -90.78383866 | 2020-08-30 04:28:22 | Lee, Arkansas, US |
1244219 | 1244219 | 2020-09-08 | US | Arkansas | Crawford | 5033 | 1000 | 10 | 0 | 990 | 35.58928601 | -94.2446814 | 2020-09-09 04:28:48 | Crawford, Arkansas, US |
1523667 | 1523667 | 2020-08-28 | US | Arkansas | Lee | 5077 | 1000 | 10 | 0 | 990 | 34.78498904 | -90.78383866 | 2020-08-29 04:28:19 | Lee, Arkansas, US |
2915672 | 2915672 | 2020-11-14 | US | Arkansas | Lawrence | 5075 | 1015 | 25 | 0 | 990 | 36.04188196 | -91.10867198 | 2020-11-15 05:26:53 | Lawrence, Arkansas, US |
3264421 | 3264421 | 2020-07-31 | US | Arkansas | Yell | 5149 | 1004 | 14 | 0 | 990 | 35.00292371 | -93.41171338 | 2020-08-01 04:36:27 | Yell, Arkansas, US |
3567051 | 3567051 | 2020-11-29 | US | Arkansas | Izard | 5065 | 996 | 6 | 0 | 990 | 36.09604046 | -91.90847954 | 2020-11-30 05:26:13 | Izard, Arkansas, US |
3652022 | 3652022 | 2020-10-24 | US | Arkansas | Boone | 5009 | 1020 | 30 | 0 | 990 | 36.3084504 | -93.09374925 | 2020-10-25 04:24:36 | Boone, Arkansas, US |
174299 | 174299 | 2020-07-27 | US | Arkansas | Clay | 5021 | 103 | 4 | 0 | 99 | 36.36826212 | -90.4148172 | 2020-07-28 04:58:43 | Clay, Arkansas, US |
301711 | 301711 | 2020-07-01 | US | Arkansas | Nevada | 5099 | 102 | 3 | 0 | 99 | 33.66340119 | -93.30632432 | 2020-07-02 04:33:46 | Nevada, Arkansas, US |
323877 | 323877 | 2020-07-20 | US | Arkansas | Bradley | 5011 | 101 | 2 | 0 | 99 | 33.46755808 | -92.15980837 | 2020-07-21 04:38:46 | Bradley, Arkansas, US |
527827 | 527827 | 2020-07-04 | US | Arkansas | Howard | 5061 | 100 | 1 | 0 | 99 | 34.09007427 | -93.9934871 | 2020-07-05 04:33:46 | Howard, Arkansas, US |
735889 | 735889 | 2020-06-12 | US | Arkansas | Madison | 5087 | 99 | 0 | 0 | 99 | 36.01038185 | -93.72524943 | 2020-06-13 03:33:14 | Madison, Arkansas, US |
802973 | 802973 | 2020-06-01 | US | Arkansas | Faulkner | 5045 | 102 | 3 | 0 | 99 | 35.14719007 | -92.33717519 | 2020-06-02 02:33:08 | Faulkner, Arkansas, US |
886988 | 886988 | 2020-07-07 | US | Arkansas | White | 5145 | 101 | 2 | 0 | 99 | 35.25688493 | -91.74908296 | 2020-07-08 05:33:48 | White, Arkansas, US |
967387 | 967387 | 2020-09-29 | US | Arkansas | Marion | 5089 | 99 | 0 | 0 | 99 | 36.26844485 | -92.68451899 | 2020-09-30 04:23:33 | Marion, Arkansas, US |
1040420 | 1040420 | 2020-05-26 | US | Arkansas | Saline | 5125 | 100 | 1 | 0 | 99 | 34.64916145 | -92.67583224 | 2020-05-27 02:32:31 | Saline, Arkansas, US |
1134620 | 1134620 | 2020-06-26 | US | Arkansas | Miller | 5091 | 101 | 2 | 0 | 99 | 33.31403423 | -93.89285258 | 2020-06-27 04:33:35 | Miller, Arkansas, US |
1134749 | 1134749 | 2020-06-26 | US | Arkansas | Nevada | 5099 | 101 | 2 | 0 | 99 | 33.66340119 | -93.30632432 | 2020-06-27 04:33:35 | Nevada, Arkansas, US |
1193936 | 1193936 | 2020-06-17 | US | Arkansas | Johnson | 5071 | 99 | 0 | 0 | 99 | 35.56759135 | -93.46036368 | 2020-06-18 04:33:18 | Johnson, Arkansas, US |
1515884 | 1515884 | 2020-09-28 | US | Arkansas | Marion | 5089 | 99 | 0 | 0 | 99 | 36.26844485 | -92.68451899 | 2020-09-29 04:23:42 | Marion, Arkansas, US |
1688578 | 1688578 | 2020-06-19 | US | Arkansas | Carroll | 5015 | 102 | 3 | 0 | 99 | 36.34038560000001 | -93.54270261 | 2020-06-20 04:33:19 | Carroll, Arkansas, US |
1706361 | 1706361 | 2020-07-21 | US | Arkansas | Poinsett | 5111 | 102 | 3 | 0 | 99 | 35.57433534 | -90.66268713 | 2020-07-22 04:34:42 | Poinsett, Arkansas, US |
1788056 | 1788056 | 2020-05-29 | US | Arkansas | Faulkner | 5045 | 102 | 3 | 0 | 99 | 35.14719007 | -92.33717519 | 2020-05-30 02:32:48 | Faulkner, Arkansas, US |
1791619 | 1791619 | 2020-05-31 | US | Arkansas | Faulkner | 5045 | 102 | 3 | 0 | 99 | 35.14719007 | -92.33717519 | 2020-06-01 02:32:46 | Faulkner, Arkansas, US |
1863882 | 1863882 | 2020-05-22 | US | Arkansas | Pope | 5115 | 100 | 1 | 0 | 99 | 35.44871474 | -93.03212219 | 2020-05-23 02:32:42 | Pope, Arkansas, US |
1925459 | 1925459 | 2020-07-30 | US | Arkansas | Clay | 5021 | 103 | 4 | 0 | 99 | 36.36826212 | -90.4148172 | 2020-07-31 04:35:18 | Clay, Arkansas, US |
1925878 | 1925878 | 2020-07-30 | US | Arkansas | Franklin | 5047 | 101 | 2 | 0 | 99 | 35.51202821 | -93.89299569 | 2020-07-31 04:35:18 | Franklin, Arkansas, US |
2038468 | 2038468 | 2020-06-27 | US | Arkansas | Nevada | 5099 | 101 | 2 | 0 | 99 | 33.66340119 | -93.30632432 | 2020-06-28 04:34:04 | Nevada, Arkansas, US |
2305133 | 2305133 | 2020-06-28 | US | Arkansas | Nevada | 5099 | 101 | 2 | 0 | 99 | 33.66340119 | -93.30632432 | 2020-06-29 04:33:44 | Nevada, Arkansas, US |
2614542 | 2614542 | 2020-09-26 | US | Arkansas | Scott | 5127 | 100 | 1 | 0 | 99 | 34.85588887 | -94.0632176 | 2020-09-27 04:23:00 | Scott, Arkansas, US |
2631569 | 2631569 | 2020-06-29 | US | Arkansas | Nevada | 5099 | 101 | 2 | 0 | 99 | 33.66340119 | -93.30632432 | 2020-06-30 04:33:48 | Nevada, Arkansas, US |
2698461 | 2698461 | 2020-06-24 | US | Arkansas | Greene | 5055 | 99 | 0 | 0 | 99 | 36.11735460000001 | -90.55832668 | 2020-06-25 05:26:54 | Greene, Arkansas, US |
2807086 | 2807086 | 2020-08-02 | US | Arkansas | Sharp | 5135 | 104 | 5 | 0 | 99 | 36.16258158 | -91.47819342 | 2020-08-03 04:34:35 | Sharp, Arkansas, US |
2813257 | 2813257 | 2020-09-25 | US | Arkansas | Scott | 5127 | 100 | 1 | 0 | 99 | 34.85588887 | -94.0632176 | 2020-09-26 04:23:00 | Scott, Arkansas, US |
3182247 | 3182247 | 2020-07-28 | US | Arkansas | Clay | 5021 | 103 | 4 | 0 | 99 | 36.36826212 | -90.4148172 | 2020-07-29 04:35:11 | Clay, Arkansas, US |
3295373 | 3295373 | 2020-05-07 | US | Arkansas | Washington | 5143 | 102 | 3 | 0 | 99 | 35.976844 | -94.21800746 | 2020-05-08 02:32:32 | Washington, 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]);