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 2020-07-09 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315576 | 315576 | 2020-07-09 | Jackson | Alabama | 1071 | 378 | 3 |
315682 | 315682 | 2020-07-09 | Jackson | Arkansas | 5067 | 39 | 0 |
315810 | 315810 | 2020-07-09 | Jackson | Colorado | 8057 | 2 | 0 |
315887 | 315887 | 2020-07-09 | Jackson | Florida | 12063 | 517 | 2 |
316002 | 316002 | 2020-07-09 | Jackson | Georgia | 13157 | 483 | 10 |
316169 | 316169 | 2020-07-09 | Jackson | Illinois | 17077 | 345 | 19 |
316269 | 316269 | 2020-07-09 | Jackson | Indiana | 18071 | 481 | 4 |
316374 | 316374 | 2020-07-09 | Jackson | Iowa | 19097 | 48 | 0 |
316466 | 316466 | 2020-07-09 | Jackson | Kansas | 20085 | 117 | 1 |
316578 | 316578 | 2020-07-09 | Jackson | Kentucky | 21109 | 115 | 14 |
316668 | 316668 | 2020-07-09 | Jackson | Louisiana | 22049 | 221 | 16 |
316803 | 316803 | 2020-07-09 | Jackson | Michigan | 26075 | 2143 | 54 |
316881 | 316881 | 2020-07-09 | Jackson | Minnesota | 27063 | 57 | 0 |
316966 | 316966 | 2020-07-09 | Jackson | Mississippi | 28059 | 727 | 17 |
317066 | 317066 | 2020-07-09 | Jackson | Missouri | 29095 | 1527 | 42 |
317441 | 317441 | 2020-07-09 | Jackson | North Carolina | 37099 | 157 | 1 |
317583 | 317583 | 2020-07-09 | Jackson | Ohio | 39079 | 27 | 0 |
317664 | 317664 | 2020-07-09 | Jackson | Oklahoma | 40065 | 54 | 3 |
317722 | 317722 | 2020-07-09 | Jackson | Oregon | 41029 | 164 | 0 |
317974 | 317974 | 2020-07-09 | Jackson | South Dakota | 46071 | 6 | 1 |
318047 | 318047 | 2020-07-09 | Jackson | Tennessee | 47087 | 41 | 0 |
318217 | 318217 | 2020-07-09 | Jackson | Texas | 48239 | 73 | 1 |
318580 | 318580 | 2020-07-09 | Jackson | West Virginia | 54035 | 149 | 18 |
318644 | 318644 | 2020-07-09 | Jackson | Wisconsin | 55053 | 32 | 1 |
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);