ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where county = "Jackson" and "date" is on date 2021-12-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2031148 | 2031148 | 2021-12-20 | Jackson | Alabama | 1071 | 10368 | 200 |
2031257 | 2031257 | 2021-12-20 | Jackson | Arkansas | 5067 | 4679 | 47 |
2031387 | 2031387 | 2021-12-20 | Jackson | Colorado | 8057 | 125 | 0 |
2031466 | 2031466 | 2021-12-20 | Jackson | Florida | 12063 | 10219 | 241 |
2031581 | 2031581 | 2021-12-20 | Jackson | Georgia | 13157 | 15352 | 229 |
2031753 | 2031753 | 2021-12-20 | Jackson | Illinois | 17077 | 8880 | 111 |
2031853 | 2031853 | 2021-12-20 | Jackson | Indiana | 18071 | 8355 | 101 |
2031958 | 2031958 | 2021-12-20 | Jackson | Iowa | 19097 | 3554 | 49 |
2032052 | 2032052 | 2021-12-20 | Jackson | Kansas | 20085 | 2575 | 20 |
2032169 | 2032169 | 2021-12-20 | Jackson | Kentucky | 21109 | 3003 | 58 |
2032259 | 2032259 | 2021-12-20 | Jackson | Louisiana | 22049 | 2834 | 64 |
2032394 | 2032394 | 2021-12-20 | Jackson | Michigan | 26075 | 33262 | 444 |
2032472 | 2032472 | 2021-12-20 | Jackson | Minnesota | 27063 | 1693 | 16 |
2032558 | 2032558 | 2021-12-20 | Jackson | Mississippi | 28059 | 25084 | 393 |
2032658 | 2032658 | 2021-12-20 | Jackson | Missouri | 29095 | 64133 | 857 |
2033068 | 2033068 | 2021-12-20 | Jackson | North Carolina | 37099 | 6143 | 74 |
2033215 | 2033215 | 2021-12-20 | Jackson | Ohio | 39079 | 6134 | 106 |
2033297 | 2033297 | 2021-12-20 | Jackson | Oklahoma | 40065 | 4331 | 89 |
2033357 | 2033357 | 2021-12-20 | Jackson | Oregon | 41029 | 25828 | 378 |
2033611 | 2033611 | 2021-12-20 | Jackson | South Dakota | 46071 | 431 | 19 |
2033686 | 2033686 | 2021-12-20 | Jackson | Tennessee | 47087 | 2168 | 43 |
2033858 | 2033858 | 2021-12-20 | Jackson | Texas | 48239 | 2800 | 52 |
2034230 | 2034230 | 2021-12-20 | Jackson | West Virginia | 54035 | 4471 | 106 |
2034294 | 2034294 | 2021-12-20 | Jackson | Wisconsin | 55053 | 4144 | 37 |
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);