johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where active = 58, country_or_region = "US" and province_or_state = "Kentucky" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3171090 | 3171090 | 2020-11-16 | US | Kentucky | Robertson | 21201 | 60 | 2 | 0 | 58 | 38.51923469 | -84.05055616 | 2020-11-17 05:25:54 | Robertson, Kentucky, US |
1178963 | 1178963 | 2020-10-22 | US | Kentucky | Wolfe | 21237 | 58 | 0 | 0 | 58 | 37.73941626 | -83.49303612 | 2020-10-23 04:24:46 | Wolfe, Kentucky, US |
2192960 | 2192960 | 2020-10-21 | US | Kentucky | Bracken | 21023 | 59 | 1 | 0 | 58 | 38.69158994 | -84.08532444 | 2020-10-22 04:24:27 | Bracken, Kentucky, US |
2193068 | 2193068 | 2020-10-21 | US | Kentucky | Wolfe | 21237 | 58 | 0 | 0 | 58 | 37.73941626 | -83.49303612 | 2020-10-22 04:24:27 | Wolfe, Kentucky, US |
2858315 | 2858315 | 2020-10-16 | US | Kentucky | Wolfe | 21237 | 58 | 0 | 0 | 58 | 37.73941626 | -83.49303612 | 2020-10-17 04:24:12 | Wolfe, Kentucky, US |
787844 | 787844 | 2020-10-15 | US | Kentucky | Wolfe | 21237 | 58 | 0 | 0 | 58 | 37.73941626 | -83.49303612 | 2020-10-16 04:24:01 | Wolfe, Kentucky, US |
3787274 | 3787274 | 2020-10-11 | US | Kentucky | Elliott | 21063 | 58 | 0 | 0 | 58 | 38.11624059 | -83.09771563 | 2020-10-12 04:23:45 | Elliott, Kentucky, US |
2603412 | 2603412 | 2020-10-10 | US | Kentucky | Elliott | 21063 | 58 | 0 | 0 | 58 | 38.11624059 | -83.09771563 | 2020-10-11 04:23:46 | Elliott, Kentucky, US |
1043174 | 1043174 | 2020-10-07 | US | Kentucky | Ballard | 21007 | 59 | 1 | 0 | 58 | 37.05842757 | -88.99427697 | 2020-10-08 04:23:56 | Ballard, Kentucky, US |
3118835 | 3118835 | 2020-10-06 | US | Kentucky | Ballard | 21007 | 59 | 1 | 0 | 58 | 37.05842757 | -88.99427697 | 2020-10-07 04:23:40 | Ballard, Kentucky, US |
3803247 | 3803247 | 2020-10-05 | US | Kentucky | Ballard | 21007 | 59 | 1 | 0 | 58 | 37.05842757 | -88.99427697 | 2020-10-06 04:23:33 | Ballard, Kentucky, US |
2381040 | 2381040 | 2020-10-01 | US | Kentucky | Lawrence | 21127 | 58 | 0 | 0 | 58 | 38.07136018 | -82.72882223 | 2020-10-02 04:23:51 | Lawrence, Kentucky, US |
1516828 | 1516828 | 2020-09-28 | US | Kentucky | Morgan | 21175 | 58 | 0 | 0 | 58 | 37.92465657 | -83.25558245 | 2020-09-29 04:23:42 | Morgan, Kentucky, US |
2583416 | 2583416 | 2020-09-27 | US | Kentucky | Morgan | 21175 | 58 | 0 | 0 | 58 | 37.92465657 | -83.25558245 | 2020-09-28 04:23:00 | Morgan, Kentucky, US |
3317676 | 3317676 | 2020-09-22 | US | Kentucky | Trimble | 21223 | 58 | 0 | 0 | 58 | 38.61056487 | -85.33775972 | 2020-09-23 04:23:00 | Trimble, Kentucky, US |
1123007 | 1123007 | 2020-09-17 | US | Kentucky | Lyon | 21143 | 62 | 4 | 0 | 58 | 37.02080035 | -88.07886257 | 2020-09-18 05:05:00 | Lyon, Kentucky, US |
2172907 | 2172907 | 2020-09-09 | US | Kentucky | Breathitt | 21025 | 58 | 0 | 0 | 58 | 37.52333168 | -83.31959161 | 2020-09-10 04:29:01 | Breathitt, Kentucky, US |
1245116 | 1245116 | 2020-09-08 | US | Kentucky | Breathitt | 21025 | 58 | 0 | 0 | 58 | 37.52333168 | -83.31959161 | 2020-09-09 04:28:48 | Breathitt, Kentucky, US |
3163037 | 3163037 | 2020-09-06 | US | Kentucky | Livingston | 21139 | 59 | 1 | 0 | 58 | 37.21137452 | -88.34797529 | 2020-09-07 04:28:30 | Livingston, Kentucky, US |
814992 | 814992 | 2020-09-05 | US | Kentucky | Livingston | 21139 | 59 | 1 | 0 | 58 | 37.21137452 | -88.34797529 | 2020-09-06 04:28:33 | Livingston, Kentucky, US |
611054 | 611054 | 2020-08-29 | US | Kentucky | Carlisle | 21039 | 59 | 1 | 0 | 58 | 36.85372876 | -88.96692220000001 | 2020-08-30 04:28:22 | Carlisle, Kentucky, US |
1524549 | 1524549 | 2020-08-28 | US | Kentucky | Carlisle | 21039 | 59 | 1 | 0 | 58 | 36.85372876 | -88.96692220000001 | 2020-08-29 04:28:19 | Carlisle, Kentucky, US |
2511550 | 2511550 | 2020-08-27 | US | Kentucky | Carlisle | 21039 | 59 | 1 | 0 | 58 | 36.85372876 | -88.96692220000001 | 2020-08-28 04:28:11 | Carlisle, Kentucky, US |
2217040 | 2217040 | 2020-08-23 | US | Kentucky | Clinton | 21053 | 59 | 1 | 0 | 58 | 36.72581156 | -85.13377529 | 2020-08-24 04:27:56 | Clinton, Kentucky, US |
2217109 | 2217109 | 2020-08-23 | US | Kentucky | Pendleton | 21191 | 58 | 0 | 0 | 58 | 38.69607718 | -84.35599463 | 2020-08-24 04:27:56 | Pendleton, Kentucky, US |
2300822 | 2300822 | 2020-08-22 | US | Kentucky | Clinton | 21053 | 59 | 1 | 0 | 58 | 36.72581156 | -85.13377529 | 2020-08-23 04:27:48 | Clinton, Kentucky, US |
2300891 | 2300891 | 2020-08-22 | US | Kentucky | Pendleton | 21191 | 58 | 0 | 0 | 58 | 38.69607718 | -84.35599463 | 2020-08-23 04:27:48 | Pendleton, Kentucky, US |
839035 | 839035 | 2020-08-17 | US | Kentucky | Mason | 21161 | 59 | 1 | 0 | 58 | 38.59471935 | -83.82151043 | 2020-08-18 04:27:56 | Mason, Kentucky, US |
1557366 | 1557366 | 2020-08-16 | US | Kentucky | Hickman | 21105 | 58 | 0 | 0 | 58 | 36.67948079999999 | -88.97875928 | 2020-08-17 04:27:20 | Hickman, Kentucky, US |
147368 | 147368 | 2020-08-15 | US | Kentucky | Hickman | 21105 | 58 | 0 | 0 | 58 | 36.67948079999999 | -88.97875928 | 2020-08-16 04:27:42 | Hickman, Kentucky, US |
1613701 | 1613701 | 2020-08-14 | US | Kentucky | Trigg | 21221 | 58 | 0 | 0 | 58 | 36.80767017 | -87.87333656 | 2020-08-15 04:27:31 | Trigg, Kentucky, US |
1918851 | 1918851 | 2020-08-10 | US | Kentucky | Metcalfe | 21169 | 60 | 2 | 0 | 58 | 36.99459295 | -85.63123699 | 2020-08-11 04:35:08 | Metcalfe, Kentucky, US |
3921660 | 3921660 | 2020-08-09 | US | Kentucky | Metcalfe | 21169 | 60 | 2 | 0 | 58 | 36.99459295 | -85.63123699 | 2020-08-10 04:34:55 | Metcalfe, Kentucky, US |
368841 | 368841 | 2020-08-08 | US | Kentucky | Fleming | 21069 | 58 | 0 | 0 | 58 | 38.36758311 | -83.69657514 | 2020-08-09 04:34:54 | Fleming, Kentucky, US |
456025 | 456025 | 2020-08-07 | US | Kentucky | Fleming | 21069 | 58 | 0 | 0 | 58 | 38.36758311 | -83.69657514 | 2020-08-08 04:34:53 | Fleming, Kentucky, US |
456742 | 456742 | 2020-08-07 | US | Kentucky | Letcher | 21133 | 58 | 0 | 0 | 58 | 37.12306748 | -82.85346474 | 2020-08-08 04:34:53 | Letcher, Kentucky, US |
3609710 | 3609710 | 2020-08-06 | US | Kentucky | Fleming | 21069 | 58 | 0 | 0 | 58 | 38.36758311 | -83.69657514 | 2020-08-07 04:35:11 | Fleming, Kentucky, US |
3792546 | 3792546 | 2020-08-05 | US | Kentucky | Union | 21225 | 58 | 0 | 0 | 58 | 37.66166713 | -87.94300009 | 2020-08-06 04:35:02 | Union, Kentucky, US |
2805478 | 2805478 | 2020-08-02 | US | Kentucky | Fulton | 21075 | 59 | 1 | 0 | 58 | 36.55238827 | -89.20140068 | 2020-08-03 04:34:35 | Fulton, Kentucky, US |
176244 | 176244 | 2020-07-27 | US | Kentucky | Rowan | 21205 | 58 | 0 | 0 | 58 | 38.19484205 | -83.42088935 | 2020-07-28 04:58:43 | Rowan, Kentucky, US |
2562173 | 2562173 | 2020-07-24 | US | Kentucky | Meade | 21163 | 60 | 2 | 0 | 58 | 37.96163597 | -86.21028219 | 2020-07-25 04:47:39 | Meade, Kentucky, US |
118699 | 118699 | 2020-07-19 | US | Kentucky | Boyle | 21021 | 58 | 0 | 0 | 58 | 37.62680923 | -84.8633779 | 2020-07-20 05:34:40 | Boyle, Kentucky, US |
3202088 | 3202088 | 2020-07-18 | US | Kentucky | Boyle | 21021 | 58 | 0 | 0 | 58 | 37.62680923 | -84.8633779 | 2020-07-19 04:34:58 | Boyle, Kentucky, US |
2707812 | 2707812 | 2020-07-17 | US | Kentucky | Spencer | 21215 | 58 | 0 | 0 | 58 | 38.03223971 | -85.32749335 | 2020-07-18 04:34:45 | Spencer, Kentucky, US |
2747421 | 2747421 | 2020-07-15 | US | Kentucky | Taylor | 21217 | 59 | 1 | 0 | 58 | 37.3677562 | -85.3329931 | 2020-07-16 04:44:59 | Taylor, Kentucky, US |
1003195 | 1003195 | 2020-07-09 | US | Kentucky | Grant | 21081 | 62 | 4 | 0 | 58 | 38.64962758 | -84.62415957 | 2020-07-10 04:34:24 | Grant, Kentucky, US |
2220338 | 2220338 | 2020-07-08 | US | Kentucky | Gallatin | 21077 | 66 | 8 | 0 | 58 | 38.75398691 | -84.8558382 | 2020-07-09 04:34:23 | Gallatin, Kentucky, US |
2221112 | 2221112 | 2020-07-08 | US | Kentucky | Marion | 21155 | 58 | 0 | 0 | 58 | 37.55218078 | -85.26898542 | 2020-07-09 04:34:23 | Marion, Kentucky, US |
2683463 | 2683463 | 2020-07-06 | US | Kentucky | Montgomery | 21173 | 58 | 0 | 0 | 58 | 38.03253032 | -83.9145241 | 2020-07-07 04:34:00 | Montgomery, Kentucky, US |
413764 | 413764 | 2020-07-05 | US | Kentucky | Marshall | 21157 | 60 | 2 | 0 | 58 | 36.88007070000001 | -88.32803576 | 2020-07-06 04:33:57 | Marshall, Kentucky, US |
528327 | 528327 | 2020-07-04 | US | Kentucky | Marshall | 21157 | 60 | 2 | 0 | 58 | 36.88007070000001 | -88.32803576 | 2020-07-05 04:33:46 | Marshall, Kentucky, US |
2232989 | 2232989 | 2020-07-03 | US | Kentucky | Marshall | 21157 | 60 | 2 | 0 | 58 | 36.88007070000001 | -88.32803576 | 2020-07-04 04:33:51 | Marshall, Kentucky, US |
3043785 | 3043785 | 2020-07-02 | US | Kentucky | Marshall | 21157 | 60 | 2 | 0 | 58 | 36.88007070000001 | -88.32803576 | 2020-07-03 04:33:54 | Marshall, Kentucky, US |
300693 | 300693 | 2020-07-01 | US | Kentucky | Gallatin | 21077 | 65 | 7 | 0 | 58 | 38.75398691 | -84.8558382 | 2020-07-02 04:33:46 | Gallatin, Kentucky, US |
2629817 | 2629817 | 2020-06-29 | US | Kentucky | Boyd | 21019 | 61 | 3 | 0 | 58 | 38.36176608 | -82.68652187 | 2020-06-30 04:33:48 | Boyd, Kentucky, US |
2303382 | 2303382 | 2020-06-28 | US | Kentucky | Boyd | 21019 | 61 | 3 | 0 | 58 | 38.36176608 | -82.68652187 | 2020-06-29 04:33:44 | Boyd, Kentucky, US |
2435788 | 2435788 | 2020-06-20 | US | Kentucky | Harrison | 21097 | 58 | 0 | 0 | 58 | 38.44188174 | -84.32869741 | 2020-06-21 04:33:19 | Harrison, Kentucky, US |
3681860 | 3681860 | 2020-06-18 | US | Kentucky | Simpson | 21213 | 61 | 3 | 0 | 58 | 36.74058474 | -86.58047435 | 2020-06-19 04:33:17 | Simpson, Kentucky, US |
3682377 | 3682377 | 2020-06-18 | US | Kentucky | Woodford | 21239 | 58 | 0 | 0 | 58 | 38.04178222 | -84.7417556 | 2020-06-19 04:33:17 | Woodford, Kentucky, US |
1193372 | 1193372 | 2020-06-17 | US | Kentucky | Edmonson | 21061 | 69 | 11 | 0 | 58 | 37.21218923 | -86.23955613 | 2020-06-18 04:33:18 | Edmonson, Kentucky, US |
2797235 | 2797235 | 2020-06-07 | US | Kentucky | Clark | 21049 | 58 | 0 | 0 | 58 | 37.9689263 | -84.14615986 | 2020-06-08 03:33:22 | Clark, Kentucky, US |
2798403 | 2798403 | 2020-06-07 | US | Kentucky | Madison | 21151 | 59 | 1 | 0 | 58 | 37.71659336 | -84.27220275 | 2020-06-08 03:33:22 | Madison, Kentucky, US |
571291 | 571291 | 2020-06-06 | US | Kentucky | Clark | 21049 | 58 | 0 | 0 | 58 | 37.9689263 | -84.14615986 | 2020-06-07 03:53:30 | Clark, Kentucky, US |
572459 | 572459 | 2020-06-06 | US | Kentucky | Madison | 21151 | 59 | 1 | 0 | 58 | 37.71659336 | -84.27220275 | 2020-06-07 03:53:30 | Madison, Kentucky, US |
1266990 | 1266990 | 2020-06-05 | US | Kentucky | Clark | 21049 | 58 | 0 | 0 | 58 | 37.9689263 | -84.14615986 | 2020-06-06 02:33:00 | Clark, Kentucky, US |
1280214 | 1280214 | 2020-06-04 | US | Kentucky | Pulaski | 21199 | 60 | 2 | 0 | 58 | 37.10466131 | -84.57629079 | 2020-06-05 02:33:06 | Pulaski, Kentucky, US |
1430796 | 1430796 | 2020-05-20 | US | Kentucky | Oldham | 21185 | 59 | 1 | 0 | 58 | 38.39791089 | -85.448222 | 2020-05-21 02:32:48 | Oldham, Kentucky, US |
3084368 | 3084368 | 2020-05-04 | US | Kentucky | Unassigned | 90021 | 58 | 0 | 0 | 58 | 38.97065142 | 0.0 | 2020-05-05 02:32:34 | Unassigned, Kentucky, US |
3588907 | 3588907 | 2020-04-27 | US | Kentucky | Unassigned | 90021 | 58 | 0 | 0 | 58 | 38.97065142 | 0.0 | 2020-04-28 02:30:51 | Unassigned, Kentucky, US |
3592090 | 3592090 | 2020-04-26 | US | Kentucky | Unassigned | 90021 | 58 | 0 | 0 | 58 | 38.97065142 | 0.0 | 2020-04-27 02:30:52 | Unassigned, Kentucky, US |
3502439 | 3502439 | 2020-04-25 | US | Kentucky | Unassigned | 90021 | 58 | 0 | 0 | 58 | 38.97065142 | 0.0 | 2020-04-26 02:30:51 | Unassigned, Kentucky, US |
1458841 | 1458841 | 2020-04-24 | US | Kentucky | Unassigned | 90021 | 58 | 0 | 0 | 58 | 38.97065142 | 0.0 | 2020-04-25 06:30:53 | Unassigned, Kentucky, US |
2521883 | 2521883 | 2020-04-23 | US | Kentucky | Adair | 21001 | 63 | 5 | 0 | 58 | 37.10459774 | -85.28129668 | 2020-04-24 03:30:50 | Adair, 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]);