ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 16001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174753 | 2174753 | 2022-02-02 | Ada | Idaho | 16001 | 107232 | 931 |
2171500 | 2171500 | 2022-02-01 | Ada | Idaho | 16001 | 106364 | 927 |
2168247 | 2168247 | 2022-01-31 | Ada | Idaho | 16001 | 105862 | 925 |
2164992 | 2164992 | 2022-01-30 | Ada | Idaho | 16001 | 105142 | 921 |
2161737 | 2161737 | 2022-01-29 | Ada | Idaho | 16001 | 105142 | 921 |
2158481 | 2158481 | 2022-01-28 | Ada | Idaho | 16001 | 103141 | 915 |
2155228 | 2155228 | 2022-01-27 | Ada | Idaho | 16001 | 103141 | 915 |
2151975 | 2151975 | 2022-01-26 | Ada | Idaho | 16001 | 101878 | 914 |
2148723 | 2148723 | 2022-01-25 | Ada | Idaho | 16001 | 100744 | 912 |
2145471 | 2145471 | 2022-01-24 | Ada | Idaho | 16001 | 100028 | 908 |
2142216 | 2142216 | 2022-01-23 | Ada | Idaho | 16001 | 99096 | 904 |
2138961 | 2138961 | 2022-01-22 | Ada | Idaho | 16001 | 99096 | 904 |
2135705 | 2135705 | 2022-01-21 | Ada | Idaho | 16001 | 98162 | 905 |
2132453 | 2132453 | 2022-01-20 | Ada | Idaho | 16001 | 97338 | 903 |
2129200 | 2129200 | 2022-01-19 | Ada | Idaho | 16001 | 96619 | 895 |
2125946 | 2125946 | 2022-01-18 | Ada | Idaho | 16001 | 95547 | 891 |
2122694 | 2122694 | 2022-01-17 | Ada | Idaho | 16001 | 94384 | 889 |
2119442 | 2119442 | 2022-01-16 | Ada | Idaho | 16001 | 94384 | 889 |
2116190 | 2116190 | 2022-01-15 | Ada | Idaho | 16001 | 94384 | 889 |
2112939 | 2112939 | 2022-01-14 | Ada | Idaho | 16001 | 93969 | 888 |
2109687 | 2109687 | 2022-01-13 | Ada | Idaho | 16001 | 93200 | 886 |
2106436 | 2106436 | 2022-01-12 | Ada | Idaho | 16001 | 92688 | 886 |
2103185 | 2103185 | 2022-01-11 | Ada | Idaho | 16001 | 92107 | 882 |
2099934 | 2099934 | 2022-01-10 | Ada | Idaho | 16001 | 91690 | 879 |
2096683 | 2096683 | 2022-01-09 | Ada | Idaho | 16001 | 91349 | 879 |
2093431 | 2093431 | 2022-01-08 | Ada | Idaho | 16001 | 91349 | 879 |
2090179 | 2090179 | 2022-01-07 | Ada | Idaho | 16001 | 91221 | 877 |
2086928 | 2086928 | 2022-01-06 | Ada | Idaho | 16001 | 91092 | 872 |
2083676 | 2083676 | 2022-01-05 | Ada | Idaho | 16001 | 90630 | 870 |
2080424 | 2080424 | 2022-01-04 | Ada | Idaho | 16001 | 90151 | 868 |
2077172 | 2077172 | 2022-01-03 | Ada | Idaho | 16001 | 89728 | 865 |
2073921 | 2073921 | 2022-01-02 | Ada | Idaho | 16001 | 89225 | 865 |
2070670 | 2070670 | 2022-01-01 | Ada | Idaho | 16001 | 89225 | 865 |
2067419 | 2067419 | 2021-12-31 | Ada | Idaho | 16001 | 89225 | 865 |
2064168 | 2064168 | 2021-12-30 | Ada | Idaho | 16001 | 89225 | 865 |
2060918 | 2060918 | 2021-12-29 | Ada | Idaho | 16001 | 88905 | 865 |
2057669 | 2057669 | 2021-12-28 | Ada | Idaho | 16001 | 88698 | 863 |
2054420 | 2054420 | 2021-12-27 | Ada | Idaho | 16001 | 88304 | 861 |
2051170 | 2051170 | 2021-12-26 | Ada | Idaho | 16001 | 87867 | 859 |
2047920 | 2047920 | 2021-12-25 | Ada | Idaho | 16001 | 87867 | 859 |
2044670 | 2044670 | 2021-12-24 | Ada | Idaho | 16001 | 87867 | 859 |
2041421 | 2041421 | 2021-12-23 | Ada | Idaho | 16001 | 87867 | 859 |
2038171 | 2038171 | 2021-12-22 | Ada | Idaho | 16001 | 87750 | 859 |
2034921 | 2034921 | 2021-12-21 | Ada | Idaho | 16001 | 87672 | 855 |
2031671 | 2031671 | 2021-12-20 | Ada | Idaho | 16001 | 87535 | 854 |
2028420 | 2028420 | 2021-12-19 | Ada | Idaho | 16001 | 87381 | 854 |
2025169 | 2025169 | 2021-12-18 | Ada | Idaho | 16001 | 87381 | 854 |
2021918 | 2021918 | 2021-12-17 | Ada | Idaho | 16001 | 87341 | 854 |
2018667 | 2018667 | 2021-12-16 | Ada | Idaho | 16001 | 87200 | 851 |
2015417 | 2015417 | 2021-12-15 | Ada | Idaho | 16001 | 87113 | 850 |
2012166 | 2012166 | 2021-12-14 | Ada | Idaho | 16001 | 86997 | 849 |
2008915 | 2008915 | 2021-12-13 | Ada | Idaho | 16001 | 86911 | 847 |
2005664 | 2005664 | 2021-12-12 | Ada | Idaho | 16001 | 86714 | 847 |
2002413 | 2002413 | 2021-12-11 | Ada | Idaho | 16001 | 86714 | 847 |
1999163 | 1999163 | 2021-12-10 | Ada | Idaho | 16001 | 86663 | 847 |
1995912 | 1995912 | 2021-12-09 | Ada | Idaho | 16001 | 86582 | 845 |
1992661 | 1992661 | 2021-12-08 | Ada | Idaho | 16001 | 86443 | 844 |
1989410 | 1989410 | 2021-12-07 | Ada | Idaho | 16001 | 86226 | 844 |
1986160 | 1986160 | 2021-12-06 | Ada | Idaho | 16001 | 86072 | 840 |
1982910 | 1982910 | 2021-12-05 | Ada | Idaho | 16001 | 85933 | 840 |
1979660 | 1979660 | 2021-12-04 | Ada | Idaho | 16001 | 85933 | 840 |
1976410 | 1976410 | 2021-12-03 | Ada | Idaho | 16001 | 85741 | 838 |
1973161 | 1973161 | 2021-12-02 | Ada | Idaho | 16001 | 85741 | 838 |
1969911 | 1969911 | 2021-12-01 | Ada | Idaho | 16001 | 85590 | 838 |
1966661 | 1966661 | 2021-11-30 | Ada | Idaho | 16001 | 85403 | 835 |
1963409 | 1963409 | 2021-11-29 | Ada | Idaho | 16001 | 85261 | 833 |
1960158 | 1960158 | 2021-11-28 | Ada | Idaho | 16001 | 85156 | 833 |
1956907 | 1956907 | 2021-11-27 | Ada | Idaho | 16001 | 85156 | 833 |
1953656 | 1953656 | 2021-11-26 | Ada | Idaho | 16001 | 85044 | 826 |
1950405 | 1950405 | 2021-11-25 | Ada | Idaho | 16001 | 84903 | 826 |
1947154 | 1947154 | 2021-11-24 | Ada | Idaho | 16001 | 84903 | 826 |
1943903 | 1943903 | 2021-11-23 | Ada | Idaho | 16001 | 84756 | 825 |
1940653 | 1940653 | 2021-11-22 | Ada | Idaho | 16001 | 84621 | 822 |
1937403 | 1937403 | 2021-11-21 | Ada | Idaho | 16001 | 84478 | 819 |
1934153 | 1934153 | 2021-11-20 | Ada | Idaho | 16001 | 84478 | 819 |
1930901 | 1930901 | 2021-11-19 | Ada | Idaho | 16001 | 84250 | 816 |
1927651 | 1927651 | 2021-11-18 | Ada | Idaho | 16001 | 84250 | 816 |
1924401 | 1924401 | 2021-11-17 | Ada | Idaho | 16001 | 84067 | 811 |
1921152 | 1921152 | 2021-11-16 | Ada | Idaho | 16001 | 83850 | 807 |
1917902 | 1917902 | 2021-11-15 | Ada | Idaho | 16001 | 83722 | 803 |
1914652 | 1914652 | 2021-11-14 | Ada | Idaho | 16001 | 83589 | 803 |
1911402 | 1911402 | 2021-11-13 | Ada | Idaho | 16001 | 83432 | 801 |
1908153 | 1908153 | 2021-11-12 | Ada | Idaho | 16001 | 83260 | 797 |
1904904 | 1904904 | 2021-11-11 | Ada | Idaho | 16001 | 83260 | 797 |
1901654 | 1901654 | 2021-11-10 | Ada | Idaho | 16001 | 83260 | 797 |
1898404 | 1898404 | 2021-11-09 | Ada | Idaho | 16001 | 83026 | 795 |
1895154 | 1895154 | 2021-11-08 | Ada | Idaho | 16001 | 82887 | 795 |
1891904 | 1891904 | 2021-11-07 | Ada | Idaho | 16001 | 82677 | 792 |
1888654 | 1888654 | 2021-11-06 | Ada | Idaho | 16001 | 82677 | 792 |
1885404 | 1885404 | 2021-11-05 | Ada | Idaho | 16001 | 82536 | 790 |
1882155 | 1882155 | 2021-11-04 | Ada | Idaho | 16001 | 82355 | 786 |
1878906 | 1878906 | 2021-11-03 | Ada | Idaho | 16001 | 82156 | 782 |
1875657 | 1875657 | 2021-11-02 | Ada | Idaho | 16001 | 81728 | 780 |
1872408 | 1872408 | 2021-11-01 | Ada | Idaho | 16001 | 81515 | 777 |
1869159 | 1869159 | 2021-10-31 | Ada | Idaho | 16001 | 81282 | 777 |
1865910 | 1865910 | 2021-10-30 | Ada | Idaho | 16001 | 81230 | 777 |
1862661 | 1862661 | 2021-10-29 | Ada | Idaho | 16001 | 81082 | 773 |
1859412 | 1859412 | 2021-10-28 | Ada | Idaho | 16001 | 80678 | 770 |
1856163 | 1856163 | 2021-10-27 | Ada | Idaho | 16001 | 80452 | 768 |
1852914 | 1852914 | 2021-10-26 | Ada | Idaho | 16001 | 80154 | 763 |
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);