ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Anchorage" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174263 | 2174263 | 2022-02-02 | Anchorage | Alaska | 2020 | 93825 | 462 |
2171011 | 2171011 | 2022-02-01 | Anchorage | Alaska | 2020 | 92478 | 458 |
2167758 | 2167758 | 2022-01-31 | Anchorage | Alaska | 2020 | 92478 | 458 |
2164503 | 2164503 | 2022-01-30 | Anchorage | Alaska | 2020 | 90639 | 458 |
2161248 | 2161248 | 2022-01-29 | Anchorage | Alaska | 2020 | 90639 | 458 |
2157992 | 2157992 | 2022-01-28 | Anchorage | Alaska | 2020 | 90639 | 458 |
2154739 | 2154739 | 2022-01-27 | Anchorage | Alaska | 2020 | 88435 | 454 |
2151486 | 2151486 | 2022-01-26 | Anchorage | Alaska | 2020 | 88435 | 454 |
2148234 | 2148234 | 2022-01-25 | Anchorage | Alaska | 2020 | 86108 | 452 |
2144982 | 2144982 | 2022-01-24 | Anchorage | Alaska | 2020 | 86108 | 452 |
2141727 | 2141727 | 2022-01-23 | Anchorage | Alaska | 2020 | 83764 | 444 |
2138471 | 2138471 | 2022-01-22 | Anchorage | Alaska | 2020 | 83764 | 444 |
2135216 | 2135216 | 2022-01-21 | Anchorage | Alaska | 2020 | 83764 | 444 |
2131964 | 2131964 | 2022-01-20 | Anchorage | Alaska | 2020 | 80757 | 444 |
2128710 | 2128710 | 2022-01-19 | Anchorage | Alaska | 2020 | 80757 | 444 |
2125457 | 2125457 | 2022-01-18 | Anchorage | Alaska | 2020 | 75309 | 426 |
2122205 | 2122205 | 2022-01-17 | Anchorage | Alaska | 2020 | 75309 | 426 |
2118953 | 2118953 | 2022-01-16 | Anchorage | Alaska | 2020 | 75309 | 426 |
2115701 | 2115701 | 2022-01-15 | Anchorage | Alaska | 2020 | 75309 | 426 |
2112449 | 2112449 | 2022-01-14 | Anchorage | Alaska | 2020 | 75309 | 426 |
2109197 | 2109197 | 2022-01-13 | Anchorage | Alaska | 2020 | 72336 | 424 |
2105946 | 2105946 | 2022-01-12 | Anchorage | Alaska | 2020 | 72336 | 424 |
2102695 | 2102695 | 2022-01-11 | Anchorage | Alaska | 2020 | 69886 | 419 |
2099444 | 2099444 | 2022-01-10 | Anchorage | Alaska | 2020 | 69886 | 419 |
2096193 | 2096193 | 2022-01-09 | Anchorage | Alaska | 2020 | 68113 | 419 |
2092941 | 2092941 | 2022-01-08 | Anchorage | Alaska | 2020 | 68113 | 419 |
2089689 | 2089689 | 2022-01-07 | Anchorage | Alaska | 2020 | 68113 | 419 |
2086438 | 2086438 | 2022-01-06 | Anchorage | Alaska | 2020 | 65810 | 419 |
2083186 | 2083186 | 2022-01-05 | Anchorage | Alaska | 2020 | 65105 | 419 |
2079934 | 2079934 | 2022-01-04 | Anchorage | Alaska | 2020 | 65105 | 419 |
2076682 | 2076682 | 2022-01-03 | Anchorage | Alaska | 2020 | 65105 | 419 |
2073431 | 2073431 | 2022-01-02 | Anchorage | Alaska | 2020 | 63352 | 419 |
2070180 | 2070180 | 2022-01-01 | Anchorage | Alaska | 2020 | 63352 | 419 |
2066929 | 2066929 | 2021-12-31 | Anchorage | Alaska | 2020 | 63352 | 419 |
2063679 | 2063679 | 2021-12-30 | Anchorage | Alaska | 2020 | 63352 | 419 |
2060429 | 2060429 | 2021-12-29 | Anchorage | Alaska | 2020 | 63352 | 419 |
2057180 | 2057180 | 2021-12-28 | Anchorage | Alaska | 2020 | 62828 | 417 |
2053931 | 2053931 | 2021-12-27 | Anchorage | Alaska | 2020 | 62828 | 417 |
2050681 | 2050681 | 2021-12-26 | Anchorage | Alaska | 2020 | 62484 | 417 |
2047431 | 2047431 | 2021-12-25 | Anchorage | Alaska | 2020 | 62484 | 417 |
2044181 | 2044181 | 2021-12-24 | Anchorage | Alaska | 2020 | 62484 | 417 |
2040932 | 2040932 | 2021-12-23 | Anchorage | Alaska | 2020 | 62484 | 417 |
2037682 | 2037682 | 2021-12-22 | Anchorage | Alaska | 2020 | 62484 | 417 |
2034432 | 2034432 | 2021-12-21 | Anchorage | Alaska | 2020 | 62389 | 412 |
2031182 | 2031182 | 2021-12-20 | Anchorage | Alaska | 2020 | 62389 | 412 |
2027931 | 2027931 | 2021-12-19 | Anchorage | Alaska | 2020 | 62208 | 412 |
2024680 | 2024680 | 2021-12-18 | Anchorage | Alaska | 2020 | 62208 | 412 |
2021429 | 2021429 | 2021-12-17 | Anchorage | Alaska | 2020 | 62208 | 412 |
2018178 | 2018178 | 2021-12-16 | Anchorage | Alaska | 2020 | 62070 | 395 |
2014928 | 2014928 | 2021-12-15 | Anchorage | Alaska | 2020 | 62070 | 395 |
2011677 | 2011677 | 2021-12-14 | Anchorage | Alaska | 2020 | 61921 | 394 |
2008426 | 2008426 | 2021-12-13 | Anchorage | Alaska | 2020 | 61921 | 394 |
2005175 | 2005175 | 2021-12-12 | Anchorage | Alaska | 2020 | 61774 | 394 |
2001924 | 2001924 | 2021-12-11 | Anchorage | Alaska | 2020 | 61774 | 394 |
1998674 | 1998674 | 2021-12-10 | Anchorage | Alaska | 2020 | 61774 | 394 |
1995423 | 1995423 | 2021-12-09 | Anchorage | Alaska | 2020 | 61633 | 394 |
1992172 | 1992172 | 2021-12-08 | Anchorage | Alaska | 2020 | 61633 | 394 |
1988921 | 1988921 | 2021-12-07 | Anchorage | Alaska | 2020 | 61455 | 393 |
1985671 | 1985671 | 2021-12-06 | Anchorage | Alaska | 2020 | 61455 | 393 |
1982421 | 1982421 | 2021-12-05 | Anchorage | Alaska | 2020 | 61272 | 393 |
1979171 | 1979171 | 2021-12-04 | Anchorage | Alaska | 2020 | 61272 | 393 |
1975921 | 1975921 | 2021-12-03 | Anchorage | Alaska | 2020 | 61272 | 393 |
1972672 | 1972672 | 2021-12-02 | Anchorage | Alaska | 2020 | 61190 | 393 |
1969422 | 1969422 | 2021-12-01 | Anchorage | Alaska | 2020 | 61075 | 392 |
1966172 | 1966172 | 2021-11-30 | Anchorage | Alaska | 2020 | 60942 | 392 |
1962920 | 1962920 | 2021-11-29 | Anchorage | Alaska | 2020 | 60889 | 391 |
1959669 | 1959669 | 2021-11-28 | Anchorage | Alaska | 2020 | 60623 | 391 |
1956418 | 1956418 | 2021-11-27 | Anchorage | Alaska | 2020 | 60623 | 391 |
1953167 | 1953167 | 2021-11-26 | Anchorage | Alaska | 2020 | 60623 | 391 |
1949916 | 1949916 | 2021-11-25 | Anchorage | Alaska | 2020 | 60432 | 387 |
1946665 | 1946665 | 2021-11-24 | Anchorage | Alaska | 2020 | 60432 | 387 |
1943414 | 1943414 | 2021-11-23 | Anchorage | Alaska | 2020 | 60272 | 383 |
1940164 | 1940164 | 2021-11-22 | Anchorage | Alaska | 2020 | 60233 | 381 |
1936914 | 1936914 | 2021-11-21 | Anchorage | Alaska | 2020 | 59993 | 381 |
1933664 | 1933664 | 2021-11-20 | Anchorage | Alaska | 2020 | 59993 | 381 |
1930412 | 1930412 | 2021-11-19 | Anchorage | Alaska | 2020 | 59993 | 381 |
1927162 | 1927162 | 2021-11-18 | Anchorage | Alaska | 2020 | 59851 | 379 |
1923912 | 1923912 | 2021-11-17 | Anchorage | Alaska | 2020 | 59672 | 379 |
1920663 | 1920663 | 2021-11-16 | Anchorage | Alaska | 2020 | 59532 | 379 |
1917413 | 1917413 | 2021-11-15 | Anchorage | Alaska | 2020 | 59440 | 375 |
1914163 | 1914163 | 2021-11-14 | Anchorage | Alaska | 2020 | 59144 | 373 |
1910913 | 1910913 | 2021-11-13 | Anchorage | Alaska | 2020 | 59144 | 373 |
1907664 | 1907664 | 2021-11-12 | Anchorage | Alaska | 2020 | 59144 | 373 |
1904415 | 1904415 | 2021-11-11 | Anchorage | Alaska | 2020 | 58838 | 373 |
1901165 | 1901165 | 2021-11-10 | Anchorage | Alaska | 2020 | 58838 | 373 |
1897915 | 1897915 | 2021-11-09 | Anchorage | Alaska | 2020 | 58677 | 368 |
1894665 | 1894665 | 2021-11-08 | Anchorage | Alaska | 2020 | 58553 | 366 |
1891415 | 1891415 | 2021-11-07 | Anchorage | Alaska | 2020 | 58055 | 342 |
1888165 | 1888165 | 2021-11-06 | Anchorage | Alaska | 2020 | 58055 | 342 |
1884915 | 1884915 | 2021-11-05 | Anchorage | Alaska | 2020 | 58055 | 342 |
1881666 | 1881666 | 2021-11-04 | Anchorage | Alaska | 2020 | 57759 | 341 |
1878417 | 1878417 | 2021-11-03 | Anchorage | Alaska | 2020 | 57554 | 338 |
1875168 | 1875168 | 2021-11-02 | Anchorage | Alaska | 2020 | 57327 | 338 |
1871919 | 1871919 | 2021-11-01 | Anchorage | Alaska | 2020 | 57155 | 333 |
1868670 | 1868670 | 2021-10-31 | Anchorage | Alaska | 2020 | 56559 | 331 |
1865421 | 1865421 | 2021-10-30 | Anchorage | Alaska | 2020 | 56559 | 331 |
1862172 | 1862172 | 2021-10-29 | Anchorage | Alaska | 2020 | 56559 | 331 |
1858923 | 1858923 | 2021-10-28 | Anchorage | Alaska | 2020 | 56268 | 329 |
1855674 | 1855674 | 2021-10-27 | Anchorage | Alaska | 2020 | 56002 | 329 |
1852425 | 1852425 | 2021-10-26 | Anchorage | Alaska | 2020 | 55731 | 328 |
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);