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 |
---|---|---|---|---|---|---|---|
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 |
1785474 | 1785474 | 2021-10-05 | Fillmore | Minnesota | 27045 | 2145 | 11 |
1782225 | 1782225 | 2021-10-04 | Fillmore | Minnesota | 27045 | 2127 | 11 |
1778975 | 1778975 | 2021-10-03 | Fillmore | Minnesota | 27045 | 2111 | 11 |
1775725 | 1775725 | 2021-10-02 | Fillmore | Minnesota | 27045 | 2111 | 11 |
1772475 | 1772475 | 2021-10-01 | Fillmore | Minnesota | 27045 | 2111 | 11 |
1769226 | 1769226 | 2021-09-30 | Fillmore | Minnesota | 27045 | 2093 | 11 |
1765977 | 1765977 | 2021-09-29 | Fillmore | Minnesota | 27045 | 2088 | 11 |
1762728 | 1762728 | 2021-09-28 | Fillmore | Minnesota | 27045 | 2082 | 11 |
1759479 | 1759479 | 2021-09-27 | Fillmore | Minnesota | 27045 | 2051 | 10 |
1756231 | 1756231 | 2021-09-26 | Fillmore | Minnesota | 27045 | 2045 | 10 |
1752983 | 1752983 | 2021-09-25 | Fillmore | Minnesota | 27045 | 2045 | 10 |
1749735 | 1749735 | 2021-09-24 | Fillmore | Minnesota | 27045 | 2045 | 10 |
1746485 | 1746485 | 2021-09-23 | Fillmore | Minnesota | 27045 | 2022 | 10 |
1743236 | 1743236 | 2021-09-22 | Fillmore | Minnesota | 27045 | 2008 | 10 |
1739987 | 1739987 | 2021-09-21 | Fillmore | Minnesota | 27045 | 2002 | 10 |
1736738 | 1736738 | 2021-09-20 | Fillmore | Minnesota | 27045 | 1968 | 10 |
1733488 | 1733488 | 2021-09-19 | Fillmore | Minnesota | 27045 | 1947 | 10 |
1730238 | 1730238 | 2021-09-18 | Fillmore | Minnesota | 27045 | 1947 | 10 |
1726988 | 1726988 | 2021-09-17 | Fillmore | Minnesota | 27045 | 1947 | 10 |
1723739 | 1723739 | 2021-09-16 | Fillmore | Minnesota | 27045 | 1937 | 10 |
1720490 | 1720490 | 2021-09-15 | Fillmore | Minnesota | 27045 | 1907 | 10 |
1717242 | 1717242 | 2021-09-14 | Fillmore | Minnesota | 27045 | 1894 | 10 |
1713994 | 1713994 | 2021-09-13 | Fillmore | Minnesota | 27045 | 1865 | 10 |
1710748 | 1710748 | 2021-09-12 | Fillmore | Minnesota | 27045 | 1843 | 10 |
1707501 | 1707501 | 2021-09-11 | Fillmore | Minnesota | 27045 | 1843 | 10 |
1704254 | 1704254 | 2021-09-10 | Fillmore | Minnesota | 27045 | 1843 | 10 |
1701004 | 1701004 | 2021-09-09 | Fillmore | Minnesota | 27045 | 1833 | 10 |
1697755 | 1697755 | 2021-09-08 | Fillmore | Minnesota | 27045 | 1825 | 10 |
1694507 | 1694507 | 2021-09-07 | Fillmore | Minnesota | 27045 | 1803 | 10 |
1691258 | 1691258 | 2021-09-06 | Fillmore | Minnesota | 27045 | 1798 | 10 |
1688008 | 1688008 | 2021-09-05 | Fillmore | Minnesota | 27045 | 1798 | 10 |
1684758 | 1684758 | 2021-09-04 | Fillmore | Minnesota | 27045 | 1798 | 10 |
1681507 | 1681507 | 2021-09-03 | Fillmore | Minnesota | 27045 | 1798 | 10 |
1678259 | 1678259 | 2021-09-02 | Fillmore | Minnesota | 27045 | 1790 | 10 |
1675011 | 1675011 | 2021-09-01 | Fillmore | Minnesota | 27045 | 1786 | 10 |
1671763 | 1671763 | 2021-08-31 | Fillmore | Minnesota | 27045 | 1783 | 10 |
1668516 | 1668516 | 2021-08-30 | Fillmore | Minnesota | 27045 | 1767 | 10 |
1665269 | 1665269 | 2021-08-29 | Fillmore | Minnesota | 27045 | 1758 | 10 |
1662021 | 1662021 | 2021-08-28 | Fillmore | Minnesota | 27045 | 1758 | 10 |
1658773 | 1658773 | 2021-08-27 | Fillmore | Minnesota | 27045 | 1758 | 10 |
1655524 | 1655524 | 2021-08-26 | Fillmore | Minnesota | 27045 | 1747 | 10 |
1652277 | 1652277 | 2021-08-25 | Fillmore | Minnesota | 27045 | 1739 | 10 |
1649029 | 1649029 | 2021-08-24 | Fillmore | Minnesota | 27045 | 1736 | 10 |
1645780 | 1645780 | 2021-08-23 | Fillmore | Minnesota | 27045 | 1722 | 10 |
1642531 | 1642531 | 2021-08-22 | Fillmore | Minnesota | 27045 | 1716 | 10 |
1639281 | 1639281 | 2021-08-21 | Fillmore | Minnesota | 27045 | 1716 | 10 |
1636031 | 1636031 | 2021-08-20 | Fillmore | Minnesota | 27045 | 1716 | 10 |
1632781 | 1632781 | 2021-08-19 | Fillmore | Minnesota | 27045 | 1706 | 10 |
1629534 | 1629534 | 2021-08-18 | Fillmore | Minnesota | 27045 | 1700 | 10 |
1626287 | 1626287 | 2021-08-17 | Fillmore | Minnesota | 27045 | 1699 | 10 |
1623040 | 1623040 | 2021-08-16 | Fillmore | Minnesota | 27045 | 1682 | 10 |
1619793 | 1619793 | 2021-08-15 | Fillmore | Minnesota | 27045 | 1674 | 10 |
1616545 | 1616545 | 2021-08-14 | Fillmore | Minnesota | 27045 | 1674 | 10 |
1613297 | 1613297 | 2021-08-13 | Fillmore | Minnesota | 27045 | 1674 | 10 |
1610048 | 1610048 | 2021-08-12 | Fillmore | Minnesota | 27045 | 1669 | 10 |
1606800 | 1606800 | 2021-08-11 | Fillmore | Minnesota | 27045 | 1663 | 10 |
1603551 | 1603551 | 2021-08-10 | Fillmore | Minnesota | 27045 | 1657 | 10 |
1600302 | 1600302 | 2021-08-09 | Fillmore | Minnesota | 27045 | 1645 | 10 |
1597054 | 1597054 | 2021-08-08 | Fillmore | Minnesota | 27045 | 1636 | 10 |
1593805 | 1593805 | 2021-08-07 | Fillmore | Minnesota | 27045 | 1636 | 10 |
1590556 | 1590556 | 2021-08-06 | Fillmore | Minnesota | 27045 | 1636 | 10 |
1587307 | 1587307 | 2021-08-05 | Fillmore | Minnesota | 27045 | 1631 | 10 |
1584056 | 1584056 | 2021-08-04 | Fillmore | Minnesota | 27045 | 1629 | 10 |
1580807 | 1580807 | 2021-08-03 | Fillmore | Minnesota | 27045 | 1623 | 10 |
1577558 | 1577558 | 2021-08-02 | Fillmore | Minnesota | 27045 | 1606 | 10 |
1574310 | 1574310 | 2021-08-01 | Fillmore | Minnesota | 27045 | 1605 | 10 |
1571062 | 1571062 | 2021-07-31 | Fillmore | Minnesota | 27045 | 1605 | 10 |
1567814 | 1567814 | 2021-07-30 | Fillmore | Minnesota | 27045 | 1605 | 10 |
1564566 | 1564566 | 2021-07-29 | Fillmore | Minnesota | 27045 | 1601 | 10 |
1561318 | 1561318 | 2021-07-28 | Fillmore | Minnesota | 27045 | 1600 | 10 |
1558070 | 1558070 | 2021-07-27 | Fillmore | Minnesota | 27045 | 1597 | 10 |
1554823 | 1554823 | 2021-07-26 | Fillmore | Minnesota | 27045 | 1592 | 10 |
1551576 | 1551576 | 2021-07-25 | Fillmore | Minnesota | 27045 | 1589 | 10 |
1548329 | 1548329 | 2021-07-24 | Fillmore | Minnesota | 27045 | 1589 | 10 |
1545082 | 1545082 | 2021-07-23 | Fillmore | Minnesota | 27045 | 1589 | 10 |
1541834 | 1541834 | 2021-07-22 | Fillmore | Minnesota | 27045 | 1589 | 10 |
1538587 | 1538587 | 2021-07-21 | Fillmore | Minnesota | 27045 | 1589 | 10 |
1535340 | 1535340 | 2021-07-20 | Fillmore | Minnesota | 27045 | 1588 | 10 |
1532092 | 1532092 | 2021-07-19 | Fillmore | Minnesota | 27045 | 1586 | 10 |
1528845 | 1528845 | 2021-07-18 | Fillmore | Minnesota | 27045 | 1586 | 10 |
1525598 | 1525598 | 2021-07-17 | Fillmore | Minnesota | 27045 | 1586 | 10 |
1522351 | 1522351 | 2021-07-16 | Fillmore | Minnesota | 27045 | 1586 | 10 |
1519102 | 1519102 | 2021-07-15 | Fillmore | Minnesota | 27045 | 1585 | 10 |
1515855 | 1515855 | 2021-07-14 | Fillmore | Minnesota | 27045 | 1585 | 10 |
1512609 | 1512609 | 2021-07-13 | Fillmore | Minnesota | 27045 | 1585 | 10 |
1509362 | 1509362 | 2021-07-12 | Fillmore | Minnesota | 27045 | 1583 | 10 |
1506116 | 1506116 | 2021-07-11 | Fillmore | Minnesota | 27045 | 1582 | 10 |
1502870 | 1502870 | 2021-07-10 | Fillmore | Minnesota | 27045 | 1582 | 10 |
1499624 | 1499624 | 2021-07-09 | Fillmore | Minnesota | 27045 | 1582 | 10 |
1496378 | 1496378 | 2021-07-08 | Fillmore | Minnesota | 27045 | 1582 | 10 |
1493131 | 1493131 | 2021-07-07 | Fillmore | Minnesota | 27045 | 1581 | 10 |
1489884 | 1489884 | 2021-07-06 | Fillmore | Minnesota | 27045 | 1578 | 10 |
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);