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 219
- Minnesota 211
- Mississippi 210
- Missouri 208
- Alabama 205
- Kansas 204
- Indiana 202
- South Dakota 202
- Georgia 201
- Iowa 200
- North Carolina 200
- Tennessee 199
- Texas 199
- Arkansas 193
- Nebraska 190
- Illinois 186
- Kentucky 181
- West Virginia 164
fips 18
county 1
- Clay · 3,574 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635216 | 635216 | 2020-10-16 | Clay | Florida | 12019 | 5627 | 114 |
635304 | 635304 | 2020-10-16 | Clay | Georgia | 13061 | 124 | 3 |
635496 | 635496 | 2020-10-16 | Clay | Illinois | 17025 | 268 | 11 |
635597 | 635597 | 2020-10-16 | Clay | Indiana | 18021 | 405 | 6 |
635699 | 635699 | 2020-10-16 | Clay | Iowa | 19041 | 471 | 4 |
635792 | 635792 | 2020-10-16 | Clay | Kansas | 20027 | 75 | 2 |
635910 | 635910 | 2020-10-16 | Clay | Kentucky | 21051 | 418 | 6 |
636224 | 636224 | 2020-10-16 | Clay | Minnesota | 27027 | 1919 | 43 |
636311 | 636311 | 2020-10-16 | Clay | Mississippi | 28025 | 663 | 21 |
636404 | 636404 | 2020-10-16 | Clay | Missouri | 29047 | 2257 | 50 |
636571 | 636571 | 2020-10-16 | Clay | Nebraska | 31035 | 119 | 0 |
636809 | 636809 | 2020-10-16 | Clay | North Carolina | 37043 | 167 | 3 |
637356 | 637356 | 2020-10-16 | Clay | South Dakota | 46027 | 683 | 8 |
637423 | 637423 | 2020-10-16 | Clay | Tennessee | 47027 | 351 | 7 |
637543 | 637543 | 2020-10-16 | Clay | Texas | 48077 | 91 | 2 |
637986 | 637986 | 2020-10-16 | Clay | West Virginia | 54015 | 51 | 2 |
631653 | 631653 | 2020-10-15 | Clay | Alabama | 1027 | 674 | 12 |
631759 | 631759 | 2020-10-15 | Clay | Arkansas | 5021 | 405 | 11 |
631970 | 631970 | 2020-10-15 | Clay | Florida | 12019 | 5596 | 113 |
632058 | 632058 | 2020-10-15 | Clay | Georgia | 13061 | 124 | 3 |
632250 | 632250 | 2020-10-15 | Clay | Illinois | 17025 | 262 | 9 |
632351 | 632351 | 2020-10-15 | Clay | Indiana | 18021 | 393 | 6 |
632453 | 632453 | 2020-10-15 | Clay | Iowa | 19041 | 461 | 4 |
632546 | 632546 | 2020-10-15 | Clay | Kansas | 20027 | 68 | 2 |
632664 | 632664 | 2020-10-15 | Clay | Kentucky | 21051 | 408 | 6 |
632978 | 632978 | 2020-10-15 | Clay | Minnesota | 27027 | 1862 | 43 |
633065 | 633065 | 2020-10-15 | Clay | Mississippi | 28025 | 660 | 21 |
633158 | 633158 | 2020-10-15 | Clay | Missouri | 29047 | 2225 | 50 |
633325 | 633325 | 2020-10-15 | Clay | Nebraska | 31035 | 117 | 0 |
633563 | 633563 | 2020-10-15 | Clay | North Carolina | 37043 | 162 | 3 |
634110 | 634110 | 2020-10-15 | Clay | South Dakota | 46027 | 677 | 8 |
634177 | 634177 | 2020-10-15 | Clay | Tennessee | 47027 | 351 | 7 |
634298 | 634298 | 2020-10-15 | Clay | Texas | 48077 | 90 | 2 |
634741 | 634741 | 2020-10-15 | Clay | West Virginia | 54015 | 50 | 2 |
628409 | 628409 | 2020-10-14 | Clay | Alabama | 1027 | 667 | 11 |
628515 | 628515 | 2020-10-14 | Clay | Arkansas | 5021 | 396 | 11 |
628726 | 628726 | 2020-10-14 | Clay | Florida | 12019 | 5556 | 111 |
628814 | 628814 | 2020-10-14 | Clay | Georgia | 13061 | 124 | 3 |
629006 | 629006 | 2020-10-14 | Clay | Illinois | 17025 | 259 | 6 |
629107 | 629107 | 2020-10-14 | Clay | Indiana | 18021 | 385 | 6 |
629209 | 629209 | 2020-10-14 | Clay | Iowa | 19041 | 449 | 4 |
629302 | 629302 | 2020-10-14 | Clay | Kansas | 20027 | 68 | 2 |
629420 | 629420 | 2020-10-14 | Clay | Kentucky | 21051 | 389 | 6 |
629733 | 629733 | 2020-10-14 | Clay | Minnesota | 27027 | 1824 | 43 |
629820 | 629820 | 2020-10-14 | Clay | Mississippi | 28025 | 651 | 21 |
629913 | 629913 | 2020-10-14 | Clay | Missouri | 29047 | 2198 | 47 |
630080 | 630080 | 2020-10-14 | Clay | Nebraska | 31035 | 115 | 0 |
630318 | 630318 | 2020-10-14 | Clay | North Carolina | 37043 | 157 | 3 |
630865 | 630865 | 2020-10-14 | Clay | South Dakota | 46027 | 667 | 8 |
630932 | 630932 | 2020-10-14 | Clay | Tennessee | 47027 | 344 | 6 |
631053 | 631053 | 2020-10-14 | Clay | Texas | 48077 | 89 | 2 |
631496 | 631496 | 2020-10-14 | Clay | West Virginia | 54015 | 48 | 2 |
625166 | 625166 | 2020-10-13 | Clay | Alabama | 1027 | 661 | 9 |
625272 | 625272 | 2020-10-13 | Clay | Arkansas | 5021 | 384 | 11 |
625483 | 625483 | 2020-10-13 | Clay | Florida | 12019 | 5535 | 111 |
625571 | 625571 | 2020-10-13 | Clay | Georgia | 13061 | 124 | 3 |
625763 | 625763 | 2020-10-13 | Clay | Illinois | 17025 | 252 | 6 |
625864 | 625864 | 2020-10-13 | Clay | Indiana | 18021 | 382 | 6 |
625966 | 625966 | 2020-10-13 | Clay | Iowa | 19041 | 442 | 4 |
626059 | 626059 | 2020-10-13 | Clay | Kansas | 20027 | 68 | 2 |
626176 | 626176 | 2020-10-13 | Clay | Kentucky | 21051 | 382 | 6 |
626489 | 626489 | 2020-10-13 | Clay | Minnesota | 27027 | 1773 | 42 |
626576 | 626576 | 2020-10-13 | Clay | Mississippi | 28025 | 642 | 20 |
626669 | 626669 | 2020-10-13 | Clay | Missouri | 29047 | 2134 | 44 |
626836 | 626836 | 2020-10-13 | Clay | Nebraska | 31035 | 109 | 0 |
627074 | 627074 | 2020-10-13 | Clay | North Carolina | 37043 | 157 | 3 |
627621 | 627621 | 2020-10-13 | Clay | South Dakota | 46027 | 654 | 8 |
627688 | 627688 | 2020-10-13 | Clay | Tennessee | 47027 | 325 | 6 |
627809 | 627809 | 2020-10-13 | Clay | Texas | 48077 | 87 | 2 |
628252 | 628252 | 2020-10-13 | Clay | West Virginia | 54015 | 51 | 2 |
621923 | 621923 | 2020-10-12 | Clay | Alabama | 1027 | 650 | 9 |
622029 | 622029 | 2020-10-12 | Clay | Arkansas | 5021 | 381 | 11 |
622240 | 622240 | 2020-10-12 | Clay | Florida | 12019 | 5503 | 111 |
622328 | 622328 | 2020-10-12 | Clay | Georgia | 13061 | 124 | 3 |
622521 | 622521 | 2020-10-12 | Clay | Illinois | 17025 | 248 | 3 |
622622 | 622622 | 2020-10-12 | Clay | Indiana | 18021 | 376 | 6 |
622724 | 622724 | 2020-10-12 | Clay | Iowa | 19041 | 438 | 4 |
622817 | 622817 | 2020-10-12 | Clay | Kansas | 20027 | 68 | 2 |
622934 | 622934 | 2020-10-12 | Clay | Kentucky | 21051 | 371 | 6 |
623247 | 623247 | 2020-10-12 | Clay | Minnesota | 27027 | 1756 | 42 |
623334 | 623334 | 2020-10-12 | Clay | Mississippi | 28025 | 639 | 20 |
623427 | 623427 | 2020-10-12 | Clay | Missouri | 29047 | 2005 | 44 |
623594 | 623594 | 2020-10-12 | Clay | Nebraska | 31035 | 105 | 0 |
623832 | 623832 | 2020-10-12 | Clay | North Carolina | 37043 | 154 | 3 |
624379 | 624379 | 2020-10-12 | Clay | South Dakota | 46027 | 650 | 8 |
624446 | 624446 | 2020-10-12 | Clay | Tennessee | 47027 | 320 | 6 |
624567 | 624567 | 2020-10-12 | Clay | Texas | 48077 | 87 | 2 |
625009 | 625009 | 2020-10-12 | Clay | West Virginia | 54015 | 49 | 2 |
618680 | 618680 | 2020-10-11 | Clay | Alabama | 1027 | 646 | 9 |
618786 | 618786 | 2020-10-11 | Clay | Arkansas | 5021 | 380 | 11 |
618997 | 618997 | 2020-10-11 | Clay | Florida | 12019 | 5484 | 110 |
619085 | 619085 | 2020-10-11 | Clay | Georgia | 13061 | 124 | 3 |
619277 | 619277 | 2020-10-11 | Clay | Illinois | 17025 | 246 | 1 |
619378 | 619378 | 2020-10-11 | Clay | Indiana | 18021 | 372 | 6 |
619480 | 619480 | 2020-10-11 | Clay | Iowa | 19041 | 433 | 4 |
619573 | 619573 | 2020-10-11 | Clay | Kansas | 20027 | 68 | 2 |
619690 | 619690 | 2020-10-11 | Clay | Kentucky | 21051 | 366 | 6 |
620004 | 620004 | 2020-10-11 | Clay | Minnesota | 27027 | 1737 | 42 |
620091 | 620091 | 2020-10-11 | Clay | Mississippi | 28025 | 635 | 20 |
620184 | 620184 | 2020-10-11 | Clay | Missouri | 29047 | 2005 | 44 |
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);