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 307
- Minnesota 299
- Mississippi 298
- Missouri 296
- Alabama 293
- Kansas 292
- Indiana 290
- South Dakota 290
- Georgia 289
- Iowa 288
- North Carolina 288
- Tennessee 287
- Texas 287
- Arkansas 281
- Nebraska 278
- Illinois 274
- Kentucky 269
- West Virginia 252
fips 18
county 1
- Clay · 5,158 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
917524 | 917524 | 2021-01-11 | Clay | Florida | 12019 | 13171 | 197 |
917612 | 917612 | 2021-01-11 | Clay | Georgia | 13061 | 199 | 3 |
917805 | 917805 | 2021-01-11 | Clay | Illinois | 17025 | 1288 | 37 |
917905 | 917905 | 2021-01-11 | Clay | Indiana | 18021 | 2084 | 32 |
918007 | 918007 | 2021-01-11 | Clay | Iowa | 19041 | 1633 | 17 |
918100 | 918100 | 2021-01-11 | Clay | Kansas | 20027 | 680 | 17 |
918218 | 918218 | 2021-01-11 | Clay | Kentucky | 21051 | 1964 | 10 |
918532 | 918532 | 2021-01-11 | Clay | Minnesota | 27027 | 6372 | 78 |
918619 | 918619 | 2021-01-11 | Clay | Mississippi | 28025 | 1507 | 31 |
918712 | 918712 | 2021-01-11 | Clay | Missouri | 29047 | 7872 | 113 |
918879 | 918879 | 2021-01-11 | Clay | Nebraska | 31035 | 586 | 11 |
919117 | 919117 | 2021-01-11 | Clay | North Carolina | 37043 | 494 | 5 |
919664 | 919664 | 2021-01-11 | Clay | South Dakota | 46027 | 1682 | 12 |
919731 | 919731 | 2021-01-11 | Clay | Tennessee | 47027 | 894 | 25 |
919852 | 919852 | 2021-01-11 | Clay | Texas | 48077 | 823 | 12 |
920295 | 920295 | 2021-01-11 | Clay | West Virginia | 54015 | 286 | 4 |
913961 | 913961 | 2021-01-10 | Clay | Alabama | 1027 | 1230 | 35 |
914068 | 914068 | 2021-01-10 | Clay | Arkansas | 5021 | 1422 | 35 |
914279 | 914279 | 2021-01-10 | Clay | Florida | 12019 | 13073 | 197 |
914367 | 914367 | 2021-01-10 | Clay | Georgia | 13061 | 198 | 3 |
914560 | 914560 | 2021-01-10 | Clay | Illinois | 17025 | 1287 | 37 |
914660 | 914660 | 2021-01-10 | Clay | Indiana | 18021 | 2067 | 32 |
914762 | 914762 | 2021-01-10 | Clay | Iowa | 19041 | 1621 | 17 |
914855 | 914855 | 2021-01-10 | Clay | Kansas | 20027 | 677 | 17 |
914973 | 914973 | 2021-01-10 | Clay | Kentucky | 21051 | 1954 | 10 |
915287 | 915287 | 2021-01-10 | Clay | Minnesota | 27027 | 6369 | 78 |
915374 | 915374 | 2021-01-10 | Clay | Mississippi | 28025 | 1496 | 31 |
915467 | 915467 | 2021-01-10 | Clay | Missouri | 29047 | 7671 | 113 |
915634 | 915634 | 2021-01-10 | Clay | Nebraska | 31035 | 584 | 11 |
915872 | 915872 | 2021-01-10 | Clay | North Carolina | 37043 | 490 | 5 |
916419 | 916419 | 2021-01-10 | Clay | South Dakota | 46027 | 1681 | 12 |
916486 | 916486 | 2021-01-10 | Clay | Tennessee | 47027 | 894 | 25 |
916607 | 916607 | 2021-01-10 | Clay | Texas | 48077 | 823 | 12 |
917050 | 917050 | 2021-01-10 | Clay | West Virginia | 54015 | 285 | 4 |
910716 | 910716 | 2021-01-09 | Clay | Alabama | 1027 | 1223 | 35 |
910823 | 910823 | 2021-01-09 | Clay | Arkansas | 5021 | 1411 | 35 |
911034 | 911034 | 2021-01-09 | Clay | Florida | 12019 | 12938 | 197 |
911122 | 911122 | 2021-01-09 | Clay | Georgia | 13061 | 198 | 3 |
911315 | 911315 | 2021-01-09 | Clay | Illinois | 17025 | 1285 | 37 |
911415 | 911415 | 2021-01-09 | Clay | Indiana | 18021 | 2044 | 32 |
911517 | 911517 | 2021-01-09 | Clay | Iowa | 19041 | 1619 | 17 |
911610 | 911610 | 2021-01-09 | Clay | Kansas | 20027 | 677 | 17 |
911728 | 911728 | 2021-01-09 | Clay | Kentucky | 21051 | 1951 | 9 |
912042 | 912042 | 2021-01-09 | Clay | Minnesota | 27027 | 6357 | 78 |
912129 | 912129 | 2021-01-09 | Clay | Mississippi | 28025 | 1480 | 31 |
912222 | 912222 | 2021-01-09 | Clay | Missouri | 29047 | 7671 | 113 |
912389 | 912389 | 2021-01-09 | Clay | Nebraska | 31035 | 583 | 11 |
912627 | 912627 | 2021-01-09 | Clay | North Carolina | 37043 | 483 | 5 |
913174 | 913174 | 2021-01-09 | Clay | South Dakota | 46027 | 1678 | 12 |
913241 | 913241 | 2021-01-09 | Clay | Tennessee | 47027 | 888 | 25 |
913362 | 913362 | 2021-01-09 | Clay | Texas | 48077 | 823 | 11 |
913805 | 913805 | 2021-01-09 | Clay | West Virginia | 54015 | 283 | 4 |
907471 | 907471 | 2021-01-08 | Clay | Alabama | 1027 | 1211 | 35 |
907578 | 907578 | 2021-01-08 | Clay | Arkansas | 5021 | 1401 | 35 |
907789 | 907789 | 2021-01-08 | Clay | Florida | 12019 | 12768 | 197 |
907877 | 907877 | 2021-01-08 | Clay | Georgia | 13061 | 195 | 3 |
908070 | 908070 | 2021-01-08 | Clay | Illinois | 17025 | 1275 | 37 |
908170 | 908170 | 2021-01-08 | Clay | Indiana | 18021 | 2014 | 32 |
908272 | 908272 | 2021-01-08 | Clay | Iowa | 19041 | 1616 | 17 |
908365 | 908365 | 2021-01-08 | Clay | Kansas | 20027 | 677 | 17 |
908483 | 908483 | 2021-01-08 | Clay | Kentucky | 21051 | 1808 | 9 |
908797 | 908797 | 2021-01-08 | Clay | Minnesota | 27027 | 6345 | 78 |
908884 | 908884 | 2021-01-08 | Clay | Mississippi | 28025 | 1468 | 30 |
908977 | 908977 | 2021-01-08 | Clay | Missouri | 29047 | 7671 | 113 |
909144 | 909144 | 2021-01-08 | Clay | Nebraska | 31035 | 575 | 11 |
909382 | 909382 | 2021-01-08 | Clay | North Carolina | 37043 | 467 | 5 |
909929 | 909929 | 2021-01-08 | Clay | South Dakota | 46027 | 1673 | 12 |
909996 | 909996 | 2021-01-08 | Clay | Tennessee | 47027 | 876 | 24 |
910117 | 910117 | 2021-01-08 | Clay | Texas | 48077 | 813 | 11 |
910560 | 910560 | 2021-01-08 | Clay | West Virginia | 54015 | 278 | 4 |
904225 | 904225 | 2021-01-07 | Clay | Alabama | 1027 | 1196 | 34 |
904332 | 904332 | 2021-01-07 | Clay | Arkansas | 5021 | 1396 | 35 |
904543 | 904543 | 2021-01-07 | Clay | Florida | 12019 | 12543 | 193 |
904631 | 904631 | 2021-01-07 | Clay | Georgia | 13061 | 191 | 3 |
904824 | 904824 | 2021-01-07 | Clay | Illinois | 17025 | 1268 | 37 |
904924 | 904924 | 2021-01-07 | Clay | Indiana | 18021 | 1996 | 32 |
905026 | 905026 | 2021-01-07 | Clay | Iowa | 19041 | 1609 | 17 |
905119 | 905119 | 2021-01-07 | Clay | Kansas | 20027 | 677 | 17 |
905237 | 905237 | 2021-01-07 | Clay | Kentucky | 21051 | 1779 | 9 |
905551 | 905551 | 2021-01-07 | Clay | Minnesota | 27027 | 6320 | 78 |
905638 | 905638 | 2021-01-07 | Clay | Mississippi | 28025 | 1458 | 30 |
905731 | 905731 | 2021-01-07 | Clay | Missouri | 29047 | 7609 | 112 |
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);