ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where fips = 38077 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 |
---|---|---|---|---|---|---|---|
1812161 | 1812161 | 2021-10-13 | Richland | North Dakota | 38077 | 2415 | 19 |
1808912 | 1808912 | 2021-10-12 | Richland | North Dakota | 38077 | 2410 | 19 |
1805661 | 1805661 | 2021-10-11 | Richland | North Dakota | 38077 | 2393 | 19 |
1802412 | 1802412 | 2021-10-10 | Richland | North Dakota | 38077 | 2389 | 19 |
1799163 | 1799163 | 2021-10-09 | Richland | North Dakota | 38077 | 2388 | 19 |
1795914 | 1795914 | 2021-10-08 | Richland | North Dakota | 38077 | 2373 | 19 |
1792665 | 1792665 | 2021-10-07 | Richland | North Dakota | 38077 | 2365 | 19 |
1789416 | 1789416 | 2021-10-06 | Richland | North Dakota | 38077 | 2349 | 19 |
1786168 | 1786168 | 2021-10-05 | Richland | North Dakota | 38077 | 2335 | 19 |
1782919 | 1782919 | 2021-10-04 | Richland | North Dakota | 38077 | 2315 | 19 |
1779670 | 1779670 | 2021-10-03 | Richland | North Dakota | 38077 | 2315 | 19 |
1776420 | 1776420 | 2021-10-02 | Richland | North Dakota | 38077 | 2312 | 19 |
1773170 | 1773170 | 2021-10-01 | Richland | North Dakota | 38077 | 2302 | 19 |
1769920 | 1769920 | 2021-09-30 | Richland | North Dakota | 38077 | 2288 | 19 |
1766671 | 1766671 | 2021-09-29 | Richland | North Dakota | 38077 | 2274 | 19 |
1763422 | 1763422 | 2021-09-28 | Richland | North Dakota | 38077 | 2258 | 19 |
1760173 | 1760173 | 2021-09-27 | Richland | North Dakota | 38077 | 2246 | 19 |
1756925 | 1756925 | 2021-09-26 | Richland | North Dakota | 38077 | 2243 | 19 |
1753677 | 1753677 | 2021-09-25 | Richland | North Dakota | 38077 | 2243 | 19 |
1750429 | 1750429 | 2021-09-24 | Richland | North Dakota | 38077 | 2236 | 19 |
1747179 | 1747179 | 2021-09-23 | Richland | North Dakota | 38077 | 2233 | 19 |
1743930 | 1743930 | 2021-09-22 | Richland | North Dakota | 38077 | 2226 | 19 |
1740681 | 1740681 | 2021-09-21 | Richland | North Dakota | 38077 | 2222 | 19 |
1737432 | 1737432 | 2021-09-20 | Richland | North Dakota | 38077 | 2217 | 19 |
1734182 | 1734182 | 2021-09-19 | Richland | North Dakota | 38077 | 2217 | 19 |
1730932 | 1730932 | 2021-09-18 | Richland | North Dakota | 38077 | 2216 | 19 |
1727682 | 1727682 | 2021-09-17 | Richland | North Dakota | 38077 | 2213 | 19 |
1724433 | 1724433 | 2021-09-16 | Richland | North Dakota | 38077 | 2212 | 19 |
1721184 | 1721184 | 2021-09-15 | Richland | North Dakota | 38077 | 2202 | 19 |
1717936 | 1717936 | 2021-09-14 | Richland | North Dakota | 38077 | 2197 | 19 |
1714688 | 1714688 | 2021-09-13 | Richland | North Dakota | 38077 | 2196 | 19 |
1711442 | 1711442 | 2021-09-12 | Richland | North Dakota | 38077 | 2196 | 19 |
1708195 | 1708195 | 2021-09-11 | Richland | North Dakota | 38077 | 2193 | 19 |
1704948 | 1704948 | 2021-09-10 | Richland | North Dakota | 38077 | 2190 | 19 |
1701698 | 1701698 | 2021-09-09 | Richland | North Dakota | 38077 | 2179 | 19 |
1698449 | 1698449 | 2021-09-08 | Richland | North Dakota | 38077 | 2166 | 19 |
1695201 | 1695201 | 2021-09-07 | Richland | North Dakota | 38077 | 2158 | 19 |
1691953 | 1691953 | 2021-09-06 | Richland | North Dakota | 38077 | 2147 | 19 |
1688703 | 1688703 | 2021-09-05 | Richland | North Dakota | 38077 | 2144 | 19 |
1685453 | 1685453 | 2021-09-04 | Richland | North Dakota | 38077 | 2141 | 19 |
1682202 | 1682202 | 2021-09-03 | Richland | North Dakota | 38077 | 2134 | 19 |
1678953 | 1678953 | 2021-09-02 | Richland | North Dakota | 38077 | 2128 | 19 |
1675705 | 1675705 | 2021-09-01 | Richland | North Dakota | 38077 | 2119 | 19 |
1672458 | 1672458 | 2021-08-31 | Richland | North Dakota | 38077 | 2109 | 18 |
1669210 | 1669210 | 2021-08-30 | Richland | North Dakota | 38077 | 2099 | 18 |
1665963 | 1665963 | 2021-08-29 | Richland | North Dakota | 38077 | 2095 | 18 |
1662715 | 1662715 | 2021-08-28 | Richland | North Dakota | 38077 | 2095 | 18 |
1659467 | 1659467 | 2021-08-27 | Richland | North Dakota | 38077 | 2091 | 18 |
1656218 | 1656218 | 2021-08-26 | Richland | North Dakota | 38077 | 2085 | 17 |
1652971 | 1652971 | 2021-08-25 | Richland | North Dakota | 38077 | 2084 | 17 |
1649723 | 1649723 | 2021-08-24 | Richland | North Dakota | 38077 | 2086 | 17 |
1646474 | 1646474 | 2021-08-23 | Richland | North Dakota | 38077 | 2078 | 17 |
1643225 | 1643225 | 2021-08-22 | Richland | North Dakota | 38077 | 2078 | 17 |
1639975 | 1639975 | 2021-08-21 | Richland | North Dakota | 38077 | 2078 | 17 |
1636725 | 1636725 | 2021-08-20 | Richland | North Dakota | 38077 | 2071 | 17 |
1633475 | 1633475 | 2021-08-19 | Richland | North Dakota | 38077 | 2067 | 17 |
1630228 | 1630228 | 2021-08-18 | Richland | North Dakota | 38077 | 2060 | 17 |
1626981 | 1626981 | 2021-08-17 | Richland | North Dakota | 38077 | 2053 | 17 |
1623734 | 1623734 | 2021-08-16 | Richland | North Dakota | 38077 | 2051 | 17 |
1620487 | 1620487 | 2021-08-15 | Richland | North Dakota | 38077 | 2050 | 17 |
1617239 | 1617239 | 2021-08-14 | Richland | North Dakota | 38077 | 2050 | 17 |
1613991 | 1613991 | 2021-08-13 | Richland | North Dakota | 38077 | 2050 | 17 |
1610742 | 1610742 | 2021-08-12 | Richland | North Dakota | 38077 | 2049 | 17 |
1607494 | 1607494 | 2021-08-11 | Richland | North Dakota | 38077 | 2048 | 17 |
1604245 | 1604245 | 2021-08-10 | Richland | North Dakota | 38077 | 2045 | 17 |
1600996 | 1600996 | 2021-08-09 | Richland | North Dakota | 38077 | 2044 | 17 |
1597748 | 1597748 | 2021-08-08 | Richland | North Dakota | 38077 | 2044 | 17 |
1594499 | 1594499 | 2021-08-07 | Richland | North Dakota | 38077 | 2044 | 17 |
1591250 | 1591250 | 2021-08-06 | Richland | North Dakota | 38077 | 2043 | 17 |
1588001 | 1588001 | 2021-08-05 | Richland | North Dakota | 38077 | 2042 | 17 |
1584751 | 1584751 | 2021-08-04 | Richland | North Dakota | 38077 | 2041 | 17 |
1581501 | 1581501 | 2021-08-03 | Richland | North Dakota | 38077 | 2040 | 17 |
1578252 | 1578252 | 2021-08-02 | Richland | North Dakota | 38077 | 2039 | 17 |
1575004 | 1575004 | 2021-08-01 | Richland | North Dakota | 38077 | 2035 | 17 |
1571756 | 1571756 | 2021-07-31 | Richland | North Dakota | 38077 | 2035 | 17 |
1568508 | 1568508 | 2021-07-30 | Richland | North Dakota | 38077 | 2032 | 17 |
1565260 | 1565260 | 2021-07-29 | Richland | North Dakota | 38077 | 2032 | 17 |
1562012 | 1562012 | 2021-07-28 | Richland | North Dakota | 38077 | 2031 | 17 |
1558764 | 1558764 | 2021-07-27 | Richland | North Dakota | 38077 | 2030 | 17 |
1555517 | 1555517 | 2021-07-26 | Richland | North Dakota | 38077 | 2029 | 17 |
1552270 | 1552270 | 2021-07-25 | Richland | North Dakota | 38077 | 2026 | 17 |
1549023 | 1549023 | 2021-07-24 | Richland | North Dakota | 38077 | 2026 | 17 |
1545776 | 1545776 | 2021-07-23 | Richland | North Dakota | 38077 | 2026 | 17 |
1542529 | 1542529 | 2021-07-22 | Richland | North Dakota | 38077 | 2026 | 17 |
1539281 | 1539281 | 2021-07-21 | Richland | North Dakota | 38077 | 2027 | 17 |
1536034 | 1536034 | 2021-07-20 | Richland | North Dakota | 38077 | 2027 | 17 |
1532786 | 1532786 | 2021-07-19 | Richland | North Dakota | 38077 | 2027 | 17 |
1529539 | 1529539 | 2021-07-18 | Richland | North Dakota | 38077 | 2027 | 17 |
1526292 | 1526292 | 2021-07-17 | Richland | North Dakota | 38077 | 2027 | 17 |
1523045 | 1523045 | 2021-07-16 | Richland | North Dakota | 38077 | 2027 | 17 |
1519797 | 1519797 | 2021-07-15 | Richland | North Dakota | 38077 | 2027 | 17 |
1516549 | 1516549 | 2021-07-14 | Richland | North Dakota | 38077 | 2026 | 17 |
1513302 | 1513302 | 2021-07-13 | Richland | North Dakota | 38077 | 2027 | 17 |
1510056 | 1510056 | 2021-07-12 | Richland | North Dakota | 38077 | 2027 | 17 |
1506809 | 1506809 | 2021-07-11 | Richland | North Dakota | 38077 | 2027 | 17 |
1503563 | 1503563 | 2021-07-10 | Richland | North Dakota | 38077 | 2027 | 17 |
1500317 | 1500317 | 2021-07-09 | Richland | North Dakota | 38077 | 2027 | 17 |
1497071 | 1497071 | 2021-07-08 | Richland | North Dakota | 38077 | 2027 | 17 |
1493824 | 1493824 | 2021-07-07 | Richland | North Dakota | 38077 | 2027 | 17 |
1490577 | 1490577 | 2021-07-06 | Richland | North Dakota | 38077 | 2027 | 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);