ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Aitkin" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175523 | 2175523 | 2022-02-02 | Aitkin | Minnesota | 27001 | 2755 | 59 |
2172270 | 2172270 | 2022-02-01 | Aitkin | Minnesota | 27001 | 2746 | 59 |
2169017 | 2169017 | 2022-01-31 | Aitkin | Minnesota | 27001 | 2710 | 58 |
2165762 | 2165762 | 2022-01-30 | Aitkin | Minnesota | 27001 | 2688 | 58 |
2162507 | 2162507 | 2022-01-29 | Aitkin | Minnesota | 27001 | 2688 | 58 |
2159252 | 2159252 | 2022-01-28 | Aitkin | Minnesota | 27001 | 2688 | 58 |
2155998 | 2155998 | 2022-01-27 | Aitkin | Minnesota | 27001 | 2664 | 58 |
2152745 | 2152745 | 2022-01-26 | Aitkin | Minnesota | 27001 | 2644 | 57 |
2149493 | 2149493 | 2022-01-25 | Aitkin | Minnesota | 27001 | 2626 | 57 |
2146241 | 2146241 | 2022-01-24 | Aitkin | Minnesota | 27001 | 2583 | 57 |
2142986 | 2142986 | 2022-01-23 | Aitkin | Minnesota | 27001 | 2571 | 57 |
2139731 | 2139731 | 2022-01-22 | Aitkin | Minnesota | 27001 | 2571 | 57 |
2136475 | 2136475 | 2022-01-21 | Aitkin | Minnesota | 27001 | 2571 | 57 |
2133223 | 2133223 | 2022-01-20 | Aitkin | Minnesota | 27001 | 2557 | 57 |
2129970 | 2129970 | 2022-01-19 | Aitkin | Minnesota | 27001 | 2549 | 56 |
2126716 | 2126716 | 2022-01-18 | Aitkin | Minnesota | 27001 | 2520 | 56 |
2123464 | 2123464 | 2022-01-17 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2120212 | 2120212 | 2022-01-16 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2116960 | 2116960 | 2022-01-15 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2113709 | 2113709 | 2022-01-14 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2110457 | 2110457 | 2022-01-13 | Aitkin | Minnesota | 27001 | 2505 | 55 |
2107206 | 2107206 | 2022-01-12 | Aitkin | Minnesota | 27001 | 2488 | 55 |
2103955 | 2103955 | 2022-01-11 | Aitkin | Minnesota | 27001 | 2484 | 55 |
2100704 | 2100704 | 2022-01-10 | Aitkin | Minnesota | 27001 | 2452 | 55 |
2097453 | 2097453 | 2022-01-09 | Aitkin | Minnesota | 27001 | 2442 | 55 |
2094201 | 2094201 | 2022-01-08 | Aitkin | Minnesota | 27001 | 2442 | 55 |
2090949 | 2090949 | 2022-01-07 | Aitkin | Minnesota | 27001 | 2442 | 55 |
2087698 | 2087698 | 2022-01-06 | Aitkin | Minnesota | 27001 | 2438 | 55 |
2084446 | 2084446 | 2022-01-05 | Aitkin | Minnesota | 27001 | 2434 | 55 |
2081194 | 2081194 | 2022-01-04 | Aitkin | Minnesota | 27001 | 2428 | 54 |
2077942 | 2077942 | 2022-01-03 | Aitkin | Minnesota | 27001 | 2425 | 54 |
2074691 | 2074691 | 2022-01-02 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2071440 | 2071440 | 2022-01-01 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2068189 | 2068189 | 2021-12-31 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2064938 | 2064938 | 2021-12-30 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2061688 | 2061688 | 2021-12-29 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2058439 | 2058439 | 2021-12-28 | Aitkin | Minnesota | 27001 | 2421 | 53 |
2055190 | 2055190 | 2021-12-27 | Aitkin | Minnesota | 27001 | 2409 | 53 |
2051940 | 2051940 | 2021-12-26 | Aitkin | Minnesota | 27001 | 2407 | 53 |
2048690 | 2048690 | 2021-12-25 | Aitkin | Minnesota | 27001 | 2407 | 53 |
2045440 | 2045440 | 2021-12-24 | Aitkin | Minnesota | 27001 | 2407 | 53 |
2042190 | 2042190 | 2021-12-23 | Aitkin | Minnesota | 27001 | 2407 | 53 |
2038941 | 2038941 | 2021-12-22 | Aitkin | Minnesota | 27001 | 2404 | 53 |
2035691 | 2035691 | 2021-12-21 | Aitkin | Minnesota | 27001 | 2398 | 53 |
2032441 | 2032441 | 2021-12-20 | Aitkin | Minnesota | 27001 | 2389 | 53 |
2029190 | 2029190 | 2021-12-19 | Aitkin | Minnesota | 27001 | 2388 | 53 |
2025939 | 2025939 | 2021-12-18 | Aitkin | Minnesota | 27001 | 2388 | 53 |
2022688 | 2022688 | 2021-12-17 | Aitkin | Minnesota | 27001 | 2388 | 53 |
2019437 | 2019437 | 2021-12-16 | Aitkin | Minnesota | 27001 | 2381 | 53 |
2016187 | 2016187 | 2021-12-15 | Aitkin | Minnesota | 27001 | 2372 | 53 |
2012936 | 2012936 | 2021-12-14 | Aitkin | Minnesota | 27001 | 2361 | 53 |
2009685 | 2009685 | 2021-12-13 | Aitkin | Minnesota | 27001 | 2343 | 53 |
2006434 | 2006434 | 2021-12-12 | Aitkin | Minnesota | 27001 | 2334 | 53 |
2003183 | 2003183 | 2021-12-11 | Aitkin | Minnesota | 27001 | 2334 | 53 |
1999933 | 1999933 | 2021-12-10 | Aitkin | Minnesota | 27001 | 2334 | 53 |
1996682 | 1996682 | 2021-12-09 | Aitkin | Minnesota | 27001 | 2322 | 53 |
1993431 | 1993431 | 2021-12-08 | Aitkin | Minnesota | 27001 | 2315 | 52 |
1990180 | 1990180 | 2021-12-07 | Aitkin | Minnesota | 27001 | 2309 | 52 |
1986930 | 1986930 | 2021-12-06 | Aitkin | Minnesota | 27001 | 2272 | 52 |
1983680 | 1983680 | 2021-12-05 | Aitkin | Minnesota | 27001 | 2250 | 52 |
1980430 | 1980430 | 2021-12-04 | Aitkin | Minnesota | 27001 | 2250 | 52 |
1977180 | 1977180 | 2021-12-03 | Aitkin | Minnesota | 27001 | 2250 | 52 |
1973930 | 1973930 | 2021-12-02 | Aitkin | Minnesota | 27001 | 2237 | 51 |
1970681 | 1970681 | 2021-12-01 | Aitkin | Minnesota | 27001 | 2224 | 50 |
1967431 | 1967431 | 2021-11-30 | Aitkin | Minnesota | 27001 | 2215 | 50 |
1964179 | 1964179 | 2021-11-29 | Aitkin | Minnesota | 27001 | 2179 | 50 |
1960928 | 1960928 | 2021-11-28 | Aitkin | Minnesota | 27001 | 2158 | 50 |
1957677 | 1957677 | 2021-11-27 | Aitkin | Minnesota | 27001 | 2158 | 50 |
1954426 | 1954426 | 2021-11-26 | Aitkin | Minnesota | 27001 | 2158 | 50 |
1951175 | 1951175 | 2021-11-25 | Aitkin | Minnesota | 27001 | 2153 | 50 |
1947924 | 1947924 | 2021-11-24 | Aitkin | Minnesota | 27001 | 2153 | 50 |
1944673 | 1944673 | 2021-11-23 | Aitkin | Minnesota | 27001 | 2147 | 50 |
1941422 | 1941422 | 2021-11-22 | Aitkin | Minnesota | 27001 | 2119 | 48 |
1938172 | 1938172 | 2021-11-21 | Aitkin | Minnesota | 27001 | 2107 | 47 |
1934922 | 1934922 | 2021-11-20 | Aitkin | Minnesota | 27001 | 2107 | 47 |
1931672 | 1931672 | 2021-11-19 | Aitkin | Minnesota | 27001 | 2107 | 47 |
1928421 | 1928421 | 2021-11-18 | Aitkin | Minnesota | 27001 | 2094 | 47 |
1925171 | 1925171 | 2021-11-17 | Aitkin | Minnesota | 27001 | 2079 | 47 |
1921922 | 1921922 | 2021-11-16 | Aitkin | Minnesota | 27001 | 2072 | 47 |
1918672 | 1918672 | 2021-11-15 | Aitkin | Minnesota | 27001 | 2053 | 46 |
1915422 | 1915422 | 2021-11-14 | Aitkin | Minnesota | 27001 | 2043 | 46 |
1912172 | 1912172 | 2021-11-13 | Aitkin | Minnesota | 27001 | 2043 | 46 |
1908922 | 1908922 | 2021-11-12 | Aitkin | Minnesota | 27001 | 2043 | 46 |
1905673 | 1905673 | 2021-11-11 | Aitkin | Minnesota | 27001 | 2025 | 46 |
1902424 | 1902424 | 2021-11-10 | Aitkin | Minnesota | 27001 | 2018 | 46 |
1899174 | 1899174 | 2021-11-09 | Aitkin | Minnesota | 27001 | 2006 | 46 |
1895924 | 1895924 | 2021-11-08 | Aitkin | Minnesota | 27001 | 1978 | 46 |
1892674 | 1892674 | 2021-11-07 | Aitkin | Minnesota | 27001 | 1971 | 46 |
1889424 | 1889424 | 2021-11-06 | Aitkin | Minnesota | 27001 | 1971 | 46 |
1886174 | 1886174 | 2021-11-05 | Aitkin | Minnesota | 27001 | 1971 | 46 |
1882925 | 1882925 | 2021-11-04 | Aitkin | Minnesota | 27001 | 1953 | 46 |
1879676 | 1879676 | 2021-11-03 | Aitkin | Minnesota | 27001 | 1949 | 46 |
1876427 | 1876427 | 2021-11-02 | Aitkin | Minnesota | 27001 | 1943 | 45 |
1873178 | 1873178 | 2021-11-01 | Aitkin | Minnesota | 27001 | 1916 | 44 |
1869929 | 1869929 | 2021-10-31 | Aitkin | Minnesota | 27001 | 1893 | 44 |
1866680 | 1866680 | 2021-10-30 | Aitkin | Minnesota | 27001 | 1893 | 44 |
1863431 | 1863431 | 2021-10-29 | Aitkin | Minnesota | 27001 | 1893 | 44 |
1860182 | 1860182 | 2021-10-28 | Aitkin | Minnesota | 27001 | 1883 | 44 |
1856933 | 1856933 | 2021-10-27 | Aitkin | Minnesota | 27001 | 1877 | 44 |
1853684 | 1853684 | 2021-10-26 | Aitkin | Minnesota | 27001 | 1871 | 43 |
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);