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

40,612 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 · 40,612 ✖
Link rowid date ▲ county state fips cases deaths
1093454 1093454 2021-03-06 Adair Kentucky 21001 1707 50
1093455 1093455 2021-03-06 Allen Kentucky 21003 1816 22
1093456 1093456 2021-03-06 Anderson Kentucky 21005 1639 16
1093457 1093457 2021-03-06 Ballard Kentucky 21007 352 5
1093458 1093458 2021-03-06 Barren Kentucky 21009 4106 71
1093459 1093459 2021-03-06 Bath Kentucky 21011 787 17
1093460 1093460 2021-03-06 Bell Kentucky 21013 2795 36
1093461 1093461 2021-03-06 Boone Kentucky 21015 13201 79
1093462 1093462 2021-03-06 Bourbon Kentucky 21017 1564 12
1093463 1093463 2021-03-06 Boyd Kentucky 21019 4666 46
1093464 1093464 2021-03-06 Boyle Kentucky 21021 3173 40
1093465 1093465 2021-03-06 Bracken Kentucky 21023 528 4
1093466 1093466 2021-03-06 Breathitt Kentucky 21025 931 6
1093467 1093467 2021-03-06 Breckinridge Kentucky 21027 1110 9
1093468 1093468 2021-03-06 Bullitt Kentucky 21029 6516 49
1093469 1093469 2021-03-06 Butler Kentucky 21031 1365 23
1093470 1093470 2021-03-06 Caldwell Kentucky 21033 1367 23
1093471 1093471 2021-03-06 Calloway Kentucky 21035 3407 38
1093472 1093472 2021-03-06 Campbell Kentucky 21037 8220 49
1093473 1093473 2021-03-06 Carlisle Kentucky 21039 436 4
1093474 1093474 2021-03-06 Carroll Kentucky 21041 899 10
1093475 1093475 2021-03-06 Carter Kentucky 21043 2034 24
1093476 1093476 2021-03-06 Casey Kentucky 21045 1291 34
1093477 1093477 2021-03-06 Christian Kentucky 21047 6253 79
1093478 1093478 2021-03-06 Clark Kentucky 21049 2444 25
1093479 1093479 2021-03-06 Clay Kentucky 21051 2456 28
1093480 1093480 2021-03-06 Clinton Kentucky 21053 1405 27
1093481 1093481 2021-03-06 Crittenden Kentucky 21055 570 17
1093482 1093482 2021-03-06 Cumberland Kentucky 21057 660 9
1093483 1093483 2021-03-06 Daviess Kentucky 21059 9799 162
1093484 1093484 2021-03-06 Edmonson Kentucky 21061 896 19
1093485 1093485 2021-03-06 Elliott Kentucky 21063 931 2
1093486 1093486 2021-03-06 Estill Kentucky 21065 982 3
1093487 1093487 2021-03-06 Fayette Kentucky 21067 32965 235
1093488 1093488 2021-03-06 Fleming Kentucky 21069 1089 14
1093489 1093489 2021-03-06 Floyd Kentucky 21071 3079 45
1093490 1093490 2021-03-06 Franklin Kentucky 21073 3723 30
1093491 1093491 2021-03-06 Fulton Kentucky 21075 485 8
1093492 1093492 2021-03-06 Gallatin Kentucky 21077 659 20
1093493 1093493 2021-03-06 Garrard Kentucky 21079 1408 17
1093494 1093494 2021-03-06 Grant Kentucky 21081 2255 14
1093495 1093495 2021-03-06 Graves Kentucky 21083 3977 74
1093496 1093496 2021-03-06 Grayson Kentucky 21085 1974 48
1093497 1093497 2021-03-06 Green Kentucky 21087 1134 13
1093498 1093498 2021-03-06 Greenup Kentucky 21089 3345 26
1093499 1093499 2021-03-06 Hancock Kentucky 21091 807 15
1093500 1093500 2021-03-06 Hardin Kentucky 21093 8950 100
1093501 1093501 2021-03-06 Harlan Kentucky 21095 2424 70
1093502 1093502 2021-03-06 Harrison Kentucky 21097 1528 9
1093503 1093503 2021-03-06 Hart Kentucky 21099 1848 33
1093504 1093504 2021-03-06 Henderson Kentucky 21101 4342 60
1093505 1093505 2021-03-06 Henry Kentucky 21103 1246 8
1093506 1093506 2021-03-06 Hickman Kentucky 21105 329 7
1093507 1093507 2021-03-06 Hopkins Kentucky 21107 3968 128
1093508 1093508 2021-03-06 Jackson Kentucky 21109 1218 29
1093509 1093509 2021-03-06 Jefferson Kentucky 21111 75030 943
1093510 1093510 2021-03-06 Jessamine Kentucky 21113 4224 53
1093511 1093511 2021-03-06 Johnson Kentucky 21115 1823 18
1093512 1093512 2021-03-06 Kenton Kentucky 21117 15636 133
1093513 1093513 2021-03-06 Knott Kentucky 21119 1067 18
1093514 1093514 2021-03-06 Knox Kentucky 21121 2978 14
1093515 1093515 2021-03-06 Larue Kentucky 21123 1233 17
1093516 1093516 2021-03-06 Laurel Kentucky 21125 5931 33
1093517 1093517 2021-03-06 Lawrence Kentucky 21127 1282 20
1093518 1093518 2021-03-06 Lee Kentucky 21129 1204 19
1093519 1093519 2021-03-06 Leslie Kentucky 21131 815 2
1093520 1093520 2021-03-06 Letcher Kentucky 21133 1711 30
1093521 1093521 2021-03-06 Lewis Kentucky 21135 1102 31
1093522 1093522 2021-03-06 Lincoln Kentucky 21137 2132 33
1093523 1093523 2021-03-06 Livingston Kentucky 21139 770 17
1093524 1093524 2021-03-06 Logan Kentucky 21141 2535 52
1093525 1093525 2021-03-06 Lyon Kentucky 21143 882 13
1093526 1093526 2021-03-06 Madison Kentucky 21151 8740 90
1093527 1093527 2021-03-06 Magoffin Kentucky 21153 880 1
1093528 1093528 2021-03-06 Marion Kentucky 21155 2166 25
1093529 1093529 2021-03-06 Marshall Kentucky 21157 2574 49
1093530 1093530 2021-03-06 Martin Kentucky 21159 947 12
1093531 1093531 2021-03-06 Mason Kentucky 21161 1470 28
1093532 1093532 2021-03-06 McCracken Kentucky 21145 5868 76
1093533 1093533 2021-03-06 McCreary Kentucky 21147 1808 27
1093534 1093534 2021-03-06 McLean Kentucky 21149 839 25
1093535 1093535 2021-03-06 Meade Kentucky 21163 1877 17
1093536 1093536 2021-03-06 Menifee Kentucky 21165 413 14
1093537 1093537 2021-03-06 Mercer Kentucky 21167 2378 35
1093538 1093538 2021-03-06 Metcalfe Kentucky 21169 977 20
1093539 1093539 2021-03-06 Monroe Kentucky 21171 1248 38
1093540 1093540 2021-03-06 Montgomery Kentucky 21173 2325 24
1093541 1093541 2021-03-06 Morgan Kentucky 21175 2040 1
1093542 1093542 2021-03-06 Muhlenberg Kentucky 21177 2778 55
1093543 1093543 2021-03-06 Nelson Kentucky 21179 4626 43
1093544 1093544 2021-03-06 Nicholas Kentucky 21181 467 6
1093545 1093545 2021-03-06 Ohio Kentucky 21183 2379 48
1093546 1093546 2021-03-06 Oldham Kentucky 21185 7025 69
1093547 1093547 2021-03-06 Owen Kentucky 21187 625 8
1093548 1093548 2021-03-06 Owsley Kentucky 21189 440 10
1093549 1093549 2021-03-06 Pendleton Kentucky 21191 954 1
1093550 1093550 2021-03-06 Perry Kentucky 21193 2390 40
1093551 1093551 2021-03-06 Pike Kentucky 21195 5203 60
1093552 1093552 2021-03-06 Powell Kentucky 21197 987 3
1093553 1093553 2021-03-06 Pulaski Kentucky 21199 5822 88

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