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 220
- Oklahoma 213
- Michigan 210
- Mississippi 210
- Missouri 210
- Illinois 208
- Florida 207
- West Virginia 207
- Alabama 206
- Minnesota 206
- Kansas 205
- Indiana 203
- Louisiana 202
- Georgia 201
- Texas 201
- Iowa 197
- Wisconsin 197
- Tennessee 194
- Kentucky 188
- Ohio 188
- North Carolina 183
- Arkansas 182
- South Dakota 142
- Colorado 109
fips 24
county 1
- Jackson · 4,689 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
622647 | 622647 | 2020-10-12 | Jackson | Indiana | 18071 | 950 | 11 |
622752 | 622752 | 2020-10-12 | Jackson | Iowa | 19097 | 456 | 3 |
622846 | 622846 | 2020-10-12 | Jackson | Kansas | 20085 | 275 | 3 |
622963 | 622963 | 2020-10-12 | Jackson | Kentucky | 21109 | 401 | 17 |
623053 | 623053 | 2020-10-12 | Jackson | Louisiana | 22049 | 744 | 22 |
623187 | 623187 | 2020-10-12 | Jackson | Michigan | 26075 | 3044 | 76 |
623265 | 623265 | 2020-10-12 | Jackson | Minnesota | 27063 | 172 | 1 |
623351 | 623351 | 2020-10-12 | Jackson | Mississippi | 28059 | 4029 | 74 |
623451 | 623451 | 2020-10-12 | Jackson | Missouri | 29095 | 8319 | 116 |
623860 | 623860 | 2020-10-12 | Jackson | North Carolina | 37099 | 766 | 7 |
624006 | 624006 | 2020-10-12 | Jackson | Ohio | 39079 | 351 | 7 |
624087 | 624087 | 2020-10-12 | Jackson | Oklahoma | 40065 | 943 | 10 |
624147 | 624147 | 2020-10-12 | Jackson | Oregon | 41029 | 1372 | 6 |
624401 | 624401 | 2020-10-12 | Jackson | South Dakota | 46071 | 57 | 1 |
624476 | 624476 | 2020-10-12 | Jackson | Tennessee | 47087 | 391 | 5 |
624648 | 624648 | 2020-10-12 | Jackson | Texas | 48239 | 632 | 16 |
625019 | 625019 | 2020-10-12 | Jackson | West Virginia | 54035 | 317 | 24 |
625083 | 625083 | 2020-10-12 | Jackson | Wisconsin | 55053 | 215 | 1 |
618702 | 618702 | 2020-10-11 | Jackson | Alabama | 1071 | 1818 | 12 |
618809 | 618809 | 2020-10-11 | Jackson | Arkansas | 5067 | 540 | 5 |
618939 | 618939 | 2020-10-11 | Jackson | Colorado | 8057 | 9 | 0 |
619018 | 619018 | 2020-10-11 | Jackson | Florida | 12063 | 2965 | 84 |
619133 | 619133 | 2020-10-11 | Jackson | Georgia | 13157 | 2222 | 37 |
619303 | 619303 | 2020-10-11 | Jackson | Illinois | 17077 | 1352 | 24 |
619403 | 619403 | 2020-10-11 | Jackson | Indiana | 18071 | 931 | 11 |
619508 | 619508 | 2020-10-11 | Jackson | Iowa | 19097 | 453 | 3 |
619602 | 619602 | 2020-10-11 | Jackson | Kansas | 20085 | 273 | 3 |
619719 | 619719 | 2020-10-11 | Jackson | Kentucky | 21109 | 401 | 17 |
619809 | 619809 | 2020-10-11 | Jackson | Louisiana | 22049 | 745 | 22 |
619944 | 619944 | 2020-10-11 | Jackson | Michigan | 26075 | 3017 | 75 |
620022 | 620022 | 2020-10-11 | Jackson | Minnesota | 27063 | 169 | 1 |
620108 | 620108 | 2020-10-11 | Jackson | Mississippi | 28059 | 4011 | 74 |
620208 | 620208 | 2020-10-11 | Jackson | Missouri | 29095 | 8319 | 116 |
620617 | 620617 | 2020-10-11 | Jackson | North Carolina | 37099 | 760 | 7 |
620763 | 620763 | 2020-10-11 | Jackson | Ohio | 39079 | 339 | 7 |
620844 | 620844 | 2020-10-11 | Jackson | Oklahoma | 40065 | 943 | 10 |
620904 | 620904 | 2020-10-11 | Jackson | Oregon | 41029 | 1364 | 6 |
621158 | 621158 | 2020-10-11 | Jackson | South Dakota | 46071 | 55 | 1 |
621233 | 621233 | 2020-10-11 | Jackson | Tennessee | 47087 | 385 | 5 |
621405 | 621405 | 2020-10-11 | Jackson | Texas | 48239 | 626 | 16 |
621776 | 621776 | 2020-10-11 | Jackson | West Virginia | 54035 | 316 | 24 |
621840 | 621840 | 2020-10-11 | Jackson | Wisconsin | 55053 | 215 | 1 |
615460 | 615460 | 2020-10-10 | Jackson | Alabama | 1071 | 1799 | 12 |
615567 | 615567 | 2020-10-10 | Jackson | Arkansas | 5067 | 501 | 5 |
615697 | 615697 | 2020-10-10 | Jackson | Colorado | 8057 | 9 | 0 |
615776 | 615776 | 2020-10-10 | Jackson | Florida | 12063 | 2932 | 83 |
615891 | 615891 | 2020-10-10 | Jackson | Georgia | 13157 | 2213 | 36 |
616061 | 616061 | 2020-10-10 | Jackson | Illinois | 17077 | 1345 | 24 |
616161 | 616161 | 2020-10-10 | Jackson | Indiana | 18071 | 911 | 11 |
616266 | 616266 | 2020-10-10 | Jackson | Iowa | 19097 | 446 | 3 |
616360 | 616360 | 2020-10-10 | Jackson | Kansas | 20085 | 273 | 3 |
616477 | 616477 | 2020-10-10 | Jackson | Kentucky | 21109 | 401 | 17 |
616567 | 616567 | 2020-10-10 | Jackson | Louisiana | 22049 | 719 | 22 |
616702 | 616702 | 2020-10-10 | Jackson | Michigan | 26075 | 3017 | 75 |
616780 | 616780 | 2020-10-10 | Jackson | Minnesota | 27063 | 168 | 1 |
616866 | 616866 | 2020-10-10 | Jackson | Mississippi | 28059 | 4002 | 74 |
616966 | 616966 | 2020-10-10 | Jackson | Missouri | 29095 | 8319 | 116 |
617375 | 617375 | 2020-10-10 | Jackson | North Carolina | 37099 | 753 | 7 |
617521 | 617521 | 2020-10-10 | Jackson | Ohio | 39079 | 332 | 7 |
617602 | 617602 | 2020-10-10 | Jackson | Oklahoma | 40065 | 937 | 10 |
617662 | 617662 | 2020-10-10 | Jackson | Oregon | 41029 | 1357 | 6 |
617915 | 617915 | 2020-10-10 | Jackson | South Dakota | 46071 | 52 | 1 |
617990 | 617990 | 2020-10-10 | Jackson | Tennessee | 47087 | 382 | 5 |
618162 | 618162 | 2020-10-10 | Jackson | Texas | 48239 | 626 | 16 |
618533 | 618533 | 2020-10-10 | Jackson | West Virginia | 54035 | 313 | 24 |
618597 | 618597 | 2020-10-10 | Jackson | Wisconsin | 55053 | 209 | 1 |
612219 | 612219 | 2020-10-09 | Jackson | Alabama | 1071 | 1777 | 12 |
612326 | 612326 | 2020-10-09 | Jackson | Arkansas | 5067 | 485 | 4 |
612456 | 612456 | 2020-10-09 | Jackson | Colorado | 8057 | 9 | 0 |
612535 | 612535 | 2020-10-09 | Jackson | Florida | 12063 | 2932 | 83 |
612650 | 612650 | 2020-10-09 | Jackson | Georgia | 13157 | 2198 | 35 |
612820 | 612820 | 2020-10-09 | Jackson | Illinois | 17077 | 1333 | 24 |
612920 | 612920 | 2020-10-09 | Jackson | Indiana | 18071 | 894 | 11 |
613025 | 613025 | 2020-10-09 | Jackson | Iowa | 19097 | 437 | 3 |
613119 | 613119 | 2020-10-09 | Jackson | Kansas | 20085 | 273 | 3 |
613236 | 613236 | 2020-10-09 | Jackson | Kentucky | 21109 | 396 | 17 |
613326 | 613326 | 2020-10-09 | Jackson | Louisiana | 22049 | 719 | 22 |
613461 | 613461 | 2020-10-09 | Jackson | Michigan | 26075 | 2979 | 73 |
613539 | 613539 | 2020-10-09 | Jackson | Minnesota | 27063 | 167 | 1 |
613625 | 613625 | 2020-10-09 | Jackson | Mississippi | 28059 | 3956 | 74 |
613725 | 613725 | 2020-10-09 | Jackson | Missouri | 29095 | 8069 | 113 |
614133 | 614133 | 2020-10-09 | Jackson | North Carolina | 37099 | 735 | 7 |
614279 | 614279 | 2020-10-09 | Jackson | Ohio | 39079 | 328 | 7 |
614360 | 614360 | 2020-10-09 | Jackson | Oklahoma | 40065 | 913 | 10 |
614420 | 614420 | 2020-10-09 | Jackson | Oregon | 41029 | 1335 | 6 |
614673 | 614673 | 2020-10-09 | Jackson | South Dakota | 46071 | 50 | 1 |
614748 | 614748 | 2020-10-09 | Jackson | Tennessee | 47087 | 377 | 5 |
614920 | 614920 | 2020-10-09 | Jackson | Texas | 48239 | 627 | 16 |
615291 | 615291 | 2020-10-09 | Jackson | West Virginia | 54035 | 311 | 24 |
615355 | 615355 | 2020-10-09 | Jackson | Wisconsin | 55053 | 207 | 1 |
608977 | 608977 | 2020-10-08 | Jackson | Alabama | 1071 | 1745 | 12 |
609084 | 609084 | 2020-10-08 | Jackson | Arkansas | 5067 | 473 | 2 |
609214 | 609214 | 2020-10-08 | Jackson | Colorado | 8057 | 9 | 0 |
609293 | 609293 | 2020-10-08 | Jackson | Florida | 12063 | 2927 | 82 |
609408 | 609408 | 2020-10-08 | Jackson | Georgia | 13157 | 2179 | 36 |
609578 | 609578 | 2020-10-08 | Jackson | Illinois | 17077 | 1327 | 24 |
609678 | 609678 | 2020-10-08 | Jackson | Indiana | 18071 | 873 | 11 |
609783 | 609783 | 2020-10-08 | Jackson | Iowa | 19097 | 433 | 3 |
609877 | 609877 | 2020-10-08 | Jackson | Kansas | 20085 | 266 | 3 |
609994 | 609994 | 2020-10-08 | Jackson | Kentucky | 21109 | 393 | 17 |
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);