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

8,055 rows where county = "Jackson" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

  • Jackson · 8,055 ✖
Link rowid date ▲ county state fips cases deaths
1076260 1076260 2021-03-01 Jackson Alabama 1071 6495 102
1076368 1076368 2021-03-01 Jackson Arkansas 5067 3175 33
1076498 1076498 2021-03-01 Jackson Colorado 8057 51 0
1076577 1076577 2021-03-01 Jackson Florida 12063 5909 150
1076692 1076692 2021-03-01 Jackson Georgia 13157 9094 131
1076863 1076863 2021-03-01 Jackson Illinois 17077 4611 71
1076963 1076963 2021-03-01 Jackson Indiana 18071 4651 68
1077068 1077068 2021-03-01 Jackson Iowa 19097 2075 38
1077162 1077162 2021-03-01 Jackson Kansas 20085 1330 15
1077280 1077280 2021-03-01 Jackson Kentucky 21109 1206 29
1077370 1077370 2021-03-01 Jackson Louisiana 22049 1786 47
1077504 1077504 2021-03-01 Jackson Michigan 26075 14208 253
1077582 1077582 2021-03-01 Jackson Minnesota 27063 935 10
1077668 1077668 2021-03-01 Jackson Mississippi 28059 12592 226
1077768 1077768 2021-03-01 Jackson Missouri 29095 30137 381
1078177 1078177 2021-03-01 Jackson North Carolina 37099 3336 48
1078323 1078323 2021-03-01 Jackson Ohio 39079 2893 56
1078404 1078404 2021-03-01 Jackson Oklahoma 40065 2918 44
1078464 1078464 2021-03-01 Jackson Oregon 41029 8407 112
1078718 1078718 2021-03-01 Jackson South Dakota 46071 279 14
1078793 1078793 2021-03-01 Jackson Tennessee 47087 1251 34
1078965 1078965 2021-03-01 Jackson Texas 48239 1682 29
1079337 1079337 2021-03-01 Jackson West Virginia 54035 1667 50
1079401 1079401 2021-03-01 Jackson Wisconsin 55053 2615 23
1073014 1073014 2021-02-28 Jackson Alabama 1071 6492 102
1073122 1073122 2021-02-28 Jackson Arkansas 5067 3172 33
1073252 1073252 2021-02-28 Jackson Colorado 8057 51 0
1073331 1073331 2021-02-28 Jackson Florida 12063 5909 150
1073446 1073446 2021-02-28 Jackson Georgia 13157 9082 131
1073617 1073617 2021-02-28 Jackson Illinois 17077 4610 71
1073717 1073717 2021-02-28 Jackson Indiana 18071 4649 67
1073822 1073822 2021-02-28 Jackson Iowa 19097 2075 38
1073916 1073916 2021-02-28 Jackson Kansas 20085 1330 15
1074034 1074034 2021-02-28 Jackson Kentucky 21109 1207 29
1074124 1074124 2021-02-28 Jackson Louisiana 22049 1776 47
1074258 1074258 2021-02-28 Jackson Michigan 26075 14172 253
1074336 1074336 2021-02-28 Jackson Minnesota 27063 934 10
1074422 1074422 2021-02-28 Jackson Mississippi 28059 12575 226
1074522 1074522 2021-02-28 Jackson Missouri 29095 30131 381
1074932 1074932 2021-02-28 Jackson North Carolina 37099 3322 48
1075078 1075078 2021-02-28 Jackson Ohio 39079 2892 56
1075159 1075159 2021-02-28 Jackson Oklahoma 40065 2915 44
1075219 1075219 2021-02-28 Jackson Oregon 41029 8395 112
1075473 1075473 2021-02-28 Jackson South Dakota 46071 279 14
1075548 1075548 2021-02-28 Jackson Tennessee 47087 1250 34
1075720 1075720 2021-02-28 Jackson Texas 48239 1682 29
1076092 1076092 2021-02-28 Jackson West Virginia 54035 1668 50
1076156 1076156 2021-02-28 Jackson Wisconsin 55053 2615 23
1069768 1069768 2021-02-27 Jackson Alabama 1071 6487 102
1069876 1069876 2021-02-27 Jackson Arkansas 5067 3135 33
1070006 1070006 2021-02-27 Jackson Colorado 8057 51 0
1070085 1070085 2021-02-27 Jackson Florida 12063 5908 150
1070200 1070200 2021-02-27 Jackson Georgia 13157 9070 131
1070371 1070371 2021-02-27 Jackson Illinois 17077 4601 71
1070471 1070471 2021-02-27 Jackson Indiana 18071 4647 67
1070576 1070576 2021-02-27 Jackson Iowa 19097 2075 38
1070670 1070670 2021-02-27 Jackson Kansas 20085 1330 15
1070788 1070788 2021-02-27 Jackson Kentucky 21109 1204 29
1070878 1070878 2021-02-27 Jackson Louisiana 22049 1777 47
1071012 1071012 2021-02-27 Jackson Michigan 26075 14172 253
1071090 1071090 2021-02-27 Jackson Minnesota 27063 933 10
1071176 1071176 2021-02-27 Jackson Mississippi 28059 12509 224
1071276 1071276 2021-02-27 Jackson Missouri 29095 30116 381
1071686 1071686 2021-02-27 Jackson North Carolina 37099 3322 48
1071832 1071832 2021-02-27 Jackson Ohio 39079 2885 56
1071913 1071913 2021-02-27 Jackson Oklahoma 40065 2899 44
1071973 1071973 2021-02-27 Jackson Oregon 41029 8377 112
1072227 1072227 2021-02-27 Jackson South Dakota 46071 279 14
1072302 1072302 2021-02-27 Jackson Tennessee 47087 1250 34
1072474 1072474 2021-02-27 Jackson Texas 48239 1680 29
1072846 1072846 2021-02-27 Jackson West Virginia 54035 1666 50
1072910 1072910 2021-02-27 Jackson Wisconsin 55053 2615 23
1066523 1066523 2021-02-26 Jackson Alabama 1071 6483 102
1066631 1066631 2021-02-26 Jackson Arkansas 5067 3134 33
1066761 1066761 2021-02-26 Jackson Colorado 8057 51 0
1066840 1066840 2021-02-26 Jackson Florida 12063 5901 150
1066955 1066955 2021-02-26 Jackson Georgia 13157 9046 131
1067126 1067126 2021-02-26 Jackson Illinois 17077 4598 71
1067226 1067226 2021-02-26 Jackson Indiana 18071 4645 66
1067331 1067331 2021-02-26 Jackson Iowa 19097 2075 38
1067425 1067425 2021-02-26 Jackson Kansas 20085 1330 15
1067543 1067543 2021-02-26 Jackson Kentucky 21109 1203 29
1067633 1067633 2021-02-26 Jackson Louisiana 22049 1777 47
1067767 1067767 2021-02-26 Jackson Michigan 26075 14142 250
1067845 1067845 2021-02-26 Jackson Minnesota 27063 930 10
1067931 1067931 2021-02-26 Jackson Mississippi 28059 12483 219
1068031 1068031 2021-02-26 Jackson Missouri 29095 30082 380
1068440 1068440 2021-02-26 Jackson North Carolina 37099 3310 48
1068586 1068586 2021-02-26 Jackson Ohio 39079 2885 56
1068667 1068667 2021-02-26 Jackson Oklahoma 40065 2894 44
1068727 1068727 2021-02-26 Jackson Oregon 41029 8315 111
1068981 1068981 2021-02-26 Jackson South Dakota 46071 279 14
1069056 1069056 2021-02-26 Jackson Tennessee 47087 1251 34
1069228 1069228 2021-02-26 Jackson Texas 48239 1680 29
1069600 1069600 2021-02-26 Jackson West Virginia 54035 1664 50
1069664 1069664 2021-02-26 Jackson Wisconsin 55053 2614 23
1063278 1063278 2021-02-25 Jackson Alabama 1071 6477 102
1063386 1063386 2021-02-25 Jackson Arkansas 5067 3133 33
1063516 1063516 2021-02-25 Jackson Colorado 8057 51 0
1063595 1063595 2021-02-25 Jackson Florida 12063 5891 147

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);