ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38055 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812150 | 1812150 | 2021-10-13 | McLean | North Dakota | 38055 | 1698 | 33 |
1808901 | 1808901 | 2021-10-12 | McLean | North Dakota | 38055 | 1681 | 33 |
1805650 | 1805650 | 2021-10-11 | McLean | North Dakota | 38055 | 1665 | 33 |
1802401 | 1802401 | 2021-10-10 | McLean | North Dakota | 38055 | 1657 | 33 |
1799152 | 1799152 | 2021-10-09 | McLean | North Dakota | 38055 | 1650 | 33 |
1795903 | 1795903 | 2021-10-08 | McLean | North Dakota | 38055 | 1643 | 33 |
1792654 | 1792654 | 2021-10-07 | McLean | North Dakota | 38055 | 1625 | 33 |
1789405 | 1789405 | 2021-10-06 | McLean | North Dakota | 38055 | 1615 | 33 |
1786157 | 1786157 | 2021-10-05 | McLean | North Dakota | 38055 | 1603 | 33 |
1782908 | 1782908 | 2021-10-04 | McLean | North Dakota | 38055 | 1589 | 33 |
1779659 | 1779659 | 2021-10-03 | McLean | North Dakota | 38055 | 1586 | 33 |
1776409 | 1776409 | 2021-10-02 | McLean | North Dakota | 38055 | 1586 | 33 |
1773159 | 1773159 | 2021-10-01 | McLean | North Dakota | 38055 | 1579 | 33 |
1769909 | 1769909 | 2021-09-30 | McLean | North Dakota | 38055 | 1574 | 33 |
1766660 | 1766660 | 2021-09-29 | McLean | North Dakota | 38055 | 1570 | 33 |
1763411 | 1763411 | 2021-09-28 | McLean | North Dakota | 38055 | 1563 | 33 |
1760162 | 1760162 | 2021-09-27 | McLean | North Dakota | 38055 | 1555 | 33 |
1756914 | 1756914 | 2021-09-26 | McLean | North Dakota | 38055 | 1552 | 33 |
1753666 | 1753666 | 2021-09-25 | McLean | North Dakota | 38055 | 1550 | 33 |
1750418 | 1750418 | 2021-09-24 | McLean | North Dakota | 38055 | 1542 | 32 |
1747168 | 1747168 | 2021-09-23 | McLean | North Dakota | 38055 | 1534 | 32 |
1743919 | 1743919 | 2021-09-22 | McLean | North Dakota | 38055 | 1524 | 32 |
1740670 | 1740670 | 2021-09-21 | McLean | North Dakota | 38055 | 1521 | 32 |
1737421 | 1737421 | 2021-09-20 | McLean | North Dakota | 38055 | 1510 | 32 |
1734171 | 1734171 | 2021-09-19 | McLean | North Dakota | 38055 | 1507 | 32 |
1730921 | 1730921 | 2021-09-18 | McLean | North Dakota | 38055 | 1501 | 32 |
1727671 | 1727671 | 2021-09-17 | McLean | North Dakota | 38055 | 1495 | 32 |
1724422 | 1724422 | 2021-09-16 | McLean | North Dakota | 38055 | 1493 | 32 |
1721173 | 1721173 | 2021-09-15 | McLean | North Dakota | 38055 | 1487 | 32 |
1717925 | 1717925 | 2021-09-14 | McLean | North Dakota | 38055 | 1478 | 32 |
1714677 | 1714677 | 2021-09-13 | McLean | North Dakota | 38055 | 1472 | 32 |
1711431 | 1711431 | 2021-09-12 | McLean | North Dakota | 38055 | 1471 | 32 |
1708184 | 1708184 | 2021-09-11 | McLean | North Dakota | 38055 | 1467 | 32 |
1704937 | 1704937 | 2021-09-10 | McLean | North Dakota | 38055 | 1460 | 32 |
1701687 | 1701687 | 2021-09-09 | McLean | North Dakota | 38055 | 1442 | 32 |
1698438 | 1698438 | 2021-09-08 | McLean | North Dakota | 38055 | 1437 | 32 |
1695190 | 1695190 | 2021-09-07 | McLean | North Dakota | 38055 | 1424 | 32 |
1691942 | 1691942 | 2021-09-06 | McLean | North Dakota | 38055 | 1419 | 32 |
1688692 | 1688692 | 2021-09-05 | McLean | North Dakota | 38055 | 1418 | 32 |
1685442 | 1685442 | 2021-09-04 | McLean | North Dakota | 38055 | 1417 | 32 |
1682191 | 1682191 | 2021-09-03 | McLean | North Dakota | 38055 | 1410 | 32 |
1678942 | 1678942 | 2021-09-02 | McLean | North Dakota | 38055 | 1405 | 32 |
1675694 | 1675694 | 2021-09-01 | McLean | North Dakota | 38055 | 1398 | 32 |
1672447 | 1672447 | 2021-08-31 | McLean | North Dakota | 38055 | 1392 | 32 |
1669199 | 1669199 | 2021-08-30 | McLean | North Dakota | 38055 | 1384 | 32 |
1665952 | 1665952 | 2021-08-29 | McLean | North Dakota | 38055 | 1381 | 32 |
1662704 | 1662704 | 2021-08-28 | McLean | North Dakota | 38055 | 1375 | 32 |
1659456 | 1659456 | 2021-08-27 | McLean | North Dakota | 38055 | 1372 | 32 |
1656207 | 1656207 | 2021-08-26 | McLean | North Dakota | 38055 | 1369 | 32 |
1652960 | 1652960 | 2021-08-25 | McLean | North Dakota | 38055 | 1363 | 32 |
1649712 | 1649712 | 2021-08-24 | McLean | North Dakota | 38055 | 1360 | 32 |
1646463 | 1646463 | 2021-08-23 | McLean | North Dakota | 38055 | 1358 | 32 |
1643214 | 1643214 | 2021-08-22 | McLean | North Dakota | 38055 | 1358 | 32 |
1639964 | 1639964 | 2021-08-21 | McLean | North Dakota | 38055 | 1357 | 32 |
1636714 | 1636714 | 2021-08-20 | McLean | North Dakota | 38055 | 1351 | 32 |
1633464 | 1633464 | 2021-08-19 | McLean | North Dakota | 38055 | 1350 | 32 |
1630217 | 1630217 | 2021-08-18 | McLean | North Dakota | 38055 | 1347 | 32 |
1626970 | 1626970 | 2021-08-17 | McLean | North Dakota | 38055 | 1344 | 32 |
1623723 | 1623723 | 2021-08-16 | McLean | North Dakota | 38055 | 1339 | 32 |
1620476 | 1620476 | 2021-08-15 | McLean | North Dakota | 38055 | 1338 | 32 |
1617228 | 1617228 | 2021-08-14 | McLean | North Dakota | 38055 | 1335 | 32 |
1613980 | 1613980 | 2021-08-13 | McLean | North Dakota | 38055 | 1334 | 32 |
1610731 | 1610731 | 2021-08-12 | McLean | North Dakota | 38055 | 1332 | 32 |
1607483 | 1607483 | 2021-08-11 | McLean | North Dakota | 38055 | 1332 | 32 |
1604234 | 1604234 | 2021-08-10 | McLean | North Dakota | 38055 | 1327 | 32 |
1600985 | 1600985 | 2021-08-09 | McLean | North Dakota | 38055 | 1323 | 32 |
1597737 | 1597737 | 2021-08-08 | McLean | North Dakota | 38055 | 1323 | 32 |
1594488 | 1594488 | 2021-08-07 | McLean | North Dakota | 38055 | 1323 | 32 |
1591239 | 1591239 | 2021-08-06 | McLean | North Dakota | 38055 | 1320 | 32 |
1587990 | 1587990 | 2021-08-05 | McLean | North Dakota | 38055 | 1318 | 32 |
1584740 | 1584740 | 2021-08-04 | McLean | North Dakota | 38055 | 1317 | 32 |
1581490 | 1581490 | 2021-08-03 | McLean | North Dakota | 38055 | 1314 | 32 |
1578241 | 1578241 | 2021-08-02 | McLean | North Dakota | 38055 | 1314 | 31 |
1574993 | 1574993 | 2021-08-01 | McLean | North Dakota | 38055 | 1314 | 31 |
1571745 | 1571745 | 2021-07-31 | McLean | North Dakota | 38055 | 1314 | 31 |
1568497 | 1568497 | 2021-07-30 | McLean | North Dakota | 38055 | 1314 | 31 |
1565249 | 1565249 | 2021-07-29 | McLean | North Dakota | 38055 | 1310 | 31 |
1562001 | 1562001 | 2021-07-28 | McLean | North Dakota | 38055 | 1305 | 31 |
1558753 | 1558753 | 2021-07-27 | McLean | North Dakota | 38055 | 1304 | 31 |
1555506 | 1555506 | 2021-07-26 | McLean | North Dakota | 38055 | 1305 | 31 |
1552259 | 1552259 | 2021-07-25 | McLean | North Dakota | 38055 | 1304 | 31 |
1549012 | 1549012 | 2021-07-24 | McLean | North Dakota | 38055 | 1303 | 31 |
1545765 | 1545765 | 2021-07-23 | McLean | North Dakota | 38055 | 1302 | 31 |
1542518 | 1542518 | 2021-07-22 | McLean | North Dakota | 38055 | 1300 | 31 |
1539270 | 1539270 | 2021-07-21 | McLean | North Dakota | 38055 | 1298 | 31 |
1536023 | 1536023 | 2021-07-20 | McLean | North Dakota | 38055 | 1297 | 31 |
1532775 | 1532775 | 2021-07-19 | McLean | North Dakota | 38055 | 1298 | 31 |
1529528 | 1529528 | 2021-07-18 | McLean | North Dakota | 38055 | 1298 | 31 |
1526281 | 1526281 | 2021-07-17 | McLean | North Dakota | 38055 | 1297 | 31 |
1523034 | 1523034 | 2021-07-16 | McLean | North Dakota | 38055 | 1297 | 31 |
1519786 | 1519786 | 2021-07-15 | McLean | North Dakota | 38055 | 1297 | 31 |
1516538 | 1516538 | 2021-07-14 | McLean | North Dakota | 38055 | 1296 | 31 |
1513291 | 1513291 | 2021-07-13 | McLean | North Dakota | 38055 | 1295 | 31 |
1510045 | 1510045 | 2021-07-12 | McLean | North Dakota | 38055 | 1295 | 31 |
1506798 | 1506798 | 2021-07-11 | McLean | North Dakota | 38055 | 1295 | 31 |
1503552 | 1503552 | 2021-07-10 | McLean | North Dakota | 38055 | 1295 | 31 |
1500306 | 1500306 | 2021-07-09 | McLean | North Dakota | 38055 | 1295 | 31 |
1497060 | 1497060 | 2021-07-08 | McLean | North Dakota | 38055 | 1295 | 31 |
1493813 | 1493813 | 2021-07-07 | McLean | North Dakota | 38055 | 1295 | 31 |
1490566 | 1490566 | 2021-07-06 | McLean | North Dakota | 38055 | 1294 | 31 |
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);