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

5,340 rows where county = "Clay" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Clay · 5,340
Link rowid date ▲ county state fips cases deaths
952985 2021-01-22 Clay Alabama 1027 1291 46
953092 2021-01-22 Clay Arkansas 5021 1525 40
953303 2021-01-22 Clay Florida 12019 14574 226
953391 2021-01-22 Clay Georgia 13061 212 3
953584 2021-01-22 Clay Illinois 17025 1333 40
953684 2021-01-22 Clay Indiana 18021 2218 32
953786 2021-01-22 Clay Iowa 19041 1714 21
953879 2021-01-22 Clay Kansas 20027 760 22
953997 2021-01-22 Clay Kentucky 21051 2114 16
954311 2021-01-22 Clay Minnesota 27027 6555 82
954398 2021-01-22 Clay Mississippi 28025 1642 37
954491 2021-01-22 Clay Missouri 29047 8505 120
954658 2021-01-22 Clay Nebraska 31035 607 11
954896 2021-01-22 Clay North Carolina 37043 552 5
955443 2021-01-22 Clay South Dakota 46027 1739 14
955510 2021-01-22 Clay Tennessee 47027 954 26
955631 2021-01-22 Clay Texas 48077 924 13
956074 2021-01-22 Clay West Virginia 54015 322 4
949740 2021-01-21 Clay Alabama 1027 1285 46
949847 2021-01-21 Clay Arkansas 5021 1513 39
950058 2021-01-21 Clay Florida 12019 14393 226
950146 2021-01-21 Clay Georgia 13061 211 3
950339 2021-01-21 Clay Illinois 17025 1322 40
950439 2021-01-21 Clay Indiana 18021 2209 32
950541 2021-01-21 Clay Iowa 19041 1707 21
950634 2021-01-21 Clay Kansas 20027 746 21
950752 2021-01-21 Clay Kentucky 21051 2099 16
951066 2021-01-21 Clay Minnesota 27027 6546 81
951153 2021-01-21 Clay Mississippi 28025 1627 35
951246 2021-01-21 Clay Missouri 29047 8421 120
951413 2021-01-21 Clay Nebraska 31035 606 11
951651 2021-01-21 Clay North Carolina 37043 548 5
952198 2021-01-21 Clay South Dakota 46027 1734 13
952265 2021-01-21 Clay Tennessee 47027 953 26
952386 2021-01-21 Clay Texas 48077 910 13
952829 2021-01-21 Clay West Virginia 54015 310 4
946494 2021-01-20 Clay Alabama 1027 1276 45
946601 2021-01-20 Clay Arkansas 5021 1502 39
946812 2021-01-20 Clay Florida 12019 14286 221
946900 2021-01-20 Clay Georgia 13061 209 3
947093 2021-01-20 Clay Illinois 17025 1314 40
947193 2021-01-20 Clay Indiana 18021 2199 32
947295 2021-01-20 Clay Iowa 19041 1698 20
947388 2021-01-20 Clay Kansas 20027 746 21
947506 2021-01-20 Clay Kentucky 21051 2076 16
947820 2021-01-20 Clay Minnesota 27027 6539 81
947907 2021-01-20 Clay Mississippi 28025 1613 35
948000 2021-01-20 Clay Missouri 29047 8370 120
948167 2021-01-20 Clay Nebraska 31035 603 11
948406 2021-01-20 Clay North Carolina 37043 543 5
948953 2021-01-20 Clay South Dakota 46027 1723 13
949020 2021-01-20 Clay Tennessee 47027 946 26
949141 2021-01-20 Clay Texas 48077 906 13
949584 2021-01-20 Clay West Virginia 54015 306 4
943247 2021-01-19 Clay Alabama 1027 1270 45
943354 2021-01-19 Clay Arkansas 5021 1486 39
943565 2021-01-19 Clay Florida 12019 14190 221
943653 2021-01-19 Clay Georgia 13061 207 3
943846 2021-01-19 Clay Illinois 17025 1312 40
943946 2021-01-19 Clay Indiana 18021 2190 32
944048 2021-01-19 Clay Iowa 19041 1688 20
944141 2021-01-19 Clay Kansas 20027 746 21
944259 2021-01-19 Clay Kentucky 21051 2061 15
944573 2021-01-19 Clay Minnesota 27027 6532 80
944660 2021-01-19 Clay Mississippi 28025 1598 33
944753 2021-01-19 Clay Missouri 29047 8320 119
944920 2021-01-19 Clay Nebraska 31035 598 11
945159 2021-01-19 Clay North Carolina 37043 535 5
945707 2021-01-19 Clay South Dakota 46027 1722 13
945774 2021-01-19 Clay Tennessee 47027 940 26
945895 2021-01-19 Clay Texas 48077 874 13
946338 2021-01-19 Clay West Virginia 54015 303 4
940002 2021-01-18 Clay Alabama 1027 1267 45
940109 2021-01-18 Clay Arkansas 5021 1479 39
940320 2021-01-18 Clay Florida 12019 14084 221
940408 2021-01-18 Clay Georgia 13061 206 3
940601 2021-01-18 Clay Illinois 17025 1309 39
940701 2021-01-18 Clay Indiana 18021 2187 32
940803 2021-01-18 Clay Iowa 19041 1673 19
940896 2021-01-18 Clay Kansas 20027 746 21
941014 2021-01-18 Clay Kentucky 21051 2054 14
941328 2021-01-18 Clay Minnesota 27027 6516 80
941415 2021-01-18 Clay Mississippi 28025 1594 33
941508 2021-01-18 Clay Missouri 29047 8179 119
941675 2021-01-18 Clay Nebraska 31035 598 11
941913 2021-01-18 Clay North Carolina 37043 533 5
942460 2021-01-18 Clay South Dakota 46027 1722 13
942527 2021-01-18 Clay Tennessee 47027 939 26
942648 2021-01-18 Clay Texas 48077 874 13
943091 2021-01-18 Clay West Virginia 54015 301 4
936757 2021-01-17 Clay Alabama 1027 1261 45
936864 2021-01-17 Clay Arkansas 5021 1477 39
937075 2021-01-17 Clay Florida 12019 14000 221
937163 2021-01-17 Clay Georgia 13061 205 3
937356 2021-01-17 Clay Illinois 17025 1309 39
937456 2021-01-17 Clay Indiana 18021 2179 32
937558 2021-01-17 Clay Iowa 19041 1660 19
937651 2021-01-17 Clay Kansas 20027 746 21
937769 2021-01-17 Clay Kentucky 21051 2039 14
938083 2021-01-17 Clay Minnesota 27027 6502 80

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