ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27039 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814712 | 1814712 | 2021-10-14 | Dodge | Minnesota | 27039 | 2667 | 9 |
1811464 | 1811464 | 2021-10-13 | Dodge | Minnesota | 27039 | 2655 | 9 |
1808215 | 1808215 | 2021-10-12 | Dodge | Minnesota | 27039 | 2646 | 9 |
1804964 | 1804964 | 2021-10-11 | Dodge | Minnesota | 27039 | 2614 | 9 |
1801715 | 1801715 | 2021-10-10 | Dodge | Minnesota | 27039 | 2604 | 8 |
1798466 | 1798466 | 2021-10-09 | Dodge | Minnesota | 27039 | 2604 | 8 |
1795217 | 1795217 | 2021-10-08 | Dodge | Minnesota | 27039 | 2604 | 8 |
1791968 | 1791968 | 2021-10-07 | Dodge | Minnesota | 27039 | 2598 | 8 |
1788719 | 1788719 | 2021-10-06 | Dodge | Minnesota | 27039 | 2591 | 7 |
1785471 | 1785471 | 2021-10-05 | Dodge | Minnesota | 27039 | 2588 | 6 |
1782222 | 1782222 | 2021-10-04 | Dodge | Minnesota | 27039 | 2561 | 6 |
1778972 | 1778972 | 2021-10-03 | Dodge | Minnesota | 27039 | 2544 | 5 |
1775722 | 1775722 | 2021-10-02 | Dodge | Minnesota | 27039 | 2544 | 5 |
1772472 | 1772472 | 2021-10-01 | Dodge | Minnesota | 27039 | 2544 | 5 |
1769223 | 1769223 | 2021-09-30 | Dodge | Minnesota | 27039 | 2537 | 5 |
1765974 | 1765974 | 2021-09-29 | Dodge | Minnesota | 27039 | 2532 | 5 |
1762725 | 1762725 | 2021-09-28 | Dodge | Minnesota | 27039 | 2527 | 5 |
1759476 | 1759476 | 2021-09-27 | Dodge | Minnesota | 27039 | 2503 | 5 |
1756228 | 1756228 | 2021-09-26 | Dodge | Minnesota | 27039 | 2486 | 5 |
1752980 | 1752980 | 2021-09-25 | Dodge | Minnesota | 27039 | 2486 | 5 |
1749732 | 1749732 | 2021-09-24 | Dodge | Minnesota | 27039 | 2486 | 5 |
1746482 | 1746482 | 2021-09-23 | Dodge | Minnesota | 27039 | 2475 | 5 |
1743233 | 1743233 | 2021-09-22 | Dodge | Minnesota | 27039 | 2465 | 5 |
1739984 | 1739984 | 2021-09-21 | Dodge | Minnesota | 27039 | 2457 | 5 |
1736735 | 1736735 | 2021-09-20 | Dodge | Minnesota | 27039 | 2422 | 4 |
1733485 | 1733485 | 2021-09-19 | Dodge | Minnesota | 27039 | 2406 | 4 |
1730235 | 1730235 | 2021-09-18 | Dodge | Minnesota | 27039 | 2406 | 4 |
1726985 | 1726985 | 2021-09-17 | Dodge | Minnesota | 27039 | 2406 | 4 |
1723736 | 1723736 | 2021-09-16 | Dodge | Minnesota | 27039 | 2396 | 4 |
1720487 | 1720487 | 2021-09-15 | Dodge | Minnesota | 27039 | 2383 | 3 |
1717239 | 1717239 | 2021-09-14 | Dodge | Minnesota | 27039 | 2369 | 3 |
1713991 | 1713991 | 2021-09-13 | Dodge | Minnesota | 27039 | 2343 | 3 |
1710745 | 1710745 | 2021-09-12 | Dodge | Minnesota | 27039 | 2338 | 3 |
1707498 | 1707498 | 2021-09-11 | Dodge | Minnesota | 27039 | 2338 | 3 |
1704251 | 1704251 | 2021-09-10 | Dodge | Minnesota | 27039 | 2338 | 3 |
1701001 | 1701001 | 2021-09-09 | Dodge | Minnesota | 27039 | 2316 | 3 |
1697752 | 1697752 | 2021-09-08 | Dodge | Minnesota | 27039 | 2311 | 3 |
1694504 | 1694504 | 2021-09-07 | Dodge | Minnesota | 27039 | 2273 | 3 |
1691255 | 1691255 | 2021-09-06 | Dodge | Minnesota | 27039 | 2265 | 3 |
1688005 | 1688005 | 2021-09-05 | Dodge | Minnesota | 27039 | 2265 | 3 |
1684755 | 1684755 | 2021-09-04 | Dodge | Minnesota | 27039 | 2265 | 3 |
1681504 | 1681504 | 2021-09-03 | Dodge | Minnesota | 27039 | 2265 | 3 |
1678256 | 1678256 | 2021-09-02 | Dodge | Minnesota | 27039 | 2245 | 3 |
1675008 | 1675008 | 2021-09-01 | Dodge | Minnesota | 27039 | 2213 | 3 |
1671760 | 1671760 | 2021-08-31 | Dodge | Minnesota | 27039 | 2204 | 3 |
1668513 | 1668513 | 2021-08-30 | Dodge | Minnesota | 27039 | 2172 | 3 |
1665266 | 1665266 | 2021-08-29 | Dodge | Minnesota | 27039 | 2153 | 3 |
1662018 | 1662018 | 2021-08-28 | Dodge | Minnesota | 27039 | 2153 | 3 |
1658770 | 1658770 | 2021-08-27 | Dodge | Minnesota | 27039 | 2153 | 3 |
1655521 | 1655521 | 2021-08-26 | Dodge | Minnesota | 27039 | 2137 | 3 |
1652274 | 1652274 | 2021-08-25 | Dodge | Minnesota | 27039 | 2122 | 3 |
1649026 | 1649026 | 2021-08-24 | Dodge | Minnesota | 27039 | 2120 | 3 |
1645777 | 1645777 | 2021-08-23 | Dodge | Minnesota | 27039 | 2079 | 3 |
1642528 | 1642528 | 2021-08-22 | Dodge | Minnesota | 27039 | 2068 | 3 |
1639278 | 1639278 | 2021-08-21 | Dodge | Minnesota | 27039 | 2068 | 3 |
1636028 | 1636028 | 2021-08-20 | Dodge | Minnesota | 27039 | 2068 | 3 |
1632778 | 1632778 | 2021-08-19 | Dodge | Minnesota | 27039 | 2051 | 3 |
1629531 | 1629531 | 2021-08-18 | Dodge | Minnesota | 27039 | 2044 | 3 |
1626284 | 1626284 | 2021-08-17 | Dodge | Minnesota | 27039 | 2042 | 3 |
1623037 | 1623037 | 2021-08-16 | Dodge | Minnesota | 27039 | 2015 | 3 |
1619790 | 1619790 | 2021-08-15 | Dodge | Minnesota | 27039 | 2003 | 3 |
1616542 | 1616542 | 2021-08-14 | Dodge | Minnesota | 27039 | 2003 | 3 |
1613294 | 1613294 | 2021-08-13 | Dodge | Minnesota | 27039 | 2003 | 3 |
1610045 | 1610045 | 2021-08-12 | Dodge | Minnesota | 27039 | 1999 | 3 |
1606797 | 1606797 | 2021-08-11 | Dodge | Minnesota | 27039 | 1996 | 3 |
1603548 | 1603548 | 2021-08-10 | Dodge | Minnesota | 27039 | 1983 | 3 |
1600299 | 1600299 | 2021-08-09 | Dodge | Minnesota | 27039 | 1964 | 3 |
1597051 | 1597051 | 2021-08-08 | Dodge | Minnesota | 27039 | 1957 | 3 |
1593802 | 1593802 | 2021-08-07 | Dodge | Minnesota | 27039 | 1957 | 3 |
1590553 | 1590553 | 2021-08-06 | Dodge | Minnesota | 27039 | 1957 | 3 |
1587304 | 1587304 | 2021-08-05 | Dodge | Minnesota | 27039 | 1949 | 3 |
1584053 | 1584053 | 2021-08-04 | Dodge | Minnesota | 27039 | 1939 | 3 |
1580804 | 1580804 | 2021-08-03 | Dodge | Minnesota | 27039 | 1938 | 3 |
1577555 | 1577555 | 2021-08-02 | Dodge | Minnesota | 27039 | 1924 | 3 |
1574307 | 1574307 | 2021-08-01 | Dodge | Minnesota | 27039 | 1917 | 3 |
1571059 | 1571059 | 2021-07-31 | Dodge | Minnesota | 27039 | 1917 | 3 |
1567811 | 1567811 | 2021-07-30 | Dodge | Minnesota | 27039 | 1917 | 3 |
1564563 | 1564563 | 2021-07-29 | Dodge | Minnesota | 27039 | 1913 | 3 |
1561315 | 1561315 | 2021-07-28 | Dodge | Minnesota | 27039 | 1905 | 3 |
1558067 | 1558067 | 2021-07-27 | Dodge | Minnesota | 27039 | 1902 | 3 |
1554820 | 1554820 | 2021-07-26 | Dodge | Minnesota | 27039 | 1897 | 3 |
1551573 | 1551573 | 2021-07-25 | Dodge | Minnesota | 27039 | 1894 | 3 |
1548326 | 1548326 | 2021-07-24 | Dodge | Minnesota | 27039 | 1894 | 3 |
1545079 | 1545079 | 2021-07-23 | Dodge | Minnesota | 27039 | 1894 | 3 |
1541831 | 1541831 | 2021-07-22 | Dodge | Minnesota | 27039 | 1888 | 3 |
1538584 | 1538584 | 2021-07-21 | Dodge | Minnesota | 27039 | 1886 | 3 |
1535337 | 1535337 | 2021-07-20 | Dodge | Minnesota | 27039 | 1886 | 3 |
1532089 | 1532089 | 2021-07-19 | Dodge | Minnesota | 27039 | 1885 | 3 |
1528842 | 1528842 | 2021-07-18 | Dodge | Minnesota | 27039 | 1882 | 3 |
1525595 | 1525595 | 2021-07-17 | Dodge | Minnesota | 27039 | 1882 | 3 |
1522348 | 1522348 | 2021-07-16 | Dodge | Minnesota | 27039 | 1882 | 3 |
1519099 | 1519099 | 2021-07-15 | Dodge | Minnesota | 27039 | 1882 | 3 |
1515852 | 1515852 | 2021-07-14 | Dodge | Minnesota | 27039 | 1882 | 3 |
1512606 | 1512606 | 2021-07-13 | Dodge | Minnesota | 27039 | 1882 | 3 |
1509359 | 1509359 | 2021-07-12 | Dodge | Minnesota | 27039 | 1878 | 3 |
1506113 | 1506113 | 2021-07-11 | Dodge | Minnesota | 27039 | 1878 | 3 |
1502867 | 1502867 | 2021-07-10 | Dodge | Minnesota | 27039 | 1878 | 3 |
1499621 | 1499621 | 2021-07-09 | Dodge | Minnesota | 27039 | 1878 | 3 |
1496375 | 1496375 | 2021-07-08 | Dodge | Minnesota | 27039 | 1877 | 3 |
1493128 | 1493128 | 2021-07-07 | Dodge | Minnesota | 27039 | 1877 | 3 |
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);