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

92,572 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 >30

county >30

state 1

  • Kentucky · 92,572 ✖
Link rowid date ▲ county state fips cases deaths
2500579 2500579 2022-05-13 Adair Kentucky 21001 5929 107
2500580 2500580 2022-05-13 Allen Kentucky 21003 6601 107
2500581 2500581 2022-05-13 Anderson Kentucky 21005 6620 70
2500582 2500582 2022-05-13 Ballard Kentucky 21007 1387 29
2500583 2500583 2022-05-13 Barren Kentucky 21009 13032 219
2500584 2500584 2022-05-13 Bath Kentucky 21011 3210 48
2500585 2500585 2022-05-13 Bell Kentucky 21013 8868 149
2500586 2500586 2022-05-13 Boone Kentucky 21015 40084 297
2500587 2500587 2022-05-13 Bourbon Kentucky 21017 6002 59
2500588 2500588 2022-05-13 Boyd Kentucky 21019 16369 177
2500589 2500589 2022-05-13 Boyle Kentucky 21021 8473 132
2500590 2500590 2022-05-13 Bracken Kentucky 21023 2186 26
2500591 2500591 2022-05-13 Breathitt Kentucky 21025 3801 54
2500592 2500592 2022-05-13 Breckinridge Kentucky 21027 5170 78
2500593 2500593 2022-05-13 Bullitt Kentucky 21029 21805 223
2500594 2500594 2022-05-13 Butler Kentucky 21031 3874 54
2500595 2500595 2022-05-13 Caldwell Kentucky 21033 4158 61
2500596 2500596 2022-05-13 Calloway Kentucky 21035 8414 94
2500597 2500597 2022-05-13 Campbell Kentucky 21037 25104 178
2500598 2500598 2022-05-13 Carlisle Kentucky 21039 1076 20
2500599 2500599 2022-05-13 Carroll Kentucky 21041 3504 45
2500600 2500600 2022-05-13 Carter Kentucky 21043 8675 107
2500601 2500601 2022-05-13 Casey Kentucky 21045 4216 74
2500602 2500602 2022-05-13 Christian Kentucky 21047 16376 210
2500603 2500603 2022-05-13 Clark Kentucky 21049 10749 68
2500604 2500604 2022-05-13 Clay Kentucky 21051 7867 92
2500605 2500605 2022-05-13 Clinton Kentucky 21053 3674 52
2500606 2500606 2022-05-13 Crittenden Kentucky 21055 2292 50
2500607 2500607 2022-05-13 Cumberland Kentucky 21057 2238 33
2500608 2500608 2022-05-13 Daviess Kentucky 21059 31176 391
2500609 2500609 2022-05-13 Edmonson Kentucky 21061 2563 47
2500610 2500610 2022-05-13 Elliott Kentucky 21063 2594 19
2500611 2500611 2022-05-13 Estill Kentucky 21065 4120 50
2500612 2500612 2022-05-13 Fayette Kentucky 21067 95993 609
2500613 2500613 2022-05-13 Fleming Kentucky 21069 3928 59
2500614 2500614 2022-05-13 Floyd Kentucky 21071 12571 206
2500615 2500615 2022-05-13 Franklin Kentucky 21073 13911 153
2500616 2500616 2022-05-13 Fulton Kentucky 21075 1218 31
2500617 2500617 2022-05-13 Gallatin Kentucky 21077 2221 51
2500618 2500618 2022-05-13 Garrard Kentucky 21079 4815 78
2500619 2500619 2022-05-13 Grant Kentucky 21081 7855 62
2500620 2500620 2022-05-13 Graves Kentucky 21083 11355 181
2500621 2500621 2022-05-13 Grayson Kentucky 21085 8014 134
2500622 2500622 2022-05-13 Green Kentucky 21087 3761 45
2500623 2500623 2022-05-13 Greenup Kentucky 21089 12124 145
2500624 2500624 2022-05-13 Hancock Kentucky 21091 2498 25
2500625 2500625 2022-05-13 Hardin Kentucky 21093 32778 434
2500626 2500626 2022-05-13 Harlan Kentucky 21095 9222 211
2500627 2500627 2022-05-13 Harrison Kentucky 21097 6417 76
2500628 2500628 2022-05-13 Hart Kentucky 21099 5428 101
2500629 2500629 2022-05-13 Henderson Kentucky 21101 13972 168
2500630 2500630 2022-05-13 Henry Kentucky 21103 4836 52
2500631 2500631 2022-05-13 Hickman Kentucky 21105 879 27
2500632 2500632 2022-05-13 Hopkins Kentucky 21107 14975 255
2500633 2500633 2022-05-13 Jackson Kentucky 21109 4286 80
2500634 2500634 2022-05-13 Jefferson Kentucky 21111 234899 2357
2500635 2500635 2022-05-13 Jessamine Kentucky 21113 15289 139
2500636 2500636 2022-05-13 Johnson Kentucky 21115 6173 118
2500637 2500637 2022-05-13 Kenton Kentucky 21117 46264 415
2500638 2500638 2022-05-13 Knott Kentucky 21119 4233 64
2500639 2500639 2022-05-13 Knox Kentucky 21121 11523 144
2500640 2500640 2022-05-13 Larue Kentucky 21123 3741 73
2500641 2500641 2022-05-13 Laurel Kentucky 21125 20315 242
2500642 2500642 2022-05-13 Lawrence Kentucky 21127 4503 69
2500643 2500643 2022-05-13 Lee Kentucky 21129 2951 52
2500644 2500644 2022-05-13 Leslie Kentucky 21131 3723 49
2500645 2500645 2022-05-13 Letcher Kentucky 21133 7140 114
2500646 2500646 2022-05-13 Lewis Kentucky 21135 4529 86
2500647 2500647 2022-05-13 Lincoln Kentucky 21137 6487 137
2500648 2500648 2022-05-13 Livingston Kentucky 21139 2482 61
2500649 2500649 2022-05-13 Logan Kentucky 21141 8369 126
2500650 2500650 2022-05-13 Lyon Kentucky 21143 2881 34
2500651 2500651 2022-05-13 Madison Kentucky 21151 27833 280
2500652 2500652 2022-05-13 Magoffin Kentucky 21153 3950 51
2500653 2500653 2022-05-13 Marion Kentucky 21155 6433 85
2500654 2500654 2022-05-13 Marshall Kentucky 21157 8421 112
2500655 2500655 2022-05-13 Martin Kentucky 21159 3308 49
2500656 2500656 2022-05-13 Mason Kentucky 21161 5017 105
2500657 2500657 2022-05-13 McCracken Kentucky 21145 18502 263
2500658 2500658 2022-05-13 McCreary Kentucky 21147 5727 82
2500659 2500659 2022-05-13 McLean Kentucky 21149 2621 53
2500660 2500660 2022-05-13 Meade Kentucky 21163 5821 66
2500661 2500661 2022-05-13 Menifee Kentucky 21165 1706 32
2500662 2500662 2022-05-13 Mercer Kentucky 21167 7401 106
2500663 2500663 2022-05-13 Metcalfe Kentucky 21169 2875 64
2500664 2500664 2022-05-13 Monroe Kentucky 21171 3624 77
2500665 2500665 2022-05-13 Montgomery Kentucky 21173 8200 108
2500666 2500666 2022-05-13 Morgan Kentucky 21175 5272 28
2500667 2500667 2022-05-13 Muhlenberg Kentucky 21177 10190 121
2500668 2500668 2022-05-13 Nelson Kentucky 21179 14507 153
2500669 2500669 2022-05-13 Nicholas Kentucky 21181 2105 31
2500670 2500670 2022-05-13 Ohio Kentucky 21183 7313 103
2500671 2500671 2022-05-13 Oldham Kentucky 21185 18515 145
2500672 2500672 2022-05-13 Owen Kentucky 21187 2370 34
2500673 2500673 2022-05-13 Owsley Kentucky 21189 1574 27
2500674 2500674 2022-05-13 Pendleton Kentucky 21191 3498 38
2500675 2500675 2022-05-13 Perry Kentucky 21193 11040 178
2500676 2500676 2022-05-13 Pike Kentucky 21195 19099 307
2500677 2500677 2022-05-13 Powell Kentucky 21197 4782 44
2500678 2500678 2022-05-13 Pulaski Kentucky 21199 18157 293

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