ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 27037 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811463 | 1811463 | 2021-10-13 | Dakota | Minnesota | 27037 | 55791 | 517 |
1808214 | 1808214 | 2021-10-12 | Dakota | Minnesota | 27037 | 55649 | 514 |
1804963 | 1804963 | 2021-10-11 | Dakota | Minnesota | 27037 | 55244 | 513 |
1801714 | 1801714 | 2021-10-10 | Dakota | Minnesota | 27037 | 55074 | 512 |
1798465 | 1798465 | 2021-10-09 | Dakota | Minnesota | 27037 | 55074 | 512 |
1795216 | 1795216 | 2021-10-08 | Dakota | Minnesota | 27037 | 55074 | 512 |
1791967 | 1791967 | 2021-10-07 | Dakota | Minnesota | 27037 | 54901 | 512 |
1788718 | 1788718 | 2021-10-06 | Dakota | Minnesota | 27037 | 54744 | 512 |
1785470 | 1785470 | 2021-10-05 | Dakota | Minnesota | 27037 | 54525 | 509 |
1782221 | 1782221 | 2021-10-04 | Dakota | Minnesota | 27037 | 54178 | 508 |
1778971 | 1778971 | 2021-10-03 | Dakota | Minnesota | 27037 | 54027 | 507 |
1775721 | 1775721 | 2021-10-02 | Dakota | Minnesota | 27037 | 54027 | 507 |
1772471 | 1772471 | 2021-10-01 | Dakota | Minnesota | 27037 | 54027 | 507 |
1769222 | 1769222 | 2021-09-30 | Dakota | Minnesota | 27037 | 53805 | 505 |
1765973 | 1765973 | 2021-09-29 | Dakota | Minnesota | 27037 | 53666 | 504 |
1762724 | 1762724 | 2021-09-28 | Dakota | Minnesota | 27037 | 53557 | 503 |
1759475 | 1759475 | 2021-09-27 | Dakota | Minnesota | 27037 | 53221 | 503 |
1756227 | 1756227 | 2021-09-26 | Dakota | Minnesota | 27037 | 53075 | 503 |
1752979 | 1752979 | 2021-09-25 | Dakota | Minnesota | 27037 | 53075 | 503 |
1749731 | 1749731 | 2021-09-24 | Dakota | Minnesota | 27037 | 53075 | 503 |
1746481 | 1746481 | 2021-09-23 | Dakota | Minnesota | 27037 | 52926 | 503 |
1743232 | 1743232 | 2021-09-22 | Dakota | Minnesota | 27037 | 52802 | 499 |
1739983 | 1739983 | 2021-09-21 | Dakota | Minnesota | 27037 | 52670 | 498 |
1736734 | 1736734 | 2021-09-20 | Dakota | Minnesota | 27037 | 52269 | 497 |
1733484 | 1733484 | 2021-09-19 | Dakota | Minnesota | 27037 | 52093 | 497 |
1730234 | 1730234 | 2021-09-18 | Dakota | Minnesota | 27037 | 52093 | 497 |
1726984 | 1726984 | 2021-09-17 | Dakota | Minnesota | 27037 | 52093 | 497 |
1723735 | 1723735 | 2021-09-16 | Dakota | Minnesota | 27037 | 51924 | 496 |
1720486 | 1720486 | 2021-09-15 | Dakota | Minnesota | 27037 | 51771 | 493 |
1717238 | 1717238 | 2021-09-14 | Dakota | Minnesota | 27037 | 51562 | 493 |
1713990 | 1713990 | 2021-09-13 | Dakota | Minnesota | 27037 | 51238 | 492 |
1710744 | 1710744 | 2021-09-12 | Dakota | Minnesota | 27037 | 51080 | 491 |
1707497 | 1707497 | 2021-09-11 | Dakota | Minnesota | 27037 | 51080 | 491 |
1704250 | 1704250 | 2021-09-10 | Dakota | Minnesota | 27037 | 51080 | 491 |
1701000 | 1701000 | 2021-09-09 | Dakota | Minnesota | 27037 | 50958 | 490 |
1697751 | 1697751 | 2021-09-08 | Dakota | Minnesota | 27037 | 50888 | 490 |
1694503 | 1694503 | 2021-09-07 | Dakota | Minnesota | 27037 | 50485 | 489 |
1691254 | 1691254 | 2021-09-06 | Dakota | Minnesota | 27037 | 50330 | 489 |
1688004 | 1688004 | 2021-09-05 | Dakota | Minnesota | 27037 | 50330 | 489 |
1684754 | 1684754 | 2021-09-04 | Dakota | Minnesota | 27037 | 50330 | 489 |
1681503 | 1681503 | 2021-09-03 | Dakota | Minnesota | 27037 | 50330 | 489 |
1678255 | 1678255 | 2021-09-02 | Dakota | Minnesota | 27037 | 50199 | 489 |
1675007 | 1675007 | 2021-09-01 | Dakota | Minnesota | 27037 | 50075 | 487 |
1671759 | 1671759 | 2021-08-31 | Dakota | Minnesota | 27037 | 49977 | 487 |
1668512 | 1668512 | 2021-08-30 | Dakota | Minnesota | 27037 | 49736 | 486 |
1665265 | 1665265 | 2021-08-29 | Dakota | Minnesota | 27037 | 49599 | 486 |
1662017 | 1662017 | 2021-08-28 | Dakota | Minnesota | 27037 | 49599 | 486 |
1658769 | 1658769 | 2021-08-27 | Dakota | Minnesota | 27037 | 49599 | 486 |
1655520 | 1655520 | 2021-08-26 | Dakota | Minnesota | 27037 | 49480 | 486 |
1652273 | 1652273 | 2021-08-25 | Dakota | Minnesota | 27037 | 49366 | 484 |
1649025 | 1649025 | 2021-08-24 | Dakota | Minnesota | 27037 | 49261 | 484 |
1645776 | 1645776 | 2021-08-23 | Dakota | Minnesota | 27037 | 49018 | 484 |
1642527 | 1642527 | 2021-08-22 | Dakota | Minnesota | 27037 | 48913 | 483 |
1639277 | 1639277 | 2021-08-21 | Dakota | Minnesota | 27037 | 48913 | 483 |
1636027 | 1636027 | 2021-08-20 | Dakota | Minnesota | 27037 | 48913 | 483 |
1632777 | 1632777 | 2021-08-19 | Dakota | Minnesota | 27037 | 48837 | 483 |
1629530 | 1629530 | 2021-08-18 | Dakota | Minnesota | 27037 | 48754 | 483 |
1626283 | 1626283 | 2021-08-17 | Dakota | Minnesota | 27037 | 48654 | 483 |
1623036 | 1623036 | 2021-08-16 | Dakota | Minnesota | 27037 | 48451 | 483 |
1619789 | 1619789 | 2021-08-15 | Dakota | Minnesota | 27037 | 48330 | 482 |
1616541 | 1616541 | 2021-08-14 | Dakota | Minnesota | 27037 | 48330 | 482 |
1613293 | 1613293 | 2021-08-13 | Dakota | Minnesota | 27037 | 48330 | 482 |
1610044 | 1610044 | 2021-08-12 | Dakota | Minnesota | 27037 | 48254 | 482 |
1606796 | 1606796 | 2021-08-11 | Dakota | Minnesota | 27037 | 48163 | 481 |
1603547 | 1603547 | 2021-08-10 | Dakota | Minnesota | 27037 | 48040 | 480 |
1600298 | 1600298 | 2021-08-09 | Dakota | Minnesota | 27037 | 47926 | 480 |
1597050 | 1597050 | 2021-08-08 | Dakota | Minnesota | 27037 | 47845 | 480 |
1593801 | 1593801 | 2021-08-07 | Dakota | Minnesota | 27037 | 47845 | 480 |
1590552 | 1590552 | 2021-08-06 | Dakota | Minnesota | 27037 | 47845 | 480 |
1587303 | 1587303 | 2021-08-05 | Dakota | Minnesota | 27037 | 47792 | 479 |
1584052 | 1584052 | 2021-08-04 | Dakota | Minnesota | 27037 | 47738 | 479 |
1580803 | 1580803 | 2021-08-03 | Dakota | Minnesota | 27037 | 47636 | 477 |
1577554 | 1577554 | 2021-08-02 | Dakota | Minnesota | 27037 | 47517 | 477 |
1574306 | 1574306 | 2021-08-01 | Dakota | Minnesota | 27037 | 47466 | 477 |
1571058 | 1571058 | 2021-07-31 | Dakota | Minnesota | 27037 | 47466 | 477 |
1567810 | 1567810 | 2021-07-30 | Dakota | Minnesota | 27037 | 47466 | 477 |
1564562 | 1564562 | 2021-07-29 | Dakota | Minnesota | 27037 | 47414 | 477 |
1561314 | 1561314 | 2021-07-28 | Dakota | Minnesota | 27037 | 47375 | 477 |
1558066 | 1558066 | 2021-07-27 | Dakota | Minnesota | 27037 | 47328 | 475 |
1554819 | 1554819 | 2021-07-26 | Dakota | Minnesota | 27037 | 47251 | 475 |
1551572 | 1551572 | 2021-07-25 | Dakota | Minnesota | 27037 | 47216 | 475 |
1548325 | 1548325 | 2021-07-24 | Dakota | Minnesota | 27037 | 47216 | 475 |
1545078 | 1545078 | 2021-07-23 | Dakota | Minnesota | 27037 | 47216 | 475 |
1541830 | 1541830 | 2021-07-22 | Dakota | Minnesota | 27037 | 47198 | 475 |
1538583 | 1538583 | 2021-07-21 | Dakota | Minnesota | 27037 | 47173 | 475 |
1535336 | 1535336 | 2021-07-20 | Dakota | Minnesota | 27037 | 47153 | 475 |
1532088 | 1532088 | 2021-07-19 | Dakota | Minnesota | 27037 | 47097 | 475 |
1528841 | 1528841 | 2021-07-18 | Dakota | Minnesota | 27037 | 47074 | 475 |
1525594 | 1525594 | 2021-07-17 | Dakota | Minnesota | 27037 | 47074 | 475 |
1522347 | 1522347 | 2021-07-16 | Dakota | Minnesota | 27037 | 47074 | 475 |
1519098 | 1519098 | 2021-07-15 | Dakota | Minnesota | 27037 | 47061 | 475 |
1515851 | 1515851 | 2021-07-14 | Dakota | Minnesota | 27037 | 47046 | 475 |
1512605 | 1512605 | 2021-07-13 | Dakota | Minnesota | 27037 | 47031 | 475 |
1509358 | 1509358 | 2021-07-12 | Dakota | Minnesota | 27037 | 47002 | 475 |
1506112 | 1506112 | 2021-07-11 | Dakota | Minnesota | 27037 | 46986 | 475 |
1502866 | 1502866 | 2021-07-10 | Dakota | Minnesota | 27037 | 46986 | 475 |
1499620 | 1499620 | 2021-07-09 | Dakota | Minnesota | 27037 | 46986 | 475 |
1496374 | 1496374 | 2021-07-08 | Dakota | Minnesota | 27037 | 46975 | 474 |
1493127 | 1493127 | 2021-07-07 | Dakota | Minnesota | 27037 | 46964 | 474 |
1489880 | 1489880 | 2021-07-06 | Dakota | Minnesota | 27037 | 46947 | 474 |
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);