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-12-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
852323 | 852323 | 2020-12-22 | Jackson | Alabama | 1071 | 4737 | 33 |
852431 | 852431 | 2020-12-22 | Jackson | Arkansas | 5067 | 2698 | 17 |
852561 | 852561 | 2020-12-22 | Jackson | Colorado | 8057 | 29 | 0 |
852640 | 852640 | 2020-12-22 | Jackson | Florida | 12063 | 4383 | 110 |
852755 | 852755 | 2020-12-22 | Jackson | Georgia | 13157 | 4958 | 67 |
852926 | 852926 | 2020-12-22 | Jackson | Illinois | 17077 | 3436 | 51 |
853025 | 853025 | 2020-12-22 | Jackson | Indiana | 18071 | 3540 | 42 |
853130 | 853130 | 2020-12-22 | Jackson | Iowa | 19097 | 1725 | 29 |
853224 | 853224 | 2020-12-22 | Jackson | Kansas | 20085 | 979 | 10 |
853342 | 853342 | 2020-12-22 | Jackson | Kentucky | 21109 | 794 | 19 |
853432 | 853432 | 2020-12-22 | Jackson | Louisiana | 22049 | 1317 | 37 |
853567 | 853567 | 2020-12-22 | Jackson | Michigan | 26075 | 9919 | 166 |
853645 | 853645 | 2020-12-22 | Jackson | Minnesota | 27063 | 752 | 5 |
853731 | 853731 | 2020-12-22 | Jackson | Mississippi | 28059 | 8126 | 151 |
853831 | 853831 | 2020-12-22 | Jackson | Missouri | 29095 | 21876 | 217 |
854240 | 854240 | 2020-12-22 | Jackson | North Carolina | 37099 | 2063 | 16 |
854386 | 854386 | 2020-12-22 | Jackson | Ohio | 39079 | 1939 | 28 |
854467 | 854467 | 2020-12-22 | Jackson | Oklahoma | 40065 | 2240 | 36 |
854527 | 854527 | 2020-12-22 | Jackson | Oregon | 41029 | 5411 | 62 |
854781 | 854781 | 2020-12-22 | Jackson | South Dakota | 46071 | 257 | 8 |
854856 | 854856 | 2020-12-22 | Jackson | Tennessee | 47087 | 898 | 18 |
855028 | 855028 | 2020-12-22 | Jackson | Texas | 48239 | 1007 | 19 |
855400 | 855400 | 2020-12-22 | Jackson | West Virginia | 54035 | 1027 | 28 |
855464 | 855464 | 2020-12-22 | Jackson | Wisconsin | 55053 | 2280 | 13 |
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);