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

35,332 rows where state = "Kentucky" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Kentucky · 35,332 ✖
Link rowid date ▲ county state fips cases deaths
950727 950727 2021-01-21 Adair Kentucky 21001 1467 47
950728 950728 2021-01-21 Allen Kentucky 21003 1449 22
950729 950729 2021-01-21 Anderson Kentucky 21005 1310 8
950730 950730 2021-01-21 Ballard Kentucky 21007 289 3
950731 950731 2021-01-21 Barren Kentucky 21009 3184 36
950732 950732 2021-01-21 Bath Kentucky 21011 652 10
950733 950733 2021-01-21 Bell Kentucky 21013 2296 32
950734 950734 2021-01-21 Boone Kentucky 21015 10455 49
950735 950735 2021-01-21 Bourbon Kentucky 21017 1279 9
950736 950736 2021-01-21 Boyd Kentucky 21019 3989 33
950737 950737 2021-01-21 Boyle Kentucky 21021 2860 16
950738 950738 2021-01-21 Bracken Kentucky 21023 406 3
950739 950739 2021-01-21 Breathitt Kentucky 21025 787 3
950740 950740 2021-01-21 Breckinridge Kentucky 21027 925 5
950741 950741 2021-01-21 Bullitt Kentucky 21029 5128 33
950742 950742 2021-01-21 Butler Kentucky 21031 1062 17
950743 950743 2021-01-21 Caldwell Kentucky 21033 1088 19
950744 950744 2021-01-21 Calloway Kentucky 21035 2974 31
950745 950745 2021-01-21 Campbell Kentucky 21037 6424 39
950746 950746 2021-01-21 Carlisle Kentucky 21039 400 1
950747 950747 2021-01-21 Carroll Kentucky 21041 764 9
950748 950748 2021-01-21 Carter Kentucky 21043 1705 19
950749 950749 2021-01-21 Casey Kentucky 21045 1054 30
950750 950750 2021-01-21 Christian Kentucky 21047 5440 74
950751 950751 2021-01-21 Clark Kentucky 21049 1996 16
950752 950752 2021-01-21 Clay Kentucky 21051 2099 16
950753 950753 2021-01-21 Clinton Kentucky 21053 1218 23
950754 950754 2021-01-21 Crittenden Kentucky 21055 485 6
950755 950755 2021-01-21 Cumberland Kentucky 21057 571 8
950756 950756 2021-01-21 Daviess Kentucky 21059 7731 124
950757 950757 2021-01-21 Edmonson Kentucky 21061 686 13
950758 950758 2021-01-21 Elliott Kentucky 21063 885 1
950759 950759 2021-01-21 Estill Kentucky 21065 834 0
950760 950760 2021-01-21 Fayette Kentucky 21067 27881 179
950761 950761 2021-01-21 Fleming Kentucky 21069 909 8
950762 950762 2021-01-21 Floyd Kentucky 21071 2417 18
950763 950763 2021-01-21 Franklin Kentucky 21073 2732 24
950764 950764 2021-01-21 Fulton Kentucky 21075 419 4
950765 950765 2021-01-21 Gallatin Kentucky 21077 544 16
950766 950766 2021-01-21 Garrard Kentucky 21079 1183 4
950767 950767 2021-01-21 Grant Kentucky 21081 1663 10
950768 950768 2021-01-21 Graves Kentucky 21083 3459 56
950769 950769 2021-01-21 Grayson Kentucky 21085 1610 38
950770 950770 2021-01-21 Green Kentucky 21087 940 13
950771 950771 2021-01-21 Greenup Kentucky 21089 2882 21
950772 950772 2021-01-21 Hancock Kentucky 21091 667 14
950773 950773 2021-01-21 Hardin Kentucky 21093 7484 56
950774 950774 2021-01-21 Harlan Kentucky 21095 2046 35
950775 950775 2021-01-21 Harrison Kentucky 21097 1210 2
950776 950776 2021-01-21 Hart Kentucky 21099 1489 14
950777 950777 2021-01-21 Henderson Kentucky 21101 3765 52
950778 950778 2021-01-21 Henry Kentucky 21103 998 5
950779 950779 2021-01-21 Hickman Kentucky 21105 260 7
950780 950780 2021-01-21 Hopkins Kentucky 21107 3374 115
950781 950781 2021-01-21 Jackson Kentucky 21109 1069 23
950782 950782 2021-01-21 Jefferson Kentucky 21111 63192 754
950783 950783 2021-01-21 Jessamine Kentucky 21113 3326 48
950784 950784 2021-01-21 Johnson Kentucky 21115 1454 16
950785 950785 2021-01-21 Kenton Kentucky 21117 12256 91
950786 950786 2021-01-21 Knott Kentucky 21119 863 14
950787 950787 2021-01-21 Knox Kentucky 21121 2357 10
950788 950788 2021-01-21 Larue Kentucky 21123 990 6
950789 950789 2021-01-21 Laurel Kentucky 21125 4820 17
950790 950790 2021-01-21 Lawrence Kentucky 21127 1021 5
950791 950791 2021-01-21 Lee Kentucky 21129 1113 18
950792 950792 2021-01-21 Leslie Kentucky 21131 643 2
950793 950793 2021-01-21 Letcher Kentucky 21133 1400 5
950794 950794 2021-01-21 Lewis Kentucky 21135 945 29
950795 950795 2021-01-21 Lincoln Kentucky 21137 1774 29
950796 950796 2021-01-21 Livingston Kentucky 21139 593 15
950797 950797 2021-01-21 Logan Kentucky 21141 2057 44
950798 950798 2021-01-21 Lyon Kentucky 21143 390 11
950799 950799 2021-01-21 Madison Kentucky 21151 7142 48
950800 950800 2021-01-21 Magoffin Kentucky 21153 782 1
950801 950801 2021-01-21 Marion Kentucky 21155 1794 20
950802 950802 2021-01-21 Marshall Kentucky 21157 2039 32
950803 950803 2021-01-21 Martin Kentucky 21159 794 11
950804 950804 2021-01-21 Mason Kentucky 21161 1159 24
950805 950805 2021-01-21 McCracken Kentucky 21145 5018 48
950806 950806 2021-01-21 McCreary Kentucky 21147 1390 18
950807 950807 2021-01-21 McLean Kentucky 21149 709 24
950808 950808 2021-01-21 Meade Kentucky 21163 1501 5
950809 950809 2021-01-21 Menifee Kentucky 21165 284 3
950810 950810 2021-01-21 Mercer Kentucky 21167 2018 11
950811 950811 2021-01-21 Metcalfe Kentucky 21169 722 12
950812 950812 2021-01-21 Monroe Kentucky 21171 1107 33
950813 950813 2021-01-21 Montgomery Kentucky 21173 1851 16
950814 950814 2021-01-21 Morgan Kentucky 21175 1734 0
950815 950815 2021-01-21 Muhlenberg Kentucky 21177 2434 47
950816 950816 2021-01-21 Nelson Kentucky 21179 3746 23
950817 950817 2021-01-21 Nicholas Kentucky 21181 397 5
950818 950818 2021-01-21 Ohio Kentucky 21183 1996 36
950819 950819 2021-01-21 Oldham Kentucky 21185 6028 55
950820 950820 2021-01-21 Owen Kentucky 21187 515 7
950821 950821 2021-01-21 Owsley Kentucky 21189 362 10
950822 950822 2021-01-21 Pendleton Kentucky 21191 772 1
950823 950823 2021-01-21 Perry Kentucky 21193 1896 17
950824 950824 2021-01-21 Pike Kentucky 21195 4064 38
950825 950825 2021-01-21 Powell Kentucky 21197 833 0
950826 950826 2021-01-21 Pulaski Kentucky 21199 4869 72

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]);