ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where fips = 38073 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 |
---|---|---|---|---|---|---|---|
1717934 | 1717934 | 2021-09-14 | Ransom | North Dakota | 38073 | 767 | 17 |
1714686 | 1714686 | 2021-09-13 | Ransom | North Dakota | 38073 | 759 | 17 |
1711440 | 1711440 | 2021-09-12 | Ransom | North Dakota | 38073 | 759 | 17 |
1708193 | 1708193 | 2021-09-11 | Ransom | North Dakota | 38073 | 756 | 17 |
1704946 | 1704946 | 2021-09-10 | Ransom | North Dakota | 38073 | 751 | 17 |
1701696 | 1701696 | 2021-09-09 | Ransom | North Dakota | 38073 | 741 | 17 |
1698447 | 1698447 | 2021-09-08 | Ransom | North Dakota | 38073 | 734 | 17 |
1695199 | 1695199 | 2021-09-07 | Ransom | North Dakota | 38073 | 727 | 17 |
1691951 | 1691951 | 2021-09-06 | Ransom | North Dakota | 38073 | 726 | 17 |
1688701 | 1688701 | 2021-09-05 | Ransom | North Dakota | 38073 | 726 | 17 |
1685451 | 1685451 | 2021-09-04 | Ransom | North Dakota | 38073 | 726 | 17 |
1682200 | 1682200 | 2021-09-03 | Ransom | North Dakota | 38073 | 723 | 17 |
1678951 | 1678951 | 2021-09-02 | Ransom | North Dakota | 38073 | 718 | 17 |
1675703 | 1675703 | 2021-09-01 | Ransom | North Dakota | 38073 | 716 | 17 |
1672456 | 1672456 | 2021-08-31 | Ransom | North Dakota | 38073 | 715 | 17 |
1669208 | 1669208 | 2021-08-30 | Ransom | North Dakota | 38073 | 715 | 17 |
1665961 | 1665961 | 2021-08-29 | Ransom | North Dakota | 38073 | 714 | 17 |
1662713 | 1662713 | 2021-08-28 | Ransom | North Dakota | 38073 | 714 | 17 |
1659465 | 1659465 | 2021-08-27 | Ransom | North Dakota | 38073 | 713 | 17 |
1656216 | 1656216 | 2021-08-26 | Ransom | North Dakota | 38073 | 712 | 17 |
1652969 | 1652969 | 2021-08-25 | Ransom | North Dakota | 38073 | 711 | 17 |
1649721 | 1649721 | 2021-08-24 | Ransom | North Dakota | 38073 | 711 | 17 |
1646472 | 1646472 | 2021-08-23 | Ransom | North Dakota | 38073 | 711 | 17 |
1643223 | 1643223 | 2021-08-22 | Ransom | North Dakota | 38073 | 710 | 17 |
1639973 | 1639973 | 2021-08-21 | Ransom | North Dakota | 38073 | 710 | 17 |
1636723 | 1636723 | 2021-08-20 | Ransom | North Dakota | 38073 | 710 | 17 |
1633473 | 1633473 | 2021-08-19 | Ransom | North Dakota | 38073 | 707 | 17 |
1630226 | 1630226 | 2021-08-18 | Ransom | North Dakota | 38073 | 705 | 17 |
1626979 | 1626979 | 2021-08-17 | Ransom | North Dakota | 38073 | 705 | 17 |
1623732 | 1623732 | 2021-08-16 | Ransom | North Dakota | 38073 | 705 | 17 |
1620485 | 1620485 | 2021-08-15 | Ransom | North Dakota | 38073 | 705 | 17 |
1617237 | 1617237 | 2021-08-14 | Ransom | North Dakota | 38073 | 705 | 17 |
1613989 | 1613989 | 2021-08-13 | Ransom | North Dakota | 38073 | 703 | 17 |
1610740 | 1610740 | 2021-08-12 | Ransom | North Dakota | 38073 | 703 | 17 |
1607492 | 1607492 | 2021-08-11 | Ransom | North Dakota | 38073 | 703 | 17 |
1604243 | 1604243 | 2021-08-10 | Ransom | North Dakota | 38073 | 702 | 17 |
1600994 | 1600994 | 2021-08-09 | Ransom | North Dakota | 38073 | 702 | 17 |
1597746 | 1597746 | 2021-08-08 | Ransom | North Dakota | 38073 | 702 | 17 |
1594497 | 1594497 | 2021-08-07 | Ransom | North Dakota | 38073 | 702 | 17 |
1591248 | 1591248 | 2021-08-06 | Ransom | North Dakota | 38073 | 702 | 17 |
1587999 | 1587999 | 2021-08-05 | Ransom | North Dakota | 38073 | 702 | 17 |
1584749 | 1584749 | 2021-08-04 | Ransom | North Dakota | 38073 | 702 | 17 |
1581499 | 1581499 | 2021-08-03 | Ransom | North Dakota | 38073 | 702 | 17 |
1578250 | 1578250 | 2021-08-02 | Ransom | North Dakota | 38073 | 702 | 17 |
1575002 | 1575002 | 2021-08-01 | Ransom | North Dakota | 38073 | 702 | 17 |
1571754 | 1571754 | 2021-07-31 | Ransom | North Dakota | 38073 | 702 | 17 |
1568506 | 1568506 | 2021-07-30 | Ransom | North Dakota | 38073 | 701 | 17 |
1565258 | 1565258 | 2021-07-29 | Ransom | North Dakota | 38073 | 701 | 17 |
1562010 | 1562010 | 2021-07-28 | Ransom | North Dakota | 38073 | 702 | 17 |
1558762 | 1558762 | 2021-07-27 | Ransom | North Dakota | 38073 | 702 | 17 |
1555515 | 1555515 | 2021-07-26 | Ransom | North Dakota | 38073 | 701 | 17 |
1552268 | 1552268 | 2021-07-25 | Ransom | North Dakota | 38073 | 700 | 17 |
1549021 | 1549021 | 2021-07-24 | Ransom | North Dakota | 38073 | 700 | 17 |
1545774 | 1545774 | 2021-07-23 | Ransom | North Dakota | 38073 | 700 | 17 |
1542527 | 1542527 | 2021-07-22 | Ransom | North Dakota | 38073 | 700 | 17 |
1539279 | 1539279 | 2021-07-21 | Ransom | North Dakota | 38073 | 700 | 17 |
1536032 | 1536032 | 2021-07-20 | Ransom | North Dakota | 38073 | 700 | 17 |
1532784 | 1532784 | 2021-07-19 | Ransom | North Dakota | 38073 | 700 | 17 |
1529537 | 1529537 | 2021-07-18 | Ransom | North Dakota | 38073 | 700 | 17 |
1526290 | 1526290 | 2021-07-17 | Ransom | North Dakota | 38073 | 700 | 17 |
1523043 | 1523043 | 2021-07-16 | Ransom | North Dakota | 38073 | 700 | 17 |
1519795 | 1519795 | 2021-07-15 | Ransom | North Dakota | 38073 | 700 | 17 |
1516547 | 1516547 | 2021-07-14 | Ransom | North Dakota | 38073 | 700 | 17 |
1513300 | 1513300 | 2021-07-13 | Ransom | North Dakota | 38073 | 700 | 17 |
1510054 | 1510054 | 2021-07-12 | Ransom | North Dakota | 38073 | 700 | 17 |
1506807 | 1506807 | 2021-07-11 | Ransom | North Dakota | 38073 | 700 | 17 |
1503561 | 1503561 | 2021-07-10 | Ransom | North Dakota | 38073 | 700 | 17 |
1500315 | 1500315 | 2021-07-09 | Ransom | North Dakota | 38073 | 700 | 17 |
1497069 | 1497069 | 2021-07-08 | Ransom | North Dakota | 38073 | 700 | 17 |
1493822 | 1493822 | 2021-07-07 | Ransom | North Dakota | 38073 | 700 | 17 |
1490575 | 1490575 | 2021-07-06 | Ransom | North Dakota | 38073 | 700 | 17 |
1487328 | 1487328 | 2021-07-05 | Ransom | North Dakota | 38073 | 700 | 17 |
1484082 | 1484082 | 2021-07-04 | Ransom | North Dakota | 38073 | 700 | 17 |
1480836 | 1480836 | 2021-07-03 | Ransom | North Dakota | 38073 | 700 | 17 |
1477589 | 1477589 | 2021-07-02 | Ransom | North Dakota | 38073 | 700 | 17 |
1474343 | 1474343 | 2021-07-01 | Ransom | North Dakota | 38073 | 700 | 17 |
1471097 | 1471097 | 2021-06-30 | Ransom | North Dakota | 38073 | 700 | 17 |
1467852 | 1467852 | 2021-06-29 | Ransom | North Dakota | 38073 | 700 | 17 |
1464607 | 1464607 | 2021-06-28 | Ransom | North Dakota | 38073 | 700 | 17 |
1461362 | 1461362 | 2021-06-27 | Ransom | North Dakota | 38073 | 700 | 17 |
1458117 | 1458117 | 2021-06-26 | Ransom | North Dakota | 38073 | 700 | 17 |
1454872 | 1454872 | 2021-06-25 | Ransom | North Dakota | 38073 | 700 | 17 |
1451627 | 1451627 | 2021-06-24 | Ransom | North Dakota | 38073 | 700 | 17 |
1448381 | 1448381 | 2021-06-23 | Ransom | North Dakota | 38073 | 700 | 17 |
1445136 | 1445136 | 2021-06-22 | Ransom | North Dakota | 38073 | 700 | 17 |
1441891 | 1441891 | 2021-06-21 | Ransom | North Dakota | 38073 | 700 | 17 |
1438646 | 1438646 | 2021-06-20 | Ransom | North Dakota | 38073 | 701 | 17 |
1435399 | 1435399 | 2021-06-19 | Ransom | North Dakota | 38073 | 700 | 17 |
1432152 | 1432152 | 2021-06-18 | Ransom | North Dakota | 38073 | 700 | 17 |
1428906 | 1428906 | 2021-06-17 | Ransom | North Dakota | 38073 | 700 | 17 |
1425661 | 1425661 | 2021-06-16 | Ransom | North Dakota | 38073 | 700 | 17 |
1422414 | 1422414 | 2021-06-15 | Ransom | North Dakota | 38073 | 700 | 17 |
1419168 | 1419168 | 2021-06-14 | Ransom | North Dakota | 38073 | 700 | 17 |
1415923 | 1415923 | 2021-06-13 | Ransom | North Dakota | 38073 | 700 | 17 |
1412677 | 1412677 | 2021-06-12 | Ransom | North Dakota | 38073 | 700 | 17 |
1409432 | 1409432 | 2021-06-11 | Ransom | North Dakota | 38073 | 700 | 17 |
1406187 | 1406187 | 2021-06-10 | Ransom | North Dakota | 38073 | 700 | 17 |
1402941 | 1402941 | 2021-06-09 | Ransom | North Dakota | 38073 | 700 | 17 |
1399696 | 1399696 | 2021-06-08 | Ransom | North Dakota | 38073 | 699 | 17 |
1396451 | 1396451 | 2021-06-07 | Ransom | North Dakota | 38073 | 698 | 17 |
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);