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
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 24
- Michigan 773
- Minnesota 773
- Mississippi 773
- Missouri 773
- Oklahoma 773
- Oregon 773
- Texas 773
- West Virginia 773
- Wisconsin 773
- Alabama 772
- Florida 772
- Georgia 772
- Illinois 772
- Indiana 772
- Iowa 772
- Kansas 772
- Louisiana 772
- Tennessee 772
- Kentucky 766
- Ohio 766
- Arkansas 761
- North Carolina 761
- South Dakota 720
- Colorado 688
fips 24
county 1
- Jackson · 18,367 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
24829 | 24829 | 2020-04-01 | Jackson | Michigan | 26075 | 56 | 2 |
24891 | 24891 | 2020-04-01 | Jackson | Minnesota | 27063 | 1 | 0 |
24950 | 24950 | 2020-04-01 | Jackson | Mississippi | 28059 | 52 | 0 |
25030 | 25030 | 2020-04-01 | Jackson | Missouri | 29095 | 86 | 2 |
25430 | 25430 | 2020-04-01 | Jackson | Oklahoma | 40065 | 2 | 0 |
25468 | 25468 | 2020-04-01 | Jackson | Oregon | 41029 | 22 | 0 |
25773 | 25773 | 2020-04-01 | Jackson | Texas | 48239 | 1 | 0 |
26013 | 26013 | 2020-04-01 | Jackson | West Virginia | 54035 | 11 | 0 |
26056 | 26056 | 2020-04-01 | Jackson | Wisconsin | 55053 | 2 | 0 |
26134 | 26134 | 2020-04-02 | Jackson | Alabama | 1071 | 9 | 1 |
26392 | 26392 | 2020-04-02 | Jackson | Florida | 12063 | 4 | 0 |
26495 | 26495 | 2020-04-02 | Jackson | Georgia | 13157 | 11 | 0 |
26626 | 26626 | 2020-04-02 | Jackson | Illinois | 17077 | 6 | 0 |
26701 | 26701 | 2020-04-02 | Jackson | Indiana | 18071 | 19 | 0 |
26781 | 26781 | 2020-04-02 | Jackson | Iowa | 19097 | 1 | 0 |
26833 | 26833 | 2020-04-02 | Jackson | Kansas | 20085 | 1 | 0 |
26958 | 26958 | 2020-04-02 | Jackson | Louisiana | 22049 | 4 | 0 |
27082 | 27082 | 2020-04-02 | Jackson | Michigan | 26075 | 67 | 2 |
27144 | 27144 | 2020-04-02 | Jackson | Minnesota | 27063 | 1 | 0 |
27204 | 27204 | 2020-04-02 | Jackson | Mississippi | 28059 | 57 | 1 |
27286 | 27286 | 2020-04-02 | Jackson | Missouri | 29095 | 103 | 2 |
27700 | 27700 | 2020-04-02 | Jackson | Oklahoma | 40065 | 2 | 0 |
27740 | 27740 | 2020-04-02 | Jackson | Oregon | 41029 | 27 | 0 |
27942 | 27942 | 2020-04-02 | Jackson | Tennessee | 47087 | 2 | 0 |
28056 | 28056 | 2020-04-02 | Jackson | Texas | 48239 | 2 | 0 |
28305 | 28305 | 2020-04-02 | Jackson | West Virginia | 54035 | 11 | 1 |
28349 | 28349 | 2020-04-02 | Jackson | Wisconsin | 55053 | 2 | 0 |
28431 | 28431 | 2020-04-03 | Jackson | Alabama | 1071 | 12 | 1 |
28695 | 28695 | 2020-04-03 | Jackson | Florida | 12063 | 4 | 0 |
28799 | 28799 | 2020-04-03 | Jackson | Georgia | 13157 | 13 | 0 |
28935 | 28935 | 2020-04-03 | Jackson | Illinois | 17077 | 8 | 0 |
29011 | 29011 | 2020-04-03 | Jackson | Indiana | 18071 | 25 | 0 |
29092 | 29092 | 2020-04-03 | Jackson | Iowa | 19097 | 2 | 0 |
29147 | 29147 | 2020-04-03 | Jackson | Kansas | 20085 | 1 | 0 |
29275 | 29275 | 2020-04-03 | Jackson | Louisiana | 22049 | 4 | 0 |
29400 | 29400 | 2020-04-03 | Jackson | Michigan | 26075 | 69 | 3 |
29463 | 29463 | 2020-04-03 | Jackson | Minnesota | 27063 | 1 | 0 |
29523 | 29523 | 2020-04-03 | Jackson | Mississippi | 28059 | 75 | 1 |
29606 | 29606 | 2020-04-03 | Jackson | Missouri | 29095 | 120 | 3 |
30030 | 30030 | 2020-04-03 | Jackson | Oklahoma | 40065 | 4 | 0 |
30073 | 30073 | 2020-04-03 | Jackson | Oregon | 41029 | 27 | 0 |
30277 | 30277 | 2020-04-03 | Jackson | Tennessee | 47087 | 3 | 0 |
30391 | 30391 | 2020-04-03 | Jackson | Texas | 48239 | 3 | 0 |
30658 | 30658 | 2020-04-03 | Jackson | West Virginia | 54035 | 11 | 1 |
30704 | 30704 | 2020-04-03 | Jackson | Wisconsin | 55053 | 2 | 0 |
30788 | 30788 | 2020-04-04 | Jackson | Alabama | 1071 | 13 | 1 |
31054 | 31054 | 2020-04-04 | Jackson | Florida | 12063 | 4 | 0 |
31159 | 31159 | 2020-04-04 | Jackson | Georgia | 13157 | 15 | 0 |
31297 | 31297 | 2020-04-04 | Jackson | Illinois | 17077 | 10 | 1 |
31377 | 31377 | 2020-04-04 | Jackson | Indiana | 18071 | 28 | 0 |
31462 | 31462 | 2020-04-04 | Jackson | Iowa | 19097 | 3 | 0 |
31520 | 31520 | 2020-04-04 | Jackson | Kansas | 20085 | 1 | 0 |
31653 | 31653 | 2020-04-04 | Jackson | Louisiana | 22049 | 1 | 0 |
31778 | 31778 | 2020-04-04 | Jackson | Michigan | 26075 | 81 | 3 |
31841 | 31841 | 2020-04-04 | Jackson | Minnesota | 27063 | 1 | 0 |
31903 | 31903 | 2020-04-04 | Jackson | Mississippi | 28059 | 79 | 1 |
31986 | 31986 | 2020-04-04 | Jackson | Missouri | 29095 | 135 | 3 |
32419 | 32419 | 2020-04-04 | Jackson | Oklahoma | 40065 | 4 | 0 |
32463 | 32463 | 2020-04-04 | Jackson | Oregon | 41029 | 33 | 0 |
32668 | 32668 | 2020-04-04 | Jackson | Tennessee | 47087 | 3 | 0 |
32786 | 32786 | 2020-04-04 | Jackson | Texas | 48239 | 3 | 0 |
33059 | 33059 | 2020-04-04 | Jackson | West Virginia | 54035 | 13 | 1 |
33105 | 33105 | 2020-04-04 | Jackson | Wisconsin | 55053 | 3 | 0 |
33192 | 33192 | 2020-04-05 | Jackson | Alabama | 1071 | 14 | 1 |
33460 | 33460 | 2020-04-05 | Jackson | Florida | 12063 | 4 | 0 |
33566 | 33566 | 2020-04-05 | Jackson | Georgia | 13157 | 15 | 0 |
33707 | 33707 | 2020-04-05 | Jackson | Illinois | 17077 | 12 | 1 |
33788 | 33788 | 2020-04-05 | Jackson | Indiana | 18071 | 36 | 0 |
33875 | 33875 | 2020-04-05 | Jackson | Iowa | 19097 | 3 | 0 |
33934 | 33934 | 2020-04-05 | Jackson | Kansas | 20085 | 1 | 0 |
34078 | 34078 | 2020-04-05 | Jackson | Louisiana | 22049 | 1 | 0 |
34203 | 34203 | 2020-04-05 | Jackson | Michigan | 26075 | 90 | 3 |
34267 | 34267 | 2020-04-05 | Jackson | Minnesota | 27063 | 1 | 0 |
34330 | 34330 | 2020-04-05 | Jackson | Mississippi | 28059 | 86 | 3 |
34414 | 34414 | 2020-04-05 | Jackson | Missouri | 29095 | 139 | 4 |
34853 | 34853 | 2020-04-05 | Jackson | Oklahoma | 40065 | 4 | 0 |
34897 | 34897 | 2020-04-05 | Jackson | Oregon | 41029 | 33 | 0 |
35105 | 35105 | 2020-04-05 | Jackson | Tennessee | 47087 | 3 | 0 |
35224 | 35224 | 2020-04-05 | Jackson | Texas | 48239 | 3 | 0 |
35497 | 35497 | 2020-04-05 | Jackson | West Virginia | 54035 | 14 | 1 |
35544 | 35544 | 2020-04-05 | Jackson | Wisconsin | 55053 | 3 | 0 |
35631 | 35631 | 2020-04-06 | Jackson | Alabama | 1071 | 17 | 1 |
35906 | 35906 | 2020-04-06 | Jackson | Florida | 12063 | 4 | 0 |
36015 | 36015 | 2020-04-06 | Jackson | Georgia | 13157 | 18 | 0 |
36158 | 36158 | 2020-04-06 | Jackson | Illinois | 17077 | 16 | 1 |
36241 | 36241 | 2020-04-06 | Jackson | Indiana | 18071 | 37 | 0 |
36330 | 36330 | 2020-04-06 | Jackson | Iowa | 19097 | 4 | 0 |
36391 | 36391 | 2020-04-06 | Jackson | Kansas | 20085 | 1 | 0 |
36536 | 36536 | 2020-04-06 | Jackson | Louisiana | 22049 | 4 | 0 |
36662 | 36662 | 2020-04-06 | Jackson | Michigan | 26075 | 103 | 4 |
36727 | 36727 | 2020-04-06 | Jackson | Minnesota | 27063 | 1 | 0 |
36793 | 36793 | 2020-04-06 | Jackson | Mississippi | 28059 | 98 | 5 |
36878 | 36878 | 2020-04-06 | Jackson | Missouri | 29095 | 149 | 4 |
37326 | 37326 | 2020-04-06 | Jackson | Oklahoma | 40065 | 4 | 0 |
37372 | 37372 | 2020-04-06 | Jackson | Oregon | 41029 | 39 | 0 |
37581 | 37581 | 2020-04-06 | Jackson | Tennessee | 47087 | 3 | 0 |
37700 | 37700 | 2020-04-06 | Jackson | Texas | 48239 | 3 | 0 |
37981 | 37981 | 2020-04-06 | Jackson | West Virginia | 54035 | 16 | 1 |
38030 | 38030 | 2020-04-06 | Jackson | Wisconsin | 55053 | 4 | 0 |
38119 | 38119 | 2020-04-07 | Jackson | Alabama | 1071 | 18 | 1 |
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);