johns_hopkins_csse_daily_reports

⚠️ 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

16,042 rows where province_or_state = "Kentucky" sorted by day descending

View and edit SQL

province_or_state

  • Kentucky · 16,042

country_or_region

  • US 16,042
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391087 2020-08-08 US Kentucky Adair 21001 203 19 0 184 37.10459774 -85.28129668 2020-08-09 04:34:54 Adair, Kentucky, US
391135 2020-08-08 US Kentucky Allen 21003 226 8 0 218 36.75197631 -86.19457544 2020-08-09 04:34:54 Allen, Kentucky, US
391148 2020-08-08 US Kentucky Anderson 21005 83 1 0 82 38.00671029 -84.99171713 2020-08-09 04:34:54 Anderson, Kentucky, US
391211 2020-08-08 US Kentucky Ballard 21007 36 0 0 36 37.05842757 -88.99427697 2020-08-09 04:34:54 Ballard, Kentucky, US
391228 2020-08-08 US Kentucky Barren 21009 362 2 0 360 36.96469836 -85.93338945 2020-08-09 04:34:54 Barren, Kentucky, US
391239 2020-08-08 US Kentucky Bath 21011 37 1 0 36 38.14735938 -83.74588932 2020-08-09 04:34:54 Bath, Kentucky, US
391263 2020-08-08 US Kentucky Bell 21013 312 4 0 308 36.73355174 -83.67766671 2020-08-09 04:34:54 Bell, Kentucky, US
391328 2020-08-08 US Kentucky Boone 21015 1097 24 0 1073 38.97065142 -84.72615357 2020-08-09 04:34:54 Boone, Kentucky, US
391340 2020-08-08 US Kentucky Bourbon 21017 78 1 0 77 38.2054607 -84.21827874 2020-08-09 04:34:54 Bourbon, Kentucky, US
391344 2020-08-08 US Kentucky Boyd 21019 190 3 0 187 38.36176608 -82.68652187 2020-08-09 04:34:54 Boyd, Kentucky, US
391346 2020-08-08 US Kentucky Boyle 21021 155 0 0 155 37.62680923 -84.8633779 2020-08-09 04:34:54 Boyle, Kentucky, US
391347 2020-08-08 US Kentucky Bracken 21023 33 0 0 33 38.69158994 -84.08532444 2020-08-09 04:34:54 Bracken, Kentucky, US
391357 2020-08-08 US Kentucky Breathitt 21025 28 0 0 28 37.52333168 -83.31959161 2020-08-09 04:34:54 Breathitt, Kentucky, US
391358 2020-08-08 US Kentucky Breckinridge 21027 67 2 0 65 37.77377239 -86.42885017 2020-08-09 04:34:54 Breckinridge, Kentucky, US
391399 2020-08-08 US Kentucky Bullitt 21029 363 5 0 358 37.97162523 -85.68955617 2020-08-09 04:34:54 Bullitt, Kentucky, US
391416 2020-08-08 US Kentucky Butler 21031 294 15 0 279 37.20946153 -86.68748787 2020-08-09 04:34:54 Butler, Kentucky, US
391432 2020-08-08 US Kentucky Caldwell 21033 52 0 0 52 37.14749129 -87.86948214 2020-08-09 04:34:54 Caldwell, Kentucky, US
391451 2020-08-08 US Kentucky Calloway 21035 230 4 0 226 36.62093411 -88.2731593 2020-08-09 04:34:54 Calloway, Kentucky, US
391464 2020-08-08 US Kentucky Campbell 21037 567 13 0 554 38.94384345 -84.37875208 2020-08-09 04:34:54 Campbell, Kentucky, US
391481 2020-08-08 US Kentucky Carlisle 21039 42 1 0 41 36.85372876 -88.96692220000001 2020-08-09 04:34:54 Carlisle, Kentucky, US
391491 2020-08-08 US Kentucky Carroll 21041 158 2 0 156 38.66599534 -85.12601074 2020-08-09 04:34:54 Carroll, Kentucky, US
391501 2020-08-08 US Kentucky Carter 21043 101 1 0 100 38.31690743 -83.05092385 2020-08-09 04:34:54 Carter, Kentucky, US
391508 2020-08-08 US Kentucky Casey 21045 175 10 0 165 37.32533118 -84.92726209 2020-08-09 04:34:54 Casey, Kentucky, US
391602 2020-08-08 US Kentucky Christian 21047 500 8 0 492 36.89267803 -87.49055367 2020-08-09 04:34:54 Christian, Kentucky, US
391623 2020-08-08 US Kentucky Clark 21049 166 7 0 159 37.9689263 -84.14615986 2020-08-09 04:34:54 Clark, Kentucky, US
391644 2020-08-08 US Kentucky Clay 21051 150 5 0 145 37.16451126 -83.712575 2020-08-09 04:34:54 Clay, Kentucky, US
391670 2020-08-08 US Kentucky Clinton 21053 29 1 0 28 36.72581156 -85.13377529 2020-08-09 04:34:54 Clinton, Kentucky, US
391771 2020-08-08 US Kentucky Crittenden 21055 30 1 0 29 37.35839237 -88.08826090000002 2020-08-09 04:34:54 Crittenden, Kentucky, US
391785 2020-08-08 US Kentucky Cumberland 21057 49 0 0 49 36.78926125 -85.39050034 2020-08-09 04:34:54 Cumberland, Kentucky, US
391825 2020-08-08 US Kentucky Daviess 21059 765 9 0 756 37.73028906 -87.09019479999998 2020-08-09 04:34:54 Daviess, Kentucky, US
391950 2020-08-08 US Kentucky Edmonson 21061 101 12 0 89 37.21218923 -86.23955613 2020-08-09 04:34:54 Edmonson, Kentucky, US
391966 2020-08-08 US Kentucky Elliott 21063 11 0 0 11 38.11624059 -83.09771563 2020-08-09 04:34:54 Elliott, Kentucky, US
391990 2020-08-08 US Kentucky Estill 21065 21 0 0 21 37.69241417 -83.95956369 2020-08-09 04:34:54 Estill, Kentucky, US
392017 2020-08-08 US Kentucky Fayette 21067 3071 47 0 3024 38.0368225 -84.45576892 2020-08-09 04:34:54 Fayette, Kentucky, US
392033 2020-08-08 US Kentucky Fleming 21069 58 0 0 58 38.36758311 -83.69657514 2020-08-09 04:34:54 Fleming, Kentucky, US
392040 2020-08-08 US Kentucky Floyd 21071 94 2 0 92 37.56213922 -82.74750924 2020-08-09 04:34:54 Floyd, Kentucky, US
392065 2020-08-08 US Kentucky Franklin 21073 296 7 0 289 38.2379395 -84.87962551 2020-08-09 04:34:54 Franklin, Kentucky, US
392098 2020-08-08 US Kentucky Fulton 21075 79 2 0 77 36.55238827 -89.20140068 2020-08-09 04:34:54 Fulton, Kentucky, US
392108 2020-08-08 US Kentucky Gallatin 21077 79 7 0 72 38.75398691 -84.8558382 2020-08-09 04:34:54 Gallatin, Kentucky, US
392119 2020-08-08 US Kentucky Garrard 21079 75 0 0 75 37.638866799999995 -84.53289319 2020-08-09 04:34:54 Garrard, Kentucky, US
392182 2020-08-08 US Kentucky Grant 21081 115 5 0 110 38.64962758 -84.62415957 2020-08-09 04:34:54 Grant, Kentucky, US
392196 2020-08-08 US Kentucky Graves 21083 558 24 0 534 36.72292505 -88.65143315 2020-08-09 04:34:54 Graves, Kentucky, US
392200 2020-08-08 US Kentucky Grayson 21085 197 11 0 186 37.46231118 -86.34248968 2020-08-09 04:34:54 Grayson, Kentucky, US
392205 2020-08-08 US Kentucky Green 21087 31 2 0 29 37.26484328 -85.5540745 2020-08-09 04:34:54 Green, Kentucky, US
392225 2020-08-08 US Kentucky Greenup 21089 110 1 0 109 38.54332505 -82.9215658 2020-08-09 04:34:54 Greenup, Kentucky, US
392283 2020-08-08 US Kentucky Hancock 21091 50 0 0 50 37.83766422 -86.78280584 2020-08-09 04:34:54 Hancock, Kentucky, US
392299 2020-08-08 US Kentucky Hardin 21093 604 8 0 596 37.6976111 -85.96319251 2020-08-09 04:34:54 Hardin, Kentucky, US
392306 2020-08-08 US Kentucky Harlan 21095 231 3 0 228 36.85699301 -83.21899516 2020-08-09 04:34:54 Harlan, Kentucky, US
392317 2020-08-08 US Kentucky Harrison 21097 121 0 0 121 38.44188174 -84.32869741 2020-08-09 04:34:54 Harrison, Kentucky, US
392325 2020-08-08 US Kentucky Hart 21099 96 0 0 96 37.29943898 -85.88461055 2020-08-09 04:34:54 Hart, Kentucky, US
392343 2020-08-08 US Kentucky Henderson 21101 343 3 0 340 37.79344553 -87.57392021 2020-08-09 04:34:54 Henderson, Kentucky, US
392356 2020-08-08 US Kentucky Henry 21103 121 2 0 119 38.44942688 -85.11587507 2020-08-09 04:34:54 Henry, Kentucky, US
392365 2020-08-08 US Kentucky Hickman 21105 42 0 0 42 36.67948079999999 -88.97875928 2020-08-09 04:34:54 Hickman, Kentucky, US
392395 2020-08-08 US Kentucky Hopkins 21107 421 33 0 388 37.30939025 -87.54670406 2020-08-09 04:34:54 Hopkins, Kentucky, US
392477 2020-08-08 US Kentucky Jackson 21109 150 14 0 136 37.41866422 -83.99825483 2020-08-09 04:34:54 Jackson, Kentucky, US
392515 2020-08-08 US Kentucky Jefferson 21111 7984 237 0 7747 38.18664655 -85.65931031 2020-08-09 04:34:54 Jefferson, Kentucky, US
392538 2020-08-08 US Kentucky Jessamine 21113 340 0 0 340 37.87119786 -84.58252003 2020-08-09 04:34:54 Jessamine, Kentucky, US
392549 2020-08-08 US Kentucky Johnson 21115 50 0 0 50 37.85106355 -82.8264322 2020-08-09 04:34:54 Johnson, Kentucky, US
392597 2020-08-08 US Kentucky Kenton 21117 1402 41 0 1361 38.93950319 -84.53241199 2020-08-09 04:34:54 Kenton, Kentucky, US
392628 2020-08-08 US Kentucky Knott 21119 54 1 0 53 37.35388197 -82.94981134 2020-08-09 04:34:54 Knott, Kentucky, US
392631 2020-08-08 US Kentucky Knox 21121 232 8 0 224 36.89225732 -83.85403396 2020-08-09 04:34:54 Knox, Kentucky, US
392698 2020-08-08 US Kentucky Larue 21123 55 1 0 54 37.54567114 -85.70138352 2020-08-09 04:34:54 Larue, Kentucky, US
392708 2020-08-08 US Kentucky Laurel 21125 432 5 0 427 37.10975748 -84.11321779 2020-08-09 04:34:54 Laurel, Kentucky, US
392716 2020-08-08 US Kentucky Lawrence 21127 36 0 0 36 38.07136018 -82.72882223 2020-08-09 04:34:54 Lawrence, Kentucky, US
392735 2020-08-08 US Kentucky Lee 21129 7 0 0 7 37.59645942 -83.71513901 2020-08-09 04:34:54 Lee, Kentucky, US
392749 2020-08-08 US Kentucky Leslie 21131 30 0 0 30 37.09246661 -83.37999606 2020-08-09 04:34:54 Leslie, Kentucky, US
392750 2020-08-08 US Kentucky Letcher 21133 60 0 0 60 37.12306748 -82.85346474 2020-08-09 04:34:54 Letcher, Kentucky, US
392752 2020-08-08 US Kentucky Lewis 21135 40 0 0 40 38.53184419 -83.37735618 2020-08-09 04:34:54 Lewis, Kentucky, US
392773 2020-08-08 US Kentucky Lincoln 21137 102 1 0 101 37.45475628 -84.6565327 2020-08-09 04:34:54 Lincoln, Kentucky, US
392801 2020-08-08 US Kentucky Livingston 21139 33 1 0 32 37.21137452 -88.34797529 2020-08-09 04:34:54 Livingston, Kentucky, US
392811 2020-08-08 US Kentucky Logan 21141 327 23 0 304 36.85949479 -86.877635 2020-08-09 04:34:54 Logan, Kentucky, US
392848 2020-08-08 US Kentucky Lyon 21143 33 4 0 29 37.02080035 -88.07886257 2020-08-09 04:34:54 Lyon, Kentucky, US
392869 2020-08-08 US Kentucky Madison 21151 492 1 0 491 37.71659336 -84.27220275 2020-08-09 04:34:54 Madison, Kentucky, US
392881 2020-08-08 US Kentucky Magoffin 21153 39 0 0 39 37.70820545 -83.0657714 2020-08-09 04:34:54 Magoffin, Kentucky, US
392908 2020-08-08 US Kentucky Marion 21155 121 0 0 121 37.55218078 -85.26898542 2020-08-09 04:34:54 Marion, Kentucky, US
392926 2020-08-08 US Kentucky Marshall 21157 137 2 0 135 36.88007070000001 -88.32803576 2020-08-09 04:34:54 Marshall, Kentucky, US
392935 2020-08-08 US Kentucky Martin 21159 36 0 0 36 37.79990579 -82.51247478 2020-08-09 04:34:54 Martin, Kentucky, US
392941 2020-08-08 US Kentucky Mason 21161 54 1 0 53 38.59471935 -83.82151043 2020-08-09 04:34:54 Mason, Kentucky, US
392960 2020-08-08 US Kentucky McCracken 21145 366 4 0 362 37.05350953 -88.70445755 2020-08-09 04:34:54 McCracken, Kentucky, US
392961 2020-08-08 US Kentucky McCreary 21147 38 0 0 38 36.73874143 -84.48102924 2020-08-09 04:34:54 McCreary, Kentucky, US
392978 2020-08-08 US Kentucky McLean 21149 42 1 0 41 37.5301951 -87.26803443 2020-08-09 04:34:54 McLean, Kentucky, US
392989 2020-08-08 US Kentucky Meade 21163 99 2 0 97 37.96163597 -86.21028219 2020-08-09 04:34:54 Meade, Kentucky, US
393004 2020-08-08 US Kentucky Menifee 21165 28 0 0 28 37.94090733 -83.59985712 2020-08-09 04:34:54 Menifee, Kentucky, US
393009 2020-08-08 US Kentucky Mercer 21167 82 0 0 82 37.81474237 -84.87488475 2020-08-09 04:34:54 Mercer, Kentucky, US
393020 2020-08-08 US Kentucky Metcalfe 21169 58 2 0 56 36.99459295 -85.63123699 2020-08-09 04:34:54 Metcalfe, Kentucky, US
393074 2020-08-08 US Kentucky Monroe 21171 94 2 0 92 36.71225341 -85.71596443 2020-08-09 04:34:54 Monroe, Kentucky, US
393095 2020-08-08 US Kentucky Montgomery 21173 120 0 0 120 38.03253032 -83.9145241 2020-08-09 04:34:54 Montgomery, Kentucky, US
393120 2020-08-08 US Kentucky Morgan 21175 31 0 0 31 37.92465657 -83.25558245 2020-08-09 04:34:54 Morgan, Kentucky, US
393139 2020-08-08 US Kentucky Muhlenberg 21177 620 11 0 609 37.21425819 -87.14632053 2020-08-09 04:34:54 Muhlenberg, Kentucky, US
393162 2020-08-08 US Kentucky Nelson 21179 215 2 0 213 37.80335779 -85.4657193 2020-08-09 04:34:54 Nelson, Kentucky, US
393191 2020-08-08 US Kentucky Nicholas 21181 20 0 0 20 38.33342292 -84.01889177 2020-08-09 04:34:54 Nicholas, Kentucky, US
393234 2020-08-08 US Kentucky Ohio 21183 358 8 0 350 37.47751843 -86.85368087 2020-08-09 04:34:54 Ohio, Kentucky, US
393243 2020-08-08 US Kentucky Oldham 21185 620 15 0 605 38.39791089 -85.448222 2020-08-09 04:34:54 Oldham, Kentucky, US
393302 2020-08-08 US Kentucky Owen 21187 48 0 0 48 38.51679143 -84.82404619 2020-08-09 04:34:54 Owen, Kentucky, US
393303 2020-08-08 US Kentucky Owsley 21189 13 0 0 13 37.42823949 -83.68811419 2020-08-09 04:34:54 Owsley, Kentucky, US
393342 2020-08-08 US Kentucky Pendleton 21191 45 0 0 45 38.69607718 -84.35599463 2020-08-09 04:34:54 Pendleton, Kentucky, US
393357 2020-08-08 US Kentucky Perry 21193 222 3 0 219 37.25023553 -83.22922731 2020-08-09 04:34:54 Perry, Kentucky, US
393391 2020-08-08 US Kentucky Pike 21195 250 3 0 247 37.47088263 -82.39487445 2020-08-09 04:34:54 Pike, Kentucky, US
393451 2020-08-08 US Kentucky Powell 21197 53 0 0 53 37.83218794 -83.82553961 2020-08-09 04:34:54 Powell, Kentucky, US
393477 2020-08-08 US Kentucky Pulaski 21199 279 4 0 275 37.10466131 -84.57629079 2020-08-09 04:34:54 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]);
Powered by Datasette · Query took 2204.515ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette