ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,908 rows where county = "Clay" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 18
- Florida 311
- Minnesota 303
- Mississippi 303
- Missouri 301
- Alabama 298
- Kansas 296
- South Dakota 295
- Indiana 294
- Georgia 293
- North Carolina 293
- Iowa 292
- Tennessee 292
- Texas 292
- Arkansas 286
- Nebraska 283
- Illinois 278
- Kentucky 273
- West Virginia 257
fips 18
county 1
- Clay · 5,240 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
938090 | 938090 | 2021-01-17 | Clay | Mississippi | 28025 | 1590 | 33 |
938183 | 938183 | 2021-01-17 | Clay | Missouri | 29047 | 8179 | 118 |
938350 | 938350 | 2021-01-17 | Clay | Nebraska | 31035 | 598 | 11 |
938588 | 938588 | 2021-01-17 | Clay | North Carolina | 37043 | 533 | 5 |
939135 | 939135 | 2021-01-17 | Clay | South Dakota | 46027 | 1720 | 13 |
939202 | 939202 | 2021-01-17 | Clay | Tennessee | 47027 | 937 | 26 |
939323 | 939323 | 2021-01-17 | Clay | Texas | 48077 | 874 | 13 |
939766 | 939766 | 2021-01-17 | Clay | West Virginia | 54015 | 299 | 4 |
933432 | 933432 | 2021-01-16 | Clay | Alabama | 1027 | 1261 | 45 |
933539 | 933539 | 2021-01-16 | Clay | Arkansas | 5021 | 1476 | 39 |
933750 | 933750 | 2021-01-16 | Clay | Florida | 12019 | 13904 | 221 |
933838 | 933838 | 2021-01-16 | Clay | Georgia | 13061 | 204 | 3 |
934031 | 934031 | 2021-01-16 | Clay | Illinois | 17025 | 1304 | 39 |
934131 | 934131 | 2021-01-16 | Clay | Indiana | 18021 | 2164 | 32 |
934233 | 934233 | 2021-01-16 | Clay | Iowa | 19041 | 1660 | 19 |
934326 | 934326 | 2021-01-16 | Clay | Kansas | 20027 | 746 | 21 |
934444 | 934444 | 2021-01-16 | Clay | Kentucky | 21051 | 2035 | 14 |
934758 | 934758 | 2021-01-16 | Clay | Minnesota | 27027 | 6484 | 78 |
934845 | 934845 | 2021-01-16 | Clay | Mississippi | 28025 | 1582 | 33 |
934938 | 934938 | 2021-01-16 | Clay | Missouri | 29047 | 8179 | 118 |
935105 | 935105 | 2021-01-16 | Clay | Nebraska | 31035 | 598 | 11 |
935343 | 935343 | 2021-01-16 | Clay | North Carolina | 37043 | 531 | 5 |
935890 | 935890 | 2021-01-16 | Clay | South Dakota | 46027 | 1715 | 12 |
935957 | 935957 | 2021-01-16 | Clay | Tennessee | 47027 | 934 | 26 |
936078 | 936078 | 2021-01-16 | Clay | Texas | 48077 | 874 | 13 |
936521 | 936521 | 2021-01-16 | Clay | West Virginia | 54015 | 300 | 4 |
930187 | 930187 | 2021-01-15 | Clay | Alabama | 1027 | 1252 | 46 |
930294 | 930294 | 2021-01-15 | Clay | Arkansas | 5021 | 1467 | 38 |
930505 | 930505 | 2021-01-15 | Clay | Florida | 12019 | 13781 | 210 |
930593 | 930593 | 2021-01-15 | Clay | Georgia | 13061 | 204 | 3 |
930786 | 930786 | 2021-01-15 | Clay | Illinois | 17025 | 1301 | 38 |
930886 | 930886 | 2021-01-15 | Clay | Indiana | 18021 | 2147 | 32 |
930988 | 930988 | 2021-01-15 | Clay | Iowa | 19041 | 1655 | 19 |
931081 | 931081 | 2021-01-15 | Clay | Kansas | 20027 | 716 | 17 |
931199 | 931199 | 2021-01-15 | Clay | Kentucky | 21051 | 2025 | 12 |
931513 | 931513 | 2021-01-15 | Clay | Minnesota | 27027 | 6466 | 78 |
931600 | 931600 | 2021-01-15 | Clay | Mississippi | 28025 | 1567 | 32 |
931693 | 931693 | 2021-01-15 | Clay | Missouri | 29047 | 8179 | 118 |
931860 | 931860 | 2021-01-15 | Clay | Nebraska | 31035 | 598 | 11 |
932098 | 932098 | 2021-01-15 | Clay | North Carolina | 37043 | 519 | 5 |
932645 | 932645 | 2021-01-15 | Clay | South Dakota | 46027 | 1711 | 12 |
932712 | 932712 | 2021-01-15 | Clay | Tennessee | 47027 | 920 | 26 |
932833 | 932833 | 2021-01-15 | Clay | Texas | 48077 | 870 | 13 |
933276 | 933276 | 2021-01-15 | Clay | West Virginia | 54015 | 295 | 4 |
926942 | 926942 | 2021-01-14 | Clay | Alabama | 1027 | 1244 | 46 |
927049 | 927049 | 2021-01-14 | Clay | Arkansas | 5021 | 1457 | 38 |
927260 | 927260 | 2021-01-14 | Clay | Florida | 12019 | 13618 | 209 |
927348 | 927348 | 2021-01-14 | Clay | Georgia | 13061 | 203 | 3 |
927541 | 927541 | 2021-01-14 | Clay | Illinois | 17025 | 1298 | 38 |
927641 | 927641 | 2021-01-14 | Clay | Indiana | 18021 | 2124 | 32 |
927743 | 927743 | 2021-01-14 | Clay | Iowa | 19041 | 1653 | 19 |
927836 | 927836 | 2021-01-14 | Clay | Kansas | 20027 | 716 | 17 |
927954 | 927954 | 2021-01-14 | Clay | Kentucky | 21051 | 2009 | 12 |
928268 | 928268 | 2021-01-14 | Clay | Minnesota | 27027 | 6432 | 78 |
928355 | 928355 | 2021-01-14 | Clay | Mississippi | 28025 | 1556 | 32 |
928448 | 928448 | 2021-01-14 | Clay | Missouri | 29047 | 8129 | 118 |
928615 | 928615 | 2021-01-14 | Clay | Nebraska | 31035 | 594 | 11 |
928853 | 928853 | 2021-01-14 | Clay | North Carolina | 37043 | 510 | 5 |
929400 | 929400 | 2021-01-14 | Clay | South Dakota | 46027 | 1701 | 12 |
929467 | 929467 | 2021-01-14 | Clay | Tennessee | 47027 | 906 | 26 |
929588 | 929588 | 2021-01-14 | Clay | Texas | 48077 | 863 | 13 |
930031 | 930031 | 2021-01-14 | Clay | West Virginia | 54015 | 291 | 4 |
923696 | 923696 | 2021-01-13 | Clay | Alabama | 1027 | 1237 | 43 |
923803 | 923803 | 2021-01-13 | Clay | Arkansas | 5021 | 1447 | 36 |
924014 | 924014 | 2021-01-13 | Clay | Florida | 12019 | 13496 | 209 |
924102 | 924102 | 2021-01-13 | Clay | Georgia | 13061 | 200 | 3 |
924295 | 924295 | 2021-01-13 | Clay | Illinois | 17025 | 1296 | 37 |
924395 | 924395 | 2021-01-13 | Clay | Indiana | 18021 | 2105 | 32 |
924497 | 924497 | 2021-01-13 | Clay | Iowa | 19041 | 1648 | 19 |
924590 | 924590 | 2021-01-13 | Clay | Kansas | 20027 | 716 | 17 |
924708 | 924708 | 2021-01-13 | Clay | Kentucky | 21051 | 1991 | 11 |
925022 | 925022 | 2021-01-13 | Clay | Minnesota | 27027 | 6410 | 78 |
925109 | 925109 | 2021-01-13 | Clay | Mississippi | 28025 | 1538 | 32 |
925202 | 925202 | 2021-01-13 | Clay | Missouri | 29047 | 8088 | 118 |
925369 | 925369 | 2021-01-13 | Clay | Nebraska | 31035 | 590 | 11 |
925608 | 925608 | 2021-01-13 | Clay | North Carolina | 37043 | 506 | 5 |
926155 | 926155 | 2021-01-13 | Clay | South Dakota | 46027 | 1698 | 12 |
926222 | 926222 | 2021-01-13 | Clay | Tennessee | 47027 | 900 | 25 |
926343 | 926343 | 2021-01-13 | Clay | Texas | 48077 | 860 | 12 |
926786 | 926786 | 2021-01-13 | Clay | West Virginia | 54015 | 289 | 4 |
920451 | 920451 | 2021-01-12 | Clay | Alabama | 1027 | 1231 | 36 |
920558 | 920558 | 2021-01-12 | Clay | Arkansas | 5021 | 1437 | 36 |
920769 | 920769 | 2021-01-12 | Clay | Florida | 12019 | 13340 | 198 |
920857 | 920857 | 2021-01-12 | Clay | Georgia | 13061 | 200 | 3 |
921050 | 921050 | 2021-01-12 | Clay | Illinois | 17025 | 1293 | 37 |
921150 | 921150 | 2021-01-12 | Clay | Indiana | 18021 | 2090 | 32 |
921252 | 921252 | 2021-01-12 | Clay | Iowa | 19041 | 1636 | 19 |
921345 | 921345 | 2021-01-12 | Clay | Kansas | 20027 | 680 | 17 |
921463 | 921463 | 2021-01-12 | Clay | Kentucky | 21051 | 1986 | 10 |
921777 | 921777 | 2021-01-12 | Clay | Minnesota | 27027 | 6392 | 78 |
921864 | 921864 | 2021-01-12 | Clay | Mississippi | 28025 | 1524 | 31 |
921957 | 921957 | 2021-01-12 | Clay | Missouri | 29047 | 7927 | 117 |
922124 | 922124 | 2021-01-12 | Clay | Nebraska | 31035 | 589 | 11 |
922362 | 922362 | 2021-01-12 | Clay | North Carolina | 37043 | 496 | 5 |
922909 | 922909 | 2021-01-12 | Clay | South Dakota | 46027 | 1691 | 12 |
922976 | 922976 | 2021-01-12 | Clay | Tennessee | 47027 | 896 | 25 |
923097 | 923097 | 2021-01-12 | Clay | Texas | 48077 | 852 | 12 |
923540 | 923540 | 2021-01-12 | Clay | West Virginia | 54015 | 288 | 4 |
917206 | 917206 | 2021-01-11 | Clay | Alabama | 1027 | 1233 | 35 |
917313 | 917313 | 2021-01-11 | Clay | Arkansas | 5021 | 1425 | 36 |
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]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);