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

10,272 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 · 10,272 ✖
Link rowid date ▲ county state fips cases deaths
1842619 1842619 2021-10-23 Clay Alabama 1027 2433 68
1842728 1842728 2021-10-23 Clay Arkansas 5021 2704 68
1842939 1842939 2021-10-23 Clay Florida 12019 33738 685
1843027 1843027 2021-10-23 Clay Georgia 13061 314 4
1843221 1843221 2021-10-23 Clay Illinois 17025 2598 59
1843322 1843322 2021-10-23 Clay Indiana 18021 4234 61
1843424 1843424 2021-10-23 Clay Iowa 19041 2791 33
1843517 1843517 2021-10-23 Clay Kansas 20027 1234 31
1843634 1843634 2021-10-23 Clay Kentucky 21051 5099 57
1843948 1843948 2021-10-23 Clay Minnesota 27027 10253 99
1844035 1844035 2021-10-23 Clay Mississippi 28025 3080 76
1844128 1844128 2021-10-23 Clay Missouri 29047 14865 215
1844295 1844295 2021-10-23 Clay Nebraska 31035 900 17
1844534 1844534 2021-10-23 Clay North Carolina 37043 1647 36
1845082 1845082 2021-10-23 Clay South Dakota 46027 2187 18
1845149 1845149 2021-10-23 Clay Tennessee 47027 1517 37
1845270 1845270 2021-10-23 Clay Texas 48077 1537 23
1845713 1845713 2021-10-23 Clay West Virginia 54015 1211 19
1839370 1839370 2021-10-22 Clay Alabama 1027 2430 68
1839478 1839478 2021-10-22 Clay Arkansas 5021 2701 68
1839689 1839689 2021-10-22 Clay Florida 12019 33738 685
1839777 1839777 2021-10-22 Clay Georgia 13061 314 4
1839971 1839971 2021-10-22 Clay Illinois 17025 2598 59
1840072 1840072 2021-10-22 Clay Indiana 18021 4234 61
1840174 1840174 2021-10-22 Clay Iowa 19041 2791 33
1840267 1840267 2021-10-22 Clay Kansas 20027 1234 31
1840384 1840384 2021-10-22 Clay Kentucky 21051 5099 57
1840698 1840698 2021-10-22 Clay Minnesota 27027 10253 99
1840785 1840785 2021-10-22 Clay Mississippi 28025 3080 76
1840878 1840878 2021-10-22 Clay Missouri 29047 14847 215
1841045 1841045 2021-10-22 Clay Nebraska 31035 900 17
1841284 1841284 2021-10-22 Clay North Carolina 37043 1647 36
1841832 1841832 2021-10-22 Clay South Dakota 46027 2187 18
1841899 1841899 2021-10-22 Clay Tennessee 47027 1517 37
1842020 1842020 2021-10-22 Clay Texas 48077 1535 23
1842463 1842463 2021-10-22 Clay West Virginia 54015 1206 19
1836121 1836121 2021-10-21 Clay Alabama 1027 2417 68
1836229 1836229 2021-10-21 Clay Arkansas 5021 2700 68
1836440 1836440 2021-10-21 Clay Florida 12019 33642 685
1836528 1836528 2021-10-21 Clay Georgia 13061 314 4
1836722 1836722 2021-10-21 Clay Illinois 17025 2592 59
1836823 1836823 2021-10-21 Clay Indiana 18021 4221 61
1836925 1836925 2021-10-21 Clay Iowa 19041 2791 33
1837018 1837018 2021-10-21 Clay Kansas 20027 1227 31
1837135 1837135 2021-10-21 Clay Kentucky 21051 5097 56
1837449 1837449 2021-10-21 Clay Minnesota 27027 10235 99
1837536 1837536 2021-10-21 Clay Mississippi 28025 3079 76
1837629 1837629 2021-10-21 Clay Missouri 29047 14817 215
1837796 1837796 2021-10-21 Clay Nebraska 31035 900 17
1838035 1838035 2021-10-21 Clay North Carolina 37043 1646 35
1838583 1838583 2021-10-21 Clay South Dakota 46027 2186 18
1838650 1838650 2021-10-21 Clay Tennessee 47027 1516 36
1838771 1838771 2021-10-21 Clay Texas 48077 1533 23
1839214 1839214 2021-10-21 Clay West Virginia 54015 1203 18
1832872 1832872 2021-10-20 Clay Alabama 1027 2412 68
1832980 1832980 2021-10-20 Clay Arkansas 5021 2695 67
1833191 1833191 2021-10-20 Clay Florida 12019 33642 685
1833279 1833279 2021-10-20 Clay Georgia 13061 314 4
1833473 1833473 2021-10-20 Clay Illinois 17025 2587 59
1833574 1833574 2021-10-20 Clay Indiana 18021 4214 61
1833676 1833676 2021-10-20 Clay Iowa 19041 2791 33
1833769 1833769 2021-10-20 Clay Kansas 20027 1227 31
1833886 1833886 2021-10-20 Clay Kentucky 21051 5094 56
1834200 1834200 2021-10-20 Clay Minnesota 27027 10180 99
1834287 1834287 2021-10-20 Clay Mississippi 28025 3076 76
1834380 1834380 2021-10-20 Clay Missouri 29047 14790 215
1834547 1834547 2021-10-20 Clay Nebraska 31035 897 17
1834786 1834786 2021-10-20 Clay North Carolina 37043 1646 35
1835334 1835334 2021-10-20 Clay South Dakota 46027 2177 18
1835401 1835401 2021-10-20 Clay Tennessee 47027 1512 36
1835522 1835522 2021-10-20 Clay Texas 48077 1526 23
1835965 1835965 2021-10-20 Clay West Virginia 54015 1190 18
1829623 1829623 2021-10-19 Clay Alabama 1027 2411 68
1829731 1829731 2021-10-19 Clay Arkansas 5021 2693 66
1829942 1829942 2021-10-19 Clay Florida 12019 33642 685
1830030 1830030 2021-10-19 Clay Georgia 13061 314 4
1830224 1830224 2021-10-19 Clay Illinois 17025 2588 59
1830325 1830325 2021-10-19 Clay Indiana 18021 4207 61
1830427 1830427 2021-10-19 Clay Iowa 19041 2748 31
1830520 1830520 2021-10-19 Clay Kansas 20027 1207 31
1830637 1830637 2021-10-19 Clay Kentucky 21051 5086 56
1830951 1830951 2021-10-19 Clay Minnesota 27027 10160 98
1831038 1831038 2021-10-19 Clay Mississippi 28025 3073 76
1831131 1831131 2021-10-19 Clay Missouri 29047 14763 215
1831298 1831298 2021-10-19 Clay Nebraska 31035 895 17
1831537 1831537 2021-10-19 Clay North Carolina 37043 1642 35
1832085 1832085 2021-10-19 Clay South Dakota 46027 2166 18
1832152 1832152 2021-10-19 Clay Tennessee 47027 1506 36
1832273 1832273 2021-10-19 Clay Texas 48077 1524 23
1832716 1832716 2021-10-19 Clay West Virginia 54015 1187 17
1826374 1826374 2021-10-18 Clay Alabama 1027 2408 67
1826482 1826482 2021-10-18 Clay Arkansas 5021 2690 66
1826693 1826693 2021-10-18 Clay Florida 12019 33642 685
1826781 1826781 2021-10-18 Clay Georgia 13061 314 4
1826975 1826975 2021-10-18 Clay Illinois 17025 2582 59
1827076 1827076 2021-10-18 Clay Indiana 18021 4203 61
1827178 1827178 2021-10-18 Clay Iowa 19041 2748 31
1827271 1827271 2021-10-18 Clay Kansas 20027 1207 31
1827388 1827388 2021-10-18 Clay Kentucky 21051 5083 56
1827702 1827702 2021-10-18 Clay Minnesota 27027 10117 98

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