ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Lincoln" and fips = 16063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174784 | 2174784 | 2022-02-02 | Lincoln | Idaho | 16063 | 869 | 14 |
2171531 | 2171531 | 2022-02-01 | Lincoln | Idaho | 16063 | 865 | 14 |
2168278 | 2168278 | 2022-01-31 | Lincoln | Idaho | 16063 | 860 | 14 |
2165023 | 2165023 | 2022-01-30 | Lincoln | Idaho | 16063 | 859 | 14 |
2161768 | 2161768 | 2022-01-29 | Lincoln | Idaho | 16063 | 859 | 14 |
2158512 | 2158512 | 2022-01-28 | Lincoln | Idaho | 16063 | 854 | 14 |
2155259 | 2155259 | 2022-01-27 | Lincoln | Idaho | 16063 | 854 | 14 |
2152006 | 2152006 | 2022-01-26 | Lincoln | Idaho | 16063 | 853 | 14 |
2148754 | 2148754 | 2022-01-25 | Lincoln | Idaho | 16063 | 844 | 14 |
2145502 | 2145502 | 2022-01-24 | Lincoln | Idaho | 16063 | 839 | 14 |
2142247 | 2142247 | 2022-01-23 | Lincoln | Idaho | 16063 | 836 | 14 |
2138992 | 2138992 | 2022-01-22 | Lincoln | Idaho | 16063 | 836 | 14 |
2135736 | 2135736 | 2022-01-21 | Lincoln | Idaho | 16063 | 834 | 14 |
2132484 | 2132484 | 2022-01-20 | Lincoln | Idaho | 16063 | 829 | 14 |
2129231 | 2129231 | 2022-01-19 | Lincoln | Idaho | 16063 | 826 | 14 |
2125977 | 2125977 | 2022-01-18 | Lincoln | Idaho | 16063 | 812 | 14 |
2122725 | 2122725 | 2022-01-17 | Lincoln | Idaho | 16063 | 806 | 14 |
2119473 | 2119473 | 2022-01-16 | Lincoln | Idaho | 16063 | 806 | 14 |
2116221 | 2116221 | 2022-01-15 | Lincoln | Idaho | 16063 | 806 | 14 |
2112970 | 2112970 | 2022-01-14 | Lincoln | Idaho | 16063 | 805 | 14 |
2109718 | 2109718 | 2022-01-13 | Lincoln | Idaho | 16063 | 804 | 14 |
2106467 | 2106467 | 2022-01-12 | Lincoln | Idaho | 16063 | 803 | 14 |
2103216 | 2103216 | 2022-01-11 | Lincoln | Idaho | 16063 | 800 | 14 |
2099965 | 2099965 | 2022-01-10 | Lincoln | Idaho | 16063 | 798 | 14 |
2096714 | 2096714 | 2022-01-09 | Lincoln | Idaho | 16063 | 798 | 14 |
2093462 | 2093462 | 2022-01-08 | Lincoln | Idaho | 16063 | 798 | 14 |
2090210 | 2090210 | 2022-01-07 | Lincoln | Idaho | 16063 | 797 | 14 |
2086959 | 2086959 | 2022-01-06 | Lincoln | Idaho | 16063 | 796 | 14 |
2083707 | 2083707 | 2022-01-05 | Lincoln | Idaho | 16063 | 786 | 14 |
2080455 | 2080455 | 2022-01-04 | Lincoln | Idaho | 16063 | 782 | 14 |
2077203 | 2077203 | 2022-01-03 | Lincoln | Idaho | 16063 | 781 | 14 |
2073952 | 2073952 | 2022-01-02 | Lincoln | Idaho | 16063 | 780 | 14 |
2070701 | 2070701 | 2022-01-01 | Lincoln | Idaho | 16063 | 780 | 14 |
2067450 | 2067450 | 2021-12-31 | Lincoln | Idaho | 16063 | 780 | 14 |
2064199 | 2064199 | 2021-12-30 | Lincoln | Idaho | 16063 | 780 | 14 |
2060949 | 2060949 | 2021-12-29 | Lincoln | Idaho | 16063 | 779 | 14 |
2057700 | 2057700 | 2021-12-28 | Lincoln | Idaho | 16063 | 775 | 14 |
2054451 | 2054451 | 2021-12-27 | Lincoln | Idaho | 16063 | 773 | 14 |
2051201 | 2051201 | 2021-12-26 | Lincoln | Idaho | 16063 | 773 | 14 |
2047951 | 2047951 | 2021-12-25 | Lincoln | Idaho | 16063 | 773 | 14 |
2044701 | 2044701 | 2021-12-24 | Lincoln | Idaho | 16063 | 773 | 14 |
2041452 | 2041452 | 2021-12-23 | Lincoln | Idaho | 16063 | 773 | 14 |
2038202 | 2038202 | 2021-12-22 | Lincoln | Idaho | 16063 | 772 | 14 |
2034952 | 2034952 | 2021-12-21 | Lincoln | Idaho | 16063 | 772 | 14 |
2031702 | 2031702 | 2021-12-20 | Lincoln | Idaho | 16063 | 770 | 14 |
2028451 | 2028451 | 2021-12-19 | Lincoln | Idaho | 16063 | 768 | 14 |
2025200 | 2025200 | 2021-12-18 | Lincoln | Idaho | 16063 | 768 | 14 |
2021949 | 2021949 | 2021-12-17 | Lincoln | Idaho | 16063 | 768 | 14 |
2018698 | 2018698 | 2021-12-16 | Lincoln | Idaho | 16063 | 768 | 14 |
2015448 | 2015448 | 2021-12-15 | Lincoln | Idaho | 16063 | 767 | 14 |
2012197 | 2012197 | 2021-12-14 | Lincoln | Idaho | 16063 | 767 | 14 |
2008946 | 2008946 | 2021-12-13 | Lincoln | Idaho | 16063 | 764 | 14 |
2005695 | 2005695 | 2021-12-12 | Lincoln | Idaho | 16063 | 761 | 14 |
2002444 | 2002444 | 2021-12-11 | Lincoln | Idaho | 16063 | 761 | 14 |
1999194 | 1999194 | 2021-12-10 | Lincoln | Idaho | 16063 | 761 | 14 |
1995943 | 1995943 | 2021-12-09 | Lincoln | Idaho | 16063 | 761 | 14 |
1992692 | 1992692 | 2021-12-08 | Lincoln | Idaho | 16063 | 760 | 14 |
1989441 | 1989441 | 2021-12-07 | Lincoln | Idaho | 16063 | 759 | 14 |
1986191 | 1986191 | 2021-12-06 | Lincoln | Idaho | 16063 | 753 | 14 |
1982941 | 1982941 | 2021-12-05 | Lincoln | Idaho | 16063 | 753 | 14 |
1979691 | 1979691 | 2021-12-04 | Lincoln | Idaho | 16063 | 753 | 14 |
1976441 | 1976441 | 2021-12-03 | Lincoln | Idaho | 16063 | 750 | 14 |
1973192 | 1973192 | 2021-12-02 | Lincoln | Idaho | 16063 | 750 | 14 |
1969942 | 1969942 | 2021-12-01 | Lincoln | Idaho | 16063 | 748 | 14 |
1966692 | 1966692 | 2021-11-30 | Lincoln | Idaho | 16063 | 743 | 14 |
1963440 | 1963440 | 2021-11-29 | Lincoln | Idaho | 16063 | 738 | 14 |
1960189 | 1960189 | 2021-11-28 | Lincoln | Idaho | 16063 | 732 | 14 |
1956938 | 1956938 | 2021-11-27 | Lincoln | Idaho | 16063 | 732 | 14 |
1953687 | 1953687 | 2021-11-26 | Lincoln | Idaho | 16063 | 732 | 14 |
1950436 | 1950436 | 2021-11-25 | Lincoln | Idaho | 16063 | 731 | 14 |
1947185 | 1947185 | 2021-11-24 | Lincoln | Idaho | 16063 | 731 | 14 |
1943934 | 1943934 | 2021-11-23 | Lincoln | Idaho | 16063 | 732 | 14 |
1940684 | 1940684 | 2021-11-22 | Lincoln | Idaho | 16063 | 719 | 14 |
1937434 | 1937434 | 2021-11-21 | Lincoln | Idaho | 16063 | 714 | 14 |
1934184 | 1934184 | 2021-11-20 | Lincoln | Idaho | 16063 | 714 | 14 |
1930932 | 1930932 | 2021-11-19 | Lincoln | Idaho | 16063 | 711 | 13 |
1927682 | 1927682 | 2021-11-18 | Lincoln | Idaho | 16063 | 711 | 13 |
1924432 | 1924432 | 2021-11-17 | Lincoln | Idaho | 16063 | 711 | 12 |
1921183 | 1921183 | 2021-11-16 | Lincoln | Idaho | 16063 | 704 | 12 |
1917933 | 1917933 | 2021-11-15 | Lincoln | Idaho | 16063 | 702 | 12 |
1914683 | 1914683 | 2021-11-14 | Lincoln | Idaho | 16063 | 702 | 12 |
1911433 | 1911433 | 2021-11-13 | Lincoln | Idaho | 16063 | 702 | 12 |
1908184 | 1908184 | 2021-11-12 | Lincoln | Idaho | 16063 | 699 | 12 |
1904935 | 1904935 | 2021-11-11 | Lincoln | Idaho | 16063 | 699 | 12 |
1901685 | 1901685 | 2021-11-10 | Lincoln | Idaho | 16063 | 699 | 12 |
1898435 | 1898435 | 2021-11-09 | Lincoln | Idaho | 16063 | 697 | 12 |
1895185 | 1895185 | 2021-11-08 | Lincoln | Idaho | 16063 | 697 | 12 |
1891935 | 1891935 | 2021-11-07 | Lincoln | Idaho | 16063 | 697 | 12 |
1888685 | 1888685 | 2021-11-06 | Lincoln | Idaho | 16063 | 697 | 12 |
1885435 | 1885435 | 2021-11-05 | Lincoln | Idaho | 16063 | 695 | 12 |
1882186 | 1882186 | 2021-11-04 | Lincoln | Idaho | 16063 | 695 | 12 |
1878937 | 1878937 | 2021-11-03 | Lincoln | Idaho | 16063 | 693 | 12 |
1875688 | 1875688 | 2021-11-02 | Lincoln | Idaho | 16063 | 691 | 12 |
1872439 | 1872439 | 2021-11-01 | Lincoln | Idaho | 16063 | 689 | 12 |
1869190 | 1869190 | 2021-10-31 | Lincoln | Idaho | 16063 | 686 | 12 |
1865941 | 1865941 | 2021-10-30 | Lincoln | Idaho | 16063 | 686 | 12 |
1862692 | 1862692 | 2021-10-29 | Lincoln | Idaho | 16063 | 683 | 12 |
1859443 | 1859443 | 2021-10-28 | Lincoln | Idaho | 16063 | 682 | 12 |
1856194 | 1856194 | 2021-10-27 | Lincoln | Idaho | 16063 | 682 | 12 |
1852945 | 1852945 | 2021-10-26 | Lincoln | Idaho | 16063 | 678 | 12 |
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);