ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where county = "Unknown" and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175987 | 2175987 | 2022-02-02 | Unknown | New Hampshire | 8083 | 27 | |
2172734 | 2172734 | 2022-02-01 | Unknown | New Hampshire | 8411 | 28 | |
2169481 | 2169481 | 2022-01-31 | Unknown | New Hampshire | 8392 | 24 | |
2166226 | 2166226 | 2022-01-30 | Unknown | New Hampshire | 8345 | 24 | |
2162971 | 2162971 | 2022-01-29 | Unknown | New Hampshire | 8345 | 24 | |
2159716 | 2159716 | 2022-01-28 | Unknown | New Hampshire | 8345 | 24 | |
2156462 | 2156462 | 2022-01-27 | Unknown | New Hampshire | 8307 | 23 | |
2153209 | 2153209 | 2022-01-26 | Unknown | New Hampshire | 8169 | 22 | |
2149957 | 2149957 | 2022-01-25 | Unknown | New Hampshire | 7990 | 21 | |
2146705 | 2146705 | 2022-01-24 | Unknown | New Hampshire | 7908 | 19 | |
2143450 | 2143450 | 2022-01-23 | Unknown | New Hampshire | 7511 | 17 | |
2140195 | 2140195 | 2022-01-22 | Unknown | New Hampshire | 7511 | 17 | |
2136939 | 2136939 | 2022-01-21 | Unknown | New Hampshire | 7511 | 17 | |
2133687 | 2133687 | 2022-01-20 | Unknown | New Hampshire | 7338 | 17 | |
2130434 | 2130434 | 2022-01-19 | Unknown | New Hampshire | 7330 | 26 | |
2127180 | 2127180 | 2022-01-18 | Unknown | New Hampshire | 7304 | 26 | |
2123928 | 2123928 | 2022-01-17 | Unknown | New Hampshire | 6444 | 26 | |
2120676 | 2120676 | 2022-01-16 | Unknown | New Hampshire | 6444 | 26 | |
2117424 | 2117424 | 2022-01-15 | Unknown | New Hampshire | 6444 | 26 | |
2114173 | 2114173 | 2022-01-14 | Unknown | New Hampshire | 6444 | 26 | |
2110921 | 2110921 | 2022-01-13 | Unknown | New Hampshire | 6320 | 24 | |
2107670 | 2107670 | 2022-01-12 | Unknown | New Hampshire | 6069 | 24 | |
2104419 | 2104419 | 2022-01-11 | Unknown | New Hampshire | 5892 | 24 | |
2101168 | 2101168 | 2022-01-10 | Unknown | New Hampshire | 5667 | 24 | |
2097917 | 2097917 | 2022-01-09 | Unknown | New Hampshire | 5111 | 23 | |
2094665 | 2094665 | 2022-01-08 | Unknown | New Hampshire | 5111 | 23 | |
2091413 | 2091413 | 2022-01-07 | Unknown | New Hampshire | 5111 | 23 | |
2088162 | 2088162 | 2022-01-06 | Unknown | New Hampshire | 4956 | 23 | |
2084910 | 2084910 | 2022-01-05 | Unknown | New Hampshire | 4604 | 23 | |
2081658 | 2081658 | 2022-01-04 | Unknown | New Hampshire | 4350 | 23 | |
2078406 | 2078406 | 2022-01-03 | Unknown | New Hampshire | 4209 | 23 | |
2075155 | 2075155 | 2022-01-02 | Unknown | New Hampshire | 3773 | 22 | |
2071904 | 2071904 | 2022-01-01 | Unknown | New Hampshire | 3773 | 22 | |
2068653 | 2068653 | 2021-12-31 | Unknown | New Hampshire | 3773 | 22 | |
2065402 | 2065402 | 2021-12-30 | Unknown | New Hampshire | 3773 | 22 | |
2062152 | 2062152 | 2021-12-29 | Unknown | New Hampshire | 3575 | 21 | |
2058903 | 2058903 | 2021-12-28 | Unknown | New Hampshire | 3374 | 20 | |
2055654 | 2055654 | 2021-12-27 | Unknown | New Hampshire | 3354 | 18 | |
2052404 | 2052404 | 2021-12-26 | Unknown | New Hampshire | 2865 | 18 | |
2049154 | 2049154 | 2021-12-25 | Unknown | New Hampshire | 2865 | 18 | |
2045904 | 2045904 | 2021-12-24 | Unknown | New Hampshire | 2865 | 18 | |
2042654 | 2042654 | 2021-12-23 | Unknown | New Hampshire | 2865 | 18 | |
2039405 | 2039405 | 2021-12-22 | Unknown | New Hampshire | 2794 | 18 | |
2036155 | 2036155 | 2021-12-21 | Unknown | New Hampshire | 2683 | 18 | |
2032905 | 2032905 | 2021-12-20 | Unknown | New Hampshire | 2628 | 16 | |
2029654 | 2029654 | 2021-12-19 | Unknown | New Hampshire | 2448 | 16 | |
2026403 | 2026403 | 2021-12-18 | Unknown | New Hampshire | 2448 | 16 | |
2023152 | 2023152 | 2021-12-17 | Unknown | New Hampshire | 2448 | 16 | |
2019901 | 2019901 | 2021-12-16 | Unknown | New Hampshire | 2360 | 16 | |
2016651 | 2016651 | 2021-12-15 | Unknown | New Hampshire | 2293 | 15 | |
2013400 | 2013400 | 2021-12-14 | Unknown | New Hampshire | 2262 | 15 | |
2010149 | 2010149 | 2021-12-13 | Unknown | New Hampshire | 2203 | 13 | |
2006898 | 2006898 | 2021-12-12 | Unknown | New Hampshire | 2021 | 13 | |
2003647 | 2003647 | 2021-12-11 | Unknown | New Hampshire | 2021 | 13 | |
2000397 | 2000397 | 2021-12-10 | Unknown | New Hampshire | 2021 | 13 | |
1997146 | 1997146 | 2021-12-09 | Unknown | New Hampshire | 1965 | 12 | |
1993895 | 1993895 | 2021-12-08 | Unknown | New Hampshire | 1906 | 12 | |
1990644 | 1990644 | 2021-12-07 | Unknown | New Hampshire | 1800 | 12 | |
1987394 | 1987394 | 2021-12-06 | Unknown | New Hampshire | 1757 | 11 | |
1984144 | 1984144 | 2021-12-05 | Unknown | New Hampshire | 1607 | 11 | |
1980894 | 1980894 | 2021-12-04 | Unknown | New Hampshire | 1607 | 11 | |
1977644 | 1977644 | 2021-12-03 | Unknown | New Hampshire | 1607 | 11 | |
1974394 | 1974394 | 2021-12-02 | Unknown | New Hampshire | 1553 | 10 | |
1971145 | 1971145 | 2021-12-01 | Unknown | New Hampshire | 1523 | 10 | |
1967895 | 1967895 | 2021-11-30 | Unknown | New Hampshire | 1459 | 10 | |
1964643 | 1964643 | 2021-11-29 | Unknown | New Hampshire | 1404 | 9 | |
1961392 | 1961392 | 2021-11-28 | Unknown | New Hampshire | 1217 | 7 | |
1958141 | 1958141 | 2021-11-27 | Unknown | New Hampshire | 1217 | 7 | |
1954890 | 1954890 | 2021-11-26 | Unknown | New Hampshire | 1217 | 7 | |
1951639 | 1951639 | 2021-11-25 | Unknown | New Hampshire | 1217 | 7 | |
1948388 | 1948388 | 2021-11-24 | Unknown | New Hampshire | 1217 | 7 | |
1945137 | 1945137 | 2021-11-23 | Unknown | New Hampshire | 1215 | 6 | |
1941886 | 1941886 | 2021-11-22 | Unknown | New Hampshire | 1160 | 6 | |
1938636 | 1938636 | 2021-11-21 | Unknown | New Hampshire | 1058 | 6 | |
1935386 | 1935386 | 2021-11-20 | Unknown | New Hampshire | 1058 | 6 | |
1932136 | 1932136 | 2021-11-19 | Unknown | New Hampshire | 1058 | 6 | |
1928885 | 1928885 | 2021-11-18 | Unknown | New Hampshire | 1052 | 6 | |
1925635 | 1925635 | 2021-11-17 | Unknown | New Hampshire | 1025 | 6 | |
1922386 | 1922386 | 2021-11-16 | Unknown | New Hampshire | 1005 | 5 | |
1919136 | 1919136 | 2021-11-15 | Unknown | New Hampshire | 960 | 4 | |
1915886 | 1915886 | 2021-11-14 | Unknown | New Hampshire | 904 | 4 | |
1912636 | 1912636 | 2021-11-13 | Unknown | New Hampshire | 904 | 4 | |
1909386 | 1909386 | 2021-11-12 | Unknown | New Hampshire | 904 | 4 | |
1906137 | 1906137 | 2021-11-11 | Unknown | New Hampshire | 837 | 4 | |
1902888 | 1902888 | 2021-11-10 | Unknown | New Hampshire | 837 | 4 | |
1899638 | 1899638 | 2021-11-09 | Unknown | New Hampshire | 844 | 4 | |
1896388 | 1896388 | 2021-11-08 | Unknown | New Hampshire | 816 | 4 | |
1893138 | 1893138 | 2021-11-07 | Unknown | New Hampshire | 804 | 4 | |
1889888 | 1889888 | 2021-11-06 | Unknown | New Hampshire | 804 | 4 | |
1886638 | 1886638 | 2021-11-05 | Unknown | New Hampshire | 804 | 4 | |
1883389 | 1883389 | 2021-11-04 | Unknown | New Hampshire | 790 | 4 | |
1880140 | 1880140 | 2021-11-03 | Unknown | New Hampshire | 784 | 2 | |
1876891 | 1876891 | 2021-11-02 | Unknown | New Hampshire | 775 | 2 | |
1873642 | 1873642 | 2021-11-01 | Unknown | New Hampshire | 748 | 2 | |
1870393 | 1870393 | 2021-10-31 | Unknown | New Hampshire | 2729 | 22 | |
1867144 | 1867144 | 2021-10-30 | Unknown | New Hampshire | 2729 | 22 | |
1863895 | 1863895 | 2021-10-29 | Unknown | New Hampshire | 2729 | 22 | |
1860646 | 1860646 | 2021-10-28 | Unknown | New Hampshire | 653 | 1 | |
1857397 | 1857397 | 2021-10-27 | Unknown | New Hampshire | 653 | 1 | |
1854148 | 1854148 | 2021-10-26 | Unknown | New Hampshire | 691 | 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);