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 109
- Minnesota 101
- Mississippi 100
- Missouri 98
- Alabama 96
- Kansas 94
- Indiana 92
- South Dakota 92
- Georgia 91
- Iowa 90
- North Carolina 90
- Tennessee 89
- Texas 89
- Arkansas 84
- Nebraska 80
- Illinois 76
- Kentucky 71
- West Virginia 54
fips 18
county 1
- Clay · 1,596 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280801 | 280801 | 2020-06-28 | Clay | Alabama | 1027 | 35 | 2 |
280903 | 280903 | 2020-06-28 | Clay | Arkansas | 5021 | 54 | 3 |
281110 | 281110 | 2020-06-28 | Clay | Florida | 12019 | 659 | 34 |
281198 | 281198 | 2020-06-28 | Clay | Georgia | 13061 | 57 | 2 |
281385 | 281385 | 2020-06-28 | Clay | Illinois | 17025 | 2 | 0 |
281485 | 281485 | 2020-06-28 | Clay | Indiana | 18021 | 59 | 4 |
281587 | 281587 | 2020-06-28 | Clay | Iowa | 19041 | 119 | 0 |
281680 | 281680 | 2020-06-28 | Clay | Kansas | 20027 | 6 | 2 |
281787 | 281787 | 2020-06-28 | Clay | Kentucky | 21051 | 53 | 3 |
282099 | 282099 | 2020-06-28 | Clay | Minnesota | 27027 | 557 | 37 |
282185 | 282185 | 2020-06-28 | Clay | Mississippi | 28025 | 235 | 7 |
282278 | 282278 | 2020-06-28 | Clay | Missouri | 29047 | 431 | 12 |
282422 | 282422 | 2020-06-28 | Clay | Nebraska | 31035 | 27 | 0 |
282645 | 282645 | 2020-06-28 | Clay | North Carolina | 37043 | 9 | 0 |
283180 | 283180 | 2020-06-28 | Clay | South Dakota | 46027 | 80 | 0 |
283242 | 283242 | 2020-06-28 | Clay | Tennessee | 47027 | 13 | 0 |
283361 | 283361 | 2020-06-28 | Clay | Texas | 48077 | 6 | 0 |
283792 | 283792 | 2020-06-28 | Clay | West Virginia | 54015 | 10 | 1 |
277653 | 277653 | 2020-06-27 | Clay | Alabama | 1027 | 35 | 2 |
277756 | 277756 | 2020-06-27 | Clay | Arkansas | 5021 | 52 | 3 |
277963 | 277963 | 2020-06-27 | Clay | Florida | 12019 | 616 | 34 |
278051 | 278051 | 2020-06-27 | Clay | Georgia | 13061 | 57 | 2 |
278237 | 278237 | 2020-06-27 | Clay | Illinois | 17025 | 2 | 0 |
278337 | 278337 | 2020-06-27 | Clay | Indiana | 18021 | 59 | 4 |
278439 | 278439 | 2020-06-27 | Clay | Iowa | 19041 | 117 | 0 |
278532 | 278532 | 2020-06-27 | Clay | Kansas | 20027 | 6 | 2 |
278639 | 278639 | 2020-06-27 | Clay | Kentucky | 21051 | 53 | 3 |
278951 | 278951 | 2020-06-27 | Clay | Minnesota | 27027 | 556 | 37 |
279037 | 279037 | 2020-06-27 | Clay | Mississippi | 28025 | 234 | 7 |
279130 | 279130 | 2020-06-27 | Clay | Missouri | 29047 | 414 | 12 |
279274 | 279274 | 2020-06-27 | Clay | Nebraska | 31035 | 27 | 0 |
279499 | 279499 | 2020-06-27 | Clay | North Carolina | 37043 | 9 | 0 |
280034 | 280034 | 2020-06-27 | Clay | South Dakota | 46027 | 80 | 0 |
280096 | 280096 | 2020-06-27 | Clay | Tennessee | 47027 | 13 | 0 |
280215 | 280215 | 2020-06-27 | Clay | Texas | 48077 | 6 | 0 |
280646 | 280646 | 2020-06-27 | Clay | West Virginia | 54015 | 10 | 1 |
274505 | 274505 | 2020-06-26 | Clay | Alabama | 1027 | 35 | 2 |
274608 | 274608 | 2020-06-26 | Clay | Arkansas | 5021 | 52 | 3 |
274815 | 274815 | 2020-06-26 | Clay | Florida | 12019 | 580 | 34 |
274903 | 274903 | 2020-06-26 | Clay | Georgia | 13061 | 56 | 2 |
275089 | 275089 | 2020-06-26 | Clay | Illinois | 17025 | 2 | 0 |
275189 | 275189 | 2020-06-26 | Clay | Indiana | 18021 | 56 | 4 |
275291 | 275291 | 2020-06-26 | Clay | Iowa | 19041 | 115 | 0 |
275384 | 275384 | 2020-06-26 | Clay | Kansas | 20027 | 6 | 2 |
275491 | 275491 | 2020-06-26 | Clay | Kentucky | 21051 | 46 | 3 |
275803 | 275803 | 2020-06-26 | Clay | Minnesota | 27027 | 545 | 37 |
275889 | 275889 | 2020-06-26 | Clay | Mississippi | 28025 | 233 | 7 |
275982 | 275982 | 2020-06-26 | Clay | Missouri | 29047 | 406 | 12 |
276126 | 276126 | 2020-06-26 | Clay | Nebraska | 31035 | 27 | 0 |
276351 | 276351 | 2020-06-26 | Clay | North Carolina | 37043 | 9 | 0 |
276886 | 276886 | 2020-06-26 | Clay | South Dakota | 46027 | 79 | 0 |
276948 | 276948 | 2020-06-26 | Clay | Tennessee | 47027 | 13 | 0 |
277067 | 277067 | 2020-06-26 | Clay | Texas | 48077 | 5 | 0 |
277498 | 277498 | 2020-06-26 | Clay | West Virginia | 54015 | 10 | 1 |
271365 | 271365 | 2020-06-25 | Clay | Alabama | 1027 | 35 | 2 |
271468 | 271468 | 2020-06-25 | Clay | Arkansas | 5021 | 49 | 3 |
271675 | 271675 | 2020-06-25 | Clay | Florida | 12019 | 542 | 33 |
271763 | 271763 | 2020-06-25 | Clay | Georgia | 13061 | 56 | 2 |
271947 | 271947 | 2020-06-25 | Clay | Illinois | 17025 | 2 | 0 |
272047 | 272047 | 2020-06-25 | Clay | Indiana | 18021 | 56 | 4 |
272149 | 272149 | 2020-06-25 | Clay | Iowa | 19041 | 113 | 0 |
272242 | 272242 | 2020-06-25 | Clay | Kansas | 20027 | 6 | 2 |
272348 | 272348 | 2020-06-25 | Clay | Kentucky | 21051 | 44 | 3 |
272660 | 272660 | 2020-06-25 | Clay | Minnesota | 27027 | 537 | 37 |
272746 | 272746 | 2020-06-25 | Clay | Mississippi | 28025 | 229 | 7 |
272839 | 272839 | 2020-06-25 | Clay | Missouri | 29047 | 386 | 11 |
272983 | 272983 | 2020-06-25 | Clay | Nebraska | 31035 | 27 | 0 |
273205 | 273205 | 2020-06-25 | Clay | North Carolina | 37043 | 9 | 0 |
273739 | 273739 | 2020-06-25 | Clay | South Dakota | 46027 | 79 | 0 |
273801 | 273801 | 2020-06-25 | Clay | Tennessee | 47027 | 12 | 0 |
273920 | 273920 | 2020-06-25 | Clay | Texas | 48077 | 5 | 0 |
274350 | 274350 | 2020-06-25 | Clay | West Virginia | 54015 | 10 | 1 |
268231 | 268231 | 2020-06-24 | Clay | Alabama | 1027 | 34 | 2 |
268333 | 268333 | 2020-06-24 | Clay | Arkansas | 5021 | 49 | 3 |
268539 | 268539 | 2020-06-24 | Clay | Florida | 12019 | 523 | 33 |
268627 | 268627 | 2020-06-24 | Clay | Georgia | 13061 | 56 | 2 |
268810 | 268810 | 2020-06-24 | Clay | Illinois | 17025 | 2 | 0 |
268910 | 268910 | 2020-06-24 | Clay | Indiana | 18021 | 56 | 4 |
269012 | 269012 | 2020-06-24 | Clay | Iowa | 19041 | 111 | 0 |
269105 | 269105 | 2020-06-24 | Clay | Kansas | 20027 | 6 | 2 |
269212 | 269212 | 2020-06-24 | Clay | Kentucky | 21051 | 39 | 3 |
269523 | 269523 | 2020-06-24 | Clay | Minnesota | 27027 | 537 | 37 |
269609 | 269609 | 2020-06-24 | Clay | Mississippi | 28025 | 222 | 7 |
269701 | 269701 | 2020-06-24 | Clay | Missouri | 29047 | 375 | 11 |
269844 | 269844 | 2020-06-24 | Clay | Nebraska | 31035 | 27 | 0 |
270066 | 270066 | 2020-06-24 | Clay | North Carolina | 37043 | 9 | 0 |
270600 | 270600 | 2020-06-24 | Clay | South Dakota | 46027 | 76 | 0 |
270662 | 270662 | 2020-06-24 | Clay | Tennessee | 47027 | 12 | 0 |
270781 | 270781 | 2020-06-24 | Clay | Texas | 48077 | 5 | 0 |
271210 | 271210 | 2020-06-24 | Clay | West Virginia | 54015 | 10 | 1 |
265102 | 265102 | 2020-06-23 | Clay | Alabama | 1027 | 34 | 2 |
265203 | 265203 | 2020-06-23 | Clay | Arkansas | 5021 | 48 | 3 |
265409 | 265409 | 2020-06-23 | Clay | Florida | 12019 | 511 | 33 |
265497 | 265497 | 2020-06-23 | Clay | Georgia | 13061 | 56 | 2 |
265680 | 265680 | 2020-06-23 | Clay | Illinois | 17025 | 2 | 0 |
265780 | 265780 | 2020-06-23 | Clay | Indiana | 18021 | 56 | 4 |
265882 | 265882 | 2020-06-23 | Clay | Iowa | 19041 | 109 | 0 |
265975 | 265975 | 2020-06-23 | Clay | Kansas | 20027 | 7 | 2 |
266079 | 266079 | 2020-06-23 | Clay | Kentucky | 21051 | 37 | 3 |
266390 | 266390 | 2020-06-23 | Clay | Minnesota | 27027 | 530 | 37 |
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);