ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,191 rows where county = "Jackson" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Jackson · 7,191 ✖
Link rowid date ▲ county state fips cases deaths
959498 959498 2021-01-24 Jackson Alabama 1071 6015 45
959606 959606 2021-01-24 Jackson Arkansas 5067 3028 30
959736 959736 2021-01-24 Jackson Colorado 8057 44 0
959815 959815 2021-01-24 Jackson Florida 12063 5513 129
959930 959930 2021-01-24 Jackson Georgia 13157 7823 97
960101 960101 2021-01-24 Jackson Illinois 17077 4302 70
960200 960200 2021-01-24 Jackson Indiana 18071 4271 48
960305 960305 2021-01-24 Jackson Iowa 19097 1950 32
960399 960399 2021-01-24 Jackson Kansas 20085 1234 10
960517 960517 2021-01-24 Jackson Kentucky 21109 1082 24
960607 960607 2021-01-24 Jackson Louisiana 22049 1582 43
960742 960742 2021-01-24 Jackson Michigan 26075 13105 228
960820 960820 2021-01-24 Jackson Minnesota 27063 873 10
960906 960906 2021-01-24 Jackson Mississippi 28059 10917 190
961006 961006 2021-01-24 Jackson Missouri 29095 27585 297
961415 961415 2021-01-24 Jackson North Carolina 37099 2884 21
961561 961561 2021-01-24 Jackson Ohio 39079 2653 45
961642 961642 2021-01-24 Jackson Oklahoma 40065 2664 40
961702 961702 2021-01-24 Jackson Oregon 41029 7169 96
961956 961956 2021-01-24 Jackson South Dakota 46071 269 13
962031 962031 2021-01-24 Jackson Tennessee 47087 1061 23
962203 962203 2021-01-24 Jackson Texas 48239 1395 23
962575 962575 2021-01-24 Jackson West Virginia 54035 1541 43
962639 962639 2021-01-24 Jackson Wisconsin 55053 2567 20
956252 956252 2021-01-23 Jackson Alabama 1071 5991 45
956360 956360 2021-01-23 Jackson Arkansas 5067 3024 30
956490 956490 2021-01-23 Jackson Colorado 8057 44 0
956569 956569 2021-01-23 Jackson Florida 12063 5496 128
956684 956684 2021-01-23 Jackson Georgia 13157 7754 97
956855 956855 2021-01-23 Jackson Illinois 17077 4296 70
956954 956954 2021-01-23 Jackson Indiana 18071 4254 48
957059 957059 2021-01-23 Jackson Iowa 19097 1949 32
957153 957153 2021-01-23 Jackson Kansas 20085 1234 10
957271 957271 2021-01-23 Jackson Kentucky 21109 1080 23
957361 957361 2021-01-23 Jackson Louisiana 22049 1555 43
957496 957496 2021-01-23 Jackson Michigan 26075 13105 228
957574 957574 2021-01-23 Jackson Minnesota 27063 873 10
957660 957660 2021-01-23 Jackson Mississippi 28059 10839 190
957760 957760 2021-01-23 Jackson Missouri 29095 27320 297
958170 958170 2021-01-23 Jackson North Carolina 37099 2866 20
958316 958316 2021-01-23 Jackson Ohio 39079 2638 45
958397 958397 2021-01-23 Jackson Oklahoma 40065 2643 40
958457 958457 2021-01-23 Jackson Oregon 41029 7122 95
958711 958711 2021-01-23 Jackson South Dakota 46071 269 13
958786 958786 2021-01-23 Jackson Tennessee 47087 1059 23
958958 958958 2021-01-23 Jackson Texas 48239 1395 23
959330 959330 2021-01-23 Jackson West Virginia 54035 1545 43
959394 959394 2021-01-23 Jackson Wisconsin 55053 2562 20
953007 953007 2021-01-22 Jackson Alabama 1071 5946 44
953115 953115 2021-01-22 Jackson Arkansas 5067 3021 30
953245 953245 2021-01-22 Jackson Colorado 8057 44 0
953324 953324 2021-01-22 Jackson Florida 12063 5470 128
953439 953439 2021-01-22 Jackson Georgia 13157 7656 96
953610 953610 2021-01-22 Jackson Illinois 17077 4285 70
953709 953709 2021-01-22 Jackson Indiana 18071 4223 48
953814 953814 2021-01-22 Jackson Iowa 19097 1943 31
953908 953908 2021-01-22 Jackson Kansas 20085 1234 10
954026 954026 2021-01-22 Jackson Kentucky 21109 1074 23
954116 954116 2021-01-22 Jackson Louisiana 22049 1555 43
954251 954251 2021-01-22 Jackson Michigan 26075 13066 223
954329 954329 2021-01-22 Jackson Minnesota 27063 871 10
954415 954415 2021-01-22 Jackson Mississippi 28059 10729 188
954515 954515 2021-01-22 Jackson Missouri 29095 27169 293
954924 954924 2021-01-22 Jackson North Carolina 37099 2840 20
955070 955070 2021-01-22 Jackson Ohio 39079 2624 45
955151 955151 2021-01-22 Jackson Oklahoma 40065 2624 40
955211 955211 2021-01-22 Jackson Oregon 41029 7073 95
955465 955465 2021-01-22 Jackson South Dakota 46071 269 13
955540 955540 2021-01-22 Jackson Tennessee 47087 1057 23
955712 955712 2021-01-22 Jackson Texas 48239 1380 23
956084 956084 2021-01-22 Jackson West Virginia 54035 1531 43
956148 956148 2021-01-22 Jackson Wisconsin 55053 2559 20
949762 949762 2021-01-21 Jackson Alabama 1071 5903 41
949870 949870 2021-01-21 Jackson Arkansas 5067 3019 29
950000 950000 2021-01-21 Jackson Colorado 8057 44 0
950079 950079 2021-01-21 Jackson Florida 12063 5437 128
950194 950194 2021-01-21 Jackson Georgia 13157 7564 93
950365 950365 2021-01-21 Jackson Illinois 17077 4244 70
950464 950464 2021-01-21 Jackson Indiana 18071 4211 48
950569 950569 2021-01-21 Jackson Iowa 19097 1939 31
950663 950663 2021-01-21 Jackson Kansas 20085 1219 10
950781 950781 2021-01-21 Jackson Kentucky 21109 1069 23
950871 950871 2021-01-21 Jackson Louisiana 22049 1546 42
951006 951006 2021-01-21 Jackson Michigan 26075 13036 223
951084 951084 2021-01-21 Jackson Minnesota 27063 863 10
951170 951170 2021-01-21 Jackson Mississippi 28059 10652 187
951270 951270 2021-01-21 Jackson Missouri 29095 27046 292
951679 951679 2021-01-21 Jackson North Carolina 37099 2811 20
951825 951825 2021-01-21 Jackson Ohio 39079 2613 45
951906 951906 2021-01-21 Jackson Oklahoma 40065 2622 40
951966 951966 2021-01-21 Jackson Oregon 41029 7043 90
952220 952220 2021-01-21 Jackson South Dakota 46071 269 13
952295 952295 2021-01-21 Jackson Tennessee 47087 1058 23
952467 952467 2021-01-21 Jackson Texas 48239 1342 23
952839 952839 2021-01-21 Jackson West Virginia 54035 1526 43
952903 952903 2021-01-21 Jackson Wisconsin 55053 2552 20
946516 946516 2021-01-20 Jackson Alabama 1071 5863 41
946624 946624 2021-01-20 Jackson Arkansas 5067 3014 29
946754 946754 2021-01-20 Jackson Colorado 8057 44 0
946833 946833 2021-01-20 Jackson Florida 12063 5383 128

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);