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 143
- Oklahoma 136
- Michigan 133
- Mississippi 133
- Missouri 133
- Illinois 131
- Florida 130
- West Virginia 130
- Alabama 129
- Minnesota 129
- Kansas 128
- Indiana 126
- Louisiana 125
- Georgia 124
- Texas 124
- Iowa 120
- Wisconsin 120
- Tennessee 117
- Kentucky 111
- Ohio 111
- North Carolina 106
- Arkansas 105
- South Dakota 65
- Colorado 32
fips 24
county 1
- Jackson · 2,841 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
373806 | 373806 | 2020-07-27 | Jackson | Indiana | 18071 | 530 | 5 |
373911 | 373911 | 2020-07-27 | Jackson | Iowa | 19097 | 126 | 0 |
374005 | 374005 | 2020-07-27 | Jackson | Kansas | 20085 | 136 | 1 |
374120 | 374120 | 2020-07-27 | Jackson | Kentucky | 21109 | 127 | 14 |
374210 | 374210 | 2020-07-27 | Jackson | Louisiana | 22049 | 340 | 18 |
374345 | 374345 | 2020-07-27 | Jackson | Michigan | 26075 | 2351 | 54 |
374423 | 374423 | 2020-07-27 | Jackson | Minnesota | 27063 | 64 | 0 |
374509 | 374509 | 2020-07-27 | Jackson | Mississippi | 28059 | 1596 | 27 |
374610 | 374610 | 2020-07-27 | Jackson | Missouri | 29095 | 2774 | 56 |
375002 | 375002 | 2020-07-27 | Jackson | North Carolina | 37099 | 365 | 3 |
375147 | 375147 | 2020-07-27 | Jackson | Ohio | 39079 | 55 | 0 |
375228 | 375228 | 2020-07-27 | Jackson | Oklahoma | 40065 | 383 | 3 |
375288 | 375288 | 2020-07-27 | Jackson | Oregon | 41029 | 302 | 0 |
375540 | 375540 | 2020-07-27 | Jackson | South Dakota | 46071 | 7 | 1 |
375615 | 375615 | 2020-07-27 | Jackson | Tennessee | 47087 | 97 | 0 |
375786 | 375786 | 2020-07-27 | Jackson | Texas | 48239 | 202 | 3 |
376155 | 376155 | 2020-07-27 | Jackson | West Virginia | 54035 | 153 | 19 |
376219 | 376219 | 2020-07-27 | Jackson | Wisconsin | 55053 | 40 | 1 |
369898 | 369898 | 2020-07-26 | Jackson | Alabama | 1071 | 658 | 5 |
370005 | 370005 | 2020-07-26 | Jackson | Arkansas | 5067 | 52 | 1 |
370134 | 370134 | 2020-07-26 | Jackson | Colorado | 8057 | 8 | 0 |
370212 | 370212 | 2020-07-26 | Jackson | Florida | 12063 | 1266 | 18 |
370327 | 370327 | 2020-07-26 | Jackson | Georgia | 13157 | 779 | 13 |
370494 | 370494 | 2020-07-26 | Jackson | Illinois | 17077 | 530 | 19 |
370594 | 370594 | 2020-07-26 | Jackson | Indiana | 18071 | 529 | 5 |
370699 | 370699 | 2020-07-26 | Jackson | Iowa | 19097 | 123 | 0 |
370793 | 370793 | 2020-07-26 | Jackson | Kansas | 20085 | 131 | 1 |
370908 | 370908 | 2020-07-26 | Jackson | Kentucky | 21109 | 127 | 14 |
370998 | 370998 | 2020-07-26 | Jackson | Louisiana | 22049 | 338 | 18 |
371133 | 371133 | 2020-07-26 | Jackson | Michigan | 26075 | 2350 | 54 |
371211 | 371211 | 2020-07-26 | Jackson | Minnesota | 27063 | 64 | 0 |
371297 | 371297 | 2020-07-26 | Jackson | Mississippi | 28059 | 1582 | 27 |
371398 | 371398 | 2020-07-26 | Jackson | Missouri | 29095 | 2642 | 55 |
371790 | 371790 | 2020-07-26 | Jackson | North Carolina | 37099 | 352 | 3 |
371935 | 371935 | 2020-07-26 | Jackson | Ohio | 39079 | 55 | 0 |
372016 | 372016 | 2020-07-26 | Jackson | Oklahoma | 40065 | 370 | 3 |
372075 | 372075 | 2020-07-26 | Jackson | Oregon | 41029 | 291 | 0 |
372327 | 372327 | 2020-07-26 | Jackson | South Dakota | 46071 | 7 | 1 |
372402 | 372402 | 2020-07-26 | Jackson | Tennessee | 47087 | 97 | 0 |
372573 | 372573 | 2020-07-26 | Jackson | Texas | 48239 | 202 | 1 |
372941 | 372941 | 2020-07-26 | Jackson | West Virginia | 54035 | 153 | 19 |
373005 | 373005 | 2020-07-26 | Jackson | Wisconsin | 55053 | 39 | 1 |
366688 | 366688 | 2020-07-25 | Jackson | Alabama | 1071 | 648 | 5 |
366795 | 366795 | 2020-07-25 | Jackson | Arkansas | 5067 | 52 | 1 |
366924 | 366924 | 2020-07-25 | Jackson | Colorado | 8057 | 8 | 0 |
367002 | 367002 | 2020-07-25 | Jackson | Florida | 12063 | 1220 | 18 |
367117 | 367117 | 2020-07-25 | Jackson | Georgia | 13157 | 766 | 13 |
367284 | 367284 | 2020-07-25 | Jackson | Illinois | 17077 | 487 | 19 |
367384 | 367384 | 2020-07-25 | Jackson | Indiana | 18071 | 525 | 5 |
367489 | 367489 | 2020-07-25 | Jackson | Iowa | 19097 | 120 | 0 |
367583 | 367583 | 2020-07-25 | Jackson | Kansas | 20085 | 131 | 1 |
367698 | 367698 | 2020-07-25 | Jackson | Kentucky | 21109 | 125 | 14 |
367788 | 367788 | 2020-07-25 | Jackson | Louisiana | 22049 | 332 | 18 |
367923 | 367923 | 2020-07-25 | Jackson | Michigan | 26075 | 2344 | 54 |
368001 | 368001 | 2020-07-25 | Jackson | Minnesota | 27063 | 64 | 0 |
368087 | 368087 | 2020-07-25 | Jackson | Mississippi | 28059 | 1552 | 26 |
368187 | 368187 | 2020-07-25 | Jackson | Missouri | 29095 | 2554 | 53 |
368578 | 368578 | 2020-07-25 | Jackson | North Carolina | 37099 | 348 | 3 |
368723 | 368723 | 2020-07-25 | Jackson | Ohio | 39079 | 55 | 0 |
368804 | 368804 | 2020-07-25 | Jackson | Oklahoma | 40065 | 346 | 3 |
368863 | 368863 | 2020-07-25 | Jackson | Oregon | 41029 | 276 | 0 |
369115 | 369115 | 2020-07-25 | Jackson | South Dakota | 46071 | 7 | 1 |
369190 | 369190 | 2020-07-25 | Jackson | Tennessee | 47087 | 93 | 0 |
369361 | 369361 | 2020-07-25 | Jackson | Texas | 48239 | 202 | 1 |
369729 | 369729 | 2020-07-25 | Jackson | West Virginia | 54035 | 153 | 19 |
369793 | 369793 | 2020-07-25 | Jackson | Wisconsin | 55053 | 37 | 1 |
363481 | 363481 | 2020-07-24 | Jackson | Alabama | 1071 | 635 | 5 |
363588 | 363588 | 2020-07-24 | Jackson | Arkansas | 5067 | 48 | 1 |
363717 | 363717 | 2020-07-24 | Jackson | Colorado | 8057 | 8 | 0 |
363795 | 363795 | 2020-07-24 | Jackson | Florida | 12063 | 979 | 17 |
363910 | 363910 | 2020-07-24 | Jackson | Georgia | 13157 | 735 | 13 |
364077 | 364077 | 2020-07-24 | Jackson | Illinois | 17077 | 463 | 19 |
364177 | 364177 | 2020-07-24 | Jackson | Indiana | 18071 | 523 | 4 |
364282 | 364282 | 2020-07-24 | Jackson | Iowa | 19097 | 113 | 0 |
364376 | 364376 | 2020-07-24 | Jackson | Kansas | 20085 | 131 | 1 |
364491 | 364491 | 2020-07-24 | Jackson | Kentucky | 21109 | 125 | 14 |
364581 | 364581 | 2020-07-24 | Jackson | Louisiana | 22049 | 332 | 18 |
364716 | 364716 | 2020-07-24 | Jackson | Michigan | 26075 | 2227 | 54 |
364794 | 364794 | 2020-07-24 | Jackson | Minnesota | 27063 | 61 | 0 |
364879 | 364879 | 2020-07-24 | Jackson | Mississippi | 28059 | 1481 | 24 |
364979 | 364979 | 2020-07-24 | Jackson | Missouri | 29095 | 2554 | 53 |
365369 | 365369 | 2020-07-24 | Jackson | North Carolina | 37099 | 327 | 3 |
365514 | 365514 | 2020-07-24 | Jackson | Ohio | 39079 | 52 | 0 |
365595 | 365595 | 2020-07-24 | Jackson | Oklahoma | 40065 | 302 | 3 |
365654 | 365654 | 2020-07-24 | Jackson | Oregon | 41029 | 269 | 0 |
365906 | 365906 | 2020-07-24 | Jackson | South Dakota | 46071 | 7 | 1 |
365981 | 365981 | 2020-07-24 | Jackson | Tennessee | 47087 | 93 | 0 |
366152 | 366152 | 2020-07-24 | Jackson | Texas | 48239 | 194 | 1 |
366519 | 366519 | 2020-07-24 | Jackson | West Virginia | 54035 | 153 | 19 |
366583 | 366583 | 2020-07-24 | Jackson | Wisconsin | 55053 | 38 | 1 |
360275 | 360275 | 2020-07-23 | Jackson | Alabama | 1071 | 620 | 4 |
360381 | 360381 | 2020-07-23 | Jackson | Arkansas | 5067 | 47 | 1 |
360510 | 360510 | 2020-07-23 | Jackson | Colorado | 8057 | 8 | 0 |
360588 | 360588 | 2020-07-23 | Jackson | Florida | 12063 | 963 | 17 |
360703 | 360703 | 2020-07-23 | Jackson | Georgia | 13157 | 694 | 13 |
360870 | 360870 | 2020-07-23 | Jackson | Illinois | 17077 | 450 | 19 |
360970 | 360970 | 2020-07-23 | Jackson | Indiana | 18071 | 518 | 4 |
361075 | 361075 | 2020-07-23 | Jackson | Iowa | 19097 | 110 | 0 |
361169 | 361169 | 2020-07-23 | Jackson | Kansas | 20085 | 131 | 1 |
361284 | 361284 | 2020-07-23 | Jackson | Kentucky | 21109 | 124 | 14 |
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);