ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jefferson" and fips = 16051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174778 | 2174778 | 2022-02-02 | Jefferson | Idaho | 16051 | 5803 | 56 |
2171525 | 2171525 | 2022-02-01 | Jefferson | Idaho | 16051 | 5778 | 56 |
2168272 | 2168272 | 2022-01-31 | Jefferson | Idaho | 16051 | 5750 | 56 |
2165017 | 2165017 | 2022-01-30 | Jefferson | Idaho | 16051 | 5721 | 56 |
2161762 | 2161762 | 2022-01-29 | Jefferson | Idaho | 16051 | 5721 | 56 |
2158506 | 2158506 | 2022-01-28 | Jefferson | Idaho | 16051 | 5662 | 56 |
2155253 | 2155253 | 2022-01-27 | Jefferson | Idaho | 16051 | 5662 | 56 |
2152000 | 2152000 | 2022-01-26 | Jefferson | Idaho | 16051 | 5579 | 56 |
2148748 | 2148748 | 2022-01-25 | Jefferson | Idaho | 16051 | 5505 | 56 |
2145496 | 2145496 | 2022-01-24 | Jefferson | Idaho | 16051 | 5437 | 56 |
2142241 | 2142241 | 2022-01-23 | Jefferson | Idaho | 16051 | 5371 | 55 |
2138986 | 2138986 | 2022-01-22 | Jefferson | Idaho | 16051 | 5371 | 55 |
2135730 | 2135730 | 2022-01-21 | Jefferson | Idaho | 16051 | 5359 | 55 |
2132478 | 2132478 | 2022-01-20 | Jefferson | Idaho | 16051 | 5280 | 55 |
2129225 | 2129225 | 2022-01-19 | Jefferson | Idaho | 16051 | 5187 | 55 |
2125971 | 2125971 | 2022-01-18 | Jefferson | Idaho | 16051 | 5131 | 55 |
2122719 | 2122719 | 2022-01-17 | Jefferson | Idaho | 16051 | 5103 | 55 |
2119467 | 2119467 | 2022-01-16 | Jefferson | Idaho | 16051 | 5103 | 55 |
2116215 | 2116215 | 2022-01-15 | Jefferson | Idaho | 16051 | 5103 | 55 |
2112964 | 2112964 | 2022-01-14 | Jefferson | Idaho | 16051 | 5091 | 55 |
2109712 | 2109712 | 2022-01-13 | Jefferson | Idaho | 16051 | 4994 | 55 |
2106461 | 2106461 | 2022-01-12 | Jefferson | Idaho | 16051 | 4918 | 55 |
2103210 | 2103210 | 2022-01-11 | Jefferson | Idaho | 16051 | 4842 | 55 |
2099959 | 2099959 | 2022-01-10 | Jefferson | Idaho | 16051 | 4761 | 55 |
2096708 | 2096708 | 2022-01-09 | Jefferson | Idaho | 16051 | 4743 | 55 |
2093456 | 2093456 | 2022-01-08 | Jefferson | Idaho | 16051 | 4743 | 55 |
2090204 | 2090204 | 2022-01-07 | Jefferson | Idaho | 16051 | 4739 | 55 |
2086953 | 2086953 | 2022-01-06 | Jefferson | Idaho | 16051 | 4717 | 54 |
2083701 | 2083701 | 2022-01-05 | Jefferson | Idaho | 16051 | 4683 | 53 |
2080449 | 2080449 | 2022-01-04 | Jefferson | Idaho | 16051 | 4657 | 53 |
2077197 | 2077197 | 2022-01-03 | Jefferson | Idaho | 16051 | 4621 | 53 |
2073946 | 2073946 | 2022-01-02 | Jefferson | Idaho | 16051 | 4610 | 53 |
2070695 | 2070695 | 2022-01-01 | Jefferson | Idaho | 16051 | 4610 | 53 |
2067444 | 2067444 | 2021-12-31 | Jefferson | Idaho | 16051 | 4610 | 53 |
2064193 | 2064193 | 2021-12-30 | Jefferson | Idaho | 16051 | 4610 | 53 |
2060943 | 2060943 | 2021-12-29 | Jefferson | Idaho | 16051 | 4609 | 53 |
2057694 | 2057694 | 2021-12-28 | Jefferson | Idaho | 16051 | 4601 | 53 |
2054445 | 2054445 | 2021-12-27 | Jefferson | Idaho | 16051 | 4587 | 53 |
2051195 | 2051195 | 2021-12-26 | Jefferson | Idaho | 16051 | 4584 | 53 |
2047945 | 2047945 | 2021-12-25 | Jefferson | Idaho | 16051 | 4584 | 53 |
2044695 | 2044695 | 2021-12-24 | Jefferson | Idaho | 16051 | 4584 | 53 |
2041446 | 2041446 | 2021-12-23 | Jefferson | Idaho | 16051 | 4584 | 53 |
2038196 | 2038196 | 2021-12-22 | Jefferson | Idaho | 16051 | 4575 | 53 |
2034946 | 2034946 | 2021-12-21 | Jefferson | Idaho | 16051 | 4572 | 53 |
2031696 | 2031696 | 2021-12-20 | Jefferson | Idaho | 16051 | 4568 | 53 |
2028445 | 2028445 | 2021-12-19 | Jefferson | Idaho | 16051 | 4563 | 53 |
2025194 | 2025194 | 2021-12-18 | Jefferson | Idaho | 16051 | 4563 | 53 |
2021943 | 2021943 | 2021-12-17 | Jefferson | Idaho | 16051 | 4562 | 53 |
2018692 | 2018692 | 2021-12-16 | Jefferson | Idaho | 16051 | 4559 | 52 |
2015442 | 2015442 | 2021-12-15 | Jefferson | Idaho | 16051 | 4556 | 52 |
2012191 | 2012191 | 2021-12-14 | Jefferson | Idaho | 16051 | 4547 | 52 |
2008940 | 2008940 | 2021-12-13 | Jefferson | Idaho | 16051 | 4540 | 51 |
2005689 | 2005689 | 2021-12-12 | Jefferson | Idaho | 16051 | 4531 | 51 |
2002438 | 2002438 | 2021-12-11 | Jefferson | Idaho | 16051 | 4531 | 51 |
1999188 | 1999188 | 2021-12-10 | Jefferson | Idaho | 16051 | 4531 | 51 |
1995937 | 1995937 | 2021-12-09 | Jefferson | Idaho | 16051 | 4523 | 51 |
1992686 | 1992686 | 2021-12-08 | Jefferson | Idaho | 16051 | 4517 | 51 |
1989435 | 1989435 | 2021-12-07 | Jefferson | Idaho | 16051 | 4509 | 51 |
1986185 | 1986185 | 2021-12-06 | Jefferson | Idaho | 16051 | 4475 | 51 |
1982935 | 1982935 | 2021-12-05 | Jefferson | Idaho | 16051 | 4460 | 51 |
1979685 | 1979685 | 2021-12-04 | Jefferson | Idaho | 16051 | 4460 | 51 |
1976435 | 1976435 | 2021-12-03 | Jefferson | Idaho | 16051 | 4449 | 51 |
1973186 | 1973186 | 2021-12-02 | Jefferson | Idaho | 16051 | 4449 | 51 |
1969936 | 1969936 | 2021-12-01 | Jefferson | Idaho | 16051 | 4443 | 51 |
1966686 | 1966686 | 2021-11-30 | Jefferson | Idaho | 16051 | 4434 | 51 |
1963434 | 1963434 | 2021-11-29 | Jefferson | Idaho | 16051 | 4416 | 51 |
1960183 | 1960183 | 2021-11-28 | Jefferson | Idaho | 16051 | 4395 | 51 |
1956932 | 1956932 | 2021-11-27 | Jefferson | Idaho | 16051 | 4395 | 51 |
1953681 | 1953681 | 2021-11-26 | Jefferson | Idaho | 16051 | 4397 | 51 |
1950430 | 1950430 | 2021-11-25 | Jefferson | Idaho | 16051 | 4384 | 51 |
1947179 | 1947179 | 2021-11-24 | Jefferson | Idaho | 16051 | 4384 | 51 |
1943928 | 1943928 | 2021-11-23 | Jefferson | Idaho | 16051 | 4381 | 49 |
1940678 | 1940678 | 2021-11-22 | Jefferson | Idaho | 16051 | 4375 | 49 |
1937428 | 1937428 | 2021-11-21 | Jefferson | Idaho | 16051 | 4363 | 49 |
1934178 | 1934178 | 2021-11-20 | Jefferson | Idaho | 16051 | 4363 | 49 |
1930926 | 1930926 | 2021-11-19 | Jefferson | Idaho | 16051 | 4339 | 49 |
1927676 | 1927676 | 2021-11-18 | Jefferson | Idaho | 16051 | 4339 | 49 |
1924426 | 1924426 | 2021-11-17 | Jefferson | Idaho | 16051 | 4322 | 49 |
1921177 | 1921177 | 2021-11-16 | Jefferson | Idaho | 16051 | 4312 | 48 |
1917927 | 1917927 | 2021-11-15 | Jefferson | Idaho | 16051 | 4291 | 47 |
1914677 | 1914677 | 2021-11-14 | Jefferson | Idaho | 16051 | 4279 | 47 |
1911427 | 1911427 | 2021-11-13 | Jefferson | Idaho | 16051 | 4278 | 47 |
1908178 | 1908178 | 2021-11-12 | Jefferson | Idaho | 16051 | 4258 | 46 |
1904929 | 1904929 | 2021-11-11 | Jefferson | Idaho | 16051 | 4258 | 46 |
1901679 | 1901679 | 2021-11-10 | Jefferson | Idaho | 16051 | 4258 | 46 |
1898429 | 1898429 | 2021-11-09 | Jefferson | Idaho | 16051 | 4247 | 46 |
1895179 | 1895179 | 2021-11-08 | Jefferson | Idaho | 16051 | 4234 | 46 |
1891929 | 1891929 | 2021-11-07 | Jefferson | Idaho | 16051 | 4207 | 45 |
1888679 | 1888679 | 2021-11-06 | Jefferson | Idaho | 16051 | 4207 | 45 |
1885429 | 1885429 | 2021-11-05 | Jefferson | Idaho | 16051 | 4201 | 45 |
1882180 | 1882180 | 2021-11-04 | Jefferson | Idaho | 16051 | 4194 | 45 |
1878931 | 1878931 | 2021-11-03 | Jefferson | Idaho | 16051 | 4185 | 45 |
1875682 | 1875682 | 2021-11-02 | Jefferson | Idaho | 16051 | 4172 | 44 |
1872433 | 1872433 | 2021-11-01 | Jefferson | Idaho | 16051 | 4158 | 44 |
1869184 | 1869184 | 2021-10-31 | Jefferson | Idaho | 16051 | 4135 | 44 |
1865935 | 1865935 | 2021-10-30 | Jefferson | Idaho | 16051 | 4135 | 44 |
1862686 | 1862686 | 2021-10-29 | Jefferson | Idaho | 16051 | 4134 | 44 |
1859437 | 1859437 | 2021-10-28 | Jefferson | Idaho | 16051 | 4121 | 44 |
1856188 | 1856188 | 2021-10-27 | Jefferson | Idaho | 16051 | 4099 | 43 |
1852939 | 1852939 | 2021-10-26 | Jefferson | Idaho | 16051 | 4075 | 43 |
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);