ny_times_us_counties

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

67,372 rows where state = "Kentucky" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Kentucky · 67,372 ✖
Link rowid date ▲ county state fips cases deaths
1817616 1817616 2021-10-15 Adair Kentucky 21001 3350 76
1817617 1817617 2021-10-15 Allen Kentucky 21003 3730 63
1817618 1817618 2021-10-15 Anderson Kentucky 21005 3292 40
1817619 1817619 2021-10-15 Ballard Kentucky 21007 657 19
1817620 1817620 2021-10-15 Barren Kentucky 21009 7814 133
1817621 1817621 2021-10-15 Bath Kentucky 21011 1554 29
1817622 1817622 2021-10-15 Bell Kentucky 21013 5736 90
1817623 1817623 2021-10-15 Boone Kentucky 21015 20474 197
1817624 1817624 2021-10-15 Bourbon Kentucky 21017 3099 32
1817625 1817625 2021-10-15 Boyd Kentucky 21019 8188 98
1817626 1817626 2021-10-15 Boyle Kentucky 21021 5273 79
1817627 1817627 2021-10-15 Bracken Kentucky 21023 1075 8
1817628 1817628 2021-10-15 Breathitt Kentucky 21025 1964 24
1817629 1817629 2021-10-15 Breckinridge Kentucky 21027 2635 30
1817630 1817630 2021-10-15 Bullitt Kentucky 21029 11794 118
1817631 1817631 2021-10-15 Butler Kentucky 21031 2295 32
1817632 1817632 2021-10-15 Caldwell Kentucky 21033 2269 46
1817633 1817633 2021-10-15 Calloway Kentucky 21035 5111 60
1817634 1817634 2021-10-15 Campbell Kentucky 21037 12793 97
1817635 1817635 2021-10-15 Carlisle Kentucky 21039 618 11
1817636 1817636 2021-10-15 Carroll Kentucky 21041 1827 26
1817637 1817637 2021-10-15 Carter Kentucky 21043 4475 57
1817638 1817638 2021-10-15 Casey Kentucky 21045 2789 53
1817639 1817639 2021-10-15 Christian Kentucky 21047 10093 125
1817640 1817640 2021-10-15 Clark Kentucky 21049 5098 36
1817641 1817641 2021-10-15 Clay Kentucky 21051 5069 56
1817642 1817642 2021-10-15 Clinton Kentucky 21053 2166 34
1817643 1817643 2021-10-15 Crittenden Kentucky 21055 1158 35
1817644 1817644 2021-10-15 Cumberland Kentucky 21057 1194 19
1817645 1817645 2021-10-15 Daviess Kentucky 21059 16609 259
1817646 1817646 2021-10-15 Edmonson Kentucky 21061 1520 28
1817647 1817647 2021-10-15 Elliott Kentucky 21063 1300 7
1817648 1817648 2021-10-15 Estill Kentucky 21065 2172 12
1817649 1817649 2021-10-15 Fayette Kentucky 21067 50887 383
1817650 1817650 2021-10-15 Fleming Kentucky 21069 2087 32
1817651 1817651 2021-10-15 Floyd Kentucky 21071 6898 109
1817652 1817652 2021-10-15 Franklin Kentucky 21073 6786 75
1817653 1817653 2021-10-15 Fulton Kentucky 21075 728 16
1817654 1817654 2021-10-15 Gallatin Kentucky 21077 1207 38
1817655 1817655 2021-10-15 Garrard Kentucky 21079 2741 45
1817656 1817656 2021-10-15 Grant Kentucky 21081 4199 35
1817657 1817657 2021-10-15 Graves Kentucky 21083 7113 120
1817658 1817658 2021-10-15 Grayson Kentucky 21085 4597 84
1817659 1817659 2021-10-15 Green Kentucky 21087 2412 32
1817660 1817660 2021-10-15 Greenup Kentucky 21089 6196 78
1817661 1817661 2021-10-15 Hancock Kentucky 21091 1373 17
1817662 1817662 2021-10-15 Hardin Kentucky 21093 17643 252
1817663 1817663 2021-10-15 Harlan Kentucky 21095 5276 124
1817664 1817664 2021-10-15 Harrison Kentucky 21097 3206 35
1817665 1817665 2021-10-15 Hart Kentucky 21099 3447 61
1817666 1817666 2021-10-15 Henderson Kentucky 21101 7864 98
1817667 1817667 2021-10-15 Henry Kentucky 21103 2510 24
1817668 1817668 2021-10-15 Hickman Kentucky 21105 547 19
1817669 1817669 2021-10-15 Hopkins Kentucky 21107 7895 192
1817670 1817670 2021-10-15 Jackson Kentucky 21109 2547 49
1817671 1817671 2021-10-15 Jefferson Kentucky 21111 117371 1556
1817672 1817672 2021-10-15 Jessamine Kentucky 21113 7932 90
1817673 1817673 2021-10-15 Johnson Kentucky 21115 3646 46
1817674 1817674 2021-10-15 Kenton Kentucky 21117 24161 257
1817675 1817675 2021-10-15 Knott Kentucky 21119 2363 36
1817676 1817676 2021-10-15 Knox Kentucky 21121 7094 52
1817677 1817677 2021-10-15 Larue Kentucky 21123 2357 45
1817678 1817678 2021-10-15 Laurel Kentucky 21125 12677 111
1817679 1817679 2021-10-15 Lawrence Kentucky 21127 2556 38
1817680 1817680 2021-10-15 Lee Kentucky 21129 1710 31
1817681 1817681 2021-10-15 Leslie Kentucky 21131 2122 18
1817682 1817682 2021-10-15 Letcher Kentucky 21133 3750 65
1817683 1817683 2021-10-15 Lewis Kentucky 21135 2462 55
1817684 1817684 2021-10-15 Lincoln Kentucky 21137 4230 80
1817685 1817685 2021-10-15 Livingston Kentucky 21139 1371 41
1817686 1817686 2021-10-15 Logan Kentucky 21141 4994 79
1817687 1817687 2021-10-15 Lyon Kentucky 21143 1925 26
1817688 1817688 2021-10-15 Madison Kentucky 21151 15532 145
1817689 1817689 2021-10-15 Magoffin Kentucky 21153 2152 20
1817690 1817690 2021-10-15 Marion Kentucky 21155 3824 43
1817691 1817691 2021-10-15 Marshall Kentucky 21157 4967 76
1817692 1817692 2021-10-15 Martin Kentucky 21159 1848 35
1817693 1817693 2021-10-15 Mason Kentucky 21161 2489 62
1817694 1817694 2021-10-15 McCracken Kentucky 21145 9898 167
1817695 1817695 2021-10-15 McCreary Kentucky 21147 3640 51
1817696 1817696 2021-10-15 McLean Kentucky 21149 1439 37
1817697 1817697 2021-10-15 Meade Kentucky 21163 3420 35
1817698 1817698 2021-10-15 Menifee Kentucky 21165 813 21
1817699 1817699 2021-10-15 Mercer Kentucky 21167 4370 72
1817700 1817700 2021-10-15 Metcalfe Kentucky 21169 1868 38
1817701 1817701 2021-10-15 Monroe Kentucky 21171 2240 59
1817702 1817702 2021-10-15 Montgomery Kentucky 21173 4401 51
1817703 1817703 2021-10-15 Morgan Kentucky 21175 2822 6
1817704 1817704 2021-10-15 Muhlenberg Kentucky 21177 5487 87
1817705 1817705 2021-10-15 Nelson Kentucky 21179 8134 77
1817706 1817706 2021-10-15 Nicholas Kentucky 21181 1132 17
1817707 1817707 2021-10-15 Ohio Kentucky 21183 4276 78
1817708 1817708 2021-10-15 Oldham Kentucky 21185 9940 91
1817709 1817709 2021-10-15 Owen Kentucky 21187 1335 22
1817710 1817710 2021-10-15 Owsley Kentucky 21189 970 15
1817711 1817711 2021-10-15 Pendleton Kentucky 21191 1991 16
1817712 1817712 2021-10-15 Perry Kentucky 21193 5962 87
1817713 1817713 2021-10-15 Pike Kentucky 21195 10393 159
1817714 1817714 2021-10-15 Powell Kentucky 21197 2442 21
1817715 1817715 2021-10-15 Pulaski Kentucky 21199 11019 181

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
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);