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 308
- Oklahoma 301
- Michigan 298
- Mississippi 298
- Missouri 298
- Illinois 296
- Florida 295
- West Virginia 295
- Alabama 294
- Minnesota 294
- Kansas 293
- Indiana 291
- Louisiana 290
- Georgia 289
- Texas 289
- Iowa 285
- Wisconsin 285
- Tennessee 282
- Kentucky 276
- Ohio 276
- North Carolina 271
- Arkansas 270
- South Dakota 230
- Colorado 197
fips 24
county 1
- Jackson · 6,801 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908195 | 908195 | 2021-01-08 | Jackson | Indiana | 18071 | 3966 | 46 |
908300 | 908300 | 2021-01-08 | Jackson | Iowa | 19097 | 1842 | 31 |
908394 | 908394 | 2021-01-08 | Jackson | Kansas | 20085 | 1126 | 10 |
908512 | 908512 | 2021-01-08 | Jackson | Kentucky | 21109 | 954 | 21 |
908602 | 908602 | 2021-01-08 | Jackson | Louisiana | 22049 | 1467 | 39 |
908737 | 908737 | 2021-01-08 | Jackson | Michigan | 26075 | 10906 | 200 |
908815 | 908815 | 2021-01-08 | Jackson | Minnesota | 27063 | 821 | 10 |
908901 | 908901 | 2021-01-08 | Jackson | Mississippi | 28059 | 9423 | 166 |
909001 | 909001 | 2021-01-08 | Jackson | Missouri | 29095 | 24938 | 263 |
909410 | 909410 | 2021-01-08 | Jackson | North Carolina | 37099 | 2516 | 18 |
909556 | 909556 | 2021-01-08 | Jackson | Ohio | 39079 | 2353 | 37 |
909637 | 909637 | 2021-01-08 | Jackson | Oklahoma | 40065 | 2419 | 38 |
909697 | 909697 | 2021-01-08 | Jackson | Oregon | 41029 | 6364 | 77 |
909951 | 909951 | 2021-01-08 | Jackson | South Dakota | 46071 | 267 | 11 |
910026 | 910026 | 2021-01-08 | Jackson | Tennessee | 47087 | 1002 | 20 |
910198 | 910198 | 2021-01-08 | Jackson | Texas | 48239 | 1198 | 20 |
910570 | 910570 | 2021-01-08 | Jackson | West Virginia | 54035 | 1328 | 33 |
910634 | 910634 | 2021-01-08 | Jackson | Wisconsin | 55053 | 2483 | 18 |
904247 | 904247 | 2021-01-07 | Jackson | Alabama | 1071 | 5466 | 34 |
904355 | 904355 | 2021-01-07 | Jackson | Arkansas | 5067 | 2901 | 24 |
904485 | 904485 | 2021-01-07 | Jackson | Colorado | 8057 | 39 | 0 |
904564 | 904564 | 2021-01-07 | Jackson | Florida | 12063 | 4948 | 120 |
904679 | 904679 | 2021-01-07 | Jackson | Georgia | 13157 | 6209 | 75 |
904850 | 904850 | 2021-01-07 | Jackson | Illinois | 17077 | 3835 | 66 |
904949 | 904949 | 2021-01-07 | Jackson | Indiana | 18071 | 3944 | 46 |
905054 | 905054 | 2021-01-07 | Jackson | Iowa | 19097 | 1833 | 30 |
905148 | 905148 | 2021-01-07 | Jackson | Kansas | 20085 | 1094 | 10 |
905266 | 905266 | 2021-01-07 | Jackson | Kentucky | 21109 | 940 | 21 |
905356 | 905356 | 2021-01-07 | Jackson | Louisiana | 22049 | 1465 | 39 |
905491 | 905491 | 2021-01-07 | Jackson | Michigan | 26075 | 10857 | 199 |
905569 | 905569 | 2021-01-07 | Jackson | Minnesota | 27063 | 817 | 9 |
905655 | 905655 | 2021-01-07 | Jackson | Mississippi | 28059 | 9364 | 164 |
905755 | 905755 | 2021-01-07 | Jackson | Missouri | 29095 | 24721 | 262 |
906165 | 906165 | 2021-01-07 | Jackson | North Carolina | 37099 | 2477 | 18 |
906311 | 906311 | 2021-01-07 | Jackson | Ohio | 39079 | 2322 | 35 |
906392 | 906392 | 2021-01-07 | Jackson | Oklahoma | 40065 | 2403 | 38 |
906452 | 906452 | 2021-01-07 | Jackson | Oregon | 41029 | 6281 | 75 |
906706 | 906706 | 2021-01-07 | Jackson | South Dakota | 46071 | 267 | 10 |
906781 | 906781 | 2021-01-07 | Jackson | Tennessee | 47087 | 991 | 20 |
906953 | 906953 | 2021-01-07 | Jackson | Texas | 48239 | 1181 | 20 |
907325 | 907325 | 2021-01-07 | Jackson | West Virginia | 54035 | 1310 | 33 |
907389 | 907389 | 2021-01-07 | Jackson | Wisconsin | 55053 | 2476 | 18 |
901002 | 901002 | 2021-01-06 | Jackson | Alabama | 1071 | 5420 | 34 |
901110 | 901110 | 2021-01-06 | Jackson | Arkansas | 5067 | 2866 | 24 |
901240 | 901240 | 2021-01-06 | Jackson | Colorado | 8057 | 39 | 0 |
901319 | 901319 | 2021-01-06 | Jackson | Florida | 12063 | 4860 | 120 |
901434 | 901434 | 2021-01-06 | Jackson | Georgia | 13157 | 6127 | 75 |
901605 | 901605 | 2021-01-06 | Jackson | Illinois | 17077 | 3804 | 62 |
901704 | 901704 | 2021-01-06 | Jackson | Indiana | 18071 | 3892 | 45 |
901809 | 901809 | 2021-01-06 | Jackson | Iowa | 19097 | 1820 | 30 |
901903 | 901903 | 2021-01-06 | Jackson | Kansas | 20085 | 1094 | 10 |
902021 | 902021 | 2021-01-06 | Jackson | Kentucky | 21109 | 922 | 21 |
902111 | 902111 | 2021-01-06 | Jackson | Louisiana | 22049 | 1454 | 39 |
902246 | 902246 | 2021-01-06 | Jackson | Michigan | 26075 | 10769 | 190 |
902324 | 902324 | 2021-01-06 | Jackson | Minnesota | 27063 | 811 | 8 |
902410 | 902410 | 2021-01-06 | Jackson | Mississippi | 28059 | 9189 | 164 |
902510 | 902510 | 2021-01-06 | Jackson | Missouri | 29095 | 24441 | 260 |
902919 | 902919 | 2021-01-06 | Jackson | North Carolina | 37099 | 2469 | 18 |
903065 | 903065 | 2021-01-06 | Jackson | Ohio | 39079 | 2284 | 35 |
903146 | 903146 | 2021-01-06 | Jackson | Oklahoma | 40065 | 2397 | 38 |
903206 | 903206 | 2021-01-06 | Jackson | Oregon | 41029 | 6210 | 75 |
903460 | 903460 | 2021-01-06 | Jackson | South Dakota | 46071 | 265 | 8 |
903535 | 903535 | 2021-01-06 | Jackson | Tennessee | 47087 | 987 | 20 |
903707 | 903707 | 2021-01-06 | Jackson | Texas | 48239 | 1148 | 20 |
904079 | 904079 | 2021-01-06 | Jackson | West Virginia | 54035 | 1290 | 33 |
904143 | 904143 | 2021-01-06 | Jackson | Wisconsin | 55053 | 2466 | 18 |
897757 | 897757 | 2021-01-05 | Jackson | Alabama | 1071 | 5324 | 34 |
897865 | 897865 | 2021-01-05 | Jackson | Arkansas | 5067 | 2859 | 23 |
897995 | 897995 | 2021-01-05 | Jackson | Colorado | 8057 | 39 | 0 |
898074 | 898074 | 2021-01-05 | Jackson | Florida | 12063 | 4802 | 120 |
898189 | 898189 | 2021-01-05 | Jackson | Georgia | 13157 | 6072 | 75 |
898360 | 898360 | 2021-01-05 | Jackson | Illinois | 17077 | 3763 | 62 |
898459 | 898459 | 2021-01-05 | Jackson | Indiana | 18071 | 3868 | 45 |
898564 | 898564 | 2021-01-05 | Jackson | Iowa | 19097 | 1811 | 29 |
898658 | 898658 | 2021-01-05 | Jackson | Kansas | 20085 | 1051 | 10 |
898776 | 898776 | 2021-01-05 | Jackson | Kentucky | 21109 | 896 | 21 |
898866 | 898866 | 2021-01-05 | Jackson | Louisiana | 22049 | 1415 | 39 |
899001 | 899001 | 2021-01-05 | Jackson | Michigan | 26075 | 10685 | 190 |
899079 | 899079 | 2021-01-05 | Jackson | Minnesota | 27063 | 804 | 8 |
899165 | 899165 | 2021-01-05 | Jackson | Mississippi | 28059 | 9057 | 164 |
899265 | 899265 | 2021-01-05 | Jackson | Missouri | 29095 | 24252 | 258 |
899674 | 899674 | 2021-01-05 | Jackson | North Carolina | 37099 | 2449 | 18 |
899820 | 899820 | 2021-01-05 | Jackson | Ohio | 39079 | 2249 | 34 |
899901 | 899901 | 2021-01-05 | Jackson | Oklahoma | 40065 | 2385 | 37 |
899961 | 899961 | 2021-01-05 | Jackson | Oregon | 41029 | 6173 | 74 |
900215 | 900215 | 2021-01-05 | Jackson | South Dakota | 46071 | 263 | 8 |
900290 | 900290 | 2021-01-05 | Jackson | Tennessee | 47087 | 986 | 20 |
900462 | 900462 | 2021-01-05 | Jackson | Texas | 48239 | 1142 | 20 |
900834 | 900834 | 2021-01-05 | Jackson | West Virginia | 54035 | 1273 | 33 |
900898 | 900898 | 2021-01-05 | Jackson | Wisconsin | 55053 | 2452 | 18 |
894511 | 894511 | 2021-01-04 | Jackson | Alabama | 1071 | 5265 | 34 |
894620 | 894620 | 2021-01-04 | Jackson | Arkansas | 5067 | 2840 | 22 |
894750 | 894750 | 2021-01-04 | Jackson | Colorado | 8057 | 37 | 0 |
894829 | 894829 | 2021-01-04 | Jackson | Florida | 12063 | 4772 | 120 |
894944 | 894944 | 2021-01-04 | Jackson | Georgia | 13157 | 5952 | 74 |
895115 | 895115 | 2021-01-04 | Jackson | Illinois | 17077 | 3727 | 62 |
895214 | 895214 | 2021-01-04 | Jackson | Indiana | 18071 | 3849 | 44 |
895319 | 895319 | 2021-01-04 | Jackson | Iowa | 19097 | 1791 | 29 |
895413 | 895413 | 2021-01-04 | Jackson | Kansas | 20085 | 1051 | 10 |
895531 | 895531 | 2021-01-04 | Jackson | Kentucky | 21109 | 878 | 21 |
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);