ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 33001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175977 | 2175977 | 2022-02-02 | Belknap | New Hampshire | 33001 | 12329 | 159 |
2172724 | 2172724 | 2022-02-01 | Belknap | New Hampshire | 33001 | 12251 | 159 |
2169471 | 2169471 | 2022-01-31 | Belknap | New Hampshire | 33001 | 12224 | 158 |
2166216 | 2166216 | 2022-01-30 | Belknap | New Hampshire | 33001 | 12045 | 158 |
2162961 | 2162961 | 2022-01-29 | Belknap | New Hampshire | 33001 | 12045 | 158 |
2159706 | 2159706 | 2022-01-28 | Belknap | New Hampshire | 33001 | 12045 | 158 |
2156452 | 2156452 | 2022-01-27 | Belknap | New Hampshire | 33001 | 11917 | 158 |
2153199 | 2153199 | 2022-01-26 | Belknap | New Hampshire | 33001 | 11788 | 157 |
2149947 | 2149947 | 2022-01-25 | Belknap | New Hampshire | 33001 | 11700 | 157 |
2146695 | 2146695 | 2022-01-24 | Belknap | New Hampshire | 33001 | 11651 | 155 |
2143440 | 2143440 | 2022-01-23 | Belknap | New Hampshire | 33001 | 11426 | 155 |
2140185 | 2140185 | 2022-01-22 | Belknap | New Hampshire | 33001 | 11426 | 155 |
2136929 | 2136929 | 2022-01-21 | Belknap | New Hampshire | 33001 | 11426 | 155 |
2133677 | 2133677 | 2022-01-20 | Belknap | New Hampshire | 33001 | 11296 | 155 |
2130424 | 2130424 | 2022-01-19 | Belknap | New Hampshire | 33001 | 11103 | 154 |
2127170 | 2127170 | 2022-01-18 | Belknap | New Hampshire | 33001 | 11057 | 153 |
2123918 | 2123918 | 2022-01-17 | Belknap | New Hampshire | 33001 | 10508 | 153 |
2120666 | 2120666 | 2022-01-16 | Belknap | New Hampshire | 33001 | 10508 | 153 |
2117414 | 2117414 | 2022-01-15 | Belknap | New Hampshire | 33001 | 10508 | 153 |
2114163 | 2114163 | 2022-01-14 | Belknap | New Hampshire | 33001 | 10508 | 153 |
2110911 | 2110911 | 2022-01-13 | Belknap | New Hampshire | 33001 | 10443 | 150 |
2107660 | 2107660 | 2022-01-12 | Belknap | New Hampshire | 33001 | 10316 | 149 |
2104409 | 2104409 | 2022-01-11 | Belknap | New Hampshire | 33001 | 10170 | 149 |
2101158 | 2101158 | 2022-01-10 | Belknap | New Hampshire | 33001 | 10085 | 149 |
2097907 | 2097907 | 2022-01-09 | Belknap | New Hampshire | 33001 | 9810 | 149 |
2094655 | 2094655 | 2022-01-08 | Belknap | New Hampshire | 33001 | 9810 | 149 |
2091403 | 2091403 | 2022-01-07 | Belknap | New Hampshire | 33001 | 9810 | 149 |
2088152 | 2088152 | 2022-01-06 | Belknap | New Hampshire | 33001 | 9708 | 149 |
2084900 | 2084900 | 2022-01-05 | Belknap | New Hampshire | 33001 | 9596 | 149 |
2081648 | 2081648 | 2022-01-04 | Belknap | New Hampshire | 33001 | 9490 | 149 |
2078396 | 2078396 | 2022-01-03 | Belknap | New Hampshire | 33001 | 9431 | 146 |
2075145 | 2075145 | 2022-01-02 | Belknap | New Hampshire | 33001 | 9284 | 146 |
2071894 | 2071894 | 2022-01-01 | Belknap | New Hampshire | 33001 | 9284 | 146 |
2068643 | 2068643 | 2021-12-31 | Belknap | New Hampshire | 33001 | 9284 | 146 |
2065392 | 2065392 | 2021-12-30 | Belknap | New Hampshire | 33001 | 9284 | 146 |
2062142 | 2062142 | 2021-12-29 | Belknap | New Hampshire | 33001 | 9188 | 145 |
2058893 | 2058893 | 2021-12-28 | Belknap | New Hampshire | 33001 | 9145 | 145 |
2055644 | 2055644 | 2021-12-27 | Belknap | New Hampshire | 33001 | 9122 | 144 |
2052394 | 2052394 | 2021-12-26 | Belknap | New Hampshire | 33001 | 8929 | 144 |
2049144 | 2049144 | 2021-12-25 | Belknap | New Hampshire | 33001 | 8929 | 144 |
2045894 | 2045894 | 2021-12-24 | Belknap | New Hampshire | 33001 | 8929 | 144 |
2042644 | 2042644 | 2021-12-23 | Belknap | New Hampshire | 33001 | 8929 | 144 |
2039395 | 2039395 | 2021-12-22 | Belknap | New Hampshire | 33001 | 8894 | 144 |
2036145 | 2036145 | 2021-12-21 | Belknap | New Hampshire | 33001 | 8817 | 144 |
2032895 | 2032895 | 2021-12-20 | Belknap | New Hampshire | 33001 | 8799 | 144 |
2029644 | 2029644 | 2021-12-19 | Belknap | New Hampshire | 33001 | 8653 | 144 |
2026393 | 2026393 | 2021-12-18 | Belknap | New Hampshire | 33001 | 8653 | 144 |
2023142 | 2023142 | 2021-12-17 | Belknap | New Hampshire | 33001 | 8653 | 144 |
2019891 | 2019891 | 2021-12-16 | Belknap | New Hampshire | 33001 | 8605 | 144 |
2016641 | 2016641 | 2021-12-15 | Belknap | New Hampshire | 33001 | 8554 | 142 |
2013390 | 2013390 | 2021-12-14 | Belknap | New Hampshire | 33001 | 8495 | 142 |
2010139 | 2010139 | 2021-12-13 | Belknap | New Hampshire | 33001 | 8419 | 138 |
2006888 | 2006888 | 2021-12-12 | Belknap | New Hampshire | 33001 | 8299 | 138 |
2003637 | 2003637 | 2021-12-11 | Belknap | New Hampshire | 33001 | 8299 | 138 |
2000387 | 2000387 | 2021-12-10 | Belknap | New Hampshire | 33001 | 8299 | 138 |
1997136 | 1997136 | 2021-12-09 | Belknap | New Hampshire | 33001 | 8228 | 138 |
1993885 | 1993885 | 2021-12-08 | Belknap | New Hampshire | 33001 | 8143 | 138 |
1990634 | 1990634 | 2021-12-07 | Belknap | New Hampshire | 33001 | 8094 | 136 |
1987384 | 1987384 | 2021-12-06 | Belknap | New Hampshire | 33001 | 8027 | 134 |
1984134 | 1984134 | 2021-12-05 | Belknap | New Hampshire | 33001 | 7923 | 134 |
1980884 | 1980884 | 2021-12-04 | Belknap | New Hampshire | 33001 | 7923 | 134 |
1977634 | 1977634 | 2021-12-03 | Belknap | New Hampshire | 33001 | 7923 | 134 |
1974384 | 1974384 | 2021-12-02 | Belknap | New Hampshire | 33001 | 7875 | 134 |
1971135 | 1971135 | 2021-12-01 | Belknap | New Hampshire | 33001 | 7812 | 134 |
1967885 | 1967885 | 2021-11-30 | Belknap | New Hampshire | 33001 | 7762 | 134 |
1964633 | 1964633 | 2021-11-29 | Belknap | New Hampshire | 33001 | 7660 | 134 |
1961382 | 1961382 | 2021-11-28 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1958131 | 1958131 | 2021-11-27 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1954880 | 1954880 | 2021-11-26 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1951629 | 1951629 | 2021-11-25 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1948378 | 1948378 | 2021-11-24 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1945127 | 1945127 | 2021-11-23 | Belknap | New Hampshire | 33001 | 7361 | 133 |
1941876 | 1941876 | 2021-11-22 | Belknap | New Hampshire | 33001 | 7344 | 132 |
1938626 | 1938626 | 2021-11-21 | Belknap | New Hampshire | 33001 | 7222 | 132 |
1935376 | 1935376 | 2021-11-20 | Belknap | New Hampshire | 33001 | 7222 | 132 |
1932126 | 1932126 | 2021-11-19 | Belknap | New Hampshire | 33001 | 7222 | 132 |
1928875 | 1928875 | 2021-11-18 | Belknap | New Hampshire | 33001 | 7174 | 131 |
1925625 | 1925625 | 2021-11-17 | Belknap | New Hampshire | 33001 | 7113 | 131 |
1922376 | 1922376 | 2021-11-16 | Belknap | New Hampshire | 33001 | 7068 | 130 |
1919126 | 1919126 | 2021-11-15 | Belknap | New Hampshire | 33001 | 7005 | 130 |
1915876 | 1915876 | 2021-11-14 | Belknap | New Hampshire | 33001 | 6910 | 130 |
1912626 | 1912626 | 2021-11-13 | Belknap | New Hampshire | 33001 | 6910 | 130 |
1909376 | 1909376 | 2021-11-12 | Belknap | New Hampshire | 33001 | 6910 | 130 |
1906127 | 1906127 | 2021-11-11 | Belknap | New Hampshire | 33001 | 6807 | 129 |
1902878 | 1902878 | 2021-11-10 | Belknap | New Hampshire | 33001 | 6807 | 129 |
1899628 | 1899628 | 2021-11-09 | Belknap | New Hampshire | 33001 | 6753 | 129 |
1896378 | 1896378 | 2021-11-08 | Belknap | New Hampshire | 33001 | 6731 | 128 |
1893128 | 1893128 | 2021-11-07 | Belknap | New Hampshire | 33001 | 6639 | 127 |
1889878 | 1889878 | 2021-11-06 | Belknap | New Hampshire | 33001 | 6639 | 127 |
1886628 | 1886628 | 2021-11-05 | Belknap | New Hampshire | 33001 | 6639 | 127 |
1883379 | 1883379 | 2021-11-04 | Belknap | New Hampshire | 33001 | 6588 | 127 |
1880130 | 1880130 | 2021-11-03 | Belknap | New Hampshire | 33001 | 6538 | 126 |
1876881 | 1876881 | 2021-11-02 | Belknap | New Hampshire | 33001 | 6501 | 125 |
1873632 | 1873632 | 2021-11-01 | Belknap | New Hampshire | 33001 | 6455 | 125 |
1870383 | 1870383 | 2021-10-31 | Belknap | New Hampshire | 33001 | 6183 | 124 |
1867134 | 1867134 | 2021-10-30 | Belknap | New Hampshire | 33001 | 6183 | 124 |
1863885 | 1863885 | 2021-10-29 | Belknap | New Hampshire | 33001 | 6183 | 124 |
1860636 | 1860636 | 2021-10-28 | Belknap | New Hampshire | 33001 | 6183 | 124 |
1857387 | 1857387 | 2021-10-27 | Belknap | New Hampshire | 33001 | 6183 | 124 |
1854138 | 1854138 | 2021-10-26 | Belknap | New Hampshire | 33001 | 6184 | 124 |
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);