⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

41,331 rows where province_or_state = "Kentucky" sorted by day descending

View and edit SQL

province_or_state

  • Kentucky · 41,331

country_or_region

  • US 41,331
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
954678 2021-03-05 US Kentucky Adair 21001 1618 50 0 1568 37.10459774 -85.28129668 2021-03-06 04:23:41 Adair, Kentucky, US
954679 2021-03-05 US Kentucky Allen 21003 1813 22 0 1791 36.75197631 -86.19457544 2021-03-06 04:23:41 Allen, Kentucky, US
954680 2021-03-05 US Kentucky Anderson 21005 1636 16 0 1620 38.00671029 -84.99171713 2021-03-06 04:23:41 Anderson, Kentucky, US
954681 2021-03-05 US Kentucky Ballard 21007 352 5 0 347 37.05842757 -88.99427697 2021-03-06 04:23:41 Ballard, Kentucky, US
954682 2021-03-05 US Kentucky Barren 21009 4083 71 0 4012 36.96469836 -85.93338945 2021-03-06 04:23:41 Barren, Kentucky, US
954683 2021-03-05 US Kentucky Bath 21011 784 17 0 767 38.14735938 -83.74588932 2021-03-06 04:23:41 Bath, Kentucky, US
954684 2021-03-05 US Kentucky Bell 21013 2787 35 0 2752 36.73355174 -83.67766671 2021-03-06 04:23:41 Bell, Kentucky, US
954685 2021-03-05 US Kentucky Boone 21015 12674 79 0 12595 38.97065142 -84.72615357 2021-03-06 04:23:41 Boone, Kentucky, US
954686 2021-03-05 US Kentucky Bourbon 21017 1563 7 0 1556 38.2054607 -84.21827874 2021-03-06 04:23:41 Bourbon, Kentucky, US
954687 2021-03-05 US Kentucky Boyd 21019 4663 44 0 4619 38.36176608 -82.68652187 2021-03-06 04:23:41 Boyd, Kentucky, US
954688 2021-03-05 US Kentucky Boyle 21021 3164 38 0 3126 37.62680923 -84.8633779 2021-03-06 04:23:41 Boyle, Kentucky, US
954689 2021-03-05 US Kentucky Bracken 21023 528 4 0 524 38.69158994 -84.08532444 2021-03-06 04:23:41 Bracken, Kentucky, US
954690 2021-03-05 US Kentucky Breathitt 21025 929 6 0 923 37.52333168 -83.31959161 2021-03-06 04:23:41 Breathitt, Kentucky, US
954691 2021-03-05 US Kentucky Breckinridge 21027 1112 9 0 1103 37.77377239 -86.42885017 2021-03-06 04:23:41 Breckinridge, Kentucky, US
954692 2021-03-05 US Kentucky Bullitt 21029 6290 49 0 6241 37.97162523 -85.68955617 2021-03-06 04:23:41 Bullitt, Kentucky, US
954693 2021-03-05 US Kentucky Butler 21031 1325 23 0 1302 37.20946153 -86.68748787 2021-03-06 04:23:41 Butler, Kentucky, US
954694 2021-03-05 US Kentucky Caldwell 21033 1366 23 0 1343 37.14749129 -87.86948214 2021-03-06 04:23:41 Caldwell, Kentucky, US
954695 2021-03-05 US Kentucky Calloway 21035 3405 38 0 3367 36.62093411 -88.2731593 2021-03-06 04:23:41 Calloway, Kentucky, US
954696 2021-03-05 US Kentucky Campbell 21037 7861 47 0 7814 38.94384345 -84.37875208 2021-03-06 04:23:41 Campbell, Kentucky, US
954697 2021-03-05 US Kentucky Carlisle 21039 435 4 0 431 36.85372876 -88.96692220000001 2021-03-06 04:23:41 Carlisle, Kentucky, US
954698 2021-03-05 US Kentucky Carroll 21041 897 10 0 887 38.66599534 -85.12601074 2021-03-06 04:23:41 Carroll, Kentucky, US
954699 2021-03-05 US Kentucky Carter 21043 2032 23 0 2009 38.31690743 -83.05092385 2021-03-06 04:23:41 Carter, Kentucky, US
954700 2021-03-05 US Kentucky Casey 21045 1212 33 0 1179 37.32533118 -84.92726209 2021-03-06 04:23:41 Casey, Kentucky, US
954701 2021-03-05 US Kentucky Christian 21047 6249 76 0 6173 36.89267803 -87.49055367 2021-03-06 04:23:41 Christian, Kentucky, US
954702 2021-03-05 US Kentucky Clark 21049 2441 24 0 2417 37.9689263 -84.14615986 2021-03-06 04:23:41 Clark, Kentucky, US
954703 2021-03-05 US Kentucky Clay 21051 2455 26 0 2429 37.16451126 -83.712575 2021-03-06 04:23:41 Clay, Kentucky, US
954704 2021-03-05 US Kentucky Clinton 21053 1372 26 0 1346 36.72581156 -85.13377529 2021-03-06 04:23:41 Clinton, Kentucky, US
954705 2021-03-05 US Kentucky Crittenden 21055 569 17 0 552 37.35839237 -88.08826090000002 2021-03-06 04:23:41 Crittenden, Kentucky, US
954706 2021-03-05 US Kentucky Cumberland 21057 658 8 0 650 36.78926125 -85.39050034 2021-03-06 04:23:41 Cumberland, Kentucky, US
954707 2021-03-05 US Kentucky Daviess 21059 9788 162 0 9626 37.73028906 -87.09019479999998 2021-03-06 04:23:41 Daviess, Kentucky, US
954708 2021-03-05 US Kentucky Edmonson 21061 826 18 0 808 37.21218923 -86.23955613 2021-03-06 04:23:41 Edmonson, Kentucky, US
954709 2021-03-05 US Kentucky Elliott 21063 931 2 0 929 38.11624059 -83.09771563 2021-03-06 04:23:41 Elliott, Kentucky, US
954710 2021-03-05 US Kentucky Estill 21065 982 2 0 980 37.69241417 -83.95956369 2021-03-06 04:23:41 Estill, Kentucky, US
954711 2021-03-05 US Kentucky Fayette 21067 32908 228 0 32680 38.0368225 -84.45576892 2021-03-06 04:23:41 Fayette, Kentucky, US
954712 2021-03-05 US Kentucky Fleming 21069 1086 14 0 1072 38.36758311 -83.69657514 2021-03-06 04:23:41 Fleming, Kentucky, US
954713 2021-03-05 US Kentucky Floyd 21071 3065 44 0 3021 37.56213922 -82.74750924 2021-03-06 04:23:41 Floyd, Kentucky, US
954714 2021-03-05 US Kentucky Franklin 21073 3716 30 0 3686 38.2379395 -84.87962551 2021-03-06 04:23:41 Franklin, Kentucky, US
954715 2021-03-05 US Kentucky Fulton 21075 485 7 0 478 36.55238827 -89.20140068 2021-03-06 04:23:41 Fulton, Kentucky, US
954716 2021-03-05 US Kentucky Gallatin 21077 656 19 0 637 38.75398691 -84.8558382 2021-03-06 04:23:41 Gallatin, Kentucky, US
954717 2021-03-05 US Kentucky Garrard 21079 1408 17 0 1391 37.6388668 -84.53289319 2021-03-06 04:23:41 Garrard, Kentucky, US
954718 2021-03-05 US Kentucky Grant 21081 2091 14 0 2077 38.64962758 -84.62415957 2021-03-06 04:23:41 Grant, Kentucky, US
954719 2021-03-05 US Kentucky Graves 21083 3973 73 0 3900 36.72292505 -88.65143315 2021-03-06 04:23:41 Graves, Kentucky, US
954720 2021-03-05 US Kentucky Grayson 21085 1970 48 0 1922 37.46231118 -86.34248968 2021-03-06 04:23:41 Grayson, Kentucky, US
954721 2021-03-05 US Kentucky Green 21087 1117 13 0 1104 37.26484328 -85.5540745 2021-03-06 04:23:41 Green, Kentucky, US
954722 2021-03-05 US Kentucky Greenup 21089 3342 23 0 3319 38.54332505 -82.9215658 2021-03-06 04:23:41 Greenup, Kentucky, US
954723 2021-03-05 US Kentucky Hancock 21091 806 14 0 792 37.83766422 -86.78280584 2021-03-06 04:23:41 Hancock, Kentucky, US
954724 2021-03-05 US Kentucky Hardin 21093 8932 98 0 8834 37.6976111 -85.96319251 2021-03-06 04:23:41 Hardin, Kentucky, US
954725 2021-03-05 US Kentucky Harlan 21095 2419 70 0 2349 36.85699301 -83.21899516 2021-03-06 04:23:41 Harlan, Kentucky, US
954726 2021-03-05 US Kentucky Harrison 21097 1523 9 0 1514 38.44188174 -84.32869741 2021-03-06 04:23:41 Harrison, Kentucky, US
954727 2021-03-05 US Kentucky Hart 21099 1844 33 0 1811 37.29943898 -85.88461055 2021-03-06 04:23:41 Hart, Kentucky, US
954728 2021-03-05 US Kentucky Henderson 21101 4340 58 0 4282 37.79344553 -87.57392021 2021-03-06 04:23:41 Henderson, Kentucky, US
954729 2021-03-05 US Kentucky Henry 21103 1242 8 0 1234 38.44942688 -85.11587507 2021-03-06 04:23:41 Henry, Kentucky, US
954730 2021-03-05 US Kentucky Hickman 21105 328 7 0 321 36.67948079999999 -88.97875928 2021-03-06 04:23:41 Hickman, Kentucky, US
954731 2021-03-05 US Kentucky Hopkins 21107 3966 126 0 3840 37.30939025 -87.54670406 2021-03-06 04:23:41 Hopkins, Kentucky, US
954732 2021-03-05 US Kentucky Jackson 21109 1215 29 0 1186 37.41866422 -83.99825483 2021-03-06 04:23:41 Jackson, Kentucky, US
954733 2021-03-05 US Kentucky Jefferson 21111 73648 837 0 72811 38.18664655 -85.65931031 2021-03-06 04:23:41 Jefferson, Kentucky, US
954734 2021-03-05 US Kentucky Jessamine 21113 4217 53 0 4164 37.87119786 -84.58252003 2021-03-06 04:23:41 Jessamine, Kentucky, US
954735 2021-03-05 US Kentucky Johnson 21115 1821 18 0 1803 37.85106355 -82.8264322 2021-03-06 04:23:41 Johnson, Kentucky, US
954736 2021-03-05 US Kentucky Kenton 21117 15056 128 0 14928 38.93950319 -84.53241199 2021-03-06 04:23:41 Kenton, Kentucky, US
954737 2021-03-05 US Kentucky Knott 21119 1070 17 0 1053 37.35388197 -82.94981134 2021-03-06 04:23:41 Knott, Kentucky, US
954738 2021-03-05 US Kentucky Knox 21121 2974 11 0 2963 36.89225732 -83.85403396 2021-03-06 04:23:41 Knox, Kentucky, US
954739 2021-03-05 US Kentucky Larue 21123 1230 17 0 1213 37.54567114 -85.70138352 2021-03-06 04:23:41 Larue, Kentucky, US
954740 2021-03-05 US Kentucky Laurel 21125 5911 31 0 5880 37.10975748 -84.11321779 2021-03-06 04:23:41 Laurel, Kentucky, US
954741 2021-03-05 US Kentucky Lawrence 21127 1277 20 0 1257 38.07136018 -82.72882223 2021-03-06 04:23:41 Lawrence, Kentucky, US
954742 2021-03-05 US Kentucky Lee 21129 1203 19 0 1184 37.59645942 -83.71513901 2021-03-06 04:23:41 Lee, Kentucky, US
954743 2021-03-05 US Kentucky Leslie 21131 809 2 0 807 37.09246661 -83.37999606 2021-03-06 04:23:41 Leslie, Kentucky, US
954744 2021-03-05 US Kentucky Letcher 21133 1707 30 0 1677 37.12306748 -82.85346474 2021-03-06 04:23:41 Letcher, Kentucky, US
954745 2021-03-05 US Kentucky Lewis 21135 1100 31 0 1069 38.53184419 -83.37735618 2021-03-06 04:23:41 Lewis, Kentucky, US
954746 2021-03-05 US Kentucky Lincoln 21137 2131 33 0 2098 37.45475628 -84.6565327 2021-03-06 04:23:41 Lincoln, Kentucky, US
954747 2021-03-05 US Kentucky Livingston 21139 770 17 0 753 37.21137452 -88.34797529 2021-03-06 04:23:41 Livingston, Kentucky, US
954748 2021-03-05 US Kentucky Logan 21141 2523 52 0 2471 36.85949479 -86.877635 2021-03-06 04:23:41 Logan, Kentucky, US
954749 2021-03-05 US Kentucky Lyon 21143 879 13 0 866 37.02080035 -88.07886257 2021-03-06 04:23:41 Lyon, Kentucky, US
954750 2021-03-05 US Kentucky Madison 21151 8724 90 0 8634 37.71659336 -84.27220275 2021-03-06 04:23:41 Madison, Kentucky, US
954751 2021-03-05 US Kentucky Magoffin 21153 879 1 0 878 37.70820545 -83.0657714 2021-03-06 04:23:41 Magoffin, Kentucky, US
954752 2021-03-05 US Kentucky Marion 21155 2165 24 0 2141 37.55218078 -85.26898542 2021-03-06 04:23:41 Marion, Kentucky, US
954753 2021-03-05 US Kentucky Marshall 21157 2567 49 0 2518 36.88007070000001 -88.32803576 2021-03-06 04:23:41 Marshall, Kentucky, US
954754 2021-03-05 US Kentucky Martin 21159 945 11 0 934 37.79990579 -82.51247478 2021-03-06 04:23:41 Martin, Kentucky, US
954755 2021-03-05 US Kentucky Mason 21161 1463 27 0 1436 38.59471935 -83.82151043 2021-03-06 04:23:41 Mason, Kentucky, US
954756 2021-03-05 US Kentucky McCracken 21145 5852 72 0 5780 37.05350953 -88.70445755 2021-03-06 04:23:41 McCracken, Kentucky, US
954757 2021-03-05 US Kentucky McCreary 21147 1789 22 0 1767 36.73874143 -84.48102924 2021-03-06 04:23:41 McCreary, Kentucky, US
954758 2021-03-05 US Kentucky McLean 21149 838 25 0 813 37.5301951 -87.26803443 2021-03-06 04:23:41 McLean, Kentucky, US
954759 2021-03-05 US Kentucky Meade 21163 1876 17 0 1859 37.96163597 -86.21028219 2021-03-06 04:23:41 Meade, Kentucky, US
954760 2021-03-05 US Kentucky Menifee 21165 413 13 0 400 37.94090733 -83.59985712 2021-03-06 04:23:41 Menifee, Kentucky, US
954761 2021-03-05 US Kentucky Mercer 21167 2371 33 0 2338 37.81474237 -84.87488475 2021-03-06 04:23:41 Mercer, Kentucky, US
954762 2021-03-05 US Kentucky Metcalfe 21169 976 20 0 956 36.99459295 -85.63123699 2021-03-06 04:23:41 Metcalfe, Kentucky, US
954763 2021-03-05 US Kentucky Monroe 21171 1248 38 0 1210 36.71225341 -85.71596443 2021-03-06 04:23:41 Monroe, Kentucky, US
954764 2021-03-05 US Kentucky Montgomery 21173 2320 24 0 2296 38.03253032 -83.9145241 2021-03-06 04:23:41 Montgomery, Kentucky, US
954765 2021-03-05 US Kentucky Morgan 21175 2038 1 0 2037 37.92465657 -83.25558245 2021-03-06 04:23:41 Morgan, Kentucky, US
954766 2021-03-05 US Kentucky Muhlenberg 21177 2759 49 0 2710 37.21425819 -87.14632053 2021-03-06 04:23:41 Muhlenberg, Kentucky, US
954767 2021-03-05 US Kentucky Nelson 21179 4624 43 0 4581 37.80335779 -85.4657193 2021-03-06 04:23:41 Nelson, Kentucky, US
954768 2021-03-05 US Kentucky Nicholas 21181 466 6 0 460 38.33342292 -84.01889177 2021-03-06 04:23:41 Nicholas, Kentucky, US
954769 2021-03-05 US Kentucky Ohio 21183 2312 47 0 2265 37.47751843 -86.85368087 2021-03-06 04:23:41 Ohio, Kentucky, US
954770 2021-03-05 US Kentucky Oldham 21185 7021 69 0 6952 38.39791089 -85.448222 2021-03-06 04:23:41 Oldham, Kentucky, US
954771 2021-03-05 US Kentucky Owen 21187 623 8 0 615 38.51679143 -84.82404619 2021-03-06 04:23:41 Owen, Kentucky, US
954772 2021-03-05 US Kentucky Owsley 21189 437 10 0 427 37.42823949 -83.68811419 2021-03-06 04:23:41 Owsley, Kentucky, US
954773 2021-03-05 US Kentucky Pendleton 21191 953 1 0 952 38.69607718 -84.35599463 2021-03-06 04:23:41 Pendleton, Kentucky, US
954774 2021-03-05 US Kentucky Perry 21193 2370 39 0 2331 37.25023553 -83.22922731 2021-03-06 04:23:41 Perry, Kentucky, US
954775 2021-03-05 US Kentucky Pike 21195 5198 60 0 5138 37.47088263 -82.39487445 2021-03-06 04:23:41 Pike, Kentucky, US
954776 2021-03-05 US Kentucky Powell 21197 984 3 0 981 37.83218794 -83.82553961 2021-03-06 04:23:41 Powell, Kentucky, US
954777 2021-03-05 US Kentucky Pulaski 21199 5815 81 0 5734 37.10466131 -84.57629079 2021-03-06 04:23:41 Pulaski, Kentucky, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);