ny_times_us_counties

⚠️ 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

2,559 rows where county = "Jackson" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Jackson · 2,559
Link rowid date ▲ county state fips cases deaths
334411 2020-07-15 Jackson Alabama 1071 517 4
334518 2020-07-15 Jackson Arkansas 5067 43 0
334646 2020-07-15 Jackson Colorado 8057 8 0
334724 2020-07-15 Jackson Florida 12063 675 5
334839 2020-07-15 Jackson Georgia 13157 559 12
335006 2020-07-15 Jackson Illinois 17077 366 19
335106 2020-07-15 Jackson Indiana 18071 489 4
335211 2020-07-15 Jackson Iowa 19097 74 0
335305 2020-07-15 Jackson Kansas 20085 124 1
335419 2020-07-15 Jackson Kentucky 21109 118 14
335509 2020-07-15 Jackson Louisiana 22049 247 17
335644 2020-07-15 Jackson Michigan 26075 2168 54
335722 2020-07-15 Jackson Minnesota 27063 59 0
335807 2020-07-15 Jackson Mississippi 28059 828 20
335907 2020-07-15 Jackson Missouri 29095 1936 46
336291 2020-07-15 Jackson North Carolina 37099 221 3
336436 2020-07-15 Jackson Ohio 39079 33 0
336517 2020-07-15 Jackson Oklahoma 40065 128 3
336575 2020-07-15 Jackson Oregon 41029 196 0
336827 2020-07-15 Jackson South Dakota 46071 7 1
336901 2020-07-15 Jackson Tennessee 47087 62 0
337072 2020-07-15 Jackson Texas 48239 97 1
337435 2020-07-15 Jackson West Virginia 54035 148 18
337499 2020-07-15 Jackson Wisconsin 55053 37 1
331220 2020-07-14 Jackson Alabama 1071 477 3
331327 2020-07-14 Jackson Arkansas 5067 42 0
331455 2020-07-14 Jackson Colorado 8057 8 0
331533 2020-07-14 Jackson Florida 12063 652 2
331648 2020-07-14 Jackson Georgia 13157 548 12
331815 2020-07-14 Jackson Illinois 17077 359 19
331915 2020-07-14 Jackson Indiana 18071 485 4
332020 2020-07-14 Jackson Iowa 19097 72 0
332114 2020-07-14 Jackson Kansas 20085 124 1
332228 2020-07-14 Jackson Kentucky 21109 117 14
332318 2020-07-14 Jackson Louisiana 22049 243 17
332453 2020-07-14 Jackson Michigan 26075 2166 54
332531 2020-07-14 Jackson Minnesota 27063 58 0
332616 2020-07-14 Jackson Mississippi 28059 809 19
332716 2020-07-14 Jackson Missouri 29095 1806 46
333099 2020-07-14 Jackson North Carolina 37099 220 1
333244 2020-07-14 Jackson Ohio 39079 32 0
333325 2020-07-14 Jackson Oklahoma 40065 72 3
333383 2020-07-14 Jackson Oregon 41029 187 0
333635 2020-07-14 Jackson South Dakota 46071 7 1
333709 2020-07-14 Jackson Tennessee 47087 52 0
333879 2020-07-14 Jackson Texas 48239 90 1
334242 2020-07-14 Jackson West Virginia 54035 148 18
334306 2020-07-14 Jackson Wisconsin 55053 36 1
328036 2020-07-13 Jackson Alabama 1071 447 3
328143 2020-07-13 Jackson Arkansas 5067 41 0
328271 2020-07-13 Jackson Colorado 8057 8 0
328348 2020-07-13 Jackson Florida 12063 632 2
328463 2020-07-13 Jackson Georgia 13157 531 12
328630 2020-07-13 Jackson Illinois 17077 357 19
328730 2020-07-13 Jackson Indiana 18071 483 4
328835 2020-07-13 Jackson Iowa 19097 67 0
328929 2020-07-13 Jackson Kansas 20085 123 1
329043 2020-07-13 Jackson Kentucky 21109 117 14
329133 2020-07-13 Jackson Louisiana 22049 236 17
329268 2020-07-13 Jackson Michigan 26075 2163 54
329346 2020-07-13 Jackson Minnesota 27063 58 0
329431 2020-07-13 Jackson Mississippi 28059 804 19
329531 2020-07-13 Jackson Missouri 29095 1781 44
329911 2020-07-13 Jackson North Carolina 37099 206 1
330054 2020-07-13 Jackson Ohio 39079 31 0
330135 2020-07-13 Jackson Oklahoma 40065 57 3
330193 2020-07-13 Jackson Oregon 41029 181 0
330445 2020-07-13 Jackson South Dakota 46071 7 1
330519 2020-07-13 Jackson Tennessee 47087 50 0
330690 2020-07-13 Jackson Texas 48239 89 1
331051 2020-07-13 Jackson West Virginia 54035 148 18
331115 2020-07-13 Jackson Wisconsin 55053 36 1
324852 2020-07-12 Jackson Alabama 1071 440 3
324959 2020-07-12 Jackson Arkansas 5067 41 0
325087 2020-07-12 Jackson Colorado 8057 7 0
325164 2020-07-12 Jackson Florida 12063 587 2
325279 2020-07-12 Jackson Georgia 13157 516 12
325446 2020-07-12 Jackson Illinois 17077 356 19
325546 2020-07-12 Jackson Indiana 18071 482 4
325651 2020-07-12 Jackson Iowa 19097 61 0
325745 2020-07-12 Jackson Kansas 20085 117 1
325859 2020-07-12 Jackson Kentucky 21109 117 14
325949 2020-07-12 Jackson Louisiana 22049 235 17
326084 2020-07-12 Jackson Michigan 26075 2159 54
326162 2020-07-12 Jackson Minnesota 27063 57 0
326247 2020-07-12 Jackson Mississippi 28059 798 19
326347 2020-07-12 Jackson Missouri 29095 1743 44
326726 2020-07-12 Jackson North Carolina 37099 198 1
326869 2020-07-12 Jackson Ohio 39079 30 0
326950 2020-07-12 Jackson Oklahoma 40065 57 3
327009 2020-07-12 Jackson Oregon 41029 179 0
327261 2020-07-12 Jackson South Dakota 46071 7 1
327335 2020-07-12 Jackson Tennessee 47087 47 0
327506 2020-07-12 Jackson Texas 48239 89 1
327867 2020-07-12 Jackson West Virginia 54035 148 18
327931 2020-07-12 Jackson Wisconsin 55053 35 1
321673 2020-07-11 Jackson Alabama 1071 422 3
321780 2020-07-11 Jackson Arkansas 5067 41 0
321908 2020-07-11 Jackson Colorado 8057 7 0
321985 2020-07-11 Jackson Florida 12063 581 2

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
);
Powered by Datasette · Query took 1108.416ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette