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