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-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
347464 | 347464 | 2020-07-19 | Jackson | Alabama | 1071 | 567 | 4 |
347570 | 347570 | 2020-07-19 | Jackson | Arkansas | 5067 | 46 | 0 |
347699 | 347699 | 2020-07-19 | Jackson | Colorado | 8057 | 8 | 0 |
347777 | 347777 | 2020-07-19 | Jackson | Florida | 12063 | 831 | 10 |
347892 | 347892 | 2020-07-19 | Jackson | Georgia | 13157 | 618 | 12 |
348061 | 348061 | 2020-07-19 | Jackson | Illinois | 17077 | 400 | 19 |
348161 | 348161 | 2020-07-19 | Jackson | Indiana | 18071 | 506 | 4 |
348266 | 348266 | 2020-07-19 | Jackson | Iowa | 19097 | 94 | 0 |
348360 | 348360 | 2020-07-19 | Jackson | Kansas | 20085 | 126 | 1 |
348474 | 348474 | 2020-07-19 | Jackson | Kentucky | 21109 | 118 | 14 |
348564 | 348564 | 2020-07-19 | Jackson | Louisiana | 22049 | 276 | 18 |
348699 | 348699 | 2020-07-19 | Jackson | Michigan | 26075 | 2193 | 54 |
348777 | 348777 | 2020-07-19 | Jackson | Minnesota | 27063 | 61 | 0 |
348862 | 348862 | 2020-07-19 | Jackson | Mississippi | 28059 | 1081 | 21 |
348962 | 348962 | 2020-07-19 | Jackson | Missouri | 29095 | 2209 | 47 |
349347 | 349347 | 2020-07-19 | Jackson | North Carolina | 37099 | 279 | 3 |
349492 | 349492 | 2020-07-19 | Jackson | Ohio | 39079 | 39 | 0 |
349573 | 349573 | 2020-07-19 | Jackson | Oklahoma | 40065 | 211 | 3 |
349632 | 349632 | 2020-07-19 | Jackson | Oregon | 41029 | 238 | 0 |
349884 | 349884 | 2020-07-19 | Jackson | South Dakota | 46071 | 7 | 1 |
349958 | 349958 | 2020-07-19 | Jackson | Tennessee | 47087 | 72 | 0 |
350129 | 350129 | 2020-07-19 | Jackson | Texas | 48239 | 147 | 1 |
350496 | 350496 | 2020-07-19 | Jackson | West Virginia | 54035 | 149 | 19 |
350560 | 350560 | 2020-07-19 | Jackson | Wisconsin | 55053 | 36 | 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);