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

18,567 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)

state 24

fips 24

county 1

  • Jackson · 18,567 ✖
Link rowid date ▲ county state fips cases deaths
2499610 2499610 2022-05-13 Jackson Alabama 1071 15049 241
2499719 2499719 2022-05-13 Jackson Arkansas 5067 6135 63
2499849 2499849 2022-05-13 Jackson Colorado 8057 166 0
2499928 2499928 2022-05-13 Jackson Florida 12063 14854 280
2500043 2500043 2022-05-13 Jackson Georgia 13157 21247 291
2500215 2500215 2022-05-13 Jackson Illinois 17077 15840 130
2500315 2500315 2022-05-13 Jackson Indiana 18071 12568 130
2500421 2500421 2022-05-13 Jackson Iowa 19097 4644 69
2500515 2500515 2022-05-13 Jackson Kansas 20085 3908 29
2500633 2500633 2022-05-13 Jackson Kentucky 21109 4286 80
2500723 2500723 2022-05-13 Jackson Louisiana 22049 4409 76
2500858 2500858 2022-05-13 Jackson Michigan 26075 45532 590
2500936 2500936 2022-05-13 Jackson Minnesota 27063 2167 17
2501022 2501022 2022-05-13 Jackson Mississippi 28059 37055 463
2501123 2501123 2022-05-13 Jackson Missouri 29095 97164 1217
2501535 2501535 2022-05-13 Jackson North Carolina 37099 9794 96
2501683 2501683 2022-05-13 Jackson Ohio 39079 8988 141
2501765 2501765 2022-05-13 Jackson Oklahoma 40065 6575 108
2501825 2501825 2022-05-13 Jackson Oregon 41029 43552 535
2502079 2502079 2022-05-13 Jackson South Dakota 46071 632 21
2502154 2502154 2022-05-13 Jackson Tennessee 47087 3211 63
2502326 2502326 2022-05-13 Jackson Texas 48239 3258 59
2502700 2502700 2022-05-13 Jackson West Virginia 54035 6926 132
2502764 2502764 2022-05-13 Jackson Wisconsin 55053 5736 43
2496352 2496352 2022-05-12 Jackson Alabama 1071 15049 241
2496461 2496461 2022-05-12 Jackson Arkansas 5067 6134 63
2496591 2496591 2022-05-12 Jackson Colorado 8057 166 0
2496670 2496670 2022-05-12 Jackson Florida 12063 14854 280
2496785 2496785 2022-05-12 Jackson Georgia 13157 21247 291
2496957 2496957 2022-05-12 Jackson Illinois 17077 15801 130
2497057 2497057 2022-05-12 Jackson Indiana 18071 12561 130
2497163 2497163 2022-05-12 Jackson Iowa 19097 4644 69
2497257 2497257 2022-05-12 Jackson Kansas 20085 3903 29
2497375 2497375 2022-05-12 Jackson Kentucky 21109 4286 80
2497465 2497465 2022-05-12 Jackson Louisiana 22049 4409 76
2497600 2497600 2022-05-12 Jackson Michigan 26075 45532 590
2497678 2497678 2022-05-12 Jackson Minnesota 27063 2166 17
2497764 2497764 2022-05-12 Jackson Mississippi 28059 37055 463
2497865 2497865 2022-05-12 Jackson Missouri 29095 96783 1215
2498277 2498277 2022-05-12 Jackson North Carolina 37099 9794 96
2498425 2498425 2022-05-12 Jackson Ohio 39079 8988 141
2498507 2498507 2022-05-12 Jackson Oklahoma 40065 6575 108
2498567 2498567 2022-05-12 Jackson Oregon 41029 43516 534
2498821 2498821 2022-05-12 Jackson South Dakota 46071 632 21
2498896 2498896 2022-05-12 Jackson Tennessee 47087 3211 63
2499068 2499068 2022-05-12 Jackson Texas 48239 3258 59
2499442 2499442 2022-05-12 Jackson West Virginia 54035 6920 132
2499506 2499506 2022-05-12 Jackson Wisconsin 55053 5731 43
2493094 2493094 2022-05-11 Jackson Alabama 1071 15048 241
2493203 2493203 2022-05-11 Jackson Arkansas 5067 6134 63
2493333 2493333 2022-05-11 Jackson Colorado 8057 165 0
2493412 2493412 2022-05-11 Jackson Florida 12063 14854 280
2493527 2493527 2022-05-11 Jackson Georgia 13157 21247 291
2493699 2493699 2022-05-11 Jackson Illinois 17077 15784 130
2493799 2493799 2022-05-11 Jackson Indiana 18071 12561 130
2493905 2493905 2022-05-11 Jackson Iowa 19097 4644 69
2493999 2493999 2022-05-11 Jackson Kansas 20085 3903 29
2494117 2494117 2022-05-11 Jackson Kentucky 21109 4286 80
2494207 2494207 2022-05-11 Jackson Louisiana 22049 4409 76
2494342 2494342 2022-05-11 Jackson Michigan 26075 45532 590
2494420 2494420 2022-05-11 Jackson Minnesota 27063 2166 17
2494506 2494506 2022-05-11 Jackson Mississippi 28059 37055 463
2494607 2494607 2022-05-11 Jackson Missouri 29095 96783 1215
2495019 2495019 2022-05-11 Jackson North Carolina 37099 9794 96
2495167 2495167 2022-05-11 Jackson Ohio 39079 8965 141
2495249 2495249 2022-05-11 Jackson Oklahoma 40065 6565 107
2495309 2495309 2022-05-11 Jackson Oregon 41029 43463 533
2495563 2495563 2022-05-11 Jackson South Dakota 46071 632 21
2495638 2495638 2022-05-11 Jackson Tennessee 47087 3211 63
2495810 2495810 2022-05-11 Jackson Texas 48239 3258 59
2496184 2496184 2022-05-11 Jackson West Virginia 54035 6918 132
2496248 2496248 2022-05-11 Jackson Wisconsin 55053 5726 43
2489836 2489836 2022-05-10 Jackson Alabama 1071 15043 241
2489945 2489945 2022-05-10 Jackson Arkansas 5067 6134 63
2490075 2490075 2022-05-10 Jackson Colorado 8057 165 0
2490154 2490154 2022-05-10 Jackson Florida 12063 14854 280
2490269 2490269 2022-05-10 Jackson Georgia 13157 21224 291
2490441 2490441 2022-05-10 Jackson Illinois 17077 15772 130
2490541 2490541 2022-05-10 Jackson Indiana 18071 12560 130
2490647 2490647 2022-05-10 Jackson Iowa 19097 4622 69
2490741 2490741 2022-05-10 Jackson Kansas 20085 3903 29
2490859 2490859 2022-05-10 Jackson Kentucky 21109 4286 80
2490949 2490949 2022-05-10 Jackson Louisiana 22049 4409 76
2491084 2491084 2022-05-10 Jackson Michigan 26075 45207 588
2491162 2491162 2022-05-10 Jackson Minnesota 27063 2165 17
2491248 2491248 2022-05-10 Jackson Mississippi 28059 37055 463
2491349 2491349 2022-05-10 Jackson Missouri 29095 96783 1215
2491761 2491761 2022-05-10 Jackson North Carolina 37099 9679 96
2491909 2491909 2022-05-10 Jackson Ohio 39079 8965 141
2491991 2491991 2022-05-10 Jackson Oklahoma 40065 6565 107
2492051 2492051 2022-05-10 Jackson Oregon 41029 43410 533
2492305 2492305 2022-05-10 Jackson South Dakota 46071 631 21
2492380 2492380 2022-05-10 Jackson Tennessee 47087 3208 63
2492552 2492552 2022-05-10 Jackson Texas 48239 3258 59
2492926 2492926 2022-05-10 Jackson West Virginia 54035 6910 132
2492990 2492990 2022-05-10 Jackson Wisconsin 55053 5719 43
2486579 2486579 2022-05-09 Jackson Alabama 1071 15042 241
2486688 2486688 2022-05-09 Jackson Arkansas 5067 6133 63
2486818 2486818 2022-05-09 Jackson Colorado 8057 165 0
2486897 2486897 2022-05-09 Jackson Florida 12063 14854 280

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