daily_reports (view)
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)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-21 | US | Kentucky | Jefferson | 21111 | 10249 | 257 | 0 | 9992 | 38.18664655 | -85.65931031 | 2020-08-22 04:27:49 | Jefferson, Kentucky, US |
2021-01-11 | US | Kentucky | Mason | 21161 | 1021 | 22 | 0 | 999 | 38.59471935 | -83.82151043 | 2021-01-12 05:22:15 | Mason, Kentucky, US |
2021-01-24 | US | Kentucky | Webster | 21233 | 1013 | 14 | 0 | 999 | 37.52168356 | -87.67989953 | 2021-01-25 05:22:16 | Webster, Kentucky, US |
2020-10-08 | US | Kentucky | Bullitt | 21029 | 1011 | 12 | 0 | 999 | 37.97162523 | -85.68955617 | 2020-10-09 04:23:59 | Bullitt, Kentucky, US |
2020-10-08 | US | Kentucky | Henderson | 21101 | 1005 | 6 | 0 | 999 | 37.79344553 | -87.57392021 | 2020-10-09 04:23:59 | Henderson, Kentucky, US |
2020-12-13 | US | Kentucky | Carter | 21043 | 1004 | 5 | 0 | 999 | 38.31690743 | -83.05092385 | 2020-12-14 05:26:27 | Carter, Kentucky, US |
2021-01-14 | US | Kentucky | Jackson | 21109 | 1021 | 22 | 0 | 999 | 37.41866422 | -83.99825483 | 2021-01-15 05:22:24 | Jackson, Kentucky, US |
2021-01-09 | US | Kentucky | Kenton | 21117 | 10061 | 78 | 0 | 9983 | 38.93950319 | -84.53241199 | 2021-01-10 05:22:12 | Kenton, Kentucky, US |
2021-02-01 | US | Kentucky | Breckinridge | 21027 | 1003 | 5 | 0 | 998 | 37.77377239 | -86.42885017 | 2021-02-02 05:22:49 | Breckinridge, Kentucky, US |
2021-02-02 | US | Kentucky | Breckinridge | 21027 | 1003 | 5 | 0 | 998 | 37.77377239 | -86.42885017 | 2021-02-03 05:22:52 | Breckinridge, Kentucky, US |
2020-12-20 | US | Kentucky | Lee | 21129 | 1016 | 18 | 0 | 998 | 37.59645942 | -83.71513901 | 2020-12-21 05:27:58 | Lee, Kentucky, US |
2020-12-19 | US | Kentucky | Lee | 21129 | 1016 | 18 | 0 | 998 | 37.59645942 | -83.71513901 | 2020-12-20 05:27:32 | Lee, Kentucky, US |
2021-01-15 | US | Kentucky | Washington | 21229 | 1014 | 16 | 0 | 998 | 37.75599461 | -85.17407732 | 2021-01-16 05:22:40 | Washington, Kentucky, US |
2020-08-30 | US | Kentucky | Madison | 21151 | 1001 | 3 | 0 | 998 | 37.71659336 | -84.27220275 | 2020-08-31 04:28:27 | Madison, Kentucky, US |
2020-10-29 | US | Kentucky | Nelson | 21179 | 1001 | 4 | 0 | 997 | 37.80335779 | -85.4657193 | 2020-10-30 04:24:49 | Nelson, Kentucky, US |
2021-02-22 | US | Kentucky | Knott | 21119 | 1012 | 15 | 0 | 997 | 37.35388197 | -82.94981134 | 2021-02-23 05:23:41 | Knott, Kentucky, US |
2020-11-19 | US | Kentucky | Greenup | 21089 | 1009 | 12 | 0 | 997 | 38.54332505 | -82.9215658 | 2020-11-20 05:26:28 | Greenup, Kentucky, US |
2020-12-21 | US | Kentucky | Allen | 21003 | 1012 | 15 | 0 | 997 | 36.75197631 | -86.19457544 | 2020-12-22 05:22:33 | Allen, Kentucky, US |
2021-02-09 | US | Kentucky | Lewis | 21135 | 1027 | 30 | 0 | 997 | 38.53184419 | -83.37735618 | 2021-02-10 05:22:41 | Lewis, Kentucky, US |
2020-10-30 | US | Kentucky | Pulaski | 21199 | 1010 | 13 | 0 | 997 | 37.10466131 | -84.57629079 | 2020-10-31 04:24:44 | Pulaski, Kentucky, US |
2021-01-25 | US | Kentucky | Larue | 21123 | 1004 | 7 | 0 | 997 | 37.54567114 | -85.70138352 | 2021-01-26 05:22:02 | Larue, Kentucky, US |
2020-08-03 | US | Kentucky | Boone | 21015 | 1021 | 24 | 0 | 997 | 38.97065142 | -84.72615357 | 2020-08-04 04:41:59 | Boone, Kentucky, US |
2020-11-15 | US | Kentucky | Boyd | 21019 | 1020 | 23 | 0 | 997 | 38.36176608 | -82.68652187 | 2020-11-16 05:25:57 | Boyd, Kentucky, US |
2021-01-05 | US | Kentucky | Bourbon | 21017 | 998 | 1 | 0 | 997 | 38.2054607 | -84.21827874 | 2021-01-06 05:22:16 | Bourbon, Kentucky, US |
2021-01-13 | US | Kentucky | Caldwell | 21033 | 1014 | 17 | 0 | 997 | 37.14749129 | -87.86948214 | 2021-01-14 05:22:32 | Caldwell, Kentucky, US |
2020-10-21 | US | Kentucky | Fayette | 21067 | 10048 | 85 | 0 | 9963 | 38.0368225 | -84.45576892 | 2020-10-22 04:24:27 | Fayette, Kentucky, US |
2021-01-08 | US | Kentucky | Union | 21225 | 1005 | 9 | 0 | 996 | 37.66166713 | -87.94300009 | 2021-01-09 05:22:18 | Union, Kentucky, US |
2021-02-08 | US | Kentucky | Lewis | 21135 | 1026 | 30 | 0 | 996 | 38.53184419 | -83.37735618 | 2021-02-09 05:23:30 | Lewis, Kentucky, US |
2020-12-02 | US | Kentucky | Taylor | 21217 | 1003 | 7 | 0 | 996 | 37.3677562 | -85.3329931 | 2020-12-03 05:28:22 | Taylor, Kentucky, US |
2021-01-19 | US | Kentucky | Lawrence | 21127 | 1001 | 5 | 0 | 996 | 38.07136018 | -82.72882223 | 2021-01-20 05:21:54 | Lawrence, Kentucky, US |
2020-10-22 | US | Kentucky | McCracken | 21145 | 1008 | 12 | 0 | 996 | 37.05350953 | -88.70445755 | 2020-10-23 04:24:46 | McCracken, Kentucky, US |
2020-12-18 | US | Kentucky | Lee | 21129 | 1014 | 18 | 0 | 996 | 37.59645942 | -83.71513901 | 2020-12-19 05:27:52 | Lee, Kentucky, US |
2020-12-16 | US | Kentucky | Johnson | 21115 | 1007 | 11 | 0 | 996 | 37.85106355 | -82.8264322 | 2020-12-17 05:28:12 | Johnson, Kentucky, US |
2021-02-21 | US | Kentucky | Knott | 21119 | 1010 | 15 | 0 | 995 | 37.35388197 | -82.94981134 | 2021-02-22 05:24:21 | Knott, Kentucky, US |
2020-12-06 | US | Kentucky | Harlan | 21095 | 1010 | 15 | 0 | 995 | 36.85699301 | -83.21899516 | 2020-12-07 05:26:14 | Harlan, Kentucky, US |
2020-11-30 | US | Kentucky | Boyle | 21021 | 995 | 0 | 0 | 995 | 37.62680923 | -84.8633779 | 2020-12-01 05:26:18 | Boyle, Kentucky, US |
2020-12-17 | US | Kentucky | Lee | 21129 | 1012 | 17 | 0 | 995 | 37.59645942 | -83.71513901 | 2020-12-18 05:28:18 | Lee, Kentucky, US |
2021-01-10 | US | Kentucky | Rockcastle | 21203 | 1004 | 9 | 0 | 995 | 37.36642393 | -84.31176452 | 2021-01-11 05:21:50 | Rockcastle, Kentucky, US |
2020-12-03 | US | Kentucky | Montgomery | 21173 | 1005 | 11 | 0 | 994 | 38.03253032 | -83.9145241 | 2020-12-04 05:27:27 | Montgomery, Kentucky, US |
2021-01-11 | US | Kentucky | Caldwell | 21033 | 1010 | 16 | 0 | 994 | 37.14749129 | -87.86948214 | 2021-01-12 05:22:15 | Caldwell, Kentucky, US |
2020-10-29 | US | Kentucky | Jessamine | 21113 | 1006 | 12 | 0 | 994 | 37.87119786 | -84.58252003 | 2020-10-30 04:24:49 | Jessamine, Kentucky, US |
2021-01-18 | US | Kentucky | Lawrence | 21127 | 999 | 5 | 0 | 994 | 38.07136018 | -82.72882223 | 2021-01-19 05:22:15 | Lawrence, Kentucky, US |
2020-12-06 | US | Kentucky | Grayson | 21085 | 1019 | 25 | 0 | 994 | 37.46231118 | -86.34248968 | 2020-12-07 05:26:14 | Grayson, Kentucky, US |
2021-02-02 | US | Kentucky | Fleming | 21069 | 1006 | 12 | 0 | 994 | 38.36758311 | -83.69657514 | 2021-02-03 05:22:52 | Fleming, Kentucky, US |
2021-01-24 | US | Kentucky | Larue | 21123 | 1001 | 7 | 0 | 994 | 37.54567114 | -85.70138352 | 2021-01-25 05:22:16 | Larue, Kentucky, US |
2020-12-07 | US | Kentucky | Hart | 21099 | 999 | 5 | 0 | 994 | 37.29943898 | -85.88461055 | 2020-12-08 05:27:42 | Hart, Kentucky, US |
2021-01-07 | US | Kentucky | Monroe | 21171 | 1022 | 28 | 0 | 994 | 36.71225341 | -85.71596443 | 2021-01-08 05:22:42 | Monroe, Kentucky, US |
2020-08-02 | US | Kentucky | Boone | 21015 | 1018 | 24 | 0 | 994 | 38.97065142 | -84.72615357 | 2020-08-03 04:34:35 | Boone, Kentucky, US |
2020-10-20 | US | Kentucky | Fayette | 21067 | 10016 | 85 | 0 | 9931 | 38.0368225 | -84.45576892 | 2020-10-21 04:24:14 | Fayette, Kentucky, US |
2021-01-21 | US | Kentucky | Henry | 21103 | 998 | 5 | 0 | 993 | 38.44942688 | -85.11587507 | 2021-01-22 05:22:10 | Henry, Kentucky, US |
2020-10-28 | US | Kentucky | Hopkins | 21107 | 1036 | 43 | 0 | 993 | 37.30939025 | -87.54670406 | 2020-10-29 04:24:49 | Hopkins, Kentucky, US |
2021-01-12 | US | Kentucky | Caldwell | 21033 | 1009 | 16 | 0 | 993 | 37.14749129 | -87.86948214 | 2021-01-13 05:22:15 | Caldwell, Kentucky, US |
2020-11-12 | US | Kentucky | Knox | 21121 | 1003 | 10 | 0 | 993 | 36.89225732 | -83.85403396 | 2020-11-13 05:25:30 | Knox, Kentucky, US |
2021-01-04 | US | Kentucky | Bourbon | 21017 | 994 | 1 | 0 | 993 | 38.2054607 | -84.21827874 | 2021-01-05 05:21:49 | Bourbon, Kentucky, US |
2021-01-23 | US | Kentucky | Larue | 21123 | 999 | 6 | 0 | 993 | 37.54567114 | -85.70138352 | 2021-01-24 05:22:35 | Larue, Kentucky, US |
2020-12-01 | US | Kentucky | Perry | 21193 | 1004 | 11 | 0 | 993 | 37.25023553 | -83.22922731 | 2020-12-02 05:27:41 | Perry, Kentucky, US |
2020-09-18 | US | Kentucky | Shelby | 21211 | 1018 | 25 | 0 | 993 | 38.21476019 | -85.194223 | 2020-09-19 04:22:00 | Shelby, Kentucky, US |
2021-01-09 | US | Kentucky | Mason | 21161 | 1015 | 22 | 0 | 993 | 38.59471935 | -83.82151043 | 2021-01-10 05:22:12 | Mason, Kentucky, US |
2020-12-29 | US | Kentucky | Warren | 21227 | 10013 | 84 | 0 | 9929 | 36.99903045 | -86.42672751 | 2020-12-30 05:22:34 | Warren, Kentucky, US |
2021-02-04 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-05 05:22:38 | Lewis, Kentucky, US |
2021-02-06 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-07 05:23:00 | Lewis, Kentucky, US |
2021-02-05 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-06 05:23:55 | Lewis, Kentucky, US |
2021-02-07 | US | Kentucky | Lewis | 21135 | 1022 | 30 | 0 | 992 | 38.53184419 | -83.37735618 | 2021-02-08 05:22:39 | Lewis, Kentucky, US |
2020-12-20 | US | Kentucky | Allen | 21003 | 1007 | 15 | 0 | 992 | 36.75197631 | -86.19457544 | 2020-12-21 05:27:58 | Allen, Kentucky, US |
2021-01-23 | US | Kentucky | Webster | 21233 | 1006 | 14 | 0 | 992 | 37.52168356 | -87.67989953 | 2021-01-24 05:22:35 | Webster, Kentucky, US |
2020-12-01 | US | Kentucky | Ohio | 21183 | 1009 | 17 | 0 | 992 | 37.47751843 | -86.85368087 | 2020-12-02 05:27:41 | Ohio, Kentucky, US |
2021-01-10 | US | Kentucky | Mason | 21161 | 1014 | 22 | 0 | 992 | 38.59471935 | -83.82151043 | 2021-01-11 05:21:50 | Mason, Kentucky, US |
2020-09-15 | US | Kentucky | Christian | 21047 | 1007 | 15 | 0 | 992 | 36.89267803 | -87.49055367 | 2020-09-16 04:22:53 | Christian, Kentucky, US |
2020-11-04 | US | Kentucky | Muhlenberg | 21177 | 1008 | 16 | 0 | 992 | 37.21425819 | -87.14632053 | 2020-11-05 06:05:03 | Muhlenberg, Kentucky, US |
2021-01-17 | US | Kentucky | Lawrence | 21127 | 997 | 5 | 0 | 992 | 38.07136018 | -82.72882223 | 2021-01-18 05:22:34 | Lawrence, Kentucky, US |
2020-11-10 | US | Kentucky | Bell | 21013 | 1008 | 17 | 0 | 991 | 36.73355174 | -83.67766671 | 2020-11-11 05:25:30 | Bell, Kentucky, US |
2021-02-03 | US | Kentucky | Lewis | 21135 | 1021 | 30 | 0 | 991 | 38.53184419 | -83.37735618 | 2021-02-04 05:22:26 | Lewis, Kentucky, US |
2021-02-08 | US | Kentucky | Green | 21087 | 1004 | 13 | 0 | 991 | 37.26484328 | -85.5540745 | 2021-02-09 05:23:30 | Green, Kentucky, US |
2021-01-19 | US | Kentucky | Butler | 21031 | 1008 | 17 | 0 | 991 | 37.20946153 | -86.68748787 | 2021-01-20 05:21:54 | Butler, Kentucky, US |
2021-02-06 | US | Kentucky | Trigg | 21221 | 999 | 8 | 0 | 991 | 36.80767017 | -87.87333656 | 2021-02-07 05:23:00 | Trigg, Kentucky, US |
2020-12-15 | US | Kentucky | Simpson | 21213 | 1000 | 9 | 0 | 991 | 36.74058474 | -86.58047435 | 2020-12-16 05:28:04 | Simpson, Kentucky, US |
2021-02-05 | US | Kentucky | Trigg | 21221 | 999 | 8 | 0 | 991 | 36.80767017 | -87.87333656 | 2021-02-06 05:23:55 | Trigg, Kentucky, US |
2020-12-05 | US | Kentucky | Grayson | 21085 | 1016 | 25 | 0 | 991 | 37.46231118 | -86.34248968 | 2020-12-06 05:26:18 | Grayson, Kentucky, US |
2021-02-07 | US | Kentucky | Green | 21087 | 1004 | 13 | 0 | 991 | 37.26484328 | -85.5540745 | 2021-02-08 05:22:39 | Green, Kentucky, US |
2020-12-14 | US | Kentucky | Grant | 21081 | 997 | 6 | 0 | 991 | 38.64962758 | -84.62415957 | 2020-12-15 05:26:38 | Grant, Kentucky, US |
2021-02-04 | US | Kentucky | Trigg | 21221 | 998 | 8 | 0 | 990 | 36.80767017 | -87.87333656 | 2021-02-05 05:22:38 | Trigg, Kentucky, US |
2020-12-11 | US | Kentucky | Rowan | 21205 | 992 | 2 | 0 | 990 | 38.19484205 | -83.42088935 | 2020-12-12 05:26:19 | Rowan, Kentucky, US |
2021-02-06 | US | Kentucky | Green | 21087 | 1003 | 13 | 0 | 990 | 37.26484328 | -85.5540745 | 2021-02-07 05:23:00 | Green, Kentucky, US |
2021-01-31 | US | Kentucky | Breckinridge | 21027 | 995 | 5 | 0 | 990 | 37.77377239 | -86.42885017 | 2021-02-01 05:22:53 | Breckinridge, Kentucky, US |
2021-01-13 | US | Kentucky | Jackson | 21109 | 1012 | 22 | 0 | 990 | 37.41866422 | -83.99825483 | 2021-01-14 05:22:32 | Jackson, Kentucky, US |
2020-12-22 | US | Kentucky | McCreary | 21147 | 991 | 1 | 0 | 990 | 36.73874143 | -84.48102924 | 2020-12-23 05:22:03 | McCreary, Kentucky, US |
2021-01-09 | US | Kentucky | Rockcastle | 21203 | 999 | 9 | 0 | 990 | 37.36642393 | -84.31176452 | 2021-01-10 05:22:12 | Rockcastle, Kentucky, US |
2020-10-14 | US | Kentucky | Morgan | 21175 | 99 | 0 | 0 | 99 | 37.92465657 | -83.25558245 | 2020-10-15 04:24:28 | Morgan, Kentucky, US |
2020-08-19 | US | Kentucky | Bourbon | 21017 | 100 | 1 | 0 | 99 | 38.2054607 | -84.21827874 | 2020-08-20 04:27:43 | Bourbon, Kentucky, US |
2020-07-05 | US | Kentucky | Scott | 21209 | 99 | 0 | 0 | 99 | 38.29622293 | -84.5816631 | 2020-07-06 04:33:57 | Scott, Kentucky, US |
2020-07-04 | US | Kentucky | Scott | 21209 | 99 | 0 | 0 | 99 | 38.29622293 | -84.5816631 | 2020-07-05 04:33:46 | Scott, Kentucky, US |
2020-06-06 | US | Kentucky | Allen | 21003 | 102 | 3 | 0 | 99 | 36.75197631 | -86.19457544 | 2020-06-07 03:53:30 | Allen, Kentucky, US |
2020-09-16 | US | Kentucky | Clinton | 21053 | 101 | 2 | 0 | 99 | 36.72581156 | -85.13377529 | 2020-09-17 04:22:00 | Clinton, Kentucky, US |
2020-09-16 | US | Kentucky | Letcher | 21133 | 101 | 2 | 0 | 99 | 37.12306748 | -82.85346474 | 2020-09-17 04:22:00 | Letcher, Kentucky, US |
2020-10-15 | US | Kentucky | Morgan | 21175 | 99 | 0 | 0 | 99 | 37.92465657 | -83.25558245 | 2020-10-16 04:24:01 | Morgan, Kentucky, US |
2020-08-17 | US | Kentucky | Fulton | 21075 | 101 | 2 | 0 | 99 | 36.55238827 | -89.20140068 | 2020-08-18 04:27:56 | Fulton, Kentucky, US |
2020-11-05 | US | Kentucky | Menifee | 21165 | 100 | 1 | 0 | 99 | 37.94090733 | -83.59985712 | 2020-11-06 05:24:55 | Menifee, Kentucky, US |
2020-09-29 | US | Kentucky | Owen | 21187 | 101 | 2 | 0 | 99 | 38.51679143 | -84.82404619 | 2020-09-30 04:23:33 | Owen, Kentucky, US |
2020-10-07 | US | Kentucky | Leslie | 21131 | 99 | 0 | 0 | 99 | 37.09246661 | -83.37999606 | 2020-10-08 04:23:56 | Leslie, Kentucky, US |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;