ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 27027 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814706 | 1814706 | 2021-10-14 | Clay | Minnesota | 27027 | 10010 | 98 |
1811458 | 1811458 | 2021-10-13 | Clay | Minnesota | 27027 | 9961 | 98 |
1808209 | 1808209 | 2021-10-12 | Clay | Minnesota | 27027 | 9934 | 98 |
1804958 | 1804958 | 2021-10-11 | Clay | Minnesota | 27027 | 9823 | 98 |
1801709 | 1801709 | 2021-10-10 | Clay | Minnesota | 27027 | 9798 | 98 |
1798460 | 1798460 | 2021-10-09 | Clay | Minnesota | 27027 | 9798 | 98 |
1795211 | 1795211 | 2021-10-08 | Clay | Minnesota | 27027 | 9798 | 98 |
1791962 | 1791962 | 2021-10-07 | Clay | Minnesota | 27027 | 9748 | 98 |
1788713 | 1788713 | 2021-10-06 | Clay | Minnesota | 27027 | 9702 | 98 |
1785465 | 1785465 | 2021-10-05 | Clay | Minnesota | 27027 | 9659 | 98 |
1782216 | 1782216 | 2021-10-04 | Clay | Minnesota | 27027 | 9584 | 97 |
1778966 | 1778966 | 2021-10-03 | Clay | Minnesota | 27027 | 9557 | 97 |
1775716 | 1775716 | 2021-10-02 | Clay | Minnesota | 27027 | 9557 | 97 |
1772466 | 1772466 | 2021-10-01 | Clay | Minnesota | 27027 | 9557 | 97 |
1769217 | 1769217 | 2021-09-30 | Clay | Minnesota | 27027 | 9508 | 97 |
1765968 | 1765968 | 2021-09-29 | Clay | Minnesota | 27027 | 9474 | 97 |
1762719 | 1762719 | 2021-09-28 | Clay | Minnesota | 27027 | 9433 | 97 |
1759470 | 1759470 | 2021-09-27 | Clay | Minnesota | 27027 | 9396 | 97 |
1756222 | 1756222 | 2021-09-26 | Clay | Minnesota | 27027 | 9368 | 97 |
1752974 | 1752974 | 2021-09-25 | Clay | Minnesota | 27027 | 9368 | 97 |
1749726 | 1749726 | 2021-09-24 | Clay | Minnesota | 27027 | 9368 | 97 |
1746476 | 1746476 | 2021-09-23 | Clay | Minnesota | 27027 | 9301 | 96 |
1743227 | 1743227 | 2021-09-22 | Clay | Minnesota | 27027 | 9285 | 95 |
1739978 | 1739978 | 2021-09-21 | Clay | Minnesota | 27027 | 9267 | 95 |
1736729 | 1736729 | 2021-09-20 | Clay | Minnesota | 27027 | 9171 | 95 |
1733479 | 1733479 | 2021-09-19 | Clay | Minnesota | 27027 | 9152 | 95 |
1730229 | 1730229 | 2021-09-18 | Clay | Minnesota | 27027 | 9152 | 95 |
1726979 | 1726979 | 2021-09-17 | Clay | Minnesota | 27027 | 9152 | 95 |
1723730 | 1723730 | 2021-09-16 | Clay | Minnesota | 27027 | 9120 | 95 |
1720481 | 1720481 | 2021-09-15 | Clay | Minnesota | 27027 | 9058 | 95 |
1717233 | 1717233 | 2021-09-14 | Clay | Minnesota | 27027 | 9022 | 93 |
1713985 | 1713985 | 2021-09-13 | Clay | Minnesota | 27027 | 8968 | 93 |
1710739 | 1710739 | 2021-09-12 | Clay | Minnesota | 27027 | 8919 | 93 |
1707492 | 1707492 | 2021-09-11 | Clay | Minnesota | 27027 | 8919 | 93 |
1704245 | 1704245 | 2021-09-10 | Clay | Minnesota | 27027 | 8919 | 93 |
1700995 | 1700995 | 2021-09-09 | Clay | Minnesota | 27027 | 8863 | 93 |
1697746 | 1697746 | 2021-09-08 | Clay | Minnesota | 27027 | 8833 | 93 |
1694498 | 1694498 | 2021-09-07 | Clay | Minnesota | 27027 | 8740 | 92 |
1691249 | 1691249 | 2021-09-06 | Clay | Minnesota | 27027 | 8721 | 92 |
1687999 | 1687999 | 2021-09-05 | Clay | Minnesota | 27027 | 8721 | 92 |
1684749 | 1684749 | 2021-09-04 | Clay | Minnesota | 27027 | 8721 | 92 |
1681498 | 1681498 | 2021-09-03 | Clay | Minnesota | 27027 | 8721 | 92 |
1678250 | 1678250 | 2021-09-02 | Clay | Minnesota | 27027 | 8701 | 92 |
1675002 | 1675002 | 2021-09-01 | Clay | Minnesota | 27027 | 8686 | 92 |
1671754 | 1671754 | 2021-08-31 | Clay | Minnesota | 27027 | 8666 | 92 |
1668507 | 1668507 | 2021-08-30 | Clay | Minnesota | 27027 | 8649 | 92 |
1665260 | 1665260 | 2021-08-29 | Clay | Minnesota | 27027 | 8619 | 92 |
1662012 | 1662012 | 2021-08-28 | Clay | Minnesota | 27027 | 8619 | 92 |
1658764 | 1658764 | 2021-08-27 | Clay | Minnesota | 27027 | 8619 | 92 |
1655515 | 1655515 | 2021-08-26 | Clay | Minnesota | 27027 | 8594 | 92 |
1652268 | 1652268 | 2021-08-25 | Clay | Minnesota | 27027 | 8567 | 92 |
1649020 | 1649020 | 2021-08-24 | Clay | Minnesota | 27027 | 8548 | 92 |
1645771 | 1645771 | 2021-08-23 | Clay | Minnesota | 27027 | 8489 | 92 |
1642522 | 1642522 | 2021-08-22 | Clay | Minnesota | 27027 | 8474 | 92 |
1639272 | 1639272 | 2021-08-21 | Clay | Minnesota | 27027 | 8474 | 92 |
1636022 | 1636022 | 2021-08-20 | Clay | Minnesota | 27027 | 8474 | 92 |
1632772 | 1632772 | 2021-08-19 | Clay | Minnesota | 27027 | 8453 | 92 |
1629525 | 1629525 | 2021-08-18 | Clay | Minnesota | 27027 | 8424 | 92 |
1626278 | 1626278 | 2021-08-17 | Clay | Minnesota | 27027 | 8411 | 92 |
1623031 | 1623031 | 2021-08-16 | Clay | Minnesota | 27027 | 8393 | 92 |
1619784 | 1619784 | 2021-08-15 | Clay | Minnesota | 27027 | 8379 | 92 |
1616536 | 1616536 | 2021-08-14 | Clay | Minnesota | 27027 | 8379 | 92 |
1613288 | 1613288 | 2021-08-13 | Clay | Minnesota | 27027 | 8379 | 92 |
1610039 | 1610039 | 2021-08-12 | Clay | Minnesota | 27027 | 8372 | 92 |
1606791 | 1606791 | 2021-08-11 | Clay | Minnesota | 27027 | 8360 | 92 |
1603542 | 1603542 | 2021-08-10 | Clay | Minnesota | 27027 | 8351 | 92 |
1600293 | 1600293 | 2021-08-09 | Clay | Minnesota | 27027 | 8334 | 92 |
1597045 | 1597045 | 2021-08-08 | Clay | Minnesota | 27027 | 8330 | 92 |
1593796 | 1593796 | 2021-08-07 | Clay | Minnesota | 27027 | 8330 | 92 |
1590547 | 1590547 | 2021-08-06 | Clay | Minnesota | 27027 | 8330 | 92 |
1587298 | 1587298 | 2021-08-05 | Clay | Minnesota | 27027 | 8322 | 92 |
1584047 | 1584047 | 2021-08-04 | Clay | Minnesota | 27027 | 8318 | 92 |
1580798 | 1580798 | 2021-08-03 | Clay | Minnesota | 27027 | 8315 | 92 |
1577549 | 1577549 | 2021-08-02 | Clay | Minnesota | 27027 | 8310 | 92 |
1574301 | 1574301 | 2021-08-01 | Clay | Minnesota | 27027 | 8307 | 92 |
1571053 | 1571053 | 2021-07-31 | Clay | Minnesota | 27027 | 8307 | 92 |
1567805 | 1567805 | 2021-07-30 | Clay | Minnesota | 27027 | 8307 | 92 |
1564557 | 1564557 | 2021-07-29 | Clay | Minnesota | 27027 | 8304 | 92 |
1561309 | 1561309 | 2021-07-28 | Clay | Minnesota | 27027 | 8301 | 92 |
1558061 | 1558061 | 2021-07-27 | Clay | Minnesota | 27027 | 8296 | 92 |
1554814 | 1554814 | 2021-07-26 | Clay | Minnesota | 27027 | 8296 | 92 |
1551567 | 1551567 | 2021-07-25 | Clay | Minnesota | 27027 | 8296 | 92 |
1548320 | 1548320 | 2021-07-24 | Clay | Minnesota | 27027 | 8296 | 92 |
1545073 | 1545073 | 2021-07-23 | Clay | Minnesota | 27027 | 8296 | 92 |
1541825 | 1541825 | 2021-07-22 | Clay | Minnesota | 27027 | 8293 | 92 |
1538578 | 1538578 | 2021-07-21 | Clay | Minnesota | 27027 | 8292 | 92 |
1535331 | 1535331 | 2021-07-20 | Clay | Minnesota | 27027 | 8292 | 92 |
1532083 | 1532083 | 2021-07-19 | Clay | Minnesota | 27027 | 8290 | 92 |
1528836 | 1528836 | 2021-07-18 | Clay | Minnesota | 27027 | 8285 | 92 |
1525589 | 1525589 | 2021-07-17 | Clay | Minnesota | 27027 | 8285 | 92 |
1522342 | 1522342 | 2021-07-16 | Clay | Minnesota | 27027 | 8285 | 92 |
1519093 | 1519093 | 2021-07-15 | Clay | Minnesota | 27027 | 8282 | 92 |
1515846 | 1515846 | 2021-07-14 | Clay | Minnesota | 27027 | 8280 | 92 |
1512600 | 1512600 | 2021-07-13 | Clay | Minnesota | 27027 | 8279 | 92 |
1509353 | 1509353 | 2021-07-12 | Clay | Minnesota | 27027 | 8277 | 92 |
1506107 | 1506107 | 2021-07-11 | Clay | Minnesota | 27027 | 8276 | 92 |
1502861 | 1502861 | 2021-07-10 | Clay | Minnesota | 27027 | 8276 | 92 |
1499615 | 1499615 | 2021-07-09 | Clay | Minnesota | 27027 | 8276 | 92 |
1496369 | 1496369 | 2021-07-08 | Clay | Minnesota | 27027 | 8276 | 92 |
1493122 | 1493122 | 2021-07-07 | Clay | Minnesota | 27027 | 8276 | 92 |
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);