johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121,675 rows where province_or_state = "Kentucky" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1480957 | 1480957 | 2020-08-21 | US | Kentucky | Jefferson | 21111 | 10249 | 257 | 0 | 9992 | 38.18664655 | -85.65931031 | 2020-08-22 04:27:49 | Jefferson, Kentucky, US |
191499 | 191499 | 2021-01-11 | US | Kentucky | Mason | 21161 | 1021 | 22 | 0 | 999 | 38.59471935 | -83.82151043 | 2021-01-12 05:22:15 | Mason, Kentucky, US |
1760768 | 1760768 | 2021-01-24 | US | Kentucky | Webster | 21233 | 1013 | 14 | 0 | 999 | 37.52168356 | -87.67989953 | 2021-01-25 05:22:16 | Webster, Kentucky, US |
2691043 | 2691043 | 2020-10-08 | US | Kentucky | Bullitt | 21029 | 1011 | 12 | 0 | 999 | 37.97162523 | -85.68955617 | 2020-10-09 04:23:59 | Bullitt, Kentucky, US |
2691079 | 2691079 | 2020-10-08 | US | Kentucky | Henderson | 21101 | 1005 | 6 | 0 | 999 | 37.79344553 | -87.57392021 | 2020-10-09 04:23:59 | Henderson, Kentucky, US |
3849162 | 3849162 | 2020-12-13 | US | Kentucky | Carter | 21043 | 1004 | 5 | 0 | 999 | 38.31690743 | -83.05092385 | 2020-12-14 05:26:27 | Carter, Kentucky, US |
3880983 | 3880983 | 2021-01-14 | US | Kentucky | Jackson | 21109 | 1021 | 22 | 0 | 999 | 37.41866422 | -83.99825483 | 2021-01-15 05:22:24 | Jackson, Kentucky, US |
3901371 | 3901371 | 2021-01-09 | US | Kentucky | Kenton | 21117 | 10061 | 78 | 0 | 9983 | 38.93950319 | -84.53241199 | 2021-01-10 05:22:12 | Kenton, Kentucky, US |
1677839 | 1677839 | 2021-02-01 | US | Kentucky | Breckinridge | 21027 | 1003 | 5 | 0 | 998 | 37.77377239 | -86.42885017 | 2021-02-02 05:22:49 | Breckinridge, Kentucky, US |
1685869 | 1685869 | 2021-02-02 | US | Kentucky | Breckinridge | 21027 | 1003 | 5 | 0 | 998 | 37.77377239 | -86.42885017 | 2021-02-03 05:22:52 | Breckinridge, Kentucky, US |
2121131 | 2121131 | 2020-12-20 | US | Kentucky | Lee | 21129 | 1016 | 18 | 0 | 998 | 37.59645942 | -83.71513901 | 2020-12-21 05:27:58 | Lee, Kentucky, US |
2932638 | 2932638 | 2020-12-19 | US | Kentucky | Lee | 21129 | 1016 | 18 | 0 | 998 | 37.59645942 | -83.71513901 | 2020-12-20 05:27:32 | Lee, Kentucky, US |
3516872 | 3516872 | 2021-01-15 | US | Kentucky | Washington | 21229 | 1014 | 16 | 0 | 998 | 37.75599461 | -85.17407732 | 2021-01-16 05:22:40 | Washington, Kentucky, US |
3933445 | 3933445 | 2020-08-30 | US | Kentucky | Madison | 21151 | 1001 | 3 | 0 | 998 | 37.71659336 | -84.27220275 | 2020-08-31 04:28:27 | Madison, Kentucky, US |
211680 | 211680 | 2020-10-29 | US | Kentucky | Nelson | 21179 | 1001 | 4 | 0 | 997 | 37.80335779 | -85.4657193 | 2020-10-30 04:24:49 | Nelson, Kentucky, US |
532120 | 532120 | 2021-02-22 | US | Kentucky | Knott | 21119 | 1012 | 15 | 0 | 997 | 37.35388197 | -82.94981134 | 2021-02-23 05:23:41 | Knott, Kentucky, US |
822967 | 822967 | 2020-11-19 | US | Kentucky | Greenup | 21089 | 1009 | 12 | 0 | 997 | 38.54332505 | -82.9215658 | 2020-11-20 05:26:28 | Greenup, Kentucky, US |
929047 | 929047 | 2020-12-21 | US | Kentucky | Allen | 21003 | 1012 | 15 | 0 | 997 | 36.75197631 | -86.19457544 | 2020-12-22 05:22:33 | Allen, Kentucky, US |
1529319 | 1529319 | 2021-02-09 | US | Kentucky | Lewis | 21135 | 1027 | 30 | 0 | 997 | 38.53184419 | -83.37735618 | 2021-02-10 05:22:41 | Lewis, Kentucky, US |
2244835 | 2244835 | 2020-10-30 | US | Kentucky | Pulaski | 21199 | 1010 | 13 | 0 | 997 | 37.10466131 | -84.57629079 | 2020-10-31 04:24:44 | Pulaski, Kentucky, US |
2569080 | 2569080 | 2021-01-25 | US | Kentucky | Larue | 21123 | 1004 | 7 | 0 | 997 | 37.54567114 | -85.70138352 | 2021-01-26 05:22:02 | Larue, Kentucky, US |
2736957 | 2736957 | 2020-08-03 | US | Kentucky | Boone | 21015 | 1021 | 24 | 0 | 997 | 38.97065142 | -84.72615357 | 2020-08-04 04:41:59 | Boone, Kentucky, US |
2881567 | 2881567 | 2020-11-15 | US | Kentucky | Boyd | 21019 | 1020 | 23 | 0 | 997 | 38.36176608 | -82.68652187 | 2020-11-16 05:25:57 | Boyd, Kentucky, US |
3035664 | 3035664 | 2021-01-05 | US | Kentucky | Bourbon | 21017 | 998 | 1 | 0 | 997 | 38.2054607 | -84.21827874 | 2021-01-06 05:22:16 | Bourbon, Kentucky, US |
3309572 | 3309572 | 2021-01-13 | US | Kentucky | Caldwell | 21033 | 1014 | 17 | 0 | 997 | 37.14749129 | -87.86948214 | 2021-01-14 05:22:32 | Caldwell, Kentucky, US |
2192982 | 2192982 | 2020-10-21 | US | Kentucky | Fayette | 21067 | 10048 | 85 | 0 | 9963 | 38.0368225 | -84.45576892 | 2020-10-22 04:24:27 | Fayette, Kentucky, US |
155449 | 155449 | 2021-01-08 | US | Kentucky | Union | 21225 | 1005 | 9 | 0 | 996 | 37.66166713 | -87.94300009 | 2021-01-09 05:22:18 | Union, Kentucky, US |
615110 | 615110 | 2021-02-08 | US | Kentucky | Lewis | 21135 | 1026 | 30 | 0 | 996 | 38.53184419 | -83.37735618 | 2021-02-09 05:23:30 | Lewis, Kentucky, US |
739762 | 739762 | 2020-12-02 | US | Kentucky | Taylor | 21217 | 1003 | 7 | 0 | 996 | 37.3677562 | -85.3329931 | 2020-12-03 05:28:22 | Taylor, Kentucky, US |
909595 | 909595 | 2021-01-19 | US | Kentucky | Lawrence | 21127 | 1001 | 5 | 0 | 996 | 38.07136018 | -82.72882223 | 2021-01-20 05:21:54 | Lawrence, Kentucky, US |
1178922 | 1178922 | 2020-10-22 | US | Kentucky | McCracken | 21145 | 1008 | 12 | 0 | 996 | 37.05350953 | -88.70445755 | 2020-10-23 04:24:46 | McCracken, Kentucky, US |
1902584 | 1902584 | 2020-12-18 | US | Kentucky | Lee | 21129 | 1014 | 18 | 0 | 996 | 37.59645942 | -83.71513901 | 2020-12-19 05:27:52 | Lee, Kentucky, US |
3151003 | 3151003 | 2020-12-16 | US | Kentucky | Johnson | 21115 | 1007 | 11 | 0 | 996 | 37.85106355 | -82.8264322 | 2020-12-17 05:28:12 | Johnson, Kentucky, US |
183454 | 183454 | 2021-02-21 | US | Kentucky | Knott | 21119 | 1010 | 15 | 0 | 995 | 37.35388197 | -82.94981134 | 2021-02-22 05:24:21 | Knott, Kentucky, US |
1007694 | 1007694 | 2020-12-06 | US | Kentucky | Harlan | 21095 | 1010 | 15 | 0 | 995 | 36.85699301 | -83.21899516 | 2020-12-07 05:26:14 | Harlan, Kentucky, US |
1585527 | 1585527 | 2020-11-30 | US | Kentucky | Boyle | 21021 | 995 | 0 | 0 | 995 | 37.62680923 | -84.8633779 | 2020-12-01 05:26:18 | Boyle, Kentucky, US |
2129410 | 2129410 | 2020-12-17 | US | Kentucky | Lee | 21129 | 1012 | 17 | 0 | 995 | 37.59645942 | -83.71513901 | 2020-12-18 05:28:18 | Lee, Kentucky, US |
2627326 | 2627326 | 2021-01-10 | US | Kentucky | Rockcastle | 21203 | 1004 | 9 | 0 | 995 | 37.36642393 | -84.31176452 | 2021-01-11 05:21:50 | Rockcastle, Kentucky, US |
76528 | 76528 | 2020-12-03 | US | Kentucky | Montgomery | 21173 | 1005 | 11 | 0 | 994 | 38.03253032 | -83.9145241 | 2020-12-04 05:27:27 | Montgomery, Kentucky, US |
191438 | 191438 | 2021-01-11 | US | Kentucky | Caldwell | 21033 | 1010 | 16 | 0 | 994 | 37.14749129 | -87.86948214 | 2021-01-12 05:22:15 | Caldwell, Kentucky, US |
211647 | 211647 | 2020-10-29 | US | Kentucky | Jessamine | 21113 | 1006 | 12 | 0 | 994 | 37.87119786 | -84.58252003 | 2020-10-30 04:24:49 | Jessamine, Kentucky, US |
238658 | 238658 | 2021-01-18 | US | Kentucky | Lawrence | 21127 | 999 | 5 | 0 | 994 | 38.07136018 | -82.72882223 | 2021-01-19 05:22:15 | Lawrence, Kentucky, US |
1007689 | 1007689 | 2020-12-06 | US | Kentucky | Grayson | 21085 | 1019 | 25 | 0 | 994 | 37.46231118 | -86.34248968 | 2020-12-07 05:26:14 | Grayson, Kentucky, US |
1685890 | 1685890 | 2021-02-02 | US | Kentucky | Fleming | 21069 | 1006 | 12 | 0 | 994 | 38.36758311 | -83.69657514 | 2021-02-03 05:22:52 | Fleming, Kentucky, US |
1760712 | 1760712 | 2021-01-24 | US | Kentucky | Larue | 21123 | 1001 | 7 | 0 | 994 | 37.54567114 | -85.70138352 | 2021-01-25 05:22:16 | Larue, Kentucky, US |
2348826 | 2348826 | 2020-12-07 | US | Kentucky | Hart | 21099 | 999 | 5 | 0 | 994 | 37.29943898 | -85.88461055 | 2020-12-08 05:27:42 | Hart, Kentucky, US |
2542845 | 2542845 | 2021-01-07 | US | Kentucky | Monroe | 21171 | 1022 | 28 | 0 | 994 | 36.71225341 | -85.71596443 | 2021-01-08 05:22:42 | Monroe, Kentucky, US |
2804709 | 2804709 | 2020-08-02 | US | Kentucky | Boone | 21015 | 1018 | 24 | 0 | 994 | 38.97065142 | -84.72615357 | 2020-08-03 04:34:35 | Boone, Kentucky, US |
3991993 | 3991993 | 2020-10-20 | US | Kentucky | Fayette | 21067 | 10016 | 85 | 0 | 9931 | 38.0368225 | -84.45576892 | 2020-10-21 04:24:14 | Fayette, Kentucky, US |
436762 | 436762 | 2021-01-21 | US | Kentucky | Henry | 21103 | 998 | 5 | 0 | 993 | 38.44942688 | -85.11587507 | 2021-01-22 05:22:10 | Henry, Kentucky, US |
755706 | 755706 | 2020-10-28 | US | Kentucky | Hopkins | 21107 | 1036 | 43 | 0 | 993 | 37.30939025 | -87.54670406 | 2020-10-29 04:24:49 | Hopkins, Kentucky, US |
775717 | 775717 | 2021-01-12 | US | Kentucky | Caldwell | 21033 | 1009 | 16 | 0 | 993 | 37.14749129 | -87.86948214 | 2021-01-13 05:22:15 | Caldwell, Kentucky, US |
866183 | 866183 | 2020-11-12 | US | Kentucky | Knox | 21121 | 1003 | 10 | 0 | 993 | 36.89225732 | -83.85403396 | 2020-11-13 05:25:30 | Knox, Kentucky, US |
1063209 | 1063209 | 2021-01-04 | US | Kentucky | Bourbon | 21017 | 994 | 1 | 0 | 993 | 38.2054607 | -84.21827874 | 2021-01-05 05:21:49 | Bourbon, Kentucky, US |
2428319 | 2428319 | 2021-01-23 | US | Kentucky | Larue | 21123 | 999 | 6 | 0 | 993 | 37.54567114 | -85.70138352 | 2021-01-24 05:22:35 | Larue, Kentucky, US |
2538844 | 2538844 | 2020-12-01 | US | Kentucky | Perry | 21193 | 1004 | 11 | 0 | 993 | 37.25023553 | -83.22922731 | 2020-12-02 05:27:41 | Perry, Kentucky, US |
2850292 | 2850292 | 2020-09-18 | US | Kentucky | Shelby | 21211 | 1018 | 25 | 0 | 993 | 38.21476019 | -85.194223 | 2020-09-19 04:22:00 | Shelby, Kentucky, US |
3901390 | 3901390 | 2021-01-09 | US | Kentucky | Mason | 21161 | 1015 | 22 | 0 | 993 | 38.59471935 | -83.82151043 | 2021-01-10 05:22:12 | Mason, Kentucky, US |
767787 | 767787 | 2020-12-29 | US | Kentucky | Warren | 21227 | 10013 | 84 | 0 | 9929 | 36.99903045 | -86.42672751 | 2020-12-30 05:22:34 | Warren, Kentucky, US |
791805 | 791805 | 2021-02-04 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-05 05:22:38 | Lewis, Kentucky, US |
976340 | 976340 | 2021-02-06 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-07 05:23:00 | Lewis, Kentucky, US |
1589598 | 1589598 | 2021-02-05 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-06 05:23:55 | Lewis, Kentucky, US |
1673879 | 1673879 | 2021-02-07 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-08 05:22:39 | Lewis, Kentucky, US |
2121068 | 2121068 | 2020-12-20 | US | Kentucky | Allen | 21003 | 1007 | 15 | 0 | 992 | 36.75197631 | -86.19457544 | 2020-12-21 05:27:58 | Allen, Kentucky, US |
2428375 | 2428375 | 2021-01-23 | US | Kentucky | Webster | 21233 | 1006 | 14 | 0 | 992 | 37.52168356 | -87.67989953 | 2021-01-24 05:22:35 | Webster, Kentucky, US |
2538839 | 2538839 | 2020-12-01 | US | Kentucky | Ohio | 21183 | 1009 | 17 | 0 | 992 | 37.47751843 | -86.85368087 | 2020-12-02 05:27:41 | Ohio, Kentucky, US |
2627302 | 2627302 | 2021-01-10 | US | Kentucky | Mason | 21161 | 1014 | 22 | 0 | 992 | 38.59471935 | -83.82151043 | 2021-01-11 05:21:50 | Mason, Kentucky, US |
2730373 | 2730373 | 2020-09-15 | US | Kentucky | Christian | 21047 | 1007 | 15 | 0 | 992 | 36.89267803 | -87.49055367 | 2020-09-16 04:22:53 | Christian, Kentucky, US |
2920622 | 2920622 | 2020-11-04 | US | Kentucky | Muhlenberg | 21177 | 1008 | 16 | 0 | 992 | 37.21425819 | -87.14632053 | 2020-11-05 06:05:03 | Muhlenberg, Kentucky, US |
3504775 | 3504775 | 2021-01-17 | US | Kentucky | Lawrence | 21127 | 997 | 5 | 0 | 992 | 38.07136018 | -82.72882223 | 2021-01-18 05:22:34 | Lawrence, Kentucky, US |
273513 | 273513 | 2020-11-10 | US | Kentucky | Bell | 21013 | 1008 | 17 | 0 | 991 | 36.73355174 | -83.67766671 | 2020-11-11 05:25:30 | Bell, Kentucky, US |
341697 | 341697 | 2021-02-03 | US | Kentucky | Lewis | 21135 | 1021 | 30 | 0 | 991 | 38.53184419 | -83.37735618 | 2021-02-04 05:22:26 | Lewis, Kentucky, US |
615086 | 615086 | 2021-02-08 | US | Kentucky | Green | 21087 | 1004 | 13 | 0 | 991 | 37.26484328 | -85.5540745 | 2021-02-09 05:23:30 | Green, Kentucky, US |
909547 | 909547 | 2021-01-19 | US | Kentucky | Butler | 21031 | 1008 | 17 | 0 | 991 | 37.20946153 | -86.68748787 | 2021-01-20 05:21:54 | Butler, Kentucky, US |
976383 | 976383 | 2021-02-06 | US | Kentucky | Trigg | 21221 | 999 | 8 | 0 | 991 | 36.80767017 | -87.87333656 | 2021-02-07 05:23:00 | Trigg, Kentucky, US |
1035833 | 1035833 | 2020-12-15 | US | Kentucky | Simpson | 21213 | 1000 | 9 | 0 | 991 | 36.74058474 | -86.58047435 | 2020-12-16 05:28:04 | Simpson, Kentucky, US |
1589641 | 1589641 | 2021-02-05 | US | Kentucky | Trigg | 21221 | 999 | 8 | 0 | 991 | 36.80767017 | -87.87333656 | 2021-02-06 05:23:55 | Trigg, Kentucky, US |
1633698 | 1633698 | 2020-12-05 | US | Kentucky | Grayson | 21085 | 1016 | 25 | 0 | 991 | 37.46231118 | -86.34248968 | 2020-12-06 05:26:18 | Grayson, Kentucky, US |
1673855 | 1673855 | 2021-02-07 | US | Kentucky | Green | 21087 | 1004 | 13 | 0 | 991 | 37.26484328 | -85.5540745 | 2021-02-08 05:22:39 | Green, Kentucky, US |
1752661 | 1752661 | 2020-12-14 | US | Kentucky | Grant | 21081 | 997 | 6 | 0 | 991 | 38.64962758 | -84.62415957 | 2020-12-15 05:26:38 | Grant, Kentucky, US |
791848 | 791848 | 2021-02-04 | US | Kentucky | Trigg | 21221 | 998 | 8 | 0 | 990 | 36.80767017 | -87.87333656 | 2021-02-05 05:22:38 | Trigg, Kentucky, US |
862132 | 862132 | 2020-12-11 | US | Kentucky | Rowan | 21205 | 992 | 2 | 0 | 990 | 38.19484205 | -83.42088935 | 2020-12-12 05:26:19 | Rowan, Kentucky, US |
976316 | 976316 | 2021-02-06 | US | Kentucky | Green | 21087 | 1003 | 13 | 0 | 990 | 37.26484328 | -85.5540745 | 2021-02-07 05:23:00 | Green, Kentucky, US |
1461127 | 1461127 | 2021-01-31 | US | Kentucky | Breckinridge | 21027 | 995 | 5 | 0 | 990 | 37.77377239 | -86.42885017 | 2021-02-01 05:22:53 | Breckinridge, Kentucky, US |
3309610 | 3309610 | 2021-01-13 | US | Kentucky | Jackson | 21109 | 1012 | 22 | 0 | 990 | 37.41866422 | -83.99825483 | 2021-01-14 05:22:32 | Jackson, Kentucky, US |
3771309 | 3771309 | 2020-12-22 | US | Kentucky | McCreary | 21147 | 991 | 1 | 0 | 990 | 36.73874143 | -84.48102924 | 2020-12-23 05:22:03 | McCreary, Kentucky, US |
3901414 | 3901414 | 2021-01-09 | US | Kentucky | Rockcastle | 21203 | 999 | 9 | 0 | 990 | 37.36642393 | -84.31176452 | 2021-01-10 05:22:12 | Rockcastle, Kentucky, US |
80523 | 80523 | 2020-10-14 | US | Kentucky | Morgan | 21175 | 99 | 0 | 0 | 99 | 37.92465657 | -83.25558245 | 2020-10-15 04:24:28 | Morgan, Kentucky, US |
207608 | 207608 | 2020-08-19 | US | Kentucky | Bourbon | 21017 | 100 | 1 | 0 | 99 | 38.2054607 | -84.21827874 | 2020-08-20 04:27:43 | Bourbon, Kentucky, US |
414487 | 414487 | 2020-07-05 | US | Kentucky | Scott | 21209 | 99 | 0 | 0 | 99 | 38.29622293 | -84.5816631 | 2020-07-06 04:33:57 | Scott, Kentucky, US |
529050 | 529050 | 2020-07-04 | US | Kentucky | Scott | 21209 | 99 | 0 | 0 | 99 | 38.29622293 | -84.5816631 | 2020-07-05 04:33:46 | Scott, Kentucky, US |
570835 | 570835 | 2020-06-06 | US | Kentucky | Allen | 21003 | 102 | 3 | 0 | 99 | 36.75197631 | -86.19457544 | 2020-06-07 03:53:30 | Allen, Kentucky, US |
667651 | 667651 | 2020-09-16 | US | Kentucky | Clinton | 21053 | 101 | 2 | 0 | 99 | 36.72581156 | -85.13377529 | 2020-09-17 04:22:00 | Clinton, Kentucky, US |
667691 | 667691 | 2020-09-16 | US | Kentucky | Letcher | 21133 | 101 | 2 | 0 | 99 | 37.12306748 | -82.85346474 | 2020-09-17 04:22:00 | Letcher, Kentucky, US |
787812 | 787812 | 2020-10-15 | US | Kentucky | Morgan | 21175 | 99 | 0 | 0 | 99 | 37.92465657 | -83.25558245 | 2020-10-16 04:24:01 | Morgan, Kentucky, US |
838995 | 838995 | 2020-08-17 | US | Kentucky | Fulton | 21075 | 101 | 2 | 0 | 99 | 36.55238827 | -89.20140068 | 2020-08-18 04:27:56 | Fulton, Kentucky, US |
893554 | 893554 | 2020-11-05 | US | Kentucky | Menifee | 21165 | 100 | 1 | 0 | 99 | 37.94090733 | -83.59985712 | 2020-11-06 05:24:55 | Menifee, Kentucky, US |
968337 | 968337 | 2020-09-29 | US | Kentucky | Owen | 21187 | 101 | 2 | 0 | 99 | 38.51679143 | -84.82404619 | 2020-09-30 04:23:33 | Owen, Kentucky, US |
1043236 | 1043236 | 2020-10-07 | US | Kentucky | Leslie | 21131 | 99 | 0 | 0 | 99 | 37.09246661 | -83.37999606 | 2020-10-08 04:23:56 | Leslie, Kentucky, US |
1266534 | 1266534 | 2020-06-05 | US | Kentucky | Allen | 21003 | 102 | 3 | 0 | 99 | 36.75197631 | -86.19457544 | 2020-06-06 02:33:00 | Allen, Kentucky, 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]);