ny_times_us_counties

⚠️ 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 license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

11,092 rows where state = "Kentucky" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Kentucky · 11,092
Link rowid date ▲ county state fips cases deaths
292742 2020-07-03 Adair Kentucky 21001 127 19
292743 2020-07-03 Allen Kentucky 21003 174 7
292744 2020-07-03 Anderson Kentucky 21005 29 1
292745 2020-07-03 Ballard Kentucky 21007 15 0
292746 2020-07-03 Barren Kentucky 21009 92 2
292747 2020-07-03 Bath Kentucky 21011 18 1
292748 2020-07-03 Bell Kentucky 21013 13 0
292749 2020-07-03 Boone Kentucky 21015 615 23
292750 2020-07-03 Bourbon Kentucky 21017 34 1
292751 2020-07-03 Boyd Kentucky 21019 67 3
292752 2020-07-03 Boyle Kentucky 21021 40 0
292753 2020-07-03 Bracken Kentucky 21023 17 0
292754 2020-07-03 Breathitt Kentucky 21025 9 0
292755 2020-07-03 Breckinridge Kentucky 21027 25 2
292756 2020-07-03 Bullitt Kentucky 21029 154 4
292757 2020-07-03 Butler Kentucky 21031 257 14
292758 2020-07-03 Caldwell Kentucky 21033 15 0
292759 2020-07-03 Calloway Kentucky 21035 86 1
292760 2020-07-03 Campbell Kentucky 21037 270 13
292761 2020-07-03 Carlisle Kentucky 21039 5 1
292762 2020-07-03 Carroll Kentucky 21041 42 1
292763 2020-07-03 Carter Kentucky 21043 29 0
292764 2020-07-03 Casey Kentucky 21045 21 0
292765 2020-07-03 Christian Kentucky 21047 262 4
292766 2020-07-03 Clark Kentucky 21049 99 5
292767 2020-07-03 Clay Kentucky 21051 68 3
292768 2020-07-03 Clinton Kentucky 21053 5 0
292769 2020-07-03 Crittenden Kentucky 21055 9 1
292770 2020-07-03 Cumberland Kentucky 21057 6 0
292771 2020-07-03 Daviess Kentucky 21059 452 8
292772 2020-07-03 Edmonson Kentucky 21061 84 11
292773 2020-07-03 Elliott Kentucky 21063 3 0
292774 2020-07-03 Estill Kentucky 21065 4 0
292775 2020-07-03 Fayette Kentucky 21067 1637 30
292776 2020-07-03 Fleming Kentucky 21069 21 0
292777 2020-07-03 Floyd Kentucky 21071 32 0
292778 2020-07-03 Franklin Kentucky 21073 144 4
292779 2020-07-03 Fulton Kentucky 21075 24 0
292780 2020-07-03 Gallatin Kentucky 21077 65 8
292781 2020-07-03 Garrard Kentucky 21079 26 0
292782 2020-07-03 Grant Kentucky 21081 60 4
292783 2020-07-03 Graves Kentucky 21083 219 21
292784 2020-07-03 Grayson Kentucky 21085 140 11
292785 2020-07-03 Green Kentucky 21087 5 1
292786 2020-07-03 Greenup Kentucky 21089 33 0
292787 2020-07-03 Hancock Kentucky 21091 19 0
292788 2020-07-03 Hardin Kentucky 21093 177 6
292789 2020-07-03 Harlan Kentucky 21095 27 2
292790 2020-07-03 Harrison Kentucky 21097 74 0
292791 2020-07-03 Hart Kentucky 21099 49 0
292792 2020-07-03 Henderson Kentucky 21101 170 4
292793 2020-07-03 Henry Kentucky 21103 36 2
292794 2020-07-03 Hickman Kentucky 21105 5 0
292795 2020-07-03 Hopkins Kentucky 21107 266 34
292796 2020-07-03 Jackson Kentucky 21109 114 14
292797 2020-07-03 Jefferson Kentucky 21111 4034 211
292798 2020-07-03 Jessamine Kentucky 21113 111 0
292799 2020-07-03 Johnson Kentucky 21115 10 0
292800 2020-07-03 Kenton Kentucky 21117 814 37
292801 2020-07-03 Knott Kentucky 21119 11 0
292802 2020-07-03 Knox Kentucky 21121 73 0
292803 2020-07-03 Larue Kentucky 21123 17 1
292804 2020-07-03 Laurel Kentucky 21125 124 3
292805 2020-07-03 Lawrence Kentucky 21127 9 0
292806 2020-07-03 Lee Kentucky 21129 1 0
292807 2020-07-03 Leslie Kentucky 21131 10 0
292808 2020-07-03 Letcher Kentucky 21133 14 0
292809 2020-07-03 Lewis Kentucky 21135 22 0
292810 2020-07-03 Lincoln Kentucky 21137 30 1
292811 2020-07-03 Livingston Kentucky 21139 10 0
292812 2020-07-03 Logan Kentucky 21141 227 15
292813 2020-07-03 Lyon Kentucky 21143 20 3
292814 2020-07-03 Madison Kentucky 21151 130 1
292815 2020-07-03 Magoffin Kentucky 21153 6 0
292816 2020-07-03 Marion Kentucky 21155 52 0
292817 2020-07-03 Marshall Kentucky 21157 60 2
292818 2020-07-03 Martin Kentucky 21159 8 0
292819 2020-07-03 Mason Kentucky 21161 33 0
292820 2020-07-03 McCracken Kentucky 21145 172 3
292821 2020-07-03 McCreary Kentucky 21147 18 0
292822 2020-07-03 McLean Kentucky 21149 27 0
292823 2020-07-03 Meade Kentucky 21163 28 2
292824 2020-07-03 Menifee Kentucky 21165 13 0
292825 2020-07-03 Mercer Kentucky 21167 24 0
292826 2020-07-03 Metcalfe Kentucky 21169 11 2
292827 2020-07-03 Monroe Kentucky 21171 40 1
292828 2020-07-03 Montgomery Kentucky 21173 58 0
292829 2020-07-03 Morgan Kentucky 21175 9 0
292830 2020-07-03 Muhlenberg Kentucky 21177 527 8
292831 2020-07-03 Nelson Kentucky 21179 81 1
292832 2020-07-03 Nicholas Kentucky 21181 8 0
292833 2020-07-03 Ohio Kentucky 21183 208 0
292834 2020-07-03 Oldham Kentucky 21185 139 7
292835 2020-07-03 Owen Kentucky 21187 7 0
292836 2020-07-03 Owsley Kentucky 21189 3 0
292837 2020-07-03 Pendleton Kentucky 21191 19 0
292838 2020-07-03 Perry Kentucky 21193 62 1
292839 2020-07-03 Pike Kentucky 21195 99 2
292840 2020-07-03 Powell Kentucky 21197 8 0
292841 2020-07-03 Pulaski Kentucky 21199 100 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 989.224ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette