ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Hennepin" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717246 | 1717246 | 2021-09-14 | Hennepin | Minnesota | 27053 | 139244 | 1849 |
1713998 | 1713998 | 2021-09-13 | Hennepin | Minnesota | 27053 | 138425 | 1849 |
1710752 | 1710752 | 2021-09-12 | Hennepin | Minnesota | 27053 | 137994 | 1847 |
1707505 | 1707505 | 2021-09-11 | Hennepin | Minnesota | 27053 | 137994 | 1847 |
1704258 | 1704258 | 2021-09-10 | Hennepin | Minnesota | 27053 | 137994 | 1847 |
1701008 | 1701008 | 2021-09-09 | Hennepin | Minnesota | 27053 | 137690 | 1844 |
1697759 | 1697759 | 2021-09-08 | Hennepin | Minnesota | 27053 | 137436 | 1843 |
1694511 | 1694511 | 2021-09-07 | Hennepin | Minnesota | 27053 | 136379 | 1843 |
1691262 | 1691262 | 2021-09-06 | Hennepin | Minnesota | 27053 | 135989 | 1839 |
1688012 | 1688012 | 2021-09-05 | Hennepin | Minnesota | 27053 | 135989 | 1839 |
1684762 | 1684762 | 2021-09-04 | Hennepin | Minnesota | 27053 | 135989 | 1839 |
1681511 | 1681511 | 2021-09-03 | Hennepin | Minnesota | 27053 | 135989 | 1839 |
1678263 | 1678263 | 2021-09-02 | Hennepin | Minnesota | 27053 | 135612 | 1838 |
1675015 | 1675015 | 2021-09-01 | Hennepin | Minnesota | 27053 | 135270 | 1835 |
1671767 | 1671767 | 2021-08-31 | Hennepin | Minnesota | 27053 | 135016 | 1833 |
1668520 | 1668520 | 2021-08-30 | Hennepin | Minnesota | 27053 | 134308 | 1830 |
1665273 | 1665273 | 2021-08-29 | Hennepin | Minnesota | 27053 | 133951 | 1829 |
1662025 | 1662025 | 2021-08-28 | Hennepin | Minnesota | 27053 | 133951 | 1829 |
1658777 | 1658777 | 2021-08-27 | Hennepin | Minnesota | 27053 | 133951 | 1829 |
1655528 | 1655528 | 2021-08-26 | Hennepin | Minnesota | 27053 | 133628 | 1829 |
1652281 | 1652281 | 2021-08-25 | Hennepin | Minnesota | 27053 | 133253 | 1828 |
1649033 | 1649033 | 2021-08-24 | Hennepin | Minnesota | 27053 | 132922 | 1827 |
1645784 | 1645784 | 2021-08-23 | Hennepin | Minnesota | 27053 | 132176 | 1826 |
1642535 | 1642535 | 2021-08-22 | Hennepin | Minnesota | 27053 | 131806 | 1825 |
1639285 | 1639285 | 2021-08-21 | Hennepin | Minnesota | 27053 | 131806 | 1825 |
1636035 | 1636035 | 2021-08-20 | Hennepin | Minnesota | 27053 | 131806 | 1825 |
1632785 | 1632785 | 2021-08-19 | Hennepin | Minnesota | 27053 | 131471 | 1821 |
1629538 | 1629538 | 2021-08-18 | Hennepin | Minnesota | 27053 | 131251 | 1819 |
1626291 | 1626291 | 2021-08-17 | Hennepin | Minnesota | 27053 | 131024 | 1819 |
1623044 | 1623044 | 2021-08-16 | Hennepin | Minnesota | 27053 | 130361 | 1816 |
1619797 | 1619797 | 2021-08-15 | Hennepin | Minnesota | 27053 | 130053 | 1814 |
1616549 | 1616549 | 2021-08-14 | Hennepin | Minnesota | 27053 | 130053 | 1814 |
1613301 | 1613301 | 2021-08-13 | Hennepin | Minnesota | 27053 | 130053 | 1814 |
1610052 | 1610052 | 2021-08-12 | Hennepin | Minnesota | 27053 | 129787 | 1813 |
1606804 | 1606804 | 2021-08-11 | Hennepin | Minnesota | 27053 | 129461 | 1811 |
1603555 | 1603555 | 2021-08-10 | Hennepin | Minnesota | 27053 | 129038 | 1811 |
1600306 | 1600306 | 2021-08-09 | Hennepin | Minnesota | 27053 | 128655 | 1811 |
1597058 | 1597058 | 2021-08-08 | Hennepin | Minnesota | 27053 | 128416 | 1809 |
1593809 | 1593809 | 2021-08-07 | Hennepin | Minnesota | 27053 | 128416 | 1809 |
1590560 | 1590560 | 2021-08-06 | Hennepin | Minnesota | 27053 | 128416 | 1809 |
1587311 | 1587311 | 2021-08-05 | Hennepin | Minnesota | 27053 | 128141 | 1807 |
1584060 | 1584060 | 2021-08-04 | Hennepin | Minnesota | 27053 | 127906 | 1807 |
1580811 | 1580811 | 2021-08-03 | Hennepin | Minnesota | 27053 | 127667 | 1805 |
1577562 | 1577562 | 2021-08-02 | Hennepin | Minnesota | 27053 | 127240 | 1805 |
1574314 | 1574314 | 2021-08-01 | Hennepin | Minnesota | 27053 | 127080 | 1803 |
1571066 | 1571066 | 2021-07-31 | Hennepin | Minnesota | 27053 | 127080 | 1803 |
1567818 | 1567818 | 2021-07-30 | Hennepin | Minnesota | 27053 | 127080 | 1803 |
1564570 | 1564570 | 2021-07-29 | Hennepin | Minnesota | 27053 | 126920 | 1801 |
1561322 | 1561322 | 2021-07-28 | Hennepin | Minnesota | 27053 | 126788 | 1800 |
1558074 | 1558074 | 2021-07-27 | Hennepin | Minnesota | 27053 | 126640 | 1800 |
1554827 | 1554827 | 2021-07-26 | Hennepin | Minnesota | 27053 | 126348 | 1799 |
1551580 | 1551580 | 2021-07-25 | Hennepin | Minnesota | 27053 | 126249 | 1796 |
1548333 | 1548333 | 2021-07-24 | Hennepin | Minnesota | 27053 | 126249 | 1796 |
1545086 | 1545086 | 2021-07-23 | Hennepin | Minnesota | 27053 | 126249 | 1796 |
1541838 | 1541838 | 2021-07-22 | Hennepin | Minnesota | 27053 | 126163 | 1795 |
1538591 | 1538591 | 2021-07-21 | Hennepin | Minnesota | 27053 | 126079 | 1794 |
1535344 | 1535344 | 2021-07-20 | Hennepin | Minnesota | 27053 | 126010 | 1794 |
1532096 | 1532096 | 2021-07-19 | Hennepin | Minnesota | 27053 | 125842 | 1794 |
1528849 | 1528849 | 2021-07-18 | Hennepin | Minnesota | 27053 | 125762 | 1794 |
1525602 | 1525602 | 2021-07-17 | Hennepin | Minnesota | 27053 | 125762 | 1794 |
1522355 | 1522355 | 2021-07-16 | Hennepin | Minnesota | 27053 | 125762 | 1794 |
1519106 | 1519106 | 2021-07-15 | Hennepin | Minnesota | 27053 | 125699 | 1793 |
1515859 | 1515859 | 2021-07-14 | Hennepin | Minnesota | 27053 | 125657 | 1793 |
1512613 | 1512613 | 2021-07-13 | Hennepin | Minnesota | 27053 | 125597 | 1793 |
1509366 | 1509366 | 2021-07-12 | Hennepin | Minnesota | 27053 | 125490 | 1792 |
1506120 | 1506120 | 2021-07-11 | Hennepin | Minnesota | 27053 | 125434 | 1791 |
1502874 | 1502874 | 2021-07-10 | Hennepin | Minnesota | 27053 | 125434 | 1791 |
1499628 | 1499628 | 2021-07-09 | Hennepin | Minnesota | 27053 | 125434 | 1791 |
1496382 | 1496382 | 2021-07-08 | Hennepin | Minnesota | 27053 | 125397 | 1791 |
1493135 | 1493135 | 2021-07-07 | Hennepin | Minnesota | 27053 | 125367 | 1791 |
1489888 | 1489888 | 2021-07-06 | Hennepin | Minnesota | 27053 | 125311 | 1791 |
1486641 | 1486641 | 2021-07-05 | Hennepin | Minnesota | 27053 | 125276 | 1790 |
1483395 | 1483395 | 2021-07-04 | Hennepin | Minnesota | 27053 | 125276 | 1790 |
1480149 | 1480149 | 2021-07-03 | Hennepin | Minnesota | 27053 | 125276 | 1790 |
1476902 | 1476902 | 2021-07-02 | Hennepin | Minnesota | 27053 | 125243 | 1789 |
1473656 | 1473656 | 2021-07-01 | Hennepin | Minnesota | 27053 | 125221 | 1788 |
1470410 | 1470410 | 2021-06-30 | Hennepin | Minnesota | 27053 | 125204 | 1788 |
1467165 | 1467165 | 2021-06-29 | Hennepin | Minnesota | 27053 | 125181 | 1787 |
1463920 | 1463920 | 2021-06-28 | Hennepin | Minnesota | 27053 | 125156 | 1788 |
1460675 | 1460675 | 2021-06-27 | Hennepin | Minnesota | 27053 | 125125 | 1785 |
1457430 | 1457430 | 2021-06-26 | Hennepin | Minnesota | 27053 | 125100 | 1785 |
1454185 | 1454185 | 2021-06-25 | Hennepin | Minnesota | 27053 | 125080 | 1785 |
1450940 | 1450940 | 2021-06-24 | Hennepin | Minnesota | 27053 | 125051 | 1781 |
1447694 | 1447694 | 2021-06-23 | Hennepin | Minnesota | 27053 | 125027 | 1781 |
1444449 | 1444449 | 2021-06-22 | Hennepin | Minnesota | 27053 | 125016 | 1780 |
1441204 | 1441204 | 2021-06-21 | Hennepin | Minnesota | 27053 | 124994 | 1780 |
1437958 | 1437958 | 2021-06-20 | Hennepin | Minnesota | 27053 | 124967 | 1779 |
1434711 | 1434711 | 2021-06-19 | Hennepin | Minnesota | 27053 | 124928 | 1777 |
1431464 | 1431464 | 2021-06-18 | Hennepin | Minnesota | 27053 | 124892 | 1775 |
1428219 | 1428219 | 2021-06-17 | Hennepin | Minnesota | 27053 | 124863 | 1774 |
1424974 | 1424974 | 2021-06-16 | Hennepin | Minnesota | 27053 | 124816 | 1773 |
1421726 | 1421726 | 2021-06-15 | Hennepin | Minnesota | 27053 | 124801 | 1773 |
1418481 | 1418481 | 2021-06-14 | Hennepin | Minnesota | 27053 | 124779 | 1772 |
1415236 | 1415236 | 2021-06-13 | Hennepin | Minnesota | 27053 | 124765 | 1771 |
1411990 | 1411990 | 2021-06-12 | Hennepin | Minnesota | 27053 | 124736 | 1769 |
1408745 | 1408745 | 2021-06-11 | Hennepin | Minnesota | 27053 | 124700 | 1767 |
1405500 | 1405500 | 2021-06-10 | Hennepin | Minnesota | 27053 | 124670 | 1763 |
1402254 | 1402254 | 2021-06-09 | Hennepin | Minnesota | 27053 | 124642 | 1762 |
1399009 | 1399009 | 2021-06-08 | Hennepin | Minnesota | 27053 | 124608 | 1762 |
1395763 | 1395763 | 2021-06-07 | Hennepin | Minnesota | 27053 | 124575 | 1761 |
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);