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 301
- Minnesota 293
- Mississippi 292
- Missouri 290
- Alabama 288
- Kansas 286
- South Dakota 285
- Indiana 284
- Georgia 283
- North Carolina 283
- Iowa 282
- Tennessee 282
- Texas 282
- Arkansas 276
- Nebraska 273
- Illinois 268
- Kentucky 263
- West Virginia 247
fips 18
county 1
- Clay · 5,058 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
905898 | 905898 | 2021-01-07 | Clay | Nebraska | 31035 | 574 | 9 |
906137 | 906137 | 2021-01-07 | Clay | North Carolina | 37043 | 451 | 5 |
906684 | 906684 | 2021-01-07 | Clay | South Dakota | 46027 | 1665 | 12 |
906751 | 906751 | 2021-01-07 | Clay | Tennessee | 47027 | 873 | 24 |
906872 | 906872 | 2021-01-07 | Clay | Texas | 48077 | 805 | 11 |
907315 | 907315 | 2021-01-07 | Clay | West Virginia | 54015 | 271 | 4 |
900980 | 900980 | 2021-01-06 | Clay | Alabama | 1027 | 1184 | 34 |
901087 | 901087 | 2021-01-06 | Clay | Arkansas | 5021 | 1383 | 35 |
901298 | 901298 | 2021-01-06 | Clay | Florida | 12019 | 12316 | 193 |
901386 | 901386 | 2021-01-06 | Clay | Georgia | 13061 | 189 | 3 |
901579 | 901579 | 2021-01-06 | Clay | Illinois | 17025 | 1260 | 36 |
901679 | 901679 | 2021-01-06 | Clay | Indiana | 18021 | 1961 | 32 |
901781 | 901781 | 2021-01-06 | Clay | Iowa | 19041 | 1594 | 17 |
901874 | 901874 | 2021-01-06 | Clay | Kansas | 20027 | 653 | 17 |
901992 | 901992 | 2021-01-06 | Clay | Kentucky | 21051 | 1755 | 9 |
902306 | 902306 | 2021-01-06 | Clay | Minnesota | 27027 | 6306 | 78 |
902393 | 902393 | 2021-01-06 | Clay | Mississippi | 28025 | 1430 | 30 |
902486 | 902486 | 2021-01-06 | Clay | Missouri | 29047 | 7473 | 107 |
902653 | 902653 | 2021-01-06 | Clay | Nebraska | 31035 | 569 | 9 |
902891 | 902891 | 2021-01-06 | Clay | North Carolina | 37043 | 445 | 5 |
903438 | 903438 | 2021-01-06 | Clay | South Dakota | 46027 | 1660 | 12 |
903505 | 903505 | 2021-01-06 | Clay | Tennessee | 47027 | 864 | 23 |
903626 | 903626 | 2021-01-06 | Clay | Texas | 48077 | 781 | 11 |
904069 | 904069 | 2021-01-06 | Clay | West Virginia | 54015 | 269 | 4 |
897735 | 897735 | 2021-01-05 | Clay | Alabama | 1027 | 1179 | 34 |
897842 | 897842 | 2021-01-05 | Clay | Arkansas | 5021 | 1369 | 32 |
898053 | 898053 | 2021-01-05 | Clay | Florida | 12019 | 12090 | 189 |
898141 | 898141 | 2021-01-05 | Clay | Georgia | 13061 | 190 | 3 |
898334 | 898334 | 2021-01-05 | Clay | Illinois | 17025 | 1253 | 36 |
898434 | 898434 | 2021-01-05 | Clay | Indiana | 18021 | 1938 | 31 |
898536 | 898536 | 2021-01-05 | Clay | Iowa | 19041 | 1580 | 16 |
898629 | 898629 | 2021-01-05 | Clay | Kansas | 20027 | 629 | 17 |
898747 | 898747 | 2021-01-05 | Clay | Kentucky | 21051 | 1723 | 8 |
899061 | 899061 | 2021-01-05 | Clay | Minnesota | 27027 | 6280 | 78 |
899148 | 899148 | 2021-01-05 | Clay | Mississippi | 28025 | 1410 | 30 |
899241 | 899241 | 2021-01-05 | Clay | Missouri | 29047 | 7398 | 103 |
899408 | 899408 | 2021-01-05 | Clay | Nebraska | 31035 | 565 | 9 |
899646 | 899646 | 2021-01-05 | Clay | North Carolina | 37043 | 428 | 5 |
900193 | 900193 | 2021-01-05 | Clay | South Dakota | 46027 | 1652 | 12 |
900260 | 900260 | 2021-01-05 | Clay | Tennessee | 47027 | 859 | 23 |
900381 | 900381 | 2021-01-05 | Clay | Texas | 48077 | 764 | 11 |
900824 | 900824 | 2021-01-05 | Clay | West Virginia | 54015 | 269 | 4 |
894489 | 894489 | 2021-01-04 | Clay | Alabama | 1027 | 1163 | 34 |
894597 | 894597 | 2021-01-04 | Clay | Arkansas | 5021 | 1350 | 32 |
894808 | 894808 | 2021-01-04 | Clay | Florida | 12019 | 11886 | 188 |
894896 | 894896 | 2021-01-04 | Clay | Georgia | 13061 | 188 | 3 |
895089 | 895089 | 2021-01-04 | Clay | Illinois | 17025 | 1238 | 36 |
895189 | 895189 | 2021-01-04 | Clay | Indiana | 18021 | 1921 | 31 |
895291 | 895291 | 2021-01-04 | Clay | Iowa | 19041 | 1570 | 15 |
895384 | 895384 | 2021-01-04 | Clay | Kansas | 20027 | 629 | 17 |
895502 | 895502 | 2021-01-04 | Clay | Kentucky | 21051 | 1707 | 8 |
895816 | 895816 | 2021-01-04 | Clay | Minnesota | 27027 | 6261 | 78 |
895903 | 895903 | 2021-01-04 | Clay | Mississippi | 28025 | 1393 | 30 |
895996 | 895996 | 2021-01-04 | Clay | Missouri | 29047 | 7340 | 98 |
896163 | 896163 | 2021-01-04 | Clay | Nebraska | 31035 | 560 | 9 |
896401 | 896401 | 2021-01-04 | Clay | North Carolina | 37043 | 415 | 5 |
896948 | 896948 | 2021-01-04 | Clay | South Dakota | 46027 | 1649 | 12 |
897015 | 897015 | 2021-01-04 | Clay | Tennessee | 47027 | 854 | 23 |
897136 | 897136 | 2021-01-04 | Clay | Texas | 48077 | 715 | 10 |
897579 | 897579 | 2021-01-04 | Clay | West Virginia | 54015 | 271 | 4 |
891243 | 891243 | 2021-01-03 | Clay | Alabama | 1027 | 1158 | 34 |
891350 | 891350 | 2021-01-03 | Clay | Arkansas | 5021 | 1343 | 31 |
891561 | 891561 | 2021-01-03 | Clay | Florida | 12019 | 11798 | 188 |
891649 | 891649 | 2021-01-03 | Clay | Georgia | 13061 | 186 | 3 |
891842 | 891842 | 2021-01-03 | Clay | Illinois | 17025 | 1231 | 36 |
891942 | 891942 | 2021-01-03 | Clay | Indiana | 18021 | 1912 | 31 |
892044 | 892044 | 2021-01-03 | Clay | Iowa | 19041 | 1559 | 13 |
892137 | 892137 | 2021-01-03 | Clay | Kansas | 20027 | 622 | 17 |
892255 | 892255 | 2021-01-03 | Clay | Kentucky | 21051 | 1701 | 8 |
892569 | 892569 | 2021-01-03 | Clay | Minnesota | 27027 | 6212 | 78 |
892656 | 892656 | 2021-01-03 | Clay | Mississippi | 28025 | 1374 | 30 |
892749 | 892749 | 2021-01-03 | Clay | Missouri | 29047 | 7134 | 98 |
892916 | 892916 | 2021-01-03 | Clay | Nebraska | 31035 | 558 | 8 |
893155 | 893155 | 2021-01-03 | Clay | North Carolina | 37043 | 412 | 5 |
893702 | 893702 | 2021-01-03 | Clay | South Dakota | 46027 | 1645 | 12 |
893769 | 893769 | 2021-01-03 | Clay | Tennessee | 47027 | 854 | 23 |
893890 | 893890 | 2021-01-03 | Clay | Texas | 48077 | 715 | 10 |
894333 | 894333 | 2021-01-03 | Clay | West Virginia | 54015 | 268 | 4 |
887996 | 887996 | 2021-01-02 | Clay | Alabama | 1027 | 1158 | 34 |
888103 | 888103 | 2021-01-02 | Clay | Arkansas | 5021 | 1337 | 31 |
888314 | 888314 | 2021-01-02 | Clay | Florida | 12019 | 11639 | 188 |
888402 | 888402 | 2021-01-02 | Clay | Georgia | 13061 | 183 | 3 |
888595 | 888595 | 2021-01-02 | Clay | Illinois | 17025 | 1226 | 36 |
888696 | 888696 | 2021-01-02 | Clay | Indiana | 18021 | 1907 | 31 |
888798 | 888798 | 2021-01-02 | Clay | Iowa | 19041 | 1555 | 13 |
888891 | 888891 | 2021-01-02 | Clay | Kansas | 20027 | 622 | 17 |
889009 | 889009 | 2021-01-02 | Clay | Kentucky | 21051 | 1692 | 8 |
889323 | 889323 | 2021-01-02 | Clay | Minnesota | 27027 | 6188 | 78 |
889410 | 889410 | 2021-01-02 | Clay | Mississippi | 28025 | 1366 | 30 |
889503 | 889503 | 2021-01-02 | Clay | Missouri | 29047 | 7134 | 98 |
889670 | 889670 | 2021-01-02 | Clay | Nebraska | 31035 | 553 | 8 |
889909 | 889909 | 2021-01-02 | Clay | North Carolina | 37043 | 405 | 5 |
890456 | 890456 | 2021-01-02 | Clay | South Dakota | 46027 | 1634 | 12 |
890523 | 890523 | 2021-01-02 | Clay | Tennessee | 47027 | 853 | 23 |
890644 | 890644 | 2021-01-02 | Clay | Texas | 48077 | 715 | 10 |
891087 | 891087 | 2021-01-02 | Clay | West Virginia | 54015 | 263 | 4 |
884751 | 884751 | 2021-01-01 | Clay | Alabama | 1027 | 1150 | 34 |
884858 | 884858 | 2021-01-01 | Clay | Arkansas | 5021 | 1332 | 31 |
885069 | 885069 | 2021-01-01 | Clay | Florida | 12019 | 11261 | 186 |
885157 | 885157 | 2021-01-01 | Clay | Georgia | 13061 | 179 | 3 |
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);