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 673
- Minnesota 665
- Mississippi 664
- Missouri 662
- Alabama 659
- Kansas 658
- Indiana 656
- South Dakota 656
- Georgia 655
- Iowa 654
- North Carolina 654
- Tennessee 653
- Texas 653
- Arkansas 648
- Nebraska 644
- Illinois 640
- Kentucky 635
- West Virginia 618
fips 18
county 1
- Clay · 11,747 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109250 | 2109250 | 2022-01-13 | Clay | Arkansas | 5021 | 3214 | 77 |
2109461 | 2109461 | 2022-01-13 | Clay | Florida | 12019 | 38296 | 707 |
2109549 | 2109549 | 2022-01-13 | Clay | Georgia | 13061 | 428 | 4 |
2109743 | 2109743 | 2022-01-13 | Clay | Illinois | 17025 | 3828 | 65 |
2109844 | 2109844 | 2022-01-13 | Clay | Indiana | 18021 | 5704 | 74 |
2109946 | 2109946 | 2022-01-13 | Clay | Iowa | 19041 | 3379 | 40 |
2110039 | 2110039 | 2022-01-13 | Clay | Kansas | 20027 | 1569 | 31 |
2110156 | 2110156 | 2022-01-13 | Clay | Kentucky | 21051 | 5612 | 69 |
2110470 | 2110470 | 2022-01-13 | Clay | Minnesota | 27027 | 14278 | 114 |
2110557 | 2110557 | 2022-01-13 | Clay | Mississippi | 28025 | 4059 | 78 |
2110650 | 2110650 | 2022-01-13 | Clay | Missouri | 29047 | 21459 | 290 |
2110817 | 2110817 | 2022-01-13 | Clay | Nebraska | 31035 | 1203 | 17 |
2111057 | 2111057 | 2022-01-13 | Clay | North Carolina | 37043 | 1969 | 38 |
2111606 | 2111606 | 2022-01-13 | Clay | South Dakota | 46027 | 2790 | 17 |
2111673 | 2111673 | 2022-01-13 | Clay | Tennessee | 47027 | 1726 | 42 |
2111794 | 2111794 | 2022-01-13 | Clay | Texas | 48077 | 1741 | 26 |
2112237 | 2112237 | 2022-01-13 | Clay | West Virginia | 54015 | 1798 | 29 |
2105890 | 2105890 | 2022-01-12 | Clay | Alabama | 1027 | 3002 | 70 |
2105999 | 2105999 | 2022-01-12 | Clay | Arkansas | 5021 | 3180 | 77 |
2106210 | 2106210 | 2022-01-12 | Clay | Florida | 12019 | 38296 | 707 |
2106298 | 2106298 | 2022-01-12 | Clay | Georgia | 13061 | 417 | 4 |
2106492 | 2106492 | 2022-01-12 | Clay | Illinois | 17025 | 3787 | 64 |
2106593 | 2106593 | 2022-01-12 | Clay | Indiana | 18021 | 5610 | 74 |
2106695 | 2106695 | 2022-01-12 | Clay | Iowa | 19041 | 3379 | 40 |
2106788 | 2106788 | 2022-01-12 | Clay | Kansas | 20027 | 1569 | 31 |
2106905 | 2106905 | 2022-01-12 | Clay | Kentucky | 21051 | 5596 | 69 |
2107219 | 2107219 | 2022-01-12 | Clay | Minnesota | 27027 | 14125 | 114 |
2107306 | 2107306 | 2022-01-12 | Clay | Mississippi | 28025 | 3965 | 78 |
2107399 | 2107399 | 2022-01-12 | Clay | Missouri | 29047 | 21162 | 290 |
2107566 | 2107566 | 2022-01-12 | Clay | Nebraska | 31035 | 1197 | 17 |
2107805 | 2107805 | 2022-01-12 | Clay | North Carolina | 37043 | 1954 | 38 |
2108354 | 2108354 | 2022-01-12 | Clay | South Dakota | 46027 | 2746 | 17 |
2108421 | 2108421 | 2022-01-12 | Clay | Tennessee | 47027 | 1726 | 42 |
2108542 | 2108542 | 2022-01-12 | Clay | Texas | 48077 | 1723 | 26 |
2108985 | 2108985 | 2022-01-12 | Clay | West Virginia | 54015 | 1769 | 28 |
2102639 | 2102639 | 2022-01-11 | Clay | Alabama | 1027 | 2950 | 70 |
2102748 | 2102748 | 2022-01-11 | Clay | Arkansas | 5021 | 3155 | 77 |
2102959 | 2102959 | 2022-01-11 | Clay | Florida | 12019 | 38296 | 708 |
2103047 | 2103047 | 2022-01-11 | Clay | Georgia | 13061 | 405 | 4 |
2103241 | 2103241 | 2022-01-11 | Clay | Illinois | 17025 | 3729 | 64 |
2103342 | 2103342 | 2022-01-11 | Clay | Indiana | 18021 | 5574 | 73 |
2103444 | 2103444 | 2022-01-11 | Clay | Iowa | 19041 | 3203 | 40 |
2103537 | 2103537 | 2022-01-11 | Clay | Kansas | 20027 | 1526 | 31 |
2103654 | 2103654 | 2022-01-11 | Clay | Kentucky | 21051 | 5573 | 69 |
2103968 | 2103968 | 2022-01-11 | Clay | Minnesota | 27027 | 13931 | 114 |
2104055 | 2104055 | 2022-01-11 | Clay | Mississippi | 28025 | 3895 | 78 |
2104148 | 2104148 | 2022-01-11 | Clay | Missouri | 29047 | 20936 | 289 |
2104315 | 2104315 | 2022-01-11 | Clay | Nebraska | 31035 | 1190 | 17 |
2104554 | 2104554 | 2022-01-11 | Clay | North Carolina | 37043 | 1926 | 38 |
2105103 | 2105103 | 2022-01-11 | Clay | South Dakota | 46027 | 2696 | 17 |
2105170 | 2105170 | 2022-01-11 | Clay | Tennessee | 47027 | 1683 | 40 |
2105291 | 2105291 | 2022-01-11 | Clay | Texas | 48077 | 1713 | 26 |
2105734 | 2105734 | 2022-01-11 | Clay | West Virginia | 54015 | 1763 | 28 |
2099388 | 2099388 | 2022-01-10 | Clay | Alabama | 1027 | 2910 | 70 |
2099497 | 2099497 | 2022-01-10 | Clay | Arkansas | 5021 | 3120 | 77 |
2099708 | 2099708 | 2022-01-10 | Clay | Florida | 12019 | 38296 | 708 |
2099796 | 2099796 | 2022-01-10 | Clay | Georgia | 13061 | 393 | 4 |
2099990 | 2099990 | 2022-01-10 | Clay | Illinois | 17025 | 3642 | 64 |
2100091 | 2100091 | 2022-01-10 | Clay | Indiana | 18021 | 5547 | 73 |
2100193 | 2100193 | 2022-01-10 | Clay | Iowa | 19041 | 3203 | 40 |
2100286 | 2100286 | 2022-01-10 | Clay | Kansas | 20027 | 1526 | 31 |
2100403 | 2100403 | 2022-01-10 | Clay | Kentucky | 21051 | 5556 | 69 |
2100717 | 2100717 | 2022-01-10 | Clay | Minnesota | 27027 | 13661 | 114 |
2100804 | 2100804 | 2022-01-10 | Clay | Mississippi | 28025 | 3855 | 78 |
2100897 | 2100897 | 2022-01-10 | Clay | Missouri | 29047 | 20705 | 281 |
2101064 | 2101064 | 2022-01-10 | Clay | Nebraska | 31035 | 1184 | 17 |
2101303 | 2101303 | 2022-01-10 | Clay | North Carolina | 37043 | 1900 | 38 |
2101852 | 2101852 | 2022-01-10 | Clay | South Dakota | 46027 | 2646 | 17 |
2101919 | 2101919 | 2022-01-10 | Clay | Tennessee | 47027 | 1683 | 40 |
2102040 | 2102040 | 2022-01-10 | Clay | Texas | 48077 | 1706 | 26 |
2102483 | 2102483 | 2022-01-10 | Clay | West Virginia | 54015 | 1760 | 28 |
2096137 | 2096137 | 2022-01-09 | Clay | Alabama | 1027 | 2901 | 70 |
2096246 | 2096246 | 2022-01-09 | Clay | Arkansas | 5021 | 3077 | 77 |
2096457 | 2096457 | 2022-01-09 | Clay | Florida | 12019 | 38296 | 708 |
2096545 | 2096545 | 2022-01-09 | Clay | Georgia | 13061 | 368 | 4 |
2096739 | 2096739 | 2022-01-09 | Clay | Illinois | 17025 | 3604 | 64 |
2096840 | 2096840 | 2022-01-09 | Clay | Indiana | 18021 | 5399 | 72 |
2096942 | 2096942 | 2022-01-09 | Clay | Iowa | 19041 | 3203 | 40 |
2097035 | 2097035 | 2022-01-09 | Clay | Kansas | 20027 | 1515 | 31 |
2097152 | 2097152 | 2022-01-09 | Clay | Kentucky | 21051 | 5533 | 69 |
2097466 | 2097466 | 2022-01-09 | Clay | Minnesota | 27027 | 13556 | 114 |
2097553 | 2097553 | 2022-01-09 | Clay | Mississippi | 28025 | 3712 | 78 |
2097646 | 2097646 | 2022-01-09 | Clay | Missouri | 29047 | 20559 | 281 |
2097813 | 2097813 | 2022-01-09 | Clay | Nebraska | 31035 | 1173 | 17 |
2098052 | 2098052 | 2022-01-09 | Clay | North Carolina | 37043 | 1860 | 38 |
2098601 | 2098601 | 2022-01-09 | Clay | South Dakota | 46027 | 2626 | 17 |
2098668 | 2098668 | 2022-01-09 | Clay | Tennessee | 47027 | 1683 | 40 |
2098789 | 2098789 | 2022-01-09 | Clay | Texas | 48077 | 1696 | 26 |
2099232 | 2099232 | 2022-01-09 | Clay | West Virginia | 54015 | 1737 | 28 |
2092885 | 2092885 | 2022-01-08 | Clay | Alabama | 1027 | 2846 | 70 |
2092994 | 2092994 | 2022-01-08 | Clay | Arkansas | 5021 | 3077 | 77 |
2093205 | 2093205 | 2022-01-08 | Clay | Florida | 12019 | 38296 | 708 |
2093293 | 2093293 | 2022-01-08 | Clay | Georgia | 13061 | 368 | 4 |
2093487 | 2093487 | 2022-01-08 | Clay | Illinois | 17025 | 3604 | 64 |
2093588 | 2093588 | 2022-01-08 | Clay | Indiana | 18021 | 5399 | 72 |
2093690 | 2093690 | 2022-01-08 | Clay | Iowa | 19041 | 3203 | 40 |
2093783 | 2093783 | 2022-01-08 | Clay | Kansas | 20027 | 1515 | 31 |
2093900 | 2093900 | 2022-01-08 | Clay | Kentucky | 21051 | 5533 | 69 |
2094214 | 2094214 | 2022-01-08 | Clay | Minnesota | 27027 | 13556 | 114 |
2094301 | 2094301 | 2022-01-08 | Clay | Mississippi | 28025 | 3712 | 78 |
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);