ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where county = "Clearwater", deaths = 18 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1892688 | 1892688 | 2021-11-07 | Clearwater | Minnesota | 27029 | 1431 | 18 |
1889438 | 1889438 | 2021-11-06 | Clearwater | Minnesota | 27029 | 1431 | 18 |
1886188 | 1886188 | 2021-11-05 | Clearwater | Minnesota | 27029 | 1431 | 18 |
1882939 | 1882939 | 2021-11-04 | Clearwater | Minnesota | 27029 | 1428 | 18 |
1879690 | 1879690 | 2021-11-03 | Clearwater | Minnesota | 27029 | 1425 | 18 |
1876441 | 1876441 | 2021-11-02 | Clearwater | Minnesota | 27029 | 1422 | 18 |
1873192 | 1873192 | 2021-11-01 | Clearwater | Minnesota | 27029 | 1416 | 18 |
1869943 | 1869943 | 2021-10-31 | Clearwater | Minnesota | 27029 | 1397 | 18 |
1866694 | 1866694 | 2021-10-30 | Clearwater | Minnesota | 27029 | 1397 | 18 |
1863445 | 1863445 | 2021-10-29 | Clearwater | Minnesota | 27029 | 1397 | 18 |
1860196 | 1860196 | 2021-10-28 | Clearwater | Minnesota | 27029 | 1392 | 18 |
1856947 | 1856947 | 2021-10-27 | Clearwater | Minnesota | 27029 | 1389 | 18 |
1853698 | 1853698 | 2021-10-26 | Clearwater | Minnesota | 27029 | 1383 | 18 |
1850449 | 1850449 | 2021-10-25 | Clearwater | Minnesota | 27029 | 1367 | 18 |
1847199 | 1847199 | 2021-10-24 | Clearwater | Minnesota | 27029 | 1366 | 18 |
1843949 | 1843949 | 2021-10-23 | Clearwater | Minnesota | 27029 | 1366 | 18 |
1840699 | 1840699 | 2021-10-22 | Clearwater | Minnesota | 27029 | 1366 | 18 |
1837450 | 1837450 | 2021-10-21 | Clearwater | Minnesota | 27029 | 1360 | 18 |
1834201 | 1834201 | 2021-10-20 | Clearwater | Minnesota | 27029 | 1358 | 18 |
1830952 | 1830952 | 2021-10-19 | Clearwater | Minnesota | 27029 | 1355 | 18 |
1827703 | 1827703 | 2021-10-18 | Clearwater | Minnesota | 27029 | 1337 | 18 |
1824454 | 1824454 | 2021-10-17 | Clearwater | Minnesota | 27029 | 1333 | 18 |
1821205 | 1821205 | 2021-10-16 | Clearwater | Minnesota | 27029 | 1333 | 18 |
1817956 | 1817956 | 2021-10-15 | Clearwater | Minnesota | 27029 | 1333 | 18 |
1814707 | 1814707 | 2021-10-14 | Clearwater | Minnesota | 27029 | 1325 | 18 |
1811459 | 1811459 | 2021-10-13 | Clearwater | Minnesota | 27029 | 1317 | 18 |
1808210 | 1808210 | 2021-10-12 | Clearwater | Minnesota | 27029 | 1312 | 18 |
1804959 | 1804959 | 2021-10-11 | Clearwater | Minnesota | 27029 | 1287 | 18 |
1801710 | 1801710 | 2021-10-10 | Clearwater | Minnesota | 27029 | 1281 | 18 |
1798461 | 1798461 | 2021-10-09 | Clearwater | Minnesota | 27029 | 1281 | 18 |
1795212 | 1795212 | 2021-10-08 | Clearwater | Minnesota | 27029 | 1281 | 18 |
1791963 | 1791963 | 2021-10-07 | Clearwater | Minnesota | 27029 | 1266 | 18 |
1788714 | 1788714 | 2021-10-06 | Clearwater | Minnesota | 27029 | 1257 | 18 |
1785466 | 1785466 | 2021-10-05 | Clearwater | Minnesota | 27029 | 1245 | 18 |
1782217 | 1782217 | 2021-10-04 | Clearwater | Minnesota | 27029 | 1222 | 18 |
1778967 | 1778967 | 2021-10-03 | Clearwater | Minnesota | 27029 | 1212 | 18 |
1775717 | 1775717 | 2021-10-02 | Clearwater | Minnesota | 27029 | 1212 | 18 |
1772467 | 1772467 | 2021-10-01 | Clearwater | Minnesota | 27029 | 1212 | 18 |
1769218 | 1769218 | 2021-09-30 | Clearwater | Minnesota | 27029 | 1188 | 18 |
1765969 | 1765969 | 2021-09-29 | Clearwater | Minnesota | 27029 | 1168 | 18 |
1762720 | 1762720 | 2021-09-28 | Clearwater | Minnesota | 27029 | 1160 | 18 |
1759471 | 1759471 | 2021-09-27 | Clearwater | Minnesota | 27029 | 1116 | 18 |
1756223 | 1756223 | 2021-09-26 | Clearwater | Minnesota | 27029 | 1092 | 18 |
1752975 | 1752975 | 2021-09-25 | Clearwater | Minnesota | 27029 | 1092 | 18 |
1749727 | 1749727 | 2021-09-24 | Clearwater | Minnesota | 27029 | 1092 | 18 |
1746477 | 1746477 | 2021-09-23 | Clearwater | Minnesota | 27029 | 1071 | 18 |
1743228 | 1743228 | 2021-09-22 | Clearwater | Minnesota | 27029 | 1054 | 18 |
1739979 | 1739979 | 2021-09-21 | Clearwater | Minnesota | 27029 | 1048 | 18 |
1736730 | 1736730 | 2021-09-20 | Clearwater | Minnesota | 27029 | 1026 | 18 |
1733480 | 1733480 | 2021-09-19 | Clearwater | Minnesota | 27029 | 1019 | 18 |
1730230 | 1730230 | 2021-09-18 | Clearwater | Minnesota | 27029 | 1019 | 18 |
1726980 | 1726980 | 2021-09-17 | Clearwater | Minnesota | 27029 | 1019 | 18 |
1723731 | 1723731 | 2021-09-16 | Clearwater | Minnesota | 27029 | 1010 | 18 |
1720482 | 1720482 | 2021-09-15 | Clearwater | Minnesota | 27029 | 1002 | 18 |
1717234 | 1717234 | 2021-09-14 | Clearwater | Minnesota | 27029 | 989 | 18 |
1713986 | 1713986 | 2021-09-13 | Clearwater | Minnesota | 27029 | 980 | 18 |
1710740 | 1710740 | 2021-09-12 | Clearwater | Minnesota | 27029 | 979 | 18 |
1707493 | 1707493 | 2021-09-11 | Clearwater | Minnesota | 27029 | 979 | 18 |
1704246 | 1704246 | 2021-09-10 | Clearwater | Minnesota | 27029 | 979 | 18 |
1700996 | 1700996 | 2021-09-09 | Clearwater | Minnesota | 27029 | 976 | 18 |
1697747 | 1697747 | 2021-09-08 | Clearwater | Minnesota | 27029 | 974 | 18 |
1694499 | 1694499 | 2021-09-07 | Clearwater | Minnesota | 27029 | 968 | 18 |
1691250 | 1691250 | 2021-09-06 | Clearwater | Minnesota | 27029 | 965 | 18 |
1688000 | 1688000 | 2021-09-05 | Clearwater | Minnesota | 27029 | 965 | 18 |
1684750 | 1684750 | 2021-09-04 | Clearwater | Minnesota | 27029 | 965 | 18 |
1681499 | 1681499 | 2021-09-03 | Clearwater | Minnesota | 27029 | 965 | 18 |
1678251 | 1678251 | 2021-09-02 | Clearwater | Minnesota | 27029 | 962 | 18 |
1675003 | 1675003 | 2021-09-01 | Clearwater | Minnesota | 27029 | 959 | 18 |
1671755 | 1671755 | 2021-08-31 | Clearwater | Minnesota | 27029 | 958 | 18 |
1668508 | 1668508 | 2021-08-30 | Clearwater | Minnesota | 27029 | 948 | 18 |
1665261 | 1665261 | 2021-08-29 | Clearwater | Minnesota | 27029 | 944 | 18 |
1662013 | 1662013 | 2021-08-28 | Clearwater | Minnesota | 27029 | 944 | 18 |
1658765 | 1658765 | 2021-08-27 | Clearwater | Minnesota | 27029 | 944 | 18 |
1655516 | 1655516 | 2021-08-26 | Clearwater | Minnesota | 27029 | 941 | 18 |
1652269 | 1652269 | 2021-08-25 | Clearwater | Minnesota | 27029 | 933 | 18 |
1649021 | 1649021 | 2021-08-24 | Clearwater | Minnesota | 27029 | 933 | 18 |
1645772 | 1645772 | 2021-08-23 | Clearwater | Minnesota | 27029 | 926 | 18 |
1642523 | 1642523 | 2021-08-22 | Clearwater | Minnesota | 27029 | 926 | 18 |
1639273 | 1639273 | 2021-08-21 | Clearwater | Minnesota | 27029 | 926 | 18 |
1636023 | 1636023 | 2021-08-20 | Clearwater | Minnesota | 27029 | 926 | 18 |
1632773 | 1632773 | 2021-08-19 | Clearwater | Minnesota | 27029 | 924 | 18 |
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);