ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18,567 rows where county = "Jackson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 24
- Oregon 127
- Oklahoma 120
- Michigan 117
- Mississippi 117
- Missouri 117
- Illinois 116
- Florida 115
- West Virginia 114
- Alabama 113
- Minnesota 113
- Kansas 112
- Indiana 110
- Georgia 109
- Louisiana 109
- Texas 108
- Iowa 104
- Wisconsin 104
- Tennessee 101
- Kentucky 95
- Ohio 95
- Arkansas 90
- North Carolina 90
- South Dakota 49
- Colorado 17
fips 24
county 1
- Jackson · 2,462 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
322034 | 322034 | 2020-07-11 | Jackson | Arkansas | 5067 | 41 | 0 |
322162 | 322162 | 2020-07-11 | Jackson | Colorado | 8057 | 7 | 0 |
322239 | 322239 | 2020-07-11 | Jackson | Florida | 12063 | 581 | 2 |
322354 | 322354 | 2020-07-11 | Jackson | Georgia | 13157 | 512 | 12 |
322521 | 322521 | 2020-07-11 | Jackson | Illinois | 17077 | 351 | 19 |
322621 | 322621 | 2020-07-11 | Jackson | Indiana | 18071 | 482 | 4 |
322726 | 322726 | 2020-07-11 | Jackson | Iowa | 19097 | 57 | 0 |
322818 | 322818 | 2020-07-11 | Jackson | Kansas | 20085 | 117 | 1 |
322932 | 322932 | 2020-07-11 | Jackson | Kentucky | 21109 | 116 | 14 |
323022 | 323022 | 2020-07-11 | Jackson | Louisiana | 22049 | 234 | 17 |
323157 | 323157 | 2020-07-11 | Jackson | Michigan | 26075 | 2155 | 54 |
323235 | 323235 | 2020-07-11 | Jackson | Minnesota | 27063 | 57 | 0 |
323320 | 323320 | 2020-07-11 | Jackson | Mississippi | 28059 | 775 | 19 |
323420 | 323420 | 2020-07-11 | Jackson | Missouri | 29095 | 1657 | 43 |
323798 | 323798 | 2020-07-11 | Jackson | North Carolina | 37099 | 189 | 1 |
323940 | 323940 | 2020-07-11 | Jackson | Ohio | 39079 | 28 | 0 |
324021 | 324021 | 2020-07-11 | Jackson | Oklahoma | 40065 | 57 | 3 |
324080 | 324080 | 2020-07-11 | Jackson | Oregon | 41029 | 178 | 0 |
324332 | 324332 | 2020-07-11 | Jackson | South Dakota | 46071 | 6 | 1 |
324406 | 324406 | 2020-07-11 | Jackson | Tennessee | 47087 | 47 | 0 |
324577 | 324577 | 2020-07-11 | Jackson | Texas | 48239 | 89 | 1 |
324940 | 324940 | 2020-07-11 | Jackson | West Virginia | 54035 | 148 | 18 |
325004 | 325004 | 2020-07-11 | Jackson | Wisconsin | 55053 | 34 | 1 |
318749 | 318749 | 2020-07-10 | Jackson | Alabama | 1071 | 406 | 3 |
318855 | 318855 | 2020-07-10 | Jackson | Arkansas | 5067 | 38 | 0 |
318983 | 318983 | 2020-07-10 | Jackson | Colorado | 8057 | 7 | 0 |
319060 | 319060 | 2020-07-10 | Jackson | Florida | 12063 | 556 | 2 |
319175 | 319175 | 2020-07-10 | Jackson | Georgia | 13157 | 499 | 11 |
319342 | 319342 | 2020-07-10 | Jackson | Illinois | 17077 | 347 | 19 |
319442 | 319442 | 2020-07-10 | Jackson | Indiana | 18071 | 482 | 4 |
319547 | 319547 | 2020-07-10 | Jackson | Iowa | 19097 | 56 | 0 |
319639 | 319639 | 2020-07-10 | Jackson | Kansas | 20085 | 117 | 1 |
319753 | 319753 | 2020-07-10 | Jackson | Kentucky | 21109 | 115 | 14 |
319843 | 319843 | 2020-07-10 | Jackson | Louisiana | 22049 | 230 | 16 |
319978 | 319978 | 2020-07-10 | Jackson | Michigan | 26075 | 2148 | 54 |
320056 | 320056 | 2020-07-10 | Jackson | Minnesota | 27063 | 57 | 0 |
320141 | 320141 | 2020-07-10 | Jackson | Mississippi | 28059 | 744 | 18 |
320241 | 320241 | 2020-07-10 | Jackson | Missouri | 29095 | 1612 | 42 |
320618 | 320618 | 2020-07-10 | Jackson | North Carolina | 37099 | 164 | 1 |
320760 | 320760 | 2020-07-10 | Jackson | Ohio | 39079 | 27 | 0 |
320841 | 320841 | 2020-07-10 | Jackson | Oklahoma | 40065 | 55 | 3 |
320900 | 320900 | 2020-07-10 | Jackson | Oregon | 41029 | 173 | 0 |
321152 | 321152 | 2020-07-10 | Jackson | South Dakota | 46071 | 6 | 1 |
321225 | 321225 | 2020-07-10 | Jackson | Tennessee | 47087 | 46 | 0 |
321396 | 321396 | 2020-07-10 | Jackson | Texas | 48239 | 79 | 1 |
321759 | 321759 | 2020-07-10 | Jackson | West Virginia | 54035 | 148 | 18 |
321823 | 321823 | 2020-07-10 | Jackson | Wisconsin | 55053 | 34 | 1 |
315576 | 315576 | 2020-07-09 | Jackson | Alabama | 1071 | 378 | 3 |
315682 | 315682 | 2020-07-09 | Jackson | Arkansas | 5067 | 39 | 0 |
315810 | 315810 | 2020-07-09 | Jackson | Colorado | 8057 | 2 | 0 |
315887 | 315887 | 2020-07-09 | Jackson | Florida | 12063 | 517 | 2 |
316002 | 316002 | 2020-07-09 | Jackson | Georgia | 13157 | 483 | 10 |
316169 | 316169 | 2020-07-09 | Jackson | Illinois | 17077 | 345 | 19 |
316269 | 316269 | 2020-07-09 | Jackson | Indiana | 18071 | 481 | 4 |
316374 | 316374 | 2020-07-09 | Jackson | Iowa | 19097 | 48 | 0 |
316466 | 316466 | 2020-07-09 | Jackson | Kansas | 20085 | 117 | 1 |
316578 | 316578 | 2020-07-09 | Jackson | Kentucky | 21109 | 115 | 14 |
316668 | 316668 | 2020-07-09 | Jackson | Louisiana | 22049 | 221 | 16 |
316803 | 316803 | 2020-07-09 | Jackson | Michigan | 26075 | 2143 | 54 |
316881 | 316881 | 2020-07-09 | Jackson | Minnesota | 27063 | 57 | 0 |
316966 | 316966 | 2020-07-09 | Jackson | Mississippi | 28059 | 727 | 17 |
317066 | 317066 | 2020-07-09 | Jackson | Missouri | 29095 | 1527 | 42 |
317441 | 317441 | 2020-07-09 | Jackson | North Carolina | 37099 | 157 | 1 |
317583 | 317583 | 2020-07-09 | Jackson | Ohio | 39079 | 27 | 0 |
317664 | 317664 | 2020-07-09 | Jackson | Oklahoma | 40065 | 54 | 3 |
317722 | 317722 | 2020-07-09 | Jackson | Oregon | 41029 | 164 | 0 |
317974 | 317974 | 2020-07-09 | Jackson | South Dakota | 46071 | 6 | 1 |
318047 | 318047 | 2020-07-09 | Jackson | Tennessee | 47087 | 41 | 0 |
318217 | 318217 | 2020-07-09 | Jackson | Texas | 48239 | 73 | 1 |
318580 | 318580 | 2020-07-09 | Jackson | West Virginia | 54035 | 149 | 18 |
318644 | 318644 | 2020-07-09 | Jackson | Wisconsin | 55053 | 32 | 1 |
312401 | 312401 | 2020-07-08 | Jackson | Alabama | 1071 | 347 | 3 |
312507 | 312507 | 2020-07-08 | Jackson | Arkansas | 5067 | 37 | 0 |
312635 | 312635 | 2020-07-08 | Jackson | Colorado | 8057 | 2 | 0 |
312712 | 312712 | 2020-07-08 | Jackson | Florida | 12063 | 504 | 2 |
312827 | 312827 | 2020-07-08 | Jackson | Georgia | 13157 | 469 | 10 |
312995 | 312995 | 2020-07-08 | Jackson | Illinois | 17077 | 343 | 19 |
313095 | 313095 | 2020-07-08 | Jackson | Indiana | 18071 | 477 | 4 |
313200 | 313200 | 2020-07-08 | Jackson | Iowa | 19097 | 39 | 0 |
313292 | 313292 | 2020-07-08 | Jackson | Kansas | 20085 | 117 | 1 |
313404 | 313404 | 2020-07-08 | Jackson | Kentucky | 21109 | 115 | 14 |
313494 | 313494 | 2020-07-08 | Jackson | Louisiana | 22049 | 221 | 16 |
313629 | 313629 | 2020-07-08 | Jackson | Michigan | 26075 | 2140 | 54 |
313707 | 313707 | 2020-07-08 | Jackson | Minnesota | 27063 | 55 | 0 |
313792 | 313792 | 2020-07-08 | Jackson | Mississippi | 28059 | 704 | 17 |
313892 | 313892 | 2020-07-08 | Jackson | Missouri | 29095 | 1479 | 42 |
314267 | 314267 | 2020-07-08 | Jackson | North Carolina | 37099 | 154 | 1 |
314410 | 314410 | 2020-07-08 | Jackson | Ohio | 39079 | 26 | 0 |
314491 | 314491 | 2020-07-08 | Jackson | Oklahoma | 40065 | 54 | 3 |
314549 | 314549 | 2020-07-08 | Jackson | Oregon | 41029 | 157 | 0 |
314801 | 314801 | 2020-07-08 | Jackson | South Dakota | 46071 | 6 | 1 |
314874 | 314874 | 2020-07-08 | Jackson | Tennessee | 47087 | 33 | 0 |
315044 | 315044 | 2020-07-08 | Jackson | Texas | 48239 | 68 | 1 |
315407 | 315407 | 2020-07-08 | Jackson | West Virginia | 54035 | 148 | 18 |
315471 | 315471 | 2020-07-08 | Jackson | Wisconsin | 55053 | 31 | 1 |
309232 | 309232 | 2020-07-07 | Jackson | Alabama | 1071 | 306 | 3 |
309337 | 309337 | 2020-07-07 | Jackson | Arkansas | 5067 | 35 | 0 |
309465 | 309465 | 2020-07-07 | Jackson | Colorado | 8057 | 2 | 0 |
309542 | 309542 | 2020-07-07 | Jackson | Florida | 12063 | 415 | 2 |
309657 | 309657 | 2020-07-07 | Jackson | Georgia | 13157 | 461 | 10 |
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);