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 341
- Minnesota 333
- Mississippi 332
- Missouri 330
- Alabama 327
- Kansas 326
- Indiana 324
- South Dakota 324
- Georgia 323
- Iowa 322
- North Carolina 322
- Tennessee 321
- Texas 321
- Arkansas 315
- Nebraska 312
- Illinois 308
- Kentucky 303
- West Virginia 286
fips 18
county 1
- Clay · 5,770 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1031117 | 1031117 | 2021-02-15 | Clay | Florida | 12019 | 16267 | 283 |
1031205 | 1031205 | 2021-02-15 | Clay | Georgia | 13061 | 227 | 3 |
1031398 | 1031398 | 2021-02-15 | Clay | Illinois | 17025 | 1411 | 46 |
1031499 | 1031499 | 2021-02-15 | Clay | Indiana | 18021 | 2364 | 42 |
1031601 | 1031601 | 2021-02-15 | Clay | Iowa | 19041 | 1814 | 25 |
1031694 | 1031694 | 2021-02-15 | Clay | Kansas | 20027 | 816 | 23 |
1031812 | 1031812 | 2021-02-15 | Clay | Kentucky | 21051 | 2329 | 26 |
1032126 | 1032126 | 2021-02-15 | Clay | Minnesota | 27027 | 6740 | 84 |
1032213 | 1032213 | 2021-02-15 | Clay | Mississippi | 28025 | 1763 | 46 |
1032306 | 1032306 | 2021-02-15 | Clay | Missouri | 29047 | 9256 | 137 |
1032473 | 1032473 | 2021-02-15 | Clay | Nebraska | 31035 | 650 | 11 |
1032711 | 1032711 | 2021-02-15 | Clay | North Carolina | 37043 | 633 | 18 |
1033258 | 1033258 | 2021-02-15 | Clay | South Dakota | 46027 | 1774 | 15 |
1033325 | 1033325 | 2021-02-15 | Clay | Tennessee | 47027 | 1056 | 29 |
1033446 | 1033446 | 2021-02-15 | Clay | Texas | 48077 | 983 | 16 |
1033889 | 1033889 | 2021-02-15 | Clay | West Virginia | 54015 | 369 | 4 |
1027552 | 1027552 | 2021-02-14 | Clay | Alabama | 1027 | 1393 | 53 |
1027659 | 1027659 | 2021-02-14 | Clay | Arkansas | 5021 | 1654 | 44 |
1027870 | 1027870 | 2021-02-14 | Clay | Florida | 12019 | 16227 | 283 |
1027958 | 1027958 | 2021-02-14 | Clay | Georgia | 13061 | 227 | 3 |
1028151 | 1028151 | 2021-02-14 | Clay | Illinois | 17025 | 1409 | 46 |
1028252 | 1028252 | 2021-02-14 | Clay | Indiana | 18021 | 2362 | 42 |
1028354 | 1028354 | 2021-02-14 | Clay | Iowa | 19041 | 1809 | 25 |
1028447 | 1028447 | 2021-02-14 | Clay | Kansas | 20027 | 816 | 23 |
1028565 | 1028565 | 2021-02-14 | Clay | Kentucky | 21051 | 2322 | 26 |
1028879 | 1028879 | 2021-02-14 | Clay | Minnesota | 27027 | 6735 | 84 |
1028966 | 1028966 | 2021-02-14 | Clay | Mississippi | 28025 | 1763 | 46 |
1029059 | 1029059 | 2021-02-14 | Clay | Missouri | 29047 | 9256 | 137 |
1029226 | 1029226 | 2021-02-14 | Clay | Nebraska | 31035 | 650 | 11 |
1029465 | 1029465 | 2021-02-14 | Clay | North Carolina | 37043 | 631 | 18 |
1030012 | 1030012 | 2021-02-14 | Clay | South Dakota | 46027 | 1773 | 15 |
1030079 | 1030079 | 2021-02-14 | Clay | Tennessee | 47027 | 1056 | 29 |
1030200 | 1030200 | 2021-02-14 | Clay | Texas | 48077 | 983 | 16 |
1030643 | 1030643 | 2021-02-14 | Clay | West Virginia | 54015 | 366 | 4 |
1024307 | 1024307 | 2021-02-13 | Clay | Alabama | 1027 | 1390 | 53 |
1024414 | 1024414 | 2021-02-13 | Clay | Arkansas | 5021 | 1654 | 44 |
1024625 | 1024625 | 2021-02-13 | Clay | Florida | 12019 | 16189 | 283 |
1024713 | 1024713 | 2021-02-13 | Clay | Georgia | 13061 | 227 | 3 |
1024906 | 1024906 | 2021-02-13 | Clay | Illinois | 17025 | 1409 | 45 |
1025007 | 1025007 | 2021-02-13 | Clay | Indiana | 18021 | 2361 | 42 |
1025109 | 1025109 | 2021-02-13 | Clay | Iowa | 19041 | 1809 | 25 |
1025202 | 1025202 | 2021-02-13 | Clay | Kansas | 20027 | 816 | 23 |
1025320 | 1025320 | 2021-02-13 | Clay | Kentucky | 21051 | 2313 | 26 |
1025633 | 1025633 | 2021-02-13 | Clay | Minnesota | 27027 | 6729 | 84 |
1025720 | 1025720 | 2021-02-13 | Clay | Mississippi | 28025 | 1761 | 46 |
1025813 | 1025813 | 2021-02-13 | Clay | Missouri | 29047 | 9256 | 137 |
1025980 | 1025980 | 2021-02-13 | Clay | Nebraska | 31035 | 649 | 11 |
1026218 | 1026218 | 2021-02-13 | Clay | North Carolina | 37043 | 628 | 18 |
1026765 | 1026765 | 2021-02-13 | Clay | South Dakota | 46027 | 1771 | 15 |
1026832 | 1026832 | 2021-02-13 | Clay | Tennessee | 47027 | 1056 | 29 |
1026953 | 1026953 | 2021-02-13 | Clay | Texas | 48077 | 983 | 16 |
1027396 | 1027396 | 2021-02-13 | Clay | West Virginia | 54015 | 365 | 4 |
1021062 | 1021062 | 2021-02-12 | Clay | Alabama | 1027 | 1389 | 53 |
1021169 | 1021169 | 2021-02-12 | Clay | Arkansas | 5021 | 1652 | 44 |
1021380 | 1021380 | 2021-02-12 | Clay | Florida | 12019 | 16129 | 283 |
1021468 | 1021468 | 2021-02-12 | Clay | Georgia | 13061 | 227 | 3 |
1021661 | 1021661 | 2021-02-12 | Clay | Illinois | 17025 | 1408 | 45 |
1021762 | 1021762 | 2021-02-12 | Clay | Indiana | 18021 | 2356 | 42 |
1021864 | 1021864 | 2021-02-12 | Clay | Iowa | 19041 | 1809 | 25 |
1021957 | 1021957 | 2021-02-12 | Clay | Kansas | 20027 | 816 | 23 |
1022075 | 1022075 | 2021-02-12 | Clay | Kentucky | 21051 | 2308 | 26 |
1022388 | 1022388 | 2021-02-12 | Clay | Minnesota | 27027 | 6729 | 83 |
1022475 | 1022475 | 2021-02-12 | Clay | Mississippi | 28025 | 1760 | 46 |
1022568 | 1022568 | 2021-02-12 | Clay | Missouri | 29047 | 9256 | 137 |
1022735 | 1022735 | 2021-02-12 | Clay | Nebraska | 31035 | 649 | 11 |
1022973 | 1022973 | 2021-02-12 | Clay | North Carolina | 37043 | 627 | 18 |
1023520 | 1023520 | 2021-02-12 | Clay | South Dakota | 46027 | 1771 | 15 |
1023587 | 1023587 | 2021-02-12 | Clay | Tennessee | 47027 | 1055 | 29 |
1023708 | 1023708 | 2021-02-12 | Clay | Texas | 48077 | 983 | 16 |
1024151 | 1024151 | 2021-02-12 | Clay | West Virginia | 54015 | 364 | 4 |
1017817 | 1017817 | 2021-02-11 | Clay | Alabama | 1027 | 1386 | 53 |
1017924 | 1017924 | 2021-02-11 | Clay | Arkansas | 5021 | 1651 | 44 |
1018135 | 1018135 | 2021-02-11 | Clay | Florida | 12019 | 16080 | 283 |
1018223 | 1018223 | 2021-02-11 | Clay | Georgia | 13061 | 226 | 3 |
1018416 | 1018416 | 2021-02-11 | Clay | Illinois | 17025 | 1402 | 45 |
1018517 | 1018517 | 2021-02-11 | Clay | Indiana | 18021 | 2351 | 42 |
1018619 | 1018619 | 2021-02-11 | Clay | Iowa | 19041 | 1806 | 25 |
1018712 | 1018712 | 2021-02-11 | Clay | Kansas | 20027 | 811 | 23 |
1018830 | 1018830 | 2021-02-11 | Clay | Kentucky | 21051 | 2306 | 26 |
1019143 | 1019143 | 2021-02-11 | Clay | Minnesota | 27027 | 6725 | 83 |
1019230 | 1019230 | 2021-02-11 | Clay | Mississippi | 28025 | 1760 | 45 |
1019323 | 1019323 | 2021-02-11 | Clay | Missouri | 29047 | 9234 | 137 |
1019490 | 1019490 | 2021-02-11 | Clay | Nebraska | 31035 | 648 | 11 |
1019728 | 1019728 | 2021-02-11 | Clay | North Carolina | 37043 | 622 | 18 |
1020275 | 1020275 | 2021-02-11 | Clay | South Dakota | 46027 | 1770 | 15 |
1020342 | 1020342 | 2021-02-11 | Clay | Tennessee | 47027 | 1050 | 29 |
1020463 | 1020463 | 2021-02-11 | Clay | Texas | 48077 | 981 | 16 |
1020906 | 1020906 | 2021-02-11 | Clay | West Virginia | 54015 | 362 | 4 |
1014572 | 1014572 | 2021-02-10 | Clay | Alabama | 1027 | 1372 | 52 |
1014679 | 1014679 | 2021-02-10 | Clay | Arkansas | 5021 | 1646 | 43 |
1014890 | 1014890 | 2021-02-10 | Clay | Florida | 12019 | 15995 | 283 |
1014978 | 1014978 | 2021-02-10 | Clay | Georgia | 13061 | 226 | 3 |
1015171 | 1015171 | 2021-02-10 | Clay | Illinois | 17025 | 1401 | 44 |
1015272 | 1015272 | 2021-02-10 | Clay | Indiana | 18021 | 2344 | 42 |
1015374 | 1015374 | 2021-02-10 | Clay | Iowa | 19041 | 1806 | 25 |
1015467 | 1015467 | 2021-02-10 | Clay | Kansas | 20027 | 811 | 23 |
1015585 | 1015585 | 2021-02-10 | Clay | Kentucky | 21051 | 2295 | 25 |
1015898 | 1015898 | 2021-02-10 | Clay | Minnesota | 27027 | 6716 | 83 |
1015985 | 1015985 | 2021-02-10 | Clay | Mississippi | 28025 | 1760 | 45 |
1016078 | 1016078 | 2021-02-10 | Clay | Missouri | 29047 | 9213 | 131 |
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);