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 142
- Minnesota 134
- Mississippi 133
- Missouri 131
- Alabama 128
- Kansas 127
- Indiana 125
- South Dakota 125
- Georgia 124
- Iowa 123
- North Carolina 123
- Tennessee 122
- Texas 122
- Arkansas 116
- Nebraska 113
- Illinois 109
- Kentucky 104
- West Virginia 87
fips 18
county 1
- Clay · 2,188 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386269 | 386269 | 2020-07-31 | Clay | Florida | 12019 | 2808 | 48 |
386357 | 386357 | 2020-07-31 | Clay | Georgia | 13061 | 72 | 2 |
386547 | 386547 | 2020-07-31 | Clay | Illinois | 17025 | 12 | 0 |
386648 | 386648 | 2020-07-31 | Clay | Indiana | 18021 | 94 | 5 |
386750 | 386750 | 2020-07-31 | Clay | Iowa | 19041 | 168 | 1 |
386843 | 386843 | 2020-07-31 | Clay | Kansas | 20027 | 18 | 2 |
386958 | 386958 | 2020-07-31 | Clay | Kentucky | 21051 | 142 | 5 |
387272 | 387272 | 2020-07-31 | Clay | Minnesota | 27027 | 740 | 39 |
387359 | 387359 | 2020-07-31 | Clay | Mississippi | 28025 | 363 | 14 |
387452 | 387452 | 2020-07-31 | Clay | Missouri | 29047 | 882 | 22 |
387611 | 387611 | 2020-07-31 | Clay | Nebraska | 31035 | 47 | 0 |
387842 | 387842 | 2020-07-31 | Clay | North Carolina | 37043 | 56 | 0 |
388387 | 388387 | 2020-07-31 | Clay | South Dakota | 46027 | 113 | 0 |
388453 | 388453 | 2020-07-31 | Clay | Tennessee | 47027 | 58 | 0 |
388573 | 388573 | 2020-07-31 | Clay | Texas | 48077 | 33 | 1 |
389013 | 389013 | 2020-07-31 | Clay | West Virginia | 54015 | 17 | 1 |
382735 | 382735 | 2020-07-30 | Clay | Alabama | 1027 | 193 | 5 |
382841 | 382841 | 2020-07-30 | Clay | Arkansas | 5021 | 103 | 4 |
383051 | 383051 | 2020-07-30 | Clay | Florida | 12019 | 2758 | 47 |
383139 | 383139 | 2020-07-30 | Clay | Georgia | 13061 | 70 | 2 |
383329 | 383329 | 2020-07-30 | Clay | Illinois | 17025 | 12 | 0 |
383430 | 383430 | 2020-07-30 | Clay | Indiana | 18021 | 92 | 5 |
383532 | 383532 | 2020-07-30 | Clay | Iowa | 19041 | 168 | 1 |
383625 | 383625 | 2020-07-30 | Clay | Kansas | 20027 | 17 | 2 |
383740 | 383740 | 2020-07-30 | Clay | Kentucky | 21051 | 141 | 5 |
384054 | 384054 | 2020-07-30 | Clay | Minnesota | 27027 | 734 | 39 |
384141 | 384141 | 2020-07-30 | Clay | Mississippi | 28025 | 360 | 13 |
384234 | 384234 | 2020-07-30 | Clay | Missouri | 29047 | 857 | 22 |
384393 | 384393 | 2020-07-30 | Clay | Nebraska | 31035 | 46 | 0 |
384625 | 384625 | 2020-07-30 | Clay | North Carolina | 37043 | 56 | 0 |
385170 | 385170 | 2020-07-30 | Clay | South Dakota | 46027 | 111 | 0 |
385236 | 385236 | 2020-07-30 | Clay | Tennessee | 47027 | 53 | 0 |
385356 | 385356 | 2020-07-30 | Clay | Texas | 48077 | 32 | 1 |
385796 | 385796 | 2020-07-30 | Clay | West Virginia | 54015 | 17 | 1 |
379518 | 379518 | 2020-07-29 | Clay | Alabama | 1027 | 185 | 4 |
379624 | 379624 | 2020-07-29 | Clay | Arkansas | 5021 | 104 | 4 |
379834 | 379834 | 2020-07-29 | Clay | Florida | 12019 | 2697 | 47 |
379922 | 379922 | 2020-07-29 | Clay | Georgia | 13061 | 69 | 2 |
380112 | 380112 | 2020-07-29 | Clay | Illinois | 17025 | 10 | 0 |
380213 | 380213 | 2020-07-29 | Clay | Indiana | 18021 | 89 | 5 |
380315 | 380315 | 2020-07-29 | Clay | Iowa | 19041 | 168 | 1 |
380408 | 380408 | 2020-07-29 | Clay | Kansas | 20027 | 17 | 2 |
380523 | 380523 | 2020-07-29 | Clay | Kentucky | 21051 | 139 | 5 |
380837 | 380837 | 2020-07-29 | Clay | Minnesota | 27027 | 725 | 39 |
380924 | 380924 | 2020-07-29 | Clay | Mississippi | 28025 | 355 | 13 |
381018 | 381018 | 2020-07-29 | Clay | Missouri | 29047 | 826 | 22 |
381177 | 381177 | 2020-07-29 | Clay | Nebraska | 31035 | 45 | 0 |
381407 | 381407 | 2020-07-29 | Clay | North Carolina | 37043 | 53 | 0 |
381952 | 381952 | 2020-07-29 | Clay | South Dakota | 46027 | 110 | 0 |
382018 | 382018 | 2020-07-29 | Clay | Tennessee | 47027 | 52 | 0 |
382138 | 382138 | 2020-07-29 | Clay | Texas | 48077 | 32 | 1 |
382578 | 382578 | 2020-07-29 | Clay | West Virginia | 54015 | 17 | 1 |
376302 | 376302 | 2020-07-28 | Clay | Alabama | 1027 | 180 | 4 |
376408 | 376408 | 2020-07-28 | Clay | Arkansas | 5021 | 103 | 4 |
376617 | 376617 | 2020-07-28 | Clay | Florida | 12019 | 2615 | 47 |
376705 | 376705 | 2020-07-28 | Clay | Georgia | 13061 | 69 | 2 |
376895 | 376895 | 2020-07-28 | Clay | Illinois | 17025 | 10 | 0 |
376996 | 376996 | 2020-07-28 | Clay | Indiana | 18021 | 88 | 5 |
377098 | 377098 | 2020-07-28 | Clay | Iowa | 19041 | 167 | 1 |
377191 | 377191 | 2020-07-28 | Clay | Kansas | 20027 | 17 | 2 |
377306 | 377306 | 2020-07-28 | Clay | Kentucky | 21051 | 136 | 4 |
377620 | 377620 | 2020-07-28 | Clay | Minnesota | 27027 | 717 | 39 |
377707 | 377707 | 2020-07-28 | Clay | Mississippi | 28025 | 350 | 13 |
377801 | 377801 | 2020-07-28 | Clay | Missouri | 29047 | 784 | 22 |
377959 | 377959 | 2020-07-28 | Clay | Nebraska | 31035 | 45 | 0 |
378190 | 378190 | 2020-07-28 | Clay | North Carolina | 37043 | 53 | 0 |
378735 | 378735 | 2020-07-28 | Clay | South Dakota | 46027 | 107 | 0 |
378801 | 378801 | 2020-07-28 | Clay | Tennessee | 47027 | 48 | 0 |
378921 | 378921 | 2020-07-28 | Clay | Texas | 48077 | 26 | 1 |
379361 | 379361 | 2020-07-28 | Clay | West Virginia | 54015 | 17 | 1 |
373088 | 373088 | 2020-07-27 | Clay | Alabama | 1027 | 178 | 4 |
373194 | 373194 | 2020-07-27 | Clay | Arkansas | 5021 | 103 | 4 |
373403 | 373403 | 2020-07-27 | Clay | Florida | 12019 | 2577 | 47 |
373491 | 373491 | 2020-07-27 | Clay | Georgia | 13061 | 69 | 2 |
373680 | 373680 | 2020-07-27 | Clay | Illinois | 17025 | 10 | 0 |
373781 | 373781 | 2020-07-27 | Clay | Indiana | 18021 | 83 | 5 |
373883 | 373883 | 2020-07-27 | Clay | Iowa | 19041 | 166 | 1 |
373976 | 373976 | 2020-07-27 | Clay | Kansas | 20027 | 17 | 2 |
374091 | 374091 | 2020-07-27 | Clay | Kentucky | 21051 | 134 | 4 |
374405 | 374405 | 2020-07-27 | Clay | Minnesota | 27027 | 707 | 39 |
374492 | 374492 | 2020-07-27 | Clay | Mississippi | 28025 | 345 | 13 |
374586 | 374586 | 2020-07-27 | Clay | Missouri | 29047 | 744 | 22 |
374744 | 374744 | 2020-07-27 | Clay | Nebraska | 31035 | 45 | 0 |
374974 | 374974 | 2020-07-27 | Clay | North Carolina | 37043 | 52 | 0 |
375519 | 375519 | 2020-07-27 | Clay | South Dakota | 46027 | 106 | 0 |
375585 | 375585 | 2020-07-27 | Clay | Tennessee | 47027 | 46 | 0 |
375705 | 375705 | 2020-07-27 | Clay | Texas | 48077 | 25 | 1 |
376145 | 376145 | 2020-07-27 | Clay | West Virginia | 54015 | 17 | 1 |
369876 | 369876 | 2020-07-26 | Clay | Alabama | 1027 | 169 | 3 |
369982 | 369982 | 2020-07-26 | Clay | Arkansas | 5021 | 104 | 4 |
370191 | 370191 | 2020-07-26 | Clay | Florida | 12019 | 2538 | 47 |
370279 | 370279 | 2020-07-26 | Clay | Georgia | 13061 | 69 | 2 |
370468 | 370468 | 2020-07-26 | Clay | Illinois | 17025 | 9 | 0 |
370569 | 370569 | 2020-07-26 | Clay | Indiana | 18021 | 83 | 5 |
370671 | 370671 | 2020-07-26 | Clay | Iowa | 19041 | 166 | 1 |
370764 | 370764 | 2020-07-26 | Clay | Kansas | 20027 | 15 | 2 |
370879 | 370879 | 2020-07-26 | Clay | Kentucky | 21051 | 134 | 4 |
371193 | 371193 | 2020-07-26 | Clay | Minnesota | 27027 | 703 | 39 |
371280 | 371280 | 2020-07-26 | Clay | Mississippi | 28025 | 340 | 13 |
371374 | 371374 | 2020-07-26 | Clay | Missouri | 29047 | 717 | 22 |
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);