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

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

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

  • Clay · 5,970 ✖
Link rowid date ▲ county state fips cases deaths
1066501 1066501 2021-02-26 Clay Alabama 1027 1434 54
1066608 1066608 2021-02-26 Clay Arkansas 5021 1679 46
1066819 1066819 2021-02-26 Clay Florida 12019 16673 304
1066907 1066907 2021-02-26 Clay Georgia 13061 230 3
1067100 1067100 2021-02-26 Clay Illinois 17025 1429 46
1067201 1067201 2021-02-26 Clay Indiana 18021 2403 44
1067303 1067303 2021-02-26 Clay Iowa 19041 1823 25
1067396 1067396 2021-02-26 Clay Kansas 20027 818 27
1067514 1067514 2021-02-26 Clay Kentucky 21051 2382 26
1067827 1067827 2021-02-26 Clay Minnesota 27027 6867 87
1067914 1067914 2021-02-26 Clay Mississippi 28025 1782 50
1068007 1068007 2021-02-26 Clay Missouri 29047 9502 144
1068174 1068174 2021-02-26 Clay Nebraska 31035 649 11
1068412 1068412 2021-02-26 Clay North Carolina 37043 655 18
1068959 1068959 2021-02-26 Clay South Dakota 46027 1787 15
1069026 1069026 2021-02-26 Clay Tennessee 47027 1065 30
1069147 1069147 2021-02-26 Clay Texas 48077 991 16
1069590 1069590 2021-02-26 Clay West Virginia 54015 376 4
1063256 1063256 2021-02-25 Clay Alabama 1027 1433 54
1063363 1063363 2021-02-25 Clay Arkansas 5021 1676 46
1063574 1063574 2021-02-25 Clay Florida 12019 16641 304
1063662 1063662 2021-02-25 Clay Georgia 13061 229 3
1063855 1063855 2021-02-25 Clay Illinois 17025 1426 46
1063956 1063956 2021-02-25 Clay Indiana 18021 2397 44
1064058 1064058 2021-02-25 Clay Iowa 19041 1823 25
1064151 1064151 2021-02-25 Clay Kansas 20027 818 24
1064269 1064269 2021-02-25 Clay Kentucky 21051 2378 26
1064582 1064582 2021-02-25 Clay Minnesota 27027 6853 86
1064669 1064669 2021-02-25 Clay Mississippi 28025 1781 49
1064762 1064762 2021-02-25 Clay Missouri 29047 9488 143
1064929 1064929 2021-02-25 Clay Nebraska 31035 649 11
1065167 1065167 2021-02-25 Clay North Carolina 37043 649 18
1065714 1065714 2021-02-25 Clay South Dakota 46027 1786 15
1065781 1065781 2021-02-25 Clay Tennessee 47027 1065 30
1065902 1065902 2021-02-25 Clay Texas 48077 990 16
1066345 1066345 2021-02-25 Clay West Virginia 54015 372 4
1060011 1060011 2021-02-24 Clay Alabama 1027 1432 54
1060118 1060118 2021-02-24 Clay Arkansas 5021 1673 46
1060329 1060329 2021-02-24 Clay Florida 12019 16603 299
1060417 1060417 2021-02-24 Clay Georgia 13061 228 3
1060610 1060610 2021-02-24 Clay Illinois 17025 1425 46
1060711 1060711 2021-02-24 Clay Indiana 18021 2394 44
1060813 1060813 2021-02-24 Clay Iowa 19041 1823 25
1060906 1060906 2021-02-24 Clay Kansas 20027 818 24
1061024 1061024 2021-02-24 Clay Kentucky 21051 2372 26
1061338 1061338 2021-02-24 Clay Minnesota 27027 6836 86
1061425 1061425 2021-02-24 Clay Mississippi 28025 1778 48
1061518 1061518 2021-02-24 Clay Missouri 29047 9477 143
1061685 1061685 2021-02-24 Clay Nebraska 31035 650 11
1061923 1061923 2021-02-24 Clay North Carolina 37043 649 18
1062469 1062469 2021-02-24 Clay South Dakota 46027 1786 15
1062536 1062536 2021-02-24 Clay Tennessee 47027 1062 30
1062657 1062657 2021-02-24 Clay Texas 48077 990 16
1063100 1063100 2021-02-24 Clay West Virginia 54015 371 4
1056765 1056765 2021-02-23 Clay Alabama 1027 1425 54
1056872 1056872 2021-02-23 Clay Arkansas 5021 1669 46
1057083 1057083 2021-02-23 Clay Florida 12019 16571 299
1057171 1057171 2021-02-23 Clay Georgia 13061 228 3
1057364 1057364 2021-02-23 Clay Illinois 17025 1422 46
1057465 1057465 2021-02-23 Clay Indiana 18021 2389 44
1057567 1057567 2021-02-23 Clay Iowa 19041 1823 25
1057660 1057660 2021-02-23 Clay Kansas 20027 818 24
1057778 1057778 2021-02-23 Clay Kentucky 21051 2365 26
1058092 1058092 2021-02-23 Clay Minnesota 27027 6822 84
1058179 1058179 2021-02-23 Clay Mississippi 28025 1773 48
1058272 1058272 2021-02-23 Clay Missouri 29047 9434 143
1058439 1058439 2021-02-23 Clay Nebraska 31035 649 11
1058677 1058677 2021-02-23 Clay North Carolina 37043 648 18
1059224 1059224 2021-02-23 Clay South Dakota 46027 1783 15
1059291 1059291 2021-02-23 Clay Tennessee 47027 1060 30
1059412 1059412 2021-02-23 Clay Texas 48077 989 16
1059855 1059855 2021-02-23 Clay West Virginia 54015 370 4
1053519 1053519 2021-02-22 Clay Alabama 1027 1422 54
1053626 1053626 2021-02-22 Clay Arkansas 5021 1665 46
1053837 1053837 2021-02-22 Clay Florida 12019 16546 299
1053925 1053925 2021-02-22 Clay Georgia 13061 228 3
1054118 1054118 2021-02-22 Clay Illinois 17025 1421 46
1054219 1054219 2021-02-22 Clay Indiana 18021 2388 44
1054321 1054321 2021-02-22 Clay Iowa 19041 1823 25
1054414 1054414 2021-02-22 Clay Kansas 20027 818 24
1054532 1054532 2021-02-22 Clay Kentucky 21051 2351 26
1054846 1054846 2021-02-22 Clay Minnesota 27027 6807 84
1054933 1054933 2021-02-22 Clay Mississippi 28025 1772 48
1055026 1055026 2021-02-22 Clay Missouri 29047 9414 143
1055193 1055193 2021-02-22 Clay Nebraska 31035 649 11
1055431 1055431 2021-02-22 Clay North Carolina 37043 648 18
1055978 1055978 2021-02-22 Clay South Dakota 46027 1781 15
1056045 1056045 2021-02-22 Clay Tennessee 47027 1056 30
1056166 1056166 2021-02-22 Clay Texas 48077 988 16
1056609 1056609 2021-02-22 Clay West Virginia 54015 370 4
1050272 1050272 2021-02-21 Clay Alabama 1027 1419 54
1050379 1050379 2021-02-21 Clay Arkansas 5021 1663 46
1050590 1050590 2021-02-21 Clay Florida 12019 16524 299
1050678 1050678 2021-02-21 Clay Georgia 13061 228 3
1050871 1050871 2021-02-21 Clay Illinois 17025 1421 46
1050972 1050972 2021-02-21 Clay Indiana 18021 2382 43
1051074 1051074 2021-02-21 Clay Iowa 19041 1823 25
1051167 1051167 2021-02-21 Clay Kansas 20027 817 24
1051285 1051285 2021-02-21 Clay Kentucky 21051 2348 26
1051599 1051599 2021-02-21 Clay Minnesota 27027 6803 84

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