ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Fillmore" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110479 | 2110479 | 2022-01-13 | Fillmore | Minnesota | 27045 | 3694 | 18 |
2107228 | 2107228 | 2022-01-12 | Fillmore | Minnesota | 27045 | 3647 | 17 |
2103977 | 2103977 | 2022-01-11 | Fillmore | Minnesota | 27045 | 3629 | 17 |
2100726 | 2100726 | 2022-01-10 | Fillmore | Minnesota | 27045 | 3559 | 17 |
2097475 | 2097475 | 2022-01-09 | Fillmore | Minnesota | 27045 | 3533 | 17 |
2094223 | 2094223 | 2022-01-08 | Fillmore | Minnesota | 27045 | 3533 | 17 |
2090971 | 2090971 | 2022-01-07 | Fillmore | Minnesota | 27045 | 3533 | 17 |
2087720 | 2087720 | 2022-01-06 | Fillmore | Minnesota | 27045 | 3491 | 17 |
2084468 | 2084468 | 2022-01-05 | Fillmore | Minnesota | 27045 | 3479 | 17 |
2081216 | 2081216 | 2022-01-04 | Fillmore | Minnesota | 27045 | 3475 | 17 |
2077964 | 2077964 | 2022-01-03 | Fillmore | Minnesota | 27045 | 3464 | 17 |
2074713 | 2074713 | 2022-01-02 | Fillmore | Minnesota | 27045 | 3454 | 17 |
2071462 | 2071462 | 2022-01-01 | Fillmore | Minnesota | 27045 | 3454 | 17 |
2068211 | 2068211 | 2021-12-31 | Fillmore | Minnesota | 27045 | 3454 | 17 |
2064960 | 2064960 | 2021-12-30 | Fillmore | Minnesota | 27045 | 3454 | 17 |
2061710 | 2061710 | 2021-12-29 | Fillmore | Minnesota | 27045 | 3435 | 16 |
2058461 | 2058461 | 2021-12-28 | Fillmore | Minnesota | 27045 | 3426 | 16 |
2055212 | 2055212 | 2021-12-27 | Fillmore | Minnesota | 27045 | 3394 | 16 |
2051962 | 2051962 | 2021-12-26 | Fillmore | Minnesota | 27045 | 3381 | 16 |
2048712 | 2048712 | 2021-12-25 | Fillmore | Minnesota | 27045 | 3381 | 16 |
2045462 | 2045462 | 2021-12-24 | Fillmore | Minnesota | 27045 | 3381 | 16 |
2042212 | 2042212 | 2021-12-23 | Fillmore | Minnesota | 27045 | 3381 | 16 |
2038963 | 2038963 | 2021-12-22 | Fillmore | Minnesota | 27045 | 3372 | 16 |
2035713 | 2035713 | 2021-12-21 | Fillmore | Minnesota | 27045 | 3362 | 15 |
2032463 | 2032463 | 2021-12-20 | Fillmore | Minnesota | 27045 | 3324 | 15 |
2029212 | 2029212 | 2021-12-19 | Fillmore | Minnesota | 27045 | 3319 | 15 |
2025961 | 2025961 | 2021-12-18 | Fillmore | Minnesota | 27045 | 3319 | 15 |
2022710 | 2022710 | 2021-12-17 | Fillmore | Minnesota | 27045 | 3319 | 15 |
2019459 | 2019459 | 2021-12-16 | Fillmore | Minnesota | 27045 | 3274 | 15 |
2016209 | 2016209 | 2021-12-15 | Fillmore | Minnesota | 27045 | 3261 | 15 |
2012958 | 2012958 | 2021-12-14 | Fillmore | Minnesota | 27045 | 3249 | 15 |
2009707 | 2009707 | 2021-12-13 | Fillmore | Minnesota | 27045 | 3218 | 15 |
2006456 | 2006456 | 2021-12-12 | Fillmore | Minnesota | 27045 | 3191 | 15 |
2003205 | 2003205 | 2021-12-11 | Fillmore | Minnesota | 27045 | 3191 | 15 |
1999955 | 1999955 | 2021-12-10 | Fillmore | Minnesota | 27045 | 3191 | 15 |
1996704 | 1996704 | 2021-12-09 | Fillmore | Minnesota | 27045 | 3173 | 15 |
1993453 | 1993453 | 2021-12-08 | Fillmore | Minnesota | 27045 | 3157 | 15 |
1990202 | 1990202 | 2021-12-07 | Fillmore | Minnesota | 27045 | 3147 | 15 |
1986952 | 1986952 | 2021-12-06 | Fillmore | Minnesota | 27045 | 3118 | 15 |
1983702 | 1983702 | 2021-12-05 | Fillmore | Minnesota | 27045 | 3101 | 15 |
1980452 | 1980452 | 2021-12-04 | Fillmore | Minnesota | 27045 | 3101 | 15 |
1977202 | 1977202 | 2021-12-03 | Fillmore | Minnesota | 27045 | 3101 | 15 |
1973952 | 1973952 | 2021-12-02 | Fillmore | Minnesota | 27045 | 3074 | 15 |
1970703 | 1970703 | 2021-12-01 | Fillmore | Minnesota | 27045 | 3053 | 15 |
1967453 | 1967453 | 2021-11-30 | Fillmore | Minnesota | 27045 | 3043 | 15 |
1964201 | 1964201 | 2021-11-29 | Fillmore | Minnesota | 27045 | 3009 | 15 |
1960950 | 1960950 | 2021-11-28 | Fillmore | Minnesota | 27045 | 2991 | 15 |
1957699 | 1957699 | 2021-11-27 | Fillmore | Minnesota | 27045 | 2991 | 15 |
1954448 | 1954448 | 2021-11-26 | Fillmore | Minnesota | 27045 | 2991 | 15 |
1951197 | 1951197 | 2021-11-25 | Fillmore | Minnesota | 27045 | 2970 | 15 |
1947946 | 1947946 | 2021-11-24 | Fillmore | Minnesota | 27045 | 2970 | 15 |
1944695 | 1944695 | 2021-11-23 | Fillmore | Minnesota | 27045 | 2965 | 15 |
1941444 | 1941444 | 2021-11-22 | Fillmore | Minnesota | 27045 | 2918 | 15 |
1938194 | 1938194 | 2021-11-21 | Fillmore | Minnesota | 27045 | 2897 | 15 |
1934944 | 1934944 | 2021-11-20 | Fillmore | Minnesota | 27045 | 2897 | 15 |
1931694 | 1931694 | 2021-11-19 | Fillmore | Minnesota | 27045 | 2897 | 15 |
1928443 | 1928443 | 2021-11-18 | Fillmore | Minnesota | 27045 | 2879 | 15 |
1925193 | 1925193 | 2021-11-17 | Fillmore | Minnesota | 27045 | 2852 | 15 |
1921944 | 1921944 | 2021-11-16 | Fillmore | Minnesota | 27045 | 2836 | 14 |
1918694 | 1918694 | 2021-11-15 | Fillmore | Minnesota | 27045 | 2784 | 14 |
1915444 | 1915444 | 2021-11-14 | Fillmore | Minnesota | 27045 | 2763 | 14 |
1912194 | 1912194 | 2021-11-13 | Fillmore | Minnesota | 27045 | 2763 | 14 |
1908944 | 1908944 | 2021-11-12 | Fillmore | Minnesota | 27045 | 2763 | 14 |
1905695 | 1905695 | 2021-11-11 | Fillmore | Minnesota | 27045 | 2746 | 14 |
1902446 | 1902446 | 2021-11-10 | Fillmore | Minnesota | 27045 | 2722 | 14 |
1899196 | 1899196 | 2021-11-09 | Fillmore | Minnesota | 27045 | 2708 | 14 |
1895946 | 1895946 | 2021-11-08 | Fillmore | Minnesota | 27045 | 2690 | 14 |
1892696 | 1892696 | 2021-11-07 | Fillmore | Minnesota | 27045 | 2679 | 14 |
1889446 | 1889446 | 2021-11-06 | Fillmore | Minnesota | 27045 | 2679 | 14 |
1886196 | 1886196 | 2021-11-05 | Fillmore | Minnesota | 27045 | 2679 | 14 |
1882947 | 1882947 | 2021-11-04 | Fillmore | Minnesota | 27045 | 2670 | 14 |
1879698 | 1879698 | 2021-11-03 | Fillmore | Minnesota | 27045 | 2634 | 14 |
1876449 | 1876449 | 2021-11-02 | Fillmore | Minnesota | 27045 | 2618 | 14 |
1873200 | 1873200 | 2021-11-01 | Fillmore | Minnesota | 27045 | 2581 | 14 |
1869951 | 1869951 | 2021-10-31 | Fillmore | Minnesota | 27045 | 2561 | 14 |
1866702 | 1866702 | 2021-10-30 | Fillmore | Minnesota | 27045 | 2561 | 14 |
1863453 | 1863453 | 2021-10-29 | Fillmore | Minnesota | 27045 | 2561 | 14 |
1860204 | 1860204 | 2021-10-28 | Fillmore | Minnesota | 27045 | 2519 | 14 |
1856955 | 1856955 | 2021-10-27 | Fillmore | Minnesota | 27045 | 2510 | 14 |
1853706 | 1853706 | 2021-10-26 | Fillmore | Minnesota | 27045 | 2505 | 14 |
1850457 | 1850457 | 2021-10-25 | Fillmore | Minnesota | 27045 | 2461 | 13 |
1847207 | 1847207 | 2021-10-24 | Fillmore | Minnesota | 27045 | 2438 | 12 |
1843957 | 1843957 | 2021-10-23 | Fillmore | Minnesota | 27045 | 2438 | 12 |
1840707 | 1840707 | 2021-10-22 | Fillmore | Minnesota | 27045 | 2438 | 12 |
1837458 | 1837458 | 2021-10-21 | Fillmore | Minnesota | 27045 | 2432 | 12 |
1834209 | 1834209 | 2021-10-20 | Fillmore | Minnesota | 27045 | 2415 | 12 |
1830960 | 1830960 | 2021-10-19 | Fillmore | Minnesota | 27045 | 2410 | 12 |
1827711 | 1827711 | 2021-10-18 | Fillmore | Minnesota | 27045 | 2382 | 12 |
1824462 | 1824462 | 2021-10-17 | Fillmore | Minnesota | 27045 | 2363 | 12 |
1821213 | 1821213 | 2021-10-16 | Fillmore | Minnesota | 27045 | 2363 | 12 |
1817964 | 1817964 | 2021-10-15 | Fillmore | Minnesota | 27045 | 2363 | 12 |
1814715 | 1814715 | 2021-10-14 | Fillmore | Minnesota | 27045 | 2326 | 12 |
1811467 | 1811467 | 2021-10-13 | Fillmore | Minnesota | 27045 | 2293 | 12 |
1808218 | 1808218 | 2021-10-12 | Fillmore | Minnesota | 27045 | 2279 | 12 |
1804967 | 1804967 | 2021-10-11 | Fillmore | Minnesota | 27045 | 2208 | 12 |
1801718 | 1801718 | 2021-10-10 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1798469 | 1798469 | 2021-10-09 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1795220 | 1795220 | 2021-10-08 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1791971 | 1791971 | 2021-10-07 | Fillmore | Minnesota | 27045 | 2180 | 12 |
1788722 | 1788722 | 2021-10-06 | Fillmore | Minnesota | 27045 | 2157 | 12 |
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);