daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

8,083 rows where province_or_state = "Kentucky" sorted by day descending

View and edit SQL

province_or_state

  • Kentucky · 8,083

country_or_region

  • US 8,083
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-03 US Kentucky Adair 21001 97 19 0 78 37.10459774 -85.28129668 2020-06-04 02:33:14 Adair, Kentucky, US
2020-06-03 US Kentucky Allen 21003 96 3 0 93 36.75197631 -86.19457544 2020-06-04 02:33:14 Allen, Kentucky, US
2020-06-03 US Kentucky Anderson 21005 21 1 0 20 38.00671029 -84.99171713 2020-06-04 02:33:14 Anderson, Kentucky, US
2020-06-03 US Kentucky Ballard 21007 12 0 0 12 37.05842757 -88.99427697 2020-06-04 02:33:14 Ballard, Kentucky, US
2020-06-03 US Kentucky Barren 21009 49 1 0 48 36.96469836 -85.93338945 2020-06-04 02:33:14 Barren, Kentucky, US
2020-06-03 US Kentucky Bath 21011 9 1 0 8 38.14735938 -83.74588932 2020-06-04 02:33:14 Bath, Kentucky, US
2020-06-03 US Kentucky Bell 21013 1 0 0 1 36.73355174 -83.67766671 2020-06-04 02:33:14 Bell, Kentucky, US
2020-06-03 US Kentucky Boone 21015 492 17 0 475 38.97065142 -84.72615357 2020-06-04 02:33:14 Boone, Kentucky, US
2020-06-03 US Kentucky Bourbon 21017 11 1 0 10 38.2054607 -84.21827874 2020-06-04 02:33:14 Bourbon, Kentucky, US
2020-06-03 US Kentucky Boyd 21019 40 3 0 37 38.36176608 -82.68652187 2020-06-04 02:33:14 Boyd, Kentucky, US
2020-06-03 US Kentucky Boyle 21021 26 0 0 26 37.62680923 -84.8633779 2020-06-04 02:33:14 Boyle, Kentucky, US
2020-06-03 US Kentucky Bracken 21023 13 0 0 13 38.69158994 -84.08532444 2020-06-04 02:33:14 Bracken, Kentucky, US
2020-06-03 US Kentucky Breathitt 21025 3 0 0 3 37.52333168 -83.31959161 2020-06-04 02:33:14 Breathitt, Kentucky, US
2020-06-03 US Kentucky Breckinridge 21027 17 2 0 15 37.77377239 -86.42885017 2020-06-04 02:33:14 Breckinridge, Kentucky, US
2020-06-03 US Kentucky Bullitt 21029 119 4 0 115 37.97162523 -85.68955617 2020-06-04 02:33:14 Bullitt, Kentucky, US
2020-06-03 US Kentucky Butler 21031 235 13 0 222 37.20946153 -86.68748787 2020-06-04 02:33:14 Butler, Kentucky, US
2020-06-03 US Kentucky Caldwell 21033 12 0 0 12 37.14749129 -87.86948214 2020-06-04 02:33:14 Caldwell, Kentucky, US
2020-06-03 US Kentucky Calloway 21035 53 1 0 52 36.62093411 -88.2731593 2020-06-04 02:33:14 Calloway, Kentucky, US
2020-06-03 US Kentucky Campbell 21037 191 12 0 179 38.94384345 -84.37875208 2020-06-04 02:33:14 Campbell, Kentucky, US
2020-06-03 US Kentucky Carlisle 21039 5 1 0 4 36.85372876 -88.96692220000001 2020-06-04 02:33:14 Carlisle, Kentucky, US
2020-06-03 US Kentucky Carroll 21041 14 0 0 14 38.66599534 -85.12601074 2020-06-04 02:33:14 Carroll, Kentucky, US
2020-06-03 US Kentucky Carter 21043 14 0 0 14 38.31690743 -83.05092385 2020-06-04 02:33:14 Carter, Kentucky, US
2020-06-03 US Kentucky Casey 21045 5 0 0 5 37.32533118 -84.92726209 2020-06-04 02:33:14 Casey, Kentucky, US
2020-06-03 US Kentucky Christian 21047 114 3 0 111 36.89267803 -87.49055367 2020-06-04 02:33:14 Christian, Kentucky, US
2020-06-03 US Kentucky Clark 21049 43 0 0 43 37.9689263 -84.14615986 2020-06-04 02:33:14 Clark, Kentucky, US
2020-06-03 US Kentucky Clay 21051 7 1 0 6 37.16451126 -83.712575 2020-06-04 02:33:14 Clay, Kentucky, US
2020-06-03 US Kentucky Clinton 21053 4 0 0 4 36.72581156 -85.13377529 2020-06-04 02:33:14 Clinton, Kentucky, US
2020-06-03 US Kentucky Crittenden 21055 7 1 0 6 37.35839237 -88.08826090000002 2020-06-04 02:33:14 Crittenden, Kentucky, US
2020-06-03 US Kentucky Cumberland 21057 5 0 0 5 36.78926125 -85.39050034 2020-06-04 02:33:14 Cumberland, Kentucky, US
2020-06-03 US Kentucky Daviess 21059 330 6 0 324 37.73028906 -87.09019479999998 2020-06-04 02:33:14 Daviess, Kentucky, US
2020-06-03 US Kentucky Edmonson 21061 57 11 0 46 37.21218923 -86.23955613 2020-06-04 02:33:14 Edmonson, Kentucky, US
2020-06-03 US Kentucky Elliott 21063 1 0 0 1 38.11624059 -83.09771563 2020-06-04 02:33:14 Elliott, Kentucky, US
2020-06-03 US Kentucky Estill 21065 1 0 0 1 37.69241417 -83.95956369 2020-06-04 02:33:14 Estill, Kentucky, US
2020-06-03 US Kentucky Fayette 21067 803 13 0 790 38.0368225 -84.45576892 2020-06-04 02:33:14 Fayette, Kentucky, US
2020-06-03 US Kentucky Fleming 21069 2 0 0 2 38.36758311 -83.69657514 2020-06-04 02:33:14 Fleming, Kentucky, US
2020-06-03 US Kentucky Floyd 21071 17 0 0 17 37.56213922 -82.74750924 2020-06-04 02:33:14 Floyd, Kentucky, US
2020-06-03 US Kentucky Franklin 21073 63 0 0 63 38.2379395 -84.87962551 2020-06-04 02:33:14 Franklin, Kentucky, US
2020-06-03 US Kentucky Fulton 21075 8 0 0 8 36.55238827 -89.20140068 2020-06-04 02:33:14 Fulton, Kentucky, US
2020-06-03 US Kentucky Gallatin 21077 46 5 0 41 38.75398691 -84.8558382 2020-06-04 02:33:14 Gallatin, Kentucky, US
2020-06-03 US Kentucky Garrard 21079 5 0 0 5 37.6388668 -84.53289319 2020-06-04 02:33:14 Garrard, Kentucky, US
2020-06-03 US Kentucky Grant 21081 46 4 0 42 38.64962758 -84.62415957 2020-06-04 02:33:14 Grant, Kentucky, US
2020-06-03 US Kentucky Graves 21083 166 19 0 147 36.72292505 -88.65143315 2020-06-04 02:33:14 Graves, Kentucky, US
2020-06-03 US Kentucky Grayson 21085 127 9 0 118 37.46231118 -86.34248968 2020-06-04 02:33:14 Grayson, Kentucky, US
2020-06-03 US Kentucky Green 21087 1 0 0 1 37.26484328 -85.5540745 2020-06-04 02:33:14 Green, Kentucky, US
2020-06-03 US Kentucky Greenup 21089 14 0 0 14 38.54332505 -82.9215658 2020-06-04 02:33:14 Greenup, Kentucky, US
2020-06-03 US Kentucky Hancock 21091 7 0 0 7 37.83766422 -86.78280584 2020-06-04 02:33:14 Hancock, Kentucky, US
2020-06-03 US Kentucky Hardin 21093 109 2 0 107 37.6976111 -85.96319251 2020-06-04 02:33:14 Hardin, Kentucky, US
2020-06-03 US Kentucky Harlan 21095 4 0 0 4 36.85699301 -83.21899516 2020-06-04 02:33:14 Harlan, Kentucky, US
2020-06-03 US Kentucky Harrison 21097 23 0 0 23 38.44188174 -84.32869741 2020-06-04 02:33:14 Harrison, Kentucky, US
2020-06-03 US Kentucky Hart 21099 23 0 0 23 37.29943898 -85.88461055 2020-06-04 02:33:14 Hart, Kentucky, US
2020-06-03 US Kentucky Henderson 21101 112 3 0 109 37.79344553 -87.57392021 2020-06-04 02:33:14 Henderson, Kentucky, US
2020-06-03 US Kentucky Henry 21103 22 0 0 22 38.44942688 -85.11587507 2020-06-04 02:33:14 Henry, Kentucky, US
2020-06-03 US Kentucky Hickman 21105 5 0 0 5 36.67948079999999 -88.97875928 2020-06-04 02:33:14 Hickman, Kentucky, US
2020-06-03 US Kentucky Hopkins 21107 224 31 0 193 37.30939025 -87.54670406 2020-06-04 02:33:14 Hopkins, Kentucky, US
2020-06-03 US Kentucky Jackson 21109 61 13 0 48 37.41866422 -83.99825483 2020-06-04 02:33:14 Jackson, Kentucky, US
2020-06-03 US Kentucky Jefferson 21111 2612 160 0 2452 38.18664655 -85.65931031 2020-06-04 02:33:14 Jefferson, Kentucky, US
2020-06-03 US Kentucky Jessamine 21113 67 0 0 67 37.87119786 -84.58252003 2020-06-04 02:33:14 Jessamine, Kentucky, US
2020-06-03 US Kentucky Johnson 21115 5 0 0 5 37.85106355 -82.8264322 2020-06-04 02:33:14 Johnson, Kentucky, US
2020-06-03 US Kentucky Kenton 21117 638 34 0 604 38.93950319 -84.53241199 2020-06-04 02:33:14 Kenton, Kentucky, US
2020-06-03 US Kentucky Knott 21119 4 0 0 4 37.35388197 -82.94981134 2020-06-04 02:33:14 Knott, Kentucky, US
2020-06-03 US Kentucky Knox 21121 10 0 0 10 36.89225732 -83.85403396 2020-06-04 02:33:14 Knox, Kentucky, US
2020-06-03 US Kentucky Larue 21123 8 0 0 8 37.54567114 -85.70138352 2020-06-04 02:33:14 Larue, Kentucky, US
2020-06-03 US Kentucky Laurel 21125 21 2 0 19 37.10975748 -84.11321779 2020-06-04 02:33:14 Laurel, Kentucky, US
2020-06-03 US Kentucky Lawrence 21127 4 0 0 4 38.07136018 -82.72882223 2020-06-04 02:33:14 Lawrence, Kentucky, US
2020-06-03 US Kentucky Lee 21129 1 0 0 1 37.59645942 -83.71513901 2020-06-04 02:33:14 Lee, Kentucky, US
2020-06-03 US Kentucky Leslie 21131 6 0 0 6 37.09246661 -83.37999606 2020-06-04 02:33:14 Leslie, Kentucky, US
2020-06-03 US Kentucky Letcher 21133 3 0 0 3 37.12306748 -82.85346474 2020-06-04 02:33:14 Letcher, Kentucky, US
2020-06-03 US Kentucky Lewis 21135 7 0 0 7 38.53184419 -83.37735618 2020-06-04 02:33:14 Lewis, Kentucky, US
2020-06-03 US Kentucky Lincoln 21137 8 1 0 7 37.45475628 -84.6565327 2020-06-04 02:33:14 Lincoln, Kentucky, US
2020-06-03 US Kentucky Livingston 21139 9 0 0 9 37.21137452 -88.34797529 2020-06-04 02:33:14 Livingston, Kentucky, US
2020-06-03 US Kentucky Logan 21141 155 4 0 151 36.85949479 -86.877635 2020-06-04 02:33:14 Logan, Kentucky, US
2020-06-03 US Kentucky Lyon 21143 15 3 0 12 37.02080035 -88.07886257 2020-06-04 02:33:14 Lyon, Kentucky, US
2020-06-03 US Kentucky Madison 21151 54 1 0 53 37.71659336 -84.27220275 2020-06-04 02:33:14 Madison, Kentucky, US
2020-06-03 US Kentucky Magoffin 21153 2 0 0 2 37.70820545 -83.0657714 2020-06-04 02:33:14 Magoffin, Kentucky, US
2020-06-03 US Kentucky Marion 21155 25 0 0 25 37.55218078 -85.26898542 2020-06-04 02:33:14 Marion, Kentucky, US
2020-06-03 US Kentucky Marshall 21157 37 2 0 35 36.88007070000001 -88.32803576 2020-06-04 02:33:14 Marshall, Kentucky, US
2020-06-03 US Kentucky Martin 21159 3 0 0 3 37.79990579 -82.51247478 2020-06-04 02:33:14 Martin, Kentucky, US
2020-06-03 US Kentucky Mason 21161 10 0 0 10 38.59471935 -83.82151043 2020-06-04 02:33:14 Mason, Kentucky, US
2020-06-03 US Kentucky McCracken 21145 99 2 0 97 37.05350953 -88.70445755 2020-06-04 02:33:14 McCracken, Kentucky, US
2020-06-03 US Kentucky McCreary 21147 13 0 0 13 36.73874143 -84.48102924 2020-06-04 02:33:14 McCreary, Kentucky, US
2020-06-03 US Kentucky McLean 21149 22 1 0 21 37.5301951 -87.26803443 2020-06-04 02:33:14 McLean, Kentucky, US
2020-06-03 US Kentucky Meade 21163 22 2 0 20 37.96163597 -86.21028219 2020-06-04 02:33:14 Meade, Kentucky, US
2020-06-03 US Kentucky Menifee 21165 10 0 0 10 37.94090733 -83.59985712 2020-06-04 02:33:14 Menifee, Kentucky, US
2020-06-03 US Kentucky Mercer 21167 14 0 0 14 37.81474237 -84.87488475 2020-06-04 02:33:14 Mercer, Kentucky, US
2020-06-03 US Kentucky Metcalfe 21169 7 1 0 6 36.99459295 -85.63123699 2020-06-04 02:33:14 Metcalfe, Kentucky, US
2020-06-03 US Kentucky Monroe 21171 21 0 0 21 36.71225341 -85.71596443 2020-06-04 02:33:14 Monroe, Kentucky, US
2020-06-03 US Kentucky Montgomery 21173 25 0 0 25 38.03253032 -83.9145241 2020-06-04 02:33:14 Montgomery, Kentucky, US
2020-06-03 US Kentucky Morgan 21175 3 0 0 3 37.92465657 -83.25558245 2020-06-04 02:33:14 Morgan, Kentucky, US
2020-06-03 US Kentucky Muhlenberg 21177 479 8 0 471 37.21425819 -87.14632053 2020-06-04 02:33:14 Muhlenberg, Kentucky, US
2020-06-03 US Kentucky Nelson 21179 44 1 0 43 37.80335779 -85.4657193 2020-06-04 02:33:14 Nelson, Kentucky, US
2020-06-03 US Kentucky Nicholas 21181 3 0 0 3 38.33342292 -84.01889177 2020-06-04 02:33:14 Nicholas, Kentucky, US
2020-06-03 US Kentucky Ohio 21183 148 0 0 148 37.47751843 -86.85368087 2020-06-04 02:33:14 Ohio, Kentucky, US
2020-06-03 US Kentucky Oldham 21185 103 5 0 98 38.39791089 -85.448222 2020-06-04 02:33:14 Oldham, Kentucky, US
2020-06-03 US Kentucky Owen 21187 3 0 0 3 38.51679143 -84.82404619 2020-06-04 02:33:14 Owen, Kentucky, US
2020-06-03 US Kentucky Owsley 21189 2 0 0 2 37.42823949 -83.68811419 2020-06-04 02:33:14 Owsley, Kentucky, US
2020-06-03 US Kentucky Pendleton 21191 11 0 0 11 38.69607718 -84.35599463 2020-06-04 02:33:14 Pendleton, Kentucky, US
2020-06-03 US Kentucky Perry 21193 22 0 0 22 37.25023553 -83.22922731 2020-06-04 02:33:14 Perry, Kentucky, US
2020-06-03 US Kentucky Pike 21195 30 2 0 28 37.47088263 -82.39487445 2020-06-04 02:33:14 Pike, Kentucky, US
2020-06-03 US Kentucky Powell 21197 1 0 0 1 37.83218794 -83.82553961 2020-06-04 02:33:14 Powell, Kentucky, US
2020-06-03 US Kentucky Pulaski 21199 61 2 0 59 37.10466131 -84.57629079 2020-06-04 02:33:14 Pulaski, Kentucky, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 2156.76ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette